[CS-Project-svn_notify] SF.net SVN: cs-project: [729] trunk/docs/sql

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

Revision: 729
          http://cs-project.svn.sourceforge.net/cs-project/?rev=729&view=rev
Author:   crazedsanity
Date:     2007-12-27 17:47:25 -0800 (Thu, 27 Dec 2007)

Log Message:
-----------
SQL for changes to tag_name_table (include tag icons).

Modified Paths:
--------------
    trunk/docs/sql/setup/02__tables.sql

Added Paths:
-----------
    trunk/docs/sql/upgrades/upgradeTo1.2.0-ALPHA2.sql

Modified: trunk/docs/sql/setup/02__tables.sql
===================================================================
--- trunk/docs/sql/setup/02__tables.sql	2007-12-28 01:46:46 UTC (rev 728)
+++ trunk/docs/sql/setup/02__tables.sql	2007-12-28 01:47:25 UTC (rev 729)
@@ -690,7 +690,9 @@
 
 CREATE TABLE tag_name_table (
     tag_name_id integer NOT NULL,
-    name text NOT NULL
+    name text NOT NULL,
+	modifier integer NOT NULL default -1,
+	icon_name text
 );
 
 

Copied: trunk/docs/sql/upgrades/upgradeTo1.2.0-ALPHA2.sql (from rev 726, trunk/docs/sql/upgrades/upgradeTo1.1.0-BETA16.sql)
===================================================================
--- trunk/docs/sql/upgrades/upgradeTo1.2.0-ALPHA2.sql	                        (rev 0)
+++ trunk/docs/sql/upgrades/upgradeTo1.2.0-ALPHA2.sql	2007-12-28 01:47:25 UTC (rev 729)
@@ -0,0 +1,12 @@
+--
+-- SVN INFORMATION:::
+-- 
+-- SVN Signature::::::::: $Id$
+-- Last Committted Date:: $Date$
+-- Last Committed Path::: $HeadURL$
+--
+
+ALTER TABLE tag_name_table ADD COLUMN icon_name text DEFAULT NULL;
+
+
+


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.