-- MySQL dump 9.10 -- -- Host: localhost Database: crash -- ------------------------------------------------------ -- Server version 4.0.18-standard-log DROP TABLE IF EXISTS Event; CREATE TABLE Event ( ID bigint(20) NOT NULL auto_increment, attraction bigint(20) NOT NULL default '-1', business bigint(20) NOT NULL default '-1', attractionListing bigint(20) NOT NULL default '-1', feed bigint(20) NOT NULL default '-1', PRIMARY KEY (ID), KEY attraction (attraction), KEY business (business), KEY attractionListing (attractionListing), KEY feed (feed) ) TYPE=MyISAM; INSERT INTO Event VALUES (1,1,1,1,1); DROP TABLE IF EXISTS Listing; CREATE TABLE Listing ( ID bigint(20) NOT NULL auto_increment, business bigint(20) NOT NULL default '-1', feed bigint(20) NOT NULL default '-1', feedId varchar(255) NOT NULL default '', hashKey bigint(20) NOT NULL default '-1', PRIMARY KEY (ID), KEY business (business), KEY feed (feed), KEY feedID (feedId), KEY hashKey (hashKey) ) TYPE=MyISAM; INSERT INTO Listing VALUES (1,1,1,'11111',73732500); INSERT INTO Listing VALUES (2,2,1,'22222',73732500);