 Database migration (structure + some data)
| Server connection : localhost | OK |
| Database connection : htech_ias | OK |
| Database server version | 10.6.20-MariaDB-cll-lve | | Client charset | utf8 | | Client collation | utf8_general_ci | | Please be patient... |
| | Choose migration script | 10.0.0-11.0.0.sql |
| Request 1 sql='ALTER TABLE llx_account_bookkeeping ADD COLUMN date_export datetime DEFAULT NULL;' |
| Request 2 sql='ALTER TABLE llx_expensereport ADD COLUMN paid smallint default 0 NOT NULL;' |
| Request 3 sql='UPDATE llx_expensereport set paid = 1 WHERE fk_statut = 6 and paid = 0;' |
| Request 4 sql='UPDATE llx_c_units SET short_label = 'i' WHERE code = 'MI';' |
| Request 5 sql='UPDATE llx_c_units SET unit_type = 'weight', short_label = 'kg', scale = 0 WHERE code = 'KG';' |
| Request 6 sql='UPDATE llx_c_units SET unit_type = 'weight', short_label = 'g', scale = -3 WHERE code = 'G';' |
| Request 7 sql='UPDATE llx_c_units SET unit_type = 'time' WHERE code IN ('S','H','D');' |
| Request 8 sql='UPDATE llx_c_units SET unit_type = 'size' WHERE code IN ('M','LM');' |
| Request 9 sql='UPDATE llx_c_units SET label = 'SizeUnitm', scale = 0 WHERE code IN ('M');' |
| Request 10 sql='UPDATE llx_c_units SET active = 0, scale = 0 WHERE code IN ('LM');' |
| Request 11 sql='UPDATE llx_c_units SET unit_type = 'surface', scale = 0 WHERE code IN ('M2');' |
| Request 12 sql='UPDATE llx_c_units SET unit_type = 'volume', scale = 0 WHERE code IN ('M3','L');' |
| Request 13 sql='UPDATE llx_c_units SET scale = -3, active = 0 WHERE code IN ('L');' |
| Request 14 sql='UPDATE llx_c_units SET label = 'VolumeUnitm3' WHERE code IN ('M3');' |
| Request 15 sql='UPDATE llx_c_units SET label = 'SurfaceUnitm2' WHERE code IN ('M2');' |
| Request 16 sql='ALTER TABLE llx_adherent_type ADD UNIQUE INDEX uk_adherent_type_libelle (libelle, entity);' |
| Request 17 sql='ALTER TABLE llx_mailing_cibles MODIFY COLUMN lastname varchar(160);' |
| Request 18 sql='ALTER TABLE llx_mailing_cibles MODIFY COLUMN firstname varchar(160);' |
| Request 19 sql='ALTER TABLE llx_emailcollector_emailcollector ADD COLUMN login varchar(128);' |
| Request 20 sql='ALTER TABLE llx_emailcollector_emailcollector ADD COLUMN codelastresult varchar(16);' |
| Request 21 sql='ALTER TABLE llx_emailcollector_emailcollectoraction ADD COLUMN position integer DEFAULT 0;' |
| Request 22 sql='ALTER TABLE llx_product_price MODIFY COLUMN tva_tx double(6,3) DEFAULT 0 NOT NULL;' |
| Request 23 sql='ALTER TABLE llx_facturedet MODIFY COLUMN situation_percent real DEFAULT 100;' |
| Request 24 sql='UPDATE llx_facturedet SET situation_percent = 100 WHERE situation_percent IS NULL AND fk_prev_id IS NULL;' |
| Request 25 sql='UPDATE llx_accounting_system SET fk_country = NULL, active = 0 WHERE pcg_version = 'SYSCOHADA';' |
| Request 26 sql='INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 20, 'BAS-K1-MINI', 'The Swedish mini chart of accounts', 1);' |
| Request 27 sql='ALTER TABLE llx_c_action_trigger MODIFY COLUMN elementtype varchar(64) NOT NULL;' |
| Request 28 sql='ALTER TABLE llx_societe_account ADD COLUMN site_account varchar(128);' |
| Request 29 sql='UPDATE llx_holiday SET ref = rowid WHERE ref IS NULL;' |
| Request 30 sql='ALTER TABLE llx_holiday MODIFY COLUMN ref varchar(30) NOT NULL;' |
| Request 31 sql='ALTER TABLE llx_c_email_senderprofile MODIFY COLUMN active tinyint DEFAULT 1 NOT NULL;' |
| Request 32 sql='insert into llx_c_type_container (code,label,module,active) values ('menu', 'Menu', 'system', 1);' |
| Request 33 sql='INSERT INTO llx_c_ticket_type (code, pos, label, active, use_default, description) VALUES('HELP', '15', 'Request for functionnal help', 1, 0, NULL);' |
| Request 34 sql='ALTER TABLE llx_don ADD COLUMN fk_user_modif integer;' |
| Request 35 sql='ALTER TABLE llx_expeditiondet ADD INDEX idx_expeditiondet_fk_origin_line (fk_origin_line);' |
| Request 36 sql='ALTER TABLE llx_rights_def ADD COLUMN module_position INTEGER NOT NULL DEFAULT 0;' |
| Request 37 sql='ALTER TABLE llx_rights_def ADD COLUMN family_position INTEGER NOT NULL DEFAULT 0;' |
| Request 38 sql='UPDATE llx_rights_def SET subperms = 'write' WHERE perms = 'fiscalyear' AND module = 'accounting' AND subperms IS NULL;' |
| Request 39 sql='ALTER TABLE llx_bom_bom ADD COLUMN duration double(24,8) DEFAULT NULL;' |
| Request 40 sql='ALTER TABLE llx_bom_bom ADD COLUMN fk_warehouse integer;' |
| Request 41 sql='ALTER TABLE llx_bom_bomline ADD COLUMN position integer NOT NULL DEFAULT 0;' |
| Request 42 sql='ALTER TABLE llx_bom_bomline ADD COLUMN qty_frozen smallint DEFAULT 0;' |
| Request 43 sql='ALTER TABLE llx_bom_bomline ADD COLUMN disable_stock_change smallint DEFAULT 0;' |
| Request 44 sql='ALTER TABLE llx_bom_bomline DROP COLUMN `rank`;' |
| Request 45 sql='create table llx_categorie_warehouse ( fk_categorie integer NOT NULL, fk_warehouse integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;' |
| Request 46 sql='ALTER TABLE llx_categorie_warehouse ADD PRIMARY KEY pk_categorie_warehouse (fk_categorie, fk_warehouse);' |
| Request 47 sql='ALTER TABLE llx_categorie_warehouse ADD INDEX idx_categorie_warehouse_fk_categorie (fk_categorie);' |
| Request 48 sql='ALTER TABLE llx_categorie_warehouse ADD INDEX idx_categorie_warehouse_fk_warehouse (fk_warehouse);' |
| Request 49 sql='ALTER TABLE llx_categorie_warehouse ADD CONSTRAINT fk_categorie_warehouse_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);' |
| Request 50 sql='ALTER TABLE llx_categorie_warehouse ADD CONSTRAINT fk_categorie_warehouse_fk_warehouse_rowid FOREIGN KEY (fk_warehouse) REFERENCES llx_entrepot (rowid);' |
| Request 51 sql='create table llx_holiday_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 52 sql='ALTER TABLE llx_holiday_extrafields ADD INDEX idx_holiday_extrafields (fk_object);' |
| Request 53 sql='ALTER TABLE llx_societe_rib MODIFY label varchar(200);' |
| Request 54 sql='ALTER TABLE llx_societe ADD COLUMN logo_squarred varchar(255);' |
| Request 55 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('USER_SENTBYMAIL','Email sent','Executed when an email is sent from user card','user',300);' |
| Request 56 sql='create table llx_entrepot_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 57 sql='ALTER TABLE llx_entrepot_extrafields ADD INDEX idx_entrepot_extrafields (fk_object);' |
| Request 58 sql='ALTER TABLE llx_extrafields ADD COLUMN printable boolean DEFAULT FALSE;' |
| Request 59 sql='ALTER TABLE llx_facture ADD COLUMN retained_warranty real DEFAULT NULL after situation_final;' |
| Request 60 sql='ALTER TABLE llx_facture ADD COLUMN retained_warranty_date_limit date DEFAULT NULL after retained_warranty;' |
| Request 61 sql='ALTER TABLE llx_facture ADD COLUMN retained_warranty_fk_cond_reglement integer DEFAULT NULL after retained_warranty_date_limit;' |
| Request 62 sql='ALTER TABLE llx_facture ADD COLUMN date_closing datetime DEFAULT NULL after date_valid;' |
| Request 63 sql='ALTER TABLE llx_facture ADD COLUMN fk_user_closing integer DEFAULT NULL after fk_user_valid;' |
| Request 64 sql='ALTER TABLE llx_c_shipment_mode ADD COLUMN entity integer DEFAULT 1 NOT NULL;' |
| Request 65 sql='ALTER TABLE llx_c_shipment_mode DROP INDEX uk_c_shipment_mode;' |
| Request 66 sql='ALTER TABLE llx_c_shipment_mode ADD UNIQUE INDEX uk_c_shipment_mode (code, entity);' |
| Request 67 sql='ALTER TABLE llx_facture_fourn DROP COLUMN total;' |
| Request 68 sql='ALTER TABLE llx_user ADD COLUMN iplastlogin varchar(250);' |
| Request 69 sql='ALTER TABLE llx_user ADD COLUMN ippreviouslogin varchar(250);' |
| Request 70 sql='ALTER TABLE llx_events ADD COLUMN prefix_session varchar(255) NULL;' |
| Request 71 sql='create table llx_payment_salary_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 72 sql='ALTER TABLE llx_payment_salary_extrafields ADD INDEX idx_payment_salary_extrafields (fk_object);' |
| Request 73 sql='ALTER TABLE llx_c_price_expression MODIFY COLUMN expression varchar(255) NOT NULL;' |
| Request 74 sql='UPDATE llx_bank_url set url = REPLACE( url, 'compta/salaries/', 'salaries/');' |
| Request 75 sql='ALTER TABLE llx_stock_mouvement ADD COLUMN fk_projet INTEGER NOT NULL DEFAULT 0 AFTER model_pdf;' |
| Request 76 sql='ALTER TABLE llx_oauth_token ADD COLUMN fk_soc integer DEFAULT NULL after token;' |
| Request 77 sql='ALTER TABLE llx_adherent_type ADD COLUMN duration varchar(6) DEFAULT NULL after morphy;' |
| Request 78 sql='ALTER TABLE llx_mailing ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
| Request 79 sql='ALTER TABLE llx_mailing_cibles ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;' |
| Request 80 sql='ALTER TABLE llx_projet ADD COLUMN usage_opportunity integer DEFAULT 0;' |
| Request 81 sql='ALTER TABLE llx_projet ADD COLUMN usage_task integer DEFAULT 1;' |
| Request 82 sql='ALTER TABLE llx_projet CHANGE COLUMN bill_time usage_bill_time integer DEFAULT 0;' |
| Request 83 sql='ALTER TABLE llx_projet ADD COLUMN usage_organize_event integer DEFAULT 0;' |
| Request 84 sql='UPDATE llx_projet set usage_opportunity = 1 WHERE fk_opp_status > 0;' |
| Request 85 sql='create table llx_societe_contacts ( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, date_creation datetime NOT NULL, fk_soc integer NOT NULL, fk_c_type_contact int NOT NULL, fk_socpeople integer NOT NULL, tms TIMESTAMP, import_key VARCHAR(14) )ENGINE=innodb;' |
| Request 86 sql='ALTER TABLE llx_societe_contacts ADD UNIQUE INDEX idx_societe_contacts_idx1 (entity, fk_soc, fk_c_type_contact, fk_socpeople);' |
| Request 87 sql='ALTER TABLE llx_societe_contacts ADD CONSTRAINT fk_societe_contacts_fk_c_type_contact FOREIGN KEY (fk_c_type_contact) REFERENCES llx_c_type_contact(rowid);' |
| Request 88 sql='ALTER TABLE llx_societe_contacts ADD CONSTRAINT fk_societe_contacts_fk_soc FOREIGN KEY (fk_soc) REFERENCES llx_societe(rowid);' |
| Request 89 sql='ALTER TABLE llx_societe_contacts ADD CONSTRAINT fk_societe_contacts_fk_socpeople FOREIGN KEY (fk_socpeople) REFERENCES llx_socpeople(rowid);' |
| Request 90 sql='ALTER TABLE llx_accounting_account MODIFY COLUMN rowid bigint AUTO_INCREMENT;' |
| Request 91 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN date_start datetime DEFAULT NULL;' |
| Request 92 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN date_end datetime DEFAULT NULL;' |
| Request 93 sql='create table llx_c_hrm_public_holiday ( id integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 0 NOT NULL, fk_country integer, code varchar(62), dayrule varchar(64) DEFAULT '', day integer, month integer, year integer, active integer DEFAULT 1, import_key varchar(14) )ENGINE=innodb;' |
| Request 94 sql='ALTER TABLE llx_c_hrm_public_holiday ADD UNIQUE INDEX uk_c_hrm_public_holiday(entity, code);' |
| Request 95 sql='ALTER TABLE llx_c_hrm_public_holiday ADD UNIQUE INDEX uk_c_hrm_public_holiday2(entity, fk_country, dayrule, day, month, year);' |
| Request 96 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('NEWYEARDAY1', 0, 0, 0, 1, 1, 1);' |
| Request 97 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('LABORDAY1', 0, 0, 0, 5, 1, 1);' |
| Request 98 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('ASSOMPTIONDAY1', 0, 0, 0, 8, 15, 1);' |
| Request 99 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('CHRISTMASDAY1', 0, 0, 0, 12, 25, 1);' |
| Request 100 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-VICTORYDAY', 0, 1, '', 0, 5, 8, 1);' |
| Request 101 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-NATIONALDAY', 0, 1, '', 0, 7, 14, 1);' |
| Request 102 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-ASSOMPTION', 0, 1, '', 0, 8, 15, 1);' |
| Request 103 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-TOUSSAINT', 0, 1, '', 0, 11, 1, 1);' |
| Request 104 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-ARMISTICE', 0, 1, '', 0, 11, 11, 1);' |
| Request 105 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-EASTER', 0, 1, 'eastermonday', 0, 0, 0, 1);' |
| Request 106 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-ASCENSION', 0, 1, 'ascension', 0, 0, 0, 1);' |
| Request 107 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-PENTECOST', 0, 1, 'pentecost', 0, 0, 0, 1);' |
| Request 108 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-LIBEAZIONE', 0, 3, 0, 4, 25, 1);' |
| Request 109 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-EPIPHANY', 0, 3, 0, 6, 1, 1);' |
| Request 110 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-REPUBBLICA', 0, 3, 0, 6, 2, 1);' |
| Request 111 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-TUTTISANTIT', 0, 3, 0, 11, 1, 1);' |
| Request 112 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-IMMACULE', 0, 3, 0, 12, 8, 1);' |
| Request 113 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-SAINTSTEFAN', 0, 3, 0, 12, 26, 1);' |
| Request 114 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-EASTER', 0, 4, 'easter', 0, 0, 0, 1);' |
| Request 115 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-REYE', 0, 4, '', 0, 6, 1, 1);' |
| Request 116 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-HISPANIDAD', 0, 4, '', 0, 10, 12, 1);' |
| Request 117 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-TOUSSAINT', 0, 4, '', 0, 11, 1, 1);' |
| Request 118 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-CONSTITUIZION', 0, 4, '', 0, 12, 6, 1);' |
| Request 119 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-IMMACULE', 0, 4, '', 0, 12, 8, 1);' |
| Request 120 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-EASTER', 0, 41, 'eastermonday', 0, 0, 0, 1);' |
| Request 121 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-ASCENSION', 0, 41, 'ascension', 0, 0, 0, 1);' |
| Request 122 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-PENTECOST', 0, 41, 'pentecost', 0, 0, 0, 1);' |
| Request 123 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-FRONLEICHNAM', 0, 41, 'fronleichnam', 0, 0, 0, 1);' |
| Request 124 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-KONEGIE', 0, 41, '', 0, 6, 1, 1);' |
| Request 125 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-26OKT', 0, 41, '', 0, 10, 26, 1);' |
| Request 126 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-TOUSSAINT', 0, 41, '', 0, 11, 1, 1);' |
| Request 127 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-IMMACULE', 0, 41, '', 0, 12, 8, 1);' |
| Request 128 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-24DEC', 0, 41, '', 0, 12, 24, 1);' |
| Request 129 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-SAINTSTEFAN', 0, 41, '', 0, 12, 26, 1);' |
| Request 130 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-Silvester', 0, 41, '', 0, 12, 31, 1);' |
| Request 131 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('IN-REPUBLICDAY', 0, 117, '', 0, 1, 26, 1);' |
| Request 132 sql='INSERT INTO llx_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('IN-GANDI', 0, 117, '', 0, 10, 2, 1);' |
| Request 133 sql='create table llx_c_socialnetworks ( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, code varchar(100), label varchar(150), url text, icon varchar(20), active tinyint DEFAULT 1 NOT NULL )ENGINE=innodb;' |
| Request 134 sql='ALTER TABLE llx_c_socialnetworks ADD UNIQUE INDEX idx_c_socialnetworks_code (code);' |
| Request 135 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'facebook', 'Facebook', 'https://www.facebook.com/{socialid}', 'fa-facebook', 1);' |
| Request 136 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'skype', 'Skype', 'https://www.skype.com/{socialid}', 'fa-skype', 1);' |
| Request 137 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'twitter', 'Twitter', 'https://www.twitter.com/{socialid}', 'fa-twitter', 1);' |
| Request 138 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'linkedin', 'LinkedIn', 'https://www.linkedin.com/{socialid}', 'fa-linkedin', 1);' |
| Request 139 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'instagram', 'Instagram', 'https://www.instagram.com/{socialid}', 'fa-instagram', 1);' |
| Request 140 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'snapchat', 'Snapchat', '{socialid}', 'fa-snapchat', 1);' |
| Request 141 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'googleplus', 'GooglePlus', 'https://www.googleplus.com/{socialid}', 'fa-google-plus-g', 1);' |
| Request 142 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'youtube', 'Youtube', 'https://www.youtube.com/{socialid}', 'fa-youtube', 1);' |
| Request 143 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'whatsapp', 'Whatsapp', '{socialid}', 'fa-whatsapp', 1);' |
| Request 144 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'tumblr', 'Tumblr', 'https://www.tumblr.com/{socialid}', 'fa-tumblr', 0);' |
| Request 145 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'vero', 'Vero', 'https://vero.co/{socialid}', '', 0);' |
| Request 146 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'viadeo', 'Viadeo', 'https://fr.viadeo.com/fr/{socialid}', 'fa-viadeo', 0);' |
| Request 147 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'slack', 'Slack', '{socialid}', 'fa-slack', 0);' |
| Request 148 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'xing', 'Xing', '{socialid}', 'fa-xing', 0);' |
| Request 149 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'meetup', 'Meetup', '{socialid}', 'fa-meetup', 0);' |
| Request 150 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'pinterest', 'Pinterest', '{socialid}', 'fa-pinterest', 0);' |
| Request 151 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'flickr', 'Flickr', '{socialid}', 'fa-flickr', 0);' |
| Request 152 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, '500px', '500px', '{socialid}', 'fa-500px', 0);' |
| Request 153 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'giphy', 'Giphy', '{socialid}', '', 0);' |
| Request 154 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'gifycat', 'Gificat', '{socialid}', '', 0);' |
| Request 155 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'dailymotion', 'Dailymotion', '{socialid}', '', 0);' |
| Request 156 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'vimeo', 'Vimeo', '{socialid}', '', 0);' |
| Request 157 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'periscope', 'Periscope', '{socialid}', '', 0);' |
| Request 158 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'twitch', 'Twitch', '{socialid}', '', 0);' |
| Request 159 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'discord', 'Discord', '{socialid}', 'fa-discord', 0);' |
| Request 160 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'wikipedia', 'Wikipedia', '{socialid}', '', 0);' |
| Request 161 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'reddit', 'Reddit', '{socialid}', 'fa-reddit', 0);' |
| Request 162 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'quora', 'Quora', '{socialid}', '', 0);' |
| Request 163 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'tripadvisor', 'Tripadvisor', '{socialid}', '', 0);' |
| Request 164 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'mastodon', 'Mastodon', '{socialid}', '', 0);' |
| Request 165 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'diaspora', 'Diaspora', '{socialid}', '', 0);' |
| Request 166 sql='INSERT INTO llx_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'viber', 'Viber', '{socialid}', '', 0);' |
| Request 167 sql='ALTER TABLE llx_adherent ADD COLUMN socialnetworks text DEFAULT NULL AFTER email;' |
| Request 168 sql='ALTER TABLE llx_societe ADD COLUMN socialnetworks text DEFAULT NULL AFTER email;' |
| Request 169 sql='ALTER TABLE llx_socpeople ADD COLUMN socialnetworks text DEFAULT NULL AFTER email;' |
| Request 170 sql='ALTER TABLE llx_user ADD COLUMN socialnetworks text DEFAULT NULL AFTER personal_email;' |
| Request 171 sql='ALTER TABLE llx_product ADD COLUMN net_measure float;' |
| Request 172 sql='ALTER TABLE llx_product ADD COLUMN net_measure_units tinyint;' |
| Request 173 sql='create table llx_adherent_type_lang ( rowid integer AUTO_INCREMENT PRIMARY KEY, fk_type integer DEFAULT 0 NOT NULL, lang varchar(5) DEFAULT 0 NOT NULL, label varchar(255) NOT NULL, description text, email text, import_key varchar(14) DEFAULT NULL )ENGINE=innodb;' |
| Request 174 sql='create table llx_fichinter_rec ( rowid integer AUTO_INCREMENT PRIMARY KEY, titre varchar(50) NOT NULL, entity integer DEFAULT 1 NOT NULL, fk_soc integer DEFAULT NULL, datec datetime, fk_contrat integer DEFAULT 0, fk_user_author integer, fk_projet integer, duree real, description text, modelpdf varchar(50), note_private text, note_public text, frequency integer, unit_frequency varchar(2) DEFAULT 'm', date_when datetime DEFAULT NULL, date_last_gen datetime DEFAULT NULL, nb_gen_done integer DEFAULT NULL, nb_gen_max integer DEFAULT NULL, auto_validate integer NULL DEFAULT NULL )ENGINE=innodb;' |
| Request 175 sql='ALTER TABLE llx_fichinter_rec ADD UNIQUE INDEX idx_fichinter_rec_uk_titre (titre, entity);' |
| Request 176 sql='ALTER TABLE llx_fichinter_rec ADD INDEX idx_fichinter_rec_fk_soc (fk_soc);' |
| Request 177 sql='ALTER TABLE llx_fichinter_rec ADD INDEX idx_fichinter_rec_fk_user_author (fk_user_author);' |
| Request 178 sql='ALTER TABLE llx_fichinter_rec ADD INDEX idx_fichinter_rec_fk_projet (fk_projet);' |
| Request 179 sql='ALTER TABLE llx_fichinter_rec ADD CONSTRAINT fk_fichinter_rec_fk_user_author FOREIGN KEY (fk_user_author) REFERENCES llx_user (rowid);' |
| Request 180 sql='ALTER TABLE llx_fichinter_rec ADD CONSTRAINT fk_fichinter_rec_fk_projet FOREIGN KEY (fk_projet) REFERENCES llx_projet (rowid);' |
| Request 181 sql='create table llx_fichinterdet_rec ( rowid integer AUTO_INCREMENT PRIMARY KEY, fk_fichinter integer NOT NULL, date datetime, description text, duree integer, rang integer DEFAULT 0, total_ht DOUBLE(24, 8) NULL DEFAULT NULL, subprice DOUBLE(24, 8) NULL DEFAULT NULL, fk_parent_line integer NULL DEFAULT NULL, fk_product integer NULL DEFAULT NULL, label varchar(255) NULL DEFAULT NULL, tva_tx DOUBLE(6, 3) NULL DEFAULT NULL, localtax1_tx DOUBLE(6, 3) NULL DEFAULT 0, localtax1_type VARCHAR(1) NULL DEFAULT NULL, localtax2_tx DOUBLE(6, 3) NULL DEFAULT 0, localtax2_type VARCHAR(1) NULL DEFAULT NULL, qty double NULL DEFAULT NULL, remise_percent double NULL DEFAULT 0, remise double NULL DEFAULT 0, fk_remise_except integer NULL DEFAULT NULL, price DOUBLE(24, 8) NULL DEFAULT NULL, total_tva DOUBLE(24, 8) NULL DEFAULT NULL, total_localtax1 DOUBLE(24, 8) NULL DEFAULT 0, total_localtax2 DOUBLE(24, 8) NULL DEFAULT 0, total_ttc DOUBLE(24, 8) NULL DEFAULT NULL, product_type INTEGER NULL DEFAULT 0, date_start datetime NULL DEFAULT NULL, date_end datetime NULL DEFAULT NULL, info_bits INTEGER NULL DEFAULT 0, buy_price_ht DOUBLE(24, 8) NULL DEFAULT 0, fk_product_fournisseur_price integer NULL DEFAULT NULL, fk_code_ventilation integer NOT NULL DEFAULT 0, fk_export_commpta integer NOT NULL DEFAULT 0, special_code integer UNSIGNED NULL DEFAULT 0, fk_unit integer NULL DEFAULT NULL, import_key varchar(14) NULL DEFAULT NULL )ENGINE=innodb;' |
| Request 182 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN date_start datetime DEFAULT NULL AFTER product_type;' |
| Request 183 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN date_end datetime DEFAULT NULL AFTER date_start;' |
| Request 184 sql='create table llx_expedition_package ( rowid integer AUTO_INCREMENT PRIMARY KEY, fk_expedition integer NOT NULL, description varchar(255), value double(24,8) DEFAULT 0, fk_parcel_type integer, height float, width float, size float, size_units integer, weight float, weight_units integer, dangerous_goods smallint DEFAULT 0, tail_lift smallint DEFAULT 0, rang integer DEFAULT 0 )ENGINE=innodb;' |
| Request 185 sql='create table llx_c_shipment_package_type ( rowid integer AUTO_INCREMENT PRIMARY KEY, label varchar(50) NOT NULL, description varchar(255), active integer DEFAULT 1 NOT NULL, entity integer DEFAULT 1 NOT NULL )ENGINE=innodb;' |
| Request 186 sql='CREATE TABLE llx_product_fournisseur_price_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 187 sql='ALTER TABLE llx_product_fournisseur_price_extrafields ADD INDEX idx_product_fournisseur_price_extrafields (fk_object);' |
| Request 188 sql='CREATE TABLE llx_mrp_mo( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, ref varchar(128) DEFAULT '(PROV)' NOT NULL, entity integer DEFAULT 1 NOT NULL, label varchar(255), qty real NOT NULL, fk_warehouse integer, fk_soc integer, note_public text, note_private text, date_creation datetime NOT NULL, date_valid datetime NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_creat integer NOT NULL, fk_user_modif integer, fk_user_valid integer, model_pdf varchar(255), import_key varchar(14), status integer NOT NULL, fk_product integer NOT NULL, date_start_planned datetime, date_end_planned datetime, fk_bom integer, fk_project integer ) ENGINE=innodb;' |
| Request 189 sql='ALTER TABLE llx_mrp_mo ADD COLUMN date_valid datetime NULL;' |
| Request 190 sql='ALTER TABLE llx_mrp_mo ADD COLUMN fk_user_valid integer;' |
| Request 191 sql='ALTER TABLE llx_bom_bom ADD COLUMN model_pdf varchar(255);' |
| Request 192 sql='ALTER TABLE llx_mrp_mo ADD COLUMN model_pdf varchar(255);' |
| Request 193 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_ref (ref);' |
| Request 194 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_entity (entity);' |
| Request 195 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_fk_soc (fk_soc);' |
| Request 196 sql='ALTER TABLE llx_mrp_mo ADD CONSTRAINT fk_mrp_mo_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);' |
| Request 197 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_status (status);' |
| Request 198 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_fk_product (fk_product);' |
| Request 199 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_date_start_planned (date_start_planned);' |
| Request 200 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_date_end_planned (date_end_planned);' |
| Request 201 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_fk_bom (fk_bom);' |
| Request 202 sql='ALTER TABLE llx_mrp_mo ADD INDEX idx_mrp_mo_fk_project (fk_project);' |
| Request 203 sql='create table llx_mrp_mo_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 204 sql='ALTER TABLE llx_mrp_mo_extrafields ADD INDEX idx_fk_object(fk_object);' |
| Request 205 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BOM_VALIDATE','BOM validated','Executed when a BOM is validated','bom',650);' |
| Request 206 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BOM_UNVALIDATE','BOM unvalidated','Executed when a BOM is unvalidated','bom',651);' |
| Request 207 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BOM_CLOSE','BOM disabled','Executed when a BOM is disabled','bom',652);' |
| Request 208 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BOM_REOPEN','BOM reopen','Executed when a BOM is re-open','bom',653);' |
| Request 209 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BOM_DELETE','BOM deleted','Executed when a BOM deleted','bom',654);' |
| Request 210 sql='DELETE FROM llx_c_action_trigger where code LIKE 'MO_%';' |
| Request 211 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MRP_MO_VALIDATE','MO validated','Executed when a MO is validated','bom',660);' |
| Request 212 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MRP_MO_PRODUCED','MO produced','Executed when a MO is produced','bom',661);' |
| Request 213 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MRP_MO_DELETE','MO deleted','Executed when a MO is deleted','bom',662);' |
| Request 214 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('MRP_MO_CANCEL','MO canceled','Executed when a MO is canceled','bom',663);' |
| Request 215 sql='ALTER TABLE llx_comment ADD COLUMN fk_user_modif integer DEFAULT NULL;' |
| Request 216 sql='CREATE TABLE llx_mrp_production( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, fk_mo integer NOT NULL, position integer NOT NULL DEFAULT 0, fk_product integer NOT NULL, fk_warehouse integer, qty real NOT NULL DEFAULT 1, qty_frozen smallint DEFAULT 0, disable_stock_change smallint DEFAULT 0, batch varchar(30), role varchar(10), fk_mrp_production integer, fk_stock_movement integer, date_creation datetime NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_creat integer NOT NULL, fk_user_modif integer, import_key varchar(14) ) ENGINE=innodb;' |
| Request 217 sql='ALTER TABLE llx_mrp_production MODIFY COLUMN qty real NOT NULL DEFAULT 1;' |
| Request 218 sql='ALTER TABLE llx_mrp_production ADD COLUMN qty_frozen smallint DEFAULT 0;' |
| Request 219 sql='ALTER TABLE llx_mrp_production ADD COLUMN disable_stock_change smallint DEFAULT 0;' |
| Request 220 sql='ALTER TABLE llx_mrp_production ADD CONSTRAINT fk_mrp_production_mo FOREIGN KEY (fk_mo) REFERENCES llx_mrp_mo (rowid);' |
| Request 221 sql='ALTER TABLE llx_mrp_production ADD CONSTRAINT fk_mrp_production_product FOREIGN KEY (fk_product) REFERENCES llx_product (rowid);' |
| Request 222 sql='ALTER TABLE llx_mrp_production ADD CONSTRAINT fk_mrp_production_stock_movement FOREIGN KEY (fk_stock_movement) REFERENCES llx_stock_mouvement (rowid);' |
| Request 223 sql='ALTER TABLE llx_mrp_production ADD INDEX idx_mrp_production_fk_mo (fk_mo);' |
| Request 224 sql='ALTER TABLE llx_emailcollector_emailcollector ADD UNIQUE INDEX uk_emailcollector_emailcollector_ref(ref, entity);' |
| Request 225 sql='ALTER TABLE llx_website ADD COLUMN use_manifest integer;' |
| Request 226 sql='ALTER TABLE llx_facture_rec MODIFY COLUMN fk_cond_reglement integer NOT NULL DEFAULT 1;' |
| Request 227 sql='create table llx_commande_fournisseur_dispatch_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 228 sql='ALTER TABLE llx_commande_fournisseur_dispatch_extrafields ADD INDEX idx_commande_fournisseur_dispatch_extrafields (fk_object);' |
| Request 229 sql='create table llx_facturedet_rec_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 230 sql='ALTER TABLE llx_facturedet_rec_extrafields ADD INDEX idx_facturedet_rec_extrafields (fk_object);' |
| Script processing | OK - Show-Hide details |
|
|
