github.com/bitcubate/cryptojournal@v1.2.5-0.20171102134152-f578b3d788ab/db/migrate/Create-Tables.sql.tmpl (about) 1 /* Setup tables for cryptojournal */ 2 CREATE TABLE fragmenta_metadata ( 3 id SERIAL NOT NULL, 4 updated_at timestamp, 5 fragmenta_version text, 6 migration_version text, 7 status integer 8 ); 9 10 CREATE TABLE comments ( 11 id SERIAL NOT NULL, 12 created_at timestamp, 13 updated_at timestamp, 14 parent_id integer, 15 dotted_ids text, 16 points integer, 17 rank integer, 18 level integer, 19 text text, 20 user_name text, 21 story_name text, 22 user_id integer, 23 story_id integer 24 ); 25 26 CREATE TABLE stories ( 27 id SERIAL NOT NULL, 28 created_at timestamp, 29 updated_at timestamp, 30 status integer, 31 name text, 32 url text, 33 rank integer, 34 summary text, 35 user_id integer, 36 user_name text, 37 points integer, 38 comment_count integer 39 ); 40 41 CREATE TABLE votes ( 42 created_at timestamp, 43 comment_id integer, 44 story_id integer, 45 user_id integer, 46 user_ip text, 47 points integer 48 ); 49 50 CREATE TABLE flags ( 51 created_at timestamp, 52 comment_id integer, 53 story_id integer, 54 user_id integer, 55 user_ip text, 56 points integer 57 ); 58 59 CREATE TABLE users ( 60 id SERIAL NOT NULL, 61 created_at timestamp, 62 updated_at timestamp, 63 status integer, 64 role integer, 65 email text, 66 name text, 67 summary text, 68 password_hash text, 69 password_reset_at timestamp, 70 password_reset_token text, 71 points integer 72 ); 73 74 ALTER TABLE fragmenta_metadata OWNER TO cryptojournal_server; 75 ALTER TABLE comments OWNER TO cryptojournal_server; 76 ALTER TABLE flags OWNER TO cryptojournal_server; 77 ALTER TABLE users OWNER TO cryptojournal_server; 78 ALTER TABLE votes OWNER TO cryptojournal_server; 79 ALTER TABLE stories OWNER TO cryptojournal_server; 80 grant all on schema public to public;