From 23115181022138907abe027225c2f1cc6c95cba3 Mon Sep 17 00:00:00 2001
From: Simon
Date: Mon, 31 Jan 2011 09:35:31 +0100
Subject: password_salt bei pbs_person hinzugefügt

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

(limited to 'pbs.sql')

diff --git a/pbs.sql b/pbs.sql
index 28f9dbe..3374a73 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -67,6 +67,7 @@ CREATE TABLE IF NOT EXISTS `pbs_person` (
   `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
   PRIMARY KEY (`personID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 
-- 
cgit v1.2.3-55-g7522


From 1251380e963a1162f228d24180b17ed43e66c23a Mon Sep 17 00:00:00 2001
From: Simon
Date: Mon, 31 Jan 2011 10:12:20 +0100
Subject: datenbank: email als unique eingetragen

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

(limited to 'pbs.sql')

diff --git a/pbs.sql b/pbs.sql
index 3374a73..6f58829 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

