訂正　スレ一覧は無かった

CREATE TABLE info(version TEXT);
CREATE TABLE board(board_id INTEGER PRIMARY KEY,board_name TEXT);
CREATE TABLE thread(board_id INTEGER,datname TEXT,title TEXT,
　　last_modified TEXT,lines TEXT,view_pos TEXT,mark TEXT,uri TEXT,
　　state TEXT,new_lines TEXT,write_name TEXT,write_mail TEXT,
　　last_wrote TEXT,last_got TEXT,read_pos TEXT,update_time TEXT);
CREATE INDEX board_name_idx ON board (board_name);
CREATE INDEX board_id_idx ON thread (board_id);
CREATE INDEX datname_idx ON thread (datname);
COMMIT;