[MySQL] SQL structure example

[MySQL] SQL structure example



-- phpMyAdmin SQL Dump

-- version 3.5.5

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Apr 07, 2014 at 06:49 AM

-- Server version: 5.5.33-31.1

-- PHP Version: 5.3.17



SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";





/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;



--

-- Database: `happy_student`

--



-- --------------------------------------------------------



--

-- Table structure for table `student`

--



CREATE TABLE IF NOT EXISTS `student` (

  `serial` mediumint(8) NOT NULL AUTO_INCREMENT,

  `name` varchar(20) NOT NULL,

  `sex` varchar(6) NOT NULL,

  `year` smallint(2) NOT NULL,

  `month` tinyint(3) NOT NULL,

  `day` tinyint(3) NOT NULL,

  `phone` varchar(20) NOT NULL,

  `mail` varchar(50) NOT NULL,

  `address` varchar(50) NOT NULL,

  `reg_data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

  PRIMARY KEY (`serial`),

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;



/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;