CREATE TABLE Listings (ListingId int(11) NOT NULL auto_increment, ListingTypeId int(11) default '0', ItemResourceId int(11) default NULL, PurchasedOn int(11) default NULL, ExpiresOn int(11) default NULL, Status tinyint(4) default '0', PRIMARY KEY (ListingId) ); CREATE TABLE ListingTypes ( ListingTypeId int(11) NOT NULL auto_increment, Name varchar(255) NOT NULL default '', Duration int(11) NOT NULL default '0', DurationType int(11) NOT NULL default '0', OnPurchaseEdPick tinyint(4) NOT NULL default '3', OnPurchaseNew tinyint(4) NOT NULL default '3', OnPurchasePop tinyint(4) NOT NULL default '3', OnPurchaseHot tinyint(4) NOT NULL default '3', OnPurchasePriorityAction tinyint(4) NOT NULL default '0', OnPurchasePriorityValue tinyint(4) NOT NULL default '1', OnPurchaseAddToCat int(11) NOT NULL default '0', OnExpireEdPick tinyint(4) NOT NULL default '3', OnExpireNew tinyint(4) NOT NULL default '3', OnExpirePop tinyint(4) NOT NULL default '3', OnExpireHot tinyint(4) NOT NULL default '3', OnExpirePriorityAction tinyint(4) NOT NULL default '0', OnExpirePriorityValue tinyint(4) NOT NULL default '1', OnExpireRemoveFromCat int(11) NOT NULL default '0', PRIMARY KEY (ListingTypeId) ); UPDATE Modules SET Version = '3.1.0' WHERE Name = 'In-Link';