-- alter table ezin_sections change column type
--	type enum('global','normal', 'hidden_from_list', 'hidden', 'disabled');
alter table ezin_articles drop column read_count;
drop table ezin_article_reads;
alter table ezin_roles change column file_management file_management varchar(15);
update ezin_roles set file_management = 'LRDCErdcuves' where file_management = 'LRDCErdvcu';

-- 8/8/2002
alter table ezin_articles add column access_key varchar(32) after datetime;
alter table ezin_sections add column access_key varchar(32) after raw_sessions_count;
alter table ezin_sections add column template_key varchar(32) after access_key;
update ezin_sections set template_key = substring_index(substring_index(template,'.',2), '.', -1);
alter table ezin_sections drop column template;

-- 12/8/2002
alter table ezin_articles add column template_key varchar(32) after access_key;
alter table ezin_articles
	change column status status enum('showed', 'partly_showed', 'hidden', 'disabled', 'hidden_from_global');
update ezin_articles set status = 'partly_showed' where status = 'hidden_from_global';
alter table ezin_articles change column status status enum('showed', 'partly_showed', 'hidden', 'disabled');
alter table ezin_sections change column type type enum('global', 'normal', 'hidden', 'hidden2', 'full_hidden', 'disabled');
update ezin_sections set type = 'full_hidden' where type = 'hidden';