[eluser]InsiteFX[/eluser]
Here is the table structures.
Code:
--
-- Table structure for users table.
--
DROP TABLE IF EXISTS users;
CREATE TABLE `users` (
`users_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`users_name` varchar(40) NOT NULL,
`users_email` varchar(255) NOT NULL,
`users_password` varchar(32) NOT NULL,
`user_level` tinyint(1) NOT NULL,
`timestamp` int(11) unsigned NOT NULL,
PRIMARY KEY (`users_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
--
-- Table structure for users_online table.
--
DROP TABLE IF EXISTS users_online;
CREATE TABLE `users_online` (
`users_id` int(11) unsigned NOT NULL,
`user_name` varchar(40) NOT NULL,
`timestamp` int(11) unsigned NOT NULL,
PRIMARY KEY (`users_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
--
-- Table structure for guests_online table.
--
DROP TABLE IF EXISTS visitors_online;
CREATE TABLE `visitors_online` (
`ip_address` varchar(16) NOT NULL DEFAULT '0',
`timestamp` int(11) unsigned NOT NULL,
PRIMARY KEY (`ip_address`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
--
-- Table structure for users_banned table.
--
DROP TABLE IF EXISTS users_banned;
CREATE TABLE `users_banned` (
`users_id` int(11) unsigned NOT NULL,
`ip_address` varchar(16) DEFAULT '0' NOT NULL,
`user_name` varchar(40) NOT NULL,
`timestamp` int(11) unsigned NOT NULL,
PRIMARY KEY (`users_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
InsiteFX