up.sql 291 B

1234567891011
  1. CREATE TABLE sent_historaies
  2. (
  3. id SERIAL PRIMARY KEY,
  4. sent_uid VARCHAR (36),
  5. user_uid VARCHAR (36),
  6. content TEXT,
  7. landmark VARCHAR (64),
  8. date BIGINT,
  9. created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
  10. );
  11. CREATE INDEX sent_historaies_sent_uid ON sent_historaies (sent_uid);