/*
 Navicat MySQL Data Transfer

 Source Server         : Delma Assets
 Source Server Type    : MySQL
 Source Server Version : 50733
 Source Host           : localhost:3306
 Source Schema         : delmaassets

 Target Server Type    : MySQL
 Target Server Version : 50733
 File Encoding         : 65001

 Date: 17/08/2022 11:28:36
*/


-- ----------------------------
-- Table structure for asset_attachments
-- ----------------------------
CREATE TABLE `asset_attachments`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `asset_id` int(11) NULL DEFAULT NULL,
  `purchase_order` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `acceptance_form` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `movement_form` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `invoice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of asset_attachments
-- ----------------------------
INSERT INTO `asset_attachments` VALUES (1, 11, 'h12-rev-bg-img-1.jpg', 'h12-rev-bg-img-1.jpg', 'h12-rev-bg-img-1.jpg', 'h12-rev-bg-img-1.jpg');

-- ----------------------------
-- Table structure for asset_history
-- ----------------------------
CREATE TABLE `asset_history`  (
  `AssetHistory_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `Asset_id` bigint(20) UNSIGNED NOT NULL,
  `Employee_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`AssetHistory_id`) USING BTREE,
  INDEX `asset_history_assetid_foreign`(`Asset_id`) USING BTREE,
  CONSTRAINT `asset_history_assetid_foreign` FOREIGN KEY (`Asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of asset_history
-- ----------------------------
INSERT INTO `asset_history` VALUES (1, 11, 1, '2022-07-02', 'OnProject', '2022-07-02 05:23:27');

-- ----------------------------
-- Table structure for asset_movements
-- ----------------------------
CREATE TABLE `asset_movements`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `assetid` int(11) NOT NULL,
  `requested_by` int(11) NULL DEFAULT NULL,
  `request_order` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `delivered_on` date NULL DEFAULT NULL,
  `delivered_by` int(11) NULL DEFAULT NULL,
  `received_by` int(11) NULL DEFAULT NULL,
  `installed_in` int(11) NULL DEFAULT NULL,
  `condition_id` int(11) NULL DEFAULT NULL,
  `delivery_form` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `comments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of asset_movements
-- ----------------------------
INSERT INTO `asset_movements` VALUES (2, 11, 1, 'h12-rev-bg-img-1(2).jpg', '2022-08-16', 3, 1, 2, 1, 'h12-rev-bg-img-1(1).jpg', 'kjkkkgj', '2022-08-16 13:12:39');

-- ----------------------------
-- Table structure for assets
-- ----------------------------
CREATE TABLE `assets`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `brandid` int(11) NULL DEFAULT NULL,
  `categoryid` int(11) UNSIGNED NULL DEFAULT NULL,
  `subcategoryid` int(11) NULL DEFAULT NULL,
  `entityid` int(11) NULL DEFAULT NULL,
  `departmentid` int(11) NULL DEFAULT NULL,
  `locationid` int(11) NULL DEFAULT NULL,
  `assettag` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `serial` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `barcode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `conditionid` int(11) NULL DEFAULT NULL,
  `warrantyid` int(11) NULL DEFAULT 0,
  `supplierid` int(11) NULL DEFAULT NULL,
  `purchasedate` date NULL DEFAULT NULL,
  `cost` decimal(12, 2) NULL DEFAULT NULL,
  `ownershipstatus` int(11) NULL DEFAULT NULL,
  `checkstatus` int(11) NULL DEFAULT 0,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int(11) NULL DEFAULT NULL,
  `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of assets
-- ----------------------------
INSERT INTO `assets` VALUES (11, 'CANON EOS 5D MARK IV (WG) CAMERA.jpg', 'CANON EOS 5D MARK IV (WG) CAMERA', 1, 1, 1, 3, 2, 2, '1234567', 'ABC123', '999990000A', 1, 0, NULL, NULL, NULL, NULL, 1, NULL, '2022-08-17 07:22:56', 3, '2022-08-16 00:00:00');

-- ----------------------------
-- Table structure for audittrail
-- ----------------------------
CREATE TABLE `audittrail`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datetime` datetime NOT NULL,
  `script` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `table` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `field` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `keyvalue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `oldvalue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `newvalue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of audittrail
-- ----------------------------

-- ----------------------------
-- Table structure for brand
-- ----------------------------
CREATE TABLE `brand`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` longblob NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of brand
-- ----------------------------
INSERT INTO `brand` VALUES (1, 'Canon', 0x[BLOB], NULL);

-- ----------------------------
-- Table structure for category
-- ----------------------------
CREATE TABLE `category`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES (1, 'Production Equipment', NULL);

-- ----------------------------
-- Table structure for condition
-- ----------------------------
CREATE TABLE `condition`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of condition
-- ----------------------------
INSERT INTO `condition` VALUES (1, 'Good', '2022-07-02 04:24:33');
INSERT INTO `condition` VALUES (2, 'Damaged', '2022-07-02 04:20:25');
INSERT INTO `condition` VALUES (3, 'Reached End of Life', '2022-07-02 04:20:44');

-- ----------------------------
-- Table structure for customer
-- ----------------------------
CREATE TABLE `customer`  (
  `Customer_id` int(11) NOT NULL AUTO_INCREMENT,
  `CustomerName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Customer_Contact_Person` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Customer_Contact_Number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Customer_City` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Customer_Country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`Customer_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of customer
-- ----------------------------
INSERT INTO `customer` VALUES (1, 'Kanoo Group', 'Houda Kanoo', '123456', 'Abu Dhabi', 'United Arab Emirates', NULL);

-- ----------------------------
-- Table structure for department
-- ----------------------------
CREATE TABLE `department`  (
  `department_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`department_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES (1, 'PyraPro', NULL, NULL);
INSERT INTO `department` VALUES (2, 'Dental Clinic', NULL, '2022-08-16 13:02:53');

-- ----------------------------
-- Table structure for employees
-- ----------------------------
CREATE TABLE `employees`  (
  `employee_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `department_id` int(11) NOT NULL,
  `fullname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `jobrole` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`employee_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of employees
-- ----------------------------
INSERT INTO `employees` VALUES (1, 1, 'Ashok Kumar', NULL, 'ashok@pyramedia.biz', 'Store Keeper', NULL, NULL, 'Abu Dhabi', 'United Arab Emirates', NULL);

-- ----------------------------
-- Table structure for entity
-- ----------------------------
CREATE TABLE `entity`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of entity
-- ----------------------------
INSERT INTO `entity` VALUES (1, 'Pyramedia Abu Dhabi (HQ)', 'info@pyramedia.biz', 'Abu Dhabi', 'United Arab Emirates', '+971 2 449 7044', 'Al Reem Island, Sky Tower\r\nSuite 3701', NULL);
INSERT INTO `entity` VALUES (2, 'Pyramedia Dubai', 'info@pyramedia.biz', 'Dubai', 'United Arab Emirates', '+971 2 449 7044', NULL, NULL);
INSERT INTO `entity` VALUES (3, 'Delma Medical Center', 'info@delmacenter.com', 'Abu Dhabi', 'United Arab Emirates', '+971 2 448 1800', 'Villa 71, Delma Street \r\nAl Nahyan Camp, \r\nOpposite Judicial Court', NULL);

-- ----------------------------
-- Table structure for location
-- ----------------------------
CREATE TABLE `location`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of location
-- ----------------------------
INSERT INTO `location` VALUES (2, 'CSSD 1', NULL, '2022-08-16 13:03:19');

-- ----------------------------
-- Table structure for maintenance
-- ----------------------------
CREATE TABLE `maintenance`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `assetid` int(11) NOT NULL,
  `supplierid` int(11) NOT NULL,
  `startdate` date NOT NULL,
  `enddate` date NOT NULL,
  `type` int(11) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of maintenance
-- ----------------------------
INSERT INTO `maintenance` VALUES (1, 11, 1, '2022-07-02', '2022-07-03', 1, NULL);

-- ----------------------------
-- Table structure for maintenancetype
-- ----------------------------
CREATE TABLE `maintenancetype`  (
  `MaintenanceType_id` int(11) NOT NULL AUTO_INCREMENT,
  `MaintenanceType_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`MaintenanceType_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of maintenancetype
-- ----------------------------
INSERT INTO `maintenancetype` VALUES (1, 'Maintenance');

-- ----------------------------
-- Table structure for orderdetails
-- ----------------------------
CREATE TABLE `orderdetails`  (
  `OrderID` int(11) NOT NULL,
  `ProductID` int(11) NOT NULL,
  `Quantity` smallint(6) NOT NULL DEFAULT 1,
  PRIMARY KEY (`OrderID`, `ProductID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of orderdetails
-- ----------------------------

-- ----------------------------
-- Table structure for orders
-- ----------------------------
CREATE TABLE `orders`  (
  `Order_id` int(11) NOT NULL AUTO_INCREMENT,
  `Customer_id` int(11) NULL DEFAULT NULL,
  `Employee_id` int(11) NULL DEFAULT NULL,
  `OrderDate` datetime NULL DEFAULT NULL,
  `Address` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `City` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `PostalCode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Country` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`Order_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of orders
-- ----------------------------

-- ----------------------------
-- Table structure for subcategory
-- ----------------------------
CREATE TABLE `subcategory`  (
  `SubCat_id` int(11) NOT NULL AUTO_INCREMENT,
  `Category_id` int(11) NULL DEFAULT NULL,
  `SubCat_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`SubCat_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of subcategory
-- ----------------------------
INSERT INTO `subcategory` VALUES (1, 1, 'Cameras', NULL);

-- ----------------------------
-- Table structure for subscriptions
-- ----------------------------
CREATE TABLE `subscriptions`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `endpoint` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `publickey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `authenticationtoken` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `contentencoding` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of subscriptions
-- ----------------------------

-- ----------------------------
-- Table structure for supplier
-- ----------------------------
CREATE TABLE `supplier`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of supplier
-- ----------------------------
INSERT INTO `supplier` VALUES (1, 'Advanced Media Trading LLC', 'info@amt.tv', 'Dubai', 'United Arab Emirates', '+971 4 352 99 77', 'Advanced Media Trading LLC.\r\nMezzanine Floor, Galadari Automobiles,\r\nMazda Showroom Building, Sheikh Zayed Rd\r\nP.O.Box: 44156, Dubai\r\nFax: +971 4 352 99 76', '2022-07-02 05:46:28');

-- ----------------------------
-- Table structure for userlevelpermissions
-- ----------------------------
CREATE TABLE `userlevelpermissions`  (
  `userlevelid` int(11) NOT NULL,
  `tablename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `permission` int(11) NOT NULL,
  PRIMARY KEY (`userlevelid`, `tablename`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of userlevelpermissions
-- ----------------------------
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}assets', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}asset_history', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}audittrail', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}brand', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}category', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}condition', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}customer', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}department', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}employees', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}entity', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}location', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}maintenance', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}maintenancetype', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}orderdetails', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}orders', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}subcategory', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}subscriptions', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}supplier', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}userlevelpermissions', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}userlevels', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}users', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}assets', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}asset_history', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}audittrail', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}brand', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}category', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}component', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}component_assets', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}condition', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}customer', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}Dashboard', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}department', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}employees', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}entity', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}location', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}maintenance', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}maintenancetype', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}migrations', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}orderdetails', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}orderdetailsview', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}orders', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}settings', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}subcategory', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}subscriptions', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}supplier', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}userlevelpermissions', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}userlevels', 0);
INSERT INTO `userlevelpermissions` VALUES (-2, '{C2A89F9E-1760-4C5D-BA1B-E14E23715193}users', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}assets', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}asset_history', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}audittrail', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}brand', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}category', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}condition', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}customer', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}department', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}employees', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}entity', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}location', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}maintenance', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}maintenancetype', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}orderdetails', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}orders', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}subcategory', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}subscriptions', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}supplier', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}userlevelpermissions', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}userlevels', 0);
INSERT INTO `userlevelpermissions` VALUES (0, '{9CC2C320-E5AD-4671-B9E3-FA719DAA7426}users', 0);

-- ----------------------------
-- Table structure for userlevels
-- ----------------------------
CREATE TABLE `userlevels`  (
  `userlevelid` int(11) NOT NULL,
  `userlevelname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`userlevelid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of userlevels
-- ----------------------------
INSERT INTO `userlevels` VALUES (-2, 'Anonymous');
INSERT INTO `userlevels` VALUES (-1, 'Administrator');
INSERT INTO `userlevels` VALUES (0, 'Default');

