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

CREATE TABLE app_meta (table_name TEXT PRIMARY KEY, schema_hash TEXT NOT NULL);
CREATE TABLE IF NOT EXISTS "accounts" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT UNIQUE, comment TEXT);
CREATE TABLE sqlite_sequence(name,seq);
CREATE TABLE IF NOT EXISTS "frequencies" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT UNIQUE, comment TEXT);
CREATE TABLE IF NOT EXISTS "subscriptions" (id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, name TEXT UNIQUE, is_active INTEGER, is_renew INTEGER, amount REAL, account_id INTEGER, frequencie_id INTEGER, expxiry DATE, key TEXT, reference TEXT, site TEXT, comment TEXT, FOREIGN KEY(frequencie_id) REFERENCES frequencies(id), FOREIGN KEY(account_id) REFERENCES accounts(id));


-- DATA: accounts
INSERT INTO accounts VALUES(1,'2025-11-26 08:31:28','Mastercard',NULL);
INSERT INTO accounts VALUES(2,'2025-11-26 08:31:36','PayPal',NULL);

-- DATA: app_meta
INSERT INTO app_meta VALUES('accounts','0f0edf91153d7640d121ad750ec0be8ea88a29b1');
INSERT INTO app_meta VALUES('frequencies','6ee80ea88388b4afed3d34eaa4dd437e67fd8c5e');
INSERT INTO app_meta VALUES('subscriptions','d409930f459fa89d12aa089ec333f7136837cd0c');

-- DATA: frequencies
INSERT INTO frequencies VALUES(1,'2025-11-26 08:31:55','Yearly',NULL);
INSERT INTO frequencies VALUES(2,'2025-11-26 08:32:08','Monthly',NULL);
INSERT INTO frequencies VALUES(3,'2025-11-26 08:32:25','Other',NULL);

-- DATA: subscriptions
INSERT INTO subscriptions VALUES(1,'2025-11-26 08:37:32','Cyberghost',1,1,85.019999999999996019,1,1,'9/5/2026','gen6723311d75-e66be','ch_3OWDuyIPuSwjvuwt1auoREzg',NULL,NULL);