Daily build 3.51.5.25

[jdadmin1]

กำลังทดสอบ น่าจะแก้ปัญหาหลาย ๆ อย่างใน 3.51.5.23 แล้ว

โค๊ด: SQL

1. ALTER TABLE roomno  ADD `room_status_type_id` INT NULL  
2. ALTER TABLE room_status_type  ADD `room_status_type_name` VARCHAR(150) NOT NULL  
3. ALTER TABLE person_genogram  ADD `genogram_data` longblob NULL  
4. ALTER TABLE pcu_age_alert  ADD `alert_text` VARCHAR(250) NULL  
5. ALTER TABLE pcu_age_alert  ADD `max_age` INT NOT NULL  
6. ALTER TABLE pcu_age_alert  ADD `min_age` INT NOT NULL  
7. ALTER TABLE opitemrece_idr  ADD `unit_name` VARCHAR(50) NULL  
8. ALTER TABLE opitemrece_idr  ADD `idr` VARCHAR(30) NULL  
9. ALTER TABLE opitemrece_idr  ADD `iperday` INT NULL  
10. ALTER TABLE opitemrece_idr  ADD `iperdose` DOUBLE(15,3) NULL  
11. ALTER TABLE lab_items  ADD `memo_line_count` INT NULL  
12. ALTER TABLE lab_items  ADD `report_edit_style` VARCHAR(25) NULL  
13. ALTER TABLE ipt_ward_stat  ADD `admit_hour` INT NULL  
14. ALTER TABLE ipt_ward_stat  ADD `admdate` INT NULL  
15. ALTER TABLE ipt_ward_stat  ADD `ward` VARCHAR(4) NULL  
16. ALTER TABLE ipt_ward_stat  ADD `an` VARCHAR(9) NOT NULL  
17. ALTER TABLE ipt_summary_queue  ADD `summary_datetime` datetime NULL  
18. ALTER TABLE ipt_summary_queue  ADD `summary_queue_status_id` INT NULL  
19. ALTER TABLE ipt_summary_queue  ADD `queue_date` DATE NULL  
20. ALTER TABLE ipt_summary_queue  ADD `doctor` VARCHAR(7) NOT NULL  
21. ALTER TABLE ipt_summary_queue  ADD `an` VARCHAR(9) NOT NULL  
22. ALTER TABLE idr_description  ADD `ba_meal_text` VARCHAR(50) NULL  
23. ALTER TABLE idr_description  ADD `override_meal_text` VARCHAR(200) NULL  
24. ALTER TABLE idr_description  ADD `prefix_route` VARCHAR(50) NULL  
25. ALTER TABLE dxa_cc_pdf  ADD `pdf_data` longblob NULL  
26. ALTER TABLE dxa_cc_pdf  ADD `dxa_cc_id` INT NULL  
27. ALTER TABLE bedno  ADD `bed_status_type_id` INT NULL  
28. ALTER TABLE bed_status_type  ADD `bed_status_type_name` VARCHAR(150) NOT NULL  
29. CREATE TABLE room_status_type ( `room_status_type_id` INT NOT NULL  )
30. CREATE TABLE person_genogram ( `person_id` INT NOT NULL  )
31. CREATE TABLE pcu_age_alert ( `pcu_age_alert_id` INT NOT NULL  )
32. CREATE TABLE opitemrece_idr ( `hos_guid` VARCHAR(38) NOT NULL  )
33. CREATE TABLE ipt_ward_stat ( `ipt_ward_stat_id` INT NOT NULL  )
34. CREATE TABLE ipt_summary_queue ( `ipt_summary_queue_id` INT NOT NULL  )
35. CREATE TABLE idr_description ( `idr` VARCHAR(30) NOT NULL  )
36. CREATE TABLE dxa_cc_pdf ( `dxa_cc_pdf_id` INT NOT NULL  )
37. CREATE TABLE bed_status_type ( `bed_status_type_id` INT NOT NULL  )
38.  
39.  
40.  

[doramon]