From bb5186ae277c500614fab54df3255c869af9ec53 Mon Sep 17 00:00:00 2001
From: Michael Vogel <icarus@dabo.de>
Date: Thu, 23 Jul 2015 08:35:45 +0200
Subject: [PATCH] Use an ID as a primary field.
---
include/dbstructure.php | 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)
diff --git a/include/dbstructure.php b/include/dbstructure.php
index c079efeb55..7d6d015a3f 100644
--- a/include/dbstructure.php
+++ b/include/dbstructure.php
@@ -691,6 +691,7 @@ function db_definition() {
);
$database["gserver"] = array(
"fields" => array(
+ "id" => array("type" => "int(10) unsigned", "not null" => "1", "extra" => "auto_increment", "primary" => "1"),
"url" => array("type" => "varchar(255)", "not null" => "1", "default" => ""),
"nurl" => array("type" => "varchar(255)", "not null" => "1", "default" => ""),
"version" => array("type" => "varchar(255)", "not null" => "1", "default" => ""),
@@ -707,7 +708,8 @@ function db_definition() {
"last_failure" => array("type" => "datetime", "default" => "0000-00-00 00:00:00"),
),
"indexes" => array(
- "PRIMARY" => array("nurl"),
+ "PRIMARY" => array("id"),
+ "nurl" => array("nurl"),
)
);
$database["guid"] = array(
--
2.39.5