mirror of
https://gitlab.com/openrsc/openrsc
synced 2026-08-16 08:23:06 -04:00
26 lines
1 KiB
Text
26 lines
1 KiB
Text
|
DROP TABLE IF EXISTS `clan`;
|
||
|
|
CREATE TABLE IF NOT EXISTS `clan`
|
||
|
|
(
|
||
|
|
`id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
`name` varchar(16) NOT NULL,
|
||
|
|
`tag` varchar(5) NOT NULL,
|
||
|
|
`leader` varchar(12) NOT NULL,
|
||
|
|
`kick_setting` tinyint(2) NOT NULL DEFAULT 1,
|
||
|
|
`invite_setting` tinyint(2) NOT NULL DEFAULT 1,
|
||
|
|
`allow_search_join` tinyint(2) NOT NULL DEFAULT 2,
|
||
|
|
`matches_won` mediumint(5) NOT NULL DEFAULT 0,
|
||
|
|
`matches_lost` mediumint(5) NOT NULL DEFAULT 0,
|
||
|
|
`clan_points` int(10) NOT NULL DEFAULT 0,
|
||
|
|
`bank_size` mediumint(5) NOT NULL DEFAULT 10
|
||
|
|
);
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `clan_players`;
|
||
|
|
CREATE TABLE IF NOT EXISTS `clan_players`
|
||
|
|
(
|
||
|
|
`id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
`clan_id` int(10) NOT NULL,
|
||
|
|
`username` varchar(12) NOT NULL,
|
||
|
|
`rank` tinyint(1) NOT NULL,
|
||
|
|
`kills` mediumint(5) NOT NULL DEFAULT 0,
|
||
|
|
`deaths` mediumint(5) NOT NULL DEFAULT 0
|
||
|
|
);
|