Advertisement
Guest User

Untitled

a guest
May 11th, 2014
21
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 4.40 KB | None | 0 0
  1. TABLE AND FIELD definitions should be updated
  2.  
  3. There seems TO be a NUMBER OF differencies BETWEEN the DATABASE AND the selected SQL-file.
  4. Please SELECT which statements you want TO EXECUTE IN ORDER TO UPDATE your DATABASE:
  5.  
  6. Changing FIELDS
  7.  
  8.     ALTER TABLE static_taxes CHANGE tx_country_iso_2 tx_country_iso_2 CHAR(2) DEFAULT '';
  9.     CURRENT VALUE: CHAR(3) DEFAULT ''
  10.  
  11. Remove unused FIELDS (RENAME WITH prefix)
  12.  
  13.     SELECT/deselect ALL
  14.     ALTER TABLE fe_users CHANGE address_ext zzz_deleted_address_ext VARCHAR(10) NOT NULL DEFAULT '';
  15.     (EXT) ALTER TABLE fe_users CHANGE tx_multishop_source_id zzz_deleted_tx_multishop_source_id VARCHAR(50) NOT NULL DEFAULT '';
  16.     (EXT) ALTER TABLE fe_users CHANGE page_uid zzz_deleted_page_uid INT(11) NOT NULL DEFAULT '0';
  17.     (EXT) ALTER TABLE tx_multishop_cms CHANGE hash zzz_deleted_hash VARCHAR(50) NOT NULL DEFAULT '';
  18.     (EXT) ALTER TABLE tx_multishop_invoices CHANGE store_currency zzz_deleted_store_currency CHAR(3) NOT NULL DEFAULT '';
  19.     (EXT) ALTER TABLE tx_multishop_invoices CHANGE customer_currency zzz_deleted_customer_currency CHAR(3) NOT NULL DEFAULT '';
  20.     (EXT) ALTER TABLE tx_multishop_invoices CHANGE currency_rate zzz_deleted_currency_rate VARCHAR(15) NOT NULL DEFAULT '1';
  21.     (EXT) ALTER TABLE tx_multishop_orders CHANGE store_currency zzz_deleted_store_currency CHAR(3) NOT NULL DEFAULT '';
  22.     (EXT) ALTER TABLE tx_multishop_orders CHANGE customer_currency zzz_deleted_customer_currency CHAR(3) NOT NULL DEFAULT '';
  23.     (EXT) ALTER TABLE tx_multishop_orders CHANGE currency_rate zzz_deleted_currency_rate VARCHAR(15) NOT NULL DEFAULT '1';
  24.     (EXT) ALTER TABLE tx_multishop_orders CHANGE track_and_trace_code zzz_deleted_track_and_trace_code VARCHAR(50) NOT NULL DEFAULT '';
  25.     (EXT) ALTER TABLE tx_multishop_orders CHANGE expected_delivery_date zzz_deleted_expected_delivery_date INT(11) NOT NULL DEFAULT '0';
  26.     (EXT) ALTER TABLE tx_multishop_orders CHANGE billing_address_ext zzz_deleted_billing_address_ext VARCHAR(10) NOT NULL DEFAULT '';
  27.     (EXT) ALTER TABLE tx_multishop_orders CHANGE delivery_address_ext zzz_deleted_delivery_address_ext VARCHAR(10) NOT NULL DEFAULT '';
  28.     (EXT) ALTER TABLE tx_multishop_orders CHANGE cruser_id zzz_deleted_cruser_id INT(11) NOT NULL DEFAULT '0';
  29.     (EXT) ALTER TABLE tx_multishop_orders CHANGE is_proposal zzz_deleted_is_proposal tinyint(1) NOT NULL DEFAULT '0';
  30.     (EXT) ALTER TABLE tx_multishop_orders_products CHANGE file_remote_location zzz_deleted_file_remote_location text NOT NULL;
  31.     (EXT) ALTER TABLE tx_multishop_orders_products CHANGE file_number_of_downloads zzz_deleted_file_number_of_downloads INT(11) NOT NULL DEFAULT '0';
  32.     (EXT) ALTER TABLE tx_multishop_orders_products CHANGE qty_delivered zzz_deleted_qty_delivered INT(4) NOT NULL DEFAULT '0';
  33.     (EXT) ALTER TABLE tx_multishop_orders_products CHANGE qty_not_deliverable zzz_deleted_qty_not_deliverable INT(4) NOT NULL DEFAULT '0';
  34.     (EXT) ALTER TABLE tx_multishop_products CHANGE file_number_of_downloads zzz_deleted_file_number_of_downloads INT(11) NOT NULL DEFAULT '0';
  35.     (EXT) ALTER TABLE tx_multishop_products_description CHANGE file_remote_location zzz_deleted_file_remote_location text NOT NULL;
  36.     (EXT) ALTER TABLE tx_multishop_products_options CHANGE required zzz_deleted_required tinyint(1) NOT NULL DEFAULT '0';
  37.  
  38. DROP FIELDS (really!)
  39.  
  40.     SELECT/deselect ALL
  41.     ALTER TABLE fe_users DROP KEY tx_multishop_source_id;
  42.     ALTER TABLE fe_users DROP KEY page_uid;
  43.     ALTER TABLE tx_multishop_cms DROP KEY hash;
  44.     ALTER TABLE tx_multishop_orders DROP KEY expected_delivery_date;
  45.     ALTER TABLE tx_multishop_orders DROP KEY is_proposal;
  46.     ALTER TABLE tx_multishop_products_description DROP KEY combined_four;
  47.  
  48. Removing TABLES (RENAME WITH prefix)
  49.  
  50.     SELECT/deselect ALL
  51.     (EXT) ALTER TABLE tx_multishop_cart_contents RENAME zzz_deleted_tx_multishop_cart_contents;
  52.     (EXT) ALTER TABLE tx_multishop_notification RENAME zzz_deleted_tx_multishop_notification;
  53.     (EXT) ALTER TABLE tx_multishop_orders_products_downloads RENAME zzz_deleted_tx_multishop_orders_products_downloads;
  54.     (EXT) ALTER TABLE tx_multishop_products_attributes_stock RENAME zzz_deleted_tx_multishop_products_attributes_stock;
  55.     (EXT) ALTER TABLE tx_multishop_products_attributes_stock_group RENAME zzz_deleted_tx_multishop_products_attributes_stock_group;
  56.     (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