search

blairbasheng / quotes

MIT License
0 stars 1 forks source link

Create Postgres DB #3

Closed sahwho closed 11 months ago

sahwho commented 11 months ago

@BryanR294 

CREATE TABLE quotes (
  quote_id     SERIAL PRIMARY KEY,
  timestamp     TIMESTAMP,
  score      SMALLINT,
  votes     SMALLINT,
  quote       VARCHAR(1024),
  note        VARCHAR(128),
  tags        VARCHAR(128)
);
sahwho commented 11 months ago

Sample insert:

INSERT INTO quotes(timestamp, score, votes, quote, note, tags) VALUES ('2023-11-13 14:41:00',5,5,'Meru: when you think of blindness you think of like not being able to see, and that''s basically what this is','Presentation on cortical blindness in neuro //mod note: later: "so, try not to get a stroke, guys!"','neuro,blindness,meru,');

sahwho commented 11 months ago

Database is up! @BryanR294 @cemeterysummoning @jania210 nice work everyone