b.sam-server.7.2.1.source-code.create_mysql.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of sam-server Show documentation

There is a newer version: 8.0.1.R2024-05-RT

--
-- #%L
-- Service Activity Monitoring :: Server
-- %%
-- Copyright (C) 2011-2019 Talend Inc.
-- %%
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
--      http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
-- #L%
--

CREATE TABLE EVENTS (
ID BIGINT NOT NULL,
EI_TIMESTAMP DATETIME,
EI_EVENT_TYPE VARCHAR(255),
ORIG_CUSTOM_ID VARCHAR(255),
ORIG_PROCESS_ID VARCHAR(255),
ORIG_HOSTNAME VARCHAR(128),
ORIG_IP VARCHAR(64),
ORIG_PRINCIPAL VARCHAR(255),
MI_PORT_TYPE VARCHAR(255),
MI_OPERATION_NAME VARCHAR(255),
MI_MESSAGE_ID VARCHAR(255),
MI_FLOW_ID VARCHAR(64),
MI_TRANSPORT_TYPE VARCHAR(255),
MESSAGE_CONTENT LONGTEXT,
CONTENT_CUT BOOLEAN,
PRIMARY KEY (ID));

CREATE TABLE EVENTS_CUSTOMINFO (
ID BIGINT NOT NULL,
EVENT_ID BIGINT NOT NULL,
CUST_KEY VARCHAR(255),
CUST_VALUE VARCHAR(255),
PRIMARY KEY (ID));

CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME));
INSERT INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values ('EVENT_SEQ', 0);
COMMIT;