Public paste
Dump
By: Xmoo | Date: Nov 30 2008 17:35 | Format: None | Expires: never | Size: 64 KB | Hits: 1303

  1. -- phpMyAdmin SQL Dump
  2. -- version 2.10.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generatie Tijd: 30 Nov 2008 om 18:34
  7. -- Server versie: 5.0.41
  8. -- PHP Versie: 5.2.2
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12. --
  13. -- Database: `caredb`
  14. --
  15.  
  16. -- --------------------------------------------------------
  17.  
  18. --
  19. -- Tabel structuur voor tabel `care_address_citytown`
  20. --
  21.  
  22. CREATE TABLE `care_address_citytown` (
  23.   `nr` mediumint(8) unsigned NOT NULL auto_increment,
  24.   `unece_modifier` char(2) collate latin1_general_ci default NULL,
  25.   `unece_locode` varchar(15) collate latin1_general_ci default NULL,
  26.   `name` varchar(100) collate latin1_general_ci NOT NULL default '',
  27.   `zip_code` varchar(25) collate latin1_general_ci default NULL,
  28.   `iso_country_id` char(3) collate latin1_general_ci NOT NULL default '',
  29.   `unece_locode_type` tinyint(3) unsigned default NULL,
  30.   `unece_coordinates` varchar(25) collate latin1_general_ci default NULL,
  31.   `info_url` varchar(255) collate latin1_general_ci default NULL,
  32.   `use_frequency` bigint(20) unsigned NOT NULL default '0',
  33.   `status` varchar(25) collate latin1_general_ci default NULL,
  34.   `history` text collate latin1_general_ci NOT NULL,
  35.   `modify_id` varchar(35) collate latin1_general_ci NOT NULL default '',
  36.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  37.   `create_id` varchar(35) collate latin1_general_ci NOT NULL default '',
  38.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  39.   PRIMARY KEY  (`nr`),
  40.   KEY `name` (`name`)
  41. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;
  42.  
  43. --
  44. -- Gegevens worden uitgevoerd voor tabel `care_address_citytown`
  45. --
  46.  
  47. INSERT INTO `care_address_citytown` VALUES (1, NULL, NULL, 'Eindhoven', '5632', '040', NULL, NULL, 'http://www.eindhoven.nl', 0, NULL, '', '', '2008-11-19 15:38:30', '', '0000-00-00 00:00:00');
  48.  
  49. -- --------------------------------------------------------
  50.  
  51. --
  52. -- Tabel structuur voor tabel `care_appointment`
  53. --
  54.  
  55. CREATE TABLE `care_appointment` (
  56.   `nr` bigint(20) unsigned NOT NULL auto_increment,
  57.   `pid` int(11) NOT NULL default '0',
  58.   `date` date NOT NULL default '0000-00-00',
  59.   `time` time NOT NULL default '00:00:00',
  60.   `to_dept_id` varchar(25) collate latin1_general_ci NOT NULL,
  61.   `to_dept_nr` smallint(5) unsigned NOT NULL default '0',
  62.   `to_personell_nr` int(11) NOT NULL default '0',
  63.   `to_personell_name` varchar(60) collate latin1_general_ci default NULL,
  64.   `purpose` text collate latin1_general_ci NOT NULL,
  65.   `urgency` tinyint(2) unsigned NOT NULL default '0',
  66.   `remind` tinyint(1) unsigned NOT NULL default '0',
  67.   `remind_email` tinyint(1) unsigned NOT NULL default '0',
  68.   `remind_mail` tinyint(1) unsigned NOT NULL default '0',
  69.   `remind_phone` tinyint(1) unsigned NOT NULL default '0',
  70.   `appt_status` varchar(35) collate latin1_general_ci NOT NULL default 'pending',
  71.   `cancel_by` varchar(255) collate latin1_general_ci NOT NULL,
  72.   `cancel_date` date default NULL,
  73.   `cancel_reason` varchar(255) collate latin1_general_ci default NULL,
  74.   `encounter_class_nr` int(1) NOT NULL default '0',
  75.   `encounter_nr` int(11) NOT NULL default '0',
  76.   `status` varchar(25) collate latin1_general_ci NOT NULL,
  77.   `history` text collate latin1_general_ci NOT NULL,
  78.   `modify_id` varchar(35) collate latin1_general_ci NOT NULL,
  79.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  80.   `create_id` varchar(35) collate latin1_general_ci NOT NULL,
  81.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  82.   PRIMARY KEY  (`nr`),
  83.   KEY `pid` (`pid`)
  84. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
  85.  
  86. --
  87. -- Gegevens worden uitgevoerd voor tabel `care_appointment`
  88. --
  89.  
  90.  
  91. -- --------------------------------------------------------
  92.  
  93. --
  94. -- Tabel structuur voor tabel `care_billing_archive`
  95. --
  96.  
  97. CREATE TABLE `care_billing_archive` (
  98.   `bill_no` bigint(20) NOT NULL default '0',
  99.   `encounter_nr` int(10) NOT NULL default '0',
  100.   `patient_name` tinytext collate latin1_general_ci NOT NULL,
  101.   `vorname` varchar(35) collate latin1_general_ci NOT NULL default '0',
  102.   `bill_date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  103.   `bill_amt` double(16,4) NOT NULL default '0.0000',
  104.   `payment_date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  105.   `payment_mode` text collate latin1_general_ci NOT NULL,
  106.   `cheque_no` varchar(10) collate latin1_general_ci NOT NULL default '0',
  107.   `creditcard_no` varchar(10) collate latin1_general_ci NOT NULL default '0',
  108.   `paid_by` varchar(15) collate latin1_general_ci NOT NULL default '0',
  109.   PRIMARY KEY  (`bill_no`)
  110. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  111.  
  112. --
  113. -- Gegevens worden uitgevoerd voor tabel `care_billing_archive`
  114. --
  115.  
  116.  
  117. -- --------------------------------------------------------
  118.  
  119. --
  120. -- Tabel structuur voor tabel `care_billing_bill`
  121. --
  122.  
  123. CREATE TABLE `care_billing_bill` (
  124.   `bill_bill_no` bigint(20) NOT NULL default '0',
  125.   `bill_encounter_nr` int(10) unsigned NOT NULL default '0',
  126.   `bill_date_time` date default NULL,
  127.   `bill_amount` float(10,2) default NULL,
  128.   `bill_outstanding` float(10,2) default NULL,
  129.   PRIMARY KEY  (`bill_bill_no`),
  130.   KEY `index_bill_patnum` (`bill_encounter_nr`)
  131. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  132.  
  133. --
  134. -- Gegevens worden uitgevoerd voor tabel `care_billing_bill`
  135. --
  136.  
  137.  
  138. -- --------------------------------------------------------
  139.  
  140. --
  141. -- Tabel structuur voor tabel `care_billing_bill_item`
  142. --
  143.  
  144. CREATE TABLE `care_billing_bill_item` (
  145.   `bill_item_id` int(11) NOT NULL auto_increment,
  146.   `bill_item_encounter_nr` int(10) unsigned NOT NULL default '0',
  147.   `bill_item_code` varchar(5) collate latin1_general_ci default NULL,
  148.   `bill_item_unit_cost` float(10,2) default '0.00',
  149.   `bill_item_units` tinyint(4) default NULL,
  150.   `bill_item_amount` float(10,2) default NULL,
  151.   `bill_item_date` datetime default NULL,
  152.   `bill_item_status` enum('0','1') collate latin1_general_ci default '0',
  153.   `bill_item_bill_no` int(11) NOT NULL default '0',
  154.   PRIMARY KEY  (`bill_item_id`),
  155.   KEY `index_bill_item_patnum` (`bill_item_encounter_nr`),
  156.   KEY `index_bill_item_bill_no` (`bill_item_bill_no`)
  157. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
  158.  
  159. --
  160. -- Gegevens worden uitgevoerd voor tabel `care_billing_bill_item`
  161. --
  162.  
  163.  
  164. -- --------------------------------------------------------
  165.  
  166. --
  167. -- Tabel structuur voor tabel `care_billing_final`
  168. --
  169.  
  170. CREATE TABLE `care_billing_final` (
  171.   `final_id` tinyint(3) NOT NULL auto_increment,
  172.   `final_encounter_nr` int(10) unsigned NOT NULL default '0',
  173.   `final_bill_no` int(11) default NULL,
  174.   `final_date` date default NULL,
  175.   `final_total_bill_amount` float(10,2) default NULL,
  176.   `final_discount` tinyint(4) default NULL,
  177.   `final_total_receipt_amount` float(10,2) default NULL,
  178.   `final_amount_due` float(10,2) default NULL,
  179.   `final_amount_recieved` float(10,2) default NULL,
  180.   PRIMARY KEY  (`final_id`),
  181.   KEY `index_final_patnum` (`final_encounter_nr`)
  182. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
  183.  
  184. --
  185. -- Gegevens worden uitgevoerd voor tabel `care_billing_final`
  186. --
  187.  
  188.  
  189. -- --------------------------------------------------------
  190.  
  191. --
  192. -- Tabel structuur voor tabel `care_billing_item`
  193. --
  194.  
  195. CREATE TABLE `care_billing_item` (
  196.   `item_code` varchar(5) collate latin1_general_ci NOT NULL,
  197.   `item_description` varchar(100) collate latin1_general_ci default NULL,
  198.   `item_unit_cost` float(10,2) default '0.00',
  199.   `item_type` tinytext collate latin1_general_ci,
  200.   `item_discount_max_allowed` tinyint(4) unsigned default '0',
  201.   PRIMARY KEY  (`item_code`)
  202. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  203.  
  204. --
  205. -- Gegevens worden uitgevoerd voor tabel `care_billing_item`
  206. --
  207.  
  208.  
  209. -- --------------------------------------------------------
  210.  
  211. --
  212. -- Tabel structuur voor tabel `care_billing_payment`
  213. --
  214.  
  215. CREATE TABLE `care_billing_payment` (
  216.   `payment_id` tinyint(5) NOT NULL auto_increment,
  217.   `payment_encounter_nr` int(10) unsigned NOT NULL default '0',
  218.   `payment_receipt_no` int(11) NOT NULL default '0',
  219.   `payment_date` datetime default '0000-00-00 00:00:00',
  220.   `payment_cash_amount` float(10,2) default '0.00',
  221.   `payment_cheque_no` int(11) default '0',
  222.   `payment_cheque_amount` float(10,2) default '0.00',
  223.   `payment_creditcard_no` int(25) default '0',
  224.   `payment_creditcard_amount` float(10,2) default '0.00',
  225.   `payment_amount_total` float(10,2) default '0.00',
  226.   PRIMARY KEY  (`payment_id`),
  227.   KEY `index_payment_patnum` (`payment_encounter_nr`),
  228.   KEY `index_payment_receipt_no` (`payment_receipt_no`)
  229. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
  230.  
  231. --
  232. -- Gegevens worden uitgevoerd voor tabel `care_billing_payment`
  233. --
  234.  
  235.  
  236. -- --------------------------------------------------------
  237.  
  238. --
  239. -- Tabel structuur voor tabel `care_cache`
  240. --
  241.  
  242. CREATE TABLE `care_cache` (
  243.   `id` varchar(125) collate latin1_general_ci NOT NULL,
  244.   `ctext` text collate latin1_general_ci,
  245.   `cbinary` blob,
  246.   `tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  247.   PRIMARY KEY  (`id`)
  248. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  249.  
  250. --
  251. -- Gegevens worden uitgevoerd voor tabel `care_cache`
  252. --
  253.  
  254.  
  255. -- --------------------------------------------------------
  256.  
  257. --
  258. -- Tabel structuur voor tabel `care_cafe_menu`
  259. --
  260.  
  261. CREATE TABLE `care_cafe_menu` (
  262.   `item` int(11) NOT NULL auto_increment,
  263.   `lang` varchar(10) collate latin1_general_ci NOT NULL default 'en',
  264.   `cdate` date NOT NULL default '0000-00-00',
  265.   `menu` text collate latin1_general_ci NOT NULL,
  266.   `modify_id` varchar(35) collate latin1_general_ci NOT NULL,
  267.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  268.   `create_id` varchar(35) collate latin1_general_ci NOT NULL,
  269.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  270.   UNIQUE KEY `item_2` (`item`),
  271.   KEY `item` (`item`,`lang`),
  272.   KEY `cdate` (`cdate`)
  273. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
  274.  
  275. --
  276. -- Gegevens worden uitgevoerd voor tabel `care_cafe_menu`
  277. --
  278.  
  279.  
  280. -- --------------------------------------------------------
  281.  
  282. --
  283. -- Tabel structuur voor tabel `care_cafe_prices`
  284. --
  285.  
  286. CREATE TABLE `care_cafe_prices` (
  287.   `item` int(11) NOT NULL auto_increment,
  288.   `lang` varchar(10) collate latin1_general_ci NOT NULL default 'en',
  289.   `productgroup` tinytext collate latin1_general_ci NOT NULL,
  290.   `article` tinytext collate latin1_general_ci NOT NULL,
  291.   `description` tinytext collate latin1_general_ci NOT NULL,
  292.   `price` varchar(10) collate latin1_general_ci NOT NULL,
  293.   `unit` tinytext collate latin1_general_ci NOT NULL,
  294.   `pic_filename` tinytext collate latin1_general_ci NOT NULL,
  295.   `modify_id` varchar(25) collate latin1_general_ci NOT NULL,
  296.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  297.   `create_id` varchar(25) collate latin1_general_ci NOT NULL,
  298.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  299.   KEY `item` (`item`),
  300.   KEY `lang` (`lang`)
  301. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
  302.  
  303. --
  304. -- Gegevens worden uitgevoerd voor tabel `care_cafe_prices`
  305. --
  306.  
  307.  
  308. -- --------------------------------------------------------
  309.  
  310. --
  311. -- Tabel structuur voor tabel `care_category_diagnosis`
  312. --
  313.  
  314. CREATE TABLE `care_category_diagnosis` (
  315.   `nr` tinyint(3) unsigned NOT NULL default '0',
  316.   `category` varchar(35) collate latin1_general_ci NOT NULL,
  317.   `name` varchar(35) collate latin1_general_ci NOT NULL,
  318.   `LD_var` varchar(35) collate latin1_general_ci NOT NULL,
  319.   `short_code` char(1) collate latin1_general_ci NOT NULL,
  320.   `LD_var_short_code` varchar(25) collate latin1_general_ci NOT NULL,
  321.   `description` varchar(255) collate latin1_general_ci NOT NULL,
  322.   `hide_from` varchar(255) collate latin1_general_ci NOT NULL default '0',
  323.   `status` varchar(25) collate latin1_general_ci NOT NULL,
  324.   `history` text collate latin1_general_ci NOT NULL,
  325.   `modify_id` varchar(35) collate latin1_general_ci NOT NULL,
  326.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  327.   `create_id` varchar(35) collate latin1_general_ci NOT NULL,
  328.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  329.   PRIMARY KEY  (`nr`)
  330. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  331.  
  332. --
  333. -- Gegevens worden uitgevoerd voor tabel `care_category_diagnosis`
  334. --
  335.  
  336. INSERT INTO `care_category_diagnosis` VALUES (1, 'most_responsible', 'Most responsible', 'LDMostResponsible', 'M', 'LDMostResp_s', 'Most responsible diagnosis, must be only one per admission or visit', '0', '', '', '', '2003-05-25 12:09:56', '', '0000-00-00 00:00:00');
  337. INSERT INTO `care_category_diagnosis` VALUES (2, 'associated', 'Associated', 'LDAssociated', 'A', 'LDAssociated_s', 'Associated diagnosis, can be several per  admission or visit', '0', '', '', '', '2003-05-25 12:10:05', '', '0000-00-00 00:00:00');
  338. INSERT INTO `care_category_diagnosis` VALUES (3, 'nosocomial', 'Hospital acquired', 'LDNosocomial', 'N', 'LDNosocomial_s', 'Hospital acquired problem, can be several per admission or visit', '0', '', '', '', '2003-05-25 12:10:15', '', '0000-00-00 00:00:00');
  339. INSERT INTO `care_category_diagnosis` VALUES (4, 'iatrogenic', 'Iatrogenic', 'LDIatrogenic', 'I', 'LDIatrogenic_s', 'Problem resulting from a procedural/surgical complication or medication mistake', '0', '', '', '', '2003-05-25 12:10:25', '', '0000-00-00 00:00:00');
  340. INSERT INTO `care_category_diagnosis` VALUES (5, 'other', 'Other', 'LDOther', 'O', 'LDOther_s', 'Other  diagnosis', '0', '', '', '', '2003-05-25 12:10:33', '', '0000-00-00 00:00:00');
  341.  
  342. -- --------------------------------------------------------
  343.  
  344. --
  345. -- Tabel structuur voor tabel `care_category_disease`
  346. --
  347.  
  348. CREATE TABLE `care_category_disease` (
  349.   `nr` tinyint(3) unsigned NOT NULL auto_increment,
  350.   `group_nr` tinyint(3) unsigned NOT NULL default '0',
  351.   `category` varchar(35) collate latin1_general_ci NOT NULL,
  352.   `name` varchar(35) collate latin1_general_ci NOT NULL,
  353.   `LD_var` varchar(35) collate latin1_general_ci NOT NULL,
  354.   `status` varchar(25) collate latin1_general_ci NOT NULL,
  355.   `modify_id` varchar(35) collate latin1_general_ci NOT NULL,
  356.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  357.   `create_id` varchar(35) collate latin1_general_ci NOT NULL,
  358.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  359.   PRIMARY KEY  (`nr`)
  360. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;
  361.  
  362. --
  363. -- Gegevens worden uitgevoerd voor tabel `care_category_disease`
  364. --
  365.  
  366. INSERT INTO `care_category_disease` VALUES (1, 2, 'asphyxia', 'Asphyxia', 'LDAsphyxia', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  367. INSERT INTO `care_category_disease` VALUES (2, 2, 'infection', 'Infection', 'LDInfection', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  368. INSERT INTO `care_category_disease` VALUES (3, 2, 'congenital_abnomality', 'Congenital abnormality', 'LDCongenitalAbnormality', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  369. INSERT INTO `care_category_disease` VALUES (4, 2, 'trauma', 'Trauma', 'LDTrauma', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  370.  
  371. -- --------------------------------------------------------
  372.  
  373. --
  374. -- Tabel structuur voor tabel `care_category_procedure`
  375. --
  376.  
  377. CREATE TABLE `care_category_procedure` (
  378.   `nr` tinyint(3) unsigned NOT NULL default '0',
  379.   `category` varchar(35) collate latin1_general_ci NOT NULL,
  380.   `name` varchar(35) collate latin1_general_ci NOT NULL,
  381.   `LD_var` varchar(35) collate latin1_general_ci NOT NULL,
  382.   `short_code` char(1) collate latin1_general_ci NOT NULL,
  383.   `LD_var_short_code` varchar(25) collate latin1_general_ci NOT NULL,
  384.   `description` varchar(255) collate latin1_general_ci NOT NULL,
  385.   `hide_from` varchar(255) collate latin1_general_ci NOT NULL default '0',
  386.   `status` varchar(25) collate latin1_general_ci NOT NULL,
  387.   `history` text collate latin1_general_ci NOT NULL,
  388.   `modify_id` varchar(35) collate latin1_general_ci NOT NULL,
  389.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  390.   `create_id` varchar(35) collate latin1_general_ci NOT NULL,
  391.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  392.   PRIMARY KEY  (`nr`)
  393. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  394.  
  395. --
  396. -- Gegevens worden uitgevoerd voor tabel `care_category_procedure`
  397. --
  398.  
  399. INSERT INTO `care_category_procedure` VALUES (1, 'main', 'Main', 'LDMain', 'M', 'LDMain_s', 'Main procedure, must be only one per op or intervention visit', '0', '', '', '', '2003-06-14 01:35:08', '', '0000-00-00 00:00:00');
  400. INSERT INTO `care_category_procedure` VALUES (2, 'supplemental', 'Supplemental', 'LDSupplemental', 'S', 'LDSupp_s', 'Supplemental procedure, can be several per  encounter op or intervention or visit', '0', '', '', '', '2003-06-14 01:53:24', '', '0000-00-00 00:00:00');
  401.  
  402. -- --------------------------------------------------------
  403.  
  404. --
  405. -- Tabel structuur voor tabel `care_classif_neonatal`
  406. --
  407.  
  408. CREATE TABLE `care_classif_neonatal` (
  409.   `nr` smallint(2) unsigned NOT NULL auto_increment,
  410.   `id` varchar(35) collate latin1_general_ci NOT NULL,
  411.   `name` varchar(35) collate latin1_general_ci NOT NULL,
  412.   `LD_var` varchar(35) collate latin1_general_ci NOT NULL,
  413.   `description` varchar(255) collate latin1_general_ci default NULL,
  414.   `status` varchar(25) collate latin1_general_ci NOT NULL,
  415.   `modify_id` varchar(35) collate latin1_general_ci NOT NULL,
  416.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  417.   `create_id` varchar(35) collate latin1_general_ci NOT NULL,
  418.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  419.   PRIMARY KEY  (`nr`),
  420.   UNIQUE KEY `id` (`id`)
  421. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=17 ;
  422.  
  423. --
  424. -- Gegevens worden uitgevoerd voor tabel `care_classif_neonatal`
  425. --
  426.  
  427. INSERT INTO `care_classif_neonatal` VALUES (1, 'jaundice', 'Neonatal jaundice', 'LDNeonatalJaundice', NULL, '', '', '2003-08-07 12:57:31', '', '0000-00-00 00:00:00');
  428. INSERT INTO `care_classif_neonatal` VALUES (2, 'x_transfusion', 'Exchange transfusion', 'LDExchangeTransfusion', NULL, '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  429. INSERT INTO `care_classif_neonatal` VALUES (3, 'photo_therapy', 'Photo therapy', 'LDPhotoTherapy', NULL, '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  430. INSERT INTO `care_classif_neonatal` VALUES (4, 'h_i_encep', 'Hypoxic ischaemic encephalopathy', 'LDH_I_Encephalopathy', NULL, '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  431. INSERT INTO `care_classif_neonatal` VALUES (5, 'parenteral', 'Parenteral nutrition', 'LDParenteralNutrition', NULL, '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  432. INSERT INTO `care_classif_neonatal` VALUES (6, 'vent_support', 'Ventilatory support', 'LDVentilatorySupport', NULL, '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  433. INSERT INTO `care_classif_neonatal` VALUES (7, 'oxygen_therapy', 'Oxygen therapy', 'LDOxygenTherapy', NULL, '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  434. INSERT INTO `care_classif_neonatal` VALUES (8, 'cpap', 'CPAP', 'LDCPAP', 'Continuous positive airway pressure', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  435. INSERT INTO `care_classif_neonatal` VALUES (9, 'congenital_abnormality', 'Congenital abnormality', 'LDCongenitalAbnormality', NULL, '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  436. INSERT INTO `care_classif_neonatal` VALUES (10, 'congenital_infection', 'Congenital infection', 'LDCongenitalInfection', NULL, '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  437. INSERT INTO `care_classif_neonatal` VALUES (11, 'acquired_infection', 'Acquired infection', 'LDAcquiredInfection', NULL, '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  438. INSERT INTO `care_classif_neonatal` VALUES (12, 'gbs_infection', 'GBS infection', 'LDGBSInfection', 'Group B Strep Infection', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  439. INSERT INTO `care_classif_neonatal` VALUES (13, 'rds', 'Resp Distress Syndrome', 'LDRespDistressSyndrome', NULL, '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  440. INSERT INTO `care_classif_neonatal` VALUES (14, 'blood_transfusion', 'Blood transfusion', 'LDBloodTransfusion', NULL, '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  441. INSERT INTO `care_classif_neonatal` VALUES (15, 'antibiotic_therapy', 'Antibiotic therapy', 'LDAntibioticTherapy', NULL, '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  442. INSERT INTO `care_classif_neonatal` VALUES (16, 'necrotising_enterocolitis', 'Necrotising enterocolitis', 'LDNecrotisingEnterocolitis', NULL, '', '', '2003-08-07 19:17:27', '', '0000-00-00 00:00:00');
  443.  
  444. -- --------------------------------------------------------
  445.  
  446. --
  447. -- Tabel structuur voor tabel `care_class_encounter`
  448. --
  449.  
  450. CREATE TABLE `care_class_encounter` (
  451.   `class_nr` smallint(6) unsigned NOT NULL default '0',
  452.   `class_id` varchar(35) collate latin1_general_ci NOT NULL,
  453.   `name` varchar(35) collate latin1_general_ci NOT NULL,
  454.   `LD_var` varchar(25) collate latin1_general_ci NOT NULL,
  455.   `description` varchar(255) collate latin1_general_ci NOT NULL,
  456.   `hide_from` tinyint(4) NOT NULL default '0',
  457.   `status` varchar(25) collate latin1_general_ci NOT NULL,
  458.   `history` text collate latin1_general_ci NOT NULL,
  459.   `modify_id` varchar(35) collate latin1_general_ci NOT NULL,
  460.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  461.   `create_id` varchar(35) collate latin1_general_ci NOT NULL,
  462.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  463.   PRIMARY KEY  (`class_nr`)
  464. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  465.  
  466. --
  467. -- Gegevens worden uitgevoerd voor tabel `care_class_encounter`
  468. --
  469.  
  470. INSERT INTO `care_class_encounter` VALUES (1, 'inpatient', 'Inpatient', 'LDStationary', 'Inpatient admission - stays at least in a ward and assigned a bed', 0, '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  471. INSERT INTO `care_class_encounter` VALUES (2, 'outpatient', 'Outpatient', 'LDAmbulant', 'Outpatient visit - does not stay in a ward nor assigned a bed', 0, '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  472.  
  473. -- --------------------------------------------------------
  474.  
  475. --
  476. -- Tabel structuur voor tabel `care_class_ethnic_orig`
  477. --
  478.  
  479. CREATE TABLE `care_class_ethnic_orig` (
  480.   `nr` smallint(5) unsigned NOT NULL auto_increment,
  481.   `name` varchar(35) collate latin1_general_ci NOT NULL,
  482.   `LD_var` varchar(35) collate latin1_general_ci NOT NULL,
  483.   `status` varchar(25) collate latin1_general_ci NOT NULL,
  484.   `modify_id` varchar(35) collate latin1_general_ci NOT NULL,
  485.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  486.   `create_id` varchar(35) collate latin1_general_ci NOT NULL,
  487.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  488.   PRIMARY KEY  (`nr`)
  489. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;
  490.  
  491. --
  492. -- Gegevens worden uitgevoerd voor tabel `care_class_ethnic_orig`
  493. --
  494.  
  495. INSERT INTO `care_class_ethnic_orig` VALUES (1, 'race', 'LDRace', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  496. INSERT INTO `care_class_ethnic_orig` VALUES (2, 'country', 'LDCountry', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  497.  
  498. -- --------------------------------------------------------
  499.  
  500. --
  501. -- Tabel structuur voor tabel `care_class_financial`
  502. --
  503.  
  504. CREATE TABLE `care_class_financial` (
  505.   `class_nr` smallint(5) unsigned NOT NULL auto_increment,
  506.   `class_id` varchar(15) collate latin1_general_ci NOT NULL default '0',
  507.   `type` varchar(25) collate latin1_general_ci NOT NULL default '0',
  508.   `code` varchar(5) collate latin1_general_ci NOT NULL,
  509.   `name` varchar(35) collate latin1_general_ci NOT NULL,
  510.   `LD_var` varchar(25) collate latin1_general_ci NOT NULL,
  511.   `description` varchar(255) collate latin1_general_ci NOT NULL,
  512.   `policy` text collate latin1_general_ci NOT NULL,
  513.   `status` varchar(25) collate latin1_general_ci NOT NULL,
  514.   `history` text collate latin1_general_ci NOT NULL,
  515.   `modify_id` varchar(35) collate latin1_general_ci NOT NULL,
  516.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  517.   `create_id` varchar(35) collate latin1_general_ci NOT NULL,
  518.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  519.   PRIMARY KEY  (`class_nr`),
  520.   KEY `class_2` (`class_id`)
  521. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=13 ;
  522.  
  523. --
  524. -- Gegevens worden uitgevoerd voor tabel `care_class_financial`
  525. --
  526.  
  527. INSERT INTO `care_class_financial` VALUES (1, 'care_c', 'care', 'c', 'common', 'LDcommon', 'Common nursing care services. (Non-private)', 'Patient with common health fund insurance policy.', '', '', '', '2002-12-29 13:40:50', '', '0000-00-00 00:00:00');
  528. INSERT INTO `care_class_financial` VALUES (2, 'care_pc', 'care', 'p/c', 'private + common', 'LDprivatecommon', 'Private services added to common services', 'Patient with common health fund insurancernpolicy with additional private insurance policyrnOR self paying components.', '', '', '', '2002-12-29 13:44:51', '', '2002-12-29 13:44:51');
  529. INSERT INTO `care_class_financial` VALUES (3, 'care_p', 'care', 'p', 'private', 'LDprivate', 'Private nursing care services', 'Patient with private insurance policyrnOR self paying.', 'LDprivate', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  530. INSERT INTO `care_class_financial` VALUES (4, 'care_pp', 'care', 'pp', 'private plus', 'LDprivateplus', '"Very private" nursing care services', 'Patient with private health insurance policyrnAND self paying components.', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  531. INSERT INTO `care_class_financial` VALUES (5, 'room_c', 'room', 'c', 'common', 'LDcommon', 'Common room services (non-private)', 'Patient with common health fund insurance policy. ', 'LDcommon', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  532. INSERT INTO `care_class_financial` VALUES (6, 'room_pc', 'room', 'p/c', 'private + common', '', 'Private services added to common services', 'Patient with common health fund insurance policy with additional private insurance policy OR self paying components.', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  533. INSERT INTO `care_class_financial` VALUES (7, 'room_p', 'room', 'p', 'private', '', 'Private room services', 'Patient with private insurance policy OR self paying. ', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  534. INSERT INTO `care_class_financial` VALUES (8, 'room_pp', 'room', 'pp', 'private plus', '', '"Very private" room services', 'Patient with private health insurance policy AND self paying components.', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  535. INSERT INTO `care_class_financial` VALUES (9, 'att_dr_c', 'att_dr', 'c', 'common', '', 'Common clinician services', 'Patient with common health fund insurance policy. ', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  536. INSERT INTO `care_class_financial` VALUES (10, 'att_dr_pc', 'att_dr', 'p/c', 'private + common', '', 'Private services added to common clinician services', 'Patient with common health fund insurance policy with additional private insurance policy OR self paying components.', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  537. INSERT INTO `care_class_financial` VALUES (11, 'att_dr_p', 'att_dr', 'p', 'private', '', 'Private clinician services', 'Patient with private insurance policy OR self paying.', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  538. INSERT INTO `care_class_financial` VALUES (12, 'att_dr_pp', 'att_dr', 'pp', 'private plus', '', '"Very private" clinician services', 'Patient with private health insurance policy AND self paying components.', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  539.  
  540. -- --------------------------------------------------------
  541.  
  542. --
  543. -- Tabel structuur voor tabel `care_class_insurance`
  544. --
  545.  
  546. CREATE TABLE `care_class_insurance` (
  547.   `class_nr` smallint(5) unsigned NOT NULL auto_increment,
  548.   `class_id` varchar(35) collate latin1_general_ci NOT NULL,
  549.   `name` varchar(35) collate latin1_general_ci NOT NULL,
  550.   `LD_var` varchar(25) collate latin1_general_ci NOT NULL,
  551.   `description` varchar(255) collate latin1_general_ci NOT NULL,
  552.   `status` varchar(25) collate latin1_general_ci NOT NULL,
  553.   `history` text collate latin1_general_ci NOT NULL,
  554.   `modify_id` varchar(35) collate latin1_general_ci NOT NULL,
  555.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  556.   `create_id` varchar(35) collate latin1_general_ci NOT NULL,
  557.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  558.   PRIMARY KEY  (`class_nr`)
  559. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;
  560.  
  561. --
  562. -- Gegevens worden uitgevoerd voor tabel `care_class_insurance`
  563. --
  564.  
  565. INSERT INTO `care_class_insurance` VALUES (1, 'private', 'Private', 'LDPrivate', 'Private insurance plan (paid by insured alone)', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  566. INSERT INTO `care_class_insurance` VALUES (2, 'common', 'Health Fund', 'LDInsurance', 'Public (common) health fund - usually paid both by the insured and his employer, eventually paid by the state', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  567. INSERT INTO `care_class_insurance` VALUES (3, 'self_pay', 'Self pay', 'LDSelfPay', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  568.  
  569. -- --------------------------------------------------------
  570.  
  571. --
  572. -- Tabel structuur voor tabel `care_class_therapy`
  573. --
  574.  
  575. CREATE TABLE `care_class_therapy` (
  576.   `nr` smallint(5) unsigned NOT NULL auto_increment,
  577.   `group_nr` tinyint(3) unsigned NOT NULL default '0',
  578.   `class` varchar(35) collate latin1_general_ci NOT NULL,
  579.   `name` varchar(35) collate latin1_general_ci NOT NULL,
  580.   `LD_var` varchar(25) collate latin1_general_ci NOT NULL,
  581.   `description` varchar(255) collate latin1_general_ci NOT NULL,
  582.   `status` varchar(25) collate latin1_general_ci NOT NULL,
  583.   `modify_id` varchar(35) collate latin1_general_ci NOT NULL,
  584.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  585.   `create_id` varchar(35) collate latin1_general_ci NOT NULL,
  586.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  587.   PRIMARY KEY  (`nr`)
  588. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=9 ;
  589.  
  590. --
  591. -- Gegevens worden uitgevoerd voor tabel `care_class_therapy`
  592. --
  593.  
  594. INSERT INTO `care_class_therapy` VALUES (1, 2, 'photo', 'Phototherapy', 'LDPhototherapy', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  595. INSERT INTO `care_class_therapy` VALUES (2, 2, 'iv', 'IV Fluids', 'LDIVFluids', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  596. INSERT INTO `care_class_therapy` VALUES (3, 2, 'oxygen', 'Oxygen therapy', 'LDOxygenTherapy', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  597. INSERT INTO `care_class_therapy` VALUES (4, 2, 'cpap', 'CPAP', 'LDCPAP', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  598. INSERT INTO `care_class_therapy` VALUES (5, 2, 'ippv', 'IPPV', 'LDIPPV', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  599. INSERT INTO `care_class_therapy` VALUES (6, 2, 'nec', 'NEC', 'LDNEC', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  600. INSERT INTO `care_class_therapy` VALUES (7, 2, 'tpn', 'TPN', 'LDTPN', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  601. INSERT INTO `care_class_therapy` VALUES (8, 2, 'hie', 'HIE', 'LDHIE', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  602.  
  603. -- --------------------------------------------------------
  604.  
  605. --
  606. -- Tabel structuur voor tabel `care_complication`
  607. --
  608.  
  609. CREATE TABLE `care_complication` (
  610.   `nr` int(10) unsigned NOT NULL auto_increment,
  611.   `group_nr` int(11) unsigned NOT NULL default '0',
  612.   `name` varchar(35) collate latin1_general_ci NOT NULL,
  613.   `LD_var` varchar(35) collate latin1_general_ci NOT NULL,
  614.   `code` varchar(25) collate latin1_general_ci default NULL,
  615.   `description` varchar(255) collate latin1_general_ci NOT NULL,
  616.   `status` varchar(25) collate latin1_general_ci NOT NULL,
  617.   `modify_id` varchar(35) collate latin1_general_ci NOT NULL,
  618.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  619.   `create_id` varchar(35) collate latin1_general_ci NOT NULL,
  620.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  621.   PRIMARY KEY  (`nr`)
  622. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=17 ;
  623.  
  624. --
  625. -- Gegevens worden uitgevoerd voor tabel `care_complication`
  626. --
  627.  
  628. INSERT INTO `care_complication` VALUES (1, 1, 'Previous C/S', 'LDPreviousCS', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  629. INSERT INTO `care_complication` VALUES (2, 1, 'Pre-eclampsia', 'LDPreEclampsia', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  630. INSERT INTO `care_complication` VALUES (3, 1, 'Eclampsia', 'LDEclampsia', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  631. INSERT INTO `care_complication` VALUES (4, 1, 'Other hypertension', 'LDOtherHypertension', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  632. INSERT INTO `care_complication` VALUES (5, 1, 'Other proteinuria', 'LDProteinuria', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  633. INSERT INTO `care_complication` VALUES (6, 1, 'Cardiac', 'LDCardiac', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  634. INSERT INTO `care_complication` VALUES (7, 1, 'Anaemia < 8.5g', 'LDAnaemia', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  635. INSERT INTO `care_complication` VALUES (8, 1, 'Asthma', 'LDAsthma', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  636. INSERT INTO `care_complication` VALUES (9, 1, 'Epilepsy', 'LDEpilepsy', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  637. INSERT INTO `care_complication` VALUES (10, 1, 'Placenta praevia', 'LDPlacentaPraevia', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  638. INSERT INTO `care_complication` VALUES (11, 1, 'Abruptio placentae', 'LDAbruptioPlacentae', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  639. INSERT INTO `care_complication` VALUES (12, 1, 'Other APH', 'LDOtherAPH', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  640. INSERT INTO `care_complication` VALUES (13, 1, 'Diabetes', 'LDDiabetes', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  641. INSERT INTO `care_complication` VALUES (14, 1, 'Cord prolapse', 'LDCordProlapse', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  642. INSERT INTO `care_complication` VALUES (15, 1, 'Ruptured uterus', 'LDRupturedUterus', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  643. INSERT INTO `care_complication` VALUES (16, 1, 'Extrauterine pregnancy', 'LDExtraUterinePregnancy', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  644.  
  645. -- --------------------------------------------------------
  646.  
  647. --
  648. -- Tabel structuur voor tabel `care_config_global`
  649. --
  650.  
  651. CREATE TABLE `care_config_global` (
  652.   `type` varchar(60) collate latin1_general_ci NOT NULL,
  653.   `value` varchar(255) collate latin1_general_ci default NULL,
  654.   `notes` varchar(255) collate latin1_general_ci default NULL,
  655.   `status` varchar(25) collate latin1_general_ci NOT NULL,
  656.   `history` text collate latin1_general_ci NOT NULL,
  657.   `modify_id` varchar(35) collate latin1_general_ci NOT NULL,
  658.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  659.   `create_id` varchar(35) collate latin1_general_ci NOT NULL,
  660.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  661.   PRIMARY KEY  (`type`)
  662. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  663.  
  664. --
  665. -- Gegevens worden uitgevoerd voor tabel `care_config_global`
  666. --
  667.  
  668. INSERT INTO `care_config_global` VALUES ('date_format', 'dd/MM/yyyy', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  669. INSERT INTO `care_config_global` VALUES ('time_format', 'HH.MM', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  670. INSERT INTO `care_config_global` VALUES ('patient_reg_nr_adder', '10000000', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  671. INSERT INTO `care_config_global` VALUES ('main_info_police_nr', '11?', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  672. INSERT INTO `care_config_global` VALUES ('main_info_fire_dept_nr', '12?', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  673. INSERT INTO `care_config_global` VALUES ('main_info_emgcy_nr', '13?', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  674. INSERT INTO `care_config_global` VALUES ('main_info_phone', '1234567', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  675. INSERT INTO `care_config_global` VALUES ('main_info_fax', '567890', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  676. INSERT INTO `care_config_global` VALUES ('main_info_address', 'Virtualstr. 89AArnCyberia 89300rnLas Vegas County', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  677. INSERT INTO `care_config_global` VALUES ('main_info_email', 'contact@care2x.com', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  678. INSERT INTO `care_config_global` VALUES ('person_id_nr_adder', '10000000', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  679. INSERT INTO `care_config_global` VALUES ('patient_outpatient_nr_adder', '500000', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  680. INSERT INTO `care_config_global` VALUES ('patient_inpatient_nr_adder', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  681. INSERT INTO `care_config_global` VALUES ('person_name_2_hide', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  682. INSERT INTO `care_config_global` VALUES ('person_name_3_hide', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  683. INSERT INTO `care_config_global` VALUES ('person_name_middle_hide', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  684. INSERT INTO `care_config_global` VALUES ('person_name_maiden_hide', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  685. INSERT INTO `care_config_global` VALUES ('person_ethnic_orig_hide', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  686. INSERT INTO `care_config_global` VALUES ('person_name_others_hide', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  687. INSERT INTO `care_config_global` VALUES ('person_nat_id_nr_hide', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  688. INSERT INTO `care_config_global` VALUES ('person_religion_hide', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  689. INSERT INTO `care_config_global` VALUES ('person_cellphone_2_nr_hide', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  690. INSERT INTO `care_config_global` VALUES ('person_phone_2_nr_hide', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  691. INSERT INTO `care_config_global` VALUES ('person_citizenship_hide', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  692. INSERT INTO `care_config_global` VALUES ('person_sss_nr_hide', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  693. INSERT INTO `care_config_global` VALUES ('language_default', 'en', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  694. INSERT INTO `care_config_global` VALUES ('language_single', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  695. INSERT INTO `care_config_global` VALUES ('mascot_hide', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  696. INSERT INTO `care_config_global` VALUES ('mascot_style', 'default', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  697. INSERT INTO `care_config_global` VALUES ('gui_frame_left_nav_width', '150', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  698. INSERT INTO `care_config_global` VALUES ('gui_frame_left_nav_border', '1', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  699. INSERT INTO `care_config_global` VALUES ('news_fotos_path', 'fotos/news/', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  700. INSERT INTO `care_config_global` VALUES ('news_headline_title_font_size', '5', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  701. INSERT INTO `care_config_global` VALUES ('news_headline_title_font_face', 'arial,verdana,helvetica,sans serif', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  702. INSERT INTO `care_config_global` VALUES ('news_headline_title_font_color', '#CC3333', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  703. INSERT INTO `care_config_global` VALUES ('news_headline_preface_font_size', '2', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  704. INSERT INTO `care_config_global` VALUES ('news_headline_preface_font_face', 'arial,verdana,helvetica,sans serif', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  705. INSERT INTO `care_config_global` VALUES ('news_headline_preface_font_color', '#336666', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  706. INSERT INTO `care_config_global` VALUES ('news_headline_body_font_size', '2', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  707. INSERT INTO `care_config_global` VALUES ('news_headline_body_font_face', 'arial,verdana,helvetica,sans serif', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  708. INSERT INTO `care_config_global` VALUES ('news_headline_body_font_color', '#000033', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  709. INSERT INTO `care_config_global` VALUES ('news_normal_preview_maxlen', '600', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  710. INSERT INTO `care_config_global` VALUES ('news_headline_title_font_bold', '1', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  711. INSERT INTO `care_config_global` VALUES ('news_headline_preface_font_bold', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  712. INSERT INTO `care_config_global` VALUES ('news_normal_display_width', '100%', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  713. INSERT INTO `care_config_global` VALUES ('person_fax_hide', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  714. INSERT INTO `care_config_global` VALUES ('person_email_hide', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  715. INSERT INTO `care_config_global` VALUES ('person_phone_1_nr_hide', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  716. INSERT INTO `care_config_global` VALUES ('person_cellphone_1_nr_hide', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  717. INSERT INTO `care_config_global` VALUES ('person_foto_path', 'fotos/registration/', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  718. INSERT INTO `care_config_global` VALUES ('patient_service_care_hide', '1', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  719. INSERT INTO `care_config_global` VALUES ('patient_service_room_hide', '1', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  720. INSERT INTO `care_config_global` VALUES ('patient_service_att_dr_hide', '1', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  721. INSERT INTO `care_config_global` VALUES ('patient_financial_class_single_result', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  722. INSERT INTO `care_config_global` VALUES ('patient_name_2_show', '1', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  723. INSERT INTO `care_config_global` VALUES ('patient_name_3_show', '1', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  724. INSERT INTO `care_config_global` VALUES ('patient_name_middle_show', '1', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  725. INSERT INTO `care_config_global` VALUES ('theme_control_buttons', 'default', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  726. INSERT INTO `care_config_global` VALUES ('gui_frame_left_nav_bdcolor', '#990000', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  727. INSERT INTO `care_config_global` VALUES ('theme_control_theme_list', 'default,blue_aqua', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  728. INSERT INTO `care_config_global` VALUES ('medocs_text_preview_maxlen', '100', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  729. INSERT INTO `care_config_global` VALUES ('personell_nr_adder', '100000', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  730. INSERT INTO `care_config_global` VALUES ('notes_preview_maxlen', '120', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  731. INSERT INTO `care_config_global` VALUES ('person_id_nr_init', '10000000', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  732. INSERT INTO `care_config_global` VALUES ('personell_nr_init', '100000', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  733. INSERT INTO `care_config_global` VALUES ('encounter_nr_init', '000000', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  734. INSERT INTO `care_config_global` VALUES ('encounter_nr_fullyear_prepend', '1', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  735. INSERT INTO `care_config_global` VALUES ('theme_mascot', 'default', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  736. INSERT INTO `care_config_global` VALUES ('pagin_address_list_max_block_rows', '20', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  737. INSERT INTO `care_config_global` VALUES ('pagin_address_search_max_block_rows', '25', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  738. INSERT INTO `care_config_global` VALUES ('pagin_insurance_list_max_block_rows', '30', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  739. INSERT INTO `care_config_global` VALUES ('pagin_insurance_search_max_block_rows', '25', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  740. INSERT INTO `care_config_global` VALUES ('pagin_personell_search_max_block_rows', '20', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  741. INSERT INTO `care_config_global` VALUES ('pagin_person_search_max_block_rows', '20', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  742. INSERT INTO `care_config_global` VALUES ('pagin_personell_list_max_block_rows', '20', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  743. INSERT INTO `care_config_global` VALUES ('pagin_patient_search_max_block_rows', '20', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  744. INSERT INTO `care_config_global` VALUES ('pagin_or_patient_search_max_block_rows', '5', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  745. INSERT INTO `care_config_global` VALUES ('timeout_inactive', '0', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  746. INSERT INTO `care_config_global` VALUES ('timeout_time', '001500', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  747. INSERT INTO `care_config_global` VALUES ('person_title_hide', '0', NULL, 'normal', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  748. INSERT INTO `care_config_global` VALUES ('person_bloodgroup_hide', '0', NULL, 'normal', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  749. INSERT INTO `care_config_global` VALUES ('person_civilstatus_hide', '0', NULL, 'normal', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  750. INSERT INTO `care_config_global` VALUES ('person_insurance_hide', '0', NULL, 'normal', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  751. INSERT INTO `care_config_global` VALUES ('person_other_his_nr_hide', '0', NULL, 'normal', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  752.  
  753. -- --------------------------------------------------------
  754.  
  755. --
  756. -- Tabel structuur voor tabel `care_config_user`
  757. --
  758.  
  759. CREATE TABLE `care_config_user` (
  760.   `user_id` varchar(100) collate latin1_general_ci NOT NULL,
  761.   `serial_config_data` text collate latin1_general_ci NOT NULL,
  762.   `notes` varchar(255) collate latin1_general_ci default NULL,
  763.   `status` varchar(25) collate latin1_general_ci NOT NULL,
  764.   `history` text collate latin1_general_ci,
  765.   `modify_id` varchar(35) collate latin1_general_ci NOT NULL,
  766.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  767.   `create_id` varchar(35) collate latin1_general_ci NOT NULL,
  768.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  769.   PRIMARY KEY  (`user_id`)
  770. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  771.  
  772. --
  773. -- Gegevens worden uitgevoerd voor tabel `care_config_user`
  774. --
  775.  
  776. INSERT INTO `care_config_user` VALUES ('default', 'a:19:{s:4:"mask";s:1:"1";s:11:"idx_bgcolor";s:7:"#99ccff";s:12:"idx_txtcolor";s:7:"#000066";s:9:"idx_hover";s:7:"#ffffcc";s:9:"idx_alink";s:7:"#ffffff";s:11:"top_bgcolor";s:7:"#99ccff";s:12:"top_txtcolor";s:7:"#330066";s:12:"body_bgcolor";s:7:"#ffffff";s:13:"body_txtcolor";s:7:"#000066";s:10:"body_hover";s:7:"#cc0033";s:10:"body_alink";s:7:"#cc0000";s:11:"bot_bgcolor";s:7:"#cccccc";s:12:"bot_txtcolor";s:4:"gray";s:5:"bname";s:0:"";s:8:"bversion";s:0:"";s:2:"ip";s:0:"";s:3:"cid";s:0:"";s:5:"dhtml";s:1:"1";s:4:"lang";s:0:"";}', 'default values', 'normal', 'installed', 'auto-installer', '0000-00-00 00:00:00', 'auto-installer', '0000-00-00 00:00:00');
  777.  
  778. -- --------------------------------------------------------
  779.  
  780. --
  781. -- Tabel structuur voor tabel `care_currency`
  782. --
  783.  
  784. CREATE TABLE `care_currency` (
  785.   `item_no` smallint(5) unsigned NOT NULL auto_increment,
  786.   `short_name` varchar(5) collate latin1_general_ci NOT NULL,
  787.   `long_name` varchar(20) collate latin1_general_ci NOT NULL,
  788.   `info` varchar(50) collate latin1_general_ci NOT NULL,
  789.   `status` varchar(5) collate latin1_general_ci NOT NULL,
  790.   `modify_id` varchar(20) collate latin1_general_ci NOT NULL,
  791.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  792.   `create_id` varchar(20) collate latin1_general_ci NOT NULL,
  793.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  794.   KEY `item_no` (`item_no`),
  795.   KEY `short_name` (`short_name`)
  796. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=14 ;
  797.  
  798. --
  799. -- Gegevens worden uitgevoerd voor tabel `care_currency`
  800. --
  801.  
  802. INSERT INTO `care_currency` VALUES (13, '?', 'Euro', 'European currency', 'main', 'Elpidio Latorilla', '2003-08-02 19:06:37', '', '2002-11-26 20:05:34');
  803. INSERT INTO `care_currency` VALUES (3, 'L', 'Pound', 'GB British Pound (ISO = GBP)', '', '', '2003-02-13 17:31:07', '', '2002-08-16 23:03:49');
  804. INSERT INTO `care_currency` VALUES (10, 'R', 'Rand', 'South African Rand (ISO = ZAR)', '', '', '2003-08-02 19:06:37', 'Elpidio Latorilla', '2002-08-17 17:18:05');
  805. INSERT INTO `care_currency` VALUES (8, 'R', 'Rupees', 'Indian Rupees (ISO = INR)', '', '', '2003-02-13 17:30:59', 'Elpidio Latorilla', '2002-09-20 23:43:06');
  806.  
  807. -- --------------------------------------------------------
  808.  
  809. --
  810. -- Tabel structuur voor tabel `care_department`
  811. --
  812.  
  813. CREATE TABLE `care_department` (
  814.   `nr` mediumint(8) unsigned NOT NULL auto_increment,
  815.   `id` varchar(60) collate latin1_general_ci NOT NULL,
  816.   `type` varchar(25) collate latin1_general_ci NOT NULL,
  817.   `name_formal` varchar(60) collate latin1_general_ci NOT NULL,
  818.   `name_short` varchar(35) collate latin1_general_ci NOT NULL,
  819.   `name_alternate` varchar(225) collate latin1_general_ci default NULL,
  820.   `LD_var` varchar(35) collate latin1_general_ci NOT NULL,
  821.   `description` text collate latin1_general_ci NOT NULL,
  822.   `admit_inpatient` tinyint(1) NOT NULL default '0',
  823.   `admit_outpatient` tinyint(1) NOT NULL default '0',
  824.   `has_oncall_doc` tinyint(1) NOT NULL default '1',
  825.   `has_oncall_nurse` tinyint(1) NOT NULL default '1',
  826.   `does_surgery` tinyint(1) NOT NULL default '0',
  827.   `this_institution` tinyint(1) NOT NULL default '1',
  828.   `is_sub_dept` tinyint(1) NOT NULL default '0',
  829.   `parent_dept_nr` tinyint(3) unsigned default NULL,
  830.   `work_hours` varchar(100) collate latin1_general_ci default NULL,
  831.   `consult_hours` varchar(100) collate latin1_general_ci default NULL,
  832.   `is_inactive` tinyint(1) NOT NULL default '0',
  833.   `sort_order` tinyint(3) unsigned NOT NULL default '0',
  834.   `address` text collate latin1_general_ci,
  835.   `sig_line` varchar(60) collate latin1_general_ci default NULL,
  836.   `sig_stamp` text collate latin1_general_ci,
  837.   `logo_mime_type` varchar(5) collate latin1_general_ci default NULL,
  838.   `status` varchar(25) collate latin1_general_ci NOT NULL,
  839.   `history` text collate latin1_general_ci,
  840.   `modify_id` varchar(35) collate latin1_general_ci NOT NULL,
  841.   `modify_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  842.   `create_id` varchar(35) collate latin1_general_ci NOT NULL,
  843.   `create_time` timestamp NOT NULL default '0000-00-00 00:00:00',
  844.   PRIMARY KEY  (`nr`),
  845.   UNIQUE KEY `id` (`id`)
  846. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=42 ;
  847.  
  848. --
  849. -- Gegevens worden uitgevoerd voor tabel `care_department`
  850. --
  851.  
  852. INSERT INTO `care_department` VALUES (1, 'pr', '2', 'Public Relations', 'PR', 'Press Relations', 'LDPressRelations', '', 0, 0, 1, 1, 0, 1, 0, 0, '', '', 0, 0, NULL, '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  853. INSERT INTO `care_department` VALUES (2, 'cafe', '2', 'Cafeteria', 'Cafe', 'Canteen', 'LDCafeteria', '', 0, 0, 1, 1, 0, 1, 0, 0, '', '', 0, 0, NULL, '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  854. INSERT INTO `care_department` VALUES (3, 'general_surgery', '1', 'General Surgery', 'General', 'General', 'LDGeneralSurgery', '', 1, 1, 1, 1, 1, 1, 0, 0, '8.30 - 21.00', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, '', '', '', '', '', '', '', '2003-08-28 11:43:27', '', '0000-00-00 00:00:00');
  855. INSERT INTO `care_department` VALUES (4, 'emergency_surgery', '1', 'Emergency Surgery', 'Emergency', '', 'LDEmergencySurgery', '', 1, 1, 1, 1, 1, 1, 0, 0, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, NULL, '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  856. INSERT INTO `care_department` VALUES (5, 'plastic_surgery', '1', 'Plastic Surgery', 'Plastic', 'Aesthetic Surgery', 'LDPlasticSurgery', '', 1, 1, 1, 1, 1, 1, 0, 0, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, NULL, '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  857. INSERT INTO `care_department` VALUES (6, 'ent', '1', 'Ear-Nose-Throath', 'ENT', 'HNO', 'LDEarNoseThroath', 'Ear-Nose-Throath, in german Hals-Nasen-Ohren. The department with  very old traditions that date back to the early beginnings of premodern medicine.', 1, 1, 1, 1, 1, 1, 0, 0, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, NULL, '', 'kope akjdielj asdlkasdf', '', '', 'Update: 2003-08-13 23:24:16 Elpidio LatorillarnUpdate: 2003-08-13 23:25:27 Elpidio LatorillarnUpdate: 2003-08-13 23:29:05 Elpidio LatorillarnUpdate: 2003-08-13 23:30:21 Elpidio LatorillarnUpdate: 2003-08-13 23:31:52 Elpidio LatorillarnUpdate: 2003-08-13 23:34:08 Elpidio Latorillarn', 'Elpidio Latorilla', '2003-10-19 15:53:46', '', '0000-00-00 00:00:00');
  858. INSERT INTO `care_department` VALUES (7, 'opthalmology', '1', 'Opthalmology', 'Opthalmology', 'Eye Department', 'LDOpthalmology', '', 1, 1, 1, 1, 1, 1, 0, 0, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, NULL, '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  859. INSERT INTO `care_department` VALUES (8, 'pathology', '1', 'Pathology', 'Pathology', 'Patho', 'LDPathology', '', 0, 0, 1, 1, 0, 1, 0, 0, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  860. INSERT INTO `care_department` VALUES (9, 'ob_gyn', '1', 'Ob-Gynecology', 'Ob-Gyne', 'Gyn', 'LDObGynecology', '', 1, 1, 1, 1, 1, 1, 0, 0, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, NULL, '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  861. INSERT INTO `care_department` VALUES (10, 'physical_therapy', '1', 'Physical Therapy', 'Physical', 'PT', 'LDPhysicalTherapy', 'Physical therapy department with on-call therapists. Day care clinics, training, rehab.', 1, 0, 1, 1, 0, 1, 1, 16, '8:00 - 15:00', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, '', '', '', '', '', '', '', '2003-08-28 11:43:51', '', '0000-00-00 00:00:00');
  862. INSERT INTO `care_department` VALUES (11, 'internal_med', '1', 'Internal Medicine', 'Internal Med', 'InMed', 'LDInternalMedicine', '', 1, 1, 1, 1, 0, 1, 0, 0, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  863. INSERT INTO `care_department` VALUES (12, 'imc', '1', 'Intermediate Care Unit', 'IMC', 'Intermediate', 'LDIntermediateCareUnit', '', 1, 1, 1, 1, 0, 1, 0, 0, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  864. INSERT INTO `care_department` VALUES (13, 'icu', '1', 'Intensive Care Unit', 'ICU', 'Intensive', 'LDIntensiveCareUnit', '', 1, 1, 1, 1, 0, 1, 0, 0, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  865. INSERT INTO `care_department` VALUES (14, 'emergency_ambulatory', '1', 'Emergency Ambulatory', 'Emergency', 'Emergency Amb', 'LDEmergencyAmbulatory', '', 0, 1, 1, 1, 0, 1, 1, 4, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, '', '', '', '', '', 'Update: 2003-09-23 00:06:27 Elpidio Latorillan', 'Elpidio Latorilla', '2003-09-23 00:06:27', '', '0000-00-00 00:00:00');
  866. INSERT INTO `care_department` VALUES (15, 'general_ambulatory', '1', 'General Ambulatory', 'Ambulatory', 'General Amb', 'LDGeneralAmbulatory', '', 0, 1, 1, 1, 0, 1, 1, 3, 'round the clock', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, '', '', '', '', '', '', '', '2003-08-28 11:42:54', '', '0000-00-00 00:00:00');
  867. INSERT INTO `care_department` VALUES (16, 'inmed_ambulatory', '1', 'Internal Medicine Ambulatory', 'InMed Ambulatory', 'InMed Amb', 'LDInternalMedicineAmbulatory', '', 0, 1, 1, 1, 0, 1, 1, 11, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  868. INSERT INTO `care_department` VALUES (17, 'sonography', '1', 'Sonography', 'Sono', 'Ultrasound diagnostics', 'LDSonography', '', 0, 1, 1, 1, 0, 1, 1, 11, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  869. INSERT INTO `care_department` VALUES (18, 'nuclear_diagnostics', '1', 'Nuclear Diagnostics', 'Nuclear', 'Nuclear Testing', 'LDNuclearDiagnostics', '', 0, 1, 1, 1, 0, 1, 1, 19, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  870. INSERT INTO `care_department` VALUES (19, 'radiology', '1', 'Radiology', 'Radiology', 'Xray', 'LDRadiology', '', 0, 1, 1, 1, 0, 1, 0, 0, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  871. INSERT INTO `care_department` VALUES (20, 'oncology', '1', 'Oncology', 'Oncology', 'Cancer Department', 'LDOncology', '', 1, 1, 1, 1, 1, 1, 0, 11, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, NULL, '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  872. INSERT INTO `care_department` VALUES (21, 'neonatal', '1', 'Neonatal', 'Neonatal', 'Newborn Department', 'LDNeonatal', '', 1, 1, 1, 1, 1, 1, 1, 9, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, NULL, '343', '', '', '', 'Update: 2003-08-13 22:32:07 Elpidio LatorillanUpdate: 2003-08-13 22:33:10 Elpidio LatorillanUpdate: 2003-08-13 22:43:39 Elpidio LatorillanUpdate: 2003-08-13 22:43:59 Elpidio LatorillanUpdate: 2003-08-13 22:44:19 Elpidio Latorillan', 'Elpidio Latorilla', '2003-08-13 22:44:19', '', '0000-00-00 00:00:00');
  873. INSERT INTO `care_department` VALUES (22, 'central_lab', '1', 'Central Laboratory', 'Central Lab', 'General Lab', 'LDCentralLaboratory', '', 0, 0, 1, 1, 0, 1, 0, 0, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, '', '', 'kdkdododospdfjdasljfdarnasdflasdjfrnasdfklasdjflasdjf', '', '', 'Update: 2003-08-13 23:12:30 Elpidio LatorillarnUpdate: 2003-08-13 23:14:59 Elpidio LatorillarnUpdate: 2003-08-13 23:15:28 Elpidio Latorillarn', 'Elpidio Latorilla', '2003-08-28 11:42:43', '', '0000-00-00 00:00:00');
  874. INSERT INTO `care_department` VALUES (23, 'serological_lab', '1', 'Serological Laboratory', 'Serological Lab', 'Serum Lab', 'LDSerologicalLaboratory', '', 0, 1, 1, 1, 0, 1, 1, 22, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  875. INSERT INTO `care_department` VALUES (24, 'chemical_lab', '1', 'Chemical Laboratory', 'Chemical Lab', 'Chem Lab', 'LDChemicalLaboratory', '', 0, 1, 1, 1, 0, 1, 1, 22, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  876. INSERT INTO `care_department` VALUES (25, 'bacteriological_lab', '1', 'Bacteriological Laboratory', 'Bacteriological Lab', 'Bacteria Lab', 'LDBacteriologicalLaboratory', '', 0, 1, 1, 1, 0, 1, 1, 22, '', '12.30 - 15.00 , 19.00 - 21.00', 0, 0, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  877. INSERT INTO `care_department` VALUES (26, 'tech', '2', 'Technical Maintenance', 'Tech', 'Technical Support', 'LDTechnicalMaintenance', '', 0, 0, 1, 1, 0, 1, 0, 0, '', '', 0, 0, '', '', '', 'jpg', '', 'Update: 2003-08-10 23:42:30 Elpidio Latorillan', 'Elpidio Latorilla', '2003-08-10 23:42:30', '', '0000-00-00 00:00:00');
  878. INSERT INTO `care_department` VALUES (27, 'it', '2', 'IT Department', 'IT', 'EDP', 'LDITDepartment', '', 0, 0, 1, 1, 0, 1, 0, 0, '', '', 0, 0, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  879. INSERT INTO `care_department` VALUES (28, 'management', '2', 'Management', 'Management', 'Busines Administration', 'LDManagement', '', 0, 0, 1, 1, 0, 1, 0, 0, '', '', 0, 0, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  880. INSERT INTO `care_department` VALUES (29, 'exhibition', '3', 'Exhibitions', 'Exhibit', 'Showcases', 'LDExhibitions', '', 0, 0, 1, 1, 1, 1, 0, 0, '', '', 0, 0, NULL, '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  881. INSERT INTO `care_department` VALUES (30, 'edu', '3', 'Education', 'Edu', 'Training', 'LDEducation', 'Education news bulletin of the hospital.', 0, 0, 1, 1, 0, 1, 0, 0, '', '', 0, 0, '', '', '', '', '', 'Update: 2003-08-13 22:44:45 Elpidio LatorillanUpdate: 2003-08-13 23:00:37 Elpidio Latorillan', 'Elpidio Latorilla', '2003-08-13 23:00:37', '', '0000-00-00 00:00:00');
  882. INSERT INTO `care_department` VALUES (31, 'study', '3', 'Studies', 'Studies', 'Advance studies or on-the-job training', 'LDStudies', '', 0, 0, 1, 1, 1, 1, 0, 0, '', '', 0, 0, NULL, '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  883. INSERT INTO `care_department` VALUES (32, 'health_tip', '3', 'Health Tips', 'Tips', 'Health Information', 'LDHealthTips', '', 0, 0, 1, 1, 1, 1, 0, 0, '', '', 0, 0, NULL, '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  884. INSERT INTO `care_department` VALUES (33, 'admission', '2', 'Admission', 'Admit', 'Admission information', 'LDAdmission', '', 0, 0, 1, 1, 1, 0, 1, 0, '', '', 0, 0, NULL, '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  885. INSERT INTO `care_department` VALUES (34, 'news_headline', '3', 'Headline', 'News head', 'Major news', 'LDHeadline', '', 0, 0, 1, 1, 1, 1, 0, 0, '', '', 0, 0, NULL, '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  886. INSERT INTO `care_department` VALUES (35, 'cafenews', '3', 'Cafe News', 'Cafe news', 'Cafeteria news', 'LDCafeNews', '', 0, 0, 1, 1, 1, 0, 0, 0, '', '', 0, 0, NULL, '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  887. INSERT INTO `care_department` VALUES (36, 'nursing', '3', 'Nursing', 'Nursing', 'Nursing care', 'LDNursing', '', 1, 1, 1, 1, 1, 1, 1, 0, '', '', 0, 0, NULL, '', '', '', '', '', '', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00');
  888. INSERT INTO `care_department` VALUES (37, 'doctors', '3', 'Doctors', 'Doctors', 'Medical personell', 'LDDoctors', '', 0, 0, 1, 1, 1