--
-- QUERIES
--
-- select weblog_accesses_raw.value_id, count(*)
-- from weblog_accesses_raw
-- group by value_id
-- order by value_id;
-- 
-- --
-- --
-- --
-- 
-- select weblog_values.id, weblog_values.value, count(*)
-- from weblog_accesses, weblog_values
-- where weblog_accesses.value_id = weblog_values.id
-- group by weblog_values.value
-- order by weblog_values.value;
-- 
-- --
-- -- Detecting double records
-- -- (records, which can be created by PHP timeout exceed)
-- --
-- 
-- select id, datetime, value_id, session_id, count(*) from weblog_accesses group
-- by datetime, value_id, request_method_id, query_string_id, path_info_id,
-- path_translated_id, content_type_id, content_length, script_name_id,
-- server_name_id, server_port, server_software_id, server_protocol_id,
-- gateway_interface_id, proxy_addr_id, proxy_host_id, remote_addr_id,
-- remote_host_id, remote_port, auth_type_id, remote_user_id, remote_ident_id,
-- document_root_id, http_accept_id, http_accept_charset_id,
-- http_accept_encoding_id, http_accept_language_id, http_connection_id,
-- http_host_id, http_referer_id, http_user_agent_id, script_filename_id,
-- server_admin_id, server_signature_id, request_uri_id, ident_username_id,
-- ident_ostype_id, session_id having count(*) > 1;
-- 

#
# ezin_roles modifycations
#

alter table ezin_roles change column roles a_roles varchar(10);
alter table ezin_roles add column roles varchar(10) after users;
update ezin_roles set roles = a_roles;
alter table ezin_roles drop column a_roles;
alter table ezin_roles add column config varchar(10) after sessions;
update ezin_roles set config = 'L' where sessions like '%l%';
update ezin_roles set config = 'LC' where name like '%superuser%';