| Index: trunk/extensions/CongressLookup/patches/CongressLookup.sql |
| — | — | @@ -9,7 +9,7 @@ |
| 10 | 10 | `ss_fax` varchar(32) NOT NULL, |
| 11 | 11 | `ss_contactform` varchar(255) NOT NULL |
| 12 | 12 | ) /*$wgDBTableOptions*/; |
| 13 | | -CREATE INDEX /*i*/ss_state ON /*$wgDBprefix*/sopa_senate (ss_state); |
| | 13 | +CREATE INDEX /*i*/ss_state ON /*$wgDBprefix*/cl_senate (ss_state); |
| 14 | 14 | |
| 15 | 15 | CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cl_house ( |
| 16 | 16 | `sh_id` int(10) unsigned NOT NULL PRIMARY KEY, |
| — | — | @@ -25,7 +25,7 @@ |
| 26 | 26 | ) /*$wgDBTableOptions*/; |
| 27 | 27 | |
| 28 | 28 | CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cl_zip3 ( |
| 29 | | - `sz3_zip` int(3) unsigned DEFAULT NULL PRIMARY KEY, |
| | 29 | + `sz3_zip` int(3) unsigned NOT NULL PRIMARY KEY, |
| 30 | 30 | `sz3_state` varchar(2) DEFAULT NULL |
| 31 | 31 | ) /*$wgDBTableOptions*/; |
| 32 | 32 | |