-- -- File generated with SQLiteStudio v3.4.4 on Fr may 10 15:37:34 2024 -- -- Text encoding used: System -- PRAGMA foreign_keys = off; BEGIN TRANSACTION; -- Table: jobs DROP TABLE IF EXISTS jobs; CREATE TABLE jobs ( id_job INTEGER PRIMARY KEY AUTOINCREMENT, id_stage INTEGER REFERENCES stages (id_stage) ON DELETE CASCADE NOT NULL, symbol TEXT NOT NULL DEFAULT EURGBP, period TEXT NOT NULL DEFAULT H1, tester_inputs TEXT, status TEXT CHECK (status IN ('Queued', 'Processing', 'Done') ) NOT NULL DEFAULT Queued ); INSERT INTO jobs (id_job, id_stage, symbol, period, tester_inputs, status) VALUES (1, 1, 'EURGBP', 'H1', '; === open signal parameters signalPeriod_=12||12||2||240||N signalDeviation_=0.7||0.1||0.1||2.0||Y signaAddlDeviation_=0.9||0.1||0.1||2.0||N ; === pending order parameters openDistance_=150||0||50||150||Y stopLevel_=10000||200.0||200.0||20000.0||N takeLevel_=85||100||100||2000.0||Y ordersExpiration_=10000||1000||1000||60000||N ; === money management parameters maxCountOfOrders_=3||3||1||30||N ', 'Queued'); INSERT INTO jobs (id_job, id_stage, symbol, period, tester_inputs, status) VALUES (2, 1, 'EURGBP', 'M30', '; === open signal parameters signalPeriod_=12||12||2||240||N signalDeviation_=0.7||0.1||0.1||2.0||Y signaAddlDeviation_=0.9||0.1||0.1||2.0||N ; === pending order parameters openDistance_=150||0||50||150||Y stopLevel_=10000||200.0||200.0||20000.0||N takeLevel_=85||100||100||2000.0||Y ordersExpiration_=10000||1000||1000||60000||N ; === money management parameters maxCountOfOrders_=3||3||1||30||N ', 'Queued'); INSERT INTO jobs (id_job, id_stage, symbol, period, tester_inputs, status) VALUES (3, 1, 'EURGBP', 'M15', '; === open signal parameters signalPeriod_=12||12||2||240||N signalDeviation_=0.7||0.1||0.1||2.0||Y signaAddlDeviation_=0.9||0.1||0.1||2.0||N ; === pending order parameters openDistance_=150||0||50||150||Y stopLevel_=10000||200.0||200.0||20000.0||N takeLevel_=85||100||100||2000.0||Y ordersExpiration_=10000||1000||1000||60000||N ; === money management parameters maxCountOfOrders_=3||3||1||30||N ', 'Queued'); INSERT INTO jobs (id_job, id_stage, symbol, period, tester_inputs, status) VALUES (4, 1, 'EURUSD', 'H1', '; === open signal parameters signalPeriod_=12||12||2||240||N signalDeviation_=0.7||0.1||0.1||2.0||Y signaAddlDeviation_=0.9||0.1||0.1||2.0||N ; === pending order parameters openDistance_=150||0||50||150||Y stopLevel_=10000||200.0||200.0||20000.0||N takeLevel_=85||100||100||2000.0||Y ordersExpiration_=10000||1000||1000||60000||N ; === money management parameters maxCountOfOrders_=3||3||1||30||N ', 'Queued'); INSERT INTO jobs (id_job, id_stage, symbol, period, tester_inputs, status) VALUES (5, 1, 'EURUSD', 'M30', '; === open signal parameters signalPeriod_=12||12||2||240||N signalDeviation_=0.7||0.1||0.1||2.0||Y signaAddlDeviation_=0.9||0.1||0.1||2.0||N ; === pending order parameters openDistance_=150||0||50||150||Y stopLevel_=10000||200.0||200.0||20000.0||N takeLevel_=85||100||100||2000.0||Y ordersExpiration_=10000||1000||1000||60000||N ; === money management parameters maxCountOfOrders_=3||3||1||30||N ', 'Queued'); INSERT INTO jobs (id_job, id_stage, symbol, period, tester_inputs, status) VALUES (6, 1, 'EURUSD', 'M15', '; === open signal parameters signalPeriod_=12||12||2||240||N signalDeviation_=0.7||0.1||0.1||2.0||Y signaAddlDeviation_=0.9||0.1||0.1||2.0||N ; === pending order parameters openDistance_=150||0||50||150||Y stopLevel_=10000||200.0||200.0||20000.0||N takeLevel_=85||100||100||2000.0||Y ordersExpiration_=10000||1000||1000||60000||N ; === money management parameters maxCountOfOrders_=3||3||1||30||N ', 'Queued'); INSERT INTO jobs (id_job, id_stage, symbol, period, tester_inputs, status) VALUES (7, 1, 'GBPUSD', 'H1', '; === open signal parameters signalPeriod_=12||12||2||240||N signalDeviation_=0.7||0.1||0.1||2.0||Y signaAddlDeviation_=0.9||0.1||0.1||2.0||N ; === pending order parameters openDistance_=150||0||50||150||Y stopLevel_=10000||200.0||200.0||20000.0||N takeLevel_=85||100||100||2000.0||Y ordersExpiration_=10000||1000||1000||60000||N ; === money management parameters maxCountOfOrders_=3||3||1||30||N ', 'Queued'); INSERT INTO jobs (id_job, id_stage, symbol, period, tester_inputs, status) VALUES (8, 1, 'GBPUSD', 'M30', '; === open signal parameters signalPeriod_=12||12||2||240||N signalDeviation_=0.7||0.1||0.1||2.0||Y signaAddlDeviation_=0.9||0.1||0.1||2.0||N ; === pending order parameters openDistance_=150||0||50||150||Y stopLevel_=10000||200.0||200.0||20000.0||N takeLevel_=85||100||100||2000.0||Y ordersExpiration_=10000||1000||1000||60000||N ; === money management parameters maxCountOfOrders_=3||3||1||30||N ', 'Queued'); INSERT INTO jobs (id_job, id_stage, symbol, period, tester_inputs, status) VALUES (9, 1, 'GBPUSD', 'M15', '; === open signal parameters signalPeriod_=12||12||2||240||N signalDeviation_=0.7||0.1||0.1||2.0||Y signaAddlDeviation_=0.9||0.1||0.1||2.0||N ; === pending order parameters openDistance_=150||0||50||150||Y stopLevel_=10000||200.0||200.0||20000.0||N takeLevel_=85||100||100||2000.0||Y ordersExpiration_=10000||1000||1000||60000||N ; === money management parameters maxCountOfOrders_=3||3||1||30||N ', 'Queued'); -- Table: passes DROP TABLE IF EXISTS passes; CREATE TABLE passes ( id_pass INTEGER PRIMARY KEY AUTOINCREMENT, id_task INTEGER REFERENCES tasks (id_task) ON DELETE CASCADE, pass INTEGER, initial_deposit REAL, withdrawal REAL, profit REAL, gross_profit REAL, gross_loss REAL, max_profittrade REAL, max_losstrade REAL, conprofitmax REAL, conprofitmax_trades REAL, max_conwins REAL, max_conprofit_trades REAL, conlossmax REAL, conlossmax_trades REAL, max_conlosses REAL, max_conloss_trades REAL, balancemin REAL, balance_dd REAL, balancedd_percent REAL, balance_ddrel_percent REAL, balance_dd_relative REAL, equitymin REAL, equity_dd REAL, equitydd_percent REAL, equity_ddrel_percent REAL, equity_dd_relative REAL, expected_payoff REAL, profit_factor REAL, recovery_factor REAL, sharpe_ratio REAL, min_marginlevel REAL, deals REAL, trades REAL, profit_trades REAL, loss_trades REAL, short_trades REAL, long_trades REAL, profit_shorttrades REAL, profit_longtrades REAL, profittrades_avgcon REAL, losstrades_avgcon REAL, complex_criterion REAL, custom_ontester REAL, params TEXT, inputs TEXT, pass_date DATETIME DEFAULT (datetime('now') ) NOT NULL ); -- Table: projects DROP TABLE IF EXISTS projects; CREATE TABLE projects ( id_project INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, version TEXT NOT NULL, description TEXT, params TEXT, status TEXT CHECK (status IN ('Created', 'Queued', 'Processing', 'Done') ) NOT NULL DEFAULT Created ); INSERT INTO projects (id_project, name, version, description, params, status) VALUES (1, 'SimpleVolumes', '1.07', NULL, NULL, 'Queued'); -- Table: stages DROP TABLE IF EXISTS stages; CREATE TABLE stages ( id_stage INTEGER PRIMARY KEY AUTOINCREMENT, id_project INTEGER REFERENCES projects (id_project) ON DELETE CASCADE, id_parent_stage INTEGER REFERENCES stages (id_stage) ON DELETE CASCADE, name TEXT NOT NULL DEFAULT (1), expert TEXT, symbol TEXT NOT NULL DEFAULT EURGBP, period TEXT NOT NULL DEFAULT H1, optimization INTEGER NOT NULL DEFAULT (2), model INTEGER NOT NULL DEFAULT (2), from_date DATE NOT NULL DEFAULT ('2022.01.01'), to_date DATE NOT NULL DEFAULT ('2022.06.01'), forward_mode INTEGER NOT NULL DEFAULT (0), forward_date DATE, deposit INTEGER NOT NULL DEFAULT (10000), currency TEXT NOT NULL DEFAULT USD, profit_in_pips INTEGER NOT NULL DEFAULT (0), leverage INTEGER NOT NULL DEFAULT (200), execution_mode INTEGER NOT NULL DEFAULT (0), optimization_criterion INTEGER NOT NULL DEFAULT (7), status TEXT CHECK (status IN ('Queue', 'Process', 'Done') ) NOT NULL DEFAULT 'Queue' ); INSERT INTO stages (id_stage, id_project, id_parent_stage, name, expert, symbol, period, optimization, model, from_date, to_date, forward_mode, forward_date, deposit, currency, profit_in_pips, leverage, execution_mode, optimization_criterion, status) VALUES (1, 1, NULL, 'First', 'SimpleVolumesExpertSingle.ex5', 'EURGBP', 'H1', 2, 2, '2022.01.01', '2022.06.01', 0, NULL, 10000, 'USD', 0, 200, 0, 7, 'Queue'); -- Table: tasks DROP TABLE IF EXISTS tasks; CREATE TABLE tasks ( id_task INTEGER PRIMARY KEY AUTOINCREMENT, id_job INTEGER NOT NULL REFERENCES jobs (id_job) ON DELETE CASCADE, optimization_criterion INTEGER DEFAULT (7) NOT NULL, start_date DATETIME, finish_date DATETIME, status TEXT CHECK (status IN ('Queued', 'Processing', 'Done') ) NOT NULL DEFAULT Queued ); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (37, 1, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (38, 2, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (39, 3, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (40, 4, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (41, 5, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (42, 6, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (43, 7, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (44, 8, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (45, 9, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (46, 1, 0, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (47, 2, 0, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (48, 3, 0, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (49, 4, 0, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (50, 5, 0, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (51, 6, 0, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (52, 7, 0, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (53, 8, 0, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (54, 9, 0, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (55, 1, 1, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (56, 2, 1, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (57, 3, 1, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (58, 4, 1, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (59, 5, 1, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (60, 6, 1, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (61, 7, 1, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (62, 8, 1, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (63, 9, 1, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (64, 1, 2, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (65, 2, 2, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (66, 3, 2, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (67, 4, 2, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (68, 5, 2, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (69, 6, 2, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (70, 7, 2, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (71, 8, 2, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (72, 9, 2, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (73, 1, 3, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (74, 2, 3, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (75, 3, 3, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (76, 4, 3, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (77, 5, 3, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (78, 6, 3, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (79, 7, 3, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (80, 8, 3, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (81, 9, 3, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (82, 1, 4, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (83, 2, 4, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (84, 3, 4, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (85, 4, 4, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (86, 5, 4, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (87, 6, 4, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (88, 7, 4, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (89, 8, 4, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (90, 9, 4, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (91, 1, 5, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (92, 2, 5, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (93, 3, 5, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (94, 4, 5, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (95, 5, 5, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (96, 6, 5, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (97, 7, 5, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (98, 8, 5, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (99, 9, 5, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (100, 1, 6, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (101, 2, 6, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (102, 3, 6, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (103, 4, 6, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (104, 5, 6, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (105, 6, 6, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (106, 7, 6, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (107, 8, 6, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (108, 9, 6, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (109, 1, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (110, 2, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (111, 3, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (112, 4, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (113, 5, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (114, 6, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (115, 7, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (116, 8, 7, NULL, NULL, 'Queued'); INSERT INTO tasks (id_task, id_job, optimization_criterion, start_date, finish_date, status) VALUES (117, 9, 7, NULL, NULL, 'Queued'); COMMIT TRANSACTION; PRAGMA foreign_keys = on;