shift-org / shift-org/shift-docs
Old Database Table Cleanup
Open
@onewheelskyward is already working on this.
Since Sep 4, 2024.
backend
cleanup
database
- Dominant language
- JavaScript
- Stars
- 30
- Forks
- 25
- Avg merge
- 9m
- Merged PRs (30d)
- 1
Description
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.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.