Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Old Database Table Cleanup #812

Open
onewheelskyward opened this issue Sep 4, 2024 · 1 comment
Open

Old Database Table Cleanup #812

onewheelskyward opened this issue Sep 4, 2024 · 1 comment

Comments

@onewheelskyward
Copy link
Contributor

onewheelskyward commented Sep 4, 2024

We have a lot of unused tables (I think) so let's go through and clean them up.

  • caladdress - address looking with various points around the city tied to addresses. (1649 rows)
  • calcount - Counts stored with the date ranges, ranging from 2008-2017. (4284 rows)
  • caldaily - newsflash related? 17,000 rows. Goes into 2026.
  • calevent - THE table. No-a touch-a.
  • calforum - Appears to be a forum decommissioned in 2018, full of folks looking for ride photos or the live ride itself! (2876 rows)
  • calshare - lookup table, 9 rows
  • mugDialog - culled and saved in ~backup/mugdialog.txt
  • mugdialog - culled and saved in ~backup/mugdialog.txt
  • pp20apr2006 - 132 events- unsure if archive or single copy of information.
  • ppdistro - appears to be a distribution list of pp flyers(?) with names attached. 55 rows. Table comment: "Tracks locations of PP calendars and posters"
  • ppforum - Seems an earlier (2007) attempt at a forum. 116 rows.
  • rideIdea - Coupla hundred rows in here. Leaving be for now.
  • rideidea - empty, dropped.
  • sched - Seems to be the 2007 version of the single use calendar.
@fool
Copy link
Member

fool commented Nov 12, 2024

I can confirm that the ppdistro/ppforu/mugdialog/mugDialog/rideIdea/rideidea/calforum are all things we didn't move forward in even the "new" php codebase. I do like keeping the calforum and rideIdea and caladdress tables (many of these were user submitted "when I say kernel sumners I mean colonel summers!"), in case someone wants to later spelunk them since they were once public-ish data but we could also just dump to a textfile and call it good..

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants