[Cs-project-svn_notify] SF.net SVN: cs-project: [650] trunk/docs/sql/upgrades/upgradeTo1.1.0-BETA14 .sql

[<cra...@us...>]

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.