diff options
| author |  Yalçın Can | 2011-07-27 14:23:37 +0300 |
|---|---|---|
| committer | Yalçın Can | 2011-07-27 14:23:37 +0300 |
| commit | efd842174fdd37f8eb2c460c7adb21954bcfbe9d (patch) | |
| tree | a2ab3cc25db92b901b69ce1bc0ad1dedb5d498ef /data/tables.sql | |
| parent | 8cd40b3d76e191b2fbe95b044f69aed07cc27664 (diff) | |
| parent | 81aa17b8523d95310c90366d9af09767db0c84f2 (diff) | |
| download | scuttle-efd842174fdd37f8eb2c460c7adb21954bcfbe9d.tar.gz scuttle-efd842174fdd37f8eb2c460c7adb21954bcfbe9d.zip | |
Merge remote-tracking branch 'upstream/master'
Diffstat (limited to 'data/tables.sql')
| -rw-r--r-- | data/tables.sql | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/data/tables.sql b/data/tables.sql index d53945e..68d5ba9 100644 --- a/data/tables.sql +++ b/data/tables.sql @@ -72,7 +72,9 @@ CREATE TABLE `sc_users` ( `email` varchar(50) NOT NULL default '', `homepage` varchar(255) default NULL, `uContent` text, - PRIMARY KEY (`uId`) + `privateKey` varchar(33) default NULL, + PRIMARY KEY (`uId`), + UNIQUE KEY `privateKey` (`privateKey`) ) CHARACTER SET utf8 COLLATE utf8_general_ci ; -- -------------------------------------------------------- @@ -84,8 +86,7 @@ CREATE TABLE `sc_users_sslclientcerts` ( `sslClientIssuerDn` VARCHAR( 1024 ) NOT NULL , `sslName` VARCHAR( 64 ) NOT NULL , `sslEmail` VARCHAR( 64 ) NOT NULL , - PRIMARY KEY ( `id` ) , - UNIQUE (`id`) + PRIMARY KEY ( `id` ) ) CHARACTER SET utf8 COLLATE utf8_general_ci; -- |