1CREATE TABLE fks_newsfeed_news (
2  'news_id'  INTEGER PRIMARY KEY AUTOINCREMENT,
3  'name'     TEXT,
4  'author'   TEXT,
5  'email'    TEXT,
6  'text'     TEXT,
7  'newsdate' TEXT,
8  'image'    TEXT,
9  'category' TEXT
10);
11
12CREATE TABLE fks_newsfeed_stream (
13  'stream_id' INTEGER PRIMARY KEY AUTOINCREMENT,
14  'name'      VARCHAR
15);
16
17CREATE TABLE fks_newsfeed_dependence (
18  'dependence_id' INTEGER PRIMARY KEY AUTOINCREMENT,
19  'parent'        INTEGER,
20  'child'         INTEGER,
21  FOREIGN KEY (child) REFERENCES fks_newsfeed_stream (stream_id),
22  FOREIGN KEY (parent) REFERENCES fks_newsfeed_stream (stream_id)
23);
24
25CREATE TABLE fks_newsfeed_order (
26  'order_id'      INTEGER PRIMARY KEY AUTOINCREMENT,
27  'news_id'       INTEGER,
28  'stream_id'     INTEGER,
29  'priority'      INTEGER,
30  'priority_from' INTEGER,
31  'priority_to'   INTEGER,
32  FOREIGN KEY (news_id) REFERENCES fks_newsfeed_news (news_id),
33  FOREIGN KEY (stream_id) REFERENCES fks_newsfeed_stream (stream_id)
34);
35
36
37
38