cDAqx34y

1-- MySQL dump 10.11
2--
3-- Host: localhost    Database: arxeio
4-- ------------------------------------------------------
5-- Server version	5.0.51b
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `amonsubjects`
20--
21
22DROP TABLE IF EXISTS `amonsubjects`;
23SET @saved_cs_client     = @@character_set_client;
24SET character_set_client = utf8;
25CREATE TABLE `amonsubjects` (
26  `id` int(11) NOT NULL auto_increment,
27  `amontarista_id` varchar(6) NOT NULL,
28  `start` varchar(10) NOT NULL default '00:00:00',
29  `end` varchar(10) NOT NULL default '00:00:00',
30  `txt` varchar(150) NOT NULL default '',
31  PRIMARY KEY  (`id`),
32  KEY `amontarista_id` (`amontarista_id`),
33  CONSTRAINT `amontarista_id` FOREIGN KEY (`amontarista_id`) REFERENCES `amontarista` (`id`)
34) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;
35SET character_set_client = @saved_cs_client;
36
37--
38-- Dumping data for table `amonsubjects`
39--
40
41LOCK TABLES `amonsubjects` WRITE;
42/*!40000 ALTER TABLE `amonsubjects` DISABLE KEYS */;
43INSERT INTO `amonsubjects` VALUES (13,'5JAN80','00:00:00','01:00:00','5JAN80-SUBJ'),(18,'6JAN80','00:00:00','01:00:00','6JAN80-SUBJ'),(19,'6JAN80','00:00:00','00:00:00','aefea'),(20,'6JAN80','00:00:00','00:00:00','efafe'),(21,'6JAN80','00:00:00','00:00:00','ffeafe'),(22,'6JAN80','00:00:00','00:00:00','fae'),(23,'6JAN80','00:00:00','00:00:00','afeafefeafefe'),(24,'6JAN80','00:00:00','00:00:00','fefefefefefefe'),(25,'6JAN80','00:00:00','00:00:00','feafefefefe'),(35,'5JAN80','00:00:00','00:00:00','aefaefafeafeaefaeaefafe'),(43,'5JAN80','00:00:00','00:00:00','aefafeafe'),(44,'5JAN80','00:00:00','00:00:00','afeafe'),(45,'5JAN80','00:00:00','00:00:00','affe'),(46,'5JAN80','00:00:00','00:00:00','feafeafe'),(47,'5JAN80','00:00:00','00:00:00','afafe'),(48,'','00:00:00','00:00:00','A'),(49,'','00:00:00','00:00:00','B'),(50,'','00:00:00','00:00:00','C'),(51,'','00:00:00','00:00:00','D'),(52,'','00:00:00','00:00:00','E'),(53,'','00:00:00','00:00:00','F'),(54,'','00:00:00','00:00:00','G'),(55,'876543','00:00:00','01:00:00','31-DEC-2020-SUBJ'),(56,'876543','00:00:00','01:00:00','31-DEC-2020-SUBJ'),(57,'876543','00:00:00','01:00:00','31-DEC-2020-SUBJ'),(58,'876543','00:00:00','01:00:00','31-DEC-2019-SUBJ'),(59,'123','00:00:00','01:00:00','31-DEC-2019-SUBJ'),(60,'123','00:00:00','00:00:00',''),(65,'123','00:00:00','00:00:00','');
44/*!40000 ALTER TABLE `amonsubjects` ENABLE KEYS */;
45UNLOCK TABLES;
46
47--
48-- Table structure for table `amontarista`
49--
50
51DROP TABLE IF EXISTS `amontarista`;
52SET @saved_cs_client     = @@character_set_client;
53SET character_set_client = utf8;
54CREATE TABLE `amontarista` (
55  `id` varchar(6) NOT NULL,
56  `date` date NOT NULL,
57  `subject` varchar(150) NOT NULL,
58  PRIMARY KEY  (`id`)
59) ENGINE=InnoDB DEFAULT CHARSET=utf8;
60SET character_set_client = @saved_cs_client;
61
62--
63-- Dumping data for table `amontarista`
64--
65
66LOCK TABLES `amontarista` WRITE;
67/*!40000 ALTER TABLE `amontarista` DISABLE KEYS */;
68INSERT INTO `amontarista` VALUES ('','0000-00-00','1-JAN-80'),('123','2019-12-31','31-DEC-2019'),('3JAN80','1980-01-03','3JAN80'),('4JAN80','1980-01-04','4JAN80'),('5JAN80','1980-01-05','5JAN80'),('6JAN80','1980-01-06','6JAN80'),('876543','2020-12-31','31-DEC-2020');
69/*!40000 ALTER TABLE `amontarista` ENABLE KEYS */;
70UNLOCK TABLES;
71
72--
73-- Table structure for table `tvpress`
74--
75
76DROP TABLE IF EXISTS `tvpress`;
77SET @saved_cs_client     = @@character_set_client;
78SET character_set_client = utf8;
79CREATE TABLE `tvpress` (
80  `date` date NOT NULL,
81  `subject` varchar(150) NOT NULL,
82  `id` int(10) unsigned NOT NULL auto_increment,
83  PRIMARY KEY  (`id`),
84  UNIQUE KEY `date` (`date`)
85) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;
86SET character_set_client = @saved_cs_client;
87
88--
89-- Dumping data for table `tvpress`
90--
91
92LOCK TABLES `tvpress` WRITE;
93/*!40000 ALTER TABLE `tvpress` DISABLE KEYS */;
94INSERT INTO `tvpress` VALUES ('1980-12-01',' hax0r ',2),('1982-02-01','fdfsdfsd',3),('1987-06-16','34343',4),('1989-07-01','σρςρ',5),('1990-03-01','fdfdfsdf',6),('1982-03-16','BMAR82',8),('2020-12-16','B122020',9),('1981-02-01','A-FEB-1981',10),('1981-01-16','B-JAN-1981',12),('1980-03-01','A-MAR-1980',13),('1980-03-16','B-MAR-1980',14),('1980-09-01','jfhjfhgfhfvghj',17),('1980-02-01','1234567890',18),('1985-05-01','fdsfsd',19),('1986-04-16','ghjg',20),('1983-04-01','',21),('1990-05-01','',22),('1984-05-16','ffff',23),('1985-04-01','',24),('1984-10-01','fgfgfg',25),('2020-12-01','A-DEC-20020',26),('2020-01-16','B-JAN-2020',27),('1981-01-01','A-JAN-1981',28),('1982-01-01','A-JAN-1982',29),('1998-12-16','B-DEC-1998',30),('0000-00-00','aefeaefae',31),('1980-12-16','aefaeffaeefa',32),('1980-01-01','1234256789',33),('1983-01-01','1234256789',34),('1984-01-01','12312421',35),('1985-01-01','122',36),('2020-01-01','aefaef',37),('1986-05-01','aefeaffea',38),('1982-04-01','A-APR-1982',39),('1985-10-01','A-OCT-85',40),('1985-10-16','B-OCT-85',41),('1980-09-16','B-SEP-80',42),('1983-06-01','A-JUN-83',43),('1983-11-01','A-NOV-83',44),('1986-11-01','A-NOV-86',45),('1981-10-16','B-OCT-81',46),('1982-10-16','B-OCT-82',47),('1993-10-01','A-OCT-93',48),('1994-10-01','A-OCT-94',49),('1990-11-01','A-NOV-90',50),('1982-11-01','A-NOV-82',51),('1995-11-01','A-NOV-95',52),('2016-11-01','A-NOV-16',53),('2018-11-01','A-NOV-18',54);
95/*!40000 ALTER TABLE `tvpress` ENABLE KEYS */;
96UNLOCK TABLES;
97
98--
99-- Table structure for table `vouli`
100--
101
102DROP TABLE IF EXISTS `vouli`;
103SET @saved_cs_client     = @@character_set_client;
104SET character_set_client = utf8;
105CREATE TABLE `vouli` (
106  `id` varchar(6) NOT NULL,
107  `date` date NOT NULL,
108  `subject` varchar(150) NOT NULL,
109  PRIMARY KEY  (`id`)
110) ENGINE=InnoDB DEFAULT CHARSET=utf8;
111SET character_set_client = @saved_cs_client;
112
113--
114-- Dumping data for table `vouli`
115--
116
117LOCK TABLES `vouli` WRITE;
118/*!40000 ALTER TABLE `vouli` DISABLE KEYS */;
119INSERT INTO `vouli` VALUES ('','0000-00-00',''),('098765','2020-12-31','31-DEC-2020'),('1JAN80','1980-01-01','single'),('3JAN80','1980-01-03','3JAN80');
120/*!40000 ALTER TABLE `vouli` ENABLE KEYS */;
121UNLOCK TABLES;
122
123--
124-- Table structure for table `voulisubjects`
125--
126
127DROP TABLE IF EXISTS `voulisubjects`;
128SET @saved_cs_client     = @@character_set_client;
129SET character_set_client = utf8;
130CREATE TABLE `voulisubjects` (
131  `id` int(10) unsigned NOT NULL auto_increment,
132  `start` varchar(10) NOT NULL default '00:00:00',
133  `end` varchar(10) NOT NULL default '00:00:00',
134  `txt` varchar(150) NOT NULL default '',
135  `vouli_id` varchar(6) NOT NULL,
136  PRIMARY KEY  (`id`),
137  KEY `vouli_id` (`vouli_id`),
138  CONSTRAINT `vouli_id` FOREIGN KEY (`vouli_id`) REFERENCES `vouli` (`id`)
139) ENGINE=InnoDB AUTO_INCREMENT=203 DEFAULT CHARSET=utf8;
140SET character_set_client = @saved_cs_client;
141
142--
143-- Dumping data for table `voulisubjects`
144--
145
146LOCK TABLES `voulisubjects` WRITE;
147/*!40000 ALTER TABLE `voulisubjects` DISABLE KEYS */;
148INSERT INTO `voulisubjects` VALUES (174,'00:00:00','01:00:00','one','1JAN80'),(177,'01:00:00','02:00:00','double','1JAN80'),(178,'01:00:00','00:00:00','3JAN80-SUB','3JAN80'),(179,'00:00:00','00:00:00','feaefafe','3JAN80'),(191,'00:00:00','00:00:00','fefe','3JAN80'),(192,'00:00:00','00:00:00','aefaef','3JAN80'),(193,'00:00:00','00:00:00','afeaefaefaefaef','3JAN80'),(194,'00:00:00','00:00:00','aefaef','3JAN80'),(195,'00:00:00','00:00:00','afeaefaef','3JAN80'),(196,'00:00:00','00:00:00','',''),(197,'00:00:00','00:00:00','',''),(198,'00:00:00','00:00:00','',''),(199,'00:00:00','00:00:00','',''),(200,'00:00:00','01:00:00','31-DEC-2020-SUBJ','098765'),(201,'00:00:00','01:00:00','31-DEC-2020-SUBJ','098765'),(202,'00:00:00','00:00:00','','');
149/*!40000 ALTER TABLE `voulisubjects` ENABLE KEYS */;
150UNLOCK TABLES;
151/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
152
153/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
154/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
155/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
156/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
157/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
158/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
159/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
160
161-- Dump completed on 2009-03-12 10:21:31