summaryrefslogtreecommitdiffstats
path: root/pbs.sql
diff options
context:
space:
mode:
Diffstat (limited to 'pbs.sql')
-rw-r--r--pbs.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/pbs.sql b/pbs.sql
index 6c60837..aa8ba1c 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -232,6 +232,7 @@ CREATE TABLE IF NOT EXISTS `pbs_poolentries` (
KEY `poolID` (`poolID`),
KEY `clientID` (`clientID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
+ALTER TABLE `pbs_poolentries` ADD `poolentriesID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
ALTER TABLE `pbs_poolentries`
ADD CONSTRAINT `pbs_poolentries_ibfk_1` FOREIGN KEY (`poolID`) REFERENCES `pbs_pool` (`poolID`) ON DELETE CASCADE,