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