Advertisement
Guest User

Untitled

a guest
Jan 27th, 2020
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.96 KB | None | 0 0
  1. void 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. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement