roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From snoopd...@apache.org
Subject svn commit: r581099 - /roller/branches/roller_4.1_dev/apps/weblogger/src/sql/createdb.vm
Date Mon, 01 Oct 2007 22:20:50 GMT
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
 



Mime
View raw message