DB_51Aspx/mobilesale.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

USE MASTER
GO

IF EXISTS (SELECT * FROM SYSDATABASES WHERE NAME='MTSSystem')
DROP DATABASE MTSSystem
GO

CREATE DATABASE MTSSystem
ON PRIMARY
(
NAME=MTSSystem_db,
FILENAME='D:\data\MTSSystem_db.mdf',
SIZE=1,
MAXSIZE=5,
FILEGROWTH=1


)

GO

USE MTSSystem
GO

IF EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME='mobileModel')
DROP TABLE mobileModel
GO

CREATE TABLE mobileModel
(
mobileModelID INT IDENTITY PRIMARY KEY,   --手机编号
mobileModel  NVARCHAR(30) NOT NULL,       --手机型号
mobileFactory NVARCHAR(50) NOT NULL, 	--手机厂家
totalPrice   NUMERIC NOT NULL,		--手机全价
maxDisccunt  TINYINT NOT NULL CHECK(maxDisccunt >= 75 and maxDisccunt <=100)		--手机折扣

)
GO

IF EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME='mobileSales')
DROP TABLE mobileSales
GO

CREATE TABLE mobileSales
(
saleID   INT IDENTITY PRIMARY KEY,
saleName  NVARCHAR(20) NOT NULL, 
salesVolume  NUMERIC  NOT NULL
)
GO

IF EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME='mobileOrder')
DROP TABLE mobileOrder
GO

CREATE TABLE mobileOrder
(
orderID  INT IDENTITY PRIMARY KEY,   --订单序号
customer  NVARCHAR (10) NOT NULL,	--客户姓名
IDCardNo  VARCHAR(18)  NOT NULL,--客户身份证