| 
      
            Lines 526-531
          DROP TABLE IF EXISTS `cities`;
      
      
        Link Here
      
     | 
  
        
          | 526 | 
          CREATE TABLE `cities` (  | 
          526 | 
          CREATE TABLE `cities` (  | 
        
        
          | 527 | 
            `cityid` int(11) NOT NULL auto_increment,  | 
          527 | 
            `cityid` int(11) NOT NULL auto_increment,  | 
        
        
          | 528 | 
            `city_name` varchar(100) NOT NULL default '',  | 
          528 | 
            `city_name` varchar(100) NOT NULL default '',  | 
        
            
               | 
               | 
              529 | 
                `city_state` VARCHAR( 100 ) NULL DEFAULT NULL,  | 
            
            
              | 530 | 
                `city_country` VARCHAR( 100 ) NULL DEFAULT NULL,  | 
            
        
          | 529 | 
            `city_zipcode` varchar(20) default NULL,  | 
          531 | 
            `city_zipcode` varchar(20) default NULL,  | 
        
        
          | 530 | 
            PRIMARY KEY  (`cityid`)  | 
          532 | 
            PRIMARY KEY  (`cityid`)  | 
        
        
          | 531 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8;  | 
          533 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8;  | 
        
            
              | 532 | 
              -   | 
               | 
               |