| Server IP : 199.250.214.225 / Your IP : 3.135.204.225 Web Server : Apache System : Linux vps64074.inmotionhosting.com 3.10.0-1160.105.1.vz7.214.3 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : nicngo5 ( 1001) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /home/nicngo5/nicnAdmin/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 4.6.4 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Mar 23, 2017 at 12:41 AM -- Server version: 5.7.14 -- PHP Version: 5.6.25 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `nicn_funds` -- -- -------------------------------------------------------- -- -- Table structure for table `audit_log` -- CREATE TABLE `audit_log` ( `auditID` bigint(11) NOT NULL, `comp_name` varchar(30) NOT NULL, `user_id` varchar(3) NOT NULL, `date` datetime NOT NULL, `ip_addr` varchar(20) NOT NULL, `operation` varchar(150) NOT NULL, `host` varchar(200) NOT NULL, `referer` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `audit_log` -- INSERT INTO `audit_log` (`auditID`, `comp_name`, `user_id`, `date`, `ip_addr`, `operation`, `host`, `referer`) VALUES (1, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 12:51:07', '::1', 'New Company List added', 'localhost', 'http://localhost/nicnfunds/public/company/store'), (2, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 12:51:27', '::1', 'Company list deleted', 'localhost', 'http://localhost/nicnfunds/public/company/remove/2'), (3, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 12:51:32', '::1', 'New Company List added', 'localhost', 'http://localhost/nicnfunds/public/company/store'), (4, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 12:51:39', '::1', 'New Company List added', 'localhost', 'http://localhost/nicnfunds/public/company/store'), (5, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 12:51:48', '::1', 'New Company List added', 'localhost', 'http://localhost/nicnfunds/public/company/store'), (6, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 12:51:59', '::1', 'Company list deleted', 'localhost', 'http://localhost/nicnfunds/public/company/remove/5'), (7, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 13:01:40', '::1', 'New group List added', 'localhost', 'http://localhost/nicnfunds/public/group/store'), (8, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 13:02:03', '::1', 'New group List added', 'localhost', 'http://localhost/nicnfunds/public/group/store'), (9, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 14:45:20', '::1', 'New description List added', 'localhost', 'http://localhost/nicnfunds/public/description/store'), (10, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 14:49:56', '::1', 'New description List added', 'localhost', 'http://localhost/nicnfunds/public/description/store'), (11, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 14:51:18', '::1', 'description list deleted', 'localhost', 'http://localhost/nicnfunds/public/description/remove/1'), (12, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 14:51:31', '::1', 'New description List added', 'localhost', 'http://localhost/nicnfunds/public/description/store'), (13, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 14:52:46', '::1', 'New description List added', 'localhost', 'http://localhost/nicnfunds/public/description/store'), (14, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 14:59:40', '::1', ' active month set to FEBRUARY/2017', 'localhost', 'http://localhost/nicnfunds/public/activeMonth/create'), (15, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 16:46:20', '::1', 'New Budgeet 1000000 for 2017 with description ID 2 added', 'localhost', 'http://localhost/nicnfunds/public/budget/store'), (16, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 17:00:50', '::1', ' active month set to FEBRUARY/2019', 'localhost', 'http://localhost/nicnfunds/public/activeMonth/create'), (17, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 17:01:03', '::1', 'New Budgeet 12 for 2019 with description ID 2 added', 'localhost', 'http://localhost/nicnfunds/public/budget/store'), (18, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 17:02:56', '::1', ' active month set to APRIL/2019', 'localhost', 'http://localhost/nicnfunds/public/activeMonth/create'), (19, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 17:03:11', '::1', ' active month set to APRIL/2011', 'localhost', 'http://localhost/nicnfunds/public/activeMonth/create'), (20, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 17:03:54', '::1', 'New Budgeet 25544522 for 2011 with description ID 2 added', 'localhost', 'http://localhost/nicnfunds/public/budget/store'), (21, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 17:05:07', '::1', 'budget list deleted', 'localhost', 'http://localhost/nicnfunds/public/budget/remove/3'), (22, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 17:05:16', '::1', 'budget list deleted', 'localhost', 'http://localhost/nicnfunds/public/budget/remove/3'), (23, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 17:05:42', '::1', 'budget list deleted', 'localhost', 'http://localhost/nicnfunds/public/budget/remove/3'), (24, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 17:07:05', '::1', 'budget list deleted', 'localhost', 'http://localhost/nicnfunds/public/budget/remove/3'), (25, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 19:44:38', '::1', 'New description List added', 'localhost', 'http://localhost/nicnfunds/public/description/store'), (26, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 19:44:59', '::1', 'New Budgeet 152666 for 2011 with description ID 5 added', 'localhost', 'http://localhost/nicnfunds/public/budget/store'), (27, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 20:11:26', '::1', 'New Company List added', 'localhost', 'http://localhost/nicnfunds/public/company/store'), (28, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 20:11:47', '::1', ' active month set to MARCH/2017', 'localhost', 'http://localhost/nicnfunds/public/activeMonth/create'), (29, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 20:12:28', '::1', 'New Budgeet 1000255 for 2017 with description ID 3 added', 'localhost', 'http://localhost/nicnfunds/public/budget/store'), (30, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 22:51:57', '::1', 'New user added', 'localhost', 'http://localhost/nicnfunds/public/user/store'), (31, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 23:28:40', '::1', 'New Budgeet 10000 for 2017 with description ID 3 added', 'localhost', 'http://localhost/nicnfunds/public/allocation/store'), (32, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 23:31:35', '::1', 'allocation list deleted', 'localhost', 'http://localhost/nicnfunds/public/allocation/remove/1'), (33, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 23:31:46', '::1', 'New Budgeet 10000 for 2017 with description ID 3 added', 'localhost', 'http://localhost/nicnfunds/public/allocation/store'), (34, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 23:32:16', '::1', ' active month set to JUNE/2017', 'localhost', 'http://localhost/nicnfunds/public/activeMonth/create'), (35, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-22 23:32:28', '::1', 'New Budgeet 100 for 2017 with description ID 3 added', 'localhost', 'http://localhost/nicnfunds/public/allocation/store'), (36, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-23 00:18:05', '::1', ' creating role with name test', 'localhost', 'http://localhost/nicnfunds/public/role/create'), (37, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-23 00:19:08', '::1', ' attach user with id 159 to role with id 6', 'localhost', 'http://localhost/nicnfunds/public/role/userRole'), (38, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-23 00:48:07', '::1', 'New Expense of 10000 company ID 6 for JUNE with description FLEXING added', 'localhost', 'http://localhost/nicnfunds/public/transaction/store'), (39, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-23 00:51:39', '::1', 'New Expense of 52222 company ID 6 for JUNE with description TEST added', 'localhost', 'http://localhost/nicnfunds/public/transaction/store'), (40, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-23 00:54:12', '::1', 'New Expense of 1222 company ID 6 for JUNE with description ASA added', 'localhost', 'http://localhost/nicnfunds/public/transaction/store'), (41, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-23 01:07:53', '::1', 'New Expense of 50000000 company ID 6 for JUNE with description TESRTING added', 'localhost', 'http://localhost/nicnfunds/public/transaction/store'), (42, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-23 01:30:53', '::1', 'allocation list deleted', 'localhost', 'http://localhost/nicnfunds/public/allocation/remove/3'), (43, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-23 01:30:56', '::1', 'allocation list deleted', 'localhost', 'http://localhost/nicnfunds/public/allocation/remove/2'), (44, 'Windows NT LAPTOP-13C6RHD2 10.', '5', '2017-03-23 01:32:08', '::1', 'New Expense of 2555333 company ID 6 for JUNE with description ASASASSAD added', 'localhost', 'http://localhost/nicnfunds/public/transaction/store'); -- -------------------------------------------------------- -- -- Table structure for table `permissions` -- CREATE TABLE `permissions` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `display_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `permissions` -- INSERT INTO `permissions` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`) VALUES (2, 'can-edit', '', 'can edit ', '2016-12-20 16:14:30', '2016-12-20 16:14:30'), (4, 'set-active-month', '', 'this gives the permission to set active month', '2016-12-20 21:38:14', '2016-12-20 21:38:14'), (5, 'can-export-soft-copy', '', 'this gives the permission to export soft copy', '2016-12-21 00:23:06', '2016-12-21 00:23:06'), (7, 'manage-users', '', 'manages user permission and roles', '2016-12-21 21:28:31', '2016-12-21 21:28:31'); -- -------------------------------------------------------- -- -- Table structure for table `permission_role` -- CREATE TABLE `permission_role` ( `permission_id` int(10) UNSIGNED NOT NULL, `role_id` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `permission_role` -- INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES (2, 1), (4, 1), (5, 1), (2, 2), (5, 2), (2, 3), (4, 3), (5, 3), (5, 4), (5, 5), (5, 6), (2, 7), (4, 7), (5, 7), (7, 7); -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `display_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `roles` -- INSERT INTO `roles` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`) VALUES (1, 'admin', '', '', '2016-12-20 15:46:42', '2016-12-20 15:46:42'), (2, 'salary staff', '', 'in charge of salary', '2016-12-20 16:00:15', '2016-12-20 16:00:15'), (3, 'salary supervisor', '', '', '2016-12-20 16:03:15', '2016-12-20 16:03:15'), (4, 'audit staff', '', '', '2016-12-20 16:04:45', '2016-12-20 16:04:45'), (5, 'tax staff', '', '', '2016-12-20 16:09:16', '2016-12-20 16:09:16'), (6, 'cpo staff', '', '', '2016-12-20 16:09:32', '2016-12-20 16:09:32'), (7, 'super admin', 'super administrative', 'can create new user and perform normal admin function', '2016-12-21 21:27:54', '2016-12-21 21:27:54'), (8, 'salary collator', 'Abuja salary collator', 'Abuja salary collator', '2017-03-14 11:15:30', '2017-03-14 11:15:30'), (9, 'nhf staff', 'nhf staff', NULL, '2017-03-20 23:00:00', '2017-03-29 23:00:00'), (10, 'test', 'test again', 'test again and again', '2017-03-22 23:18:05', '2017-03-22 23:18:05'); -- -------------------------------------------------------- -- -- Table structure for table `role_user` -- CREATE TABLE `role_user` ( `user_id` int(10) UNSIGNED NOT NULL, `role_id` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `role_user` -- INSERT INTO `role_user` (`user_id`, `role_id`) VALUES (24, 1), (37, 3), (54, 3), (19, 7), (5, 8), (17, 9); -- -------------------------------------------------------- -- -- Table structure for table `tblactivemonth` -- CREATE TABLE `tblactivemonth` ( `activemonthID` int(11) NOT NULL, `month` varchar(10) NOT NULL, `year` varchar(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tblactivemonth` -- INSERT INTO `tblactivemonth` (`activemonthID`, `month`, `year`) VALUES (1, 'JUNE', '2017'); -- -------------------------------------------------------- -- -- Table structure for table `tblallocation` -- CREATE TABLE `tblallocation` ( `allocationID` int(11) NOT NULL, `descriptionID` int(11) NOT NULL, `month` varchar(15) NOT NULL, `year` varchar(4) NOT NULL, `allocation` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tblbudget` -- CREATE TABLE `tblbudget` ( `budgetID` int(11) NOT NULL, `descriptionID` int(11) NOT NULL, `year` varchar(4) NOT NULL, `proposedbudget` double NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tblbudget` -- INSERT INTO `tblbudget` (`budgetID`, `descriptionID`, `year`, `proposedbudget`) VALUES (1, 2, '2017', 1000000), (2, 2, '2019', 12), (4, 5, '2011', 152666), (5, 3, '2017', 1000255); -- -------------------------------------------------------- -- -- Table structure for table `tblcompany` -- CREATE TABLE `tblcompany` ( `companyID` int(11) NOT NULL, `companyname` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tblcompany` -- INSERT INTO `tblcompany` (`companyID`, `companyname`) VALUES (3, 'COMPANY B'), (4, 'COMPANY A'), (6, 'MBR'); -- -------------------------------------------------------- -- -- Table structure for table `tbldescription` -- CREATE TABLE `tbldescription` ( `descriptionID` int(11) NOT NULL, `groupID` int(11) NOT NULL, `name` varchar(200) NOT NULL, `code` varchar(10) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbldescription` -- INSERT INTO `tbldescription` (`descriptionID`, `groupID`, `name`, `code`) VALUES (2, 1, 'OVERTIME PAYMENTS', '1023'), (3, 1, 'SALARY', '101'), (4, 2, 'LOCAL TRAVEL & TRANSPORT TRAINING', '202'), (5, 2, 'DESCRIPTION A', '1235'); -- -------------------------------------------------------- -- -- Table structure for table `tblgroup` -- CREATE TABLE `tblgroup` ( `groupID` int(11) NOT NULL, `groupname` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tblgroup` -- INSERT INTO `tblgroup` (`groupID`, `groupname`) VALUES (1, 'RE-CURRENT'), (2, 'PERSONNEL'); -- -------------------------------------------------------- -- -- Table structure for table `tbltransaction` -- CREATE TABLE `tbltransaction` ( `transactionID` int(11) NOT NULL, `budgetID` int(11) NOT NULL, `companyID` int(11) NOT NULL, `description` varchar(200) NOT NULL, `amount` double NOT NULL, `month` varchar(15) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbltransaction` -- INSERT INTO `tbltransaction` (`transactionID`, `budgetID`, `companyID`, `description`, `amount`, `month`) VALUES (4, 4, 6, 'ASA', 1222, 'JUNE'), (5, 2, 6, 'TESRTING', 50000000, 'JUNE'), (6, 5, 6, 'ASASASSAD', 2555333, 'JUNE'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `remember_token` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `username`, `email`, `remember_token`, `password`, `created_at`, `updated_at`) VALUES (5, 'Olufemi Titilayo Samuel', 'teesam', 'olufemititilayosamuel@gmail.com', 'dQ2gNOpn4AFCAxDrKHvcXhsoqKjMOTISD1Y50PXKTajEc7KJhS3Hzz2Q0UpB', '$2y$10$ErpZP5c.IWcZMIdOfHjP2.U0XSge3Pa1TbHPySQI0pFhC2fJ4iDYS', '2016-08-31 11:50:44', '2017-03-16 09:24:54'), (159, 'samtee', 'samtee', 'teesam@yahoo.com', '', '$2y$10$AZ42wqIU2v8sAITduMHl3.fg5YsJhJKv7iWyn4POK2JYdOgqRn8Xq', '2017-03-22 21:51:57', '2017-03-22 21:51:57'); -- -- Indexes for dumped tables -- -- -- Indexes for table `audit_log` -- ALTER TABLE `audit_log` ADD PRIMARY KEY (`auditID`); -- -- Indexes for table `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `permissions_name_unique` (`name`); -- -- Indexes for table `permission_role` -- ALTER TABLE `permission_role` ADD PRIMARY KEY (`permission_id`,`role_id`), ADD KEY `permission_role_role_id_foreign` (`role_id`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `roles_name_unique` (`name`); -- -- Indexes for table `role_user` -- ALTER TABLE `role_user` ADD PRIMARY KEY (`user_id`,`role_id`), ADD KEY `role_user_role_id_foreign` (`role_id`); -- -- Indexes for table `tblactivemonth` -- ALTER TABLE `tblactivemonth` ADD PRIMARY KEY (`activemonthID`); -- -- Indexes for table `tblallocation` -- ALTER TABLE `tblallocation` ADD PRIMARY KEY (`allocationID`), ADD KEY `descriptionID` (`descriptionID`); -- -- Indexes for table `tblbudget` -- ALTER TABLE `tblbudget` ADD PRIMARY KEY (`budgetID`), ADD KEY `descriptionID` (`descriptionID`); -- -- Indexes for table `tblcompany` -- ALTER TABLE `tblcompany` ADD PRIMARY KEY (`companyID`); -- -- Indexes for table `tbldescription` -- ALTER TABLE `tbldescription` ADD PRIMARY KEY (`descriptionID`), ADD KEY `groupID` (`groupID`); -- -- Indexes for table `tblgroup` -- ALTER TABLE `tblgroup` ADD PRIMARY KEY (`groupID`); -- -- Indexes for table `tbltransaction` -- ALTER TABLE `tbltransaction` ADD PRIMARY KEY (`transactionID`), ADD KEY `budgetID` (`budgetID`), ADD KEY `companyID` (`companyID`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_username_unique` (`username`), ADD KEY `users_divisionid_foreign` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `audit_log` -- ALTER TABLE `audit_log` MODIFY `auditID` bigint(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45; -- -- AUTO_INCREMENT for table `permissions` -- ALTER TABLE `permissions` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `tblactivemonth` -- ALTER TABLE `tblactivemonth` MODIFY `activemonthID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tblallocation` -- ALTER TABLE `tblallocation` MODIFY `allocationID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `tblbudget` -- ALTER TABLE `tblbudget` MODIFY `budgetID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `tblcompany` -- ALTER TABLE `tblcompany` MODIFY `companyID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `tbldescription` -- ALTER TABLE `tbldescription` MODIFY `descriptionID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `tblgroup` -- ALTER TABLE `tblgroup` MODIFY `groupID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tbltransaction` -- ALTER TABLE `tbltransaction` MODIFY `transactionID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=160; -- -- Constraints for dumped tables -- -- -- Constraints for table `tblallocation` -- ALTER TABLE `tblallocation` ADD CONSTRAINT `tblallocation_ibfk_1` FOREIGN KEY (`descriptionID`) REFERENCES `tbldescription` (`descriptionID`); -- -- Constraints for table `tblbudget` -- ALTER TABLE `tblbudget` ADD CONSTRAINT `tblbudget_ibfk_1` FOREIGN KEY (`descriptionID`) REFERENCES `tbldescription` (`descriptionID`); -- -- Constraints for table `tbldescription` -- ALTER TABLE `tbldescription` ADD CONSTRAINT `tbldescription_ibfk_1` FOREIGN KEY (`groupID`) REFERENCES `tblgroup` (`groupID`); -- -- Constraints for table `tbltransaction` -- ALTER TABLE `tbltransaction` ADD CONSTRAINT `tbltransaction_ibfk_1` FOREIGN KEY (`budgetID`) REFERENCES `tblbudget` (`budgetID`), ADD CONSTRAINT `tbltransaction_ibfk_2` FOREIGN KEY (`companyID`) REFERENCES `tblcompany` (`companyID`); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;