--
-- Host: localhost    Database: parkingdb
-- ------------------------------------------------------


--
-- Table structure for table `accescod`
--

CREATE TABLE `accescod` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cod` text NOT NULL,
  `name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `accescod`
--


--
-- Table structure for table `camera`
--

CREATE TABLE `camera` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` text NOT NULL,
  `u` text NOT NULL,
  `p` text NOT NULL,
  `s` text NOT NULL,
  `t` text NOT NULL,
  `pid` int(11) NOT NULL,
  `dir` text NOT NULL,
  `printername` text NOT NULL,
  `grup` text NOT NULL,
  `ctrl` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `camera`
--

INSERT INTO `camera` VALUES (3,'192.168.8.19','admin','Admin12345','zoneup','cam',0,'in','\\\\DESKTOP-DHA7369\\Intrare1','1',1),(4,'192.168.8.18','admin','Admin12345','zoneup','cam',3,'out','','1',1);

--
-- Table structure for table `cfg`
--

CREATE TABLE `cfg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `n` text NOT NULL,
  `v` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `cfg`
--

INSERT INTO `cfg` VALUES (1,'pretora_zi','5'),(2,'minutes','30'),(3,'pretora_noapte','5'),(4,'pretora','5'),(5,'pretora_after','5'),(6,'panel_name','BOTOSANI BVD'),(7,'pagination_nr','40');

--
-- Table structure for table `counter`
--

CREATE TABLE `counter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entries_id` int(11) NOT NULL,
  `val` int(11) NOT NULL,
  `incasator` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32142 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `counter`
--


--
-- Table structure for table `entries`
--

CREATE TABLE `entries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `camera_id` int(11) NOT NULL,
  `plate` text NOT NULL,
  `time` int(11) NOT NULL,
  `timeout` int(11) NOT NULL,
  `payed` text NOT NULL,
  `payby` int(11) NOT NULL,
  `incasator` int(11) NOT NULL,
  `btn` int(11) NOT NULL,
  `rest` int(11) NOT NULL,
  `rest_success` int(11) NOT NULL,
  `scheck` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=112127 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `entries`
--


--
-- Table structure for table `entries_by_camera`
--

CREATE TABLE `entries_by_camera` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `camera_id` int(11) NOT NULL,
  `entries_id` int(11) NOT NULL,
  `whitelist_id` int(11) NOT NULL,
  `recno` int(11) NOT NULL,
  `timeout` int(11) NOT NULL,
  `del` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=86926 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `entries_by_camera`
--


--
-- Table structure for table `entries_to_out`
--

CREATE TABLE `entries_to_out` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plate` text NOT NULL,
  `entries_id` text NOT NULL,
  `camera_ip` text NOT NULL,
  `is_del` int(11) NOT NULL,
  `accescod_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15928 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `entries_to_out`
--


--
-- Table structure for table `whitelist`
--

CREATE TABLE `whitelist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plate` text NOT NULL,
  `timeout` int(11) NOT NULL,
  `is_m` int(11) NOT NULL,
  `type_id` int(11) NOT NULL,
  `name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1661 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `whitelist`
--


--
-- Table structure for table `whitelisttype`
--

CREATE TABLE `whitelisttype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `whitelisttype`
--

INSERT INTO `whitelisttype` VALUES (64,'CTS');


