[Sommaire] [Imprimer]

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