Revision: 650
http://cs-project.svn.sourceforge.net/cs-project/?rev=650&view=rev
Author: crazedsanity
Date: 2007-11-21 08:44:46 -0800 (Wed, 21 Nov 2007)
Log Message:
-----------
Fix SQL so it actually works. ;)
Modified Paths:
--------------
trunk/docs/sql/upgrades/upgradeTo1.1.0-BETA14.sql
Modified: trunk/docs/sql/upgrades/upgradeTo1.1.0-BETA14.sql
===================================================================
--- trunk/docs/sql/upgrades/upgradeTo1.1.0-BETA14.sql 2007-11-21 16:44:10 UTC (rev 649)
+++ trunk/docs/sql/upgrades/upgradeTo1.1.0-BETA14.sql 2007-11-21 16:44:46 UTC (rev 650)
@@ -9,5 +9,5 @@
ALTER TABLE tag_name_table ADD COLUMN modifier int;
UPDATE tag_name_table SET modifier = -1;
-ALTER TABLE tag_name_table ALTER COLUMN SET DEFAULT -1;
-ALTER TABLE tag_name_table SET NOT NULL;
+ALTER TABLE tag_name_table ALTER COLUMN modifier SET DEFAULT -1;
+ALTER TABLE tag_name_table ALTER COLUMN modifier SET NOT NULL;
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
