| Index: trunk/extensions/CongressLookup/patches/CongressLookup.sql |
| — | — | @@ -1,14 +1,14 @@ |
| 2 | 2 | CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/cl_senate ( |
| 3 | | - `ss_id` int(10) unsigned NOT NULL, |
| 4 | | - `ss_bioguideid` varchar(32) NOT NULL, |
| 5 | | - `ss_gender` varchar(1) NOT NULL, |
| 6 | | - `ss_name` varchar(255) NOT NULL, |
| 7 | | - `ss_title` varchar(8) NOT NULL, |
| 8 | | - `ss_state` varchar(2) NOT NULL, |
| 9 | | - `ss_phone` varchar(32) NOT NULL, |
| 10 | | - `ss_fax` varchar(32) NOT NULL, |
| 11 | | - `ss_contactform` varchar(255) NOT NULL, |
| 12 | | - PRIMARY KEY (`ss_id`) |
| | 3 | + `ss_id` int(10) unsigned NOT NULL, |
| | 4 | + `ss_bioguideid` varchar(32) NOT NULL, |
| | 5 | + `ss_gender` varchar(1) NOT NULL, |
| | 6 | + `ss_name` varchar(255) NOT NULL, |
| | 7 | + `ss_title` varchar(8) NOT NULL, |
| | 8 | + `ss_state` varchar(2) NOT NULL, |
| | 9 | + `ss_phone` varchar(32) NOT NULL, |
| | 10 | + `ss_fax` varchar(32) NOT NULL, |
| | 11 | + `ss_contactform` varchar(255) NOT NULL, |
| | 12 | +PRIMARY KEY (`ss_id`) |
| 13 | 13 | ) /*$wgDBTableOptions*/; |
| 14 | 14 | CREATE INDEX /*i*/ss_state ON /*$wgDBprefix*/sopa_senate (ss_state); |
| 15 | 15 | |