-- --------------------------------------------------------
-- 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' */;

/* CHANGE HMDS TO NAME OF NEW LAB: */
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, '1999-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 */;
