Return-Path: Delivered-To: apmail-roller-commits-archive@www.apache.org Received: (qmail 80646 invoked from network); 1 Oct 2007 22:21:41 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 1 Oct 2007 22:21:41 -0000 Received: (qmail 88573 invoked by uid 500); 1 Oct 2007 22:21:31 -0000 Delivered-To: apmail-roller-commits-archive@roller.apache.org Received: (qmail 88538 invoked by uid 500); 1 Oct 2007 22:21:31 -0000 Mailing-List: contact commits-help@roller.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@roller.apache.org Delivered-To: mailing list commits@roller.apache.org Received: (qmail 88529 invoked by uid 99); 1 Oct 2007 22:21:31 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Oct 2007 15:21:31 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO eris.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Oct 2007 22:21:41 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id D1D3C1A9832; Mon, 1 Oct 2007 15:20:50 -0700 (PDT) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r581099 - /roller/branches/roller_4.1_dev/apps/weblogger/src/sql/createdb.vm Date: Mon, 01 Oct 2007 22:20:50 -0000 To: commits@roller.apache.org From: snoopdave@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20071001222050.D1D3C1A9832@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org 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