--创建数据库
use master
go
--判断数据库是否存在,存在删除
if exists(select * from sys.databases where name='DigitalProductShop')
drop database DigitalProductShop
go
--(创建数据库)
create database DigitalProductShop
go
--(进入创建的数据库)
use DigitalProductShop
go
--(产品类别表)
create table ProductCategory
(
Id int primary key identity(1,1),
Name nvarchar(16) not null
)
--产品表
create table Product
(
Id int primary key identity(1,1),
ProductName nvarchar(32) not null,
MarketPrice decimal(16,2) not null,
SellingPrice decimal(16,2) not null,
CategoryId int references ProductCategory(Id),
Introduction nvarchar(128) not null,
IsOnSale bit not null,
AddTime datetime default getdate()
)
--测试数据
insert into ProductCategory values('手机')
insert into ProductCategory values('笔记本')
insert into ProductCategory values('平板电脑')
insert into ProductCategory values('台式机')
insert into Product values('iPhone XR',6099,7200,1,'xxxx',1,GETDATE())
insert into Product values('荣耀十',5099,6200,3,'xxxx',0,GETDATE())
insert into Product values('戴尔',7099,8500,2,'xxxx',0,GETDATE())