appserver/tests/appserv-tests/devtests/jdbc/stmtCaching_hit_miss.monitoring/sql/create_pointbase.sql

drop table customer_stmt_wrapper1;
drop table customer_stmt_wrapper2;
drop table customer_stmt_wrapper3;
drop table customer_stmt_wrapper4;
drop table customer_stmt_wrapper5;
drop table customer_stmt_wrapper6;
drop table customer_stmt_wrapper7;
drop table customer_stmt_wrapper8;
drop table customer_stmt_wrapper9;
drop table customer_stmt_wrapper10;
CREATE TABLE customer_stmt_wrapper1 (
    c_id            integer not null,
    c_phone         char(16),
    c_id3            integer not null,
    c_id4            integer not null,
    c_id5            integer not null,
    c_id6            integer not null,
    c_id7            integer not null,
    c_id8            integer not null,
    c_id9            integer not null,
    c_id10            integer not null

);

INSERT INTO customer_stmt_wrapper1 VALUES(2, 'iiop', 3, 4, 5, 6, 7, 8, 9, 10);

CREATE TABLE customer_stmt_wrapper2 (
    c_id            integer not null,
    c_phone         char(16),
    c_id3            integer not null,
    c_id4            integer not null,
    c_id5            integer not null,
    c_id6            integer not null,
    c_id7            integer not null,
    c_id8            integer not null,
    c_id9            integer not null,
    c_id10            integer not null
);

INSERT INTO customer_stmt_wrapper2 VALUES(2, 'iiop', 3, 4, 5, 6, 7, 8, 9, 10);

CREATE TABLE customer_stmt_wrapper3 (
    c_id            integer not null,
    c_phone         char(16),
    c_id3            integer not null,
    c_id4            integer not null,
    c_id5            integer not null,
    c_id6            integer not null,
    c_id7            integer not null,
    c_id8            integer not null,
    c_id9            integer not null,
    c_id10            integer not null
);

INSERT INTO customer_stmt_wrapper3 VALUES(2, 'iiop', 3, 4, 5, 6, 7, 8, 9, 10);
CREATE TABLE customer_stmt_wrapper4 (
    c_id            integer not null,
    c_phone         char(16),
    c_id3            integer not null,
    c_id4            integer not null,
    c_id5            integer not null,
    c_id6            integer not null,
    c_id7            integer not null,
    c_id8            integer not null,
    c_id9            integer not null,
    c_id10            integer not null
);

INSERT INTO customer_stmt_wrapper4 VALUES(2, 'iiop', 3, 4, 5, 6, 7, 8, 9, 10);

CREATE TABLE customer_stmt_wrapper5 (
    c_id            integer not null,
    c_phone         char(16),
    c_id3            integer not null,
    c_id4            integer not null,
    c_id5            integer not null,
    c_id6            integer not null,
    c_id7            integer not null,
    c_id8            integer not null,
    c_id9            integer not null,
    c_id10            integer not null
);

INSERT INTO customer_stmt_wrapper5 VALUES(2, 'iiop', 3, 4, 5, 6, 7, 8, 9, 10);



CREATE TABLE customer_stmt_wrapper6 (
    c_id            integer not null,
    c_phone         char(16),
    c_id3            integer not null,
    c_id4            integer not null,
    c_id5            integer not null,
    c_id6            integer not null,
    c_id7            integer not null,
    c_id8            integer not null,
    c_id9            integer not null,
    c_id10            integer not null
);

INSERT INTO customer_stmt_wrapper6 VALUES(2, 'iiop', 3, 4, 5, 6, 7, 8, 9, 10);

CREATE TABLE customer_stmt_wrapper7 (
    c_id            integer not null,
    c_phone         char(16),
    c_id3            integer not null,
    c_id4            integer not null,
    c_id5            integer not null,
    c_id6            integer not null,
    c_id7            integer not null,
    c_id8            integer not null,
    c_id9            integer not null,
    c_id10            integer not null
);

INSERT INTO customer_stmt_wrapper7 VALUES(2, 'iiop', 3, 4, 5, 6, 7, 8, 9, 10);

CREATE TABLE customer_stmt_wrapper8 (
    c_id            integer not null,
    c_phone         char(16),
    c_id3            integer not null,
    c_id4            integer not null,
    c_id5            integer not null,
    c_id6            integer not null,
    c_id7            integer not null,
    c_id8            integer not null,
    c_id9            integer not null,
    c_id10            integer not null
);

INSERT INTO customer_stmt_wrapper8 VALUES(2, 'iiop', 3, 4, 5, 6, 7, 8, 9, 10);

CREATE TABLE customer_stmt_wrapper9 (
    c_id            integer not null,
    c_phone         char(16),
    c_id3            integer not null,
    c_id4            integer not null,
    c_id5            integer not null,
    c_id6            integer not null,
    c_id7            integer not null,
    c_id8            integer not null,
    c_id9            integer not null,
    c_id10            integer not null
);

INSERT INTO customer_stmt_wrapper9 VALUES(2, 'iiop', 3, 4, 5, 6, 7, 8, 9, 10);

CREATE TABLE customer_stmt_wrapper10 (
    c_id            integer not null,
    c_phone         char(16),
    c_id3            integer not null,
    c_id4            integer not null,
    c_id5            integer not null,
    c_id6            integer not null,
    c_id7            integer not null,
    c_id8            integer not null,
    c_id9            integer not null,
    c_id10            integer not null
);

INSERT INTO customer_stmt_wrapper10 VALUES(2, 'iiop', 3, 4, 5, 6, 7, 8, 9, 10);