/**Begin D:\PDM_UPGRADE\PDM1\HAOS_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_HAOS_EMPTYREMAINSTAFF') 
 CREATE TABLE T_HAOS_EMPTYREMAINSTAFF (
FID BIGINT DEFAULT 0 NOT NULL,
FADMINORGID BIGINT DEFAULT 0 NOT NULL,
FSTAFFTYPE VARCHAR(2) DEFAULT ' ' NOT NULL,
FSTAFFCOUNT INT DEFAULT 0 NOT NULL,
FREMAINCOUNT INT DEFAULT 0 NOT NULL,
FOCCUPYCOUNT INT DEFAULT 0 NOT NULL,
FPARENTORGLONGNAME VARCHAR(50) DEFAULT ' ' NOT NULL,
FCREATORID BIGINT DEFAULT 0 NOT NULL,
FCREATETIME DATETIME,
FMODIFIERID BIGINT DEFAULT 0 NOT NULL,
FMODIFYTIME DATETIME
);



/**End D:\PDM_UPGRADE\PDM1\HAOS_table.sql **/
