|
| Choose migration script | 3.3.0-3.4.0.sql |
| Request 1 sql='ALTER TABLE llx_menu MODIFY COLUMN leftmenu varchar(100);' |
| Request 2 sql='create table llx_adherent_type_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;' |
| Request 3 sql='ALTER TABLE llx_adherent_type_extrafields ADD INDEX idx_adherent_type_extrafields (fk_object);' |
| Request 4 sql='UPDATE llx_const set value = __ENCRYPT('eldy_menu.php')__ where __DECRYPT('value')__ = 'eldy_backoffice.php';' |
| Request 5 sql='UPDATE llx_const set value = __ENCRYPT('eldy_menu.php')__ where __DECRYPT('value')__ = 'eldy_frontoffice.php';' |
| Request 6 sql='UPDATE llx_const set value = __ENCRYPT('auguria_menu.php')__ where __DECRYPT('value')__ = 'auguria_backoffice.php';' |
| Request 7 sql='UPDATE llx_const set value = __ENCRYPT('auguria_menu.php')__ where __DECRYPT('value')__ = 'auguria_frontoffice.php';' |
| Request 8 sql='UPDATE llx_const set value = __ENCRYPT('smartphone_menu.php')__ where __DECRYPT('value')__ = 'smartphone_backoffice.php';' |
| Request 9 sql='UPDATE llx_const set value = __ENCRYPT('smartphone_menu.php')__ where __DECRYPT('value')__ = 'smartphone_frontoffice.php';' |
| Request 10 sql='UPDATE llx_const set name = __ENCRYPT('MAIN_INFO_SOCIETE_ADDRESS')__ where __DECRYPT('name')__ = 'MAIN_INFO_SOCIETE_ADRESSE';' |
| Request 11 sql='UPDATE llx_const set name = __ENCRYPT('MAIN_INFO_SOCIETE_TOWN')__ where __DECRYPT('name')__ = 'MAIN_INFO_SOCIETE_VILLE';' |
| Request 12 sql='UPDATE llx_const set name = __ENCRYPT('MAIN_INFO_SOCIETE_ZIP')__ where __DECRYPT('name')__ = 'MAIN_INFO_SOCIETE_CP';' |
| Request 13 sql='UPDATE llx_const set name = __ENCRYPT('MAIN_INFO_SOCIETE_COUNTRY')__ where __DECRYPT('name')__ = 'MAIN_INFO_SOCIETE_PAYS';' |
| Request 14 sql='UPDATE llx_const set name = __ENCRYPT('MAIN_INFO_SOCIETE_STATE')__ where __DECRYPT('name')__ = 'MAIN_INFO_SOCIETE_DEPARTEMENT';' |
| Request 15 sql='UPDATE llx_const set name = __ENCRYPT('LIVRAISON_ADDON_NUMBER')__ where __DECRYPT('name')__ = 'LIVRAISON_ADDON';' |
| Request 16 sql='ALTER TABLE llx_user add COLUMN fk_user integer;' |
| Request 17 sql='alter table llx_contratdet add column fk_product_fournisseur_price integer after info_bits;' |
| Request 18 sql='alter table llx_contratdet add column buy_price_ht double(24,8) DEFAULT 0 after fk_product_fournisseur_price;' |
| Request 19 sql='alter table llx_extrafields add column param text after pos;' |
| Request 20 sql='ALTER TABLE llx_facture_fourn ADD COLUMN ref varchar(30) after rowid;' |
| Request 21 sql='ALTER TABLE llx_facture_fourn MODIFY COLUMN ref varchar(30);' |
| Request 22 sql='ALTER TABLE llx_facture_fourn DROP INDEX uk_facture_fourn;' |
| Request 23 sql='ALTER TABLE llx_facture_fourn DROP INDEX uk_facture_fourn_ref;' |
| Request 24 sql='UPDATE llx_facture_fourn set ref = NULL where ref = '';' |
| Request 25 sql='ALTER TABLE llx_facture_fourn ADD UNIQUE INDEX uk_facture_fourn_ref (ref, entity);' |
| Request 26 sql='ALTER TABLE llx_facture_fourn CHANGE COLUMN facnumber ref_supplier varchar(50);' |
| Request 27 sql='ALTER TABLE llx_facture_fourn ADD UNIQUE INDEX uk_facture_fourn_ref_supplier (ref_supplier, fk_soc, entity);' |
| Request 28 sql='alter table llx_propal CHANGE COLUMN fk_adresse_livraison fk_delivery_address integer;' |
| Request 29 sql='alter table llx_commande CHANGE COLUMN fk_adresse_livraison fk_delivery_address integer;' |
| Request 30 sql='alter table llx_don CHANGE COLUMN adresse address text;' |
| Request 31 sql='alter table llx_don CHANGE COLUMN ville town text;' |
| Request 32 sql='alter table llx_don CHANGE COLUMN prenom firstname varchar(50);' |
| Request 33 sql='alter table llx_don CHANGE COLUMN nom lastname varchar(50);' |
| Request 34 sql='alter table llx_don CHANGE COLUMN cp zip varchar(10);' |
| Request 35 sql='alter table llx_don CHANGE COLUMN pays country varchar(50);' |
| Request 36 sql='alter table llx_adherent CHANGE COLUMN adresse address text;' |
| Request 37 sql='alter table llx_adherent CHANGE COLUMN nom lastname varchar(50);' |
| Request 38 sql='alter table llx_adherent CHANGE COLUMN prenom firstname varchar(50);' |
| Request 39 sql='alter table llx_adherent CHANGE COLUMN ville town text;' |
| Request 40 sql='alter table llx_adherent CHANGE COLUMN cp zip varchar(10);' |
| Request 41 sql='alter table llx_adherent CHANGE COLUMN pays country varchar(50);' |
| Request 42 sql='alter table llx_adherent CHANGE COLUMN naiss birth date;' |
| Request 43 sql='alter table llx_adherent CHANGE COLUMN fk_departement state_id varchar(50);' |
| Request 44 sql='alter table llx_bank_account CHANGE COLUMN adresse_proprio owner_address text;' |
| Request 45 sql='alter table llx_bank_account CHANGE COLUMN fk_departement state_id varchar(50);' |
| Request 46 sql='alter table llx_mailing_cibles CHANGE COLUMN nom lastname varchar(50);' |
| Request 47 sql='alter table llx_mailing_cibles CHANGE COLUMN prenom firstname varchar(50);' |
| Request 48 sql='alter table llx_user CHANGE COLUMN name lastname varchar(50);' |
| Request 49 sql='alter table llx_entrepot CHANGE COLUMN ville town text;' |
| Request 50 sql='alter table llx_entrepot CHANGE COLUMN cp zip varchar(10);' |
| Request 51 sql='alter table llx_societe CHANGE COLUMN ville town text;' |
| Request 52 sql='alter table llx_societe CHANGE COLUMN cp zip varchar(10);' |
| Request 53 sql='alter table llx_societe CHANGE COLUMN tel phone varchar(20);' |
| Request 54 sql='alter table llx_socpeople CHANGE COLUMN name lastname varchar(50);' |
| Request 55 sql='alter table llx_socpeople CHANGE COLUMN ville town text;' |
| Request 56 sql='alter table llx_socpeople CHANGE COLUMN cp zip varchar(10);' |
| Request 57 sql='alter table llx_societe_rib CHANGE COLUMN adresse_proprio owner_address text;' |
| Request 58 sql='alter table llx_societe_address CHANGE COLUMN ville town text;' |
| Request 59 sql='alter table llx_societe_address CHANGE COLUMN cp zip varchar(10);' |
| Request 60 sql='ALTER TABLE llx_expedition DROP FOREIGN KEY fk_expedition_fk_expedition_methode;' |
| Request 61 sql='ALTER TABLE llx_expedition DROP FOREIGN KEY fk_expedition_fk_shipping_method;' |
| Request 62 sql='ALTER TABLE llx_expedition DROP INDEX idx_expedition_fk_expedition_methode;' |
| Request 63 sql='ALTER TABLE llx_expedition CHANGE COLUMN fk_expedition_methode fk_shipping_method integer;' |
| Request 64 sql='ALTER TABLE llx_reception DROP FOREIGN KEY fk_reception_fk_shipping_method;' |
| Request 65 sql='ALTER TABLE llx_c_shipment_mode ADD COLUMN tracking VARCHAR(255) NOT NULL DEFAULT '' AFTER description;' |
| Request 66 sql='ALTER TABLE llx_c_shipment_mode CHANGE COLUMN rowid rowid INTEGER NOT NULL AUTO_INCREMENT;' |
| Request 67 sql='ALTER TABLE llx_expedition ADD INDEX idx_expedition_fk_shipping_method (fk_shipping_method);' |
| Request 68 sql='ALTER TABLE llx_expedition ADD CONSTRAINT fk_expedition_fk_shipping_method FOREIGN KEY (fk_shipping_method) REFERENCES llx_c_shipment_mode (rowid);' |
| Request 69 sql='ALTER TABLE llx_stock_mouvement MODIFY COLUMN value real;' |
| Request 70 sql='create table llx_propal_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;' |
| Request 71 sql='ALTER TABLE llx_propal_extrafields ADD INDEX idx_propal_extrafields (fk_object);' |
| Request 72 sql='create table llx_facture_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;' |
| Request 73 sql='ALTER TABLE llx_facture_extrafields ADD INDEX idx_facture_extrafields (fk_object);' |
| Request 74 sql='ALTER TABLE llx_facture ADD COLUMN revenuestamp double(24,8) DEFAULT 0 AFTER localtax2;' |
| Request 75 sql='CREATE TABLE llx_c_revenuestamp ( rowid integer NOT NULL AUTO_INCREMENT PRIMARY KEY, fk_pays integer NOT NULL, taux double NOT NULL, note varchar(128), active tinyint DEFAULT 1 NOT NULL, accountancy_code_sell varchar(15) DEFAULT NULL, accountancy_code_buy varchar(15) DEFAULT NULL ) ENGINE=innodb;' |
| Request 76 sql='insert into llx_c_revenuestamp(rowid,fk_pays,taux,note,active) values (101, 10, '0.4', 'Timbre fiscal', 1);' |
| Request 77 sql='ALTER TABLE llx_c_tva MODIFY COLUMN localtax1_type varchar(10) DEFAULT NULL;' |
| Request 78 sql='ALTER TABLE llx_c_tva MODIFY COLUMN localtax2_type varchar(10) DEFAULT NULL;' |
| Request 79 sql='ALTER TABLE llx_commande_fournisseurdet MODIFY COLUMN localtax1_type varchar(10) DEFAULT NULL;' |
| Request 80 sql='ALTER TABLE llx_commande_fournisseurdet MODIFY COLUMN localtax2_type varchar(10) DEFAULT NULL;' |
| Request 81 sql='ALTER TABLE llx_commandedet MODIFY COLUMN localtax1_type varchar(10) DEFAULT NULL;' |
| Request 82 sql='ALTER TABLE llx_commandedet MODIFY COLUMN localtax2_type varchar(10) DEFAULT NULL;' |
| Request 83 sql='ALTER TABLE llx_contratdet MODIFY COLUMN localtax1_type varchar(10) DEFAULT NULL;' |
| Request 84 sql='ALTER TABLE llx_contratdet MODIFY COLUMN localtax2_type varchar(10) DEFAULT NULL;' |
| Request 85 sql='ALTER TABLE llx_facture_fourn_det MODIFY COLUMN localtax1_type varchar(10) DEFAULT NULL;' |
| Request 86 sql='ALTER TABLE llx_facture_fourn_det MODIFY COLUMN localtax2_type varchar(10) DEFAULT NULL;' |
| Request 87 sql='ALTER TABLE llx_facturedet_rec MODIFY COLUMN localtax1_type varchar(10) DEFAULT NULL;' |
| Request 88 sql='ALTER TABLE llx_facturedet_rec MODIFY COLUMN localtax2_type varchar(10) DEFAULT NULL;' |
| Request 89 sql='ALTER TABLE llx_facturedet MODIFY COLUMN localtax1_type varchar(10) DEFAULT NULL;' |
| Request 90 sql='ALTER TABLE llx_facturedet MODIFY COLUMN localtax2_type varchar(10) DEFAULT NULL;' |
| Request 91 sql='ALTER TABLE llx_propaldet MODIFY COLUMN localtax1_type varchar(10) DEFAULT NULL;' |
| Request 92 sql='ALTER TABLE llx_propaldet MODIFY COLUMN localtax2_type varchar(10) DEFAULT NULL;' |
| Request 93 sql='UPDATE llx_c_tva set localtax1=0, localtax1_type='0' where localtax1_type = '7';' |
| Request 94 sql='UPDATE llx_c_tva set localtax2=0, localtax2_type='0' where localtax2_type = '7';' |
| Request 95 sql='ALTER TABLE llx_facture_fourn_det ADD COLUMN info_bits integer NOT NULL DEFAULT 0 after date_end;' |
| Request 96 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN info_bits integer NOT NULL DEFAULT 0 after tva_tx;' |
| Request 97 sql='ALTER TABLE llx_actioncomm ADD COLUMN code varchar(32) NULL after fk_action;' |
| Request 98 sql='ALTER TABLE llx_holiday ADD COLUMN note text;' |
| Request 99 sql='ALTER TABLE llx_holiday ADD COLUMN note_public text;' |
| Request 100 sql='INSERT INTO llx_c_action_trigger (rowid,code,label,description,elementtype,rang) values (28,'BILL_UNVALIDATE','Customer invoice unvalidated','Executed when a customer invoice status set back to draft','facture',10);' |
| Request 101 sql='ALTER TABLE llx_c_action_trigger ADD INDEX idx_action_trigger_rang (rang);' |
| Request 102 sql='ALTER TABLE llx_facture_fourn_det ADD COLUMN fk_code_ventilation integer DEFAULT 0 NOT NULL;' |
| Request 103 sql='ALTER TABLE llx_facturedet DROP COLUMN fk_export_compta;' |
| Request 104 sql='CREATE TABLE llx_cronjob ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, datec datetime, jobtype varchar(10) NOT NULL, label text NOT NULL, command varchar(255), classesname varchar(255), objectname varchar(255), methodename varchar(255), params text NOT NULL, md5params varchar(32), module_name varchar(255), priority integer DEFAULT 0, datelastrun datetime, datenextrun datetime, datestart datetime, dateend datetime, datelastresult datetime, lastresult text, lastoutput text, unitfrequency integer NOT NULL DEFAULT 0, frequency integer NOT NULL DEFAULT 0, nbrun integer, status integer NOT NULL DEFAULT 1, fk_user_author integer DEFAULT NULL, fk_user_mod integer DEFAULT NULL, note text )ENGINE=innodb;' |
| Request 105 sql='ALTER TABLE llx_societe MODIFY COLUMN zip varchar(25);' |
| Request 106 sql='ALTER TABLE llx_user ADD COLUMN address varchar(255);' |
| Request 107 sql='ALTER TABLE llx_user ADD COLUMN zip varchar(25);' |
| Request 108 sql='ALTER TABLE llx_user ADD COLUMN town varchar(50);' |
| Request 109 sql='ALTER TABLE llx_user ADD COLUMN fk_state integer DEFAULT 0;' |
| Request 110 sql='ALTER TABLE llx_user ADD COLUMN fk_country integer DEFAULT 0;' |
| Request 111 sql='ALTER TABLE llx_user ADD COLUMN color varchar(6);' |
| Request 112 sql='ALTER TABLE llx_product_price ADD COLUMN import_key varchar(14) AFTER price_by_qty;' |
| Request 113 sql='DROP TABLE llx_printer_ipp;' |
| Request 114 sql='CREATE TABLE llx_printer_ipp ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, datec datetime, printer_name text NOT NULL, printer_location text NOT NULL, printer_uri varchar(255) NOT NULL, copy integer NOT NULL DEFAULT '1', module varchar(16) NOT NULL, login varchar(32) NOT NULL ) ENGINE=innodb;' |
| Request 115 sql='ALTER TABLE llx_socpeople ADD COLUMN ref_ext varchar(128) after entity;' |
| Request 116 sql='ALTER TABLE llx_adherent MODIFY COLUMN ref_ext varchar(128);' |
| Request 117 sql='create table llx_commande_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;' |
| Request 118 sql='ALTER TABLE llx_commande_extrafields ADD INDEX idx_commande_extrafields (fk_object);' |
| Request 119 sql='ALTER TABLE llx_socpeople ADD COLUMN note_public text after note;' |
| Request 120 sql='ALTER TABLE llx_societe ADD COLUMN note_public text after note;' |
| Request 121 sql='ALTER TABLE llx_actioncomm ADD COLUMN transparency integer after fk_user_action;' |
| Request 122 sql='INSERT INTO llx_c_action_trigger (rowid,code,label,description,elementtype,rang) VALUES (29,'FICHINTER_SENTBYMAIL','Intervention sent by mail','Executed when a intervention is sent by mail','ficheinter',29);' |
| Request 123 sql='ALTER TABLE llx_adherent ADD COLUMN canvas varchar(32) after fk_user_valid;' |
| Request 124 sql='ALTER TABLE llx_expedition CHANGE COLUMN note note_private text;' |
| Request 125 sql='ALTER TABLE llx_expedition ADD COLUMN note_public text after note_private;' |
| Request 126 sql='ALTER TABLE llx_livraison CHANGE COLUMN note note_private text;' |
| Request 127 sql='ALTER TABLE llx_facture CHANGE COLUMN note note_private text;' |
| Request 128 sql='ALTER TABLE llx_commande CHANGE COLUMN note note_private text;' |
| Request 129 sql='ALTER TABLE llx_propal CHANGE COLUMN note note_private text;' |
| Request 130 sql='ALTER TABLE llx_commande_fournisseur CHANGE COLUMN note note_private text;' |
| Request 131 sql='ALTER TABLE llx_contrat CHANGE COLUMN note note_private text;' |
| Request 132 sql='ALTER TABLE llx_deplacement CHANGE COLUMN note note_private text;' |
| Request 133 sql='ALTER TABLE llx_don CHANGE COLUMN note note_private text;' |
| Request 134 sql='ALTER TABLE llx_facture_fourn CHANGE COLUMN note note_private text;' |
| Request 135 sql='ALTER TABLE llx_facture_rec CHANGE COLUMN note note_private text;' |
| Request 136 sql='ALTER TABLE llx_holiday CHANGE COLUMN note note_private text;' |
| Request 137 sql='ALTER TABLE llx_societe CHANGE COLUMN note note_private text;' |
| Request 138 sql='ALTER TABLE llx_socpeople CHANGE COLUMN note note_private text;' |
| Request 139 sql='create table llx_projet_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;' |
| Request 140 sql='ALTER TABLE llx_projet_extrafields ADD INDEX idx_projet_extrafields (fk_object);' |
| Request 141 sql='create table llx_projet_task_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;' |
| Request 142 sql='ALTER TABLE llx_projet_task_extrafields ADD INDEX idx_projet_task_extrafields (fk_object);' |
| Request 143 sql='CREATE TABLE llx_opensurvey_comments ( id_comment INTEGER unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, id_sondage CHAR(16) NOT NULL, comment text NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, usercomment text ) ENGINE=InnoDB;' |
| Request 144 sql='CREATE TABLE llx_opensurvey_sondage ( id_sondage VARCHAR(16) PRIMARY KEY, id_sondage_admin CHAR(24), commentaires text, mail_admin VARCHAR(128), nom_admin VARCHAR(64), titre text, date_fin datetime, format VARCHAR(2), mailsonde varchar(2) DEFAULT '0', survey_link_visible integer DEFAULT 1, canedit integer DEFAULT 0, origin varchar(64), tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, sujet TEXT ) ENGINE=InnoDB;' |
| Request 145 sql='CREATE TABLE llx_opensurvey_user_studs ( id_users INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, nom VARCHAR(64) NOT NULL, id_sondage VARCHAR(16) NOT NULL, reponses VARCHAR(100) NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB;' |
| Request 146 sql='ALTER TABLE llx_opensurvey_sondage ADD COLUMN id_sondage_admin CHAR(24);' |
| Request 147 sql='ALTER TABLE llx_opensurvey_comments ADD INDEX idx_id_comment (id_comment);' |
| Request 148 sql='ALTER TABLE llx_opensurvey_comments ADD INDEX idx_id_sondage (id_sondage);' |
| Request 149 sql='ALTER TABLE llx_opensurvey_sondage ADD INDEX idx_id_sondage_admin (id_sondage_admin);' |
| Request 150 sql='ALTER TABLE llx_opensurvey_sondage ADD INDEX idx_date_fin (date_fin);' |
| Request 151 sql='ALTER TABLE llx_opensurvey_user_studs ADD INDEX idx_opensurvey_user_studs_id_users (id_users);' |
| Request 152 sql='ALTER TABLE llx_opensurvey_user_studs ADD INDEX idx_opensurvey_user_studs_nom (nom);' |
| Request 153 sql='ALTER TABLE llx_opensurvey_user_studs ADD INDEX idx_opensurvey_user_studs_id_sondage (id_sondage);' |
| Request 154 sql='ALTER TABLE llx_boxes ADD COLUMN params varchar(255);' |
| Request 155 sql='UPDATE llx_extrafields SET elementtype='socpeople' WHERE elementtype='contact';' |
| Request 156 sql='UPDATE llx_extrafields SET elementtype='actioncomm' WHERE elementtype='action';' |
| Request 157 sql='UPDATE llx_extrafields SET elementtype='adherent' WHERE elementtype='member';' |
| Request 158 sql='UPDATE llx_extrafields SET elementtype='societe' WHERE elementtype='company';' |
| Request 159 sql='create table llx_commande_fournisseur_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;' |
| Request 160 sql='ALTER TABLE llx_commande_fournisseur_extrafields ADD INDEX idx_commande_fournisseur_extrafields (fk_object);' |
| Request 161 sql='create table llx_facture_fourn_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;' |
| Request 162 sql='ALTER TABLE llx_facture_fourn_extrafields ADD INDEX idx_facture_fourn_extrafields (fk_object);' |
| Request 163 sql='ALTER TABLE llx_user_clicktodial ADD COLUMN url varchar(255) AFTER fk_user;' |
| Request 164 sql='ALTER TABLE llx_fichinterdet ADD COLUMN fk_parent_line integer NULL AFTER fk_fichinter;' |
| Request 165 sql='ALTER TABLE llx_societe_address CHANGE COLUMN tel phone varchar(20);' |
| Request 166 sql='insert into llx_c_tva(rowid,fk_pays,taux,recuperableonly,localtax1,localtax1_type,note,active) values (143, 14,'5','0','9.975','1','TPS and TVQ rate',1);' |
| Request 167 sql='DELETE FROM llx_document_model WHERE nom ='elevement' AND type='delivery';' |
| Request 168 sql='DELETE FROM llx_document_model WHERE nom ='' AND type='delivery';' |
| Script processing | OK - Show-Hide details |
