Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sqlite>
- sqlite> .schema items
- CREATE TABLE items ( item_id INTEGER, parent_item_id INTEGER, node_id TEXT, parent_node_id TEXT, title TEXT, read INTEGER, updated INTEGER, popup INTEGER, marked INTEGER, source TEXT, source_id TEXT, valid_guid INTEGER, description TEXT, dateINTEGER, comment_feed_id TEXT, comment INTEGER, PRIMARY KEY (item_id));
- CREATE INDEX items_idx ON items (source_id);
- CREATE INDEX items_idx2 ON items (comment_feed_id);
- CREATE INDEX items_idx3 ON items (node_id);
- CREATE INDEX items_idx4 ON items (item_id);
- CREATE INDEX items_idx5 ON items (parent_item_id);
- CREATE INDEX items_idx6 ON items (parent_node_id);
- CREATE TRIGGER item_removal DELETE ON items BEGIN DELETE FROM metadata WHERE item_id = old.item_id; DELETE FROM search_folder_items WHERE item_id = old.item_id; END;
- sqlite>
- sqlite> FROM items LIMIT 9 Select title, description;
- Error: near "FROM": syntax error
- sqlite>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement