aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/update/rev002019-1-mayor_portal.sql
diff options
context:
space:
mode:
Diffstat (limited to 'mayor-orig/update/rev002019-1-mayor_portal.sql')
-rw-r--r--mayor-orig/update/rev002019-1-mayor_portal.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/mayor-orig/update/rev002019-1-mayor_portal.sql b/mayor-orig/update/rev002019-1-mayor_portal.sql
new file mode 100644
index 00000000..cc90243f
--- /dev/null
+++ b/mayor-orig/update/rev002019-1-mayor_portal.sql
@@ -0,0 +1,3 @@
+create table `kerdoivSzavazott` (`kerdoivId` int unsigned not null, `policy` ENUM('private','parent'), `userAccount` varchar(60))
+ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_hungarian_ci;
+alter table `kerdesek` add `policy` set('private','parent','public') DEFAULT 'public';