From eb62181cba61aaf86dbeb500f5a0835455bed230 Mon Sep 17 00:00:00 2001 From: freakolowsky Date: Sun, 26 May 2013 12:14:58 +0200 Subject: [PATCH] Updated profiling table definition. Change-Id: I20e92f2bc9b57a9c06cbcdfd30370fedf3c0e2f7 --- maintenance/oracle/tables.sql | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) diff --git a/maintenance/oracle/tables.sql b/maintenance/oracle/tables.sql index 0f6f3655b9..74fb1b107b 100644 --- a/maintenance/oracle/tables.sql +++ b/maintenance/oracle/tables.sql @@ -636,10 +636,11 @@ ALTER TABLE &mw_prefix.valid_tag ADD CONSTRAINT &mw_prefix.valid_tag_pk PRIMARY -- This table is not used unless profiling is turned on --CREATE TABLE &mw_prefix.profiling ( --- pf_count NUMBER DEFAULT 0 NOT NULL, --- pf_time NUMERIC(18,10) DEFAULT 0 NOT NULL, --- pf_name CLOB NOT NULL, --- pf_server CLOB NULL +-- pf_count NUMBER DEFAULT 0 NOT NULL, +-- pf_time NUMBER(18,10) DEFAULT 0 NOT NULL, +-- pf_memory NUMBER(18,10) DEFAULT 0 NOT NULL, +-- pf_name VARCHAR2(255), +-- pf_server VARCHAR2(30) --); --CREATE UNIQUE INDEX &mw_prefix.profiling_u01 ON &mw_prefix.profiling (pf_name, pf_server); -- 2.20.1