3 -- http://www.phpmyadmin.net
6 -- Generation Time: Nov 16, 2005 at 10:28 AM
7 -- Server version: 4.1.11
8 -- PHP Version: 4.3.9-1
10 -- Database: `openemr1018`
13 -- --------------------------------------------------------
16 -- Table structure for table `lang_constants`
19 CREATE TABLE IF NOT EXISTS `lang_constants` (
20 `cons_id` int(11) NOT NULL auto_increment,
21 `constant_name` varchar(255) NOT NULL default '',
22 UNIQUE KEY `cons_id` (`cons_id`),
23 KEY `cons_name` (`constant_name`)
24 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
27 -- Dumping data for table `lang_constants`
30 -- --------------------------------------------------------
33 -- Table structure for table `lang_definitions`
36 CREATE TABLE IF NOT EXISTS `lang_definitions` (
37 `def_id` int(11) NOT NULL auto_increment,
38 `cons_id` int(11) NOT NULL default '0',
39 `lang_id` int(11) NOT NULL default '0',
40 `definition` mediumtext NOT NULL,
41 UNIQUE KEY `def_id` (`def_id`),
42 KEY `definition` (`definition`(100))
43 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
46 -- Dumping data for table `lang_definitions`
50 -- --------------------------------------------------------
53 -- Table structure for table `lang_languages`
56 CREATE TABLE IF NOT EXISTS `lang_languages` (
57 `lang_id` int(11) NOT NULL auto_increment,
58 `lang_code` char(2) NOT NULL default '',
59 `lang_description` varchar(100) NOT NULL default '',
60 UNIQUE KEY `lang_id` (`lang_id`)
61 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
64 -- Dumping data for table `lang_languages`
67 INSERT INTO `lang_languages` (`lang_id`, `lang_code`, `lang_description`) VALUES (1, 'en', 'English');
68 INSERT INTO `lang_languages` (`lang_id`, `lang_code`, `lang_description`) VALUES (2, 'se', 'Swedish');
69 INSERT INTO `lang_languages` (`lang_id`, `lang_code`, `lang_description`) VALUES (3, 'es', 'Spanish');