mysql创建数据库sql实例

mysql创建数据库sql实例

 

# MySQL-Front 3.2  (Build 2.10)

/*!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 CHARACTER SET 'latin1' */;

# Host: 192.168.1.7    Database: sohunews
# ------------------------------------------------------
# Server version 5.0.26-community-nt

CREATE DATABASE `sohunews`;
USE `sohunews`;

#
# Table structure for table email
#

CREATE TABLE `email` (
  `emailid` int(11) NOT NULL auto_increment,
  `email` varchar(60) NOT NULL,
  PRIMARY KEY  (`emailid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Table structure for table news
#

CREATE TABLE `news` (
  `newsid` int(11) NOT NULL auto_increment,
  `newstitle` varchar(60) NOT NULL,
  `newsauthor` varchar(20) NOT NULL,
  `newscontent` text NOT NULL,
  `newsurl` char(130) NOT NULL,
  `newsdate` varchar(24) NOT NULL,
  PRIMARY KEY  (`newsid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Table structure for table qq
#

CREATE TABLE `qq` (
  `qqid` int(11) NOT NULL auto_increment,
  `qq` varchar(15) NOT NULL,
  PRIMARY KEY  (`qqid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Table structure for table visitedurl
#

CREATE TABLE `visitedurl` (
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(150) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!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 */;