version1.txt

Connected to SQLite
select * from mysql.user;
Column Wildcard Usage DML
----------------
CREATE TABLE payload (name text, value blob);
No Primary Key DDL
----------------
CREATE TABLE privilege ( user_id char(20) NOT NULL DEFAULT '', rightstr char(30) NOT NULL DEFAULT '', defunct char(1) NOT NULL DEFAULT 'N')
No Primary Key DDL
----------------
SELECT * FROM wpdb_prefix_options WHERE option_name LIKE '_transient_wowcharcache%'
Column Wildcard Usage DML
----------------
CREATE TABLE contest_problem ( problem_id int(11) NOT NULL DEFAULT '0', contest_id int(11) DEFAULT NULL, title varchar(200) DEFAULT NULL, num int(11) NOT NULL DEFAULT '0')
No Primary Key DDL
----------------
SELECT * FROM harmony_access_records WHERE (entity_id = 0 OR entity_id = 123) AND grant_view = 1 AND entity_type = 'type'
Column Wildcard Usage DML
----------------
create table external_group_mapping ( group_id varchar(36) not null, external_group varchar(255) not null, added timestamp default current_timestamp not null, primary key (group_id, external_group)); select identity_zone_id from users where authz_approvals.user_id = users.id);
Multi-valued Attribute DDL
----------------
create table external_group_mapping ( group_id varchar(36) not null, external_group varchar(255) not null, added timestamp default current_timestamp not null, primary key (group_id, external_group)); select identity_zone_id from users where authz_approvals.user_id = users.id);
Multi-valued Attribute DDL
----------------
create table external_group_mapping ( group_id varchar(36) not null, external_group varchar(255) not null, added timestamp default current_timestamp not null, primary key (group_id, external_group)); select identity_zone_id from users where authz_approvals.user_id = users.id);
Multi-valued Attribute DDL
----------------
insert into trigtest values (5)
Implicit Columns DML
----------------
CREATE TABLE gpkg_contents (table_name TEXT NOT NULL PRIMARY KEY,data_type TEXT NOT NULL,identifier TEXT UNIQUE,description TEXT DEFAULT '',last_change DATETIME NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ',CURRENT_TIMESTAMP)),min_x DOUBLE,min_y DOUBLE,max_x DOUBLE,max_y DOUBLE,srs_id INTEGER,CONSTRAINT fk_gc_r_srid FOREIGN KEY (srs_id) REFERENCES gpkg_spatial_ref_sys(srs_id))
God Table DDL
----------------
create table child2 (id1 integer, id2 integer, foreign key(id2, id1) references parent(id2, id1))
Data In Metadata DDL
----------------
create table test (id integer primary key, fn float default 0.0, sn not null)
Generic Primary Key DDL
----------------
SELECT name FROM SQLITE_MASTER WHERE type = 'table' AND name = NEW.table_name AND sql LIKE ('%' || NEW.column_name || '%')
Pattern Matching DML
----------------
CREATE TABLE abc (curve_id INTEGER NOT NULL,edge_code TEXT NOT NULL,orientation TEXT,CONSTRAINT pk_curves PRIMARY KEY (curve_id, edge_code))
No Foreign Key DDL
----------------
CREATE TABLE IF NOT EXISTS sql_statements_log (id INTEGER PRIMARY KEY AUTOINCREMENT,time_start TIMESTAMP NOT NULL DEFAULT '0000-01-01T00:00:00.000Z',time_end TIMESTAMP NOT NULL DEFAULT '0000-01-01T00:00:00.000Z',user_agent TEXT NOT NULL,sql_statement TEXT NOT NULL,success INTEGER NOT NULL DEFAULT 0,error_cause TEXT NOT NULL DEFAULT 'ABORTED',CONSTRAINT sqllog_success CHECK (success IN (0,1)))
Enumerated Types DDL
----------------
Total queries are:   22
The Sqlite connection is closed