[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.3.0' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='1' WHERE name='ezpublish-release';
   3  
   4  ALTER TABLE ezinfocollection ADD COLUMN user_identifier VARCHAR(34);
   5  ALTER TABLE ezinfocollection ADD COLUMN modified INT;
   6  ALTER TABLE ezinfocollection ALTER modified SET DEFAULT 0;
   7  ALTER TABLE ezinfocollection_attribute ADD COLUMN contentobject_attribute_id INT;
   8  ALTER TABLE ezinfocollection_attribute ADD COLUMN contentobject_id INT;
   9  
  10  
  11  CREATE SEQUENCE ezpdf_export_s
  12      START 1
  13      INCREMENT 1
  14      MAXVALUE 9223372036854775807
  15      MINVALUE 1
  16      CACHE 1;
  17  
  18  CREATE TABLE ezpdf_export ( 
  19    id integer DEFAULT nextval('ezpdf_export_s'::text) NOT NULL,
  20    title varchar(255) default NULL,
  21    show_frontpage int default NULL,
  22    intro_text text default NULL,
  23    sub_text text default NULL,
  24    source_node_id int default NULL,
  25    export_structure varchar(255) default NULL,
  26    export_classes varchar(255) default NULL,
  27    site_access varchar(255) default NULL,
  28    pdf_filename varchar(255) default NULL,
  29    modifier_id integer default NULL,
  30    modified integer default NULL,
  31    created integer default NULL,
  32    creator_id integer default NULL,
  33    status integer default NULL,
  34    PRIMARY KEY (id) 
  35  );
  36  
  37  CREATE SEQUENCE ezrss_export_s
  38      START 1
  39      INCREMENT 1
  40      MAXVALUE 9223372036854775807
  41      MINVALUE 1
  42      CACHE 1;
  43  
  44  CREATE TABLE ezrss_export (
  45    id integer DEFAULT nextval('ezrss_export_s'::text) NOT NULL,
  46    title varchar(255) default NULL,
  47    modifier_id integer default NULL,
  48    modified integer default NULL,
  49    url varchar(255) default NULL,
  50    description text,
  51    image_id integer default NULL,
  52    active integer default NULL,
  53    access_url varchar(255) default NULL,
  54    created integer default NULL,
  55    creator_id integer default NULL,
  56    status integer default NULL,
  57    rss_version varchar(255) default NULL,
  58    site_access varchar(255) default NULL,
  59    PRIMARY KEY  (id)
  60  );
  61  
  62  CREATE SEQUENCE ezrss_export_item_s
  63      START 1
  64      INCREMENT 1
  65      MAXVALUE 9223372036854775807
  66      MINVALUE 1
  67      CACHE 1;
  68  
  69  CREATE TABLE ezrss_export_item (
  70    id integer DEFAULT nextval('ezrss_export_item_s'::text) NOT NULL,
  71    rssexport_id integer default NULL,
  72    source_node_id integer default NULL,
  73    class_id integer default NULL,
  74    title varchar(255) default NULL,
  75    description varchar(255) default 0,
  76    PRIMARY KEY  (id)
  77  );
  78  
  79  CREATE INDEX ezrss_export_rsseid ON ezrss_export_item( rssexport_id );
  80  
  81  CREATE SEQUENCE ezrss_import_s
  82      START 1
  83      INCREMENT 1
  84      MAXVALUE 9223372036854775807
  85      MINVALUE 1
  86      CACHE 1;
  87  
  88  CREATE TABLE ezrss_import (
  89    id integer DEFAULT nextval('ezrss_import_s'::text) NOT NULL,
  90    name varchar(255) default NULL,
  91    url text,
  92    destination_node_id integer default NULL,
  93    class_id integer default NULL,
  94    class_title varchar(255) default NULL,
  95    class_url varchar(255) default NULL,
  96    class_description varchar(255) default NULL,
  97    active integer default NULL,
  98    creator_id integer default NULL,
  99    created integer default NULL,
 100    modifier_id integer default NULL,
 101    modified integer default NULL,
 102    status integer default NULL,
 103    object_owner_id integer default NULL,
 104    PRIMARY KEY  (id)
 105  );
 106  
 107  
 108  
 109  
 110  CREATE SEQUENCE ezimagefile_s
 111      START 1
 112      INCREMENT 1
 113      MAXVALUE 9223372036854775807
 114      MINVALUE 1
 115      CACHE 1;
 116  
 117  CREATE TABLE ezimagefile (
 118    id INTEGER DEFAULT nextval('ezimagefile_s'::text) NOT NULL,
 119    contentobject_attribute_id INTEGER NOT NULL,
 120    filepath TEXT NOT NULL,
 121    PRIMARY KEY ( id )
 122  );
 123  
 124  CREATE INDEX ezimagefile_coid ON ezimagefile( contentobject_attribute_id );
 125  CREATE INDEX ezimagefile_file ON ezimagefile( filepath );
 126  
 127  CREATE TABLE eztipafriend_counter (
 128    node_id integer NOT NULL default '0',
 129    count integer NOT NULL default '0',
 130    PRIMARY KEY  (node_id)
 131  );
 132  
 133  CREATE TABLE ezview_counter (
 134    node_id integer NOT NULL default '0',
 135    count integer NOT NULL default '0',
 136    PRIMARY KEY  (node_id)
 137  );
 138  
 139  ALTER TABLE ezcontentobject_attribute ADD COLUMN data_type_string VARCHAR(50);
 140  
 141  UPDATE ezcontentobject_attribute
 142  SET data_type_string=ezcontentclass_attribute.data_type_string 
 143  WHERE ezcontentobject_attribute.contentclassattribute_id=ezcontentclass_attribute.id;
 144  
 145  ALTER TABLE ezcontentobject_version ADD COLUMN workflow_event_pos INT;
 146  ALTER TABLE ezcontentobject_version ALTER workflow_event_pos SET DEFAULT 0;
 147  
 148