Re: [Tiki-users] Dropping abandoned Tables in Tiki-Schema

Hello all,

after some fiddling I made the following SQL-Script which hopefully 
deletes superfluous tables.

I give no guarantees! (And I have no idea why my user database has 
system tables. Anyone?)

-- vor Upgrade Schema bereinigen/korrigieren

use mytiki;

-- falsche Feldlänge:
ALTER TABLE `tiki_comments`
     CHANGE COLUMN `title` `title` VARCHAR(255) DEFAULT NULL;

-- bereinigen: Galaxia (wurde nie benutzt)
drop table if EXISTS galaxia_activities;
drop table if EXISTS galaxia_activity_roles;
drop table if EXISTS galaxia_instance_activities;
drop table if EXISTS galaxia_instance_comments;
drop table if EXISTS galaxia_instances;
drop table if EXISTS galaxia_processes;
drop table if EXISTS galaxia_roles;
drop table if EXISTS galaxia_transitions;
drop table if EXISTS galaxia_user_roles;
drop table if EXISTS galaxia_workitems;

-- weitere(s) nicht im aktuellen Installationsskript
-- und nicht umgestellt auf InnoDB
-- und bekannt gedropptes Feature
drop table if EXISTS tiki_eph;

drop table if EXISTS tiki_charts;
drop table if EXISTS tiki_charts_rankings;
drop table if EXISTS tiki_charts_votes;
drop table if EXISTS tiki_chart_items;
drop table if EXISTS tiki_drawings;
drop table if EXISTS tiki_newsreader_marks;
drop table if EXISTS tiki_newsreader_servers;
drop table if EXISTS tiki_page_drafts;
drop table if EXISTS tiki_quicktags;
drop table if EXISTS tiki_users;
drop table if EXISTS tiki_users_score;
-- Überbleibsel:
drop table if EXISTS users_score;

-- seltsame Tabellen:
drop table if EXISTS zzz_unused_metrics_assigned;
drop table if EXISTS zzz_unused_metrics_metric;
drop table if EXISTS zzz_unused_metrics_tab;

-- Systemtabellen?
drop table if EXISTS columns_priv;
drop table if EXISTS db;
drop table if EXISTS func;
drop table if EXISTS help_category;
drop table if EXISTS help_keyword;
drop table if EXISTS help_relation;
drop table if EXISTS help_topic;
drop table if EXISTS host;
drop table if EXISTS proc;
drop table if EXISTS procs_priv;
drop table if EXISTS tables_priv;
drop table if EXISTS time_zone;
drop table if EXISTS time_zone_leap_second;
drop table if EXISTS time_zone_name;
drop table if EXISTS time_zone_transition;
drop table if EXISTS time_zone_transition_type;
drop table if EXISTS user;



On 15.09.2020 16:58, Manuel Martin wrote:
> Hello all,
>
> I want to update my slightly outdated Tiki 8.2 installation to 21.2 
> and find some error message pertaining not yet properly converted 
> tables (to uft8mb4). I'm using MariaDB 10.5 BTW. I *believe* it's not 
> that important mostly, but want to be sure.
>
> Well, my best guess is those are leftovers from features which have 
> been dropped (like galaxia.* or tiki_eph), or they somehow came out of 
> use? They have in common that they are empty and that they have the 
> outdated charset/collation or perhaps special names (zzz_unused*)
>
> Long story short: is there a positive list which tables can be 
> dropped? Or is it 101% safe to drop tables which are not included in 
> tiki.sql? (Theoretically tiki-install.php could just rename things or 
> create tables by other means?)
>
> TIA, Manuel
>
>
>
> _______________________________________________
> TikiWiki-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-users
>


_______________________________________________
TikiWiki-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-users