WordPress.org

Making WordPress.org

Changeset 6260


Ignore:
Timestamp:
12/13/2017 12:11:02 AM (7 months 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.