[Phpbbproject-svn] SF.net SVN: phpbbproject:[287] trunk
phpBB download manager, mainly aimed at MOD authors
Status: Planning
Brought to you by:
lord_le_brand
From: <lor...@us...> - 2008-07-31 12:00:46
|
Revision: 287 http://phpbbproject.svn.sourceforge.net/phpbbproject/?rev=287&view=rev Author: lord_le_brand Date: 2008-07-31 12:00:51 +0000 (Thu, 31 Jul 2008) Log Message: ----------- Added phpbb_project_project_authors table again... Updated mysql_41_schema.sql Modified Paths: -------------- trunk/develop/create_schema_files_phpbb3.php trunk/develop/todo_list.txt trunk/phpbb3/root/project_install/schemas/mysql_41_schema.sql Modified: trunk/develop/create_schema_files_phpbb3.php =================================================================== --- trunk/develop/create_schema_files_phpbb3.php 2008-07-31 11:15:23 UTC (rev 286) +++ trunk/develop/create_schema_files_phpbb3.php 2008-07-31 12:00:51 UTC (rev 287) @@ -872,7 +872,6 @@ 'project_logo_width' => array('USINT', '0'), 'project_logo_height' => array('USINT', '0'), 'project_start_time' => array('TIMESTAMP', '0'), - 'project_owner' => array('UINT', '0'), 'project_last_update' => array('TIMESTAMP', '0'), 'project_status' => array('BOOL', '0'), 'file_only' => array('BOOL', '0'), @@ -888,6 +887,22 @@ //------------------------------------------ // + // Author-project relationship + // + $schema_data['phpbb_project_project_authors'] = array( + 'COLUMNS' => array( + 'author_id' => array('UINT', '0'), + 'project_id' => array('UINT', '0'), + 'author_order' => array('TINT:2', '0'), + 'is_owner' => array('BOOL', '0'), + 'version_from' => array('UINT:11', '0'), + ), + 'PRIMARY_KEY' => array('author_id', 'project_id'), + ); + + //------------------------------------------ + + // // Actions and versions // $schema_data['phpbb_project_versions'] = array( Modified: trunk/develop/todo_list.txt =================================================================== --- trunk/develop/todo_list.txt 2008-07-31 11:15:23 UTC (rev 286) +++ trunk/develop/todo_list.txt 2008-07-31 12:00:51 UTC (rev 287) @@ -1,6 +1,5 @@ Todo list for phpBB Project -- Add table for authors-project relation (also get rid of project_owner in projects_table?) - Author ordering in MOD(X) file/project overview page - Expand validate_project_title() - Add functions for assigning authors etc. Modified: trunk/phpbb3/root/project_install/schemas/mysql_41_schema.sql =================================================================== --- trunk/phpbb3/root/project_install/schemas/mysql_41_schema.sql 2008-07-31 11:15:23 UTC (rev 286) +++ trunk/phpbb3/root/project_install/schemas/mysql_41_schema.sql 2008-07-31 12:00:51 UTC (rev 287) @@ -54,7 +54,6 @@ project_logo_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL, project_logo_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL, project_start_time int(11) UNSIGNED DEFAULT '0' NOT NULL, - project_owner mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, project_last_update int(11) UNSIGNED DEFAULT '0' NOT NULL, project_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, file_only tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, @@ -65,6 +64,17 @@ ) CHARACTER SET `utf8` COLLATE `utf8_bin`; +# Table: 'phpbb_project_project_authors' +CREATE TABLE phpbb_project_project_authors ( + author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + project_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + author_order tinyint(2) DEFAULT '0' NOT NULL, + is_owner tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, + version_from int(11) UNSIGNED DEFAULT '0' NOT NULL, + PRIMARY KEY (author_id, project_id) +) CHARACTER SET `utf8` COLLATE `utf8_bin`; + + # Table: 'phpbb_project_versions' CREATE TABLE phpbb_project_versions ( version_id int(11) UNSIGNED NOT NULL auto_increment, @@ -222,3 +232,5 @@ 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. |