Annotation of /branches/mambo5/app/config/sql/db_acl.sql
Parent Directory
| 
Revision Log
Revision 2 - (view) (download)
| 1 : | enjoyman | 2 | # $Id: db_acl.sql 4605 2007-03-09 23:26:37Z phpnut $ |
| 2 : | # | ||
| 3 : | # Copyright 2005-2007, Cake Software Foundation, Inc. | ||
| 4 : | # 1785 E. Sahara Avenue, Suite 490-204 | ||
| 5 : | # Las Vegas, Nevada 89104 | ||
| 6 : | # | ||
| 7 : | # Licensed under The MIT License | ||
| 8 : | # Redistributions of files must retain the above copyright notice. | ||
| 9 : | # http://www.opensource.org/licenses/mit-license.php The MIT License | ||
| 10 : | |||
| 11 : | CREATE TABLE acos ( | ||
| 12 : | id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, | ||
| 13 : | parent_id INTEGER(10) DEFAULT NULL, | ||
| 14 : | model VARCHAR(255) DEFAULT '', | ||
| 15 : | foreign_key INTEGER(10) UNSIGNED DEFAULT NULL, | ||
| 16 : | alias VARCHAR(255) DEFAULT '', | ||
| 17 : | lft INTEGER(10) DEFAULT NULL, | ||
| 18 : | rght INTEGER(10) DEFAULT NULL, | ||
| 19 : | PRIMARY KEY (id) | ||
| 20 : | ); | ||
| 21 : | |||
| 22 : | CREATE TABLE aros_acos ( | ||
| 23 : | id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, | ||
| 24 : | aro_id INTEGER(10) UNSIGNED NOT NULL, | ||
| 25 : | aco_id INTEGER(10) UNSIGNED NOT NULL, | ||
| 26 : | _create CHAR(2) NOT NULL DEFAULT 0, | ||
| 27 : | _read CHAR(2) NOT NULL DEFAULT 0, | ||
| 28 : | _update CHAR(2) NOT NULL DEFAULT 0, | ||
| 29 : | _delete CHAR(2) NOT NULL DEFAULT 0, | ||
| 30 : | PRIMARY KEY(id) | ||
| 31 : | ); | ||
| 32 : | |||
| 33 : | CREATE TABLE aros ( | ||
| 34 : | id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, | ||
| 35 : | parent_id INTEGER(10) DEFAULT NULL, | ||
| 36 : | model VARCHAR(255) DEFAULT '', | ||
| 37 : | foreign_key INTEGER(10) UNSIGNED DEFAULT NULL, | ||
| 38 : | alias VARCHAR(255) DEFAULT '', | ||
| 39 : | lft INTEGER(10) DEFAULT NULL, | ||
| 40 : | rght INTEGER(10) DEFAULT NULL, | ||
| 41 : | PRIMARY KEY (id) | ||
| 42 : | ); |
| ViewVC Help | |
| Powered by ViewVC 1.0.0 |
Web Hosting provided by Network Redux.