aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/mayor-portal/install
diff options
context:
space:
mode:
authorM.Gergo2019-03-08 21:20:34 +0100
committerM.Gergo2019-03-08 21:20:34 +0100
commitf51c9ed2abe5c68211bb3736be5f70b1fe2c9ec0 (patch)
treee13e60e4b94a3b58f1e2bfbe271102c8f04b67bd /mayor-orig/mayor-portal/install
parentc76a004b0135786f2742283f8d5f917106f58bd8 (diff)
downloadmayor-f51c9ed2abe5c68211bb3736be5f70b1fe2c9ec0.tar.gz
mayor-f51c9ed2abe5c68211bb3736be5f70b1fe2c9ec0.zip
további rendrakás
Diffstat (limited to 'mayor-orig/mayor-portal/install')
-rw-r--r--mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql150
-rw-r--r--mayor-orig/mayor-portal/install/mayor-portal/mysql/portal-init.sql17
2 files changed, 167 insertions, 0 deletions
diff --git a/mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql b/mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql
new file mode 100644
index 00000000..842760b7
--- /dev/null
+++ b/mayor-orig/mayor-portal/install/mayor-portal/mysql/mayor-portal.sql
@@ -0,0 +1,150 @@
+-- MySQL dump 10.11
+--
+-- Host: localhost Database: hirek
+-- ------------------------------------------------------
+-- Server version 5.0.32-Debian_7etch1-log
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+CREATE DATABASE IF NOT EXISTS %MYSQL_PORTAL_DB% CHARACTER SET utf8 COLLATE utf8_hungarian_ci;
+GRANT ALL ON `%MYSQL_PORTAL_DB%`.* TO '%MYSQL_PORTAL_USER%'@'localhost' IDENTIFIED BY '%MYSQL_PORTAL_PW%';
+
+USE %MYSQL_PORTAL_DB%;
+
+CREATE TABLE `mayorUpdateLog` (
+ `scriptFile` varchar(255) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',
+ `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ PRIMARY KEY (`scriptFile`,`dt`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
+
+--
+-- Table structure for table `hirek`
+--
+
+DROP TABLE IF EXISTS `hirek`;
+SET @saved_cs_client = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `hirek` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `kdt` datetime default NULL,
+ `vdt` datetime default NULL,
+ `class` tinyint(3) unsigned NOT NULL default '0',
+ `lang` varchar(5) default 'hu_HU',
+ `cim` text,
+ `txt` text,
+ `owner` varchar(10) default NULL,
+ `flag` tinyint(3) unsigned NOT NULL default '0',
+ `cid` tinyint(3) unsigned NOT NULL default '0',
+ `pic` varchar(20) default NULL,
+ `friss` enum('','on') default '',
+ `fontos` enum('','on') default '',
+ `split` tinyint(3) unsigned NOT NULL default '0',
+ `csoport` varchar(255) NOT NULL default '',
+ PRIMARY KEY (`id`),
+ KEY `dtindex` (`kdt`,`vdt`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=1;
+SET character_set_client = @saved_cs_client;
+
+--
+--
+-- Table structure for table `kategoriak`
+--
+
+DROP TABLE IF EXISTS `kategoriak`;
+CREATE TABLE `kategoriak` (
+ `id` mediumint(8) unsigned NOT NULL default '0',
+ `leiras` varchar(70) NOT NULL default '',
+ `precode` text,
+ `postcode` text
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=1;
+
+
+--
+-- Table structure for table `linkek`
+--
+
+DROP TABLE IF EXISTS `linkek`;
+CREATE TABLE `linkek` (
+ `kulcs` int(10) unsigned NOT NULL auto_increment,
+ `hid` int(10) unsigned NOT NULL default '0',
+ `uri` varchar(255) default NULL,
+ `linktipus` enum('belso','kulso') default NULL,
+ `szoveg` text,
+ PRIMARY KEY (`kulcs`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=1;
+
+
+--
+-- Table structure for table `kerdesek`
+--
+
+DROP TABLE IF EXISTS `kerdesek`;
+CREATE TABLE `kerdesek` (
+ `sorszam` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `vszam` tinyint(3) unsigned DEFAULT NULL,
+ `kerdes` varchar(255) DEFAULT NULL,
+ `policy` set('private','parent','public') DEFAULT 'public',
+ PRIMARY KEY (`sorszam`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=1;
+
+
+--
+-- Table structure for table `nevnap`
+--
+
+DROP TABLE IF EXISTS `nevnap`;
+CREATE TABLE `nevnap` (
+ `honap` tinyint(4) default NULL,
+ `nap` tinyint(4) default NULL,
+ `nevnap` tinytext
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=1;
+
+--
+-- Dumping data for table `nevnap`
+--
+
+/*!40000 ALTER TABLE `nevnap` DISABLE KEYS */;
+INSERT INTO `nevnap` VALUES (1,1,'Fruzsina'),(1,2,'Ábel'),(1,3,'Genovéva, Benjámin'),(1,4,'Titusz, Leona'),(1,5,'Simon'),(1,6,'Boldizsár'),(1,7,'Attila, Ramóna'),(1,8,'Gyöngyvér'),(1,9,'Marcell'),(1,10,'Melánia'),(1,11,'Ágota'),(1,12,'Ernő'),(1,13,'Veronika'),(1,14,'Bódog'),(1,15,'Lóránt, Loránd'),(1,16,'Gusztáv'),(1,17,'Antal, Antónia'),(1,18,'Piroska'),(1,19,'Sára, Márió'),(1,20,'Fábián, Sebestyén'),(1,21,'Ágnes'),(1,22,'Vince, Artúr'),(1,23,'Zelma, Rajmund'),(1,24,'Timót'),(1,25,'Pál'),(1,26,'Vanda, Paula'),(1,27,'Angelika'),(1,28,'Károly, Karola'),(1,29,'Adél'),(1,30,'Martina, Gerda'),(1,31,'Marcella'),(2,1,'Ignác'),(2,2,'Karolina, Aida'),(2,3,'Balázs'),(2,4,'Ráhel, Csenge'),(2,5,'Ágota, Ingrid'),(2,6,'Dorottya, Dóra'),(2,7,'Tódor, Rómeó'),(2,8,'Aranka'),(2,9,'Abigél, Alex'),(2,10,'Elvira'),(2,11,'Bertold, Marietta'),(2,12,'Lívia, Lídia'),(2,13,'Ella, Linda'),(2,14,'Bálint, Valentin'),(2,15,'Kolos, Georgina'),(2,16,'Julianna, Lilla'),(2,17,'Donát'),(2,18,'Bernadett'),(2,19,'Zsuzsanna'),(2,20,'Aladár, Álmos'),(2,21,'Eleonóra'),(2,22,'Gerzson'),(2,23,'Alfréd'),(2,24,'Szőkőnap'),(2,25,'Mátyás'),(2,26,'Géza'),(2,27,'Edina'),(2,28,'Ákos, Bátor'),(2,29,'Elemér'),(3,1,'Albin'),(3,2,'Lujza'),(3,3,'Kornélia'),(3,4,'Kázmér'),(3,5,'Adorján, Adrián'),(3,6,'Leonóra, Inez'),(3,7,'Tamás'),(3,8,'Zoltán'),(3,9,'Franciska, Fanni'),(3,10,'Ildikó'),(3,11,'Szilárd'),(3,12,'Gergely'),(3,13,'Krisztián, Ajtony'),(3,14,'Matild'),(3,15,'Kristóf'),(3,16,'Henrietta'),(3,17,'Gertrúd, Patrik'),(3,18,'Sándor, Ede'),(3,19,'József, Bánk'),(3,20,'Klaudia'),(3,21,'Benedek'),(3,22,'Beáta, Izolda'),(3,23,'Emőke'),(3,24,'Gábor, Karina'),(3,25,'Irén, Irisz'),(3,26,'Emánuel'),(3,27,'Hajnalka'),(3,28,'Gedeon, Johanna'),(3,29,'Auguszta'),(3,30,'Zalán'),(3,31,'Árpád'),(4,1,'Hugó'),(4,2,'Áron'),(4,3,'Buda, Richárd'),(4,4,'Izidor'),(4,5,'Vince'),(4,6,'Vilmos, Bíborka'),(4,7,'Herman'),(4,8,'Dénes'),(4,9,'Erhard'),(4,10,'Zsolt'),(4,11,'Leó, Szaniszló'),(4,12,'Gyula'),(4,13,'Ida'),(4,14,'Tibor, Nyúl:)'),(4,15,'Anasztázia, Tas'),(4,16,'Csongor'),(4,17,'Rudolf'),(4,18,'Andrea, Ilma'),(4,19,'Emma, :)'),(4,20,'Tivadar'),(4,21,'Konrád'),(4,22,'Csilla, Noémi'),(4,23,'Béla'),(4,24,'György'),(4,25,'Márk'),(4,26,'Ervin'),(4,27,'Zita'),(4,28,'Valéria'),(4,29,'Péter'),(4,30,'Katalin, Kitti'),(5,1,'Fülöp, Jakab'),(5,2,'Zsigmond'),(5,3,'Tímea, Irma'),(5,4,'Mónika, Flórián'),(5,5,'Györgyi'),(5,6,'Ivett, Frida'),(5,7,'Gizella'),(5,8,'Mihály'),(5,9,'Gergely'),(5,10,'Ármin, Pálma'),(5,11,'Ferenc'),(5,12,'Pongrác'),(5,13,'Szervác, Imola'),(5,14,'Bonifác'),(5,15,'Zsófia, Szonja'),(5,16,'Mózes, Botond'),(5,17,'Paszkál'),(5,18,'Erik, Alexandra'),(5,19,'Ivó, Milán'),(5,20,'Bernát, Felícia'),(5,21,'Konstantin'),(5,22,'Júlia, Rita'),(5,23,'Dezső'),(5,24,'Eszter, Eliza'),(5,25,'Orbán'),(5,26,'Fülöp, Evelin'),(5,27,'Hella'),(5,28,'Emil, Csanád'),(5,29,'Magdolna'),(5,30,'Janka, Zsanett'),(5,31,'Angéla, Petronella'),(6,1,'Tünde'),(6,2,'Kármen, Anita'),(6,3,'Klotild'),(6,4,'Bulcsú'),(6,5,'Fatime'),(6,6,'Norbert, Cintia'),(6,7,'Róbert'),(6,8,'Medárd'),(6,9,'Félix'),(6,10,'Margit, Gréta'),(6,11,'Barnabás'),(6,12,'Villő'),(6,13,'Antal, Anett'),(6,14,'Vazul'),(6,15,'Jolán, Vid'),(6,16,'Jusztin'),(6,17,'Laura, Alida'),(6,18,'Arnold, Levente'),(6,19,'Gyárfás'),(6,20,'Rafael'),(6,21,'Alajos, Leila'),(6,22,'Paulina'),(6,23,'Zoltán'),(6,24,'Iván'),(6,25,'Vilmos'),(6,26,'János, Pál'),(6,27,'László'),(6,28,'Levente, Irén'),(6,29,'Péter, Pál'),(6,30,'Pál'),(7,1,'Tihamér, Annamária'),(7,2,'Ottó'),(7,3,'Kornél, Soma'),(7,4,'Ulrik'),(7,5,'Emese, Sarolta'),(7,6,'Csaba'),(7,7,'Appolónia'),(7,8,'Ellák'),(7,9,'Lukrécia'),(7,10,'Amália'),(7,11,'Nóra, Lili'),(7,12,'Izabella, Dalma'),(7,13,'Jenő'),(7,14,'őrs, Stella'),(7,15,'Henrik, Roland'),(7,16,'Valter'),(7,17,'Endre, Elek'),(7,18,'Frigyes'),(7,19,'Emília'),(7,20,'Illés'),(7,21,'Dániel, Daniella'),(7,22,'Magdolna'),(7,23,'Lenke'),(7,24,'Kinga, Kincső'),(7,25,'Kristóf, Jakab'),(7,26,'Anna, Anikó'),(7,27,'Olga, Liliána'),(7,28,'Szabolcs'),(7,29,'Márta, Flóra'),(7,30,'Judit, Xénia'),(7,31,'Oszkár'),(8,1,'Boglárka'),(8,2,'Lehel'),(8,3,'Hermina'),(8,4,'Domonkos, Dominika'),(8,5,'Krisztina'),(8,6,'Berta, Bettina'),(8,7,'Ibolya'),(8,8,'László'),(8,9,'Emőd'),(8,10,'Lörinc'),(8,11,'Zsuzsanna, Tiborc'),(8,12,'Klára'),(8,13,'Ipoly'),(8,14,'Marcell'),(8,15,'Mária'),(8,16,'Ábrahám'),(8,17,'Jácint'),(8,18,'Ilona'),(8,19,'Huba'),(8,20,'István'),(8,21,'Sámuel, Hajna'),(8,22,'Menyhért, Mirjam'),(8,23,'Bence'),(8,24,'Bertalan'),(8,25,'Lajos, Patrícia'),(8,26,'Izsó'),(8,27,'Gáspár'),(8,28,'Ágoston'),(8,29,'Beatrix, Erna'),(8,30,'Rózsa'),(8,31,'Erika, Bella'),(9,1,'Egyed, Egon'),(9,2,'Rebeka, Dorina'),(9,3,'Hilda'),(9,4,'Rozália'),(9,5,'Viktor, Lőrinc'),(9,6,'Zakariás'),(9,7,'Regina'),(9,8,'Mária, Adrienn'),(9,9,'Ádám'),(9,10,'Nikolett, Hunor'),(9,11,'Teodóra'),(9,12,'Mária'),(9,13,'Kornél'),(9,14,'Szeréna, Roxána'),(9,15,'Enikő, Melitta'),(9,16,'Edit'),(9,17,'Zsófia'),(9,18,'Diána'),(9,19,'Vilhelmina'),(9,20,'Friderika'),(9,21,'Máté, Mirella'),(9,22,'Móric'),(9,23,'Tekla'),(9,24,'Gellért, Mercédesz'),(9,25,'Eufrozina, Kende'),(9,26,'Jusztina'),(9,27,'Adalbert'),(9,28,'Vencel'),(9,29,'Mihály'),(9,30,'Jeromos'),(10,1,'Malvin'),(10,2,'Petra'),(10,3,'Helga'),(10,4,'Ferenc'),(10,5,'Aurél'),(10,6,'Brúnó, Renáta'),(10,7,'Amália'),(10,8,'Koppány'),(10,9,'Dénes'),(10,10,'Gedeon'),(10,11,'Brigitta'),(10,12,'Miksa'),(10,13,'Kálmán, Ede'),(10,14,'Helén'),(10,15,'Teréz'),(10,16,'Gál'),(10,17,'Hedvig'),(10,18,'Lukács'),(10,19,'Nándor'),(10,20,'Vendel, :)'),(10,21,'Orsolya'),(10,22,'Előd'),(10,23,'Gyöngyi'),(10,24,'Salamon'),(10,25,'Blanka, Bianka'),(10,26,'Dömötör'),(10,27,'Szabina'),(10,28,'Simon, Szimonetta'),(10,29,'Nárcisz'),(10,30,'Alfonz'),(10,31,'Farkas'),(11,1,'Marianna'),(11,2,'Achilles'),(11,3,'Győző'),(11,4,'Károly'),(11,5,'Imre'),(11,6,'Lénárd'),(11,7,'Rezső'),(11,8,'Zsombor'),(11,9,'Tivadar'),(11,10,'Réka'),(11,11,'Márton'),(11,12,'Jónás, Renátó'),(11,13,'Szilvia'),(11,14,'Aliz'),(11,15,'Albert, Lipót'),(11,16,'Ödön'),(11,17,'Hortenzia, Gergő'),(11,18,'Jenő'),(11,19,'Erzsébet'),(11,20,'Jolán'),(11,21,'Olivér'),(11,22,'Cecília'),(11,23,'Kelemen, Klementina'),(11,24,'Emma'),(11,25,'Katalin'),(11,26,'Virág'),(11,27,'Virgil'),(11,28,'Stefánia'),(11,29,'Taksony'),(11,30,'András, Andor'),(12,1,'Elza'),(12,2,'Melinda, Vivien'),(12,3,'Ferenc, Olívia'),(12,4,'Borbála, Barbara'),(12,5,'Vilma'),(12,6,'Mikulás, Miklós'),(12,7,'Ambrus'),(12,8,'Mária'),(12,9,'Natália'),(12,10,'Judit'),(12,11,'Árpád'),(12,12,'Gabriella'),(12,13,'Luca, Otília'),(12,14,'Szilárda'),(12,15,'Valér'),(12,16,'Etelka, Aletta'),(12,17,'Lázár, Olimpia'),(12,18,'Auguszta'),(12,19,'Viola'),(12,20,'Teofil'),(12,21,'Tamás'),(12,22,'Zéno'),(12,23,'Viktória'),(12,24,'Ádám, Éva'),(12,25,'KARÁCSONY, Eugénia'),(12,26,'KARÁCSONY, István'),(12,27,'János'),(12,28,'Kamilla'),(12,29,'Tamás, Tamara'),(12,30,'Dávid'),(12,31,'Szilveszter');
+/*!40000 ALTER TABLE `nevnap` ENABLE KEYS */;
+
+-- Table structure for table `valaszok`
+--
+
+DROP TABLE IF EXISTS `valaszok`;
+CREATE TABLE `valaszok` (
+ `sorszam` int(10) unsigned NOT NULL auto_increment,
+ `kszam` int(10) unsigned default NULL,
+ `pontszam` int(10) unsigned default '0',
+ `valasz` varchar(255) default NULL,
+ PRIMARY KEY (`sorszam`)
+) ENGINE=InnoDb DEFAULT CHARSET=utf8;
+
+-- Table structure for table `kerdoivSzavazott`
+--
+
+DROP TABLE IF EXISTS `kerdoivSzavazott`;
+CREATE TABLE `kerdoivSzavazott` (
+ `kerdoivId` int(10) unsigned NOT NULL,
+ `policy` enum('private','parent') COLLATE utf8_hungarian_ci DEFAULT NULL,
+ `userAccount` varchar(60) COLLATE utf8_hungarian_ci DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
+
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
diff --git a/mayor-orig/mayor-portal/install/mayor-portal/mysql/portal-init.sql b/mayor-orig/mayor-portal/install/mayor-portal/mysql/portal-init.sql
new file mode 100644
index 00000000..969730ba
--- /dev/null
+++ b/mayor-orig/mayor-portal/install/mayor-portal/mysql/portal-init.sql
@@ -0,0 +1,17 @@
+
+USE %MYSQL_PRIVATE_DB%;
+
+SET @uid = (SELECT uid FROM accounts WHERE userAccount='mayoradmin');
+DELETE FROM groups WHERE groupCn='hirekadmin';
+INSERT INTO groups (groupCn,groupDesc,policy) VALUES ('hirekadmin','Hír adminisztrátor','private');
+SET @gid = (SELECT gid FROM groups WHERE groupCn='hirekadmin');
+DELETE FROM members WHERE uid=@uid AND gid=@gid;
+INSERT INTO members (uid,gid) VALUES (@uid,@gid);
+
+INSERT INTO %MYSQL_PORTAL_DB%.hirek (kdt,vdt,class,lang,cim,txt,owner,flag,csoport) VALUES (
+ CURDATE(), CURDATE() + INTERVAL 7 DAY, 6, 'hu_HU',
+ 'Köszöntünk a MaYoR-ban!','A MaYoR keretrendszer és elektronikus napló telepítése sikeresen lezajlott,
+ következhet az adatok betöltése és a rendszer konfigurálása. Ehhez segítséget a
+ <a href="http://wiki.mayor.hu/doku.php?id=hogyan:telepites#adatok_felvitele">MaYoR Wiki</a>-ben találsz.',
+ 'mayoradmin', 1, 'egyéb'
+);