[Sommaire] [Imprimer]

   1  # $Id: db_acl.sql 4409 2007-02-02 13:20:59Z 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    model VARCHAR(255) NOT NULL DEFAULT '',
  14    object_id INTEGER(10) NULL DEFAULT NULL,
  15    alias VARCHAR(255) NOT NULL DEFAULT '',
  16    lft INTEGER(10) NULL DEFAULT NULL,
  17    rght INTEGER(10) NULL DEFAULT NULL,
  18    PRIMARY KEY(id)
  19  );
  20  
  21  CREATE TABLE aros_acos (
  22    id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  23    aro_id INTEGER(10) UNSIGNED NOT NULL,
  24    aco_id INTEGER(10) UNSIGNED NOT NULL,
  25    _create CHAR(2) NOT NULL DEFAULT 0,
  26    _read CHAR(2) NOT NULL DEFAULT 0,
  27    _update CHAR(2) NOT NULL DEFAULT 0,
  28    _delete CHAR(2) NOT NULL DEFAULT 0,
  29    PRIMARY KEY(id)
  30  );
  31  
  32  CREATE TABLE aros (
  33    id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  34    model VARCHAR(255) NOT NULL DEFAULT '',
  35    foreign_key INTEGER(10) UNSIGNED NULL DEFAULT NULL,
  36    alias VARCHAR(255) NOT NULL DEFAULT '',
  37    lft INTEGER(10) NULL DEFAULT NULL,
  38    rght INTEGER(10) NULL DEFAULT NULL,
  39    PRIMARY KEY(id)
  40  );