[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.9.0alpha1' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='1' WHERE name='ezpublish-release';
   3  
   4  -- START: from 3.8.1
   5  CREATE INDEX ezkeyword_keyword_id ON ezkeyword USING btree ( keyword, id );
   6  CREATE INDEX ezkeyword_attr_link_kid_oaid ON ezkeyword_attribute_link USING btree ( keyword_id, objectattribute_id );
   7  
   8  CREATE INDEX ezurlalias_is_wildcard ON ezurlalias USING btree ( is_wildcard );
   9  
  10  CREATE INDEX eznode_assignment_coid_cov ON eznode_assignment USING btree ( contentobject_id,contentobject_version );
  11  CREATE INDEX eznode_assignment_is_main ON eznode_assignment USING btree ( is_main );
  12  CREATE INDEX eznode_assignment_parent_node ON eznode_assignment USING btree ( parent_node );
  13  -- END: from 3.8.1
  14  
  15  ALTER TABLE ezuservisit ADD COLUMN failed_login_attempts int;
  16  ALTER TABLE ezuservisit ALTER COLUMN failed_login_attempts SET DEFAULT 0;
  17  ALTER TABLE ezuservisit ALTER COLUMN failed_login_attempts SET NOT NULL;
  18  
  19  ALTER TABLE ezcontentobject_link ADD COLUMN relation_type int;
  20  ALTER TABLE ezcontentobject_link ALTER COLUMN relation_type SET DEFAULT 1;
  21  ALTER TABLE ezcontentobject_link ALTER COLUMN relation_type SET NOT NULL;
  22  UPDATE ezcontentobject_link SET relation_type=8 WHERE contentclassattribute_id<>0;
  23  
  24  
  25  -- START: 'default sorting' attribute for ezcontentclass
  26  
  27  ALTER TABLE ezcontentclass ADD COLUMN sort_field int;
  28  ALTER TABLE ezcontentclass ALTER COLUMN sort_field SET DEFAULT 1;
  29  ALTER TABLE ezcontentclass ALTER COLUMN sort_field SET NOT NULL;
  30  
  31  ALTER TABLE ezcontentclass ADD COLUMN sort_order int;
  32  ALTER TABLE ezcontentclass ALTER COLUMN sort_order SET DEFAULT 1;
  33  ALTER TABLE ezcontentclass ALTER COLUMN sort_order SET NOT NULL;
  34  
  35  -- END: 'default sorting' attribute for ezcontentclass
  36  
  37  -- START: new table for trash
  38  CREATE TABLE ezcontentobject_trash (
  39      contentobject_id integer,
  40      contentobject_version integer,
  41      depth integer DEFAULT 0 NOT NULL,
  42      is_hidden integer DEFAULT 0 NOT NULL,
  43      is_invisible integer DEFAULT 0 NOT NULL,
  44      main_node_id integer,
  45      modified_subnode integer DEFAULT 0,
  46      node_id integer DEFAULT 0 NOT NULL,
  47      parent_node_id integer DEFAULT 0 NOT NULL,
  48      path_identification_string text,
  49      path_string character varying(255) DEFAULT ''::character varying NOT NULL,
  50      priority integer DEFAULT 0 NOT NULL,
  51      remote_id character varying(100) DEFAULT ''::character varying NOT NULL,
  52      sort_field integer DEFAULT 1,
  53      sort_order integer DEFAULT 1
  54  );
  55  
  56  
  57  CREATE INDEX ezcobj_trash_co_id ON ezcontentobject_trash USING btree (contentobject_id);
  58  CREATE INDEX ezcobj_trash_depth ON ezcontentobject_trash USING btree (depth);
  59  CREATE INDEX ezcobj_trash_p_node_id ON ezcontentobject_trash USING btree (parent_node_id);
  60  CREATE INDEX ezcobj_trash_path ON ezcontentobject_trash USING btree (path_string);
  61  CREATE INDEX ezcobj_trash_path_ident ON ezcontentobject_trash USING btree (path_identification_string);
  62  CREATE INDEX ezcobj_trash_modified_subnode ON ezcontentobject_trash USING btree (modified_subnode);
  63  ALTER TABLE ONLY ezcontentobject_trash ADD CONSTRAINT ezcontentobject_trash_pkey PRIMARY KEY (node_id);
  64  -- END: new table for trash
  65  
  66  -- START: ezcontentclass/ezcontentclass_attribute translations
  67  ALTER TABLE ezcontentclass RENAME COLUMN name TO serialized_name_list;
  68  ALTER TABLE ezcontentclass ADD COLUMN language_mask integer;
  69  ALTER TABLE ezcontentclass ALTER language_mask SET NOT NULL;
  70  ALTER TABLE ezcontentclass ALTER language_mask SET DEFAULT 0;
  71  ALTER TABLE ezcontentclass ADD COLUMN initial_language_id integer;
  72  ALTER TABLE ezcontentclass ALTER initial_language_id SET NOT NULL;
  73  ALTER TABLE ezcontentclass ALTER initial_language_id SET DEFAULT 0;
  74  ALTER TABLE ezcontentclass_attribute RENAME COLUMN name TO serialized_name_list;
  75  
  76  CREATE TABLE ezcontentclass_name
  77  (
  78      contentclass_id integer NOT NULL default 0,
  79      contentclass_version integer NOT NULL default 0,
  80      language_locale varchar(20) NOT NULL default '',
  81      language_id integer NOT NULL default 0,
  82      name varchar(255) NOT NULL default ''
  83  );
  84  
  85  ALTER TABLE ONLY ezcontentclass_name
  86      ADD CONSTRAINT ezcontentclass_name_pkey PRIMARY KEY (contentclass_id, contentclass_version, language_id);
  87  -- END: ezcontentclass/ezcontentclass_attribute translations
  88  
  89  -- START: eztipafriend_counter, new column and primary key (new fetch function for tipafriend_top_list)
  90  ALTER TABLE eztipafriend_counter ADD COLUMN requested integer;
  91  ALTER TABLE eztipafriend_counter ALTER requested SET NOT NULL;
  92  ALTER TABLE eztipafriend_counter ALTER requested SET DEFAULT 0;
  93  
  94  ALTER TABLE eztipafriend_counter DROP CONSTRAINT eztipafriend_counter_pkey;
  95  ALTER TABLE ONLY eztipafriend_counter ADD CONSTRAINT eztipafriend_counter_pkey PRIMARY KEY( node_id, requested );
  96  -- END: eztipafriend_counter, new column and primary key (new fetch function for tipafriend_top_list)
  97  
  98  -- START: improvements in shop(better vat handling of order items, like shipping)
  99  ALTER TABLE ezorder_item ADD COLUMN is_vat_inc integer;
 100  ALTER TABLE ezorder_item ALTER is_vat_inc SET NOT NULL;
 101  ALTER TABLE ezorder_item ALTER is_vat_inc SET default 0;
 102  -- END: improvements in shop(better vat handling of order items, like shipping)