A2uirKGg

1-- --------------------------------------------------------
2-- Host:                         127.0.0.1
3-- Server version:               5.6.12-log - MySQL Community Server (GPL)
4-- Server OS:                    Win32
5-- HeidiSQL Version:             8.0.0.4464
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13-- Dumping database structure for indexa_v1
14CREATE DATABASE IF NOT EXISTS `indexa_v1` /*!40100 DEFAULT CHARACTER SET latin1 */;
15USE `indexa_v1`;
16
17
18-- Dumping structure for table indexa_v1.t_d_variabel_putusan
19CREATE TABLE IF NOT EXISTS `t_d_variabel_putusan` (
20  `id` int(11) NOT NULL AUTO_INCREMENT,
21  `t_m_variabel_putusan` int(11) DEFAULT NULL,
22  `tahun` int(11) DEFAULT NULL,
23  `start_kondisi` varchar(50) DEFAULT NULL,
24  `end_kondisi` varchar(50) DEFAULT NULL,
25  `nama_variabel` varchar(250) DEFAULT NULL,
26  `status` int(11) DEFAULT NULL,
27  `group` varchar(50) DEFAULT NULL,
28  `dispose` varchar(50) DEFAULT NULL,
29  `refer_to` varchar(50) DEFAULT NULL,
30  `refer_to_trigger` varchar(50) DEFAULT NULL,
31  `created_by` int(11) DEFAULT NULL,
32  `created_date` datetime DEFAULT NULL,
33  `updated_by` int(11) DEFAULT NULL,
34  `updated_date` datetime DEFAULT NULL,
35  PRIMARY KEY (`id`)
36) ENGINE=InnoDB AUTO_INCREMENT=259 DEFAULT CHARSET=latin1;
37
38-- Dumping data for table indexa_v1.t_d_variabel_putusan: ~257 rows (approximately)
39/*!40000 ALTER TABLE `t_d_variabel_putusan` DISABLE KEYS */;
40INSERT INTO `t_d_variabel_putusan` (`id`, `t_m_variabel_putusan`, `tahun`, `start_kondisi`, `end_kondisi`, `nama_variabel`, `status`, `group`, `dispose`, `refer_to`, `refer_to_trigger`, `created_by`, `created_date`, `updated_by`, `updated_date`) VALUES
41	(2, 4, 2009, 'No.', '', 'No.', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
42	(3, 5, 2009, ':', '', 'Nama lengkap', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
43	(4, 6, 2009, ':', '', 'Tempat lahir', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
44	(5, 7, 2009, ':', '', 'Umur/tanggal lahir', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
45	(6, 8, 2009, ':', '', 'Jenis kelamin', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
46	(7, 9, 2009, ':', '', 'Kebangsaan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
47	(8, 10, 2009, ':', '', 'Tempat tinggal', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
48	(9, 11, 2009, ':', '', 'Agama', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
49	(10, 12, 2009, ':', '', 'Pekerjaan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
50	(11, 13, 2009, ':', '', 'Pendidikan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
51	(12, 18, 2009, 'hari', 'sekira', 'pada hari', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
52	(13, 19, 2009, 'jam', ',', 'jam', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
53	(14, 17, 2009, 'bertempat', ',', 'bertempat', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
54	(15, 31, 2009, 'kota', '', 'kota', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
55	(16, 32, 2009, 'kecamatan', '', 'kecamatan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
56	(17, 33, 2009, 'kelurahan', '', 'kelurahan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
57	(18, 34, 2009, 'jalan', '', 'jalan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
58	(19, 35, 2009, 'rw', '', 'rw', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
59	(20, 36, 2009, 'rt', '', 'rt', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
60	(21, 37, 2009, 'rumah', '', 'rumah', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
61	(22, 38, 2009, ':', '/', 'umur', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
62	(23, 20, 2009, 'mengambil', 'milik', 'mengambil', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
63	(24, 21, 2009, 'dengan cara', '', 'dengan cara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
64	(25, 22, 2009, 'korban', '', 'korban', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
65	(26, 23, 2009, 'kerugian', '', 'kerugian', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
66	(27, 24, 2009, '', '', 'memperhatikan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
67	(28, 25, 2009, 'mengadili', 'demikian diputus', 'mengadili', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
68	(29, 26, 2009, 'tindak pidana', ';', 'tindak pidana', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
69	(30, 27, 2009, 'pidana penjara', ';', 'pidana penjara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
70	(31, 28, 2009, ':', '[[NUMBER]]', 'barang bukti', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
71	(32, 29, 2009, 'biaya perkara', '', 'biaya perkara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
72	(33, 30, 2009, '', '', 'tanggal amar', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
73	(34, 4, 2010, 'No.', '', 'No.', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
74	(35, 5, 2010, ':', '', 'Nama lengkap', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
75	(36, 6, 2010, ':', '', 'Tempat lahir', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
76	(37, 7, 2010, ':', '', 'Umur/tanggal lahir', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
77	(38, 8, 2010, ':', '', 'Jenis kelamin', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
78	(39, 9, 2010, ':', '', 'Kebangsaan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
79	(40, 10, 2010, ':', '', 'Tempat tinggal', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
80	(41, 11, 2010, ':', '', 'Agama', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
81	(42, 12, 2010, ':', '', 'Pekerjaan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
82	(43, 13, 2010, ':', '', 'Pendidikan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
83	(44, 18, 2010, 'hari', 'sekira', 'pada hari', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
84	(45, 19, 2010, 'jam', ',', 'jam', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
85	(46, 17, 2010, 'bertempat', ',', 'bertempat', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
86	(47, 31, 2010, 'kota', '', 'kota', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
87	(48, 32, 2010, 'kecamatan', '', 'kecamatan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
88	(49, 33, 2010, 'kelurahan', '', 'kelurahan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
89	(50, 34, 2010, 'jalan', '', 'jalan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
90	(51, 35, 2010, 'rw', '', 'rw', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
91	(52, 36, 2010, 'rt', '', 'rt', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
92	(53, 37, 2010, 'rumah', '', 'rumah', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
93	(54, 38, 2010, ':', '/', 'umur', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
94	(55, 20, 2010, 'mengambil', 'milik', 'mengambil', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
95	(56, 21, 2010, 'dengan cara', '', 'dengan cara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
96	(57, 22, 2010, 'korban', '', 'korban', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
97	(58, 23, 2010, 'kerugian', '', 'kerugian', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
98	(59, 24, 2010, '', '', 'memperhatikan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
99	(60, 25, 2010, 'mengadili', 'demikian diputus', 'mengadili', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
100	(61, 26, 2010, 'tindak pidana', ';', 'tindak pidana', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
101	(62, 27, 2010, 'pidana penjara', ';', 'pidana penjara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
102	(63, 28, 2010, ':', '', 'barang bukti', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
103	(64, 29, 2010, 'biaya perkara', '', 'biaya perkara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
104	(65, 30, 2010, '', '', 'tanggal amar', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
105	(66, 4, 2011, 'No.', '', 'No.', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
106	(67, 5, 2011, ':', '', 'Nama lengkap', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
107	(68, 6, 2011, ':', '', 'Tempat lahir', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
108	(69, 7, 2011, ':', '', 'Umur/tanggal lahir', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
109	(70, 8, 2011, ':', '', 'Jenis kelamin', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
110	(71, 9, 2011, ':', '', 'Kebangsaan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
111	(72, 10, 2011, ':', '', 'Tempat tinggal', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
112	(73, 11, 2011, ':', '', 'Agama', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
113	(74, 12, 2011, ':', '', 'Pekerjaan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
114	(75, 13, 2011, ':', '', 'Pendidikan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
115	(76, 18, 2011, 'hari', 'sekira', 'pada hari', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
116	(77, 19, 2011, 'jam', ',', 'jam', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
117	(78, 17, 2011, 'bertempat', ',', 'bertempat', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
118	(79, 31, 2011, 'kota', '', 'kota', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
119	(80, 32, 2011, 'kecamatan', '', 'kecamatan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
120	(81, 33, 2011, 'kelurahan', '', 'kelurahan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
121	(82, 34, 2011, 'jalan', '', 'jalan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
122	(83, 35, 2011, 'rw', '', 'rw', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
123	(84, 36, 2011, 'rt', '', 'rt', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
124	(85, 37, 2011, 'rumah', '', 'rumah', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
125	(86, 38, 2011, ':', '/', 'umur', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
126	(87, 20, 2011, 'mengambil', 'milik', 'mengambil', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
127	(88, 21, 2011, 'dengan cara', '', 'dengan cara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
128	(89, 22, 2011, 'korban', '', 'korban', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
129	(90, 23, 2011, 'kerugian', '', 'kerugian', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
130	(91, 24, 2011, '', '', 'memperhatikan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
131	(92, 25, 2011, 'mengadili', 'demikian diputus', 'mengadili', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
132	(93, 26, 2011, 'tindak pidana', ';', 'tindak pidana', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
133	(94, 27, 2011, 'pidana penjara', ';', 'pidana penjara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
134	(95, 28, 2011, ':', '', 'barang bukti', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
135	(96, 29, 2011, 'biaya perkara', '', 'biaya perkara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
136	(97, 30, 2011, '', '', 'tanggal amar', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
137	(98, 4, 2012, 'No.', '', 'No.', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
138	(99, 5, 2012, ':', '', 'Nama lengkap', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
139	(100, 6, 2012, ':', '', 'Tempat lahir', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
140	(101, 7, 2012, ':', '', 'Umur/tanggal lahir', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
141	(102, 8, 2012, ':', '', 'Jenis kelamin', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
142	(103, 9, 2012, ':', '', 'Kebangsaan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
143	(104, 10, 2012, ':', '', 'Tempat tinggal', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
144	(105, 11, 2012, ':', '', 'Agama', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
145	(106, 12, 2012, ':', '', 'Pekerjaan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
146	(107, 13, 2012, ':', '', 'Pendidikan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
147	(108, 18, 2012, 'hari', 'sekira', 'pada hari', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
148	(109, 19, 2012, 'jam', ',', 'jam', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
149	(110, 17, 2012, 'bertempat', ',', 'bertempat', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
150	(111, 31, 2012, 'kota', '', 'kota', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
151	(112, 32, 2012, 'kecamatan', '', 'kecamatan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
152	(113, 33, 2012, 'kelurahan', '', 'kelurahan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
153	(114, 34, 2012, 'jalan', '', 'jalan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
154	(115, 35, 2012, 'rw', '', 'rw', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
155	(116, 36, 2012, 'rt', '', 'rt', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
156	(117, 37, 2012, 'rumah', '', 'rumah', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
157	(118, 38, 2012, ':', '/', 'umur', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
158	(119, 20, 2012, 'mengambil', 'milik', 'mengambil', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
159	(120, 21, 2012, 'dengan cara', '', 'dengan cara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
160	(121, 22, 2012, 'korban', '', 'korban', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
161	(122, 23, 2012, 'kerugian', '', 'kerugian', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
162	(123, 24, 2012, '', '', 'memperhatikan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
163	(124, 25, 2012, 'mengadili', 'demikian diputus', 'mengadili', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
164	(125, 26, 2012, 'tindak pidana', ';', 'tindak pidana', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
165	(126, 27, 2012, 'pidana penjara', ';', 'pidana penjara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
166	(127, 28, 2012, ':', '', 'barang bukti', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
167	(128, 29, 2012, 'biaya perkara', '', 'biaya perkara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
168	(129, 30, 2012, '', '', 'tanggal amar', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
169	(130, 4, 2013, 'No.', '', 'No.', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
170	(131, 5, 2013, ':', '', 'Nama lengkap', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
171	(132, 6, 2013, ':', '', 'Tempat lahir', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
172	(133, 7, 2013, ':', '', 'Umur/tanggal lahir', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
173	(134, 8, 2013, ':', '', 'Jenis kelamin', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
174	(135, 9, 2013, ':', '', 'Kebangsaan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
175	(136, 10, 2013, ':', '', 'Tempat tinggal', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
176	(137, 11, 2013, ':', '', 'Agama', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
177	(138, 12, 2013, ':', '', 'Pekerjaan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
178	(139, 13, 2013, ':', '', 'Pendidikan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
179	(140, 18, 2013, 'hari', 'sekira', 'pada hari', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
180	(141, 19, 2013, 'jam', ',', 'jam', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
181	(142, 17, 2013, 'bertempat', ',', 'bertempat', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
182	(143, 31, 2013, 'kota', '', 'kota', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
183	(144, 32, 2013, 'kecamatan', '', 'kecamatan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
184	(145, 33, 2013, 'kelurahan', '', 'kelurahan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
185	(146, 34, 2013, 'jalan', '', 'jalan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
186	(147, 35, 2013, 'rw', '', 'rw', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
187	(148, 36, 2013, 'rt', '', 'rt', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
188	(149, 37, 2013, 'rumah', '', 'rumah', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
189	(150, 38, 2013, ':', '/', 'umur', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
190	(151, 20, 2013, 'mengambil', 'milik', 'mengambil', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
191	(152, 21, 2013, 'dengan cara', '', 'dengan cara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
192	(153, 22, 2013, 'korban', '', 'korban', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
193	(154, 23, 2013, 'kerugian', '', 'kerugian', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
194	(155, 24, 2013, '', '', 'memperhatikan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
195	(156, 25, 2013, 'mengadili', 'demikian diputus', 'mengadili', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
196	(157, 26, 2013, 'tindak pidana', ';', 'tindak pidana', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
197	(158, 27, 2013, 'pidana penjara', ';', 'pidana penjara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
198	(159, 28, 2013, ':', '', 'barang bukti', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
199	(160, 29, 2013, 'biaya perkara', '', 'biaya perkara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
200	(161, 30, 2013, '', '', 'tanggal amar', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
201	(162, 4, 2014, 'Nomor', '', 'Nomor', 1, NULL, ':', NULL, NULL, NULL, NULL, NULL, NULL),
202	(163, 5, 2014, 'Nama lengkap', '', 'Nama lengkap', 1, NULL, ':', NULL, NULL, NULL, NULL, NULL, NULL),
203	(164, 6, 2014, 'Tempat lahir', '', 'Tempat lahir', 1, NULL, ':| |.', NULL, NULL, NULL, NULL, NULL, NULL),
204	(165, 7, 2014, 'Umur/tanggal lahir', '', 'Umur/tanggal lahir', 1, NULL, ':|.', NULL, NULL, NULL, NULL, NULL, NULL),
205	(166, 8, 2014, 'Jenis kelamin', '', 'Jenis kelamin', 1, NULL, ':| |.', NULL, NULL, NULL, NULL, NULL, NULL),
206	(167, 9, 2014, 'Kebangsaan', '', 'Kebangsaan', 1, NULL, ':| |.', NULL, NULL, NULL, NULL, NULL, NULL),
207	(168, 10, 2014, 'Tempat tinggal', '', 'Tempat tinggal', 1, NULL, ':|', NULL, NULL, NULL, NULL, NULL, NULL),
208	(169, 11, 2014, 'Agama', '', 'Agama', 1, NULL, ':|.', NULL, NULL, NULL, NULL, NULL, NULL),
209	(170, 12, 2014, 'Pekerjaan', '', 'Pekerjaan', 1, NULL, ':|.', NULL, NULL, NULL, NULL, NULL, NULL),
210	(171, 13, 2014, 'Pendidikan', '', 'Pendidikan', 1, NULL, ':| |.', NULL, NULL, NULL, NULL, NULL, NULL),
211	(172, 18, 2014, 'pada hari', 'sekira', 'pada hari', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
212	(173, 19, 2014, 'jam', 'atau', 'jam', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
213	(174, 17, 2014, 'bertempat', ',', 'bertempat', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
214	(175, 31, 2014, 'kota', '', 'kota', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
215	(176, 32, 2014, 'kecamatan', '', 'kecamatan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
216	(177, 33, 2014, 'kelurahan', '', 'kelurahan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
217	(178, 34, 2014, 'jalan', '', 'jalan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
218	(179, 35, 2014, 'rw', '', 'rw', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
219	(180, 36, 2014, 'rt', '', 'rt', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
220	(181, 37, 2014, 'rumah', '', 'rumah', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
221	(182, 38, 2014, 'Umur/tanggal lahir', 'tahun|thn', 'Umur', 1, NULL, ':|.', NULL, NULL, NULL, NULL, NULL, NULL),
222	(183, 20, 2014, 'pada hari', ';', 'mengambil', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
223	(184, 21, 2014, 'dengan cara sebagai berikut', 'Bahwa akibat', 'dengan cara', 1, NULL, '#NL#|:|\\n|;', NULL, NULL, NULL, NULL, NULL, NULL),
224	(185, 22, 2014, 'korban', '', 'korban', 1, NULL, ';|.', NULL, NULL, NULL, NULL, NULL, NULL),
225	(186, 23, 2014, 'kerugian', '', 'kerugian', 1, NULL, ';', NULL, NULL, NULL, NULL, NULL, NULL),
226	(187, 24, 2014, '#NL#Mengingat|#NL#Memperhatikan', 'serta|;', 'Pasal Amar', 1, NULL, ';', NULL, NULL, NULL, NULL, NULL, NULL),
227	(188, 25, 2014, '#NL#Mengadili', 'demikian|demikianlah', 'Amar', 1, NULL, '#NL#|;', NULL, NULL, NULL, NULL, NULL, NULL),
228	(189, 26, 2014, 'tindak pidana', ';|sebagaimana ', 'Tindak Pidana', 1, '#NL#Mengadili--', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
229	(190, 27, 2014, 'pidana penjara', ';', 'pidana penjara', 1, '#NL#Mengadili--', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
230	(191, 28, 2014, 'barang bukti berupa\\s?:|barang-bukti berupa\\s?:', '\\#NL#\\d.', 'barang bukti', 1, '#NL#Mengadili--', '#NL#|;', NULL, NULL, NULL, NULL, NULL, NULL),
231	(192, 29, 2014, 'biaya perkara', '', 'biaya perkara', 1, '#NL#Mengadili--', ';', NULL, NULL, NULL, NULL, NULL, NULL),
232	(193, 30, 2014, 'pada hari', 'putusan|oleh', 'tanggal Amar', 1, 'masing sebagai--', NULL, '39|2014', 'tanggal itu juga|hari itu juga', NULL, NULL, NULL, NULL),
233	(194, 4, 2015, ':', '', 'No.', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
234	(195, 5, 2015, ':', '', 'Nama lengkap', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
235	(196, 6, 2015, ':', '', 'Tempat lahir', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
236	(197, 7, 2015, ':', '', 'Umur/tanggal lahir', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
237	(198, 8, 2015, ':', '', 'Jenis kelamin', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
238	(199, 9, 2015, ':', '', 'Kebangsaan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
239	(200, 10, 2015, ':', '', 'Tempat tinggal', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
240	(201, 11, 2015, ':', '', 'Agama', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
241	(202, 12, 2015, ':', '', 'Pekerjaan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
242	(203, 13, 2015, ':', '', 'Pendidikan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
243	(204, 18, 2015, 'hari', 'sekira', 'pada hari', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
244	(205, 19, 2015, 'jam', ',', 'jam', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
245	(206, 17, 2015, 'bertempat', ',', 'bertempat', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
246	(207, 31, 2015, 'kota', '', 'kota', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
247	(208, 32, 2015, 'kecamatan', '', 'kecamatan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
248	(209, 33, 2015, 'kelurahan', '', 'kelurahan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
249	(210, 34, 2015, 'jalan', '', 'jalan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
250	(211, 35, 2015, 'rw', '', 'rw', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
251	(212, 36, 2015, 'rt', '', 'rt', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
252	(213, 37, 2015, 'rumah', '', 'rumah', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
253	(214, 38, 2015, ':', '/', 'umur', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
254	(215, 20, 2015, 'mengambil', 'milik', 'mengambil', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
255	(216, 21, 2015, 'dengan cara', '', 'dengan cara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
256	(217, 22, 2015, 'korban', '', 'korban', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
257	(218, 23, 2015, 'kerugian', '', 'kerugian', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
258	(219, 24, 2015, '', '', 'memperhatikan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
259	(220, 25, 2015, 'mengadili', 'demikian diputus', 'mengadili', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
260	(221, 26, 2015, 'tindak pidana', ';', 'tindak pidana', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
261	(222, 27, 2015, 'pidana penjara', ';', 'pidana penjara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
262	(223, 28, 2015, ':', '', 'barang bukti', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
263	(224, 29, 2015, 'biaya perkara', '', 'biaya perkara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
264	(225, 30, 2015, '', '', 'tanggal amar', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
265	(226, 4, 2016, 'No.', '', 'No.', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
266	(227, 5, 2016, ':', '', 'Nama lengkap', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
267	(228, 6, 2016, ':', '', 'Tempat lahir', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
268	(229, 7, 2016, ':', '', 'Umur/tanggal lahir', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
269	(230, 8, 2016, ':', '', 'Jenis kelamin', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
270	(231, 9, 2016, ':', '', 'Kebangsaan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
271	(232, 10, 2016, ':', '', 'Tempat tinggal', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
272	(233, 11, 2016, ':', '', 'Agama', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
273	(234, 12, 2016, ':', '', 'Pekerjaan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
274	(235, 13, 2016, ':', '', 'Pendidikan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
275	(236, 18, 2016, 'hari', 'sekira', 'pada hari', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
276	(237, 19, 2016, 'jam', ',', 'jam', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
277	(238, 17, 2016, 'bertempat', ',', 'bertempat', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
278	(239, 31, 2016, 'kota', '', 'kota', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
279	(240, 32, 2016, 'kecamatan', '', 'kecamatan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
280	(241, 33, 2016, 'kelurahan', '', 'kelurahan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
281	(242, 34, 2016, 'jalan', '', 'jalan', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
282	(243, 35, 2016, 'rw', '', 'rw', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
283	(244, 36, 2016, 'rt', '', 'rt', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
284	(245, 37, 2016, 'rumah', '', 'rumah', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
285	(246, 38, 2016, ':', '/', 'umur', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
286	(247, 20, 2016, 'mengambil', 'milik', 'mengambil', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
287	(248, 21, 2016, 'dengan cara', '', 'dengan cara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
288	(249, 22, 2016, 'korban', '', 'korban', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
289	(250, 23, 2016, 'kerugian', '', 'kerugian', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
290	(251, 24, 2016, '', '', 'memperhatikan', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
291	(252, 25, 2016, 'mengadili', 'demikian diputus', 'mengadili', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
292	(253, 26, 2016, 'tindak pidana', ';', 'tindak pidana', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
293	(254, 27, 2016, 'pidana penjara', ';', 'pidana penjara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
294	(255, 28, 2016, ':', '', 'barang bukti', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
295	(256, 29, 2016, 'biaya perkara', '', 'biaya perkara', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
296	(257, 30, 2016, '', '', 'tanggal amar', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
297	(258, 39, 2014, 'pada hari\\s?:', '\\d{4}', 'tanggal putusan amar', 1, '#NL#Mengadili--', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
298/*!40000 ALTER TABLE `t_d_variabel_putusan` ENABLE KEYS */;
299/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
300/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
301/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;