[Sommaire] [Imprimer]

   1  # This script simply rebuilds the auto-increment settings on tables which should have them.
   2  # $ Id: $
   3  
   4  ALTER TABLE upgrade_exceptions CHANGE COLUMN   upgrade_exception_id  upgrade_exception_id smallint(5) NOT NULL auto_increment;
   5  ALTER TABLE address_book CHANGE COLUMN address_book_id  address_book_id int(11) NOT NULL auto_increment;
   6  ALTER TABLE address_format CHANGE COLUMN   address_format_id  address_format_id int(11) NOT NULL auto_increment;
   7  ALTER TABLE admin CHANGE COLUMN   admin_id  admin_id int(11) NOT NULL auto_increment;
   8  ALTER TABLE admin_activity_log CHANGE COLUMN   log_id  log_id int(15) NOT NULL auto_increment;
   9  ALTER TABLE authorizenet CHANGE COLUMN id  id int(11) unsigned NOT NULL auto_increment;
  10  ALTER TABLE banners CHANGE COLUMN   banners_id  banners_id int(11) NOT NULL auto_increment;
  11  ALTER TABLE banners_history CHANGE COLUMN   banners_history_id  banners_history_id int(11) NOT NULL auto_increment;
  12  ALTER TABLE categories CHANGE COLUMN   categories_id  categories_id int(11) NOT NULL auto_increment;
  13  ALTER TABLE configuration CHANGE COLUMN   configuration_id  configuration_id int(11) NOT NULL auto_increment;
  14  ALTER TABLE configuration_group CHANGE COLUMN   configuration_group_id  configuration_group_id int(11) NOT NULL auto_increment;
  15  ALTER TABLE countries CHANGE COLUMN   countries_id  countries_id int(11) NOT NULL auto_increment;
  16  ALTER TABLE coupon_email_track CHANGE COLUMN   unique_id  unique_id int(11) NOT NULL auto_increment;
  17  ALTER TABLE coupon_gv_queue CHANGE COLUMN unique_id  unique_id int(5) NOT NULL auto_increment;
  18  ALTER TABLE coupon_redeem_track CHANGE COLUMN unique_id  unique_id int(11) NOT NULL auto_increment;
  19  ALTER TABLE coupon_restrict CHANGE COLUMN restrict_id  restrict_id int(11) NOT NULL auto_increment;
  20  ALTER TABLE coupons CHANGE COLUMN coupon_id  coupon_id int(11) NOT NULL auto_increment;
  21  ALTER TABLE currencies CHANGE COLUMN currencies_id  currencies_id int(11) NOT NULL auto_increment;
  22  ALTER TABLE customers CHANGE COLUMN customers_id  customers_id int(11) NOT NULL auto_increment;
  23  ALTER TABLE customers_basket CHANGE COLUMN customers_basket_id  customers_basket_id int(11) NOT NULL auto_increment;
  24  ALTER TABLE customers_basket_attributes CHANGE COLUMN customers_basket_attributes_id  customers_basket_attributes_id int(11) NOT NULL auto_increment;
  25  ALTER TABLE email_archive CHANGE COLUMN archive_id  archive_id int(11) NOT NULL auto_increment;
  26  ALTER TABLE featured CHANGE COLUMN featured_id  featured_id int(11) NOT NULL auto_increment;
  27  ALTER TABLE files_uploaded CHANGE COLUMN files_uploaded_id  files_uploaded_id int(11) NOT NULL auto_increment;
  28  ALTER TABLE geo_zones CHANGE COLUMN geo_zone_id  geo_zone_id int(11) NOT NULL auto_increment;
  29  ALTER TABLE group_pricing CHANGE COLUMN group_id  group_id int(11) NOT NULL auto_increment;
  30  ALTER TABLE ezpages CHANGE COLUMN pages_id  pages_id int(11) NOT NULL auto_increment;
  31  ALTER TABLE languages CHANGE COLUMN languages_id  languages_id int(11) NOT NULL auto_increment;
  32  ALTER TABLE layout_boxes CHANGE COLUMN layout_id  layout_id int(11) NOT NULL auto_increment;
  33  ALTER TABLE manufacturers CHANGE COLUMN manufacturers_id  manufacturers_id int(11) NOT NULL auto_increment;
  34  ALTER TABLE media_clips CHANGE COLUMN clip_id  clip_id int(11) NOT NULL auto_increment;
  35  ALTER TABLE media_manager CHANGE COLUMN media_id  media_id int(11) NOT NULL auto_increment;
  36  ALTER TABLE media_types CHANGE COLUMN type_id  type_id int(11) NOT NULL auto_increment;
  37  ALTER TABLE music_genre CHANGE COLUMN music_genre_id  music_genre_id int(11) NOT NULL auto_increment;
  38  ALTER TABLE newsletters CHANGE COLUMN newsletters_id  newsletters_id int(11) NOT NULL auto_increment;
  39  ALTER TABLE orders CHANGE COLUMN orders_id  orders_id int(11) NOT NULL auto_increment;
  40  ALTER TABLE orders_products CHANGE COLUMN orders_products_id  orders_products_id int(11) NOT NULL auto_increment;
  41  ALTER TABLE orders_products_attributes CHANGE COLUMN orders_products_attributes_id  orders_products_attributes_id int(11) NOT NULL auto_increment;
  42  ALTER TABLE orders_products_download CHANGE COLUMN orders_products_download_id  orders_products_download_id int(11) NOT NULL auto_increment;
  43  ALTER TABLE orders_status_history CHANGE COLUMN orders_status_history_id  orders_status_history_id int(11) NOT NULL auto_increment;
  44  ALTER TABLE orders_total CHANGE COLUMN orders_total_id  orders_total_id int(10) unsigned NOT NULL auto_increment;
  45  ALTER TABLE paypal_session CHANGE COLUMN unique_id  unique_id int(11) NOT NULL auto_increment;
  46  ALTER TABLE paypal CHANGE COLUMN paypal_ipn_id  paypal_ipn_id int(11) unsigned NOT NULL auto_increment;
  47  ALTER TABLE paypal_testing CHANGE COLUMN paypal_ipn_id  paypal_ipn_id int(11) unsigned NOT NULL auto_increment;
  48  ALTER TABLE paypal_payment_status CHANGE COLUMN payment_status_id  payment_status_id int(11) NOT NULL auto_increment;
  49  ALTER TABLE paypal_payment_status_history CHANGE COLUMN payment_status_history_id  payment_status_history_id int(11) NOT NULL auto_increment;
  50  ALTER TABLE product_type_layout CHANGE COLUMN configuration_id  configuration_id int(11) NOT NULL auto_increment;
  51  ALTER TABLE product_types CHANGE COLUMN type_id  type_id int(11) NOT NULL auto_increment;
  52  ALTER TABLE products CHANGE COLUMN products_id  products_id int(11) NOT NULL auto_increment;
  53  ALTER TABLE products_attributes CHANGE COLUMN products_attributes_id  products_attributes_id int(11) NOT NULL auto_increment;
  54  ALTER TABLE products_description CHANGE COLUMN products_id  products_id int(11) NOT NULL auto_increment;
  55  ALTER TABLE products_options_values_to_products_options CHANGE COLUMN products_options_values_to_products_options_id  products_options_values_to_products_options_id int(11) NOT NULL auto_increment;
  56  ALTER TABLE project_version CHANGE COLUMN project_version_id  project_version_id tinyint(3) NOT NULL auto_increment;
  57  ALTER TABLE project_version_history CHANGE COLUMN project_version_id  project_version_id tinyint(3) NOT NULL auto_increment;
  58  ALTER TABLE query_builder CHANGE COLUMN query_id  query_id int(11) NOT NULL auto_increment;
  59  ALTER TABLE record_artists CHANGE COLUMN artists_id  artists_id int(11) NOT NULL auto_increment;
  60  ALTER TABLE record_company CHANGE COLUMN record_company_id  record_company_id int(11) NOT NULL auto_increment;
  61  ALTER TABLE reviews CHANGE COLUMN reviews_id  reviews_id int(11) NOT NULL auto_increment;
  62  ALTER TABLE salemaker_sales CHANGE COLUMN sale_id  sale_id int(11) NOT NULL auto_increment;
  63  ALTER TABLE specials CHANGE COLUMN specials_id  specials_id int(11) NOT NULL auto_increment;
  64  ALTER TABLE tax_class CHANGE COLUMN tax_class_id  tax_class_id int(11) NOT NULL auto_increment;
  65  ALTER TABLE tax_rates CHANGE COLUMN tax_rates_id  tax_rates_id int(11) NOT NULL auto_increment;
  66  ALTER TABLE template_select CHANGE COLUMN template_id  template_id int(11) NOT NULL auto_increment;
  67  ALTER TABLE zones CHANGE COLUMN zone_id  zone_id int(11) NOT NULL auto_increment;
  68  ALTER TABLE zones_to_geo_zones CHANGE COLUMN association_id  association_id int(11) NOT NULL auto_increment;