mint/api-v8/public/db/postgresql/migrations/2021-11-20-221521_word/up.sql

-- Your SQL goes here
-- 表：word
CREATE TABLE words
(
	id SERIAL PRIMARY KEY, 
	sn INTEGER NOT NULL , 
	book INTEGER NOT NULL, 
	paragraph INTEGER NOT NULL, 
	wordindex INTEGER NOT NULL, 
	bold INTEGER NOT NULL  DEFAULT (0), 
	weight INTEGER  NOT NULL  DEFAULT (1),
	created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

-- 索引：pali
CREATE INDEX word_book_paragraph ON words (book, paragraph);

-- 索引：wordindex1
CREATE INDEX word_wordindex ON words (wordindex);