int sqlScripts_qyImGrpInfoTab( CString * sqlStr, unsigned int uiMaxCnt, int * piCnt, char * pAutoincrement, char * p_nchar, char * p_nvarchar )
{
int cnt = *piCnt;
TCHAR * pTabName = CONST_tabName_qyImGrpInfoTab;
//
sqlStr[cnt] = CString( "" ) + "create table " + pTabName + "("
"id " + pAutoincrement + ","
"idStr char(20) not null,"
"misServName " + getDataType( p_nvarchar, 255 ) + " not null," // varchar(255),"
"constraint tmpIndex_" + pTabName + " unique(misServName,idStr),"
//
"name " + getDataType( p_nvarchar, 255 ) + "," // varchar(255),"
//
"subtype int," // 2014/01/31
//
"idStr_creator char(20)," // 2017/07/25
//
"startTime char(14),"
"tLastModifiedTime char(14),"
//
"col0 varchar(255),"
"col1 varchar(255),"
"col2 varchar(255),"
"col3 varchar(255),"
"col4 varchar(255),"
+ "comment0 varchar(255)"
")";
cnt ++ ;
*piCnt = cnt;
return 0;
}
