Author: snoopdave
Date: Mon Oct 1 15:20:49 2007
New Revision: 581099
URL: http://svn.apache.org/viewvc?rev=581099&view=rev
Log:
Removing more references to userid
Modified:
roller/branches/roller_4.1_dev/apps/weblogger/src/sql/createdb.vm
Modified: roller/branches/roller_4.1_dev/apps/weblogger/src/sql/createdb.vm
URL:
http://svn.apache.org/viewvc/roller/branches/roller_4.1_dev/apps/weblogger/src/sql/createdb.vm?rev=581099&r1=581098&r2=581099&view=diff
==============================================================================
--- roller/branches/roller_4.1_dev/apps/weblogger/src/sql/createdb.vm (original)
+++ roller/branches/roller_4.1_dev/apps/weblogger/src/sql/createdb.vm Mon Oct
1 15:20:49 2007
@@ -124,7 +124,6 @@
about varchar(255),
icon varchar(255)
);
-create index ws_userid_idx on website(userid);
create index ws_isenabled_idx on website(isenabled);
alter table website add constraint ws_handle_uq unique (handle$!db.INDEXSIZE);
@@ -502,12 +501,6 @@
-- Now add the foreign key relationships
-- user, role, website, and permissions
-
-alter table website add constraint ws_userid_fk
- foreign key ( userid ) references rolleruser ( id ) $!db.ADDL_FK_PARAMS ;
-
-alter table userrole add constraint ur_userid_fk
- foreign key ( userid ) references rolleruser( id ) $!db.ADDL_FK_PARAMS ;
-- page, entry, category, comment
