-- Export generated by tools/export_sql.php
-- App: Trading
-- Source DB: Trading.db
-- Generated: 2026-03-31T14:47:53+00:00

CREATE TABLE app_meta (table_name TEXT PRIMARY KEY, schema_hash TEXT NOT NULL);
CREATE TABLE IF NOT EXISTS "watching" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, code_id INTEGER,       sector_id INTEGER,       ta_setup TEXT,       ta_conditions TEXT,       entry_low REAL,       entry_high REAL,       sl REAL,       risk_pct REAL,       target REAL,       ta_comment TEXT, ta_invalidation TEXT, ta_rr_rules TEXT, R REAL, pattern_entry TEXT, trigger_price REAL, result_r REAL, setup TEXT, invalidation TEXT, status_id INTEGER, formula_r TEXT,       FOREIGN KEY(code_id) REFERENCES codes(id),       FOREIGN KEY(sector_id) REFERENCES sectors(id));
CREATE TABLE sqlite_sequence(name,seq);
CREATE TABLE IF NOT EXISTS "trades" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, code_id INTEGER,       sector_id INTEGER,       entry REAL,       sl REAL,       target REAL,       result_r REAL,       is_open INTEGER,       is_closed INTEGER,       ta_comment TEXT,       FOREIGN KEY(code_id) REFERENCES codes(id),       FOREIGN KEY(sector_id) REFERENCES sectors(id));
CREATE TABLE IF NOT EXISTS "Pre_Trade_Checklist" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_confirmed INTEGER,       cl_entry INTEGER,       cl_sl INTEGER,       cl_ps INTEGER,       ta_comment TEXT);
CREATE TABLE IF NOT EXISTS "Trade_Plan_Template" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, code TEXT,       sector TEXT,       ta_setup TEXT,       ta_conditions TEXT,       timeframe TEXT,       entry TEXT,       sl REAL,       risk_pct REAL,       target REAL,       ta_comment TEXT);
CREATE TABLE IF NOT EXISTS "codes" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT UNIQUE,       ta_desc TEXT);
CREATE TABLE IF NOT EXISTS "sectors" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT UNIQUE,       ta_desc TEXT);
CREATE TABLE IF NOT EXISTS "NT_setup_Checklist" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, cl_dhd INTEGER,       cl_mtsf INTEGER,       cl_chd INTEGER,       cl_iin INTEGER,       ta_comment TEXT, cl_css INTEGER, cl_oih INTEGER, cl_stz INTEGER, cl_cass INTEGER, cl_smw INTEGER, cl_as INTEGER, cl_tps INTEGER, cl_comment TEXT, cl_ts INTEGER);
CREATE TABLE IF NOT EXISTS "status" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT UNIQUE,       ta_desc TEXT);


-- DATA: NT_setup_Checklist
INSERT INTO NT_setup_Checklist VALUES(1,'2026-02-28 02:10:23',1,1,0,0,NULL,0,1,1,1,0,0,0,'',0);

-- DATA: Pre_Trade_Checklist
INSERT INTO Pre_Trade_Checklist VALUES(1,'2026-02-18 01:38:20',0,0,0,0,NULL);

-- DATA: Trade_Plan_Template

-- DATA: app_meta
INSERT INTO app_meta VALUES('watching','6d67fb7f1fafa204f09dec7abe1385afcc86ce47');
INSERT INTO app_meta VALUES('trades','14a0e3a48a9361dc939cbb084543550f29b851a0');
INSERT INTO app_meta VALUES('Pre_Trade_Checklist','9a79d99b3eb5144723f255117d9b9110ad7cdafb');
INSERT INTO app_meta VALUES('Trade_Plan_Template','0f2f01ab34a41315842329e924fbf137b6b448a3');
INSERT INTO app_meta VALUES('codes','a1c0dc80afd3809324741e9dcb2c204aea468335');
INSERT INTO app_meta VALUES('sectors','8decd596c8648f1ece63c611783d65e8a0924116');
INSERT INTO app_meta VALUES('NT_setup_Checklist','26853e7edfb72bfadc232eaa331d4dc3de9220a2');
INSERT INTO app_meta VALUES('status','6e38c624a0fe4407caf75075d2c280a5755adb87');

-- DATA: codes
INSERT INTO codes VALUES(1,'2026-02-18 01:38:56','ANZ','ANZ GROUP HOLDINGS LIMITED ORDINARY FULLY PAID');
INSERT INTO codes VALUES(2,'2026-02-20 01:26:51','CSL','CSL LIMITED ORDINARY FULLY PAID');
INSERT INTO codes VALUES(3,'2026-02-28 02:57:02','BHP','BHP GROUP LIMITED ORDINARY FULLY PAID');
INSERT INTO codes VALUES(4,'2026-02-28 02:57:12','RIO','RIO TINTO LIMITED ORDINARY FULLY PAID');
INSERT INTO codes VALUES(5,'2026-02-28 02:57:30','CBA','COMMONWEALTH BANK OF AUSTRALIA. ORDINARY FULLY PAID');
INSERT INTO codes VALUES(6,'2026-02-28 02:58:20','SUN','SUNCORP GROUP LIMITED ORDINARY FULLY PAID');
INSERT INTO codes VALUES(7,'2026-03-04 02:54:54','WBC',NULL);
INSERT INTO codes VALUES(8,'2026-03-04 02:55:03','NAB',NULL);
INSERT INTO codes VALUES(9,'2026-03-16 06:38:01','eld',NULL);
INSERT INTO codes VALUES(10,'2026-03-16 06:38:09','elv',NULL);

-- DATA: sectors
INSERT INTO sectors VALUES(1,'2026-02-18 01:39:12','Banks',NULL);
INSERT INTO sectors VALUES(2,'2026-02-20 01:33:55','Pharmaceuticals, Biotechnology & Life Sciences',NULL);
INSERT INTO sectors VALUES(3,'2026-02-28 02:58:43','Materials',NULL);
INSERT INTO sectors VALUES(4,'2026-02-28 03:00:03','Metals & Mining',NULL);
INSERT INTO sectors VALUES(5,'2026-02-28 03:10:15','Insurance',NULL);

-- DATA: status
INSERT INTO status VALUES(1,'2026-03-31 05:25:46','RED','Invalid / avoid');
INSERT INTO status VALUES(2,'2026-03-31 05:26:30','YELLOW','Watch / not confirmed');
INSERT INTO status VALUES(3,'2026-03-31 05:27:06','GREEN','Ready / valid setup');

-- DATA: trades
INSERT INTO trades VALUES(1,'2026-03-16 06:38:38',9,NULL,NULL,NULL,NULL,NULL,0,0,NULL);
INSERT INTO trades VALUES(2,'2026-03-16 06:39:01',10,NULL,NULL,NULL,NULL,NULL,0,0,NULL);

-- DATA: watching
INSERT INTO watching VALUES(2,'2026-02-20 01:49:36',2,2,replace(replace('Potential structural reversal candidate\r\n---------------------------------------\r\nStatus: Major downtrend attempting base.\r\nTrigger: Weekly close above 180 for structural shift.\r\nBias: Neutral until structure shifts\r\n\r\n','\r',char(13)),'\n',char(10)),replace(replace('Higher low form on the weekly\r\nWeekly bullish close with expansion\r\nRSI push back above 40–45\r\nMACD histogram turning up\r\nIdeally with strong volume','\r',char(13)),'\n',char(10)),NULL,NULL,NULL,NULL,NULL,NULL,'Close Below Support ~150','????',NULL,'Weekly Close above resistance ~180',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO watching VALUES(3,'2026-02-28 03:03:20',3,4,'check for continuation or breakout',replace(replace('close above 49.8-50 pluss confirmation\r\nPullback\r\n→ reclaim of structure\r\n→ bullish follow-through','\r',char(13)),'\n',char(10)),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO watching VALUES(4,'2026-02-28 03:03:44',4,4,'check for continuation or breakout',replace(replace('Hold above reclaimed structure around 158–160 and continue through 161–162 with bullish confirmation.\r\n','\r',char(13)),'\n',char(10)),158.0,161.99999999999999999,153.99999999999999999,NULL,170.0,NULL,replace(replace('Fails if price loses reclaimed structure and closes back below ~154. This would weaken the continuation setup.\r\n','\r',char(13)),'\n',char(10)),replace(replace('Target 1 = 170 (~1.3R)\r\nTarget 2 = 180 (~2.7R)\r\nPrefer entry on hold / pullback confirmation rather than chasing extended strength.\r\n','\r',char(13)),'\n',char(10)),NULL,'Pullback continuation',161.0,1.2900000000000000355,NULL,NULL,3,NULL);
INSERT INTO watching VALUES(5,'2026-02-28 03:04:06',5,1,'check for continuation or breakout',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,replace(replace('- Minimum target must be ≥ 2R\r\n- Stop must be no wider than defined pullback low\r\n- Partial profit at 1R if structure intact','\r',char(13)),'\n',char(10)),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO watching VALUES(6,'2026-02-28 03:05:05',6,5,replace(replace('possible bottoming, its dropping quite well, we have a good bullish engulfing candle-a single engulfing candle does not confirm  trend change\r\nits not yet a confirmed reversal\r\nAfter the engulfing candle we want to see:Another bullish candle or a consolidation followed by expansion\r\nIdeally the chart does something like this:Bullish engulfing (done)\r\nSmall pullback\r\nHigher low\r\nBreak above 16 (16.5 is better, this is the resistance)\r\nSo now we watch the next few candles, Good behaviour would be: 15.6 → 15.9 → small pullback → push toward 16.5\r\nIf price closes above resistance we get: Higher low, Break of resistance, Reversal confirmation\r\nThey almost always build structure first: Low, Higher low, Higher high','\r',char(13)),'\n',char(10)),replace(replace('	•	Pullback holds above ~15.2–15.5 zone\r\n	•	Forms higher low\r\n	•	Push back toward resistance\r\n	•	Enter on break / confirmation above 16.5\r\n','\r',char(13)),'\n',char(10)),15.199999999999999289,15.599999999999999644,14.900000000000000355,NULL,17.999999999999999999,replace(replace('One more small thing I like about your SUN chart\r\n-----------------------------------------------\r\nThe bounce came exactly at the lower Bollinger band on the weekly.\r\nThat’s where exhaustion moves often start.\r\nIt doesn’t guarantee reversal — but it increases the probability of a tradable rally.\r\n','\r',char(13)),'\n',char(10)),replace(replace('Fails if price loses higher low structure and closes below ~15.0\r\nThis would invalidate the reversal → continuation idea','\r',char(13)),'\n',char(10)),replace(replace('Prefer entry after pullback and confirmation above resistance.\r\nAvoid chasing extended moves.\r\nTrade only valid if structure holds and R is acceptable.\r\n','\r',char(13)),'\n',char(10)),NULL,'Small pullback / higher low / continuation through resistance',16.600000000000001421,0.8000000000000000444,NULL,NULL,3,NULL);
INSERT INTO watching VALUES(7,'2026-03-04 02:55:41',7,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,replace(replace('- Daily close below key structure level\r\n- Break of higher low on daily timeframe\r\n- Loss of prior support zone\r\n- Strong bearish engulfing candle at level\r\n- Close below 20 EMA on daily\r\n- Close below 50 MA on daily\r\n- Volume expansion on downside break\r\n- Failure to hold VWAP (intraday)\r\n- Failed breakout (false break and close back inside range)\r\n- Lower high forms after entry\r\n- Momentum divergence against position\r\n- RSI loses 50 level\r\n- Macro/sector rotation against trade\r\n- Thesis no longer valid','\r',char(13)),'\n',char(10)),replace(replace('- Minimum target must be ≥ 2R\r\n- Stop must be no wider than defined pullback low\r\n- Partial profit at 1R if structure intact','\r',char(13)),'\n',char(10)),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO watching VALUES(8,'2026-03-04 02:55:58',8,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,replace(replace('- Daily close below key structure level\r\n- Break of higher low on daily timeframe\r\n- Loss of prior support zone\r\n- Strong bearish engulfing candle at level\r\n- Close below 20 EMA on daily\r\n- Close below 50 MA on daily\r\n- Volume expansion on downside break\r\n- Failure to hold VWAP (intraday)\r\n- Failed breakout (false break and close back inside range)\r\n- Lower high forms after entry\r\n- Momentum divergence against position\r\n- RSI loses 50 level\r\n- Macro/sector rotation against trade\r\n- Thesis no longer valid','\r',char(13)),'\n',char(10)),replace(replace('- Minimum target must be ≥ 2R\r\n- Stop must be no wider than defined pullback low\r\n- Partial profit at 1R if structure intact','\r',char(13)),'\n',char(10)),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);