11 lines
302 B
SQL
11 lines
302 B
SQL
DROP TABLE IF EXISTS guilds;
|
|
CREATE TABLE guilds (
|
|
id INTEGER PRIMARY KEY,
|
|
name TEXT NOT NULL DEFAULT '' UNIQUE,
|
|
motd TEXT,
|
|
level INTEGER NOT NULL DEFAULT 1,
|
|
xp INTEGER NOT NULL DEFAULT 0,
|
|
xp_needed INTEGER NOT NULL DEFAULT 0,
|
|
formed_on INTEGER NOT NULL DEFAULT 0
|
|
);
|