CREATE TABLE IF NOT EXISTS ajxp_feed ( id integer NOT NULL primary key autoincrement, edate integer NOT NULL, etype text NOT NULL, htype text NOT NULL, index_path text, user_id text NOT NULL, repository_id text NOT NULL, user_group text, repository_scope text, repository_owner text, content blob NOT NULL ); CREATE INDEX ajxp_feed_repository_id_idx ON ajxp_feed (repository_id); CREATE INDEX ajxp_feed_user_id_idx ON ajxp_feed (user_id);