SQL脚本

yuandan

MySQL版
/*
Navicat MySQL Data Transfer
Source Server         : localMySQL
Source Server Version : 50151
Source Host           : localhost:3306
Source Database       : bookshop
Target Server Type    : MYSQL
Target Server Version : 50151
File Encoding         : 65001
Date: 2013-07-31 09:55:38
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`password` varchar(20) DEFAULT NULL,
`email` varchar(30) DEFAULT NULL,
`account` double DEFAULT NULL,
`address` varchar(30) DEFAULT NULL,
`telephone` varchar(20) DEFAULT NULL,
`createdate` datetime DEFAULT NULL,
`state` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO t_user VALUES ('1', 'admin', '123456', 'admin@sina.com', '100', 'Wuhan', '18537611275', '2013-07-31 09:55:17', '1');

CREATE  TABLE `bookshop`.`t_book` (
`id` INT NOT NULL ,
`name` VARCHAR(45) NULL ,
`auther` VARCHAR(45) NULL ,
`press` VARCHAR(45) NULL ,
`price` DOUBLE NULL ,
PRIMARY KEY (`id`) );
CREATE TABLE `bookshop`.`t_order`(
`id` varchar(20) NOT NULL,
`userid` int(20) NULL,
`sum` double NULL,
`createdate` datetime NULL,
`state` int NULL,
PRIMARY KEY (`id`));
insert into `bookshop`.`t_book` values(1,'秘密','拜恩','中国城市出版社',17.3);
insert into `bookshop`.`t_book` values(2,'白鹿原','陈忠实','北京十月文艺出版社',22);
insert into `bookshop`.`t_book` values(3,'青春','韩寒','湖南人民出版社',20.3);
insert into `bookshop`.`t_book` values(4,'追风筝的人','胡赛尼','上海人民出版社',16.3);
insert into `bookshop`.`t_book` values(5,'狼图腾','姜戎','长江文艺出版社',21.1);
insert into `bookshop`.`t_book` values(6,'正能量','理查德 怀斯曼民','湖南文艺出版社',18.5);
insert into `bookshop`.`t_book` values(7,'好妈妈胜过好老师','尹建莉','作家出版社',14.3);
insert into `bookshop`.`t_book` values(8,'你若安好便是晴天','白落梅','中国华侨出版社',17.4);
insert into `bookshop`.`t_book` values(9,'不一样的卡梅拉','克利斯提昂','二十一世纪出版社',26.5);
insert into `bookshop`.`t_book` values(10,'因为痛 所以叫青春','金兰都','广西科学技术出版社',19.7);
insert into `bookshop`.`t_book` values(11,'看见','柴静','广西师范大学出版社',28.9);
insert into `bookshop`.`t_book` values(12,'超级整理术','泉正人','中国友谊出版公司',15);
insert into `bookshop`.`t_book` values(13,'余华文集','余华','作家出版社',177.5);
insert into `bookshop`.`t_book` values(14,'九州·缥缈录','江南','新世界出版社',82.2);
insert into `bookshop`.`t_book` values(15,'越二越单纯','王小柔','人民文学出版社',18.1);
insert into `bookshop`.`t_book` values(16,'那么远那么近','宇文卿','北京联合出版公司',31.1);
insert into `bookshop`.`t_book` values(17,'偷影子的人','马克·李维','湖南文艺出版社',17.9);
insert into `bookshop`.`t_book` values(18,'高效能人士的七个习惯','史蒂芬·柯维','中国青年出版社',29.4);
insert into `bookshop`.`t_book` values(19,'我在哈佛的最后一堂课','赛诺威','北京联合出版公司',21.6);
insert into `bookshop`.`t_book` values(20,'不畏将来 不念过去','十二','江苏文艺出版社',19.0);
insert into `bookshop`.`t_book` values(21,'FBI行为分析学','玛丽·艾伦·奥图尔','江苏文艺出版社',19.40);
insert into `bookshop`.`t_book` values(22,'金星：掷地有声','金星','湖南人民出版社',23.9);
insert into `bookshop`.`t_book` values(23,'肖申克的救赎','弗兰克·达拉邦特 ','湖南人民出版社',21.8);
insert into `bookshop`.`t_book` values(24,'六西格玛管理学','远平 ','湖南人民出版社',24.2);
insert into `bookshop`.`t_book` values(25,'天堂的证据','埃本·亚历山大 ','百花洲文艺出版社',21.0);
insert into `bookshop`.`t_book` values(26,'龙族III黑月之潮·中','江南','长江出版社',20.6);
insert into `bookshop`.`t_book` values(27,'战国纵横：鬼谷子的局7','寒川子','江苏文艺出版社',20.60);
insert into `bookshop`.`t_book` values(28,'天定风华Ⅲ笑忘归','天下归元','江苏文艺出版社',41.30);
insert into `bookshop`.`t_book` values(29,'末日曙光','非天夜翔','湖南人民出版社',17.80);
insert into `bookshop`.`t_book` values(30,'大国兴亡录','艾米·蔡','新世界出版社',19.80);
insert into `bookshop`.`t_book` values(31,'天才在左 疯子在右','高铭','武汉大学出版社',14.90);
select * from `bookshop`.`t_book`;

CREATE  TABLE `bookshop`.`t_book` (
`id` INT NOT NULL ,
`name` VARCHAR(45) NULL ,
`auther` VARCHAR(45) NULL ,
`press` VARCHAR(45) NULL ,
`price` DOUBLE NULL ,
PRIMARY KEY (`id`) );
CREATE TABLE `bookshop`.`t_user`(
`id` int NOT NULL,
`name` varchar(20) NOT NULL,
`password` varchar(20) NULL,
`email` varchar(30) NULL,
`account` double NULL,
`address` varchar(30) NULL,
`telephone` varchar(20) NULL,
`createdate` datetime NULL,
`state` int NULL,
PRIMARY KEY (`id`));
CREATE TABLE `bookshop`.`t_order`(
`id` varchar(20) NOT NULL,
`userid` int(20) NULL,
`sum` double NULL,
`createdate` datetime NULL,
`state` int NULL,
PRIMARY KEY (`id`));
insert into `bookshop`.`t_book` values(1,'秘密','拜恩','中国城市出版社',17.3);
insert into `bookshop`.`t_book` values(2,'白鹿原','陈忠实','北京十月文艺出版社',22);
insert into `bookshop`.`t_book` values(3,'青春','韩寒','湖南人民出版社',20.3);
insert into `bookshop`.`t_book` values(4,'追风筝的人','胡赛尼','上海人民出版社',16.3);
insert into `bookshop`.`t_book` values(5,'狼图腾','姜戎','长江文艺出版社',21.1);
insert into `bookshop`.`t_book` values(6,'正能量','理查德 怀斯曼民','湖南文艺出版社',18.5);
insert into `bookshop`.`t_book` values(7,'好妈妈胜过好老师','尹建莉','作家出版社',14.3);
insert into `bookshop`.`t_book` values(8,'你若安好便是晴天','白落梅','中国华侨出版社',17.4);
insert into `bookshop`.`t_book` values(9,'不一样的卡梅拉','克利斯提昂','二十一世纪出版社',26.5);
insert into `bookshop`.`t_book` values(10,'因为痛 所以叫青春','金兰都','广西科学技术出版社',19.7);
insert into `bookshop`.`t_book` values(11,'看见','柴静','广西师范大学出版社',28.9);
insert into `bookshop`.`t_book` values(12,'超级整理术','泉正人','中国友谊出版公司',15);
insert into `bookshop`.`t_book` values(13,'余华文集','余华','作家出版社',177.5);
insert into `bookshop`.`t_book` values(14,'九州·缥缈录','江南','新世界出版社',82.2);
insert into `bookshop`.`t_book` values(15,'越二越单纯','王小柔','人民文学出版社',18.1);
insert into `bookshop`.`t_book` values(16,'那么远那么近','宇文卿','北京联合出版公司',31.1);
select * from `bookshop`.`t_book`;

SQLServer版
create database bookshop
USE [bookshop]
CREATE TABLE [dbo].[t_book](
[id] [int] NOT NULL,
[name] [varchar](20) NULL,
[auther] [varchar](20) NULL,
[press] [varchar](20) NULL,
[price] [money] NULL,
CONSTRAINT [PK_t_book] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[t_user](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](20) NOT NULL,
[password] [varchar](20) NULL,
[email] [varchar](30) NULL,
[account] [money] NULL,
[address] [varchar](30) NULL,
[telephone] [varchar](20) NULL,
[createdate] [datetime] NULL,
[state] [int] NULL,
CONSTRAINT [PK_t_user] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[t_order](
[id] [varchar](20) NOT NULL,
[userid] [int](20) NULL,
[sum] [money] NULL,
[createdate] [datetime] NULL,
[state] [int] NULL,
CONSTRAINT [PK_t_order] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
insert into [bookshop].[dbo].[t_book] values(1,'秘密','拜恩','中国城市出版社',17.3);
insert into [bookshop].[dbo].[t_book] values(2,'白鹿原','陈忠实','北京十月文艺出版社',22);
insert into [bookshop].[dbo].[t_book] values(3,'青春','韩寒','湖南人民出版社',20.3);
insert into [bookshop].[dbo].[t_book] values(4,'追风筝的人','胡赛尼','上海人民出版社',16.3);
insert into [bookshop].[dbo].[t_book] values(5,'狼图腾','姜戎','长江文艺出版社',21.1);
insert into [bookshop].[dbo].[t_book] values(6,'正能量','理查德 怀斯曼民','湖南文艺出版社',18.5);
insert into [bookshop].[dbo].[t_book] values(7,'好妈妈胜过好老师','尹建莉','作家出版社',14.3);
insert into [bookshop].[dbo].[t_book] values(8,'你若安好便是晴天','白落梅','中国华侨出版社',17.4);
insert into [bookshop].[dbo].[t_book] values(9,'不一样的卡梅拉','克利斯提昂','二十一世纪出版社',26.5);
insert into [bookshop].[dbo].[t_book] values(10,'因为痛 所以叫青春','金兰都','广西科学技术出版社',19.7);
insert into [bookshop].[dbo].[t_book] values(11,'看见','柴静','广西师范大学出版社',28.9);
insert into [bookshop].[dbo].[t_book] values(12,'超级整理术','泉正人','中国友谊出版公司',15);
insert into [bookshop].[dbo].[t_book] values(13,'余华文集','余华','作家出版社',177.5);
insert into [bookshop].[dbo].[t_book] values(14,'九州·缥缈录','江南','新世界出版社',82.2);
insert into [bookshop].[dbo].[t_book] values(15,'越二越单纯','王小柔','人民文学出版社',18.1);
insert into [bookshop].[dbo].[t_book] values(16,'那么远那么近','宇文卿','北京联合出版公司',31.1);