[Phpbbproject-svn] SF.net SVN: phpbbproject:[297] trunk

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

Revision: 297
          http://sourceforge.net/p/phpbbproject/svn/297
Author:   lord_le_brand
Date:     2014-09-10 08:08:41 +0000 (Wed, 10 Sep 2014)
Log Message:
-----------
A new directory structure is put into place. Development will take a new path, one where features get added along the way and new releases are when a feature is done. In /trunk/develop/ documents will be added to guide the design.

Added Paths:
-----------
    trunk/develop/
    trunk/install_ascraeus/
    trunk/install_olympus/
    trunk/install_olympus/schemas/
    trunk/install_olympus/schemas/mysql_41_schema.sql
    trunk/source_ascraeus/
    trunk/source_olympus/

Property Changed:
----------------
    /

Index: 
===================================================================
--- 	2009-07-29 20:30:05 UTC (rev 296)
+++ 	2014-09-10 08:08:41 UTC (rev 297)

Property changes on: 
___________________________________________________________________
Deleted: svn:externals
## -1 +0,0 ##
-branches/unfinished_business/phpbb3/root/includes/sources_project/mod http://svn2.assembla.com/svn/evilmods/3.0/mod_tools/handler/trunk/root/includes/mod
\ No newline at end of property
Added: trunk/install_olympus/schemas/mysql_41_schema.sql
===================================================================
--- trunk/install_olympus/schemas/mysql_41_schema.sql	                        (rev 0)
+++ trunk/install_olympus/schemas/mysql_41_schema.sql	2014-09-10 08:08:41 UTC (rev 297)
@@ -0,0 +1,71 @@
+CREATE TABLE phpbb_phpbbproject_projects (
+    project_id medumint(8) unsigned not null auto_increment,
+    project_name varchar(255) default '' not null,
+    project_summary text not null,
+    author_user_id mediumint(8) unsigned default '0' not null,
+    project_created int(11) unsigned default '0' not null,
+    category_id mediumint(8) unsigned default '0' not null,
+    project_current_version varchar(20) default '' not null,
+    project_last_update int(11) unsigned default '0' not null,
+    primary key (project_id),
+    key author_user_id (author_user_id),
+    key category_id (category_id)
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
+
+CREATE TABLE phpbb_phpbbproject_categories (
+    category_id mediumint(8) unsigned not null auto_increment,
+    parent_id mediumint(8) unsigned default '0' not null,
+    left_id mediumint(8) unsigned default '0' not null,
+    right_id mediumint(8) unsigned default '0' not null,
+    category_name varchar(255) default '' not null,
+    category_desc text not null,
+    category_projects_per_page tinyint(4) default '0' not null,
+    category_projects mediumint(8) default '0' not null,
+    category_last_project_id mediumint(8) unsigned default '0' not null,
+    category_last_project_time int(11) unsigned default '0' not null,
+    primary key (category_id),
+    key left_right_id (left_id, right_id),
+    key category_last_project_id (category_last_project_id)
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
+
+CREATE TABLE phpbb_phpbbproject_downloads (
+    download_id int(10) unsigned not null auto_increment,
+    project_id mediumint(8) unsigned default '0' not null,
+    download_version varchar(20) default '' not null,
+    download_filepath varchar(255) default '' not null,
+    download_filename varchar(255) default '' not null,
+    download_uploadtime int(11) unsigned default '0' not null,
+    download_count mediumint(8) unsigned default '0' not null,
+    download_filetype varchar(100) default '' not null,
+    download_extension varchar(100) default '' not null,
+    is_orphan tinyint(1) unsigned default '0' not null, 
+    primary key (download_id),
+    key project_id (project_id),
+    key download_uploadtime (download_uploadtime),
+    key is_orphan (is_orphan)
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
+
+CREATE TABLE phpbb_phpbbproject_acl_groups (
+    group_id mediumint(8) unsigned default '0' not null,
+    project_id mediumint(8) unsigned default '0' not null,
+    category_id mediumint(8) unsigned default '0' not null,
+    auth_option_id mediumint(8) unsigned default '0' not null,
+    auth_role_id mediumint(8) unsigned default '0' not null,
+    auth_setting tinyint(2) default '0' not null,
+    key group_id (group_id),
+    key auth_option_id (auth_option_id),
+    key auth_role_id (auth_role_id)
+) CHARACTER SET `utf8` COLLATE `utf8_bin`;
+
+CREATE TABLE phpbb_phpbbproject_acl_users (
+    user_id mediumint(8) unsigned default '0' not null,
+    project_id mediumint(8) unsigned default '0' not null,
+    category_id mediumint(8) unsigned default '0' not null,
+    auth_option_id mediumint(8) unsigned default '0' not null,
+    auth_role_id mediumint(8) unsigned default '0' not null,
+    auth_setting tinyint(2) default '0' not null,
+    key user_id (user_id),
+    key auth_option_id (auth_option_id),
+    key auth_role_id (auth_role_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.