3
# Copyright 2005-2010, Cake Software Foundation, Inc.
5
# Licensed under The MIT License
6
# Redistributions of files must retain the above copyright notice.
7
# MIT License (http://www.opensource.org/licenses/mit-license.php)
10
id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
11
parent_id INTEGER(10) DEFAULT NULL,
12
model VARCHAR(255) DEFAULT '',
13
foreign_key INTEGER(10) UNSIGNED DEFAULT NULL,
14
alias VARCHAR(255) DEFAULT '',
15
lft INTEGER(10) DEFAULT NULL,
16
rght INTEGER(10) DEFAULT NULL,
20
CREATE TABLE aros_acos (
21
id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
22
aro_id INTEGER(10) UNSIGNED NOT NULL,
23
aco_id INTEGER(10) UNSIGNED NOT NULL,
24
_create CHAR(2) NOT NULL DEFAULT 0,
25
_read CHAR(2) NOT NULL DEFAULT 0,
26
_update CHAR(2) NOT NULL DEFAULT 0,
27
_delete CHAR(2) NOT NULL DEFAULT 0,
32
id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
33
parent_id INTEGER(10) DEFAULT NULL,
34
model VARCHAR(255) DEFAULT '',
35
foreign_key INTEGER(10) UNSIGNED DEFAULT NULL,
36
alias VARCHAR(255) DEFAULT '',
37
lft INTEGER(10) DEFAULT NULL,
38
rght INTEGER(10) DEFAULT NULL,
b'\\ No newline at end of file'