public TableSestavyLstInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_lst", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("nazev", DB_TEXT, 120, dbNotNullFieldOption);
CreateField("druh", DB_BYTE, dbNotNullFieldOption);
CreateField("typ_lst", DB_BYTE, dbNotNullFieldOption);
CreateField("skupina", DB_BYTE, dbNotNullFieldOption);
CreateField("kod_data", DB_INTEGER, dbNotNullFieldOption);
CreateField("subjekt_id", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("soubor", DB_TEXT, 255, dbNullFieldOption);
CreateField("informace", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("oddelovac_pol", DB_TEXT, 5, dbNullFieldOption);
CreateFTEXT("oddelovac_rad", DB_TEXT, 5, dbNullFieldOption);
CreateField("typcrlf_rad", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("trideni", DB_TEXT, 255, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("kod_lst");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1SESTAVY_LST");
TableIndex.AppendField("firma_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_slst", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
}
public TableSestavyUdataInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("uzivatel_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_data", DB_INTEGER, dbNotNullFieldOption);
CreateField("vytvor_dat", DB_DATE, dbNullFieldOption);
CreateField("vyuct_dat", DB_DATE, dbNullFieldOption);
CreateField("mesic_od", DB_INTEGER, dbNotNullFieldOption);
CreateField("mesic_do", DB_INTEGER, dbNotNullFieldOption);
CreateField("rok", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("vytvor_txt", DB_TEXT, 255, dbNullFieldOption);
CreateField("vytvor_vyuc", DB_INTEGER, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("uzivatel_id");
PKConstraint.AppendField("kod_data");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1SESTAVY_UDATA");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("uzivatel_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("uziv_udata", "UZIVATEL", "uzivatel_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("uzivatel_id", "uuzivatel_id");
}
public TableSestavyFiltrInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_lst", DB_INTEGER, dbNotNullFieldOption);
CreateField("typ_filtru", DB_BYTE, dbNotNullFieldOption);
CreateField("poradi", DB_BYTE, dbNotNullFieldOption);
CreateField("typ_vyberu", DB_INTEGER, dbNotNullFieldOption);
CreateField("kategorie", DB_BYTE, dbNotNullFieldOption);
CreateField("druh", DB_BYTE, dbNotNullFieldOption);
CreateField("kod_polozky", DB_INTEGER, dbNotNullFieldOption);
CreateField("kod_begin", DB_INTEGER, dbNotNullFieldOption);
CreateField("kod_end", DB_INTEGER, dbNotNullFieldOption);
CreateField("zapocty", DB_LONG, dbNotNullFieldOption);
CreateField("sazba_pr", DB_LONG, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("kod_lst");
PKConstraint.AppendField("typ_filtru");
PKConstraint.AppendField("poradi");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1SESTAVY_FILTR");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("kod_lst");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("slst_filtr", "SESTAVY_LST", "sestavy_lst_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("kod_lst", "kod_lst");
}
protected override void TryProcessCast3Indexs(IList <TableDefInfo> tableList, IGeneratorWriter scriptWriter)
{
bool bCreatePKs = (m_scriptBuilder.DbXPIndexInCreateTable() == false);
foreach (TableDefInfo tableDef in tableList)
{
if (bCreatePKs)
{
IndexDefInfo indexPK = tableDef.IndexPK();
if (indexPK != null)
{
string scriptPart = m_scriptBuilder.AlterXPKIndexSQL(indexPK);
scriptPart += DBConstants.NEW_LINE_STR;
scriptWriter.DefaultCodeLine(scriptPart, indexPK.InfoName());
}
}
IList <IndexDefInfo> indexes = tableDef.IndexesNonPK();
foreach (var indexIF in indexes)
{
string scriptPart = m_scriptBuilder.CreateIndexSQL(indexIF);
scriptPart += DBConstants.NEW_LINE_STR;
scriptWriter.DefaultCodeLine(scriptPart, indexIF.InfoName());
}
}
}
public TableFiltrPmediaInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("pmedium_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("filtr_id", DB_LONG);
CreateField("zpusob", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("cislo_uctu", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("varsymb", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("konsymb", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("specsymb", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("popis", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("cislo_pobocky", DB_TEXT, 10, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("pmedium_id");
PKConstraint.AppendField("filtr_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1FILTR_PMEDIA");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("pmedium_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("pid_pfil", "PLATEBNI_MEDIUM", "pmedium_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("pmedium_id", "pmedium_id");
}
private string CreateConstraintSQL(IndexDefInfo indexInfo, bool addComma, bool addNewLine)
{
if (indexInfo == null)
{
return(DBConstants.EMPTY_STRING);
}
string sqlCommand = DBConstants.EMPTY_STRING;
string sqlFieldsList = CreateConstraintFiledList(indexInfo.IndexFields(), indexInfo.m_bPrimary);
sqlCommand = PlatformCreateContraintSQL(sqlFieldsList, indexInfo.m_strName, indexInfo.m_bPrimary);
if (sqlCommand != DBConstants.EMPTY_STRING)
{
if (addComma)
{
sqlCommand += ",";
}
if (addNewLine)
{
sqlCommand += DBConstants.NEW_LINE_STR;
}
}
return(sqlCommand);
}
public TableVrepPodaniDataInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("ppodani_id", DB_LONG);
CreateFTEXT("correlation_id", DB_TEXT, 50, dbNullFieldOption);
CreateFTEXT("vars_sign", DB_TEXT, 50, dbNullFieldOption);
CreateField("uzivatel_id", DB_LONG, dbNotNullFieldOption);
CreateField("podani_type", DB_INTEGER, dbNotNullFieldOption);
CreateField("podani_state", DB_INTEGER, dbNotNullFieldOption);
CreateField("podani_date", DB_DATE, dbNullFieldOption);
CreateFTEXT("cert_sign", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("cert_crypt", DB_TEXT, 255, dbNullFieldOption);
CreateField("xml_data", DB_LONGBINARY, dbNullFieldOption);
CreateField("xml_error", DB_LONGBINARY, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("ppodani_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1VREP_PODANI_DATA");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("uzivatel_id");
TableIndex.AppendField("ppodani_id");
}
public TablePpomUkazateleInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("poradi", DB_BYTE, dbNotNullFieldOption);
CreateField("navesti_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_detail", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("text_nadpisu", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("text_obsahu", DB_TEXT, 255, dbNullFieldOption);
CreateField("info", DB_LONG, dbNotNullFieldOption);
CreateField("format", DB_BYTE, dbNotNullFieldOption);
CreateField("sirka", DB_INTEGER, dbNotNullFieldOption);
CreateField("sirka_exp", DB_INTEGER, dbNotNullFieldOption);
CreateField("hod_mesic", DB_INTEGER, dbNotNullFieldOption);
CreateField("hod_oprava", DB_INTEGER, dbNotNullFieldOption);
CreateField("hod_seznam", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("text_xmlattr", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("text_xmlnode", DB_TEXT, 255, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("poradi");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fir_ppomukaz", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
}
public TableNavestiFiltrInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("kod_navesti", DB_INTEGER, dbNotNullFieldOption);
CreateField("typ_filtru", DB_BYTE, dbNotNullFieldOption);
CreateField("poradi", DB_BYTE, dbNotNullFieldOption);
CreateField("typ_vyberu", DB_INTEGER, dbNotNullFieldOption);
CreateField("kategorie", DB_BYTE, dbNotNullFieldOption);
CreateField("druh", DB_BYTE, dbNotNullFieldOption);
CreateField("kod_polozky", DB_INTEGER, dbNotNullFieldOption);
CreateField("kod_begin", DB_INTEGER, dbNotNullFieldOption);
CreateField("kod_end", DB_INTEGER, dbNotNullFieldOption);
CreateField("zapocty", DB_LONG, dbNotNullFieldOption);
CreateField("sazba_pr", DB_LONG, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("kod_navesti");
PKConstraint.AppendField("typ_filtru");
PKConstraint.AppendField("poradi");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("nav_filtr", "NAVESTI_UZIV", "navesti_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("kod_navesti", "kod_navesti");
}
public TableImp101UtvarInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("davka_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("impRadek_id", DB_LONG);
CreateField("zpracovano", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("nazev", DB_TEXT, 50, dbNotNullFieldOption);
CreateFTEXT("ucetni_kod", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("poznamka", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("zeme_cislo", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("uzivatel_jmeno", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("plati_od", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("plati_do", DB_TEXT, 10, dbNullFieldOption);
CreateGDATE("reg_datum", DB_DATE, dbNotNullFieldOption);
CreateField("reg_logid", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("davka_id");
PKConstraint.AppendField("impRadek_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1IMP_101_UTVAR", true);
TableIndex.AppendField("firma_id");
TableIndex.AppendField("davka_id");
TableIndex.AppendField("nazev");
}
public TableImp06SocPojInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("davka_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("impRadek_id", DB_LONG);
CreateFTEXT("pnr", DB_TEXT, 12, dbNotNullFieldOption);
CreateField("zpracovano", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("SOC_POJ_KOD", DB_TEXT, 5, dbNullFieldOption);
CreateFTEXT("SOC_POJ_MISTO", DB_TEXT, 48, dbNullFieldOption);
CreateGDATE("reg_datum", DB_DATE, dbNotNullFieldOption);
CreateField("reg_logid", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("davka_id");
PKConstraint.AppendField("impRadek_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1IMP_06_SOC_POJ", true);
TableIndex.AppendField("firma_id");
TableIndex.AppendField("davka_id");
TableIndex.AppendField("pnr");
}
public TableStavSemaforInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("uzivatel_id", DB_LONG, dbNotNullFieldOption);
CreateField("semaf_type", DB_INTEGER, dbNotNullFieldOption);
CreateField("semaf_flag", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("semaf_guid", DB_TEXT, 64, dbNullFieldOption);
CreateField("semaf_time", DB_DATE, dbNullFieldOption);
CreateField("server_sid", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("wwks_name", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("wwks_user", DB_TEXT, 255, dbNullFieldOption);
CreateField("serial_num", DB_LONG, dbNotNullFieldOption);
CreateField("pracov_id", DB_LONG, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("uzivatel_id");
PKConstraint.AppendField("semaf_type");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1STAV_SEMAFOR");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("uzivatel_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("uid_semaf", "UZIVATEL", "uzivatel_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("uzivatel_id", "uuzivatel_id");
}
public TableImp31PrAdresaInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("davka_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("impRadek_id", DB_LONG);
CreateFTEXT("pnr", DB_TEXT, 12, dbNotNullFieldOption);
CreateField("zpracovano", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("adr_obec", DB_TEXT, 48, dbNullFieldOption);
CreateFTEXT("adr_cast_obce", DB_TEXT, 48, dbNullFieldOption);
CreateFTEXT("adr_cisdom_typ", DB_TEXT, 1, dbNullFieldOption);
CreateFTEXT("adr_cisdom_hod", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("adr_ulice", DB_TEXT, 48, dbNullFieldOption);
CreateFTEXT("adr_psc", DB_TEXT, 11, dbNullFieldOption);
CreateFTEXT("adr_nazev_posty", DB_TEXT, 48, dbNullFieldOption);
CreateFTEXT("adr_cisor_hod", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("adr_stat_kod", DB_TEXT, 10, dbNullFieldOption);
CreateGDATE("reg_datum", DB_DATE, dbNotNullFieldOption);
CreateField("reg_logid", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("davka_id");
PKConstraint.AppendField("impRadek_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1IMP_31_PR_ADRESA", true);
TableIndex.AppendField("firma_id");
TableIndex.AppendField("davka_id");
TableIndex.AppendField("pnr");
}
public TableImp05ZdrPojInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("davka_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("impRadek_id", DB_LONG);
CreateFTEXT("pnr", DB_TEXT, 12, dbNotNullFieldOption);
CreateField("zpracovano", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("zdr_poj_kod", DB_TEXT, 5, dbNullFieldOption);
CreateFTEXT("zdr_poj_misto", DB_TEXT, 48, dbNullFieldOption);
CreateFTEXT("zdr_poj_cislo", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("zdr_poj_cizinec", DB_TEXT, 1, dbNullFieldOption);
CreateGDATE("reg_datum", DB_DATE, dbNotNullFieldOption);
CreateField("reg_logid", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("davka_id");
PKConstraint.AppendField("impRadek_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1IMP_05_ZDR_POJ", true);
TableIndex.AppendField("firma_id");
TableIndex.AppendField("davka_id");
TableIndex.AppendField("pnr");
}
public TablePoplatkyInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("smedium_id", DB_LONG, dbNotNullFieldOption);
CreateField("platnost_od", DB_DATE, dbNotNullFieldOption);
CreateField("castka_do", DB_LONG, dbNotNullFieldOption);
CreateField("platnost_do", DB_DATE, dbNullFieldOption);
CreateField("sazba", DB_LONG, dbNotNullFieldOption);
CreateField("castka_dalsi", DB_LONG, dbNotNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("smedium_id");
PKConstraint.AppendField("platnost_od");
PKConstraint.AppendField("castka_do");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1POPLATKY");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("smedium_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("sid_pop", "SBERNE_MEDIUM", "smedium_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("smedium_id", "smedium_id");
}
public TableDetailMediaInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("detail_id", DB_LONG);
CreateField("poradi", DB_BYTE, dbNotNullFieldOption);
CreateField("skupina", DB_BYTE, dbNotNullFieldOption);
CreateField("navesti", DB_LONG, dbNotNullFieldOption);
CreateField("info", DB_INTEGER, dbNotNullFieldOption);
CreateField("sirka_exp", DB_INTEGER, dbNotNullFieldOption);
CreateField("sirka_op", DB_INTEGER, dbNotNullFieldOption);
CreateField("format_typ", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("format_str", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("nadpis", DB_TEXT, 80, dbNullFieldOption);
CreateField("smedium_id", DB_LONG, dbNullFieldOption);
CreateField("pmedium_id", DB_LONG, dbNullFieldOption);
CreateField("umedium_id", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("detail_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1DETAIL_MEDIA");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("smedium_id");
TableIndex = CreateIndex("XIF2DETAIL_MEDIA");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("pmedium_id");
TableIndex = CreateIndex("XIF3DETAIL_MEDIA");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("umedium_id");
}
public TableFirmaInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateFAUTO("ffirma_id", DB_LONG);
CreateFTEXT("firnazev", DB_TEXT, 20, dbNotNullFieldOption);
CreateField("verze", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("zap_obchrej", DB_TEXT, 255, dbNullFieldOption);
CreateField("cislo_prac", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("sest_textoou", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("rozp_kapitola", DB_TEXT, 24, dbNullFieldOption);
CreateFTEXT("rozp_paragraf", DB_TEXT, 24, dbNullFieldOption);
CreateFTEXT("rozp_polozka", DB_TEXT, 24, dbNullFieldOption);
CreateFTEXT("rozp_podpoloz", DB_TEXT, 24, dbNullFieldOption);
CreateFTEXT("rozp_zazpoloz", DB_TEXT, 24, dbNullFieldOption);
CreateFTEXT("rozp_ucelzdroj", DB_TEXT, 24, dbNullFieldOption);
CreateFTEXT("rozp_kompetent", DB_TEXT, 24, dbNullFieldOption);
CreateFTEXT("rozp_akce", DB_TEXT, 48, dbNullFieldOption);
CreateFTEXT("mvprac_nazev", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("mvprac_nobec", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("mvprac_kobec", DB_TEXT, 10, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("ffirma_id");
}
public TableImp08ProhlMesInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("davka_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("impRadek_id", DB_LONG);
CreateFTEXT("pnr", DB_TEXT, 12, dbNotNullFieldOption);
CreateField("zpracovano", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("podepsal", DB_TEXT, 1, dbNullFieldOption);
CreateFTEXT("invalidita1", DB_TEXT, 1, dbNullFieldOption);
CreateFTEXT("invalidita2", DB_TEXT, 1, dbNullFieldOption);
CreateFTEXT("invalidita3", DB_TEXT, 1, dbNullFieldOption);
CreateGDATE("reg_datum", DB_DATE, dbNotNullFieldOption);
CreateField("reg_logid", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("davka_id");
PKConstraint.AppendField("impRadek_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1IMP_08_PROHL_MES", true);
TableIndex.AppendField("firma_id");
TableIndex.AppendField("davka_id");
TableIndex.AppendField("pnr");
}
public TableImp21SrazkaInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("davka_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("impRadek_id", DB_LONG);
CreateFTEXT("pnr", DB_TEXT, 12, dbNotNullFieldOption);
CreateField("zpracovano", DB_BYTE, dbNotNullFieldOption);
CreateField("id", DB_LONG, dbNotNullFieldOption);
CreateField("cislo", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("kod", DB_TEXT, 4, dbNullFieldOption);
CreateFTEXT("kod_text", DB_TEXT, 6, dbNullFieldOption);
CreateFTEXT("celkem_kc", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("mesicne_kc", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("proc_jednotky", DB_TEXT, 5, dbNullFieldOption);
CreateFTEXT("posledni_kc", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("posledni_den", DB_TEXT, 2, dbNullFieldOption);
CreateFTEXT("posledni_mesic", DB_TEXT, 2, dbNullFieldOption);
CreateFTEXT("posledni_rok", DB_TEXT, 4, dbNullFieldOption);
CreateFTEXT("str_nazev", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("cin_nazev", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("zak_nazev", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("trvale", DB_TEXT, 2, dbNullFieldOption);
CreateFTEXT("zp_vyplaty", DB_TEXT, 1, dbNullFieldOption);
CreateFTEXT("adr_obec", DB_TEXT, 48, dbNullFieldOption);
CreateFTEXT("adr_cast_obce", DB_TEXT, 48, dbNullFieldOption);
CreateFTEXT("adr_cisdom_typ", DB_TEXT, 1, dbNullFieldOption);
CreateFTEXT("adr_cisdom_hod", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("adr_ulice", DB_TEXT, 48, dbNullFieldOption);
CreateFTEXT("adr_psc", DB_TEXT, 11, dbNullFieldOption);
CreateFTEXT("adr_nazev_posty", DB_TEXT, 48, dbNullFieldOption);
CreateFTEXT("adr_cisor_hod", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("adr_stat_kod", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("bank_ucet", DB_TEXT, 18, dbNullFieldOption);
CreateFTEXT("bank_ustav", DB_TEXT, 4, dbNullFieldOption);
CreateFTEXT("bank_konsymb", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("bank_varsymb", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("bank_specsymb", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("opt_valuta_mena", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("opt_zeme_nazev", DB_TEXT, 50, dbNullFieldOption);
CreateFTEXT("opt_mesto_nazev", DB_TEXT, 50, dbNullFieldOption);
CreateGDATE("reg_datum", DB_DATE, dbNotNullFieldOption);
CreateField("reg_logid", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("davka_id");
PKConstraint.AppendField("impRadek_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1IMP_21_SRAZKA", true);
TableIndex.AppendField("firma_id");
TableIndex.AppendField("davka_id");
TableIndex.AppendField("pnr");
TableIndex.AppendField("id");
}
public TableImp01PracInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("davka_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("impRadek_id", DB_LONG);
CreateFTEXT("pnr", DB_TEXT, 12, dbNotNullFieldOption);
CreateField("zpracovano", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("rodne_cislo", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("rodne_prijmeni", DB_TEXT, 35, dbNullFieldOption);
CreateFTEXT("utvar_nazev", DB_TEXT, 50, dbNullFieldOption);
CreateFTEXT("str_nazev", DB_TEXT, 50, dbNullFieldOption);
CreateFTEXT("cin_nazev", DB_TEXT, 50, dbNullFieldOption);
CreateFTEXT("zak_nazev", DB_TEXT, 50, dbNullFieldOption);
CreateFTEXT("prijmeni", DB_TEXT, 35, dbNullFieldOption);
CreateFTEXT("jmeno", DB_TEXT, 30, dbNullFieldOption);
CreateFTEXT("titul_pred", DB_TEXT, 35, dbNullFieldOption);
CreateFTEXT("titul_za", DB_TEXT, 13, dbNullFieldOption);
CreateFTEXT("misto_narozeni", DB_TEXT, 48, dbNullFieldOption);
CreateFTEXT("rodst_kod", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("zapocet_roky", DB_TEXT, 2, dbNullFieldOption);
CreateFTEXT("zapocet_dny", DB_TEXT, 3, dbNullFieldOption);
CreateFTEXT("zapocet_datum", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("adr_tr_obec", DB_TEXT, 48, dbNullFieldOption);
CreateFTEXT("adr_tr_cast_obce", DB_TEXT, 48, dbNullFieldOption);
CreateFTEXT("adr_tr_cisdom_typ", DB_TEXT, 3, dbNullFieldOption);
CreateFTEXT("adr_tr_cisdom_hod", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("adr_tr_ulice", DB_TEXT, 48, dbNullFieldOption);
CreateFTEXT("adr_tr_psc", DB_TEXT, 11, dbNullFieldOption);
CreateFTEXT("adr_tr_nazev_posty", DB_TEXT, 48, dbNullFieldOption);
CreateFTEXT("adr_tr_cisor_hod", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("adr_tr_stat_kod", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("vychov_deti", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("duchod_pob", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("duchod_kod", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("zdrav_kod", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("obcan_kod", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("prukaz_obc", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("prukaz_pas", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("cizinec_rc", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("stat_narozeni_kod", DB_TEXT, 10, dbNullFieldOption);
CreateGDATE("reg_datum", DB_DATE, dbNotNullFieldOption);
CreateField("reg_logid", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("davka_id");
PKConstraint.AppendField("impRadek_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1IMP_01_PRAC", true);
TableIndex.AppendField("firma_id");
TableIndex.AppendField("davka_id");
TableIndex.AppendField("pnr");
}
public TableImp17PomerInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("davka_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("impRadek_id", DB_LONG);
CreateFTEXT("pnr", DB_TEXT, 12, dbNotNullFieldOption);
CreateField("zpracovano", DB_BYTE, dbNotNullFieldOption);
CreateField("cislo", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("pomer_nazev", DB_TEXT, 31, dbNullFieldOption);
CreateFTEXT("zacatek", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("konec", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("cinnost", DB_TEXT, 2, dbNullFieldOption);
CreateFTEXT("platce_danpr", DB_TEXT, 1, dbNullFieldOption);
CreateFTEXT("platce_spoj", DB_TEXT, 1, dbNullFieldOption);
CreateFTEXT("platce_zpoj", DB_TEXT, 1, dbNullFieldOption);
CreateFTEXT("min_zp", DB_TEXT, 1, dbNullFieldOption);
CreateFTEXT("neni_evid", DB_TEXT, 1, dbNullFieldOption);
CreateFTEXT("neni_dovol", DB_TEXT, 1, dbNullFieldOption);
CreateFTEXT("kzam", DB_TEXT, 5, dbNullFieldOption);
CreateFTEXT("praxe_roky", DB_TEXT, 2, dbNullFieldOption);
CreateFTEXT("praxe_dny", DB_TEXT, 3, dbNullFieldOption);
CreateFTEXT("tar_trida", DB_TEXT, 5, dbNullFieldOption);
CreateFTEXT("tar_stupen", DB_TEXT, 2, dbNullFieldOption);
CreateFTEXT("tar_stupen_auto", DB_TEXT, 1, dbNullFieldOption);
CreateFTEXT("tar_zvys_kod", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("druh_nastup_kod", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("druh_odchod_kod", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("druh_doba_kod", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("druh_pprav_kod", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("kvalifikace_kod", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("funkce", DB_TEXT, 50, dbNullFieldOption);
CreateFTEXT("dovol_nar_letos", DB_TEXT, 2, dbNullFieldOption);
CreateFTEXT("dovol_nar_dodat", DB_TEXT, 2, dbNullFieldOption);
CreateFTEXT("dovol_jina", DB_TEXT, 2, dbNullFieldOption);
CreateFTEXT("dovol_letos", DB_TEXT, 2, dbNullFieldOption);
CreateFTEXT("dovol_lonska", DB_TEXT, 2, dbNullFieldOption);
CreateFTEXT("dovol_cerpano", DB_TEXT, 2, dbNullFieldOption);
CreateFTEXT("dovol_proplac", DB_TEXT, 2, dbNullFieldOption);
CreateGDATE("reg_datum", DB_DATE, dbNotNullFieldOption);
CreateField("reg_logid", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("davka_id");
PKConstraint.AppendField("impRadek_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1IMP_17_POMER", true);
TableIndex.AppendField("firma_id");
TableIndex.AppendField("davka_id");
TableIndex.AppendField("pnr");
TableIndex.AppendField("cislo");
}
public string AlterXPKIndexSQL(IndexDefInfo indexInfo)
{
string strNames = indexInfo.CreateFieldsNameLnList();
string strSQL = ("ALTER TABLE ");
strSQL += indexInfo.m_strTable;
strSQL += (" ADD ");
strSQL += PlatformCreateContraintSQL(strNames, indexInfo.m_strName, indexInfo.m_bPrimary);
return(strSQL);
}
public TableStredCinzakInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("strcinzak_id", DB_LONG);
CreateFTEXT("nazev", DB_TEXT, 50, dbNotNullFieldOption);
CreateField("druh", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("ucetni_kod", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("stat_nuts", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("poznamka", DB_TEXT, 255, dbNullFieldOption);
CreateField("platnost_od", DB_DATE, dbNullFieldOption);
CreateField("platnost_do", DB_DATE, dbNullFieldOption);
CreateField("divize_id", DB_LONG, dbNullFieldOption);
CreateField("bezny_md", DB_LONG, dbNotNullFieldOption);
CreateField("bezny_dal", DB_LONG, dbNotNullFieldOption);
CreateField("druh_zar", DB_INTEGER, 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("strcinzak_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1STRED_CINZAK");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF2STRED_CINZAK");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("divize_id");
TableIndex = CreateIndex("XIF3STRED_CINZAK");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("bezny_md");
TableIndex = CreateIndex("XIF4STRED_CINZAK");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("bezny_dal");
TableIndex = CreateIndex("XIF5STRED_CINZAK");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("druh_zar");
TableIndex = CreateIndex("XIF1VYBSTRED_CINZAK");
TableIndex.AppendField("druh");
TableIndex.AppendField("nazev");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_str", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
TableRelation = CreateRelation("zariz_strcz", "UZIV_CISELNIK", "druh_zar_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("druh_zar", "uzc_kod");
}
public TableStredRozpocetInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("rozpocet_id", DB_LONG);
CreateField("strcinzak_id", DB_LONG, dbNotNullFieldOption);
CreateField("strcinzak_druh", DB_BYTE, dbNotNullFieldOption);
CreateField("rok", DB_INTEGER, dbNotNullFieldOption);
CreateField("datum", DB_DATE, dbNullFieldOption);
CreateField("druh", DB_BYTE, dbNotNullFieldOption);
CreateField("zmena_kod", DB_INTEGER, dbNotNullFieldOption);
CreateField("rozp_data1", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data2", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data3", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data4", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data5", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data6", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data7", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data8", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data9", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data10", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data11", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data12", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data13", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data14", DB_LONG, dbNotNullFieldOption);
CreateField("rozp_data15", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("poznamka", DB_TEXT, 255, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("rozpocet_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1STRED_ROZPOCET");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("strcinzak_id");
TableIndex = CreateIndex("XIF2STRED_ROZPOCET");
TableIndex.AppendField("firma_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("rok_rozpoc_firma", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
TableRelation = CreateRelation("rok_rozpoc_stred", "STRED_CINZAK", "strcinzak_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("strcinzak_id", "strcinzak_id");
}
public string CreateIndexSQL(IndexDefInfo indexInfo)
{
string strNames = indexInfo.CreateFieldsNameLnList();
string strSQL = ("CREATE INDEX ");
strSQL += indexInfo.m_strName;
strSQL += (" ON ");
strSQL += indexInfo.m_strTable;
strSQL += (" (");
strSQL += strNames;
strSQL += (")");
return(strSQL);
}
public TablePlatebniMediumInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("pmedium_id", DB_LONG);
CreateField("info_medium", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("nazev_klienta", DB_TEXT, 25, dbNullFieldOption);
CreateField("soubor_start", DB_INTEGER, dbNotNullFieldOption);
CreateField("soubor_stop", DB_INTEGER, dbNotNullFieldOption);
CreateField("soubor_next", DB_INTEGER, dbNotNullFieldOption);
CreateField("datum_predani", DB_INTEGER, dbNotNullFieldOption);
CreateField("pol_cis1", DB_BYTE, dbNotNullFieldOption);
CreateField("pol_cis2", DB_BYTE, dbNotNullFieldOption);
CreateField("pol_cis3", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("pol_txt1", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("pol_txt2", DB_TEXT, 15, dbNullFieldOption);
CreateFTEXT("pol_txt3", DB_TEXT, 15, 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);
CreateFTEXT("mena", DB_TEXT, 3, dbNullFieldOption);
CreateFTEXT("ustav", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("cislo_pobocky", DB_TEXT, 5, dbNullFieldOption);
CreateFTEXT("prideleny_kod", DB_TEXT, 10, dbNullFieldOption);
CreateField("banka_id", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("pmedium_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1PLATEBNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF2PLATEBNI_MEDIUM");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("banka_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_plm", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
}
public TableAdresaInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("adresa_id", DB_LONG);
CreateField("stat_kod", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("obec", DB_TEXT, 48, dbNotNullFieldOption);
CreateFTEXT("cast_obce", DB_TEXT, 48, dbNullFieldOption);
CreateField("cisdom_typ", DB_BYTE, dbNotNullFieldOption);
CreateField("cisdom_hod", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("ulice", DB_TEXT, 48, dbNullFieldOption);
CreateField("cisor_hod", DB_INTEGER, dbNotNullFieldOption);
CreateFTEXT("cisor_pis", DB_TEXT, 1, dbNullFieldOption);
CreateFTEXT("psc", DB_TEXT, 11, dbNullFieldOption);
CreateFTEXT("nazev_posty", DB_TEXT, 40, dbNullFieldOption);
CreateField("trv_adr_prac", DB_BOOLEAN, dbNotNullFieldOption);
CreateField("org_id", DB_LONG, dbNullFieldOption);
CreateField("pracovnik_id", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("adresa_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1ADRESA");
TableIndex.AppendField("firma_id");
TableIndex = CreateIndex("XIF2ADRESA");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("org_id");
TableIndex = CreateIndex("XIF3ADRESA");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("pracovnik_id");
TableIndex = CreateIndex("XIF4ADRESA");
TableIndex.AppendField("firma_id");
TableIndex.AppendField("stat_kod");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_adr", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
TableRelation = CreateRelation("uzivc_adr_stat", "UZIV_CISELNIK", "stat_id");
TableRelation.AppendForeignField("firma_id", "firma_id");
TableRelation.AppendForeignField("stat_kod", "uzc_kod");
}
public TableUzivatelInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("uuzivatel_id", DB_LONG);
CreateFTEXT("uzivjmeno", DB_TEXT, 20, dbNotNullFieldOption);
CreateField("uzivfunkce", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("uzivemail", DB_TEXT, 255, dbNullFieldOption);
CreateField("uzivsidlo", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("heslo", DB_TEXT, 80, dbNotNullFieldOption);
CreateFTEXT("uplne_jmeno", DB_TEXT, 40, dbNullFieldOption);
CreateField("jazyk", DB_BYTE, dbNotNullFieldOption);
CreateFTEXT("telefon", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("tel_linka", DB_TEXT, 5, dbNullFieldOption);
CreateField("sestavy_id", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("poznamka", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("uzivcerts", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("uzivcertp", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("uzivpdfpw", DB_TEXT, 255, dbNullFieldOption);
CreateField("uziv_param_info", DB_LONG, dbNotNullFieldOption);
CreateField("uzivfunkce_omez", DB_LONG, dbNotNullFieldOption);
CreateField("uzivfunkce_edit", DB_LONG, dbNotNullFieldOption);
CreateField("uzivfuncfg_omez", DB_LONG, dbNotNullFieldOption);
CreateField("uzivfuncfg_edit", DB_LONG, dbNotNullFieldOption);
CreateField("uzivfunkce_new", DB_LONG, dbNotNullFieldOption);
CreateField("uzivfunkce_del", DB_LONG, dbNotNullFieldOption);
CreateField("uzivfuncfg_new", DB_LONG, dbNotNullFieldOption);
CreateField("uzivfuncfg_del", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("prijmeni", DB_TEXT, 255, dbNullFieldOption);
CreateFTEXT("pjmeno", DB_TEXT, 255, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("uuzivatel_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1UZIVATEL");
TableIndex.AppendField("firma_id");
RelationDefInfo TableRelation = null;
TableRelation = CreateRelation("fid_uziv", "FIRMA", "firma_id");
TableRelation.AppendForeignField("firma_id", "ffirma_id");
}
public TableImp20NepritInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("davka_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("impRadek_id", DB_LONG);
CreateFTEXT("pnr", DB_TEXT, 12, dbNotNullFieldOption);
CreateField("zpracovano", DB_BYTE, dbNotNullFieldOption);
CreateField("cislo", DB_LONG, dbNotNullFieldOption);
CreateField("id", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("pomer_nazev", DB_TEXT, 31, dbNullFieldOption);
CreateFTEXT("kod", DB_TEXT, 4, dbNullFieldOption);
CreateFTEXT("kod_text", DB_TEXT, 6, dbNullFieldOption);
CreateFTEXT("plati_od", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("plati_do", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("min_prvniden", DB_TEXT, 4, dbNullFieldOption);
CreateFTEXT("min_posledniden", DB_TEXT, 4, dbNullFieldOption);
CreateFTEXT("sazba_kc", DB_TEXT, 12, dbNullFieldOption);
CreateFTEXT("sazba_proc", DB_TEXT, 5, dbNullFieldOption);
CreateFTEXT("zap_vyd", DB_TEXT, 12, dbNullFieldOption);
CreateFTEXT("doklad", DB_TEXT, 10, dbNullFieldOption);
CreateFTEXT("platit", DB_TEXT, 1, dbNullFieldOption);
CreateFTEXT("str_nazev", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("cin_nazev", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("zak_nazev", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("trvale", DB_TEXT, 2, dbNullFieldOption);
CreateGDATE("reg_datum", DB_DATE, dbNotNullFieldOption);
CreateField("reg_logid", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("davka_id");
PKConstraint.AppendField("impRadek_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1IMP_20_NEPRIT", true);
TableIndex.AppendField("firma_id");
TableIndex.AppendField("davka_id");
TableIndex.AppendField("pnr");
TableIndex.AppendField("cislo");
TableIndex.AppendField("id");
}
public TableImp19MzdaInfo(string lpszOwnerName, string lpszUsersName) :
base(lpszOwnerName, lpszUsersName, TABLE_NAME)
{
CreateField("firma_id", DB_LONG, dbNotNullFieldOption);
CreateField("davka_id", DB_LONG, dbNotNullFieldOption);
CreateFAUTO("impRadek_id", DB_LONG);
CreateFTEXT("pnr", DB_TEXT, 12, dbNotNullFieldOption);
CreateField("zpracovano", DB_BYTE, dbNotNullFieldOption);
CreateField("cislo", DB_LONG, dbNotNullFieldOption);
CreateField("id", DB_LONG, dbNotNullFieldOption);
CreateFTEXT("pomer_nazev", DB_TEXT, 31, dbNullFieldOption);
CreateFTEXT("kod", DB_TEXT, 4, dbNullFieldOption);
CreateFTEXT("kod_text", DB_TEXT, 6, dbNullFieldOption);
CreateFTEXT("minuty", DB_TEXT, 4, dbNullFieldOption);
CreateFTEXT("minuty_norm", DB_TEXT, 4, dbNullFieldOption);
CreateFTEXT("jednotky", DB_TEXT, 12, dbNullFieldOption);
CreateFTEXT("sazba_kc", DB_TEXT, 12, dbNullFieldOption);
CreateFTEXT("sazba_proc", DB_TEXT, 5, dbNullFieldOption);
CreateFTEXT("str_nazev", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("cin_nazev", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("zak_nazev", DB_TEXT, 20, dbNullFieldOption);
CreateFTEXT("trvale", DB_TEXT, 2, dbNullFieldOption);
CreateFTEXT("tar_trida", DB_TEXT, 5, dbNullFieldOption);
CreateFTEXT("tar_stupen", DB_TEXT, 2, dbNullFieldOption);
CreateFTEXT("tar_stupen_auto", DB_TEXT, 1, dbNullFieldOption);
CreateGDATE("reg_datum", DB_DATE, dbNotNullFieldOption);
CreateField("reg_logid", DB_LONG, dbNullFieldOption);
IndexDefInfo PKConstraint = CreatePKConstraint("XPK");
PKConstraint.AppendField("firma_id");
PKConstraint.AppendField("davka_id");
PKConstraint.AppendField("impRadek_id");
IndexDefInfo TableIndex = null;
TableIndex = CreateIndex("XIF1IMP_19_MZDA", true);
TableIndex.AppendField("firma_id");
TableIndex.AppendField("davka_id");
TableIndex.AppendField("pnr");
TableIndex.AppendField("cislo");
TableIndex.AppendField("id");
}
