up.sql 405 B

1234567891011121314
  1. -- Your SQL goes here
  2. CREATE TABLE bolds (
  3. id SERIAL PRIMARY KEY,
  4. book_id INTEGER NOT NULL,
  5. paragraph INTEGER NOT NULL,
  6. word_spell VARCHAR(512) NOT NULL,
  7. word_real VARCHAR(512) NOT NULL,
  8. word_en VARCHAR(512) NOT NULL,
  9. created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
  10. );
  11. CREATE INDEX bolds_word_real ON bolds (word_real);