JqZDR0es

1CREATE TABLE IF NOT EXISTS `preferences` (
2	steamid VARCHAR(24) NOT NULL,
3    teleport_menu BOOLEAN NOT NULL DEFAULT '1',
4    info_panel BOOLEAN NOT NULL DEFAULT '1',
5    show_keys BOOLEAN NOT NULL DEFAULT '0',
6    hide_players BOOLEAN NOT NULL DEFAULT '0',
7    hide_weapons BOOLEAN NOT NULL DEFAULT '0',
8    pistol VARCHAR(20) NOT NULL DEFAULT 'P2K / USP',
9    CONSTRAINT PREF_PK PRIMARY KEY (steamid),
10	CONSTRAINT PREF_STEAM_FK FOREIGN KEY (steamid)
11			REFERENCES PLAYER (steamid)
12			ON UPDATE CASCADE ON DELETE CASCADE
13);