Adding Tables to the Database

 

Having created a user and the user's database, we will now add all the needed tables.

Step 1

Select isltest database in the left side of the page, then click the SQL tab.

Step 2

Paste the text below into the provided space and then click Go.

CREATE TABLE sessions_events (
 id bigint NOT NULL AUTO_INCREMENT PRIMARY KEY,
 cpg_session_ident varchar(50) COLLATE utf8_unicode_ci NOT NULL,
 event_type_code varchar(50) COLLATE utf8_unicode_ci NOT NULL,
 fields nvarchar(4000) COLLATE utf8_unicode_ci NULL,
 inserted_date varchar(50) COLLATE utf8_unicode_ci NOT NULL,
 event_date varchar(50) COLLATE utf8_unicode_ci NULL
)

Step 3

Clear the text in the query space, paste all these lines and then click Go.

CREATE TABLE sessions_rawdata (
 id bigint NOT NULL AUTO_INCREMENT PRIMARY KEY,
 cpg_session_ident varchar(50) COLLATE utf8_unicode_ci NOT NULL,
 event_name varchar(50) COLLATE utf8_unicode_ci NULL,
 key_name varchar(5000) COLLATE utf8_unicode_ci NULL,
 key_value nvarchar(4000) COLLATE utf8_unicode_ci NULL
)

Step 4

Clear the text in the query space, paste the text below into the provided space and click Go.

CREATE TABLE pronto_sessions (
 id bigint NOT NULL AUTO_INCREMENT PRIMARY KEY,
 cpg_server_id int NOT NULL,
 cpg_session_db_id varchar(50) COLLATE utf8_unicode_ci NULL,
 cpg_user_domain_name nvarchar(100) COLLATE utf8_unicode_ci NULL,
 cpg_user_name nvarchar(50) COLLATE utf8_unicode_ci NULL,
 start_time varchar(50) COLLATE utf8_unicode_ci NULL,
 stop_time varchar(50) COLLATE utf8_unicode_ci NULL,
 cpg_session_ident varchar(50) COLLATE utf8_unicode_ci NULL,
 status_code varchar(50) COLLATE utf8_unicode_ci NOT NULL,
 created_date varchar(50) COLLATE utf8_unicode_ci NULL,
 customer_email varchar(100) COLLATE utf8_unicode_ci NULL,
 customer_name varchar(50) COLLATE utf8_unicode_ci NULL,
 customer_location varchar(500) COLLATE utf8_unicode_ci NULL,
 supporter_email varchar(100) COLLATE utf8_unicode_ci NULL,
 supporter_name varchar(50) COLLATE utf8_unicode_ci NULL,
 supporter_status varchar(50) COLLATE utf8_unicode_ci NULL,
 customer_satisfied varchar(10) COLLATE utf8_unicode_ci NULL,
 customer_comment varchar(5000) COLLATE utf8_unicode_ci NULL
)

Step 5

Clear the text in the query space, paste the text below into the provided space and click Go.

CREATE TABLE pronto_supporters (
 id bigint NOT NULL AUTO_INCREMENT PRIMARY KEY,
 cpg_server_id int NOT NULL,
 cpg_session_ident varchar(50) COLLATE utf8_unicode_ci NULL,
 cpg_user_domain_name nvarchar(100) COLLATE utf8_unicode_ci NULL,
 cpg_user_name nvarchar(50) COLLATE utf8_unicode_ci NULL,
 supporter_name varchar(50) COLLATE utf8_unicode_ci NULL,
 supporter_email varchar(100) COLLATE utf8_unicode_ci NULL
)

Step 6

Clear the text in the query space, paste the text below into the provided space and click Go.

CREATE TABLE pronto_customers (
 id bigint NOT NULL AUTO_INCREMENT PRIMARY KEY,
 cpg_server_id int NOT NULL,
 cpg_session_ident varchar(50) COLLATE utf8_unicode_ci NULL,
 customer_name varchar(50) COLLATE utf8_unicode_ci NULL,
 customer_email varchar(100) COLLATE utf8_unicode_ci NULL
)

Was this article helpful?