protected override string PlatformCreateTableRelationSQL(RelationDefInfo relInfo)
{
string strCNames = relInfo.FieldNameColumnLnList();
string strFNames = relInfo.ForeignFieldNameColumnLnList();
string strSQL = ("");
strSQL += ("FOREIGN KEY(");
strSQL += strFNames;
strSQL += (") REFERENCES ");
strSQL += relInfo.m_strTable;
strSQL += ("(");
strSQL += strCNames;
strSQL += (")");
return(strSQL);
}
protected string CreateRelationSQL(RelationDefInfo relInfo, string addBegin, string addClose)
{
string strCNames = relInfo.FieldNameColumnLnList();
string strFNames = relInfo.ForeignFieldNameColumnLnList();
string strSQL = ("ALTER TABLE ");
strSQL += relInfo.m_strForeignTable;
strSQL += (" ADD ");
strSQL += addBegin;
strSQL += ("CONSTRAINT ");
strSQL += relInfo.m_strName;
strSQL += (" FOREIGN KEY (");
strSQL += strFNames;
strSQL += (") REFERENCES ");
strSQL += relInfo.m_strTable;
strSQL += (" (");
strSQL += strCNames;
strSQL += (")");
strSQL += addClose;
return(strSQL);
}
