This script generated 4 warnings - Scroll to the first warning

courseshop


(mysql): SHOW TABLES  

(mysql): SHOW TABLES  

(mysql): SHOW TABLES  

(mysql): SHOW TABLES  

(mysql): SHOW TABLES  

(mysql): SHOW TABLES  

(mysql): SHOW TABLES  

(mysql): SHOW TABLES  

(mysql): SHOW TABLES  

(mysql): SHOW TABLES  

(mysql): SHOW TABLES  

(mysql): SHOW TABLES  

(mysql): SHOW TABLES  

(mysql): CREATE TABLE mdl_courseshop_catalog ( id BIGINT(11) unsigned NOT NULL auto_increment, name VARCHAR(255) NOT NULL DEFAULT '', description TEXT NOT NULL, salesconditions TEXT NOT NULL, groupid SMALLINT(4) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )  
Succès

(mysql): ALTER TABLE mdl_courseshop_catalog COMMENT='courseshop_catalog table retrofitted from MySQL'  
Succès

(mysql): CREATE UNIQUE INDEX mdl_courcata_nam_uix ON mdl_courseshop_catalog (name)  
Succès

(mysql): CREATE TABLE mdl_courseshop_catalogitem ( id BIGINT(11) unsigned NOT NULL auto_increment, catalogid SMALLINT(4) unsigned NOT NULL DEFAULT 0, code VARCHAR(20) NOT NULL DEFAULT '', shortname VARCHAR(30) NOT NULL DEFAULT '', name VARCHAR(255) NOT NULL DEFAULT '', description TEXT NOT NULL, price1 NUMERIC(10,3) unsigned NOT NULL DEFAULT 0.00, price2 NUMERIC(10,3) unsigned NOT NULL DEFAULT 0.00, price3 NUMERIC(10,3) unsigned NOT NULL DEFAULT 0.00, taxcode VARCHAR(8) DEFAULT NULL, stock BIGINT(10) unsigned NOT NULL DEFAULT 0, sold BIGINT(10) unsigned NOT NULL DEFAULT 0, categoryid MEDIUMINT(6) unsigned DEFAULT 0, status enum('WORKING', 'PREVIEW', 'AVAILABLE', 'AVAILABLEINTERNAL', 'SUSPENDED', 'PROVIDING', 'ABANDONNED') NOT NULL DEFAULT 'AVAILABLE', leafleturl VARCHAR(255) DEFAULT NULL, image VARCHAR(255) DEFAULT NULL, thumb VARCHAR(255) DEFAULT NULL, notes TEXT, isset enum('0', '1', 'B') NOT NULL DEFAULT '0', setid MEDIUMINT(6) unsigned DEFAULT NULL, showsdescriptioninset TINYINT(1) unsigned NOT NULL DEFAULT 0, showsnameinset TINYINT(1) unsigned NOT NULL DEFAULT 0, isoptioninbundle TINYINT(1) unsigned NOT NULL DEFAULT 0, bundleshowscontent enum('0', '1', 'DEFAULT') NOT NULL DEFAULT 'DEFAULT', productiondata TEXT, maxdeliveryquant BIGINT(10) unsigned NOT NULL DEFAULT 0, onlyforloggedin TINYINT(2) NOT NULL DEFAULT 0, requireddata TEXT, enablehandler VARCHAR(30) DEFAULT NULL, handlerparams VARCHAR(80) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )  
Succès

(mysql): ALTER TABLE mdl_courseshop_catalogitem COMMENT='coursehop_catalogitem table retrofitted from MySQL'  
Succès

(mysql): CREATE INDEX mdl_courcata_cat_ix ON mdl_courseshop_catalogitem (categoryid)  
Succès

(mysql): CREATE INDEX mdl_courcata_cat2_ix ON mdl_courseshop_catalogitem (catalogid)  
Succès

(mysql): CREATE UNIQUE INDEX mdl_courcata_catcod_uix ON mdl_courseshop_catalogitem (catalogid, code)  
Succès

(mysql): CREATE TABLE mdl_courseshop_catalogcategory ( id BIGINT(11) unsigned NOT NULL auto_increment, catalogid SMALLINT(4) unsigned NOT NULL DEFAULT 0, parentid BIGINT(11) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', description TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )  
Succès

(mysql): ALTER TABLE mdl_courseshop_catalogcategory COMMENT='courseshop_catalogcategory table retrofitted from MySQL'  
Succès

(mysql): CREATE INDEX mdl_courcata_catpar_ix ON mdl_courseshop_catalogcategory (catalogid, parentid)  
Succès

(mysql): CREATE INDEX mdl_courcata_par_ix ON mdl_courseshop_catalogcategory (parentid)  
Succès

(mysql): CREATE TABLE mdl_courseshop_catalogshipping ( id BIGINT(11) unsigned NOT NULL auto_increment, productcode VARCHAR(32) NOT NULL DEFAULT '', zoneid SMALLINT(4) unsigned NOT NULL DEFAULT 0, value NUMERIC(10,3) unsigned NOT NULL DEFAULT 0.00, formula VARCHAR(64) DEFAULT NULL, a NUMERIC(10,3) unsigned NOT NULL DEFAULT 0.00, b NUMERIC(10,3) unsigned NOT NULL DEFAULT 0.00, c NUMERIC(10,3) unsigned NOT NULL DEFAULT 0.00, CONSTRAINT PRIMARY KEY (id) )  
Succès

(mysql): ALTER TABLE mdl_courseshop_catalogshipping COMMENT='courseshop_catalogshipping table retrofitted from MySQL'  
Succès

(mysql): CREATE UNIQUE INDEX mdl_courcata_prozon_uix ON mdl_courseshop_catalogshipping (productcode, zoneid)  
Succès

(mysql): CREATE TABLE mdl_courseshop_catalogshipzone ( id BIGINT(11) unsigned NOT NULL auto_increment, catalogid SMALLINT(4) unsigned NOT NULL DEFAULT 0, zonecode VARCHAR(4) NOT NULL DEFAULT '', description VARCHAR(255) NOT NULL DEFAULT '', billscopeamount NUMERIC(10,3) unsigned NOT NULL DEFAULT 0.00, taxid BIGINT(10) unsigned NOT NULL DEFAULT 0, applicability TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )  
Succès

(mysql): ALTER TABLE mdl_courseshop_catalogshipzone COMMENT='courseshop_catalogshipzone table retrofitted from MySQL'  
Succès

(mysql): CREATE UNIQUE INDEX mdl_courcata_catzon_uix ON mdl_courseshop_catalogshipzone (catalogid, zonecode)  
Succès

(mysql): CREATE TABLE mdl_courseshop_customer ( id BIGINT(10) unsigned NOT NULL auto_increment, firstname VARCHAR(40) NOT NULL DEFAULT '', lastname VARCHAR(40) NOT NULL DEFAULT '', address1 VARCHAR(255) NOT NULL DEFAULT '', address2 VARCHAR(255) DEFAULT NULL, zip VARCHAR(6) NOT NULL DEFAULT '', email VARCHAR(80) NOT NULL DEFAULT '', city VARCHAR(40) NOT NULL DEFAULT '', country VARCHAR(2) NOT NULL DEFAULT '', organisation VARCHAR(64) NOT NULL DEFAULT '', hasaccount BIGINT(11) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(11) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
Succès

(mysql): ALTER TABLE mdl_courseshop_customer COMMENT='courseshop_customer table retrofitted from MySQL'  
Succès

(mysql): CREATE TABLE mdl_courseshop_bill ( id BIGINT(11) unsigned NOT NULL auto_increment, idnumber VARCHAR(255) DEFAULT NULL, ordering BIGINT(11) unsigned DEFAULT NULL, userid VARCHAR(50) NOT NULL DEFAULT '', title VARCHAR(255) DEFAULT NULL, worktype enum('PROD', 'PACK', 'OTHER') NOT NULL DEFAULT 'PACK', status enum('PENDING', 'PAYBACK', 'PARTIAL', 'SOLDOUT', 'DELAYED', 'RECOVERING', 'CANCELLED', 'WORKING', 'COMPLETE', 'FAILED') NOT NULL DEFAULT 'PENDING', emissiondate BIGINT(11) unsigned DEFAULT NULL, lastactiondate BIGINT(11) unsigned DEFAULT NULL, assignedto VARCHAR(16) DEFAULT NULL, timetodo DOUBLE unsigned NOT NULL DEFAULT 0, untaxedamount NUMERIC(10,3) unsigned NOT NULL DEFAULT 0.00, taxes NUMERIC(10,3) unsigned NOT NULL DEFAULT 0.00, amount NUMERIC(10,3) unsigned NOT NULL DEFAULT 0.00, currency enum('DOLLARS', 'CANADIAN DOLLARS', 'EUROS', 'POUNDS', 'YENS') NOT NULL DEFAULT 'EUR', convertedamount NUMERIC(10,3) unsigned NOT NULL DEFAULT 0.00, transactionid VARCHAR(40) DEFAULT NULL, onlinetransactionid VARCHAR(128) DEFAULT NULL, expectedpaiement TEXT, paiedamount NUMERIC(10,3) unsigned NOT NULL DEFAULT 0.00, paymode VARCHAR(16) NOT NULL DEFAULT 'CHK', ignoretax TINYINT(1) unsigned NOT NULL DEFAULT 0, productiondata MEDIUMTEXT, paymentfee NUMERIC(10,3) unsigned NOT NULL DEFAULT 0.00, CONSTRAINT PRIMARY KEY (id) )  
1067: Invalid default value for 'currency'
            ADOConnection._Execute(CREATE TABLE mdl_courseshop_bill (
    id BIGINT(11) unsigned NOT NULL auto_increment,
    idnumber VARCHAR(255) DEFAULT NULL,
 ..., false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE mdl_courseshop_bill (
    id BIGINT(11) unsigned NOT NULL auto_increment,
    idnumber VARCHAR(255) DEFAULT NULL,
 ...) % line   89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_courseshop_bill (
    id BIGINT(11) unsigned NOT NULL auto_increment,
    idnumber VARCHAR(255) DEFAULT NULL,
 ..., true) % line 2364, file: dmllib.php
   execute_sql_arr(Array[57]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/httpd/vhosts/cefr.net/httpdocs/inscription/blocks/courseshop/db/install.xml) % line 1399, file: blocklib.php

(mysql): ALTER TABLE mdl_courseshop_bill COMMENT='courseshop_bill table retrofitted from MySQL'  
1146: Table 'db_inscription.mdl_courseshop_bill' doesn't exist
            ADOConnection._Execute(ALTER TABLE mdl_courseshop_bill COMMENT='courseshop_bill table retrofitted from MySQL', false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(ALTER TABLE mdl_courseshop_bill COMMENT='courseshop_bill table retrofitted from MySQL') % line   89, file: dmllib.php
      execute_sql(ALTER TABLE mdl_courseshop_bill COMMENT='courseshop_bill table retrofitted from MySQL', true) % line 2364, file: dmllib.php
   execute_sql_arr(Array[57]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/httpd/vhosts/cefr.net/httpdocs/inscription/blocks/courseshop/db/install.xml) % line 1399, file: blocklib.php

(mysql): CREATE UNIQUE INDEX mdl_courbill_tra_uix ON mdl_courseshop_bill (transactionid)  
1146: Table 'db_inscription.mdl_courseshop_bill' doesn't exist
            ADOConnection._Execute(CREATE UNIQUE INDEX mdl_courbill_tra_uix ON mdl_courseshop_bill (transactionid), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE UNIQUE INDEX mdl_courbill_tra_uix ON mdl_courseshop_bill (transactionid)) % line   89, file: dmllib.php
      execute_sql(CREATE UNIQUE INDEX mdl_courbill_tra_uix ON mdl_courseshop_bill (transactionid), true) % line 2364, file: dmllib.php
   execute_sql_arr(Array[57]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/httpd/vhosts/cefr.net/httpdocs/inscription/blocks/courseshop/db/install.xml) % line 1399, file: blocklib.php

(mysql): CREATE UNIQUE INDEX mdl_courbill_ord_uix ON mdl_courseshop_bill (ordering)  
1146: Table 'db_inscription.mdl_courseshop_bill' doesn't exist
            ADOConnection._Execute(CREATE UNIQUE INDEX mdl_courbill_ord_uix ON mdl_courseshop_bill (ordering), false) % line  891, file: adodb.inc.php
         ADOConnection.Execute(CREATE UNIQUE INDEX mdl_courbill_ord_uix ON mdl_courseshop_bill (ordering)) % line   89, file: dmllib.php
      execute_sql(CREATE UNIQUE INDEX mdl_courbill_ord_uix ON mdl_courseshop_bill (ordering), true) % line 2364, file: dmllib.php
   execute_sql_arr(Array[57]) % line  635, file: ddllib.php
install_from_xmldb_file(/home/httpd/vhosts/cefr.net/httpdocs/inscription/blocks/courseshop/db/install.xml) % line 1399, file: blocklib.php

(mysql): CREATE TABLE mdl_courseshop_billitem ( id BIGINT(11) unsigned NOT NULL auto_increment, billid BIGINT(11) unsigned NOT NULL DEFAULT 0, ordering BIGINT(11) unsigned NOT NULL DEFAULT 0, type enum('BILLING', 'COMMENT') NOT NULL DEFAULT 'BILLING', itemcode VARCHAR(15) DEFAULT NULL, abstract VARCHAR(80) NOT NULL DEFAULT '', description TEXT NOT NULL, delay DOUBLE unsigned DEFAULT NULL, unitcost NUMERIC(10,3) NOT NULL DEFAULT 0.00, quantity DOUBLE unsigned NOT NULL DEFAULT 1, totalprice NUMERIC(10,2) DEFAULT 0.00, taxcode VARCHAR(8) DEFAULT NULL, bundleid MEDIUMINT(6) unsigned DEFAULT NULL, customerdata TEXT, CONSTRAINT PRIMARY KEY (id) )  
Succès

(mysql): ALTER TABLE mdl_courseshop_billitem COMMENT='courseshop_billitem table retrofitted from MySQL'  
Succès

(mysql): CREATE INDEX mdl_courbill_bilord_ix ON mdl_courseshop_billitem (billid, ordering)  
Succès

(mysql): CREATE INDEX mdl_courbill_bil_ix ON mdl_courseshop_billitem (billid)  
Succès

(mysql): CREATE TABLE mdl_courseshop_tax ( id BIGINT(10) unsigned NOT NULL auto_increment, country VARCHAR(2) NOT NULL DEFAULT '', title VARCHAR(128) NOT NULL DEFAULT '', ratio DOUBLE unsigned NOT NULL, formula VARCHAR(255) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )  
Succès

(mysql): ALTER TABLE mdl_courseshop_tax COMMENT='courseshop_customer table retrofitted from MySQL'  
Succès

(mysql): CREATE TABLE mdl_flowcontrol ( id BIGINT(11) unsigned NOT NULL auto_increment, element VARCHAR(16) NOT NULL DEFAULT '', `from` VARCHAR(16) NOT NULL DEFAULT '', `to` VARCHAR(16) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )  
Succès

(mysql): ALTER TABLE mdl_flowcontrol COMMENT='flowcontrol table retrofitted from MySQL'  
Succès

(mysql): CREATE UNIQUE INDEX mdl_flow_elefroto_uix ON mdl_flowcontrol (element, `from`, `to`)  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('order', 'WORKING', 'RECEIVED')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('order', 'RECEIVED', 'EXAMINED')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('order', 'EXAMINED', 'QUANTIFIED')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('order', 'RECEIVED', 'QUANTIFIED')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('order', 'QUANTIFIED', 'ANSWERED')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('order', 'ANSWERED', 'EXECUTING')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('order', 'EXECUTING', 'CANCELLED')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('order', 'ANSWERED', 'CANCELLED')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('order', 'ANSWERED', 'WORKING')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('order', 'RECEIVED', 'CANCELLED')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('bill', 'DELAYED', 'PENDING')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('bill', 'DELAYED', 'SOLDOUT')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('bill', 'SOLDOUT', 'PAYBACK')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('bill', 'PENDING', 'PARTIAL')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('bill', 'PARTIAL', 'SOLDOUT')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('bill', 'PARTIAL', 'PAYBACK')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('bill', 'PAYBACK', 'CANCELLED')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('bill', 'PENDING', 'CANCELLED')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('bill', 'WORKING', 'DELAYED')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('bill', 'WORKING', 'PENDING')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('bill', 'WORKING', 'PARTIAL')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('bill', 'WORKING', 'CANCELLED')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('bill', 'PENDING', 'SOLDOUT')  
Succès

(mysql): INSERT INTO mdl_flowcontrol(element, `from`, `to`) VALUES ('bill', 'SOLDOUT', 'COMPLETE')  
Succès

Block courseshop tables could NOT be set up successfully!