DWVibR8Y

1void DB_CreateTables(Database db) {
2	char query[512];
3	if (db_mysql) {
4		FormatEx(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `%splayers` (\
5							  `id` int(5) NOT NULL AUTO_INCREMENT,\
6							  `name` varchar(32) NOT NULL DEFAULT 'unknown',\
7							  `auth` varchar(22) NOT NULL,\
8							  `position` varchar(32) NOT NULL DEFAULT 'unknown',\
9							  PRIMARY KEY (`id`), \
10								UNIQUE KEY `auth` (`auth`) \
11							) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;", db_prefix);
12
13		db.Query(DB_PlayersTable, query, 1, DBPrio_High);
14
15		FormatEx(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `%splayers_info` (\
16							  `id` int(5) NOT NULL,\
17							  `name` varchar(32) NOT NULL DEFAULT 'unknown',\
18							  `auth` varchar(22) NOT NULL,\
19							  `jobid` varchar(32) NOT NULL DEFAULT 'idlejob',\
20							  `rankid` varchar(32) NOT NULL DEFAULT 'idlerank',\
21							  `money` int(12) NOT NULL,\
22							  `bank_money` int(12) NOT NULL,\
23							  PRIMARY KEY (`id`), \
24								UNIQUE KEY `auth` (`auth`) \
25							) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;", db_prefix);
26		db.Query(DB_PlayersTable, query, 2, DBPrio_High);
27	} else {
28		FormatEx(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `%splayers` (\
29							  `id` INTEGER PRIMARY KEY AUTOINCREMENT,\
30							  `name` VARCHAR DEFAULT 'unknown',\
31							  `auth` VARCHAR UNIQUE ON CONFLICT IGNORE,\
32							  `position` VARCHAR DEFAULT 'unknown');", db_prefix);
33
34		db.Query(DB_PlayersTable, query, 1, DBPrio_High);
35		
36		FormatEx(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `%splayers_info` (\
37							  `id` INTEGER PRIMARY KEY,\
38							  `name` VARCHAR DEFAULT 'unknown',\
39							  `auth` VARCHAR UNIQUE ON CONFLICT IGNORE,\
40							  `jobid` VARCHAR DEFAULT 'idlejob',\
41							  `rankid` VARCHAR DEFAULT 'idlerank',\
42							  `money` NUMERIC DEFAULT '0',\
43							  `bank_money` NUMERIC DEFAULT '0');", db_prefix);
44
45		db.Query(DB_PlayersTable, query, 2, DBPrio_High);
46	}
47}