IF NOT EXISTS (SELECT name FROM sqlite_master WHERE type='table' AND name='mt_goods_cate') THEN CREATE TABLE mt_goods_cate ( ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT DEFAULT '', LOGO TEXT DEFAULT '', LOCAL_LOGO TEXT DEFAULT '', DESCRIPTION TEXT, CREATE_TIME DATETIME DEFAULT NULL, UPDATE_TIME DATETIME DEFAULT NULL, OPERATOR TEXT DEFAULT NULL, SORT INTEGER DEFAULT 0, STATUS TEXT DEFAULT 'A' ); END IF;