 |
|
Junior Member
Join Date: Sep 2007
Location: Romania
|

12-24-2008
, 17:20
Re: extract sql
|
#6
|
Quote:
CREATE TABLE `amx_amxadmins` (
`id` int(12) NOT NULL auto_increment,
`username` varchar(32) default NULL,
`password` varchar(32) default NULL,
`access` varchar(32) default NULL,
`flags` varchar(32) default NULL,
`steamid` varchar(32) default NULL,
`nickname` varchar(32) NOT NULL default '',
`forum_id` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1 AUTO_INCREMENT=46 ;
|
Quote:
CREATE TABLE `amx_bans` (
`bid` int(11) NOT NULL auto_increment,
`player_ip` varchar(100) default NULL,
`player_id` varchar(50) NOT NULL default '0',
`player_nick` varchar(100) NOT NULL default 'Unknown',
`admin_ip` varchar(100) default NULL,
`admin_steamid` varchar(50) NOT NULL default '0',
`admin_nick` varchar(100) NOT NULL default 'Unknown',
`ban_type` varchar(10) NOT NULL default 'S',
`ban_reason` varchar(255) NOT NULL default '',
`ban_created` int(11) NOT NULL default '0',
`ban_length` varchar(100) NOT NULL default '',
`server_ip` varchar(100) NOT NULL default '',
`server_name` varchar(100) NOT NULL default 'Unknown',
`admin_id` varchar(50) NOT NULL default '0',
PRIMARY KEY (`bid`)
) ENGINE=MyISAM AUTO_INCREMENT=755 DEFAULT CHARSET=latin1 AUTO_INCREMENT=755 ;
|
__________________
loading...
|
|
|
|