Code: Select all
CREATE TABLE IF NOT EXISTS `membership_userrecords` (
`recID` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`tableName` VARCHAR(100),
`pkValue` VARCHAR(255),
`memberID` VARCHAR(100),
`dateAdded` BIGINT UNSIGNED,
`dateUpdated` BIGINT UNSIGNED,
`groupID` INT UNSIGNED,
PRIMARY KEY (`recID`),
UNIQUE INDEX `tableName_pkValue` (`tableName`, `pkValue`(150)),
INDEX `pkValue` (`pkValue`),
INDEX `tableName` (`tableName`),
INDEX `memberID` (`memberID`),
INDEX `groupID` (`groupID`)
)