PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE users (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            username TEXT UNIQUE NOT NULL,
            email TEXT UNIQUE NOT NULL,
            password_hash TEXT NOT NULL,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
        );
INSERT INTO users VALUES(3,'rosly','mamakemrosly@gmail.com','0a08b8117fca22afb7ea1ba38216add5c7dab9574a689c2d04acfb587d0ea88e','2026-05-12 12:35:12');
CREATE TABLE predictions (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            user_id INTEGER NOT NULL,
            image_path TEXT NOT NULL,
            predicted_class TEXT NOT NULL,
            confidence REAL NOT NULL,
            all_predictions TEXT,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, image_url TEXT,
            FOREIGN KEY (user_id) REFERENCES users (id)
        );
INSERT INTO predictions VALUES(15,3,'/static/uploads/0ff79c94-1466-4cf4-b1a9-4a6ed71ee6da_image.jpg','trash',0.966138184070587158,'{"battery": 0.0003114229184575379, "biological": 0.0018871838692575693, "brown-glass": 0.0001699666172498837, "cardboard": 0.00014502232079394162, "clothes": 0.0009530826937407255, "green-glass": 0.0008419877849519253, "metal": 0.002559387357905507, "paper": 0.0010681642452254891, "plastic": 0.01037166453897953, "shoes": 0.011428941041231155, "trash": 0.9661381840705872, "white-glass": 0.004125077277421951}','2026-05-12 12:35:33','/static/uploads/0ff79c94-1466-4cf4-b1a9-4a6ed71ee6da_image.jpg');
INSERT INTO predictions VALUES(16,3,'/static/uploads/867c8809-16f9-4bc2-9c2f-763471cd9388_image.jpg','battery',0.966897785663604736,'{"battery": 0.9668977856636047, "biological": 5.661144678015262e-05, "brown-glass": 0.0009046181221492589, "cardboard": 0.0005820824299007654, "clothes": 6.053773176972754e-05, "green-glass": 4.09618005505763e-05, "metal": 0.009143846109509468, "paper": 0.02000255510210991, "plastic": 0.001700820866972208, "shoes": 0.00011447992437751964, "trash": 0.0003171983698848635, "white-glass": 0.00017849539290182292}','2026-05-12 12:35:46','/static/uploads/867c8809-16f9-4bc2-9c2f-763471cd9388_image.jpg');
INSERT INTO predictions VALUES(17,3,'/static/uploads/e4c7dff2-3a11-4586-b260-5356aa5e6392_image.jpg','biological',0.845708310604095459,'{"battery": 0.0076080686412751675, "biological": 0.8457083106040955, "brown-glass": 0.048524409532547, "cardboard": 0.00397450290620327, "clothes": 0.002265630755573511, "green-glass": 0.012831157073378563, "metal": 0.02651715651154518, "paper": 0.0037325662560760975, "plastic": 0.0022942007053643465, "shoes": 0.03851614519953728, "trash": 0.0052048019133508205, "white-glass": 0.0028230103198438883}','2026-05-12 12:36:06','/static/uploads/e4c7dff2-3a11-4586-b260-5356aa5e6392_image.jpg');
INSERT INTO predictions VALUES(18,3,'/static/uploads/bb015cd0-50a4-4ea9-9659-9350a5a12fe4_image.jpg','brown-glass',0.993579626083374023,'{"battery": 8.200757292797789e-05, "biological": 0.00019369021174497902, "brown-glass": 0.993579626083374, "cardboard": 4.4033895392203704e-05, "clothes": 3.9906357415020466e-05, "green-glass": 0.0007554902695119381, "metal": 0.0010120738297700882, "paper": 5.588194653682876e-06, "plastic": 0.00020358464098535478, "shoes": 7.031216227915138e-05, "trash": 3.5942071008321363e-06, "white-glass": 0.004010089207440615}','2026-05-12 12:36:20','/static/uploads/bb015cd0-50a4-4ea9-9659-9350a5a12fe4_image.jpg');
INSERT INTO predictions VALUES(19,3,'/static/uploads/28703e90-dc32-4280-b94a-c1ab41dacfa1_image.jpg','cardboard',0.597537457942962646,'{"battery": 0.03238697722554207, "biological": 0.0011777587933465838, "brown-glass": 0.004269774071872234, "cardboard": 0.5975374579429626, "clothes": 0.0015866897301748395, "green-glass": 0.0017555936938151717, "metal": 0.029820438474416733, "paper": 0.3199402093887329, "plastic": 0.0003561356570571661, "shoes": 0.007938257418572903, "trash": 0.0012706907000392675, "white-glass": 0.0019600477535277605}','2026-05-12 12:36:45','/static/uploads/28703e90-dc32-4280-b94a-c1ab41dacfa1_image.jpg');
INSERT INTO predictions VALUES(20,3,'/static/uploads/358bbbe1-3348-4a67-a668-0f32ccde39e3_image.jpg','clothes',0.986677169799804687,'{"battery": 0.00017501490947324783, "biological": 0.0006832935614511371, "brown-glass": 0.0003816693788394332, "cardboard": 0.0010520822834223509, "clothes": 0.9866771697998047, "green-glass": 4.726319821202196e-05, "metal": 0.0002748695551417768, "paper": 0.009993955492973328, "plastic": 8.35228493087925e-05, "shoes": 0.00024895661044865847, "trash": 0.000215244508581236, "white-glass": 0.00016693588986527175}','2026-05-12 12:36:58','/static/uploads/358bbbe1-3348-4a67-a668-0f32ccde39e3_image.jpg');
INSERT INTO predictions VALUES(21,3,'/static/uploads/3c94020d-c216-4e90-b08b-5a45a7f43837_image.jpg','biological',0.94701772928237915,'{"battery": 0.003660338232293725, "biological": 0.9470177292823792, "brown-glass": 0.0020243669860064983, "cardboard": 0.0060153440572321415, "clothes": 0.0017862897366285324, "green-glass": 0.018068350851535797, "metal": 0.0032605156302452087, "paper": 0.0014871302992105484, "plastic": 0.011756766587495804, "shoes": 0.001320696552284062, "trash": 0.002252401551231742, "white-glass": 0.001350079313851893}','2026-05-12 12:37:17','/static/uploads/3c94020d-c216-4e90-b08b-5a45a7f43837_image.jpg');
INSERT INTO predictions VALUES(22,3,'/static/uploads/838a27ea-206a-4f43-b391-b7f607c05291_image.jpg','metal',0.909292995929718017,'{"battery": 0.025598565116524696, "biological": 0.00014258357987273484, "brown-glass": 0.002586630405858159, "cardboard": 0.04848402738571167, "clothes": 3.53949872078374e-05, "green-glass": 0.0004242008435539901, "metal": 0.909292995929718, "paper": 0.005297597963362932, "plastic": 0.0006470357766374946, "shoes": 0.00015009530761744827, "trash": 0.00029692210955545306, "white-glass": 0.007043892052024603}','2026-05-12 12:37:30','/static/uploads/838a27ea-206a-4f43-b391-b7f607c05291_image.jpg');
INSERT INTO predictions VALUES(23,3,'/static/uploads/5f857488-bb66-402f-a374-c3b08a1d46ce_image.jpg','plastic',0.914946258068084716,'{"battery": 0.00025791654479689896, "biological": 0.00018221995560452342, "brown-glass": 0.0020960760302841663, "cardboard": 3.5126929560647113e-06, "clothes": 0.0001185745932161808, "green-glass": 0.014035980217158794, "metal": 0.0018937725108116865, "paper": 0.00012169042020104825, "plastic": 0.9149462580680847, "shoes": 0.0005647654179483652, "trash": 0.011286349967122078, "white-glass": 0.054492875933647156}','2026-05-12 12:38:00','/static/uploads/5f857488-bb66-402f-a374-c3b08a1d46ce_image.jpg');
INSERT INTO predictions VALUES(24,3,'/static/uploads/27dd2dff-0978-4b62-8052-2f8d1fe5e8be_image.jpg','shoes',0.998957276344299316,'{"battery": 0.00021586798538919538, "biological": 7.421237114613177e-06, "brown-glass": 0.00049113406566903, "cardboard": 1.6651032638037577e-05, "clothes": 1.0783202924358193e-05, "green-glass": 5.830590089317411e-05, "metal": 0.0001993448386201635, "paper": 8.442228136118501e-06, "plastic": 2.163072167604696e-05, "shoes": 0.9989572763442993, "trash": 5.736601906392025e-06, "white-glass": 7.396457476716023e-06}','2026-05-12 12:38:18','/static/uploads/27dd2dff-0978-4b62-8052-2f8d1fe5e8be_image.jpg');
INSERT INTO predictions VALUES(25,3,'/static/uploads/e15bc51f-d33f-45c3-aa06-973883f36b5a_image.jpg','shoes',0.997832119464874267,'{"battery": 0.0002688053937163204, "biological": 0.00010848297097254544, "brown-glass": 0.0005952693172730505, "cardboard": 3.492266478133388e-05, "clothes": 0.0003216952318325639, "green-glass": 1.8404180082143284e-05, "metal": 0.0006790523184463382, "paper": 6.715604831697419e-05, "plastic": 5.7165962061844766e-05, "shoes": 0.9978321194648743, "trash": 1.0608629054331686e-05, "white-glass": 6.255726020754082e-06}','2026-05-12 12:38:36','/static/uploads/e15bc51f-d33f-45c3-aa06-973883f36b5a_image.jpg');
INSERT INTO predictions VALUES(26,3,'/static/uploads/d9baf721-49bb-4cd1-a994-87467191b9a8_image.jpg','shoes',0.998209357261657714,'{"battery": 9.238364873453975e-05, "biological": 2.4525052140234038e-05, "brown-glass": 0.00026595822419039905, "cardboard": 0.00013593005132861435, "clothes": 4.2248018871759996e-05, "green-glass": 2.5902629204210825e-05, "metal": 0.0010483769001439214, "paper": 6.55092517263256e-05, "plastic": 6.124960054876283e-05, "shoes": 0.9982093572616577, "trash": 1.4215022019925527e-05, "white-glass": 1.4382885638042353e-05}','2026-05-12 12:38:49','/static/uploads/d9baf721-49bb-4cd1-a994-87467191b9a8_image.jpg');
INSERT INTO predictions VALUES(27,3,'/static/uploads/b2b5f10a-bd8f-43d6-a2aa-4a3c975279c0_image.jpg','trash',0.706486105918884277,'{"battery": 0.0004721448931377381, "biological": 0.019440731033682823, "brown-glass": 0.0010099452920258045, "cardboard": 0.0018515593837946653, "clothes": 0.007966974750161171, "green-glass": 0.010206187143921852, "metal": 0.026035021990537643, "paper": 0.0404096320271492, "plastic": 0.09804090857505798, "shoes": 0.023023780435323715, "trash": 0.7064861059188843, "white-glass": 0.06505715101957321}','2026-05-12 12:39:05','/static/uploads/b2b5f10a-bd8f-43d6-a2aa-4a3c975279c0_image.jpg');
INSERT INTO predictions VALUES(28,3,'/static/uploads/9db2ab34-6167-4b19-a017-c11e9629407c_image.jpg','paper',0.979501903057098388,'{"battery": 0.00844046100974083, "biological": 0.00044638130930252373, "brown-glass": 0.00029364562942646444, "cardboard": 0.0014411516021937132, "clothes": 0.00034075771691277623, "green-glass": 0.00035828311229124665, "metal": 0.0053158970549702644, "paper": 0.9795019030570984, "plastic": 0.0013949329731985927, "shoes": 0.002202995354309678, "trash": 0.00014585490862373263, "white-glass": 0.00011778472253354266}','2026-05-12 12:39:26','/static/uploads/9db2ab34-6167-4b19-a017-c11e9629407c_image.jpg');
INSERT INTO predictions VALUES(29,3,'/static/uploads/82902c62-af3f-42a5-a908-21b5aa5e22f6_image.jpg','plastic',0.87916111946105957,'{"battery": 0.0006709658773615956, "biological": 8.58051935210824e-05, "brown-glass": 0.0002828730794135481, "cardboard": 7.96501353761414e-06, "clothes": 2.985876562888734e-05, "green-glass": 0.0001913887244882062, "metal": 0.03899155184626579, "paper": 0.0005917061353102326, "plastic": 0.8791611194610596, "shoes": 1.972095196833834e-05, "trash": 0.00031624859548173845, "white-glass": 0.07965079694986343}','2026-05-12 12:40:02','/static/uploads/82902c62-af3f-42a5-a908-21b5aa5e22f6_image.jpg');
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('users',3);
INSERT INTO sqlite_sequence VALUES('predictions',29);
COMMIT;
