My favorites | Sign in
Project Home Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
ConfiguracionBaseDatos  
Updated Jul 28, 2010 by msdark...@gmail.com

#Configuracion de la base de datos usada por el servidor

CREATE DATABASE servidor_video;

use servidor_video;


CREATE TABLE `videolist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titulo` varchar(300) NOT NULL,
  `path` varchar(400) NOT NULL,
  `imagen` varchar(400) NOT NULL,
  `duracion` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;


INSERT INTO `videolist` (`id`,`titulo`,`path`,`imagen`,`duracion`)
VALUES
	(1, 'Primer Video', 'videos/video1.3gp', 'imagenes/video1.png', '00:30');

INSERT INTO `videolist` (`id`,`titulo`,`path`,`imagen`,`duracion`)
VALUES
	(2, 'Segundo Video', 'videos/video2.3gp', 'imagenes/video2.png', '1:00');

INSERT INTO `videolist` (`id`,`titulo`,`path`,`imagen`,`duracion`)
VALUES
	(3, 'Tercer Video', 'videos/video3.3gp', 'imagenes/video3.png', '00:37');
Powered by Google Project Hosting