DiSjnuzj

1DROP TABLE IF EXISTS `users`;
2CREATE TABLE `users` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `username` varchar(255) DEFAULT "",
5  `password` varchar(255) DEFAULT "",
6  `fullName` varchar(255) DEFAULT "",
7  `Avatar` varchar(255) DEFAULT "",
8  `isAdmin` boolean DEFAULT 0,
9  PRIMARY KEY (`id`)
10) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
11
12DROP TABLE IF EXISTS `sessions`;
13CREATE TABLE `sessions` (
14  `id` int(11) NOT NULL AUTO_INCREMENT,
15  `uuid` varchar(255) DEFAULT "",
16  `username` varchar(255) DEFAULT "",
17  `expire` int(11) DEFAULT 0,
18  PRIMARY KEY (`id`)
19) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
20
21DROP TABLE IF EXISTS `tasks`;
22CREATE TABLE `tasks` (
23  `id` int(11) NOT NULL AUTO_INCREMENT,
24  `resource` varchar(255) DEFAULT "",
25  `name` varchar(255) DEFAULT "",
26  `status` varchar(255) DEFAULT "",
27  `initiator` varchar(255) DEFAULT "",
28  `date` varchar(255) DEFAULT "",
29  `timestamp` int(11) DEFAULT 0,
30  PRIMARY KEY (`id`)
31) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
32