Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --
- -- Table for Datserv users
- --
- DROP TABLE IF EXISTS `users`;
- CREATE TABLE `users` (
- `userid` int(20) NOT NULL auto_increment,
- `session_key` int(11) NOT NULL default '0',
- `last_login` datetime NOT NULL default '0000-00-00 00:00:00',
- `created` datetime NOT NULL default '0000-00-00 00:00:00',
- `totalgames` int(11) unsigned default '0',
- `fullname` varchar(255) collate utf8_unicode_ci NOT NULL default '',
- `username` varchar(255) collate utf8_unicode_ci NOT NULL default '',
- `md5sum` char(32) collate utf8_unicode_ci NOT NULL default '',
- `pass` varchar(255) collate utf8_unicode_ci NOT NULL default '',
- `ipaddress` varchar(128) collate utf8_unicode_ci NOT NULL default '',
- `lang` tinyint(3) unsigned default NULL default '0',
- `macaddress` varchar(255) collate utf8_unicode_ci NOT NULL default '0',
- `email` varchar(400) collate utf8_unicode_ci NOT NULL default '0',
- `enabled` int(2) unsigned default '1',
- PRIMARY KEY (`userid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- --
- -- Datserv Banking table
- --
- -- pin number for password
- --
- DROP TABLE IF EXISTS `banking`;
- CREATE TABLE `banking` (
- `id` bigint(20) NOT NULL auto_increment,
- `userid` bigint(20) default '0',
- `pin` int(11) default '0',
- `name` varchar(255) collate utf8_unicode_ci NOT NULL,
- `description` varchar(255) collate utf8_unicode_ci NOT NULL,
- `last_accessed` datetime NOT NULL default '0000-00-00 00:00:00',
- `last_transaction` datetime NOT NULL default '0000-00-00 00:00:00',
- `last_updated` datetime NOT NULL default '0000-00-00 00:00:00',
- `created` datetime NOT NULL default '0000-00-00 00:00:00',
- `money` bigint(20) default '0',
- `intrest_last_hour` bigint(20) default '0',
- `intrest_last_halfday` bigint(20) default '0',
- `intrest_last_day` bigint(20) default '0',
- `intrest_last_month` bigint(20) default '0',
- `intrest_last_year` bigint(20) default '0',
- `account_type` tinyint(3) default '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- --
- -- Game general info Table
- --
- DROP TABLE IF EXISTS `gameinfo`;
- CREATE TABLE `gameinfo` (
- `id` bigint(20) NOT NULL auto_increment,
- `last_updated` datetime NOT NULL default '0000-00-00 00:00:00',
- `created` datetime NOT NULL default '0000-00-00 00:00:00',
- `name` varchar(255) collate utf8_unicode_ci NOT NULL,
- `description` varchar(255) collate utf8_unicode_ci NOT NULL,
- `ownerid` int(11) default '0',
- `lastuserid` int(11) default '0',
- `gametype` tinyint(3) default '0',
- `permissions` tinyint(3) default '0',
- `registered` tinyint(3) default '0',
- `ntrains` int(11) default '0',
- `ntrucks` int(11) default '0',
- `nboats` int(11) default '0',
- `nplains` int(11) default '0',
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement