# SQL query information
#
# <!> delimiter [ ; ]
#
# 1:check_query_file
# 2:db user
# 3:db name
# 4:query
# 5:grep
#
# [ check ]

access_ctl_alter_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.columns WHERE table_name ='access_ctl' AND column_name='delete_no' OR column_name='invalid_no';2;
access_ctl_update_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM access_ctl;0;
access_ctl_update_table_3.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM access_ctl;0;
access_ctl_alter_table_4.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.columns WHERE table_name ='access_ctl' AND column_name='delete_no' OR column_name='invalid_no';0;
access_ctl_alter_table_5.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='access_ctl_pkey' OR constraint_name='access_ctl_ukey1' OR constraint_name='access_ctl_ukey2';3;
access_level_alter_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='access_level_pkey';1;
client_use_group_alter_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='client_use_group_pkey';1;
ctrantbl_alter_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='ctrantbl_pkey';1;
display_privilege_alter_table_4.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='display_privilege_pkey';1;
display_privilege_update_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM display_privilege WHERE item IN ('user_list.group','user_input.group','admin_menu.group','admin_menu.gsb','user_list.sso_btn','admin_menu.vgroup','admin_menu.password','password_policy_impossible_btn','password_policy_fixpwinfo_btn','password_policy_analyzer_btn','password_policy_info_btn','admin_menu.radius_client','user_list.domain_clear_btn','admin_menu.samlsp','user_plural_input.group');0;
display_privilege_update_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM display_privilege WHERE item IN ('user_list.group');0;
display_privilege_insert_3.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM pg_class WHERE relname='display_privilege';0;
groupmaster_alter_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM pg_class WHERE relname='groupmaster';0;
groupmaster_update_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM groupmaster WHERE realm IS NULL;0;
groupmaster_update_table_3.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM groupmaster;0;
groupmaster_update_table_4.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM groupmaster;0;
groupmaster_update_table_5.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM groupmaster;0;
groupmaster_update_table_6.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM groupmaster;0;
groupmaster_update_table_7.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM groupmaster WHERE group_id=100;0;
groupmaster_update_table_8.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM groupmaster WHERE group_id=1 OR group_id=2;0;
groupmaster_alter_table_9.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM pg_class WHERE relname='groupmaster';0;
groupmaster_alter_table_10.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='groupmaster_pkey' OR constraint_name='groupmaster_ukey';2;
groupmaster_alter_sequence_10.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM pg_class c WHERE c.relkind = 'S' AND c.relname='group_id';0;
grp_permit_alter_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='grp_permit_pkey';1;
handler_privilege_alter_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='handler_privilege_pkey';1;
handler_privilege_update_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM handler_privilege;0;
handler_privilege_insert_3.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM pg_class WHERE relname='handler_privilege';0;
news_alter_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='news_pkey';1;
news_update_table_3.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM news WHERE news_title='db.noNews';0;
panel_customize_alter_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='panel_customize_pkey';1;
panel_customize_update_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM panel_customize WHERE update_id != 'SMX' AND design_id = 0;0;
password_info_delete_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM password_info;0;
password_info_alter_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.columns WHERE table_name='password_info' AND column_name='delete_flag';0;
password_info_alter_table_4.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='password_info_pkey';1;
prohibition_image_create_sequence_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM pg_class c WHERE c.relkind = 'S' AND c.relname='image_id';1;
prohibition_image_update_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM prohibition_image;0;
prohibition_image_delete_3.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM prohibition_image;0;
prohibition_image_alter_table_4.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM pg_class WHERE relname='prohibition_image';0;
prohibition_image_alter_table_5.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='prohibition_image_pkey' OR constraint_name='prohibition_image_ukey';2;
radius_client_alter_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.columns WHERE table_name ='radius_client' AND column_name='delete_id' OR column_name='invalid_id' OR column_name='vpn_type';3;
radius_client_update_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM radius_client;0;
radius_client_update_table_3.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM radius_client;0;
radius_client_update_table_4.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM radius_client;0;
radius_client_alter_table_5.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM pg_class WHERE relname='radius_client';0;
radius_client_alter_table_6.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='radius_client_pkey' OR constraint_name='radius_client_ukey1' OR constraint_name='radius_client_ukey2' OR constraint_name='radius_client_ukey3';4;
service_control_alter_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM pg_class WHERE relname='service_control';0;
service_control_create_sequence_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM pg_class c WHERE c.relkind = 'S' AND c.relname='scl_no';1;
service_control_update_table_3.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM service_control;0;
service_control_update_table_4.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM service_control;0;
service_control_alter_table_5.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM pg_class WHERE relname='service_control';0;
service_control_alter_table_6.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='service_control_pkey' OR constraint_name='service_control_ukey';2;
service_info_alter_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='service_info_pkey';1;
setup_info_update_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM setup_info;0;
setup_info_update_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM setup_info;0;
setup_info_alter_table_3.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.columns WHERE table_name='setup_info' AND column_name='smxbridge_session_time';1;
setup_info_update_table_4.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM setup_info;0;
setup_info_update_table_5.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.columns WHERE table_name='setup_info' AND column_name='smxbridge_session_time';0;
sp_federation_alter_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.columns WHERE table_name ='sp_federation' AND column_name='group_id';1;
sp_federation_update_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM sp_federation;0;
sp_federation_alter_table_3.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM pg_class WHERE relname='sp_federation';0;
sp_federation_alter_table_4.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='sp_federation_ukey';1;
sp_grp_permit_alter_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='sp_grp_permit_pkey';1;
sp_info_alter_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM pg_class WHERE relname='sp_info';0;
sp_info_update_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM sp_info;0;
sp_info_alter_table_3.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.columns WHERE table_name='sp_info' AND column_name='invalid_id';0;
sp_info_alter_table_4.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='sp_info_pkey' OR constraint_name='sp_info_ukey1'  OR constraint_name='sp_info_ukey2' ;3;
sp_vgrp_permit_alter_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='sp_vgrp_permit_pkey';1;
sso_ctl_alter_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.columns WHERE table_name='sso_ctl' AND column_name='delete_no' OR column_name='auth_type';2;
sso_ctl_update_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM sso_ctl;0;
sso_ctl_update_table_3.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM sso_ctl;0;
sso_ctl_alter_table_4.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.columns WHERE table_name='sso_ctl' AND column_name='delete_no' OR column_name='auth_type';0;
sso_ctl_alter_table_5.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='sso_ctl_pkey' OR constraint_name='sso_ctl_ukey';2;
sso_info_alter_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='sso_info_ukey';1;
vgroup_alter_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.columns WHERE table_name='vgroup' AND column_name='owner_id' OR column_name='delete_id' OR column_name='public';3;
vgroup_update_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM vgroup;0;
vgroup_update_table_3.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM vgroup;0;
vgroup_update_table_4.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM vgroup;0;
vgroup_alter_table_5.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.columns WHERE table_name='vgroup' AND column_name='owner_id' OR column_name='delete_id' OR column_name='public';0;
vgroup_alter_table_6.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='vgroup_pkey' OR constraint_name='vgroup_ukey';2;
vgrp_belong_alter_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='vgrp_belong_ukey';1;
vgrp_permit_alter_table_a_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='vgrp_permit_pkey';1;
vpn_info_alter_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.columns WHERE table_name='vpn_info' AND column_name='vpn_info_id' OR column_name='delete_id';2;
vpn_info_create_sequence_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM pg_class c WHERE c.relkind = 'S' AND c.relname='vpn_info_id';1;
vpn_info_update_table_3.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM vpn_info;0;
vpn_info_update_table_4.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM vpn_info;0;
vpn_info_alter_table_5.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.columns WHERE table_name='vpn_info' AND column_name='vpn_info_id' OR column_name='delete_id';0;
vpn_info_alter_table_6.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='vpn_info_pkey' OR constraint_name='vpn_info_ukey';2;
vpn_list_update_table_1.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM vpn_list WHERE default_client_info LIKE '%securematrix.com';0;
# vpn_list_insert_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM vpn_list WHERE vpn_name = 'db.ciscoASA_5500';0;
win_account_alter_table_2.sql;nanakoDB;nanakoDB;SELECT COUNT('') FROM information_schema.table_constraints WHERE constraint_type IN ('PRIMARY KEY', 'UNIQUE') AND constraint_name='win_account_ukey';1;
