-- phpMyAdmin SQL Dump -- version 2.11.7 -- http://www.phpmyadmin.net -- -- Servidor: localhost -- Tiempo de generación: 26-10-2008 a las 19:14:11 -- Versión del servidor: 5.0.51 -- Versión de PHP: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Base de datos: `ftchat` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `ftchat_banned_ips` -- CREATE TABLE IF NOT EXISTS `ftchat_banned_ips` ( `id` int(11) NOT NULL auto_increment, `uid` int(11) NOT NULL default '1', `ip` varchar(16) NOT NULL default '', `reason` tinytext NOT NULL, `suspended` enum('0','1') default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Volcar la base de datos para la tabla `ftchat_banned_ips` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `ftchat_messages` -- CREATE TABLE IF NOT EXISTS `ftchat_messages` ( `id` int(11) NOT NULL auto_increment, `room_id` int(11) NOT NULL default '1', `chat_time` datetime default NULL, `chat_nick` varchar(16) NOT NULL default '', `chat_ip` varchar(16) NOT NULL default '', `chat_ip_receive` varchar(16) NOT NULL default '', `message` text NOT NULL, `status` int(1) default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ; -- -- Volcar la base de datos para la tabla `ftchat_messages` -- INSERT INTO `ftchat_messages` (`id`, `room_id`, `chat_time`, `chat_nick`, `chat_ip`, `chat_ip_receive`, `message`, `status`) VALUES (1, 2, '2008-10-26 00:58:56', 'ewrew', '', '', 'ewrew: (has entered the room)', 1), (2, 1, '2008-10-26 00:59:35', 'ewrew', '', '', 'ewrew: (has entered the room)', 1), (3, 1, '2008-10-26 00:59:44', 'ewrew', '', '', 'ewrew: Hello', 1), (4, 1, '2008-10-26 00:59:54', 'ewrew', '', '', 'ewrew: putos y ahora que', 1), (5, 2, '2008-10-26 01:00:09', 'beto', '', '', 'beto: (has entered the room)', 1), (6, 2, '2008-10-26 01:00:21', 'beto', '', '', 'beto: Hello', 1), (7, 2, '2008-10-26 01:00:27', 'beto', '', '', 'beto: ahora si', 1), (8, 2, '2008-10-26 01:00:45', 'beto', '', '', 'beto: (has entered the room)', 1), (9, 2, '2008-10-26 01:00:56', 'beto', '', '', 'beto: (has entered the room)', 1), (10, 2, '2008-10-26 01:01:00', 'beto', '', '', 'beto: (has entered the room)', 1), (11, 2, '2008-10-26 01:01:40', 'beto', '', '', 'beto: (has entered the room)', 1), (12, 2, '2008-10-26 01:02:54', 'qweqw', '', '', 'qweqw: (has entered the room)', 1), (13, 2, '2008-10-26 01:07:58', 'ewr5ew4', '', '', 'ewr5ew4: (has entered the room)', 1), (14, 2, '2008-10-26 01:10:02', 'ewr5ew4', '', '', 'ewr5ew4: (has entered the room)', 1), (15, 2, '2008-10-26 01:18:50', 'ertew', '', '', 'ertew: (has entered the room)', 1), (16, 2, '2008-10-26 01:25:14', 'ewtr545', '', '', 'ewtr545: (has entered the room)', 1), (17, 2, '2008-10-26 01:35:52', 'ewtr545', '', '', 'ewtr545: (has left the room)', 1), (18, 2, '2008-10-26 01:37:49', 'betin', '', '', 'betin: (has entered the room)', 1), (19, 2, '2008-10-26 01:40:44', '234r234', '', '', '234r234: (has entered the room)', 1), (20, 2, '2008-10-26 01:41:28', 'qwqwe', '', '', 'qwqwe: (has entered the room)', 1), (21, 2, '2008-10-26 01:45:12', 'qwqwe', '', '', 'qwqwe: (has left the room)', 1), (22, 2, '2008-10-26 01:36:16', 'nico125', '', '', 'nico125: (has entered the room)', 1), (23, 2, '2008-10-26 15:33:52', 'ewr5ew435r', '', '', 'ewr5ew435r: (has entered the room)', 1), (24, 3, '2008-10-26 15:34:24', 'dsergdstf', '', '', 'dsergdstf: (has entered the room)', 0), (25, 3, '2008-10-26 15:34:32', 'dsergdstf', '', '', 'dsergdstf: Hello', 0); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `ftchat_rooms` -- CREATE TABLE IF NOT EXISTS `ftchat_rooms` ( `id` int(11) NOT NULL auto_increment, `uid` int(11) NOT NULL default '1', `name` varchar(64) NOT NULL, `description` tinytext NOT NULL, `suspended` enum('0','1') default '0', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Volcar la base de datos para la tabla `ftchat_rooms` -- INSERT INTO `ftchat_rooms` (`id`, `uid`, `name`, `description`, `suspended`) VALUES (1, 1, 'Public', 'Public Chat Room', '0'), (2, 1, 'Nuevo Laredo', 'Gente de la localidad, conoce y haz amigos', '0'), (3, 1, 'Adolecentes', 'Para los chavos no tan grandes', '0'), (4, 1, 'De 30-40', 'Amistad Madura', '0'), (5, 1, 'De 40-50 y mas', 'Para los ya maduritos', '0'), (6, 1, 'Adultos', 'Quieres hablar de sexo=', '0'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `ftchat_users` -- CREATE TABLE IF NOT EXISTS `ftchat_users` ( `uid` int(11) NOT NULL auto_increment, `login` varchar(32) NOT NULL, `password` varchar(255) NOT NULL default 'h9XXkDKzwY432', `permit` varchar(1) NOT NULL default 'g', `status` enum('0','1','2') NOT NULL default '0', `ip` varchar(16) NOT NULL default '', `date` datetime default NULL, `language` varchar(32) NOT NULL default 'english.inc.php', PRIMARY KEY (`uid`), UNIQUE KEY `login` (`login`), KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1002 ; -- -- Volcar la base de datos para la tabla `ftchat_users` -- INSERT INTO `ftchat_users` (`uid`, `login`, `password`, `permit`, `status`, `ip`, `date`, `language`) VALUES (1, 'admin', '$1$.a0.ti3.$Jqxral3cy9p7e4vNyacdO1', '1', '1', '', '2008-10-26 01:33:50', 'english.inc.php'), (1001, 'guest', 'h9XXkDKzwY432', 'g', '1', '', NULL, 'english.inc.php');