From cfd8facee6586fadf97be852446b4a03ce08b634 Mon Sep 17 00:00:00 2001 From: vyshane Date: Mon, 24 Apr 2006 07:44:27 +0000 Subject: [PATCH] Added primary key definition for log_display --- lib/db/mysql.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/lib/db/mysql.sql b/lib/db/mysql.sql index 7dc125a843..7bb6b458ec 100644 --- a/lib/db/mysql.sql +++ b/lib/db/mysql.sql @@ -436,7 +436,8 @@ CREATE TABLE `prefix_log_display` ( `module` varchar(20) NOT NULL default '', `action` varchar(20) NOT NULL default '', `mtable` varchar(20) NOT NULL default '', - `field` varchar(40) NOT NULL default '' + `field` varchar(40) NOT NULL default '', + PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='For a particular module/action, specifies a moodle table/field.'; ALTER TABLE prefix_log_display ADD UNIQUE `moduleaction`(`module` , `action`); # -------------------------------------------------------- -- 2.39.5