salary.sql

来自「vfp数据库应用编程」· SQL 代码 · 共 47 行

CREATE TABLE dbo.salary
(
   H_CODE VARCHAR(6) NULL,
   S_DATE VARCHAR(8) NULL,
   S_BSALARY NUMERIC(8,2) NULL,
   S_ALLOW1 NUMERIC(7,2) NULL,
   S_ALLOW2 NUMERIC(7,2) NULL,
   S_ALLOW3 NUMERIC(7,2) NULL,
   S_ALLOW4 NUMERIC(7,2) NULL,
   S_ALLOW5 NUMERIC(7,2) NULL,
   S_OT NUMERIC(7,2) NULL,
   S_SICK NUMERIC(7,2) NULL,
   S_EVENT NUMERIC(7,2) NULL,
   S_LATE NUMERIC(7,2) NULL,
   S_PENSIONC NUMERIC(7,2) NULL,
   S_PENSIONP NUMERIC(7,2) NULL,
   S_HOUSINGC NUMERIC(7,2) NULL,
   S_HOUSINGP NUMERIC(7,2) NULL,
   S_MEDICALC NUMERIC(7,2) NULL,
   S_MEDICALP NUMERIC(7,2) NULL,
   S_CUT1 NUMERIC(7,2) NULL,
   S_CUT2 NUMERIC(7,2) NULL,
   S_TAX NUMERIC(7,2) NULL,
   S_DOLEC NUMERIC(7,2) NULL,
   S_DOLEP NUMERIC(7,2) NULL,
   S_PAY NUMERIC(8,2) NULL
)

GO

CREATE INDEX DATECODE ON dbo.salary(S_DATE,H_CODE)

GO

CREATE INDEX CODEDATE ON dbo.salary(H_CODE,S_DATE)

GO

CREATE INDEX S_DATE ON dbo.salary(S_DATE)

GO

CREATE INDEX H_CODE ON dbo.salary(H_CODE)

END