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