--
-- Host: localhost    Database: fasaadmin_com
-- ------------------------------------------------------


--
-- Table structure for table `faman_auth_assignment`
--

CREATE TABLE `faman_auth_assignment` (
  `item_name` varchar(64) NOT NULL,
  `user_id` varchar(64) NOT NULL,
  `created_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`item_name`,`user_id`),
  CONSTRAINT `faman_auth_assignment_ibfk_1` FOREIGN KEY (`item_name`) REFERENCES `faman_auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `faman_auth_assignment`
--

INSERT INTO `faman_auth_assignment` VALUES ('authenticated','47',1499238204),('customer_service_manager','40',1491252240),('resapi_invoice_admin','242',1510071995),('resapi.admin','42',1497896621),('resapi.scique','46',1499088760),('super_admin','35',1471452388);

--
-- Table structure for table `faman_auth_item`
--

CREATE TABLE `faman_auth_item` (
  `name` varchar(64) NOT NULL,
  `type` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `rule_name` varchar(64) DEFAULT NULL,
  `data` text DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`name`),
  KEY `rule_name` (`rule_name`),
  KEY `idx-auth_item-type` (`type`),
  CONSTRAINT `faman_auth_item_ibfk_1` FOREIGN KEY (`rule_name`) REFERENCES `faman_auth_rule` (`name`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `faman_auth_item`
--

INSERT INTO `faman_auth_item` VALUES ('/*',2,NULL,NULL,NULL,1471379966,1471379966),('/admin/*',2,NULL,NULL,NULL,1471379966,1471379966),('/admin/auth',2,NULL,NULL,NULL,1471379966,1471379966),('/admin/create',2,NULL,NULL,NULL,1471379966,1471379966),('/admin/delete',2,NULL,NULL,NULL,1471379966,1471379966),('/admin/index',2,NULL,NULL,NULL,1471379966,1471379966),('/admin/password',2,NULL,NULL,NULL,1471379966,1471379966),('/admin/update',2,NULL,NULL,NULL,1471379966,1471379966),('/admin/view',2,NULL,NULL,NULL,1471379966,1471379966),('/audit/*',2,NULL,NULL,NULL,1471452707,1471452707),('/audit/download-report',2,NULL,NULL,NULL,1724899470,1724899470),('/audit/export',2,NULL,NULL,NULL,1471458309,1471458309),('/audit/fee-report',2,NULL,NULL,NULL,1509692690,1509692690),('/audit/generated-report',2,NULL,NULL,NULL,1724899470,1724899470),('/audit/index',2,NULL,NULL,NULL,1471452707,1471452707),('/audit/member',2,NULL,NULL,NULL,1471452707,1471452707),('/audit/report-explorer',2,NULL,NULL,NULL,1724899470,1724899470),('/audit/report-list',2,NULL,NULL,NULL,1724899470,1724899470),('/bank-anggota/create',2,NULL,NULL,NULL,1509945758,1509945758),('/bank-anggota/delete',2,NULL,NULL,NULL,1509945758,1509945758),('/bank-anggota/index',2,NULL,NULL,NULL,1509945758,1509945758),('/bank-anggota/update',2,NULL,NULL,NULL,1509945758,1509945758),('/bank-anggota/view',2,NULL,NULL,NULL,1509945758,1509945758),('/bank/create',2,NULL,NULL,NULL,1509945758,1509945758),('/bank/delete',2,NULL,NULL,NULL,1509945758,1509945758),('/bank/index',2,NULL,NULL,NULL,1509945758,1509945758),('/bank/update',2,NULL,NULL,NULL,1509945758,1509945758),('/bank/view',2,NULL,NULL,NULL,1509945758,1509945758),('/blacklist/create',2,NULL,NULL,NULL,1724899470,1724899470),('/blacklist/delete',2,NULL,NULL,NULL,1724899470,1724899470),('/blacklist/index',2,NULL,NULL,NULL,1724899470,1724899470),('/blacklist/update',2,NULL,NULL,NULL,1724899470,1724899470),('/blacklist/view',2,NULL,NULL,NULL,1724899470,1724899470),('/cashback-rule/create',2,NULL,NULL,NULL,1484300321,1484300321),('/cashback-rule/delete',2,NULL,NULL,NULL,1484300321,1484300321),('/cashback-rule/index',2,NULL,NULL,NULL,1484300321,1484300321),('/cashback-rule/update',2,NULL,NULL,NULL,1484300321,1484300321),('/cashback-rule/view',2,NULL,NULL,NULL,1484300321,1484300321),('/cashback/create',2,NULL,NULL,NULL,1484300321,1484300321),('/cashback/delete',2,NULL,NULL,NULL,1484300321,1484300321),('/cashback/group',2,NULL,NULL,NULL,1509691429,1509691429),('/cashback/index',2,NULL,NULL,NULL,1484300321,1484300321),('/cashback/update',2,NULL,NULL,NULL,1484300321,1484300321),('/cashback/view',2,NULL,NULL,NULL,1484300321,1484300321),('/event-coupon/index',2,NULL,NULL,NULL,1724899470,1724899470),('/event-coupon/point',2,NULL,NULL,NULL,1724899470,1724899470),('/event-coupon/process',2,NULL,NULL,NULL,1724899470,1724899470),('/event-coupon/update',2,NULL,NULL,NULL,1724899470,1724899470),('/event-coupon/view',2,NULL,NULL,NULL,1724899470,1724899470),('/facility-holiday/*',2,NULL,NULL,NULL,1506090342,1506090342),('/facility-holiday/create',2,NULL,NULL,NULL,1506090342,1506090342),('/facility-holiday/delete',2,NULL,NULL,NULL,1506090342,1506090342),('/facility-holiday/index',2,NULL,NULL,NULL,1506090342,1506090342),('/facility-holiday/update',2,NULL,NULL,NULL,1506090342,1506090342),('/facility-holiday/view',2,NULL,NULL,NULL,1506090342,1506090342),('/facility/*',2,NULL,NULL,NULL,1506090342,1506090342),('/facility/create',2,NULL,NULL,NULL,1506090342,1506090342),('/facility/delete',2,NULL,NULL,NULL,1506090342,1506090342),('/facility/index',2,NULL,NULL,NULL,1506090342,1506090342),('/facility/update',2,NULL,NULL,NULL,1506090342,1506090342),('/facility/view',2,NULL,NULL,NULL,1506090342,1506090342),('/fee-special/*',2,NULL,NULL,NULL,1484300321,1484300321),('/fee-special/create',2,NULL,NULL,NULL,1484300321,1484300321),('/fee-special/delete',2,NULL,NULL,NULL,1484300321,1484300321),('/fee-special/index',2,NULL,NULL,NULL,1484300321,1484300321),('/fee-special/status',2,NULL,NULL,NULL,1484300321,1484300321),('/fee-special/update',2,NULL,NULL,NULL,1484300321,1484300321),('/fee-special/view',2,NULL,NULL,NULL,1484300321,1484300321),('/fee/create',2,NULL,NULL,NULL,1724899428,1724899428),('/fee/delete',2,NULL,NULL,NULL,1724899428,1724899428),('/fee/index',2,NULL,NULL,NULL,1724899428,1724899428),('/fee/update',2,NULL,NULL,NULL,1724899428,1724899428),('/fee/view',2,NULL,NULL,NULL,1724899428,1724899428),('/gridview/*',2,NULL,NULL,NULL,1491218277,1491218277),('/gridview/export/*',2,NULL,NULL,NULL,1491218277,1491218277),('/gridview/export/download',2,NULL,NULL,NULL,1491218277,1491218277),('/holiday/*',2,NULL,NULL,NULL,1506087854,1506087854),('/holiday/create',2,NULL,NULL,NULL,1506087854,1506087854),('/holiday/delete',2,NULL,NULL,NULL,1506087854,1506087854),('/holiday/index',2,NULL,NULL,NULL,1506087854,1506087854),('/holiday/update',2,NULL,NULL,NULL,1506087854,1506087854),('/holiday/view',2,NULL,NULL,NULL,1506087854,1506087854),('/identitas/*',2,NULL,NULL,NULL,1471379966,1471379966),('/identitas/create',2,NULL,NULL,NULL,1471379966,1471379966),('/identitas/delete',2,NULL,NULL,NULL,1471379966,1471379966),('/identitas/image',2,NULL,NULL,NULL,1724899470,1724899470),('/identitas/index',2,NULL,NULL,NULL,1471379966,1471379966),('/identitas/process',2,NULL,NULL,NULL,1724899470,1724899470),('/identitas/status',2,NULL,NULL,NULL,1724899470,1724899470),('/identitas/update',2,NULL,NULL,NULL,1471379966,1471379966),('/identitas/view',2,NULL,NULL,NULL,1471379966,1471379966),('/log-admin/*',2,NULL,NULL,NULL,1487855104,1487855104),('/log-admin/create',2,NULL,NULL,NULL,1487855104,1487855104),('/log-admin/delete',2,NULL,NULL,NULL,1487855104,1487855104),('/log-admin/index',2,NULL,NULL,NULL,1487855104,1487855104),('/log-admin/update',2,NULL,NULL,NULL,1487855104,1487855104),('/log-admin/view',2,NULL,NULL,NULL,1487855104,1487855104),('/member/*',2,NULL,NULL,NULL,1471379966,1471379966),('/member/address',2,NULL,NULL,NULL,1491214532,1491214532),('/member/contact',2,NULL,NULL,NULL,1491214532,1491214532),('/member/create',2,NULL,NULL,NULL,1471379966,1471379966),('/member/delete',2,NULL,NULL,NULL,1471379966,1471379966),('/member/index',2,NULL,NULL,NULL,1471379966,1471379966),('/member/profile',2,NULL,NULL,NULL,1491214532,1491214532),('/member/status',2,NULL,NULL,NULL,1491214532,1491214532),('/member/update',2,NULL,NULL,NULL,1471379966,1471379966),('/member/view',2,NULL,NULL,NULL,1471379966,1471379966),('/mutasi-bank/*',2,NULL,NULL,NULL,1484300321,1484300321),('/mutasi-bank/audit',2,NULL,NULL,NULL,1509945758,1509945758),('/mutasi-bank/create',2,NULL,NULL,NULL,1484300321,1484300321),('/mutasi-bank/delete',2,NULL,NULL,NULL,1484300321,1484300321),('/mutasi-bank/index',2,NULL,NULL,NULL,1484300321,1484300321),('/mutasi-bank/update',2,NULL,NULL,NULL,1484300321,1484300321),('/mutasi-bank/view',2,NULL,NULL,NULL,1484300321,1484300321),('/payment-mode/create',2,NULL,NULL,NULL,1724899470,1724899470),('/payment-mode/delete',2,NULL,NULL,NULL,1724899470,1724899470),('/payment-mode/index',2,NULL,NULL,NULL,1724899470,1724899470),('/payment-mode/update',2,NULL,NULL,NULL,1724899470,1724899470),('/payment-mode/view',2,NULL,NULL,NULL,1724899470,1724899470),('/pin-setting/pin-list',2,NULL,NULL,NULL,1491252043,1491252043),('/pin-setting/update',2,NULL,NULL,NULL,1491252043,1491252043),('/pin-setting/view',2,NULL,NULL,NULL,1491252043,1491252043),('/quesms/create',2,NULL,NULL,NULL,1491218260,1491218260),('/quesms/index',2,NULL,NULL,NULL,1491218260,1491218260),('/quesms/update',2,NULL,NULL,NULL,1491218397,1491218397),('/quesms/view',2,NULL,NULL,NULL,1491218260,1491218260),('/rbac/*',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/assignment/*',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/assignment/assign',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/assignment/index',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/assignment/revoke',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/assignment/view',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/default/*',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/default/index',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/menu/*',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/menu/create',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/menu/delete',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/menu/index',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/menu/update',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/menu/view',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/permission/*',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/permission/assign',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/permission/create',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/permission/delete',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/permission/index',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/permission/remove',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/permission/update',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/permission/view',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/role/*',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/role/assign',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/role/create',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/role/delete',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/role/index',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/role/remove',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/role/update',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/role/view',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/route/*',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/route/assign',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/route/create',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/route/index',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/route/refresh',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/route/remove',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/rule/*',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/rule/create',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/rule/delete',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/rule/index',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/rule/update',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/rule/view',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/user/*',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/user/activate',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/user/change-password',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/user/delete',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/user/index',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/user/login',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/user/logout',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/user/request-password-reset',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/user/reset-password',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/user/signup',2,NULL,NULL,NULL,1471379966,1471379966),('/rbac/user/view',2,NULL,NULL,NULL,1471379966,1471379966),('/resapi/rest/invoice/list',2,NULL,NULL,NULL,1510071906,1510071906),('/resapi/sci/status/*',2,NULL,NULL,NULL,1499084609,1499084609),('/resapi/sci/status/push',2,NULL,NULL,NULL,1499088539,1499088539),('/rest/member/index',2,NULL,NULL,NULL,1497896840,1497896840),('/rest/member/update',2,NULL,NULL,NULL,1497896814,1497896814),('/rest/member/view',2,NULL,NULL,NULL,1497896805,1497896805),('/sci-que/index',2,NULL,NULL,NULL,1724899470,1724899470),('/sci-que/resend',2,NULL,NULL,NULL,1724899470,1724899470),('/sci-que/view',2,NULL,NULL,NULL,1724899470,1724899470),('/site/*',2,NULL,NULL,NULL,1471379966,1471379966),('/site/avatar',2,NULL,NULL,NULL,1471428362,1471428362),('/site/error',2,NULL,NULL,NULL,1471379966,1471379966),('/site/index',2,NULL,NULL,NULL,1471379966,1471379966),('/site/login',2,NULL,NULL,NULL,1471379966,1471379966),('/site/logout',2,NULL,NULL,NULL,1471379966,1471379966),('/sms-gateway/create',2,NULL,NULL,NULL,1491218264,1491218264),('/sms-gateway/delete',2,NULL,NULL,NULL,1491218264,1491218264),('/sms-gateway/index',2,NULL,NULL,NULL,1491218264,1491218264),('/sms-gateway/update',2,NULL,NULL,NULL,1491218264,1491218264),('/sms-gateway/view',2,NULL,NULL,NULL,1491218264,1491218264),('/sms-route/create',2,NULL,NULL,NULL,1491218268,1491218268),('/sms-route/delete',2,NULL,NULL,NULL,1491218268,1491218268),('/sms-route/index',2,NULL,NULL,NULL,1491218268,1491218268),('/sms-route/update',2,NULL,NULL,NULL,1491218268,1491218268),('/sms-route/view',2,NULL,NULL,NULL,1491218268,1491218268),('/transaction/*',2,NULL,NULL,NULL,1484300321,1484300321),('/transaction/create',2,NULL,NULL,NULL,1484300321,1484300321),('/transaction/delete',2,NULL,NULL,NULL,1484300321,1484300321),('/transaction/index',2,NULL,NULL,NULL,1484300321,1484300321),('/transaction/update',2,NULL,NULL,NULL,1484300321,1484300321),('/transaction/view',2,NULL,NULL,NULL,1484300321,1484300321),('/transaksi-kuota/create',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-kuota/delete',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-kuota/index',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-kuota/recalculate',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-kuota/reset',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-kuota/update',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-kuota/view',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-limit-special/create',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-limit-special/delete',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-limit-special/index',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-limit-special/update',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-limit-special/update-status',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-limit-special/view',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-limit/create',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-limit/delete',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-limit/index',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-limit/update',2,NULL,NULL,NULL,1724899428,1724899428),('/transaksi-limit/view',2,NULL,NULL,NULL,1724899428,1724899428),('accounting',1,NULL,NULL,NULL,1724899470,1724899470),('admin_facility',2,'Administer Facility Setting',NULL,NULL,1506090445,1506090445),('admin_facility_holiday',2,'Administer Facility Schedule Data',NULL,NULL,1506090524,1506090524),('admin_holiday',2,'Holiday Administration',NULL,NULL,1506087935,1506087935),('anggota.view',1,NULL,NULL,NULL,1724899470,1724899470),('audit',1,NULL,NULL,NULL,1724899470,1724899470),('audit_fee_report',2,'Generate Fee Report',NULL,NULL,1724899470,1724899470),('audit_member_balance',2,NULL,NULL,NULL,1471452056,1471452056),('audit_member_transaction',2,NULL,NULL,NULL,1471452079,1471452079),('audit_transaction',2,NULL,NULL,NULL,1471452088,1471452088),('authenticated',1,'Basic Authenticated Admin',NULL,NULL,1471381026,1471381026),('bank_admin',2,'Bank Administrator',NULL,NULL,1724899470,1724899470),('bank_view',2,'View Bank Data',NULL,NULL,1724899470,1724899470),('blacklist.read',2,NULL,NULL,NULL,1724899470,1724899470),('blacklist.write',2,NULL,NULL,NULL,1724899470,1724899470),('cashback-manager',2,'Cashback Manager',NULL,NULL,1724899470,1724899470),('cashback-rule-manager',2,'Cashback Rule manager',NULL,NULL,1724899470,1724899470),('cashback-view',2,'View Cashback List and Rules',NULL,NULL,1724899470,1724899470),('change_member_fasapay_id',2,NULL,NULL,NULL,1471451967,1471451967),('change_pin_setting',2,'Change Member\'s PIN Setting',NULL,NULL,1724899470,1724899470),('create_transaction',2,'Create Transaction',NULL,NULL,1724899470,1724899470),('customer_service',1,'Customer Service',NULL,NULL,1471449441,1471449441),('customer_service_manager',1,'Customer Service Manager',NULL,NULL,1491252147,1491252147),('customer_support',1,NULL,NULL,NULL,1724899470,1724899470),('dev',1,'Development Role',NULL,NULL,1471384465,1471384465),('download_report',2,'Download Report',NULL,NULL,1724899470,1724899470),('edit_facility',2,'Update Facility Setting',NULL,NULL,1506090418,1506090418),('event_coupon_admin',2,NULL,NULL,NULL,1724899470,1724899470),('event_coupon_update',2,NULL,NULL,NULL,1724899470,1724899470),('event_manager',1,NULL,NULL,NULL,1724899470,1724899470),('event_view',2,NULL,NULL,NULL,1724899470,1724899470),('export',1,NULL,NULL,NULL,1724899470,1724899470),('fee-special.read',2,NULL,NULL,NULL,1724899470,1724899470),('fee-special.write',2,NULL,NULL,NULL,1724899470,1724899470),('fee.read',2,NULL,NULL,NULL,1724899428,1724899428),('fee.write',2,NULL,NULL,NULL,1724899428,1724899428),('finance_manager',1,NULL,NULL,NULL,1724899470,1724899470),('finance_staff',1,NULL,NULL,NULL,1471452112,1471452112),('guest',1,'Guest Roles',NULL,NULL,1471380725,1471380725),('identitas.read',2,'Melihat Daftar KYC (No Photo Access)',NULL,NULL,1724899470,1724899470),('identitas.verify',2,'Verifikasi KYC',NULL,NULL,1724899470,1724899470),('member_security_update',2,'Update Member Security Setting',NULL,NULL,1491252078,1491252078),('partner',1,NULL,NULL,NULL,1724899470,1724899470),('payment_admin',2,'Administer Payment Mode',NULL,NULL,1724899470,1724899470),('payment_view',2,'View Payment Mode Data',NULL,NULL,1724899470,1724899470),('quesms_creator',2,'Can Create SMS Message',NULL,NULL,1491218464,1491218464),('quesms_editor',2,'Edit Quesms Status Only',NULL,NULL,1491218351,1491218351),('quesms_status_viewer',2,'View and Search Quesms List',NULL,NULL,1491218438,1491218438),('rbac',1,'RBAC Admin',NULL,NULL,1471380952,1471380952),('resapi_invoice_admin',1,'Resapi Invoices',NULL,NULL,1510071955,1510071955),('resapi_invoice_list',2,'List Invoice',NULL,NULL,1510071929,1510071929),('resapi_push_scique',2,'Create an SCI-QUEUE Notification Que / Resend Que',NULL,NULL,1499088690,1499088690),('resapi.admin',1,NULL,NULL,NULL,1497896553,1497896553),('resapi.scique',1,'SCI Que Admin',NULL,NULL,1499088725,1499088725),('reset_member_master',2,NULL,NULL,NULL,1471451946,1471451946),('reset_member_password',2,NULL,NULL,NULL,1471451926,1471451926),('scique_admin',2,'Administer SCI Que',NULL,NULL,1724899470,1724899470),('scique_view',2,'View SCI Que',NULL,NULL,1724899470,1724899470),('sms_gateway_admin',2,'Admin SMS Gateway and Routing',NULL,NULL,1491218509,1491218509),('Special Fee Admin',2,NULL,NULL,NULL,1724899470,1724899470),('super_admin',1,NULL,NULL,NULL,1471452332,1471452332),('technical_admin',1,'Admin for IT Tech',NULL,NULL,1491218297,1491218297),('transaksi-kuota.admin',2,NULL,NULL,NULL,1724899428,1724899428),('transaksi-kuota.read',2,NULL,NULL,NULL,1724899428,1724899428),('transaksi-kuota.write',2,NULL,NULL,NULL,1724899428,1724899428),('transaksi-limit-special.admin',2,NULL,NULL,NULL,1724899428,1724899428),('transaksi-limit-special.read',2,NULL,NULL,NULL,1724899428,1724899428),('transaksi-limit-special.write',2,NULL,NULL,NULL,1724899428,1724899428),('transaksi-limit.read',2,NULL,NULL,NULL,1724899428,1724899428),('transaksi-limit.write',2,NULL,NULL,NULL,1724899428,1724899428),('update_holiday',2,'Update Holiday Setting',NULL,NULL,1506087903,1506087903),('update_member_address',2,'Update Member Address',NULL,NULL,1471451877,1471451877),('update_member_contact',2,NULL,NULL,NULL,1471451890,1471451890),('update_member_profile',2,NULL,NULL,NULL,1471451904,1471451904),('update_member_status',2,'Update Member Status',NULL,NULL,1724899470,1724899470),('view_admin_log',2,NULL,NULL,NULL,1487855125,1487855125),('view_facility',2,'View Facility Setting',NULL,NULL,1506090376,1506090376),('view_facility_holiday',2,'View Facility Schedule Data',NULL,NULL,1506090481,1506090481),('view_holiday',2,'View Holiday List',NULL,NULL,1506087874,1506087874),('view_member',2,'Basic Member View',NULL,NULL,1471451828,1471451828),('view_member_finance',2,NULL,NULL,NULL,1471452002,1471452002),('view_member_transaction',2,NULL,NULL,NULL,1471452030,1471452030),('view_transaction',2,'View Transaction (Everything)',NULL,NULL,1724899470,1724899470);

--
-- Table structure for table `faman_auth_item_child`
--

CREATE TABLE `faman_auth_item_child` (
  `parent` varchar(64) NOT NULL,
  `child` varchar(64) NOT NULL,
  PRIMARY KEY (`parent`,`child`),
  KEY `child` (`child`),
  CONSTRAINT `faman_auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `faman_auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `faman_auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `faman_auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `faman_auth_item_child`
--

INSERT INTO `faman_auth_item_child` VALUES ('accounting','finance_staff'),('admin_facility','/facility/*'),('admin_facility_holiday','/facility-holiday/*'),('admin_holiday','/holiday/*'),('anggota.view','bank_view'),('anggota.view','view_member'),('audit','authenticated'),('audit','finance_staff'),('audit_member_transaction','/audit/member'),('audit_transaction','/audit/index'),('authenticated','/admin/password'),('authenticated','/admin/view'),('authenticated','/site/*'),('authenticated','/site/avatar'),('authenticated','guest'),('bank_admin','/bank-anggota/create'),('bank_admin','/bank-anggota/delete'),('bank_admin','/bank-anggota/update'),('bank_admin','/bank/create'),('bank_admin','/bank/delete'),('bank_admin','/bank/update'),('bank_admin','bank_view'),('bank_view','/bank-anggota/index'),('bank_view','/bank-anggota/view'),('bank_view','/bank/index'),('bank_view','/bank/view'),('blacklist.read','/blacklist/index'),('blacklist.read','/blacklist/view'),('blacklist.write','/blacklist/create'),('blacklist.write','/blacklist/delete'),('blacklist.write','/blacklist/update'),('blacklist.write','blacklist.read'),('cashback-manager','/cashback/create'),('cashback-manager','/cashback/delete'),('cashback-manager','/cashback/index'),('cashback-manager','/cashback/update'),('cashback-manager','/cashback/view'),('cashback-manager','cashback-view'),('cashback-rule-manager','/cashback-rule/create'),('cashback-rule-manager','/cashback-rule/delete'),('cashback-rule-manager','/cashback-rule/index'),('cashback-rule-manager','/cashback-rule/update'),('cashback-rule-manager','/cashback-rule/view'),('cashback-view','/cashback-rule/index'),('cashback-view','/cashback-rule/view'),('cashback-view','/cashback/group'),('cashback-view','/cashback/index'),('cashback-view','/cashback/view'),('change_pin_setting','/pin-setting/pin-list'),('change_pin_setting','/pin-setting/update'),('change_pin_setting','/pin-setting/view'),('create_transaction','/transaction/create'),('create_transaction','view_transaction'),('customer_service','/identitas/index'),('customer_service','/identitas/update'),('customer_service','/identitas/view'),('customer_service','/member/index'),('customer_service','/member/update'),('customer_service','/member/view'),('customer_service','authenticated'),('customer_service','view_facility'),('customer_service','view_facility_holiday'),('customer_service','view_holiday'),('customer_service_manager','admin_facility'),('customer_service_manager','admin_facility_holiday'),('customer_service_manager','admin_holiday'),('customer_service_manager','audit_member_transaction'),('customer_service_manager','audit_transaction'),('customer_service_manager','change_member_fasapay_id'),('customer_service_manager','customer_service'),('customer_service_manager','edit_facility'),('customer_service_manager','member_security_update'),('customer_service_manager','quesms_creator'),('customer_service_manager','quesms_status_viewer'),('customer_service_manager','reset_member_master'),('customer_service_manager','reset_member_password'),('customer_service_manager','sms_gateway_admin'),('customer_service_manager','update_member_address'),('customer_service_manager','update_member_contact'),('customer_service_manager','update_member_profile'),('customer_service_manager','view_admin_log'),('customer_service_manager','view_facility'),('customer_service_manager','view_facility_holiday'),('customer_service_manager','view_holiday'),('customer_service_manager','view_member'),('customer_service_manager','view_member_finance'),('customer_service_manager','view_member_transaction'),('customer_support','customer_service'),('download_report','/audit/download-report'),('download_report','/audit/generated-report'),('download_report','/audit/report-explorer'),('download_report','/audit/report-list'),('edit_facility','/facility/update'),('edit_facility','view_facility'),('event_coupon_update','/event-coupon/process'),('event_coupon_update','/event-coupon/update'),('event_coupon_update','event_view'),('event_manager','event_coupon_admin'),('event_manager','event_coupon_update'),('event_manager','event_view'),('event_view','/event-coupon/index'),('event_view','/event-coupon/point'),('event_view','/event-coupon/view'),('export','/gridview/*'),('export','/gridview/export/*'),('export','/gridview/export/download'),('export','authenticated'),('fee-special.read','/fee-special/index'),('fee-special.read','/fee-special/view'),('fee-special.write','/fee-special/create'),('fee-special.write','/fee-special/delete'),('fee-special.write','/fee-special/status'),('fee-special.write','/fee-special/update'),('fee-special.write','fee-special.read'),('fee.read','/fee/index'),('fee.read','/fee/view'),('fee.write','/fee/create'),('fee.write','/fee/delete'),('fee.write','/fee/update'),('fee.write','fee.read'),('finance_manager','bank_admin'),('finance_manager','fee-special.write'),('finance_manager','fee.write'),('finance_manager','finance_staff'),('finance_manager','payment_admin'),('finance_manager','transaksi-limit-special.write'),('finance_manager','transaksi-limit.write'),('finance_manager','view_member_finance'),('finance_staff','audit_member_balance'),('finance_staff','audit_member_transaction'),('finance_staff','audit_transaction'),('finance_staff','fee.read'),('finance_staff','transaksi-kuota.admin'),('finance_staff','transaksi-kuota.read'),('finance_staff','transaksi-kuota.write'),('finance_staff','transaksi-limit-special.admin'),('finance_staff','transaksi-limit-special.read'),('finance_staff','transaksi-limit.read'),('finance_staff','transaksi-limit.write'),('finance_staff','view_member'),('guest','/site/error'),('guest','/site/login'),('identitas.read','/identitas/index'),('identitas.read','/identitas/view'),('identitas.verify','/identitas/image'),('identitas.verify','/identitas/process'),('identitas.verify','/identitas/status'),('identitas.verify','/identitas/update'),('identitas.verify','identitas.read'),('member_security_update','/pin-setting/pin-list'),('member_security_update','/pin-setting/update'),('member_security_update','/pin-setting/view'),('partner','view_member'),('payment_admin','/payment-mode/create'),('payment_admin','/payment-mode/delete'),('payment_admin','/payment-mode/update'),('payment_admin','payment_view'),('payment_view','/payment-mode/index'),('payment_view','/payment-mode/view'),('quesms_creator','/quesms/create'),('quesms_creator','quesms_editor'),('quesms_editor','/quesms/create'),('quesms_editor','/quesms/index'),('quesms_editor','/quesms/update'),('quesms_editor','/quesms/view'),('quesms_status_viewer','/quesms/index'),('rbac','/rbac/*'),('resapi_invoice_admin','resapi_invoice_list'),('resapi_invoice_list','/resapi/rest/invoice/list'),('resapi_push_scique','/resapi/sci/status/push'),('resapi.scique','resapi_push_scique'),('scique_admin','/sci-que/resend'),('scique_admin','scique_view'),('scique_view','/sci-que/index'),('scique_view','/sci-que/view'),('sms_gateway_admin','/sms-gateway/create'),('sms_gateway_admin','/sms-gateway/delete'),('sms_gateway_admin','/sms-gateway/index'),('sms_gateway_admin','/sms-gateway/update'),('sms_gateway_admin','/sms-gateway/view'),('sms_gateway_admin','/sms-route/create'),('sms_gateway_admin','/sms-route/delete'),('sms_gateway_admin','/sms-route/index'),('sms_gateway_admin','/sms-route/update'),('sms_gateway_admin','/sms-route/view'),('sms_gateway_admin','quesms_creator'),('Special Fee Admin','fee-special.read'),('Special Fee Admin','fee-special.write'),('super_admin','/*'),('super_admin','authenticated'),('super_admin','blacklist.read'),('super_admin','blacklist.write'),('super_admin','customer_service'),('super_admin','customer_service_manager'),('super_admin','dev'),('super_admin','fee.read'),('super_admin','fee.write'),('super_admin','finance_staff'),('super_admin','rbac'),('super_admin','technical_admin'),('super_admin','transaksi-kuota.admin'),('super_admin','transaksi-kuota.read'),('super_admin','transaksi-kuota.write'),('super_admin','transaksi-limit-special.admin'),('super_admin','transaksi-limit-special.read'),('super_admin','transaksi-limit-special.write'),('super_admin','transaksi-limit.read'),('super_admin','transaksi-limit.write'),('super_admin','view_admin_log'),('technical_admin','dev'),('technical_admin','sms_gateway_admin'),('transaksi-kuota.admin','/transaksi-kuota/recalculate'),('transaksi-kuota.admin','/transaksi-kuota/reset'),('transaksi-kuota.admin','transaksi-kuota.read'),('transaksi-kuota.read','/transaksi-kuota/index'),('transaksi-kuota.read','/transaksi-kuota/view'),('transaksi-kuota.write','/transaksi-kuota/create'),('transaksi-kuota.write','/transaksi-kuota/delete'),('transaksi-kuota.write','/transaksi-kuota/update'),('transaksi-kuota.write','transaksi-kuota.admin'),('transaksi-kuota.write','transaksi-kuota.read'),('transaksi-limit-special.admin','/transaksi-limit-special/update-status'),('transaksi-limit-special.admin','transaksi-limit-special.read'),('transaksi-limit-special.read','/transaksi-limit-special/index'),('transaksi-limit-special.read','/transaksi-limit-special/view'),('transaksi-limit-special.write','/transaksi-limit-special/create'),('transaksi-limit-special.write','/transaksi-limit-special/delete'),('transaksi-limit-special.write','/transaksi-limit-special/update'),('transaksi-limit-special.write','transaksi-limit-special.admin'),('transaksi-limit-special.write','transaksi-limit-special.read'),('transaksi-limit.read','/transaksi-limit/index'),('transaksi-limit.read','/transaksi-limit/view'),('transaksi-limit.write','/transaksi-limit/create'),('transaksi-limit.write','/transaksi-limit/delete'),('transaksi-limit.write','/transaksi-limit/update'),('transaksi-limit.write','transaksi-limit.read'),('update_holiday','/holiday/update'),('update_holiday','view_holiday'),('update_member_status','/member/status'),('update_member_status','view_member'),('view_admin_log','/log-admin/*'),('view_admin_log','/log-admin/index'),('view_admin_log','/log-admin/view'),('view_facility','/facility/index'),('view_facility','/facility/view'),('view_facility_holiday','/facility-holiday/index'),('view_facility_holiday','/facility-holiday/view'),('view_facility_holiday','view_facility'),('view_holiday','/holiday/index'),('view_holiday','/holiday/view'),('view_member','/member/index'),('view_member','/member/view'),('view_transaction','/transaction/index'),('view_transaction','/transaction/view');

--
-- Table structure for table `faman_auth_rule`
--

CREATE TABLE `faman_auth_rule` (
  `name` varchar(64) NOT NULL,
  `data` text DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `faman_auth_rule`
--


--
-- Table structure for table `faman_menu`
--

CREATE TABLE `faman_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `parent` int(11) DEFAULT NULL,
  `route` varchar(255) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  `data` blob DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parent` (`parent`),
  CONSTRAINT `faman_menu_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `faman_menu` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `faman_menu`
--

INSERT INTO `faman_menu` VALUES (1,'Home',NULL,'/site/index',0,'{\"icon\":\"home\"}'),(2,'RBAC',NULL,NULL,99,'{\"icon\":\"map-signs\"}'),(3,'Role',2,'/rbac/role/index',3,'{\"icon\":\"gears\"}'),(4,'Route',2,'/rbac/route/index',5,'{\"icon\":\"road\"}'),(5,'Permission',2,'/rbac/permission/index',4,'{\"icon\":\"gavel\"}'),(6,'Assignment',2,'/rbac/assignment/index',1,'{\"icon\":\"pencil\"}'),(7,'Menu',2,'/rbac/menu/index',2,'{\"icon\":\"navicon\"}'),(8,'Member',NULL,'/member/index',1,'{\"icon\":\"user\"}'),(10,'Audit',NULL,NULL,10,'{\"icon\":\"cc\"}'),(11,'Audit Balance',10,'/audit/index',1,NULL),(12,'Audit Member History',10,'/audit/member',1,NULL),(13,'Fee',NULL,NULL,8,'{\"icon\":\"percent\"}'),(14,'Fee Special',13,'/fee-special/index',6,'{\"icon\":\"percent\"}'),(15,'Cashback',NULL,NULL,7,'{\"icon\":\"money\"}'),(16,'Cashback Rule',15,'/cashback-rule/index',1,NULL),(17,'Cashback List',15,'/cashback/index',2,NULL),(18,'Administrator',NULL,NULL,98,'{\"icon\":\"gear\"}'),(19,'Log Admin',18,'/log-admin/index',2,NULL),(20,'Admin',18,'/admin/index',NULL,NULL),(21,'SMS',NULL,NULL,97,'{\"icon\":\"mobile-phone\"}'),(22,'Quesms',21,'/quesms/index',1,'{\"icon\":\"wechat\"}'),(23,'SMS Gateway',21,'/sms-gateway/index',2,'{\"icon\":\"arrows\"}'),(24,'SMS Route',21,'/sms-route/index',3,'{\"icon\":\"arrows-alt\"}'),(25,'Transaction',NULL,'/transaction/index',3,'{\"icon\":\"money\"}'),(26,'SCI',NULL,NULL,97,'{\"icon\":\"shopping-cart\"}'),(27,'Sci Queue',26,'/sci-que/index',1,'{\"icon\":\"phone-square\"}'),(28,'Bank',NULL,NULL,5,'{\"icon\":\"bank\"}'),(29,'Payment Mode',28,'/payment-mode/index',3,'{\"icon\":\"credit-card\"}'),(30,'Bank',28,'/bank/index',1,'{\"icon\":\"bank\"}'),(31,'Mutasi Bank',10,'/mutasi-bank/index',3,'{\"icon\":\"bank\"}'),(32,'Facility & Schedule',NULL,NULL,17,'{\"icon\":\"calendar\"}'),(33,'Holiday',32,'/holiday/index',1,'{\"icon\":\"holiday\"}'),(34,'Facility',32,'/facility/index',2,'{\"icon\":\"building\"}'),(35,'Schedule',32,'/facility-holiday/index',3,'{\"icon\":\"calendar\"}'),(36,'Cashback Group',15,'/cashback/group',3,NULL),(37,'Fee Report',10,'/audit/fee-report',5,NULL),(38,'Trans Rules',NULL,NULL,9,'{\"icon\":\"user-police\"}'),(39,'Kuota',38,'/transaksi-kuota/index',1,'{\"icon\":\"gauge\"}'),(40,'Limit Special',38,'/transaksi-limit-special/index',2,'{\"icon\":\"gauge-max\"}'),(41,'Fee',38,'/fee/index',2,'{\"icon\":\"gauge-max\"}'),(42,'Limit',38,'/transaksi-limit/index',2,'{\"icon\":\"gauge-max\"}'),(43,'Member',NULL,NULL,1,'{\"icon\":\"user\"}'),(44,'Member List',8,'/member/index',1,'{\"icon\":\"user\"}'),(45,'Ban List',8,'/blacklist/index',2,'{\"icon\":\"ban\"}');


