[Sommaire] [Imprimer]

   1  alter table ezproductcollection add column created integer;
   2  
   3  create table ezproductcollection_item_opt(
   4      id int NOT NULL auto_increment,
   5      item_id int not null,
   6      option_item_id int not null,
   7      name varchar(255) not null,
   8      value varchar(255) not null,
   9      price float not null default 0,
  10      PRIMARY KEY  (id)
  11      );
  12  
  13  alter table ezproductcollection_item modify price double;
  14  alter table ezproductcollection_item add is_vat_inc int;
  15  alter table ezproductcollection_item add vat_value float;
  16  alter table ezproductcollection_item add discount float;
  17  alter table ezproductcollection_item_opt add object_attribute_id int;
  18  
  19  alter table ezorder add data_text_2 text;
  20  alter table ezorder add data_text_1 text;
  21  
  22  alter table ezsection add navigation_part_identifier varchar(100) default 'ezcontentnavigationpart';
  23  alter table ezorder add account_identifier varchar(100) not null default 'default';
  24  
  25  drop table eztask;
  26  drop table eztask_message;
  27  
  28  alter table ezimage add alternative_text varchar(255) not null default "";
  29  alter table ezcontentobject add remote_id varchar(100);
  30  
  31  
  32  alter table ezorder add ignore_vat int not null default '0';
  33  
  34  alter table ezorder_item drop vat_type_id;
  35  alter table ezorder_item drop vat_is_included;
  36  alter table ezorder_item add vat_value int not null default '0';
  37  
  38  alter table ezcontentobject_tree add index ( md5_path );
  39  alter table ezsession drop cache_mask_1;
  40  
  41  create table ezforgot_password(
  42      id int NOT NULL auto_increment,
  43      user_id int not null,
  44      hash_key varchar(32) not null,
  45      time int not null,
  46      PRIMARY KEY  (id)
  47      );
  48  
  49  create table ezuser_accountkey(
  50      id int NOT NULL auto_increment,
  51      user_id int not null,
  52      hash_key varchar(32) not null,
  53      time int not null,
  54      PRIMARY KEY  (id)
  55      );