1 ## ########################################################
4 ## Table structure for table `lang_constants`
7 CREATE TABLE IF NOT EXISTS `lang_constants` (
8 `cons_id` int(11) NOT NULL auto_increment,
9 `constant_name` varchar(255) NOT NULL default '',
10 UNIQUE KEY `cons_id` (`cons_id`),
11 KEY `cons_name` (`constant_name`)
12 ) ENGINE=MyISAM AUTO_INCREMENT=6 ;
15 ## Dumping data for table `lang_constants`
18 ## ########################################################
21 ## Table structure for table `lang_definitions`
24 CREATE TABLE IF NOT EXISTS `lang_definitions` (
25 `def_id` int(11) NOT NULL auto_increment,
26 `cons_id` int(11) NOT NULL default '0',
27 `lang_id` int(11) NOT NULL default '0',
28 `definition` mediumtext NOT NULL,
29 UNIQUE KEY `def_id` (`def_id`),
30 KEY `definition` (`definition`(100))
34 ## Dumping data for table `lang_definitions`
38 ## ########################################################
41 ## Table structure for table `lang_languages`
44 CREATE TABLE IF NOT EXISTS `lang_languages` (
45 `lang_id` int(11) NOT NULL auto_increment,
46 `lang_code` char(2) NOT NULL default '',
47 `lang_description` varchar(100) NOT NULL default '',
48 UNIQUE KEY `lang_id` (`lang_id`)
52 ## Dumping data for table `lang_languages`
55 INSERT INTO `lang_languages` (`lang_id`, `lang_code`, `lang_description`) VALUES (1, 'en', 'English');
56 INSERT INTO `lang_languages` (`lang_id`, `lang_code`, `lang_description`) VALUES (2, 'se', 'Swedish');
57 INSERT INTO `lang_languages` (`lang_id`, `lang_code`, `lang_description`) VALUES (3, 'es', 'Spanish');
60 ADD outcome int(11) NOT NULL DEFAULT 0,
61 ADD destination varchar(255) DEFAULT NULL;
63 ALTER TABLE form_clinical_notes
64 MODIFY followup_required int(11) NOT NULL DEFAULT 0;