gbook.sql

来自「struts spring hibernate制作的留言本」· SQL 代码 · 共 23 行

CREATE DATABASE `gbook`
    CHARACTER SET 'latin1'
    COLLATE 'latin1_swedish_ci';

USE `gbook`;


CREATE TABLE `t_gbook` (
  `i_id` int(11) NOT NULL auto_increment,
  `c_name` varchar(15) NOT NULL,
  `c_email` varchar(60) NOT NULL,
  `c_page_name` varchar(60) NULL,
  `c_page_url` varchar(80) NULL,
  `i_sex` int(1) NOT NULL,
  `c_img` varchar(20) NOT NULL,
  `c_content` varchar(1000) NOT NULL,
  `c_ip` varchar(15) NOT NULL,
  `c_datetime` datetime NOT NULL,
  `c_reply` varchar(1000) NULL,
  PRIMARY KEY  (`i_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;