summaryrefslogtreecommitdiffstats
path: root/scripts/sys_schema/tables
diff options
context:
space:
mode:
Diffstat (limited to 'scripts/sys_schema/tables')
-rw-r--r--scripts/sys_schema/tables/sys_config.sql29
-rw-r--r--scripts/sys_schema/tables/sys_config_data.sql23
-rw-r--r--scripts/sys_schema/tables/sys_config_data_57.sql26
3 files changed, 78 insertions, 0 deletions
diff --git a/scripts/sys_schema/tables/sys_config.sql b/scripts/sys_schema/tables/sys_config.sql
new file mode 100644
index 00000000..37d0a183
--- /dev/null
+++ b/scripts/sys_schema/tables/sys_config.sql
@@ -0,0 +1,29 @@
+-- Copyright (c) 2014, 2015, Oracle and/or its affiliates. All rights reserved.
+--
+-- This program is free software; you can redistribute it and/or modify
+-- it under the terms of the GNU General Public License as published by
+-- the Free Software Foundation; version 2 of the License.
+--
+-- This program is distributed in the hope that it will be useful,
+-- but WITHOUT ANY WARRANTY; without even the implied warranty of
+-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+-- GNU General Public License for more details.
+--
+-- You should have received a copy of the GNU General Public License
+-- along with this program; if not, write to the Free Software
+-- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
+
+--
+-- Table: sys_config
+--
+-- Stores configuration options for sys objects
+--
+
+CREATE TABLE IF NOT EXISTS sys_config (
+ variable VARCHAR(128) PRIMARY KEY,
+ value VARCHAR(128),
+ set_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ set_by VARCHAR(128)
+) ENGINE = Aria;
+
+
diff --git a/scripts/sys_schema/tables/sys_config_data.sql b/scripts/sys_schema/tables/sys_config_data.sql
new file mode 100644
index 00000000..fb322fc7
--- /dev/null
+++ b/scripts/sys_schema/tables/sys_config_data.sql
@@ -0,0 +1,23 @@
+-- Copyright (c) 2015 Oracle and/or its affiliates. All rights reserved.
+--
+-- This program is free software; you can redistribute it and/or modify
+-- it under the terms of the GNU General Public License as published by
+-- the Free Software Foundation; version 2 of the License.
+--
+-- This program is distributed in the hope that it will be useful,
+-- but WITHOUT ANY WARRANTY; without even the implied warranty of
+-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+-- GNU General Public License for more details.
+--
+-- You should have received a copy of the GNU General Public License
+-- along with this program; if not, write to the Free Software
+-- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
+
+-- NOTE: This needs to be replicated within the sys_config_clean.inc file
+
+INSERT IGNORE INTO sys.sys_config (variable, value) VALUES
+ ('statement_truncate_len', 64),
+ ('statement_performance_analyzer.limit', 100),
+ ('statement_performance_analyzer.view', NULL),
+ ('diagnostics.allow_i_s_tables', 'OFF'),
+ ('diagnostics.include_raw', 'OFF');
diff --git a/scripts/sys_schema/tables/sys_config_data_57.sql b/scripts/sys_schema/tables/sys_config_data_57.sql
new file mode 100644
index 00000000..4abbb0b1
--- /dev/null
+++ b/scripts/sys_schema/tables/sys_config_data_57.sql
@@ -0,0 +1,26 @@
+-- Copyright (c) 2015 Oracle and/or its affiliates. All rights reserved.
+--
+-- This program is free software; you can redistribute it and/or modify
+-- it under the terms of the GNU General Public License as published by
+-- the Free Software Foundation; version 2 of the License.
+--
+-- This program is distributed in the hope that it will be useful,
+-- but WITHOUT ANY WARRANTY; without even the implied warranty of
+-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+-- GNU General Public License for more details.
+--
+-- You should have received a copy of the GNU General Public License
+-- along with this program; if not, write to the Free Software
+-- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
+
+-- NOTE: This needs to be replicated within the sys_config_clean.inc file
+
+INSERT IGNORE INTO sys.sys_config (variable, value) VALUES
+ ('statement_truncate_len', 64),
+ ('statement_performance_analyzer.limit', 100),
+ ('statement_performance_analyzer.view', NULL),
+ ('diagnostics.allow_i_s_tables', 'OFF'),
+ ('diagnostics.include_raw', 'OFF'),
+ ('ps_thread_trx_info.max_length', 65535);
+
+FLUSH TABLES sys.sys_config;