summaryrefslogtreecommitdiffstats
path: root/pbs.sql
diff options
context:
space:
mode:
authorBjörn Geiger2011-01-31 14:44:05 +0100
committerBjörn Geiger2011-01-31 14:44:05 +0100
commitb15a3bfe1c68c170fed384957a8329ed5f154d36 (patch)
tree9e9d272eb9336b1185819b27ab9d01f0d12a2ff9 /pbs.sql
parentauthForm klappt (diff)
downloadpbs2-b15a3bfe1c68c170fed384957a8329ed5f154d36.tar.gz
pbs2-b15a3bfe1c68c170fed384957a8329ed5f154d36.tar.xz
pbs2-b15a3bfe1c68c170fed384957a8329ed5f154d36.zip
Fehler in SQL korrigiert
Diffstat (limited to 'pbs.sql')
-rw-r--r--pbs.sql4
1 files changed, 2 insertions, 2 deletions
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 ;