

-------------------------------------------------------------------------------
--  schedule
-------------------------------------------------------------------------------
CREATE TABLE PIM_SCHEDULE(
        ID BIGINT NOT NULL,
	NAME VARCHAR(200),
	LOCATION VARCHAR(200),
	CONTENT VARCHAR(200),
	TYPE INTEGER,
	START_TIME DATETIME,
	END_TIME DATETIME,
	ALERT_TIME VARCHAR(50),
	USER_ID VARCHAR(64),
	STATUS INTEGER,
	REF VARCHAR(100),
        CONSTRAINT PK_PIM_SCHEDULE PRIMARY KEY(ID)
) ENGINE=INNODB CHARSET=UTF8;

