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;