[CS-Project-svn_notify] SF.net SVN: cs-project: [798] releases/1.1

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

Revision: 798
          http://cs-project.svn.sourceforge.net/cs-project/?rev=798&view=rev
Author:   crazedsanity
Date:     2008-02-06 22:24:26 -0800 (Wed, 06 Feb 2008)

Log Message:
-----------
 *** RELEASE 1.1.2 ***

SUMMARY OF CHANGES:::
 * fix invalid/missing schema for tags during initial setup (issue #147)

SVN COMMANDS:::
merge -r796:HEAD https://cs-project.svn.sourceforge.net/svnroot/cs-project/trunk/1.1

Modified Paths:
--------------
    releases/1.1/VERSION
    releases/1.1/docs/schema/cs_project.schema.sql
    releases/1.1/docs/sql/setup/02__tables.sql
    releases/1.1/includes/setup/3.inc

Modified: releases/1.1/VERSION
===================================================================
--- releases/1.1/VERSION	2008-02-07 05:28:32 UTC (rev 797)
+++ releases/1.1/VERSION	2008-02-07 06:24:26 UTC (rev 798)
@@ -1,4 +1,4 @@
 $Id:VERSION 628 2007-11-20 16:58:45Z crazedsanity $
 
-VERSION: 1.1.1
+VERSION: 1.1.2
 $HeadURL:https://cs-project.svn.sourceforge.net/svnroot/cs-project/trunk/VERSION $

Modified: releases/1.1/docs/schema/cs_project.schema.sql
===================================================================
--- releases/1.1/docs/schema/cs_project.schema.sql	2008-02-07 05:28:32 UTC (rev 797)
+++ releases/1.1/docs/schema/cs_project.schema.sql	2008-02-07 06:24:26 UTC (rev 798)
@@ -1300,7 +1300,8 @@
 
 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
 );
 
 

Modified: releases/1.1/docs/sql/setup/02__tables.sql
===================================================================
--- releases/1.1/docs/sql/setup/02__tables.sql	2008-02-07 05:28:32 UTC (rev 797)
+++ releases/1.1/docs/sql/setup/02__tables.sql	2008-02-07 06:24:26 UTC (rev 798)
@@ -690,7 +690,8 @@
 
 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
 );
 
 

Modified: releases/1.1/includes/setup/3.inc
===================================================================
--- releases/1.1/includes/setup/3.inc	2008-02-07 05:28:32 UTC (rev 797)
+++ releases/1.1/includes/setup/3.inc	2008-02-07 06:24:26 UTC (rev 798)
@@ -790,19 +790,21 @@
 	//=========================================================================
 	private function create_tag_names() {
 		$tags = array(
-			1	=> 'bug',
-			2	=> 'feature request',
-			3	=> 'information',
-			4	=> 'network related',
-			5	=> 'critical',
-			6	=> 'exception'
+			1	=> array(-1, 'bug'),
+			2	=> array(-1, 'feature request'),
+			3	=> array(0,  'information'),
+			4	=> array(0,  'network related'),
+			5	=> array(-5, 'critical'),
+			6	=> array(-2, 'exception')
 		);
 		
 		$retval = 0;
-		foreach($tags as $id=>$name) {
+		foreach($tags as $id=>$data) {
+			$name = $data[1];
 			$insertArr = array(
 				'tag_name_id'	=> $id,
-				'name'			=> $name
+				'name'			=> $data[1],
+				'modifier'		=> $data[0]
 			);
 			$sql = "INSERT INTO tag_name_table ". $this->gfObj->string_from_array($insertArr, 'insert', NULL, 'sql');
 			$numrows = $this->db->exec($sql);


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