use bookshop
create table T_popedom
(
PopID Int,
Popedom Nvarchar(30)
)
go
create table T_client
(
CliID Int,
Cliname Nvarchar(30),
Cliphone Nvarchar(30),
cliaddress Nvarchar(30),
Clibirthday Datetime
)
go
create table T_employees
(
Empid Int,
Empname Nvarchar(30),
Empage Int,
Empaddress Nvarchar(30),
Empbirthday Datetime,
Empphone Nvarchar(30)
)
go
create table T_Book
(
Bookid Int,
Bookname nvarchar(30),
BookAuthor Nvarchar(30),
Bookconcern Nvarchar(30),
[Quantity Perunit] Int,
Unitprice Money
)
go
create table T_sell
(
Bookid Int,
Bookname Nvarchar(30),
Cliid Int,
Uid Int,
freamount Int,
sellUnitprice Money,
Selldatetime Datetime
)
go
create table T_Buy
(
Bookid Int,
Concernid Int,
Uid Int,
freamount Int,
buyUnitprice Money,
buydatetime Datetime,
)
go
create table T_Concern
(
Concernid Int,
ConcernName Nvarchar(30),
ContactName Int,
ContactPhone Nvarchar(30),
ConcernAddress Nvarchar(30),
ConcernHomePage ntext
)
go
create table T_Log
(
Uid Int,
LoginDate datetime,
ExDate datetime
)
go
create table T_Style
(
StyleID Int,
Style nvarchar(30)
)
create table T_Storage
(
StprageID Int,
EmpID int,
StorageName nvarchar(30)
)
create table T_Numbel
(
NumID Char(10),
NameID Char(10)
)
go
create trigger trInsert on T_employees for insert
as
begin
declare @name nvarchar(30),@state int,@popedomID char(10)
set @state=(select [EmpStateid] from inserted)
if (@state=1)
begin
set @name =(select [Empname] from inserted)
set @popedomID=(select [popedomID] from inserted)
insert into dbo.T_User([Uname],[popedomID]) values(@name,@popedomID)
update [bookshop].[dbo].[T_employees] set [EmpStateid]=3 where [Empname]=@name
end
end
