26 lines
904 B
SQL
26 lines
904 B
SQL
CREATE TABLE IF NOT EXISTS `items` (
|
|
`Id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
|
`Text` varchar(300) NOT NULL,
|
|
`UserId` bigint(20) unsigned NOT NULL,
|
|
`Completed` tinyint(1) NOT NULL,
|
|
`Must` tinyint(1) NOT NULL,
|
|
`CreationDate` timestamp NULL DEFAULT NULL,
|
|
`CompletionDate` timestamp NULL DEFAULT NULL,
|
|
`Deadline` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`Id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE IF NOT EXISTS `users` (
|
|
`Id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
|
`Username` varchar(48) NOT NULL,
|
|
`Hash` varchar(43) NOT NULL,
|
|
`Salt` varchar(10) NOT NULL,
|
|
`CurrentItemId` bigint(20) unsigned NOT NULL,
|
|
`Admin` tinyint(1) NOT NULL,
|
|
`Banned` tinyint(1) NOT NULL,
|
|
`Guest` tinyint(1) NOT NULL,
|
|
`RegistrationDate` timestamp NULL DEFAULT NULL,
|
|
`LastSeen` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`Id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|