up.sql 568 B

123456789101112131415161718
  1. -- Your SQL goes here
  2. CREATE TABLE articles (
  3. id SERIAL PRIMARY KEY,
  4. uuid VARCHAR (36) ,
  5. title VARCHAR (32) NOT NULL,
  6. subtitle VARCHAR (32),
  7. summary VARCHAR (255),
  8. content TEXT,
  9. owner_id INTEGER NOT NULL,
  10. owner VARCHAR (36),
  11. setting JSON,
  12. status INTEGER NOT NULL DEFAULT (10),
  13. version INTEGER NOT NULL DEFAULT (1),
  14. deleted_at TIMESTAMP,
  15. created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  16. updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
  17. );