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); }