UNIQUE INDEX `userid_url` (`url_userid`, `url`),
INDEX `status_userid` (`url_status`, `url_userid`),
INDEX (`url_package_id`)",
UNIQUE INDEX `userid_url` (`url_userid`, `url`),
INDEX `status_userid` (`url_status`, `url_userid`),
INDEX (`url_package_id`)",
`package_points_reward` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
PRIMARY KEY (`package_id`),
UNIQUE INDEX `package` (`package_reload`, `package_waiting`)",
`package_points_reward` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
PRIMARY KEY (`package_id`),
UNIQUE INDEX `package` (`package_reload`, `package_waiting`)",
PRIMARY KEY (`locks_id`),
UNIQUE INDEX `userid_url` (`locks_userid`, `locks_url_id`),
INDEX (`locks_url_id`)",
PRIMARY KEY (`locks_id`),
UNIQUE INDEX `userid_url` (`locks_userid`, `locks_url_id`),
INDEX (`locks_url_id`)",
PRIMARY KEY (`salts_id`),
UNIQUE INDEX `salts_userid_url` (`salts_userid`, `salts_url_id`),
INDEX (`salts_url_id`)",
PRIMARY KEY (`salts_id`),
UNIQUE INDEX `salts_userid_url` (`salts_userid`, `salts_url_id`),
INDEX (`salts_url_id`)",
PRIMARY KEY (`stats_id`),
UNIQUE INDEX `userid_url` (`stats_userid`, `stats_url_id`),
INDEX (`stats_url_id`)",
PRIMARY KEY (`stats_id`),
UNIQUE INDEX `userid_url` (`stats_userid`, `stats_url_id`),
INDEX (`stats_url_id`)",
`actions_new_status` ENUM('PENDING', 'ACTIVE', 'LOCKED', 'STOPPED', 'REJECTED', 'DELETED', 'MIGRATED', 'DEPLETED') NULL DEFAULT NULL,
PRIMARY KEY (`actions_id`),
UNIQUE INDEX `status_action` (`actions_status`, `actions_action`)",
`actions_new_status` ENUM('PENDING', 'ACTIVE', 'LOCKED', 'STOPPED', 'REJECTED', 'DELETED', 'MIGRATED', 'DEPLETED') NULL DEFAULT NULL,
PRIMARY KEY (`actions_id`),
UNIQUE INDEX `status_action` (`actions_status`, `actions_action`)",
// Member actions
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`, `actions_action`, `actions_new_status`) VALUES ('PENDING', 'RETREAT', 'DELETED')");
// Member actions
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_surfbar_actions` (`actions_status`, `actions_action`, `actions_new_status`) VALUES ('PENDING', 'RETREAT', 'DELETED')");