CsHNBiY7

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