Peradventure/setup_db

25 lines
490 B
Plaintext
Raw Permalink Normal View History

2024-03-17 16:54:08 -05:00
#!/bin/bash
sqlite3 database.sqlite3 "
CREATE TABLE IF NOT EXISTS map (
id INTEGER PRIMARY KEY AUTOINCREMENT,
x TEXT,
y TEXT,
occupied_by_type TEXT,
occupied_by_id INTEGER
);
CREATE TABLE IF NOT EXISTS entity_ref (
id INTEGER PRIMARY KEY AUTOINCREMENT,
entity_id INTEGER,
type TEXT,
hp INTEGER,
inventory_ref INTEGER
);
2024-03-18 15:31:53 -05:00
CREATE TABLE IF NOT EXISTS player_inventory (
2024-03-17 16:54:08 -05:00
id INTEGER PRIMARY KEY AUTOINCREMENT,
type TEXT,
quantity INTEGER,
func_ref TEXT
)
"