Files
opensourcepos/app/Database/Migrations/sqlscripts/pre-3.0.2/2.2.1_to_2.2.2.sql
BudsieBuds e83c23cf0c Improve code style and PSR-12 compliance (#4204)
* Improve code style and PSR-12 compliance
- refactored code formatting to adhere to PSR-12 guidelines
- standardized coding conventions across the codebase
- added missing framework files and reverted markup changes
- reformatted arrays for enhanced readability
- updated language files for consistent styling and clarity
- minor miscellaneous improvements
2025-05-02 19:37:06 +02:00

25 lines
1.1 KiB
SQL

ALTER TABLE ospos_giftcards MODIFY value decimal(15,2);
ALTER TABLE ospos_items MODIFY cost_price decimal(15,2);
ALTER TABLE ospos_items MODIFY unit_price decimal(15,2);
ALTER TABLE ospos_items MODIFY quantity decimal(15,0);
ALTER TABLE ospos_items MODIFY reorder_level decimal(15,0);
ALTER TABLE ospos_items_taxes MODIFY percent decimal(15,2);
ALTER TABLE ospos_item_kit_items MODIFY quantity decimal(15,0);
ALTER TABLE ospos_receivings_items MODIFY quantity_purchased decimal(15,0);
ALTER TABLE ospos_receivings_items MODIFY item_unit_price decimal(15,2);
ALTER TABLE ospos_receivings_items MODIFY discount_percent decimal(15,2);
ALTER TABLE ospos_sales_items_taxes MODIFY percent decimal(15,2);
ALTER TABLE ospos_sales_suspended_items MODIFY quantity_purchased decimal(15,0);
ALTER TABLE ospos_sales_suspended_items MODIFY item_unit_price decimal(15,2);
ALTER TABLE ospos_sales_suspended_items MODIFY discount_percent decimal(15,2);
ALTER TABLE ospos_sales_suspended_items_taxes MODIFY percent decimal(15,2);
ALTER TABLE ospos_sessions MODIFY ip_address varchar(45);