17 lines
383 B
SQL
17 lines
383 B
SQL
DROP TABLE IF EXISTS users;
|
|
DROP TABLE IF EXISTS entities;
|
|
|
|
PRAGMA foreign_keys = ON;
|
|
|
|
CREATE TABLE IF NOT EXISTS users (
|
|
id INTEGER PRIMARY KEY,
|
|
name VARCHAR(64) UNIQUE
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS entities (
|
|
id INTEGER PRIMARY KEY,
|
|
user_id INTEGER NOT NULL,
|
|
name VARCHAR(64),
|
|
spawn_line VARCHAR(64),
|
|
FOREIGN KEY(user_id) REFERENCES users(id)
|
|
);
|