Search options

SET NAMES utf8;

SET SQL_MODE='';

create database if not exists `perfonus`;

USE `perfonus`;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';

/*Table structure for table `imones` */

DROP TABLE IF EXISTS `imones`;

CREATE TABLE `imones` (
  `Pavadinimas` varchar(200) collate latin1_general_ci default NULL,
  `PVM` varchar(100) collate latin1_general_ci NOT NULL,
  `Kodas` varchar(50) collate latin1_general_ci NOT NULL,
  `Adresas` varchar(255) collate latin1_general_ci default NULL,
  `Telefonas` varchar(50) collate latin1_general_ci default NULL,
  `Astovauja` varchar(50) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`PVM`,`Kodas`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

/*Data for the table `imones` */

insert into `imones` (`Pavadinimas`,`PVM`,`Kodas`,`Adresas`,`Telefonas`,`Astovauja`) values ('Saraskino kontora','1234567','7777777','Toli','911',NULL);

/*Table structure for table `irankiai` */

DROP TABLE IF EXISTS `irankiai`;

CREATE TABLE `irankiai` (
  `Irankis` varchar(200) collate latin1_general_ci default NULL,
  `Verte` double default NULL,
  `Numeris` int(11) NOT NULL,
  `Eksplotacija` datetime default NULL,
  PRIMARY KEY  (`Numeris`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

/*Data for the table `irankiai` */

insert into `irankiai` (`Irankis`,`Verte`,`Numeris`,`Eksplotacija`) values ('Sudo maisykle',0,666,NULL);

/*Table structure for table `irankiunuoma` */

DROP TABLE IF EXISTS `irankiunuoma`;

CREATE TABLE `irankiunuoma` (
  `Numeris` int(11) NOT NULL,
  `Kodas` varchar(50) collate latin1_general_ci NOT NULL,
  `Paimtas` datetime NOT NULL,
  PRIMARY KEY  (`Numeris`,`Kodas`,`Paimtas`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

/*Data for the table `irankiunuoma` */

insert into `irankiunuoma` (`Numeris`,`Kodas`,`Paimtas`) values (17,'7777777','2006-08-27 15:00:00');

SET SQL_MODE=@OLD_SQL_MODE;

SELECT Imones.Pavadinimas, Irankiai.Irankis, IrankiuNuoma.Paimtas FROM Imones INNER JOIN IrankiuNuoma ON Imones.Kodas = IrankiuNuoma.Kodas INNER JOIN Irankiai ON Irankiai.Numeris = IrankiuNuoma.Numeris