# MySQL dump 8.14 # # Host: localhost Database: ejemplos #-------------------------------------------------------- # Server version 3.23.39-log # # Table structure for table 'db1' # CREATE TABLE db1 ( nombre varchar(50) NOT NULL default '', apellido varchar(50) NOT NULL default '', sexo char(2) NOT NULL default '', chocolate char(3) NOT NULL default '', vainilla char(3) NOT NULL default '', fresa char(3) NOT NULL default '', rocky char(3) NOT NULL default '', cafe char(3) NOT NULL default '', pelicula varchar(20) NOT NULL default '', texto longtext NOT NULL, id varchar(25) NOT NULL default '' ) TYPE=MyISAM; # # Dumping data for table 'db1' # INSERT INTO db1 VALUES ('Javi','Figueroa','M','Si','Si','No','No','No','Pulp Fiction','Esto es solo una prueba.\r\nsjklsdf Goodbye\r\nPrueba','7397141.25919'); INSERT INTO db1 VALUES ('Primera','persona','F','No','No','No','Si','Si','Cinema Paradiso','Otra persona, Woohoo\r\n\r\nHello goodbye welcome.','9607411.30559'); INSERT INTO db1 VALUES ('kljkl','lkjkl','','No','No','No','No','No','Star Wars',',hjk kljhjkh','7128640.9975'); INSERT INTO db1 VALUES ('asdf','asdf','M','Si','No','No','No','No','Star Wars','asdf asdf a','1785869.21219'); INSERT INTO db1 VALUES ('asdf','asdf','M','Si','No','No','No','No','Star Wars','asdf asdf a','3282717.21332'); # # Table structure for table 'emails' # CREATE TABLE emails ( nombre varchar(50) NOT NULL default '', email varchar(50) NOT NULL default '' ) TYPE=MyISAM; # # Dumping data for table 'emails' # INSERT INTO emails VALUES ('Javi Figueroa','figue@umich.edu'); INSERT INTO emails VALUES ('Javi','figue@umich.edu'); # # Table structure for table 'foros' # CREATE TABLE foros ( foro varchar(50) NOT NULL default '' ) TYPE=MyISAM; # # Dumping data for table 'foros' # INSERT INTO foros VALUES ('Foro de Prueba'); # # Table structure for table 'meses' # CREATE TABLE meses ( mes char(2) NOT NULL default '', actividad varchar(50) NOT NULL default '', fecha date NOT NULL default '0000-00-00', hora varchar(25) NOT NULL default '', lugar varchar(25) NOT NULL default '', tema varchar(50) NOT NULL default '', contacto varchar(50) NOT NULL default '', telefono varchar(25) NOT NULL default '', comentarios longtext NOT NULL, dates varchar(50) NOT NULL default '', id varchar(25) NOT NULL default '' ) TYPE=MyISAM; # # Dumping data for table 'meses' # INSERT INTO meses VALUES ('01','Prueba','2001-01-01','93939','ayer','prueba','prueba','939393','Prueba\r\nprueba\r\nprueba\r\n','9393','4129838.669'); INSERT INTO meses VALUES ('01','lkjh','2001-01-09','lkjh','klj','hlkj','hlk','jh','lkjh','kljh','8135456.22322'); # # Table structure for table 'pagina' # CREATE TABLE pagina ( id varchar(25) NOT NULL default '', titulo varchar(25) NOT NULL default '', header varchar(25) NOT NULL default '', footer varchar(25) NOT NULL default '', texto longtext NOT NULL ) TYPE=MyISAM; # # Dumping data for table 'pagina' # INSERT INTO pagina VALUES ('9340502.25407','prueba','tag_lunes.gif','tag_sabado.gif','Esto es una prueba'); INSERT INTO pagina VALUES ('7953966.29276','Test','header.gif','footer.gif','This is only a test. This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.\r\n\r\nThis is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.\r\n\r\nThis is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.'); INSERT INTO pagina VALUES ('3291112.29292','Test','header.gif','footer.gif','This is only a test. This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.\r\n\r\nThis is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.\r\n\r\nThis is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.'); INSERT INTO pagina VALUES ('6486927.29300','Test','header.gif','footer.gif','This is only a test. This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.\r\n\r\nThis is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.\r\n\r\nThis is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.'); INSERT INTO pagina VALUES ('5836182.29305','Test','header.gif','footer.gif','This is only a test. This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.\r\n\r\nThis is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.\r\n\r\nThis is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.This is only a test.'); # # Table structure for table 'poll' # CREATE TABLE poll ( movie varchar(30) NOT NULL default '', votos int(11) NOT NULL default '0' ) TYPE=MyISAM; # # Dumping data for table 'poll' # INSERT INTO poll VALUES ('Star Wars',7); INSERT INTO poll VALUES ('2001: A Space Oddysey',2); INSERT INTO poll VALUES ('The Godfather',2); INSERT INTO poll VALUES ('Cinema Paradiso',4); INSERT INTO poll VALUES ('Being John Malkovich',4); INSERT INTO poll VALUES ('L.A. Confidential',4); INSERT INTO poll VALUES ('Pulp Fiction',2); INSERT INTO poll VALUES ('Glory',3); INSERT INTO poll VALUES ('Memento',3); INSERT INTO poll VALUES ('Moulin Rouge',3); # # Table structure for table 'tex_foro' # CREATE TABLE tex_foro ( nombre varchar(50) NOT NULL default '', foro varchar(50) NOT NULL default '', texto longtext NOT NULL, id varchar(25) NOT NULL default '' ) TYPE=MyISAM; # # Dumping data for table 'tex_foro' # INSERT INTO tex_foro VALUES ('Javi Figueroa','Foro de Prueba','Esto es solo una prueba.\r\nProbando\r\nProbando\r\nHello\r\nGoodbye','5004823.29326');