[MySQL][PHP]Jak czytać output komendy doctrine orm:schema-tool:update --dump-sql. Opcje

[szczrzcz]

Zrobiłem "reverse enginering" istniejącej bazy. Teraz komenda sprawdzająca czy encje pasują do bazy orm:validate-schema wywala:

Kod

--  [Mapping]  OK - The mapping files are correct.
--  [Database] FAIL - The database schema is not in sync with the current mapping file.

a

Kod

orm:schema-tool:update --dump-sql

pokazuje mi 60 wierszy ALTER, które wyglądają mniej więcej tak:

[SQL] pobierz, plaintext 
ALTER TABLE taxes CHANGE position position SMALLINT NOT NULL;
[SQL] pobierz, plaintext 

jak czytać powyższą sugestię jeśli teraz ta kolumna wygląda tak:

[SQL] pobierz, plaintext 
CREATE TABLE `taxes` (
  `position` smallint(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[SQL] pobierz, plaintext 

Ten post edytował szczrzcz 25.06.2017, 15:58:13

[szczrzcz]

A co ci mowi:
doctrine:schema:update --dump-sql
?

napisałem w pierwszym poście

a pełny --dump-sql daje:

[SQL] pobierz, plaintext 
ALTER TABLE site_globals_translation CHANGE locale locale enum('en','pl','es','de','fr');
ALTER TABLE taxes CHANGE position position SMALLINT NOT NULL;
ALTER TABLE colors CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL;
ALTER TABLE gallery_desc CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE parent_id parent_id INT NOT NULL, CHANGE lang_id lang_id INT NOT NULL;
ALTER TABLE config CHANGE id id INT AUTO_INCREMENT NOT NULL;
ALTER TABLE languages CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE active active TINYINT(1) NOT NULL;
ALTER TABLE users CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE active active TINYINT(1) NOT NULL, CHANGE level level TINYINT(1) NOT NULL;
ALTER TABLE menu_translation CHANGE translatable_id translatable_id INT NOT NULL;
ALTER TABLE transport_service CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE courier_id courier_id INT NOT NULL, CHANGE status_id status_id TINYINT(1) NOT NULL;
ALTER TABLE order_transport CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE order_id order_id INT NOT NULL, CHANGE courier_id courier_id INT NOT NULL, CHANGE service_id service_id INT NOT NULL, CHANGE region_id region_id INT NOT NULL, CHANGE option_id option_id INT NOT NULL;
ALTER TABLE order_product CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE order_id order_id INT NOT NULL, CHANGE product_id product_id INT NOT NULL, CHANGE variation_id variation_id INT NOT NULL, CHANGE qty qty INT NOT NULL;
ALTER TABLE categories CHANGE show_expanded show_expanded TINYINT(1) NOT NULL;
ALTER TABLE product_variation CHANGE id2 id2 INT AUTO_INCREMENT NOT NULL, CHANGE product_id product_id INT NOT NULL, CHANGE tax_id tax_id INT NOT NULL, CHANGE qty qty INT NOT NULL;
ALTER TABLE gallery_photos CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE parent_id parent_id INT NOT NULL;
ALTER TABLE menu CHANGE parent_id parent_id INT NOT NULL, CHANGE `order` `order` TINYINT(1) NOT NULL;
ALTER TABLE news_desc CHANGE id2 id2 INT AUTO_INCREMENT NOT NULL, CHANGE parent_id parent_id INT NOT NULL, CHANGE lang_id lang_id INT NOT NULL;
ALTER TABLE pages_translation CHANGE translatable_id translatable_id INT NOT NULL;
ALTER TABLE transport_country CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE status_id status_id TINYINT(1) NOT NULL;
ALTER TABLE product_status CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE `order` `order` TINYINT(1) NOT NULL;
ALTER TABLE order_address CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE order_id order_id INT NOT NULL, CHANGE type type TINYINT(1) NOT NULL, CHANGE shipping_type shipping_type TINYINT(1) NOT NULL;
ALTER TABLE logistic_services CHANGE id id INT AUTO_INCREMENT NOT NULL;
ALTER TABLE frazy_promocyjne CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE max_uzyc max_uzyc INT NOT NULL;
ALTER TABLE news CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE gallery_id gallery_id INT NOT NULL, CHANGE active active TINYINT(1) NOT NULL;
ALTER TABLE product_manufacturer CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE status_id status_id INT NOT NULL, CHANGE popular popular TINYINT(1) NOT NULL, CHANGE `order` `order` INT NOT NULL;
ALTER TABLE transport_courier CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE status_id status_id TINYINT(1) NOT NULL;
ALTER TABLE transport_type CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE status_id status_id TINYINT(1) NOT NULL;
ALTER TABLE newsletter_users CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE lang_id lang_id TINYINT(1) NOT NULL;
ALTER TABLE transport_service_option CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE region_id region_id INT NOT NULL, CHANGE service_id service_id INT NOT NULL, CHANGE tax_id tax_id INT NOT NULL, CHANGE status_id status_id TINYINT(1) NOT NULL;
ALTER TABLE slider CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE `order` `order` INT NOT NULL;
ALTER TABLE payment CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE `order` `order` TINYINT(1) NOT NULL, CHANGE active active TINYINT(1) NOT NULL;
ALTER TABLE contact CHANGE id id INT AUTO_INCREMENT NOT NULL;
ALTER TABLE unitTransport_transport_groups_units CHANGE transport_group_id transport_group_id INT AUTO_INCREMENT NOT NULL;
ALTER TABLE product_translation CHANGE translatable_id translatable_id INT NOT NULL;
ALTER TABLE frazy_promocyjne_uzycia CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE id_frazy id_frazy INT NOT NULL, CHANGE id_zam id_zam INT NOT NULL, CHANGE id_user id_user INT NOT NULL;
ALTER TABLE transport_region CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE courier_id courier_id INT NOT NULL, CHANGE type_id type_id INT NOT NULL, CHANGE status_id status_id TINYINT(1) NOT NULL;
ALTER TABLE modules CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE type type TINYINT(1) NOT NULL;
ALTER TABLE pages CHANGE gallery_id gallery_id INT NOT NULL;
ALTER TABLE newsletter_templates CHANGE id id INT AUTO_INCREMENT NOT NULL;
ALTER TABLE transport_region_country CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE region_id region_id INT NOT NULL, CHANGE country_id country_id INT NOT NULL;
ALTER TABLE order_status CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE `order` `order` TINYINT(1) NOT NULL;
ALTER TABLE comments CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE parent_id parent_id INT NOT NULL, CHANGE customer_id customer_id INT NOT NULL, CHANGE lang_id lang_id INT NOT NULL;
ALTER TABLE transport_region_postcode CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE region_id region_id INT NOT NULL, CHANGE status_id status_id TINYINT(1) NOT NULL;
ALTER TABLE `order` CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE customer_id customer_id INT NOT NULL, CHANGE lang_id lang_id INT NOT NULL, CHANGE price price NUMERIC(10, 4) NOT NULL, CHANGE discount discount NUMERIC(5, 0) NOT NULL, CHANGE phrase_id phrase_id INT NOT NULL, CHANGE payment_id payment_id TINYINT(1) NOT NULL, CHANGE status_id status_id TINYINT(1) NOT NULL, CHANGE time_payment time_payment DATETIME NOT NULL, CHANGE time_complete time_complete DATETIME NOT NULL;
ALTER TABLE product CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE category_id category_id INT NOT NULL, CHANGE producer_id producer_id INT NOT NULL, CHANGE status_id status_id INT NOT NULL, CHANGE type type VARCHAR(255) NOT NULL;
ALTER TABLE gallery CHANGE id id INT AUTO_INCREMENT NOT NULL;
ALTER TABLE slider_translation CHANGE translatable_id translatable_id INT NOT NULL;
ALTER TABLE transport_region_service CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE region_id region_id INT NOT NULL, CHANGE service_id service_id INT NOT NULL;
ALTER TABLE logotypes CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE `order` `order` INT NOT NULL;
ALTER TABLE product_image CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE product_id product_id INT NOT NULL, CHANGE ga_image_id ga_image_id INT NOT NULL, CHANGE `order` `order` INT NOT NULL;
ALTER TABLE api_shop_log CHANGE date_add date_add DATETIME NOT NULL;
ALTER TABLE customer CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE type type TINYINT(1) NOT NULL, CHANGE country country TINYINT(1) NOT NULL, CHANGE discount discount NUMERIC(4, 2) NOT NULL, CHANGE price_group price_group TINYINT(1) NOT NULL, CHANGE sales_representative sales_representative INT NOT NULL;
ALTER TABLE unitTransport_units CHANGE length length INT NOT NULL, CHANGE width width INT NOT NULL, CHANGE height height INT NOT NULL, CHANGE price price NUMERIC(5, 2) NOT NULL;
[SQL] pobierz, plaintext