store-project/src-tauri/resources/init.sql

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;