[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.4.0alpha2' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='2' WHERE name='ezpublish-release';
   3  
   4  ---
   5  --- Add session ID to user object
   6  ---
   7  
   8  CREATE TABLE ezuser_session_link (
   9    user_id INTEGER NOT NULL,
  10    session_key CHARACTER VARYING(32),
  11    PRIMARY KEY( user_id, session_key )
  12  );
  13  CREATE INDEX ezuser_session_link_user_idx on ezuser_session_link ( user_id );
  14  CREATE INDEX ezuser_session_link_session_idx on ezuser_session_link ( session_key );
  15  
  16  CREATE INDEX ezpreferences_user_id_idx on ezpreferences ( user_id, name );
  17  
  18  ALTER TABLE ezorder ADD COLUMN email CHARACTER VARYING(150);
  19  ALTER TABLE ezorder ALTER email SET DEFAULT '';
  20  --- 
  21  --- Run script update/common/scripts/addorderemail.php after this change to
  22  --- insert correct email for existing orders.
  23  ---
  24  
  25  
  26  CREATE TABLE ezsubtree_expiry (
  27      subtree character varying(255) NOT NULL,
  28      cache_file character varying(255) NOT NULL
  29  );
  30  
  31  CREATE INDEX ezsubtree_expiry_subtree ON ezsubtree_expiry USING btree (subtree);
  32  
  33  
  34  CREATE TABLE ezpending_actions (
  35    action character varying(64) NOT NULL,
  36    param text
  37  );
  38  
  39  CREATE INDEX ezpending_actions_action ON ezpending_actions USING btree (action);
  40  
  41  
  42  -- Make sure ezrss_export_item (description) has '' as default like the MySQL schema
  43  ALTER TABLE ezrss_export_item RENAME COLUMN description TO description_tmp;
  44  ALTER TABLE ezrss_export_item ADD COLUMN description character varying(255) ;
  45  ALTER TABLE ezrss_export_item ALTER description SET DEFAULT '' ;
  46  UPDATE ezrss_export_item SET description=description_tmp;
  47  ALTER TABLE ezrss_export_item DROP COLUMN description_tmp;
  48  
  49  -- Make sure ezsession (expiration_time) is normal integer and not bigint
  50  ALTER TABLE ezsession RENAME COLUMN expiration_time TO expiration_time_tmp;
  51  ALTER TABLE ezsession ADD COLUMN expiration_time integer ;
  52  ALTER TABLE ezsession ALTER expiration_time SET DEFAULT 0 ;
  53  UPDATE ezsession SET expiration_time=0;
  54  ALTER TABLE ezsession ALTER expiration_time SET NOT NULL ;
  55  UPDATE ezsession SET expiration_time=expiration_time_tmp;
  56  ALTER TABLE ezsession DROP COLUMN expiration_time_tmp;
  57  CREATE INDEX expiration_time986 ON ezsession USING btree (expiration_time);
  58  
  59  -- Run these four if you installed kernel_schema.sql from 3.4.0alpha1, they were missing
  60  -- ALTER TABLE ezuser_role ADD COLUMN limit_identifier varchar(255);
  61  -- ALTER TABLE ezuser_role ALTER limit_identifier SET DEFAULT '';
  62  -- ALTER TABLE ezuser_role ADD COLUMN limit_value varchar(255);
  63  -- ALTER TABLE ezuser_role ALTER limit_value SET DEFAULT '';
  64