Spaces:
Paused
Paused
File size: 874 Bytes
2cdc05c |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
import sqlite3
def init_db():
conn = sqlite3.connect('game.db')
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE IF NOT EXISTS players (
id INTEGER PRIMARY KEY AUTOINCREMENT,
username TEXT UNIQUE,
location TEXT,
inventory TEXT
)
''')
cursor.execute('''
CREATE TABLE IF NOT EXISTS game_world (
id INTEGER PRIMARY KEY AUTOINCREMENT,
location TEXT UNIQUE,
description TEXT,
items TEXT
)
''')
cursor.execute('''
CREATE TABLE IF NOT EXISTS interactions (
id INTEGER PRIMARY KEY AUTOINCREMENT,
player_id INTEGER,
action TEXT,
result TEXT,
timestamp DATETIME DEFAULT CURRENT_TIMESTAMP
)
''')
conn.commit()
conn.close()
init_db()
|