#change field entry_company from 64 to 128
ALTER TABLE address_book CHANGE `entry_company` `entry_company` VARCHAR(128) NULL;
#change field entry_firstname from 32 to 64
ALTER TABLE address_book CHANGE `entry_firstname` `entry_firstname` VARCHAR(64) NOT NULL;
#change field entry_lastname from 32 to 64
ALTER TABLE address_book CHANGE `entry_lastname` `entry_lastname` VARCHAR(64) NOT NULL;
#change field entry_suburb from 32 to 64
ALTER TABLE address_book CHANGE `entry_suburb` `entry_suburb` VARCHAR(64) NULL;
#change field entry_city from 32 to 64
ALTER TABLE address_book CHANGE `entry_city` `entry_city` VARCHAR(64) NOT NULL;
#change field customers_company from 64 to 128
ALTER TABLE orders CHANGE `customers_company` `customers_company` VARCHAR(128) NULL;
#change field customers_suburb from 32 to 64
ALTER TABLE orders CHANGE `customers_suburb` `customers_suburb` VARCHAR(64) NULL;
#change field customers_city from 32 to 64
ALTER TABLE orders CHANGE `customers_city` `customers_city` VARCHAR(64) NOT NULL;
#change field delivery_company from 64 to 128
ALTER TABLE orders CHANGE `delivery_company` `delivery_company` VARCHAR(128) NULL;
#change field delivery_suburb from 32 to 64
ALTER TABLE orders CHANGE `delivery_suburb` `delivery_suburb` VARCHAR(64) NULL;
#change field delivery_city from 32 to 64
ALTER TABLE orders CHANGE `delivery_city` `delivery_city` VARCHAR(64) NOT NULL;
#change field billing_company from 64 to 128
ALTER TABLE orders CHANGE `billing_company` `billing_company` VARCHAR(128) NULL;
#change field billing_suburb from 32 to 64
ALTER TABLE orders CHANGE `billing_suburb` `billing_suburb` VARCHAR(64) NULL;
#change field billing_city from 32 to 64
ALTER TABLE orders CHANGE `billing_city` `billing_city` VARCHAR(64) NOT NULL;
#change field customers_company from 64 to 128
ALTER TABLE reclamations CHANGE `customers_company` `customers_company` VARCHAR(128) NULL;
#change field customers_suburb from 32 to 64
ALTER TABLE reclamations CHANGE `customers_suburb` `customers_suburb` VARCHAR(64) NULL;
#change field customers_city from 32 to 64
ALTER TABLE reclamations CHANGE `customers_city` `customers_city` VARCHAR(64) NOT NULL;
#change field delivery_company from 64 to 128
ALTER TABLE reclamations CHANGE `delivery_company` `delivery_company` VARCHAR(128) NULL;
#change field delivery_suburb from 32 to 64
ALTER TABLE reclamations CHANGE `delivery_suburb` `delivery_suburb` VARCHAR(64) NULL;
#change field delivery_city from 32 to 64
ALTER TABLE reclamations CHANGE `delivery_city` `delivery_city` VARCHAR(64) NOT NULL;
#change field billing_company from 64 to 128
ALTER TABLE reclamations CHANGE `billing_company` `billing_company` VARCHAR(128) NULL;
#change field billing_suburb from 32 to 64
ALTER TABLE reclamations CHANGE `billing_suburb` `billing_suburb` VARCHAR(64) NULL;
#change field billing_city from 32 to 64
ALTER TABLE reclamations CHANGE `billing_city` `billing_city` VARCHAR(64) NOT NULL;
#change field company from 64 to 128
ALTER TABLE shippings CHANGE `company` `company` VARCHAR(128) NULL;
#change field customers_firstname from 32 to 64
ALTER TABLE customers CHANGE `customers_firstname` `customers_firstname` VARCHAR(64) NOT NULL;
#change field customers_lastname from 32 to 64
ALTER TABLE customers CHANGE `customers_lastname` `customers_lastname` VARCHAR(64) NOT NULL;
#change field customers_firstname from 32 to 64
ALTER TABLE newsletter_recipients CHANGE `customers_firstname` `customers_firstname` VARCHAR(64) NOT NULL;
#change field customers_lastname from 32 to 64
ALTER TABLE newsletter_recipients CHANGE `customers_lastname` `customers_lastname` VARCHAR(64) NOT NULL;
#change field categories_name from 32 to 64
ALTER TABLE categories_description CHANGE `categories_name` `categories_name` VARCHAR(64) NULL;
-------------------------------------