1CREATE TABLE `news`
2(
3    `news_id`      INTEGER PRIMARY KEY AUTO_INCREMENT,
4    `title`        VARCHAR(64) NOT NULL,
5    `author_name`  VARCHAR(64) NOT NULL,
6    `author_email` VARCHAR(64) NOT NULL,
7    `text`         TEXT        NOT NULL,
8    `news_date`    VARCHAR(32) NOT NULL,
9    `image`        VARCHAR(64) NULL DEFAULT NULL,
10    `category`     VARCHAR(32) NOT NULL,
11    `link_href`    VARCHAR(64) NULL DEFAULT NULL,
12    `link_title`   VARCHAR(64) NULL DEFAULT NULL
13);
14
15CREATE TABLE `stream`
16(
17    `stream_id` INTEGER PRIMARY KEY AUTO_INCREMENT,
18    `name`      VARCHAR(32) NOT NULL
19);
20
21CREATE TABLE `dependence`
22(
23    `dependence_id` INTEGER PRIMARY KEY AUTO_INCREMENT,
24    `parent`        INTEGER NOT NULL,
25    `child`         INTEGER NOT NULL,
26    FOREIGN KEY (`child`) REFERENCES `stream` (`stream_id`),
27    FOREIGN KEY (`parent`) REFERENCES `stream` (`stream_id`)
28);
29
30CREATE TABLE `priority`
31(
32    `priority_id`   INTEGER PRIMARY KEY AUTO_INCREMENT,
33    `news_id`       INTEGER NOT NULL,
34    `stream_id`     INTEGER NOT NULL,
35    `priority`      INTEGER NOT NULL DEFAULT 0,
36    `priority_from` INTEGER NULL     DEFAULT NULL,
37    `priority_to`   INTEGER NULL     DEFAULT NULL,
38    FOREIGN KEY (`news_id`) REFERENCES `news` (`news_id`),
39    FOREIGN KEY (`stream_id`) REFERENCES `stream` (`stream_id`)
40);
41
42