diff options
| author | zottel <github@zottel.net> | 2012-04-08 10:33:32 +0200 |
|---|---|---|
| committer | zottel <github@zottel.net> | 2012-04-08 10:33:32 +0200 |
| commit | aaf5a81365b4cbcb3d1b9537b5544aeb5de66f4b (patch) | |
| tree | 1d7e5f2b575b8836fefe76660f466cb176585d5c /database.sql | |
| parent | 64a1367525ac920721943a08adec1124657df70d (diff) | |
| parent | e3b2ac0735c908357dafb8670339fd34d3e2e6c0 (diff) | |
| download | volse-hubzilla-aaf5a81365b4cbcb3d1b9537b5544aeb5de66f4b.tar.gz volse-hubzilla-aaf5a81365b4cbcb3d1b9537b5544aeb5de66f4b.tar.bz2 volse-hubzilla-aaf5a81365b4cbcb3d1b9537b5544aeb5de66f4b.zip | |
Merge remote branch 'upstream/master'
Diffstat (limited to 'database.sql')
| -rw-r--r--[-rwxr-xr-x] | database.sql | 14 |
1 files changed, 8 insertions, 6 deletions
diff --git a/database.sql b/database.sql index a271e5491..010c63bb2 100755..100644 --- a/database.sql +++ b/database.sql @@ -34,10 +34,11 @@ CREATE TABLE IF NOT EXISTS `challenge` ( CREATE TABLE IF NOT EXISTS `config` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `cat` char(255) NOT NULL, - `k` char(255) NOT NULL, + `cat` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL, + `k` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL, `v` text NOT NULL, - PRIMARY KEY (`id`) + PRIMARY KEY (`id`), + UNIQUE KEY `access`(`cat`,`k`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -542,9 +543,10 @@ INDEX ( `batch` ) CREATE TABLE IF NOT EXISTS `pconfig` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `uid` INT NOT NULL DEFAULT '0', -`cat` CHAR( 255 ) NOT NULL , -`k` CHAR( 255 ) NOT NULL , -`v` MEDIUMTEXT NOT NULL +`cat` CHAR( 255 ) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL , +`k` CHAR( 255 ) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL , +`v` MEDIUMTEXT NOT NULL, +UNIQUE KEY `access`(`cat`, `k`) ) ENGINE = MyISAM DEFAULT CHARSET=utf8; |