Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- TABLE AND FIELD definitions should be updated
- There seems TO be a NUMBER OF differencies BETWEEN the DATABASE AND the selected SQL-file.
- Please SELECT which statements you want TO EXECUTE IN ORDER TO UPDATE your DATABASE:
- Changing FIELDS
- ALTER TABLE static_taxes CHANGE tx_country_iso_2 tx_country_iso_2 CHAR(2) DEFAULT '';
- CURRENT VALUE: CHAR(3) DEFAULT ''
- Remove unused FIELDS (RENAME WITH prefix)
- SELECT/deselect ALL
- ALTER TABLE fe_users CHANGE address_ext zzz_deleted_address_ext VARCHAR(10) NOT NULL DEFAULT '';
- (EXT) ALTER TABLE fe_users CHANGE tx_multishop_source_id zzz_deleted_tx_multishop_source_id VARCHAR(50) NOT NULL DEFAULT '';
- (EXT) ALTER TABLE fe_users CHANGE page_uid zzz_deleted_page_uid INT(11) NOT NULL DEFAULT '0';
- (EXT) ALTER TABLE tx_multishop_cms CHANGE hash zzz_deleted_hash VARCHAR(50) NOT NULL DEFAULT '';
- (EXT) ALTER TABLE tx_multishop_invoices CHANGE store_currency zzz_deleted_store_currency CHAR(3) NOT NULL DEFAULT '';
- (EXT) ALTER TABLE tx_multishop_invoices CHANGE customer_currency zzz_deleted_customer_currency CHAR(3) NOT NULL DEFAULT '';
- (EXT) ALTER TABLE tx_multishop_invoices CHANGE currency_rate zzz_deleted_currency_rate VARCHAR(15) NOT NULL DEFAULT '1';
- (EXT) ALTER TABLE tx_multishop_orders CHANGE store_currency zzz_deleted_store_currency CHAR(3) NOT NULL DEFAULT '';
- (EXT) ALTER TABLE tx_multishop_orders CHANGE customer_currency zzz_deleted_customer_currency CHAR(3) NOT NULL DEFAULT '';
- (EXT) ALTER TABLE tx_multishop_orders CHANGE currency_rate zzz_deleted_currency_rate VARCHAR(15) NOT NULL DEFAULT '1';
- (EXT) ALTER TABLE tx_multishop_orders CHANGE track_and_trace_code zzz_deleted_track_and_trace_code VARCHAR(50) NOT NULL DEFAULT '';
- (EXT) ALTER TABLE tx_multishop_orders CHANGE expected_delivery_date zzz_deleted_expected_delivery_date INT(11) NOT NULL DEFAULT '0';
- (EXT) ALTER TABLE tx_multishop_orders CHANGE billing_address_ext zzz_deleted_billing_address_ext VARCHAR(10) NOT NULL DEFAULT '';
- (EXT) ALTER TABLE tx_multishop_orders CHANGE delivery_address_ext zzz_deleted_delivery_address_ext VARCHAR(10) NOT NULL DEFAULT '';
- (EXT) ALTER TABLE tx_multishop_orders CHANGE cruser_id zzz_deleted_cruser_id INT(11) NOT NULL DEFAULT '0';
- (EXT) ALTER TABLE tx_multishop_orders CHANGE is_proposal zzz_deleted_is_proposal tinyint(1) NOT NULL DEFAULT '0';
- (EXT) ALTER TABLE tx_multishop_orders_products CHANGE file_remote_location zzz_deleted_file_remote_location text NOT NULL;
- (EXT) ALTER TABLE tx_multishop_orders_products CHANGE file_number_of_downloads zzz_deleted_file_number_of_downloads INT(11) NOT NULL DEFAULT '0';
- (EXT) ALTER TABLE tx_multishop_orders_products CHANGE qty_delivered zzz_deleted_qty_delivered INT(4) NOT NULL DEFAULT '0';
- (EXT) ALTER TABLE tx_multishop_orders_products CHANGE qty_not_deliverable zzz_deleted_qty_not_deliverable INT(4) NOT NULL DEFAULT '0';
- (EXT) ALTER TABLE tx_multishop_products CHANGE file_number_of_downloads zzz_deleted_file_number_of_downloads INT(11) NOT NULL DEFAULT '0';
- (EXT) ALTER TABLE tx_multishop_products_description CHANGE file_remote_location zzz_deleted_file_remote_location text NOT NULL;
- (EXT) ALTER TABLE tx_multishop_products_options CHANGE required zzz_deleted_required tinyint(1) NOT NULL DEFAULT '0';
- DROP FIELDS (really!)
- SELECT/deselect ALL
- ALTER TABLE fe_users DROP KEY tx_multishop_source_id;
- ALTER TABLE fe_users DROP KEY page_uid;
- ALTER TABLE tx_multishop_cms DROP KEY hash;
- ALTER TABLE tx_multishop_orders DROP KEY expected_delivery_date;
- ALTER TABLE tx_multishop_orders DROP KEY is_proposal;
- ALTER TABLE tx_multishop_products_description DROP KEY combined_four;
- Removing TABLES (RENAME WITH prefix)
- SELECT/deselect ALL
- (EXT) ALTER TABLE tx_multishop_cart_contents RENAME zzz_deleted_tx_multishop_cart_contents;
- (EXT) ALTER TABLE tx_multishop_notification RENAME zzz_deleted_tx_multishop_notification;
- (EXT) ALTER TABLE tx_multishop_orders_products_downloads RENAME zzz_deleted_tx_multishop_orders_products_downloads;
- (EXT) ALTER TABLE tx_multishop_products_attributes_stock RENAME zzz_deleted_tx_multishop_products_attributes_stock;
- (EXT) ALTER TABLE tx_multishop_products_attributes_stock_group RENAME zzz_deleted_tx_multishop_products_attributes_stock_group;
- (EXT) ALTER TABLE tx_multishop_products_search_log RENAME zzz_deleted_tx_multishop_products_search_log;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement