SQL Server

Development Platform:

C#

Super market数据库文件.sql：Code Content

							use master
go
if exists(select * from sysdatabases where name='wkdl')
	begin
		drop database wkdl
		create database wkdl
		on primary
		(
		name='wkdl_data',
		filename='D:wkdl.mdf',
		size=3,
		filegrowth=15%
		)
		log on
		(
		name='wkdl_log',
		filename='D:wkdl.ldf',
		size=3,
		filegrowth=15%
		)
	end
else
	begin
		create database wkdl
		on primary
		(
		name='wkdl_data',
		filename='D:wkdl.mdf',
		size=3,
		filegrowth=15%
		)
		log on
		(
		name='MyQQ_log',
		filename='D:wkdl.ldf',
		size=3,
		filegrowth=15%
		)
	end
go
use wkdl
go
create table userlogin
(
	uid int identity(1,1),
	uName varchar(50) not null,
	uPassword varchar(50) not null,
	usa varchar(50) not null
)
go
alter table userlogin
add constraint pk_id primary key (uName)
go
create table ware
(
	[Id] int identity(1,1),
	wareName varchar(20) not null,
	price decimal(18,2) not null,
	entries int not null,
	[keep] int not null
)
go
alter table ware
add constraint qk_id primary key (wareName)
go
--添加数据
insert into userlogin (uName,uPassword,usa) values('wdxg','ayjl','管理员')
insert into userlogin (uName,uPassword,usa) values('sa','.','管理员')
insert into userlogin (uName,uPassword,usa) values('test','test','员工')
insert into userlogin (uName,uPassword,usa) values('super','super','员工')
go
insert into ware (wareName,price,entries,[keep]) values('火龙果',1.22,120,12)
insert into ware (wareName,price,entries,[keep]) values('黄瓜',2.22,22,1)
insert into ware (wareName,price,entries,[keep]) values('土豆',3.33,0,2)
insert into ware (wareName,price,entries,[keep]) values('番茄',4.44,2,3)
insert into ware (wareName,price,entries,[keep]) values('西瓜',5.55,14,4)
insert into ware (wareName,price,entries,[keep]) values('胡萝卜',6.66,52,5)
insert into ware (wareName,price,entries,[keep]) values('苦瓜',7.77,9,6)
insert into ware (wareName,price,entries,[keep]) values('葡萄',8.88,0,8)
go

						