# 02.03 backendmenu rechte für plugins entfernen
UPDATE dedi_backendmenu SET entry_validate = 'root' WHERE entry_langstring = 'nav_4_0' AND entry_validate = '$perm->have_perm(\'area_plugin\')';

# 02.03 alle Module löschbar machen
UPDATE dedi_mod SET deletable='1' WHERE deletable='0';

# 02.03 doppelte Konfigurationseinträge entfernen
DELETE FROM dedi_values WHERE group_name='cfg' AND key1='chmod_enabled';
INSERT INTO dedi_values VALUES ('', 0, 0, 'cfg', 'chmod_enabled', '', '', '', '1', 301, 'set_chmod_enable', NULL, 'txt', NULL, NULL, 1);
DELETE FROM dedi_values WHERE group_name='cfg_client' AND key1 IN ('errorpage', 'loginpage', 'cache') AND idclient='1';
INSERT INTO dedi_values VALUES ('', 1, 0, 'cfg_client', 'errorpage', '', '', '', '0', 209, 'setuse_errorpage', NULL, 'txt', NULL, NULL, 1);
INSERT INTO dedi_values VALUES ('', 1, 0, 'cfg_client', 'loginpage', '', '', '', '0', 210, 'setuse_loginpage', NULL, 'txt', NULL, NULL, 1);
INSERT INTO dedi_values VALUES ('', 1, 0, 'cfg_client', 'cache', '', '', '', '1', 211, 'setuse_cache', NULL, 'txt', NULL, NULL, 1);

# 13.03 Ordnerbeschreibung hinzugefügt
ALTER TABLE dedi_cat_lang ADD `description` TEXT AFTER `name`;

# 15.03 Update Repository
UPDATE dedi_values SET `value` = 'service.das-repository.de',`conf_input_type_val` = NULL ,`conf_input_type_langstring` = NULL WHERE `key1` = 'repository_server';
UPDATE dedi_values SET `value` = '1',`conf_input_type_val` = NULL ,`conf_input_type_langstring` = NULL WHERE `key1` = 'repository_show_up2date';
ALTER TABLE dedi_mod CHANGE `repository_id` `repository_id` VARCHAR( 255 ) DEFAULT NULL;
ALTER TABLE dedi_plug CHANGE `repository_id` `repository_id` VARCHAR( 255 ) DEFAULT NULL;
UPDATE dedi_mod SET `repository_id` = NULL;
UPDATE dedi_plug SET `repository_id` = NULL;

# 18.03. filetypepict geändert
UPDATE `dedi_filetype` SET filetypepict='unknown.gif' WHERE filetypepict='upl_unknown.gif';

# 18.03. db_cache aktivieren
INSERT INTO dedi_values VALUES ('', 0, 0, 'cfg', 'db_cache_enabled', '', '', '', '0', 800, 'set_db_cache_enabled', 'set_db_cache', 'txt', NULL, NULL, 1);
INSERT INTO dedi_values VALUES ('', 0, 0, 'cfg', 'db_cache_name', '', '', '', 'db_cache', 805, 'set_db_cache_name', NULL, 'txt', NULL, NULL, 0);
INSERT INTO dedi_values VALUES ('', 0, 0, 'cfg', 'db_cache_groups', 'default', '', '', '60', 810, 'set_db_cache_group_default', 'set_db_cache_groups', 'txt', NULL, NULL, 1);
INSERT INTO dedi_values VALUES ('', 0, 0, 'cfg', 'db_cache_groups', 'standard', '', '', '3600', 820, 'set_db_cache_group_standard', NULL, 'txt', NULL, NULL, 1);
INSERT INTO dedi_values VALUES ('', 0, 0, 'cfg', 'db_cache_groups', 'frontend_tree', '', '', '15', 830, 'set_db_cache_group_frontend_tree', NULL, 'txt', NULL, NULL, 1);

# 18.03. db_cache tabelle einfügen
DROP TABLE IF EXISTS dedi_db_cache;
CREATE TABLE dedi_db_cache (
  sid varchar(32) NOT NULL default '',
  name varchar(32) NOT NULL default '',
  val mediumtext,
  changed varchar(14) NOT NULL default '',
  `release` varchar(14) default '0',
  groups varchar(32) NOT NULL default '',
  PRIMARY KEY  (name,sid),
  KEY changed (changed)
) TYPE=MyISAM;

#21.03.2004 correct permnames - toggle clientslang to clientlangs
UPDATE dedi_values set value = 'clients,clientlangs' where group_name = 'user_perms' AND key1 ='dedi_access' AND key2 = 'area_clients';

#24.03.2004 turn up sessions to mediumtext
ALTER TABLE `dedi_sessions` CHANGE `val` `val` MEDIUMTEXT;




#26.03.2004 set new versionnumber
UPDATE dedi_values  SET value =  '00.98.00' WHERE group_name =  'cfg' AND key1 =  'version';

#21.05.2004 alte rechte wegen neuen rechtemanagment löschen
DELETE FROM dedi_perms;