-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jun 28, 2017 at 10:18 AM
-- Server version: 5.5.55-cll
-- PHP Version: 5.6.30

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: `portalfl_db`
--

-- --------------------------------------------------------

--
-- Table structure for table `apl_access_roles`
--

CREATE TABLE `apl_access_roles` (
  `role_id` int(11) NOT NULL,
  `role_name` varchar(225) NOT NULL,
  `modules` text NOT NULL,
  `privileges` text NOT NULL,
  `userid` int(11) NOT NULL,
  `time_created` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `apl_access_roles`
--

INSERT INTO `apl_access_roles` (`role_id`, `role_name`, `modules`, `privileges`, `userid`, `time_created`) VALUES
(1, 'Super Admin', '1,3,8,5,6,4,7', 'create_tickets,read_tickets,edit_tickets,delete_tickets,close_tickets,create_requisition,read_requisition,edit_requisition,delete_requisition,create_station,edit_station,delete_station,read_station,create_users,edit_users,delete_users,read_users,create_modules,edit_modules,delete_modules,read_modules,create_access,edit_access,delete_access,read_access,create_store_item,edit_store_item,delete_store_item,read_store_item,assign_ticket,assigned_ticket,close_ticket,reopen_ticket,all_ticket', 1, 1495975781),
(2, 'IT Support', '1', 'create_tickets,read_tickets,edit_tickets,delete_tickets,close_tickets,assign_ticket,assigned_ticket,close_ticket,reopen_ticket,user_ticket', 1, 1495976999),
(3, 'Station Staff', '1', 'create_tickets,read_tickets,user_ticket', 1, 1497009241);

-- --------------------------------------------------------

--
-- Table structure for table `apl_app_module`
--

CREATE TABLE `apl_app_module` (
  `module_id` int(11) NOT NULL,
  `module_name` varchar(225) NOT NULL,
  `module_link` text,
  `position` int(11) NOT NULL,
  `status` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `apl_app_module`
--

INSERT INTO `apl_app_module` (`module_id`, `module_name`, `module_link`, `position`, `status`) VALUES
(1, 'Tickets', 'tickets.php', 1, 'Active'),
(3, 'Requisition', 'requisition.php', 2, 'Active'),
(4, 'Manage Modules', 'module.php', 5, 'Active'),
(5, 'Out Stations', 'stations.php', 3, 'Active'),
(6, 'Manage Users', 'users.php', 4, 'Active'),
(7, 'Manage Access', 'access.php', 6, 'Active'),
(8, 'Store', 'store.php', 2, 'Active');

-- --------------------------------------------------------

--
-- Table structure for table `apl_assets`
--

CREATE TABLE `apl_assets` (
  `asset_id` int(11) NOT NULL,
  `asset_serial` smallint(5) UNSIGNED ZEROFILL NOT NULL,
  `asset_name` varchar(225) NOT NULL,
  `asset_desc` text NOT NULL,
  `power_rating` varchar(32) NOT NULL,
  `capacity` int(11) NOT NULL,
  `total_hours` int(11) NOT NULL,
  `service_hours` int(11) NOT NULL,
  `replace_hours` int(11) NOT NULL,
  `date_bought` date NOT NULL,
  `amount` double NOT NULL,
  `life_span` int(11) NOT NULL,
  `replace_alert` int(11) NOT NULL,
  `has_img` varchar(32) NOT NULL,
  `asset_img` longblob NOT NULL,
  `userid` int(11) NOT NULL,
  `time_created` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `apl_departments`
--

CREATE TABLE `apl_departments` (
  `dept_id` int(11) NOT NULL,
  `dept_name` varchar(225) NOT NULL,
  `userid` int(11) NOT NULL,
  `time_created` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `apl_departments`
--

INSERT INTO `apl_departments` (`dept_id`, `dept_name`, `userid`, `time_created`) VALUES
(2, 'Operations', 18, 1468434100),
(6, 'Procurement', 18, 1476285384),
(7, 'HR/Admin.', 18, 1476285421),
(8, 'IT/ICT', 37, 1478687614),
(9, 'QA/QC', 37, 1479389173),
(10, 'Finance', 37, 1479389634),
(11, 'Security', 37, 1479984296);

-- --------------------------------------------------------

--
-- Table structure for table `apl_designations`
--

CREATE TABLE `apl_designations` (
  `designation_id` int(11) NOT NULL,
  `dept_id` int(11) NOT NULL,
  `designations` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `apl_designations`
--

INSERT INTO `apl_designations` (`designation_id`, `dept_id`, `designations`) VALUES
(3, 2, 'Manager'),
(4, 2, 'Supervisor'),
(22, 6, 'Manager'),
(23, 6, 'Officer'),
(24, 7, 'Manager'),
(25, 7, 'Hr Officer'),
(26, 7, 'Admin Officer'),
(27, 2, 'Reporter'),
(28, 2, 'Planner'),
(29, 2, 'QAC'),
(30, 2, 'FSE'),
(31, 8, 'Staff'),
(32, 7, 'Office Assistant'),
(33, 9, 'Manager'),
(34, 9, 'Officer'),
(35, 10, 'Manager'),
(36, 10, 'Officer'),
(37, 2, 'AC Technician'),
(38, 11, 'Manager'),
(39, 11, 'Supervisor'),
(40, 6, 'Driver'),
(41, 6, 'Motor boy'),
(42, 11, 'Security Guard');

-- --------------------------------------------------------

--
-- Table structure for table `apl_employees`
--

CREATE TABLE `apl_employees` (
  `id` int(11) NOT NULL,
  `station_id` int(11) NOT NULL,
  `fullname` varchar(32) NOT NULL,
  `gender` varchar(32) NOT NULL,
  `phone` varchar(225) NOT NULL,
  `cooperate_email` varchar(225) NOT NULL,
  `password` text NOT NULL,
  `status` enum('Active','Inactive') NOT NULL,
  `created_by` int(11) NOT NULL,
  `access_role` int(11) NOT NULL,
  `last_loggedin2` int(11) NOT NULL,
  `time_created` int(11) NOT NULL,
  `first_loggin` int(11) NOT NULL,
  `last_loggedin` int(11) NOT NULL,
  `changed_password` enum('Yes','No') NOT NULL,
  `dropped` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `apl_employees`
--

INSERT INTO `apl_employees` (`id`, `station_id`, `fullname`, `gender`, `phone`, `cooperate_email`, `password`, `status`, `created_by`, `access_role`, `last_loggedin2`, `time_created`, `first_loggin`, `last_loggedin`, `changed_password`, `dropped`) VALUES
(1, 1, 'Samuel', 'Male', '07039513207', 'ikenna.onyejiaka@flyairpeace.com', '202cb962ac59075b964b07152d234b70', 'Active', 18, 1, 0, 1468585098, 1469106445, 1486557087, 'Yes', 0),
(2, 1, 'Ikenna', 'Male', '07039513207', 'onyejiaka.samuel@gmail.com', '202cb962ac59075b964b07152d234b70', 'Active', 1, 3, 0, 1468585098, 1469106445, 1486557087, 'Yes', 0),
(3, 2, 'Onyejiaka Ikenna', 'Male', '07039513207', 'ikenna@flyairpeace.com', '202cb962ac59075b964b07152d234b70', 'Active', 1, 3, 0, 1496947388, 0, 0, 'Yes', 0),
(4, 3, 'Samuel Ikenna', 'Male', '07039513207', 'samuel.onyejiaka@flyairpeace.com', '202cb962ac59075b964b07152d234b70', 'Active', 1, 3, 0, 1496947775, 0, 0, 'Yes', 0);

-- --------------------------------------------------------

--
-- Table structure for table `apl_employee_doc`
--

CREATE TABLE `apl_employee_doc` (
  `doc_id` int(11) NOT NULL,
  `emp_id` varchar(32) NOT NULL,
  `resume` text NOT NULL,
  `offer_letter` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `apl_it_stock_dispatch`
--

CREATE TABLE `apl_it_stock_dispatch` (
  `dispatch_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `qty_dispatched` double NOT NULL,
  `dispatched_to` varchar(225) NOT NULL,
  `dispatched_by` int(11) NOT NULL,
  `dispatch_reason` text NOT NULL,
  `date_dispatched` varchar(32) NOT NULL,
  `time_created` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `apl_it_stock_received`
--

CREATE TABLE `apl_it_stock_received` (
  `received_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `qty_received` double NOT NULL,
  `date_received` date NOT NULL,
  `received_by` int(11) NOT NULL,
  `remarks` text NOT NULL,
  `time_created` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `apl_it_store_item`
--

CREATE TABLE `apl_it_store_item` (
  `item_id` int(11) NOT NULL,
  `item_name` varchar(225) NOT NULL,
  `time_created` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `apl_requisition`
--

CREATE TABLE `apl_requisition` (
  `requisition_id` int(11) NOT NULL,
  `reference` smallint(5) UNSIGNED ZEROFILL NOT NULL,
  `requested_by` int(11) NOT NULL,
  `department` int(11) NOT NULL,
  `designation` int(11) NOT NULL,
  `delivery_date` varchar(32) NOT NULL,
  `request_reason` text NOT NULL,
  `approval_status` enum('Approved','Not Approved') NOT NULL,
  `approval_status_date` varchar(32) NOT NULL,
  `time_created` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `apl_requisition_items`
--

CREATE TABLE `apl_requisition_items` (
  `item_id` int(11) NOT NULL,
  `requisition_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `quantity` double NOT NULL,
  `remarks` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `apl_station`
--

CREATE TABLE `apl_station` (
  `station_id` int(11) NOT NULL,
  `station_name` varchar(225) NOT NULL,
  `userid` int(11) NOT NULL,
  `time_created` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `apl_station`
--

INSERT INTO `apl_station` (`station_id`, `station_name`, `userid`, `time_created`) VALUES
(1, 'HQ', 1, 1496937498),
(2, 'Lagos GAT', 1, 1496937639),
(3, 'Lasgos Int&#39;l', 1, 1496937647),
(4, 'Abuja', 1, 1496937661),
(5, 'Uyo', 1, 1496937666),
(6, 'Port Harcourt', 1, 1496937686),
(7, 'Calabar', 1, 1496937692),
(8, 'Enugu', 1, 1496937696),
(9, 'Owerri', 1, 1496937700),
(10, 'Benin', 1, 1496937756),
(11, 'Sokoto', 1, 1496937952),
(12, 'Kaduna', 1, 1496937957),
(13, 'Ghana', 1, 1496937960);

-- --------------------------------------------------------

--
-- Table structure for table `apl_tickets`
--

CREATE TABLE `apl_tickets` (
  `ticket_id` int(11) NOT NULL,
  `ticket_ref` tinyint(4) UNSIGNED ZEROFILL NOT NULL,
  `created_by` int(11) NOT NULL,
  `station_id` int(11) NOT NULL,
  `severity` varchar(32) NOT NULL,
  `ticket_subject` varchar(150) NOT NULL,
  `ticket_desc` text NOT NULL,
  `assigned` int(11) NOT NULL,
  `date_assigned` int(11) NOT NULL,
  `time_created` int(11) NOT NULL,
  `status` varchar(35) NOT NULL,
  `opened_date` date NOT NULL,
  `close_date` int(11) NOT NULL,
  `closed_by` int(11) NOT NULL,
  `dropped` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `apl_tickets`
--

INSERT INTO `apl_tickets` (`ticket_id`, `ticket_ref`, `created_by`, `station_id`, `severity`, `ticket_subject`, `ticket_desc`, `assigned`, `date_assigned`, `time_created`, `status`, `opened_date`, `close_date`, `closed_by`, `dropped`) VALUES
(1, 0001, 1, 1, 'Normal Level', 'Unable to access my Crane', 'sample description', 1, 0, 1496223238, 'Closed', '2017-05-31', 0, 0, 0),
(2, 0002, 1, 1, 'Low Level', 'Unable to access my Crane', 'sample', 1, 0, 1496223527, 'Closed', '2017-05-31', 0, 0, 0),
(3, 0003, 1, 1, 'High Level', 'Unable to access my Crane', 'adwdDDsad', 1, 0, 1496405557, 'Open', '2017-06-02', 0, 0, 0),
(4, 0004, 3, 1, 'Low Level', 'Unable to access my website', 'dsadasdasd', 2, 1497370022, 1496655878, 'Open', '2017-06-05', 0, 0, 0),
(5, 0005, 3, 2, 'High Level', 'sample Ticket from my station', 'xfvxzcxzczxcxzczxczxc', 4, 1497522634, 0, 'Closed', '2017-06-15', 0, 0, 0),
(6, 0005, 1, 1, 'Normal Level', 'Another sample Ticket from my station', 'dfghlookhjgfhjhgcjhgjhgh', 2, 1497613020, 1497613020, 'In Progress', '2017-06-16', 0, 0, 0),
(7, 0006, 1, 1, 'High Level', 'Well, Another sample Ticket from my station', 'jsbkjbjhsabvdhlkjhfliewfnb', 2, 1497613343, 1497613343, 'In Progress', '2017-06-16', 0, 0, 0),
(8, 0007, 1, 1, 'Low Level', 'A sample Ticket from my station', 'adqtdsfxdadas', 1, 1497617585, 1497617585, 'In Progress', '2017-06-16', 0, 0, 0),
(9, 0008, 1, 1, 'Low Level', 'A sample Ticket from my station', 'adqtdsfxdadas', 1, 1497617754, 1497617754, 'In Progress', '2017-06-16', 0, 0, 0),
(10, 0009, 1, 1, 'Low Level', 'A sample Ticket from my station', 'adqtdsfxdadas', 1, 1497617904, 1497617904, 'In Progress', '2017-06-16', 0, 0, 0),
(16, 0010, 3, 2, 'High Level', 'Another sample Ticket from my station', 'Sample Trouble Ticket', 0, 0, 1497963968, 'Open', '2017-06-20', 0, 0, 0),
(17, 0011, 2, 1, 'Normal Level', 'Another sample Ticket from my station', 'Another sample Ticket from my station Another sample Ticket from my station', 1, 1497966111, 1497965802, 'In Progress', '2017-06-20', 0, 0, 0),
(18, 0012, 2, 1, 'High Level', 'Poor Network Connectivity at HR Building', 'Hello ITSUPPORTDESK,\r\n\r\nNetwork Connectivity has been poor at the HR Building this morning, Please kindly lookinto it as we have major Series Movies This Morning That needs to be downloaded ad watched during the forth coming Sallah Holiday.\r\n\r\nThank you.', 0, 0, 1498031956, 'Open', '2017-06-21', 0, 0, 0),
(19, 0013, 1, 1, 'High Level', 'Printer: Install Black Cartridge', 'Printer is bad', 1, 1498033655, 1498033655, 'In Progress', '2017-06-21', 0, 0, 0),
(20, 0014, 1, 1, 'High Level', 'Re: Install Black Cartridge', 'Hi IT,\r\nPlease I want to know if you have made any provision for attachment or it should be done with email', 1, 1498034188, 1498034188, 'In Progress', '2017-06-21', 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `apl_ticket_assignment`
--

CREATE TABLE `apl_ticket_assignment` (
  `assignment_id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `assigned_to` int(11) NOT NULL,
  `assigned_by` int(11) NOT NULL,
  `date_assigned` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `apl_ticket_assignment`
--

INSERT INTO `apl_ticket_assignment` (`assignment_id`, `ticket_id`, `assigned_to`, `assigned_by`, `date_assigned`) VALUES
(1, 4, 4, 1, 1497356302),
(2, 4, 1, 1, 1497369798),
(3, 4, 2, 1, 1497370022),
(4, 5, 4, 1, 1497522634),
(5, 0, 2, 1, 1497613343),
(6, 0, 1, 1, 1497617585),
(7, 0, 1, 1, 1497617754),
(8, 0, 1, 1, 1497617904),
(9, 17, 1, 1, 1497966111),
(10, 19, 1, 1, 1498033655),
(11, 20, 1, 1, 1498034188);

-- --------------------------------------------------------

--
-- Table structure for table `apl_ticket_comment`
--

CREATE TABLE `apl_ticket_comment` (
  `comment_id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `comment` text NOT NULL,
  `commented_by` int(11) NOT NULL,
  `time_created` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `apl_ticket_comment`
--

INSERT INTO `apl_ticket_comment` (`comment_id`, `ticket_id`, `comment`, `commented_by`, `time_created`) VALUES
(1, 2, 'done', 1, 1496236687),
(2, 2, 'ruift', 1, 1496236724),
(3, 2, 'iujhhljjvjh', 1, 1496236850),
(4, 7, 'new comment', 1, 1497614540),
(5, 7, 'sample comment', 1, 1497615023),
(6, 7, 'hello comment', 1, 1497615733),
(7, 7, 'nice comment', 1, 1497615786),
(8, 7, 'nice comment', 1, 1497615895),
(9, 7, 'See Comments', 1, 1497616185),
(10, 7, 'See Comments', 1, 1497616338),
(11, 17, 'Sample comment on ticket ATT0011-1', 1, 1497967430),
(12, 20, 'good', 1, 1498037204),
(13, 3, 'ok', 1, 1498487769);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `apl_access_roles`
--
ALTER TABLE `apl_access_roles`
  ADD PRIMARY KEY (`role_id`);

--
-- Indexes for table `apl_app_module`
--
ALTER TABLE `apl_app_module`
  ADD PRIMARY KEY (`module_id`);

--
-- Indexes for table `apl_assets`
--
ALTER TABLE `apl_assets`
  ADD PRIMARY KEY (`asset_id`),
  ADD UNIQUE KEY `asset_serial_2` (`asset_serial`),
  ADD KEY `asset_serial` (`asset_serial`);

--
-- Indexes for table `apl_departments`
--
ALTER TABLE `apl_departments`
  ADD PRIMARY KEY (`dept_id`);

--
-- Indexes for table `apl_designations`
--
ALTER TABLE `apl_designations`
  ADD PRIMARY KEY (`designation_id`);

--
-- Indexes for table `apl_employees`
--
ALTER TABLE `apl_employees`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `apl_employee_doc`
--
ALTER TABLE `apl_employee_doc`
  ADD PRIMARY KEY (`doc_id`);

--
-- Indexes for table `apl_it_stock_dispatch`
--
ALTER TABLE `apl_it_stock_dispatch`
  ADD PRIMARY KEY (`dispatch_id`);

--
-- Indexes for table `apl_it_stock_received`
--
ALTER TABLE `apl_it_stock_received`
  ADD PRIMARY KEY (`received_id`);

--
-- Indexes for table `apl_it_store_item`
--
ALTER TABLE `apl_it_store_item`
  ADD PRIMARY KEY (`item_id`);

--
-- Indexes for table `apl_requisition`
--
ALTER TABLE `apl_requisition`
  ADD PRIMARY KEY (`requisition_id`);

--
-- Indexes for table `apl_requisition_items`
--
ALTER TABLE `apl_requisition_items`
  ADD PRIMARY KEY (`item_id`);

--
-- Indexes for table `apl_station`
--
ALTER TABLE `apl_station`
  ADD PRIMARY KEY (`station_id`);

--
-- Indexes for table `apl_tickets`
--
ALTER TABLE `apl_tickets`
  ADD PRIMARY KEY (`ticket_id`);

--
-- Indexes for table `apl_ticket_assignment`
--
ALTER TABLE `apl_ticket_assignment`
  ADD PRIMARY KEY (`assignment_id`);

--
-- Indexes for table `apl_ticket_comment`
--
ALTER TABLE `apl_ticket_comment`
  ADD PRIMARY KEY (`comment_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `apl_access_roles`
--
ALTER TABLE `apl_access_roles`
  MODIFY `role_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `apl_app_module`
--
ALTER TABLE `apl_app_module`
  MODIFY `module_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `apl_assets`
--
ALTER TABLE `apl_assets`
  MODIFY `asset_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `apl_departments`
--
ALTER TABLE `apl_departments`
  MODIFY `dept_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `apl_designations`
--
ALTER TABLE `apl_designations`
  MODIFY `designation_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;
--
-- AUTO_INCREMENT for table `apl_employees`
--
ALTER TABLE `apl_employees`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `apl_employee_doc`
--
ALTER TABLE `apl_employee_doc`
  MODIFY `doc_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `apl_it_stock_dispatch`
--
ALTER TABLE `apl_it_stock_dispatch`
  MODIFY `dispatch_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `apl_it_stock_received`
--
ALTER TABLE `apl_it_stock_received`
  MODIFY `received_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `apl_it_store_item`
--
ALTER TABLE `apl_it_store_item`
  MODIFY `item_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `apl_requisition`
--
ALTER TABLE `apl_requisition`
  MODIFY `requisition_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `apl_requisition_items`
--
ALTER TABLE `apl_requisition_items`
  MODIFY `item_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `apl_station`
--
ALTER TABLE `apl_station`
  MODIFY `station_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `apl_tickets`
--
ALTER TABLE `apl_tickets`
  MODIFY `ticket_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `apl_ticket_assignment`
--
ALTER TABLE `apl_ticket_assignment`
  MODIFY `assignment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `apl_ticket_comment`
--
ALTER TABLE `apl_ticket_comment`
  MODIFY `comment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
/*!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 */;
