84 lines
8.5 KiB
SQL
84 lines
8.5 KiB
SQL
PRAGMA foreign_keys=OFF;
|
|
BEGIN TRANSACTION;
|
|
CREATE TABLE admins (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
username TEXT UNIQUE,
|
|
password TEXT
|
|
);
|
|
INSERT INTO admins VALUES(1,'admin','$2b$10$pBGE/HCOaqHzcvwowYtb7evVcxXTDjd6AAI03SSNqyjpmC/0VZ6Xa');
|
|
CREATE TABLE users (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
|
|
vorname TEXT,
|
|
nachname TEXT,
|
|
|
|
strasse TEXT,
|
|
hausnummer TEXT,
|
|
plz TEXT,
|
|
ort TEXT,
|
|
land TEXT,
|
|
|
|
mobil TEXT,
|
|
telefon TEXT,
|
|
email TEXT,
|
|
|
|
iban TEXT,
|
|
bic TEXT,
|
|
kontoinhaber TEXT,
|
|
mandatsreferenz TEXT,
|
|
|
|
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
|
|
, gesperrt INTEGER DEFAULT 0, vertragsnummer TEXT, vertragsvariante INTEGER, geburtsdatum TEXT, zustimmung_agb INTEGER DEFAULT 0, zustimmung_sepa INTEGER DEFAULT 0, zustimmung_einverstaendnis INTEGER DEFAULT 0, zustimmung_datum TEXT, zustimmung_ip TEXT, vertragsversion TEXT, widerruf_moeglich_bis TEXT, widerrufen_am TEXT, widerrufen_von_ip TEXT, status TEXT DEFAULT 'aktiv');
|
|
INSERT INTO users VALUES(11,'Cay','Joksch','Calle la Fuente','24','38628','San Miguel de Abina','Deutschland','01752547854','','info@joksch-it.ch','87e2461b0c35c8d5ff345498edbb06bf:d2c26512d662c2cd075bf5ecf9bc97f645f77d58497b8a70a97231ce4ffc664e','64ef2f37012c7a65d9408bf92ab05eb3:798b946c92bf5cdd1e78b6c35fd6bfa5','Cay Josch','gfhmf','2026-01-01 14:12:33',0,'PF-2026-000001',2,NULL,1,1,1,'2026-01-01T14:12:33.508Z','::1','v1.0','2026-01-15T14:12:33.508Z',NULL,NULL,'aktiv');
|
|
INSERT INTO users VALUES(12,'Cay','Joksch','Calle la Fuente','24','38628','San Miguel de Abina','Deutschland','01752547854','','info@joksch-it.ch','9b80b9ba378d5d56e0d86ab34e22a027:62ff75f664b1e03e65f483a9a13637a9f09180eacda25ee011175705bf491e0a','b451e90412e44d2bbc08e5713960ad2d:7b57fbfde3e822f181a16d8799f9d63b','Cay Josch','gfhmffgh','2026-01-01 14:15:20',0,'PF-2026-000002',2,NULL,1,1,1,'2026-01-01T14:15:20.564Z','::1','v1.0','2026-01-15T14:15:20.564Z',NULL,NULL,'aktiv');
|
|
INSERT INTO users VALUES(13,'Cay','Joksch','Calle la Fuente','24','38628','San Miguel de Abina','Deutschland','01752547854','','info@joksch-it.ch','d0a0f4d51ea3eaabd8ef821027ff8705:9714ca174140e67693632a5550445a364cf761dc1bb0f8da81c50f63437e6269','44f98047304d75fa4f415b599faee4ee:0707cfddefa99cfc3d2eb1b7dbe1f21e','Cay Josch','Test5','2026-01-01 14:16:34',0,'PF-2026-000003',2,NULL,1,1,1,'2026-01-01T14:16:34.304Z','::1','v1.0','2026-01-15T14:16:34.304Z',NULL,NULL,'aktiv');
|
|
INSERT INTO users VALUES(14,'Cay','Joksch','Calle la Fuente','24','38628','San Miguel de Abina','Deutschland','01752547854','','info@joksch-it.ch','d85c6adb3ae6929a2c006e0d91322243:b95a025c3beff69b7d5fd366d2098e6dc249b283331a62a48075ea8ffd078496','c452e42ebc9644f12afdeb3a6cad5417:81cb4ebc87eb58e4157d63bcb2ec208b','Cay Josch','Test5frg','2026-01-01 14:18:31',0,'PF-2026-000004',2,NULL,1,1,1,'2026-01-01T14:18:31.901Z','::1','v1.0','2026-01-15T14:18:31.901Z',NULL,NULL,'aktiv');
|
|
INSERT INTO users VALUES(15,'Cay','Joksch','Calle la Fuente','24','38628','San Miguel de Abina','Deutschland','01752547854','','info@joksch-it.ch','cf0a9ebd22fd00aea1b0bd8f2d9421ba:b70bacd3c749c95e21b9c57a3ea3b52cc4305a775e3df8b54d7104b507e3eb9b','3cc0d07c371303ecc694dfb15776bde2:5c09d1960e9a5aedb62f459da43cd53f','Cay Josch','Test5frgatr','2026-01-01 14:40:18',0,'PF-2026-000005',2,NULL,1,1,1,'2026-01-01T14:40:18.359Z','::1','v1.0','2026-01-15T14:40:18.359Z',NULL,NULL,'aktiv');
|
|
INSERT INTO users VALUES(16,'Cay','Joksch','Calle la Fuente','24','38628','San Miguel de Abina','Deutschland','01752547854','','info@joksch-it.ch','df01b1fa17ec2c455dda2cb98601f46a:eab3206f0302edcf6a6c2ad004a96914b93dc52b4376a76a20937ec1f34327af','4936be0722aba26f8700a215a1f8ea28:7665b8e08415ff9530913cdb2f8e0081','Cay Josch','Test5frgatreatrg','2026-01-01 14:49:06',0,'PF-2026-000006',2,NULL,1,1,1,'2026-01-01T14:49:06.163Z','::1','v1.0','2026-01-15T14:49:06.163Z',NULL,NULL,'aktiv');
|
|
INSERT INTO users VALUES(17,'Cay','Joksch','Calle la Fuente','24','38628','San Miguel de Abina','Deutschland','01752547854','','info@joksch-it.ch','63efccca02c1ee8c36a11c19f9c979e9:544b48d591856c5804e63362c4283dbe43af59fc2c80d7d8cff1c9baf5162abf','60d353623c0cf566190cdc368313e464:33e894b1e3745697650789dccc2ea42a','Cay Josch','Test5fdrgatr','2026-01-01 14:56:37',0,'PF-2026-000007',2,NULL,1,1,1,'2026-01-01T14:56:37.161Z','::1','v1.0','2026-01-15T14:56:37.161Z',NULL,NULL,'aktiv');
|
|
INSERT INTO users VALUES(18,'Cay','Joksch','Calle la Fuente','24','38628','San Miguel de Abina','Deutschland','01752547854','','info@joksch-it.ch','c840f0478d2bdaa61e506323a9fe3ccd:d767b360f7da53c0d2af975757700d1b612bcabc1a4f83996e04eb1d694b9083','05fdb262a838590d60ad2bfe741e1824:f092846733f47f7765b5e0d05ab5ec9e','Cay Josch','Test5fdrgtgdratr','2026-01-01 15:00:57',0,'PF-2026-000008',2,NULL,1,1,1,'2026-01-01T15:00:57.142Z','::1','v1.0','2026-01-15T15:00:57.143Z',NULL,NULL,'aktiv');
|
|
INSERT INTO users VALUES(19,'Cay','Joksch','Calle la Fuente','24','38628','San Miguel de Abina','Deutschland','01752547854','','info@joksch-it.ch','2d08eec4d0f6c23a8250b7758f9983cd:c6da689ada651c112bd2b7696a7a655b39e2598dfe85b5e572547353f4ac5126','e41d283c5c6ede67d0b3efab5d86e801:7e7d7d01c02f3b66562a5202637e39d5','Cay Josch','Test5fdrgatrgu','2026-01-01 15:03:38',0,'PF-2026-000009',2,NULL,1,1,1,'2026-01-01T15:03:38.139Z','::1','v1.0','2026-01-15T15:03:38.139Z',NULL,NULL,'aktiv');
|
|
INSERT INTO users VALUES(20,'Cay','Joksch','Calle la Fuente','24','38628','San Miguel de Abina','Deutschland','01752547854','','info@joksch-it.ch','6b09922ad92a750d538a22a212ce4fc3:e9ee0e5c6cc50955dc4c202964b0cce7b72692fc958e03ffbd0859a125489386','d250fbfec033d4452c4f6fa92d8461eb:2b7b441b16d917e3f64db6793a14139a','Cay Josch','Teshzt5fdrgatr','2026-01-01 15:05:18',0,'PF-2026-000010',2,NULL,1,1,1,'2026-01-01T15:05:18.719Z','::1','v1.0','2026-01-15T15:05:18.719Z',NULL,NULL,'aktiv');
|
|
INSERT INTO users VALUES(21,'Cay','Joksch','Calle la Fuente','24','38628','San Miguel de Abina','Deutschland','01752547854','','info@joksch-it.ch','b397d96f81ffebf71719f29bc4f09432:2f7fa6910bdf6a4a7e7a60ffb77845eca1b1d93a5fae98c3071e955904b71f90','1d3bf3724e415f98794b7ef0c3aaa2df:ec87c540227a716c44572ba260a0f324','Cay Josch','Teshzt5sdefdrgatr','2026-01-01 15:08:47',0,'PF-2026-000011',2,NULL,1,1,1,'2026-01-01T15:08:47.171Z','::1','v1.0','2026-01-15T15:08:47.171Z',NULL,NULL,'aktiv');
|
|
INSERT INTO users VALUES(22,'Cay','Joksch','Calle la Fuente','24','38628','San Miguel de Abina','Deutschland','01752547854','','info@joksch-it.ch','df3e334a94454bf1009a95b68e53a82f:6f4f08cd7faf653bb8b863511842650b419ab8cd893f1ad17e3d28578b6218ef','174d68e5d089d80e23bb9bdf6c9ea72a:8bdd73a85e2e8cf0ab5dd2cd999122b8','Cay Josch','Teshzt5sdtefdrgatr','2026-01-01 15:11:31',0,'PF-2026-000012',2,NULL,1,1,1,'2026-01-01T15:11:31.037Z','::1','v1.0','2026-01-15T15:11:31.037Z',NULL,NULL,'aktiv');
|
|
INSERT INTO users VALUES(23,'Cay','Joksch','Calle la Fuente','24','38628','San Miguel de Abina','Deutschland','01752547854','','info@joksch-it.ch','90784a704431acb0e6a712a951a3cb59:478996c21dd5f05ca7188d8e908536bd29de0c83dce16da29a87576b107275b3','e14aa36ceacc212c429764fc50021bef:4638c43c1ab2b694e00a0ea08a093229','Cay Josch','Teshzt5sgfhdtefdrgatr','2026-01-01 15:14:30',0,'PF-2026-000013',2,NULL,1,1,1,'2026-01-01T15:14:30.773Z','::1','v1.0','2026-01-15T15:14:30.773Z',NULL,NULL,'aktiv');
|
|
CREATE TABLE vertragsarten (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
name TEXT NOT NULL,
|
|
laufzeit INTEGER NOT NULL,
|
|
betrag REAL NOT NULL,
|
|
aktiv INTEGER DEFAULT 1,
|
|
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
|
|
, beschreibung TEXT);
|
|
INSERT INTO vertragsarten VALUES(1,'Test',12,79.0,1,'2025-12-30 17:43:51',' Das ist ein Test wie der Vertrag heissen soll und was er kann');
|
|
INSERT INTO vertragsarten VALUES(2,'test2',24,50.0,1,'2025-12-30 18:00:54','skifrwjüpigjürwbghA ');
|
|
CREATE TABLE company (
|
|
id INTEGER PRIMARY KEY CHECK (id = 1),
|
|
|
|
firmenname TEXT NOT NULL,
|
|
strasse TEXT,
|
|
hausnummer TEXT,
|
|
plz TEXT,
|
|
ort TEXT,
|
|
land TEXT,
|
|
|
|
telefon TEXT,
|
|
email TEXT,
|
|
web TEXT,
|
|
|
|
iban TEXT,
|
|
bic TEXT,
|
|
glaeubiger_id TEXT,
|
|
|
|
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
INSERT INTO company VALUES(1,'Plusfit24','Lohweg','33','85375','Neufahrn b. Freising','Deutschland','+49 174 9677163','info@fitplus24.de','https://plusfit24.de/','','','','2025-12-30 18:39:52');
|
|
PRAGMA writable_schema=ON;
|
|
CREATE TABLE IF NOT EXISTS sqlite_sequence(name,seq);
|
|
DELETE FROM sqlite_sequence;
|
|
INSERT INTO sqlite_sequence VALUES('admins',1);
|
|
INSERT INTO sqlite_sequence VALUES('users',23);
|
|
INSERT INTO sqlite_sequence VALUES('vertragsarten',2);
|
|
PRAGMA writable_schema=OFF;
|
|
COMMIT;
|