-- --------------------------------------------------------
-- Host: 127.0.0.1
-- Server version: 5.1.72-2-log - (Debian)
-- Server OS: debian-linux-gnu
-- HeidiSQL Version: 8.1.0.4545
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
INSERT INTO `user_locations` (`location_name`, `region_code`, `active`)
VALUES ('HMDS', NULL, 'yes');
INSERT INTO `users` (`username`, `first_name`, `last_name`, `password`, `email`,
`user_location_id`, `designation`, `group_id`, `last_login`, `active`)
VALUES ('raj', 'richard', 'jones', 'uwvhGoF84pL4awpbH9kBkVcIhMA',
'ra.jones@hmds.org.uk', 1, 'Administrator', 6, '1901-01-01 00:00:00', 'yes');
-- Dumping data for table lab_test_status_options: ~2 rows (approximately)
DELETE FROM `lab_test_status_options`;
/*!40000 ALTER TABLE `lab_test_status_options` DISABLE KEYS */;
INSERT INTO `lab_test_status_options` (`id`, `description`, `is_editable`, `is_active`) VALUES
(1, 'new', 'no', 'yes'),
(2, 'complete', 'no', 'yes'),
(3, 'delete', 'no', 'yes');
DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
`id` VARCHAR(32) NOT NULL DEFAULT '',
`userid` VARCHAR(255) NULL DEFAULT NULL,
`a_session` TEXT NOT NULL,
`time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
UNIQUE INDEX `id` (`id`),
UNIQUE INDEX `userid` (`userid`)
)
ENGINE=InnoDB;
/*!40000 ALTER TABLE `lab_test_status_options` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
