X-Git-Url: http://git.euphorik.ch/?p=cl7.git;a=blobdiff_plain;f=php%2Fupdate_db.php;h=c094a9e1e983f34309e65c9d6b078b01d53714b1;hp=5ff59047cb7ed9de31d748fcedc7ad3a5256045c;hb=9f4608bb190f3cd49c45aefbb4076182a1449cf8;hpb=82d6311c3924dd70a8fde64435b2490d5a121cde diff --git a/php/update_db.php b/php/update_db.php index 5ff5904..c094a9e 100644 --- a/php/update_db.php +++ b/php/update_db.php @@ -87,6 +87,7 @@ function update_db() if ($version == 1) { mysql_query("BEGIN TRANSACTION"); + mysql_query("ALTER TABLE participants ADD CONSTRAINT UNIQUE INDEX pseudo_unique (pseudo);"); mysql_query(" CREATE TABLE IF NOT EXISTS periodes ( id mediumint(3) unsigned NOT NULL auto_increment,