| Index: trunk/extensions/CongressLookup/patches/CongressLookup.sql |
| — | — | @@ -27,11 +27,9 @@ |
| 28 | 28 | ) /*$wgDBTableOptions*/; |
| 29 | 29 | |
| 30 | 30 | CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cl_zip3 ( |
| 31 | | - `clz3_id` int(10) unsigned NOT NULL PRIMARY KEY auto_increment, |
| 32 | | - `clz3_zip` int(3) unsigned NOT NULL, |
| | 31 | + `clz3_zip` int(3) unsigned NOT NULL PRIMARY KEY, |
| 33 | 32 | `clz3_state` varchar(2) DEFAULT NULL |
| 34 | 33 | ) /*$wgDBTableOptions*/; |
| 35 | | -CREATE INDEX /*i*/clz3_zip ON /*$wgDBprefix*/cl_zip3 (clz3_zip); |
| 36 | 34 | |
| 37 | 35 | CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cl_zip5 ( |
| 38 | 36 | `clz5_id` int(10) unsigned NOT NULL PRIMARY KEY auto_increment, |