Index: trunk/bookmarks.sql
===================================================================
--- trunk/bookmarks.sql	(revision 72)
+++ trunk/bookmarks.sql	(revision 73)
@@ -2,4 +2,12 @@
 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,12 +20,4 @@
     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)
 );