| Index: trunk/extensions/CongressLookup/patches/CongressLookup.sql |
| — | — | @@ -32,9 +32,11 @@ |
| 33 | 33 | ) /*$wgDBTableOptions*/; |
| 34 | 34 | |
| 35 | 35 | CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cl_zip5 ( |
| 36 | | - `clz5_zip` int(5) unsigned NOT NULL PRIMARY KEY, |
| | 36 | + `clz5_id` int(10) unsigned NOT NULL PRIMARY KEY auto_increment, |
| | 37 | + `clz5_zip` int(5) unsigned NOT NULL, |
| 37 | 38 | `clz5_rep_id` int(10) unsigned DEFAULT NULL |
| 38 | 39 | ) /*$wgDBTableOptions*/; |
| | 40 | +CREATE INDEX /*i*/clz5_zip ON /*$wgDBprefix*/cl_zip5 (clz5_zip); |
| 39 | 41 | |
| 40 | 42 | CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cl_zip9 ( |
| 41 | 43 | `clz9_zip` int(9) unsigned NOT NULL PRIMARY KEY, |