HOSXP 3.50.8.31

[naj]

post แทน อ.อ๊อด

โค๊ด: SQL

1. ALTER TABLE web_pwd  ADD `passweb` VARCHAR(250) NULL  
2. ALTER TABLE web_conf  ADD `theme` VARCHAR(250) NULL  
3. ALTER TABLE web_conf  ADD `header` VARCHAR(1) NULL  
4. ALTER TABLE web_conf  ADD `startrev` DATE NULL  
5. ALTER TABLE web_conf  ADD `auditor` VARCHAR(250) NULL  
6. ALTER TABLE users_account  ADD `Status_social_secure` CHAR(1) NOT NULL  
7. ALTER TABLE users_account  ADD `Status_Access` CHAR(1) NOT NULL  
8. ALTER TABLE users_account  ADD `NoBank_Account` VARCHAR(20) NOT NULL  
9. ALTER TABLE spclty  ADD `oldcode` VARCHAR(10) NULL  
10. ALTER TABLE risk_user_access  ADD `UserAccess` text NOT NULL  
11. ALTER TABLE risk_typelist2  ADD `list_name2` text NOT NULL  
12. ALTER TABLE risk_typelist1  ADD `list_name1` text NOT NULL  
13. ALTER TABLE risk_type  ADD `typename` text NOT NULL  
14. ALTER TABLE risk_report_web  ADD `form_rm` text NOT NULL  
15. ALTER TABLE risk_report_web  ADD `idm` INT NULL  
16. ALTER TABLE risk_report_web  ADD `idc` INT NULL  
17. ALTER TABLE risk_report_web  ADD `type_list` INT NULL  
18. ALTER TABLE risk_report_web  ADD `type` INT NULL  
19. ALTER TABLE risk_report_web  ADD `freq` INT NULL  
20. ALTER TABLE risk_report_web  ADD `all_date_review` longtext NULL  
21. ALTER TABLE risk_report_web  ADD `result_follow` longtext NULL  
22. ALTER TABLE risk_report_web  ADD `respond_level_depart` longtext NULL  
23. ALTER TABLE risk_report_web  ADD `info_system` longtext NULL  
24. ALTER TABLE risk_report_web  ADD `edit_basic` longtext NULL  
25. ALTER TABLE risk_report_web  ADD `review_detail` longtext NULL  
26. ALTER TABLE risk_report_web  ADD `review_staff` VARCHAR(25) NULL  
27. ALTER TABLE risk_report_web  ADD `review_date_time` datetime NULL  
28. ALTER TABLE risk_report_web  ADD `review_status` CHAR(1) NULL  
29. ALTER TABLE risk_report_web  ADD `report_user` VARCHAR(25) NULL  
30. ALTER TABLE risk_report_web  ADD `risk_detail` longtext NULL  
31. ALTER TABLE risk_report_web  ADD `relation_program` VARCHAR(50) NULL  
32. ALTER TABLE risk_report_web  ADD `risk_level` CHAR(1) NULL  
33. ALTER TABLE risk_report_web  ADD `subject` VARCHAR(250) NULL  
34. ALTER TABLE risk_report_web  ADD `department_id` INT NULL  
35. ALTER TABLE risk_report_web  ADD `report_date_time` datetime NOT NULL  
36. ALTER TABLE risk_cause  ADD `name` text NULL  
37. ALTER TABLE risk_can_manage  ADD `mname` text NOT NULL  
38. ALTER TABLE reporttemplate  ADD `script_dfm` longtext NULL  
39. ALTER TABLE medication_err  ADD `level_code` CHAR(1) NOT NULL  
40. ALTER TABLE medication_err  ADD `cause` VARCHAR(250) NOT NULL  
41. ALTER TABLE medication_err  ADD `adminis_err` VARCHAR(250) NOT NULL  
42. ALTER TABLE medication_err  ADD `dispens_err` VARCHAR(250) NOT NULL  
43. ALTER TABLE medication_err  ADD `order_process_err` VARCHAR(250) NOT NULL  
44. ALTER TABLE medication_err  ADD `prescrib_err` VARCHAR(250) NOT NULL  
45. ALTER TABLE medication_err  ADD `detail_err` VARCHAR(250) NOT NULL  
46. ALTER TABLE medication_err  ADD `patient_type` CHAR(3) NOT NULL  
47. ALTER TABLE medication_err  ADD `err_time` TIME NOT NULL  
48. ALTER TABLE medication_err  ADD `err_date` DATE NOT NULL  
49. ALTER TABLE medication_err  ADD `err_time_report` TIME NOT NULL  
50. ALTER TABLE medication_err  ADD `err_date_report` DATE NOT NULL  
51. ALTER TABLE medication_err  ADD `depart_code` CHAR(3) NOT NULL  
52. ALTER TABLE medication_err  ADD `user_err` VARCHAR(250) NOT NULL  
53. ALTER TABLE level_err  ADD `detail` VARCHAR(250) NOT NULL  
54. ALTER TABLE dttm_inc  ADD `inc_code` VARCHAR(7) NOT NULL  
55. ALTER TABLE dttm_inc  ADD `code` VARCHAR(7) NOT NULL  
56. ALTER TABLE dttm  ADD `charge_per_qty` CHAR(1) NULL  
57. ALTER TABLE detail_account  ADD `syear` VARCHAR(4) NOT NULL  
58. ALTER TABLE detail_account  ADD `mouth` VARCHAR(2) NOT NULL  
59. ALTER TABLE detail_account  ADD `total` DOUBLE(15,2) NOT NULL  
60. ALTER TABLE detail_account  ADD `social_secure` DOUBLE(15,2) NOT NULL  
61. ALTER TABLE detail_account  ADD `valve_all` DOUBLE(15,2) NOT NULL  
62. ALTER TABLE detail_account  ADD `credit_car` DOUBLE(15,2) NOT NULL  
63. ALTER TABLE detail_account  ADD `off_country` DOUBLE(15,2) NOT NULL  
64. ALTER TABLE detail_account  ADD `insurance` DOUBLE(15,2) NOT NULL  
65. ALTER TABLE detail_account  ADD `life_insurance` DOUBLE(15,2) NOT NULL  
66. ALTER TABLE detail_account  ADD `credit_saving_bank` DOUBLE(15,2) NOT NULL  
67. ALTER TABLE detail_account  ADD `to_help_die` DOUBLE(15,2) NOT NULL  
68. ALTER TABLE detail_account  ADD `gpf_gratuity` DOUBLE(15,2) NOT NULL  
69. ALTER TABLE detail_account  ADD `tax` DOUBLE(15,2) NOT NULL  
70. ALTER TABLE detail_account  ADD `goverment_bank` DOUBLE(15,2) NOT NULL  
71. ALTER TABLE detail_account  ADD `money_position` DOUBLE(15,2) NOT NULL  
72. ALTER TABLE detail_account  ADD `child_educated` DOUBLE(15,2) NOT NULL  
73. ALTER TABLE detail_account  ADD `rent_home` DOUBLE(15,2) NOT NULL  
74. ALTER TABLE detail_account  ADD `to_treat` DOUBLE(15,2) NOT NULL  
75. ALTER TABLE detail_account  ADD `help_child` DOUBLE(15,2) NOT NULL  
76. ALTER TABLE detail_account  ADD `to_risk` DOUBLE(15,2) NOT NULL  
77. ALTER TABLE detail_account  ADD `to_retaliate` DOUBLE(15,2) NOT NULL  
78. ALTER TABLE detail_account  ADD `class` DOUBLE(15,2) NOT NULL  
79. ALTER TABLE approve_doctor  ADD `date_appr` DATE NULL  
80. ALTER TABLE approve_doctor  ADD `comment_appr` text NULL  
81. ALTER TABLE approve_doctor  ADD `chkcomment7` CHAR(1) NULL  
82. ALTER TABLE approve_doctor  ADD `chkcomment6` CHAR(1) NULL  
83. ALTER TABLE approve_doctor  ADD `chkcomment5` CHAR(1) NULL  
84. ALTER TABLE approve_doctor  ADD `chkcomment4` CHAR(1) NULL  
85. ALTER TABLE approve_doctor  ADD `chkcomment3` CHAR(1) NULL  
86. ALTER TABLE approve_doctor  ADD `chkcomment2` CHAR(1) NULL  
87. ALTER TABLE approve_doctor  ADD `chkcomment1` CHAR(1) NULL  
88. ALTER TABLE approve_doctor  ADD `approve_doctor` CHAR(1) NULL  
89. ALTER TABLE approve_doctor  ADD `command_doctor` VARCHAR(4) NULL  
90. ALTER TABLE approve_doctor  ADD `vstdate` DATE NULL  
91. ALTER TABLE approve_doctor  ADD `hn` VARCHAR(9) NULL  
92. CREATE TABLE web_pwd ( `loginname` VARCHAR(250) NOT NULL  )
93. CREATE TABLE web_conf ( `icdedit` VARCHAR(250) NULL  )
94. CREATE TABLE users_account ( `UserID` VARCHAR(50) NOT NULL  )
95. CREATE TABLE risk_user_access ( `loginname` VARCHAR(250) NOT NULL  )
96. CREATE TABLE risk_typelist2 ( `idl2` INT NOT NULL  )
97. CREATE TABLE risk_typelist1 ( `idl1` INT NOT NULL  )
98. CREATE TABLE risk_type ( `idt` INT NOT NULL  )
99. CREATE TABLE risk_report_web ( `risk_id` INT NOT NULL  )
100. CREATE TABLE risk_cause ( `idc` INT NOT NULL  )
101. CREATE TABLE risk_can_manage ( `idm` INT NOT NULL  )
102. CREATE TABLE medication_err ( `err_id` INT NOT NULL  )
103. CREATE TABLE level_err ( `level_code` CHAR(1) NOT NULL  )
104. CREATE TABLE dttm_inc ( `dttm_inc_id` INT NOT NULL  )
105. CREATE TABLE detail_account ( `UserID` VARCHAR(50) NOT NULL  )
106. CREATE TABLE approve_doctor ( `vn` VARCHAR(13) NOT NULL  )
107.  

[SrWooD]

รับทราบครับ

[por]

  เพิ่มรายการมาเยะเหมือนกันนะครับ

[doramon]

ไม่ทันเลย  ขนาดว่างนะนี้