Index: openacs-4/packages/layout-manager/sql/oracle/pages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/layout-manager/sql/oracle/pages-create.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/layout-manager/sql/oracle/pages-create.sql	22 Jul 2008 07:31:02 -0000	1.1
+++ openacs-4/packages/layout-manager/sql/oracle/pages-create.sql	19 Jan 2010 22:52:47 -0000	1.2
@@ -10,9 +10,11 @@
                                     constraint layout_pages_pk
                                     primary key,
     name                            varchar(100)
-                                    default 'Untitled Page'
                                     constraint l_pages_name_nn
                                     not null,
+    url_name                        varchar(100)
+                                    constraint l_pages_url_name_nn
+                                    not null,
     pageset_id                      integer
                                     constraint l_pages_pageset_id_fk
                                     references layout_pagesets (pageset_id)
@@ -31,7 +33,9 @@
                                     constraint l_pages_sort_key_nn
                                     not null,
     constraint l_pages_pageset_id_sort_key_un
-    unique (pageset_id, sort_key)
+    unique (pageset_id, sort_key),
+    constraint l_pages_pageset_id_name_un
+    unique (url_name, name, pageset_id)
 );
 
 create index layout_pages_page_idx on layout_pages (pageset_id, page_id);
