-- MySQL dump 10.13 Distrib 5.1.46, for Win32 (ia32) -- -- Host: localhost Database: asteroid -- ------------------------------------------------------ -- Server version 5.1.46-community /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `bonuri_martor` -- DROP TABLE IF EXISTS `bonuri_martor`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bonuri_martor` ( `NR` int(11) NOT NULL AUTO_INCREMENT, `Data` date NOT NULL DEFAULT '0000-00-00', `Total` double NOT NULL DEFAULT '0', `OBS` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`NR`), KEY `Data` (`Data`) ) ENGINE=InnoDB AUTO_INCREMENT=80260 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `bonuri_pt_facturi` -- DROP TABLE IF EXISTS `bonuri_pt_facturi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bonuri_pt_facturi` ( `BonCorespunzatorFacturaID` int(11) NOT NULL AUTO_INCREMENT, `BonMartorID` int(11) DEFAULT NULL, `FacturaID` int(11) DEFAULT NULL, PRIMARY KEY (`BonCorespunzatorFacturaID`), KEY `BonMartorID` (`BonMartorID`) USING BTREE, KEY `FacturaID` (`FacturaID`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1048 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `categorii_reg_casa` -- DROP TABLE IF EXISTS `categorii_reg_casa`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `categorii_reg_casa` ( `RCCategoryID` int(11) NOT NULL AUTO_INCREMENT, `Descriere` varchar(255) NOT NULL, PRIMARY KEY (`RCCategoryID`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `chitante` -- DROP TABLE IF EXISTS `chitante`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chitante` ( `ChitantaID` int(11) NOT NULL AUTO_INCREMENT, `ChitantaNo` int(11) NOT NULL, `FirmaID` int(11) DEFAULT NULL, `Data` datetime NOT NULL, `Explicatie` varchar(255) NOT NULL, `Suma` double NOT NULL, PRIMARY KEY (`ChitantaID`), UNIQUE KEY `ChitantaNo` (`ChitantaNo`), KEY `IDX_Data` (`Data`), KEY `IDX_Firma` (`FirmaID`) ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `corectii` -- DROP TABLE IF EXISTS `corectii`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `corectii` ( `CorectieID` int(11) NOT NULL AUTO_INCREMENT, `DataEfectuarii` date DEFAULT NULL, `DataCorectiei` date DEFAULT NULL, `FacturaID` int(11) DEFAULT NULL, `Total` double NOT NULL, PRIMARY KEY (`CorectieID`) ) ENGINE=InnoDB AUTO_INCREMENT=2150 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `corectii_entries` -- DROP TABLE IF EXISTS `corectii_entries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `corectii_entries` ( `CorectieEntryID` int(11) NOT NULL AUTO_INCREMENT, `CorectieID` int(11) NOT NULL DEFAULT '0', `TipPozitie` tinyint(4) NOT NULL DEFAULT '0', `ProdusID` int(11) NOT NULL DEFAULT '0', `Cant` double NOT NULL DEFAULT '0', PRIMARY KEY (`CorectieEntryID`), KEY `CorectieID` (`CorectieID`), KEY `ProdusID` (`ProdusID`) ) ENGINE=InnoDB AUTO_INCREMENT=7881 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `facturi` -- DROP TABLE IF EXISTS `facturi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `facturi` ( `FacturaID` int(11) NOT NULL AUTO_INCREMENT, `FacturaNo` int(11) NOT NULL, `Data` datetime NOT NULL, `ClientID` int(11) DEFAULT NULL, `NumeDelegat` varchar(255) NOT NULL, `SerieCiDelegat` varchar(255) NOT NULL, `MijlocTransportDelegat` varchar(255) NOT NULL, `Total` double NOT NULL, PRIMARY KEY (`FacturaID`), KEY `Data` (`Data`) USING BTREE, KEY `ClientID` (`ClientID`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1466 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `facturi_items` -- DROP TABLE IF EXISTS `facturi_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `facturi_items` ( `FacturaItemID` int(11) NOT NULL AUTO_INCREMENT, `FacturaID` int(11) DEFAULT NULL, `NrCrt` int(11) NOT NULL, `ProdusID` int(11) DEFAULT NULL, `Qty` double DEFAULT NULL, PRIMARY KEY (`FacturaItemID`), KEY `FacturaID` (`FacturaID`) USING BTREE, KEY `ProdusID` (`ProdusID`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4101 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `firme` -- DROP TABLE IF EXISTS `firme`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `firme` ( `FirmaID` int(11) NOT NULL AUTO_INCREMENT, `Nume` varchar(100) NOT NULL DEFAULT '', `J` varchar(50) NOT NULL DEFAULT '', `R` varchar(50) NOT NULL DEFAULT '', `Adresa` varchar(100) NOT NULL DEFAULT '', `Telefon1` varchar(100) NOT NULL DEFAULT '', `Telefon2` varchar(100) NOT NULL DEFAULT '', `Fax` varchar(100) NOT NULL DEFAULT '', `Email` varchar(100) NOT NULL DEFAULT '', `Cont` varchar(50) NOT NULL DEFAULT '', `Banca` varchar(50) NOT NULL DEFAULT '', `DelegatID` int(11) DEFAULT NULL, PRIMARY KEY (`FirmaID`), KEY `DelegatID` (`DelegatID`), KEY `Nume` (`Nume`) ) ENGINE=InnoDB AUTO_INCREMENT=454 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `furnizori_nrcd` -- DROP TABLE IF EXISTS `furnizori_nrcd`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `furnizori_nrcd` ( `FurnizorNrcdID` int(11) NOT NULL AUTO_INCREMENT, `NrcdID` int(11) NOT NULL DEFAULT '0', `FirmaID` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`FurnizorNrcdID`), KEY `NrcdID` (`NrcdID`), KEY `FirmaID` (`FirmaID`) ) ENGINE=InnoDB AUTO_INCREMENT=1361 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `modificari_pret_bonuri` -- DROP TABLE IF EXISTS `modificari_pret_bonuri`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `modificari_pret_bonuri` ( `ModificarePretBonID` int(11) NOT NULL AUTO_INCREMENT, `BonMartorEntryID` int(11) DEFAULT NULL, `PretModificat` double DEFAULT NULL, `Raportata` tinyint(4) DEFAULT NULL, PRIMARY KEY (`ModificarePretBonID`), KEY `BonMartorEntryID` (`BonMartorEntryID`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `modificari_pret_facturi` -- DROP TABLE IF EXISTS `modificari_pret_facturi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `modificari_pret_facturi` ( `ModificarePretFacturaID` int(11) NOT NULL AUTO_INCREMENT, `FacturaItemID` int(11) DEFAULT NULL, `PretModificat` double DEFAULT NULL, `Raportata` tinyint(4) DEFAULT NULL, PRIMARY KEY (`ModificarePretFacturaID`), KEY `FacturaItemID` (`FacturaItemID`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `nrcd` -- DROP TABLE IF EXISTS `nrcd`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `nrcd` ( `NR` int(11) NOT NULL AUTO_INCREMENT, `CodFurnizor` varchar(100) NOT NULL DEFAULT '', `NrFactAviz` varchar(100) NOT NULL DEFAULT '', `DataExpedierii` date NOT NULL DEFAULT '0000-00-00', `DataReceptiei` date NOT NULL DEFAULT '0000-00-00', `Furnizor` varchar(100) NOT NULL DEFAULT '', `OrasFurnizor` varchar(100) NOT NULL DEFAULT '', `VehiculNr` varchar(100) NOT NULL DEFAULT '', `Documente` varchar(200) NOT NULL DEFAULT '', `Constatari` varchar(200) NOT NULL DEFAULT '', PRIMARY KEY (`NR`), KEY `DataReceptiei` (`DataReceptiei`) ) ENGINE=InnoDB AUTO_INCREMENT=1785 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `nrcd_items` -- DROP TABLE IF EXISTS `nrcd_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `nrcd_items` ( `NrcdItemID` int(11) NOT NULL AUTO_INCREMENT, `NrcdID` int(11) NOT NULL, `NrCrt` int(11) NOT NULL, `ProdusID` int(11) NOT NULL, `Qty` double NOT NULL, `PretIntrare` double NOT NULL, PRIMARY KEY (`NrcdItemID`), KEY `IDX_NrCrt` (`NrCrt`) ) ENGINE=InnoDB AUTO_INCREMENT=8214 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `nrcduri` -- DROP TABLE IF EXISTS `nrcduri`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `nrcduri` ( `NrcdID` int(11) NOT NULL AUTO_INCREMENT, `NrcdNo` int(11) NOT NULL, `FurnizorID` int(11) NOT NULL, `NrFactAviz` varchar(255) NOT NULL, `DataExpedierii` datetime NOT NULL, `DataReceptiei` datetime NOT NULL, `VehiculNr` varchar(255) NOT NULL, `DocumenteInsotitoare` varchar(255) NOT NULL, `Constatari` varchar(255) NOT NULL, `ValoareMarfa` double NOT NULL, PRIMARY KEY (`NrcdID`), KEY `IDX_Furnizor` (`FurnizorID`), KEY `IDX_NrcdNo` (`NrcdNo`), KEY `IDX_DataReceptiei` (`DataReceptiei`) ) ENGINE=InnoDB AUTO_INCREMENT=3079 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `operatiuni` -- DROP TABLE IF EXISTS `operatiuni`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `operatiuni` ( `NR` int(10) unsigned NOT NULL AUTO_INCREMENT, `ID` int(10) unsigned NOT NULL DEFAULT '0', `Data` date NOT NULL DEFAULT '0000-00-00', `TipAct` char(10) NOT NULL DEFAULT '', `Descriere` char(100) NOT NULL DEFAULT '', `Intrare` double NOT NULL DEFAULT '0', `Iesire` double NOT NULL DEFAULT '0', PRIMARY KEY (`NR`), KEY `ID` (`ID`), KEY `Data` (`Data`), KEY `Descriere` (`Descriere`) ) ENGINE=MyISAM AUTO_INCREMENT=141394 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `operatiuni_martor` -- DROP TABLE IF EXISTS `operatiuni_martor`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `operatiuni_martor` ( `NR` int(11) NOT NULL AUTO_INCREMENT, `ID` int(11) NOT NULL DEFAULT '0', `Bon` int(11) NOT NULL DEFAULT '0', `Cant` double NOT NULL DEFAULT '0', `tiparita` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`NR`), KEY `ID` (`ID`), KEY `Bon` (`Bon`) ) ENGINE=InnoDB AUTO_INCREMENT=149586 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `persoane` -- DROP TABLE IF EXISTS `persoane`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `persoane` ( `PersoanaID` int(11) NOT NULL AUTO_INCREMENT, `FirmaID` int(11) NOT NULL DEFAULT '0', `Nume` varchar(50) NOT NULL DEFAULT '', `Prenume` varchar(50) NOT NULL DEFAULT '', `SerieCI` varchar(20) NOT NULL DEFAULT '', `Politia` varchar(50) NOT NULL DEFAULT '', `Telefon1` varchar(50) NOT NULL DEFAULT '', `Telefon2` varchar(50) NOT NULL DEFAULT '', `Email` varchar(100) NOT NULL DEFAULT '', `Adresa` varchar(200) NOT NULL DEFAULT '', `Masina` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`PersoanaID`), KEY `FirmaID` (`FirmaID`), KEY `Nume` (`Nume`) ) ENGINE=InnoDB AUTO_INCREMENT=262 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `prescurtari_denumiri` -- DROP TABLE IF EXISTS `prescurtari_denumiri`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `prescurtari_denumiri` ( `ProdusID` int(11) NOT NULL DEFAULT '0', `Prescurtare` varchar(200) NOT NULL DEFAULT '', KEY `ProdusID` (`ProdusID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `preturi_furnizori` -- DROP TABLE IF EXISTS `preturi_furnizori`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `preturi_furnizori` ( `NRP` int(11) NOT NULL AUTO_INCREMENT, `ID` int(11) NOT NULL DEFAULT '0', `Pret` double NOT NULL DEFAULT '0', `NRCD` int(11) NOT NULL DEFAULT '0', `PozNRCD` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`NRP`), KEY `ID` (`ID`), KEY `NRCD` (`NRCD`) ) ENGINE=InnoDB AUTO_INCREMENT=3692 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `produse` -- DROP TABLE IF EXISTS `produse`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `produse` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Nume` char(100) NOT NULL DEFAULT '', `UM` char(20) NOT NULL DEFAULT '', `Pret` double NOT NULL DEFAULT '0', `Cant` double NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=2272 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `produse_verificate` -- DROP TABLE IF EXISTS `produse_verificate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `produse_verificate` ( `NrProd` int(11) NOT NULL AUTO_INCREMENT, `IDProd` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`NrProd`), KEY `IDProd` (`IDProd`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `registru_casa` -- DROP TABLE IF EXISTS `registru_casa`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `registru_casa` ( `RCEntryID` int(11) NOT NULL AUTO_INCREMENT, `RCCategoryID` int(11) NOT NULL, `FirmaID` int(11) DEFAULT NULL, `Data` date NOT NULL, `Descriere` varchar(255) NOT NULL, `NrDocument` varchar(255) NOT NULL, `Intrare` double NOT NULL, `Iesire` double NOT NULL, PRIMARY KEY (`RCEntryID`), KEY `idx_RCData` (`Data`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1911 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `stocuri` -- DROP TABLE IF EXISTS `stocuri`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `stocuri` ( `StocProdusID` int(11) NOT NULL AUTO_INCREMENT, `ProdusID` int(11) NOT NULL, `Data` datetime NOT NULL, `Stoc` double NOT NULL, PRIMARY KEY (`StocProdusID`), KEY `ProdusID` (`ProdusID`) USING BTREE, KEY `Data` (`Data`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=53378176 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `tmp` -- DROP TABLE IF EXISTS `tmp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tmp` ( `cnt` bigint(21) NOT NULL DEFAULT '0', `id` int(10) unsigned NOT NULL DEFAULT '0', `nume` char(100) CHARACTER SET latin1 NOT NULL DEFAULT '', `total_in` double DEFAULT NULL, `total_out` double DEFAULT NULL, `my_total` double DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2010-07-04 18:42:01