use [% osc %];
SET FOREIGN_KEY_CHECKS = 0;

#
# DDL START
#
CREATE TABLE administrators (
    id int(11) NOT NULL COMMENT '' auto_increment,
    user_name varchar(32) NOT NULL COMMENT '' COLLATE latin1_bin,
    user_password varchar(40) NOT NULL COMMENT '' COLLATE latin1_swedish_ci,
    PRIMARY KEY (id)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

INSERT INTO `administrators` VALUES (1,'[% username %]','[% password_md5_salt %]');

ALTER TABLE banners
    ADD INDEX idx_banners_group (banners_group);


ALTER TABLE banners_history
    ADD INDEX idx_banners_history_banners_id (banners_id);


ALTER TABLE configuration
    MODIFY configuration_title varchar(255) NOT NULL COMMENT '' COLLATE latin1_swedish_ci,
    MODIFY configuration_key varchar(255) NOT NULL COMMENT '' COLLATE latin1_swedish_ci;
#
#  Fieldformats of
#    configuration.configuration_title changed from varchar(64) NOT NULL COMMENT '' COLLATE latin1_swedish_ci to varchar(255) NOT NULL COMMENT '' COLLATE latin1_swedish_ci.
#    configuration.configuration_key changed from varchar(64) NOT NULL COMMENT '' COLLATE latin1_swedish_ci to varchar(255) NOT NULL COMMENT '' COLLATE latin1_swedish_ci.
#  Possibly data modifications needed!
#

ALTER TABLE currencies
    ADD INDEX idx_currencies_code (code);


ALTER TABLE customers
    ADD INDEX idx_customers_email_address (customers_email_address);


ALTER TABLE customers_basket
    ADD INDEX idx_customers_basket_customers_id (customers_id);


ALTER TABLE customers_basket_attributes
    ADD INDEX idx_customers_basket_att_customers_id (customers_id);


ALTER TABLE orders
    MODIFY payment_method varchar(255) NOT NULL COMMENT '' COLLATE latin1_swedish_ci,
    ADD INDEX idx_orders_customers_id (customers_id);
#
#  Fieldformat of
#    orders.payment_method changed from varchar(32) NOT NULL COMMENT '' COLLATE latin1_swedish_ci to varchar(255) NOT NULL COMMENT '' COLLATE latin1_swedish_ci.
#  Possibly data modifications needed!
#

ALTER TABLE orders_products
    ADD INDEX idx_orders_products_orders_id (orders_id),
    ADD INDEX idx_orders_products_products_id (products_id);


ALTER TABLE orders_products_attributes
    ADD INDEX idx_orders_products_att_orders_id (orders_id);


ALTER TABLE orders_products_download
    ADD INDEX idx_orders_products_download_orders_id (orders_id);


ALTER TABLE orders_status
    ADD public_flag int(11) NULL DEFAULT '1' COMMENT '' AFTER orders_status_name,
    ADD downloads_flag int(11) NULL DEFAULT '0' COMMENT '' AFTER public_flag;


ALTER TABLE orders_status_history
    ADD INDEX idx_orders_status_history_orders_id (orders_id);


ALTER TABLE products
    ADD INDEX idx_products_model (products_model);


ALTER TABLE products_attributes
    ADD INDEX idx_products_attributes_products_id (products_id);


ALTER TABLE reviews
    ADD INDEX idx_reviews_products_id (products_id),
    ADD INDEX idx_reviews_customers_id (customers_id);


ALTER TABLE specials
    ADD INDEX idx_specials_products_id (products_id);


ALTER TABLE whos_online
    MODIFY last_page_url text NOT NULL COMMENT '' COLLATE latin1_swedish_ci;
#
#  Fieldformat of
#    whos_online.last_page_url changed from varchar(255) NOT NULL COMMENT '' COLLATE latin1_swedish_ci to text NOT NULL COMMENT '' COLLATE latin1_swedish_ci.
#  Possibly data modifications needed!
#

ALTER TABLE zones
    ADD INDEX idx_zones_country_id (zone_country_id);


ALTER TABLE zones_to_geo_zones
    ADD INDEX idx_zones_to_geo_zones_country_id (zone_country_id);


#
# DDL END
#

SET FOREIGN_KEY_CHECKS = 1;
