-- phpMyAdmin SQL Dump
-- version 2.10.3
--
http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 24-04-2009 a las 14:04:50
-- Versión del servidor: 5.0.45
-- Versión de PHP: 5.2.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Base de datos: `skill_test`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `skills`
--
CREATE TABLE `skills` (
`skill_id` int(11) NOT NULL auto_increment,
`skill_name` char(100) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`skill_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;
--
-- Volcar la base de datos para la tabla `skills`
--
INSERT INTO `skills` (`skill_id`, `skill_name`) VALUES
(1, 'Excel'),
(2, 'Word'),
(3, 'PHP'),
(4, 'MySQL'),
(5, 'Delphi'),
(6, '.NET');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `users`
--
CREATE TABLE `users` (
`user_id` int(11) NOT NULL auto_increment,
`user_firstname` char(50) collate latin1_general_ci NOT NULL,
`user_lastname` char(50) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;
--
-- Volcar la base de datos para la tabla `users`
--
INSERT INTO `users` (`user_id`, `user_firstname`, `user_lastname`) VALUES
(1, 'Pedro', 'Buchon'),
(2, 'Juan', 'Perez'),
(3, 'Maria Marta', 'Gonzalez'),
(4, 'Jose', 'Acasuso');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `user_skill`
--
CREATE TABLE `user_skill` (
`user_skill_id` int(11) NOT NULL auto_increment,
`user_skill_last_modified` timestamp NULL default CURRENT_TIMESTAMP,
`user_skill_date_created` datetime default NULL,
`user_id` int(11) default NULL,
`skill_id` int(11) NOT NULL,
`skill_level` tinyint(1) default NULL,
`skill_usage` char(255) collate latin1_general_ci default NULL,
`skill_last_used` char(255) collate latin1_general_ci default NULL,
`user_skill_endorsed` tinyint(1) default NULL,
PRIMARY KEY (`user_skill_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;
--
-- Volcar la base de datos para la tabla `user_skill`
--
INSERT INTO `user_skill` (`user_skill_id`, `user_skill_last_modified`, `user_skill_date_created`, `user_id`, `skill_id`, `skill_level`, `skill_usage`, `skill_last_used`, `user_skill_endorsed`) VALUES
(1, '2009-04-24 13:43:19', NULL, 1, 3, 2, NULL, NULL, 3),
(2, '2009-04-24 13:43:19', NULL, 1, 4, 4, NULL, NULL, NULL),
(3, '2009-04-24 13:44:01', NULL, 4, 6, NULL, NULL, NULL, NULL),
(4, '2009-04-24 13:44:01', NULL, 2, 6, NULL, NULL, NULL, NULL);