4n7LUnpP

1import sqlite3
2 
3conn = sqlite3.connect("sessions.db")
4 
5cursor = conn.cursor()
6
7cursor.execute("DROP TABLE IF EXISTS sessions")
8cursor.execute("""
9               CREATE TABLE IF NOT EXISTS sessions(
10                  id INTEGER PRIMARY KEY AUTOINCREMENT,
11                  bike TEXT,
12                  date TEXT,
13                  timestart INTEGER,
14                  timeend INTEGER,
15                  duration INTEGER,
16                  meters INTEGER
17               )
18""")
19
20conn.close()
21
22mod('../main').init()