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

[sn...@apache.org]

Author: snoopdave
Date: Tue Sep  6 08:25:36 2005
New Revision: 279021

URL: http://svn.apache.org/viewcvs?rev=279021&view=rev
Log:
Bug fix: its not userrole.handle, its website.handle

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

Modified: incubator/roller/branches/roller_2.0/metadata/database/130-to-200-migration-raw.sql
URL: http://svn.apache.org/viewcvs/incubator/roller/branches/roller_2.0/metadata/database/130-to-200-migration-raw.sql?rev=279021&r1=279020&r2=279021&view=diff
==============================================================================
--- incubator/roller/branches/roller_2.0/metadata/database/130-to-200-migration-raw.sql (original)
+++ incubator/roller/branches/roller_2.0/metadata/database/130-to-200-migration-raw.sql Tue Sep  6 08:25:36 2005
@@ -20,7 +20,7 @@
 -- Add new handle field to uniquely identify websites in URLs
 alter table website add column handle varchar(255) @ALTER_TABLE_NOT_NULL@;
 alter table website add column datecreated  timestamp @ALTER_TABLE_NOT_NULL@;
-create index website_handle_index on userrole(handle);
+create index website_handle_index on website(handle);
 alter table website add constraint website_handle_uq unique (handle@INDEXSIZE@);
 
 -- Add userid to weblogentry so we can track original creator of entry