|
Revision 5069, 0.6 kB
(checked in by p_lindheimer, 1 year ago)
|
#1767 add weather to contributed module repository
|
| Line | |
|---|
| 1 |
CREATE TABLE IF NOT EXISTS `zipcodes` ( |
|---|
| 2 |
`id` mediumint(6) NOT NULL auto_increment, |
|---|
| 3 |
`zip` varchar(5) NOT NULL default '', |
|---|
| 4 |
`latitude` varchar(11) NOT NULL default '', |
|---|
| 5 |
`longitude` varchar(11) NOT NULL default '', |
|---|
| 6 |
`city` varchar(40) NOT NULL default '', |
|---|
| 7 |
`state` char(2) NOT NULL default '', |
|---|
| 8 |
`fullstate` varchar(30) NOT NULL default '', |
|---|
| 9 |
`county` varchar(40) NOT NULL default '', |
|---|
| 10 |
`zipclass` varchar(20) NOT NULL default '', |
|---|
| 11 |
PRIMARY KEY (`id`), |
|---|
| 12 |
KEY `zip` (`zip`), |
|---|
| 13 |
KEY `city` (`city`,`state`), |
|---|
| 14 |
KEY `state` (`state`,`city`) |
|---|
| 15 |
) ENGINE=MyISAM DEFAULT CHARSET=ascii AUTO_INCREMENT=42742; |
|---|
