-- phpMyAdmin SQL Dump
-- version 2.11.1
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 21-06-2008 a las 02:07:12
-- Versión del servidor: 5.0.45
-- Versión de PHP: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Base de datos: `twitter`
--
CREATE DATABASE `twitter` DEFAULT CHARACTER SET utf8 COLLATE utf8_spanish_ci;
USE `twitter`;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `mensajes`
--

CREATE TABLE `mensajes` (
  `id_mensaje` int(11) NOT NULL auto_increment,
  `id_usuario` int(11) NOT NULL,
  `texto_mensaje` varchar(200) character set utf8 collate utf8_spanish_ci NOT NULL,
  `fecha` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `personaje` int(10) NOT NULL,
  PRIMARY KEY  (`id_mensaje`,`id_usuario`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=38 ;

--
-- Volcar la base de datos para la tabla `mensajes`
--

INSERT INTO `mensajes` (`id_mensaje`, `id_usuario`, `texto_mensaje`, `fecha`, `personaje`) VALUES
(1, 1, 'Primer mensaje', '2007-04-15 20:48:01', 0),
(2, 1, 'Primer mensaje', '2007-04-15 20:50:00', 0),
(3, 1, 'jjjjj', '2007-04-15 20:54:21', 0),
(4, 1, 'adfadf', '2008-06-16 18:52:17', 0),
(5, 1, 'adsfadsfadsf', '2008-06-16 19:04:04', 0),
(6, 1, 'adfadf', '2008-06-16 19:04:10', 0),
(7, 1, 'adf adsf adsf asdf', '2008-06-16 19:04:15', 0),
(8, 1, 'Probando el sistema', '2008-06-18 23:56:53', 0),
(9, 1, 'hola', '2008-06-19 00:05:38', 0),
(10, 1, 'sfasdfadsf', '2008-06-19 00:05:43', 0),
(11, 1, 'adsasddddddddddddddddddddddddddddddddddddddddddddddddddddddddd', '2008-06-19 00:05:46', 0),
(12, 1, 'adfasdf', '2008-06-19 00:07:09', 0),
(13, 1, 'adfad', '2008-06-19 00:13:56', 0),
(14, 1, 'adfadf adf', '2008-06-19 00:14:31', 0),
(15, 1, 'adfadf', '2008-06-19 00:15:28', 0),
(16, 1, 'ddddd', '2008-06-19 00:15:31', 0),
(17, 1, 'prueba', '2008-06-21 00:14:28', 9),
(18, 1, 'prueba', '2008-06-21 00:14:40', 8),
(19, 1, 'prueba ', '2008-06-21 00:14:51', 7),
(20, 1, 'nueva', '2008-06-21 00:40:13', 7),
(21, 1, 'prueba más', '2008-06-21 00:40:24', 1),
(22, 1, 'adsfad', '2008-06-21 01:13:12', 10),
(23, 1, 'una prueba', '2008-06-21 01:22:28', 11),
(24, 1, 'hola', '2008-06-21 01:26:04', 13),
(25, 1, 'prueba', '2008-06-21 01:38:08', 2),
(26, 1, 'adfa df a', '2008-06-21 01:38:11', 1),
(27, 1, 'adfasdf ads f', '2008-06-21 01:38:16', 3),
(28, 1, 'dd', '2008-06-21 01:38:20', 4),
(29, 1, 'adf adf ', '2008-06-21 01:38:25', 5),
(30, 1, 'ad ad ', '2008-06-21 01:38:29', 6),
(31, 1, 'ad fad f', '2008-06-21 01:38:32', 8),
(32, 1, 'ad adsf ads ', '2008-06-21 01:38:36', 9),
(33, 1, 'ads adf', '2008-06-21 01:38:40', 10),
(34, 1, 'ad adsf ', '2008-06-21 01:38:43', 11),
(35, 1, 'adsf adsf', '2008-06-21 01:38:49', 12),
(36, 1, 'adsf adsf ', '2008-06-21 01:38:52', 13),
(37, 1, 'ads fads fads f', '2008-06-21 01:40:36', 2);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `personajes`
--

CREATE TABLE `personajes` (
  `id` int(10) NOT NULL auto_increment,
  `nombre` varchar(50) collate utf8_spanish_ci NOT NULL,
  `archivo` varchar(50) collate utf8_spanish_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=14 ;

--
-- Volcar la base de datos para la tabla `personajes`
--

INSERT INTO `personajes` (`id`, `nombre`, `archivo`) VALUES
(1, 'Enrique Place', '1.jpg'),
(2, 'Bruce Lee', '2.gif'),
(3, 'Richard Stallman', '3.jpg'),
(4, 'Linus Torvalds', '4.jpg'),
(5, 'Bill Gates', '5.jpg'),
(6, 'Michael Jackson', '6.jpg'),
(7, 'Zoolander', '7.jpg'),
(8, 'Dexter', '8.jpg'),
(9, 'Dexter Morgan', '9.jpg'),
(10, 'prueba', '9.jpg'),
(11, 'Hiro Nakamura', 'hiro.jpg'),
(12, 'hiro', 'fnbox.jpg'),
(13, 'hiro', 'fnbox.jpg');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `usuarios`
--

CREATE TABLE `usuarios` (
  `id_usuario` int(11) NOT NULL,
  `nombre_usuario` varchar(100) collate latin1_general_ci NOT NULL,
  `foto_usuario` varchar(100) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id_usuario`),
  UNIQUE KEY `nombre_usuario` (`nombre_usuario`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Volcar la base de datos para la tabla `usuarios`
--

INSERT INTO `usuarios` (`id_usuario`, `nombre_usuario`, `foto_usuario`) VALUES
(1, 'enriqueplace', 'enriqueplace.jpg'),
(2, 'marcos', 'marcos.jpg');
