diff options
| author | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2012-08-02 10:13:55 +0000 |
|---|---|---|
| committer | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2012-08-02 10:13:55 +0000 |
| commit | f4792ba1a7785220fef5adb1cb3e7ce8ac40152f (patch) | |
| tree | 2bd98d59f1c10bf4264f747973ba7a3a643cad8d /poc/poc02-compiling-cake/src/workdir/in/app/config/sql | |
| parent | 104ff522c43fabc7c284fc38a46d17c16fe114d1 (diff) | |
| download | 2012-php-weave-f4792ba1a7785220fef5adb1cb3e7ce8ac40152f.tar.gz 2012-php-weave-f4792ba1a7785220fef5adb1cb3e7ce8ac40152f.tar.bz2 2012-php-weave-f4792ba1a7785220fef5adb1cb3e7ce8ac40152f.zip | |
Creation d'un projet cake (exemple Blog du book) pour développer le CakePHPWeaver
git-svn-id: file:///var/svn/2012-php-weave/trunk@6 d972a294-176a-4cf9-8ea1-fcd5b0c30f5c
Diffstat (limited to 'poc/poc02-compiling-cake/src/workdir/in/app/config/sql')
| -rw-r--r-- | poc/poc02-compiling-cake/src/workdir/in/app/config/sql/db_acl.sql | 38 | ||||
| -rw-r--r-- | poc/poc02-compiling-cake/src/workdir/in/app/config/sql/sessions.sql | 16 |
2 files changed, 54 insertions, 0 deletions
diff --git a/poc/poc02-compiling-cake/src/workdir/in/app/config/sql/db_acl.sql b/poc/poc02-compiling-cake/src/workdir/in/app/config/sql/db_acl.sql new file mode 100644 index 0000000..be8f200 --- /dev/null +++ b/poc/poc02-compiling-cake/src/workdir/in/app/config/sql/db_acl.sql @@ -0,0 +1,38 @@ +# $Id: db_acl.sql 6305 2008-01-02 02:33:56Z 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 acos ( + id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, + object_id INTEGER(10) NULL DEFAULT NULL, + alias VARCHAR(255) NOT NULL DEFAULT '', + lft INTEGER(10) NULL DEFAULT NULL, + rght INTEGER(10) NULL 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, + foreign_key INTEGER(10) UNSIGNED NULL DEFAULT NULL, + alias VARCHAR(255) NOT NULL DEFAULT '', + lft INTEGER(10) NULL DEFAULT NULL, + rght INTEGER(10) NULL DEFAULT NULL, + PRIMARY KEY(id) +);
\ No newline at end of file diff --git a/poc/poc02-compiling-cake/src/workdir/in/app/config/sql/sessions.sql b/poc/poc02-compiling-cake/src/workdir/in/app/config/sql/sessions.sql new file mode 100644 index 0000000..14c0036 --- /dev/null +++ b/poc/poc02-compiling-cake/src/workdir/in/app/config/sql/sessions.sql @@ -0,0 +1,16 @@ +# $Id: sessions.sql 6305 2008-01-02 02:33:56Z 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 |