· 8 years ago · Mar 21, 2018, 12:52 PM
1
2--
3-- Table structure for table `kota`
4--
5
6CREATE TABLE IF NOT EXISTS `kota` (
7 `id` int(11) NOT NULL,
8 `kode` varchar(10) NOT NULL,
9 `nama` varchar(255) NOT NULL,
10 `prov_kode` varchar(5) NOT NULL,
11 `detail` text NOT NULL
12) ENGINE=InnoDB DEFAULT CHARSET=latin1;
13
14-- --------------------------------------------------------
15
16--
17-- Table structure for table `negara`
18--
19
20CREATE TABLE IF NOT EXISTS `negara` (
21 `id` int(11) NOT NULL,
22 `kode` varchar(5) NOT NULL,
23 `nama` varchar(255) NOT NULL,
24 `detail` text NOT NULL
25) ENGINE=InnoDB DEFAULT CHARSET=latin1;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `pekerjaan`
31--
32
33CREATE TABLE IF NOT EXISTS `pekerjaan` (
34 `id` bigint(20) NOT NULL,
35 `nama` varchar(255) NOT NULL,
36 `kota_kode` varchar(5) NOT NULL,
37 `prov_kode` varchar(5) NOT NULL,
38 `negara_kode` varchar(10) NOT NULL,
39 `keterangan` longtext NOT NULL
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41
42-- --------------------------------------------------------
43
44--
45-- Table structure for table `prov`
46--
47
48CREATE TABLE IF NOT EXISTS `prov` (
49 `id` int(11) NOT NULL,
50 `kode` varchar(5) NOT NULL,
51 `nama` varchar(255) NOT NULL,
52 `negara_kode` varchar(5) NOT NULL,
53 `detail` text NOT NULL
54) ENGINE=InnoDB DEFAULT CHARSET=latin1;
55
56--
57-- Indexes for dumped tables
58--
59
60--
61-- Indexes for table `kota`
62--
63ALTER TABLE `kota`
64 ADD PRIMARY KEY (`id`),
65 ADD UNIQUE KEY `kode` (`kode`),
66 ADD KEY `prov_kode` (`prov_kode`);
67
68--
69-- Indexes for table `negara`
70--
71ALTER TABLE `negara`
72 ADD PRIMARY KEY (`id`),
73 ADD UNIQUE KEY `kode` (`kode`);
74
75--
76-- Indexes for table `pekerjaan`
77--
78ALTER TABLE `pekerjaan`
79 ADD PRIMARY KEY (`id`),
80 ADD KEY `kota_kode` (`kota_kode`),
81 ADD KEY `prov_kode` (`prov_kode`),
82 ADD KEY `negara_kode` (`negara_kode`);
83
84--
85-- Indexes for table `prov`
86--
87ALTER TABLE `prov`
88 ADD PRIMARY KEY (`id`),
89 ADD UNIQUE KEY `kode` (`kode`),
90 ADD KEY `negara_kode` (`negara_kode`);
91
92--
93-- AUTO_INCREMENT for dumped tables
94--
95
96--
97-- AUTO_INCREMENT for table `kota`
98--
99ALTER TABLE `kota`
100 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
101--
102-- AUTO_INCREMENT for table `negara`
103--
104ALTER TABLE `negara`
105 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
106--
107-- AUTO_INCREMENT for table `pekerjaan`
108--
109ALTER TABLE `pekerjaan`
110 MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
111--
112-- AUTO_INCREMENT for table `prov`
113--
114ALTER TABLE `prov`
115 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
116--
117-- Constraints for dumped tables
118--
119
120--
121-- Constraints for table `kota`
122--
123ALTER TABLE `kota`
124 ADD CONSTRAINT `kota_ibfk_1` FOREIGN KEY (`prov_kode`) REFERENCES `prov` (`kode`);
125
126--
127-- Constraints for table `pekerjaan`
128--
129ALTER TABLE `pekerjaan`
130 ADD CONSTRAINT `pekerjaan_ibfk_1` FOREIGN KEY (`kota_kode`) REFERENCES `kota` (`kode`) ON DELETE NO ACTION ON UPDATE NO ACTION,
131 ADD CONSTRAINT `pekerjaan_ibfk_2` FOREIGN KEY (`prov_kode`) REFERENCES `prov` (`kode`) ON DELETE NO ACTION ON UPDATE NO ACTION,
132 ADD CONSTRAINT `pekerjaan_ibfk_3` FOREIGN KEY (`negara_kode`) REFERENCES `negara` (`kode`) ON DELETE NO ACTION ON UPDATE NO ACTION;
133
134--
135-- Constraints for table `prov`
136--
137ALTER TABLE `prov`
138 ADD CONSTRAINT `prov_ibfk_1` FOREIGN KEY (`negara_kode`) REFERENCES `negara` (`kode`);