[2015-12-28 10:50:54] [Upgrade started...

Updating query #1...
Query:

CREATE TABLE IF NOT EXISTS `fullstyler_categories` (
`category_id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) DEFAULT '0',
`status` tinyint(2) DEFAULT NULL,
`delete` tinyint(2) DEFAULT NULL,
PRIMARY KEY (`category_id`),
KEY `parent_id_status_delete` (`parent_id`,`status`,`delete`),
KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

CREATE TABLE `fullstyler_categories_metadata` (
`id` INT(11) NOT NULL,
`field_name` VARCHAR(35) NOT NULL,
`language_code` VARCHAR(3) NOT NULL,
`value` VARCHAR(1000) NULL DEFAULT NULL,
PRIMARY KEY (`id`, `field_name`, `language_code`),
INDEX `clipart_id_language_code` (`id`, `language_code`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB;

CREATE TABLE IF NOT EXISTS
`fullstyler_category_has_clipart`
(
`category_id` int(11) NOT NULL,
`clipart_id` int(11) NOT NULL,
PRIMARY KEY (`category_id`,`clipart_id`),
KEY `category_id` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `fullstyler_cliparts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`orig_file_name` varchar(250) DEFAULT '0',
`status` tinyint(2) DEFAULT '0',
`deleted` tinyint(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `fullstyler_cliparts_fields`
(
`field_id` int(11) NOT NULL AUTO_INCREMENT,
`field_name` varchar(35) DEFAULT NULL,
PRIMARY KEY (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `fullstyler_cliparts_metadata` (
`id` int(11) NOT NULL,
`field_name` varchar(35) NOT NULL,
`language_code` varchar(3) DEFAULT NULL,
`value` varchar(1000) DEFAULT NULL,
PRIMARY KEY (`id`,`field_name`),
KEY `clipart_id_language_code` (`id`,`language_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `fullstyler_cliparts_thumb_size_fields` (
`thumb_key` varchar(50) NOT NULL,
PRIMARY KEY (`thumb_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `fullstyler_cliparts_thumb_size_fields`
(`thumb_key`)
VALUES
('big'),
('medium'),
('small');

CREATE TABLE IF NOT EXISTS `fullstyler_clipart_colors` (
`clipart_id` int(11) NOT NULL,
`original_color` varchar(7) NOT NULL,
PRIMARY KEY (`clipart_id`,`original_color`),
KEY `clipart_id` (`clipart_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `fullstyler_handlers` (
`handler_key` varchar(35) NOT NULL,
`title` varchar(100) DEFAULT NULL,
`status` tinyint(2) DEFAULT NULL,
PRIMARY KEY (`handler_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `fullstyler_handlers`
(`handler_key`, `title`, `status`)
VALUES
('add_clipart', 'Add Clipart', 1);

CREATE TABLE IF NOT EXISTS `fullstyler_modules` (
`module_key` varchar(35) NOT NULL,
`namespace` varchar(150) DEFAULT NULL,
`title` varchar(100) DEFAULT NULL,
`status` tinyint(2) DEFAULT NULL,
PRIMARY KEY (`module_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `fullstyler_modules`
(`module_key`, `namespace`, `title`, `status`)
VALUES
('ClipartAdder', 'SwissStyle\\Module', 'Add Cliparts', 1);

CREATE TABLE IF NOT EXISTS `fullstyler_registered_handlers` (
`handler_key` varchar(35) NOT NULL,
`module_key` varchar(35) NOT NULL,
PRIMARY KEY (`handler_key`,`module_key`),
KEY `handler_key` (`handler_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `fullstyler_registered_handlers`
(`handler_key`, `module_key`)
VALUES
('add_clipart', 'ClipartAdder');

Status: Updated

***********************************************************

Updating query #2...
Query:

CREATE TABLE `fullstyler_storage` (
`storage_id` VARCHAR(100) NOT NULL,
`serialize_fields` TEXT NULL,
`timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`allow_cleaning` TINYINT(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`storage_id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB

Status: Updated

***********************************************************

Updating query #3...
Query:

CREATE TABLE `fullstyler_designs_has_storage` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`builder_id` VARCHAR(32) NOT NULL,
`product_id` INT(11) NULL DEFAULT NULL,
`view_id` INT(11) NOT NULL,
`storage_id` VARCHAR(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `storage_id` (`storage_id`),
INDEX `builder_id` (`builder_id`),
INDEX `product_id` (`product_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB

Status: Updated

***********************************************************

Updating query #4...
Query:

CREATE TABLE `fullstyler_order` (
`subject` VARCHAR(25) NOT NULL,
`unique_id` INT(11) NOT NULL,
`order_value` INT(11) NULL DEFAULT NULL,
PRIMARY KEY (`subject`, `unique_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB

Status: Updated

***********************************************************

Updating query #5...
Query:

CREATE TABLE `fullstyler_product_metadata` (
`id` INT(11) NOT NULL,
`field_name` VARCHAR(35) NOT NULL,
`language_code` VARCHAR(3) NULL DEFAULT NULL,
`value` VARCHAR(1000) NULL DEFAULT NULL,
PRIMARY KEY (`id`, `field_name`),
INDEX `clipart_id_language_code` (`id`, `language_code`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB

Status: Updated

***********************************************************

Updating query #6...
Query:

CREATE TABLE `fullstyler_booked_designs` (
`id` INT(11) NOT NULL,
`field_name` VARCHAR(35) NOT NULL,
`language_code` VARCHAR(3) NULL DEFAULT NULL,
`value` VARCHAR(1000) NULL DEFAULT NULL,
PRIMARY KEY (`id`, `field_name`),
INDEX `clipart_id_language_code` (`id`, `language_code`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB

Status: Updated

***********************************************************

Updating query #7...
Query:

CREATE TABLE `fullstyler_booked_orders` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`order_id` INT(11) NULL DEFAULT NULL,
`view_id` INT(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX `order_id` (`order_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB

Status: Updated

***********************************************************

Updating query #8...
Query:

ALTER TABLE `fullstyler_cliparts`
ADD COLUMN `view` TINYINT(2) NOT NULL DEFAULT '1' AFTER `deleted`;

Status: Updated

***********************************************************

Updating query #9...
Query:

CREATE TABLE `fullstyler_cliparts_of_usersimgs` (
`builder_id` VARCHAR(32) NOT NULL,
`clipart_id` INT(11) NOT NULL,
PRIMARY KEY (`builder_id`, `clipart_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB

Status: Updated

***********************************************************

Updating query #10...
Query:

CREATE TABLE `fullstyler_view_disabled_status` (
`view_id` INT(11) NOT NULL,
`disabled` TINYINT(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`view_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB

Status: Updated

***********************************************************

Updating query #11...
Query:

CREATE TABLE `fullstyler_user_has_builder_ids` (
`user_id` INT(11) NOT NULL,
`builder_id` VARCHAR(32) NOT NULL,
`timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`user_id`, `builder_id`),
INDEX `user_id` (`user_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB

Status: Updated

***********************************************************

Updating query #12...
Query:

ALTER TABLE
`fullstyler_categories_metadata`
CHANGE COLUMN
`value` `value` VARCHAR(1000) NULL DEFAULT NULL COLLATE 'utf8_general_ci'
AFTER
`language_code`;

Status: Updated

***********************************************************

Updating query #13...
Query:

CREATE TABLE `fullstyler_pp_config_metadata` (
`id` varchar(50) NOT NULL,
`field_name` VARCHAR(35) NOT NULL,
`language_code` VARCHAR(3) NULL DEFAULT NULL,
`value` VARCHAR(1000) NULL DEFAULT NULL,
PRIMARY KEY (`id`, `field_name`),
INDEX `clipart_id_language_code` (`id`, `language_code`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB

Status: Updated

***********************************************************

_Review____________________________________________________
Upgrade status: Updated to 13 version
Updated: 13
Errors: 0
___________________________________________________________

]
