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