1 CREATE TABLE IF NOT EXISTS `form_CAMOS` (
2 id bigint(20) NOT NULL auto_increment,
3 date datetime default NULL,
4 pid bigint(20) default NULL,
5 user varchar(255) default NULL,
6 groupname varchar(255) default NULL,
7 authorized tinyint(4) default NULL,
8 activity tinyint(4) default NULL,
17 CREATE TABLE IF NOT EXISTS `form_CAMOS_category` (
18 id bigint(20) NOT NULL auto_increment,
19 date datetime default NULL,
20 pid bigint(20) default NULL,
21 user varchar(255) default NULL,
22 groupname varchar(255) default NULL,
23 authorized tinyint(4) default NULL,
24 activity tinyint(4) default NULL,
31 CREATE TABLE IF NOT EXISTS `form_CAMOS_subcategory` (
32 id bigint(20) NOT NULL auto_increment,
33 date datetime default NULL,
34 pid bigint(20) default NULL,
35 user varchar(255) default NULL,
36 groupname varchar(255) default NULL,
37 authorized tinyint(4) default NULL,
38 activity tinyint(4) default NULL,
41 category_id bigint(20) NOT NULL,
46 CREATE TABLE IF NOT EXISTS `form_CAMOS_item` (
47 id bigint(20) NOT NULL auto_increment,
48 date datetime default NULL,
49 pid bigint(20) default NULL,
50 user varchar(255) default NULL,
51 groupname varchar(255) default NULL,
52 authorized tinyint(4) default NULL,
53 activity tinyint(4) default NULL,
57 subcategory_id bigint(20) NOT NULL,
63 #### START SQL DUMP DATA ######
68 -- Host: localhost Database: openemr
69 -- ------------------------------------------------------
70 -- Server version 4.1.10a-standard
72 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
73 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
74 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
75 /*!40101 SET NAMES utf8 */;
76 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
77 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
78 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
81 -- Table structure for table `form_CAMOS_category`
84 DROP TABLE IF EXISTS `form_CAMOS_category`;
85 CREATE TABLE `form_CAMOS_category` (
86 `id` bigint(20) NOT NULL auto_increment,
87 `date` datetime default NULL,
88 `pid` bigint(20) default NULL,
89 `user` varchar(255) default NULL,
90 `groupname` varchar(255) default NULL,
91 `authorized` tinyint(4) default NULL,
92 `activity` tinyint(4) default NULL,
98 -- Dumping data for table `form_CAMOS_category`
102 /*!40000 ALTER TABLE `form_CAMOS_category` DISABLE KEYS */;
103 LOCK TABLES `form_CAMOS_category` WRITE;
104 INSERT INTO `form_CAMOS_category` VALUES (13,NULL,NULL,NULL,NULL,NULL,NULL,'prescriptions'),(14,NULL,NULL,NULL,NULL,NULL,NULL,'referrals'),(15,NULL,NULL,NULL,NULL,NULL,NULL,'radiology'),(16,NULL,NULL,NULL,NULL,NULL,NULL,'exam'),(17,NULL,NULL,NULL,NULL,NULL,NULL,'text fragments');
106 /*!40000 ALTER TABLE `form_CAMOS_category` ENABLE KEYS */;
109 -- Table structure for table `form_CAMOS_subcategory`
112 DROP TABLE IF EXISTS `form_CAMOS_subcategory`;
113 CREATE TABLE `form_CAMOS_subcategory` (
114 `id` bigint(20) NOT NULL auto_increment,
115 `date` datetime default NULL,
116 `pid` bigint(20) default NULL,
117 `user` varchar(255) default NULL,
118 `groupname` varchar(255) default NULL,
119 `authorized` tinyint(4) default NULL,
120 `activity` tinyint(4) default NULL,
122 `category_id` bigint(20) NOT NULL default '0',
127 -- Dumping data for table `form_CAMOS_subcategory`
131 /*!40000 ALTER TABLE `form_CAMOS_subcategory` DISABLE KEYS */;
132 LOCK TABLES `form_CAMOS_subcategory` WRITE;
133 INSERT INTO `form_CAMOS_subcategory` VALUES (90,NULL,NULL,NULL,NULL,NULL,NULL,'by dx',16),(91,NULL,NULL,NULL,NULL,NULL,NULL,'antibiotics',13),(92,NULL,NULL,NULL,NULL,NULL,NULL,'analgesics',13),(93,NULL,NULL,NULL,NULL,NULL,NULL,'orthopedics',14),(94,NULL,NULL,NULL,NULL,NULL,NULL,'cardiology',14),(95,NULL,NULL,NULL,NULL,NULL,NULL,'endocrinology',14),(96,NULL,NULL,NULL,NULL,NULL,NULL,'MRI',15),(97,NULL,NULL,NULL,NULL,NULL,NULL,'X-Ray',15),(98,NULL,NULL,NULL,NULL,NULL,NULL,'prescription',17),(99,NULL,NULL,NULL,NULL,NULL,NULL,'physical',17),(100,NULL,NULL,NULL,NULL,NULL,NULL,'htn',13);
135 /*!40000 ALTER TABLE `form_CAMOS_subcategory` ENABLE KEYS */;
138 -- Table structure for table `form_CAMOS_item`
141 DROP TABLE IF EXISTS `form_CAMOS_item`;
142 CREATE TABLE `form_CAMOS_item` (
143 `id` bigint(20) NOT NULL auto_increment,
144 `date` datetime default NULL,
145 `pid` bigint(20) default NULL,
146 `user` varchar(255) default NULL,
147 `groupname` varchar(255) default NULL,
148 `authorized` tinyint(4) default NULL,
149 `activity` tinyint(4) default NULL,
152 `subcategory_id` bigint(20) NOT NULL default '0',
157 -- Dumping data for table `form_CAMOS_item`
161 /*!40000 ALTER TABLE `form_CAMOS_item` DISABLE KEYS */;
162 LOCK TABLES `form_CAMOS_item` WRITE;
163 INSERT INTO `form_CAMOS_item` VALUES (259,NULL,NULL,NULL,NULL,NULL,NULL,'tonsillitis','',90),(260,NULL,NULL,NULL,NULL,NULL,NULL,'basic normal 01','/* This is just an example, not necessarily a good example! */\r\nGeneral: Alert and Oriented x 3, in no\r\n apparent distress.\r\nHEENT: Head is normocephalic, atraumatic,\r\n Ears are unremarkable, Throat unremarkable\r\nNeck: Supple, no carotid bruits ausc.\r\nHeart: Regular rate and rhythm, no murmurs, rubs,\r\n or gallops ausc.\r\nLungs: Clear, no wheezes, rales, or rhonchi\r\nAbdomen: Soft, non-tender, bowel sounds present x 4q\r\nNeuro: CN II->XII grossly intact\r\n',99),(261,NULL,NULL,NULL,NULL,NULL,NULL,'health checkup','Routine physical exam\r\n\r\n/*replace::basic normal 01*/\r\n\r\nAssessment:\r\n\r\nv70.0\r\n\r\nPlan:\r\n\r\nfollow up prn.',90),(262,NULL,NULL,NULL,NULL,NULL,NULL,'30 tablets qd','dispense: #30/thirty tablets.\r\n\r\nsig: Take one tablet by mouth once daily.',98),(263,NULL,NULL,NULL,NULL,NULL,NULL,'atenolol','Atenolol 25mg\r\n\r\n/*replace::30 tablets qd*/',100),(264,NULL,NULL,NULL,NULL,NULL,NULL,'90 tablets qd','dispense: #90/ninety tablets.\r\n\r\nsig: Take one tablet by mouth once daily.',98);
165 /*!40000 ALTER TABLE `form_CAMOS_item` ENABLE KEYS */;
167 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
168 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
169 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
170 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
171 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
172 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;