mint/api-v8/public/db/postgresql/migrations/2021-11-20-084233_res_index/up.sql

-- Your SQL goes here

CREATE TABLE res_indexs
(
	id SERIAL PRIMARY KEY,
	book INTEGER, 
	paragraph INTEGER, 
	title VARCHAR (1024), 
	title_en VARCHAR (1024),  
	level INTEGER, 
	type INTEGER, 
	language VARCHAR (16), 
	author VARCHAR (256), 
	editor INTEGER, 
	share INTEGER, 
	edition INTEGER NOT NULL DEFAULT 1, 
	hit INTEGER DEFAULT 0 NOT NULL, 
	album INTEGER, 
	tag VARCHAR (1024), 
	summary VARCHAR (1024), 
	create_time bigint, 
	update_time bigint
);


CREATE INDEX res_index_title ON res_indexs (title);
CREATE INDEX res_index_title_en ON res_indexs (title_en);