-- MySQL dump 8.23
--
-- Host: localhost    Database: if01_halina
---------------------------------------------------------
-- Server version	3.23.58

--
-- Table structure for table `Vill`
--

DROP TABLE IF EXISTS Vill;
CREATE TABLE Vill (
  id int(6) NOT NULL auto_increment,
  eesnimi varchar(100) NOT NULL default '',
  perenimi varchar(100) NOT NULL default '',
  mail varchar(100) NOT NULL default '',
  tel varchar(100) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table `Vill`
--


INSERT INTO Vill VALUES (1,'Halina','Mugme','moolin@hot.ee','-');
INSERT INTO Vill VALUES (2,'Rain','Viigipuu','-','056456538');

--
-- Table structure for table `logi`
--

DROP TABLE IF EXISTS logi;
CREATE TABLE logi (
  id int(6) NOT NULL auto_increment,
  ip int(14) default NULL,
  eesnimi varchar(100) NOT NULL default '',
  perenimi varchar(100) NOT NULL default '',
  mail varchar(100) NOT NULL default '',
  tel varchar(100) NOT NULL default '',
  vid int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table `logi`
--


INSERT INTO logi VALUES (1,193,'Halina','Mugme','moolin@hot.ee','-',1);
INSERT INTO logi VALUES (2,193,'Rain','Viigipuu','-','-',2);
INSERT INTO logi VALUES (3,193,'Rain','Viigipuu','-','056456538',2);
INSERT INTO logi VALUES (4,193,'Rain','Viigipuu','-','-',2);
INSERT INTO logi VALUES (5,193,'Rain','Viigipuu','-','056456538',2);
INSERT INTO logi VALUES (6,193,'Rain','Viigipuu','dragut@hot.ee','056456538',2);
INSERT INTO logi VALUES (7,193,'Rain','Viigipuu','-','-',2);
INSERT INTO logi VALUES (8,193,'Rain','Viigipuu','-','056456538',2);