Created
January 28, 2012 18:56
-
-
Save Javlopez/1695417 to your computer and use it in GitHub Desktop.
SQL del taller de kohana
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- phpMyAdmin SQL Dump | |
-- version 3.4.5 | |
-- http://www.phpmyadmin.net | |
-- | |
-- Servidor: localhost | |
-- Tiempo de generación: 28-01-2012 a las 19:55:23 | |
-- Versión del servidor: 5.5.16 | |
-- Versión de PHP: 5.3.8 | |
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; | |
SET time_zone = "+00:00"; | |
-- | |
-- Base de datos: `blog` | |
-- | |
-- -------------------------------------------------------- | |
-- | |
-- Estructura de tabla para la tabla `posts` | |
-- | |
CREATE TABLE IF NOT EXISTS `posts` ( | |
`id` int(10) NOT NULL AUTO_INCREMENT, | |
`title` char(150) NOT NULL, | |
`content` text NOT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; | |
-- -------------------------------------------------------- | |
-- | |
-- Estructura de tabla para la tabla `users` | |
-- | |
CREATE TABLE IF NOT EXISTS `users` ( | |
`id` int(10) NOT NULL AUTO_INCREMENT, | |
`username` char(50) NOT NULL, | |
`password` char(70) NOT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment