🔧 Multi-Database Migration (Standalone PHP)

📌 Found Databases:

🚀 Updating: aa_sample_database

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_abhinandan

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_ameeriyaschool

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_brightcareerschool

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_db_4

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_dreamacademy

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_eden

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_glorious

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_heritage

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_heritageglobal

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_hmpublicschool

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_holymission

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_juapublicschool

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_jyotipublicschool

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_mps

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_myfirstteest

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_mytesting

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_royalanglesschool

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_ruchiexport

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_sahayschool

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_saintsandipanischool

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_saraswati

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_school

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_scpschadi

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_startsmartpublicschool

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_sunrisepublicschool

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_testinxmd

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🚀 Updating: school_vvspublicschool

Running: ALTER TABLE `item_stock` ADD `total_price` DECIMAL(10,2) NULL AFTER `purchase_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `paid_amount` DECIMAL(10,2) NOT NULL AFTER `total_price`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` ADD `sell_amount` DECIMAL(10,2) NOT NULL AFTER `paid_amount`;

⚠ Already Exists — Skipped

Running: ALTER TABLE `item_stock` CHANGE `sell_amount` `sell_amount` DECIMAL(10,0) NULL DEFAULT NULL;

✔ SUCCESS

🎉 Migration Completed for ALL Databases!