INSERT INTO systemsettings (type, value, description, active, created, createdById, updated, updatedById)
VALUES ('aus_post_type', 'MyPost Business', 'Type of Auspost: MyPost Business or Parcel Contractor', '1', UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10');


ALTER TABLE shippment
MODIFY COLUMN auspostShipmentId VARCHAR(255) DEFAULT '';


alter table `ecommerceinfo` add column `mypostToken` varchar(100) DEFAULT '' after `xeroPaymentSyncWay`;


CREATE TABLE `auspostproduct` (
    `id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
    `auspostProductId`  varchar(20) NOT NULL default "",
    `type` varchar(20) not null default "",
    `name` varchar(100) not null default "",
    `shippingMethod` varchar(20) not null default "",
    `length`  double(6,1) unsigned NOT NULL,
    `width`  double(6,1) unsigned NOT NULL,
    `height`  double(6,1) unsigned NOT NULL,
    `maxWeight`  double(10,4) unsigned NOT NULL,
    `active`  tinyint(1) NOT NULL DEFAULT 1 ,
    `created`  datetime NOT NULL DEFAULT '0001-01-01 00:00:00' ,
    `createdById`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
    `updated`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
    `updatedById`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
    PRIMARY KEY (`id`)
)
    ENGINE=InnoDB
    DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
    ROW_FORMAT=Dynamic
;


INSERT INTO auspostproduct
(auspostProductId, type, name, shippingMethod, length, width, height, maxWeight, active, created, createdById, updated, updatedById)
VALUES
('B30', 'Own', 'Own Box: Max 5kg', 'Standard', 0, 0, 0, 5, 1, UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('B31', 'Own', 'Own Box: Max 22kg', 'Standard', 0, 0, 0, 22, 1,  UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('B20', 'Own', 'Own Box: Max 5kg', 'Express', 0, 0, 0, 5, 1,  UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('B21', 'Own', 'Own Box: Max 22kg', 'Express', 0, 0, 0, 22, 1,  UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('BE9PB4', 'Box', 'Extra Large Box: 440x277x168mm, Max 5kg', 'Express', 44, 27.7, 16.8, 5, 1, UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('BE9PB3', 'Box', 'Large Box: 390x280x140mm, Max 5kg', 'Express', 39, 28, 14, 5, 1,  UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('BE9PB2', 'Box', 'Medium Box: 240x190x120mm, Max 5kg', 'Express', 24, 19, 12, 5, 1,  UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('BE9PB1', 'Box', 'Small Box: 220x160x70mm, Max 5kg', 'Express', 22, 16, 7, 5, 1,  UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('BE9P50', 'Satchel', 'Extra Large Satchel: 440x510mm, Max 5kg', 'Express', 44, 51, 0, 5, 1, UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('BE9P30', 'Satchel', 'Large Satchel: 315x405mm, Max 5kg', 'Express', 31.5, 40.5, 0, 5, 1, UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('BE9P10', 'Satchel', 'Medium Satchel: 270x390mm, Max 5kg', 'Express', 27, 39, 0, 5, 1, UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('BE9P05', 'Satchel', 'Small Satchel: 225x355mm, Max 5kg', 'Express', 22.5, 35.5, 0, 5, 1, UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('BE1PB4', 'Box', 'Extra Large Box: 440x277x168mm, Max 5kg', 'Standard', 44, 27.7, 16.8, 5, 1, UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('BE1PB3', 'Box', 'Large Box: 390x280x140mm, Max 5kg', 'Standard', 39, 28, 14, 5, 1, UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('BE1PB2', 'Box', 'Medium Box: 240x190x120mm, Max 5kg', 'Standard', 24, 19, 12, 5, 1, UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('BE1PB1', 'Box', 'Small Box: 220x160x70mm, Max 5kg', 'Standard', 22, 16, 7, 5, 1, UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('BE1P50', 'Satchel', 'Extra Large Satchel: 440x510mm, Max 5kg', 'Standard', 44, 51, 0, 5, 1, UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('BE1P30', 'Satchel', 'Large Satchel: 315x405mm, Max 5kg', 'Standard', 31.5, 40.5, 0, 5, 1, UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('BE1P10', 'Satchel', 'Medium Satchel: 270x390mm, Max 5kg', 'Standard', 27, 39, 0, 5, 1, UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('BE1P05', 'Satchel', 'Small Satchel: 225x355mm, Max 5kg', 'Standard', 22.5, 35.5, 0, 5, 1, UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('I65', 'International', 'Standard International Parcels Air. Max 20kg.', 'Standard', 140, 0, 0, 20, 0, UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('I67', 'International', 'Express International Parcels Air, Max 20kg.', 'Express', 140, 0, 0, 20, 0, UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10');
