-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `ttl_admin_new`
--

-- --------------------------------------------------------

--
-- Table structure for table `access_query_log`
--

CREATE TABLE `access_query_log` (
  `id` int(11) NOT NULL,
  `company_id` varchar(20) DEFAULT NULL,
  `branch_id` varchar(20) DEFAULT NULL COMMENT 'Branch Id sometime brnach_from also',
  `branch_to` varchar(20) DEFAULT NULL,
  `table_name` varchar(100) DEFAULT NULL,
  `operation_type` varchar(100) DEFAULT NULL,
  `query_sql` longtext DEFAULT NULL,
  `execution_time` datetime DEFAULT NULL,
  `execution_by` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `access_query_log`
--

INSERT INTO `access_query_log` (`id`, `company_id`, `branch_id`, `branch_to`, `table_name`, `operation_type`, `query_sql`, `execution_time`, `execution_by`) VALUES
(1, NULL, NULL, NULL, 'gnl_sys_user_roles', 'update', 'update `gnl_sys_user_roles` set `updated_at` = \'2022-02-09 12:08:18\', `menus` = \'1,4,5,460,486,6,8,7,357,359,360,263,341,352,369,3,23,25,26,24,196,197,198,127,131,132,139,140,141,142,344,128,143,144,145,189,129,190,146,147,130,191,192,193,135,148,155,153,475,501,154,149,151,150,152,367,272,280,339,340,281,282,284,285,286,287,289,290,291,355,356,273,299,301,302,303,274,304,305,306,307,478,275,283,288,293,294,366,292,295,296,297,298,300,276,308,309,310,311,312,313,371,277,278,315,316,318,370,319,321,322,354,279,314,324,317,320,323,327,336,368,347,351,328,337,506,507,508,509,350,502,505,510,511,512,513,514,349,503,515,516,345,517,518,519,520,338,504,346,521,479,522,372,353,334,335,361,459,485,348,454,455,456,457,458,394,416,415,417,426,425,424,423,422,421,420,419,418,413,427,414,429,428,398,430,451,399,412,433,432,401,441,440,439,438,437,402,411,450,404,449,448,405,447,446,445,444,442,443,452,200,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,362,224,363,220,221,222,225,226,227,228,229,242,243,244,245,246,364,247,365,248,230,231,232,233,234,235,236,237,238,239,240,241,265,374,384,385,476,375,266,378,379,380,381,382,383,267,268,269,270,386,271,387,473,388,389,477,461,462,463,464,465,466,467,468,469,474,470,472,390,391,392,393,471\', `permissions` = \'25,26,27,32,30,33,34,35,40,38,3419,3420,3421,3422,3423,41,42,43,48,46,57,58,59,64,62,49,50,51,55,56,54,2759,2760,2761,2762,2763,2775,2776,2777,2778,2779,2783,2784,2785,2786,2787,2631,2632,2633,2634,2635,2719,2720,2721,2722,2723,2856,2857,2864,2858,2859,2860,177,178,180,181,858,184,182,859,193,194,196,197,862,200,198,863,201,202,204,205,206,857,185,186,188,189,860,192,190,861,1480,1481,1484,1492,1482,1483,1489,1488,1485,1490,1487,1491,1493,1494,1499,1500,1496,1497,984,985,986,987,988,990,991,992,993,994,1016,1017,1018,1019,1020,1024,1025,1026,1027,1028,1032,1033,1034,1035,1036,1040,1041,1042,1043,1044,2655,2656,2657,2658,2659,2660,2661,2662,1048,1051,1052,1056,1059,1060,1064,1067,1068,1408,1409,1410,1411,1412,1416,1417,1418,1419,1420,1072,1080,1424,1425,1426,1427,1428,1432,1440,1092,1148,1132,3548,3549,3550,3551,3552,1140,1100,1116,1108,1124,2840,2841,2842,2843,2844,2151,2152,2153,2154,2155,2615,2616,2617,2618,2619,2623,2624,2625,2626,2627,2183,2184,2185,2186,2187,2199,2200,2201,2202,2203,2207,2208,2209,2210,2211,2223,2224,2225,2226,2227,2231,2232,2233,2234,2235,2239,2240,2241,2242,2243,2743,2744,2745,2746,2747,2751,2752,2753,2754,2755,2303,2304,2305,2306,2307,2319,2320,2321,2322,2323,2327,2328,2329,2330,2331,2335,2336,2337,2338,2339,2343,2344,2345,2346,2347,2351,2352,2353,2354,2355,2359,2360,2361,2362,2363,2367,2368,2369,2370,2371,3572,3573,3574,3575,3576,2175,2176,2177,2178,2179,2215,2216,2217,2218,2219,2255,2256,2257,2258,2259,2263,2264,2265,2266,2267,2832,2833,2834,2835,2836,2247,2248,2249,2250,2251,2271,2272,2273,2274,2275,2279,2280,2281,2282,2283,2287,2288,2289,2290,2291,2295,2296,2297,2298,2299,2311,2312,2313,2314,2315,2375,2376,2377,2378,2379,2383,2384,2385,2386,2387,2391,2392,2393,2394,2395,2399,2400,2401,2402,2403,2407,2408,2409,2410,2411,2415,2416,2417,2418,2419,2873,2875,2876,2877,2127,2128,2129,2130,2131,2431,2432,2433,2434,2435,2439,2440,2441,2442,2443,2455,2456,2457,2458,2459,2865,2867,2868,2869,2463,2466,2467,2479,2480,2481,2482,2483,2487,2488,2489,2490,2491,2735,2736,2737,2738,2739,2503,2504,2505,2506,2507,2447,2448,2449,2450,2451,2471,2472,2473,2474,2475,2495,2496,2497,2498,2499,2591,2592,2593,2594,2595,2848,2849,2850,2851,2852,2679,2680,2681,2682,2683,2684,2685,2686,2711,2712,2713,2714,2715,2703,2704,2705,2706,2707,2695,2696,2697,2698,2699,2663,2664,2665,2666,2667,2668,2669,2670,2607,2608,2609,2610,2611,2671,2672,2673,2674,2675,2676,2677,2678,2881,2882,2883,2884,2885,2727,2728,2729,2730,2731,2583,2584,2585,2586,2587,2791,2792,2793,2794,2795,3411,3412,3413,3414,3415,2687,2688,2689,2690,2691,2692,2693,2694,3379,3380,3381,3382,3383,3387,3388,3389,3390,3391,3395,3396,3397,3398,3399,3403,3404,3405,3406,3407,3065,3066,3067,3068,3069,3073,3074,3075,3076,3077,3145,3146,3147,3148,3149,3137,3138,3139,3140,3141,3129,3130,3131,3132,3133,3121,3122,3123,3124,3125,3113,3114,3115,3116,3117,3105,3106,3107,3108,3109,3097,3098,3099,3100,3101,3089,3090,3091,3092,3093,3081,3082,3083,3084,3085,3153,3154,3155,3156,3157,3169,3170,3171,3172,3173,3161,3162,3163,3164,3165,3177,3178,3179,3180,3181,3345,3346,3347,3348,3349,3201,3202,3203,3204,3205,3193,3194,3195,3196,3197,3265,3266,3267,3268,3269,3257,3258,3259,3260,3261,3249,3250,3251,3252,3253,3241,3242,3243,3244,3245,3233,3234,3235,3236,3237,3337,3338,3339,3340,3341,3329,3330,3331,3332,3333,3321,3322,3323,3324,3325,3313,3314,3315,3316,3317,3305,3306,3307,3308,3309,3297,3298,3299,3300,3301,3289,3290,3291,3292,3293,3273,3274,3275,3276,3277,3281,3282,3283,3284,3285,3353,3354,3355,3356,3357,1525,1526,1527,1528,1529,1533,1534,1535,1536,1537,1541,1544,1545,1549,1552,1553,1565,1566,1568,1569,1573,1574,1576,1577,1581,1582,1584,1585,1589,1590,1592,1593,1597,1598,1600,1601,1605,1606,1608,1609,1613,1614,1616,1617,1621,1622,1624,1625,1629,1630,1631,1632,1633,1653,1654,1655,1656,1657,1661,1662,1663,1664,1665,1701,1702,1703,1704,1902,1705,2807,2808,2809,2810,2815,2811,1677,1678,1679,1680,1681,1685,1686,1687,1688,1689,1717,1718,1719,1720,1721,1725,1726,1727,1728,1729,1733,1734,1735,1736,1737,1857,1865,1873,1881,1889,2824,2825,2826,2827,2828,1897,1761,1769,1785,1789,1790,1791,1792,1793,1809,1817,1833,1841,2897,2898,2899,2900,2901,2977,2978,2979,2980,2981,2985,2986,2987,2988,2989,3556,3557,3558,3559,3560,2905,2906,2907,2908,2909,2039,2040,2041,2042,2043,2929,2930,2931,2932,2933,2937,2938,2939,2940,2941,2945,2946,2947,2948,2949,2953,2954,2955,2956,2957,2961,2962,2963,2964,2965,2969,2970,2971,2972,2973,2055,2056,2057,2058,2059,2063,2064,2065,2066,2067,2071,2072,2073,2074,2075,2993,2994,2995,2996,2997,3001,3002,3003,3004,3005,3530,3531,3532,3533,3534,3361,3017,3018,3019,3362,3020,3021,3564,3565,3566,3567,3568,3427,3428,3429,3523,3430,3431,3524,3435,3436,3437,3438,3439,3443,3444,3525,3445,3446,3447,3451,3452,3453,3526,3454,3455,3459,3460,3527,3461,3462,3463,3467,3468,3469,3528,3470,3471,3475,3476,3477,3529,3478,3479,3483,3484,3485,3486,3487,3491,3492,3493,3494,3495,3538,3539,3546,3540,3541,3542,3499,3500,3501,3502,3503,3515,3516,3517,3518,3519,3033,3034,3035,3036,3037,3041,3042,3043,3044,3045,3049,3050,3051,3052,3053,3507,3508,3547,3509,3510,3511\', `serialize_menu` = \'[encoded data, 120760 characters]\', `serialize_permission` = \'[encoded data, 323680 characters]\' where `id` = 1', '2022-02-09 12:08:18', '1');
