TeYzPMYW

1-- phpMyAdmin SQL Dump
2-- version 3.5.2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jun 05, 2014 at 07:35 PM
7-- Server version: 5.5.25a
8-- PHP Version: 5.4.4
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `junio14`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `socios`
27--
28drop database  IF  EXISTS exajsf;
29CREATE DATABASE exajsf;
30USE exajsf;
31CREATE TABLE IF NOT EXISTS `socios` (
32  `ID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
33  `nombre` varchar(20) NOT NULL,
34  `apellido` varchar(30) NOT NULL,
35  `direccion` varchar(50) NOT NULL,
36  PRIMARY KEY (`ID`)
37) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
38
39--
40-- Dumping data for table `socios`
41--
42
43INSERT INTO `socios` (`ID`, `nombre`, `apellido`, `direccion`) VALUES
44(1, 'Luis', 'Buendia', 'Jaen 7'),
45(2, 'Susana', 'Palacios', 'Montilla 10'),
46(3, 'Pedro', 'Jimenez', 'C / Baeza 3'),
47(4, 'Miguel', 'Gonzalez', 'Av. Ripalda 101');
48
49/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
50/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
51/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;