/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50612
Source Host           : localhost:3306
Source Database       : visualsoftcustomers2020

Target Server Type    : MYSQL
Target Server Version : 50612
File Encoding         : 65001

Date: 2020-06-14 22:56:19
*/


-- ----------------------------
-- Table structure for `applications`
-- ----------------------------
CREATE TABLE `applications` (
  `IDc` int(11) NOT NULL AUTO_INCREMENT,
  `Omada` varchar(100) DEFAULT NULL,
  `Perigrafi` varchar(255) NOT NULL,
  `Version` varchar(100) DEFAULT NULL,
  `VersionDate` date DEFAULT NULL,
  `VersionDateDateNum` int(11) DEFAULT '0',
  `FtpServer` varchar(150) DEFAULT NULL,
  `FtpServer2` varchar(150) DEFAULT NULL,
  `isActive` tinyint(1) DEFAULT '-1',
  `Sxolia` longtext,
  PRIMARY KEY (`IDc`),
  KEY `ThesiPerigrafi` (`Perigrafi`)
) ENGINE=InnoDB AUTO_INCREMENT=605 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of applications
-- ----------------------------
INSERT INTO `applications` VALUES ('155', '', 'ΧΕΛΗΣ ΛΕΩΝΙΔΑΣ', 'ΟΓΚΟΛΟΓΟΣ', null, null, 'xelis@dpth.gr', null, '-1', '');
INSERT INTO `applications` VALUES ('447', '', 'ΑΜΑΡΑΝΤΙΔΗΣ ΚΥΡΙΑΚΟΣ', 'ΟΓΚΟΛΟΓΟΣ', null, null, 'k.amarantidis@gmail.com', null, '-1', 'θα απουσιάζει από 15/7 - 22/7-2015');
INSERT INTO `applications` VALUES ('450', '', 'ΞΕΝΙΔΗΣ ΝΙΚΟΛΑΟΣ', 'ΟΓΚΟΛΟΓΟΣ', null, null, 'xenidis@dpth.gr', null, '-1', '');
INSERT INTO `applications` VALUES ('600', '', 'ΑΙΘΟΥΣΑ 5', '', null, null, '', null, '0', '');
INSERT INTO `applications` VALUES ('601', '', 'ΑΙΘΟΥΣΑ 4', '', null, null, '', null, '0', '');
INSERT INTO `applications` VALUES ('602', '', 'ΑΙΘΟΥΣΑ 6', '', null, null, '', null, '0', '');
INSERT INTO `applications` VALUES ('603', '', 'ΑΙΘΟΥΣΑ 7', '', null, null, '', null, '0', '');
INSERT INTO `applications` VALUES ('604', '', 'ΑΙΘΟΥΣΑ 8', '', null, null, '', null, '0', '');

-- ----------------------------
-- Table structure for `customers`
-- ----------------------------
CREATE TABLE `customers` (
  `IDCustomer` int(11) NOT NULL AUTO_INCREMENT,
  `Eponymia` varchar(150) NOT NULL,
  `AFM` varchar(20) DEFAULT NULL,
  `DOY` varchar(50) DEFAULT NULL,
  `Tilefono` varchar(50) DEFAULT NULL,
  `Kinito` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `License` varchar(250) DEFAULT NULL,
  `SerialNo` int(11) DEFAULT '0',
  `ApplicationName` varchar(100) DEFAULT NULL,
  `ApplicationCustomerVer` varchar(100) DEFAULT NULL,
  `ActivateStartDate` date DEFAULT NULL,
  `ActivateStartDateNum` int(11) DEFAULT NULL,
  `ActivateEndDate` date DEFAULT NULL,
  `ActivateEndDateNum` int(11) DEFAULT NULL,
  `ActivateUses` int(11) DEFAULT NULL,
  `isActive` tinyint(1) DEFAULT '-1',
  `Message` longtext,
  `Sxolia` longtext,
  PRIMARY KEY (`IDCustomer`),
  KEY `ThesiPerigrafi` (`Eponymia`)
) ENGINE=InnoDB AUTO_INCREMENT=605 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of customers
-- ----------------------------
INSERT INTO `customers` VALUES ('155', 'ΠΑΠΑΔΟΠΟΥΛΟΣ ΕΥΣΤΑΘΙΟΣ', '1234567890', null, '25510 12234, 6977 123456', null, 'xelis@dpth.gr', 'Nick1.jpg', '3', '', null, null, null, null, null, null, '-1', null, '');
INSERT INTO `customers` VALUES ('447', 'ΤΕΡΖΑΚΗΣ ΚΩΣΤΑΣ', '', null, '25510 11111', null, 'k.amarantidis@gmail.com', 'Nick1.jpg', '2', '', null, null, null, null, null, null, '-1', null, 'θα απουσιάζει από 15/7 - 22/7-2015');
INSERT INTO `customers` VALUES ('450', 'ΞΕΝΙΔΗΣ ΝΙΚΟΛΑΟΣ', '', null, '25510 22222 , εσ. 102', null, 'xenidis@dpth.gr', 'm1.jpg', '1', '', null, null, null, null, null, null, '-1', null, '');
INSERT INTO `customers` VALUES ('600', 'ΒΟΥΛΓΑΡΙΔΗΣ ΝΙΚΟΛΑΟΣ', '', null, '', null, '', '', '5', '', null, null, null, null, null, null, '0', null, '');
INSERT INTO `customers` VALUES ('601', 'ΠΟΡΤΟΚΑΛΙΔΗΣ ΓΕΩΡΓΙΟΣ', '', null, '', null, '', '', '4', '', null, null, null, null, null, null, '0', null, '');
INSERT INTO `customers` VALUES ('602', 'ΑΙΘΟΥΣΑ 6', '', null, '', null, '', '', '6', '', null, null, null, null, null, null, '0', null, '');
INSERT INTO `customers` VALUES ('603', 'ΑΙΘΟΥΣΑ 7', '', null, '', null, '', '', '7', '', null, null, null, null, null, null, '0', null, '');
INSERT INTO `customers` VALUES ('604', 'ΑΙΘΟΥΣΑ 8', '', null, '', null, '', '', '8', '', null, null, null, null, null, null, '0', null, '');
