Skip to content

Instantly share code, notes, and snippets.

@kadai

kadai/monarch.sql

Created April 19, 2018 03:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kadai/06293af4255e6f1a3ac237dcc5dad862 to your computer and use it in GitHub Desktop.
Save kadai/06293af4255e6f1a3ac237dcc5dad862 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
monarch.sql
CREATE TABLE $tableprefix_et_social_stats (
id mediumint(9) NOT NULL AUTO_INCREMENT,
sharing_date datetime DEFAULT '1000-01-01 00:00:00' NOT NULL,
network varchar(20) NOT NULL,
action varchar(10) NOT NULL,
post_id bigint(20) NOT NULL,
ip_address varchar(45) NOT NULL,
media_url varchar(2083) NOT NULL,
location varchar(20) NOT NULL,
UNIQUE KEY id (id)) DEFAULT CHARACTER SET utf8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment