[Sommaire] [Imprimer]

   1  
   2  create table ezkeyword(
   3  id int NOT NULL auto_increment,
   4  keyword varchar(255),
   5  class_id int not null,
   6  PRIMARY KEY  (id)
   7  );
   8  
   9  
  10  create table ezkeyword_attribute_link(
  11  id int NOT NULL auto_increment,
  12  keyword_id int not null,
  13  objectattribute_id  int not null,
  14  PRIMARY KEY  (id)
  15  );
  16  
  17  
  18  
  19  CREATE TABLE ezcontentbrowsebookmark (
  20      id integer NOT NULL auto_increment,
  21      user_id integer NOT NULL,
  22      node_id integer NOT NULL,
  23      name  varchar(255) NOT NULL DEFAULT '',
  24      PRIMARY KEY (id)
  25  );
  26  
  27  Create index ezcontentbrowsebookmark_user on ezcontentbrowsebookmark( user_id );
  28  
  29  
  30  CREATE TABLE ezcontentbrowserecent (
  31      id integer NOT NULL auto_increment,
  32      user_id integer NOT NULL,
  33      node_id integer NOT NULL,
  34      created integer NOT NULL DEFAULT 0,
  35      name  varchar(255) NOT NULL DEFAULT '',
  36      PRIMARY KEY (id)
  37  );
  38  
  39  Create index ezcontentbrowserecent_user on ezcontentbrowserecent( user_id );
  40  
  41  
  42  
  43  CREATE TABLE eznotificationevent (
  44      id integer  auto_increment NOT NULL,
  45      status integer NOT NULL DEFAULT 0,
  46      event_type_string varchar(255) NOT NULL,
  47      data_int1 integer NOT NULL default 0,
  48      data_int2 integer NOT NULL default 0,
  49      data_int3 integer NOT NULL default 0,
  50      data_int4 integer NOT NULL default 0,
  51      data_text1 text NOT NULL default '',
  52      data_text2 text NOT NULL default '',
  53      data_text3 text NOT NULL default '',
  54      data_text4 text NOT NULL default '',
  55      primary key ( id )
  56  );
  57  
  58  
  59  
  60  CREATE TABLE eznotificationcollection (
  61      id integer  auto_increment NOT NULL,
  62      event_id integer NOT NULL default 0,
  63      handler varchar(255) NOT NULL default '',
  64      transport varchar(255) NOT NULL default '',
  65      data_subject text NOT NULL default '',
  66      data_text text NOT NULL default '',
  67      primary key ( id )
  68  );
  69  
  70  
  71  CREATE TABLE eznotificationcollection_item (
  72      id integer  auto_increment NOT NULL,
  73      collection_id integer NOT NULL default 0,
  74      event_id integer NOT NULL default 0,
  75      address varchar(255) NOT NULL default '',
  76      send_date integer NOT NULL default 0,
  77      primary key ( id )
  78  );
  79  
  80  
  81  CREATE TABLE ezsubtree_notification_rule (
  82      id integer  auto_increment NOT NULL,
  83      address varchar(255) NOT NULL,
  84      use_digest integer not null default 0,
  85      node_id integer NOT NULL,
  86      primary key ( id )
  87  );
  88  
  89  
  90  
  91  CREATE TABLE ezgeneral_digest_user_settings (
  92      id integer  auto_increment NOT NULL,
  93      address varchar(255) NOT NULL,
  94      receive_digest integer not null default 0,
  95      digest_type integer not null default 0,
  96      day varchar(255) not null default '',
  97      time varchar(255) not null default '',
  98      primary key ( id )
  99  );
 100  
 101  alter table  ezpolicy_limitation_value MODIFY value varchar(255);