• File: delmaassets.sql
  • Full Path: /home/yaeytimy/public_html/pyra_apps/sql/delmaassets.sql
  • File size: 38.91 KB
  • MIME-type: text/plain
  • Charset: utf-8
 
Delete Open Edit Advanced Editor Back 
/*
 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
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for asset_attachments
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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', 0x89504E470D0A1A0A0000000D49484452000000E1000000E10803000000096D2248000000F3504C5445E21B21FEFEFDE21B23FDFDFEFCFFFFFAFEFDFCFDFCFAFFFFFCFEFFFAE3E4E7696CE01B23E41A22E1161CF1B9BAE33039EC8A8DE10611FAEEECE79EA3DE6063FEF6F7F8D3D4E24C50E30F18F2A3A5DF232BFEFBFEDD1D24F8E7E7FDFDF9E8696CE00000F6C7CBE54046D9373DF3C5C3E06D6FEA9597E4585EFDEEEDF9FFF9ECCAC9E57B80EAA8AAF4E0DEE05054F7ECE8ED1418D72C33F09DA4E88B94E53A3DEAB8B6E82933EA8487DA1514DA5756DB2A2DD43335E97A79E85155FADCDCF6BDC0EBA8A5E08D8DF1D3D0E4434BE8B3AEDD8586E8626FF0A8A9DC413EE29C99F5D7DCE38A87F2B5BCDA6164EA5E65E06D6DEF0C09E6258E0000000F8A49444154789CED5DFB5F1A39BF9E6132C9402640D081C80C080A8872716DB152D6622B6FEBF666CFFFFFD79C2799E1E2AE567A6A77CFFAE6F941253393E4C9F79EF0199DDC7387F34F4FE097E3BF80A1858585858585858585858585858585858585858585858585858585858585858585858585858585858585858585858585858585858585858585858585858585858585858585858585C5BF0CB9D009373EA5EF9412C209C3071FF97721C7C35CCA47BF10CC11A6310CC35CEE99300CC190276023646B0D29C2A49E13CF836318F25C28143FAB8DF7CB7BC3E2F0C5CBC29BC37AA894782E7ACA854A0EBFED55FB9E4B0871F18335F3ED1785432ED533A018866A3A29F43A7D70238CF97E1004F8EDBA6EBFFD7277066DD522767E19D350E35775EE68F1097130E8345CE206AE4B7D0F801C691445D427B4713E78354DF8032EE78137F9DDF396BFEFBCF3CF30FC5E4F8FB43C8AB0DEED545CC63C088D1297BA34EACF8B37BD72EFE3976A83B24AF1B58E1CF72EF3933074C287DF7A784FF30F3354AF2EE6BEEB0581564BEAC71EA327EF8F4A75883679551B0C2337B8DE17E1BD0CBF37AFED19E20AFF6E4F5B8DF92084DAAFC60CCA497DCDB0E9B1E697EE9933E55A73C2E4EC686744A2E242429DEF7B1AB8775EFA42B83113FC79FFADE8C35C11CE0313FFCB630F8C793F386EEF8E68CC8200DC348EDDF960C611F58D6D708ED57D1DF951670C89A6CF844264731152CC4AB34428CD60792D34F9C254D44BF5A9FE2B95BC502A2995A63AABD81C1F370B354D6613DCAC109A9CD565A331F8A18748248216A2996E1253899EB9D21FB6F14EE8E16BC50D7CC407D78D637851B7FDFB54AD9608FDF2D625718F49F58DE4E9C81836E48E5252CE2EDA8D7E7FBE579B4A817C01EBC1B92623E474F7AAD16FECFDAEDBD1051A0E7BF3286A1712B59613C782487936F8326F542AFDEAB07B2625065CAA38C651ADE9D77614CD7B6732091D8EF593F2F717F97EBF5D982AC7D94292A16AD54E5DCF0D486A8230C5F6598BAFD4116C446BB7CF9A3426578722E5CC13484D8952F7A641E09D1040A3BD432940049386450959FF50747DE2FBEEFC8370742A2127EFE0AA61E1DE5E7D352D68874AC66FB58F7319D13F1B2F165A58865D0EFC55BD7B85F085D87C7DA4530F28CBA2D74744C390BDFA1602343A728E815D034A638F16CF04BF237CC94F48DCF402C686253D39E8A752CEE4766784904929F57DEA79AC7A248526A8AF1D76CF2317CD9431F6E908BA573FEAE55DAC84E7FB2CEAE556148598EC54DCF8E4DDE74E851DA32B979CBE2BA5F60871F183CB8E4BBCE3E3633F20D59A9C4EEBBBC306C25813F0A372B88D310A51467C275E1C6B8A5E4C3B07BF8589B34E45314E3982FAC20DB14A57E806C50FF6CB2715BDB29E87D1A866E88EB0C85AE99CF1E7139D16792E2E402D86F54977D8608CC0D04181924FBB2AEB5B25831306CA252545210A3084E7337652D05214921FF5AE9B8C34CD12FA940C679341B1828EE0F4E12E02763D560FB05A82C320A6E33CBC689031A46CD4D516BD69C1EA688E513CB8A2C64D0DCB5B3FD0B98FAB133BA816D606F3C2C31E3B818525875FF7E69A0D3A04FB38A62CFFAE1831F8B120C662F871CCA2B2F14A50DD7AB9C1025A2D499E13ADA196B04B6127F9CB9CC327859BB9D64F0FE4B08281C746BD2BAC1C3C8587E56E7A9434DFF1478498C070A743F4A04DC928AA4F87B3F543C6DA45BDE8FB0820A4725E484030590C6EDAD5F6125528B667B49CD082CC95BAC39376BBD3CE7B81D14A0FB9431457217050494D2170F712BDB8A8652E1A982D7D0BF5E68EECE20A75CD3C46DFE4D9E50D3A6A9F34744768C57251AF79528D4800BE9E6922C5D2230C5130A9718368861948A3B091659BB82ABB0DED31DCF6C5444D215F5EAABD591C4C0E34F0FBE89481A09E85CFFEC39DD941AD86E6835EB4ECD28516BE599447CCA3CB96BDBA66284461C4905DF843694C7BB17EC43F19278BDA428F30A44C771E0784B246F9A0D66B30EAA5F38DDD4719863C943D1A307FCDB053DA485C8C084BE70C91A4D1AB3970FBBA4236911CC6A883D754AAA29E6560B2BDD142E9588C245E9623B2ECD3FB3243AE30E82F3F079E91614E4DCEF124BC6B27113A1928B5570C9BD1B024F500527D4CD705A647592F99CAD91E74796B8602F3EFF831F3575D473D29EEC8D049E066586538E669840C95764226ECA5914F0E5CD856AAE2D1403A5C27E88928AF0552D1AD6A5C25DE1D869CBFAFE049D8EF6821B547487AAB47A8D71F489D1009BE4349EA023DDFFBAAC345B7F1030CC3508E477AC855D750D28D0A42853939FEE4FA9D230E5341EF30432749B4907531A573493E3D74B301BDE378C754CB90C806435229282C4C6DCD506B2942E7F8DAD52B43E0A12587F39CEE478C92D4A553763E9BE67445B01393CC0EFDF8ABC21C0A7937EB683B868586BB89F9426CA49E2157AF8664DE45BE92256910504E53E410A9CEB038CAE611F19A66124DBF9DA48216776458505096DAA60CEB5803DE43A4A346256FF454726A5165A90F0173D2D897709490619CB281EB7477B1AC3FC4509BD48647D0A89636522A0754CAA71F4B325CE7F226D9407E3A9B8CC7B549A29044FD074BEE9949B0796D1B86AE6138E920729BCFA473A05750BCFAE2C6BE694290F17750D9847F62A8B5E3871842CB6EEE326CD7456E438862F2F652A884AF6AD3902758D983AF3BE7D5F9687E32BC1CD75B176EB369DC5DECF707D36D19AA5A85A41243C4846D60E5440F42A5A91D52768DF48DFF2C43D40F436F93A0DBA98B754A0A87522F499D1DAF8498433EBA787772AAEB48A486249ADF1C61AA3463180FB794A193535DCA523A1ED2AF2932D450ED37989F316CBACD8284C7FA49862846FEA2A577EC10A9BD494453BAB95C82ACF3B6A81F899BCD63EAEB1DABF9FB1312A45AEAB3F6CCD111E5513B74B8788FC435AD677C7FC805C65007ED2C70510ACBBE503FCD105E53214C6D4A119EE6C1DAD924FC7290CFDCF7B1EFA6A1AA52098CC780CAB1EB37D0AC6D18E6C40E924596CA90754A3AC114F59D8DE4C37DA99CDC4F328458E4384F3619E66F11211EBCDB09E56E4488F19CAE1FB07EB1D71BE6C9D20306AE5FB9143A8FF82E4392321C2237316B4589AE3FB4CA88CB8A17AF19FEBCA7D175E961F58E96562EA0FC0F50448E27CEAEB1E4696C0882CE6E29E133E455C4E816E2FE317DAB5DD5A332845282A19F2E0C943D7A6F46906FAA64CDB0FCF39E4617ACA2485D12AC7AA56F1FAE47E045A703A44C86200958A7AEC025A7F80E4BA7EAD163D25E485D343C2A4347BCD3F965AADD1EF9A2ED3FA74A45C350172B9E7BF1F39EC6D176D58D10CDD60B371F7F67835BCCDAAB1B83682C4DFAC3D5419565637A6EA38BC434B745C4975D82A897453F58077C3882D78BC8C40F1F7588874C07D9DDCF32440DD361CDA6B79E77EFC14D2C814A71953EC7642853B7CB137511ACB480BEE03A9DDC221EBEA92C458F5A920EA0DC39AEBE3532F74AC8F542267FCE69FE4F0CE587A8B9AE2D7C563D7AE0A150856AB09AB7E77E6865397A4EEEE6577430A8DA8A214A894CF21EE222DBA9C364B83A3C318D4800FD612212F1040CB933BD21696A6146A3F4FCE09EA7C04594760FC110EE3C0D1247D2E400B044B13B87EAA536E57E1A2B5DFA3DCED0E965C6014F83C4ED1051372792621AF18F196A00AD363FC9D040CE46D9968A6B62137DC97542AD0F4CCD756D1EF0284A5D54BF1522C2E2664AA52B752AA0174974FBC48B3389F4BBE2315F9A31BC9D2F351B6337C6BA6E10599E7C8CDCE1D084C8276028446BD024B1DF342E32083C54D2893415449ABFE93DD0C499CADBEBE8B2D67749961BBBE74A85863DE73D3FF082A5B7F9CC1FF1A529C330AC6FE65351178529D2F84B63E94D2F7A67067F12863CE4BD0814B3E5C454A38F53097A990CCD31F75475F3B4584BAEE004CC991B6551A165F25521C773C620C2348A90AB89D88AA1108B938D6CE3066525177231D76DD42B1E384FC5D0091381D524D92E8A071FCEE8D5A2A53211A29870C4748A3B8613210B94A505BD17101D58A057ADD215F12A34880D43C6F2AF1F63E8A50C1D7579BA16E2F599826D08A7A8EF62A35BF51D19063FC250D74A7C5A2F575CBD53A47BF37D1AF8A7BD3F64CBEC9428FC9E5D5CBBFE47384995B421AD189E49EFAF343ECF849ADD7E626EF1F369600E1D3D46E2814C197A29560C970D990CB5717F8E5CD319CCBF326E25602DDF521ABB1554612263E865CFDD91A139E00C1EDF6B5BD1CCB516C508954B10C45EF3D82C517C35181F9CCD66935A6108DBF874DBD296AFEA73BD2DA8B76E8D528FE6F8ED9FBF7A33728F515BF8A0C986DA0996D15D8A741B39AC55570DD94E9456702C04D2768FF8815B6E092420A8F303D21FA85CB6ED9EEC50DDAD4F7D64FA29C3113523A1A32DB5D43165D46FF58BB9DEB7F5B2CD4F8F3016CDABD5EB5185B95EBEA70B7D7DAB5AB45DD6A4CCEC5E99E28045BD7A6BD2D67BF20014E16416264E39223405E977C324516098355077C91014BB2312347D7D9E111D09254B43101A1DA96519AE77A2826547F14A4B4D5708365FB665680A4139E9552BBA624B13EB1889BF296E40F4663C45AD96DEAA0EF71A5010B37F48B090517EA0CFF2868CA5DB87849C1EC93079B94E04A3AE3E1A1C5757DB8B602852865CC93F3A5140F48E389B97BB036852A5F8478B2F4FD495F336AD64B05EC4FF9A322469D5457E4086C61A95940717C56A3ECA366EF584BCA8313F2F2FD4147E27DDE80F43C50BC5D1A97124B8FCE9C51B89F9ABF2A7FC289FE21486985CE4571815909A4C6B578D6543A3B794219C199F5D741A913E2320248A9A8DCE804BA86898CB3C4D6FDD51E3B566F8A1BDEE68B83543730425B0A27C51F8BC57BC6A5F57ABD593F6979B77974725813A7FE32C176EA4B4FB796F582C166F7A839A480BCAC9ED7E61BF00ECEF170EE01527E683C1AE3E4B12F5A3C2B2697FC1970784585BA126DF7A6F3B7AC0CEDB5EA164F62DC3ECE424148BECA97D60A6F7174BB7CB8EF60BE3ED8FBACD3EB7CEB614FC5EBDB4181F8DC7B5C35902D24A1F06DFBD1B9CC37AA934335F274A2F0AB986B8E7339EF953C37A6C31E5B3C3DAEBD7E3C3BAB873087C5FC7773A525B8B7005BDAC3A9CE9F2DA7C6DEFDE4532877BE989F413FCCB486D747A4C84DEE46FF89A6076B89C1E4D6CEC93FEE526632A3FFEB5967B603223F3DD83903FF49D9D27C472D750676B09D755E9430CF5C9C3933034A7205A94E60B3B7FCBBF11CD8ED11D4DF0EF182F1BCE7C25C9FE9F540B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B0B8BA70477EE7FC5C5B3C1EAFD0FCFE09FFEDC0F9EF0F4953696E1BF16E6D599FFF4247E2978EEB9337C9A17C9FC7F46F8FC19EA5706FFD393F8A500C3F0B1FFC9F2EF06188AE7CD50BF1B543DDF60E81886EAB7676D88FF050C79FDB7FF79DE0C13CDF0398744C113CDF019530C3543A519FE2F942D77107027FEE00000000049454E44AE426082, NULL);

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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
-- ----------------------------
DROP TABLE IF EXISTS `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');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `fullname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `role` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `profile` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `users_email_unique`(`email`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (3, 'Tarek Tarabichi', NULL, 'tarek@pyramedia.biz', 'Tarek', 'K@rine@808012', '1', NULL, NULL, '-1', NULL, NULL, '2022-08-16 14:58:25');
INSERT INTO `users` VALUES (4, 'Ashok Kumar', NULL, 'ashok@pyramedia.biz', 'ashok', '123456', '1', 'Abu Dhabi', '1234567', '-1', NULL, NULL, '2022-08-04 00:00:00');

SET FOREIGN_KEY_CHECKS = 1;