-- MySQL dump 10.10
--
-- Host: localhost    Database: app
-- ------------------------------------------------------
-- Server version	5.0.22-community-nt

/*!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 `clienti`
--

DROP TABLE IF EXISTS `clienti`;
CREATE TABLE `clienti` (
  `id` int(10) unsigned NOT NULL auto_increment COMMENT 'Cheia surogat',
  `tip` tinyint(3) unsigned NOT NULL default '2' COMMENT 'Tip: 0 -> pers fizica, 1 -> pers juridica',
  `denumire` varchar(240) collate utf8_romanian_ci NOT NULL default '' COMMENT 'Denumire client',
  `upd_time` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Timpul ultimului update',
  `upd_user` int(10) unsigned NOT NULL default '0' COMMENT 'Userul care a facut ultimul update',
  `obs` text collate utf8_romanian_ci COMMENT 'Observatii',
  `adresa` text collate utf8_romanian_ci NOT NULL COMMENT 'Adresa principala / sediu',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci COMMENT='Tabela clienti';

--
-- Dumping data for table `clienti`
--


/*!40000 ALTER TABLE `clienti` DISABLE KEYS */;
LOCK TABLES `clienti` WRITE;
INSERT INTO `clienti` VALUES (2,0,'Bogdan','2006-07-07 12:57:05',1,'eu','str Varful cu Dor'),(3,1,'Exito srl','2006-07-07 12:58:48',1,'eu','str Varful cu Dor'),(5,1,'Blabla srl','2006-07-07 13:14:15',1,'firma de renume','str Mamaia'),(6,0,'Enache Bogdan','2006-07-11 08:19:04',0,'Fibra optica 100 GBPS','1 Decembrie 1918'),(7,0,'Enache Bogdanel','2006-07-11 08:31:58',0,'Fibra optica 100 GBPS','1 Decembrie 1918'),(8,0,'gheorghe gh v','2006-07-11 12:18:31',1,'jdosa\r\nsf\r\nsaf\r\nsa','sfskaj'),(9,0,'Dana d','2006-07-12 06:28:32',1,'assa\r\nasdsa\r\nsa\r\ndsa','Constanţa\r\nbdul 1 Decembrie 1918'),(10,0,'Dana x','2006-07-12 06:37:39',1,'assa\r\nasdsa\r\nsa\r\ndsa','Constanţa\r\nbdul 1 Decembrie 1918'),(11,1,'jsandak SRl','2006-07-12 09:37:49',1,'kdwl\r\nf\r\nf\r\nsadf','wf;la\r\nf\r\nf\r\n\r\nfs'),(12,0,'fklas klsaflak','2006-07-12 11:22:19',1,'jklajflkwa','klwajlfkwql'),(16,0,'fklas klsaflak','2006-07-12 11:25:50',1,'jklajflkwa','klwajlfkwql'),(17,0,'fklas klsaflak','2006-07-12 11:26:53',1,'jklajflkwa','klwajlfkwql');
UNLOCK TABLES;
/*!40000 ALTER TABLE `clienti` ENABLE KEYS */;


--
-- Table structure for table `persfiz`
--

DROP TABLE IF EXISTS `persfiz`;
CREATE TABLE `persfiz` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `cl_id` int(10) unsigned NOT NULL default '0',
  `cnp` varchar(13) collate utf8_romanian_ci NOT NULL default '',
  `serieci` varchar(8) collate utf8_romanian_ci NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `cl_id` (`cl_id`),
  UNIQUE KEY `cnp` (`cnp`),
  UNIQUE KEY `serieci` (`serieci`),
  CONSTRAINT `persfiz_id` FOREIGN KEY (`cl_id`) REFERENCES `clienti` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci COMMENT='Tabela persoane fizice';

--
-- Dumping data for table `persfiz`
--


/*!40000 ALTER TABLE `persfiz` DISABLE KEYS */;
LOCK TABLES `persfiz` WRITE;
INSERT INTO `persfiz` VALUES (2,2,'1810711134272','gr111198'),(3,6,'1880811134272','GR123456'),(4,7,'1680941134272','GV153457'),(5,8,'1850811134272','GG999999'),(6,9,'2810811134272','GV112233'),(7,10,'2810811135272','GV112633'),(8,12,'4810811134272','TT999911'),(9,16,'4810871134272','TT999971'),(10,17,'4810871134275','TT999975');
UNLOCK TABLES;
/*!40000 ALTER TABLE `persfiz` ENABLE KEYS */;

--
-- Table structure for table `persjur`
--

DROP TABLE IF EXISTS `persjur`;
CREATE TABLE `persjur` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `cl_id` int(10) unsigned NOT NULL default '0',
  `cui` varchar(24) collate utf8_romanian_ci NOT NULL default '',
  `regcom` varchar(24) collate utf8_romanian_ci NOT NULL default '',
  `iban` varchar(24) collate utf8_romanian_ci NOT NULL default '',
  `banca` varchar(200) collate utf8_romanian_ci NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `cl_id` (`cl_id`),
  UNIQUE KEY `cui` (`cui`),
  UNIQUE KEY `regcom` (`regcom`),
  UNIQUE KEY `iban` (`iban`),
  CONSTRAINT `persjur_id` FOREIGN KEY (`cl_id`) REFERENCES `clienti` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci COMMENT='Tabela persoane juridice';

--
-- Dumping data for table `persjur`
--


/*!40000 ALTER TABLE `persjur` DISABLE KEYS */;
LOCK TABLES `persjur` WRITE;
INSERT INTO `persjur` VALUES (1,3,'235238','j13/2005/224242','RO3212345678901234567890',''),(2,5,'13131','j13/2004/1234','RO1234567890123456789012',''),(3,11,'J13/1242123/2006','238523829','RO2412345612345678901234','Transilvania');
UNLOCK TABLES;
/*!40000 ALTER TABLE `persjur` ENABLE KEYS */;

--
-- Table structure for table `view_cl_fiz`
--

DROP TABLE IF EXISTS `view_cl_fiz`;
/*!50001 DROP VIEW IF EXISTS `view_cl_fiz`*/;
/*!50001 DROP TABLE IF EXISTS `view_cl_fiz`*/;
/*!50001 CREATE TABLE `view_cl_fiz` (
  `id` int(10) unsigned,
  `tip` tinyint(3) unsigned,
  `denumire` varchar(240),
  `upd_time` timestamp,
  `upd_user` int(10) unsigned,
  `obs` text,
  `adresa` text,
  `cnp` varchar(13),
  `serieci` varchar(8)
) */;

--
-- Table structure for table `view_cl_jur`
--

DROP TABLE IF EXISTS `view_cl_jur`;
/*!50001 DROP VIEW IF EXISTS `view_cl_jur`*/;
/*!50001 DROP TABLE IF EXISTS `view_cl_jur`*/;
/*!50001 CREATE TABLE `view_cl_jur` (
  `id` int(10) unsigned,
  `tip` tinyint(3) unsigned,
  `denumire` varchar(240),
  `upd_time` timestamp,
  `upd_user` int(10) unsigned,
  `obs` text,
  `adresa` text,
  `cui` varchar(24),
  `regcom` varchar(24),
  `iban` varchar(24)
) */;

--
-- Dumping routines for database 'app'
--
DELIMITER ;;

/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE*/;;
/*!50003 DROP PROCEDURE IF EXISTS `cl_view` */;;
/*!50003 SET SESSION SQL_MODE="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER"*/;;
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE `cl_view`(IN cl_id INT)
BEGIN

  DECLARE t INT;



  SELECT tip INTO t FROM clienti WHERE id = cl_id;

  IF t = 0 THEN /* pers fizica */



    SELECT * FROM view_cl_fiz WHERE id = cl_id;



  ELSE /* pers juridica */



    SELECT * FROM view_cl_jur WHERE id = cl_id;



  END IF;



END */;;

/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE*/;;
DELIMITER ;


--
-- View structure for view `view_cl_fiz`
--

/*!50001 DROP TABLE IF EXISTS `view_cl_fiz`*/;
/*!50001 DROP VIEW IF EXISTS `view_cl_fiz`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view_cl_fiz` AS select `clienti`.`id` AS `id`,`clienti`.`tip` AS `tip`,`clienti`.`denumire` AS `denumire`,`clienti`.`upd_time` AS `upd_time`,`clienti`.`upd_user` AS `upd_user`,`clienti`.`obs` AS `obs`,`clienti`.`adresa` AS `adresa`,`persfiz`.`cnp` AS `cnp`,`persfiz`.`serieci` AS `serieci` from (`clienti` join `persfiz` on((`clienti`.`id` = `persfiz`.`cl_id`))) where (`clienti`.`id` = `persfiz`.`cl_id`) */;

--
-- View structure for view `view_cl_jur`
--

/*!50001 DROP TABLE IF EXISTS `view_cl_jur`*/;
/*!50001 DROP VIEW IF EXISTS `view_cl_jur`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view_cl_jur` AS select `clienti`.`id` AS `id`,`clienti`.`tip` AS `tip`,`clienti`.`denumire` AS `denumire`,`clienti`.`upd_time` AS `upd_time`,`clienti`.`upd_user` AS `upd_user`,`clienti`.`obs` AS `obs`,`clienti`.`adresa` AS `adresa`,`persjur`.`cui` AS `cui`,`persjur`.`regcom` AS `regcom`,`persjur`.`iban` AS `iban` from (`clienti` join `persjur` on((`clienti`.`id` = `persjur`.`cl_id`))) */;
/*!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 */;