--
-- Host: localhost    Database: teamwayomantelx_garage
-- ------------------------------------------------------


--
-- Table structure for table `Garage_Demoaccounts`
--

CREATE TABLE `Garage_Demoaccounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `acc_name` varchar(255) NOT NULL,
  `acc_code` varchar(255) DEFAULT NULL,
  `acc_parent` int(11) NOT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Garage_Demoaccounts`
--

INSERT INTO `Garage_Demoaccounts` VALUES (1,'Assets','1',0,1,0),(2,'Liabilities','2',0,1,0),(3,'Owner\'s Equity','3',0,1,0),(4,'Expenses','4',0,1,0),(5,'Revenue','5',0,1,0),(6,'Cost of Goods Sold','6',0,1,0),(7,'Current Assets','1-1',1,1,0),(8,'Fixed Assets','1-2',1,1,0),(9,'Current Liabilities','2-1',2,1,0),(10,'Long-term Liabilities','2-2',2,1,0),(11,'Capital','3-1',3,1,0),(12,'Retain Earnings','3-2',3,1,0),(13,'Partners\' Withdrawal','3-3',3,1,0),(14,'Products','5-1-1',47,1,0),(15,'Services','5-1-2',47,1,0),(17,'Discounts','5-1-3',47,1,0),(18,'Banks','1-1-1',7,1,0),(19,'Cash In Hand','1-1-2',7,1,0),(20,'Receivable Accounts','1-1-3',7,1,0),(21,'Receivable Notes','1-1-4',7,1,0),(22,'Other Receivable Accounts','1-1-5',7,1,0),(23,'Employee Petty Cash','1-1-6',7,1,0),(24,'Inventory','1-1-7',7,1,0),(25,'Suppliers','2-1-1',9,1,0),(26,'Salary Payable','2-1-2',9,1,0),(47,'Sales','5-1',5,1,0),(48,'Employee Reimbursement','2-1-3',9,1,0),(52,'Default Bank','123456789',18,1,0),(53,'cheques Payable','2-1-4',9,1,0),(59,'Prepayments','1-1-8',7,1,0),(60,'Advance Payments','2-1-5',9,1,0),(67,'Salaries','4-1',4,1,0);

--
-- Table structure for table `Garage_Demoactivity_logs`
--

CREATE TABLE `Garage_Demoactivity_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `action` enum('created','updated','deleted') COLLATE utf8_unicode_ci NOT NULL,
  `log_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `log_type_title` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `log_type_id` int(11) NOT NULL DEFAULT '0',
  `changes` mediumtext COLLATE utf8_unicode_ci,
  `log_for` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `log_for_id` int(11) NOT NULL DEFAULT '0',
  `log_for2` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `log_for_id2` int(11) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoactivity_logs`
--

INSERT INTO `Garage_Demoactivity_logs` VALUES (1,'2023-09-26 10:02:50',2,'created','clients','',1,NULL,'',0,'',0,0),(2,'2023-09-26 10:04:20',2,'created','estimates','',1,NULL,'',0,'',0,0),(3,'2023-09-26 10:05:09',2,'created','item_categories','',5,NULL,'',0,'',0,0),(4,'2023-09-26 10:05:16',2,'created','item_categories','',6,NULL,'',0,'',0,0),(5,'2023-09-26 10:06:20',2,'created','items','',1,NULL,'',0,'',0,0),(6,'2023-09-26 10:07:22',2,'created','items','',2,NULL,'',0,'',0,0),(7,'2023-09-26 10:07:59',2,'created','item_categories','',7,NULL,'',0,'',0,0),(8,'2023-09-26 10:09:23',2,'created','items','',3,NULL,'',0,'',0,0),(9,'2023-09-26 10:40:09',2,'created','suppliers','',13,NULL,'',0,'',0,0),(10,'2023-09-26 10:40:42',2,'created','suppliers','',14,NULL,'',0,'',0,0),(11,'2023-09-30 13:26:43',2,'created','purchase_orders','',1,NULL,'',0,'',0,0);

--
-- Table structure for table `Garage_Demoannouncements`
--

CREATE TABLE `Garage_Demoannouncements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `share_with` mediumtext COLLATE utf8_unicode_ci,
  `created_at` datetime NOT NULL,
  `files` text COLLATE utf8_unicode_ci NOT NULL,
  `read_by` mediumtext COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoannouncements`
--


--
-- Table structure for table `Garage_Demoattendance`
--

CREATE TABLE `Garage_Demoattendance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` enum('incomplete','pending','approved','rejected','deleted') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'incomplete',
  `user_id` int(11) NOT NULL,
  `in_time` datetime NOT NULL,
  `out_time` datetime DEFAULT NULL,
  `checked_by` int(11) DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `checked_at` datetime DEFAULT NULL,
  `reject_reason` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `checked_by` (`checked_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoattendance`
--


--
-- Table structure for table `Garage_Demobrands`
--

CREATE TABLE `Garage_Demobrands` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `models` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demobrands`
--

INSERT INTO `Garage_Demobrands` VALUES (1,'BMW','335I',0),(2,'CADILLAC','ESCALADE',0),(3,'CHEVORLET','SILVERADO 1500,TAHOE,SUBURBAN,AVALANCHE,TRAVERSE,TRAVERSE AWD',0),(4,'CHRYSLER','CHRYSLER 300LX,GRAND VOYAGER,200C',0),(5,'DODGE','DORANGO ,CHARGER ,CALIBER ,RAM ,CHALENGER ,NITRO',0),(6,'FIAT','500',0),(7,'FORD','PICK-UP,DS350 AMBULANCE,F150,EXPEDITION,EXPLORER,RAPTOR,F250 SUPER DUTY,MUSTANG,RANGER,FOCUS,EDGE',0),(8,'GMC','YUKON XL ,SIERRA ,BUS 4X4 ,FIRE ,SIERRA DENALI ,ENVOY ,ACADIA',0),(9,'HUMMER','H2',0),(10,'HYUNDAI','SANTAFE',0),(11,'INFINITY','QX56,QX80',0),(12,'JEEP','CHEROKEE,SAHARA,GRAND CHEROKEE,COMANDER,LIBERTY,PATRIOT,COMPASS,RENEGADE,GRAND CHEROKEE SRT8,WRANGLER YJ,WRANGLER TJ,WRANGLER JK,WRANGLER JL,GLADIATOR',0),(13,'KIA','SOUL ,CERATO ,CARNAVAL',0),(14,'LAND ROVER','110 ,LR3 ,S 2 ,90 ,LR4 ,DISCOVERY',0),(15,'LEXUS','400 ,LX470 ,RX350',0),(16,'MAN','RECOVERI 25T, RECOVERY 1002',0),(17,'MANTRA','MANTRA',0),(18,'MAZDA','PIK UP,BUS,CX5,CX9',0),(19,'MERCEDES','E200,G-CLASS 500',0),(20,'MITSUBISHI','PAJERO,PICK UP,BUS,OUTLANDER',0),(21,'NISSAN','PATROL Y61,SUNNY,INFINITI,XTERRA,BUS,PICK UP,PATROL Y62,ARMADA,SENTRA,PATHFINDER,ALTIMA',0),(22,'PORSCHE','CAYENNE',0),(23,'SUZUKI','JIMMY',0),(24,'TOYOTA','LANDCRUISER,HILUX,FJ CRUISER,BUS COASTER,PRADO,TACOMA PICKUP,DAYNA,COROLA,AVALON,YARIS,EMBULANCE,TUNDRA,FORTUNER,RAV4,LEXUS ES330,LEXUS,CAMRY,ECHO,DAYHASU,SEQUOIA',0),(25,'VOLKSWAGON','TOURAGE',0);

--
-- Table structure for table `Garage_Demochecklist_items`
--

CREATE TABLE `Garage_Demochecklist_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `is_checked` int(11) NOT NULL DEFAULT '0',
  `task_id` int(11) NOT NULL DEFAULT '0',
  `sort` int(11) NOT NULL DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demochecklist_items`
--


--
-- Table structure for table `Garage_Democi_sessions`
--

CREATE TABLE `Garage_Democi_sessions` (
  `id` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `data` blob NOT NULL,
  KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Democi_sessions`
--

INSERT INTO `Garage_Democi_sessions` VALUES ('30befb4b73788c12f757fc89c79adad3ac806877','161.8.109.180',1687079953,_binary '__ci_last_regenerate|i:1687079953;user_id|s:1:\"2\";'),('badb76412300910692c2cf8634995f990e24293d','161.8.109.180',1687087011,_binary '__ci_last_regenerate|i:1687079953;user_id|s:1:\"2\";'),('54b7ab8932bc23109a2cc663a7eac60f7be8bace','161.8.109.180',1694522037,_binary '__ci_last_regenerate|i:1694522017;'),('ed4f0e37a74276fed88a701cb6343dc00a32ae2f','156.205.235.3',1695646875,_binary '__ci_last_regenerate|i:1695644535;user_id|s:1:\"2\";'),('007666e2fd8943c37c4b2948b21ab2cf9e80becd','45.80.151.145',1695644774,_binary '__ci_last_regenerate|i:1695644774;'),('bf46f3995f4166917fcfb41e1c925f09275bad40','54.236.238.118',1695644796,_binary '__ci_last_regenerate|i:1695644795;'),('649cb4006a9204f1e65c7a5ddc68a3243a93281a','54.236.238.118',1695644796,_binary '__ci_last_regenerate|i:1695644796;'),('8abd08f2df7b3cb17e35655d6f062010eb335336','156.205.235.3',1695654567,''),('9d4507a8131dcad05d9386a8b5d5114139ecd55d','161.8.109.180',1695722859,_binary '__ci_last_regenerate|i:1695722859;user_id|s:1:\"2\";'),('a74f91e8abdd449c1050c54473c5e9113a747a9c','161.8.109.180',1695724702,_binary '__ci_last_regenerate|i:1695724702;user_id|s:1:\"2\";'),('ef8f7151e444a7999fddfeebc361e427a2af8da3','161.8.109.180',1695725355,_binary '__ci_last_regenerate|i:1695725355;user_id|s:1:\"2\";'),('c48040c2c0c12f2957daaa4e420a4a62a5065f4d','161.8.109.180',1695728045,_binary '__ci_last_regenerate|i:1695728045;user_id|s:1:\"2\";'),('ec1d9e041a77a5c07d928817f3a973814741bc30','41.35.113.34',1695726381,_binary '__ci_last_regenerate|i:1695726381;'),('46f7819e9a76aa69751d49e982d5516074717265','41.35.113.34',1695727808,_binary '__ci_last_regenerate|i:1695727808;user_id|s:1:\"2\";'),('1c54f942875f490354b16c371b6c6b74bba9fe3a','41.35.113.34',1695733012,_binary '__ci_last_regenerate|i:1695727808;user_id|s:1:\"2\";'),('b3384baebf47cc664c610c41b3c7af90b8a968bd','161.8.109.180',1695737077,_binary '__ci_last_regenerate|i:1695737077;user_id|s:1:\"2\";'),('71b7f0a851dffb8a6ab2c4bd2c0d67c4ad96c5f1','161.8.109.180',1695737263,_binary '__ci_last_regenerate|i:1695737077;user_id|s:1:\"2\";'),('162bf00912eb948bf0d6909263c9ea1cf48cd4fb','161.8.109.180',1695795111,''),('b8e94a67d311954df9010ea6d55f8ae76e712489','161.8.109.180',1695795116,''),('82b43a36fb333028665b8ebb422fbcf442d8ba3f','161.8.109.180',1695803796,_binary '__ci_last_regenerate|i:1695803796;'),('7a25d610fee3f40dff450c4561792923fa059fcc','161.8.109.180',1696070959,_binary '__ci_last_regenerate|i:1696069391;user_id|s:1:\"2\";'),('d8530e147897f0098041829619708d3be5e1dd37','161.8.109.180',1696071006,''),('6be3d4223a8e5bf5fee3940b1f41cb543693937b','161.8.109.180',1696083690,_binary '__ci_last_regenerate|i:1696080308;user_id|s:1:\"2\";'),('d5dd3eeee5b9e0baebe2221d5e3793d9b25c9f08','161.8.109.180',1696426332,_binary '__ci_last_regenerate|i:1696426332;'),('03a7604352f008237e8c9f447eaa380cd9ceca17','161.8.109.180',1696673450,_binary '__ci_last_regenerate|i:1696673450;'),('530168d0917364069e84fe3d5a3f7224bee4c458','161.8.109.180',1696681011,_binary '__ci_last_regenerate|i:1696681011;'),('14c0b9ebbdb8f1ebbf83ab259f2c72674e99f6f4','185.228.7.170',1725874424,_binary '__ci_last_regenerate|i:1725867645;user_id|s:1:\"2\";'),('65e2325c875f8fd0a8e7debdeba7346f0a6b1a44','185.228.7.170',1725867757,_binary '__ci_last_regenerate|i:1725867757;'),('b442d0f34ae10df82a7d0c65aa8883ba007ea023','185.228.7.170',1725867758,_binary '__ci_last_regenerate|i:1725867758;'),('b2489ba1f3356495c84f53e2582314f999022a27','37.41.130.20',1725870118,_binary '__ci_last_regenerate|i:1725868677;user_id|s:1:\"2\";'),('944a94a376ccfa8f79f6bc1c2b8b18c15e6f25d4','37.200.247.120',1725869160,_binary '__ci_last_regenerate|i:1725869160;'),('ecb560b02b348591175ee02609f4b580c59eb48f','37.200.247.120',1725869161,_binary '__ci_last_regenerate|i:1725869161;'),('2a44fa3460704863e69f971828f4ead4c51d6382','185.228.7.170',1725874438,''),('38a518279525b5268c70cc6ecbde1322c84dbd64','185.228.7.170',1725878510,_binary '__ci_last_regenerate|i:1725878510;user_id|s:1:\"2\";'),('de7f58ff330b7a30141d370f727ddb511c80072c','185.228.7.170',1725879247,_binary '__ci_last_regenerate|i:1725878510;user_id|s:1:\"2\";'),('a066d793aa0d6e004f65c3903f1c10397760dc87','185.112.106.97',1725900009,_binary '__ci_last_regenerate|i:1725900009;user_id|s:1:\"2\";'),('5bbc9941054d42d0aa8c86df7f6caf83f57e2f88','185.112.106.97',1725902543,_binary '__ci_last_regenerate|i:1725900009;user_id|s:1:\"2\";'),('70fc5ed64a533ce953c1a35bcb0b1e6edebe15af','161.8.109.180',1725950175,_binary '__ci_last_regenerate|i:1725950175;'),('5bc90f752eac15d36c78f7ccae47af79c4b803c3','161.8.109.180',1726144497,_binary '__ci_last_regenerate|i:1726144491;user_id|s:1:\"2\";'),('dbf7cfee58d1ea2e3346f3bf34c06ee40a3aa21a','161.8.109.180',1741081145,_binary '__ci_last_regenerate|i:1741079132;user_id|s:1:\"2\";'),('68f2c15cc4e3983cd3b26bd57e47ed2d7b7e7d2c','161.8.109.180',1741604146,_binary '__ci_last_regenerate|i:1741604075;user_id|s:1:\"2\";'),('4c1a3ac9eefb9f0c20b4fd4b6585f28493bb2e71','161.8.109.180',1747917804,_binary '__ci_last_regenerate|i:1747917804;'),('ec3155f5087584439f7a3228af43e08062417f9c','5.37.153.89',1748273986,_binary '__ci_last_regenerate|i:1748273050;user_id|s:1:\"2\";'),('9bad54ac85f5d27e50e3056b1f176790fdfdd5e8','37.41.37.237',1748759145,_binary '__ci_last_regenerate|i:1748758452;user_id|s:1:\"2\";'),('3721e33d1a7a636ea285c57f0d68f730b761c360','5.37.234.79',1748961364,_binary '__ci_last_regenerate|i:1748961364;'),('396fbea287ba88f3281db70c0e2b72e870bfe842','5.37.234.79',1748961364,_binary '__ci_last_regenerate|i:1748961364;'),('63f646e7b4f2337d0510eb02ac2e24078c415ec7','5.21.80.199',1749036758,_binary '__ci_last_regenerate|i:1749036758;'),('fc0c5da7b1bdea67c5ff01b4eb12740ba5e269f6','5.21.80.199',1749036758,_binary '__ci_last_regenerate|i:1749036758;'),('fc7f5b808884fd4728c0a8ea2f9fbe9dc266a954','37.40.46.161',1749037175,_binary '__ci_last_regenerate|i:1749037175;'),('a87d70baaf37414b57c3b59ac0e4713f16d94992','37.40.46.161',1749037176,_binary '__ci_last_regenerate|i:1749037176;'),('c914d5d41f1dab7e1f34eb2f0a14acfeb0f51989','37.40.46.161',1749037266,_binary '__ci_last_regenerate|i:1749037180;user_id|s:1:\"2\";'),('8702e43994d5f64114b1300070f9930be08905fc','212.72.12.174',1758701207,_binary '__ci_last_regenerate|i:1758701206;'),('ac190c46bb0e2f047b341cdeae3b5a4706110e9f','212.72.12.174',1758712418,_binary '__ci_last_regenerate|i:1758701207;user_id|s:1:\"2\";'),('a7e324da974d3a459a48987632636c656f0bee41','212.72.12.174',1758702879,_binary '__ci_last_regenerate|i:1758702878;'),('eb41cecadda36bd5483eb10176ec238c7135593e','212.146.176.241',1758705341,_binary '__ci_last_regenerate|i:1758705181;user_id|s:1:\"2\";'),('34828854eb73527bc5cf9cbbd0b2931b78144ddd','212.146.176.241',1758713165,_binary '__ci_last_regenerate|i:1758713165;'),('7bc4d9dec1eaa33ad885dd017042c184eab05aff','212.146.176.241',1758713196,_binary '__ci_last_regenerate|i:1758713165;user_id|s:1:\"2\";'),('f8f80f7a2cf456ed76bfc992b04822587aeeb627','212.146.161.198',1759164166,_binary '__ci_last_regenerate|i:1759164145;user_id|s:1:\"2\";'),('55bbc8537cd74d4fb3a8e8ef4373d5722252cb25','212.146.161.198',1759172752,_binary '__ci_last_regenerate|i:1759172752;'),('32043f017c0794888daeb0a0a8629498a057d4f0','207.154.242.250',1760109099,_binary '__ci_last_regenerate|i:1760109087;user_id|s:1:\"2\";'),('5c2a8c12991f7c8f2f9c70658a0ac29f1083592e','207.154.242.250',1760180982,_binary '__ci_last_regenerate|i:1760180981;'),('ab4c10c424d74a6254cef017795a3b2e2a811379','5.162.102.229',1760777264,_binary '__ci_last_regenerate|i:1760777264;'),('348078050da68763e593d235067ecef0225ebfa0','5.162.102.229',1760777265,_binary '__ci_last_regenerate|i:1760777265;'),('0d38477941ea74d420773cbe328e08adbdca8154','37.40.226.149',1763619802,_binary '__ci_last_regenerate|i:1763619802;'),('43f4dfae4c9a5616a91d6790a32d842484f6b2ed','37.40.227.100',1763789117,_binary '__ci_last_regenerate|i:1763789117;'),('f495d1a4546c939b080f638a684386ad8e5cdcb6','37.40.227.100',1763789561,_binary '__ci_last_regenerate|i:1763789561;'),('2913a1a399b3ab5230fcbe3f10785b36e51e1cae','212.146.177.57',1764658436,_binary '__ci_last_regenerate|i:1764658378;user_id|s:1:\"2\";'),('732200b9f9f76af17f86324a1a68a4fd86ad451a','5.37.114.188',1764681465,_binary '__ci_last_regenerate|i:1764681465;'),('b0456e5e09317b19c351dcb2917fc4606752ffbd','37.40.91.163',1765384426,_binary '__ci_last_regenerate|i:1765384426;'),('15634670de0cb2f58150bb5bc45d6540e08f4acb','89.147.134.233',1767781240,_binary '__ci_last_regenerate|i:1767780916;user_id|s:1:\"2\";'),('5f0ce9406a7eaf9f0fcc487f55159de744242d67','188.140.128.94',1768600235,_binary '__ci_last_regenerate|i:1768600234;');

--
-- Table structure for table `Garage_Democlient_groups`
--

CREATE TABLE `Garage_Democlient_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Democlient_groups`
--

INSERT INTO `Garage_Democlient_groups` VALUES (1,'Regular',0),(2,'VIP',0);

--
-- Table structure for table `Garage_Democlients`
--

CREATE TABLE `Garage_Democlients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date NOT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `starred_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `group_ids` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `is_lead` tinyint(1) NOT NULL DEFAULT '0',
  `lead_status_id` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `lead_source_id` int(11) NOT NULL,
  `last_lead_status` text COLLATE utf8_unicode_ci NOT NULL,
  `client_migration_date` date NOT NULL,
  `vat_number` text COLLATE utf8_unicode_ci,
  `currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `disable_online_payment` tinyint(1) NOT NULL DEFAULT '0',
  `geo_location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `advance_account_id` int(11) NOT NULL DEFAULT '0',
  `blocked_sale` tinyint(1) DEFAULT '0',
  `blocked_jobcard` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Democlients`
--

INSERT INTO `Garage_Democlients` VALUES (1,'Yahya Al Hinaei','','','','','','2023-09-26','','098747346','','','',0,0,0,0,0,0,'','0000-00-00','','',0,NULL,0,0,0,0);

--
-- Table structure for table `Garage_Democontacts`
--

CREATE TABLE `Garage_Democontacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alternative_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `job_title` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Democontacts`
--


--
-- Table structure for table `Garage_Democurrencies`
--

CREATE TABLE `Garage_Democurrencies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `symbol` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rate` double NOT NULL DEFAULT '1',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Democurrencies`
--

INSERT INTO `Garage_Democurrencies` VALUES (1,'USD','$',2.6,0),(2,'OMR','OMR',1,0);

--
-- Table structure for table `Garage_Democustom_field_values`
--

CREATE TABLE `Garage_Democustom_field_values` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `related_to_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `related_to_id` int(11) NOT NULL,
  `custom_field_id` int(11) NOT NULL,
  `value` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Democustom_field_values`
--


--
-- Table structure for table `Garage_Democustom_fields`
--

CREATE TABLE `Garage_Democustom_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `placeholder` text COLLATE utf8_unicode_ci NOT NULL,
  `example_variable_name` text COLLATE utf8_unicode_ci,
  `options` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `field_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `related_to` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_table` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_invoice` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_estimate` tinyint(1) NOT NULL DEFAULT '0',
  `visible_to_admins_only` tinyint(1) NOT NULL DEFAULT '0',
  `hide_from_clients` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Democustom_fields`
--

INSERT INTO `Garage_Democustom_fields` VALUES (1,'phone number 2','phone number 2','','','number','clients',1,0,1,0,0,0,0,1),(2,'Primary Complaint','Primary Complaint','','','textarea','projects',1,0,1,0,0,0,1,0);

--
-- Table structure for table `Garage_Democustom_widgets`
--

CREATE TABLE `Garage_Democustom_widgets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci,
  `content` text COLLATE utf8_unicode_ci,
  `show_title` tinyint(1) NOT NULL DEFAULT '0',
  `show_border` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Democustom_widgets`
--


--
-- Table structure for table `Garage_Demodashboards`
--

CREATE TABLE `Garage_Demodashboards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci,
  `data` text COLLATE utf8_unicode_ci,
  `color` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demodashboards`
--

INSERT INTO `Garage_Demodashboards` VALUES (2,25,'un paid invoice','a:0:{}','#83c340',0,0),(3,25,'tree','a:0:{}','#2d9cdb',0,0);

--
-- Table structure for table `Garage_Demodelivery_note_items`
--

CREATE TABLE `Garage_Demodelivery_note_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT '0',
  `invoice_item_id` int(11) DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `quantity` int(11) NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `delivery_note_id` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demodelivery_note_items`
--


--
-- Table structure for table `Garage_Demodelivery_notes`
--

CREATE TABLE `Garage_Demodelivery_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `project_id` int(11) NOT NULL DEFAULT '0',
  `delivery_note_date` date NOT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `status` enum('draft','approved','request_approval') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demodelivery_notes`
--


--
-- Table structure for table `Garage_Demoemail_templates`
--

CREATE TABLE `Garage_Demoemail_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `email_subject` text COLLATE utf8_unicode_ci NOT NULL,
  `default_message` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `custom_message` mediumtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoemail_templates`
--


--
-- Table structure for table `Garage_Demoenteries`
--

CREATE TABLE `Garage_Demoenteries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trans_id` int(11) NOT NULL,
  `account` int(11) NOT NULL,
  `type` enum('dr','cr') NOT NULL,
  `amount` double NOT NULL,
  `narration` text NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Garage_Demoenteries`
--


--
-- Table structure for table `Garage_Demoestimate_forms`
--

CREATE TABLE `Garage_Demoestimate_forms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL,
  `assigned_to` int(11) NOT NULL,
  `public` tinyint(1) NOT NULL DEFAULT '0',
  `enable_attachment` tinyint(4) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoestimate_forms`
--


--
-- Table structure for table `Garage_Demoestimate_items`
--

CREATE TABLE `Garage_Demoestimate_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `work_place` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoestimate_items`
--


--
-- Table structure for table `Garage_Demoestimate_requests`
--

CREATE TABLE `Garage_Demoestimate_requests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `estimate_form_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `client_id` int(11) NOT NULL,
  `lead_id` int(11) NOT NULL,
  `assigned_to` int(11) NOT NULL,
  `status` enum('new','processing','hold','canceled','estimated') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoestimate_requests`
--


--
-- Table structure for table `Garage_Demoestimates`
--

CREATE TABLE `Garage_Demoestimates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `estimate_request_id` int(11) NOT NULL DEFAULT '0',
  `estimate_date` date NOT NULL,
  `valid_until` date NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci,
  `last_email_sent_date` date DEFAULT NULL,
  `status` enum('draft','sent','accepted','declined','approved','request_approval') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `discount_type` enum('before_tax','after_tax') COLLATE utf8_unicode_ci NOT NULL,
  `discount_amount` double NOT NULL,
  `discount_amount_type` enum('percentage','fixed_amount') COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `work_place` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoestimates`
--

INSERT INTO `Garage_Demoestimates` VALUES (1,1,0,'2023-09-26','2023-10-03','',NULL,'draft',0,0,'before_tax',0,'percentage',0,7,0);

--
-- Table structure for table `Garage_Demoevents`
--

CREATE TABLE `Garage_Demoevents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `location` mediumtext COLLATE utf8_unicode_ci,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci NOT NULL,
  `share_with` mediumtext COLLATE utf8_unicode_ci,
  `editable_google_event` tinyint(1) NOT NULL DEFAULT '0',
  `google_event_id` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  `color` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `recurring` int(1) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `last_start_date` date DEFAULT NULL,
  `recurring_dates` longtext COLLATE utf8_unicode_ci NOT NULL,
  `confirmed_by` text COLLATE utf8_unicode_ci NOT NULL,
  `rejected_by` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoevents`
--


--
-- Table structure for table `Garage_Demoexpense_categories`
--

CREATE TABLE `Garage_Demoexpense_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoexpense_categories`
--

INSERT INTO `Garage_Demoexpense_categories` VALUES (1,'Rent',92,0);

--
-- Table structure for table `Garage_Demoexpenses`
--

CREATE TABLE `Garage_Demoexpenses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `expense_date` date NOT NULL,
  `category_id` int(11) NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `amount` double NOT NULL,
  `payment_mode` enum('bank','cash_on_hand','cheque','reimbursement','pt_cash') COLLATE utf8_unicode_ci NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` int(11) DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `client_id` int(11) NOT NULL DEFAULT '0',
  `status` enum('draft','request_approval','approved','rejected') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `transaction_id` int(11) NOT NULL DEFAULT '0',
  `work_place` int(11) DEFAULT '0',
  `purchase_order_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoexpenses`
--


--
-- Table structure for table `Garage_Demogeneral_files`
--

CREATE TABLE `Garage_Demogeneral_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` text COLLATE utf8_unicode_ci NOT NULL,
  `file_id` text COLLATE utf8_unicode_ci,
  `service_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `file_size` double NOT NULL,
  `created_at` datetime NOT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `eroom_id` int(11) NOT NULL DEFAULT '0',
  `vehicle_id` int(11) NOT NULL DEFAULT '0',
  `uploaded_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demogeneral_files`
--


--
-- Table structure for table `Garage_Demohelp_articles`
--

CREATE TABLE `Garage_Demohelp_articles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `category_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `files` text COLLATE utf8_unicode_ci NOT NULL,
  `total_views` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demohelp_articles`
--


--
-- Table structure for table `Garage_Demohelp_categories`
--

CREATE TABLE `Garage_Demohelp_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `type` enum('help','knowledge_base') COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demohelp_categories`
--


--
-- Table structure for table `Garage_Demointernal_transactions`
--

CREATE TABLE `Garage_Demointernal_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `from_employee` int(11) NOT NULL,
  `to_employee` int(11) NOT NULL,
  `amount` float(10,3) NOT NULL,
  `note` text COLLATE utf8_bin NOT NULL,
  `status` enum('draft','approved') COLLATE utf8_bin NOT NULL DEFAULT 'draft',
  `transaction_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `Garage_Demointernal_transactions`
--


--
-- Table structure for table `Garage_Demoinventory`
--

CREATE TABLE `Garage_Demoinventory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `module` enum('purchase_orders','stock_issues','stock_returns','invoices','inventory_adjustment','invoice_returns') COLLATE utf8_unicode_ci NOT NULL,
  `module_id` int(11) DEFAULT NULL,
  `module_item_id` int(11) DEFAULT NULL,
  `quantity` float DEFAULT '0',
  `datetime` datetime DEFAULT NULL,
  `from_id` int(11) NOT NULL COMMENT '100 from supplier, 101 from client, else branch id. ',
  `to_id` int(11) NOT NULL COMMENT '100 to supplier, 101 to client, else branch id. ',
  `reserved` int(11) DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoinventory`
--


--
-- Table structure for table `Garage_Demoinvoice_items`
--

CREATE TABLE `Garage_Demoinvoice_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `invoice_id` int(11) NOT NULL,
  `non_stock` int(11) DEFAULT '0',
  `work_place` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoinvoice_items`
--


--
-- Table structure for table `Garage_Demoinvoice_payments`
--

CREATE TABLE `Garage_Demoinvoice_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` double NOT NULL,
  `payment_date` date NOT NULL,
  `payment_method_id` int(11) NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `invoice_id` int(11) NOT NULL,
  `status` enum('draft','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `transaction_id` tinytext COLLATE utf8_unicode_ci,
  `account_transaction_id` int(11) NOT NULL DEFAULT '0',
  `advance_transaction_id` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoinvoice_payments`
--


--
-- Table structure for table `Garage_Demoinvoices`
--

CREATE TABLE `Garage_Demoinvoices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `bill_date` date NOT NULL,
  `due_date` date NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci,
  `labels` text COLLATE utf8_unicode_ci,
  `last_email_sent_date` date DEFAULT NULL,
  `status` enum('draft','not_paid','cancelled') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `delivery_status` enum('delivered','not_delivered') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_delivered',
  `approval_status` enum('not_approved','request_approval','approved','reserved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_approved',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `recurring` tinyint(4) NOT NULL DEFAULT '0',
  `recurring_invoice_id` int(11) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `next_recurring_date` date DEFAULT NULL,
  `no_of_cycles_completed` int(11) NOT NULL DEFAULT '0',
  `due_reminder_date` date DEFAULT NULL,
  `recurring_reminder_date` date DEFAULT NULL,
  `discount_amount` double NOT NULL,
  `discount_amount_type` enum('percentage','fixed_amount') COLLATE utf8_unicode_ci NOT NULL,
  `discount_type` enum('before_tax','after_tax') COLLATE utf8_unicode_ci NOT NULL,
  `cancelled_at` datetime DEFAULT NULL,
  `cancelled_by` int(11) NOT NULL,
  `work_place` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoinvoices`
--


--
-- Table structure for table `Garage_Demoip_sin`
--

CREATE TABLE `Garage_Demoip_sin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `branch_id` int(11) NOT NULL,
  `date` date DEFAULT NULL,
  `sqn_id` int(11) DEFAULT '0',
  `delivery_user_id` int(11) DEFAULT NULL,
  `status` enum('draft','approved','rejected','assigned','received','returned','final_approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `note` text COLLATE utf8_unicode_ci NOT NULL,
  `receiver_user_id` int(11) DEFAULT NULL,
  `delivery_comments` text COLLATE utf8_unicode_ci,
  `receiver_comments` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoip_sin`
--


--
-- Table structure for table `Garage_Demoip_sin_items`
--

CREATE TABLE `Garage_Demoip_sin_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `sin_id` int(11) NOT NULL,
  `sqn_item_id` int(11) DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoip_sin_items`
--


--
-- Table structure for table `Garage_Demoip_sqn`
--

CREATE TABLE `Garage_Demoip_sqn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `branch_id` int(11) NOT NULL,
  `date` date DEFAULT NULL,
  `reason` text COLLATE utf8_unicode_ci,
  `status` enum('draft','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `note` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoip_sqn`
--


--
-- Table structure for table `Garage_Demoip_sqn_items`
--

CREATE TABLE `Garage_Demoip_sqn_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `sqn_id` int(11) NOT NULL,
  `quantity` int(11) DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoip_sqn_items`
--


--
-- Table structure for table `Garage_Demoip_srn`
--

CREATE TABLE `Garage_Demoip_srn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `branch_id` int(11) NOT NULL,
  `to_branch_id` int(11) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT '0',
  `client_id` int(11) DEFAULT '0',
  `invoice_id` int(11) DEFAULT '0',
  `reason` text COLLATE utf8_unicode_ci,
  `status` enum('draft','approved','rejected','completed','final_approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoip_srn`
--


--
-- Table structure for table `Garage_Demoip_srn_items`
--

CREATE TABLE `Garage_Demoip_srn_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `srn_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoip_srn_items`
--


--
-- Table structure for table `Garage_Demoitem_brands`
--

CREATE TABLE `Garage_Demoitem_brands` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoitem_brands`
--


--
-- Table structure for table `Garage_Demoitem_categories`
--

CREATE TABLE `Garage_Demoitem_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoitem_categories`
--

INSERT INTO `Garage_Demoitem_categories` VALUES (5,'Tyres',0),(6,'Engine',0),(7,'Repare',0);

--
-- Table structure for table `Garage_Demoitems`
--

CREATE TABLE `Garage_Demoitems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `part_no` text COLLATE utf8_unicode_ci,
  `part_no_2` text COLLATE utf8_unicode_ci,
  `serial_no` text COLLATE utf8_unicode_ci,
  `description` text COLLATE utf8_unicode_ci,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cost` double NOT NULL,
  `rate` double NOT NULL,
  `retail_rate` double NOT NULL,
  `category_id` int(11) NOT NULL,
  `item_type` enum('product','service') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'product',
  `item_level` int(11) DEFAULT '0',
  `item_brand` int(11) NOT NULL DEFAULT '0',
  `bar_code` text COLLATE utf8_unicode_ci,
  `blocked_sale` int(11) DEFAULT '0',
  `blocked_purchase` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoitems`
--

INSERT INTO `Garage_Demoitems` VALUES (1,'The BMW B58','','','','','',200,300,250,6,'product',0,0,'',0,0,0),(2,'Tyre 245/45 R18','','','','','',50,60,55,5,'product',0,0,'',0,0,0),(3,'Window repair ','','','','','',30,20,25,7,'service',0,0,'',0,0,0);

--
-- Table structure for table `Garage_Demoitems_levels`
--

CREATE TABLE `Garage_Demoitems_levels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `level_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoitems_levels`
--


--
-- Table structure for table `Garage_Demoitems_transfer_request`
--

CREATE TABLE `Garage_Demoitems_transfer_request` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `from_workplace_id` int(11) DEFAULT NULL,
  `to_workplace_id` int(11) DEFAULT NULL,
  `requested_by` int(11) DEFAULT NULL,
  `request_date` date DEFAULT NULL,
  `processed_by` int(11) DEFAULT NULL,
  `process_date` date DEFAULT NULL,
  `status` enum('transferred','rejected','pending','returned') COLLATE utf8_unicode_ci DEFAULT 'pending',
  `invoice_id` int(11) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoitems_transfer_request`
--


--
-- Table structure for table `Garage_Demolead_source`
--

CREATE TABLE `Garage_Demolead_source` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demolead_source`
--

INSERT INTO `Garage_Demolead_source` VALUES (1,'Google',1,0),(2,'Facebook',2,0),(3,'Twitter',3,0),(4,'Youtube',4,0),(5,'Elsewhere',5,0);

--
-- Table structure for table `Garage_Demolead_status`
--

CREATE TABLE `Garage_Demolead_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demolead_status`
--

INSERT INTO `Garage_Demolead_status` VALUES (1,'New','#f1c40f',0,0),(2,'Qualified','#2d9cdb',1,0),(3,'Discussion','#29c2c2',2,0),(4,'Negotiation','#2d9cdb',3,0),(5,'Won','#83c340',4,0),(6,'Lost','#e74c3c',5,0);

--
-- Table structure for table `Garage_Demoleads`
--

CREATE TABLE `Garage_Demoleads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `first_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date NOT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoleads`
--


--
-- Table structure for table `Garage_Demoleave_applications`
--

CREATE TABLE `Garage_Demoleave_applications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `leave_type_id` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `total_hours` decimal(7,2) NOT NULL,
  `total_days` decimal(5,2) NOT NULL,
  `applicant_id` int(11) NOT NULL,
  `reason` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('pending','approved','rejected','canceled') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `checked_at` datetime DEFAULT NULL,
  `checked_by` int(11) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `leave_type_id` (`leave_type_id`),
  KEY `user_id` (`applicant_id`),
  KEY `checked_by` (`checked_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoleave_applications`
--


--
-- Table structure for table `Garage_Demoleave_types`
--

CREATE TABLE `Garage_Demoleave_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoleave_types`
--

INSERT INTO `Garage_Demoleave_types` VALUES (1,'Casual Leave','active','#83c340','',0),(2,'Annual Leave','active','#83c340','',0),(3,'Emergency leave','active','#29c2c2','',0),(4,'Eid Vacation','active','#83c340','',0);

--
-- Table structure for table `Garage_Demomessages`
--

CREATE TABLE `Garage_Demomessages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Untitled',
  `message` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `from_user_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `status` enum('unread','read') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'unread',
  `message_id` int(11) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `files` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted_by_users` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `message_from` (`from_user_id`),
  KEY `message_to` (`to_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demomessages`
--


--
-- Table structure for table `Garage_Demomilestones`
--

CREATE TABLE `Garage_Demomilestones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL,
  `due_date` date NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demomilestones`
--


--
-- Table structure for table `Garage_Demonotes`
--

CREATE TABLE `Garage_Demonotes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `client_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci,
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demonotes`
--


--
-- Table structure for table `Garage_Demonotification_settings`
--

CREATE TABLE `Garage_Demonotification_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event` varchar(250) NOT NULL,
  `category` varchar(50) NOT NULL,
  `enable_email` int(1) NOT NULL DEFAULT '0',
  `enable_web` int(1) NOT NULL DEFAULT '0',
  `notify_to_team` text NOT NULL,
  `notify_to_team_members` text NOT NULL,
  `notify_to_terms` text NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `event` (`event`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Garage_Demonotification_settings`
--

INSERT INTO `Garage_Demonotification_settings` VALUES (1,'project_created','project',1,1,'1','5','client_primary_contact,client_all_contacts',1,0),(2,'project_deleted','project',0,1,'1','5','project_members,client_primary_contact,client_all_contacts',2,0),(3,'project_task_created','project',0,1,'','5','project_members,task_assignee',3,0),(4,'project_task_updated','project',0,1,'','','task_assignee',4,0),(5,'project_task_assigned','project',0,1,'','','task_assignee',5,0),(7,'project_task_started','project',0,1,'','5','project_members,client_primary_contact,client_all_contacts',7,0),(8,'project_task_finished','project',0,0,'','','',8,0),(9,'project_task_reopened','project',0,0,'','','',9,0),(10,'project_task_deleted','project',0,1,'','','task_assignee',10,0),(11,'project_task_commented','project',0,1,'','','task_assignee',11,0),(12,'project_member_added','project',0,1,'','','project_members',12,0),(13,'project_member_deleted','project',0,1,'','','project_members',13,0),(14,'project_file_added','project',0,1,'','','project_members',14,0),(15,'project_file_deleted','project',0,1,'','','project_members',15,0),(16,'project_file_commented','project',0,1,'','','project_members',16,0),(17,'project_comment_added','project',0,1,'','','project_members',17,0),(18,'project_comment_replied','project',0,1,'','','project_members,comment_creator',18,0),(19,'project_customer_feedback_added','project',0,1,'','','project_members',19,0),(20,'project_customer_feedback_replied','project',0,1,'','','project_members,comment_creator',20,0),(21,'client_signup','client',0,0,'','','',21,0),(22,'invoice_online_payment_received','invoice',0,0,'','','',22,0),(23,'leave_application_submitted','leave',0,0,'','','',23,0),(24,'leave_approved','leave',0,1,'','','leave_applicant',24,0),(25,'leave_assigned','leave',0,1,'','','leave_applicant',25,0),(26,'leave_rejected','leave',0,1,'','','leave_applicant',26,0),(27,'leave_canceled','leave',0,0,'','','',27,0),(28,'ticket_created','ticket',0,1,'','6,7,5,11,12,1','client_all_contacts',28,0),(29,'ticket_commented','ticket',0,1,'','','client_primary_contact,ticket_creator',29,0),(30,'ticket_closed','ticket',0,1,'','','client_primary_contact,ticket_creator',30,0),(31,'ticket_reopened','ticket',0,1,'','','client_primary_contact,ticket_creator',31,0),(32,'estimate_request_received','estimate',0,0,'','','',32,0),(33,'estimate_sent','estimate',0,0,'','','',33,0),(34,'estimate_accepted','estimate',0,0,'','','',34,0),(35,'estimate_rejected','estimate',0,0,'','','',35,0),(36,'new_message_sent','message',0,0,'','','',36,0),(37,'message_reply_sent','message',0,0,'','','',37,0),(38,'invoice_payment_confirmation','invoice',0,0,'','','',22,0),(39,'new_event_added_in_calendar','event',0,0,'','','',39,0),(40,'recurring_invoice_created_vai_cron_job','invoice',0,0,'','','',22,0),(41,'new_announcement_created','announcement',1,1,'','','recipient',41,0),(42,'invoice_due_reminder_before_due_date','invoice',0,0,'','','',22,0),(43,'invoice_overdue_reminder','invoice',0,0,'','','',22,0),(44,'recurring_invoice_creation_reminder','invoice',0,0,'','','',22,0),(45,'project_completed','project',0,0,'','','',2,0),(46,'lead_created','lead',0,0,'','','',21,0),(47,'client_created_from_lead','lead',0,0,'','','',21,0),(48,'project_task_deadline_pre_reminder','project',0,1,'','','task_assignee',20,0),(49,'project_task_reminder_on_the_day_of_deadline','project',0,1,'','','task_assignee',20,0),(50,'project_task_deadline_overdue_reminder','project',0,1,'','','task_assignee',20,0),(51,'recurring_task_created_via_cron_job','project',0,1,'','','project_members,task_assignee',20,0),(52,'calendar_event_modified','event',0,0,'','','',39,0);

--
-- Table structure for table `Garage_Demonotifications`
--

CREATE TABLE `Garage_Demonotifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `notify_to` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `read_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `event` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL,
  `project_comment_id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `ticket_comment_id` int(11) NOT NULL,
  `project_file_id` int(11) NOT NULL,
  `leave_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `activity_log_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `lead_id` int(11) NOT NULL,
  `invoice_payment_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `estimate_request_id` int(11) NOT NULL,
  `actual_message_id` int(11) NOT NULL,
  `parent_message_id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `announcement_id` int(11) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demonotifications`
--


--
-- Table structure for table `Garage_Demopayment_methods`
--

CREATE TABLE `Garage_Demopayment_methods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'custom',
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `online_payable` tinyint(1) NOT NULL DEFAULT '0',
  `available_on_invoice` tinyint(1) NOT NULL DEFAULT '0',
  `minimum_payment_amount` double NOT NULL DEFAULT '0',
  `settings` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demopayment_methods`
--

INSERT INTO `Garage_Demopayment_methods` VALUES (1,'Cash','custom','',0,0,0,'a:0:{}',0),(4,'Bank transfer','custom','',0,0,0,'a:0:{}',0),(5,'Cheque','custom','',0,0,0,'a:0:{}',0),(6,'jk','custom','jh',0,0,0,'a:0:{}',1),(7,'Visa','custom','',0,0,0,'a:0:{}',0);

--
-- Table structure for table `Garage_Demopaypal_ipn`
--

CREATE TABLE `Garage_Demopaypal_ipn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` tinytext COLLATE utf8_unicode_ci,
  `ipn_hash` longtext COLLATE utf8_unicode_ci NOT NULL,
  `ipn_data` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demopaypal_ipn`
--


--
-- Table structure for table `Garage_Demopayroll`
--

CREATE TABLE `Garage_Demopayroll` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `month` date NOT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demopayroll`
--


--
-- Table structure for table `Garage_Demopayroll_detail`
--

CREATE TABLE `Garage_Demopayroll_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payroll_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `salary` float(8,3) NOT NULL,
  `manual_deduction` float(8,3) NOT NULL,
  `manual_deduction_reason` text COLLATE utf8_unicode_ci,
  `manual_bounce` float(8,3) NOT NULL,
  `manual_bonus_reason` text COLLATE utf8_unicode_ci,
  `advance` float(10,3) NOT NULL,
  `loan` float(10,3) NOT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demopayroll_detail`
--


--
-- Table structure for table `Garage_Demoposts`
--

CREATE TABLE `Garage_Demoposts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `post_id` int(11) NOT NULL,
  `share_with` text COLLATE utf8_unicode_ci,
  `files` longtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoposts`
--


--
-- Table structure for table `Garage_Demoproject_comments`
--

CREATE TABLE `Garage_Demoproject_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `comment_id` int(11) NOT NULL DEFAULT '0',
  `task_id` int(11) NOT NULL DEFAULT '0',
  `file_id` int(11) NOT NULL DEFAULT '0',
  `customer_feedback_id` int(11) NOT NULL DEFAULT '0',
  `files` longtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoproject_comments`
--


--
-- Table structure for table `Garage_Demoproject_files`
--

CREATE TABLE `Garage_Demoproject_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` text COLLATE utf8_unicode_ci NOT NULL,
  `file_id` text COLLATE utf8_unicode_ci,
  `service_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `file_size` double NOT NULL,
  `created_at` datetime NOT NULL,
  `project_id` int(11) NOT NULL,
  `uploaded_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoproject_files`
--


--
-- Table structure for table `Garage_Demoproject_members`
--

CREATE TABLE `Garage_Demoproject_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `is_leader` tinyint(1) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoproject_members`
--


--
-- Table structure for table `Garage_Demoproject_settings`
--

CREATE TABLE `Garage_Demoproject_settings` (
  `project_id` int(11) NOT NULL,
  `setting_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `setting_value` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `unique_index` (`project_id`,`setting_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoproject_settings`
--


--
-- Table structure for table `Garage_Demoproject_time`
--

CREATE TABLE `Garage_Demoproject_time` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime DEFAULT NULL,
  `status` enum('open','logged','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'logged',
  `note` text COLLATE utf8_unicode_ci,
  `task_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoproject_time`
--


--
-- Table structure for table `Garage_Demoprojects`
--

CREATE TABLE `Garage_Demoprojects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `start_date` date DEFAULT NULL,
  `deadline` date DEFAULT NULL,
  `client_id` int(11) NOT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT '0',
  `status` enum('open','completed','hold','canceled','pending','') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending',
  `labels` text COLLATE utf8_unicode_ci,
  `price` double NOT NULL DEFAULT '0',
  `starred_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `geo_location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vehicle` int(11) NOT NULL DEFAULT '0',
  `work_place` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoprojects`
--


--
-- Table structure for table `Garage_Demopurchase_order_items`
--

CREATE TABLE `Garage_Demopurchase_order_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `purchase_order_id` int(11) NOT NULL,
  `work_place` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demopurchase_order_items`
--


--
-- Table structure for table `Garage_Demopurchase_order_payments`
--

CREATE TABLE `Garage_Demopurchase_order_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` double NOT NULL,
  `payment_date` date NOT NULL,
  `payment_method_id` int(11) NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `purchase_order_id` int(11) NOT NULL,
  `status` enum('draft','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `transaction_id` int(11) DEFAULT '0',
  `prepayment_transaction_id` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demopurchase_order_payments`
--


--
-- Table structure for table `Garage_Demopurchase_orders`
--

CREATE TABLE `Garage_Demopurchase_orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `supplier_id` int(11) NOT NULL,
  `purchase_order_date` date NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci,
  `status` enum('draft','not_paid') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `approval_status` enum('not_approved','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_approved',
  `shipment_status` enum('delivered','not_delivered') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_delivered',
  `work_place` int(11) DEFAULT '0',
  `invoice_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `invoice_date` date DEFAULT NULL,
  `wip_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demopurchase_orders`
--

INSERT INTO `Garage_Demopurchase_orders` VALUES (1,13,'2023-09-30',0,'','','draft','not_approved','not_delivered',7,'123','2023-09-30','123',0);

--
-- Table structure for table `Garage_Demoroles`
--

CREATE TABLE `Garage_Demoroles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `permissions` mediumtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoroles`
--


--
-- Table structure for table `Garage_Demosettings`
--

CREATE TABLE `Garage_Demosettings` (
  `setting_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `setting_value` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'app',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `setting_name` (`setting_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demosettings`
--

INSERT INTO `Garage_Demosettings` VALUES ('accepted_file_formats','jpg,jpeg,doc,pdf,csv,pptx,xlsx,docx,png,rar','app',0),('allow_partial_invoice_payment_from_clients','','app',0),('allowed_ip_addresses','','app',0),('app_title','Oman Garage','app',0),('attendance_password','94269935','app',0),('client_can_add_project_files','','app',0),('client_can_comment_on_files','','app',0),('client_can_comment_on_tasks','','app',0),('client_can_create_projects','','app',0),('client_can_create_tasks','','app',0),('client_can_edit_tasks','','app',0),('client_can_view_activity','','app',0),('client_can_view_gantt','','app',0),('client_can_view_milestones','','app',0),('client_can_view_overview','','app',0),('client_can_view_project_files','','app',0),('client_can_view_tasks','','app',0),('client_default_dashboard','','app',0),('client_message_own_contacts','','app',0),('client_message_users','5','app',0),('company_address','Al-Ma\'bila 11th\nPost Box No: 673, Postal Code: 113','app',0),('company_email','info@teamway.om','app',0),('company_name','My 4x4 Oman','app',0),('company_phone','00968 - 95094494','app',0),('company_vat_number','','app',0),('company_website','www.my4x4oman.com','app',0),('currency_position','right','app',0),('currency_symbol','/ OMR','app',0),('date_format','d-m-Y','app',0),('decimal_separator','.','app',0),('default_currency','OMR','app',0),('default_due_date_after_billing_date','1','app',0),('disable_client_login','1','app',0),('disable_client_signup','1','app',0),('email_protocol','','app',0),('email_sent_from_address','info@teamway.om','app',0),('email_sent_from_name','Teamway','app',0),('email_smtp_host','','app',0),('email_smtp_pass','','app',0),('email_smtp_port','','app',0),('email_smtp_security_type','none','app',0),('email_smtp_user','','app',0),('enable_attendance','','app',0),('enable_email_piping','','app',0),('enable_google_calendar_api','','app',0),('enable_push_notification','','app',0),('enable_rich_text_editor','0','app',0),('estimate_color','#808080','app',0),('first_day_of_week','0','app',0),('hidden_client_menus','','app',0),('imap_email','muhand@almutsahel.com','app',0),('imap_host','','app',0),('imap_password','Mcs@123456','app',0),('imap_port','','app',0),('imap_ssl_enabled','1','app',0),('initial_number_of_the_estimate','10','app',0),('initial_number_of_the_invoice','8938','app',0),('invoice_color','#808080','app',0),('invoice_footer','<p><br></p>','app',0),('invoice_prefix','','app',0),('item_purchase_code','53434654','app',0),('language','arabic','app',0),('module_announcement','','app',0),('module_attendance','','app',0),('module_chat','1','app',0),('module_estimate','1','app',0),('module_estimate_request','','app',0),('module_event','1','app',0),('module_expense','1','app',0),('module_help','','app',0),('module_invoice','1','app',0),('module_knowledge_base','','app',0),('module_lead','','app',0),('module_leave','','app',0),('module_message','1','app',0),('module_note','1','app',0),('module_project_timesheet','','app',0),('module_ticket','','app',0),('module_timeline','','app',0),('module_todo','','app',0),('no_of_decimals','2','app',0),('project_reference_in_tickets','1','app',0),('pusher_app_id','929038','app',0),('pusher_cluster','eu','app',0),('pusher_key','2cbc86a72bfa9a85b0e5','app',0),('pusher_secret','53077cbb420c5e79c8f6','app',0),('rows_per_page','100','app',0),('scrollbar','native','app',0),('send_bcc_to','','app',0),('send_estimate_bcc_to','','app',0),('show_background_image_in_signin_page','yes','app',0),('show_logo_in_signin_page','yes','app',0),('show_recent_ticket_comments_at_the_top','1','app',0),('signin_page_background','sigin-background-image.jpg','app',0),('ticket_prefix','','app',0),('time_format','24_hours','app',0),('timezone','Asia/Muscat','app',0),('user_2_dashboard','','user',0),('user_2_personal_language','english','user',0),('weekend','5,6','app',0);

--
-- Table structure for table `Garage_Demoshipment_items`
--

CREATE TABLE `Garage_Demoshipment_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT '0',
  `purchase_order_item_id` int(11) DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `quantity` int(11) NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `shipment_id` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoshipment_items`
--


--
-- Table structure for table `Garage_Demoshipments`
--

CREATE TABLE `Garage_Demoshipments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_order_id` int(11) NOT NULL,
  `supplier_id` int(11) NOT NULL DEFAULT '0',
  `shipment_date` date NOT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `status` enum('draft','approved','request_approval') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoshipments`
--


--
-- Table structure for table `Garage_Demosocial_links`
--

CREATE TABLE `Garage_Demosocial_links` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `facebook` text COLLATE utf8_unicode_ci,
  `twitter` text COLLATE utf8_unicode_ci,
  `linkedin` text COLLATE utf8_unicode_ci,
  `googleplus` text COLLATE utf8_unicode_ci,
  `digg` text COLLATE utf8_unicode_ci,
  `youtube` text COLLATE utf8_unicode_ci,
  `pinterest` text COLLATE utf8_unicode_ci,
  `instagram` text COLLATE utf8_unicode_ci,
  `github` text COLLATE utf8_unicode_ci,
  `tumblr` text COLLATE utf8_unicode_ci,
  `vine` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demosocial_links`
--


--
-- Table structure for table `Garage_Demosuppliers`
--

CREATE TABLE `Garage_Demosuppliers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `contact_name` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alternative_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vat_number` text COLLATE utf8_unicode_ci,
  `note` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `currency_id` int(11) NOT NULL DEFAULT '0',
  `account_id` int(11) NOT NULL DEFAULT '0',
  `advance_account_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demosuppliers`
--

INSERT INTO `Garage_Demosuppliers` VALUES (13,'Apollo','Apollo','','','','','','2023-09-26','','94875645654','','','','','',0,0,0,0),(14,'Bridgestone','Bridgestone','','','','','','2023-09-26','','76465446','','','','','',0,0,0,0);

--
-- Table structure for table `Garage_Demotask_status`
--

CREATE TABLE `Garage_Demotask_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `key_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demotask_status`
--

INSERT INTO `Garage_Demotask_status` VALUES (1,'To Do','to_do','#F9A52D',0,0),(2,'In progress','in_progress','#1672B9',1,0),(3,'Done','done','#00B393',2,0),(4,'holding','','#aab7b7',3,0);

--
-- Table structure for table `Garage_Demotasks`
--

CREATE TABLE `Garage_Demotasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `milestone_id` int(11) NOT NULL DEFAULT '0',
  `assigned_to` int(11) NOT NULL,
  `deadline` date DEFAULT NULL,
  `labels` text COLLATE utf8_unicode_ci,
  `points` tinyint(4) NOT NULL DEFAULT '1',
  `status` enum('to_do','in_progress','done') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'to_do',
  `status_id` int(11) NOT NULL,
  `start_date` date DEFAULT NULL,
  `collaborators` text COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `recurring` tinyint(1) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `recurring_task_id` int(11) NOT NULL DEFAULT '0',
  `no_of_cycles_completed` int(11) NOT NULL DEFAULT '0',
  `created_date` date NOT NULL,
  `next_recurring_date` date DEFAULT NULL,
  `reminder_date` date NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `deleted` tinyint(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demotasks`
--


--
-- Table structure for table `Garage_Demotaxes`
--

CREATE TABLE `Garage_Demotaxes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `percentage` double NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Garage_Demotaxes`
--

INSERT INTO `Garage_Demotaxes` VALUES (1,'Tax (10%)',10,0),(2,'VAT',5,0);

--
-- Table structure for table `Garage_Demoteam`
--

CREATE TABLE `Garage_Demoteam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `members` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoteam`
--


--
-- Table structure for table `Garage_Demoteam_member_job_info`
--

CREATE TABLE `Garage_Demoteam_member_job_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `date_of_hire` date DEFAULT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  `salary` double NOT NULL DEFAULT '0',
  `salary_term` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `working_hours` int(11) DEFAULT NULL,
  `yearly_leaves` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoteam_member_job_info`
--


--
-- Table structure for table `Garage_Demoticket_comments`
--

CREATE TABLE `Garage_Demoticket_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `files` longtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoticket_comments`
--


--
-- Table structure for table `Garage_Demoticket_types`
--

CREATE TABLE `Garage_Demoticket_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoticket_types`
--

INSERT INTO `Garage_Demoticket_types` VALUES (1,'General Support',0),(2,'One way',0),(3,'Two way',0);

--
-- Table structure for table `Garage_Demotickets`
--

CREATE TABLE `Garage_Demotickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `ticket_type_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `status` enum('new','client_replied','open','closed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
  `last_activity_at` datetime DEFAULT NULL,
  `assigned_to` int(11) NOT NULL DEFAULT '0',
  `creator_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `creator_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `labels` text COLLATE utf8_unicode_ci,
  `task_id` int(11) NOT NULL,
  `closed_at` datetime NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demotickets`
--


--
-- Table structure for table `Garage_Demoto_do`
--

CREATE TABLE `Garage_Demoto_do` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `labels` text COLLATE utf8_unicode_ci,
  `status` enum('to_do','done') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'to_do',
  `start_date` date DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demoto_do`
--


--
-- Table structure for table `Garage_Demotransactions`
--

CREATE TABLE `Garage_Demotransactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `type` text NOT NULL,
  `is_manual` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Garage_Demotransactions`
--


--
-- Table structure for table `Garage_Demousers`
--

CREATE TABLE `Garage_Demousers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nationality` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `first_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `superior_id` int(11) DEFAULT '-1',
  `user_type` enum('staff','client','lead') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'client',
  `is_admin` tinyint(1) NOT NULL DEFAULT '0',
  `role_id` int(11) NOT NULL DEFAULT '0',
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` text COLLATE utf8_unicode_ci,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `message_checked_at` datetime DEFAULT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `notification_checked_at` datetime DEFAULT NULL,
  `is_primary_contact` tinyint(1) NOT NULL DEFAULT '0',
  `job_title` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Untitled',
  `disable_login` tinyint(1) NOT NULL DEFAULT '0',
  `note` mediumtext COLLATE utf8_unicode_ci,
  `address` text COLLATE utf8_unicode_ci,
  `alternative_address` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alternative_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `ssn` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gender` enum('male','female') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'male',
  `sticky_note` mediumtext COLLATE utf8_unicode_ci,
  `external_links` mediumtext COLLATE utf8_unicode_ci,
  `skype` text COLLATE utf8_unicode_ci,
  `enable_web_notification` tinyint(1) NOT NULL DEFAULT '1',
  `enable_email_notification` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `last_online` datetime DEFAULT NULL,
  `pt_account_id` int(11) NOT NULL DEFAULT '0',
  `sal_account_id` int(11) NOT NULL DEFAULT '0',
  `imb_account_id` int(11) NOT NULL DEFAULT '0',
  `resident_card_no` text COLLATE utf8_unicode_ci,
  `resident_card_expiry` date DEFAULT NULL,
  `passport_no` text COLLATE utf8_unicode_ci,
  `passport_expiry` date DEFAULT NULL,
  `requested_account_removal` tinyint(1) DEFAULT '0',
  `payroll` tinyint(1) DEFAULT '1',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_type` (`user_type`),
  KEY `email` (`email`),
  KEY `client_id` (`client_id`),
  KEY `deleted` (`deleted`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demousers`
--

INSERT INTO `Garage_Demousers` VALUES (2,'0','Admin','Admin',-1,'staff',1,0,'garagedemo@teamway.om','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,'2025-03-10 10:55:44',0,'Untitled',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'male',NULL,NULL,NULL,1,1,NULL,'2026-01-07 10:20:40',0,0,0,NULL,NULL,NULL,NULL,0,1,0),(3,'0','Yahya Al Hinaei','',-1,'client',0,0,'yahya@gmail.com',NULL,NULL,'active',NULL,1,NULL,1,'Untitled',0,NULL,NULL,NULL,'098747346',NULL,NULL,NULL,'male',NULL,NULL,NULL,1,1,'2023-09-26 10:02:50',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,0);

--
-- Table structure for table `Garage_Demovehicles`
--

CREATE TABLE `Garage_Demovehicles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `ac` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'no',
  `rego` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `make` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `model` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `model_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `model_series` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vin` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `engine_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fleet_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `transmission` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `body_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `seating_cap` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `odometer` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hours` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `drive_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `engine_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `chassis_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fuel_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rego_due_date` date DEFAULT NULL,
  `build_date` year(4) DEFAULT NULL COMMENT 'year',
  `produce_date` date DEFAULT NULL,
  `last_in_date` date DEFAULT NULL,
  `last_service` date DEFAULT NULL,
  `next_service` date DEFAULT NULL,
  `next_service_km` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `service_intervals` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cylinders` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `liters` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fuel_induction` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tare_mass` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `radio_pin` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `key_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tyre_size` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `imported_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `blocked` tinyint(1) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4057 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demovehicles`
--


--
-- Table structure for table `Garage_Demowork_places`
--

CREATE TABLE `Garage_Demowork_places` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Garage_Demowork_places`
--

INSERT INTO `Garage_Demowork_places` VALUES (6,'Main Branch',0),(7,'Branch 1',0),(8,'Branch 2',0);

--
-- Table structure for table `garage1accounts`
--

CREATE TABLE `garage1accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `acc_name` varchar(255) NOT NULL,
  `acc_code` varchar(255) DEFAULT NULL,
  `acc_parent` int(11) NOT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `garage1accounts`
--

INSERT INTO `garage1accounts` VALUES (1,'Assets','1',0,1,0),(2,'Liabilities','2',0,1,0),(3,'Owner\'s Equity','3',0,1,0),(4,'Expenses','4',0,1,0),(5,'Revenue','5',0,1,0),(6,'Cost of Goods Sold','6',0,1,0),(7,'Current Assets','1-1',1,1,0),(8,'Fixed Assets','1-2',1,1,0),(9,'Current Liabilities','2-1',2,1,0),(10,'Long-term Liabilities','2-2',2,1,0),(11,'Capital','3-1',3,1,0),(12,'Retain Earnings','3-2',3,1,0),(13,'Partners\' Withdrawal','3-3',3,1,0),(14,'Products','5-1-1',47,1,0),(15,'Services','5-1-2',47,1,0),(17,'Discounts','5-1-3',47,1,0),(18,'Banks','1-1-1',7,1,0),(19,'Cash In Hand','1-1-2',7,1,0),(20,'Receivable Accounts','1-1-3',7,1,0),(21,'Receivable Notes','1-1-4',7,1,0),(22,'Other Receivable Accounts','1-1-5',7,1,0),(23,'Employee Petty Cash','1-1-6',7,1,0),(24,'Inventory','1-1-7',7,1,0),(25,'Suppliers','2-1-1',9,1,0),(26,'Salary Payable','2-1-2',9,1,0),(47,'Sales','5-1',5,1,0),(48,'Employee Reimbursement','2-1-3',9,1,0),(52,'Default Bank','123456789',18,1,0),(53,'cheques Payable','2-1-4',9,1,0),(59,'Prepayments','1-1-8',7,1,0),(60,'Advance Payments','2-1-5',9,1,0),(67,'Salaries','4-1',4,1,0);

--
-- Table structure for table `garage1activity_logs`
--

CREATE TABLE `garage1activity_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `action` enum('created','updated','deleted') COLLATE utf8_unicode_ci NOT NULL,
  `log_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `log_type_title` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `log_type_id` int(11) NOT NULL DEFAULT '0',
  `changes` mediumtext COLLATE utf8_unicode_ci,
  `log_for` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `log_for_id` int(11) NOT NULL DEFAULT '0',
  `log_for2` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `log_for_id2` int(11) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1activity_logs`
--


--
-- Table structure for table `garage1announcements`
--

CREATE TABLE `garage1announcements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `share_with` mediumtext COLLATE utf8_unicode_ci,
  `created_at` datetime NOT NULL,
  `files` text COLLATE utf8_unicode_ci NOT NULL,
  `read_by` mediumtext COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1announcements`
--


--
-- Table structure for table `garage1attendance`
--

CREATE TABLE `garage1attendance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` enum('incomplete','pending','approved','rejected','deleted') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'incomplete',
  `user_id` int(11) NOT NULL,
  `in_time` datetime NOT NULL,
  `out_time` datetime DEFAULT NULL,
  `checked_by` int(11) DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `checked_at` datetime DEFAULT NULL,
  `reject_reason` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `checked_by` (`checked_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1attendance`
--


--
-- Table structure for table `garage1brands`
--

CREATE TABLE `garage1brands` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `models` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1brands`
--

INSERT INTO `garage1brands` VALUES (1,'BMW','335I',0),(2,'CADILLAC','ESCALADE',0),(3,'CHEVORLET','SILVERADO 1500,TAHOE,SUBURBAN,AVALANCHE,TRAVERSE,TRAVERSE AWD',0),(4,'CHRYSLER','CHRYSLER 300LX,GRAND VOYAGER,200C',0),(5,'DODGE','DORANGO ,CHARGER ,CALIBER ,RAM ,CHALENGER ,NITRO',0),(6,'FIAT','500',0),(7,'FORD','PICK-UP,DS350 AMBULANCE,F150,EXPEDITION,EXPLORER,RAPTOR,F250 SUPER DUTY,MUSTANG,RANGER,FOCUS,EDGE',0),(8,'GMC','YUKON XL ,SIERRA ,BUS 4X4 ,FIRE ,SIERRA DENALI ,ENVOY ,ACADIA',0),(9,'HUMMER','H2',0),(10,'HYUNDAI','SANTAFE',0),(11,'INFINITY','QX56,QX80',0),(12,'JEEP','CHEROKEE,SAHARA,GRAND CHEROKEE,COMANDER,LIBERTY,PATRIOT,COMPASS,RENEGADE,GRAND CHEROKEE SRT8,WRANGLER YJ,WRANGLER TJ,WRANGLER JK,WRANGLER JL,GLADIATOR',0),(13,'KIA','SOUL ,CERATO ,CARNAVAL',0),(14,'LAND ROVER','110 ,LR3 ,S 2 ,90 ,LR4 ,DISCOVERY',0),(15,'LEXUS','400 ,LX470 ,RX350',0),(16,'MAN','RECOVERI 25T, RECOVERY 1002',0),(17,'MANTRA','MANTRA',0),(18,'MAZDA','PIK UP,BUS,CX5,CX9',0),(19,'MERCEDES','E200,G-CLASS 500',0),(20,'MITSUBISHI','PAJERO,PICK UP,BUS,OUTLANDER',0),(21,'NISSAN','PATROL Y61,SUNNY,INFINITI,XTERRA,BUS,PICK UP,PATROL Y62,ARMADA,SENTRA,PATHFINDER,ALTIMA',0),(22,'PORSCHE','CAYENNE',0),(23,'SUZUKI','JIMMY',0),(24,'TOYOTA','LANDCRUISER,HILUX,FJ CRUISER,BUS COASTER,PRADO,TACOMA PICKUP,DAYNA,COROLA,AVALON,YARIS,EMBULANCE,TUNDRA,FORTUNER,RAV4,LEXUS ES330,LEXUS,CAMRY,ECHO,DAYHASU,SEQUOIA',0),(25,'VOLKSWAGON','TOURAGE',0);

--
-- Table structure for table `garage1checklist_items`
--

CREATE TABLE `garage1checklist_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `is_checked` int(11) NOT NULL DEFAULT '0',
  `task_id` int(11) NOT NULL DEFAULT '0',
  `sort` int(11) NOT NULL DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1checklist_items`
--


--
-- Table structure for table `garage1ci_sessions`
--

CREATE TABLE `garage1ci_sessions` (
  `id` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `data` blob NOT NULL,
  KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1ci_sessions`
--

INSERT INTO `garage1ci_sessions` VALUES ('dcef2e12f326bdb1cfa936fd7320cee12c4afc4e','45.80.151.145',1686828354,_binary '__ci_last_regenerate|i:1686828189;');

--
-- Table structure for table `garage1client_groups`
--

CREATE TABLE `garage1client_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1client_groups`
--

INSERT INTO `garage1client_groups` VALUES (1,'Regular',0),(2,'VIP',0);

--
-- Table structure for table `garage1clients`
--

CREATE TABLE `garage1clients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date NOT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `starred_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `group_ids` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `is_lead` tinyint(1) NOT NULL DEFAULT '0',
  `lead_status_id` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `lead_source_id` int(11) NOT NULL,
  `last_lead_status` text COLLATE utf8_unicode_ci NOT NULL,
  `client_migration_date` date NOT NULL,
  `vat_number` text COLLATE utf8_unicode_ci,
  `currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `disable_online_payment` tinyint(1) NOT NULL DEFAULT '0',
  `geo_location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `advance_account_id` int(11) NOT NULL DEFAULT '0',
  `blocked_sale` tinyint(1) DEFAULT '0',
  `blocked_jobcard` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1clients`
--


--
-- Table structure for table `garage1contacts`
--

CREATE TABLE `garage1contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alternative_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `job_title` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1contacts`
--


--
-- Table structure for table `garage1currencies`
--

CREATE TABLE `garage1currencies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `symbol` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rate` double NOT NULL DEFAULT '1',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1currencies`
--

INSERT INTO `garage1currencies` VALUES (1,'USD','$',2.6,0),(2,'OMR','OMR',1,0);

--
-- Table structure for table `garage1custom_field_values`
--

CREATE TABLE `garage1custom_field_values` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `related_to_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `related_to_id` int(11) NOT NULL,
  `custom_field_id` int(11) NOT NULL,
  `value` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1custom_field_values`
--


--
-- Table structure for table `garage1custom_fields`
--

CREATE TABLE `garage1custom_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `placeholder` text COLLATE utf8_unicode_ci NOT NULL,
  `example_variable_name` text COLLATE utf8_unicode_ci,
  `options` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `field_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `related_to` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_table` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_invoice` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_estimate` tinyint(1) NOT NULL DEFAULT '0',
  `visible_to_admins_only` tinyint(1) NOT NULL DEFAULT '0',
  `hide_from_clients` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1custom_fields`
--

INSERT INTO `garage1custom_fields` VALUES (1,'phone number 2','phone number 2','','','number','clients',1,0,1,0,0,0,0,1),(2,'Primary Complaint','Primary Complaint','','','textarea','projects',1,0,1,0,0,0,1,0);

--
-- Table structure for table `garage1custom_widgets`
--

CREATE TABLE `garage1custom_widgets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci,
  `content` text COLLATE utf8_unicode_ci,
  `show_title` tinyint(1) NOT NULL DEFAULT '0',
  `show_border` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1custom_widgets`
--


--
-- Table structure for table `garage1dashboards`
--

CREATE TABLE `garage1dashboards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci,
  `data` text COLLATE utf8_unicode_ci,
  `color` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1dashboards`
--

INSERT INTO `garage1dashboards` VALUES (2,25,'un paid invoice','a:0:{}','#83c340',0,0),(3,25,'tree','a:0:{}','#2d9cdb',0,0);

--
-- Table structure for table `garage1delivery_note_items`
--

CREATE TABLE `garage1delivery_note_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT '0',
  `invoice_item_id` int(11) DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `quantity` int(11) NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `delivery_note_id` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1delivery_note_items`
--


--
-- Table structure for table `garage1delivery_notes`
--

CREATE TABLE `garage1delivery_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `project_id` int(11) NOT NULL DEFAULT '0',
  `delivery_note_date` date NOT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `status` enum('draft','approved','request_approval') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1delivery_notes`
--


--
-- Table structure for table `garage1email_templates`
--

CREATE TABLE `garage1email_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `email_subject` text COLLATE utf8_unicode_ci NOT NULL,
  `default_message` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `custom_message` mediumtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1email_templates`
--


--
-- Table structure for table `garage1enteries`
--

CREATE TABLE `garage1enteries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trans_id` int(11) NOT NULL,
  `account` int(11) NOT NULL,
  `type` enum('dr','cr') NOT NULL,
  `amount` double NOT NULL,
  `narration` text NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `garage1enteries`
--


--
-- Table structure for table `garage1estimate_forms`
--

CREATE TABLE `garage1estimate_forms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL,
  `assigned_to` int(11) NOT NULL,
  `public` tinyint(1) NOT NULL DEFAULT '0',
  `enable_attachment` tinyint(4) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1estimate_forms`
--


--
-- Table structure for table `garage1estimate_items`
--

CREATE TABLE `garage1estimate_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `work_place` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1estimate_items`
--


--
-- Table structure for table `garage1estimate_requests`
--

CREATE TABLE `garage1estimate_requests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `estimate_form_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `client_id` int(11) NOT NULL,
  `lead_id` int(11) NOT NULL,
  `assigned_to` int(11) NOT NULL,
  `status` enum('new','processing','hold','canceled','estimated') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1estimate_requests`
--


--
-- Table structure for table `garage1estimates`
--

CREATE TABLE `garage1estimates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `estimate_request_id` int(11) NOT NULL DEFAULT '0',
  `estimate_date` date NOT NULL,
  `valid_until` date NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci,
  `last_email_sent_date` date DEFAULT NULL,
  `status` enum('draft','sent','accepted','declined','approved','request_approval') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `discount_type` enum('before_tax','after_tax') COLLATE utf8_unicode_ci NOT NULL,
  `discount_amount` double NOT NULL,
  `discount_amount_type` enum('percentage','fixed_amount') COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `work_place` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1estimates`
--


--
-- Table structure for table `garage1events`
--

CREATE TABLE `garage1events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `location` mediumtext COLLATE utf8_unicode_ci,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci NOT NULL,
  `share_with` mediumtext COLLATE utf8_unicode_ci,
  `editable_google_event` tinyint(1) NOT NULL DEFAULT '0',
  `google_event_id` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  `color` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `recurring` int(1) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `last_start_date` date DEFAULT NULL,
  `recurring_dates` longtext COLLATE utf8_unicode_ci NOT NULL,
  `confirmed_by` text COLLATE utf8_unicode_ci NOT NULL,
  `rejected_by` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1events`
--


--
-- Table structure for table `garage1expense_categories`
--

CREATE TABLE `garage1expense_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1expense_categories`
--

INSERT INTO `garage1expense_categories` VALUES (1,'Rent',92,0);

--
-- Table structure for table `garage1expenses`
--

CREATE TABLE `garage1expenses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `expense_date` date NOT NULL,
  `category_id` int(11) NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `amount` double NOT NULL,
  `payment_mode` enum('bank','cash_on_hand','cheque','reimbursement','pt_cash') COLLATE utf8_unicode_ci NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` int(11) DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `client_id` int(11) NOT NULL DEFAULT '0',
  `status` enum('draft','request_approval','approved','rejected') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `transaction_id` int(11) NOT NULL DEFAULT '0',
  `work_place` int(11) DEFAULT '0',
  `purchase_order_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1expenses`
--


--
-- Table structure for table `garage1general_files`
--

CREATE TABLE `garage1general_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` text COLLATE utf8_unicode_ci NOT NULL,
  `file_id` text COLLATE utf8_unicode_ci,
  `service_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `file_size` double NOT NULL,
  `created_at` datetime NOT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `eroom_id` int(11) NOT NULL DEFAULT '0',
  `vehicle_id` int(11) NOT NULL DEFAULT '0',
  `uploaded_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1general_files`
--


--
-- Table structure for table `garage1help_articles`
--

CREATE TABLE `garage1help_articles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `category_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `files` text COLLATE utf8_unicode_ci NOT NULL,
  `total_views` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1help_articles`
--


--
-- Table structure for table `garage1help_categories`
--

CREATE TABLE `garage1help_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `type` enum('help','knowledge_base') COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1help_categories`
--


--
-- Table structure for table `garage1internal_transactions`
--

CREATE TABLE `garage1internal_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `from_employee` int(11) NOT NULL,
  `to_employee` int(11) NOT NULL,
  `amount` float(10,3) NOT NULL,
  `note` text COLLATE utf8_bin NOT NULL,
  `status` enum('draft','approved') COLLATE utf8_bin NOT NULL DEFAULT 'draft',
  `transaction_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `garage1internal_transactions`
--


--
-- Table structure for table `garage1inventory`
--

CREATE TABLE `garage1inventory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `module` enum('purchase_orders','stock_issues','stock_returns','invoices','inventory_adjustment','invoice_returns') COLLATE utf8_unicode_ci NOT NULL,
  `module_id` int(11) DEFAULT NULL,
  `module_item_id` int(11) DEFAULT NULL,
  `quantity` float DEFAULT '0',
  `datetime` datetime DEFAULT NULL,
  `from_id` int(11) NOT NULL COMMENT '100 from supplier, 101 from client, else branch id. ',
  `to_id` int(11) NOT NULL COMMENT '100 to supplier, 101 to client, else branch id. ',
  `reserved` int(11) DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1inventory`
--


--
-- Table structure for table `garage1invoice_items`
--

CREATE TABLE `garage1invoice_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `invoice_id` int(11) NOT NULL,
  `non_stock` int(11) DEFAULT '0',
  `work_place` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1invoice_items`
--


--
-- Table structure for table `garage1invoice_payments`
--

CREATE TABLE `garage1invoice_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` double NOT NULL,
  `payment_date` date NOT NULL,
  `payment_method_id` int(11) NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `invoice_id` int(11) NOT NULL,
  `status` enum('draft','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `transaction_id` tinytext COLLATE utf8_unicode_ci,
  `account_transaction_id` int(11) NOT NULL DEFAULT '0',
  `advance_transaction_id` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1invoice_payments`
--


--
-- Table structure for table `garage1invoices`
--

CREATE TABLE `garage1invoices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `bill_date` date NOT NULL,
  `due_date` date NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci,
  `labels` text COLLATE utf8_unicode_ci,
  `last_email_sent_date` date DEFAULT NULL,
  `status` enum('draft','not_paid','cancelled') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `delivery_status` enum('delivered','not_delivered') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_delivered',
  `approval_status` enum('not_approved','request_approval','approved','reserved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_approved',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `recurring` tinyint(4) NOT NULL DEFAULT '0',
  `recurring_invoice_id` int(11) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `next_recurring_date` date DEFAULT NULL,
  `no_of_cycles_completed` int(11) NOT NULL DEFAULT '0',
  `due_reminder_date` date DEFAULT NULL,
  `recurring_reminder_date` date DEFAULT NULL,
  `discount_amount` double NOT NULL,
  `discount_amount_type` enum('percentage','fixed_amount') COLLATE utf8_unicode_ci NOT NULL,
  `discount_type` enum('before_tax','after_tax') COLLATE utf8_unicode_ci NOT NULL,
  `cancelled_at` datetime DEFAULT NULL,
  `cancelled_by` int(11) NOT NULL,
  `work_place` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1invoices`
--


--
-- Table structure for table `garage1ip_sin`
--

CREATE TABLE `garage1ip_sin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `branch_id` int(11) NOT NULL,
  `date` date DEFAULT NULL,
  `sqn_id` int(11) DEFAULT '0',
  `delivery_user_id` int(11) DEFAULT NULL,
  `status` enum('draft','approved','rejected','assigned','received','returned','final_approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `note` text COLLATE utf8_unicode_ci NOT NULL,
  `receiver_user_id` int(11) DEFAULT NULL,
  `delivery_comments` text COLLATE utf8_unicode_ci,
  `receiver_comments` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1ip_sin`
--


--
-- Table structure for table `garage1ip_sin_items`
--

CREATE TABLE `garage1ip_sin_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `sin_id` int(11) NOT NULL,
  `sqn_item_id` int(11) DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1ip_sin_items`
--


--
-- Table structure for table `garage1ip_sqn`
--

CREATE TABLE `garage1ip_sqn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `branch_id` int(11) NOT NULL,
  `date` date DEFAULT NULL,
  `reason` text COLLATE utf8_unicode_ci,
  `status` enum('draft','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `note` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1ip_sqn`
--


--
-- Table structure for table `garage1ip_sqn_items`
--

CREATE TABLE `garage1ip_sqn_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `sqn_id` int(11) NOT NULL,
  `quantity` int(11) DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1ip_sqn_items`
--


--
-- Table structure for table `garage1ip_srn`
--

CREATE TABLE `garage1ip_srn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `branch_id` int(11) NOT NULL,
  `to_branch_id` int(11) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT '0',
  `client_id` int(11) DEFAULT '0',
  `invoice_id` int(11) DEFAULT '0',
  `reason` text COLLATE utf8_unicode_ci,
  `status` enum('draft','approved','rejected','completed','final_approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1ip_srn`
--


--
-- Table structure for table `garage1ip_srn_items`
--

CREATE TABLE `garage1ip_srn_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `srn_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1ip_srn_items`
--


--
-- Table structure for table `garage1item_brands`
--

CREATE TABLE `garage1item_brands` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1item_brands`
--


--
-- Table structure for table `garage1item_categories`
--

CREATE TABLE `garage1item_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1item_categories`
--


--
-- Table structure for table `garage1items`
--

CREATE TABLE `garage1items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `part_no` text COLLATE utf8_unicode_ci,
  `part_no_2` text COLLATE utf8_unicode_ci,
  `serial_no` text COLLATE utf8_unicode_ci,
  `description` text COLLATE utf8_unicode_ci,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cost` double NOT NULL,
  `rate` double NOT NULL,
  `retail_rate` double NOT NULL,
  `category_id` int(11) NOT NULL,
  `item_type` enum('product','service') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'product',
  `item_level` int(11) DEFAULT '0',
  `item_brand` int(11) NOT NULL DEFAULT '0',
  `bar_code` text COLLATE utf8_unicode_ci,
  `blocked_sale` int(11) DEFAULT '0',
  `blocked_purchase` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1items`
--


--
-- Table structure for table `garage1items_levels`
--

CREATE TABLE `garage1items_levels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `level_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1items_levels`
--


--
-- Table structure for table `garage1items_transfer_request`
--

CREATE TABLE `garage1items_transfer_request` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `from_workplace_id` int(11) DEFAULT NULL,
  `to_workplace_id` int(11) DEFAULT NULL,
  `requested_by` int(11) DEFAULT NULL,
  `request_date` date DEFAULT NULL,
  `processed_by` int(11) DEFAULT NULL,
  `process_date` date DEFAULT NULL,
  `status` enum('transferred','rejected','pending','returned') COLLATE utf8_unicode_ci DEFAULT 'pending',
  `invoice_id` int(11) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1items_transfer_request`
--


--
-- Table structure for table `garage1lead_source`
--

CREATE TABLE `garage1lead_source` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1lead_source`
--

INSERT INTO `garage1lead_source` VALUES (1,'Google',1,0),(2,'Facebook',2,0),(3,'Twitter',3,0),(4,'Youtube',4,0),(5,'Elsewhere',5,0);

--
-- Table structure for table `garage1lead_status`
--

CREATE TABLE `garage1lead_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1lead_status`
--

INSERT INTO `garage1lead_status` VALUES (1,'New','#f1c40f',0,0),(2,'Qualified','#2d9cdb',1,0),(3,'Discussion','#29c2c2',2,0),(4,'Negotiation','#2d9cdb',3,0),(5,'Won','#83c340',4,0),(6,'Lost','#e74c3c',5,0);

--
-- Table structure for table `garage1leads`
--

CREATE TABLE `garage1leads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `first_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date NOT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1leads`
--


--
-- Table structure for table `garage1leave_applications`
--

CREATE TABLE `garage1leave_applications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `leave_type_id` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `total_hours` decimal(7,2) NOT NULL,
  `total_days` decimal(5,2) NOT NULL,
  `applicant_id` int(11) NOT NULL,
  `reason` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('pending','approved','rejected','canceled') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `checked_at` datetime DEFAULT NULL,
  `checked_by` int(11) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `leave_type_id` (`leave_type_id`),
  KEY `user_id` (`applicant_id`),
  KEY `checked_by` (`checked_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1leave_applications`
--


--
-- Table structure for table `garage1leave_types`
--

CREATE TABLE `garage1leave_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1leave_types`
--

INSERT INTO `garage1leave_types` VALUES (1,'Casual Leave','active','#83c340','',0),(2,'Annual Leave','active','#83c340','',0),(3,'Emergency leave','active','#29c2c2','',0),(4,'Eid Vacation','active','#83c340','',0);

--
-- Table structure for table `garage1messages`
--

CREATE TABLE `garage1messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Untitled',
  `message` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `from_user_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `status` enum('unread','read') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'unread',
  `message_id` int(11) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `files` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted_by_users` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `message_from` (`from_user_id`),
  KEY `message_to` (`to_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1messages`
--


--
-- Table structure for table `garage1milestones`
--

CREATE TABLE `garage1milestones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL,
  `due_date` date NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1milestones`
--


--
-- Table structure for table `garage1notes`
--

CREATE TABLE `garage1notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `client_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci,
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1notes`
--


--
-- Table structure for table `garage1notification_settings`
--

CREATE TABLE `garage1notification_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event` varchar(250) NOT NULL,
  `category` varchar(50) NOT NULL,
  `enable_email` int(1) NOT NULL DEFAULT '0',
  `enable_web` int(1) NOT NULL DEFAULT '0',
  `notify_to_team` text NOT NULL,
  `notify_to_team_members` text NOT NULL,
  `notify_to_terms` text NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `event` (`event`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `garage1notification_settings`
--

INSERT INTO `garage1notification_settings` VALUES (1,'project_created','project',1,1,'1','5','client_primary_contact,client_all_contacts',1,0),(2,'project_deleted','project',0,1,'1','5','project_members,client_primary_contact,client_all_contacts',2,0),(3,'project_task_created','project',0,1,'','5','project_members,task_assignee',3,0),(4,'project_task_updated','project',0,1,'','','task_assignee',4,0),(5,'project_task_assigned','project',0,1,'','','task_assignee',5,0),(7,'project_task_started','project',0,1,'','5','project_members,client_primary_contact,client_all_contacts',7,0),(8,'project_task_finished','project',0,0,'','','',8,0),(9,'project_task_reopened','project',0,0,'','','',9,0),(10,'project_task_deleted','project',0,1,'','','task_assignee',10,0),(11,'project_task_commented','project',0,1,'','','task_assignee',11,0),(12,'project_member_added','project',0,1,'','','project_members',12,0),(13,'project_member_deleted','project',0,1,'','','project_members',13,0),(14,'project_file_added','project',0,1,'','','project_members',14,0),(15,'project_file_deleted','project',0,1,'','','project_members',15,0),(16,'project_file_commented','project',0,1,'','','project_members',16,0),(17,'project_comment_added','project',0,1,'','','project_members',17,0),(18,'project_comment_replied','project',0,1,'','','project_members,comment_creator',18,0),(19,'project_customer_feedback_added','project',0,1,'','','project_members',19,0),(20,'project_customer_feedback_replied','project',0,1,'','','project_members,comment_creator',20,0),(21,'client_signup','client',0,0,'','','',21,0),(22,'invoice_online_payment_received','invoice',0,0,'','','',22,0),(23,'leave_application_submitted','leave',0,0,'','','',23,0),(24,'leave_approved','leave',0,1,'','','leave_applicant',24,0),(25,'leave_assigned','leave',0,1,'','','leave_applicant',25,0),(26,'leave_rejected','leave',0,1,'','','leave_applicant',26,0),(27,'leave_canceled','leave',0,0,'','','',27,0),(28,'ticket_created','ticket',0,1,'','6,7,5,11,12,1','client_all_contacts',28,0),(29,'ticket_commented','ticket',0,1,'','','client_primary_contact,ticket_creator',29,0),(30,'ticket_closed','ticket',0,1,'','','client_primary_contact,ticket_creator',30,0),(31,'ticket_reopened','ticket',0,1,'','','client_primary_contact,ticket_creator',31,0),(32,'estimate_request_received','estimate',0,0,'','','',32,0),(33,'estimate_sent','estimate',0,0,'','','',33,0),(34,'estimate_accepted','estimate',0,0,'','','',34,0),(35,'estimate_rejected','estimate',0,0,'','','',35,0),(36,'new_message_sent','message',0,0,'','','',36,0),(37,'message_reply_sent','message',0,0,'','','',37,0),(38,'invoice_payment_confirmation','invoice',0,0,'','','',22,0),(39,'new_event_added_in_calendar','event',0,0,'','','',39,0),(40,'recurring_invoice_created_vai_cron_job','invoice',0,0,'','','',22,0),(41,'new_announcement_created','announcement',1,1,'','','recipient',41,0),(42,'invoice_due_reminder_before_due_date','invoice',0,0,'','','',22,0),(43,'invoice_overdue_reminder','invoice',0,0,'','','',22,0),(44,'recurring_invoice_creation_reminder','invoice',0,0,'','','',22,0),(45,'project_completed','project',0,0,'','','',2,0),(46,'lead_created','lead',0,0,'','','',21,0),(47,'client_created_from_lead','lead',0,0,'','','',21,0),(48,'project_task_deadline_pre_reminder','project',0,1,'','','task_assignee',20,0),(49,'project_task_reminder_on_the_day_of_deadline','project',0,1,'','','task_assignee',20,0),(50,'project_task_deadline_overdue_reminder','project',0,1,'','','task_assignee',20,0),(51,'recurring_task_created_via_cron_job','project',0,1,'','','project_members,task_assignee',20,0),(52,'calendar_event_modified','event',0,0,'','','',39,0);

--
-- Table structure for table `garage1notifications`
--

CREATE TABLE `garage1notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `notify_to` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `read_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `event` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL,
  `project_comment_id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `ticket_comment_id` int(11) NOT NULL,
  `project_file_id` int(11) NOT NULL,
  `leave_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `activity_log_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `lead_id` int(11) NOT NULL,
  `invoice_payment_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `estimate_request_id` int(11) NOT NULL,
  `actual_message_id` int(11) NOT NULL,
  `parent_message_id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `announcement_id` int(11) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1notifications`
--


--
-- Table structure for table `garage1payment_methods`
--

CREATE TABLE `garage1payment_methods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'custom',
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `online_payable` tinyint(1) NOT NULL DEFAULT '0',
  `available_on_invoice` tinyint(1) NOT NULL DEFAULT '0',
  `minimum_payment_amount` double NOT NULL DEFAULT '0',
  `settings` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1payment_methods`
--

INSERT INTO `garage1payment_methods` VALUES (1,'Cash','custom','',0,0,0,'a:0:{}',0),(4,'Bank transfer','custom','',0,0,0,'a:0:{}',0),(5,'Cheque','custom','',0,0,0,'a:0:{}',0),(6,'jk','custom','jh',0,0,0,'a:0:{}',1),(7,'Visa','custom','',0,0,0,'a:0:{}',0);

--
-- Table structure for table `garage1paypal_ipn`
--

CREATE TABLE `garage1paypal_ipn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` tinytext COLLATE utf8_unicode_ci,
  `ipn_hash` longtext COLLATE utf8_unicode_ci NOT NULL,
  `ipn_data` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1paypal_ipn`
--


--
-- Table structure for table `garage1payroll`
--

CREATE TABLE `garage1payroll` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `month` date NOT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1payroll`
--


--
-- Table structure for table `garage1payroll_detail`
--

CREATE TABLE `garage1payroll_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payroll_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `salary` float(8,3) NOT NULL,
  `manual_deduction` float(8,3) NOT NULL,
  `manual_deduction_reason` text COLLATE utf8_unicode_ci,
  `manual_bounce` float(8,3) NOT NULL,
  `manual_bonus_reason` text COLLATE utf8_unicode_ci,
  `advance` float(10,3) NOT NULL,
  `loan` float(10,3) NOT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1payroll_detail`
--


--
-- Table structure for table `garage1posts`
--

CREATE TABLE `garage1posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `post_id` int(11) NOT NULL,
  `share_with` text COLLATE utf8_unicode_ci,
  `files` longtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1posts`
--


--
-- Table structure for table `garage1project_comments`
--

CREATE TABLE `garage1project_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `comment_id` int(11) NOT NULL DEFAULT '0',
  `task_id` int(11) NOT NULL DEFAULT '0',
  `file_id` int(11) NOT NULL DEFAULT '0',
  `customer_feedback_id` int(11) NOT NULL DEFAULT '0',
  `files` longtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1project_comments`
--


--
-- Table structure for table `garage1project_files`
--

CREATE TABLE `garage1project_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` text COLLATE utf8_unicode_ci NOT NULL,
  `file_id` text COLLATE utf8_unicode_ci,
  `service_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `file_size` double NOT NULL,
  `created_at` datetime NOT NULL,
  `project_id` int(11) NOT NULL,
  `uploaded_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1project_files`
--


--
-- Table structure for table `garage1project_members`
--

CREATE TABLE `garage1project_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `is_leader` tinyint(1) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1project_members`
--


--
-- Table structure for table `garage1project_settings`
--

CREATE TABLE `garage1project_settings` (
  `project_id` int(11) NOT NULL,
  `setting_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `setting_value` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `unique_index` (`project_id`,`setting_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1project_settings`
--


--
-- Table structure for table `garage1project_time`
--

CREATE TABLE `garage1project_time` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime DEFAULT NULL,
  `status` enum('open','logged','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'logged',
  `note` text COLLATE utf8_unicode_ci,
  `task_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1project_time`
--


--
-- Table structure for table `garage1projects`
--

CREATE TABLE `garage1projects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `start_date` date DEFAULT NULL,
  `deadline` date DEFAULT NULL,
  `client_id` int(11) NOT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT '0',
  `status` enum('open','completed','hold','canceled','pending','') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending',
  `labels` text COLLATE utf8_unicode_ci,
  `price` double NOT NULL DEFAULT '0',
  `starred_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `geo_location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vehicle` int(11) NOT NULL DEFAULT '0',
  `work_place` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1projects`
--


--
-- Table structure for table `garage1purchase_order_items`
--

CREATE TABLE `garage1purchase_order_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `purchase_order_id` int(11) NOT NULL,
  `work_place` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1purchase_order_items`
--


--
-- Table structure for table `garage1purchase_order_payments`
--

CREATE TABLE `garage1purchase_order_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` double NOT NULL,
  `payment_date` date NOT NULL,
  `payment_method_id` int(11) NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `purchase_order_id` int(11) NOT NULL,
  `status` enum('draft','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `transaction_id` int(11) DEFAULT '0',
  `prepayment_transaction_id` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1purchase_order_payments`
--


--
-- Table structure for table `garage1purchase_orders`
--

CREATE TABLE `garage1purchase_orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `supplier_id` int(11) NOT NULL,
  `purchase_order_date` date NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci,
  `status` enum('draft','not_paid') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `approval_status` enum('not_approved','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_approved',
  `shipment_status` enum('delivered','not_delivered') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_delivered',
  `work_place` int(11) DEFAULT '0',
  `invoice_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `invoice_date` date DEFAULT NULL,
  `wip_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1purchase_orders`
--


--
-- Table structure for table `garage1roles`
--

CREATE TABLE `garage1roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `permissions` mediumtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1roles`
--


--
-- Table structure for table `garage1settings`
--

CREATE TABLE `garage1settings` (
  `setting_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `setting_value` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'app',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `setting_name` (`setting_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1settings`
--

INSERT INTO `garage1settings` VALUES ('accepted_file_formats','jpg,jpeg,doc,pdf,csv,pptx,xlsx,docx,png,rar','app',0),('allow_partial_invoice_payment_from_clients','','app',0),('allowed_ip_addresses','','app',0),('app_title','Oman Garage','app',0),('attendance_password','94269935','app',0),('client_can_add_project_files','','app',0),('client_can_comment_on_files','','app',0),('client_can_comment_on_tasks','','app',0),('client_can_create_projects','','app',0),('client_can_create_tasks','','app',0),('client_can_edit_tasks','','app',0),('client_can_view_activity','','app',0),('client_can_view_gantt','','app',0),('client_can_view_milestones','','app',0),('client_can_view_overview','','app',0),('client_can_view_project_files','','app',0),('client_can_view_tasks','','app',0),('client_default_dashboard','','app',0),('client_message_own_contacts','','app',0),('client_message_users','5','app',0),('company_address','Al-Ma\'bila 11th\nPost Box No: 673, Postal Code: 113','app',0),('company_email','info@teamway.om','app',0),('company_name','My 4x4 Oman','app',0),('company_phone','00968 - 95094494','app',0),('company_vat_number','','app',0),('company_website','www.my4x4oman.com','app',0),('currency_position','right','app',0),('currency_symbol','/ OMR','app',0),('date_format','d-m-Y','app',0),('decimal_separator','.','app',0),('default_currency','OMR','app',0),('default_due_date_after_billing_date','1','app',0),('disable_client_login','1','app',0),('disable_client_signup','1','app',0),('email_protocol','','app',0),('email_sent_from_address','info@teamway.om','app',0),('email_sent_from_name','Teamway','app',0),('email_smtp_host','','app',0),('email_smtp_pass','','app',0),('email_smtp_port','','app',0),('email_smtp_security_type','none','app',0),('email_smtp_user','','app',0),('enable_attendance','','app',0),('enable_email_piping','','app',0),('enable_google_calendar_api','','app',0),('enable_push_notification','','app',0),('enable_rich_text_editor','0','app',0),('estimate_color','#808080','app',0),('first_day_of_week','0','app',0),('hidden_client_menus','','app',0),('imap_email','muhand@almutsahel.com','app',0),('imap_host','','app',0),('imap_password','Mcs@123456','app',0),('imap_port','','app',0),('imap_ssl_enabled','1','app',0),('initial_number_of_the_estimate','10','app',0),('initial_number_of_the_invoice','8938','app',0),('invoice_color','#808080','app',0),('invoice_footer','<p><br></p>','app',0),('invoice_prefix','','app',0),('item_purchase_code','53434654','app',0),('language','arabic','app',0),('module_announcement','','app',0),('module_attendance','','app',0),('module_chat','1','app',0),('module_estimate','1','app',0),('module_estimate_request','','app',0),('module_event','1','app',0),('module_expense','1','app',0),('module_help','','app',0),('module_invoice','1','app',0),('module_knowledge_base','','app',0),('module_lead','','app',0),('module_leave','','app',0),('module_message','1','app',0),('module_note','1','app',0),('module_project_timesheet','','app',0),('module_ticket','','app',0),('module_timeline','','app',0),('module_todo','','app',0),('no_of_decimals','2','app',0),('project_reference_in_tickets','1','app',0),('pusher_app_id','929038','app',0),('pusher_cluster','eu','app',0),('pusher_key','2cbc86a72bfa9a85b0e5','app',0),('pusher_secret','53077cbb420c5e79c8f6','app',0),('rows_per_page','100','app',0),('scrollbar','native','app',0),('send_bcc_to','','app',0),('send_estimate_bcc_to','','app',0),('show_background_image_in_signin_page','yes','app',0),('show_logo_in_signin_page','yes','app',0),('show_recent_ticket_comments_at_the_top','1','app',0),('signin_page_background','sigin-background-image.jpg','app',0),('ticket_prefix','','app',0),('time_format','24_hours','app',0),('timezone','Asia/Muscat','app',0),('weekend','5,6','app',0);

--
-- Table structure for table `garage1shipment_items`
--

CREATE TABLE `garage1shipment_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT '0',
  `purchase_order_item_id` int(11) DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `quantity` int(11) NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `shipment_id` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1shipment_items`
--


--
-- Table structure for table `garage1shipments`
--

CREATE TABLE `garage1shipments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_order_id` int(11) NOT NULL,
  `supplier_id` int(11) NOT NULL DEFAULT '0',
  `shipment_date` date NOT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `status` enum('draft','approved','request_approval') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1shipments`
--


--
-- Table structure for table `garage1social_links`
--

CREATE TABLE `garage1social_links` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `facebook` text COLLATE utf8_unicode_ci,
  `twitter` text COLLATE utf8_unicode_ci,
  `linkedin` text COLLATE utf8_unicode_ci,
  `googleplus` text COLLATE utf8_unicode_ci,
  `digg` text COLLATE utf8_unicode_ci,
  `youtube` text COLLATE utf8_unicode_ci,
  `pinterest` text COLLATE utf8_unicode_ci,
  `instagram` text COLLATE utf8_unicode_ci,
  `github` text COLLATE utf8_unicode_ci,
  `tumblr` text COLLATE utf8_unicode_ci,
  `vine` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1social_links`
--


--
-- Table structure for table `garage1suppliers`
--

CREATE TABLE `garage1suppliers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `contact_name` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alternative_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vat_number` text COLLATE utf8_unicode_ci,
  `note` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `currency_id` int(11) NOT NULL DEFAULT '0',
  `account_id` int(11) NOT NULL DEFAULT '0',
  `advance_account_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1suppliers`
--


--
-- Table structure for table `garage1task_status`
--

CREATE TABLE `garage1task_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `key_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1task_status`
--

INSERT INTO `garage1task_status` VALUES (1,'To Do','to_do','#F9A52D',0,0),(2,'In progress','in_progress','#1672B9',1,0),(3,'Done','done','#00B393',2,0),(4,'holding','','#aab7b7',3,0);

--
-- Table structure for table `garage1tasks`
--

CREATE TABLE `garage1tasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `milestone_id` int(11) NOT NULL DEFAULT '0',
  `assigned_to` int(11) NOT NULL,
  `deadline` date DEFAULT NULL,
  `labels` text COLLATE utf8_unicode_ci,
  `points` tinyint(4) NOT NULL DEFAULT '1',
  `status` enum('to_do','in_progress','done') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'to_do',
  `status_id` int(11) NOT NULL,
  `start_date` date DEFAULT NULL,
  `collaborators` text COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `recurring` tinyint(1) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `recurring_task_id` int(11) NOT NULL DEFAULT '0',
  `no_of_cycles_completed` int(11) NOT NULL DEFAULT '0',
  `created_date` date NOT NULL,
  `next_recurring_date` date DEFAULT NULL,
  `reminder_date` date NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `deleted` tinyint(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1tasks`
--


--
-- Table structure for table `garage1taxes`
--

CREATE TABLE `garage1taxes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `percentage` double NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `garage1taxes`
--

INSERT INTO `garage1taxes` VALUES (1,'Tax (10%)',10,0),(2,'VAT',5,0);

--
-- Table structure for table `garage1team`
--

CREATE TABLE `garage1team` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `members` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1team`
--


--
-- Table structure for table `garage1team_member_job_info`
--

CREATE TABLE `garage1team_member_job_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `date_of_hire` date DEFAULT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  `salary` double NOT NULL DEFAULT '0',
  `salary_term` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `working_hours` int(11) DEFAULT NULL,
  `yearly_leaves` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1team_member_job_info`
--


--
-- Table structure for table `garage1ticket_comments`
--

CREATE TABLE `garage1ticket_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `files` longtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1ticket_comments`
--


--
-- Table structure for table `garage1ticket_types`
--

CREATE TABLE `garage1ticket_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1ticket_types`
--

INSERT INTO `garage1ticket_types` VALUES (1,'General Support',0),(2,'One way',0),(3,'Two way',0);

--
-- Table structure for table `garage1tickets`
--

CREATE TABLE `garage1tickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `ticket_type_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `status` enum('new','client_replied','open','closed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
  `last_activity_at` datetime DEFAULT NULL,
  `assigned_to` int(11) NOT NULL DEFAULT '0',
  `creator_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `creator_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `labels` text COLLATE utf8_unicode_ci,
  `task_id` int(11) NOT NULL,
  `closed_at` datetime NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1tickets`
--


--
-- Table structure for table `garage1to_do`
--

CREATE TABLE `garage1to_do` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `labels` text COLLATE utf8_unicode_ci,
  `status` enum('to_do','done') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'to_do',
  `start_date` date DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1to_do`
--


--
-- Table structure for table `garage1transactions`
--

CREATE TABLE `garage1transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `type` text NOT NULL,
  `is_manual` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `garage1transactions`
--


--
-- Table structure for table `garage1users`
--

CREATE TABLE `garage1users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `user_type` enum('staff','client','lead') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'client',
  `is_admin` tinyint(1) NOT NULL DEFAULT '0',
  `role_id` int(11) NOT NULL DEFAULT '0',
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` text COLLATE utf8_unicode_ci,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `message_checked_at` datetime DEFAULT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `notification_checked_at` datetime DEFAULT NULL,
  `is_primary_contact` tinyint(1) NOT NULL DEFAULT '0',
  `job_title` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Untitled',
  `disable_login` tinyint(1) NOT NULL DEFAULT '0',
  `note` mediumtext COLLATE utf8_unicode_ci,
  `address` text COLLATE utf8_unicode_ci,
  `alternative_address` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alternative_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `ssn` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gender` enum('male','female') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'male',
  `sticky_note` mediumtext COLLATE utf8_unicode_ci,
  `external_links` mediumtext COLLATE utf8_unicode_ci,
  `skype` text COLLATE utf8_unicode_ci,
  `enable_web_notification` tinyint(1) NOT NULL DEFAULT '1',
  `enable_email_notification` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `last_online` datetime DEFAULT NULL,
  `pt_account_id` int(11) NOT NULL DEFAULT '0',
  `sal_account_id` int(11) NOT NULL DEFAULT '0',
  `imb_account_id` int(11) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_type` (`user_type`),
  KEY `email` (`email`),
  KEY `client_id` (`client_id`),
  KEY `deleted` (`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1users`
--


--
-- Table structure for table `garage1vehicles`
--

CREATE TABLE `garage1vehicles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `ac` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'no',
  `rego` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `make` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `model` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `model_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `model_series` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vin` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `engine_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fleet_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `transmission` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `body_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `seating_cap` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `odometer` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hours` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `drive_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `engine_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `chassis_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fuel_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rego_due_date` date DEFAULT NULL,
  `build_date` year(4) DEFAULT NULL COMMENT 'year',
  `produce_date` date DEFAULT NULL,
  `last_in_date` date DEFAULT NULL,
  `last_service` date DEFAULT NULL,
  `next_service` date DEFAULT NULL,
  `next_service_km` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `service_intervals` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cylinders` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `liters` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fuel_induction` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tare_mass` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `radio_pin` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `key_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tyre_size` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `imported_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `blocked` tinyint(1) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4057 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1vehicles`
--


--
-- Table structure for table `garage1work_places`
--

CREATE TABLE `garage1work_places` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage1work_places`
--


--
-- Table structure for table `garage2accounts`
--

CREATE TABLE `garage2accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `acc_name` varchar(255) NOT NULL,
  `acc_code` varchar(255) DEFAULT NULL,
  `acc_parent` int(11) NOT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `garage2accounts`
--

INSERT INTO `garage2accounts` VALUES (1,'Assets','1',0,1,0),(2,'Liabilities','2',0,1,0),(3,'Owner\'s Equity','3',0,1,0),(4,'Expenses','4',0,1,0),(5,'Revenue','5',0,1,0),(6,'Cost of Goods Sold','6',0,1,0),(7,'Current Assets','1-1',1,1,0),(8,'Fixed Assets','1-2',1,1,0),(9,'Current Liabilities','2-1',2,1,0),(10,'Long-term Liabilities','2-2',2,1,0),(11,'Capital','3-1',3,1,0),(12,'Retain Earnings','3-2',3,1,0),(13,'Partners\' Withdrawal','3-3',3,1,0),(14,'Products','5-1-1',47,1,0),(15,'Services','5-1-2',47,1,0),(17,'Discounts','5-1-3',47,1,0),(18,'Banks','1-1-1',7,1,0),(19,'Cash In Hand','1-1-2',7,1,0),(20,'Receivable Accounts','1-1-3',7,1,0),(21,'Receivable Notes','1-1-4',7,1,0),(22,'Other Receivable Accounts','1-1-5',7,1,0),(23,'Employee Petty Cash','1-1-6',7,1,0),(24,'Inventory','1-1-7',7,1,0),(25,'Suppliers','2-1-1',9,1,0),(26,'Salary Payable','2-1-2',9,1,0),(47,'Sales','5-1',5,1,0),(48,'Employee Reimbursement','2-1-3',9,1,0),(52,'Default Bank','123456789',18,1,0),(53,'cheques Payable','2-1-4',9,1,0),(59,'Prepayments','1-1-8',7,1,0),(60,'Advance Payments','2-1-5',9,1,0),(67,'Salaries','4-1',4,1,0);

--
-- Table structure for table `garage2activity_logs`
--

CREATE TABLE `garage2activity_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `action` enum('created','updated','deleted') COLLATE utf8_unicode_ci NOT NULL,
  `log_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `log_type_title` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `log_type_id` int(11) NOT NULL DEFAULT '0',
  `changes` mediumtext COLLATE utf8_unicode_ci,
  `log_for` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `log_for_id` int(11) NOT NULL DEFAULT '0',
  `log_for2` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `log_for_id2` int(11) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2activity_logs`
--


--
-- Table structure for table `garage2announcements`
--

CREATE TABLE `garage2announcements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `share_with` mediumtext COLLATE utf8_unicode_ci,
  `created_at` datetime NOT NULL,
  `files` text COLLATE utf8_unicode_ci NOT NULL,
  `read_by` mediumtext COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2announcements`
--


--
-- Table structure for table `garage2attendance`
--

CREATE TABLE `garage2attendance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` enum('incomplete','pending','approved','rejected','deleted') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'incomplete',
  `user_id` int(11) NOT NULL,
  `in_time` datetime NOT NULL,
  `out_time` datetime DEFAULT NULL,
  `checked_by` int(11) DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `checked_at` datetime DEFAULT NULL,
  `reject_reason` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `checked_by` (`checked_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2attendance`
--


--
-- Table structure for table `garage2brands`
--

CREATE TABLE `garage2brands` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `models` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2brands`
--

INSERT INTO `garage2brands` VALUES (1,'BMW','335I',0),(2,'CADILLAC','ESCALADE',0),(3,'CHEVORLET','SILVERADO 1500,TAHOE,SUBURBAN,AVALANCHE,TRAVERSE,TRAVERSE AWD',0),(4,'CHRYSLER','CHRYSLER 300LX,GRAND VOYAGER,200C',0),(5,'DODGE','DORANGO ,CHARGER ,CALIBER ,RAM ,CHALENGER ,NITRO',0),(6,'FIAT','500',0),(7,'FORD','PICK-UP,DS350 AMBULANCE,F150,EXPEDITION,EXPLORER,RAPTOR,F250 SUPER DUTY,MUSTANG,RANGER,FOCUS,EDGE',0),(8,'GMC','YUKON XL ,SIERRA ,BUS 4X4 ,FIRE ,SIERRA DENALI ,ENVOY ,ACADIA',0),(9,'HUMMER','H2',0),(10,'HYUNDAI','SANTAFE',0),(11,'INFINITY','QX56,QX80',0),(12,'JEEP','CHEROKEE,SAHARA,GRAND CHEROKEE,COMANDER,LIBERTY,PATRIOT,COMPASS,RENEGADE,GRAND CHEROKEE SRT8,WRANGLER YJ,WRANGLER TJ,WRANGLER JK,WRANGLER JL,GLADIATOR',0),(13,'KIA','SOUL ,CERATO ,CARNAVAL',0),(14,'LAND ROVER','110 ,LR3 ,S 2 ,90 ,LR4 ,DISCOVERY',0),(15,'LEXUS','400 ,LX470 ,RX350',0),(16,'MAN','RECOVERI 25T, RECOVERY 1002',0),(17,'MANTRA','MANTRA',0),(18,'MAZDA','PIK UP,BUS,CX5,CX9',0),(19,'MERCEDES','E200,G-CLASS 500',0),(20,'MITSUBISHI','PAJERO,PICK UP,BUS,OUTLANDER',0),(21,'NISSAN','PATROL Y61,SUNNY,INFINITI,XTERRA,BUS,PICK UP,PATROL Y62,ARMADA,SENTRA,PATHFINDER,ALTIMA',0),(22,'PORSCHE','CAYENNE',0),(23,'SUZUKI','JIMMY',0),(24,'TOYOTA','LANDCRUISER,HILUX,FJ CRUISER,BUS COASTER,PRADO,TACOMA PICKUP,DAYNA,COROLA,AVALON,YARIS,EMBULANCE,TUNDRA,FORTUNER,RAV4,LEXUS ES330,LEXUS,CAMRY,ECHO,DAYHASU,SEQUOIA',0),(25,'VOLKSWAGON','TOURAGE',0);

--
-- Table structure for table `garage2checklist_items`
--

CREATE TABLE `garage2checklist_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `is_checked` int(11) NOT NULL DEFAULT '0',
  `task_id` int(11) NOT NULL DEFAULT '0',
  `sort` int(11) NOT NULL DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2checklist_items`
--


--
-- Table structure for table `garage2ci_sessions`
--

CREATE TABLE `garage2ci_sessions` (
  `id` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `data` blob NOT NULL,
  KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2ci_sessions`
--

INSERT INTO `garage2ci_sessions` VALUES ('dcef2e12f326bdb1cfa936fd7320cee12c4afc4e','45.80.151.145',1686829189,_binary '__ci_last_regenerate|i:1686829176;');

--
-- Table structure for table `garage2client_groups`
--

CREATE TABLE `garage2client_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2client_groups`
--

INSERT INTO `garage2client_groups` VALUES (1,'Regular',0),(2,'VIP',0);

--
-- Table structure for table `garage2clients`
--

CREATE TABLE `garage2clients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date NOT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `starred_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `group_ids` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `is_lead` tinyint(1) NOT NULL DEFAULT '0',
  `lead_status_id` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `lead_source_id` int(11) NOT NULL,
  `last_lead_status` text COLLATE utf8_unicode_ci NOT NULL,
  `client_migration_date` date NOT NULL,
  `vat_number` text COLLATE utf8_unicode_ci,
  `currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `disable_online_payment` tinyint(1) NOT NULL DEFAULT '0',
  `geo_location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `advance_account_id` int(11) NOT NULL DEFAULT '0',
  `blocked_sale` tinyint(1) DEFAULT '0',
  `blocked_jobcard` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2clients`
--


--
-- Table structure for table `garage2contacts`
--

CREATE TABLE `garage2contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alternative_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `job_title` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2contacts`
--


--
-- Table structure for table `garage2currencies`
--

CREATE TABLE `garage2currencies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `symbol` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rate` double NOT NULL DEFAULT '1',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2currencies`
--

INSERT INTO `garage2currencies` VALUES (1,'USD','$',2.6,0),(2,'OMR','OMR',1,0);

--
-- Table structure for table `garage2custom_field_values`
--

CREATE TABLE `garage2custom_field_values` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `related_to_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `related_to_id` int(11) NOT NULL,
  `custom_field_id` int(11) NOT NULL,
  `value` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2custom_field_values`
--


--
-- Table structure for table `garage2custom_fields`
--

CREATE TABLE `garage2custom_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `placeholder` text COLLATE utf8_unicode_ci NOT NULL,
  `example_variable_name` text COLLATE utf8_unicode_ci,
  `options` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `field_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `related_to` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_table` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_invoice` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_estimate` tinyint(1) NOT NULL DEFAULT '0',
  `visible_to_admins_only` tinyint(1) NOT NULL DEFAULT '0',
  `hide_from_clients` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2custom_fields`
--

INSERT INTO `garage2custom_fields` VALUES (1,'phone number 2','phone number 2','','','number','clients',1,0,1,0,0,0,0,1),(2,'Primary Complaint','Primary Complaint','','','textarea','projects',1,0,1,0,0,0,1,0);

--
-- Table structure for table `garage2custom_widgets`
--

CREATE TABLE `garage2custom_widgets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci,
  `content` text COLLATE utf8_unicode_ci,
  `show_title` tinyint(1) NOT NULL DEFAULT '0',
  `show_border` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2custom_widgets`
--


--
-- Table structure for table `garage2dashboards`
--

CREATE TABLE `garage2dashboards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci,
  `data` text COLLATE utf8_unicode_ci,
  `color` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2dashboards`
--

INSERT INTO `garage2dashboards` VALUES (2,25,'un paid invoice','a:0:{}','#83c340',0,0),(3,25,'tree','a:0:{}','#2d9cdb',0,0);

--
-- Table structure for table `garage2delivery_note_items`
--

CREATE TABLE `garage2delivery_note_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT '0',
  `invoice_item_id` int(11) DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `quantity` int(11) NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `delivery_note_id` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2delivery_note_items`
--


--
-- Table structure for table `garage2delivery_notes`
--

CREATE TABLE `garage2delivery_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `project_id` int(11) NOT NULL DEFAULT '0',
  `delivery_note_date` date NOT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `status` enum('draft','approved','request_approval') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2delivery_notes`
--


--
-- Table structure for table `garage2email_templates`
--

CREATE TABLE `garage2email_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `email_subject` text COLLATE utf8_unicode_ci NOT NULL,
  `default_message` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `custom_message` mediumtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2email_templates`
--


--
-- Table structure for table `garage2enteries`
--

CREATE TABLE `garage2enteries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trans_id` int(11) NOT NULL,
  `account` int(11) NOT NULL,
  `type` enum('dr','cr') NOT NULL,
  `amount` double NOT NULL,
  `narration` text NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `garage2enteries`
--


--
-- Table structure for table `garage2estimate_forms`
--

CREATE TABLE `garage2estimate_forms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL,
  `assigned_to` int(11) NOT NULL,
  `public` tinyint(1) NOT NULL DEFAULT '0',
  `enable_attachment` tinyint(4) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `garage2estimate_forms`
--


--
-- Table structure for table `garage2estimate_items`
--

CREATE TABLE `garage2estimate_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `work_place` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
