[Phpbbproject-svn] SF.net SVN: phpbbproject: [280] trunk/phpbb3/root/project_install/schemas/ mysql_41_schema.sql

[<lor...@us...>]

Revision: 280
          http://phpbbproject.svn.sourceforge.net/phpbbproject/?rev=280&view=rev
Author:   lord_le_brand
Date:     2008-05-05 17:23:24 -0700 (Mon, 05 May 2008)

Log Message:
-----------
whoops , forgot to update sql file =/

Modified Paths:
--------------
    trunk/phpbb3/root/project_install/schemas/mysql_41_schema.sql

Modified: trunk/phpbb3/root/project_install/schemas/mysql_41_schema.sql
===================================================================
--- trunk/phpbb3/root/project_install/schemas/mysql_41_schema.sql	2008-05-06 00:21:55 UTC (rev 279)
+++ trunk/phpbb3/root/project_install/schemas/mysql_41_schema.sql	2008-05-06 00:23:24 UTC (rev 280)
@@ -15,15 +15,6 @@
 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 
 
-# Table: 'phpbb_project_project_authors'
-CREATE TABLE phpbb_project_project_authors (
-	project_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	author_role mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	PRIMARY KEY (project_id, author_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
 # Table: 'phpbb_project_categories'
 CREATE TABLE phpbb_project_categories (
 	category_id mediumint(8) UNSIGNED NOT NULL auto_increment,
@@ -150,22 +141,36 @@
 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 
 
-# Table: 'phpbb_project_tracker_entries'
-CREATE TABLE phpbb_project_tracker_entries (
-	entry_id int(11) UNSIGNED NOT NULL auto_increment,
+# Table: 'phpbb_project_tracker_tickets'
+CREATE TABLE phpbb_project_tracker_tickets (
+	ticket_id int(11) UNSIGNED NOT NULL auto_increment,
 	tracker_id int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	tracker_category int(11) UNSIGNED DEFAULT '0' NOT NULL,
-	entry_title varchar(100) DEFAULT '' NOT NULL,
-	entry_description mediumtext NOT NULL,
-	entry_status smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
-	entry_author mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-	entry_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
-	PRIMARY KEY (entry_id),
+	ticket_title varchar(100) DEFAULT '' NOT NULL,
+	ticket_description mediumtext NOT NULL,
+	ticket_status smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
+	ticket_author mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+	ticket_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
+	PRIMARY KEY (ticket_id),
 	KEY tracker_id (tracker_id),
 	KEY tracker_category (tracker_category)
 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 
 
+# Table: 'phpbb_project_tracker_comments'
+CREATE TABLE phpbb_project_tracker_comments (
+	comment_id int(11) UNSIGNED NOT NULL auto_increment,
+	ticket_id int(11) UNSIGNED DEFAULT '0' NOT NULL,
+	comment_title varchar(100) DEFAULT '' NOT NULL,
+	comment_text text NOT NULL,
+	comment_author mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+	comment_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
+	PRIMARY KEY (comment_id),
+	KEY ticket_id (ticket_id),
+	KEY comment_time (comment_time)
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
+
+
 # Table: 'phpbb_project_search_wordmatch'
 CREATE TABLE phpbb_project_search_wordmatch (
 	project_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
@@ -212,9 +217,8 @@
 	license_id tinyint(3) NOT NULL auto_increment,
 	license_title varchar(100) DEFAULT '' NOT NULL,
 	license_acronym varchar(15) DEFAULT '' NOT NULL,
+	license_description text NOT NULL,
 	license_text mediumtext NOT NULL,
 	license_url varchar(255) DEFAULT '' NOT NULL,
 	PRIMARY KEY (license_id)
 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-


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