BMSHOSxPInventory_Setup_3.53.4.17.exe

[doramon]

http://bms-hosxp.com/hosxp/BMSHOSxPInventory_Setup_3.53.4.17.exe

แล้วมีอะไรเพิ่มบ้างใครใช้แล้วแจ้งด้วย

โค๊ด: SQL

1. ALTER IGNORE TABLE stock_item_month_rate ADD PRIMARY KEY (stock_item_month_rate_id)
2. ALTER IGNORE TABLE stock_item_month_rate MODIFY stock_item_month_rate_id INT NOT NULL
3. ALTER IGNORE TABLE stock_item_balance_history ADD PRIMARY KEY (stock_item_balance_history_id)
4. ALTER IGNORE TABLE stock_item_balance_history MODIFY stock_item_balance_history_id INT NOT NULL
5. ALTER TABLE stock_item_unit  ADD `age_morethan_5_year` INT NULL  
6. ALTER TABLE stock_item_unit  ADD `age_5_year` INT NULL  
7. ALTER TABLE stock_item_unit  ADD `age_4_year` INT NULL  
8. ALTER TABLE stock_item_unit  ADD `age_3_year` INT NULL  
9. ALTER TABLE stock_item_unit  ADD `age_2_year` INT NULL  
10. ALTER TABLE stock_item_unit  ADD `age_1_year` INT NULL  
11. ALTER TABLE stock_item_unit  ADD `empty_in_day` INT NULL  
12. ALTER TABLE stock_item_unit  ADD `rate_1_month_lastyear` INT NULL  
13. ALTER TABLE stock_item_unit  ADD `rate_12_month` INT NULL  
14. ALTER TABLE stock_item_unit  ADD `rate_3_month` INT NULL  
15. ALTER TABLE stock_item_unit  ADD `rate_1_month` INT NULL  
16. ALTER TABLE stock_item_unit  ADD `last_active_date` DATE NULL  
17. ALTER TABLE stock_item_month_rate  ADD `balance_amount` DOUBLE(15,3) NULL  
18. ALTER TABLE stock_item_month_rate  ADD `pay_amount` DOUBLE(15,3) NULL  
19. ALTER TABLE stock_item_month_rate  ADD `receive_amount` DOUBLE(15,3) NULL  
20. ALTER TABLE stock_item_month_rate  ADD `stock_item_unit_id` INT NULL  
21. ALTER TABLE stock_item_month_rate  ADD `balance_qty` INT NULL  
22. ALTER TABLE stock_item_month_rate  ADD `pay_qty` INT NULL  
23. ALTER TABLE stock_item_month_rate  ADD `receive_qty` INT NULL  
24. ALTER TABLE stock_item_month_rate  ADD `item_date` DATE NULL  
25. ALTER TABLE stock_item_month_rate  ADD `item_month` INT NOT NULL  
26. ALTER TABLE stock_item_month_rate  ADD `item_year` INT NOT NULL  
27. ALTER TABLE stock_item_month_rate  ADD `item_id` INT NOT NULL  
28. ALTER TABLE stock_item_balance_history  ADD `adj_amount` INT NULL  
29. ALTER TABLE stock_item_balance_history  ADD `adj_qty` INT NULL  
30. ALTER TABLE stock_item_balance_history  ADD `warehouse_id` INT NULL  
31. ALTER TABLE stock_item_balance_history  ADD `pay_amount` DOUBLE(15,3) NULL  
32. ALTER TABLE stock_item_balance_history  ADD `pay_qty` INT NULL  
33. ALTER TABLE stock_item_balance_history  ADD `receive_amount` DOUBLE(15,3) NULL  
34. ALTER TABLE stock_item_balance_history  ADD `receive_qty` INT NULL  
35. ALTER TABLE stock_item_balance_history  ADD `stock_item_unit_id` INT NOT NULL  
36. ALTER TABLE stock_item_balance_history  ADD `amount` DOUBLE(15,3) NULL  
37. ALTER TABLE stock_item_balance_history  ADD `qty` INT NULL  
38. ALTER TABLE stock_item_balance_history  ADD `balance_date` DATE NOT NULL  
39. ALTER TABLE stock_item_balance_history  ADD `item_id` INT NOT NULL  
40. CREATE TABLE stock_item_month_rate ( `stock_item_month_rate_id` INT NOT NULL  )
41. CREATE TABLE stock_item_balance_history ( `stock_item_balance_history_id` INT NOT NULL  )
42. DELETE FROM hosxp_ddl_index
43. DELETE FROM hosxp_ddl_field
44. CREATE TABLE IF NOT EXISTS `hosxp_ddl_index` (  `table_name` VARCHAR(150) NOT NULL DEFAULT "",  `index_name` VARCHAR(150) NOT NULL DEFAULT "",  `field_number` INT(11) DEFAULT NULL,  `field_name` VARCHAR(150) NOT NULL DEFAULT "",  `index_unique` CHAR(1) DEFAULT NULL,  `index_seq` INT(11) DEFAULT NULL,  PRIMARY KEY  (`table_name`,`index_name`,`field_name`),  KEY `index_name` (`index_name`),  KEY `table_name` (`table_name`)  )
45. DROP TABLE IF EXISTS hosxp_ddl_index
46. CREATE TABLE IF NOT EXISTS `hosxp_ddl_field` (   `table_name` VARCHAR(150) NOT NULL DEFAULT "",  `field_name` VARCHAR(150) NOT NULL DEFAULT "",  `field_type_mysql` VARCHAR(100) DEFAULT NULL,  `field_type_postgresql` VARCHAR(100) DEFAULT NULL,  `field_type_mssql` VARCHAR(100) DEFAULT NULL,  `field_type_interbase` VARCHAR(100) DEFAULT NULL,  `field_width` INT(11) DEFAULT NULL,  `field_null` VARCHAR(10) DEFAULT NULL,  `field_number` INT(11) DEFAULT NULL,  `field_primary` CHAR(1) DEFAULT NULL,  `field_type_oracle` VARCHAR(150) DEFAULT NULL,  `field_type_native` VARCHAR(100) DEFAULT NULL,  `field_precision` INT(11) DEFAULT NULL,  `field_precision_text` VARCHAR(100) DEFAULT NULL,  PRIMARY KEY  (`table_name`,`field_name`),  KEY `field_name` (`field_name`),  KEY `table_name` (`table_name`)  )
47. DROP TABLE IF EXISTS hosxp_ddl_field
48. UPDATE hosxp_dll_field DATA ...
49. CHANGE pk ON TABLE stock_item_balance_history --> stock_item_balance_history_id
50. CHANGE pk ON TABLE stock_item_month_rate --> stock_item_month_rate_id
51.