19 lines
562 B
SQL
19 lines
562 B
SQL
DROP TABLE IF EXISTS guild_ranks_defaults;
|
|
CREATE TABLE guild_ranks_defaults (
|
|
id INTEGER PRIMARY KEY,
|
|
rank_id INTEGER NOT NULL DEFAULT 0,
|
|
rank_name TEXT NOT NULL UNIQUE,
|
|
permission1 INTEGER NOT NULL DEFAULT 0,
|
|
permission2 INTEGER NOT NULL DEFAULT 0
|
|
);
|
|
|
|
INSERT INTO guild_ranks_defaults VALUES
|
|
(1,0,'Leader',4294967295,4294967295),
|
|
(2,1,'Senior Officer',4294967295,4294967295),
|
|
(3,2,'Officer',6320242,0),
|
|
(4,3,'Senior Member',24576,0),
|
|
(5,4,'Member',24576,0),
|
|
(6,5,'Junior Member',24576,0),
|
|
(7,6,'Initiate',24576,0),
|
|
(8,7,'Recruit',24576,0);
|