create table StaffwageTable(ID int auto_increment primary key,StaffID varchar(50) not null,
Sdate Date not null,Amount int not null,Unitprice float not null,DaySum float not null,
MonthSum float not null,AllSum float not nll,Remarks varchar(500)
create table KucunOpelogTable(ID int auto_increment primary key,OperateDate timestamp not null,
StaffID varchar(50)not null,OperateStaff varchar(50)not null,OperateObj varchar(50) not null,
OperatingContent varchar(255)not null,Backup1 varchar(500),Remarks varchar(500)
create table HeDanTable(HDID int auto_increment primary key,SenderID varchar(50) not null,
SenderName varchar(50)not null,HDdate timestamp not null,HDstatus varchar(25)not null,
HDName varchar(50)not null,PrintStatus varchar(50)not null,Printdate date,Backup1 varchar(500),
Backup2 varchar(500),Remarks varchar(500)
create table HDcontentTable(ID int auto_increment primary key,HDID int not null,
GDID int not null,OrderID int not null,Backup1 varchar(500),Backup2 varchar(500),
Remarks varchar(500)
create view hdcontentview as select hdcontenttable.HDID,hdcontenttable.GDID,hdcontenttable.OrderID,
hedantable.SenderID,hedantable.SenderName,hedantable.HDdate,hedantable.HDstatus,
hedantable.HDName,hedantable.PrintStatus,hedantable.Printdate
from hedantable,hdcontenttable
where hedantable.HDID=hdcontenttable.HDI
这里又过不去了 大哥