im_table_list.sql

工厂采购系统,DELPHI+SQL SERVER,三层技术

if object_id('dbo.GL_IM_User') is not null
drop table dbo.GL_IM_User
go

Create table GL_IM_User
(
 UserID varchar(15) not null primary key,
 nick_nm varchar(30) not null,
 ip_addr varchar(30) not null,
 Port 	 int  not null
)
go

if object_id('dbo.GL_IM_Msg') is not null
drop table dbo.GL_IM_Msg
go
create table GL_IM_Msg
(
 sender  varchar(15) not null constraint fk_userid references pu_user_mstr(userid),
 Receiver varchar(15) not null constraint fk_useridx references pu_user_mstr(userid),
 Msg	  varchar(250) null
)
go