vU295eYq

1CREATE TABLE IF NOT EXISTS `mst_gmd` (
2  `gmd_id` int(11) NOT NULL auto_increment,
3  `gmd_code` varchar(3) collate utf8_unicode_ci default NULL,
4  `gmd_name` varchar(30) collate utf8_unicode_ci NOT NULL,
5  `icon_image` varchar(100) collate utf8_unicode_ci default NULL,
6  `input_date` date NOT NULL,
7  `last_update` date default NULL,
8  PRIMARY KEY  (`gmd_id`),
9  UNIQUE KEY `gmd_name` (`gmd_name`),
10  UNIQUE KEY `gmd_code` (`gmd_code`)
11) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=32 ;
12
13--
14-- Dumping data for table `mst_gmd`
15--
16
17INSERT INTO `mst_gmd` (`gmd_id`, `gmd_code`, `gmd_name`, `icon_image`, `input_date`, `last_update`) VALUES
18(1, 'TE', 'Text', NULL, DATE(NOW()), DATE(NOW())),
19(2, 'AR', 'Art Original', NULL, DATE(NOW()), DATE(NOW())),
20(3, 'CH', 'Chart', NULL, DATE(NOW()), DATE(NOW())),
21(4, 'CO', 'Computer Software', NULL, DATE(NOW()), DATE(NOW())),
22(5, 'DI', 'Diorama', NULL, DATE(NOW()), DATE(NOW())),
23(6, 'FI', 'Filmstrip', NULL, DATE(NOW()), DATE(NOW())),
24(7, 'FL', 'Flash Card', NULL, DATE(NOW()), DATE(NOW())),
25(8, 'GA', 'Game', NULL, DATE(NOW()), DATE(NOW())),
26(9, 'GL', 'Globe', NULL, DATE(NOW()), DATE(NOW())),
27(10, 'KI', 'Kit', NULL, DATE(NOW()), DATE(NOW())),
28(11, 'MA', 'Map', NULL, DATE(NOW()), DATE(NOW())),
29(12, 'MI', 'Microform', NULL, DATE(NOW()), DATE(NOW())),
30(13, 'MN', 'Manuscript', NULL, DATE(NOW()), DATE(NOW())),
31(14, 'MO', 'Model', NULL, DATE(NOW()), DATE(NOW())),
32(15, 'MP', 'Motion Picture', NULL, DATE(NOW()), DATE(NOW())),
33(16, 'MS', 'Microscope Slide', NULL, DATE(NOW()), DATE(NOW())),
34(17, 'MU', 'Music', NULL, DATE(NOW()), DATE(NOW())),
35(18, 'PI', 'Picture', NULL, DATE(NOW()), DATE(NOW())),
36(19, 'RE', 'Realia', NULL, DATE(NOW()), DATE(NOW())),
37(20, 'SL', 'Slide', NULL, DATE(NOW()), DATE(NOW())),
38(21, 'SO', 'Sound Recording', NULL, DATE(NOW()), DATE(NOW())),
39(22, 'TD', 'Technical Drawing', NULL, DATE(NOW()), DATE(NOW())),
40(23, 'TR', 'Transparency', NULL, DATE(NOW()), DATE(NOW())),
41(24, 'VI', 'Video Recording', NULL, DATE(NOW()), DATE(NOW())),
42(25, 'EQ', 'Equipment', NULL, DATE(NOW()), DATE(NOW())),
43(26, 'CF', 'Computer File', NULL, DATE(NOW()), DATE(NOW())),
44(27, 'CA', 'Cartographic Material', NULL, DATE(NOW()), DATE(NOW())),
45(28, 'CD', 'CD-ROM', NULL, DATE(NOW()), DATE(NOW())),
46(29, 'MV', 'Multimedia', NULL, DATE(NOW()), DATE(NOW())),
47(30, 'ER', 'Electronic Resource', NULL, DATE(NOW()), DATE(NOW())),
48(31, 'DVD', 'Digital Versatile Disc', NULL, DATE(NOW()), DATE(NOW()));