Advertisement
nsaunders

Untitled

Sep 20th, 2020
33
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. sqlite>
  2. sqlite> .schema items
  3. 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));
  4. CREATE INDEX items_idx ON items (source_id);
  5. CREATE INDEX items_idx2 ON items (comment_feed_id);
  6. CREATE INDEX items_idx3 ON items (node_id);
  7. CREATE INDEX items_idx4 ON items (item_id);
  8. CREATE INDEX items_idx5 ON items (parent_item_id);
  9. CREATE INDEX items_idx6 ON items (parent_node_id);
  10. 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;
  11. sqlite>
  12. sqlite> FROM items LIMIT 9 Select title, description;
  13. Error: near "FROM": syntax error
  14. sqlite>
  15.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement