Author: gangolli
Date: Thu Sep 17 15:13:17 2009
New Revision: 816227
URL: http://svn.apache.org/viewvc?rev=816227&view=rev
Log:
Change mediafile constraint names to agree with migration script.
Modified:
roller/trunk/apps/weblogger/src/sql/createdb.vm
Modified: roller/trunk/apps/weblogger/src/sql/createdb.vm
URL:
http://svn.apache.org/viewvc/roller/trunk/apps/weblogger/src/sql/createdb.vm?rev=816227&r1=816226&r2=816227&view=diff
==============================================================================
--- roller/trunk/apps/weblogger/src/sql/createdb.vm (original)
+++ roller/trunk/apps/weblogger/src/sql/createdb.vm Thu Sep 17 15:13:17 2009
@@ -612,10 +612,10 @@
-- media file foreign key constraints
-alter table roller_mediafile add constraint media_file_directoryid_fk
+alter table roller_mediafile add constraint roller_mediafiledir_id_fk
foreign key (directoryid) references roller_mediafiledir(id)
$!db.ADDL_FK_PARAMS ;
-alter table roller_mediafiletag add constraint media_file_id_tag_fk
+alter table roller_mediafiletag add constraint roller_mediafile_id_tag_fk
foreign key (mediafile_id) references roller_mediafile(id)
$!db.ADDL_FK_PARAMS ;
alter table roller_mediafiledir add constraint mf_websiteid_fk
