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.
|