-- --------------------------------------------------------
-- Host:                         153.92.1.116
-- Server version:               8.0.45-0ubuntu0.22.04.1 - (Ubuntu)
-- Server OS:                    Linux
-- HeidiSQL Version:             12.6.0.6765
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- Dumping database structure for sa_luksofori
CREATE DATABASE IF NOT EXISTS `sa_luksofori` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `sa_luksofori`;

-- Dumping structure for procedure sa_luksofori.GenerateDigitalMatrix
DELIMITER //
CREATE PROCEDURE `GenerateDigitalMatrix`(IN obj_id INT)
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE s_code VARCHAR(10);
    DECLARE s_type TINYINT;
    DECLARE s_duration INT;
    DECLARE s_offset INT;
    DECLARE s_cycle INT;
    DECLARE i INT;
    
    -- Kursoru signāliem
    DECLARE signal_cursor CURSOR FOR 
        SELECT signal_code, type_code, duration_sec, offset_sec 
        FROM signals 
        WHERE object_id = obj_id;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
    
    -- Iegūst cikla laiku
    SELECT cycle_time INTO s_cycle FROM objects WHERE id = obj_id;
    
    -- Notīra vecās vērtības
    DELETE FROM signal_states WHERE object_id = obj_id;
    
    OPEN signal_cursor;
    read_loop: LOOP
        FETCH signal_cursor INTO s_code, s_type, s_duration, s_offset;
        IF done THEN
            LEAVE read_loop;
        END IF;
        
        -- Aizpilda katru sekundi
        SET i = 0;
        WHILE i < s_cycle DO
            IF i >= s_offset AND i < (s_offset + s_duration) THEN
                -- Aktīvā fāze
                IF s_type = 2 THEN
                    INSERT INTO signal_states (object_id, signal_code, second_num, state) 
                    VALUES (obj_id, s_code, i, 2); -- CAUTION
                ELSE
                    INSERT INTO signal_states (object_id, signal_code, second_num, state) 
                    VALUES (obj_id, s_code, i, 1); -- GO
                END IF;
            ELSE
                -- Neaktīvā fāze (STOP)
                INSERT INTO signal_states (object_id, signal_code, second_num, state) 
                VALUES (obj_id, s_code, i, 0);
            END IF;
            SET i = i + 1;
        END WHILE;
        
    END LOOP;
    CLOSE signal_cursor;
    
    SELECT CONCAT('Digitalizācija pabeigta objektam ', obj_id) AS result;
END//
DELIMITER ;

-- Dumping structure for table sa_luksofori.objects
CREATE TABLE IF NOT EXISTS `objects` (
  `id` int NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `cycle_time` int NOT NULL COMMENT 'Cikla ilgums sekundēs',
  `amber_duration` int DEFAULT '3' COMMENT 'Dzeltenā ilgums',
  `red_duration` int DEFAULT '1' COMMENT 'Sarkanā ilgums',
  `yellow_duration` int DEFAULT '3' COMMENT 'Dzeltenā ilgums gājējiem',
  `created_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_cycle` (`cycle_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table sa_luksofori.objects: ~3 rows (approximately)
INSERT INTO `objects` (`id`, `name`, `cycle_time`, `amber_duration`, `red_duration`, `yellow_duration`, `created_date`) VALUES
	(9, 'Dobeles-Satiksmes-Aspazijas', 90, 3, 1, 3, '2022-08-29'),
	(16, 'Lielā-Katoļu', 90, 3, 1, 3, '2024-09-06'),
	(42, 'Rīgas-Pērnavas-Pumpura', 90, 3, 1, 3, '2024-01-01');

-- Dumping structure for table sa_luksofori.signals
CREATE TABLE IF NOT EXISTS `signals` (
  `id` int NOT NULL AUTO_INCREMENT,
  `object_id` int NOT NULL,
  `signal_code` varchar(10) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'V1, V4, GP1 utt.',
  `type_code` tinyint NOT NULL COMMENT '1=V, 2=A, 3=P',
  `duration_sec` int NOT NULL COMMENT 'Zaļā/aktīvā fāze',
  `offset_sec` int DEFAULT '0' COMMENT 'Nobīve cikla sākumā',
  PRIMARY KEY (`id`),
  KEY `idx_obj_signal` (`object_id`,`signal_code`),
  KEY `idx_type` (`type_code`),
  CONSTRAINT `signals_ibfk_1` FOREIGN KEY (`object_id`) REFERENCES `objects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table sa_luksofori.signals: ~17 rows (approximately)
INSERT INTO `signals` (`id`, `object_id`, `signal_code`, `type_code`, `duration_sec`, `offset_sec`) VALUES
	(22, 16, 'V1', 1, 23, 70),
	(23, 16, 'V4', 1, 47, 0),
	(24, 16, 'V10', 1, 63, 0),
	(25, 16, 'GP4', 3, 43, 70),
	(26, 16, 'GP7', 3, 72, 0),
	(27, 9, 'V1', 1, 23, 0),
	(28, 9, 'V4', 1, 23, 30),
	(29, 9, 'V7', 1, 15, 60),
	(30, 9, 'V10', 1, 23, 0),
	(31, 9, 'GP1', 3, 17, 0),
	(32, 9, 'GP4', 3, 13, 70),
	(33, 9, 'GP7', 3, 13, 70),
	(34, 42, 'V1', 1, 35, 0),
	(35, 42, 'V2', 1, 25, 45),
	(36, 42, 'V3', 1, 20, 70),
	(37, 42, 'GP1', 3, 15, 0),
	(38, 42, 'GP2', 3, 15, 45);

-- Dumping structure for table sa_luksofori.signal_states
CREATE TABLE IF NOT EXISTS `signal_states` (
  `id` int NOT NULL AUTO_INCREMENT,
  `object_id` int NOT NULL,
  `signal_code` varchar(10) COLLATE utf8mb4_general_ci NOT NULL,
  `second_num` int NOT NULL COMMENT 'Sekunde ciklā (0-cycle_time)',
  `state` tinyint NOT NULL COMMENT '0=STOP, 1=GO, 2=CAUTION',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_state` (`object_id`,`signal_code`,`second_num`),
  KEY `idx_second` (`second_num`),
  CONSTRAINT `signal_states_ibfk_1` FOREIGN KEY (`object_id`) REFERENCES `objects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2324 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table sa_luksofori.signal_states: ~0 rows (approximately)
INSERT INTO `signal_states` (`id`, `object_id`, `signal_code`, `second_num`, `state`) VALUES
	(2324, 16, 'GP4', 0, 0),
	(2325, 16, 'GP4', 1, 0),
	(2326, 16, 'GP4', 2, 0),
	(2327, 16, 'GP4', 3, 0),
	(2328, 16, 'GP4', 4, 0),
	(2329, 16, 'GP4', 5, 0),
	(2330, 16, 'GP4', 6, 0),
	(2331, 16, 'GP4', 7, 0),
	(2332, 16, 'GP4', 8, 0),
	(2333, 16, 'GP4', 9, 0),
	(2334, 16, 'GP4', 10, 0),
	(2335, 16, 'GP4', 11, 0),
	(2336, 16, 'GP4', 12, 0),
	(2337, 16, 'GP4', 13, 0),
	(2338, 16, 'GP4', 14, 0),
	(2339, 16, 'GP4', 15, 0),
	(2340, 16, 'GP4', 16, 0),
	(2341, 16, 'GP4', 17, 0),
	(2342, 16, 'GP4', 18, 0),
	(2343, 16, 'GP4', 19, 0),
	(2344, 16, 'GP4', 20, 0),
	(2345, 16, 'GP4', 21, 0),
	(2346, 16, 'GP4', 22, 0),
	(2347, 16, 'GP4', 23, 0),
	(2348, 16, 'GP4', 24, 0),
	(2349, 16, 'GP4', 25, 0),
	(2350, 16, 'GP4', 26, 0),
	(2351, 16, 'GP4', 27, 0),
	(2352, 16, 'GP4', 28, 0),
	(2353, 16, 'GP4', 29, 0),
	(2354, 16, 'GP4', 30, 0),
	(2355, 16, 'GP4', 31, 0),
	(2356, 16, 'GP4', 32, 0),
	(2357, 16, 'GP4', 33, 0),
	(2358, 16, 'GP4', 34, 0),
	(2359, 16, 'GP4', 35, 0),
	(2360, 16, 'GP4', 36, 0),
	(2361, 16, 'GP4', 37, 0),
	(2362, 16, 'GP4', 38, 0),
	(2363, 16, 'GP4', 39, 0),
	(2364, 16, 'GP4', 40, 0),
	(2365, 16, 'GP4', 41, 0),
	(2366, 16, 'GP4', 42, 0),
	(2367, 16, 'GP4', 43, 0),
	(2368, 16, 'GP4', 44, 0),
	(2369, 16, 'GP4', 45, 0),
	(2370, 16, 'GP4', 46, 0),
	(2371, 16, 'GP4', 47, 0),
	(2372, 16, 'GP4', 48, 0),
	(2373, 16, 'GP4', 49, 0),
	(2374, 16, 'GP4', 50, 0),
	(2375, 16, 'GP4', 51, 0),
	(2376, 16, 'GP4', 52, 0),
	(2377, 16, 'GP4', 53, 0),
	(2378, 16, 'GP4', 54, 0),
	(2379, 16, 'GP4', 55, 0),
	(2380, 16, 'GP4', 56, 0),
	(2381, 16, 'GP4', 57, 0),
	(2382, 16, 'GP4', 58, 0),
	(2383, 16, 'GP4', 59, 0),
	(2384, 16, 'GP4', 60, 0),
	(2385, 16, 'GP4', 61, 0),
	(2386, 16, 'GP4', 62, 0),
	(2387, 16, 'GP4', 63, 0),
	(2388, 16, 'GP4', 64, 0),
	(2389, 16, 'GP4', 65, 0),
	(2390, 16, 'GP4', 66, 0),
	(2391, 16, 'GP4', 67, 0),
	(2392, 16, 'GP4', 68, 0),
	(2393, 16, 'GP4', 69, 0),
	(2394, 16, 'GP4', 70, 1),
	(2395, 16, 'GP4', 71, 1),
	(2396, 16, 'GP4', 72, 1),
	(2397, 16, 'GP4', 73, 1),
	(2398, 16, 'GP4', 74, 1),
	(2399, 16, 'GP4', 75, 1),
	(2400, 16, 'GP4', 76, 1),
	(2401, 16, 'GP4', 77, 1),
	(2402, 16, 'GP4', 78, 1),
	(2403, 16, 'GP4', 79, 1),
	(2404, 16, 'GP4', 80, 1),
	(2405, 16, 'GP4', 81, 1),
	(2406, 16, 'GP4', 82, 1),
	(2407, 16, 'GP4', 83, 1),
	(2408, 16, 'GP4', 84, 1),
	(2409, 16, 'GP4', 85, 1),
	(2410, 16, 'GP4', 86, 1),
	(2411, 16, 'GP4', 87, 1),
	(2412, 16, 'GP4', 88, 1),
	(2413, 16, 'GP4', 89, 1),
	(2414, 16, 'GP7', 0, 1),
	(2415, 16, 'GP7', 1, 1),
	(2416, 16, 'GP7', 2, 1),
	(2417, 16, 'GP7', 3, 1),
	(2418, 16, 'GP7', 4, 1),
	(2419, 16, 'GP7', 5, 1),
	(2420, 16, 'GP7', 6, 1),
	(2421, 16, 'GP7', 7, 1),
	(2422, 16, 'GP7', 8, 1),
	(2423, 16, 'GP7', 9, 1),
	(2424, 16, 'GP7', 10, 1),
	(2425, 16, 'GP7', 11, 1),
	(2426, 16, 'GP7', 12, 1),
	(2427, 16, 'GP7', 13, 1),
	(2428, 16, 'GP7', 14, 1),
	(2429, 16, 'GP7', 15, 1),
	(2430, 16, 'GP7', 16, 1),
	(2431, 16, 'GP7', 17, 1),
	(2432, 16, 'GP7', 18, 1),
	(2433, 16, 'GP7', 19, 1),
	(2434, 16, 'GP7', 20, 1),
	(2435, 16, 'GP7', 21, 1),
	(2436, 16, 'GP7', 22, 1),
	(2437, 16, 'GP7', 23, 1),
	(2438, 16, 'GP7', 24, 1),
	(2439, 16, 'GP7', 25, 1),
	(2440, 16, 'GP7', 26, 1),
	(2441, 16, 'GP7', 27, 1),
	(2442, 16, 'GP7', 28, 1),
	(2443, 16, 'GP7', 29, 1),
	(2444, 16, 'GP7', 30, 1),
	(2445, 16, 'GP7', 31, 1),
	(2446, 16, 'GP7', 32, 1),
	(2447, 16, 'GP7', 33, 1),
	(2448, 16, 'GP7', 34, 1),
	(2449, 16, 'GP7', 35, 1),
	(2450, 16, 'GP7', 36, 1),
	(2451, 16, 'GP7', 37, 1),
	(2452, 16, 'GP7', 38, 1),
	(2453, 16, 'GP7', 39, 1),
	(2454, 16, 'GP7', 40, 1),
	(2455, 16, 'GP7', 41, 1),
	(2456, 16, 'GP7', 42, 1),
	(2457, 16, 'GP7', 43, 1),
	(2458, 16, 'GP7', 44, 1),
	(2459, 16, 'GP7', 45, 1),
	(2460, 16, 'GP7', 46, 1),
	(2461, 16, 'GP7', 47, 1),
	(2462, 16, 'GP7', 48, 1),
	(2463, 16, 'GP7', 49, 1),
	(2464, 16, 'GP7', 50, 1),
	(2465, 16, 'GP7', 51, 1),
	(2466, 16, 'GP7', 52, 1),
	(2467, 16, 'GP7', 53, 1),
	(2468, 16, 'GP7', 54, 1),
	(2469, 16, 'GP7', 55, 1),
	(2470, 16, 'GP7', 56, 1),
	(2471, 16, 'GP7', 57, 1),
	(2472, 16, 'GP7', 58, 1),
	(2473, 16, 'GP7', 59, 1),
	(2474, 16, 'GP7', 60, 1),
	(2475, 16, 'GP7', 61, 1),
	(2476, 16, 'GP7', 62, 1),
	(2477, 16, 'GP7', 63, 1),
	(2478, 16, 'GP7', 64, 1),
	(2479, 16, 'GP7', 65, 1),
	(2480, 16, 'GP7', 66, 1),
	(2481, 16, 'GP7', 67, 1),
	(2482, 16, 'GP7', 68, 1),
	(2483, 16, 'GP7', 69, 1),
	(2484, 16, 'GP7', 70, 1),
	(2485, 16, 'GP7', 71, 1),
	(2486, 16, 'GP7', 72, 0),
	(2487, 16, 'GP7', 73, 0),
	(2488, 16, 'GP7', 74, 0),
	(2489, 16, 'GP7', 75, 0),
	(2490, 16, 'GP7', 76, 0),
	(2491, 16, 'GP7', 77, 0),
	(2492, 16, 'GP7', 78, 0),
	(2493, 16, 'GP7', 79, 0),
	(2494, 16, 'GP7', 80, 0),
	(2495, 16, 'GP7', 81, 0),
	(2496, 16, 'GP7', 82, 0),
	(2497, 16, 'GP7', 83, 0),
	(2498, 16, 'GP7', 84, 0),
	(2499, 16, 'GP7', 85, 0),
	(2500, 16, 'GP7', 86, 0),
	(2501, 16, 'GP7', 87, 0),
	(2502, 16, 'GP7', 88, 0),
	(2503, 16, 'GP7', 89, 0),
	(2504, 16, 'V1', 0, 0),
	(2505, 16, 'V1', 1, 0),
	(2506, 16, 'V1', 2, 0),
	(2507, 16, 'V1', 3, 0),
	(2508, 16, 'V1', 4, 0),
	(2509, 16, 'V1', 5, 0),
	(2510, 16, 'V1', 6, 0),
	(2511, 16, 'V1', 7, 0),
	(2512, 16, 'V1', 8, 0),
	(2513, 16, 'V1', 9, 0),
	(2514, 16, 'V1', 10, 0),
	(2515, 16, 'V1', 11, 0),
	(2516, 16, 'V1', 12, 0),
	(2517, 16, 'V1', 13, 0),
	(2518, 16, 'V1', 14, 0),
	(2519, 16, 'V1', 15, 0),
	(2520, 16, 'V1', 16, 0),
	(2521, 16, 'V1', 17, 0),
	(2522, 16, 'V1', 18, 0),
	(2523, 16, 'V1', 19, 0),
	(2524, 16, 'V1', 20, 0),
	(2525, 16, 'V1', 21, 0),
	(2526, 16, 'V1', 22, 0),
	(2527, 16, 'V1', 23, 0),
	(2528, 16, 'V1', 24, 0),
	(2529, 16, 'V1', 25, 0),
	(2530, 16, 'V1', 26, 0),
	(2531, 16, 'V1', 27, 0),
	(2532, 16, 'V1', 28, 0),
	(2533, 16, 'V1', 29, 0),
	(2534, 16, 'V1', 30, 0),
	(2535, 16, 'V1', 31, 0),
	(2536, 16, 'V1', 32, 0),
	(2537, 16, 'V1', 33, 0),
	(2538, 16, 'V1', 34, 0),
	(2539, 16, 'V1', 35, 0),
	(2540, 16, 'V1', 36, 0),
	(2541, 16, 'V1', 37, 0),
	(2542, 16, 'V1', 38, 0),
	(2543, 16, 'V1', 39, 0),
	(2544, 16, 'V1', 40, 0),
	(2545, 16, 'V1', 41, 0),
	(2546, 16, 'V1', 42, 0),
	(2547, 16, 'V1', 43, 0),
	(2548, 16, 'V1', 44, 0),
	(2549, 16, 'V1', 45, 0),
	(2550, 16, 'V1', 46, 0),
	(2551, 16, 'V1', 47, 0),
	(2552, 16, 'V1', 48, 0),
	(2553, 16, 'V1', 49, 0),
	(2554, 16, 'V1', 50, 0),
	(2555, 16, 'V1', 51, 0),
	(2556, 16, 'V1', 52, 0),
	(2557, 16, 'V1', 53, 0),
	(2558, 16, 'V1', 54, 0),
	(2559, 16, 'V1', 55, 0),
	(2560, 16, 'V1', 56, 0),
	(2561, 16, 'V1', 57, 0),
	(2562, 16, 'V1', 58, 0),
	(2563, 16, 'V1', 59, 0),
	(2564, 16, 'V1', 60, 0),
	(2565, 16, 'V1', 61, 0),
	(2566, 16, 'V1', 62, 0),
	(2567, 16, 'V1', 63, 0),
	(2568, 16, 'V1', 64, 0),
	(2569, 16, 'V1', 65, 0),
	(2570, 16, 'V1', 66, 0),
	(2571, 16, 'V1', 67, 0),
	(2572, 16, 'V1', 68, 0),
	(2573, 16, 'V1', 69, 0),
	(2574, 16, 'V1', 70, 1),
	(2575, 16, 'V1', 71, 1),
	(2576, 16, 'V1', 72, 1),
	(2577, 16, 'V1', 73, 1),
	(2578, 16, 'V1', 74, 1),
	(2579, 16, 'V1', 75, 1),
	(2580, 16, 'V1', 76, 1),
	(2581, 16, 'V1', 77, 1),
	(2582, 16, 'V1', 78, 1),
	(2583, 16, 'V1', 79, 1),
	(2584, 16, 'V1', 80, 1),
	(2585, 16, 'V1', 81, 1),
	(2586, 16, 'V1', 82, 1),
	(2587, 16, 'V1', 83, 1),
	(2588, 16, 'V1', 84, 1),
	(2589, 16, 'V1', 85, 1),
	(2590, 16, 'V1', 86, 1),
	(2591, 16, 'V1', 87, 1),
	(2592, 16, 'V1', 88, 1),
	(2593, 16, 'V1', 89, 1),
	(2594, 16, 'V10', 0, 1),
	(2595, 16, 'V10', 1, 1),
	(2596, 16, 'V10', 2, 1),
	(2597, 16, 'V10', 3, 1),
	(2598, 16, 'V10', 4, 1),
	(2599, 16, 'V10', 5, 1),
	(2600, 16, 'V10', 6, 1),
	(2601, 16, 'V10', 7, 1),
	(2602, 16, 'V10', 8, 1),
	(2603, 16, 'V10', 9, 1),
	(2604, 16, 'V10', 10, 1),
	(2605, 16, 'V10', 11, 1),
	(2606, 16, 'V10', 12, 1),
	(2607, 16, 'V10', 13, 1),
	(2608, 16, 'V10', 14, 1),
	(2609, 16, 'V10', 15, 1),
	(2610, 16, 'V10', 16, 1),
	(2611, 16, 'V10', 17, 1),
	(2612, 16, 'V10', 18, 1),
	(2613, 16, 'V10', 19, 1),
	(2614, 16, 'V10', 20, 1),
	(2615, 16, 'V10', 21, 1),
	(2616, 16, 'V10', 22, 1),
	(2617, 16, 'V10', 23, 1),
	(2618, 16, 'V10', 24, 1),
	(2619, 16, 'V10', 25, 1),
	(2620, 16, 'V10', 26, 1),
	(2621, 16, 'V10', 27, 1),
	(2622, 16, 'V10', 28, 1),
	(2623, 16, 'V10', 29, 1),
	(2624, 16, 'V10', 30, 1),
	(2625, 16, 'V10', 31, 1),
	(2626, 16, 'V10', 32, 1),
	(2627, 16, 'V10', 33, 1),
	(2628, 16, 'V10', 34, 1),
	(2629, 16, 'V10', 35, 1),
	(2630, 16, 'V10', 36, 1),
	(2631, 16, 'V10', 37, 1),
	(2632, 16, 'V10', 38, 1),
	(2633, 16, 'V10', 39, 1),
	(2634, 16, 'V10', 40, 1),
	(2635, 16, 'V10', 41, 1),
	(2636, 16, 'V10', 42, 1),
	(2637, 16, 'V10', 43, 1),
	(2638, 16, 'V10', 44, 1),
	(2639, 16, 'V10', 45, 1),
	(2640, 16, 'V10', 46, 1),
	(2641, 16, 'V10', 47, 1),
	(2642, 16, 'V10', 48, 1),
	(2643, 16, 'V10', 49, 1),
	(2644, 16, 'V10', 50, 1),
	(2645, 16, 'V10', 51, 1),
	(2646, 16, 'V10', 52, 1),
	(2647, 16, 'V10', 53, 1),
	(2648, 16, 'V10', 54, 1),
	(2649, 16, 'V10', 55, 1),
	(2650, 16, 'V10', 56, 1),
	(2651, 16, 'V10', 57, 1),
	(2652, 16, 'V10', 58, 1),
	(2653, 16, 'V10', 59, 1),
	(2654, 16, 'V10', 60, 1),
	(2655, 16, 'V10', 61, 1),
	(2656, 16, 'V10', 62, 1),
	(2657, 16, 'V10', 63, 0),
	(2658, 16, 'V10', 64, 0),
	(2659, 16, 'V10', 65, 0),
	(2660, 16, 'V10', 66, 0),
	(2661, 16, 'V10', 67, 0),
	(2662, 16, 'V10', 68, 0),
	(2663, 16, 'V10', 69, 0),
	(2664, 16, 'V10', 70, 0),
	(2665, 16, 'V10', 71, 0),
	(2666, 16, 'V10', 72, 0),
	(2667, 16, 'V10', 73, 0),
	(2668, 16, 'V10', 74, 0),
	(2669, 16, 'V10', 75, 0),
	(2670, 16, 'V10', 76, 0),
	(2671, 16, 'V10', 77, 0),
	(2672, 16, 'V10', 78, 0),
	(2673, 16, 'V10', 79, 0),
	(2674, 16, 'V10', 80, 0),
	(2675, 16, 'V10', 81, 0),
	(2676, 16, 'V10', 82, 0),
	(2677, 16, 'V10', 83, 0),
	(2678, 16, 'V10', 84, 0),
	(2679, 16, 'V10', 85, 0),
	(2680, 16, 'V10', 86, 0),
	(2681, 16, 'V10', 87, 0),
	(2682, 16, 'V10', 88, 0),
	(2683, 16, 'V10', 89, 0),
	(2684, 16, 'V4', 0, 1),
	(2685, 16, 'V4', 1, 1),
	(2686, 16, 'V4', 2, 1),
	(2687, 16, 'V4', 3, 1),
	(2688, 16, 'V4', 4, 1),
	(2689, 16, 'V4', 5, 1),
	(2690, 16, 'V4', 6, 1),
	(2691, 16, 'V4', 7, 1),
	(2692, 16, 'V4', 8, 1),
	(2693, 16, 'V4', 9, 1),
	(2694, 16, 'V4', 10, 1),
	(2695, 16, 'V4', 11, 1),
	(2696, 16, 'V4', 12, 1),
	(2697, 16, 'V4', 13, 1),
	(2698, 16, 'V4', 14, 1),
	(2699, 16, 'V4', 15, 1),
	(2700, 16, 'V4', 16, 1),
	(2701, 16, 'V4', 17, 1),
	(2702, 16, 'V4', 18, 1),
	(2703, 16, 'V4', 19, 1),
	(2704, 16, 'V4', 20, 1),
	(2705, 16, 'V4', 21, 1),
	(2706, 16, 'V4', 22, 1),
	(2707, 16, 'V4', 23, 1),
	(2708, 16, 'V4', 24, 1),
	(2709, 16, 'V4', 25, 1),
	(2710, 16, 'V4', 26, 1),
	(2711, 16, 'V4', 27, 1),
	(2712, 16, 'V4', 28, 1),
	(2713, 16, 'V4', 29, 1),
	(2714, 16, 'V4', 30, 1),
	(2715, 16, 'V4', 31, 1),
	(2716, 16, 'V4', 32, 1),
	(2717, 16, 'V4', 33, 1),
	(2718, 16, 'V4', 34, 1),
	(2719, 16, 'V4', 35, 1),
	(2720, 16, 'V4', 36, 1),
	(2721, 16, 'V4', 37, 1),
	(2722, 16, 'V4', 38, 1),
	(2723, 16, 'V4', 39, 1),
	(2724, 16, 'V4', 40, 1),
	(2725, 16, 'V4', 41, 1),
	(2726, 16, 'V4', 42, 1),
	(2727, 16, 'V4', 43, 1),
	(2728, 16, 'V4', 44, 1),
	(2729, 16, 'V4', 45, 1),
	(2730, 16, 'V4', 46, 1),
	(2731, 16, 'V4', 47, 0),
	(2732, 16, 'V4', 48, 0),
	(2733, 16, 'V4', 49, 0),
	(2734, 16, 'V4', 50, 0),
	(2735, 16, 'V4', 51, 0),
	(2736, 16, 'V4', 52, 0),
	(2737, 16, 'V4', 53, 0),
	(2738, 16, 'V4', 54, 0),
	(2739, 16, 'V4', 55, 0),
	(2740, 16, 'V4', 56, 0),
	(2741, 16, 'V4', 57, 0),
	(2742, 16, 'V4', 58, 0),
	(2743, 16, 'V4', 59, 0),
	(2744, 16, 'V4', 60, 0),
	(2745, 16, 'V4', 61, 0),
	(2746, 16, 'V4', 62, 0),
	(2747, 16, 'V4', 63, 0),
	(2748, 16, 'V4', 64, 0),
	(2749, 16, 'V4', 65, 0),
	(2750, 16, 'V4', 66, 0),
	(2751, 16, 'V4', 67, 0),
	(2752, 16, 'V4', 68, 0),
	(2753, 16, 'V4', 69, 0),
	(2754, 16, 'V4', 70, 0),
	(2755, 16, 'V4', 71, 0),
	(2756, 16, 'V4', 72, 0),
	(2757, 16, 'V4', 73, 0),
	(2758, 16, 'V4', 74, 0),
	(2759, 16, 'V4', 75, 0),
	(2760, 16, 'V4', 76, 0),
	(2761, 16, 'V4', 77, 0),
	(2762, 16, 'V4', 78, 0),
	(2763, 16, 'V4', 79, 0),
	(2764, 16, 'V4', 80, 0),
	(2765, 16, 'V4', 81, 0),
	(2766, 16, 'V4', 82, 0),
	(2767, 16, 'V4', 83, 0),
	(2768, 16, 'V4', 84, 0),
	(2769, 16, 'V4', 85, 0),
	(2770, 16, 'V4', 86, 0),
	(2771, 16, 'V4', 87, 0),
	(2772, 16, 'V4', 88, 0),
	(2773, 16, 'V4', 89, 0),
	(2774, 9, 'GP1', 0, 1),
	(2775, 9, 'GP1', 1, 1),
	(2776, 9, 'GP1', 2, 1),
	(2777, 9, 'GP1', 3, 1),
	(2778, 9, 'GP1', 4, 1),
	(2779, 9, 'GP1', 5, 1),
	(2780, 9, 'GP1', 6, 1),
	(2781, 9, 'GP1', 7, 1),
	(2782, 9, 'GP1', 8, 1),
	(2783, 9, 'GP1', 9, 1),
	(2784, 9, 'GP1', 10, 1),
	(2785, 9, 'GP1', 11, 1),
	(2786, 9, 'GP1', 12, 1),
	(2787, 9, 'GP1', 13, 1),
	(2788, 9, 'GP1', 14, 1),
	(2789, 9, 'GP1', 15, 1),
	(2790, 9, 'GP1', 16, 1),
	(2791, 9, 'GP1', 17, 0),
	(2792, 9, 'GP1', 18, 0),
	(2793, 9, 'GP1', 19, 0),
	(2794, 9, 'GP1', 20, 0),
	(2795, 9, 'GP1', 21, 0),
	(2796, 9, 'GP1', 22, 0),
	(2797, 9, 'GP1', 23, 0),
	(2798, 9, 'GP1', 24, 0),
	(2799, 9, 'GP1', 25, 0),
	(2800, 9, 'GP1', 26, 0),
	(2801, 9, 'GP1', 27, 0),
	(2802, 9, 'GP1', 28, 0),
	(2803, 9, 'GP1', 29, 0),
	(2804, 9, 'GP1', 30, 0),
	(2805, 9, 'GP1', 31, 0),
	(2806, 9, 'GP1', 32, 0),
	(2807, 9, 'GP1', 33, 0),
	(2808, 9, 'GP1', 34, 0),
	(2809, 9, 'GP1', 35, 0),
	(2810, 9, 'GP1', 36, 0),
	(2811, 9, 'GP1', 37, 0),
	(2812, 9, 'GP1', 38, 0),
	(2813, 9, 'GP1', 39, 0),
	(2814, 9, 'GP1', 40, 0),
	(2815, 9, 'GP1', 41, 0),
	(2816, 9, 'GP1', 42, 0),
	(2817, 9, 'GP1', 43, 0),
	(2818, 9, 'GP1', 44, 0),
	(2819, 9, 'GP1', 45, 0),
	(2820, 9, 'GP1', 46, 0),
	(2821, 9, 'GP1', 47, 0),
	(2822, 9, 'GP1', 48, 0),
	(2823, 9, 'GP1', 49, 0),
	(2824, 9, 'GP1', 50, 0),
	(2825, 9, 'GP1', 51, 0),
	(2826, 9, 'GP1', 52, 0),
	(2827, 9, 'GP1', 53, 0),
	(2828, 9, 'GP1', 54, 0),
	(2829, 9, 'GP1', 55, 0),
	(2830, 9, 'GP1', 56, 0),
	(2831, 9, 'GP1', 57, 0),
	(2832, 9, 'GP1', 58, 0),
	(2833, 9, 'GP1', 59, 0),
	(2834, 9, 'GP1', 60, 0),
	(2835, 9, 'GP1', 61, 0),
	(2836, 9, 'GP1', 62, 0),
	(2837, 9, 'GP1', 63, 0),
	(2838, 9, 'GP1', 64, 0),
	(2839, 9, 'GP1', 65, 0),
	(2840, 9, 'GP1', 66, 0),
	(2841, 9, 'GP1', 67, 0),
	(2842, 9, 'GP1', 68, 0),
	(2843, 9, 'GP1', 69, 0),
	(2844, 9, 'GP1', 70, 0),
	(2845, 9, 'GP1', 71, 0),
	(2846, 9, 'GP1', 72, 0),
	(2847, 9, 'GP1', 73, 0),
	(2848, 9, 'GP1', 74, 0),
	(2849, 9, 'GP1', 75, 0),
	(2850, 9, 'GP1', 76, 0),
	(2851, 9, 'GP1', 77, 0),
	(2852, 9, 'GP1', 78, 0),
	(2853, 9, 'GP1', 79, 0),
	(2854, 9, 'GP1', 80, 0),
	(2855, 9, 'GP1', 81, 0),
	(2856, 9, 'GP1', 82, 0),
	(2857, 9, 'GP1', 83, 0),
	(2858, 9, 'GP1', 84, 0),
	(2859, 9, 'GP1', 85, 0),
	(2860, 9, 'GP1', 86, 0),
	(2861, 9, 'GP1', 87, 0),
	(2862, 9, 'GP1', 88, 0),
	(2863, 9, 'GP1', 89, 0),
	(2864, 9, 'GP4', 0, 0),
	(2865, 9, 'GP4', 1, 0),
	(2866, 9, 'GP4', 2, 0),
	(2867, 9, 'GP4', 3, 0),
	(2868, 9, 'GP4', 4, 0),
	(2869, 9, 'GP4', 5, 0),
	(2870, 9, 'GP4', 6, 0),
	(2871, 9, 'GP4', 7, 0),
	(2872, 9, 'GP4', 8, 0),
	(2873, 9, 'GP4', 9, 0),
	(2874, 9, 'GP4', 10, 0),
	(2875, 9, 'GP4', 11, 0),
	(2876, 9, 'GP4', 12, 0),
	(2877, 9, 'GP4', 13, 0),
	(2878, 9, 'GP4', 14, 0),
	(2879, 9, 'GP4', 15, 0),
	(2880, 9, 'GP4', 16, 0),
	(2881, 9, 'GP4', 17, 0),
	(2882, 9, 'GP4', 18, 0),
	(2883, 9, 'GP4', 19, 0),
	(2884, 9, 'GP4', 20, 0),
	(2885, 9, 'GP4', 21, 0),
	(2886, 9, 'GP4', 22, 0),
	(2887, 9, 'GP4', 23, 0),
	(2888, 9, 'GP4', 24, 0),
	(2889, 9, 'GP4', 25, 0),
	(2890, 9, 'GP4', 26, 0),
	(2891, 9, 'GP4', 27, 0),
	(2892, 9, 'GP4', 28, 0),
	(2893, 9, 'GP4', 29, 0),
	(2894, 9, 'GP4', 30, 0),
	(2895, 9, 'GP4', 31, 0),
	(2896, 9, 'GP4', 32, 0),
	(2897, 9, 'GP4', 33, 0),
	(2898, 9, 'GP4', 34, 0),
	(2899, 9, 'GP4', 35, 0),
	(2900, 9, 'GP4', 36, 0),
	(2901, 9, 'GP4', 37, 0),
	(2902, 9, 'GP4', 38, 0),
	(2903, 9, 'GP4', 39, 0),
	(2904, 9, 'GP4', 40, 0),
	(2905, 9, 'GP4', 41, 0),
	(2906, 9, 'GP4', 42, 0),
	(2907, 9, 'GP4', 43, 0),
	(2908, 9, 'GP4', 44, 0),
	(2909, 9, 'GP4', 45, 0),
	(2910, 9, 'GP4', 46, 0),
	(2911, 9, 'GP4', 47, 0),
	(2912, 9, 'GP4', 48, 0),
	(2913, 9, 'GP4', 49, 0),
	(2914, 9, 'GP4', 50, 0),
	(2915, 9, 'GP4', 51, 0),
	(2916, 9, 'GP4', 52, 0),
	(2917, 9, 'GP4', 53, 0),
	(2918, 9, 'GP4', 54, 0),
	(2919, 9, 'GP4', 55, 0),
	(2920, 9, 'GP4', 56, 0),
	(2921, 9, 'GP4', 57, 0),
	(2922, 9, 'GP4', 58, 0),
	(2923, 9, 'GP4', 59, 0),
	(2924, 9, 'GP4', 60, 0),
	(2925, 9, 'GP4', 61, 0),
	(2926, 9, 'GP4', 62, 0),
	(2927, 9, 'GP4', 63, 0),
	(2928, 9, 'GP4', 64, 0),
	(2929, 9, 'GP4', 65, 0),
	(2930, 9, 'GP4', 66, 0),
	(2931, 9, 'GP4', 67, 0),
	(2932, 9, 'GP4', 68, 0),
	(2933, 9, 'GP4', 69, 0),
	(2934, 9, 'GP4', 70, 1),
	(2935, 9, 'GP4', 71, 1),
	(2936, 9, 'GP4', 72, 1),
	(2937, 9, 'GP4', 73, 1),
	(2938, 9, 'GP4', 74, 1),
	(2939, 9, 'GP4', 75, 1),
	(2940, 9, 'GP4', 76, 1),
	(2941, 9, 'GP4', 77, 1),
	(2942, 9, 'GP4', 78, 1),
	(2943, 9, 'GP4', 79, 1),
	(2944, 9, 'GP4', 80, 1),
	(2945, 9, 'GP4', 81, 1),
	(2946, 9, 'GP4', 82, 1),
	(2947, 9, 'GP4', 83, 0),
	(2948, 9, 'GP4', 84, 0),
	(2949, 9, 'GP4', 85, 0),
	(2950, 9, 'GP4', 86, 0),
	(2951, 9, 'GP4', 87, 0),
	(2952, 9, 'GP4', 88, 0),
	(2953, 9, 'GP4', 89, 0),
	(2954, 9, 'GP7', 0, 0),
	(2955, 9, 'GP7', 1, 0),
	(2956, 9, 'GP7', 2, 0),
	(2957, 9, 'GP7', 3, 0),
	(2958, 9, 'GP7', 4, 0),
	(2959, 9, 'GP7', 5, 0),
	(2960, 9, 'GP7', 6, 0),
	(2961, 9, 'GP7', 7, 0),
	(2962, 9, 'GP7', 8, 0),
	(2963, 9, 'GP7', 9, 0),
	(2964, 9, 'GP7', 10, 0),
	(2965, 9, 'GP7', 11, 0),
	(2966, 9, 'GP7', 12, 0),
	(2967, 9, 'GP7', 13, 0),
	(2968, 9, 'GP7', 14, 0),
	(2969, 9, 'GP7', 15, 0),
	(2970, 9, 'GP7', 16, 0),
	(2971, 9, 'GP7', 17, 0),
	(2972, 9, 'GP7', 18, 0),
	(2973, 9, 'GP7', 19, 0),
	(2974, 9, 'GP7', 20, 0),
	(2975, 9, 'GP7', 21, 0),
	(2976, 9, 'GP7', 22, 0),
	(2977, 9, 'GP7', 23, 0),
	(2978, 9, 'GP7', 24, 0),
	(2979, 9, 'GP7', 25, 0),
	(2980, 9, 'GP7', 26, 0),
	(2981, 9, 'GP7', 27, 0),
	(2982, 9, 'GP7', 28, 0),
	(2983, 9, 'GP7', 29, 0),
	(2984, 9, 'GP7', 30, 0),
	(2985, 9, 'GP7', 31, 0),
	(2986, 9, 'GP7', 32, 0),
	(2987, 9, 'GP7', 33, 0),
	(2988, 9, 'GP7', 34, 0),
	(2989, 9, 'GP7', 35, 0),
	(2990, 9, 'GP7', 36, 0),
	(2991, 9, 'GP7', 37, 0),
	(2992, 9, 'GP7', 38, 0),
	(2993, 9, 'GP7', 39, 0),
	(2994, 9, 'GP7', 40, 0),
	(2995, 9, 'GP7', 41, 0),
	(2996, 9, 'GP7', 42, 0),
	(2997, 9, 'GP7', 43, 0),
	(2998, 9, 'GP7', 44, 0),
	(2999, 9, 'GP7', 45, 0),
	(3000, 9, 'GP7', 46, 0),
	(3001, 9, 'GP7', 47, 0),
	(3002, 9, 'GP7', 48, 0),
	(3003, 9, 'GP7', 49, 0),
	(3004, 9, 'GP7', 50, 0),
	(3005, 9, 'GP7', 51, 0),
	(3006, 9, 'GP7', 52, 0),
	(3007, 9, 'GP7', 53, 0),
	(3008, 9, 'GP7', 54, 0),
	(3009, 9, 'GP7', 55, 0),
	(3010, 9, 'GP7', 56, 0),
	(3011, 9, 'GP7', 57, 0),
	(3012, 9, 'GP7', 58, 0),
	(3013, 9, 'GP7', 59, 0),
	(3014, 9, 'GP7', 60, 0),
	(3015, 9, 'GP7', 61, 0),
	(3016, 9, 'GP7', 62, 0),
	(3017, 9, 'GP7', 63, 0),
	(3018, 9, 'GP7', 64, 0),
	(3019, 9, 'GP7', 65, 0),
	(3020, 9, 'GP7', 66, 0),
	(3021, 9, 'GP7', 67, 0),
	(3022, 9, 'GP7', 68, 0),
	(3023, 9, 'GP7', 69, 0),
	(3024, 9, 'GP7', 70, 1),
	(3025, 9, 'GP7', 71, 1),
	(3026, 9, 'GP7', 72, 1),
	(3027, 9, 'GP7', 73, 1),
	(3028, 9, 'GP7', 74, 1),
	(3029, 9, 'GP7', 75, 1),
	(3030, 9, 'GP7', 76, 1),
	(3031, 9, 'GP7', 77, 1),
	(3032, 9, 'GP7', 78, 1),
	(3033, 9, 'GP7', 79, 1),
	(3034, 9, 'GP7', 80, 1),
	(3035, 9, 'GP7', 81, 1),
	(3036, 9, 'GP7', 82, 1),
	(3037, 9, 'GP7', 83, 0),
	(3038, 9, 'GP7', 84, 0),
	(3039, 9, 'GP7', 85, 0),
	(3040, 9, 'GP7', 86, 0),
	(3041, 9, 'GP7', 87, 0),
	(3042, 9, 'GP7', 88, 0),
	(3043, 9, 'GP7', 89, 0),
	(3044, 9, 'V1', 0, 1),
	(3045, 9, 'V1', 1, 1),
	(3046, 9, 'V1', 2, 1),
	(3047, 9, 'V1', 3, 1),
	(3048, 9, 'V1', 4, 1),
	(3049, 9, 'V1', 5, 1),
	(3050, 9, 'V1', 6, 1),
	(3051, 9, 'V1', 7, 1),
	(3052, 9, 'V1', 8, 1),
	(3053, 9, 'V1', 9, 1),
	(3054, 9, 'V1', 10, 1),
	(3055, 9, 'V1', 11, 1),
	(3056, 9, 'V1', 12, 1),
	(3057, 9, 'V1', 13, 1),
	(3058, 9, 'V1', 14, 1),
	(3059, 9, 'V1', 15, 1),
	(3060, 9, 'V1', 16, 1),
	(3061, 9, 'V1', 17, 1),
	(3062, 9, 'V1', 18, 1),
	(3063, 9, 'V1', 19, 1),
	(3064, 9, 'V1', 20, 1),
	(3065, 9, 'V1', 21, 1),
	(3066, 9, 'V1', 22, 1),
	(3067, 9, 'V1', 23, 0),
	(3068, 9, 'V1', 24, 0),
	(3069, 9, 'V1', 25, 0),
	(3070, 9, 'V1', 26, 0),
	(3071, 9, 'V1', 27, 0),
	(3072, 9, 'V1', 28, 0),
	(3073, 9, 'V1', 29, 0),
	(3074, 9, 'V1', 30, 0),
	(3075, 9, 'V1', 31, 0),
	(3076, 9, 'V1', 32, 0),
	(3077, 9, 'V1', 33, 0),
	(3078, 9, 'V1', 34, 0),
	(3079, 9, 'V1', 35, 0),
	(3080, 9, 'V1', 36, 0),
	(3081, 9, 'V1', 37, 0),
	(3082, 9, 'V1', 38, 0),
	(3083, 9, 'V1', 39, 0),
	(3084, 9, 'V1', 40, 0),
	(3085, 9, 'V1', 41, 0),
	(3086, 9, 'V1', 42, 0),
	(3087, 9, 'V1', 43, 0),
	(3088, 9, 'V1', 44, 0),
	(3089, 9, 'V1', 45, 0),
	(3090, 9, 'V1', 46, 0),
	(3091, 9, 'V1', 47, 0),
	(3092, 9, 'V1', 48, 0),
	(3093, 9, 'V1', 49, 0),
	(3094, 9, 'V1', 50, 0),
	(3095, 9, 'V1', 51, 0),
	(3096, 9, 'V1', 52, 0),
	(3097, 9, 'V1', 53, 0),
	(3098, 9, 'V1', 54, 0),
	(3099, 9, 'V1', 55, 0),
	(3100, 9, 'V1', 56, 0),
	(3101, 9, 'V1', 57, 0),
	(3102, 9, 'V1', 58, 0),
	(3103, 9, 'V1', 59, 0),
	(3104, 9, 'V1', 60, 0),
	(3105, 9, 'V1', 61, 0),
	(3106, 9, 'V1', 62, 0),
	(3107, 9, 'V1', 63, 0),
	(3108, 9, 'V1', 64, 0),
	(3109, 9, 'V1', 65, 0),
	(3110, 9, 'V1', 66, 0),
	(3111, 9, 'V1', 67, 0),
	(3112, 9, 'V1', 68, 0),
	(3113, 9, 'V1', 69, 0),
	(3114, 9, 'V1', 70, 0),
	(3115, 9, 'V1', 71, 0),
	(3116, 9, 'V1', 72, 0),
	(3117, 9, 'V1', 73, 0),
	(3118, 9, 'V1', 74, 0),
	(3119, 9, 'V1', 75, 0),
	(3120, 9, 'V1', 76, 0),
	(3121, 9, 'V1', 77, 0),
	(3122, 9, 'V1', 78, 0),
	(3123, 9, 'V1', 79, 0),
	(3124, 9, 'V1', 80, 0),
	(3125, 9, 'V1', 81, 0),
	(3126, 9, 'V1', 82, 0),
	(3127, 9, 'V1', 83, 0),
	(3128, 9, 'V1', 84, 0),
	(3129, 9, 'V1', 85, 0),
	(3130, 9, 'V1', 86, 0),
	(3131, 9, 'V1', 87, 0),
	(3132, 9, 'V1', 88, 0),
	(3133, 9, 'V1', 89, 0),
	(3134, 9, 'V10', 0, 1),
	(3135, 9, 'V10', 1, 1),
	(3136, 9, 'V10', 2, 1),
	(3137, 9, 'V10', 3, 1),
	(3138, 9, 'V10', 4, 1),
	(3139, 9, 'V10', 5, 1),
	(3140, 9, 'V10', 6, 1),
	(3141, 9, 'V10', 7, 1),
	(3142, 9, 'V10', 8, 1),
	(3143, 9, 'V10', 9, 1),
	(3144, 9, 'V10', 10, 1),
	(3145, 9, 'V10', 11, 1),
	(3146, 9, 'V10', 12, 1),
	(3147, 9, 'V10', 13, 1),
	(3148, 9, 'V10', 14, 1),
	(3149, 9, 'V10', 15, 1),
	(3150, 9, 'V10', 16, 1),
	(3151, 9, 'V10', 17, 1),
	(3152, 9, 'V10', 18, 1),
	(3153, 9, 'V10', 19, 1),
	(3154, 9, 'V10', 20, 1),
	(3155, 9, 'V10', 21, 1),
	(3156, 9, 'V10', 22, 1),
	(3157, 9, 'V10', 23, 0),
	(3158, 9, 'V10', 24, 0),
	(3159, 9, 'V10', 25, 0),
	(3160, 9, 'V10', 26, 0),
	(3161, 9, 'V10', 27, 0),
	(3162, 9, 'V10', 28, 0),
	(3163, 9, 'V10', 29, 0),
	(3164, 9, 'V10', 30, 0),
	(3165, 9, 'V10', 31, 0),
	(3166, 9, 'V10', 32, 0),
	(3167, 9, 'V10', 33, 0),
	(3168, 9, 'V10', 34, 0),
	(3169, 9, 'V10', 35, 0),
	(3170, 9, 'V10', 36, 0),
	(3171, 9, 'V10', 37, 0),
	(3172, 9, 'V10', 38, 0),
	(3173, 9, 'V10', 39, 0),
	(3174, 9, 'V10', 40, 0),
	(3175, 9, 'V10', 41, 0),
	(3176, 9, 'V10', 42, 0),
	(3177, 9, 'V10', 43, 0),
	(3178, 9, 'V10', 44, 0),
	(3179, 9, 'V10', 45, 0),
	(3180, 9, 'V10', 46, 0),
	(3181, 9, 'V10', 47, 0),
	(3182, 9, 'V10', 48, 0),
	(3183, 9, 'V10', 49, 0),
	(3184, 9, 'V10', 50, 0),
	(3185, 9, 'V10', 51, 0),
	(3186, 9, 'V10', 52, 0),
	(3187, 9, 'V10', 53, 0),
	(3188, 9, 'V10', 54, 0),
	(3189, 9, 'V10', 55, 0),
	(3190, 9, 'V10', 56, 0),
	(3191, 9, 'V10', 57, 0),
	(3192, 9, 'V10', 58, 0),
	(3193, 9, 'V10', 59, 0),
	(3194, 9, 'V10', 60, 0),
	(3195, 9, 'V10', 61, 0),
	(3196, 9, 'V10', 62, 0),
	(3197, 9, 'V10', 63, 0),
	(3198, 9, 'V10', 64, 0),
	(3199, 9, 'V10', 65, 0),
	(3200, 9, 'V10', 66, 0),
	(3201, 9, 'V10', 67, 0),
	(3202, 9, 'V10', 68, 0),
	(3203, 9, 'V10', 69, 0),
	(3204, 9, 'V10', 70, 0),
	(3205, 9, 'V10', 71, 0),
	(3206, 9, 'V10', 72, 0),
	(3207, 9, 'V10', 73, 0),
	(3208, 9, 'V10', 74, 0),
	(3209, 9, 'V10', 75, 0),
	(3210, 9, 'V10', 76, 0),
	(3211, 9, 'V10', 77, 0),
	(3212, 9, 'V10', 78, 0),
	(3213, 9, 'V10', 79, 0),
	(3214, 9, 'V10', 80, 0),
	(3215, 9, 'V10', 81, 0),
	(3216, 9, 'V10', 82, 0),
	(3217, 9, 'V10', 83, 0),
	(3218, 9, 'V10', 84, 0),
	(3219, 9, 'V10', 85, 0),
	(3220, 9, 'V10', 86, 0),
	(3221, 9, 'V10', 87, 0),
	(3222, 9, 'V10', 88, 0),
	(3223, 9, 'V10', 89, 0),
	(3224, 9, 'V4', 0, 0),
	(3225, 9, 'V4', 1, 0),
	(3226, 9, 'V4', 2, 0),
	(3227, 9, 'V4', 3, 0),
	(3228, 9, 'V4', 4, 0),
	(3229, 9, 'V4', 5, 0),
	(3230, 9, 'V4', 6, 0),
	(3231, 9, 'V4', 7, 0),
	(3232, 9, 'V4', 8, 0),
	(3233, 9, 'V4', 9, 0),
	(3234, 9, 'V4', 10, 0),
	(3235, 9, 'V4', 11, 0),
	(3236, 9, 'V4', 12, 0),
	(3237, 9, 'V4', 13, 0),
	(3238, 9, 'V4', 14, 0),
	(3239, 9, 'V4', 15, 0),
	(3240, 9, 'V4', 16, 0),
	(3241, 9, 'V4', 17, 0),
	(3242, 9, 'V4', 18, 0),
	(3243, 9, 'V4', 19, 0),
	(3244, 9, 'V4', 20, 0),
	(3245, 9, 'V4', 21, 0),
	(3246, 9, 'V4', 22, 0),
	(3247, 9, 'V4', 23, 0),
	(3248, 9, 'V4', 24, 0),
	(3249, 9, 'V4', 25, 0),
	(3250, 9, 'V4', 26, 0),
	(3251, 9, 'V4', 27, 0),
	(3252, 9, 'V4', 28, 0),
	(3253, 9, 'V4', 29, 0),
	(3254, 9, 'V4', 30, 1),
	(3255, 9, 'V4', 31, 1),
	(3256, 9, 'V4', 32, 1),
	(3257, 9, 'V4', 33, 1),
	(3258, 9, 'V4', 34, 1),
	(3259, 9, 'V4', 35, 1),
	(3260, 9, 'V4', 36, 1),
	(3261, 9, 'V4', 37, 1),
	(3262, 9, 'V4', 38, 1),
	(3263, 9, 'V4', 39, 1),
	(3264, 9, 'V4', 40, 1),
	(3265, 9, 'V4', 41, 1),
	(3266, 9, 'V4', 42, 1),
	(3267, 9, 'V4', 43, 1),
	(3268, 9, 'V4', 44, 1),
	(3269, 9, 'V4', 45, 1),
	(3270, 9, 'V4', 46, 1),
	(3271, 9, 'V4', 47, 1),
	(3272, 9, 'V4', 48, 1),
	(3273, 9, 'V4', 49, 1),
	(3274, 9, 'V4', 50, 1),
	(3275, 9, 'V4', 51, 1),
	(3276, 9, 'V4', 52, 1),
	(3277, 9, 'V4', 53, 0),
	(3278, 9, 'V4', 54, 0),
	(3279, 9, 'V4', 55, 0),
	(3280, 9, 'V4', 56, 0),
	(3281, 9, 'V4', 57, 0),
	(3282, 9, 'V4', 58, 0),
	(3283, 9, 'V4', 59, 0),
	(3284, 9, 'V4', 60, 0),
	(3285, 9, 'V4', 61, 0),
	(3286, 9, 'V4', 62, 0),
	(3287, 9, 'V4', 63, 0),
	(3288, 9, 'V4', 64, 0),
	(3289, 9, 'V4', 65, 0),
	(3290, 9, 'V4', 66, 0),
	(3291, 9, 'V4', 67, 0),
	(3292, 9, 'V4', 68, 0),
	(3293, 9, 'V4', 69, 0),
	(3294, 9, 'V4', 70, 0),
	(3295, 9, 'V4', 71, 0),
	(3296, 9, 'V4', 72, 0),
	(3297, 9, 'V4', 73, 0),
	(3298, 9, 'V4', 74, 0),
	(3299, 9, 'V4', 75, 0),
	(3300, 9, 'V4', 76, 0),
	(3301, 9, 'V4', 77, 0),
	(3302, 9, 'V4', 78, 0),
	(3303, 9, 'V4', 79, 0),
	(3304, 9, 'V4', 80, 0),
	(3305, 9, 'V4', 81, 0),
	(3306, 9, 'V4', 82, 0),
	(3307, 9, 'V4', 83, 0),
	(3308, 9, 'V4', 84, 0),
	(3309, 9, 'V4', 85, 0),
	(3310, 9, 'V4', 86, 0),
	(3311, 9, 'V4', 87, 0),
	(3312, 9, 'V4', 88, 0),
	(3313, 9, 'V4', 89, 0),
	(3314, 9, 'V7', 0, 0),
	(3315, 9, 'V7', 1, 0),
	(3316, 9, 'V7', 2, 0),
	(3317, 9, 'V7', 3, 0),
	(3318, 9, 'V7', 4, 0),
	(3319, 9, 'V7', 5, 0),
	(3320, 9, 'V7', 6, 0),
	(3321, 9, 'V7', 7, 0),
	(3322, 9, 'V7', 8, 0),
	(3323, 9, 'V7', 9, 0),
	(3324, 9, 'V7', 10, 0),
	(3325, 9, 'V7', 11, 0),
	(3326, 9, 'V7', 12, 0),
	(3327, 9, 'V7', 13, 0),
	(3328, 9, 'V7', 14, 0),
	(3329, 9, 'V7', 15, 0),
	(3330, 9, 'V7', 16, 0),
	(3331, 9, 'V7', 17, 0),
	(3332, 9, 'V7', 18, 0),
	(3333, 9, 'V7', 19, 0),
	(3334, 9, 'V7', 20, 0),
	(3335, 9, 'V7', 21, 0),
	(3336, 9, 'V7', 22, 0),
	(3337, 9, 'V7', 23, 0),
	(3338, 9, 'V7', 24, 0),
	(3339, 9, 'V7', 25, 0),
	(3340, 9, 'V7', 26, 0),
	(3341, 9, 'V7', 27, 0),
	(3342, 9, 'V7', 28, 0),
	(3343, 9, 'V7', 29, 0),
	(3344, 9, 'V7', 30, 0),
	(3345, 9, 'V7', 31, 0),
	(3346, 9, 'V7', 32, 0),
	(3347, 9, 'V7', 33, 0),
	(3348, 9, 'V7', 34, 0),
	(3349, 9, 'V7', 35, 0),
	(3350, 9, 'V7', 36, 0),
	(3351, 9, 'V7', 37, 0),
	(3352, 9, 'V7', 38, 0),
	(3353, 9, 'V7', 39, 0),
	(3354, 9, 'V7', 40, 0),
	(3355, 9, 'V7', 41, 0),
	(3356, 9, 'V7', 42, 0),
	(3357, 9, 'V7', 43, 0),
	(3358, 9, 'V7', 44, 0),
	(3359, 9, 'V7', 45, 0),
	(3360, 9, 'V7', 46, 0),
	(3361, 9, 'V7', 47, 0),
	(3362, 9, 'V7', 48, 0),
	(3363, 9, 'V7', 49, 0),
	(3364, 9, 'V7', 50, 0),
	(3365, 9, 'V7', 51, 0),
	(3366, 9, 'V7', 52, 0),
	(3367, 9, 'V7', 53, 0),
	(3368, 9, 'V7', 54, 0),
	(3369, 9, 'V7', 55, 0),
	(3370, 9, 'V7', 56, 0),
	(3371, 9, 'V7', 57, 0),
	(3372, 9, 'V7', 58, 0),
	(3373, 9, 'V7', 59, 0),
	(3374, 9, 'V7', 60, 1),
	(3375, 9, 'V7', 61, 1),
	(3376, 9, 'V7', 62, 1),
	(3377, 9, 'V7', 63, 1),
	(3378, 9, 'V7', 64, 1),
	(3379, 9, 'V7', 65, 1),
	(3380, 9, 'V7', 66, 1),
	(3381, 9, 'V7', 67, 1),
	(3382, 9, 'V7', 68, 1),
	(3383, 9, 'V7', 69, 1),
	(3384, 9, 'V7', 70, 1),
	(3385, 9, 'V7', 71, 1),
	(3386, 9, 'V7', 72, 1),
	(3387, 9, 'V7', 73, 1),
	(3388, 9, 'V7', 74, 1),
	(3389, 9, 'V7', 75, 0),
	(3390, 9, 'V7', 76, 0),
	(3391, 9, 'V7', 77, 0),
	(3392, 9, 'V7', 78, 0),
	(3393, 9, 'V7', 79, 0),
	(3394, 9, 'V7', 80, 0),
	(3395, 9, 'V7', 81, 0),
	(3396, 9, 'V7', 82, 0),
	(3397, 9, 'V7', 83, 0),
	(3398, 9, 'V7', 84, 0),
	(3399, 9, 'V7', 85, 0),
	(3400, 9, 'V7', 86, 0),
	(3401, 9, 'V7', 87, 0),
	(3402, 9, 'V7', 88, 0),
	(3403, 9, 'V7', 89, 0),
	(3404, 42, 'GP1', 0, 1),
	(3405, 42, 'GP1', 1, 1),
	(3406, 42, 'GP1', 2, 1),
	(3407, 42, 'GP1', 3, 1),
	(3408, 42, 'GP1', 4, 1),
	(3409, 42, 'GP1', 5, 1),
	(3410, 42, 'GP1', 6, 1),
	(3411, 42, 'GP1', 7, 1),
	(3412, 42, 'GP1', 8, 1),
	(3413, 42, 'GP1', 9, 1),
	(3414, 42, 'GP1', 10, 1),
	(3415, 42, 'GP1', 11, 1),
	(3416, 42, 'GP1', 12, 1),
	(3417, 42, 'GP1', 13, 1),
	(3418, 42, 'GP1', 14, 1),
	(3419, 42, 'GP1', 15, 0),
	(3420, 42, 'GP1', 16, 0),
	(3421, 42, 'GP1', 17, 0),
	(3422, 42, 'GP1', 18, 0),
	(3423, 42, 'GP1', 19, 0),
	(3424, 42, 'GP1', 20, 0),
	(3425, 42, 'GP1', 21, 0),
	(3426, 42, 'GP1', 22, 0),
	(3427, 42, 'GP1', 23, 0),
	(3428, 42, 'GP1', 24, 0),
	(3429, 42, 'GP1', 25, 0),
	(3430, 42, 'GP1', 26, 0),
	(3431, 42, 'GP1', 27, 0),
	(3432, 42, 'GP1', 28, 0),
	(3433, 42, 'GP1', 29, 0),
	(3434, 42, 'GP1', 30, 0),
	(3435, 42, 'GP1', 31, 0),
	(3436, 42, 'GP1', 32, 0),
	(3437, 42, 'GP1', 33, 0),
	(3438, 42, 'GP1', 34, 0),
	(3439, 42, 'GP1', 35, 0),
	(3440, 42, 'GP1', 36, 0),
	(3441, 42, 'GP1', 37, 0),
	(3442, 42, 'GP1', 38, 0),
	(3443, 42, 'GP1', 39, 0),
	(3444, 42, 'GP1', 40, 0),
	(3445, 42, 'GP1', 41, 0),
	(3446, 42, 'GP1', 42, 0),
	(3447, 42, 'GP1', 43, 0),
	(3448, 42, 'GP1', 44, 0),
	(3449, 42, 'GP1', 45, 0),
	(3450, 42, 'GP1', 46, 0),
	(3451, 42, 'GP1', 47, 0),
	(3452, 42, 'GP1', 48, 0),
	(3453, 42, 'GP1', 49, 0),
	(3454, 42, 'GP1', 50, 0),
	(3455, 42, 'GP1', 51, 0),
	(3456, 42, 'GP1', 52, 0),
	(3457, 42, 'GP1', 53, 0),
	(3458, 42, 'GP1', 54, 0),
	(3459, 42, 'GP1', 55, 0),
	(3460, 42, 'GP1', 56, 0),
	(3461, 42, 'GP1', 57, 0),
	(3462, 42, 'GP1', 58, 0),
	(3463, 42, 'GP1', 59, 0),
	(3464, 42, 'GP1', 60, 0),
	(3465, 42, 'GP1', 61, 0),
	(3466, 42, 'GP1', 62, 0),
	(3467, 42, 'GP1', 63, 0),
	(3468, 42, 'GP1', 64, 0),
	(3469, 42, 'GP1', 65, 0),
	(3470, 42, 'GP1', 66, 0),
	(3471, 42, 'GP1', 67, 0),
	(3472, 42, 'GP1', 68, 0),
	(3473, 42, 'GP1', 69, 0),
	(3474, 42, 'GP1', 70, 0),
	(3475, 42, 'GP1', 71, 0),
	(3476, 42, 'GP1', 72, 0),
	(3477, 42, 'GP1', 73, 0),
	(3478, 42, 'GP1', 74, 0),
	(3479, 42, 'GP1', 75, 0),
	(3480, 42, 'GP1', 76, 0),
	(3481, 42, 'GP1', 77, 0),
	(3482, 42, 'GP1', 78, 0),
	(3483, 42, 'GP1', 79, 0),
	(3484, 42, 'GP1', 80, 0),
	(3485, 42, 'GP1', 81, 0),
	(3486, 42, 'GP1', 82, 0),
	(3487, 42, 'GP1', 83, 0),
	(3488, 42, 'GP1', 84, 0),
	(3489, 42, 'GP1', 85, 0),
	(3490, 42, 'GP1', 86, 0),
	(3491, 42, 'GP1', 87, 0),
	(3492, 42, 'GP1', 88, 0),
	(3493, 42, 'GP1', 89, 0),
	(3494, 42, 'GP2', 0, 0),
	(3495, 42, 'GP2', 1, 0),
	(3496, 42, 'GP2', 2, 0),
	(3497, 42, 'GP2', 3, 0),
	(3498, 42, 'GP2', 4, 0),
	(3499, 42, 'GP2', 5, 0),
	(3500, 42, 'GP2', 6, 0),
	(3501, 42, 'GP2', 7, 0),
	(3502, 42, 'GP2', 8, 0),
	(3503, 42, 'GP2', 9, 0),
	(3504, 42, 'GP2', 10, 0),
	(3505, 42, 'GP2', 11, 0),
	(3506, 42, 'GP2', 12, 0),
	(3507, 42, 'GP2', 13, 0),
	(3508, 42, 'GP2', 14, 0),
	(3509, 42, 'GP2', 15, 0),
	(3510, 42, 'GP2', 16, 0),
	(3511, 42, 'GP2', 17, 0),
	(3512, 42, 'GP2', 18, 0),
	(3513, 42, 'GP2', 19, 0),
	(3514, 42, 'GP2', 20, 0),
	(3515, 42, 'GP2', 21, 0),
	(3516, 42, 'GP2', 22, 0),
	(3517, 42, 'GP2', 23, 0),
	(3518, 42, 'GP2', 24, 0),
	(3519, 42, 'GP2', 25, 0),
	(3520, 42, 'GP2', 26, 0),
	(3521, 42, 'GP2', 27, 0),
	(3522, 42, 'GP2', 28, 0),
	(3523, 42, 'GP2', 29, 0),
	(3524, 42, 'GP2', 30, 0),
	(3525, 42, 'GP2', 31, 0),
	(3526, 42, 'GP2', 32, 0),
	(3527, 42, 'GP2', 33, 0),
	(3528, 42, 'GP2', 34, 0),
	(3529, 42, 'GP2', 35, 0),
	(3530, 42, 'GP2', 36, 0),
	(3531, 42, 'GP2', 37, 0),
	(3532, 42, 'GP2', 38, 0),
	(3533, 42, 'GP2', 39, 0),
	(3534, 42, 'GP2', 40, 0),
	(3535, 42, 'GP2', 41, 0),
	(3536, 42, 'GP2', 42, 0),
	(3537, 42, 'GP2', 43, 0),
	(3538, 42, 'GP2', 44, 0),
	(3539, 42, 'GP2', 45, 1),
	(3540, 42, 'GP2', 46, 1),
	(3541, 42, 'GP2', 47, 1),
	(3542, 42, 'GP2', 48, 1),
	(3543, 42, 'GP2', 49, 1),
	(3544, 42, 'GP2', 50, 1),
	(3545, 42, 'GP2', 51, 1),
	(3546, 42, 'GP2', 52, 1),
	(3547, 42, 'GP2', 53, 1),
	(3548, 42, 'GP2', 54, 1),
	(3549, 42, 'GP2', 55, 1),
	(3550, 42, 'GP2', 56, 1),
	(3551, 42, 'GP2', 57, 1),
	(3552, 42, 'GP2', 58, 1),
	(3553, 42, 'GP2', 59, 1),
	(3554, 42, 'GP2', 60, 0),
	(3555, 42, 'GP2', 61, 0),
	(3556, 42, 'GP2', 62, 0),
	(3557, 42, 'GP2', 63, 0),
	(3558, 42, 'GP2', 64, 0),
	(3559, 42, 'GP2', 65, 0),
	(3560, 42, 'GP2', 66, 0),
	(3561, 42, 'GP2', 67, 0),
	(3562, 42, 'GP2', 68, 0),
	(3563, 42, 'GP2', 69, 0),
	(3564, 42, 'GP2', 70, 0),
	(3565, 42, 'GP2', 71, 0),
	(3566, 42, 'GP2', 72, 0),
	(3567, 42, 'GP2', 73, 0),
	(3568, 42, 'GP2', 74, 0),
	(3569, 42, 'GP2', 75, 0),
	(3570, 42, 'GP2', 76, 0),
	(3571, 42, 'GP2', 77, 0),
	(3572, 42, 'GP2', 78, 0),
	(3573, 42, 'GP2', 79, 0),
	(3574, 42, 'GP2', 80, 0),
	(3575, 42, 'GP2', 81, 0),
	(3576, 42, 'GP2', 82, 0),
	(3577, 42, 'GP2', 83, 0),
	(3578, 42, 'GP2', 84, 0),
	(3579, 42, 'GP2', 85, 0),
	(3580, 42, 'GP2', 86, 0),
	(3581, 42, 'GP2', 87, 0),
	(3582, 42, 'GP2', 88, 0),
	(3583, 42, 'GP2', 89, 0),
	(3584, 42, 'V1', 0, 1),
	(3585, 42, 'V1', 1, 1),
	(3586, 42, 'V1', 2, 1),
	(3587, 42, 'V1', 3, 1),
	(3588, 42, 'V1', 4, 1),
	(3589, 42, 'V1', 5, 1),
	(3590, 42, 'V1', 6, 1),
	(3591, 42, 'V1', 7, 1),
	(3592, 42, 'V1', 8, 1),
	(3593, 42, 'V1', 9, 1),
	(3594, 42, 'V1', 10, 1),
	(3595, 42, 'V1', 11, 1),
	(3596, 42, 'V1', 12, 1),
	(3597, 42, 'V1', 13, 1),
	(3598, 42, 'V1', 14, 1),
	(3599, 42, 'V1', 15, 1),
	(3600, 42, 'V1', 16, 1),
	(3601, 42, 'V1', 17, 1),
	(3602, 42, 'V1', 18, 1),
	(3603, 42, 'V1', 19, 1),
	(3604, 42, 'V1', 20, 1),
	(3605, 42, 'V1', 21, 1),
	(3606, 42, 'V1', 22, 1),
	(3607, 42, 'V1', 23, 1),
	(3608, 42, 'V1', 24, 1),
	(3609, 42, 'V1', 25, 1),
	(3610, 42, 'V1', 26, 1),
	(3611, 42, 'V1', 27, 1),
	(3612, 42, 'V1', 28, 1),
	(3613, 42, 'V1', 29, 1),
	(3614, 42, 'V1', 30, 1),
	(3615, 42, 'V1', 31, 1),
	(3616, 42, 'V1', 32, 1),
	(3617, 42, 'V1', 33, 1),
	(3618, 42, 'V1', 34, 1),
	(3619, 42, 'V1', 35, 0),
	(3620, 42, 'V1', 36, 0),
	(3621, 42, 'V1', 37, 0),
	(3622, 42, 'V1', 38, 0),
	(3623, 42, 'V1', 39, 0),
	(3624, 42, 'V1', 40, 0),
	(3625, 42, 'V1', 41, 0),
	(3626, 42, 'V1', 42, 0),
	(3627, 42, 'V1', 43, 0),
	(3628, 42, 'V1', 44, 0),
	(3629, 42, 'V1', 45, 0),
	(3630, 42, 'V1', 46, 0),
	(3631, 42, 'V1', 47, 0),
	(3632, 42, 'V1', 48, 0),
	(3633, 42, 'V1', 49, 0),
	(3634, 42, 'V1', 50, 0),
	(3635, 42, 'V1', 51, 0),
	(3636, 42, 'V1', 52, 0),
	(3637, 42, 'V1', 53, 0),
	(3638, 42, 'V1', 54, 0),
	(3639, 42, 'V1', 55, 0),
	(3640, 42, 'V1', 56, 0),
	(3641, 42, 'V1', 57, 0),
	(3642, 42, 'V1', 58, 0),
	(3643, 42, 'V1', 59, 0),
	(3644, 42, 'V1', 60, 0),
	(3645, 42, 'V1', 61, 0),
	(3646, 42, 'V1', 62, 0),
	(3647, 42, 'V1', 63, 0),
	(3648, 42, 'V1', 64, 0),
	(3649, 42, 'V1', 65, 0),
	(3650, 42, 'V1', 66, 0),
	(3651, 42, 'V1', 67, 0),
	(3652, 42, 'V1', 68, 0),
	(3653, 42, 'V1', 69, 0),
	(3654, 42, 'V1', 70, 0),
	(3655, 42, 'V1', 71, 0),
	(3656, 42, 'V1', 72, 0),
	(3657, 42, 'V1', 73, 0),
	(3658, 42, 'V1', 74, 0),
	(3659, 42, 'V1', 75, 0),
	(3660, 42, 'V1', 76, 0),
	(3661, 42, 'V1', 77, 0),
	(3662, 42, 'V1', 78, 0),
	(3663, 42, 'V1', 79, 0),
	(3664, 42, 'V1', 80, 0),
	(3665, 42, 'V1', 81, 0),
	(3666, 42, 'V1', 82, 0),
	(3667, 42, 'V1', 83, 0),
	(3668, 42, 'V1', 84, 0),
	(3669, 42, 'V1', 85, 0),
	(3670, 42, 'V1', 86, 0),
	(3671, 42, 'V1', 87, 0),
	(3672, 42, 'V1', 88, 0),
	(3673, 42, 'V1', 89, 0),
	(3674, 42, 'V2', 0, 0),
	(3675, 42, 'V2', 1, 0),
	(3676, 42, 'V2', 2, 0),
	(3677, 42, 'V2', 3, 0),
	(3678, 42, 'V2', 4, 0),
	(3679, 42, 'V2', 5, 0),
	(3680, 42, 'V2', 6, 0),
	(3681, 42, 'V2', 7, 0),
	(3682, 42, 'V2', 8, 0),
	(3683, 42, 'V2', 9, 0),
	(3684, 42, 'V2', 10, 0),
	(3685, 42, 'V2', 11, 0),
	(3686, 42, 'V2', 12, 0),
	(3687, 42, 'V2', 13, 0),
	(3688, 42, 'V2', 14, 0),
	(3689, 42, 'V2', 15, 0),
	(3690, 42, 'V2', 16, 0),
	(3691, 42, 'V2', 17, 0),
	(3692, 42, 'V2', 18, 0),
	(3693, 42, 'V2', 19, 0),
	(3694, 42, 'V2', 20, 0),
	(3695, 42, 'V2', 21, 0),
	(3696, 42, 'V2', 22, 0),
	(3697, 42, 'V2', 23, 0),
	(3698, 42, 'V2', 24, 0),
	(3699, 42, 'V2', 25, 0),
	(3700, 42, 'V2', 26, 0),
	(3701, 42, 'V2', 27, 0),
	(3702, 42, 'V2', 28, 0),
	(3703, 42, 'V2', 29, 0),
	(3704, 42, 'V2', 30, 0),
	(3705, 42, 'V2', 31, 0),
	(3706, 42, 'V2', 32, 0),
	(3707, 42, 'V2', 33, 0),
	(3708, 42, 'V2', 34, 0),
	(3709, 42, 'V2', 35, 0),
	(3710, 42, 'V2', 36, 0),
	(3711, 42, 'V2', 37, 0),
	(3712, 42, 'V2', 38, 0),
	(3713, 42, 'V2', 39, 0),
	(3714, 42, 'V2', 40, 0),
	(3715, 42, 'V2', 41, 0),
	(3716, 42, 'V2', 42, 0),
	(3717, 42, 'V2', 43, 0),
	(3718, 42, 'V2', 44, 0),
	(3719, 42, 'V2', 45, 1),
	(3720, 42, 'V2', 46, 1),
	(3721, 42, 'V2', 47, 1),
	(3722, 42, 'V2', 48, 1),
	(3723, 42, 'V2', 49, 1),
	(3724, 42, 'V2', 50, 1),
	(3725, 42, 'V2', 51, 1),
	(3726, 42, 'V2', 52, 1),
	(3727, 42, 'V2', 53, 1),
	(3728, 42, 'V2', 54, 1),
	(3729, 42, 'V2', 55, 1),
	(3730, 42, 'V2', 56, 1),
	(3731, 42, 'V2', 57, 1),
	(3732, 42, 'V2', 58, 1),
	(3733, 42, 'V2', 59, 1),
	(3734, 42, 'V2', 60, 1),
	(3735, 42, 'V2', 61, 1),
	(3736, 42, 'V2', 62, 1),
	(3737, 42, 'V2', 63, 1),
	(3738, 42, 'V2', 64, 1),
	(3739, 42, 'V2', 65, 1),
	(3740, 42, 'V2', 66, 1),
	(3741, 42, 'V2', 67, 1),
	(3742, 42, 'V2', 68, 1),
	(3743, 42, 'V2', 69, 1),
	(3744, 42, 'V2', 70, 0),
	(3745, 42, 'V2', 71, 0),
	(3746, 42, 'V2', 72, 0),
	(3747, 42, 'V2', 73, 0),
	(3748, 42, 'V2', 74, 0),
	(3749, 42, 'V2', 75, 0),
	(3750, 42, 'V2', 76, 0),
	(3751, 42, 'V2', 77, 0),
	(3752, 42, 'V2', 78, 0),
	(3753, 42, 'V2', 79, 0),
	(3754, 42, 'V2', 80, 0),
	(3755, 42, 'V2', 81, 0),
	(3756, 42, 'V2', 82, 0),
	(3757, 42, 'V2', 83, 0),
	(3758, 42, 'V2', 84, 0),
	(3759, 42, 'V2', 85, 0),
	(3760, 42, 'V2', 86, 0),
	(3761, 42, 'V2', 87, 0),
	(3762, 42, 'V2', 88, 0),
	(3763, 42, 'V2', 89, 0),
	(3764, 42, 'V3', 0, 0),
	(3765, 42, 'V3', 1, 0),
	(3766, 42, 'V3', 2, 0),
	(3767, 42, 'V3', 3, 0),
	(3768, 42, 'V3', 4, 0),
	(3769, 42, 'V3', 5, 0),
	(3770, 42, 'V3', 6, 0),
	(3771, 42, 'V3', 7, 0),
	(3772, 42, 'V3', 8, 0),
	(3773, 42, 'V3', 9, 0),
	(3774, 42, 'V3', 10, 0),
	(3775, 42, 'V3', 11, 0),
	(3776, 42, 'V3', 12, 0),
	(3777, 42, 'V3', 13, 0),
	(3778, 42, 'V3', 14, 0),
	(3779, 42, 'V3', 15, 0),
	(3780, 42, 'V3', 16, 0),
	(3781, 42, 'V3', 17, 0),
	(3782, 42, 'V3', 18, 0),
	(3783, 42, 'V3', 19, 0),
	(3784, 42, 'V3', 20, 0),
	(3785, 42, 'V3', 21, 0),
	(3786, 42, 'V3', 22, 0),
	(3787, 42, 'V3', 23, 0),
	(3788, 42, 'V3', 24, 0),
	(3789, 42, 'V3', 25, 0),
	(3790, 42, 'V3', 26, 0),
	(3791, 42, 'V3', 27, 0),
	(3792, 42, 'V3', 28, 0),
	(3793, 42, 'V3', 29, 0),
	(3794, 42, 'V3', 30, 0),
	(3795, 42, 'V3', 31, 0),
	(3796, 42, 'V3', 32, 0),
	(3797, 42, 'V3', 33, 0),
	(3798, 42, 'V3', 34, 0),
	(3799, 42, 'V3', 35, 0),
	(3800, 42, 'V3', 36, 0),
	(3801, 42, 'V3', 37, 0),
	(3802, 42, 'V3', 38, 0),
	(3803, 42, 'V3', 39, 0),
	(3804, 42, 'V3', 40, 0),
	(3805, 42, 'V3', 41, 0),
	(3806, 42, 'V3', 42, 0),
	(3807, 42, 'V3', 43, 0),
	(3808, 42, 'V3', 44, 0),
	(3809, 42, 'V3', 45, 0),
	(3810, 42, 'V3', 46, 0),
	(3811, 42, 'V3', 47, 0),
	(3812, 42, 'V3', 48, 0),
	(3813, 42, 'V3', 49, 0),
	(3814, 42, 'V3', 50, 0),
	(3815, 42, 'V3', 51, 0),
	(3816, 42, 'V3', 52, 0),
	(3817, 42, 'V3', 53, 0),
	(3818, 42, 'V3', 54, 0),
	(3819, 42, 'V3', 55, 0),
	(3820, 42, 'V3', 56, 0),
	(3821, 42, 'V3', 57, 0),
	(3822, 42, 'V3', 58, 0),
	(3823, 42, 'V3', 59, 0),
	(3824, 42, 'V3', 60, 0),
	(3825, 42, 'V3', 61, 0),
	(3826, 42, 'V3', 62, 0),
	(3827, 42, 'V3', 63, 0),
	(3828, 42, 'V3', 64, 0),
	(3829, 42, 'V3', 65, 0),
	(3830, 42, 'V3', 66, 0),
	(3831, 42, 'V3', 67, 0),
	(3832, 42, 'V3', 68, 0),
	(3833, 42, 'V3', 69, 0),
	(3834, 42, 'V3', 70, 1),
	(3835, 42, 'V3', 71, 1),
	(3836, 42, 'V3', 72, 1),
	(3837, 42, 'V3', 73, 1),
	(3838, 42, 'V3', 74, 1),
	(3839, 42, 'V3', 75, 1),
	(3840, 42, 'V3', 76, 1),
	(3841, 42, 'V3', 77, 1),
	(3842, 42, 'V3', 78, 1),
	(3843, 42, 'V3', 79, 1),
	(3844, 42, 'V3', 80, 1),
	(3845, 42, 'V3', 81, 1),
	(3846, 42, 'V3', 82, 1),
	(3847, 42, 'V3', 83, 1),
	(3848, 42, 'V3', 84, 1),
	(3849, 42, 'V3', 85, 1),
	(3850, 42, 'V3', 86, 1),
	(3851, 42, 'V3', 87, 1),
	(3852, 42, 'V3', 88, 1),
	(3853, 42, 'V3', 89, 1);

-- Dumping structure for view sa_luksofori.view_digital
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `view_digital` (
	`object_id` INT(10) NOT NULL,
	`signal_code` VARCHAR(10) NOT NULL COLLATE 'utf8mb4_general_ci',
	`second_num` INT(10) NOT NULL COMMENT 'Sekunde ciklā (0-cycle_time)',
	`state_name` VARCHAR(7) NULL COLLATE 'utf8mb4_0900_ai_ci',
	`state` TINYINT(3) NOT NULL COMMENT '0=STOP, 1=GO, 2=CAUTION'
) ENGINE=MyISAM;

-- Dumping structure for view sa_luksofori.view_signals_simple
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `view_signals_simple` (
	`obj_id` INT(10) NOT NULL,
	`obj_name` VARCHAR(100) NOT NULL COLLATE 'utf8mb4_general_ci',
	`signal_code` VARCHAR(10) NOT NULL COMMENT 'V1, V4, GP1 utt.' COLLATE 'utf8mb4_general_ci',
	`type_char` VARCHAR(1) NULL COLLATE 'utf8mb4_0900_ai_ci',
	`type_code` TINYINT(3) NOT NULL COMMENT '1=V, 2=A, 3=P',
	`duration_sec` INT(10) NOT NULL COMMENT 'Zaļā/aktīvā fāze',
	`offset_sec` INT(10) NULL COMMENT 'Nobīve cikla sākumā',
	`end_sec` BIGINT(19) NULL
) ENGINE=MyISAM;

-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `view_digital`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `view_digital` AS select `signal_states`.`object_id` AS `object_id`,`signal_states`.`signal_code` AS `signal_code`,`signal_states`.`second_num` AS `second_num`,(case `signal_states`.`state` when 0 then 'STOP' when 1 then 'GO' when 2 then 'CAUTION' end) AS `state_name`,`signal_states`.`state` AS `state` from `signal_states` order by `signal_states`.`object_id`,`signal_states`.`signal_code`,`signal_states`.`second_num`;

-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `view_signals_simple`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `view_signals_simple` AS select `o`.`id` AS `obj_id`,`o`.`name` AS `obj_name`,`s`.`signal_code` AS `signal_code`,(case `s`.`type_code` when 1 then 'V' when 2 then 'A' when 3 then 'P' end) AS `type_char`,`s`.`type_code` AS `type_code`,`s`.`duration_sec` AS `duration_sec`,`s`.`offset_sec` AS `offset_sec`,(`s`.`offset_sec` + `s`.`duration_sec`) AS `end_sec` from (`objects` `o` join `signals` `s` on((`o`.`id` = `s`.`object_id`))) order by `o`.`id`,`s`.`signal_code`;

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
