eshop.sql(复制的时候注意路径!!!)

beyond谚语
已于 2023-07-18 12:20:25 修改
阅读量487
点赞数
分类专栏： # SQL Server实验报告文章标签： eshop.sql
于 2019-12-06 15:38:09 首次发布
本文链接：https://blog.csdn.net/qq_41264055/article/details/103424324
版权
SQL Server实验报告专栏收录该内容
13 篇文章 46 订阅
订阅专栏
复制的时候注意路径!!!
USE [master]
GO
/****** Object:  Database [eshop]    Script Date: 2019/11/25 星期一 上午 08:54:14 ******/
CREATE DATABASE [eshop] ON  PRIMARY 
( NAME = N'eshop_dat', FILENAME = N'D:\eshop\eshop_dat.mdf' , SIZE = 10240KB , MAXSIZE = 51200KB , FILEGROWTH = 5120KB )
 LOG ON 
( NAME = N'eshop_log', FILENAME = N'D:\eshop\eshop_log.ldf' , SIZE = 10240KB , MAXSIZE = 51200KB , FILEGROWTH = 5120KB )
GO
ALTER DATABASE [eshop] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [eshop].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [eshop] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [eshop] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [eshop] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [eshop] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [eshop] SET ARITHABORT OFF 
GO
ALTER DATABASE [eshop] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [eshop] SET AUTO_CREATE_STATISTICS ON 
GO
ALTER DATABASE [eshop] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [eshop] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [eshop] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [eshop] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [eshop] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [eshop] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [eshop] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [eshop] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [eshop] SET  DISABLE_BROKER 
GO
ALTER DATABASE [eshop] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [eshop] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [eshop] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [eshop] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [eshop] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [eshop] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [eshop] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [eshop] SET RECOVERY FULL 
GO
ALTER DATABASE [eshop] SET  MULTI_USER 
GO
ALTER DATABASE [eshop] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [eshop] SET DB_CHAINING OFF 
GO
EXEC sys.sp_db_vardecimal_storage_format N'eshop', N'ON'
GO
USE [eshop]
GO
/****** Object:  Table [dbo].[members]    Script Date: 2019/11/25 星期一 上午 08:54:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[members](
	[m_account] [varchar](20) NOT NULL,
	[m_name] [varchar](20) NOT NULL,
	[m_sex] [char](2) NULL,
	[m_birth] [datetime] NULL,
	[m_address] [varchar](50) NULL,
	[m_salary] [money] NULL,
	[m_password] [varchar](20) NULL,
PRIMARY KEY CLUSTERED 
(
	[m_account] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[orders]    Script Date: 2019/11/25 星期一 上午 08:54:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[orders](
	[o_no] [char](10) NOT NULL,
	[m_account] [varchar](20) NOT NULL,
	[p_no] [char](10) NOT NULL,
	[o_quantity] [int] NULL,
	[o_date] [datetime] NULL,
	[o_confirm_state] [char](1) NULL,
	[o_pay_state] [char](1) NULL,
	[o_send_state] [char](1) NULL,
PRIMARY KEY CLUSTERED 
(
	[o_no] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[products]    Script Date: 2019/11/25 星期一 上午 08:54:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[products](
	[p_no] [char](10) NOT NULL,
	[p_name] [varchar](30) NOT NULL,
	[p_date] [datetime] NULL,
	[p_quantity] [int] NULL,
	[p_price] [money] NULL,
	[p_information] [varchar](50) NULL,
PRIMARY KEY CLUSTERED 
(
	[p_no] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[members] ([m_account], [m_name], [m_sex], [m_birth], [m_address], [m_salary], [m_password]) VALUES (N'Jinjin', N'津津有味', N'女', CAST(0x0000756500000000 AS DateTime), N'北京市', 8200.0000, N'jinjin')
INSERT [dbo].[members] ([m_account], [m_name], [m_sex], [m_birth], [m_address], [m_salary], [m_password]) VALUES (N'Lfz', N'刘法治', N'男', CAST(0x00006D5C00000000 AS DateTime), N'天津市', 4500.0000, N'lfz0826')
INSERT [dbo].[members] ([m_account], [m_name], [m_sex], [m_birth], [m_address], [m_salary], [m_password]) VALUES (N'liuzc518', N'刘志成', N'男', CAST(0x0000674300000000 AS DateTime), N'湖南株洲', 3500.0000, N'liuzc518')
INSERT [dbo].[members] ([m_account], [m_name], [m_sex], [m_birth], [m_address], [m_salary], [m_password]) VALUES (N'Wangym', N'王咏梅', N'女', CAST(0x00006A6D00000000 AS DateTime), N'湖南长沙', 4000.0000, N'wangym0806')
INSERT [dbo].[members] ([m_account], [m_name], [m_sex], [m_birth], [m_address], [m_salary], [m_password]) VALUES (N'Zhangzl', N'张自梁', N'男', CAST(0x00006B6E00000000 AS DateTime), N'湖南株洲', 4300.0000, N'zhangzl')
INSERT [dbo].[members] ([m_account], [m_name], [m_sex], [m_birth], [m_address], [m_salary], [m_password]) VALUES (N'zhao888', N'赵爱云', N'男', CAST(0x000066E300000000 AS DateTime), N'湖南株洲', 5500.0000, N'zhao888')
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N'0000000001', N'jinjin', N'0910810004', 2, CAST(0x0000966B00000000 AS DateTime), N'1', N'0', N'0')
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N'0000000002', N'lfz', N'0910810001', 1, CAST(0x000096AB00000000 AS DateTime), N'0', N'0', N'0')
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N'0000000003', N'jinjin', N'0910810004', 1, CAST(0x000096AB00000000 AS DateTime), N'1', N'1', N'1')
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N'0000000004', N'lfz', N'0910810004', 2, CAST(0x0000966B00000000 AS DateTime), N'1', N'1', N'1')
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N'0000000005', N'lfz', N'0910810004', 2, CAST(0x000096AB00000000 AS DateTime), N'1', N'1', N'1')
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N'0000000006', N'liuzc518', N'0140810324', 1, CAST(0x000096E800000000 AS DateTime), N'0', N'0', N'0')
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N'0000000007', N'liuzc518', N'0910810004', 2, CAST(0x000096E800000000 AS DateTime), N'1', N'1', N'0')
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N'0000000008', N'wangym', N'0910810001', 1, CAST(0x000096AB00000000 AS DateTime), N'1', N'0', N'0')
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N'0000000009', N'zhao888', N'0240810333', 2, CAST(0x0000966B00000000 AS DateTime), N'1', N'1', N'0')
INSERT [dbo].[orders] ([o_no], [m_account], [p_no], [o_quantity], [o_date], [o_confirm_state], [o_pay_state], [o_send_state]) VALUES (N'0000000010', N'liuzc518', N'0910810001', 1, CAST(0x000096E800000000 AS DateTime), N'1', N'1', N'0')
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N'0130810324', N'清华同方电脑', CAST(0x0000972700000000 AS DateTime), 7, 8000.0000, N'优惠多多')
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N'0140810330', N'洗衣粉', CAST(0x0000966500000000 AS DateTime), 1000, 8.6000, N'特价销售')
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N'0140810332', N'红彤彤腊肉', CAST(0x0000965A00000000 AS DateTime), 43, 15.0000, N'是一种卫生食品')
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N'0140810333', N'力士牌香皂', CAST(0x0000964C00000000 AS DateTime), 22, 6.0000, N'是一种清洁用品')
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N'0240810330', N'电动自行车', CAST(0x0000966500000000 AS DateTime), 10, 1586.0000, N'价廉物美')
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N'0240810333', N'自行车', CAST(0x0000966500000000 AS DateTime), 10, 586.0000, N'价廉物美')
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N'0910810001', N'爱国者MP3', CAST(0x0000966500000000 AS DateTime), 100, 450.0000, N'价廉物美')
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N'0910810002', N'商务通', CAST(0x0000965A00000000 AS DateTime), 10, 850.0000, N'价廉物美')
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N'0910810003', N'名人好记星', CAST(0x0000966500000000 AS DateTime), 100, 550.0000, N'价廉物美')
INSERT [dbo].[products] ([p_no], [p_name], [p_date], [p_quantity], [p_price], [p_information]) VALUES (N'0910810004', N'奥美嘉 U盘', CAST(0x0000966500000000 AS DateTime), 100, 350.0000, N'价廉物美')
USE [master]
GO
ALTER DATABASE [eshop] SET  READ_WRITE 
GO