DROP TABLE IF EXISTS moments; CREATE TABLE IF NOT EXISTS moments ( id integer PRIMARY KEY AUTOINCREMENT, body text NOT NULL, tags text WITH NULL, star integer NOT NULL default 0, created_at text NOT NULL, deleted_at text WITH NULL ); CREATE INDEX idx_moments_created_at ON moments (created_at);