Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- void DB_CreateTables(Database db) {
- char query[512];
- if (db_mysql) {
- FormatEx(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `%splayers` (\
- `id` int(5) NOT NULL AUTO_INCREMENT,\
- `name` varchar(32) NOT NULL DEFAULT 'unknown',\
- `auth` varchar(22) NOT NULL,\
- `position` varchar(32) NOT NULL DEFAULT 'unknown',\
- PRIMARY KEY (`id`), \
- UNIQUE KEY `auth` (`auth`) \
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;", db_prefix);
- db.Query(DB_PlayersTable, query, 1, DBPrio_High);
- FormatEx(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `%splayers_info` (\
- `id` int(5) NOT NULL,\
- `name` varchar(32) NOT NULL DEFAULT 'unknown',\
- `auth` varchar(22) NOT NULL,\
- `jobid` varchar(32) NOT NULL DEFAULT 'idlejob',\
- `rankid` varchar(32) NOT NULL DEFAULT 'idlerank',\
- `money` int(12) NOT NULL,\
- `bank_money` int(12) NOT NULL,\
- PRIMARY KEY (`id`), \
- UNIQUE KEY `auth` (`auth`) \
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;", db_prefix);
- db.Query(DB_PlayersTable, query, 2, DBPrio_High);
- } else {
- FormatEx(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `%splayers` (\
- `id` INTEGER PRIMARY KEY AUTOINCREMENT,\
- `name` VARCHAR DEFAULT 'unknown',\
- `auth` VARCHAR UNIQUE ON CONFLICT IGNORE,\
- `position` VARCHAR DEFAULT 'unknown');", db_prefix);
- db.Query(DB_PlayersTable, query, 1, DBPrio_High);
- FormatEx(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `%splayers_info` (\
- `id` INTEGER PRIMARY KEY,\
- `name` VARCHAR DEFAULT 'unknown',\
- `auth` VARCHAR UNIQUE ON CONFLICT IGNORE,\
- `jobid` VARCHAR DEFAULT 'idlejob',\
- `rankid` VARCHAR DEFAULT 'idlerank',\
- `money` NUMERIC DEFAULT '0',\
- `bank_money` NUMERIC DEFAULT '0');", db_prefix);
- db.Query(DB_PlayersTable, query, 2, DBPrio_High);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement