svn commit: r290531 - /incubator/roller/branches/roller_2.0/metadata/database/120-to-200-migration-raw.sql

[ag...@apache.org]

Author: agilliland
Date: Tue Sep 20 12:11:00 2005
New Revision: 290531

URL: http://svn.apache.org/viewcvs?rev=290531&view=rev
Log:
commenting out a constraint line that isn't working properly.


Modified:
    incubator/roller/branches/roller_2.0/metadata/database/120-to-200-migration-raw.sql

Modified: incubator/roller/branches/roller_2.0/metadata/database/120-to-200-migration-raw.sql
URL: http://svn.apache.org/viewcvs/incubator/roller/branches/roller_2.0/metadata/database/120-to-200-migration-raw.sql?rev=290531&r1=290530&r2=290531&view=diff
==============================================================================
--- incubator/roller/branches/roller_2.0/metadata/database/120-to-200-migration-raw.sql (original)
+++ incubator/roller/branches/roller_2.0/metadata/database/120-to-200-migration-raw.sql Tue Sep 20 12:11:00 2005
@@ -15,7 +15,11 @@
 alter table website add column datecreated  timestamp @ALTER_TABLE_NOT_NULL@;
 alter table website add column emailaddress varchar(255) @ALTER_TABLE_NOT_NULL@;
 create index website_handle_index on website(handle);
-alter table website add constraint website_handle_uq unique (handle@INDEXSIZE@);
+
+-- this constraint won't work for upgrades until the handle column is
+-- populated with data, otherwise all columns are '' which will not
+-- satisfy the 'unique' condition
+-- alter table website add constraint website_handle_uq unique (handle@INDEXSIZE@);
 
 -- Add userid to weblogentry so we can track original creator of entry
 alter table weblogentry add column userid varchar(48) @ALTER_TABLE_NOT_NULL@;