1
Create Table Suppliers
(
SupplierID int not null AUTO_INCREMENT ,
StateValue int default 0,
UserID int,
HitCount int default 0,
Score int default 0,
CompanyName nvarchar(140) NOT NULL,
ContactName nvarchar(30) Not NULL,
ContactTitle nvarchar(30) ,
Address nvarchar(60) Not NULL,
RegionID int,
Phone nvarchar(24) not NULL ,
Fax nvarchar(24) ,
UpdatedDate datetime,
HomePage nvarchar(100),
primary key(SupplierID),
index rid(RegionID),
index uid(UserID),
foreign key(UserID) references userInfo(User_ID),
foreign key(RegionID)references RegionInfo(RegionID)
)
2
Create Table TgInfo
(
TgID int not null AUTO_INCREMENT primary key,
UserID int references userInfo(user_id),--外键
TgTitle nvarchar(20) not null,
TgDes nvarchar(50) not null,
HitCount int default 0,
Score int default 0,
Pgmoney varchar(30) not null,
Tgmoney varchar(30) not null,
UpdatedDate datetime,
IsLock bit default 0,
Picture nvarchar(30),
StateValue int default 0
)