From e62dfb1a310aff5efa285e8bde018314e6f70b50 Mon Sep 17 00:00:00 2001 From: Ludovic Pouzenc Date: Thu, 2 Aug 2012 12:12:19 +0000 Subject: Application Blog fonctionnelle avec repertoire du framework separé et mod-rewrite utilisé (donc le index.php à la racine ne sert pas, c'est le app/webroot/index.php qui sert) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit git-svn-id: file:///var/svn/2012-php-weave/trunk@9 d972a294-176a-4cf9-8ea1-fcd5b0c30f5c --- .../src/workdir/in/app/Config/Schema/db_acl.php | 72 ++++++++++++++++++++++ .../src/workdir/in/app/Config/Schema/db_acl.sql | 40 ++++++++++++ .../src/workdir/in/app/Config/Schema/i18n.php | 49 +++++++++++++++ .../src/workdir/in/app/Config/Schema/i18n.sql | 26 ++++++++ .../src/workdir/in/app/Config/Schema/sessions.php | 46 ++++++++++++++ .../src/workdir/in/app/Config/Schema/sessions.sql | 16 +++++ 6 files changed, 249 insertions(+) create mode 100644 poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/db_acl.php create mode 100644 poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/db_acl.sql create mode 100644 poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/i18n.php create mode 100644 poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/i18n.sql create mode 100644 poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/sessions.php create mode 100644 poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/sessions.sql (limited to 'poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema') diff --git a/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/db_acl.php b/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/db_acl.php new file mode 100644 index 0000000..149ded0 --- /dev/null +++ b/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/db_acl.php @@ -0,0 +1,72 @@ + array('type' => 'integer', 'null' => false, 'default' => null, 'length' => 10, 'key' => 'primary'), + 'parent_id' => array('type' => 'integer', 'null' => true, 'default' => null, 'length' => 10), + 'model' => array('type' => 'string', 'null' => true), + 'foreign_key' => array('type' => 'integer', 'null' => true, 'default' => null, 'length' => 10), + 'alias' => array('type' => 'string', 'null' => true), + 'lft' => array('type' => 'integer', 'null' => true, 'default' => null, 'length' => 10), + 'rght' => array('type' => 'integer', 'null' => true, 'default' => null, 'length' => 10), + 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)) + ); + + public $aros = array( + 'id' => array('type' => 'integer', 'null' => false, 'default' => null, 'length' => 10, 'key' => 'primary'), + 'parent_id' => array('type' => 'integer', 'null' => true, 'default' => null, 'length' => 10), + 'model' => array('type' => 'string', 'null' => true), + 'foreign_key' => array('type' => 'integer', 'null' => true, 'default' => null, 'length' => 10), + 'alias' => array('type' => 'string', 'null' => true), + 'lft' => array('type' => 'integer', 'null' => true, 'default' => null, 'length' => 10), + 'rght' => array('type' => 'integer', 'null' => true, 'default' => null, 'length' => 10), + 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)) + ); + + public $aros_acos = array( + 'id' => array('type' => 'integer', 'null' => false, 'default' => null, 'length' => 10, 'key' => 'primary'), + 'aro_id' => array('type' => 'integer', 'null' => false, 'length' => 10, 'key' => 'index'), + 'aco_id' => array('type' => 'integer', 'null' => false, 'length' => 10), + '_create' => array('type' => 'string', 'null' => false, 'default' => '0', 'length' => 2), + '_read' => array('type' => 'string', 'null' => false, 'default' => '0', 'length' => 2), + '_update' => array('type' => 'string', 'null' => false, 'default' => '0', 'length' => 2), + '_delete' => array('type' => 'string', 'null' => false, 'default' => '0', 'length' => 2), + 'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1), 'ARO_ACO_KEY' => array('column' => array('aro_id', 'aco_id'), 'unique' => 1)) + ); + +} diff --git a/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/db_acl.sql b/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/db_acl.sql new file mode 100644 index 0000000..f50f392 --- /dev/null +++ b/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/db_acl.sql @@ -0,0 +1,40 @@ +# $Id$ +# +# Copyright 2005-2012, Cake Software Foundation, Inc. +# +# Licensed under The MIT License +# Redistributions of files must retain the above copyright notice. +# MIT License (http://www.opensource.org/licenses/mit-license.php) + +CREATE TABLE acos ( + id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, + parent_id INTEGER(10) DEFAULT NULL, + model VARCHAR(255) DEFAULT '', + foreign_key INTEGER(10) UNSIGNED DEFAULT NULL, + alias VARCHAR(255) DEFAULT '', + lft INTEGER(10) DEFAULT NULL, + rght INTEGER(10) DEFAULT NULL, + PRIMARY KEY (id) +); + +CREATE TABLE aros_acos ( + id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, + aro_id INTEGER(10) UNSIGNED NOT NULL, + aco_id INTEGER(10) UNSIGNED NOT NULL, + _create CHAR(2) NOT NULL DEFAULT 0, + _read CHAR(2) NOT NULL DEFAULT 0, + _update CHAR(2) NOT NULL DEFAULT 0, + _delete CHAR(2) NOT NULL DEFAULT 0, + PRIMARY KEY(id) +); + +CREATE TABLE aros ( + id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, + parent_id INTEGER(10) DEFAULT NULL, + model VARCHAR(255) DEFAULT '', + foreign_key INTEGER(10) UNSIGNED DEFAULT NULL, + alias VARCHAR(255) DEFAULT '', + lft INTEGER(10) DEFAULT NULL, + rght INTEGER(10) DEFAULT NULL, + PRIMARY KEY (id) +); \ No newline at end of file diff --git a/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/i18n.php b/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/i18n.php new file mode 100644 index 0000000..8de0052 --- /dev/null +++ b/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/i18n.php @@ -0,0 +1,49 @@ + 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)) + ); + +} diff --git a/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/i18n.sql b/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/i18n.sql new file mode 100644 index 0000000..239e146 --- /dev/null +++ b/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/i18n.sql @@ -0,0 +1,26 @@ +# $Id$ +# +# Copyright 2005-2012, Cake Software Foundation, Inc. +# +# Licensed under The MIT License +# Redistributions of files must retain the above copyright notice. +# MIT License (http://www.opensource.org/licenses/mit-license.php) + +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/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/sessions.php b/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/sessions.php new file mode 100644 index 0000000..e98ca06 --- /dev/null +++ b/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/sessions.php @@ -0,0 +1,46 @@ + 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)) + ); + +} diff --git a/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/sessions.sql b/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/sessions.sql new file mode 100644 index 0000000..b8951b6 --- /dev/null +++ b/poc/poc02-compiling-cake/src/workdir/in/app/Config/Schema/sessions.sql @@ -0,0 +1,16 @@ +# $Id$ +# +# Copyright 2005-2012, 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. +# MIT License (http://www.opensource.org/licenses/mit-license.php) + +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 -- cgit v1.2.3