[Sommaire] [Imprimer]

   1  
   2  
   3  CREATE SEQUENCE ezkeyword_s
   4      START 1
   5      INCREMENT 1
   6      MAXVALUE 9223372036854775807
   7      MINVALUE 1
   8      CACHE 1;
   9  
  10  create table ezkeyword(
  11  id int NOT NULL DEFAULT nextval('ezkeyword_s'::text),
  12  keyword varchar(255),
  13  class_id int not null,
  14  PRIMARY KEY  (id)
  15  );
  16  
  17  CREATE SEQUENCE ezkeyword_attribute_link_s
  18      START 1
  19      INCREMENT 1
  20      MAXVALUE 9223372036854775807
  21      MINVALUE 1
  22      CACHE 1;
  23  
  24  create table ezkeyword_attribute_link(
  25  id int NOT NULL nextval('ezkeyword_attribute_link_s'::text),
  26  keyword_id int not null,
  27  objectattribute_id  int not null,
  28  PRIMARY KEY  (id)
  29  );
  30  
  31  
  32  CREATE SEQUENCE ezcontentbrowsebookmark_s
  33      START 1
  34      INCREMENT 1
  35      MAXVALUE 9223372036854775807
  36      MINVALUE 1
  37      CACHE 1;
  38  
  39  
  40  
  41  CREATE TABLE ezcontentbrowsebookmark (
  42      id integer DEFAULT nextval('ezcontentbrowsebookmark_s'::text) NOT NULL,
  43      user_id integer NOT NULL,
  44      node_id integer NOT NULL,
  45      name character varying NOT NULL DEFAULT ''
  46  );
  47  
  48  ALTER TABLE ONLY ezcontentbrowsebookmark
  49      ADD CONSTRAINT ezcontentbrowsebookmark_pkey PRIMARY KEY (id);
  50  Create index ezcontentbrowsebookmark_user on ezcontentbrowsebookmark( user_id );
  51  
  52  
  53  CREATE SEQUENCE ezcontentbrowserecent_s
  54      START 1
  55      INCREMENT 1
  56      MAXVALUE 9223372036854775807
  57      MINVALUE 1
  58      CACHE 1;
  59  
  60  
  61  
  62  CREATE TABLE ezcontentbrowserecent (
  63      id integer DEFAULT nextval('ezcontentbrowserecent_s'::text) NOT NULL,
  64      user_id integer NOT NULL,
  65      node_id integer NOT NULL,
  66      created integer NOT NULL DEFAULT 0,
  67      name character varying NOT NULL DEFAULT ''
  68  );
  69  
  70  ALTER TABLE ONLY ezcontentbrowserecent
  71      ADD CONSTRAINT ezcontentbrowserecent_pkey PRIMARY KEY (id);
  72  Create index ezcontentbrowserecent_user on ezcontentbrowserecent( user_id );
  73  
  74  
  75  CREATE SEQUENCE eznotificationevent_s
  76      START 1
  77      INCREMENT 1
  78      MAXVALUE 9223372036854775807
  79      MINVALUE 1
  80      CACHE 1;
  81  
  82  
  83  
  84  CREATE TABLE eznotificationevent (
  85      id integer DEFAULT nextval('eznotificationevent_s'::text) NOT NULL,
  86      status integer NOT NULL DEFAULT 0,
  87      event_type_string varchar(255) NOT NULL,
  88      data_int1 integer NOT NULL default 0,
  89      data_int2 integer NOT NULL default 0,
  90      data_int3 integer NOT NULL default 0,
  91      data_int4 integer NOT NULL default 0,
  92      data_text1 text NOT NULL default '',
  93      data_text2 text NOT NULL default '',
  94      data_text3 text NOT NULL default '',
  95      data_text4 text NOT NULL default '',
  96      primary key ( id )
  97  );
  98  
  99  
 100  CREATE SEQUENCE eznotificationcollection_s
 101      START 1
 102      INCREMENT 1
 103      MAXVALUE 9223372036854775807
 104      MINVALUE 1
 105      CACHE 1;
 106  
 107  
 108  
 109  CREATE TABLE eznotificationcollection (
 110      id integer DEFAULT nextval('eznotificationcollection_s'::text) NOT NULL,
 111      event_id integer NOT NULL default 0,
 112      handler varchar(255) NOT NULL default '',
 113      transport varchar(255) NOT NULL default '',
 114      data_subject text NOT NULL default '',
 115      data_text text NOT NULL default '',
 116      primary key ( id )
 117  );
 118  
 119  CREATE SEQUENCE eznotificationcollection_item_s
 120      START 1
 121      INCREMENT 1
 122      MAXVALUE 9223372036854775807
 123      MINVALUE 1
 124      CACHE 1;
 125  
 126  
 127  
 128  CREATE TABLE eznotificationcollection_item (
 129      id integer DEFAULT nextval('eznotificationcollection_item_s'::text) NOT NULL,
 130      collection_id integer NOT NULL default 0,
 131      event_id integer NOT NULL default 0,
 132      address varchar(255) NOT NULL default '',
 133      send_date integer NOT NULL default 0,
 134      primary key ( id )
 135  );
 136  
 137  
 138  CREATE SEQUENCE ezsubtree_notification_rule_s
 139      START 1
 140      INCREMENT 1
 141      MAXVALUE 9223372036854775807
 142      MINVALUE 1
 143      CACHE 1;
 144  
 145  CREATE TABLE ezsubtree_notification_rule (
 146      id integer DEFAULT nextval('ezsubtree_notification_rule_s'::text) NOT NULL,
 147      address varchar(255) NOT NULL,
 148      use_digest integer not null default 0,
 149      node_id integer NOT NULL,
 150      primary key ( id )
 151  );
 152  
 153  
 154  CREATE SEQUENCE ezgeneral_digest_user_settings_s
 155      START 1
 156      INCREMENT 1
 157      MAXVALUE 9223372036854775807
 158      MINVALUE 1
 159      CACHE 1;
 160  
 161  CREATE TABLE ezgeneral_digest_user_settings (
 162      id integer DEFAULT nextval('ezgeneral_digest_user_settings_s'::text) NOT NULL,
 163      address varchar(255) NOT NULL,
 164      receive_digest integer not null default 0,
 165      digest_type integer not null default 0,
 166      day varchar(255) not null default '',
 167      time varchar(255) not null default '',
 168      primary key ( id )
 169  );
 170  
 171  
 172  create temporary table ezpolicy_limitation_value_temp as select * from ezpolicy_limitation_value;
 173  drop table ezpolicy_limitation_value;
 174  CREATE TABLE ezpolicy_limitation_value (
 175      id integer DEFAULT nextval('ezpolicy_limitation_value_s'::text) NOT NULL,
 176      limitation_id integer,
 177      limitation_id integer,
 178   );
 179  insert into ezpolicy_limitation_value(id, limitation_id,value) select id, limitation_id,value::char from ezpolicy_limitation_value_temp;