Zen Cart 源代码 db_rebuild

Zen Cart 源代码 db_rebuild_autoincrement.sql

下载文件

文件名: db_rebuild_autoincrement.sql
文件类型: Unknown文件
文件大小: 6.82 KiB
MD5: 49b4b5cecad65892b4a47e40b6c8de12

db_rebuild_autoincrement.sql - 打开高亮: # This script simply rebuilds the auto-increment settings on tables which should have them. # $ Id: $ ALTER TABLE upgrade_exceptions CHANGE COLUMN upgrade_exception_id upgrade_exception_id smallint(5) NOT NULL auto_increment; ALTER TABLE address_book CHANGE COLUMN address_book_id address_book_id int(11) NOT NULL auto_increment; ALTER TABLE address_format CHANGE COLUMN address_format_id address_format_id int(11) NOT NULL auto_increment; ALTER TABLE admin CHANGE COLUMN admin_id admin_id int(11) NOT NULL auto_increment; ALTER TABLE admin_activity_log CHANGE COLUMN log_id log_id int(15) NOT NULL auto_increment; ALTER TABLE authorizenet CHANGE COLUMN id id int(11) unsigned NOT NULL auto_increment; ALTER TABLE banners CHANGE COLUMN banners_id banners_id int(11) NOT NULL auto_increment; ALTER TABLE banners_history CHANGE COLUMN banners_history_id banners_history_id int(11) NOT NULL auto_increment; ALTER TABLE categories CHANGE COLUMN categories_id categories_id int(11) NOT NULL auto_increment; ALTER TABLE configuration CHANGE COLUMN configuration_id configuration_id int(11) NOT NULL auto_increment; ALTER TABLE configuration_group CHANGE COLUMN configuration_group_id configuration_group_id int(11) NOT NULL auto_increment; ALTER TABLE countries CHANGE COLUMN countries_id countries_id int(11) NOT NULL auto_increment; ALTER TABLE coupon_email_track CHANGE COLUMN unique_id unique_id int(11) NOT NULL auto_increment; ALTER TABLE coupon_gv_queue CHANGE COLUMN unique_id unique_id int(5) NOT NULL auto_increment; ALTER TABLE coupon_redeem_track CHANGE COLUMN unique_id unique_id int(11) NOT NULL auto_increment; ALTER TABLE coupon_restrict CHANGE COLUMN restrict_id restrict_id int(11) NOT NULL auto_increment; ALTER TABLE coupons CHANGE COLUMN coupon_id coupon_id int(11) NOT NULL auto_increment; ALTER TABLE currencies CHANGE COLUMN currencies_id currencies_id int(11) NOT NULL auto_increment; ALTER TABLE customers CHANGE COLUMN customers_id customers_id int(11) NOT NULL auto_increment; ALTER TABLE customers_basket CHANGE COLUMN customers_basket_id customers_basket_id int(11) NOT NULL auto_increment; ALTER TABLE customers_basket_attributes CHANGE COLUMN customers_basket_attributes_id customers_basket_attributes_id int(11) NOT NULL auto_increment; ALTER TABLE email_archive CHANGE COLUMN archive_id archive_id int(11) NOT NULL auto_increment; ALTER TABLE featured CHANGE COLUMN featured_id featured_id int(11) NOT NULL auto_increment; ALTER TABLE files_uploaded CHANGE COLUMN files_uploaded_id files_uploaded_id int(11) NOT NULL auto_increment; ALTER TABLE geo_zones CHANGE COLUMN geo_zone_id geo_zone_id int(11) NOT NULL auto_increment; ALTER TABLE group_pricing CHANGE COLUMN group_id group_id int(11) NOT NULL auto_increment; ALTER TABLE ezpages CHANGE COLUMN pages_id pages_id int(11) NOT NULL auto_increment; ALTER TABLE languages CHANGE COLUMN languages_id languages_id int(11) NOT NULL auto_increment; ALTER TABLE layout_boxes CHANGE COLUMN layout_id layout_id int(11) NOT NULL auto_increment; ALTER TABLE manufacturers CHANGE COLUMN manufacturers_id manufacturers_id int(11) NOT NULL auto_increment; ALTER TABLE media_clips CHANGE COLUMN clip_id clip_id int(11) NOT NULL auto_increment; ALTER TABLE media_manager CHANGE COLUMN media_id media_id int(11) NOT NULL auto_increment; ALTER TABLE media_types CHANGE COLUMN type_id type_id int(11) NOT NULL auto_increment; ALTER TABLE music_genre CHANGE COLUMN music_genre_id music_genre_id int(11) NOT NULL auto_increment; ALTER TABLE newsletters CHANGE COLUMN newsletters_id newsletters_id int(11) NOT NULL auto_increment; ALTER TABLE orders CHANGE COLUMN orders_id orders_id int(11) NOT NULL auto_increment; ALTER TABLE orders_products CHANGE COLUMN orders_products_id orders_products_id int(11) NOT NULL auto_increment; ALTER TABLE orders_products_attributes CHANGE COLUMN orders_products_attributes_id orders_products_attributes_id int(11) NOT NULL auto_increment; ALTER TABLE orders_products_download CHANGE COLUMN orders_products_download_id orders_products_download_id int(11) NOT NULL auto_increment; ALTER TABLE orders_status_history CHANGE COLUMN orders_status_history_id orders_status_history_id int(11) NOT NULL auto_increment; ALTER TABLE orders_total CHANGE COLUMN orders_total_id orders_total_id int(10) unsigned NOT NULL auto_increment; ALTER TABLE paypal_session CHANGE COLUMN unique_id unique_id int(11) NOT NULL auto_increment; ALTER TABLE paypal CHANGE COLUMN paypal_ipn_id paypal_ipn_id int(11) unsigned NOT NULL auto_increment; ALTER TABLE paypal_testing CHANGE COLUMN paypal_ipn_id paypal_ipn_id int(11) unsigned NOT NULL auto_increment; ALTER TABLE paypal_payment_status CHANGE COLUMN payment_status_id payment_status_id int(11) NOT NULL auto_increment; ALTER TABLE paypal_payment_status_history CHANGE COLUMN payment_status_history_id payment_status_history_id int(11) NOT NULL auto_increment; ALTER TABLE product_type_layout CHANGE COLUMN configuration_id configuration_id int(11) NOT NULL auto_increment; ALTER TABLE product_types CHANGE COLUMN type_id type_id int(11) NOT NULL auto_increment; ALTER TABLE products CHANGE COLUMN products_id products_id int(11) NOT NULL auto_increment; ALTER TABLE products_attributes CHANGE COLUMN products_attributes_id products_attributes_id int(11) NOT NULL auto_increment; ALTER TABLE products_description CHANGE COLUMN products_id products_id int(11) NOT NULL auto_increment; 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; ALTER TABLE project_version CHANGE COLUMN project_version_id project_version_id tinyint(3) NOT NULL auto_increment; ALTER TABLE project_version_history CHANGE COLUMN project_version_id project_version_id tinyint(3) NOT NULL auto_increment; ALTER TABLE query_builder CHANGE COLUMN query_id query_id int(11) NOT NULL auto_increment; ALTER TABLE record_artists CHANGE COLUMN artists_id artists_id int(11) NOT NULL auto_increment; ALTER TABLE record_company CHANGE COLUMN record_company_id record_company_id int(11) NOT NULL auto_increment; ALTER TABLE reviews CHANGE COLUMN reviews_id reviews_id int(11) NOT NULL auto_increment; ALTER TABLE salemaker_sales CHANGE COLUMN sale_id sale_id int(11) NOT NULL auto_increment; ALTER TABLE specials CHANGE COLUMN specials_id specials_id int(11) NOT NULL auto_increment; ALTER TABLE tax_class CHANGE COLUMN tax_class_id tax_class_id int(11) NOT NULL auto_increment; ALTER TABLE tax_rates CHANGE COLUMN tax_rates_id tax_rates_id int(11) NOT NULL auto_increment; ALTER TABLE template_select CHANGE COLUMN template_id template_id int(11) NOT NULL auto_increment; ALTER TABLE zones CHANGE COLUMN zone_id zone_id int(11) NOT NULL auto_increment; ALTER TABLE zones_to_geo_zones CHANGE COLUMN association_id association_id int(11) NOT NULL auto_increment;