예제 #1
0
        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");
        }
예제 #2
0
        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");
        }
예제 #3
0
        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");
        }
예제 #4
0
        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());
                }
            }
        }
예제 #5
0
        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");
        }
예제 #6
0
        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);
        }
예제 #7
0
        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");
        }
예제 #8
0
        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");
        }
예제 #9
0
        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");
        }
예제 #10
0
        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");
        }
예제 #11
0
        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");
        }
예제 #12
0
        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");
        }
예제 #13
0
        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");
        }
예제 #14
0
        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");
        }
예제 #15
0
        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");
        }
예제 #16
0
        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");
        }
예제 #17
0
        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");
        }
예제 #18
0
        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");
        }
예제 #19
0
        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");
        }
예제 #20
0
        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");
        }
예제 #21
0
        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");
        }
예제 #22
0
        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);
        }
예제 #23
0
        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");
        }
예제 #24
0
        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");
        }
예제 #25
0
        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);
        }
예제 #26
0
        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");
        }
예제 #27
0
        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");
        }
예제 #28
0
        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");
        }
예제 #29
0
        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");
        }
예제 #30
0
        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");
        }