Advertisement
Guest User

Untitled

a guest
Jun 27th, 2017
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.81 KB | None | 0 0
  1.  
  2. --
  3. -- Table for Datserv users
  4. --
  5.  
  6. DROP TABLE IF EXISTS `users`;
  7. CREATE TABLE `users` (
  8. `userid` int(20) NOT NULL auto_increment,
  9. `session_key` int(11) NOT NULL default '0',
  10. `last_login` datetime NOT NULL default '0000-00-00 00:00:00',
  11. `created` datetime NOT NULL default '0000-00-00 00:00:00',
  12. `totalgames` int(11) unsigned default '0',
  13. `fullname` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  14. `username` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  15. `md5sum` char(32) collate utf8_unicode_ci NOT NULL default '',
  16. `pass` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  17. `ipaddress` varchar(128) collate utf8_unicode_ci NOT NULL default '',
  18. `lang` tinyint(3) unsigned default NULL default '0',
  19. `macaddress` varchar(255) collate utf8_unicode_ci NOT NULL default '0',
  20. `email` varchar(400) collate utf8_unicode_ci NOT NULL default '0',
  21. `enabled` int(2) unsigned default '1',
  22. PRIMARY KEY (`userid`)
  23. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  24.  
  25. --
  26. -- Datserv Banking table
  27. --
  28. -- pin number for password
  29. --
  30.  
  31. DROP TABLE IF EXISTS `banking`;
  32. CREATE TABLE `banking` (
  33. `id` bigint(20) NOT NULL auto_increment,
  34. `userid` bigint(20) default '0',
  35. `pin` int(11) default '0',
  36. `name` varchar(255) collate utf8_unicode_ci NOT NULL,
  37. `description` varchar(255) collate utf8_unicode_ci NOT NULL,
  38. `last_accessed` datetime NOT NULL default '0000-00-00 00:00:00',
  39. `last_transaction` datetime NOT NULL default '0000-00-00 00:00:00',
  40. `last_updated` datetime NOT NULL default '0000-00-00 00:00:00',
  41. `created` datetime NOT NULL default '0000-00-00 00:00:00',
  42. `money` bigint(20) default '0',
  43. `intrest_last_hour` bigint(20) default '0',
  44. `intrest_last_halfday` bigint(20) default '0',
  45. `intrest_last_day` bigint(20) default '0',
  46. `intrest_last_month` bigint(20) default '0',
  47. `intrest_last_year` bigint(20) default '0',
  48. `account_type` tinyint(3) default '0',
  49. PRIMARY KEY (`id`)
  50. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  51.  
  52. --
  53. -- Game general info Table
  54. --
  55.  
  56. DROP TABLE IF EXISTS `gameinfo`;
  57. CREATE TABLE `gameinfo` (
  58. `id` bigint(20) NOT NULL auto_increment,
  59. `last_updated` datetime NOT NULL default '0000-00-00 00:00:00',
  60. `created` datetime NOT NULL default '0000-00-00 00:00:00',
  61. `name` varchar(255) collate utf8_unicode_ci NOT NULL,
  62. `description` varchar(255) collate utf8_unicode_ci NOT NULL,
  63. `ownerid` int(11) default '0',
  64. `lastuserid` int(11) default '0',
  65. `gametype` tinyint(3) default '0',
  66. `permissions` tinyint(3) default '0',
  67. `registered` tinyint(3) default '0',
  68. `ntrains` int(11) default '0',
  69. `ntrucks` int(11) default '0',
  70. `nboats` int(11) default '0',
  71. `nplains` int(11) default '0',
  72. PRIMARY KEY (`id`)
  73. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement