From f4792ba1a7785220fef5adb1cb3e7ce8ac40152f Mon Sep 17 00:00:00 2001 From: Ludovic Pouzenc Date: Thu, 2 Aug 2012 10:13:55 +0000 Subject: Creation d'un projet cake (exemple Blog du book) pour développer le CakePHPWeaver 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@6 d972a294-176a-4cf9-8ea1-fcd5b0c30f5c --- .../src/workdir/in/app/config/sql/db_acl.sql | 38 ++++++++++++++++++++++ .../src/workdir/in/app/config/sql/sessions.sql | 16 +++++++++ 2 files changed, 54 insertions(+) create mode 100644 poc/poc02-compiling-cake/src/workdir/in/app/config/sql/db_acl.sql create mode 100644 poc/poc02-compiling-cake/src/workdir/in/app/config/sql/sessions.sql (limited to 'poc/poc02-compiling-cake/src/workdir/in/app/config/sql') 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 -- cgit v1.2.3