Python batchSql примеры использования

Пример #1

def upgradeDB():
    sqls = ("ALTER TABLE userinfo ADD AutoSchPlan int NULL",
            "ALTER TABLE userinfo ADD MinAutoSchInterval int NULL",
            "ALTER TABLE userinfo ADD RegisterOT int NULL",
            "ALTER TABLE userinfo ADD Image_id int NULL",
            "ALTER TABLE SchClass ADD WorkDay int NULL",
            "ALTER TABLE iclock ADD PhotoStamp varchar(20) NULL",
            "ALTER TABLE iclock ADD FWVersion varchar(30) NULL",
            "ALTER TABLE iclock ADD FPCount varchar(10) NULL",
            "ALTER TABLE iclock ADD TransactionCount varchar(10) NULL",
            "ALTER TABLE iclock ADD UserCount varchar(10) NULL",
            "ALTER TABLE iclock ADD MainTime varchar(20) NULL",
            "ALTER TABLE iclock ADD MaxFingerCount int NULL",
            "ALTER TABLE iclock ADD MaxAttLogCount int NULL",
            "ALTER TABLE iclock ADD DeviceName varchar(30) NULL",
            "ALTER TABLE iclock ADD AlgVer varchar(30) NULL",
            "ALTER TABLE iclock ADD FlashSize varchar(10) NULL",
            "ALTER TABLE iclock ADD FreeFlashSize varchar(10) NULL",
            "ALTER TABLE iclock ADD Language varchar(30) NULL",
            "ALTER TABLE iclock ADD VOLUME varchar(10) NULL",
            "ALTER TABLE iclock ADD DtFmt varchar(10) NULL",
            "ALTER TABLE iclock ADD IPAddress varchar(20) NULL",
            "ALTER TABLE iclock ADD IsTFT varchar(5) NULL",
            "ALTER TABLE iclock ADD Platform varchar(20) NULL",
            "ALTER TABLE iclock ADD Brightness varchar(5) NULL",
            "ALTER TABLE iclock ADD BackupDev varchar(30) NULL",
            "ALTER TABLE iclock ADD OEMVendor varchar(30) NULL",
            "ALTER TABLE iclock ADD AccFun int NOT NULL DEFAULT 0",
            "ALTER TABLE iclock ADD TZAdj int NOT NULL DEFAULT 8",
            "ALTER TABLE checkinout ADD WorkCode VARCHAR(20) NULL",
            "ALTER TABLE checkinout ADD Reserved VARCHAR(20) NULL",
            "ALTER TABLE iclock DROP COLUMN CheckInterval")
    batchSql(sqls)
    from mysite.iclock.modpin import checkPINWidth
    checkPINWidth()

Пример #2

Файл: modelproc.py Проект: baksoikan/zktime_wlm

def createDefautValue():
#    from mysite.iclock.sql import createDefautValue_sql
#    sqls=createDefautValue_sql()
    
    sqls=(
"ALTER TABLE departments ADD CONSTRAINT sdf DEFAULT 1 FOR supdeptid",
"ALTER TABLE userinfo ADD CONSTRAINT ddf DEFAULT 1 FOR defaultdeptid",
"ALTER TABLE userinfo ADD CONSTRAINT tdf DEFAULT 1 FOR ATT",
"ALTER TABLE userinfo ADD CONSTRAINT indf DEFAULT 1 FOR INLATE",
"ALTER TABLE userinfo ADD CONSTRAINT oedf DEFAULT 1 FOR OutEarly",
"ALTER TABLE userinfo ADD CONSTRAINT otdf DEFAULT 1 FOR OverTime",
"ALTER TABLE userinfo ADD CONSTRAINT hdf DEFAULT 1 FOR Holiday",
"ALTER TABLE userinfo ADD CONSTRAINT ldf DEFAULT 1 FOR Lunchduration",
"ALTER TABLE userinfo ADD CONSTRAINT sepdf DEFAULT 1 FOR SEP",
"ALTER TABLE userinfo ADD CONSTRAINT offdutydf DEFAULT 0 FOR OffDuty",
"ALTER TABLE userinfo ADD CONSTRAINT DelTagdf DEFAULT 0 FOR DelTag",
"ALTER TABLE userinfo ADD CONSTRAINT enamedf DEFAULT ' ' FOR name",
"ALTER TABLE template ADD CONSTRAINT fiddf DEFAULT 0 FOR FingerID",
"ALTER TABLE template ADD CONSTRAINT vdf DEFAULT 1 FOR Valid",
"ALTER TABLE template ADD CONSTRAINT dtdf DEFAULT 0 FOR DelTag",
"ALTER TABLE checkinout ADD CONSTRAINT stdf DEFAULT 'I' FOR checktype",
"ALTER TABLE checkinout ADD CONSTRAINT vcedf DEFAULT 0 FOR verifycode",
"CREATE INDEX DEPTNAME ON DEPARTMENTS(DEPTNAME)",
"CREATE UNIQUE INDEX EXCNOTE ON EXCNOTES(USERID, ATTDATE)",
"ALTER TABLE iclock ADD CONSTRAINT accfundf DEFAULT 0 FOR AccFun",
"ALTER TABLE iclock ADD CONSTRAINT tzadjdf DEFAULT 8 FOR TZAdj",
    )
    batchSql(sqls);

Пример #3

Файл: modelproc.py Проект: SongJLG/johan-doc

def upgradeDB():
    sqls=(
    "ALTER TABLE userinfo ADD AutoSchPlan int NULL",
    "ALTER TABLE userinfo ADD MinAutoSchInterval int NULL",
    "ALTER TABLE userinfo ADD RegisterOT int NULL",
    "ALTER TABLE userinfo ADD Image_id int NULL",
    "ALTER TABLE iclock ADD PhotoStamp varchar(20) NULL",
    "ALTER TABLE iclock ADD FWVersion varchar(30) NULL",
    "ALTER TABLE iclock ADD FPCount varchar(10) NULL",
    "ALTER TABLE iclock ADD TransactionCount varchar(10) NULL",
    "ALTER TABLE iclock ADD UserCount varchar(10) NULL",
    "ALTER TABLE iclock ADD MainTime varchar(20) NULL",
    "ALTER TABLE iclock ADD MaxFingerCount int NULL",
    "ALTER TABLE iclock ADD MaxAttLogCount int NULL",
    "ALTER TABLE iclock ADD DeviceName varchar(30) NULL",
    "ALTER TABLE iclock ADD AlgVer varchar(30) NULL",
    "ALTER TABLE iclock ADD FlashSize varchar(10) NULL",
    "ALTER TABLE iclock ADD FreeFlashSize varchar(10) NULL",
    "ALTER TABLE iclock ADD Language varchar(30) NULL",
    "ALTER TABLE iclock ADD VOLUME varchar(10) NULL",
    "ALTER TABLE iclock ADD DtFmt varchar(10) NULL",
    "ALTER TABLE iclock ADD IPAddress varchar(20) NULL",
    "ALTER TABLE iclock ADD IsTFT varchar(5) NULL",
    "ALTER TABLE iclock ADD Platform varchar(20) NULL",
    "ALTER TABLE iclock ADD Brightness varchar(5) NULL",
    "ALTER TABLE iclock ADD BackupDev varchar(30) NULL",
    "ALTER TABLE iclock ADD OEMVendor varchar(30) NULL",
    "ALTER TABLE iclock ADD AccFun int NOT NULL DEFAULT 0",
    "ALTER TABLE iclock ADD TZAdj int NOT NULL DEFAULT 8",
    "ALTER TABLE checkinout ADD WorkCode VARCHAR(20) NULL",
    "ALTER TABLE checkinout ADD Reserved VARCHAR(20) NULL",
    "ALTER TABLE iclock DROP COLUMN CheckInterval")
    batchSql(sqls)
    from mysite.iclock.modpin import checkPINWidth
    checkPINWidth()                                                                                

Пример #4

Файл: modelproc.py Проект: SongJLG/johan-doc

def createDefautValue():
    sqls=(
"ALTER TABLE departments ADD CONSTRAINT sdf DEFAULT 1 FOR supdeptid",
"ALTER TABLE userinfo ADD CONSTRAINT ddf DEFAULT 1 FOR defaultdeptid",
"ALTER TABLE userinfo ADD CONSTRAINT tdf DEFAULT 1 FOR ATT",
"ALTER TABLE userinfo ADD CONSTRAINT indf DEFAULT 1 FOR INLATE",
"ALTER TABLE userinfo ADD CONSTRAINT oedf DEFAULT 1 FOR OutEarly",
"ALTER TABLE userinfo ADD CONSTRAINT otdf DEFAULT 1 FOR OverTime",
"ALTER TABLE userinfo ADD CONSTRAINT hdf DEFAULT 1 FOR Holiday",
"ALTER TABLE userinfo ADD CONSTRAINT ldf DEFAULT 1 FOR Lunchduration",
"ALTER TABLE userinfo ADD CONSTRAINT sepdf DEFAULT 1 FOR SEP",
"ALTER TABLE userinfo ADD CONSTRAINT offdutydf DEFAULT 0 FOR OffDuty",
"ALTER TABLE userinfo ADD CONSTRAINT DelTagdf DEFAULT 0 FOR DelTag",
"ALTER TABLE userinfo ADD CONSTRAINT enamedf DEFAULT ' ' FOR name",
"ALTER TABLE template ADD CONSTRAINT fiddf DEFAULT 0 FOR FingerID",
"ALTER TABLE template ADD CONSTRAINT vdf DEFAULT 1 FOR Valid",
"ALTER TABLE template ADD CONSTRAINT dtdf DEFAULT 0 FOR DelTag",
"ALTER TABLE checkinout ADD CONSTRAINT stdf DEFAULT 'I' FOR checktype",
"ALTER TABLE checkinout ADD CONSTRAINT vcedf DEFAULT 0 FOR verifycode",
"CREATE INDEX DEPTNAME ON DEPARTMENTS(DEPTNAME)",
"CREATE UNIQUE INDEX EXCNOTE ON EXCNOTES(USERID, ATTDATE)",
"ALTER TABLE iclock ADD CONSTRAINT accfundf DEFAULT 0 FOR AccFun",
"ALTER TABLE iclock ADD CONSTRAINT tzadjdf DEFAULT 8 FOR TZAdj",
    )
    batchSql(sqls);

Пример #5

def createDefautValue():
    sqls = (
        "ALTER TABLE departments ADD CONSTRAINT sdf DEFAULT 1 FOR supdeptid",
        "ALTER TABLE userinfo ADD CONSTRAINT ddf DEFAULT 1 FOR defaultdeptid",
        "ALTER TABLE userinfo ADD CONSTRAINT tdf DEFAULT 1 FOR ATT",
        "ALTER TABLE userinfo ADD CONSTRAINT indf DEFAULT 1 FOR INLATE",
        "ALTER TABLE userinfo ADD CONSTRAINT oedf DEFAULT 1 FOR OutEarly",
        "ALTER TABLE userinfo ADD CONSTRAINT otdf DEFAULT 1 FOR OverTime",
        "ALTER TABLE userinfo ADD CONSTRAINT hdf DEFAULT 1 FOR Holiday",
        "ALTER TABLE userinfo ADD CONSTRAINT ldf DEFAULT 1 FOR Lunchduration",
        "ALTER TABLE userinfo ADD CONSTRAINT sepdf DEFAULT 1 FOR SEP",
        "ALTER TABLE userinfo ADD CONSTRAINT offdutydf DEFAULT 0 FOR OffDuty",
        "ALTER TABLE userinfo ADD CONSTRAINT DelTagdf DEFAULT 0 FOR DelTag",
        "ALTER TABLE userinfo ADD CONSTRAINT enamedf DEFAULT ' ' FOR name",
        "ALTER TABLE template ADD CONSTRAINT fiddf DEFAULT 0 FOR FingerID",
        "ALTER TABLE template ADD CONSTRAINT vdf DEFAULT 1 FOR Valid",
        "ALTER TABLE template ADD CONSTRAINT dtdf DEFAULT 0 FOR DelTag",
        "ALTER TABLE checkinout ADD CONSTRAINT stdf DEFAULT 'I' FOR checktype",
        "ALTER TABLE checkinout ADD CONSTRAINT vcedf DEFAULT 0 FOR verifycode",
        "ALTER TABLE checkexact ADD CONSTRAINT uidf DEFAULT 0 FOR UserID",
        "ALTER TABLE checkexact ADD CONSTRAINT ctdf DEFAULT 0 FOR CHECKTIME",
        "ALTER TABLE checkexact ADD CONSTRAINT ctydf DEFAULT 0 FOR CHECKTYPE",
        "ALTER TABLE checkexact ADD CONSTRAINT isdf DEFAULT 0 FOR ISMODIFY",
        "ALTER TABLE checkexact ADD CONSTRAINT idldf DEFAULT 0 FOR ISDELETE",
        "ALTER TABLE checkexact ADD CONSTRAINT icdf DEFAULT 0 FOR INCOUNT",
        "ALTER TABLE checkexact ADD CONSTRAINT icodf DEFAULT 0 FOR ISCOUNT",
        "ALTER TABLE holidays ADD CONSTRAINT hddf DEFAULT 1 FOR HolidayDay",
        "ALTER TABLE NUM_RUN_DEIL ADD CONSTRAINT siddf DEFAULT -1 FOR SchclassID",
        "ALTER TABLE NUM_RUN ADD CONSTRAINT oldiddf DEFAULT -1 FOR OLDID",
        "ALTER TABLE NUM_RUN ADD CONSTRAINT sddf DEFAULT '2000-1-1' FOR StartDate",
        "ALTER TABLE NUM_RUN ADD CONSTRAINT eddf DEFAULT '2099-12-31' FOR EndDate",
        "ALTER TABLE NUM_RUN ADD CONSTRAINT cedf DEFAULT 1 FOR Cyle",
        "ALTER TABLE NUM_RUN ADD CONSTRAINT usdf DEFAULT 1 FOR Units",
        "ALTER TABLE USER_OF_RUN ADD CONSTRAINT sdedf DEFAULT '1900-1-1' FOR StartDate",
        "ALTER TABLE USER_OF_RUN ADD CONSTRAINT ede1df DEFAULT '2099-12-31' FOR EndDate",
        "ALTER TABLE USER_OF_RUN ADD CONSTRAINT irndf DEFAULT 0 FOR ISNOTOF_RUN",
        "ALTER TABLE USER_SPEDAY ADD CONSTRAINT ssdf DEFAULT '1900-1-1' FOR StartSpecDay",
        "ALTER TABLE USER_SPEDAY ADD CONSTRAINT diddf DEFAULT -1 FOR DateID",
        "ALTER TABLE USER_SPEDAY ADD CONSTRAINT esddf DEFAULT '2099-12-31' FOR EndSpecDay",
        "ALTER TABLE USER_TEMP_SCH ADD CONSTRAINT otedf DEFAULT 0 FOR OverTime",
        "ALTER TABLE USER_TEMP_SCH ADD CONSTRAINT tedf DEFAULT 0 FOR Type",
        "ALTER TABLE USER_TEMP_SCH ADD CONSTRAINT fgdf DEFAULT 1 FOR Flag",
        "ALTER TABLE USER_TEMP_SCH ADD CONSTRAINT ssiddf DEFAULT -1 FOR SchclassID",
        "ALTER TABLE LeaveClass ADD CONSTRAINT mudf DEFAULT 1 FOR MinUnit",
        "ALTER TABLE LeaveClass ADD CONSTRAINT utdf DEFAULT 1 FOR Unit",
        "ALTER TABLE LeaveClass ADD CONSTRAINT rpdf DEFAULT 1 FOR RemaindProc",
        "ALTER TABLE LeaveClass ADD CONSTRAINT rcdf DEFAULT 1 FOR RemaindCount",
        "ALTER TABLE LeaveClass ADD CONSTRAINT rsdf DEFAULT '-' FOR ReportSymbol",
        "ALTER TABLE LeaveClass ADD CONSTRAINT coldf DEFAULT 0 FOR Color",
        "ALTER TABLE LeaveClass ADD CONSTRAINT cfydf DEFAULT 0 FOR Classify",
        "ALTER TABLE LeaveClass ADD CONSTRAINT dedudf DEFAULT 0 FOR Deduct",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT mutdf DEFAULT 1 FOR MinUnit",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT uitdf DEFAULT 0 FOR Unit",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT rpcdf DEFAULT 2 FOR RemaindProc",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT rctdf DEFAULT 1 FOR RemaindCount",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT rsldf DEFAULT '_' FOR ReportSymbol",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT dctdf DEFAULT 0 FOR Deduct",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT colodf DEFAULT 0 FOR Color",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT cifydf DEFAULT 0 FOR Classify",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT ltedf DEFAULT 0 FOR LeaveType",
        "ALTER TABLE SchClass ADD CONSTRAINT cindf DEFAULT 1 FOR CheckIn",
        "ALTER TABLE SchClass ADD CONSTRAINT coudf DEFAULT 1 FOR CheckOut",
        "ALTER TABLE SchClass ADD CONSTRAINT colordf DEFAULT 16715535 FOR Color",
        "ALTER TABLE SchClass ADD CONSTRAINT abdf DEFAULT 1 FOR AutoBind",
        "CREATE UNIQUE INDEX USERFINGER ON TEMPLATE(USERID, FINGERID)",
        "CREATE UNIQUE INDEX HOLIDAYNAME ON HOLIDAYS(HOLIDAYNAME)",
        "CREATE INDEX DEPTNAME ON DEPARTMENTS(DEPTNAME)",
        "CREATE UNIQUE INDEX EXCNOTE ON EXCNOTES(USERID, ATTDATE)",
        "ALTER TABLE iclock ADD CONSTRAINT accfundf DEFAULT 0 FOR AccFun",
        "ALTER TABLE iclock ADD CONSTRAINT tzadjdf DEFAULT 8 FOR TZAdj",
        "ALTER TABLE user_temp_sch ADD CONSTRAINT ovt default 0 FOR OverTime",
    )
    batchSql(sqls)

Пример #6

Файл: modelproc.py Проект: qiwihui/johan-doc

def createDefautValue():
    sqls = (
        "ALTER TABLE departments ADD CONSTRAINT sdf DEFAULT 1 FOR supdeptid",
        "ALTER TABLE userinfo ADD CONSTRAINT ddf DEFAULT 1 FOR defaultdeptid",
        "ALTER TABLE userinfo ADD CONSTRAINT tdf DEFAULT 1 FOR ATT",
        "ALTER TABLE userinfo ADD CONSTRAINT indf DEFAULT 1 FOR INLATE",
        "ALTER TABLE userinfo ADD CONSTRAINT oedf DEFAULT 1 FOR OutEarly",
        "ALTER TABLE userinfo ADD CONSTRAINT otdf DEFAULT 1 FOR OverTime",
        "ALTER TABLE userinfo ADD CONSTRAINT hdf DEFAULT 1 FOR Holiday",
        "ALTER TABLE userinfo ADD CONSTRAINT ldf DEFAULT 1 FOR Lunchduration",
        "ALTER TABLE userinfo ADD CONSTRAINT sepdf DEFAULT 1 FOR SEP",
        "ALTER TABLE userinfo ADD CONSTRAINT offdutydf DEFAULT 0 FOR OffDuty",
        "ALTER TABLE userinfo ADD CONSTRAINT DelTagdf DEFAULT 0 FOR DelTag",
        "ALTER TABLE userinfo ADD CONSTRAINT enamedf DEFAULT ' ' FOR name",
        "ALTER TABLE template ADD CONSTRAINT fiddf DEFAULT 0 FOR FingerID",
        "ALTER TABLE template ADD CONSTRAINT vdf DEFAULT 1 FOR Valid",
        "ALTER TABLE template ADD CONSTRAINT dtdf DEFAULT 0 FOR DelTag",
        "ALTER TABLE checkinout ADD CONSTRAINT stdf DEFAULT 'I' FOR checktype",
        "ALTER TABLE checkinout ADD CONSTRAINT vcedf DEFAULT 0 FOR verifycode",
        "ALTER TABLE checkexact ADD CONSTRAINT uidf DEFAULT 0 FOR UserID",
        "ALTER TABLE checkexact ADD CONSTRAINT ctdf DEFAULT 0 FOR CHECKTIME",
        "ALTER TABLE checkexact ADD CONSTRAINT ctydf DEFAULT 0 FOR CHECKTYPE",
        "ALTER TABLE checkexact ADD CONSTRAINT isdf DEFAULT 0 FOR ISMODIFY",
        "ALTER TABLE checkexact ADD CONSTRAINT idldf DEFAULT 0 FOR ISDELETE",
        "ALTER TABLE checkexact ADD CONSTRAINT icdf DEFAULT 0 FOR INCOUNT",
        "ALTER TABLE checkexact ADD CONSTRAINT icodf DEFAULT 0 FOR ISCOUNT",
        "ALTER TABLE holidays ADD CONSTRAINT hddf DEFAULT 1 FOR HolidayDay",
        "ALTER TABLE NUM_RUN_DEIL ADD CONSTRAINT siddf DEFAULT -1 FOR SchclassID",
        "ALTER TABLE NUM_RUN ADD CONSTRAINT oldiddf DEFAULT -1 FOR OLDID",
        "ALTER TABLE NUM_RUN ADD CONSTRAINT sddf DEFAULT '2000-1-1' FOR StartDate",
        "ALTER TABLE NUM_RUN ADD CONSTRAINT eddf DEFAULT '2099-12-31' FOR EndDate",
        "ALTER TABLE NUM_RUN ADD CONSTRAINT cedf DEFAULT 1 FOR Cyle",
        "ALTER TABLE NUM_RUN ADD CONSTRAINT usdf DEFAULT 1 FOR Units",
        "ALTER TABLE USER_OF_RUN ADD CONSTRAINT sdedf DEFAULT '1900-1-1' FOR StartDate",
        "ALTER TABLE USER_OF_RUN ADD CONSTRAINT ede1df DEFAULT '2099-12-31' FOR EndDate",
        "ALTER TABLE USER_OF_RUN ADD CONSTRAINT irndf DEFAULT 0 FOR ISNOTOF_RUN",
        "ALTER TABLE USER_SPEDAY ADD CONSTRAINT ssdf DEFAULT '1900-1-1' FOR StartSpecDay",
        "ALTER TABLE USER_SPEDAY ADD CONSTRAINT diddf DEFAULT -1 FOR DateID",
        "ALTER TABLE USER_SPEDAY ADD CONSTRAINT esddf DEFAULT '2099-12-31' FOR EndSpecDay",
        "ALTER TABLE USER_TEMP_SCH ADD CONSTRAINT otedf DEFAULT 0 FOR OverTime",
        "ALTER TABLE USER_TEMP_SCH ADD CONSTRAINT tedf DEFAULT 0 FOR Type",
        "ALTER TABLE USER_TEMP_SCH ADD CONSTRAINT fgdf DEFAULT 1 FOR Flag",
        "ALTER TABLE USER_TEMP_SCH ADD CONSTRAINT ssiddf DEFAULT -1 FOR SchclassID",
        "ALTER TABLE LeaveClass ADD CONSTRAINT mudf DEFAULT 1 FOR MinUnit",
        "ALTER TABLE LeaveClass ADD CONSTRAINT utdf DEFAULT 1 FOR Unit",
        "ALTER TABLE LeaveClass ADD CONSTRAINT rpdf DEFAULT 1 FOR RemaindProc",
        "ALTER TABLE LeaveClass ADD CONSTRAINT rcdf DEFAULT 1 FOR RemaindCount",
        "ALTER TABLE LeaveClass ADD CONSTRAINT rsdf DEFAULT '-' FOR ReportSymbol",
        "ALTER TABLE LeaveClass ADD CONSTRAINT coldf DEFAULT 0 FOR Color",
        "ALTER TABLE LeaveClass ADD CONSTRAINT cfydf DEFAULT 0 FOR Classify",
        "ALTER TABLE LeaveClass ADD CONSTRAINT dedudf DEFAULT 0 FOR Deduct",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT mutdf DEFAULT 1 FOR MinUnit",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT uitdf DEFAULT 0 FOR Unit",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT rpcdf DEFAULT 2 FOR RemaindProc",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT rctdf DEFAULT 1 FOR RemaindCount",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT rsldf DEFAULT '_' FOR ReportSymbol",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT dctdf DEFAULT 0 FOR Deduct",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT colodf DEFAULT 0 FOR Color",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT cifydf DEFAULT 0 FOR Classify",
        "ALTER TABLE LeaveClass1 ADD CONSTRAINT ltedf DEFAULT 0 FOR LeaveType",
        "ALTER TABLE SchClass ADD CONSTRAINT cindf DEFAULT 1 FOR CheckIn",
        "ALTER TABLE SchClass ADD CONSTRAINT coudf DEFAULT 1 FOR CheckOut",
        "ALTER TABLE SchClass ADD CONSTRAINT colordf DEFAULT 16715535 FOR Color",
        "ALTER TABLE SchClass ADD CONSTRAINT abdf DEFAULT 1 FOR AutoBind",
        "CREATE UNIQUE INDEX USERFINGER ON TEMPLATE(USERID, FINGERID)",
        "CREATE UNIQUE INDEX HOLIDAYNAME ON HOLIDAYS(HOLIDAYNAME)",
        "CREATE INDEX DEPTNAME ON DEPARTMENTS(DEPTNAME)",
        "CREATE UNIQUE INDEX EXCNOTE ON EXCNOTES(USERID, ATTDATE)",
        "ALTER TABLE iclock ADD CONSTRAINT accfundf DEFAULT 0 FOR AccFun",
        "ALTER TABLE iclock ADD CONSTRAINT tzadjdf DEFAULT 8 FOR TZAdj",
        "ALTER TABLE user_temp_sch ADD CONSTRAINT ovt default 0 FOR OverTime",
    )
    batchSql(sqls)