===================================
创建划线排班表分类.sql
===================================
-----错误提示如下-----
Duplicate entry '168' for key 'PRIMARY'
-----语句如下-----
-- 新增划线排班表分类
INSERT INTO WEBTABLETYPE(TABLETYPEID,TABLETYPEDES,TABLEVISIBLE,ACESSMODULE,MODULEID,TABLEPREFIX,ALLOWADDTABLE,EDITMODE)
SELECT '168','划线排班','1','111111111111111111111111111111','05','','1','1110000000' FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM WEBTABLETYPE WHERE TABLETYPEID='168' AND TABLETYPEDES='划线排班');

-- 新增划线排班表分类模板列
INSERT INTO WebTableTemplate(TableTypeID,ColName,ColOrder,ColType,ColWidth,ColPrecision,ColNull,ColDefault,DisplayLabel,DisplayWidth,DisplayFormat,EditFormat,ColVarify,VarifyMsg,ColVisible,ColProperty)
SELECT 168,'RecordID', 1, 'INT IDENTITY',4, 0, 0, NULL,'记录ID', 6, NULL, NULL, NULL, NULL,0,1 FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM WebTableTemplate WHERE TableTypeID=168);