[Sommaire] [Imprimer]

   1  CREATE TABLE `acos` (
   2    `id` int(11) NOT NULL auto_increment,
   3    `model` varchar(255) NOT NULL default '',
   4    `object_id` int(11) default NULL,
   5    `alias` varchar(255) NOT NULL default '',
   6    `lft` int(11) default NULL,
   7    `rght` int(11) default NULL,
   8    PRIMARY KEY  (`id`)
   9  );
  10  
  11  CREATE TABLE `aros` (
  12    `id` int(11) NOT NULL auto_increment,
  13    `model` varchar(255) NOT NULL default '',
  14    `user_id` int(11) default NULL,
  15    `alias` varchar(255) NOT NULL default '',
  16    `lft` int(11) default NULL,
  17    `rght` int(11) default NULL,
  18    PRIMARY KEY  (`id`)
  19  );
  20  
  21  CREATE TABLE `aros_acos` (
  22    `id` int(11) NOT NULL auto_increment,
  23    `aro_id` int(11) default NULL,
  24    `aco_id` int(11) default NULL,
  25    `_create` int(1) NOT NULL default '0',
  26    `_read` int(1) NOT NULL default '0',
  27    `_update` int(1) NOT NULL default '0',
  28    `_delete` int(11) NOT NULL default '0',
  29    PRIMARY KEY  (`id`)
  30  );