[Sommaire] [Imprimer]

   1  alter table ezsearch_object_word_link add column identifier varchar(255);
   2  alter table ezsearch_object_word_link add column integer_value integer;
   3  
   4  CREATE SEQUENCE ezcollab_notification_rule_s
   5      START 1
   6      INCREMENT 1
   7      MAXVALUE 9223372036854775807
   8      MINVALUE 1
   9      CACHE 1;
  10  
  11  CREATE TABLE ezcollab_notification_rule (
  12      id integer DEFAULT nextval('ezcollab_notification_rule_s'::text) NOT NULL,
  13      user_id character varying(255) DEFAULT '' NOT NULL,
  14      collab_identifier character varying(255) DEFAULT '' NOT NULL
  15  );
  16  
  17  ALTER TABLE ONLY ezcollab_notification_rule
  18      ADD CONSTRAINT ezcollab_notification_rule160_key PRIMARY KEY (id);
  19  
  20  
  21  CREATE TABLE ezurl_object_link (
  22      url_id integer DEFAULT '0' NOT NULL,
  23      contentobject_attribute_id integer DEFAULT '0' NOT NULL,
  24      contentobject_attribute_version integer DEFAULT '0' NOT NULL
  25  );
  26  
  27  ALTER TABLE ONLY ezurl_object_link
  28      ADD CONSTRAINT ezurl_object_link1039_key PRIMARY KEY (url_id, contentobject_attribute_id, contentobject_attribute_version);
  29  
  30  CREATE TABLE ezsite_data (
  31    name varchar(60) NOT NULL default '',
  32    value text NOT NULL default '',
  33    PRIMARY KEY (name)
  34  );
  35  
  36  INSERT INTO ezsite_data (name, value) VALUES('ezpublish-version', '3.2.0');
  37  INSERT INTO ezsite_data (name, value) VALUES('ezpublish-release', '1');
  38  
  39  
  40  drop index ezcontentobject_tree_depth on ezcontentobject_tree;
  41  create index ezsearch_word_object_count on ezsearch_word(object_count);
  42  create index ezcontentobject_status on ezcontentobject( status );
  43  create index ezcontentobject_tree_path_depth on ezcontentobject_tree( path_string, depth );
  44  
  45  alter table ezcontentclass_attribute add can_translate int default 1;
  46  alter table ezcontentobject_attribute add attribute_original_id int default 0;
  47  
  48  CREATE SEQUENCE ezurlalias_s
  49      START 1
  50      INCREMENT 1
  51      MAXVALUE 9223372036854775807
  52      MINVALUE 1
  53      CACHE 1;
  54  
  55  CREATE TABLE ezurlalias (
  56      id integer DEFAULT nextval('ezurlalias_s'::text) NOT NULL,
  57      source_url text NOT NULL,
  58      source_md5 character varying(32),
  59      destination_url text NOT NULL,
  60      is_internal integer DEFAULT '1' NOT NULL,
  61      forward_to_id integer DEFAULT '0' NOT NULL
  62  );
  63  
  64  CREATE INDEX ezurlalias_source_md51059 ON ezurlalias USING btree (source_md5);
  65  
  66  ALTER TABLE ONLY ezurlalias
  67      ADD CONSTRAINT ezurlalias1051_key PRIMARY KEY (id);
  68  
  69  
  70  create index ezurlalias_source_md5 on ezurlalias( source_md5 );
  71  
  72  insert into ezurlalias ( source_url, source_md5, destination_url, is_internal ) select path_identification_string, md5( path_identification_string ), concat( 'content/view/full/', node_id ), 1 from ezcontentobject_tree where node_id <> 1;
  73  
  74  # Drop unneeded columns
  75  alter table ezcontentobject_tree drop md5_path;
  76  alter table ezcontentobject_tree drop crc32_path;
  77  
  78  CREATE SEQUENCE ezpreferences_s
  79      START 1
  80      INCREMENT 1
  81      MAXVALUE 9223372036854775807
  82      MINVALUE 1
  83      CACHE 1;
  84  
  85  CREATE TABLE ezpreferences (
  86      id integer DEFAULT nextval('ezpreferences_s'::text) NOT NULL,
  87      user_id integer DEFAULT '0' NOT NULL,
  88      name character varying(100),
  89      value character varying(100)
  90  );
  91  
  92  create index ezpreferences_name on ezpreferences using btree ( name );
  93  
  94  ALTER TABLE ONLY ezpreferences
  95      ADD CONSTRAINT ezpreferences833_key PRIMARY KEY (id);
  96  
  97  alter table ezcontentobject_attribute add sort_key_int int not null default 0;
  98  alter table ezcontentobject_attribute add sort_key_string varchar(50) not null default '';
  99  
 100  ## Updates from sort_key to sort_key_int and sort_key_string
 101  # Not needed if you don't upgrade from an svn version of 3.2
 102  # update ezcontentobject_attribute set sort_key_int=sort_key;
 103  # update ezcontentobject_attribute set sort_key_string=sort_key;
 104  # alter table  ezcontentobject_attribute drop sort_key;
 105  
 106  
 107  ALTER TABLE ezcontentobject_attribute ADD index ( sort_key_int );
 108  ALTER TABLE ezcontentobject_attribute ADD index ( sort_key_string );