Changeset 73 in bookmarks for trunk/bookmarks.sql
- Timestamp:
- 02/27/14 16:06:54 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/bookmarks.sql
r15 r73 2 2 drop table if exists resources; 3 3 drop table if exists bookmarks; 4 5 -- resources by URI 6 -- this is where we would store information about the resource, 7 -- such as its title, last known status, etc. 8 create table resources ( 9 uri varchar primary key, 10 title varchar -- URI title (e.g., page title) 11 ); 4 12 5 13 -- bookmarks of resources … … 12 20 mtime integer, -- modification time of the bookmark 13 21 constraint unique_uri unique (uri) 14 );15 16 -- resources by URI17 -- this is where we would store information about the resource,18 -- such as its title, last known status, etc.19 create table resources (20 uri varchar primary key,21 title varchar -- URI title (e.g., page title)22 22 ); 23 23
Note: See TracChangeset
for help on using the changeset viewer.