· 5 years ago · Feb 11, 2020, 01:20 PM
1DROP TABLE IF EXISTS `authors`;
2CREATE TABLE `authors` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `name` varchar(255) NOT NULL,
5 `url` varchar(255) NOT NULL,
6 `reg_date` varchar(255) NOT NULL,
7 `proj` int(11) NOT NULL,
8 `pos` int(11) NOT NULL,
9 `neg` int(11) NOT NULL,
10 `contacts` int(11) DEFAULT NULL,
11 PRIMARY KEY (`id`)
12) ENGINE=InnoDB DEFAULT CHARSET=utf8;
13
14
15DROP TABLE IF EXISTS `tasks`;
16CREATE TABLE `tasks` (
17 `id` int(11) NOT NULL AUTO_INCREMENT,
18 `name` varchar(255) NOT NULL,
19 `url` text NOT NULL,
20 `price` varchar(255) NOT NULL,
21 `shortText` varchar(255) NOT NULL,
22 `fullText` text,
23 `data_pub` varchar(255) NOT NULL,
24 `daysCount` int(11) DEFAULT NULL,
25 `messages` int(11) NOT NULL,
26 `views` int(11) NOT NULL,
27 `status` varchar(255) NOT NULL,
28 `author` int(11) DEFAULT NULL,
29 PRIMARY KEY (`id`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8;