-
Notifications
You must be signed in to change notification settings - Fork 0
/
SQL load.txt
27 lines (21 loc) · 1.15 KB
/
SQL load.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
CREATE TABLE `buffered_items` (
`item_id` int(10) unsigned NOT NULL, -- ID îáüÿâëåíèÿ
`days_left` int(11) DEFAULT NULL, -- îñòàòîê äíåé äî ñíÿòèÿ ñ ïóáëèêàöèè.
PRIMARY KEY (`item_id`),
CONSTRAINT `id` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `items` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT, -- ID îáúÿâëåíèÿ
`user_id` int(11) unsigned NOT NULL DEFAULT '0', -- ID ïîëüçîâàòåëÿ
`status` tinyint(1) unsigned NOT NULL DEFAULT '1', -- ñòàòóñ îáúÿâëåíèÿ
`title` varchar(150) NOT NULL DEFAULT '', -- çàãîëîâîê îáúÿâëåíèÿ
`link` text, -- ññûëêà íà ñòðàíèöó ïðîñìîòðà îáúÿâëåíèÿ
`descr` text, -- îïèñàíèå îáúÿâëåíèÿ
`publicated_to` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', -- ñðîê îêîí÷àíèÿ ïóáëèêàöèè îáúÿâëåíèÿ
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
CREATE TABLE `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT, -- ID ïîëüçîâàòåëÿ
`email` text, -- Email ïîëüçîâàòåëÿ
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;