SET FOREIGN_KEY_CHECKS=0;

DROP DATABASE IF EXISTS `dblock`;

CREATE DATABASE `dblock`;

USE `dblock`;

#
# Structure for the `users` table : 
#

CREATE TABLE `users` (
  `iUserID` int(11) unsigned NOT NULL DEFAULT '0',
  `strLoginName` varchar(15) NOT NULL DEFAULT '',
  `strUserName` varchar(15) NOT NULL DEFAULT '',
  `dTimeStamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `bGroup` tinyint(1) NOT NULL DEFAULT '0',
  `iGroupID` int(11) DEFAULT NULL,
  `strRunningVersion` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`iUserID`),
  UNIQUE KEY `iUserID` (`iUserID`),
  UNIQUE KEY `strLoginName` (`strLoginName`)
) ENGINE=InnoDB;

#
# Structure for the `usersettings` table : 
#

CREATE TABLE `usersettings` (
  `strFormName` varchar(70) NOT NULL,
  `strFieldKey` varchar(70) NOT NULL,
  `strCharacteristic` varchar(70) NOT NULL,
  `strUserName` varchar(15) NOT NULL DEFAULT '',
  `strValue` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`strFormName`,`strFieldKey`,`strCharacteristic`,`strUserName`),
  KEY `strValue` (`strValue`),
  KEY `usersettings_fk` (`strUserName`),
  CONSTRAINT `usersettings_fk` FOREIGN KEY (`strUserName`) REFERENCES `users` (`strLoginName`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB;

#
# Data for the `users` table  (LIMIT 0,500)
#

INSERT INTO `users` (`iUserID`, `strLoginName`, `strUserName`, `dTimeStamp`, `bGroup`, `iGroupID`, `strRunningVersion`) VALUES 
  (1,'TEST1','','2009-09-09 09:35:44',0,1000,NULL),
  (2,'TEST2','','2009-09-09 09:31:35',0,NULL,NULL),
  (3,'TEST3','','2009-09-09 09:31:38',0,NULL,NULL),
  (4,'TEST4','','2009-09-09 09:31:40',0,NULL,NULL),
  (1000,'.GROUP1','','2009-09-09 09:35:42',1,NULL,NULL);
COMMIT;

#
# Data for the `usersettings` table  (LIMIT 0,500)
#

INSERT INTO `usersettings` (`strFormName`, `strFieldKey`, `strCharacteristic`, `strUserName`, `strValue`) VALUES 
  ('FORM1','FIELD1','CHAR1','TEST1','10'),
  ('FORM2','FIELD2','CHAR2','TEST1','20'),
  ('FORM3','FIELD3','CHAR3','TEST1','30');
COMMIT;