I have the cleaner for the PerlMonks backup dumps ready in some way, but I have some questions remaining on the tables which are needed for Everything operation. Especially the various approval tables escape my understanding - which of these tables are necessary?

What follows is the relevant excerpt of the config file I use to drive the process of copying/purging/passing the tables from the MySQL mysqldump files into a fresh dump file which is cleaned of sensitive data. I hope it is self-explanatory - "output" copies the CREATE and INSERT statements, "drop" removes the CREATE and INSERT statements, "purge" only copies the CREATE statement.

output approval (approved_id,user_approved,whenapproved,status) output approvalhistory (approves_id,user_approves,whenapproves,section +_id,action) output approvalstatus (approved_id,user_approved,whenapproved,status) output approved (user_id,node_id,action,tstamp) #output approves (approves_id,user_approves,whenapproves,action,sectio +n_id) drop approves drop backup_scratchpad drop backup_user # What is protouser? drop protouser # ??? drop rating # These seem to be more used drop testpolls drop testpollvote # The stuff in the tomb is gone for mortals purge tomb #version.version_id #version.version drop version

Any hints on what other tables can be dropped are welcome too.


Replies are listed 'Best First'.
Re: What tables are necessary for PM/Everything operation?
by demerphq (Chancellor) on Jun 29, 2006 at 15:24 UTC

    IIRC Protouser was my idea for dealing with the "new account problem". The idea was that when someone registers they create a protouser. When they actually log in for the first time the protouser gets promoted to a real user. If protouser accounts were used after a certain time they were to be automatically purged.

    As I recall tye didnt like the implementation, and since the code involved PM module changes which I tend to leave to tye the patches were never applied. tye had some other idea for how it was to work, but I dont know if it ever went anywhere.

    ---
    $world=~s/war/peace/g