99Isuru/Reef_Fish_Identifier

1import sqlite3
2
3conn = sqlite3.connect("fish.db")
4cur = conn.cursor()
5
6cur.execute("""
7CREATE TABLE IF NOT EXISTS fish (
8    scientific_name TEXT PRIMARY KEY,
9    authority TEXT,
10    common_name TEXT,
11    family TEXT,
12    total_length_cm REAL,
13    distribution TEXT,
14    iucn_status TEXT,
15    dorsal_spines INTEGER,
16    dorsal_soft_rays TEXT,
17    anal_spines INTEGER,
18    anal_soft_rays TEXT,
19    body_shape TEXT,
20    image TEXT
21)
22""")
23
24conn.commit()
25conn.close()
26print("✅ Database created")
27
28
29