-- https://www.phpmyadmin.net/
--

START TRANSACTION;

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

--
-- Table structure for table `app_profile`
--

CREATE TABLE `app_profile` (
  `app_id` int(10) UNSIGNED NOT NULL,
  `profile_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `app_scope`
--

CREATE TABLE `app_scope` (
  `app_id` int(10) UNSIGNED NOT NULL,
  `scope_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `app_webhook`
--

CREATE TABLE `app_webhook` (
  `app_id` int(10) UNSIGNED NOT NULL,
  `webhook_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `auth_profile`
--

CREATE TABLE `auth_profile` (
  `auth_id` int(10) UNSIGNED NOT NULL,
  `profile_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_profile`
--

INSERT INTO `auth_profile` (`auth_id`, `profile_id`) VALUES
(1, 1),
(2, 1);

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

--
-- Table structure for table `history`
--

CREATE TABLE `history` (
  `history_id` int(10) UNSIGNED NOT NULL,
  `history_activity` text,
  `history_page` text,
  `history_path` varchar(255) DEFAULT NULL,
  `history_type` varchar(255) DEFAULT NULL,
  `history_table_name` varchar(255) DEFAULT NULL,
  `history_table_id` varchar(255) DEFAULT NULL,
  `history_flag` int(1) UNSIGNED DEFAULT '0',
  `history_active` int(1) UNSIGNED DEFAULT '1',
  `history_created` datetime DEFAULT NULL,
  `history_updated` datetime DEFAULT NULL,
  `history_remote_address` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `history_profile`
--

CREATE TABLE `history_profile` (
  `history_id` int(10) UNSIGNED NOT NULL,
  `profile_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hour`
--

CREATE TABLE `hour` (
  `hour_id` int(10) UNSIGNED NOT NULL,
  `hour_date` date DEFAULT NULL,
  `hour_time_in` time DEFAULT '00:00:00',
  `hour_time_out` time DEFAULT '00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `hour_profile`
--

CREATE TABLE `hour_profile` (
  `hour_id` int(10) UNSIGNED NOT NULL,
  `profile_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loan`
--

CREATE TABLE `loan` (
  `loan_id` int(10) UNSIGNED NOT NULL,
  `loan_amount` float(10,2) DEFAULT '0.00',
  `loan_type` varchar(255) DEFAULT 'bale',
  `loan_created` datetime DEFAULT NULL,
  `loan_updated` datetime DEFAULT NULL,
  `loan_identifier` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loan_profile`
--

CREATE TABLE `loan_profile` (
  `loan_id` int(10) UNSIGNED NOT NULL,
  `profile_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `payment_id` int(10) UNSIGNED NOT NULL,
  `payment_amount` float(10,2) DEFAULT '0.00',
  `payment_type` varchar(255) DEFAULT 'bale',
  `payment_created` datetime DEFAULT NULL,
  `payment_updated` datetime DEFAULT NULL,
  `payment_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `payment_loan`
--

CREATE TABLE `payment_loan` (
  `payment_id` int(10) UNSIGNED NOT NULL,
  `loan_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `payment_profile`
--

CREATE TABLE `payment_profile` (
  `payment_id` int(10) UNSIGNED NOT NULL,
  `profile_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `payslip`
--

CREATE TABLE `payslip` (
  `payslip_id` int(10) UNSIGNED NOT NULL,
  `payslip_start` date DEFAULT NULL,
  `payslip_end` date DEFAULT NULL,
  `payslip_total_work_hours` float(4,2) DEFAULT NULL,
  `payslip_total_overtime_hours` float(4,2) DEFAULT '0.00',
  `payslip_total_loan_payment` float(10,2) DEFAULT '0.00',
  `payslip_total_late_time` int(10) DEFAULT '0',
  `payslip_total_late_occurrence` int(10) DEFAULT '0',
  `payslip_work_hours` json DEFAULT NULL,
  `payslip_total_late_deduction` float(10,2) DEFAULT '0.00',
  `payslip_total_pay` float(10,2) DEFAULT NULL,
  `payslip_work_pay` float(10,2) DEFAULT NULL,
  `payslip_ot_pay` float(10,2) DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `payslip_hour`
--

CREATE TABLE `payslip_hour` (
  `payslip_id` int(10) UNSIGNED NOT NULL,
  `hour_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `payslip_loan`
--

CREATE TABLE `payslip_loan` (
  `payslip_id` int(10) UNSIGNED NOT NULL,
  `loan_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `payslip_payment`
--

CREATE TABLE `payslip_payment` (
  `payslip_id` int(10) UNSIGNED NOT NULL,
  `payment_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `payslip_profile`
--

CREATE TABLE `payslip_profile` (
  `payslip_id` int(10) UNSIGNED NOT NULL,
  `profile_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `profile`
--

CREATE TABLE `profile` (
  `profile_id` int(10) UNSIGNED NOT NULL,
  `profile_name` varchar(255) DEFAULT NULL,
  `profile_active` int(1) UNSIGNED DEFAULT '1',
  `profile_created` datetime DEFAULT NULL,
  `profile_updated` datetime DEFAULT NULL,
  `profile_hourly_rate` float(10,2) DEFAULT NULL,
  `profile_overtime_rate` float(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `profile`
--

INSERT INTO `profile` (`profile_id`, `profile_name`, `profile_active`, `profile_created`, `profile_updated`, `profile_hourly_rate`, `profile_overtime_rate`) VALUES
(1, 'ADMIN', 1, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `rest`
--

CREATE TABLE `rest` (
  `rest_id` int(10) UNSIGNED NOT NULL,
  `rest_title` varchar(255) DEFAULT NULL,
  `rest_type` varchar(255) DEFAULT 'public',
  `rest_method` varchar(255) DEFAULT 'all',
  `rest_path` varchar(255) DEFAULT NULL,
  `rest_event` varchar(255) DEFAULT NULL,
  `rest_parameters` json DEFAULT NULL,
  `rest_detail` text,
  `rest_sample_request` text,
  `rest_sample_response` text,
  `rest_active` int(1) UNSIGNED DEFAULT '1',
  `rest_created` datetime DEFAULT NULL,
  `rest_updated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `role`
--

CREATE TABLE `role` (
  `role_id` int(10) UNSIGNED NOT NULL,
  `role_name` varchar(255) DEFAULT NULL,
  `role_slug` varchar(255) DEFAULT NULL,
  `role_locked` int(1) UNSIGNED DEFAULT '0',
  `role_permissions` json DEFAULT NULL,
  `role_admin_menu` json DEFAULT NULL,
  `role_active` int(1) UNSIGNED DEFAULT '1',
  `role_created` datetime DEFAULT NULL,
  `role_updated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `role`
--

INSERT INTO `role` (`role_id`, `role_name`, `role_slug`, `role_locked`, `role_permissions`, `role_admin_menu`, `role_active`, `role_created`, `role_updated`) VALUES
(1, 'Developer', 'developer', 1, '[{\"path\": \"**\", \"label\": \"All Access\", \"method\": \"all\"}]', '[{\"icon\": \"fas fa-tachometer-alt\", \"path\": \"/admin/dashboard\", \"label\": \"Dashboard\"}, {\"icon\": \"fas fa-coffee\", \"path\": \"#menu-admin\", \"label\": \"Admin\", \"children\": [{\"icon\": \"fas fa-user\", \"path\": \"/admin/system/model/profile/search\", \"label\": \"Profiles\"}, {\"icon\": \"fas fa-lock\", \"path\": \"/admin/system/model/auth/search\", \"label\": \"Auth\"}, {\"icon\": \"fas fa-key\", \"path\": \"/admin/system/model/role/search\", \"label\": \"Roles\"}]}, {\"icon\": \"fas fa-code\", \"path\": \"#menu-api\", \"label\": \"API\", \"children\": [{\"icon\": \"fas fa-mobile-alt\", \"path\": \"/admin/system/model/app/search\", \"label\": \"Applications\"}, {\"icon\": \"fas fa-address-card\", \"path\": \"/admin/system/model/session/search\", \"label\": \"Sessions\"}, {\"icon\": \"fas fa-crosshairs\", \"path\": \"/admin/system/model/scope/search\", \"label\": \"Scopes\"}, {\"icon\": \"fas fa-phone\", \"path\": \"/admin/system/model/rest/search\", \"label\": \"REST Calls\"}, {\"icon\": \"fas fa-comments\", \"path\": \"/admin/system/model/webhook/search\", \"label\": \"Webhooks\"}]}, {\"icon\": \"fas fa-server\", \"path\": \"#menu-system\", \"label\": \"System\", \"children\": [{\"icon\": \"fas fa-database\", \"path\": \"/admin/system/schema/search\", \"label\": \"Schemas\"}, {\"icon\": \"fas fa-sliders-h\", \"path\": \"/admin/system/fieldset/search\", \"label\": \"Fieldsets\"}, {\"icon\": \"fas fa-cogs\", \"path\": \"/admin/configuration\", \"label\": \"Configuration\"}, {\"icon\": \"fas fa-plug\", \"path\": \"/admin/package/search\", \"label\": \"Packages\"}]}, {\"icon\": \"fas fa-columns\", \"path\": \"#menu-templates\", \"label\": \"Templates\", \"children\": [{\"icon\": \"fas fa-puzzle-piece\", \"path\": \"/admin/template/ui\", \"label\": \"UI\"}, {\"icon\": \"fas fa-search\", \"path\": \"/admin/template/search\", \"label\": \"Search\"}, {\"icon\": \"fas fa-sliders-h\", \"path\": \"/admin/template/form\", \"label\": \"Form\"}]}]', 1, '2019-03-29 10:34:53', '2019-03-29 10:34:54'),
(2, 'Admin', 'admin', 1, '[{\"path\": \"/admin\", \"label\": \"Admin Dashboard\", \"method\": \"all\"}, {\"path\": \"/admin/**\", \"label\": \"All Admin Access\", \"method\": \"all\"}, {\"path\": \"(?!/(admin))/**\", \"label\": \"All Front End Access\", \"method\": \"all\"}]', '[{\"icon\": \"fas fa-users\", \"path\": \"#menu-employees\", \"label\": \"Employees\", \"children\": [{\"icon\": \"fas fa-table\", \"path\": \"/admin/profile/search\", \"label\": \"List Employees\"}, {\"icon\": \"fas fa-plus\", \"path\": \"/admin/profile/create?redirect_uri=%2Fadmin%2Fprofile%2Fsearch\", \"label\": \"Create Employees\"}]}, {\"icon\": \"fas fa-history\", \"path\": \"#menu-hours\", \"label\": \"Hours\", \"children\": [{\"icon\": \"fas fa-table\", \"path\": \"/admin/hour/search\", \"label\": \"List Hours\"}, {\"icon\": \"fas fa-plus\", \"path\": \"/admin/hour/create?redirect_uri=%2Fadmin%2Fhour%2Fsearch\", \"label\": \"Insert Hours\"}]}, {\"icon\": \"fas fa-file-alt\", \"path\": \"/admin/payslip/search\", \"label\": \"Payslip\"}, {\"icon\": \"fas fa-calculator\", \"path\": \"/admin/payroll/calculator\", \"label\": \"Calculator\"}]', 1, '2019-03-29 10:34:54', '2019-04-28 03:10:54'),
(3, 'Guest', 'guest', 1, '[{\"path\": \"(?!/(admin))/**\", \"label\": \"All Front End Access\", \"method\": \"all\"}]', '[]', 1, '2019-03-29 10:34:54', '2019-03-29 10:34:54');

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

--
-- Table structure for table `scope`
--

CREATE TABLE `scope` (
  `scope_id` int(10) UNSIGNED NOT NULL,
  `scope_name` varchar(255) DEFAULT NULL,
  `scope_slug` varchar(255) DEFAULT NULL,
  `scope_type` varchar(255) DEFAULT 'app',
  `scope_detail` text,
  `scope_special_approval` int(1) UNSIGNED DEFAULT '0',
  `scope_active` int(1) UNSIGNED DEFAULT '1',
  `scope_created` datetime DEFAULT NULL,
  `scope_updated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `scope_rest`
--

CREATE TABLE `scope_rest` (
  `scope_id` int(10) UNSIGNED NOT NULL,
  `rest_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `webhook`
--

CREATE TABLE `webhook` (
  `webhook_id` int(10) UNSIGNED NOT NULL,
  `webhook_title` varchar(255) DEFAULT NULL,
  `webhook_type` varchar(255) DEFAULT 'app',
  `webhook_detail` text,
  `webhook_event` varchar(255) DEFAULT NULL,
  `webhook_parameters` json DEFAULT NULL,
  `webhook_method` varchar(255) DEFAULT 'all',
  `webhook_action` varchar(255) DEFAULT NULL,
  `webhook_sample_response` text,
  `webhook_active` int(1) UNSIGNED DEFAULT '1',
  `webhook_created` datetime DEFAULT NULL,
  `webhook_updated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for table `app_profile`
--
ALTER TABLE `app_profile`
  ADD PRIMARY KEY (`app_id`,`profile_id`);

--
-- Indexes for table `app_scope`
--
ALTER TABLE `app_scope`
  ADD PRIMARY KEY (`app_id`,`scope_id`);

--
-- Indexes for table `app_webhook`
--
ALTER TABLE `app_webhook`
  ADD PRIMARY KEY (`app_id`,`webhook_id`);

--
-- Indexes for table `auth_profile`
--
ALTER TABLE `auth_profile`
  ADD PRIMARY KEY (`auth_id`,`profile_id`);

--
-- Indexes for table `history`
--
ALTER TABLE `history`
  ADD PRIMARY KEY (`history_id`),
  ADD KEY `history_table_name` (`history_table_name`),
  ADD KEY `history_table_id` (`history_table_id`),
  ADD KEY `history_active` (`history_active`),
  ADD KEY `history_created` (`history_created`),
  ADD KEY `history_updated` (`history_updated`);

--
-- Indexes for table `history_profile`
--
ALTER TABLE `history_profile`
  ADD PRIMARY KEY (`history_id`,`profile_id`);

--
-- Indexes for table `hour`
--
ALTER TABLE `hour`
  ADD PRIMARY KEY (`hour_id`),
  ADD KEY `hour_date` (`hour_date`),
  ADD KEY `hour_time_in` (`hour_time_in`,`hour_time_out`);

--
-- Indexes for table `hour_profile`
--
ALTER TABLE `hour_profile`
  ADD PRIMARY KEY (`hour_id`,`profile_id`);

--
-- Indexes for table `loan`
--
ALTER TABLE `loan`
  ADD PRIMARY KEY (`loan_id`),
  ADD KEY `loan_amount` (`loan_amount`),
  ADD KEY `loan_type` (`loan_type`),
  ADD KEY `loan_created` (`loan_created`,`loan_updated`),
  ADD KEY `loan_identifier` (`loan_identifier`);

--
-- Indexes for table `loan_profile`
--
ALTER TABLE `loan_profile`
  ADD PRIMARY KEY (`loan_id`,`profile_id`);

--
-- Indexes for table `payment`
--
ALTER TABLE `payment`
  ADD PRIMARY KEY (`payment_id`),
  ADD KEY `payment_amount` (`payment_amount`),
  ADD KEY `payment_type` (`payment_type`),
  ADD KEY `payment_created` (`payment_created`,`payment_updated`),
  ADD KEY `payment_date` (`payment_date`);

--
-- Indexes for table `payment_loan`
--
ALTER TABLE `payment_loan`
  ADD PRIMARY KEY (`payment_id`,`loan_id`);

--
-- Indexes for table `payment_profile`
--
ALTER TABLE `payment_profile`
  ADD PRIMARY KEY (`payment_id`,`profile_id`);

--
-- Indexes for table `payslip`
--
ALTER TABLE `payslip`
  ADD PRIMARY KEY (`payslip_id`),
  ADD KEY `payslip_start` (`payslip_start`),
  ADD KEY `payslip_end` (`payslip_end`),
  ADD KEY `payslip_total_work_hours` (`payslip_total_work_hours`);

--
-- Indexes for table `payslip_hour`
--
ALTER TABLE `payslip_hour`
  ADD PRIMARY KEY (`payslip_id`,`hour_id`);

--
-- Indexes for table `payslip_loan`
--
ALTER TABLE `payslip_loan`
  ADD PRIMARY KEY (`payslip_id`,`loan_id`);

--
-- Indexes for table `payslip_payment`
--
ALTER TABLE `payslip_payment`
  ADD PRIMARY KEY (`payslip_id`,`payment_id`);

--
-- Indexes for table `payslip_profile`
--
ALTER TABLE `payslip_profile`
  ADD PRIMARY KEY (`payslip_id`,`profile_id`);

--
-- Indexes for table `profile`
--
ALTER TABLE `profile`
  ADD PRIMARY KEY (`profile_id`),
  ADD KEY `profile_name` (`profile_name`),
  ADD KEY `profile_active` (`profile_active`),
  ADD KEY `profile_created` (`profile_created`),
  ADD KEY `profile_updated` (`profile_updated`),
  ADD KEY `profile_hourly_rate` (`profile_hourly_rate`,`profile_overtime_rate`);

--
-- Indexes for table `rest`
--
ALTER TABLE `rest`
  ADD PRIMARY KEY (`rest_id`),
  ADD KEY `rest_title` (`rest_title`),
  ADD KEY `rest_type` (`rest_type`),
  ADD KEY `rest_method` (`rest_method`),
  ADD KEY `rest_path` (`rest_path`),
  ADD KEY `rest_event` (`rest_event`),
  ADD KEY `rest_active` (`rest_active`),
  ADD KEY `rest_created` (`rest_created`),
  ADD KEY `rest_updated` (`rest_updated`);

--
-- Indexes for table `role`
--
ALTER TABLE `role`
  ADD PRIMARY KEY (`role_id`),
  ADD KEY `role_name` (`role_name`),
  ADD KEY `role_slug` (`role_slug`),
  ADD KEY `role_locked` (`role_locked`),
  ADD KEY `role_active` (`role_active`),
  ADD KEY `role_created` (`role_created`),
  ADD KEY `role_updated` (`role_updated`);

--
-- Indexes for table `scope`
--
ALTER TABLE `scope`
  ADD PRIMARY KEY (`scope_id`),
  ADD KEY `scope_name` (`scope_name`),
  ADD KEY `scope_slug` (`scope_slug`),
  ADD KEY `scope_type` (`scope_type`),
  ADD KEY `scope_special_approval` (`scope_special_approval`),
  ADD KEY `scope_active` (`scope_active`),
  ADD KEY `scope_created` (`scope_created`),
  ADD KEY `scope_updated` (`scope_updated`);

--
-- Indexes for table `scope_rest`
--
ALTER TABLE `scope_rest`
  ADD PRIMARY KEY (`scope_id`,`rest_id`);

--
-- Indexes for table `webhook`
--
ALTER TABLE `webhook`
  ADD PRIMARY KEY (`webhook_id`),
  ADD KEY `webhook_title` (`webhook_title`),
  ADD KEY `webhook_type` (`webhook_type`),
  ADD KEY `webhook_event` (`webhook_event`),
  ADD KEY `webhook_method` (`webhook_method`),
  ADD KEY `webhook_action` (`webhook_action`),
  ADD KEY `webhook_active` (`webhook_active`),
  ADD KEY `webhook_created` (`webhook_created`),
  ADD KEY `webhook_updated` (`webhook_updated`);

--
-- AUTO_INCREMENT for table `history`
--
ALTER TABLE `history`
  MODIFY `history_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hour`
--
ALTER TABLE `hour`
  MODIFY `hour_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `loan`
--
ALTER TABLE `loan`
  MODIFY `loan_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment`
--
ALTER TABLE `payment`
  MODIFY `payment_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payslip`
--
ALTER TABLE `payslip`
  MODIFY `payslip_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `profile`
--
ALTER TABLE `profile`
  MODIFY `profile_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `rest`
--
ALTER TABLE `rest`
  MODIFY `rest_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `role`
--
ALTER TABLE `role`
  MODIFY `role_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `scope`
--
ALTER TABLE `scope`
  MODIFY `scope_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `webhook`
--
ALTER TABLE `webhook`
  MODIFY `webhook_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;
