-- -- Indexes for dumped tables -- -- -- Indexes for table `auth` -- ALTER TABLE `auth` ADD PRIMARY KEY (`id`) USING BTREE, ADD KEY `prov` (`prov`) USING BTREE, ADD KEY `kab` (`kab`) USING BTREE, ADD KEY `kec` (`kec`) USING BTREE, ADD KEY `kel` (`kel`) USING BTREE, ADD KEY `hak_akses` (`hak_akses`) USING BTREE; -- -- Indexes for table `dt_pwd` -- ALTER TABLE `dt_pwd` ADD PRIMARY KEY (`id`) USING BTREE, ADD KEY `id_user` (`id_user`) USING BTREE, ADD KEY `syscreateuser` (`syscreateuser`) USING BTREE; -- -- Indexes for table `dt_simkah` -- ALTER TABLE `dt_simkah` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id_UNIQUE` (`id`); -- -- Indexes for table `dt_users` -- ALTER TABLE `dt_users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`) USING BTREE, ADD KEY `id_user` (`sys_user_id`), ADD KEY `address_provinsi` (`address_provinsi`), ADD KEY `address_kelurahan` (`address_kelurahan`), ADD KEY `address_kecamatan` (`address_kecamatan`), ADD KEY `address_kabupaten` (`address_kabupaten`); -- -- Indexes for table `keys` -- ALTER TABLE `keys` ADD PRIMARY KEY (`id`) USING BTREE; -- -- Indexes for table `mt_country` -- ALTER TABLE `mt_country` ADD PRIMARY KEY (`id`) USING BTREE, ADD KEY `code` (`code`) USING BTREE, ADD KEY `id` (`id`) USING BTREE; -- -- Indexes for table `mt_wil_kabupaten` -- ALTER TABLE `mt_wil_kabupaten` ADD PRIMARY KEY (`id_kabupaten`) USING BTREE; -- -- Indexes for table `mt_wil_kecamatan` -- ALTER TABLE `mt_wil_kecamatan` ADD PRIMARY KEY (`id_kecamatan`) USING BTREE; -- -- Indexes for table `mt_wil_kelurahan` -- ALTER TABLE `mt_wil_kelurahan` ADD PRIMARY KEY (`id_kelurahan`) USING BTREE; -- -- Indexes for table `mt_wil_provinsi` -- ALTER TABLE `mt_wil_provinsi` ADD PRIMARY KEY (`id_provinsi`) USING BTREE; -- -- Indexes for table `subdit` -- ALTER TABLE `subdit` ADD PRIMARY KEY (`id`) USING BTREE; -- -- Indexes for table `sys_app` -- ALTER TABLE `sys_app` ADD PRIMARY KEY (`favico`) USING BTREE; -- -- Indexes for table `sys_menu` -- ALTER TABLE `sys_menu` ADD PRIMARY KEY (`id`) USING BTREE, ADD UNIQUE KEY `id` (`id`) USING BTREE, ADD KEY `group_menu` (`group_menu`) USING BTREE; -- -- Indexes for table `sys_menu_group` -- ALTER TABLE `sys_menu_group` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`) USING BTREE; -- -- Indexes for table `sys_param` -- ALTER TABLE `sys_param` ADD PRIMARY KEY (`id`) USING BTREE, ADD UNIQUE KEY `id` (`id`) USING BTREE; -- -- Indexes for table `sys_permissions` -- ALTER TABLE `sys_permissions` ADD PRIMARY KEY (`id`) USING BTREE, ADD KEY `sys_permissions_ibfk_1` (`role_id`) USING BTREE, ADD KEY `id_menu` (`id_menu`) USING BTREE; -- -- Indexes for table `sys_roles` -- ALTER TABLE `sys_roles` ADD PRIMARY KEY (`id`) USING BTREE; -- -- Indexes for table `sys_users` -- ALTER TABLE `sys_users` ADD UNIQUE KEY `id` (`id`) USING BTREE, ADD UNIQUE KEY `uname` (`uname`) USING BTREE, ADD KEY `role_id` (`role_id`) USING BTREE; -- -- Indexes for table `tbl_users` -- ALTER TABLE `tbl_users` ADD PRIMARY KEY (`id_user`) USING BTREE; -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `auth` -- ALTER TABLE `auth` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7532; -- -- AUTO_INCREMENT for table `dt_pwd` -- ALTER TABLE `dt_pwd` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=224; -- -- AUTO_INCREMENT for table `dt_simkah` -- ALTER TABLE `dt_simkah` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46; -- -- AUTO_INCREMENT for table `dt_users` -- ALTER TABLE `dt_users` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7507; -- -- AUTO_INCREMENT for table `keys` -- ALTER TABLE `keys` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45; -- -- AUTO_INCREMENT for table `mt_country` -- ALTER TABLE `mt_country` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=250; -- -- AUTO_INCREMENT for table `subdit` -- ALTER TABLE `subdit` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `sys_menu` -- ALTER TABLE `sys_menu` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=82; -- -- AUTO_INCREMENT for table `sys_menu_group` -- ALTER TABLE `sys_menu_group` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `sys_permissions` -- ALTER TABLE `sys_permissions` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1135; -- -- AUTO_INCREMENT for table `sys_roles` -- ALTER TABLE `sys_roles` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `sys_users` -- ALTER TABLE `sys_users` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15280; -- -- AUTO_INCREMENT for table `tbl_users` -- ALTER TABLE `tbl_users` MODIFY `id_user` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- Constraints for dumped tables -- -- -- Constraints for table `auth` -- ALTER TABLE `auth` ADD CONSTRAINT `auth_ibfk_1` FOREIGN KEY (`hak_akses`) REFERENCES `subdit` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `dt_pwd` -- ALTER TABLE `dt_pwd` ADD CONSTRAINT `dt_pwd_ibfk_1` FOREIGN KEY (`syscreateuser`) REFERENCES `sys_users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `dt_users` -- ALTER TABLE `dt_users` ADD CONSTRAINT `dt_users_ibfk_1` FOREIGN KEY (`sys_user_id`) REFERENCES `sys_users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `dt_users_ibfk_2` FOREIGN KEY (`address_provinsi`) REFERENCES `mt_wil_provinsi` (`id_provinsi`) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `dt_users_ibfk_3` FOREIGN KEY (`address_kelurahan`) REFERENCES `mt_wil_kelurahan` (`id_kelurahan`) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `dt_users_ibfk_4` FOREIGN KEY (`address_kecamatan`) REFERENCES `mt_wil_kecamatan` (`id_kecamatan`) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `dt_users_ibfk_5` FOREIGN KEY (`address_kabupaten`) REFERENCES `mt_wil_kabupaten` (`id_kabupaten`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `sys_menu` -- ALTER TABLE `sys_menu` ADD CONSTRAINT `sys_menu_ibfk_1` FOREIGN KEY (`group_menu`) REFERENCES `sys_menu_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `sys_permissions` -- ALTER TABLE `sys_permissions` ADD CONSTRAINT `sys_permissions_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `sys_roles` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `sys_permissions_ibfk_2` FOREIGN KEY (`id_menu`) REFERENCES `sys_menu` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; -- -- Constraints for table `sys_users` -- ALTER TABLE `sys_users` ADD CONSTRAINT `sys_users_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `sys_roles` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT;