init_database.sql

-- Adminer 5.0.6 PostgreSQL 17.4 (Debian 17.4-1.pgdg120+2) dump

DROP TABLE IF EXISTS "consumer";
CREATE TABLE "public"."consumer" (
    "id" integer NOT NULL,
    "max_power" double precision,
    CONSTRAINT "consumer_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

TRUNCATE "consumer";
INSERT INTO "consumer" ("id", "max_power") VALUES
(3,	500),
(4,	600);

DROP TABLE IF EXISTS "datapoint";
DROP SEQUENCE IF EXISTS datapoint_id_seq;
CREATE SEQUENCE datapoint_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 3301 CACHE 1;

CREATE TABLE "public"."datapoint" (
    "id" integer DEFAULT nextval('datapoint_id_seq') NOT NULL,
    "timestamp" bigint,
    "value" double precision,
    "measurement" integer,
    CONSTRAINT "datapoint_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

TRUNCATE "datapoint";
INSERT INTO "datapoint" ("id", "timestamp", "value", "measurement") VALUES
(2401,	1743513408,	18008.5554197711,	3),
(2402,	1743513408,	20.2580304356311,	1),
(2403,	1743513408,	300.142590329518,	2),
(2404,	1743513468,	35159.3868807908,	3),
(2405,	1743513468,	20.2012028207296,	1),
(2406,	1743513468,	285.847191016996,	2),
(2407,	1743513528,	52488.7125671953,	3),
(2408,	1743513528,	288.822094773409,	2),
(2409,	1743513528,	19.7128032535346,	1),
(2410,	1743513588,	20.3936053200536,	1),
(2411,	1743513588,	280.757232687782,	2),
(2412,	1743513588,	69334.1465284623,	3),
(2413,	1743513648,	19.5839331273887,	1),
(2414,	1743513648,	85280.182148345,	3),
(2415,	1743513648,	265.767260331379,	2),
(2416,	1743513708,	100903.870689334,	3),
(2417,	1743513708,	260.394809016481,	2),
(2418,	1743513708,	20.2975938952335,	1),
(2419,	1743513768,	117623.264598735,	3),
(2420,	1743513768,	20.3869805304407,	1),
(2421,	1743513768,	278.656565156678,	2),
(2422,	1743513828,	134136.133927037,	3),
(2423,	1743513828,	19.9426153526732,	1),
(2424,	1743513828,	275.214488805047,	2),
(2425,	1743513888,	150080.352354753,	3),
(2426,	1743513888,	20.5826752584863,	1),
(2427,	1743513888,	265.736973795263,	2),
(2428,	1743513948,	21.4541410810767,	1),
(2429,	1743513948,	256.74774657365,	2),
(2430,	1743513948,	165485.217149172,	3),
(2431,	1743514008,	266.369311043636,	2),
(2432,	1743514008,	21.0649455376209,	1),
(2433,	1743514008,	181467.37581179,	3),
(2434,	1743514068,	20.842169291753,	1),
(2435,	1743514068,	280.861074613099,	2),
(2436,	1743514068,	198319.040288576,	3),
(2437,	1743514128,	286.24602303099,	2),
(2438,	1743514128,	215493.801670436,	3),
(2439,	1743514128,	20.7960330245816,	1),
(2440,	1743514188,	20.6352477200388,	1),
(2441,	1743514188,	233029.575494339,	3),
(2442,	1743514188,	292.262897065055,	2),
(2443,	1743514248,	21.5955788880574,	1),
(2444,	1743514248,	251286.375540126,	3),
(2445,	1743514248,	304.28000076311,	2),
(2446,	1743514308,	316.95157828323,	2),
(2447,	1743514308,	270303.470237119,	3),
(2448,	1743514308,	21.9331257009546,	1),
(2449,	1743514368,	290168.600021762,	3),
(2450,	1743514368,	331.08549641071,	2),
(2451,	1743514368,	22.829458572673,	1),
(2452,	1743514428,	22.8560514171262,	1),
(2453,	1743514428,	310019.717878436,	3),
(2454,	1743514428,	330.851964277897,	2),
(2455,	1743514488,	337.285156194004,	2),
(2456,	1743514488,	22.9713148152665,	1),
(2457,	1743514488,	330256.827250076,	3),
(2458,	1743514548,	23.0744186212425,	1),
(2459,	1743514548,	349821.850281989,	3),
(2460,	1743514548,	326.083717198555,	2),
(2461,	1743514608,	23.3501932260934,	1),
(2462,	1743514608,	336.08081660701,	2),
(2463,	1743514608,	369986.69927841,	3),
(2464,	1743514668,	23.7339372011532,	1),
(2465,	1743514668,	353.641116050289,	2),
(2466,	1743514668,	391205.166241427,	3),
(2467,	1743514728,	412872.361606028,	3),
(2468,	1743514728,	361.119922743343,	2),
(2469,	1743514728,	24.4764198833775,	1),
(2470,	1743514788,	375.241059128078,	2),
(2471,	1743514788,	435386.825153713,	3),
(2472,	1743514788,	25.2737524226888,	1),
(2473,	1743514848,	360.174325524959,	2),
(2474,	1743514848,	25.7798768439294,	1),
(2475,	1743514848,	456997.28468521,	3),
(2476,	1743514908,	477410.104707929,	3),
(2477,	1743514908,	340.213667045321,	2),
(2478,	1743514908,	24.9929700752161,	1),
(2479,	1743514968,	499011.525103884,	3),
(2480,	1743514968,	360.023673265916,	2),
(2481,	1743514968,	24.0251294856418,	1),
(2482,	1743515028,	24.3798586424305,	1),
(2483,	1743515028,	368.068194767151,	2),
(2484,	1743515028,	521095.616789913,	3),
(2485,	1743515088,	360.701742828555,	2),
(2486,	1743515088,	24.7114386945818,	1),
(2487,	1743515088,	542737.721359627,	3),
(2488,	1743515148,	565313.674488448,	3),
(2489,	1743515148,	23.8025937761155,	1),
(2490,	1743515148,	376.265885480358,	2),
(2491,	1743515208,	360.42078784355,	2),
(2492,	1743515208,	23.0475515688213,	1),
(2493,	1743515208,	586938.921759061,	3),
(2494,	1743515268,	23.7957865237608,	1),
(2495,	1743515268,	609635.178443206,	3),
(2496,	1743515268,	378.270944735753,	2),
(2497,	1743515328,	23.2363045978021,	1),
(2498,	1743515328,	368.536343225257,	2),
(2499,	1743515328,	631747.359036722,	3),
(2500,	1743515388,	22.4881941790262,	1),
(2501,	1743515388,	654645.218684515,	3),
(2502,	1743515388,	381.63099412989,	2),
(2503,	1743515448,	23.437498556195,	1),
(2504,	1743515448,	385.352922815637,	2),
(2505,	1743515448,	677766.394053453,	3),
(2506,	1743515508,	372.159168265594,	2),
(2507,	1743515508,	24.3289508120954,	1),
(2508,	1743515508,	700095.944149389,	3),
(2509,	1743515568,	723309.923171614,	3),
(2510,	1743515568,	386.899650370424,	2),
(2511,	1743515568,	23.5242056264441,	1),
(2512,	1743515628,	22.8073745101293,	1),
(2513,	1743515628,	390.751434663003,	2),
(2514,	1743515628,	746755.009251395,	3),
(2515,	1743515688,	22.232656937365,	1),
(2516,	1743515688,	382.524103397982,	2),
(2517,	1743515688,	769706.455455274,	3),
(2518,	1743515748,	792894.941526991,	3),
(2519,	1743515748,	21.9499090452652,	1),
(2520,	1743515748,	386.474767861955,	2),
(2521,	1743515808,	22.1541238682548,	1),
(2522,	1743515808,	817240.692377831,	3),
(2523,	1743515808,	405.76251418067,	2),
(2524,	1743515868,	22.6420403424991,	1),
(2525,	1743515868,	840988.962382277,	3),
(2526,	1743515868,	395.804500074098,	2),
(2527,	1743515928,	21.8537551409041,	1),
(2528,	1743515928,	865405.660697878,	3),
(2529,	1743515928,	406.944971926678,	2),
(2530,	1743515988,	889752.007691177,	3),
(2531,	1743515988,	405.772449888328,	2),
(2532,	1743515988,	20.8880910752456,	1),
(2533,	1743516048,	391.885357664651,	2),
(2534,	1743516048,	913265.129151056,	3),
(2535,	1743516048,	20.8511600928417,	1),
(2536,	1743516108,	20.612641851815,	1),
(2537,	1743516108,	400.811376123348,	2),
(2538,	1743516108,	937313.811718457,	3),
(2539,	1743516168,	19.8856397252039,	1),
(2540,	1743516168,	387.287510138443,	2),
(2541,	1743516168,	960551.062326764,	3),
(2542,	1743516228,	984655.812297476,	3),
(2543,	1743516228,	401.745832845207,	2),
(2544,	1743516228,	20.1489533130239,	1),
(2545,	1743516288,	382.671458439789,	2),
(2546,	1743516288,	20.4403581098137,	1),
(2547,	1743516288,	1007616.09980386,	3),
(2548,	1743516348,	1030007.18208945,	3),
(2549,	1743516348,	373.184704759791,	2),
(2550,	1743516348,	19.7771706673748,	1),
(2551,	1743513408,	300.001869488499,	8),
(2552,	1743513408,	21.7622488834455,	7),
(2553,	1743513408,	18000.11216931,	9),
(2554,	1743513468,	36110.0184601452,	9),
(2555,	1743513468,	21.4161098417776,	7),
(2556,	1743513468,	301.831771513921,	8),
(2557,	1743513528,	22.2076010398725,	7),
(2558,	1743513528,	286.947366716898,	8),
(2559,	1743513528,	53326.8604631591,	9),
(2560,	1743513588,	22.4565892461209,	7),
(2561,	1743513588,	304.110024030818,	8),
(2562,	1743513588,	71573.4619050081,	9),
(2563,	1743513648,	89313.3535182134,	9),
(2564,	1743513648,	295.664860220088,	8),
(2565,	1743513648,	23.3139184953248,	7),
(2566,	1743513708,	22.3984374167858,	7),
(2567,	1743513708,	304.843705840353,	8),
(2568,	1743513708,	107603.975868635,	9),
(2569,	1743513768,	296.202518480831,	8),
(2570,	1743513768,	21.4541385880547,	7),
(2571,	1743513768,	125376.126977484,	9),
(2572,	1743513828,	299.574389520476,	8),
(2573,	1743513828,	143350.590348713,	9),
(2574,	1743513828,	21.3248134099821,	7),
(2575,	1743513888,	162147.14160073,	9),
(2576,	1743513888,	313.27585420028,	8),
(2577,	1743513888,	21.9711196936865,	7),
(2578,	1743513948,	181505.003615397,	9),
(2579,	1743513948,	22.0178159181342,	7),
(2580,	1743513948,	322.631033577793,	8),
(2581,	1743514008,	341.066310770164,	8),
(2582,	1743514008,	22.8669693806429,	7),
(2583,	1743514008,	201968.982261607,	9),
(2584,	1743514068,	325.101696643343,	8),
(2585,	1743514068,	221475.084060208,	9),
(2586,	1743514068,	23.2370362295959,	7),
(2587,	1743514128,	327.805529173699,	8),
(2588,	1743514128,	22.7759524632729,	7),
(2589,	1743514128,	241143.41581063,	9),
(2590,	1743514188,	261924.487450112,	9),
(2591,	1743514188,	346.351193991374,	8),
(2592,	1743514188,	23.6903917960065,	7),
(2593,	1743514248,	23.6845287660794,	7),
(2594,	1743514248,	282167.920645943,	9),
(2595,	1743514248,	337.390553263846,	8),
(2596,	1743514308,	302978.552808901,	9),
(2597,	1743514308,	23.127404326676,	7),
(2598,	1743514308,	346.843869382631,	8),
(2599,	1743514368,	22.3079946579033,	7),
(2600,	1743514368,	342.963213788746,	8),
(2601,	1743514368,	323556.345636226,	9),
(2602,	1743514428,	344712.432969375,	9),
(2603,	1743514428,	352.601455552491,	8),
(2604,	1743514428,	22.4095257030243,	7),
(2605,	1743514488,	365890.366120374,	9),
(2606,	1743514488,	22.5924051886568,	7),
(2607,	1743514488,	352.965552516646,	8),
(2608,	1743514548,	387990.611127623,	9),
(2609,	1743514548,	21.7623336912371,	7),
(2610,	1743514548,	368.337416787478,	8),
(2611,	1743514608,	411159.753693689,	9),
(2612,	1743514608,	22.1079406274988,	7),
(2613,	1743514608,	386.152376101099,	8),
(2614,	1743514668,	435139.427061316,	9),
(2615,	1743514668,	399.66122279379,	8),
(2616,	1743514668,	22.315421661747,	7),
(2617,	1743514728,	458593.540764876,	9),
(2618,	1743514728,	390.901895059333,	8),
(2619,	1743514728,	21.7606456863631,	7),
(2620,	1743514788,	397.238678700419,	8),
(2621,	1743514788,	21.1125873247721,	7),
(2622,	1743514788,	482427.861486901,	9),
(2623,	1743514848,	21.8985199437855,	7),
(2624,	1743514848,	378.415901383316,	8),
(2625,	1743514848,	505132.8155699,	9),
(2626,	1743514908,	22.6524901984193,	7),
(2627,	1743514908,	528528.479554981,	9),
(2628,	1743514908,	389.92773308469,	8),
(2629,	1743514968,	23.1502648433823,	7),
(2630,	1743514968,	401.542037608945,	8),
(2631,	1743514968,	552621.001811518,	9),
(2632,	1743515028,	575551.988844225,	9),
(2633,	1743515028,	382.183117211773,	8),
(2634,	1743515028,	23.3232915521022,	7),
(2635,	1743515088,	393.482459845109,	8),
(2636,	1743515088,	23.8356049822586,	7),
(2637,	1743515088,	599160.936434931,	9),
(2638,	1743515148,	23.4489168655109,	7),
(2639,	1743515148,	385.937717887945,	8),
(2640,	1743515148,	622317.199508208,	9),
(2641,	1743515208,	646081.732470202,	9),
(2642,	1743515208,	24.1499914207285,	7),
(2643,	1743515208,	396.07554936657,	8),
(2644,	1743515268,	391.223749007002,	8),
(2645,	1743515268,	23.6944880132762,	7),
(2646,	1743515268,	669555.157410622,	9),
(2647,	1743515328,	692844.176884062,	9),
(2648,	1743515328,	23.1786684579447,	7),
(2649,	1743515328,	388.150324557331,	8),
(2650,	1743515388,	715973.733939805,	9),
(2651,	1743515388,	22.9091601912143,	7),
(2652,	1743515388,	385.49261759572,	8),
(2653,	1743515448,	22.7605391539355,	7),
(2654,	1743515448,	403.156820767486,	8),
(2655,	1743515448,	740163.143185854,	9),
(2656,	1743515508,	765448.869719507,	9),
(2657,	1743515508,	421.428775560874,	8),
(2658,	1743515508,	23.7410701131468,	7),
(2659,	1743515568,	22.9260006569516,	7),
(2660,	1743515568,	414.369932007211,	8),
(2661,	1743515568,	790311.065639939,	9),
(2662,	1743515628,	814282.8603872,	9),
(2663,	1743515628,	23.1663505240823,	7),
(2664,	1743515628,	399.529912454349,	8),
(2665,	1743515688,	838159.804987771,	9),
(2666,	1743515688,	23.6999357633995,	7),
(2667,	1743515688,	397.949076676184,	8),
(2668,	1743515748,	861400.416147397,	9),
(2669,	1743515748,	387.343519327099,	8),
(2670,	1743515748,	24.0572005982021,	7),
(2671,	1743515808,	883691.109035179,	9),
(2672,	1743515808,	371.511548129692,	8),
(2673,	1743515808,	24.1163469258319,	7),
(2674,	1743515868,	23.6978134691727,	7),
(2675,	1743515868,	906161.598690982,	9),
(2676,	1743515868,	374.508160930049,	8),
(2677,	1743515928,	927830.209240269,	9),
(2678,	1743515928,	23.959695981774,	7),
(2679,	1743515928,	361.143509154793,	8),
(2680,	1743515988,	949079.011496437,	9),
(2681,	1743515988,	354.14670426946,	8),
(2682,	1743515988,	24.3665583686601,	7),
(2683,	1743516048,	365.429337774487,	8),
(2684,	1743516048,	971004.771762906,	9),
(2685,	1743516048,	23.6548748934617,	7),
(2686,	1743516108,	24.3631895189262,	7),
(2687,	1743516108,	992556.670737249,	9),
(2688,	1743516108,	359.198316239043,	8),
(2689,	1743516168,	373.627381674132,	8),
(2690,	1743516168,	23.4978733900024,	7),
(2691,	1743516168,	1014974.3136377,	9),
(2692,	1743516228,	359.456204845971,	8),
(2693,	1743516228,	23.7960120755053,	7),
(2694,	1743516228,	1036541.68592846,	9),
(2695,	1743516288,	1057485.17750082,	9),
(2696,	1743516288,	349.05819287273,	8),
(2697,	1743516288,	23.6776322864134,	7),
(2698,	1743516348,	22.6808734717668,	7),
(2699,	1743516348,	333.898904515351,	8),
(2700,	1743516348,	1077519.11177174,	9),
(2701,	1743513409,	17202.0596811961,	6),
(2702,	1743513409,	286.700994686602,	5),
(2703,	1743513409,	20.230403008124,	4),
(2704,	1743513469,	291.965391781938,	5),
(2705,	1743513469,	20.3856948565159,	4),
(2706,	1743513469,	34719.9831881124,	6),
(2707,	1743513529,	293.505716491395,	5),
(2708,	1743513529,	52330.3261775962,	6),
(2709,	1743513529,	20.944031609911,	4),
(2710,	1743513589,	304.318730693983,	5),
(2711,	1743513589,	70589.4500192351,	6),
(2712,	1743513589,	20.9338725009721,	4),
(2713,	1743513649,	88179.098164356,	6),
(2714,	1743513649,	293.160802418682,	5),
(2715,	1743513649,	21.4045108600166,	4),
(2716,	1743513709,	22.2708185775928,	4),
(2717,	1743513709,	290.508614976328,	5),
(2718,	1743513709,	105609.615062936,	6),
(2719,	1743513769,	22.6692629100403,	4),
(2720,	1743513769,	123850.763530544,	6),
(2721,	1743513769,	304.019141126797,	5),
(2722,	1743513829,	23.1185458231213,	4),
(2723,	1743513829,	317.788126120791,	5),
(2724,	1743513829,	142918.051097791,	6),
(2725,	1743513889,	23.295872334488,	4),
(2726,	1743513889,	320.813916099632,	5),
(2727,	1743513889,	162166.886063769,	6),
(2728,	1743513949,	182171.024985016,	6),
(2729,	1743513949,	333.402315354114,	5),
(2730,	1743513949,	23.3284728378968,	4),
(2731,	1743514009,	203258.320551429,	6),
(2732,	1743514009,	24.0664423749073,	4),
(2733,	1743514009,	351.454926106892,	5),
(2734,	1743514069,	365.707740621412,	5),
(2735,	1743514069,	225200.784988714,	6),
(2736,	1743514069,	23.1075974616589,	4),
(2737,	1743514129,	248275.34040597,	6),
(2738,	1743514129,	384.575923620926,	5),
(2739,	1743514129,	23.1580258662805,	4),
(2740,	1743514189,	22.5694764707294,	4),
(2741,	1743514189,	271825.036870731,	6),
(2742,	1743514189,	392.494941079363,	5),
(2743,	1743514249,	21.855126715291,	4),
(2744,	1743514249,	404.465460339042,	5),
(2745,	1743514249,	296092.964491074,	6),
(2746,	1743514309,	321336.79775129,	6),
(2747,	1743514309,	420.730554336943,	5),
(2748,	1743514309,	20.8855136158461,	4),
(2749,	1743514369,	434.967283660394,	5),
(2750,	1743514369,	21.6782234921091,	4),
(2751,	1743514369,	347434.834770914,	6),
(2752,	1743514429,	372516.165039087,	6),
(2753,	1743514429,	418.022171136215,	5),
(2754,	1743514429,	21.3810266654871,	4),
(2755,	1743514489,	397073.002680779,	6),
(2756,	1743514489,	409.280627361536,	5),
(2757,	1743514489,	21.3185013218348,	4),
(2758,	1743514549,	421603.169468009,	6),
(2759,	1743514549,	408.836113120495,	5),
(2760,	1743514549,	21.5403153120056,	4),
(2761,	1743514609,	420.825548701353,	5),
(2762,	1743514609,	446852.70239009,	6),
(2763,	1743514609,	20.6484948007861,	4),
(2764,	1743514669,	471474.660177026,	6),
(2765,	1743514669,	410.365963115593,	5),
(2766,	1743514669,	19.6804843172778,	4),
(2767,	1743514729,	19.9461429394738,	4),
(2768,	1743514729,	403.963991119861,	5),
(2769,	1743514729,	495712.499644217,	6),
(2770,	1743514789,	520099.97954011,	6),
(2771,	1743514789,	406.457998264881,	5),
(2772,	1743514789,	19.6500897054627,	4),
(2773,	1743514849,	543792.980163772,	6),
(2774,	1743514849,	394.883343727689,	5),
(2775,	1743514849,	19.950836017742,	4),
(2776,	1743514909,	19.9307697673299,	4),
(2777,	1743514909,	395.648590107244,	5),
(2778,	1743514909,	567531.895570206,	6),
(2779,	1743514969,	590623.256724145,	6),
(2780,	1743514969,	19.0893940280497,	4),
(2781,	1743514969,	384.85601923232,	5),
(2782,	1743515029,	18.5928998969014,	4),
(2783,	1743515029,	373.658199228234,	5),
(2784,	1743515029,	613042.74867784,	6),
(2785,	1743515089,	18.7925594066848,	4),
(2786,	1743515089,	636615.90397049,	6),
(2787,	1743515089,	392.885921544176,	5),
(2788,	1743515149,	19.3049665770037,	4),
(2789,	1743515149,	394.116745583603,	5),
(2790,	1743515149,	660262.908705506,	6),
(2791,	1743515209,	384.94068179801,	5),
(2792,	1743515209,	18.8935080644921,	4),
(2793,	1743515209,	683359.349613387,	6),
(2794,	1743515269,	706541.307951944,	6),
(2795,	1743515269,	386.365972309286,	5),
(2796,	1743515269,	18.6457945650727,	4),
(2797,	1743515329,	19.2840876947691,	4),
(2798,	1743515329,	730844.135880731,	6),
(2799,	1743515329,	405.047132146448,	5),
(2800,	1743515389,	754147.88372959,	6),
(2801,	1743515389,	19.9439811053433,	4),
(2802,	1743515389,	388.395797480987,	5),
(2803,	1743515449,	19.9269774116935,	4),
(2804,	1743515449,	777667.68848975,	6),
(2805,	1743515449,	391.996746002658,	5),
(2806,	1743515509,	20.3948918400543,	4),
(2807,	1743515509,	800997.113989194,	6),
(2808,	1743515509,	388.823758324078,	5),
(2809,	1743515569,	386.76762546942,	5),
(2810,	1743515569,	824203.17151736,	6),
(2811,	1743515569,	19.6077295990163,	4),
(2812,	1743515629,	376.819267254,	5),
(2813,	1743515629,	18.9073555786142,	4),
(2814,	1743515629,	846812.3275526,	6),
(2815,	1743515689,	869763.53347955,	6),
(2816,	1743515689,	19.0847023845365,	4),
(2817,	1743515689,	382.520098782513,	5),
(2818,	1743515749,	18.6347583772072,	4),
(2819,	1743515749,	385.507747469843,	5),
(2820,	1743515749,	892893.998327741,	6),
(2821,	1743515809,	917113.845941401,	6),
(2822,	1743515809,	403.664126894339,	5),
(2823,	1743515809,	19.1822205354395,	4),
(2824,	1743515869,	940823.662983147,	6),
(2825,	1743515869,	19.0735819309565,	4),
(2826,	1743515869,	395.163617362433,	5),
(2827,	1743515929,	395.528423333833,	5),
(2828,	1743515929,	964555.368383177,	6),
(2829,	1743515929,	19.497912602693,	4),
(2830,	1743515989,	989150.307346955,	6),
(2831,	1743515989,	409.915649396299,	5),
(2832,	1743515989,	18.5915575950212,	4),
(2833,	1743516049,	19.3840643213261,	4),
(2834,	1743516049,	394.083594282077,	5),
(2835,	1743516049,	1012795.32300388,	6),
(2836,	1743516109,	388.243408531065,	5),
(2837,	1743516109,	19.9025145078631,	4),
(2838,	1743516109,	1036089.92751574,	6),
(2839,	1743516169,	20.3400003642692,	4),
(2840,	1743516169,	378.484552955119,	5),
(2841,	1743516169,	1058799.00069305,	6),
(2842,	1743516229,	1081943.35683645,	6),
(2843,	1743516229,	20.9606886488737,	4),
(2844,	1743516229,	385.739269056685,	5),
(2845,	1743516289,	1104767.42345959,	6),
(2846,	1743516289,	20.5429610855504,	4),
(2847,	1743516289,	380.401110385584,	5),
(2848,	1743516349,	1127024.23967559,	6),
(2849,	1743516349,	370.946936933344,	5),
(2850,	1743516349,	20.6287290764565,	4),
(2851,	1743513409,	18885.1749766717,	12),
(2852,	1743513409,	314.752916277861,	11),
(2853,	1743513409,	20.9449473987401,	10),
(2854,	1743513469,	37072.2263926812,	12),
(2855,	1743513469,	21.277160655841,	10),
(2856,	1743513469,	303.117523600159,	11),
(2857,	1743513529,	317.578380855272,	11),
(2858,	1743513529,	56126.9292439975,	12),
(2859,	1743513529,	21.4561266615307,	10),
(2860,	1743513589,	325.470451733763,	11),
(2861,	1743513589,	20.4821966670086,	10),
(2862,	1743513589,	75655.1563480233,	12),
(2863,	1743513649,	21.2123794313381,	10),
(2864,	1743513649,	95260.5752791713,	12),
(2865,	1743513649,	326.7569821858,	11),
(2866,	1743513709,	114905.720152393,	12),
(2867,	1743513709,	21.1942989324128,	10),
(2868,	1743513709,	327.41908122037,	11),
(2869,	1743513769,	332.213295576573,	11),
(2870,	1743513769,	20.2236646274896,	10),
(2871,	1743513769,	134838.517886988,	12),
(2872,	1743513829,	19.5899948497043,	10),
(2873,	1743513829,	155014.279249666,	12),
(2874,	1743513829,	336.262689377964,	11),
(2875,	1743513889,	327.245022440893,	11),
(2876,	1743513889,	20.2262226392606,	10),
(2877,	1743513889,	174648.980596119,	12),
(2878,	1743513949,	195423.571143363,	12),
(2879,	1743513949,	19.6993193049816,	10),
(2880,	1743513949,	346.243175787394,	11),
(2881,	1743514009,	363.550326919819,	11),
(2882,	1743514009,	217236.590758552,	12),
(2883,	1743514009,	20.1600881262879,	10),
(2884,	1743514069,	239582.434232001,	12),
(2885,	1743514069,	372.430724557489,	11),
(2886,	1743514069,	19.6657169628599,	10),
(2887,	1743514129,	362.339228875327,	11),
(2888,	1743514129,	20.1757037714065,	10),
(2889,	1743514129,	261322.787964521,	12),
(2890,	1743514189,	19.9560755034717,	10),
(2891,	1743514189,	361.594893326155,	11),
(2892,	1743514189,	283018.48156409,	12),
(2893,	1743514249,	369.18933689592,	11),
(2894,	1743514249,	20.698859611407,	10),
(2895,	1743514249,	305169.841777846,	12),
(2896,	1743514309,	368.625967332779,	11),
(2897,	1743514309,	327287.399817812,	12),
(2898,	1743514309,	20.2550096086667,	10),
(2899,	1743514369,	19.8181674764951,	10),
(2900,	1743514369,	348588.928158273,	12),
(2901,	1743514369,	355.025472341003,	11),
(2902,	1743514429,	349.173460196275,	11),
(2903,	1743514429,	369539.335770049,	12),
(2904,	1743514429,	19.1160154753936,	10),
(2905,	1743514489,	19.3575468145729,	10),
(2906,	1743514489,	391332.089001206,	12),
(2907,	1743514489,	363.212553852611,	11),
(2908,	1743514549,	370.41132409234,	11),
(2909,	1743514549,	18.9563991273215,	10),
(2910,	1743514549,	413556.768446746,	12),
(2911,	1743514609,	18.0827463166789,	10),
(2912,	1743514609,	375.751650198736,	11),
(2913,	1743514609,	436101.86745867,	12),
(2914,	1743514669,	394.722733892982,	11),
(2915,	1743514669,	17.2979440396879,	10),
(2916,	1743514669,	459785.231492249,	12),
(2917,	1743514729,	483332.842421262,	12),
(2918,	1743514729,	392.460182150205,	11),
(2919,	1743514729,	18.1907546412278,	10),
(2920,	1743514789,	17.8961294467859,	10),
(2921,	1743514789,	398.121225693802,	11),
(2922,	1743514789,	507220.11596289,	12),
(2923,	1743514849,	531118.056746729,	12),
(2924,	1743514849,	17.1690636655923,	10),
(2925,	1743514849,	398.299013063984,	11),
(2926,	1743514909,	398.88953849208,	11),
(2927,	1743514909,	555051.429056254,	12),
(2928,	1743514909,	17.192335548926,	10),
(2929,	1743514969,	17.9131395825617,	10),
(2930,	1743514969,	408.181531030731,	11),
(2931,	1743514969,	579542.320918097,	12),
(2932,	1743515029,	16.9908800887354,	10),
(2933,	1743515029,	424.722663361664,	11),
(2934,	1743515029,	605025.680719797,	12),
(2935,	1743515089,	630115.448739672,	12),
(2936,	1743515089,	16.280130182315,	10),
(2937,	1743515089,	418.162800331246,	11),
(2938,	1743515149,	16.030918701861,	10),
(2939,	1743515149,	411.107420947942,	11),
(2940,	1743515149,	654781.893996549,	12),
(2941,	1743515209,	679343.523383697,	12),
(2942,	1743515209,	15.6597904619913,	10),
(2943,	1743515209,	409.36048978581,	11),
(2944,	1743515269,	15.8172112419558,	10),
(2945,	1743515269,	704078.961899252,	12),
(2946,	1743515269,	412.257308592586,	11),
(2947,	1743515329,	729207.172565423,	12),
(2948,	1743515329,	15.2848437634298,	10),
(2949,	1743515329,	418.803511102841,	11),
(2950,	1743515389,	755076.076703549,	12),
(2951,	1743515389,	14.3185070122418,	10),
(2952,	1743515389,	431.148402302108,	11),
(2953,	1743515449,	780404.427055837,	12),
(2954,	1743515449,	422.139172538128,	11),
(2955,	1743515449,	13.5075128511148,	10),
(2956,	1743515509,	429.569793253903,	11),
(2957,	1743515509,	13.5628349085216,	10),
(2958,	1743515509,	806178.614651071,	12),
(2959,	1743515569,	13.7617533973624,	10),
(2960,	1743515569,	832533.922777679,	12),
(2961,	1743515569,	439.255135443459,	11),
(2962,	1743515629,	455.110310609894,	11),
(2963,	1743515629,	859840.541414273,	12),
(2964,	1743515629,	14.3802968234964,	10),
(2965,	1743515689,	14.0367999308811,	10),
(2966,	1743515689,	467.888574214609,	11),
(2967,	1743515689,	887913.855867149,	12),
(2968,	1743515749,	916242.99021368,	12),
(2969,	1743515749,	472.152239108842,	11),
(2970,	1743515749,	14.1910582749875,	10),
(2971,	1743515809,	945325.091401455,	12),
(2972,	1743515809,	484.701686462922,	11),
(2973,	1743515809,	15.0319968241149,	10),
(2974,	1743515869,	974169.027500663,	12),
(2975,	1743515869,	480.732268320127,	11),
(2976,	1743515869,	14.434105824786,	10),
(2977,	1743515929,	500,	11),
(2978,	1743515929,	1004169.02750066,	12),
(2979,	1743515929,	14.3705266570958,	10),
(2980,	1743515989,	1033116.63024083,	12),
(2981,	1743515989,	13.6059979125288,	10),
(2982,	1743515989,	482.460045669486,	11),
(2983,	1743516049,	12.9455721870934,	10),
(2984,	1743516049,	469.158290565868,	11),
(2985,	1743516049,	1061266.12767478,	12),
(2986,	1743516109,	1090333.47942907,	12),
(2987,	1743516109,	484.455862571463,	11),
(2988,	1743516109,	12.5532748381337,	10),
(2989,	1743516169,	481.796419958878,	11),
(2990,	1743516169,	1119241.2646266,	12),
(2991,	1743516169,	13.2816517354686,	10),
(2992,	1743516229,	13.2624122555915,	10),
(2993,	1743516229,	471.379344959586,	11),
(2994,	1743516229,	1147524.02532418,	12),
(2995,	1743516289,	1175827.13522828,	12),
(2996,	1743516289,	471.71849840163,	11),
(2997,	1743516289,	13.3413538492939,	10),
(2998,	1743516349,	484.974884528573,	11),
(2999,	1743516349,	13.5422052221155,	10),
(3000,	1743516349,	1204925.62829999,	12),
(3001,	1743513410,	20.5762571963964,	13),
(3002,	1743513410,	288.511899978953,	14),
(3003,	1743513410,	17310.7139987372,	15),
(3004,	1743513470,	19.7780445944167,	13),
(3005,	1743513470,	34235.2451664767,	15),
(3006,	1743513470,	282.075519462325,	14),
(3007,	1743513530,	19.7153076075825,	13),
(3008,	1743513530,	278.378453776518,	14),
(3009,	1743513530,	50937.9523930677,	15),
(3010,	1743513590,	67051.8858233861,	15),
(3011,	1743513590,	268.565557171974,	14),
(3012,	1743513590,	19.8605498131622,	13),
(3013,	1743513650,	18.9099424513921,	13),
(3014,	1743513650,	82666.183585171,	15),
(3015,	1743513650,	260.238296029747,	14),
(3016,	1743513710,	251.403223266894,	14),
(3017,	1743513710,	97750.3769811846,	15),
(3018,	1743513710,	19.558055766955,	13),
(3019,	1743513770,	18.583046125507,	13),
(3020,	1743513770,	265.399623136178,	14),
(3021,	1743513770,	113674.354369355,	15),
(3022,	1743513830,	128400.764693962,	15),
(3023,	1743513830,	18.1837606216457,	13),
(3024,	1743513830,	245.44017207678,	14),
(3025,	1743513890,	142524.103938306,	15),
(3026,	1743513890,	235.388987405739,	14),
(3027,	1743513890,	17.9655293636564,	13),
(3028,	1743513950,	236.70892452299,	14),
(3029,	1743513950,	156726.639409686,	15),
(3030,	1743513950,	17.7110659003658,	13),
(3031,	1743514010,	222.822342628104,	14),
(3032,	1743514010,	170095.979967372,	15),
(3033,	1743514010,	16.7928071567228,	13),
(3034,	1743514070,	16.457638557051,	13),
(3035,	1743514070,	219.017663315165,	14),
(3036,	1743514070,	183237.039766282,	15),
(3037,	1743514130,	209.076469495006,	14),
(3038,	1743514130,	195781.627935982,	15),
(3039,	1743514130,	17.053468176239,	13),
(3040,	1743514190,	200.704056771145,	14),
(3041,	1743514190,	17.1697572150465,	13),
(3042,	1743514190,	207823.871342251,	15),
(3043,	1743514250,	220519.242941103,	15),
(3044,	1743514250,	211.589526647537,	14),
(3045,	1743514250,	16.1783687284383,	13),
(3046,	1743514310,	194.85171160578,	14),
(3047,	1743514310,	232210.34563745,	15),
(3048,	1743514310,	15.937961733473,	13),
(3049,	1743514370,	243646.60608974,	15),
(3050,	1743514370,	190.604340871509,	14),
(3051,	1743514370,	16.3754009504272,	13),
(3052,	1743514430,	186.89054059181,	14),
(3053,	1743514430,	254860.038525249,	15),
(3054,	1743514430,	16.6080571082048,	13),
(3055,	1743514490,	266712.65137221,	15),
(3056,	1743514490,	16.1204831426388,	13),
(3057,	1743514490,	197.543547449349,	14),
(3058,	1743514550,	215.760620972462,	14),
(3059,	1743514550,	279658.288630558,	15),
(3060,	1743514550,	16.3853362448608,	13),
(3061,	1743514610,	15.7338987722859,	13),
(3062,	1743514610,	293306.595817401,	15),
(3063,	1743514610,	227.471786447385,	14),
(3064,	1743514670,	307779.678817335,	15),
(3065,	1743514670,	14.7894806745534,	13),
(3066,	1743514670,	241.218049998897,	14),
(3067,	1743514730,	258.756910328452,	14),
(3068,	1743514730,	323305.093437042,	15),
(3069,	1743514730,	14.1279712730396,	13),
(3070,	1743514790,	14.6279746556062,	13),
(3071,	1743514790,	339679.145133183,	15),
(3072,	1743514790,	272.900861602351,	14),
(3073,	1743514850,	256.589527304159,	14),
(3074,	1743514850,	355074.516771432,	15),
(3075,	1743514850,	14.8322033548015,	13),
(3076,	1743514910,	14.8420251556033,	13),
(3077,	1743514910,	370611.710325902,	15),
(3078,	1743514910,	258.953225907835,	14),
(3079,	1743514970,	275.958175732552,	14),
(3080,	1743514970,	14.9104323644952,	13),
(3081,	1743514970,	387169.200869856,	15),
(3082,	1743515030,	15.5659182676724,	13),
(3083,	1743515030,	265.826975761944,	14),
(3084,	1743515030,	403118.819415572,	15),
(3085,	1743515090,	256.506052797063,	14),
(3086,	1743515090,	15.0062573657475,	13),
(3087,	1743515090,	418509.182583396,	15),
(3088,	1743515150,	432839.637419486,	15),
(3089,	1743515150,	14.1534635324232,	13),
(3090,	1743515150,	238.840913934835,	14),
(3091,	1743515210,	447774.504883101,	15),
(3092,	1743515210,	15.1129789744137,	13),
(3093,	1743515210,	248.914457726921,	14),
(3094,	1743515270,	463835.329728256,	15),
(3095,	1743515270,	15.8886767353707,	13),
(3096,	1743515270,	267.680414085916,	14),
(3097,	1743515330,	15.3875593615716,	13),
(3098,	1743515330,	480789.407426497,	15),
(3099,	1743515330,	282.567961637345,	14),
(3100,	1743515390,	15.2371358853608,	13),
(3101,	1743515390,	264.762500738616,	14),
(3102,	1743515390,	496675.157470814,	15),
(3103,	1743515450,	512860.566740542,	15),
(3104,	1743515450,	269.756821162137,	14),
(3105,	1743515450,	15.0396580223922,	13),
(3106,	1743515510,	249.774893032153,	14),
(3107,	1743515510,	15.4345074594196,	13),
(3108,	1743515510,	527847.060322471,	15),
(3109,	1743515570,	235.063248576034,	14),
(3110,	1743515570,	15.6516280159814,	13),
(3111,	1743515570,	541950.855237033,	15),
(3112,	1743515630,	557144.141049226,	15),
(3113,	1743515630,	16.5745848275531,	13),
(3114,	1743515630,	253.221430203218,	14),
(3115,	1743515690,	272.359907728152,	14),
(3116,	1743515690,	573485.735512916,	15),
(3117,	1743515690,	16.8484670521115,	13),
(3118,	1743515750,	590163.985739585,	15),
(3119,	1743515750,	277.970837111166,	14),
(3120,	1743515750,	17.7758071253299,	13),
(3121,	1743515810,	278.521352832844,	14),
(3122,	1743515810,	606875.266909556,	15),
(3123,	1743515810,	18.6631107794042,	13),
(3124,	1743515870,	18.0976337409608,	13),
(3125,	1743515870,	263.110974138844,	14),
(3126,	1743515870,	622661.925357887,	15),
(3127,	1743515930,	637362.652734889,	15),
(3128,	1743515930,	18.8571266726372,	13),
(3129,	1743515930,	245.012122950035,	14),
(3130,	1743515990,	18.2713383402222,	13),
(3131,	1743515990,	652444.04295722,	15),
(3132,	1743515990,	251.356503705513,	14),
(3133,	1743516050,	667952.171904628,	15),
(3134,	1743516050,	17.4848226722044,	13),
(3135,	1743516050,	258.468815790143,	14),
(3136,	1743516110,	17.6287552998778,	13),
(3137,	1743516110,	242.344347013593,	14),
(3138,	1743516110,	682492.832725444,	15),
(3139,	1743516170,	696997.095272161,	15),
(3140,	1743516170,	17.7550191781673,	13),
(3141,	1743516170,	241.73770911195,	14),
(3142,	1743516230,	18.4822640767786,	13),
(3143,	1743516230,	710909.796044664,	15),
(3144,	1743516230,	231.878346208391,	14),
(3145,	1743516290,	250.06434936216,	14),
(3146,	1743516290,	18.3742495739084,	13),
(3147,	1743516290,	725913.657006394,	15),
(3148,	1743516350,	18.2548271191335,	13),
(3149,	1743516350,	244.052219593122,	14),
(3150,	1743516350,	740556.790181981,	15),
(3151,	1743513410,	18702.2885036753,	18),
(3152,	1743513410,	21.4181259732752,	16),
(3153,	1743513410,	311.704808394588,	17),
(3154,	1743513470,	327.635991189345,	17),
(3155,	1743513470,	38360.4479750359,	18),
(3156,	1743513470,	21.2503850896803,	16),
(3157,	1743513530,	58587.0448491705,	18),
(3158,	1743513530,	21.2924746527212,	16),
(3159,	1743513530,	337.109947902243,	17),
(3160,	1743513590,	319.125519755034,	17),
(3161,	1743513590,	21.0107964881623,	16),
(3162,	1743513590,	77734.5760344726,	18),
(3163,	1743513650,	322.644171455969,	17),
(3164,	1743513650,	21.963837442292,	16),
(3165,	1743513650,	97093.2263218307,	18),
(3166,	1743513710,	22.1770162505078,	16),
(3167,	1743513710,	319.047718837858,	17),
(3168,	1743513710,	116236.089452102,	18),
(3169,	1743513770,	135221.600005966,	18),
(3170,	1743513770,	316.425175897727,	17),
(3171,	1743513770,	21.3905257881769,	16),
(3172,	1743513830,	21.6898132223488,	16),
(3173,	1743513830,	298.371888014997,	17),
(3174,	1743513830,	153123.913286866,	18),
(3175,	1743513890,	317.231536836376,	17),
(3176,	1743513890,	22.4873876864988,	16),
(3177,	1743513890,	172157.805497048,	18),
(3178,	1743513950,	330.120725308905,	17),
(3179,	1743513950,	191965.049015583,	18),
(3180,	1743513950,	21.5458169567872,	16),
(3181,	1743514010,	212701.059103109,	18),
(3182,	1743514010,	21.7430217125743,	16),
(3183,	1743514010,	345.600168125446,	17),
(3184,	1743514070,	21.9012720765197,	16),
(3185,	1743514070,	330.582593252656,	17),
(3186,	1743514070,	232536.014698269,	18),
(3187,	1743514130,	252416.379172776,	18),
(3188,	1743514130,	20.9968673471659,	16),
(3189,	1743514130,	331.339407908459,	17),
(3190,	1743514190,	21.3080912150619,	16),
(3191,	1743514190,	273237.168426961,	18),
(3192,	1743514190,	347.013154236417,	17),
(3193,	1743514250,	342.095566870168,	17),
(3194,	1743514250,	293762.902439171,	18),
(3195,	1743514250,	20.6741952273024,	16),
(3196,	1743514310,	313128.464532914,	18),
(3197,	1743514310,	322.759368229047,	17),
(3198,	1743514310,	20.0734051046218,	16),
(3199,	1743514370,	329.361254113005,	17),
(3200,	1743514370,	332890.139779694,	18),
(3201,	1743514370,	19.3010679225173,	16),
(3202,	1743514430,	18.486373433772,	16),
(3203,	1743514430,	352232.469118261,	18),
(3204,	1743514430,	322.372155642768,	17),
(3205,	1743514490,	371909.764350041,	18),
(3206,	1743514490,	327.954920529678,	17),
(3207,	1743514490,	18.2586716676751,	16),
(3208,	1743514550,	345.047946411348,	17),
(3209,	1743514550,	17.8343640851857,	16),
(3210,	1743514550,	392612.641134722,	18),
(3211,	1743514610,	345.03278906533,	17),
(3212,	1743514610,	413314.608478642,	18),
(3213,	1743514610,	17.1120298184169,	16),
(3214,	1743514670,	432943.842119653,	18),
(3215,	1743514670,	17.3597341750509,	16),
(3216,	1743514670,	327.153894016852,	17),
(3217,	1743514730,	18.0869996663136,	16),
(3218,	1743514730,	452600.844371982,	18),
(3219,	1743514730,	327.616704205481,	17),
(3220,	1743514790,	326.146707316289,	17),
(3221,	1743514790,	17.2133538935899,	16),
(3222,	1743514790,	472169.646810959,	18),
(3223,	1743514850,	491125.712880524,	18),
(3224,	1743514850,	315.934434492754,	17),
(3225,	1743514850,	16.9966278653072,	16),
(3226,	1743514910,	301.390848691002,	17),
(3227,	1743514910,	16.6667027770167,	16),
(3228,	1743514910,	509209.163801985,	18),
(3229,	1743514970,	16.7583936072173,	16),
(3230,	1743514970,	526373.517108809,	18),
(3231,	1743514970,	286.072555113748,	17),
(3232,	1743515030,	16.9758371608671,	16),
(3233,	1743515030,	542856.613914865,	18),
(3234,	1743515030,	274.71828010092,	17),
(3235,	1743515090,	560378.791368379,	18),
(3236,	1743515090,	17.222603946537,	16),
(3237,	1743515090,	292.036290891898,	17),
(3238,	1743515150,	277.548986758358,	17),
(3239,	1743515150,	17.9727789331413,	16),
(3240,	1743515150,	577031.73057388,	18),
(3241,	1743515210,	286.795561256012,	17),
(3242,	1743515210,	594239.464249241,	18),
(3243,	1743515210,	17.9742219874827,	16),
(3244,	1743515270,	17.3179082222864,	16),
(3245,	1743515270,	284.509180617824,	17),
(3246,	1743515270,	611310.01508631,	18),
(3247,	1743515330,	17.700707411858,	16),
(3248,	1743515330,	266.771946607252,	17),
(3249,	1743515330,	627316.331882745,	18),
(3250,	1743515390,	642210.875294574,	18),
(3251,	1743515390,	18.0057554274962,	16),
(3252,	1743515390,	248.242390197146,	17),
(3253,	1743515450,	256.987426077766,	17),
(3254,	1743515450,	17.2620268875731,	16),
(3255,	1743515450,	657630.12085924,	18),
(3256,	1743515510,	259.0075701997,	17),
(3257,	1743515510,	17.801183293976,	16),
(3258,	1743515510,	673170.575071222,	18),
(3259,	1743515570,	247.252457116237,	17),
(3260,	1743515570,	18.3808527433455,	16),
(3261,	1743515570,	688005.722498196,	18),
(3262,	1743515630,	18.4183253799877,	16),
(3263,	1743515630,	228.197912544726,	17),
(3264,	1743515630,	701697.59725088,	18),
(3265,	1743515690,	18.5161101091353,	16),
(3266,	1743515690,	714646.697863868,	18),
(3267,	1743515690,	215.818343549812,	17),
(3268,	1743515750,	209.594210663973,	17),
(3269,	1743515750,	727222.350503707,	18),
(3270,	1743515750,	19.0658050754673,	16),
(3271,	1743515810,	740923.759765232,	18),
(3272,	1743515810,	228.356821025425,	17),
(3273,	1743515810,	19.6164551782563,	16),
(3274,	1743515870,	19.093696484436,	16),
(3275,	1743515870,	755233.006600445,	18),
(3276,	1743515870,	238.487447253541,	17),
(3277,	1743515930,	229.458402991858,	17),
(3278,	1743515930,	769000.510779956,	18),
(3279,	1743515930,	18.6969711523947,	16),
(3280,	1743515990,	18.5154099243504,	16),
(3281,	1743515990,	219.266682810336,	17),
(3282,	1743515990,	782156.511748576,	18),
(3283,	1743516050,	223.560273405896,	17),
(3284,	1743516050,	795570.12815293,	18),
(3285,	1743516050,	18.167354680883,	16),
(3286,	1743516110,	809920.350843313,	18),
(3287,	1743516110,	17.7661846259631,	16),
(3288,	1743516110,	239.170378173043,	17),
(3289,	1743516170,	224.824360625027,	17),
(3290,	1743516170,	18.188131430766,	16),
(3291,	1743516170,	823409.812480814,	18),
(3292,	1743516230,	242.141968401504,	17),
(3293,	1743516230,	837938.330584905,	18),
(3294,	1743516230,	17.8241536411844,	16),
(3295,	1743516290,	233.486738041195,	17),
(3296,	1743516290,	851947.534867376,	18),
(3297,	1743516290,	18.6679872105112,	16),
(3298,	1743516350,	214.613796543556,	17),
(3299,	1743516350,	19.3850097042048,	16),
(3300,	1743516350,	864824.36265999,	18);

DROP TABLE IF EXISTS "ev_charger";
CREATE TABLE "public"."ev_charger" (
    "id" integer NOT NULL,
    "maxamp" double precision,
    "connector_type" character varying(255),
    "voltage" integer,
    CONSTRAINT "ev_charger_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

TRUNCATE "ev_charger";
INSERT INTO "ev_charger" ("id", "maxamp", "connector_type", "voltage") VALUES
(3,	10,	'type 1',	220),
(4,	20,	'type 2',	380);

DROP TABLE IF EXISTS "grid";
DROP SEQUENCE IF EXISTS grid_id_seq;
CREATE SEQUENCE grid_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 START 2;

CREATE TABLE "public"."grid" (
    "id" integer DEFAULT nextval('grid_id_seq') NOT NULL,
    "description" character varying(255),
    "name" character varying(255),
    CONSTRAINT "grid_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

TRUNCATE "grid";
INSERT INTO "grid" ("id", "description", "name") VALUES
(1,	'smart grid du quartier de la Chantrerie',	'La Chantrerie');

DROP TABLE IF EXISTS "measurement";
DROP SEQUENCE IF EXISTS measurement_id_seq;
CREATE SEQUENCE measurement_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 START 19;

CREATE TABLE "public"."measurement" (
    "id" integer DEFAULT nextval('measurement_id_seq') NOT NULL,
    "name" character varying(255),
    "unit" character varying(255),
    "sensor" integer,
    CONSTRAINT "measurement_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

TRUNCATE "measurement";
INSERT INTO "measurement" ("id", "name", "unit", "sensor") VALUES
(1,	'temperature',	'C°',	1),
(2,	'power',	'W',	1),
(3,	'total_energy_produced',	'Wh',	1),
(4,	'speed',	'rpm',	2),
(5,	'power',	'W',	2),
(6,	'total_energy_produced',	'Wh',	2),
(7,	'temperature',	'C°',	5),
(8,	'power',	'W',	5),
(9,	'total_energy_produced',	'Wh',	5),
(10,	'speed',	'rpm',	6),
(11,	'power',	'W',	6),
(12,	'total_energy_produced',	'Wh',	6),
(13,	'temperature',	'C°',	3),
(14,	'power',	'W',	3),
(15,	'total_energy_consumed',	'Wh',	3),
(16,	'temperature',	'C°',	4),
(17,	'power',	'W',	4),
(18,	'total_energy_consumed',	'Wh',	4);

DROP TABLE IF EXISTS "person";
DROP SEQUENCE IF EXISTS person_id_seq;
CREATE SEQUENCE person_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 START 3;

CREATE TABLE "public"."person" (
    "id" integer DEFAULT nextval('person_id_seq') NOT NULL,
    "firstname" character varying(255),
    "lastname" character varying(255),
    "grid" integer,
    CONSTRAINT "person_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

TRUNCATE "person";
INSERT INTO "person" ("id", "firstname", "lastname", "grid") VALUES
(1,	'George',	'Abitbol',	1),
(2,	'Pétère',	NULL,	1);

DROP TABLE IF EXISTS "person_sensor";
CREATE TABLE "public"."person_sensor" (
    "person_id" integer NOT NULL,
    "sensor_id" integer NOT NULL,
    CONSTRAINT "person_sensor_pkey" PRIMARY KEY ("person_id", "sensor_id")
) WITH (oids = false);

TRUNCATE "person_sensor";
INSERT INTO "person_sensor" ("person_id", "sensor_id") VALUES
(1,	1),
(1,	2),
(2,	2);

DROP TABLE IF EXISTS "producer";
CREATE TABLE "public"."producer" (
    "id" integer NOT NULL,
    "power_source" character varying(255),
    CONSTRAINT "producer_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

TRUNCATE "producer";
INSERT INTO "producer" ("id", "power_source") VALUES
(1,	'solar'),
(2,	'wind'),
(5,	'solar'),
(6,	'wind');

DROP TABLE IF EXISTS "sensor";
DROP SEQUENCE IF EXISTS sensor_id_seq;
CREATE SEQUENCE sensor_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 START 7;

CREATE TABLE "public"."sensor" (
    "id" integer DEFAULT nextval('sensor_id_seq') NOT NULL,
    "dtype" character varying(31),
    "description" character varying(255),
    "name" character varying(255),
    "grid" integer,
    CONSTRAINT "sensor_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

TRUNCATE "sensor";
INSERT INTO "sensor" ("id", "dtype", "description", "name", "grid") VALUES
(1,	'SolarPanel',	'une description',	'panneau solaire 1',	1),
(2,	'WindTurbine',	'l''éolienne à côté de Polytech',	'Éolienne 1',	1),
(3,	'EVCharger',	'un chargeur de voiture',	'chargeur 1',	1),
(4,	'EVCharger',	'un autre chargeur de voitures',	'Chargeur 2',	1),
(5,	'SolarPanel',	'le panneau solaire chez moi',	'panneau solaire 2',	1),
(6,	'WindTurbine',	'l''éolienne à côté de Londres',	'Éolienne 2',	1);

DROP TABLE IF EXISTS "solar_panel";
CREATE TABLE "public"."solar_panel" (
    "id" integer NOT NULL,
    "efficiency" double precision,
    CONSTRAINT "solar_panel_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

TRUNCATE "solar_panel";
INSERT INTO "solar_panel" ("id", "efficiency") VALUES
(1,	90),
(5,	95);

DROP TABLE IF EXISTS "wind_turbine";
CREATE TABLE "public"."wind_turbine" (
    "id" integer NOT NULL,
    "height" double precision,
    "bladelength" double precision,
    CONSTRAINT "wind_turbine_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

TRUNCATE "wind_turbine";
INSERT INTO "wind_turbine" ("id", "height", "bladelength") VALUES
(2,	30,	10),
(6,	40,	20);

ALTER TABLE ONLY "public"."consumer" ADD CONSTRAINT "consumer_id_fkey" FOREIGN KEY (id) REFERENCES sensor(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."datapoint" ADD CONSTRAINT "fk_datapoint_measurement" FOREIGN KEY (measurement) REFERENCES measurement(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."ev_charger" ADD CONSTRAINT "ev_charger_id_fkey" FOREIGN KEY (id) REFERENCES consumer(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."measurement" ADD CONSTRAINT "fk_measurement_sensor" FOREIGN KEY (sensor) REFERENCES sensor(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."person" ADD CONSTRAINT "fk_person_grid" FOREIGN KEY (grid) REFERENCES grid(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."person_sensor" ADD CONSTRAINT "fk_person_sensor_person_id" FOREIGN KEY (person_id) REFERENCES person(id) NOT DEFERRABLE;
ALTER TABLE ONLY "public"."person_sensor" ADD CONSTRAINT "fk_person_sensor_sensor_id" FOREIGN KEY (sensor_id) REFERENCES sensor(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."producer" ADD CONSTRAINT "producer_id_fkey" FOREIGN KEY (id) REFERENCES sensor(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."sensor" ADD CONSTRAINT "fk_sensor_grid" FOREIGN KEY (grid) REFERENCES grid(id) NOT DEFERRABLE;
ALTER TABLE ONLY "public"."sensor" ADD CONSTRAINT "sensor_grid_fkey" FOREIGN KEY (grid) REFERENCES grid(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."solar_panel" ADD CONSTRAINT "solar_panel_id_fkey" FOREIGN KEY (id) REFERENCES producer(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."wind_turbine" ADD CONSTRAINT "wind_turbine_id_fkey" FOREIGN KEY (id) REFERENCES producer(id) NOT DEFERRABLE;

-- 2025-04-01 13:22:34 UTC