
--
-- Table structure for table `kimai2_timesheet_meta`
--

CREATE TABLE `kimai2_timesheet_meta` (
  `id` int NOT NULL AUTO_INCREMENT,
  `timesheet_id` int NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `visible` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_CB606CBAABDD46BE5E237E06` (`timesheet_id`,`name`),
  KEY `IDX_CB606CBAABDD46BE` (`timesheet_id`),
  CONSTRAINT `FK_CB606CBAABDD46BE` FOREIGN KEY (`timesheet_id`) REFERENCES `kimai2_timesheet` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kimai2_timesheet_meta`
--


--
-- Table structure for table `kimai2_timesheet_tags`
--

CREATE TABLE `kimai2_timesheet_tags` (
  `timesheet_id` int NOT NULL,
  `tag_id` int NOT NULL,
  PRIMARY KEY (`timesheet_id`,`tag_id`),
  KEY `IDX_E3284EFEABDD46BE` (`timesheet_id`),
  KEY `IDX_E3284EFEBAD26311` (`tag_id`),
  CONSTRAINT `FK_732EECA9ABDD46BE` FOREIGN KEY (`timesheet_id`) REFERENCES `kimai2_timesheet` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_732EECA9BAD26311` FOREIGN KEY (`tag_id`) REFERENCES `kimai2_tags` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kimai2_timesheet_tags`
--

INSERT INTO `kimai2_timesheet_tags` VALUES (21,2),(24,1),(25,1),(26,3),(27,4),(28,4),(141,6),(156,6),(165,6),(166,6),(170,6),(176,7),(181,6),(194,6),(199,7),(208,6),(227,6),(230,2),(231,8),(232,8),(234,6),(239,6),(260,6),(263,6),(266,6),(267,7),(288,6),(290,4),(296,4),(307,4),(314,7),(323,9),(331,6),(339,6),(339,7),(353,7),(356,7),(358,7),(360,10),(362,7),(373,6),(380,7),(386,11),(391,7),(400,7),(410,7),(413,7),(424,6),(426,10),(434,19),(456,7),(457,7),(458,7),(464,6),(477,19),(481,7),(483,6),(487,7),(489,7),(494,7),(503,7),(504,7),(521,6),(540,6),(543,6),(560,7),(561,7),(588,7),(594,7),(596,6),(601,7),(602,7),(603,7),(611,6),(612,6),(629,2),(629,6),(632,7),(639,6),(643,7),(647,6),(660,7),(662,7),(663,1),(676,7),(679,4),(679,6),(679,7),(681,7),(697,6),(698,6),(706,1),(724,6),(731,7),(738,7),(749,4),(749,6),(749,7),(765,7),(766,7),(767,7),(770,6),(785,1),(786,1),(797,12),(801,12),(803,6),(817,7),(818,7),(819,7),(820,7),(828,7),(835,7),(836,7),(838,7),(839,7),(848,6),(854,4),(854,6),(854,7),(866,1),(867,1),(869,1),(872,16),(883,7),(887,6),(888,7),(896,7),(908,7),(911,7),(921,13),(923,7),(925,7),(926,7),(927,15),(929,1),(930,1),(931,1),(960,6),(966,7),(982,6),(984,7),(990,13),(991,7),(1004,7),(1006,7),(1021,13),(1022,7),(1048,19),(1053,6),(1075,6),(1075,7),(1077,6),(1081,6),(1086,7),(1087,13),(1105,7),(1106,14),(1110,7),(1124,13),(1126,7),(1127,7),(1128,7),(1130,6),(1131,13),(1132,7),(1137,6),(1159,13),(1160,7),(1162,6),(1166,7),(1205,7),(1208,7),(1212,7),(1213,7),(1217,7),(1218,7),(1221,6),(1236,6),(1236,7),(1237,6),(1252,19),(1257,6),(1263,7),(1264,7),(1270,19),(1275,18),(1281,17),(1296,13),(1297,14),(1298,13),(1299,7),(1307,8),(1312,6),(1333,6),(1339,7),(1340,7),(1363,19),(1364,7),(1365,7),(1366,7),(1370,7),(1371,19),(1372,6),(1386,7),(1387,7),(1388,7),(1389,7),(1400,6),(1402,6),(1402,7),(1403,6),(1403,7),(1410,6),(1415,19),(1418,7),(1435,19),(1447,7),(1451,7),(1452,7),(1454,6),(1459,19),(1468,19),(1484,6),(1490,7),(1511,7),(1514,4),(1514,6),(1514,7),(1542,7),(1549,6),(1549,7),(1556,7),(1571,7),(1577,7),(1578,7),(1589,6),(1589,7),(1614,6),(1638,6),(1674,19),(1682,7),(1683,7),(1689,7),(1694,7),(1703,7),(1709,4),(1709,6),(1709,7),(1723,7),(1751,5),(1752,19),(1753,7),(1755,7),(1756,7),(1757,7),(1763,6),(1791,7),(1794,7),(1808,7),(1824,7),(1825,7),(1885,4),(1885,6),(1885,7),(1886,19),(1902,4),(1902,6),(1902,7),(1902,19),(1991,19),(1993,19),(2009,19),(2010,6),(2010,19),(2011,4),(2022,19),(2038,19),(2143,14),(2144,14),(2145,14),(2146,14),(2147,4),(2148,4),(2149,4),(2150,4),(2151,4),(2152,4),(2187,19),(2193,19),(2243,7),(2269,19),(2288,19),(2327,19),(2357,5),(2361,10),(2362,10),(2363,10),(2365,10),(2376,10),(2415,7),(2427,19),(2451,19),(2468,19),(2482,5),(2497,19),(2504,5),(2536,7),(2539,6),(2540,14),(2541,6),(2542,6),(2544,7),(2647,6),(2648,20),(2649,6),(2651,21),(2652,7),(2673,6),(2699,21),(2723,6),(2725,7),(2739,6),(2748,6),(2888,22),(2889,23),(2921,14),(2936,4),(2937,4),(2938,4),(2940,14),(2941,14),(2943,14),(2945,14),(2973,25),(3009,7),(3010,7),(3011,22),(3013,24),(3014,7),(3026,7),(3034,25),(3038,7),(3047,6),(3052,7),(3066,25),(3084,7),(3088,7),(3088,10),(3094,25),(3143,7),(3148,7),(3161,25),(3190,7),(3199,7),(3208,7),(3218,7),(3219,23),(3221,7),(3229,7),(3230,23),(3231,7),(3239,7),(3247,7),(3249,7),(3249,25),(3270,14),(3273,7),(3273,14),(3280,4),(3281,4),(3295,7),(3312,7),(3334,7),(3335,23),(3336,7),(3338,7),(3373,7),(3376,7),(3398,7),(3400,23),(3401,7),(3407,7),(3416,5),(3417,5),(3418,7),(3423,7),(3426,7),(3453,7),(3459,19),(3467,7),(3477,7),(3487,7),(3497,7),(3502,7),(3504,6),(3505,7),(3505,22),(3506,7),(3507,7),(3508,6),(3509,6),(3510,22),(3512,6),(3513,22),(3514,6),(3515,6),(3515,7),(3516,6),(3517,7),(3518,4),(3518,6),(3518,7),(3519,23),(3520,4),(3520,6),(3520,7),(3522,4),(3522,6),(3522,7),(3545,7),(3556,14),(3559,7),(3560,7),(3580,7),(3629,7),(3629,25),(3647,7),(3649,25),(3653,19),(3688,26),(3695,19),(3700,25),(3729,25),(3748,25),(3753,7),(3777,14),(3823,7),(3840,7),(3854,25),(3875,7),(3875,14),(3875,25),(3881,7),(3890,25),(3959,14),(3961,7),(3985,7),(3985,25),(4004,7),(4005,7),(4084,14),(4085,7),(4086,7),(4090,7),(4091,7),(4106,7),(4122,25),(4141,14),(4142,7),(4150,25),(4166,25),(4171,19),(4191,7),(4223,7),(4234,14),(4235,7),(4250,7),(4263,25),(4267,25),(4300,25),(4306,14),(4308,7),(4311,19),(4326,7),(4330,19),(4345,7),(4358,7),(4359,25),(4399,14),(4400,25),(4422,25),(4432,25),(4441,25),(4459,7),(4476,25),(4480,7),(4483,7),(4490,7),(4499,25),(4511,25),(4525,25),(4549,25),(4553,7),(4570,7),(4571,7),(4576,7),(4583,25),(4613,25),(4616,7),(4640,7),(4641,25),(4648,7),(4652,7),(4658,25),(4659,14),(4660,25),(4663,25),(4676,7),(4690,25),(4713,25),(4719,7),(4723,14),(4745,25),(4746,7),(4805,25),(4812,14),(4813,25),(4848,25),(4856,25),(4866,14),(4868,25),(4872,25),(4874,25),(4906,14),(4907,7),(4911,7),(4923,7),(4940,25),(4942,25),(4978,7),(4980,7),(4989,7),(4999,25),(5019,25),(5022,25),(5047,7),(5052,14),(5055,25),(5079,25),(5094,25),(5128,25),(5159,25),(5182,14),(5183,25),(5191,7),(5195,7),(5219,23),(5238,25),(5255,7),(5292,25),(5315,25),(5321,7),(5325,25),(5383,14),(5384,7),(5413,7),(5430,7),(5474,25),(5478,14),(5479,7),(5487,7),(5522,7),(5557,25),(5562,14),(5563,7),(5579,7),(5587,7),(5592,7),(5596,7),(5627,7),(5629,14),(5633,7),(5644,7),(5650,7),(5662,7),(5701,25),(5710,14),(5711,25),(5744,25),(5772,25),(5796,7),(5806,14),(5807,25),(5845,25),(5888,7),(5889,7),(5894,14),(5924,7),(5932,25),(5987,7),(6001,7),(6015,14),(6016,7),(6017,25),(6078,25),(6089,25),(6126,25),(6163,7),(6164,14),(6166,7),(6188,7),(6247,25),(6275,25),(6339,25),(6373,25),(6377,25),(6403,25),(6414,14),(6415,7),(6416,7),(6420,7),(6492,25),(6519,25),(6555,25),(6580,7),(6582,7),(6609,7),(6618,7),(6643,7),(6650,7),(6667,7),(6730,14),(6732,25),(6741,25),(6756,7),(6772,7),(6779,25),(6792,25),(6864,25),(6866,14),(6867,25),(6877,25),(6881,7),(6910,14),(6912,7),(6936,7),(6944,25),(6957,25),(7008,25),(7029,25),(7058,25),(7064,14),(7068,25),(7086,25),(7101,25),(7102,7),(7117,7),(7117,14),(7117,25),(7129,7),(7134,7),(7151,7),(7160,7),(7160,14),(7160,25),(7205,25),(7209,25),(7224,25),(7226,25),(7244,25),(7266,25),(7286,25),(7354,25),(7386,25),(8077,9),(8077,11),(8101,9),(8101,11),(8119,9),(8119,11),(8170,9),(8170,11),(8183,4),(8196,9),(8196,11),(8231,9),(8231,11),(8233,9),(8233,11),(8293,9),(8293,11),(8341,9),(8341,11),(8358,9),(8358,11),(8421,9),(8421,11),(8498,9),(8498,11),(9061,4),(9062,4),(10939,19),(11780,27),(11781,28),(11782,29),(11783,30),(11784,30),(11788,31),(11796,31),(11912,29),(11917,24),(11924,29),(12004,29),(12009,31),(12009,32),(12021,31),(12021,32),(12044,28),(12046,32),(12056,32),(12063,33),(12065,32),(12090,32),(12107,32),(12111,32),(12128,28),(12132,32),(12141,32),(12159,32),(12167,32),(12171,33),(12172,32),(12181,32),(12198,32),(12207,32),(12223,28),(12228,32),(12238,32),(12240,34),(12241,32),(12241,33),(12254,32),(12292,35),(12293,32),(12315,32),(12340,32),(12358,32),(12379,32),(12380,28),(12394,32),(12404,33),(12454,32),(12474,32),(12484,33),(12565,36),(12567,36),(12645,36),(12646,33),(12714,7),(12746,7),(12870,37),(12918,32),(12919,32),(12998,32),(12999,28),(13181,19),(13181,27),(13191,35),(13210,19),(13210,27),(13218,19),(13218,27),(13239,27),(14460,7),(14473,38),(14487,7),(14488,35),(14510,7),(14511,7),(14520,23),(14522,7),(14526,7),(14588,39),(14589,39),(14591,25),(14611,25),(14639,25),(14643,25),(14684,25),(14699,25),(14728,25),(14749,23),(14755,25),(14762,25),(14774,25),(14795,39),(14796,7),(14798,35),(14806,7),(14808,23),(14818,25),(14854,7),(14855,25),(14869,25),(14879,39),(14880,35),(14887,40),(14888,35),(14904,19),(14909,25),(14910,25),(14923,25),(14929,25),(14930,19),(14938,38),(14957,23),(14960,38),(14961,38),(14967,38),(14986,23),(14987,38),(14995,38),(15011,38),(15017,38),(15025,38),(15026,19),(15030,38),(15037,19),(15055,19),(15057,38),(15090,25),(15091,23),(15092,25),(15096,19),(15101,25),(15116,38),(15117,38),(15118,38),(15121,19),(15140,38),(15146,25),(15152,23),(15153,41),(15156,7),(15157,25),(15159,7),(15162,25),(15168,19),(15175,25),(15188,19),(15202,25),(15208,25),(15226,25),(15245,25),(15266,25),(15284,25),(15322,25),(15342,25),(15351,38),(15357,25),(15359,38),(15380,23),(15386,23),(15388,25),(15397,23),(15411,25),(15420,40),(15425,23),(15429,40),(15431,25),(15441,25),(15443,25),(15457,25),(15486,25),(15501,23),(15508,25),(15546,7),(15548,7),(15560,25),(15572,25),(15597,25),(15604,25),(15608,38),(15611,25),(15630,25),(15647,23),(15650,25),(15655,7),(15661,25),(15671,25),(15691,25),(15697,25),(15705,25),(15732,25),(15749,25),(15763,25),(15774,25),(15781,44),(15808,7),(15830,42),(15869,42),(15895,42),(15917,38),(15918,25),(15946,25),(15965,25),(15975,25),(16029,25),(16074,25),(16107,7),(16113,7),(16115,23),(16119,38),(16163,7),(16214,25),(16218,23),(16225,25),(16241,25),(16242,25),(16275,25),(16315,25),(16327,7),(16334,7),(16369,25),(16370,42),(16381,42),(16423,42),(16425,43),(16463,25),(16479,25),(16482,38),(16493,25),(16512,23),(16528,25),(16534,23),(16541,25),(16645,45),(16650,25),(16667,25),(16695,25),(16699,45),(16709,25),(16724,42),(16761,45),(16763,43),(16787,7),(16789,7),(16802,25),(16808,45),(16819,23),(16819,27),(16823,25),(16831,38),(16859,45),(16864,23),(16865,38),(16884,45),(16887,7),(16894,7),(16919,38),(16927,38),(16944,45),(16946,38),(16964,7),(16967,25),(16982,45),(16984,25),(16993,38),(17000,25),(17029,46),(17049,25),(17052,46),(17057,45),(17069,40),(17075,21),(17077,46),(17078,25),(17079,38),(17088,46),(17089,25),(17092,45),(17100,40),(17104,25),(17113,40),(17115,25),(17123,46),(17196,46),(17201,23),(17203,38),(17208,38),(17284,46),(17313,46),(17324,46),(17380,38),(17387,46),(17393,7),(17399,7),(17408,46),(17409,25),(17413,46),(17418,25),(17421,38),(17422,38),(17435,38),(17437,46),(17442,46),(17444,25),(17448,46),(17480,46),(17482,23),(17485,23),(17506,25),(17507,38),(17510,38),(17512,46),(17522,25),(17526,46),(17543,43),(17551,25),(17552,25),(17554,38),(17556,45),(17563,25),(17568,25),(17585,25),(17597,45),(17601,46),(17603,38),(17610,25),(17621,25),(17634,46),(17648,25),(17674,40),(17677,25),(17727,46),(17737,25),(17738,38),(17757,38),(17758,46),(17771,38),(17772,42),(17776,38),(17777,23),(17785,38),(17794,38),(17796,25),(17800,36),(17812,42),(17814,46),(17816,23),(17823,42),(17840,38),(17841,42),(17847,46),(17853,46),(17866,46),(17878,46),(17888,46),(17891,46),(17892,47),(17893,46),(17894,47),(17897,46),(17898,46),(17900,47),(17941,23),(17948,46),(17957,23),(17959,38),(17970,45),(17985,46),(17990,25),(17991,45),(18006,40),(18007,42),(18011,46),(18018,25),(18021,42),(18023,40),(18039,46),(18045,46),(18061,23),(18062,46),(18079,25),(18095,38),(18101,25),(18108,46),(18109,46),(18117,48),(18124,25),(18126,46),(18154,41),(18157,44),(18158,25),(18161,48),(18165,25),(18182,38),(18193,46),(18211,25),(18218,23),(18228,25),(18237,46),(18256,7),(18263,7),(18280,38),(18285,45),(18289,46),(18291,23),(18303,38),(18318,46),(18319,46),(18321,38),(18323,46),(18335,45),(18342,49),(18345,25),(18349,7),(18353,25),(18366,46),(18386,23),(18407,45),(18410,46),(18426,38),(18434,46),(18450,46),(18455,38),(18475,46),(18482,23),(18483,45),(18484,45),(18485,23),(18503,45),(18507,23),(18549,46),(18551,46),(18552,46),(18555,46),(18556,46),(18557,44),(18558,46),(18569,23),(18584,45),(18588,46),(18594,46),(18596,44),(18628,46),(18631,46),(18632,46),(18639,45),(18666,46),(18683,46),(18716,38),(18718,46),(18738,38),(18744,38),(18748,46),(18758,38),(18801,23),(18802,38),(18816,46),(18817,38),(18831,46),(18853,46),(18866,25),(18881,23),(18884,25),(18886,46),(18944,25),(18946,46),(18981,46),(18982,25),(19034,46),(19035,46),(19037,46),(19056,45),(19057,38),(19061,46),(19090,25),(19097,25),(19099,46),(19104,45),(19112,38),(19115,46),(19116,46),(19128,45),(19143,46),(19167,46),(19169,45),(19191,20),(19224,45),(19228,41),(19231,46),(19234,23),(19235,23),(19248,41),(19259,25),(19272,25),(19273,46),(19275,45),(19283,7),(19289,38),(19291,25),(19296,46),(19297,46),(19298,46),(19299,46),(19312,45),(19313,46),(19317,23),(19318,25),(19347,46),(19348,45),(19350,25),(19373,25),(19394,45),(19401,23),(19404,25),(19406,46),(19414,40),(19426,25),(19447,25),(19451,25),(19459,46),(19473,45),(19478,41),(19479,40),(19484,25),(19500,25),(19501,25),(19512,46),(19576,46),(19579,23),(19581,25),(19587,45),(19610,46),(19613,25),(19621,45),(19658,46),(19695,45),(19702,46),(19703,46),(19742,45),(19747,46),(19757,50),(19758,50),(19767,38),(19769,38),(19770,43),(19771,38),(19786,50),(19797,45),(19799,23),(19800,50),(19804,46),(19806,38),(19821,23),(19824,25),(19833,46),(19834,43),(19837,38),(19839,45),(19842,40),(19845,7),(19859,50),(19868,50),(19886,45),(19890,50),(19897,46),(19900,23),(19904,25),(19917,40),(19922,25),(19926,46),(19929,45),(19936,50),(19937,50),(19947,46),(19948,46),(19953,46),(19954,25),(19957,46),(19959,46),(19980,45),(19988,46),(20001,23),(20002,25),(20017,25),(20019,45),(20021,25),(20024,46),(20041,21),(20042,25),(20044,46),(20048,25),(20116,25),(20125,46),(20132,25),(20138,25),(20139,25),(20140,46),(20169,46),(20174,38),(20175,38),(20179,25),(20180,45),(20187,46),(20195,25),(20213,50),(20219,46),(20221,45),(20228,25),(20243,23),(20246,46),(20253,25),(20277,45),(20278,25),(20282,23),(20285,46),(20298,25),(20321,7),(20326,35),(20330,7),(20333,46),(20338,7),(20340,45),(20342,25),(20352,50),(20353,38),(20362,25),(20374,46),(20375,46),(20390,45),(20394,46),(20396,23),(20397,38),(20402,50),(20408,38),(20428,7),(20429,46),(20431,45),(20432,50),(20436,7),(20452,38),(20453,38),(20460,38),(20462,7),(20467,46),(20468,46),(20470,46),(20478,38),(20480,45),(20481,7),(20484,46),(20485,50),(20496,40),(20508,38),(20509,38),(20517,46),(20523,45),(20525,50),(20526,19),(20527,38),(20544,38),(20608,46),(20609,23),(20610,50),(20622,7),(20631,7),(20633,7),(20643,46),(20645,50),(20655,7),(20666,7),(20671,46),(20672,46),(20697,46),(20698,46),(20699,46),(20700,46),(20701,46),(20702,46),(20703,46),(20704,46),(20705,46),(20706,36),(20708,46),(20709,46),(20710,46),(20763,50),(20801,45),(20808,50),(20847,50),(20851,46),(20852,46),(20854,45),(20857,46),(20873,50),(20891,46),(20894,50),(20895,50),(20896,50),(20897,50),(20898,45),(20928,46),(20930,46),(20947,45),(20950,23),(20953,46),(20957,50),(20962,23),(20968,41),(20971,38),(20973,46),(20979,38),(20982,46),(20983,50),(20990,45),(20995,38),(20996,38),(20998,50),(21000,38),(21018,46),(21022,25),(21023,50),(21041,25),(21042,46),(21043,46),(21055,50),(21069,46),(21070,25),(21076,23),(21077,25),(21083,25),(21101,50),(21103,46),(21104,23),(21105,38),(21117,38),(21120,38),(21125,38),(21131,50),(21132,46),(21141,23),(21149,38),(21154,46),(21171,46),(21180,50),(21185,23),(21186,38),(21187,49),(21189,38),(21194,38),(21198,46),(21206,50),(21213,49),(21219,38),(21232,45),(21237,50),(21240,23),(21242,38),(21244,46),(21272,46),(21278,50),(21279,45),(21281,38),(21282,38),(21294,48),(21298,38),(21299,46),(21300,46),(21302,38),(21303,38);

--
-- Table structure for table `kimai2_user_preferences`
--

CREATE TABLE `kimai2_user_preferences` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_8D08F631A76ED3955E237E06` (`user_id`,`name`),
  KEY `IDX_8D08F631A76ED395` (`user_id`),
  CONSTRAINT `FK_8D08F631A76ED395` FOREIGN KEY (`user_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=884 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kimai2_user_preferences`
--

INSERT INTO `kimai2_user_preferences` VALUES (14,2,'timezone','Asia/Kolkata'),(15,2,'language','en_IN'),(16,2,'hourly_rate','0'),(17,2,'internal_rate',NULL),(18,2,'first_weekday','monday'),(19,2,'skin','default'),(20,2,'update_browser_title','1'),(21,2,'calendar_initial_view','month'),(22,2,'login_initial_view','timesheet'),(23,2,'favorite_routes',''),(24,2,'daily_stats',''),(25,2,'export_decimal',''),(26,2,'__wizards__','intro,profile'),(27,3,'timezone','Asia/Kolkata'),(28,3,'language','en_US'),(29,4,'timezone','Asia/Kolkata'),(30,4,'language','en_IN'),(31,5,'timezone','Asia/Kolkata'),(32,5,'language','en_IN'),(33,6,'timezone','Asia/Kolkata'),(34,6,'language','en_IN'),(35,7,'timezone','Asia/Kolkata'),(36,7,'language','en_IN'),(37,8,'timezone','Asia/Kolkata'),(38,8,'language','en_GB'),(39,9,'timezone','Asia/Kolkata'),(40,9,'language','en_IN'),(41,10,'timezone','Asia/Kolkata'),(42,10,'language','en_US'),(43,11,'timezone','Asia/Kolkata'),(44,11,'language','en_IN'),(45,12,'timezone','Asia/Kolkata'),(46,12,'language','en_GB'),(47,13,'timezone','Asia/Kolkata'),(48,13,'language','en_GB'),(49,14,'timezone','Asia/Dili'),(50,14,'language','en_IN'),(51,15,'timezone','Asia/Kolkata'),(52,15,'language','en_IN'),(53,16,'timezone','Asia/Kolkata'),(54,16,'language','en_IN'),(57,18,'timezone','Asia/Kolkata'),(58,18,'language','en_US'),(59,19,'timezone','Asia/Kolkata'),(60,19,'language','en'),(61,20,'timezone','Asia/Kolkata'),(62,20,'language','en_GB'),(65,22,'timezone','Asia/Kolkata'),(66,22,'language','en_GB'),(67,23,'timezone','Asia/Kolkata'),(68,23,'language','en_GB'),(69,24,'timezone','Asia/Kolkata'),(70,24,'language','en_IN'),(71,25,'timezone','Asia/Kolkata'),(72,25,'language','en_US'),(73,26,'timezone','Asia/Kolkata'),(74,26,'language','en_IN'),(75,27,'timezone','Asia/Kolkata'),(76,27,'language','en_GB'),(77,28,'timezone','Asia/Kolkata'),(78,28,'language','en'),(81,30,'timezone','Asia/Kolkata'),(82,30,'language','en_US'),(83,31,'timezone','Asia/Kolkata'),(84,31,'language','en_US'),(87,6,'hourly_rate','0'),(88,6,'internal_rate','271.88'),(89,6,'first_weekday','monday'),(90,6,'skin','default'),(91,6,'update_browser_title','1'),(92,6,'calendar_initial_view','month'),(93,6,'login_initial_view','timesheet'),(94,6,'favorite_routes',''),(95,6,'daily_stats',''),(96,6,'export_decimal',''),(97,6,'__wizards__','intro,profile'),(100,24,'hourly_rate','0'),(101,24,'internal_rate','143.75'),(102,24,'first_weekday','monday'),(103,24,'skin','default'),(104,24,'update_browser_title','1'),(105,24,'calendar_initial_view','month'),(106,24,'login_initial_view','timesheet'),(107,24,'favorite_routes',''),(108,24,'daily_stats',''),(109,24,'export_decimal',''),(110,34,'timezone','Asia/Kolkata'),(111,34,'language','en_US'),(112,35,'timezone','Asia/Kolkata'),(113,35,'language','en_GB'),(114,36,'timezone','Asia/Kolkata'),(115,36,'language','en_US'),(116,37,'timezone','Asia/Kolkata'),(117,37,'language','en_US'),(118,38,'timezone','Asia/Kolkata'),(119,38,'language','en_GB'),(120,39,'timezone','Asia/Kolkata'),(121,39,'language','en_US'),(122,40,'timezone','Asia/Kolkata'),(123,40,'language','en_IN'),(124,41,'timezone','Asia/Kolkata'),(125,41,'language','en_IN'),(126,42,'timezone','Asia/Kolkata'),(127,42,'language','en_IN'),(138,16,'hourly_rate','0'),(139,16,'internal_rate','182.5'),(140,16,'first_weekday','monday'),(141,16,'skin','default'),(142,16,'update_browser_title','1'),(143,16,'calendar_initial_view','month'),(144,16,'login_initial_view','timesheet'),(145,16,'favorite_routes',''),(146,16,'daily_stats',''),(147,16,'export_decimal',''),(148,31,'hourly_rate','0'),(149,31,'internal_rate','207.5'),(150,31,'first_weekday','monday'),(151,31,'skin','default'),(152,31,'update_browser_title','1'),(153,31,'calendar_initial_view','month'),(154,31,'login_initial_view','timesheet'),(155,31,'favorite_routes',''),(156,31,'daily_stats',''),(157,31,'export_decimal',''),(158,11,'hourly_rate','0'),(159,11,'internal_rate','656.25'),(160,11,'first_weekday','monday'),(161,11,'skin','default'),(162,11,'update_browser_title','1'),(163,11,'calendar_initial_view','month'),(164,11,'login_initial_view','timesheet'),(165,11,'favorite_routes',''),(166,11,'daily_stats',''),(167,11,'export_decimal',''),(168,34,'hourly_rate','0'),(169,34,'internal_rate','62.5'),(170,34,'first_weekday','monday'),(171,34,'skin','default'),(172,34,'update_browser_title','1'),(173,34,'calendar_initial_view','month'),(174,34,'login_initial_view','timesheet'),(175,34,'favorite_routes',''),(176,34,'daily_stats',''),(177,34,'export_decimal',''),(178,3,'hourly_rate','0'),(179,3,'internal_rate','1093.75'),(180,3,'first_weekday','monday'),(181,3,'skin','default'),(182,3,'update_browser_title','1'),(183,3,'calendar_initial_view','month'),(184,3,'login_initial_view','timesheet'),(185,3,'favorite_routes',''),(186,3,'daily_stats',''),(187,3,'export_decimal',''),(188,25,'hourly_rate','0'),(189,25,'internal_rate','250'),(190,25,'first_weekday','monday'),(191,25,'skin','default'),(192,25,'update_browser_title','1'),(193,25,'calendar_initial_view','month'),(194,25,'login_initial_view','timesheet'),(195,25,'favorite_routes',''),(196,25,'daily_stats',''),(197,25,'export_decimal',''),(198,39,'hourly_rate','0'),(199,39,'internal_rate','132.5'),(200,39,'first_weekday','monday'),(201,39,'skin','dark'),(202,39,'update_browser_title','1'),(203,39,'calendar_initial_view','month'),(204,39,'login_initial_view','timesheet'),(205,39,'favorite_routes',''),(206,39,'daily_stats',''),(207,39,'export_decimal',''),(208,10,'hourly_rate','0'),(209,10,'internal_rate','437.5'),(210,10,'first_weekday','monday'),(211,10,'skin','default'),(212,10,'update_browser_title','1'),(213,10,'calendar_initial_view','month'),(214,10,'login_initial_view','timesheet'),(215,10,'favorite_routes',''),(216,10,'daily_stats',''),(217,10,'export_decimal',''),(218,22,'hourly_rate','0'),(219,22,'internal_rate','220'),(220,22,'first_weekday','monday'),(221,22,'skin','default'),(222,22,'update_browser_title','1'),(223,22,'calendar_initial_view','month'),(224,22,'login_initial_view','timesheet'),(225,22,'favorite_routes','timesheet'),(226,22,'daily_stats',''),(227,22,'export_decimal',''),(228,16,'__wizards__','intro,profile'),(229,7,'hourly_rate','0'),(230,7,'internal_rate','588.75'),(231,7,'first_weekday','monday'),(232,7,'skin','default'),(233,7,'update_browser_title','1'),(234,7,'calendar_initial_view','month'),(235,7,'login_initial_view','timesheet'),(236,7,'favorite_routes',''),(237,7,'daily_stats',''),(238,7,'export_decimal',''),(239,7,'__wizards__','intro,profile'),(240,28,'hourly_rate','0'),(241,28,'internal_rate','145'),(242,28,'first_weekday','monday'),(243,28,'skin','dark'),(244,28,'update_browser_title','1'),(245,28,'calendar_initial_view','month'),(246,28,'login_initial_view','timesheet'),(247,28,'favorite_routes',''),(248,28,'daily_stats',''),(249,28,'export_decimal',''),(250,18,'hourly_rate','0'),(251,18,'internal_rate','288.75'),(252,18,'first_weekday','monday'),(253,18,'skin','default'),(254,18,'update_browser_title','1'),(255,18,'calendar_initial_view','month'),(256,18,'login_initial_view','timesheet'),(257,18,'favorite_routes',''),(258,18,'daily_stats',''),(259,18,'export_decimal',''),(260,23,'hourly_rate','0'),(261,23,'internal_rate','137.5'),(262,23,'first_weekday','monday'),(263,23,'skin','default'),(264,23,'update_browser_title','1'),(265,23,'calendar_initial_view','month'),(266,23,'login_initial_view','timesheet'),(267,23,'favorite_routes',''),(268,23,'daily_stats',''),(269,23,'export_decimal',''),(270,36,'hourly_rate','0'),(271,36,'internal_rate','87.5'),(272,36,'first_weekday','monday'),(273,36,'skin','dark'),(274,36,'update_browser_title','1'),(275,36,'calendar_initial_view','month'),(276,36,'login_initial_view','timesheet'),(277,36,'favorite_routes',''),(278,36,'daily_stats',''),(279,36,'export_decimal',''),(280,35,'hourly_rate','0'),(281,35,'internal_rate','200'),(282,35,'first_weekday','monday'),(283,35,'skin','default'),(284,35,'update_browser_title','1'),(285,35,'calendar_initial_view','month'),(286,35,'login_initial_view','timesheet'),(287,35,'favorite_routes',''),(288,35,'daily_stats',''),(289,35,'export_decimal',''),(290,38,'hourly_rate','0'),(291,38,'internal_rate','218.75'),(292,38,'first_weekday','monday'),(293,38,'skin','default'),(294,38,'update_browser_title','1'),(295,38,'calendar_initial_view','month'),(296,38,'login_initial_view','timesheet'),(297,38,'favorite_routes',''),(298,38,'daily_stats',''),(299,38,'export_decimal',''),(300,13,'hourly_rate','0'),(301,13,'internal_rate','781.25'),(302,13,'first_weekday','monday'),(303,13,'skin','default'),(304,13,'update_browser_title','1'),(305,13,'calendar_initial_view','month'),(306,13,'login_initial_view','timesheet'),(307,13,'favorite_routes',''),(308,13,'daily_stats','1'),(309,13,'export_decimal',''),(310,27,'hourly_rate','0'),(311,27,'internal_rate','426.25'),(312,27,'first_weekday','monday'),(313,27,'skin','dark'),(314,27,'update_browser_title','1'),(315,27,'calendar_initial_view','month'),(316,27,'login_initial_view','timesheet'),(317,27,'favorite_routes',''),(318,27,'daily_stats',''),(319,27,'export_decimal',''),(320,40,'hourly_rate','0'),(321,40,'internal_rate','125'),(322,40,'first_weekday','monday'),(323,40,'skin','default'),(324,40,'update_browser_title','1'),(325,40,'calendar_initial_view','month'),(326,40,'login_initial_view','timesheet'),(327,40,'favorite_routes',''),(328,40,'daily_stats',''),(329,40,'export_decimal',''),(330,37,'hourly_rate','0'),(331,37,'internal_rate','95'),(332,37,'first_weekday','monday'),(333,37,'skin','default'),(334,37,'update_browser_title','1'),(335,37,'calendar_initial_view','month'),(336,37,'login_initial_view','timesheet'),(337,37,'favorite_routes',''),(338,37,'daily_stats',''),(339,37,'export_decimal',''),(340,5,'hourly_rate','0'),(341,5,'internal_rate','234.38'),(342,5,'first_weekday','monday'),(343,5,'skin','default'),(344,5,'update_browser_title','1'),(345,5,'calendar_initial_view','month'),(346,5,'login_initial_view','timesheet'),(347,5,'favorite_routes',''),(348,5,'daily_stats',''),(349,5,'export_decimal',''),(360,4,'hourly_rate','0'),(361,4,'internal_rate','406.25'),(362,4,'first_weekday','monday'),(363,4,'skin','default'),(364,4,'update_browser_title','1'),(365,4,'calendar_initial_view','month'),(366,4,'login_initial_view','timesheet'),(367,4,'favorite_routes',''),(368,4,'daily_stats',''),(369,4,'export_decimal',''),(370,20,'hourly_rate','0'),(371,20,'internal_rate','313.75'),(372,20,'first_weekday','monday'),(373,20,'skin','default'),(374,20,'update_browser_title','1'),(375,20,'calendar_initial_view','month'),(376,20,'login_initial_view','timesheet'),(377,20,'favorite_routes',''),(378,20,'daily_stats',''),(379,20,'export_decimal',''),(380,9,'hourly_rate','0'),(381,9,'internal_rate','666.66'),(382,9,'first_weekday','monday'),(383,9,'skin','dark'),(384,9,'update_browser_title','1'),(385,9,'calendar_initial_view','month'),(386,9,'login_initial_view','timesheet'),(387,9,'favorite_routes',''),(388,9,'daily_stats','1'),(389,9,'export_decimal',''),(390,15,'hourly_rate','800'),(391,15,'internal_rate','200'),(392,15,'first_weekday','monday'),(393,15,'skin','default'),(394,15,'update_browser_title','1'),(395,15,'calendar_initial_view','month'),(396,15,'login_initial_view','timesheet'),(397,15,'favorite_routes',''),(398,15,'daily_stats',''),(399,15,'export_decimal',''),(400,12,'hourly_rate','0'),(401,12,'internal_rate','513.75'),(402,12,'first_weekday','monday'),(403,12,'skin','dark'),(404,12,'update_browser_title','1'),(405,12,'calendar_initial_view','month'),(406,12,'login_initial_view','timesheet'),(407,12,'favorite_routes',''),(408,12,'daily_stats',''),(409,12,'export_decimal',''),(410,8,'hourly_rate','0'),(411,8,'internal_rate','606.25'),(412,8,'first_weekday','monday'),(413,8,'skin','default'),(414,8,'update_browser_title','1'),(415,8,'calendar_initial_view','month'),(416,8,'login_initial_view','timesheet'),(417,8,'favorite_routes',''),(418,8,'daily_stats',''),(419,8,'export_decimal',''),(420,41,'hourly_rate','0'),(421,41,'internal_rate','31.25'),(422,41,'first_weekday','monday'),(423,41,'skin','default'),(424,41,'update_browser_title','1'),(425,41,'calendar_initial_view','month'),(426,41,'login_initial_view','timesheet'),(427,41,'favorite_routes',''),(428,41,'daily_stats',''),(429,41,'export_decimal',''),(430,14,'hourly_rate','0'),(431,14,'internal_rate','407.5'),(432,14,'first_weekday','monday'),(433,14,'skin','default'),(434,14,'update_browser_title','1'),(435,14,'calendar_initial_view','month'),(436,14,'login_initial_view','timesheet'),(437,14,'favorite_routes',''),(438,14,'daily_stats',''),(439,14,'export_decimal',''),(440,19,'hourly_rate','0'),(441,19,'internal_rate','325'),(442,19,'first_weekday','monday'),(443,19,'skin','default'),(444,19,'update_browser_title','1'),(445,19,'calendar_initial_view','month'),(446,19,'login_initial_view','timesheet'),(447,19,'favorite_routes',''),(448,19,'daily_stats',''),(449,19,'export_decimal',''),(460,26,'hourly_rate','0'),(461,26,'internal_rate','250'),(462,26,'first_weekday','monday'),(463,26,'skin','default'),(464,26,'update_browser_title','1'),(465,26,'calendar_initial_view','month'),(466,26,'login_initial_view','timesheet'),(467,26,'favorite_routes',''),(468,26,'daily_stats',''),(469,26,'export_decimal',''),(470,30,'hourly_rate','0'),(471,30,'internal_rate','76.25'),(472,30,'first_weekday','monday'),(473,30,'skin','default'),(474,30,'update_browser_title','1'),(475,30,'calendar_initial_view','month'),(476,30,'login_initial_view','timesheet'),(477,30,'favorite_routes',''),(478,30,'daily_stats',''),(479,30,'export_decimal',''),(480,4,'__wizards__','intro,profile'),(481,13,'__wizards__','intro,profile'),(482,42,'hourly_rate','0'),(483,42,'internal_rate',NULL),(484,42,'first_weekday','monday'),(485,42,'skin','default'),(486,42,'update_browser_title','1'),(487,42,'calendar_initial_view','month'),(488,42,'login_initial_view','timesheet'),(489,42,'favorite_routes',''),(490,42,'daily_stats',''),(491,42,'export_decimal',''),(492,42,'__wizards__','intro,profile'),(493,11,'__wizards__','intro,profile'),(494,9,'__wizards__','intro,profile'),(495,14,'__wizards__','intro,profile'),(496,12,'__wizards__','intro,profile'),(497,22,'__wizards__','intro,profile'),(498,20,'__wizards__','intro,profile'),(499,5,'__wizards__','intro,profile'),(500,30,'__wizards__','intro,profile'),(501,27,'__wizards__','intro,profile'),(502,35,'__wizards__','intro,profile'),(503,18,'__wizards__','intro,profile'),(504,43,'timezone','Asia/Kolkata'),(505,43,'language','en_GB'),(507,43,'hourly_rate','0'),(508,43,'internal_rate',NULL),(509,43,'first_weekday','monday'),(510,43,'skin','default'),(511,43,'update_browser_title','1'),(512,43,'calendar_initial_view','month'),(513,43,'login_initial_view','timesheet'),(514,43,'favorite_routes',''),(515,43,'daily_stats',''),(516,43,'export_decimal',''),(517,43,'__wizards__','intro,profile'),(518,15,'__wizards__','intro,profile'),(519,24,'__wizards__','intro,profile'),(521,44,'timezone','UTC'),(522,44,'language','en_US'),(523,45,'timezone','Asia/Kolkata'),(524,45,'language','en_US'),(525,46,'timezone','Asia/Kolkata'),(526,46,'language','en_IN'),(527,47,'timezone','Asia/Kolkata'),(528,47,'language','en_US'),(529,25,'__wizards__','intro,profile'),(530,10,'__wizards__','intro,profile'),(531,19,'__wizards__','intro,profile'),(532,44,'hourly_rate','0'),(533,44,'internal_rate',NULL),(534,44,'first_weekday','monday'),(535,44,'skin','dark'),(536,44,'update_browser_title','1'),(537,44,'calendar_initial_view','month'),(538,44,'login_initial_view','timesheet'),(539,44,'favorite_routes',''),(540,44,'daily_stats',''),(541,44,'export_decimal',''),(542,44,'__wizards__','intro,profile'),(544,39,'__wizards__','intro,profile'),(545,38,'__wizards__','intro,profile'),(546,28,'__wizards__','intro,profile'),(547,48,'timezone','Asia/Kolkata'),(548,48,'language','en_GB'),(549,48,'hourly_rate','0'),(550,48,'internal_rate','382.5'),(551,48,'first_weekday','monday'),(552,48,'skin','default'),(553,48,'update_browser_title','1'),(554,48,'calendar_initial_view','month'),(555,48,'login_initial_view','timesheet'),(556,48,'favorite_routes',''),(557,48,'daily_stats',''),(558,48,'export_decimal',''),(559,48,'__wizards__','intro,profile'),(560,23,'__wizards__','intro,profile'),(561,31,'__wizards__','intro,profile'),(562,45,'hourly_rate','0'),(563,45,'internal_rate','50'),(564,45,'first_weekday','monday'),(565,45,'skin','default'),(566,45,'update_browser_title','1'),(567,45,'calendar_initial_view','month'),(568,45,'login_initial_view','timesheet'),(569,45,'favorite_routes',''),(570,45,'daily_stats',''),(571,45,'export_decimal',''),(572,45,'__wizards__','intro,profile'),(573,47,'hourly_rate','0'),(574,47,'internal_rate',NULL),(575,47,'first_weekday','monday'),(576,47,'skin','default'),(577,47,'update_browser_title','1'),(578,47,'calendar_initial_view','month'),(579,47,'login_initial_view','timesheet'),(580,47,'favorite_routes',''),(581,47,'daily_stats',''),(582,47,'export_decimal',''),(583,47,'__wizards__','intro,profile'),(584,36,'__wizards__','intro,profile'),(585,34,'__wizards__','intro,profile'),(586,37,'__wizards__','intro,profile'),(587,46,'hourly_rate','0'),(588,46,'internal_rate','75'),(589,46,'first_weekday','monday'),(590,46,'skin','default'),(591,46,'update_browser_title','1'),(592,46,'calendar_initial_view','month'),(593,46,'login_initial_view','timesheet'),(594,46,'favorite_routes',''),(595,46,'daily_stats',''),(596,46,'export_decimal',''),(597,46,'__wizards__','intro,profile'),(598,3,'__wizards__','intro,profile'),(599,49,'timezone','Asia/Kolkata'),(600,49,'language','en_IN'),(601,49,'hourly_rate','0'),(602,49,'internal_rate',NULL),(603,49,'first_weekday','monday'),(604,49,'skin','default'),(605,49,'update_browser_title','1'),(606,49,'calendar_initial_view','month'),(607,49,'login_initial_view','timesheet'),(608,49,'favorite_routes',''),(609,49,'daily_stats',''),(610,49,'export_decimal',''),(611,49,'__wizards__','intro,profile'),(612,8,'__wizards__','intro,profile'),(613,50,'timezone','Asia/Kolkata'),(614,50,'language','en_IN'),(615,50,'hourly_rate','0'),(616,50,'internal_rate',NULL),(617,50,'first_weekday','monday'),(618,50,'skin','default'),(619,50,'update_browser_title','1'),(620,50,'calendar_initial_view','month'),(621,50,'login_initial_view','timesheet'),(622,50,'favorite_routes',''),(623,50,'daily_stats',''),(624,50,'export_decimal',''),(625,50,'__wizards__','intro,profile'),(626,51,'timezone','Asia/Kolkata'),(627,51,'language','en_US'),(628,51,'hourly_rate','0'),(629,51,'internal_rate',NULL),(630,51,'first_weekday','monday'),(631,51,'skin','default'),(632,51,'update_browser_title','1'),(633,51,'calendar_initial_view','month'),(634,51,'login_initial_view','timesheet'),(635,51,'favorite_routes',''),(636,51,'daily_stats',''),(637,51,'export_decimal',''),(638,51,'__wizards__','intro,profile'),(639,52,'timezone','Asia/Kolkata'),(640,52,'language','en_GB'),(641,52,'__pw_reset__','0'),(642,52,'hourly_rate','0'),(643,52,'internal_rate','137.5'),(644,52,'first_weekday','monday'),(645,52,'skin','default'),(646,52,'update_browser_title','1'),(647,52,'calendar_initial_view','month'),(648,52,'login_initial_view','timesheet'),(649,52,'favorite_routes',''),(650,52,'daily_stats',''),(651,52,'export_decimal',''),(652,52,'__wizards__','intro,profile'),(653,53,'timezone','Asia/Kolkata'),(654,53,'language','en_GB'),(655,53,'hourly_rate','0'),(656,53,'internal_rate',NULL),(657,53,'first_weekday','monday'),(658,53,'skin','default'),(659,53,'update_browser_title','1'),(660,53,'calendar_initial_view','month'),(661,53,'login_initial_view','timesheet'),(662,53,'favorite_routes',''),(663,53,'daily_stats',''),(664,53,'export_decimal',''),(665,53,'__wizards__','intro,profile'),(666,54,'timezone','Asia/Kolkata'),(667,54,'language','en_US'),(668,54,'hourly_rate','0'),(669,54,'internal_rate',NULL),(670,54,'first_weekday','monday'),(671,54,'skin','default'),(672,54,'update_browser_title','1'),(673,54,'calendar_initial_view','month'),(674,54,'login_initial_view','timesheet'),(675,54,'favorite_routes',''),(676,54,'daily_stats',''),(677,54,'export_decimal',''),(678,54,'__wizards__','intro,profile'),(679,40,'__wizards__','intro,profile'),(680,55,'timezone','Asia/Kolkata'),(681,55,'language','en_US'),(682,55,'__pw_reset__','0'),(683,55,'hourly_rate','0'),(684,55,'internal_rate',NULL),(685,55,'first_weekday','monday'),(686,55,'skin','default'),(687,55,'update_browser_title','1'),(688,55,'calendar_initial_view','month'),(689,55,'login_initial_view','timesheet'),(690,55,'favorite_routes',''),(691,55,'daily_stats',''),(692,55,'export_decimal',''),(693,55,'__wizards__','intro,profile'),(694,56,'timezone','Asia/Kolkata'),(695,56,'language','en_US'),(696,56,'__pw_reset__','0'),(697,26,'__wizards__','intro,profile'),(698,57,'timezone','Asia/Kolkata'),(699,57,'language','en_IN'),(700,57,'hourly_rate','0'),(701,57,'internal_rate',NULL),(702,57,'first_weekday','monday'),(703,57,'skin','default'),(704,57,'update_browser_title','1'),(705,57,'calendar_initial_view','month'),(706,57,'login_initial_view','timesheet'),(707,57,'favorite_routes',''),(708,57,'daily_stats',''),(709,57,'export_decimal',''),(710,57,'__wizards__','intro,profile'),(711,41,'__wizards__','intro,profile'),(712,58,'timezone','Asia/Kolkata'),(713,58,'language','en_IN'),(714,58,'hourly_rate','0'),(715,58,'internal_rate',NULL),(716,58,'first_weekday','monday'),(717,58,'skin','default'),(718,58,'update_browser_title','1'),(719,58,'calendar_initial_view','month'),(720,58,'login_initial_view','timesheet'),(721,58,'favorite_routes',''),(722,58,'daily_stats',''),(723,58,'export_decimal',''),(724,58,'__wizards__','intro,profile'),(725,59,'timezone','Asia/Kolkata'),(726,59,'language','en_US'),(727,59,'hourly_rate','0'),(728,59,'internal_rate',NULL),(729,59,'first_weekday','monday'),(730,59,'skin','default'),(731,59,'update_browser_title','1'),(732,59,'calendar_initial_view','month'),(733,59,'login_initial_view','timesheet'),(734,59,'favorite_routes',''),(735,59,'daily_stats',''),(736,59,'export_decimal',''),(737,59,'__wizards__','intro,profile'),(738,56,'hourly_rate','0'),(739,56,'internal_rate',NULL),(740,56,'first_weekday','monday'),(741,56,'skin','dark'),(742,56,'update_browser_title','1'),(743,56,'calendar_initial_view','month'),(744,56,'login_initial_view','timesheet'),(745,56,'favorite_routes',''),(746,56,'daily_stats',''),(747,56,'export_decimal',''),(748,56,'__wizards__','intro,profile'),(749,60,'timezone','Asia/Kolkata'),(750,60,'language','en_US'),(751,60,'__pw_reset__','0'),(752,60,'hourly_rate','0'),(753,60,'internal_rate',NULL),(754,60,'first_weekday','monday'),(755,60,'skin','default'),(756,60,'update_browser_title','1'),(757,60,'calendar_initial_view','month'),(758,60,'login_initial_view','timesheet'),(759,60,'favorite_routes',''),(760,60,'daily_stats',''),(761,60,'export_decimal',''),(762,60,'__wizards__','intro,profile'),(763,61,'timezone','Asia/Kolkata'),(764,61,'language','en_GB'),(765,61,'__pw_reset__','0'),(766,61,'hourly_rate','0'),(767,61,'internal_rate',NULL),(768,61,'first_weekday','monday'),(769,61,'skin','dark'),(770,61,'update_browser_title','1'),(771,61,'calendar_initial_view','month'),(772,61,'login_initial_view','timesheet'),(773,61,'favorite_routes',''),(774,61,'daily_stats',''),(775,61,'export_decimal',''),(776,61,'__wizards__','intro,profile'),(777,62,'timezone','Asia/Kolkata'),(778,62,'language','en_GB'),(779,62,'__pw_reset__','0'),(780,62,'hourly_rate','0'),(781,62,'internal_rate',NULL),(782,62,'first_weekday','monday'),(783,62,'skin','default'),(784,62,'update_browser_title','1'),(785,62,'calendar_initial_view','month'),(786,62,'login_initial_view','timesheet'),(787,62,'favorite_routes',''),(788,62,'daily_stats',''),(789,62,'export_decimal',''),(790,62,'__wizards__','intro,profile'),(791,63,'timezone','Asia/Kolkata'),(792,63,'language','en_GB'),(793,63,'hourly_rate','0'),(794,63,'internal_rate',NULL),(795,63,'first_weekday','monday'),(796,63,'skin','default'),(797,63,'update_browser_title','1'),(798,63,'calendar_initial_view','month'),(799,63,'login_initial_view','timesheet'),(800,63,'favorite_routes',''),(801,63,'daily_stats',''),(802,63,'export_decimal',''),(803,63,'__wizards__','intro,profile'),(804,64,'timezone','Asia/Kolkata'),(805,64,'language','en'),(806,64,'hourly_rate','0'),(807,64,'internal_rate',NULL),(808,64,'first_weekday','monday'),(809,64,'skin','default'),(810,64,'update_browser_title','1'),(811,64,'calendar_initial_view','month'),(812,64,'login_initial_view','timesheet'),(813,64,'favorite_routes',''),(814,64,'daily_stats',''),(815,64,'export_decimal',''),(816,64,'__wizards__','intro,profile'),(817,65,'timezone','Asia/Kolkata'),(818,65,'language','en_US'),(819,65,'hourly_rate','0'),(820,65,'internal_rate',NULL),(821,65,'first_weekday','monday'),(822,65,'skin','default'),(823,65,'update_browser_title','1'),(824,65,'calendar_initial_view','month'),(825,65,'login_initial_view','timesheet'),(826,65,'favorite_routes',''),(827,65,'daily_stats',''),(828,65,'export_decimal',''),(829,65,'__wizards__','intro,profile'),(830,66,'timezone','Asia/Kolkata'),(831,66,'language','en_US'),(832,66,'hourly_rate','0'),(833,66,'internal_rate',NULL),(834,66,'first_weekday','monday'),(835,66,'skin','default'),(836,66,'update_browser_title','1'),(837,66,'calendar_initial_view','month'),(838,66,'login_initial_view','timesheet'),(839,66,'favorite_routes',''),(840,66,'daily_stats',''),(841,66,'export_decimal',''),(842,66,'__wizards__','intro,profile'),(843,67,'timezone','Asia/Kolkata'),(844,67,'language','en_IN'),(845,67,'hourly_rate','0'),(846,67,'internal_rate',NULL),(847,67,'first_weekday','monday'),(848,67,'skin','dark'),(849,67,'update_browser_title','1'),(850,67,'calendar_initial_view','month'),(851,67,'login_initial_view','timesheet'),(852,67,'favorite_routes',''),(853,67,'daily_stats',''),(854,67,'export_decimal',''),(855,67,'__wizards__','intro,profile'),(856,68,'timezone','Asia/Kolkata'),(857,68,'language','en_US'),(858,68,'__pw_reset__','0'),(859,68,'hourly_rate','0'),(860,68,'internal_rate',NULL),(861,68,'first_weekday','monday'),(862,68,'skin','default'),(863,68,'update_browser_title','1'),(864,68,'calendar_initial_view','month'),(865,68,'login_initial_view','timesheet'),(866,68,'favorite_routes',''),(867,68,'daily_stats',''),(868,68,'export_decimal',''),(869,68,'__wizards__','intro,profile'),(870,69,'timezone','Asia/Kolkata'),(871,69,'language','en_US'),(872,69,'__pw_reset__','0'),(873,69,'hourly_rate','0'),(874,69,'internal_rate',NULL),(875,69,'first_weekday','monday'),(876,69,'skin','default'),(877,69,'update_browser_title','1'),(878,69,'calendar_initial_view','month'),(879,69,'login_initial_view','timesheet'),(880,69,'favorite_routes',''),(881,69,'daily_stats',''),(882,69,'export_decimal',''),(883,69,'__wizards__','intro,profile');

--
-- Table structure for table `kimai2_users`
--

CREATE TABLE `kimai2_users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alias` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL,
  `registration_date` datetime DEFAULT NULL,
  `title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `roles` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `last_login` datetime DEFAULT NULL,
  `confirmation_token` varchar(180) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password_requested_at` datetime DEFAULT NULL,
  `api_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `auth` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(7) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `totp_secret` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `totp_enabled` tinyint(1) NOT NULL DEFAULT '0',
  `system_account` tinyint(1) NOT NULL DEFAULT '0',
  `supervisor_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_B9AC5BCEF85E0677` (`username`),
  UNIQUE KEY `UNIQ_B9AC5BCEE7927C74` (`email`),
  UNIQUE KEY `UNIQ_B9AC5BCEC05FB297` (`confirmation_token`),
  KEY `IDX_B9AC5BCE19E9AC5F` (`supervisor_id`),
  CONSTRAINT `FK_B9AC5BCE19E9AC5F` FOREIGN KEY (`supervisor_id`) REFERENCES `kimai2_users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kimai2_users`
--

INSERT INTO `kimai2_users` VALUES (2,'Jainam','jainam@moweb.com','$2y$13$ySdW9JniCMA8XOWCWjRMR.vBjLJ1a56h/a7EKZ4D8Zy94BJStf.Dq','Jainam',1,'2023-12-06 13:28:21','CEO',NULL,'a:1:{i:0;s:16:\"ROLE_SUPER_ADMIN\";}','2024-11-15 23:02:16',NULL,NULL,NULL,'kimai','#1e90ff',NULL,'7PCTAQEE3CG24SJNAQHJFBX34IE4DKDPNICQN22A4NHZW2ABUM6Q',0,0,NULL),(3,'Deep','deep@moweb.com','$2y$13$ot.jqVTnR5ClGRWNNsiFZu5cQXeF1sLMfL/T7YAGte0t8fzphGlVe','Deep',1,'2023-12-07 06:36:19','Director',NULL,'a:2:{i:0;s:7:\"MANAGER\";i:1;s:10:\"ROLE_ADMIN\";}','2024-11-14 12:31:28','lCJFYSDUCg4_OaM1XIiDS4sm2_nfK468757Ei-wdRlw',NULL,NULL,'kimai',NULL,NULL,NULL,0,0,NULL),(4,'Nisarg','nisarg@moweb.com','$2y$13$2jJ7QN4Ic3pN1jVWBOITduF.7GO/d/scFTMwVgESaj0WTZoQ.AFvC','Nisarg',1,'2023-12-07 06:37:12',NULL,NULL,'a:1:{i:0;s:7:\"MANAGER\";}','2024-11-12 04:21:20','tuihRipJR5nGjoAIiRClgXYr64YP_B3Xulte2bYLKPQ',NULL,NULL,'kimai',NULL,NULL,NULL,0,0,NULL),(5,'namrata','namrata@moweb.com','$2y$13$H8FK.DbdsLy1lCrhMcFq4.Fb0RpJXceLDAsHbdcL5iTosjdRATuUi','Namrata',1,'2023-12-07 06:37:43','QA',NULL,'a:0:{}','2024-07-22 09:13:18',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,4),(6,'Zeel','hr@moweb.com','$2y$13$lNGIE7kU1KsX9t3uo4yDOefsKI7o3MdbWxTbjyfw6NbTm9xJ4Y3Ha','Zeel',1,'2023-12-07 07:31:17','HR',NULL,'a:1:{i:0;s:10:\"ROLE_ADMIN\";}','2024-07-16 13:12:36',NULL,NULL,NULL,'kimai',NULL,NULL,'WMHINY2UMTOSFAJ4YKM7WERPHAKZKWN2FD2UH5BMBBYZR6TG2GWQ',0,0,3),(7,'Rupal','rupal.gohel@moweb.com','$2y$13$VWmeBKVo4XQqZEcbd1om/eqeMX4jEQUOkxBqsaMTiO42h6NxST/OW','Rupal Gohel',1,'2023-12-07 11:03:17',NULL,NULL,'a:1:{i:0;s:7:\"MANAGER\";}','2024-11-22 09:28:08','Du3HBvL4fr96y1lIujcGSNK5ApAXW0aANP5Hxea79Dc',NULL,NULL,'kimai',NULL,NULL,NULL,0,0,3),(8,'Sanjay','Sanjay@moweb.com','$2y$13$oD5vMHUlezjlZr7JBa7Ut.bfo0pgw1STxbyv.v2b1vuPJSfSSY8rK','Sanjay',1,'2023-12-07 11:04:08',NULL,NULL,'a:0:{}','2024-12-10 13:01:54','8hxQIzh9Zt2E5ZVhi9yY8N983t3zauE_7uuhW1b5qcQ','2024-11-07 10:11:07',NULL,'kimai',NULL,NULL,NULL,0,0,7),(9,'Pinak','pinak@moweb.com','$2y$13$d9svViIC.QGzklcXcf/Qq.tfgsyXL1bW6TzZJKqarpy9OaVcvQIsa','Pinak',1,'2023-12-07 11:04:46',NULL,NULL,'a:1:{i:0;s:7:\"MANAGER\";}','2024-12-09 05:34:31',NULL,NULL,NULL,'kimai',NULL,NULL,'7C2FAR75CDEAQMXMQC4IPRJYZNEAQGFET47UHX7JY2543XHYZUAA',1,0,7),(10,'Hardi','hardi.shah@moweb.com','$2y$13$qLQKW1Sz4T.eanGUKO5bG.qzhD.nwwDzGEMxJbGR87LP.FnOGoQCa','Hardi',1,'2023-12-07 11:06:06',NULL,NULL,'a:0:{}','2024-10-18 12:19:58',NULL,NULL,NULL,'kimai',NULL,NULL,'5ZGBEERQY3YBPH667WUESXS54MALVRCKFCOVDZL5F6ZGHU5M5ASA',0,0,7),(11,'Ashit','ioslead@moweb.com','$2y$13$Z.qLz8BBL3DnhZSu5sl7We5rUR4kFeduvtx61jrrors0v61j1AlUy','Ashit',1,'2023-12-07 11:07:11',NULL,NULL,'a:1:{i:0;s:7:\"MANAGER\";}','2024-11-21 14:05:23',NULL,NULL,NULL,'kimai',NULL,NULL,'JBW6FWA6F5CHV7HCIOIYJ4VNDGL5FYZJXWEV55SPWFGAXIXTQJ7A',0,0,3),(12,'Prashant','prashant.dabhi@moweb.com','$2y$13$UEekn/SXiG1QRcGI2oCa0uz6RXWgEFAVoyEeXLC4AeYT1.CVojlDy','Prashant',1,'2023-12-07 11:07:36',NULL,NULL,'a:1:{i:0;s:7:\"MANAGER\";}','2024-12-04 11:24:30',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,11),(13,'Kaushal','designlead@moweb.com','$2y$13$yw45rCffBKkMKiLxR1YnA.cN1awwmjRSawRFO/IztiEiehkI1alti','Kaushal',1,'2023-12-07 11:08:11','Design & Sales Manager',NULL,'a:2:{i:0;s:7:\"MANAGER\";i:1;s:13:\"ROLE_TEAMLEAD\";}','2024-12-03 05:54:56',NULL,NULL,NULL,'kimai',NULL,NULL,'IBQUB3D6ZGZ2EGCXP2STCGGTJNWZOJ2L3K7L5VAVRM43YGXZ55RA',0,0,3),(14,'Sonal','sonal@moweb.com','$2y$13$6G9fkFOlGe5N0ZufMyYWo.Pkp2UfQPOs/2uNtab0mk6hu/PgaatZ6','Sonal',0,'2023-12-07 11:08:42',NULL,NULL,'a:0:{}','2024-01-01 07:59:01',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,13),(15,'Pragyan','pragyan@moweb.com','$2y$13$5GjgeIVu1I6AbUeu8VcPN.EuBvfXxXrmxCdtjl1Lc3y4PoGW59k2m','Pragyan',1,'2023-12-07 11:09:29',NULL,NULL,'a:0:{}','2024-12-10 05:39:26',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,13),(16,'Ami','ami@moweb.com','$2y$13$pweDxfB2ZOdP0CQtya.XY.ZgNDfyak83yQI8asAtnbUByuFmmTRci','Ami',0,'2023-12-07 11:09:58',NULL,NULL,'a:0:{}','2024-01-11 09:44:04',NULL,NULL,NULL,'kimai',NULL,NULL,'LJHH4VDXAPWZOCKCRBAJCSFOSBA4KMXADBEINRHPFRYC7ZJUQVWQ',0,0,13),(18,'Hardik','hardik@moweb.com','$2y$13$YXMNLklD6SuwfJ71bZsuz.v0.F59osnmmS7O4PedbxvKeUfb1bbhm','Hardik Chitroda',1,'2023-12-07 11:11:34',NULL,NULL,'a:0:{}','2024-12-10 13:05:27',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,11),(19,'Swati','swati@moweb.com','$2y$13$Raggye78UlW5JDGhOWU6c.jj8Qjwh1hNyxXFLNKl222bsLA2oDtei','Swati',0,'2023-12-07 11:11:56',NULL,NULL,'a:0:{}','2024-05-19 03:12:12',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,7),(20,'Niyati','niyati@moweb.com','$2y$13$pkK.l6hCulmEflWTDYNczeTDi.l0QjSwrpmYcWf00Apg0DW4mcxDG','Niyati Mehta',0,'2023-12-07 11:12:30',NULL,NULL,'a:0:{}','2024-01-10 12:25:16',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,4),(22,'hardikchauhan','hardikchauhan@moweb.com','$2y$13$DE8kVu6wYz3grUxb58UKP.SFIAPStQjttxmw/wpQoKomnHBK.6xv2','Hardik Chauhan',1,'2023-12-07 11:15:58',NULL,NULL,'a:0:{}','2024-12-05 12:32:05','MslDRsMXyz0O73qoNNHojbB_EhYuZ9pNJGNrKRxINCM',NULL,NULL,'kimai',NULL,NULL,'5XBXPI7HAOJ7HAP2CY4UTSV65LYA6EKMHFVHHFJX3ITWD56OBHNQ',0,0,13),(23,'harshthakor','harsh.thakor@moweb.com','$2y$13$uh1Yyom7eoipwdmIqVtZwu7oTNn.9L9/ArJjaedG.8LqasGa5dL4O','Harsh Thakor',0,'2023-12-07 11:20:49',NULL,NULL,'a:0:{}','2024-05-02 14:50:29',NULL,NULL,NULL,'kimai',NULL,NULL,'NILETSPWTXBRK7YVOJJLIJAZH7UUXBNKKACNW2MI7QGVHH77SD4Q',0,0,7),(24,'Abhishek','abhishek.chauhan@moweb.com','$2y$13$Xu0ekgvBOoPidCkfxjnfeeh3vIXYCwTGq7HafjI6tP/tXaoxdMtMO','Abhishek Chauhan',0,'2023-12-07 11:21:34',NULL,NULL,'a:0:{}','2024-04-30 14:42:08',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,7),(25,'Devang','devang@moweb.com','$2y$13$a9uqJQABdGzcikvYfL3l4.mKsl6UUdgBkdHe/l3N6/8LVEEUmthD2','Devang Shah',0,'2023-12-07 11:22:11',NULL,NULL,'a:0:{}','2024-05-06 10:43:49','rQolG4VLf9t9Rxw1lfC4aG6pCOrL-LL_FRbVZ5hhtGw',NULL,NULL,'kimai',NULL,NULL,NULL,0,0,7),(26,'Yagnik','yagnik@moweb.in','$2y$13$CpI5nnuRjTfPyvnGnjEl/.WtTLEORmPvK8OowMGOxOy9RbE4vCLn.','Yagnik Gajipara',1,'2023-12-07 11:24:35',NULL,NULL,'a:0:{}','2024-12-10 12:56:54',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,4),(27,'Khushal','khushal@moweb.com','$2y$13$TjbSxbHMnsOxRlKVQlCBDeOO19Fhht83p8sPFoUj5Q6ppcq3MpIKW','Khushal Vadher',0,'2023-12-07 11:25:44',NULL,NULL,'a:0:{}','2024-05-03 09:58:47',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,11),(28,'harshprajapati','devops@moweb.com','$2y$13$0GKkpa6uiljb9tZtKSs/d.UcdwzD0WzHG2LOXU8qDfKd5J0KkXqe6','Harsh Prajapati',1,'2023-12-07 11:27:58','DevOps',NULL,'a:0:{}','2024-12-10 13:33:34','5RbthUudXZSYKy_MdXl1buaIJGR5hUc5mpHxBF-C-og',NULL,NULL,'kimai',NULL,NULL,'5RY6CCS46ADQIXEJVOWGGVMDDKQ5NFKFF4IYJQWG434NKKRHVSZA',0,0,3),(30,'Yash','yash@moweb.com','$2y$13$hwubg2BZVIkemOPSMxthQuPQDv47IVQLQwmVPmI0K3gG89HCrSuJa','Yash Trivedi',1,'2023-12-07 11:41:51',NULL,NULL,'a:0:{}','2024-12-09 09:16:03',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,13),(31,'Arjun','arjun@moweb.com','$2y$13$AEHRJpGd0Y/YFqFCxWDr.e6s7UrCndUTE59ufNor.GxpHAFllylhO','Arjun Vaghasiya',0,'2023-12-07 11:42:29',NULL,NULL,'a:0:{}','2024-02-22 13:32:40','7c9ERq3_QAUywWEXQ-qRV6sP7logTyZWBWrKU46fdvg',NULL,NULL,'kimai',NULL,NULL,NULL,0,0,3),(34,'bhaveshramanuj','wpdev@moweb.com','$2y$13$EL0XSyoauF/yJJ1GMI5GyeGH3yFzHYNCwZyNuXuxW6UV6UE27fxgu','Bhavesh Ramanuj',0,'2023-12-07 11:59:10',NULL,NULL,'a:0:{}','2024-02-29 13:36:46',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,7),(35,'Jayshah','jay@moweb.in','$2y$13$iZ3L85aL2TWLGpSz71kdGewTI81ly9MIHxKztqPcH.B9i9h.P91k2','Jay Shah',1,'2023-12-07 11:59:48',NULL,NULL,'a:0:{}','2024-06-28 12:40:24',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,11),(36,'jaygajjar','jay.gajjar@moweb.com','$2y$13$92Ffc6mzAL6QB4EG/imvXeSb5ox9LDRH1.LaoKY2uKwkmEpbxkqBu','Jay Gajjar',1,'2023-12-07 12:00:33',NULL,NULL,'a:0:{}','2024-09-30 08:45:40',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,7),(37,'naitiksheth','naitik@moweb.com','$2y$13$dp3tVL5vOYRbLzOn6zn2DuE5Ssi9GW6DztMwakEFax7l76vGj9u0a','Naitik Sheth',1,'2023-12-07 12:01:39',NULL,NULL,'a:0:{}','2024-12-10 13:11:02','0W0vbd_3jMBEmWxigHvkzWkqwtg-ZD8k8RrEjfJxZ1w',NULL,NULL,'kimai',NULL,NULL,NULL,0,0,7),(38,'KashyapTrivedi','kashyap@moweb.com','$2y$13$MKoyvE.d3XGBhWZqWwQ0K.PMmXA/372U/1xhTQTWXuHhIM/0EB4Hi','Kashyap Trivedi',1,'2023-12-07 12:02:20',NULL,NULL,'a:0:{}','2024-12-10 12:42:20',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,7),(39,'DevendraMali','devendra@moweb.com','$2y$13$2vo/QbAHT7p5jkkIDoiiD.IdxV4fL8iShwktL0MlyD.M9siVrhele','Devendra Mali',1,'2023-12-07 12:02:47',NULL,NULL,'a:0:{}','2024-12-10 13:52:19',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,7),(40,'KrutikGohel','krutik@moweb.com','$2y$13$uN0uPEMDZJ3FKqsykPtgLOfVULj271DxNdaE5gxoUTWevUYH4EyYS','Krutik Gohel',1,'2023-12-07 12:03:45',NULL,NULL,'a:0:{}','2024-12-10 13:55:00',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,11),(41,'SmitPatel','psmit7638@gmail.com','$2y$13$/HQas6xRIh1B280pMu46muwbNjoEcM8.TLGhp6RWEfCcoGDDY4O5a','Smit Patel',1,'2023-12-07 12:04:35',NULL,NULL,'a:0:{}','2024-09-25 05:26:04',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,7),(42,'Kruti','kruti@moweb.com','$2y$13$OZGTSG33A0co5iV4wdUy2uUOrrXMpdFNEyX8tIAVQzK4fvJidhsFu','Kruti Shah',1,'2023-12-07 12:05:19',NULL,NULL,'a:0:{}','2024-01-04 12:33:40',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,2),(43,'bhavesh','bhavesh@moweb.in','$2y$13$mQxMmMjZ.89pRtRvrf43keFftWw85w9RDoK57KZMpCklu7P3HwCCO','Bhavesh',0,'2023-12-12 10:32:11',NULL,NULL,'a:0:{}','2023-12-29 14:03:56',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,NULL),(44,'Ayush','ayush.web.moweb@gmail.com','$2y$13$MsJt/WagWALheUljwWZ/yOFOg8SXMTjwoXQ4KR2MwCAQugPoaqtkO',NULL,0,'2023-12-14 06:40:52',NULL,NULL,'a:0:{}','2023-12-20 04:01:03',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,NULL),(45,'darshit','darshit@moweb.in','$2y$13$KxjsHLhya4bmKrn5VoLUc.mJzXUvEDK1VcHNG5L7kZhbIRXv5LSTi','Darshit Dandnayak',1,'2023-12-14 06:42:29',NULL,NULL,'a:0:{}','2024-12-10 13:17:33',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,NULL),(46,'dhruva','dhruva@moweb.com','$2y$13$KOEfdHW5jp6iBwFBlPHjduxitb9cVDTDdu/j/rA30dTWZFHbJyjfG','Dhruva shah',1,'2023-12-14 06:43:59',NULL,NULL,'a:0:{}','2024-12-10 13:07:55','C1X8JixOHn9gq2pCTFg3ZFTJDc4XMk8knMBdRUQlkNU',NULL,NULL,'kimai',NULL,NULL,NULL,0,0,NULL),(47,'krutiksinh','krutik.web.moweb@gmail.com','$2y$13$fiMKKoDvNAl1azStHFVU6uWDqdxcrIxU.07YdUsJPkpALN1CLYsLW','Krutiksinh Jadav',0,'2023-12-14 06:44:54',NULL,NULL,'a:0:{}','2024-02-09 11:37:25','pdvf4vnPLs_f6GwmIFOsYq09jpAN9Cjvmrw6-0-4LJM',NULL,NULL,'kimai',NULL,NULL,NULL,0,0,NULL),(48,'Nandani','nandani@moweb.com','$2y$13$oCblE8ACRK0AQ4yuT8PFrOeYiEAi9ezs3xXKGk9d8it.EVRS2PsNS','Nandani Boghara',1,'2023-12-14 07:24:17',NULL,NULL,'a:0:{}','2024-12-10 13:49:45',NULL,NULL,NULL,'kimai',NULL,NULL,'6F3PJX4TY7SQW6SALVRDLMQJ6F4WFBDJDE7ZNSGYKMFR674JVMKA',0,0,NULL),(49,'nirav','nirav@moweb.com','$2y$13$s32rQBq.yEl6YWLkkJVywuK7ZmeexQGojyj5Ve7I2X0I7sM5y6uIG','Nirav',1,'2024-01-23 13:01:07',NULL,NULL,'a:1:{i:0;s:7:\"MANAGER\";}','2024-12-03 16:29:41',NULL,NULL,NULL,'kimai','#000000',NULL,NULL,0,0,NULL),(50,'Vruta','vruta@moweb.in','$2y$13$Sc2b8p4KU1SDwPdCBHxv1uQd8T1HJ47LXRVeLFDqIl8QvosJrsvgi','Vruta baldha',1,'2024-03-29 11:40:05','Associate DevOps Engineer',NULL,'a:0:{}','2024-12-10 08:15:02','U53JyvWJz1jrrhp6pe1O4C0tdCQnMkpakYNV4G_t2Fo',NULL,NULL,'kimai','#0000ff',NULL,'FI4HBA7TIC2OHPFKOZQLYOMUWFTSTJFKYFWLMKOYTZL23IAY24TA',0,0,28),(51,'ghanshyam','ghanshyam@moweb.in','$2y$13$pEviM4qiG5lwoA432Ae.jeCA1QU/JXe2mrUt3LWaHdbWx3muEmhcS','Raval Ghanshyam',1,'2024-04-30 05:13:47','Associate Software Engineer | WordPress',NULL,'a:0:{}','2024-12-10 13:33:51',NULL,NULL,NULL,'kimai','#00bfff',NULL,'BTA6TLA2YZBMGDCVP2QQQV7K4R4PMJDXHSBDMC6IIFCX2UCZNNLA',0,0,7),(52,'Smit Hajare','smit@moweb.in','$2y$13$nbEO7mZzmA3H.e0/X9cewOvmuN97Gkz92XfbLYOOwX8DFHGfowYNq','Smit Hajare',1,'2024-05-02 10:02:29','Hajare',NULL,'a:0:{}','2024-12-10 12:33:12',NULL,NULL,NULL,'kimai','#ffdab9',NULL,'7JMFSXYASZZNVXMO227RFXZY7WJKTSBSRRI37XS5F6Z4OSC2LEPA',0,0,13),(53,'saksham','saksham@moweb.in','$2y$13$Mi7/yGzERuYoWU0z4G6dP.I.ZUw07LtMgUroy9dWtGwdiqjUE.pCq','Saksham Nagar',1,'2024-05-07 12:00:35','Intern | Full Stack Web',NULL,'a:0:{}','2024-12-10 13:05:49',NULL,NULL,NULL,'kimai','#a52a2a',NULL,NULL,0,0,48),(54,'khushi','khushi.ds.moweb@gmail.com','$2y$13$PHJkMhf1e10jjrRjgAKmkec8xJ1rAbCVNDyn16ofMR59iy679gKna','Khushi',1,'2024-05-31 05:05:02','Desai',NULL,'a:0:{}','2024-12-05 14:33:47',NULL,NULL,NULL,'kimai','#c0c0c0',NULL,NULL,0,0,3),(55,'archana','archana@moweb.com','$2y$13$cvmL32nPUmbhv1JZp9ZYJ.IIhRiaykuvirFM3QRzOI8H7AtEuIxeG','Archana Suthar',1,'2024-06-17 09:42:09','Associate Front-End Developer',NULL,'a:0:{}','2024-12-10 13:28:25',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,NULL),(56,'Vedant','vedant@moweb.com','$2y$13$5Kb9P.wAgh3xle1qoSWWrOe..m24sutzQs8sLSmTPPlhGU330rK4.','Vedant Pandya',1,'2024-06-20 13:36:40','Associate Business Analyst',NULL,'a:0:{}','2024-12-10 06:09:17',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,NULL),(57,'Palak','palak@moweb.com','$2y$13$sOkJvhkNP5KlcyAkLfks5.46msorLlBblpr3Qvv7PlQrTLsL2YEQa','Palak',1,'2024-07-15 05:17:19',NULL,NULL,'a:0:{}','2024-12-10 06:00:13',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,NULL),(58,'harsh','harsh.web.moweb@gmail.com','$2y$13$cjneAoK7ECjSFb2YdhWQAuMEv1EYL6ZvO3E13c7Mb6W2S3TAjbO3q','Harsh Sheth',1,'2024-07-17 10:18:34','Intern | Full Stack Web',NULL,'a:0:{}','2024-08-05 13:49:34',NULL,NULL,NULL,'kimai','#a52a2a',NULL,NULL,0,0,7),(59,'neel_shah','neel.web.moweb@gmail.com','$2y$13$.FqYIyhJ3IYWVDpwxDbVF.aiXMzIvPUgjaar.yLZZ27Q/B0L2l5KG','Neel Shah',1,'2024-07-17 10:23:44','Neel Shah',NULL,'a:0:{}','2024-11-12 06:43:00',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,7),(60,'bhumika','bhumikas@moweb.in','$2y$13$FGenTtB0Q1sTBSHWUYsIjOxqGvvhJcykXBz7vRjahpQicwY7CK1Lm','Bhumika Singal',1,'2024-08-01 07:33:30','Bhumika Singal',NULL,'a:0:{}','2024-12-06 13:01:10',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,7),(61,'Zeel Shah','zeel@moweb.in','$2y$13$NLyebGGc2ULRPFdIxl3mWuk97C4IAeM3L6ZCL71XPNvBg8jZTNmKO','Zeel SEO',1,'2024-08-08 06:22:36','Sr. SEO Executive',NULL,'a:0:{}','2024-12-09 09:04:53',NULL,NULL,NULL,'kimai','#a52a2a',NULL,NULL,0,0,NULL),(62,'rajvadariya','raj@moweb.com','$2y$13$uE.47ntAlxfemmOkWRfGVu1P99AQSoG0ieviL9va2ygHEeKpVmUTi','Raj Vadariya',1,'2024-09-06 09:34:12','Raj Vadariya',NULL,'a:0:{}','2024-12-10 13:42:14',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,7),(63,'Anand Parmar','anand@moweb.com','$2y$13$iyOOezWhUATgn0K2xhA.DOukCqPsZfvqR5OSBVfwbR5Eoncokl3vm','Anand Parmar',1,'2024-09-12 05:03:41','Software Engineer | Flutter',NULL,'a:0:{}','2024-12-10 04:20:51',NULL,NULL,NULL,'kimai','#800000',NULL,NULL,0,0,NULL),(64,'yusuf','yusuf@moweb.in','$2y$13$94CchOb8/KbvVtEYIMiKEe27gbqFu9p49v.oXv5hI4ai8ggL5r0aq','Yusuf',1,'2024-09-17 06:05:24',NULL,NULL,'a:0:{}','2024-12-07 12:21:03',NULL,NULL,NULL,'kimai','#ff0000',NULL,NULL,0,0,NULL),(65,'nishant','nishant@moweb.in','$2y$13$cjDnHvJcZ.nU0jW2LeW/uuonlnImqvY541KC.iN3wxzYbKFPxFwTG','Nishant Darji',1,'2024-09-24 05:34:17',NULL,NULL,'a:0:{}','2024-12-10 09:56:17',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,NULL),(66,'Bansi','bansi@moweb.com','$2y$13$UXWhduZGn3kWEOHOdCidI.bh19g3Nw0bekebh.8q3nTtaPmZ2QoFG','Bansi',1,'2024-10-07 08:20:18',NULL,NULL,'a:1:{i:0;s:7:\"MANAGER\";}','2024-12-06 09:14:25',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,NULL),(67,'Komal','komal@moweb.com','$2y$13$8x26V9jv.OEUwpPu81h0tuyGIApW5wNMigy7P6G4W8YnwRbpJJWZ2','Komal',1,'2024-11-11 08:49:21',NULL,NULL,'a:0:{}','2024-12-10 12:55:40',NULL,NULL,NULL,'kimai','#0000ff',NULL,NULL,0,0,NULL),(68,'tirthshah.python','tirth.web.moweb@gmail.com','$2y$13$gJToXOPqrUQ.4gDreWBgzO7CHGZsY1GSI.VUJHG8dXAqZnMmDoXDm','Tirth Shah',1,'2024-11-15 09:09:45','Tirth Shah',NULL,'a:0:{}','2024-12-10 13:44:01',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,7),(69,'bhavesh.suthar','bhavesh.web.moweb@gmail.com','$2y$13$0u8iFSAesMrw0T1Xk.URcuBvKNtM62NtpQwVy2gTmIQtU9uAsP9BO','Bhavesh Suthar',1,'2024-12-02 07:45:40','Bhavesh|Web',NULL,'a:0:{}','2024-12-10 13:14:33',NULL,NULL,NULL,'kimai',NULL,NULL,NULL,0,0,7);

--
-- Table structure for table `kimai2_users_teams`
--

CREATE TABLE `kimai2_users_teams` (
  `user_id` int NOT NULL,
  `team_id` int NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `teamlead` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_B5E92CF8A76ED395296CD8AE` (`user_id`,`team_id`),
  KEY `IDX_B5E92CF8A76ED395` (`user_id`),
  KEY `IDX_B5E92CF8296CD8AE` (`team_id`),
  CONSTRAINT `FK_B5E92CF8296CD8AE` FOREIGN KEY (`team_id`) REFERENCES `kimai2_teams` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_B5E92CF8A76ED395` FOREIGN KEY (`user_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=570 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kimai2_users_teams`
--

INSERT INTO `kimai2_users_teams` VALUES (13,1,1,1),(11,1,2,1),(18,1,3,0),(14,2,4,0),(15,2,5,0),(16,2,6,0),(13,2,7,1),(9,2,8,0),(11,3,9,1),(18,3,10,0),(4,3,11,0),(20,3,12,0),(10,3,13,0),(16,3,14,0),(11,4,15,1),(38,4,16,0),(9,4,17,0),(36,4,18,0),(16,4,19,0),(14,4,20,0),(4,4,21,0),(4,5,22,1),(22,6,23,0),(16,6,24,0),(13,6,25,1),(14,7,26,1),(15,7,27,0),(13,7,28,1),(5,5,29,0),(20,5,30,0),(24,8,31,0),(23,8,32,0),(25,8,33,0),(10,8,34,0),(5,8,35,0),(14,8,36,0),(7,8,37,1),(24,10,39,0),(9,10,40,0),(4,10,41,1),(13,3,42,0),(13,4,43,0),(30,11,44,0),(13,11,46,1),(3,11,47,1),(2,11,48,1),(42,11,49,1),(26,5,50,0),(12,12,51,1),(38,12,55,0),(9,12,56,0),(13,12,59,1),(22,12,61,0),(18,13,63,0),(35,13,64,0),(40,13,65,0),(11,13,66,1),(11,15,68,1),(18,15,69,0),(35,15,70,0),(12,15,71,0),(43,15,73,0),(40,15,74,0),(27,15,75,0),(39,16,80,0),(10,16,81,0),(28,16,82,0),(36,16,84,0),(38,16,85,0),(37,16,86,0),(9,16,89,1),(8,16,91,0),(7,16,92,1),(41,16,93,0),(39,17,94,0),(38,17,95,0),(27,17,96,0),(14,17,98,0),(12,17,99,1),(16,17,100,0),(13,17,101,1),(5,17,102,0),(4,17,103,0),(9,17,104,0),(7,17,105,1),(15,8,106,0),(45,16,107,0),(46,16,109,0),(48,16,111,0),(28,18,112,0),(7,18,113,1),(35,19,114,0),(25,19,115,0),(11,19,116,1),(24,20,117,0),(7,20,118,1),(9,20,119,1),(8,20,120,0),(5,20,121,0),(31,21,122,0),(7,21,123,1),(27,21,124,0),(46,21,125,0),(37,21,126,0),(25,21,127,0),(48,21,128,0),(10,22,129,0),(7,22,130,1),(12,22,131,0),(48,12,133,0),(13,24,134,1),(14,24,135,0),(16,24,137,0),(22,24,138,0),(2,24,139,0),(10,10,140,0),(15,24,141,1),(28,20,142,0),(9,25,143,1),(7,25,144,1),(14,25,145,0),(38,25,146,0),(15,25,147,0),(9,1,152,0),(7,27,153,1),(13,27,154,1),(14,27,155,0),(15,27,156,0),(48,27,157,0),(37,27,158,0),(23,13,159,0),(7,2,161,1),(38,2,162,0),(39,2,163,0),(45,2,164,0),(13,25,166,1),(13,29,167,1),(2,29,168,1),(7,29,169,1),(22,29,170,0),(16,29,171,0),(42,29,173,0),(10,29,174,0),(25,30,175,0),(23,30,176,0),(7,30,177,1),(2,31,179,1),(47,1,180,0),(47,4,181,0),(12,32,182,0),(11,32,183,1),(27,33,184,0),(9,33,185,1),(25,33,186,0),(27,34,187,0),(9,34,188,1),(25,34,189,0),(7,34,190,1),(7,35,191,1),(31,35,192,0),(28,35,193,0),(27,35,194,0),(25,20,195,0),(2,36,196,1),(7,36,197,1),(28,36,198,0),(13,36,199,1),(42,36,200,1),(5,36,201,0),(23,36,202,0),(22,25,203,0),(25,37,204,0),(7,37,205,1),(22,36,206,0),(7,38,207,1),(9,38,208,1),(8,38,209,0),(38,38,210,0),(15,29,211,0),(11,39,212,1),(2,39,213,0),(12,39,214,0),(12,40,215,1),(35,40,216,1),(13,40,217,1),(11,41,218,1),(2,41,219,0),(18,41,220,0),(22,2,221,0),(22,40,222,0),(7,42,223,1),(10,42,224,0),(19,42,225,0),(34,42,226,0),(7,43,227,1),(13,43,228,1),(10,43,229,0),(15,36,230,0),(15,12,231,0),(13,44,232,1),(15,44,233,0),(22,44,234,0),(13,45,235,1),(15,45,236,0),(22,45,237,0),(2,45,238,0),(39,25,239,0),(39,4,240,0),(34,46,241,0),(10,46,242,0),(7,46,243,1),(22,4,244,0),(18,47,245,0),(11,47,246,1),(4,47,247,0),(7,47,248,1),(40,47,249,0),(27,47,250,0),(23,47,251,0),(28,47,252,0),(22,47,253,0),(24,47,254,0),(41,47,255,0),(35,47,256,0),(36,47,257,0),(8,47,258,0),(12,47,259,0),(13,47,260,0),(38,47,261,0),(37,47,262,0),(9,47,263,0),(47,47,264,0),(39,47,265,0),(10,47,266,0),(30,47,267,0),(6,47,268,1),(15,47,269,0),(48,47,270,0),(13,48,271,1),(8,48,272,1),(2,48,273,1),(4,48,274,0),(22,30,275,0),(9,49,276,1),(35,50,277,0),(13,50,278,0),(11,50,279,1),(22,50,280,0),(45,4,281,0),(39,50,282,0),(45,50,283,0),(7,51,284,1),(19,51,285,0),(10,51,286,0),(12,52,287,1),(41,52,289,0),(40,52,290,0),(19,29,291,0),(12,53,292,1),(38,53,293,0),(18,50,294,0),(27,22,295,0),(22,17,296,0),(15,22,297,0),(12,54,298,1),(18,54,299,0),(8,54,300,0),(46,54,301,0),(22,54,302,0),(9,54,303,0),(9,53,304,0),(7,55,305,1),(19,55,306,0),(10,55,307,0),(7,56,308,1),(10,56,309,0),(19,56,310,0),(50,16,311,0),(50,18,312,0),(38,54,313,0),(39,54,314,0),(22,22,315,0),(15,54,316,0),(12,57,317,1),(18,57,318,0),(35,57,319,0),(22,13,320,0),(45,52,321,0),(9,52,322,1),(2,58,323,0),(8,58,324,0),(28,58,325,0),(9,58,326,0),(7,58,327,0),(3,58,328,1),(11,59,329,1),(18,59,330,0),(13,59,331,0),(13,58,333,0),(4,58,334,0),(10,57,335,0),(12,58,336,0),(11,58,337,0),(15,56,338,0),(13,61,339,1),(10,61,340,0),(7,61,341,0),(2,61,342,1),(22,61,343,0),(48,54,344,0),(10,53,345,0),(22,57,346,0),(8,62,347,0),(7,62,348,1),(6,62,349,0),(48,62,350,0),(15,17,351,0),(22,58,352,0),(38,58,353,0),(36,58,354,0),(51,16,355,0),(52,6,356,0),(15,50,357,0),(46,12,358,0),(39,12,359,0),(13,64,361,1),(7,64,362,1),(9,64,363,1),(11,64,364,1),(15,51,365,0),(53,16,366,0),(39,64,367,0),(45,64,368,0),(22,64,370,0),(22,1,371,0),(15,1,372,0),(9,65,373,1),(7,65,374,1),(3,65,375,1),(15,65,376,0),(13,65,377,1),(50,58,378,0),(37,66,379,0),(28,66,380,0),(3,66,381,1),(3,67,382,1),(3,68,383,1),(13,68,384,1),(22,68,385,0),(54,66,386,0),(54,21,387,0),(54,16,388,0),(7,69,389,1),(7,1,390,0),(28,1,391,0),(40,64,392,0),(28,12,393,0),(39,58,394,0),(52,29,395,0),(5,58,396,0),(55,7,397,0),(3,70,398,1),(18,58,399,0),(54,12,400,0),(26,12,401,0),(51,3,402,0),(57,5,403,0),(26,58,404,0),(57,64,405,0),(3,71,406,1),(9,71,407,0),(56,71,408,0),(13,71,409,0),(5,71,410,0),(54,71,411,0),(55,71,412,0),(11,71,413,0),(38,71,414,0),(28,71,415,0),(22,71,416,0),(13,72,417,1),(55,72,418,0),(7,72,419,1),(51,72,420,0),(2,72,421,1),(10,72,422,0),(59,16,424,0),(13,73,425,1),(2,73,426,1),(7,73,427,1),(51,73,428,0),(52,73,429,0),(10,73,430,0),(13,74,431,1),(3,74,432,1),(2,74,433,1),(56,74,434,0),(60,16,435,0),(12,75,436,1),(11,75,437,1),(7,75,438,1),(60,75,439,0),(57,75,440,0),(7,76,441,0),(54,76,442,0),(2,76,443,1),(13,76,444,0),(56,76,445,0),(2,77,446,1),(22,77,447,0),(13,77,448,1),(13,78,449,1),(6,78,450,1),(52,78,451,0),(55,78,452,0),(30,78,453,0),(3,78,454,1),(13,79,455,1),(3,79,456,0),(56,79,457,0),(3,80,458,1),(3,81,459,1),(4,76,460,0),(52,72,461,0),(52,77,462,0),(7,82,463,1),(51,82,464,0),(56,83,465,0),(3,83,466,1),(2,83,467,1),(13,84,468,1),(3,84,469,1),(2,84,470,1),(13,83,471,1),(61,84,472,0),(53,12,473,0),(8,12,474,0),(39,71,475,0),(57,73,476,0),(3,85,477,1),(2,85,478,1),(56,85,479,0),(13,85,480,1),(55,73,481,0),(22,86,482,0),(2,86,483,1),(13,86,484,1),(13,88,486,1),(7,88,487,1),(2,88,488,1),(62,16,489,0),(51,88,490,0),(62,72,491,0),(63,12,492,0),(22,89,493,0),(2,89,494,1),(13,89,495,1),(62,88,496,0),(63,15,497,0),(64,75,498,0),(7,86,499,1),(45,86,500,0),(57,86,501,0),(2,90,505,1),(13,90,506,1),(7,90,507,1),(2,91,508,1),(13,91,509,1),(7,91,510,1),(65,75,511,0),(64,16,512,0),(65,15,513,0),(60,76,514,0),(65,86,515,0),(62,82,516,0),(62,91,517,0),(51,91,518,0),(62,90,519,0),(51,90,520,0),(18,71,521,0),(2,44,522,1),(55,44,523,0),(62,92,524,0),(51,92,525,0),(7,92,526,1),(13,92,527,1),(66,86,528,1),(15,90,529,0),(15,91,530,0),(2,93,531,1),(55,93,532,0),(13,93,533,1),(22,90,534,0),(55,90,535,0),(50,12,536,0),(37,72,537,0),(39,86,538,0),(40,86,539,0),(62,43,540,0),(51,43,541,0),(15,89,542,0),(67,67,543,0),(67,70,544,0),(67,58,545,0),(22,94,546,0),(7,94,547,1),(9,94,548,1),(12,94,549,1),(11,94,550,1),(4,94,551,1),(2,94,552,1),(15,94,553,0),(55,94,554,0),(13,94,555,1),(12,95,556,1),(18,95,557,0),(67,75,558,0),(68,16,559,0),(61,96,560,0),(13,96,561,1),(2,96,562,1),(52,94,563,0),(69,16,564,0),(55,89,565,0),(61,72,566,0),(66,97,567,1),(62,86,568,0),(51,86,569,0);

--
-- Table structure for table `kimai2_working_times`
--

CREATE TABLE `kimai2_working_times` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `approved_by` int DEFAULT NULL,
  `date` date NOT NULL,
  `expected` int NOT NULL,
  `actual` int NOT NULL,
  `approved_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_F95E4933A76ED395AA9E377A` (`user_id`,`date`),
  KEY `IDX_F95E4933A76ED395` (`user_id`),
  KEY `IDX_F95E49334EA3CB3D` (`approved_by`),
  CONSTRAINT `FK_F95E49334EA3CB3D` FOREIGN KEY (`approved_by`) REFERENCES `kimai2_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_F95E4933A76ED395` FOREIGN KEY (`user_id`) REFERENCES `kimai2_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kimai2_working_times`
--


--
-- Table structure for table `migration_versions`
--

CREATE TABLE `migration_versions` (
  `version` varchar(191) COLLATE utf8mb3_unicode_ci NOT NULL,
  `executed_at` datetime DEFAULT NULL,
  `execution_time` int DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `migration_versions`
--

INSERT INTO `migration_versions` VALUES ('DoctrineMigrations\\Version20180701120000','2023-12-06 12:28:04',153),('DoctrineMigrations\\Version20180715160326','2023-12-06 12:28:04',91),('DoctrineMigrations\\Version20180730044139','2023-12-06 12:28:04',20),('DoctrineMigrations\\Version20180805183527','2023-12-06 12:28:04',23),('DoctrineMigrations\\Version20180903202256','2023-12-06 12:28:04',12),('DoctrineMigrations\\Version20180905190737','2023-12-06 12:28:04',36),('DoctrineMigrations\\Version20180924111853','2023-12-06 12:28:04',12),('DoctrineMigrations\\Version20181031220003','2023-12-06 12:28:04',122),('DoctrineMigrations\\Version20190124004014','2023-12-06 12:28:04',24),('DoctrineMigrations\\Version20190201150324','2023-12-06 12:28:04',5),('DoctrineMigrations\\Version20190219200020','2023-12-06 12:28:04',0),('DoctrineMigrations\\Version20190305152308','2023-12-06 12:28:04',60),('DoctrineMigrations\\Version20190321181243','2023-12-06 12:28:04',10),('DoctrineMigrations\\Version20190502161758','2023-12-06 12:28:04',46),('DoctrineMigrations\\Version20190510205245','2023-12-06 12:28:05',31),('DoctrineMigrations\\Version20190605171157','2023-12-06 12:28:05',42),('DoctrineMigrations\\Version20190617100845','2023-12-06 12:28:05',111),('DoctrineMigrations\\Version20190706224211','2023-12-06 12:28:05',81),('DoctrineMigrations\\Version20190706224219','2023-12-06 12:28:05',109),('DoctrineMigrations\\Version20190729162655','2023-12-06 12:28:05',57),('DoctrineMigrations\\Version20190730123324','2023-12-06 12:28:05',144),('DoctrineMigrations\\Version20190813162649','2023-12-06 12:28:05',39),('DoctrineMigrations\\Version20191024100951','2023-12-06 12:28:05',32),('DoctrineMigrations\\Version20191108151534','2023-12-06 12:28:05',45),('DoctrineMigrations\\Version20191113132640','2023-12-06 12:28:05',31),('DoctrineMigrations\\Version20191116110124','2023-12-06 12:28:05',35),('DoctrineMigrations\\Version20191204120823','2023-12-06 12:28:05',34),('DoctrineMigrations\\Version20200109102138','2023-12-06 12:28:05',104),('DoctrineMigrations\\Version20200125123942','2023-12-06 12:28:05',47),('DoctrineMigrations\\Version20200204124425','2023-12-06 12:28:05',40),('DoctrineMigrations\\Version20200205115243','2023-12-06 12:28:06',180),('DoctrineMigrations\\Version20200205115244','2023-12-06 12:28:06',85),('DoctrineMigrations\\Version20200308171950','2023-12-06 12:28:06',112),('DoctrineMigrations\\Version20200323163038','2023-12-06 12:28:06',66),('DoctrineMigrations\\Version20200323163039','2023-12-06 12:28:06',1),('DoctrineMigrations\\Version20200413133226','2023-12-06 12:28:06',51),('DoctrineMigrations\\Version20200524142042','2023-12-06 12:28:06',44),('DoctrineMigrations\\Version20200705152310','2023-12-06 12:28:06',49),('DoctrineMigrations\\Version20200725213424','2023-12-06 12:28:06',85),('DoctrineMigrations\\Version20210316224358','2023-12-06 12:28:06',67),('DoctrineMigrations\\Version20210320162820','2023-12-06 12:28:06',64),('DoctrineMigrations\\Version20210405105611','2023-12-06 12:28:06',51),('DoctrineMigrations\\Version20210605154245','2023-12-06 12:28:06',58),('DoctrineMigrations\\Version20210704111542','2023-12-06 12:28:06',67),('DoctrineMigrations\\Version20210717211144','2023-12-06 12:28:06',42),('DoctrineMigrations\\Version20210719123928','2023-12-06 12:28:07',72),('DoctrineMigrations\\Version20210727104955','2023-12-06 12:28:07',95),('DoctrineMigrations\\Version20210802152259','2023-12-06 12:28:07',52),('DoctrineMigrations\\Version20210802152814','2023-12-06 12:28:07',70),('DoctrineMigrations\\Version20210802160837','2023-12-06 12:28:07',73),('DoctrineMigrations\\Version20210802174318','2023-12-06 12:28:07',63),('DoctrineMigrations\\Version20210802174319','2023-12-06 12:28:07',0),('DoctrineMigrations\\Version20210802174320','2023-12-06 12:28:07',53),('DoctrineMigrations\\Version20211008092010','2023-12-06 12:28:07',54),('DoctrineMigrations\\Version20211230163612','2023-12-06 12:28:07',43),('DoctrineMigrations\\Version20220101204501','2023-12-06 12:28:07',72),('DoctrineMigrations\\Version20220315224645','2023-12-06 12:28:07',57),('DoctrineMigrations\\Version20220404150236','2023-12-06 12:28:07',48),('DoctrineMigrations\\Version20220531145920','2023-12-06 12:28:07',81),('DoctrineMigrations\\Version20220722125847','2023-12-06 12:28:07',46),('DoctrineMigrations\\Version20230126002049','2023-12-06 12:28:07',163),('DoctrineMigrations\\Version20230126002050','2023-12-06 12:28:08',62),('DoctrineMigrations\\Version20230327143628','2023-12-06 12:28:08',121),('DoctrineMigrations\\Version20230606125948','2023-12-06 12:28:08',53),('DoctrineMigrations\\Version20230819090536','2023-12-06 12:28:08',106),('DoctrineMigrations\\Version20231130000719','2023-12-06 12:28:08',1);


