public TableSestavyUzivInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_lst", DB_INTEGER, dbNotNullFieldOption);
CreateField("poradi", DB_BYTE, dbNotNullFieldOption);
CreateField("navesti_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_detail", DB_INTEGER, dbNotNullFieldOption);
CreateField("info", DB_LONG, dbNotNullFieldOption);
CreateField("sirka", DB_INTEGER, dbNotNullFieldOption);
CreateField("format", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("text_nadpisu", DB_TEXT, 80, dbNotNullFieldOption);
CreateFTEXT("text_obsahu", DB_TEXT, 80, dbNullFieldOption);
CreateFTEXT("text_xmlnode", DB_TEXT, 80, dbNullFieldOption);
CreateFTEXT("text_xmlattr", DB_TEXT, 80, dbNullFieldOption);
CreateField("sirka_exp", DB_INTEGER, dbNotNullFieldOption);
CreateField("hod_mesic", DB_INTEGER, dbNotNullFieldOption);
CreateField("hod_oprava", DB_INTEGER, dbNotNullFieldOption);
CreateField("hod_seznam", DB_INTEGER, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("kod_lst");
PKConstraint.AppendField("poradi");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1SESTAVY_UZIV");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("kod_lst");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("slst_usest", "SESTAVY_LST", "sestavy_lst_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("kod_lst", "kod_lst");
}
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);
}
public TableNavestiUzivInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_navesti", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("nazev", DB_TEXT, 70, dbNotNullFieldOption);
CreateFTEXT("poznamka", DB_TEXT, 255, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("kod_navesti");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1NAVESTI_UZIV");
TableIndex.AppendField("firma_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_nav", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
}
public TableUtvarInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("uutvar_id", DB_LONG);
CreateField("zeme_cislo", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("utvnazev", DB_TEXT, 50, dbNotNullFieldOption);
CreateFTEXT("ucetni_kod", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("stat_nuts", DB_TEXT, 10, dbNullFieldOption);
CreateField("vyuctgr", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("poznamka", DB_TEXT, 255, dbNullFieldOption);
CreateField("platnost_od", DB_DATE, dbNullFieldOption);
CreateField("platnost_do", DB_DATE, dbNullFieldOption);
CreateField("personal_id", DB_LONG, dbNotNullFieldOption);
CreateField("prohlizet_id", DB_LONG, dbNotNullFieldOption);
CreateField("omezproh_id", DB_LONG, dbNotNullFieldOption);
CreateField("uzivatel_id", DB_LONG, dbNullFieldOption);
CreateField("zdroj_id", DB_LONG, dbNullFieldOption);
CreateField("stred_id", DB_LONG, dbNullFieldOption);
CreateField("cinn_id", DB_LONG, dbNullFieldOption);
CreateField("zakaz_id", DB_LONG, dbNullFieldOption);
CreateField("referzp_id", DB_LONG, dbNotNullFieldOption);
CreateField("druh_zar", DB_INTEGER, dbNotNullFieldOption);
CreateField("informace", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("mvprac_nazev", DB_TEXT, 255, true);
CreateFTEXT("mvprac_nobec", DB_TEXT, 255, true);
CreateFTEXT("mvprac_kobec", DB_TEXT, 10, true);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("uutvar_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1UTVAR");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF2UTVAR");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("zeme_cislo");
TableIndex = CreateIndex("XIF3UTVAR");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("uzivatel_id");
TableIndex = CreateIndex("XIF4UTVAR");
TableIndex.AppendField("zdroj_id");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF5UTVAR");
TableIndex.AppendField("stred_id");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF6UTVAR");
TableIndex.AppendField("cinn_id");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF7UTVAR");
TableIndex.AppendField("zakaz_id");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF8UTVAR");
TableIndex.AppendField("druh_zar");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF1VYBUTVAR");
TableIndex.AppendField("utvnazev");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_utv", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
TableRelation = CreateRelation("zdroj_utvar", "STRED_CINZAK", "zdroj_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("zdroj_id", "strcinzak_id");
TableRelation = CreateRelation("stred_utvar", "STRED_CINZAK", "stred_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("stred_id", "strcinzak_id");
TableRelation = CreateRelation("cinn_utvar", "STRED_CINZAK", "cinn_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("cinn_id", "strcinzak_id");
TableRelation = CreateRelation("zakaz_utvar", "STRED_CINZAK", "zakaz_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("zakaz_id", "strcinzak_id");
TableRelation = CreateRelation("zariz_utvar", "UZIV_CISELNIK", "druh_zar_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("druh_zar", "uzc_kod");
TableRelation = CreateRelation("zemid_utvar", "ZEME_PLATKOEF", "zeme_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("zeme_cislo", "zzeme_cislo");
}
public abstract string CreateAlterTableRelationSQL(TableDefInfo tableInfo, RelationDefInfo relInfo);
protected virtual string PlatformCreateTableRelationSQL(RelationDefInfo relInfo)
{
return(DBConstants.EMPTY_STRING);
}
public TableUcetniMediumInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("umedium_id", DB_LONG);
CreateField("info_medium", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("doklad_druh", DB_TEXT, 6, dbNullFieldOption);
CreateField("soub_cis1", DB_BYTE, dbNotNullFieldOption);
CreateField("soub_cis2", DB_BYTE, dbNotNullFieldOption);
CreateField("soub_cis3", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("soub_txt1", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("soub_txt2", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("soub_txt3", DB_TEXT, 15, dbNullFieldOption);
CreateField("doklad_cis1", DB_BYTE, dbNotNullFieldOption);
CreateField("doklad_cis2", DB_BYTE, dbNotNullFieldOption);
CreateField("doklad_cis3", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("doklad_txt1", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("doklad_txt2", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("doklad_txt3", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("ucto_klicmd", DB_TEXT, 6, dbNullFieldOption);
CreateFTEXT("ucto_klicdal", DB_TEXT, 6, dbNullFieldOption);
CreateFTEXT("znam_plus", DB_TEXT, 3, dbNullFieldOption);
CreateFTEXT("znam_minus", DB_TEXT, 3, dbNullFieldOption);
CreateFTEXT("domaci_mena", DB_TEXT, 3, dbNullFieldOption);
CreateField("spoj_ucet_md", DB_LONG, dbNullFieldOption);
CreateField("spoj_ucet_dal", DB_LONG, dbNullFieldOption);
CreateField("bezny_ucet_md", DB_LONG, dbNullFieldOption);
CreateField("bezny_ucet_dal", DB_LONG, dbNullFieldOption);
CreateField("korekce_str", DB_LONG, dbNotNullFieldOption);
CreateField("korekce_zak", DB_LONG, dbNotNullFieldOption);
CreateField("korekce_cin", DB_LONG, dbNotNullFieldOption);
CreateField("korekce_zdr", DB_LONG, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("umedium_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1UCETNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF2UCETNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("spoj_ucet_md");
TableIndex = CreateIndex("XIF3UCETNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("spoj_ucet_dal");
TableIndex = CreateIndex("XIF4UCETNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("bezny_ucet_md");
TableIndex = CreateIndex("XIF5UCETNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("bezny_ucet_dal");
TableIndex = CreateIndex("XIF6UCETNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("korekce_zak");
TableIndex = CreateIndex("XIF7UCETNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("korekce_str");
TableIndex = CreateIndex("XIF8UCETNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("korekce_cin");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_ucm", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
TableRelation = CreateRelation("zdr_umed", "STRED_CINZAK", "korekce_zdr");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("korekce_zdr", "strcinzak_id");
TableRelation = CreateRelation("cin_umed", "STRED_CINZAK", "korekce_cin");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("korekce_cin", "strcinzak_id");
TableRelation = CreateRelation("str_umed", "STRED_CINZAK", "korekce_str");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("korekce_str", "strcinzak_id");
TableRelation = CreateRelation("zak_umed", "STRED_CINZAK", "korekce_zak");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("korekce_zak", "strcinzak_id");
}
public TableSberneMediumInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("smedium_id", DB_LONG);
CreateField("info_medium", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("nazev_klienta", DB_TEXT, 25, dbNullFieldOption);
CreateField("soubor_start", DB_BYTE, dbNotNullFieldOption);
CreateField("soubor_stop", DB_BYTE, dbNotNullFieldOption);
CreateField("soubor_next", DB_BYTE, dbNotNullFieldOption);
CreateField("datum_predani", DB_INTEGER, dbNotNullFieldOption);
CreateField("datum_transakce", DB_INTEGER, dbNotNullFieldOption);
CreateField("datum_splatnosti", DB_INTEGER, dbNotNullFieldOption);
CreateField("datum_prevodu", DB_INTEGER, dbNotNullFieldOption);
CreateField("datum_popprev", DB_INTEGER, dbNotNullFieldOption);
CreateField("bezny_bkspoj_id", DB_LONG, dbNotNullFieldOption);
CreateField("debet_bkspoj_id", DB_LONG, dbNotNullFieldOption);
CreateField("cpopl_bkspoj_id", DB_LONG, dbNotNullFieldOption);
CreateField("dpopl_bkspoj_id", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("par_kod_obr11", DB_TEXT, 6, dbNullFieldOption);
CreateFTEXT("par_kod_obr32", DB_TEXT, 6, dbNullFieldOption);
CreateField("crc", DB_LONG, dbNotNullFieldOption);
CreateField("prior_prevodu", DB_INTEGER, dbNotNullFieldOption);
CreateField("prior_popprev", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("cislo_klienta", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("telefon", DB_TEXT, 20, dbNullFieldOption);
CreateField("ucet_dal", DB_LONG, dbNullFieldOption);
CreateField("ucet_md", DB_LONG, dbNullFieldOption);
CreateField("ucetni_str", DB_LONG, dbNullFieldOption);
CreateField("ucetni_zak", DB_LONG, dbNullFieldOption);
CreateField("ucetni_cin", DB_LONG, dbNullFieldOption);
CreateField("prijem_id", DB_LONG, dbNullFieldOption);
CreateField("ucetni_zdr", DB_LONG, dbNullFieldOption);
CreateField("soub_cis1", DB_BYTE, dbNotNullFieldOption);
CreateField("soub_cis2", DB_BYTE, dbNotNullFieldOption);
CreateField("soub_cis3", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("soub_txt1", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("soub_txt2", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("soub_txt3", DB_TEXT, 15, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("smedium_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1SBERNE_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF2SBERNE_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("ucet_dal");
TableIndex = CreateIndex("XIF3SBERNE_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("ucet_md");
TableIndex = CreateIndex("XIF4SBERNE_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("ucetni_zak");
TableIndex = CreateIndex("XIF5SBERNE_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("ucetni_str");
TableIndex = CreateIndex("XIF6SBERNE_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("ucetni_cin");
TableIndex = CreateIndex("XIF7SBERNE_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("prijem_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_sbm", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
}
public override string CreateAlterTableRelationSQL(TableDefInfo tableInfo, RelationDefInfo relInfo)
{
return(DBConstants.EMPTY_STRING);
}
