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 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 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 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"); }
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"); }
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 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 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 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 TableSestavyUlstInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME) { CreateField("firma_id", DB_LONG, dbNotNullFieldOption); CreateField("uzivatel_id", DB_LONG, dbNotNullFieldOption); CreateField("kod_lst", DB_INTEGER, dbNotNullFieldOption); CreateField("tisknout", DB_LONG, dbNotNullFieldOption); CreateField("papir", DB_BYTE, dbNotNullFieldOption); CreateField("tridit", DB_BYTE, dbNotNullFieldOption); CreateField("pg_margins", DB_LONG, dbNotNullFieldOption); CreateField("sestavy_id", DB_LONG, dbNotNullFieldOption); CreateFTEXT("exp_cesta", DB_TEXT, 255, dbNullFieldOption); CreateFTEXT("lst_param", DB_TEXT, 255, dbNullFieldOption); CreateFTEXT("txt_param", DB_TEXT, 255, dbNullFieldOption); CreateFTEXT("msg_param", DB_TEXT, 255, dbNullFieldOption); CreateField("filtr_zobr", DB_BYTE, dbNotNullFieldOption); IndexDefInfo PKConstraint = CreatePKConstraint("XPK"); PKConstraint.AppendField("firma_id"); PKConstraint.AppendField("uzivatel_id"); PKConstraint.AppendField("kod_lst"); IndexDefInfo TableIndex = null; TableIndex = CreateIndex("XIF1SESTAVY_ULST"); TableIndex.AppendField("firma_id"); TableIndex.AppendField("uzivatel_id"); TableIndex = CreateIndex("XIF2SESTAVY_ULST"); TableIndex.AppendField("firma_id"); TableIndex.AppendField("kod_lst"); RelationDefInfo TableRelation = null; TableRelation = CreateRelation("uziv_ulst", "UZIVATEL", "uzivatel_id"); TableRelation.AppendForeignField("firma_id", "firma_id"); TableRelation.AppendForeignField("uzivatel_id", "uuzivatel_id"); TableRelation = CreateRelation("slst_ulst", "SESTAVY_LST", "sestavy_lst_id"); TableRelation.AppendForeignField("firma_id", "firma_id"); TableRelation.AppendForeignField("kod_lst", "kod_lst"); }
public TableFiltrUmediaInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME) { CreateField("firma_id", DB_LONG, dbNotNullFieldOption); CreateField("umedium_id", DB_LONG, dbNotNullFieldOption); CreateFAUTO("filtr_id", DB_LONG); CreateFTEXT("ukontace_typ", DB_TEXT, 25, dbNotNullFieldOption); CreateFTEXT("mad_ucet_skup", DB_TEXT, 3, dbNullFieldOption); CreateFTEXT("mad_ucet_synt", DB_TEXT, 6, dbNullFieldOption); CreateFTEXT("mad_ucet_anal", DB_TEXT, 15, dbNullFieldOption); CreateFTEXT("dal_ucet_skup", DB_TEXT, 3, dbNullFieldOption); CreateFTEXT("dal_ucet_synt", DB_TEXT, 6, dbNullFieldOption); CreateFTEXT("dal_ucet_anal", DB_TEXT, 15, 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); IndexDefInfo PKConstraint = CreatePKConstraint("XPK"); PKConstraint.AppendField("firma_id"); PKConstraint.AppendField("umedium_id"); PKConstraint.AppendField("filtr_id"); IndexDefInfo TableIndex = null; TableIndex = CreateIndex("XIF1FILTR_UMEDIA"); TableIndex.AppendField("firma_id"); TableIndex.AppendField("umedium_id"); RelationDefInfo TableRelation = null; TableRelation = CreateRelation("umedium_filtr", "UCETNI_MEDIUM", "umedium_id"); TableRelation.AppendForeignField("firma_id", "firma_id"); TableRelation.AppendForeignField("umedium_id", "umedium_id"); }
public TableFiltrMediaInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME) { CreateField("firma_id", DB_LONG, dbNotNullFieldOption); CreateField("smedium_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); CreateField("sloz_pkod", DB_LONG, dbNotNullFieldOption); CreateFTEXT("sloz_ukod", DB_TEXT, 10, dbNullFieldOption); CreateField("filtr_utvar", DB_LONG, dbNotNullFieldOption); CreateField("filtr_divize", DB_LONG, dbNotNullFieldOption); CreateField("filtr_str", DB_LONG, dbNotNullFieldOption); CreateField("filtr_cin", DB_LONG, dbNotNullFieldOption); CreateField("filtr_zak", DB_LONG, dbNotNullFieldOption); CreateField("filtr_zdr", DB_LONG, dbNotNullFieldOption); IndexDefInfo PKConstraint = CreatePKConstraint("XPK"); PKConstraint.AppendField("firma_id"); PKConstraint.AppendField("smedium_id"); PKConstraint.AppendField("filtr_id"); IndexDefInfo TableIndex = null; TableIndex = CreateIndex("XIF1FILTR_MEDIA"); TableIndex.AppendField("firma_id"); TableIndex.AppendField("smedium_id"); RelationDefInfo TableRelation = null; TableRelation = CreateRelation("sid_fil", "SBERNE_MEDIUM", "smedium_id"); TableRelation.AppendForeignField("firma_id", "firma_id"); TableRelation.AppendForeignField("smedium_id", "smedium_id"); }
public TableOrganizaceInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME) { CreateField("firma_id", DB_LONG, dbNotNullFieldOption); CreateFAUTO("org_id", DB_LONG); CreateFTEXT("nazev", DB_TEXT, 255, dbNotNullFieldOption); CreateField("druh", DB_BYTE, dbNotNullFieldOption); CreateField("info_org", DB_LONG, dbNotNullFieldOption); CreateFTEXT("ucetni_kod", DB_TEXT, 20, dbNullFieldOption); CreateFTEXT("misto", DB_TEXT, 48, dbNullFieldOption); CreateFTEXT("ico_kod", DB_TEXT, 35, dbNullFieldOption); CreateFTEXT("dic", DB_TEXT, 35, dbNullFieldOption); CreateFTEXT("zkratka", DB_TEXT, 10, dbNullFieldOption); CreateField("okres_kod", DB_INTEGER, dbNullFieldOption); CreateField("stat_kod", DB_INTEGER, dbNotNullFieldOption); IndexDefInfo PKConstraint = CreatePKConstraint("XPK"); PKConstraint.AppendField("firma_id"); PKConstraint.AppendField("org_id"); IndexDefInfo TableIndex = null; TableIndex = CreateIndex("XIF1ORGANIZACE"); TableIndex.AppendField("firma_id"); TableIndex = CreateIndex("XIF2ORGANIZACE"); TableIndex.AppendField("firma_id"); TableIndex.AppendField("stat_kod"); TableIndex = CreateIndex("XIF3ORGANIZACE"); TableIndex.AppendField("firma_id"); TableIndex.AppendField("okres_kod"); RelationDefInfo TableRelation = null; TableRelation = CreateRelation("fid_org", "FIRMA", "firma_id"); TableRelation.AppendForeignField("firma_id", "ffirma_id"); TableRelation = CreateRelation("uzivc_org_stat", "UZIV_CISELNIK", "stat_id"); TableRelation.AppendForeignField("firma_id", "firma_id"); TableRelation.AppendForeignField("stat_kod", "uzc_kod"); }
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"); }
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 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 TableImpPnrInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME) { CreateField("firma_id", DB_LONG, dbNotNullFieldOption); CreateFTEXT("pnr", DB_TEXT, 12, dbNotNullFieldOption); CreateFTEXT("pnr_ok", DB_TEXT, 12, dbNotNullFieldOption); CreateGDATE("reg_datum", DB_DATE, dbNotNullFieldOption); CreateField("reg_logid", DB_LONG, dbNullFieldOption); IndexDefInfo PKConstraint = CreatePKConstraint("XPK"); PKConstraint.AppendField("firma_id"); PKConstraint.AppendField("pnr"); RelationDefInfo TableRelation = null; TableRelation = CreateRelation("fir_imppnr", "FIRMA", "firma_id"); TableRelation.AppendForeignField("firma_id", "ffirma_id"); }
public TableImpDavkaInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME) { CreateField("firma_id", DB_LONG, dbNotNullFieldOption); CreateFAUTO("davka_id", DB_LONG); CreateFTEXT("nazev", DB_TEXT, 50, dbNullFieldOption); CreateField("zpracovano", DB_BYTE, dbNotNullFieldOption); CreateField("saphr", DB_BYTE, dbNotNullFieldOption); CreateGDATE("reg_datum", DB_DATE, dbNotNullFieldOption); CreateField("reg_logid", DB_LONG, dbNullFieldOption); IndexDefInfo PKConstraint = CreatePKConstraint("XPK"); PKConstraint.AppendField("firma_id"); PKConstraint.AppendField("davka_id"); RelationDefInfo TableRelation = null; TableRelation = CreateRelation("fir_impdavka", "FIRMA", "firma_id"); TableRelation.AppendForeignField("firma_id", "ffirma_id"); }
public TableBankSpojInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME) { CreateField("firma_id", DB_LONG, dbNotNullFieldOption); CreateFAUTO("bspoj_id", DB_LONG); CreateFTEXT("ucet", DB_TEXT, 18, dbNullFieldOption); CreateFTEXT("ustav", DB_TEXT, 4, dbNullFieldOption); CreateFTEXT("konsymb", DB_TEXT, 10, dbNullFieldOption); CreateFTEXT("varsymb", DB_TEXT, 10, dbNullFieldOption); CreateFTEXT("specsymb", DB_TEXT, 10, dbNullFieldOption); CreateField("org_id", DB_LONG, dbNullFieldOption); CreateField("banka_id", DB_LONG, dbNullFieldOption); CreateField("pracovnik_id", DB_LONG, dbNullFieldOption); CreateFTEXT("iban", DB_TEXT, 40, dbNullFieldOption); CreateField("bspoj_info", DB_INTEGER, dbNotNullFieldOption); IndexDefInfo PKConstraint = CreatePKConstraint("XPK"); PKConstraint.AppendField("firma_id"); PKConstraint.AppendField("bspoj_id"); IndexDefInfo TableIndex = null; TableIndex = CreateIndex("XIF1BANK_SPOJ"); TableIndex.AppendField("firma_id"); TableIndex = CreateIndex("XIF2BANK_SPOJ"); TableIndex.AppendField("firma_id"); TableIndex.AppendField("org_id"); TableIndex = CreateIndex("XIF3BANK_SPOJ"); TableIndex.AppendField("firma_id"); TableIndex.AppendField("pracovnik_id"); TableIndex = CreateIndex("XIF4BANK_SPOJ"); TableIndex.AppendField("firma_id"); TableIndex.AppendField("banka_id"); RelationDefInfo TableRelation = null; TableRelation = CreateRelation("fid_bspoj", "FIRMA", "firma_id"); TableRelation.AppendForeignField("firma_id", "ffirma_id"); }
public TableSvatekInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME) { CreateField("firma_id", DB_LONG, dbNotNullFieldOption); CreateField("datum", DB_DATE, dbNotNullFieldOption); CreateField("velikonoce", DB_BYTE, dbNotNullFieldOption); IndexDefInfo PKConstraint = CreatePKConstraint("XPK"); PKConstraint.AppendField("firma_id"); PKConstraint.AppendField("datum"); IndexDefInfo TableIndex = null; TableIndex = CreateIndex("XIF1SVATEK"); TableIndex.AppendField("firma_id"); RelationDefInfo TableRelation = null; TableRelation = CreateRelation("fid_svat", "FIRMA", "firma_id"); TableRelation.AppendForeignField("firma_id", "ffirma_id"); }
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 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 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 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"); }