WordPress.org

Making WordPress.org

Changeset 6260


Ignore:
Timestamp:
12/13/17 00:11:02 (5 weeks ago)
Author:
dd32
Message:

API: Events: Update the CREATE TABLE comment to match the latest schema of the table.

Fixes #3328

File:
1 edited

Legend:

Unmodified
Added
Removed
  • sites/trunk/api.wordpress.org/public_html/events/1.0/index.php

    r6209 r6260  
    886886  `meetup_url` text, 
    887887  `date_utc` datetime NOT NULL, 
     888  `date_utc_offset` varchar(32) DEFAULT NULL, 
    888889  `end_date` datetime NOT NULL, 
    889890  `location` text, 
     891  `country` varchar(64) DEFAULT NULL, 
    890892  `latitude` double NOT NULL, 
    891893  `longitude` double NOT NULL, 
    892894  PRIMARY KEY (`id`), 
    893895  UNIQUE KEY `event_source_id` (`type`,`source_id`), 
    894   KEY `latitude` (`latitude`), 
    895   KEY `longitude` (`longitude`), 
    896   KEY `date` (`date_utc`) 
     896  KEY `date` (`date_utc`), 
     897  KEY `country` (`country`), 
     898  KEY `lat_lon` (`latitude`,`longitude`) 
    897899) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1; 
    898900*/ 
Note: See TracChangeset for help on using the changeset viewer.