Projects / Chaw

diff --git a/.gitignore b/.gitignore index b3abd9b..5c4d679 100644 --- a/.gitignore +++ b/.gitignore @@ -1,9 +1,7 @@ +.DS_Store config/* content/* tmp/* webroot/index.php webroot/test.php -webroot/js/* -plugins/diff -plugins/debug_kit -webroot/css/images \ No newline at end of file +plugins/debug_kit \ No newline at end of file diff --git a/config/schema/schema.php b/config/schema/schema.php new file mode 100644 index 0000000..3e53c9c --- /dev/null +++ b/config/schema/schema.php @@ -0,0 +1,162 @@ +<?php +/* SVN FILE: $Id$ */ +/* Chaw schema generated on: 2009-12-14 08:12:10 : 1260809950*/ +class ChawSchema extends CakeSchema { + var $name = 'Chaw'; + + function before($event = array()) { + return true; + } + + function after($event = array()) { + } + + var $comments = array( + 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), + 'model' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 40), + 'foreign_key' => array('type' => 'integer', 'null' => false, 'default' => '0'), + 'user_id' => array('type' => 'integer', 'null' => false, 'default' => '0'), + 'reason' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 100), + 'changes' => array('type' => 'text', 'null' => true, 'default' => NULL), + 'body' => array('type' => 'text', 'null' => true, 'default' => NULL), + 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'modified' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)), + 'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_general_ci', 'engine' => 'MyISAM') + ); + var $commits = array( + 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), + 'project_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), + 'user_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), + 'branch' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 200), + 'revision' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 40), + 'author' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 200), + 'committer' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 200), + 'commit_date' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'message' => array('type' => 'string', 'null' => true, 'default' => NULL), + 'changes' => array('type' => 'text', 'null' => true, 'default' => NULL), + 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)), + 'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_general_ci', 'engine' => 'MyISAM') + ); + var $permissions = array( + 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), + 'project_id' => array('type' => 'integer', 'null' => true, 'default' => NULL, 'key' => 'index'), + 'user_id' => array('type' => 'integer', 'null' => true, 'default' => NULL, 'key' => 'index'), + 'group' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 50), + 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'modified' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1), 'project_id' => array('column' => 'project_id', 'unique' => 0), 'user_id' => array('column' => 'user_id', 'unique' => 0)), + 'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_general_ci', 'engine' => 'MyISAM') + ); + var $projects = array( + 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), + 'url' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 200), + 'approved' => array('type' => 'boolean', 'null' => false, 'default' => '0'), + 'private' => array('type' => 'boolean', 'null' => false, 'default' => '0'), + 'active' => array('type' => 'boolean', 'null' => false, 'default' => '1'), + 'user_id' => array('type' => 'integer', 'null' => false, 'default' => '0'), + 'fork' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 200), + 'project_id' => array('type' => 'integer', 'null' => false, 'default' => '0'), + 'name' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 200), + 'repo_type' => array('type' => 'string', 'null' => false, 'default' => 'git', 'length' => 10), + 'config' => array('type' => 'text', 'null' => false, 'default' => NULL), + 'users_count' => array('type' => 'integer', 'null' => false, 'default' => '0'), + 'ohloh_project' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 200), + 'description' => array('type' => 'text', 'null' => true, 'default' => NULL), + 'created' => array('type' => 'date', 'null' => true, 'default' => NULL), + 'modified' => array('type' => 'date', 'null' => true, 'default' => NULL), + 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)), + 'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_general_ci', 'engine' => 'MyISAM') + ); + var $tags = array( + 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), + 'key' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 100, 'key' => 'index'), + 'name' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 100), + 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'modified' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1), 'key' => array('column' => 'key', 'unique' => 0)), + 'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_general_ci', 'engine' => 'MyISAM') + ); + var $tags_tickets = array( + 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), + 'tag_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), + 'ticket_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), + 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)), + 'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_general_ci', 'engine' => 'MyISAM') + ); + var $tickets = array( + 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), + 'number' => array('type' => 'integer', 'null' => false, 'default' => NULL), + 'project_id' => array('type' => 'integer', 'null' => false, 'default' => '0'), + 'version_id' => array('type' => 'integer', 'null' => false, 'default' => '0'), + 'reporter' => array('type' => 'integer', 'null' => false, 'default' => '0'), + 'owner' => array('type' => 'integer', 'null' => false, 'default' => '0'), + 'type' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 50), + 'status' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 50), + 'resolution' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 50), + 'priority' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 50), + 'title' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 200), + 'description' => array('type' => 'text', 'null' => true, 'default' => NULL), + 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'modified' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)), + 'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_general_ci', 'engine' => 'MyISAM') + ); + var $timeline = array( + 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), + 'project_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), + 'user_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), + 'model' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 50), + 'foreign_key' => array('type' => 'integer', 'null' => true, 'default' => NULL), + 'event' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 50), + 'data' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 200), + 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)), + 'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_general_ci', 'engine' => 'MyISAM') + ); + var $users = array( + 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), + 'active' => array('type' => 'boolean', 'null' => false, 'default' => '0', 'key' => 'index'), + 'username' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 40, 'key' => 'index'), + 'password' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 40), + 'email' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 200, 'key' => 'index'), + 'ohloh_account' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 200), + 'last_login' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'tmp_pass' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 40), + 'token' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 40), + 'token_expires' => array('type' => 'date', 'null' => true, 'default' => NULL), + 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'modified' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1), 'active' => array('column' => 'active', 'unique' => 0), 'username' => array('column' => 'username', 'unique' => 0), 'email' => array('column' => 'email', 'unique' => 0)), + 'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_general_ci', 'engine' => 'MyISAM') + ); + var $versions = array( + 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), + 'project_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), + 'slug' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 200), + 'title' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 100), + 'description' => array('type' => 'text', 'null' => true, 'default' => NULL), + 'due_date' => array('type' => 'date', 'null' => true, 'default' => NULL), + 'completed' => array('type' => 'boolean', 'null' => true, 'default' => NULL), + 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'modified' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)), + 'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_general_ci', 'engine' => 'MyISAM') + ); + var $wiki = array( + 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), + 'project_id' => array('type' => 'integer', 'null' => false, 'default' => '0', 'key' => 'index'), + 'path' => array('type' => 'string', 'null' => false, 'default' => '/', 'length' => 200, 'key' => 'index'), + 'slug' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 200, 'key' => 'index'), + 'active' => array('type' => 'boolean', 'null' => false, 'default' => '0'), + 'read_only' => array('type' => 'boolean', 'null' => false, 'default' => '0'), + 'last_changed_by' => array('type' => 'integer', 'null' => true, 'default' => NULL), + 'content' => array('type' => 'text', 'null' => true, 'default' => NULL), + 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'modified' => array('type' => 'datetime', 'null' => true, 'default' => NULL), + 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1), 'path' => array('column' => 'path', 'unique' => 0), 'slug' => array('column' => 'slug', 'unique' => 0), 'project_id' => array('column' => 'project_id', 'unique' => 0)), + 'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_general_ci', 'engine' => 'MyISAM') + ); +} +?> \ No newline at end of file diff --git a/config/schema/sessions.php b/config/schema/sessions.php new file mode 100755 index 0000000..76bfd3c --- /dev/null +++ b/config/schema/sessions.php @@ -0,0 +1,55 @@ +<?php +/* SVN FILE: $Id: sessions.php 6296 2008-01-01 22:18:17Z phpnut $ */ +/*Sessions schema generated on: 2007-11-25 07:11:54 : 1196004714*/ +/** + * This is Sessions Schema file + * + * Use it to configure database for Sessions + * + * PHP versions 4 and 5 + * + * CakePHP(tm) : Rapid Development Framework <http://www.cakephp.org/> + * Copyright 2005-2008, Cake Software Foundation, Inc. + * 1785 E. Sahara Avenue, Suite 490-204 + * Las Vegas, Nevada 89104 + * + * Licensed under The MIT License + * Redistributions of files must retain the above copyright notice. + * + * @filesource + * @copyright Copyright 2005-2008, Cake Software Foundation, Inc. + * @link http://www.cakefoundation.org/projects/info/cakephp CakePHP(tm) Project + * @package cake + * @subpackage cake.app.config.sql + * @since CakePHP(tm) v 0.2.9 + * @version $Revision: 6296 $ + * @modifiedby $LastChangedBy: phpnut $ + * @lastmodified $Date: 2008-01-01 14:18:17 -0800 (Tue, 01 Jan 2008) $ + * @license http://www.opensource.org/licenses/mit-license.php The MIT License + */ +/* + * + * Using the Schema command line utility + * cake schema run create Sessions + * + */ +class SessionsSchema extends CakeSchema { + + var $name = 'Sessions'; + + function before($event = array()) { + return true; + } + + function after($event = array()) { + } + + var $cake_sessions = array( + 'id' => array('type'=>'string', 'null' => false, 'key' => 'primary'), + 'data' => array('type'=>'text', 'null' => true, 'default' => NULL), + 'expires' => array('type'=>'integer', 'null' => true, 'default' => NULL), + 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)) + ); + +} +?> \ No newline at end of file diff --git a/config/sql/i18n.php b/config/sql/i18n.php deleted file mode 100755 index 02e9f0e..0000000 --- a/config/sql/i18n.php +++ /dev/null @@ -1,58 +0,0 @@ -<?php -/* SVN FILE: $Id: i18n.php 6354 2008-01-10 07:02:33Z nate $ */ -/*i18n schema generated on: 2007-11-25 07:11:25 : 1196004805*/ -/** - * This is i18n Schema file - * - * Use it to configure database for i18n - * - * PHP versions 4 and 5 - * - * CakePHP(tm) : Rapid Development Framework <http://www.cakephp.org/> - * Copyright 2005-2008, Cake Software Foundation, Inc. - * 1785 E. Sahara Avenue, Suite 490-204 - * Las Vegas, Nevada 89104 - * - * Licensed under The MIT License - * Redistributions of files must retain the above copyright notice. - * - * @filesource - * @copyright Copyright 2005-2008, Cake Software Foundation, Inc. - * @link http://www.cakefoundation.org/projects/info/cakephp CakePHP(tm) Project - * @package cake - * @subpackage cake.app.config.sql - * @since CakePHP(tm) v 0.2.9 - * @version $Revision: 6354 $ - * @modifiedby $LastChangedBy: nate $ - * @lastmodified $Date: 2008-01-09 23:02:33 -0800 (Wed, 09 Jan 2008) $ - * @license http://www.opensource.org/licenses/mit-license.php The MIT License - */ -/* - * - * Using the Schema command line utility - * cake schema run create i18n - * - */ -class i18nSchema extends CakeSchema { - - var $name = 'i18n'; - - function before($event = array()) { - return true; - } - - function after($event = array()) { - } - - var $i18n = array( - 'id' => array('type'=>'integer', 'null' => false, 'default' => NULL, 'length' => 10, 'key' => 'primary'), - 'locale' => array('type'=>'string', 'null' => false, 'length' => 6, 'key' => 'index'), - 'model' => array('type'=>'string', 'null' => false, 'key' => 'index'), - 'foreign_key' => array('type'=>'integer', 'null' => false, 'length' => 10, 'key' => 'index'), - 'field' => array('type'=>'string', 'null' => false, 'key' => 'index'), - 'content' => array('type'=>'text', 'null' => true, 'default' => NULL), - 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1), 'locale' => array('column' => 'locale', 'unique' => 0), 'model' => array('column' => 'model', 'unique' => 0), 'row_id' => array('column' => 'foreign_key', 'unique' => 0), 'field' => array('column' => 'field', 'unique' => 0)) - ); - -} -?> \ No newline at end of file diff --git a/config/sql/i18n.sql b/config/sql/i18n.sql deleted file mode 100755 index 64f7a8e..0000000 --- a/config/sql/i18n.sql +++ /dev/null @@ -1,28 +0,0 @@ -# $Id: i18n.sql 6314 2008-01-02 21:33:51Z phpnut $ -# -# Copyright 2005-2008, Cake Software Foundation, Inc. -# 1785 E. Sahara Avenue, Suite 490-204 -# Las Vegas, Nevada 89104 -# -# Licensed under The MIT License -# Redistributions of files must retain the above copyright notice. -# http://www.opensource.org/licenses/mit-license.php The MIT License - -CREATE TABLE i18n ( - id int(10) NOT NULL auto_increment, - locale varchar(6) NOT NULL, - model varchar(255) NOT NULL, - foreign_key int(10) NOT NULL, - field varchar(255) NOT NULL, - content mediumtext, - PRIMARY KEY (id), -# UNIQUE INDEX I18N_LOCALE_FIELD(locale, model, foreign_key, field), -# INDEX I18N_LOCALE_ROW(locale, model, foreign_key), -# INDEX I18N_LOCALE_MODEL(locale, model), -# INDEX I18N_FIELD(model, foreign_key, field), -# INDEX I18N_ROW(model, foreign_key), - INDEX locale (locale), - INDEX model (model), - INDEX row_id (foreign_key), - INDEX field (field) -); \ No newline at end of file diff --git a/config/sql/schema.php b/config/sql/schema.php deleted file mode 100644 index e59f2a2..0000000 --- a/config/sql/schema.php +++ /dev/null @@ -1,159 +0,0 @@ -<?php -/* SVN FILE: $Id$ */ -/* Chaw schema generated on: 2009-02-07 09:02:00 : 1234015860*/ -class ChawSchema extends CakeSchema { - var $name = 'Chaw'; - - function before($event = array()) { - return true; - } - - function after($event = array()) { - } - - var $comments = array( - 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), - 'model' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 40), - 'foreign_key' => array('type' => 'integer', 'null' => false, 'default' => '0'), - 'user_id' => array('type' => 'integer', 'null' => false, 'default' => '0'), - 'reason' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 100), - 'changes' => array('type' => 'text', 'null' => true, 'default' => NULL), - 'body' => array('type' => 'text', 'null' => true, 'default' => NULL), - 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'modified' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)) - ); - var $commits = array( - 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), - 'project_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), - 'user_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), - 'branch' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 200), - 'revision' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 40), - 'author' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 200), - 'committer' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 200), - 'commit_date' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'message' => array('type' => 'string', 'null' => true, 'default' => NULL), - 'changes' => array('type' => 'text', 'null' => true, 'default' => NULL), - 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)) - ); - var $permissions = array( - 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), - 'project_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), - 'user_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), - 'group' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 50), - 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'modified' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)) - ); - var $projects = array( - 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), - 'url' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 200), - 'approved' => array('type' => 'boolean', 'null' => false, 'default' => '0'), - 'private' => array('type' => 'boolean', 'null' => false, 'default' => '0'), - 'active' => array('type' => 'boolean', 'null' => false, 'default' => '1'), - 'user_id' => array('type' => 'integer', 'null' => false, 'default' => '0'), - 'fork' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 200), - 'project_id' => array('type' => 'integer', 'null' => false, 'default' => '0'), - 'name' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 200), - 'repo_type' => array('type' => 'string', 'null' => false, 'default' => 'git', 'length' => 10), - 'config' => array('type' => 'text', 'null' => false, 'default' => NULL), - 'users_count' => array('type' => 'integer', 'null' => false, 'default' => '0'), - 'ohloh_project' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 200), - 'description' => array('type' => 'text', 'null' => true, 'default' => NULL), - 'created' => array('type' => 'date', 'null' => true, 'default' => NULL), - 'modified' => array('type' => 'date', 'null' => true, 'default' => NULL), - 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)) - ); - var $queues = array( - 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), - 'project_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), - 'name' => array('type' => 'string', 'null' => true, 'default' => NULL), - 'slug' => array('type' => 'string', 'null' => true, 'default' => NULL), - 'tickets_count' => array('type' => 'integer', 'null' => true, 'default' => NULL), - 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)) - ); - var $tags = array( - 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), - 'key' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 100), - 'name' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 100), - 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'modified' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)) - ); - var $tags_tickets = array( - 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), - 'tag_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), - 'ticket_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), - 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)) - ); - var $tickets = array( - 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), - 'number' => array('type' => 'integer', 'null' => false, 'default' => NULL), - 'project_id' => array('type' => 'integer', 'null' => false, 'default' => 0), - 'version_id' => array('type' => 'integer', 'null' => false, 'default' => 0), - 'reporter' => array('type' => 'integer', 'null' => false, 'default' => 0), - 'owner' => array('type' => 'integer', 'null' => false, 'default' => 0), - 'type' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 50), - 'status' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 50), - 'resolution' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 50), - 'priority' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 50), - 'title' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 200), - 'description' => array('type' => 'text', 'null' => true, 'default' => NULL), - 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'modified' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)) - ); - var $timeline = array( - 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), - 'project_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), - 'user_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), - 'model' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 50), - 'foreign_key' => array('type' => 'integer', 'null' => true, 'default' => NULL), - 'event' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 50), - 'data' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 200), - 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)) - ); - var $users = array( - 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), - 'username' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 40), - 'password' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 40), - 'email' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 200), - 'ohloh_account' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 200), - 'last_login' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'tmp_pass' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 40), - 'token' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 40), - 'token_expires' => array('type' => 'date', 'null' => true, 'default' => NULL), - 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'modified' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'active' => array('type' => 'boolean', 'null' => false, 'default' => '0'), - 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)) - ); - var $versions = array( - 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), - 'project_id' => array('type' => 'integer', 'null' => true, 'default' => NULL), - 'slug' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 200), - 'title' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 100), - 'description' => array('type' => 'text', 'null' => true, 'default' => NULL), - 'due_date' => array('type' => 'date', 'null' => true, 'default' => NULL), - 'completed' => array('type' => 'boolean', 'null' => true, 'default' => NULL), - 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'modified' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)) - ); - var $wiki = array( - 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'), - 'project_id' => array('type' => 'integer', 'null' => false, 'default' => '0'), - 'path' => array('type' => 'string', 'null' => false, 'default' => '/', 'length' => 200), - 'slug' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 200), - 'active' => array('type' => 'boolean', 'null' => false, 'default' => '0'), - 'read_only' => array('type' => 'boolean', 'null' => false, 'default' => '0'), - 'last_changed_by' => array('type' => 'integer', 'null' => true, 'default' => NULL), - 'content' => array('type' => 'text', 'null' => true, 'default' => NULL), - 'created' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'modified' => array('type' => 'datetime', 'null' => true, 'default' => NULL), - 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)) - ); -} -?> \ No newline at end of file diff --git a/config/sql/sessions.php b/config/sql/sessions.php deleted file mode 100755 index 76bfd3c..0000000 --- a/config/sql/sessions.php +++ /dev/null @@ -1,55 +0,0 @@ -<?php -/* SVN FILE: $Id: sessions.php 6296 2008-01-01 22:18:17Z phpnut $ */ -/*Sessions schema generated on: 2007-11-25 07:11:54 : 1196004714*/ -/** - * This is Sessions Schema file - * - * Use it to configure database for Sessions - * - * PHP versions 4 and 5 - * - * CakePHP(tm) : Rapid Development Framework <http://www.cakephp.org/> - * Copyright 2005-2008, Cake Software Foundation, Inc. - * 1785 E. Sahara Avenue, Suite 490-204 - * Las Vegas, Nevada 89104 - * - * Licensed under The MIT License - * Redistributions of files must retain the above copyright notice. - * - * @filesource - * @copyright Copyright 2005-2008, Cake Software Foundation, Inc. - * @link http://www.cakefoundation.org/projects/info/cakephp CakePHP(tm) Project - * @package cake - * @subpackage cake.app.config.sql - * @since CakePHP(tm) v 0.2.9 - * @version $Revision: 6296 $ - * @modifiedby $LastChangedBy: phpnut $ - * @lastmodified $Date: 2008-01-01 14:18:17 -0800 (Tue, 01 Jan 2008) $ - * @license http://www.opensource.org/licenses/mit-license.php The MIT License - */ -/* - * - * Using the Schema command line utility - * cake schema run create Sessions - * - */ -class SessionsSchema extends CakeSchema { - - var $name = 'Sessions'; - - function before($event = array()) { - return true; - } - - function after($event = array()) { - } - - var $cake_sessions = array( - 'id' => array('type'=>'string', 'null' => false, 'key' => 'primary'), - 'data' => array('type'=>'text', 'null' => true, 'default' => NULL), - 'expires' => array('type'=>'integer', 'null' => true, 'default' => NULL), - 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)) - ); - -} -?> \ No newline at end of file diff --git a/config/sql/sessions.sql b/config/sql/sessions.sql deleted file mode 100755 index 5d124d4..0000000 --- a/config/sql/sessions.sql +++ /dev/null @@ -1,16 +0,0 @@ -# $Id: sessions.sql 6314 2008-01-02 21:33:51Z phpnut $ -# -# Copyright 2005-2008, Cake Software Foundation, Inc. -# 1785 E. Sahara Avenue, Suite 490-204 -# Las Vegas, Nevada 89104 -# -# Licensed under The MIT License -# Redistributions of files must retain the above copyright notice. -# http://www.opensource.org/licenses/mit-license.php The MIT License - -CREATE TABLE cake_sessions ( - id varchar(255) NOT NULL default '', - data text, - expires int(11) default NULL, - PRIMARY KEY (id) -); \ No newline at end of file