partsERP

000_combine.sql

feat: Shop Supplier Purchase Order get, filter, and add new.

2024-10-25 16:42:13 +01:00

001_destroy.sql

feat(MySQL): Get Many stored procedures created for product variations with variation types and product prices with discounts and delivery options.

2024-10-05 13:20:00 +01:00

100_tbl_Msg_Error_Type.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

100.0_tbl_Shop_Product_Change_Set.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

100.1_tbl_Shop_User_Change_Set.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

100.2_tbl_Shop_Access_Level.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

100.2_tbl_Shop_Sales_And_Purchasing_Change_Set.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

100.3_tbl_Shop_Access_Level_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

102_tbl_File_Type.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

103_tbl_File_Type_Audit.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

104_tbl_Shop_General.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

105_tbl_Shop_General_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

106_tbl_Shop_Category.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

107_tbl_Shop_Category_Audit.sql

1.started removal of CDNs.\n 2. Improved modular structure for all parts of project including database.

2024-08-30 23:27:28 +01:00

108_tbl_Shop_Recurrence_Interval.sql

1. View, filter, and save Product Permutation. \n 2. Synchronised with Product Category page and all common functionality moved into base and base table css, js, and python files.

2024-09-24 23:25:52 +01:00

109_tbl_Shop_Recurrence_Interval_Audit.sql

1. View, filter, and save Product Permutation. \n 2. Synchronised with Product Category page and all common functionality moved into base and base table css, js, and python files.

2024-09-24 23:25:52 +01:00

110.0_tbl_Shop_Region.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

110.1_tbl_Shop_Region_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

110.2_tbl_Shop_Region_Branch.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

110.3_tbl_Shop_Region_Branch_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

110.4_tbl_Shop_Currency.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

110.5_tbl_Shop_Currency_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

110.6_tbl_Shop_Tax_Or_Surcharge.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

110.7_tbl_Shop_Tax_Or_Surcharge_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

110.8_tbl_Shop_Product.sql

1. View, filter, and save Product Permutation. \n 2. Synchronised with Product Category page and all common functionality moved into base and base table css, js, and python files.

2024-09-24 23:25:52 +01:00

110.9_tbl_Shop_Product_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

112_tbl_Shop_Variation_Type.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

113.0_tbl_Shop_Variation_Type_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

114_tbl_Shop_Variation.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

115_tbl_Shop_Variation_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

117.1_tbl_Shop_Product_Permutation.sql

feat: Shop Supplier Purchase Order get, filter, and add new.

2024-10-25 16:42:13 +01:00

117.2_tbl_Shop_Product_Permutation_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

117.3_tbl_Shop_Product_Permutation_Variation_Link.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

117.4_tbl_Shop_Product_Permutation_Variation_Link_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

117.5_tbl_Shop_Product_Currency_Region_Link.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

117.6_tbl_Shop_Product_Currency_Region_Link_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

118_tbl_Shop_Image_Type.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

119_tbl_Shop_Image_Type_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

120_tbl_Shop_Image.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

121_tbl_Shop_Image_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

122_tbl_Shop_Delivery_Option.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

123_tbl_Shop_Delivery_Option_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

124_tbl_Shop_Product_Delivery_Option_Link.sql

feat(MySQL): Get Many stored procedures created for product variations with variation types and product prices with discounts and delivery options.

2024-10-05 13:20:00 +01:00

125_tbl_Shop_Product_Delivery_Option_Link_Audit.sql

feat(MySQL): Get Many stored procedures created for product variations with variation types and product prices with discounts and delivery options.

2024-10-05 13:20:00 +01:00

130.4_tbl_Shop_Discount.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

131_tbl_Shop_Discount_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

132_tbl_Shop_Discount_Region_Currency_Link.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

133_tbl_Shop_Discount_Region_Currency_Link_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

153_tbl_Shop_Permission_Group.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

154_tbl_Shop_Permission_Group_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

155_tbl_Shop_Permission.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

156_tbl_Shop_Permission_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

157_tbl_Shop_Role.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

158_tbl_Shop_Role_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

159_tbl_Shop_Role_Permission_Link.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

160_tbl_Shop_Role_Permission_Link_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

161_tbl_Shop_User.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

162_tbl_Shop_User_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

163_tbl_Shop_User_Role_Link.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

164_tbl_Shop_User_Role_Link_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

165_tbl_Shop_Address.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

166_tbl_Shop_Address_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

167_tbl_Shop_User_Basket.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

168_tbl_Shop_User_Basket_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

169_tbl_Shop_User_Order_Status.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

170_tbl_Shop_User_Order_Status_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

181.0_tbl_Shop_Supplier.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

181.1_tbl_Shop_Supplier_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

181.2_tbl_Shop_Unit_Measurement.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

181.3_tbl_Shop_Unit_Measurement_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

181.4_tbl_Shop_Unit_Measurement_Conversion.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

181.5_tbl_Shop_Unit_Measurement_Conversion_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

181.6_tbl_Shop_Supplier_Purchase_Order.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

181.7_tbl_Shop_Supplier_Purchase_Order_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

181.8_tbl_Shop_Supplier_Purchase_Order_Product_Link.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

181.9_tbl_Shop_Supplier_Purchase_Order_Product_Link_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

182.0_tbl_Shop_Supplier_Purchase_Order_Product_Link_Temp.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

183_tbl_Shop_Manufacturing_Purchase_Order.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

184_tbl_Shop_Manufacturing_Purchase_Order_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

185_tbl_Shop_Manufacturing_Purchase_Order_Product_Link.sql

feat: Shop Supplier Purchase Order get, filter, and add new.

2024-10-25 16:42:13 +01:00

186_tbl_Shop_Manufacturing_Purchase_Order_Product_Link_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

186.1_tbl_Shop_Manufacturing_Purchase_Order_Product_Link_Temp.sql

feat: Shop Supplier Purchase Order get, filter, and add new.

2024-10-25 16:42:13 +01:00

187.0_tbl_Shop_Customer.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

187.1_tbl_Shop_Customer_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

187.2_tbl_Shop_Customer_Sales_Order.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

188_tbl_Shop_Customer_Sales_Order_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

189_tbl_Shop_Customer_Sales_Order_Product_Link.sql

Complete system for getting + saving Product Categories with new database, server, and client architecture.

2024-09-01 21:57:46 +01:00

190_tbl_Shop_Customer_Sales_Order_Product_Link_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

191_tbl_Shop_Customer_Sales_Order_Product_Link_Temp.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

300.2_tri_Shop_Sales_And_Purchasing_Change_Set.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

301_tri_Shop_Product_Change_Set.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

301.1_tri_Shop_User_Change_Set.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

301.2_tri_Shop_Access_Level.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

302_tri_File_Type.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

303_tri_File_Type_Audit.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

304_tri_Shop_General.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

306_tri_Shop_Category.sql

1.started removal of CDNs.\n 2. Improved modular structure for all parts of project including database.

2024-08-30 23:27:28 +01:00

308_tri_Shop_Recurrence_Interval.sql

1. View, filter, and save Product Permutation. \n 2. Synchronised with Product Category page and all common functionality moved into base and base table css, js, and python files.

2024-09-24 23:25:52 +01:00

310.0_tri_Shop_Region.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

310.2_tri_Shop_Region_Branch.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

310.4_tri_Shop_Currency.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

310.6_tri_Shop_Tax_Or_Surcharge.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

310.8_tri_Shop_Product.sql

1. View, filter, and save Product Permutation. \n 2. Synchronised with Product Category page and all common functionality moved into base and base table css, js, and python files.

2024-09-24 23:25:52 +01:00

312_tri_Shop_Variation_Type.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

314_tri_Shop_Variation.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

317.1_tri_Shop_Product_Permutation.sql

feat: Shop Supplier Purchase Order get, filter, and add new.

2024-10-25 16:42:13 +01:00

317.3_tri_Shop_Product_Permutation_Variation_Link.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

317.5_tri_Shop_Product_Currency_Region_Link.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

318_tri_Shop_Image_Type.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

320_tri_Shop_Image.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

322_tri_Shop_Delivery_Option.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

324_tri_Shop_Product_Delivery_Option_Link.sql

feat(MySQL): Get Many stored procedures created for product variations with variation types and product prices with discounts and delivery options.

2024-10-05 13:20:00 +01:00

330_tri_Shop_Discount.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

332_tri_Shop_Discount_Region_Currency_Link.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

353_tri_Shop_Permission_Group.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

355_tri_Shop_Permission.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

357_tri_Shop_Role.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

359_tri_Shop_Role_Permission_Link.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

361_tri_Shop_User.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

363_tri_Shop_User_Role_Link.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

365_tri_Shop_Address.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

367_tri_Shop_User_Basket.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

369_tri_Shop_User_Order_Status.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

381.0_tri_Shop_Supplier.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

381.2_tri_Shop_Unit_Measurement.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

381.4_tri_Shop_Unit_Of_Measurement_Conversion.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

381.6_tri_Shop_Supplier_Purchase_Order.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

381.8_tri_Shop_Supplier_Purchase_Order_Product_Link.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

383_tri_Shop_Manufacturing_Purchase_Order.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

385_tri_Shop_Manufacturing_Purchase_Order_Product_Link.sql

feat: Shop Supplier Purchase Order get, filter, and add new.

2024-10-25 16:42:13 +01:00

387.0_tri_Shop_Customer.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

387.2_tri_Shop_Customer_Sales_Order.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

389_tri_Shop_Customer_Sales_Order_Product_Link.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

600_p_shop_save_product.sql

feat(web): Store Product UI created and hooked up for viewing, editing, and saving.

2024-10-05 21:16:42 +01:00

600_p_shop_user_eval.sql

refactor(SQL): Staging tables and Calc stored procedures used for modular stored procedure archicture for scalability. Implemented for Product Catalogue. \n BREAKING CHANGE: BIT argument a_debug added to all but basic stored procedures for analysis of performance and results.

2024-10-02 15:59:53 +01:00

602_p_save_supplier_purchase_order.sql

refactor(SQL): Staging tables and Calc stored procedures used for modular stored procedure archicture for scalability. Implemented for Product Catalogue. \n BREAKING CHANGE: BIT argument a_debug added to all but basic stored procedures for analysis of performance and results.

2024-10-02 15:59:53 +01:00

602_p_shop_save_supplier.sql

feat(web): Store Product UI created and hooked up for viewing, editing, and saving.

2024-10-05 21:16:42 +01:00

604_p_shop_save_manufacturing_purchase_order.sql

feat: Shop Supplier Purchase Order get, filter, and add new.

2024-10-25 16:42:13 +01:00

605_p_shop_save_customer.sql

feat(web): Store Product UI created and hooked up for viewing, editing, and saving.

2024-10-05 21:16:42 +01:00

606_p_shop_save_customer_sales_order.sql

refactor(SQL): Staging tables and Calc stored procedures used for modular stored procedure archicture for scalability. Implemented for Product Catalogue. \n BREAKING CHANGE: BIT argument a_debug added to all but basic stored procedures for analysis of performance and results.

2024-10-02 15:59:53 +01:00

610_p_shop_save_user.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

611_p_shop_save_user_basket.sql

refactor(SQL): Staging tables and Calc stored procedures used for modular stored procedure archicture for scalability. Implemented for Product Catalogue. \n BREAKING CHANGE: BIT argument a_debug added to all but basic stored procedures for analysis of performance and results.

2024-10-02 15:59:53 +01:00

700_p_shop_get_many_product.sql

feat: Shop Supplier Purchase Order get, filter, and add new.

2024-10-25 16:42:13 +01:00

701_p_shop_get_many_role_permission.sql

1.started removal of CDNs.\n 2. Improved modular structure for all parts of project including database.

2024-08-30 23:27:28 +01:00

702.1_p_shop_get_many_currency.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

702.2_p_shop_get_many_region.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

703_p_shop_get_many_user_order.sql

refactor(SQL): Staging tables and Calc stored procedures used for modular stored procedure archicture for scalability. Implemented for Product Catalogue. \n BREAKING CHANGE: BIT argument a_debug added to all but basic stored procedures for analysis of performance and results.

2024-10-02 15:59:53 +01:00

704_p_shop_get_many_stripe_product_new.sql

refactor(SQL): Staging tables and Calc stored procedures used for modular stored procedure archicture for scalability. Implemented for Product Catalogue. \n BREAKING CHANGE: BIT argument a_debug added to all but basic stored procedures for analysis of performance and results.

2024-10-02 15:59:53 +01:00

705_p_shop_get_many_stripe_price_new.sql

refactor(SQL): Staging tables and Calc stored procedures used for modular stored procedure archicture for scalability. Implemented for Product Catalogue. \n BREAKING CHANGE: BIT argument a_debug added to all but basic stored procedures for analysis of performance and results.

2024-10-02 15:59:53 +01:00

706_p_shop_get_many_supplier_purchase_order.sql

feat: Shop Supplier Purchase Order get, filter, and add new.

2024-10-25 16:42:13 +01:00

706_p_shop_get_many_supplier.sql

refactor(SQL): Staging tables and Calc stored procedures used for modular stored procedure archicture for scalability. Implemented for Product Catalogue. \n BREAKING CHANGE: BIT argument a_debug added to all but basic stored procedures for analysis of performance and results.

2024-10-02 15:59:53 +01:00

708_p_shop_get_many_manufacturing_purchase_order.sql

feat: Shop Supplier Purchase Order get, filter, and add new.

2024-10-25 16:42:13 +01:00

709_p_shop_get_many_customer.sql

refactor(SQL): Staging tables and Calc stored procedures used for modular stored procedure archicture for scalability. Implemented for Product Catalogue. \n BREAKING CHANGE: BIT argument a_debug added to all but basic stored procedures for analysis of performance and results.

2024-10-02 15:59:53 +01:00

710_p_shop_get_many_customer_sales_order.sql

feat: Shop Supplier Purchase Order get, filter, and add new.

2024-10-25 16:42:13 +01:00

900_populate.sql

feat: Shop Supplier Purchase Order get, filter, and add new.

2024-10-25 16:42:13 +01:00

901_view.sql

feat(MySQL): Get Many stored procedures created for product variations with variation types and product prices with discounts and delivery options.

2024-10-05 13:20:00 +01:00

910_anal.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

920_edit_permissions.sql

1. PostgreSQL copy of all MySQL created and tested.\n 2. Purchase Orders and Sales Orders and stock level management added to MySQL, PostgreSQL, and server and front end code.

2024-07-05 20:34:11 +01:00

temp.txt

feat(MySQL): Get Many stored procedures created for product variations with variation types and product prices with discounts and delivery options.

2024-10-05 13:20:00 +01:00