Changeset 73 in bookmarks

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:

• trunk/bookmarks.sql (modified) (2 diffs)

trunk/bookmarks.sql

@@ -2 +2 @@
 drop table if exists resources;
 drop table if exists bookmarks;
+
+-- resources by URI
+-- this is where we would store information about the resource,
+-- such as its title, last known status, etc.
+create table resources (
+    uri varchar primary key,
+    title varchar -- URI title (e.g., page title)
+);
 
 -- bookmarks of resources
@@ -12 +20 @@
     mtime integer,  -- modification time of the bookmark
     constraint unique_uri unique (uri)
-);
-
--- resources by URI
--- this is where we would store information about the resource,
--- such as its title, last known status, etc.
-create table resources (
-    uri varchar primary key,
-    title varchar -- URI title (e.g., page title)
 );