From b15a3bfe1c68c170fed384957a8329ed5f154d36 Mon Sep 17 00:00:00 2001
From: Björn Geiger
Date: Mon, 31 Jan 2011 14:44:05 +0100
Subject: Fehler in SQL korrigiert

---
 pbs.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'pbs.sql')

diff --git a/pbs.sql b/pbs.sql
index 6f58829..2419e41 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -64,10 +64,10 @@ CREATE TABLE IF NOT EXISTS `pbs_person` (
   `postalcode` varchar(30) COLLATE utf8_unicode_ci,
   `logindate` varchar(14) COLLATE utf8_unicode_ci,
   `registerdate` varchar(14) COLLATE utf8_unicode_ci NOT NULL,
-  `email` varchar(30) COLLATE utf8_unicode_ci NOT NULL UNIQUE,
+  `email` varchar(30) COLLATE utf8_unicode_ci NOT NULL ,
   `login` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
   `password` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
-  `password_salt` varchar(64) COLLATE utf8_unicode_ci NOT NULL
+  `password_salt` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
   PRIMARY KEY (`personID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 
-- 
cgit v1.2.3-55-g7522


From c2ade39fad31432453270788231400144771af9f Mon Sep 17 00:00:00 2001
From: Björn Geiger
Date: Mon, 31 Jan 2011 14:47:01 +0100
Subject: ausversehen gelöschtes UNIQUE bei E-Mail wieder hinzugefügt

---
 pbs.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'pbs.sql')

diff --git a/pbs.sql b/pbs.sql
index 2419e41..bc8d5d3 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -64,7 +64,7 @@ CREATE TABLE IF NOT EXISTS `pbs_person` (
   `postalcode` varchar(30) COLLATE utf8_unicode_ci,
   `logindate` varchar(14) COLLATE utf8_unicode_ci,
   `registerdate` varchar(14) COLLATE utf8_unicode_ci NOT NULL,
-  `email` varchar(30) COLLATE utf8_unicode_ci NOT NULL ,
+  `email` varchar(30) COLLATE utf8_unicode_ci NOT NULL UNIQUE,
   `login` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
   `password` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
   `password_salt` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
-- 
cgit v1.2.3-55-g7522

