Changeset 73 in bookmarks for trunk/bookmarks.sql


Ignore:
Timestamp:
02/27/14 16:06:54 (11 years ago)
Author:
peter
Message:

create the resources table first, so that the foreign keys in the bookmarks and tags tables can correctly reference it

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/bookmarks.sql

    r15 r73  
    22drop table if exists resources; 
    33drop 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. 
     8create table resources ( 
     9    uri varchar primary key, 
     10    title varchar -- URI title (e.g., page title) 
     11); 
    412 
    513-- bookmarks of resources 
     
    1220    mtime integer,  -- modification time of the bookmark 
    1321    constraint unique_uri unique (uri) 
    14 ); 
    15  
    16 -- resources by URI 
    17 -- 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) 
    2222); 
    2323 
Note: See TracChangeset for help on using the changeset viewer.