· 9 years ago · Dec 30, 2016, 10:32 PM
1MYSQL:
2
3SQL_TQuery(db, SQL_SelectPlayerCallback, "CREATE TABLE IF NOT EXISTS d_player_stats (id int NOT NULL AUTO_INCREMENT, steamid varchar(35) NOT NULL, name varchar(100) NOT NULL, ip varchar(21) NOT NULL, kills int(20) NOT NULL, deaths int(20) NOT NULL, headshots int(20) NOT NULL, teamkills int(20) NOT NULL, shots int(20) NOT NULL, hits int(20) NOT NULL, level int(20) NOT NULL, exp int(20) NOT NULL, credits int(20) NOT NULL, botkills int(20) NOT NULL, planted int(20) NOT NULL, defused int(20) NOT NULL, exploded int(20) NOT NULL, hostages_rescued int(20) NOT NULL, hostage_killed int(20) NOT NULL, twin int(20) NOT NULL, ctwin int(20) NOT NULL, roundsplayed int(20) NOT NULL, lastconnect int(20) NOT NULL, timeplayed int(20) NOT NULL, PRIMARY KEY (`id`))", 0);
4SQLITE:
5
6SQL_TQuery(db, SQL_SelectPlayerCallback, "CREATE TABLE IF NOT EXISTS `d_player_stats` (id INTEGER PRIMARY KEY AUTOINCREMENT, steamid TEXT, name TEXT, ip TEXT, kills NUMERIC, deaths NUMERIC, headshots NUMERIC, teamkills NUMERIC, shots NUMERIC, hits NUMERIC, level NUMERIC, exp NUMERIC, credits NUMERIC, botkills NUMERIC, planted NUMERIC, defused NUMERIC, exploded NUMERIC, hostages_rescued NUMERIC, hostage_killed NUMERIC, twin NUMERIC, ctwin NUMERIC, roundsplayed NUMERIC, lastconnect NUMERIC, timeplayed NUMERIC)", 0);