UberBots Website Documentation

SQL Documentation

The site stores all content for the site in the `omni` database in SQL.

Tables in the database:

• articles
  contains news articles for news page
  • title
  • content
  • time
  • photo
  • caption
  • id
  • importance
• calendar
  contains information for events on the calendar
  • id
  • name
  • description
  • type
  • startTime
  • endTime
  • location
• calendarLinks
  holds information for links to forum posts for meeting minutes
  • eventId
  • forumId
  • postId
• calendarMentors
  holds information for which mentors can attend events
  • userId
  • eventId
  • response
  • comment
• emailList
  stores email addresses for parent email list
  • email
• moduleProps
  stores properties for modules on site
  • instanceId
  • pageId
  • propName
  • propValue
• modules
  stores type and place of modules on a page
  • pageId
  • modId
  • instanceId
  • order
• pagePermissions
  stores special user permissions
  • userId
  • username
  • pageId
  • type
• pages
  stores information for pages on the site
  • id
  • parentId
  • title
  • order
  • inheritPermissions
  • private
  • redirect
• photos
  stores information for photos in media directory
  • filepath
  • photoId
  • parentId
  • type
  • title
  • caption
  • year
• videos
  stores videos and their information
  • id
  • name
  • description
  • filename
  • time

SQL Functions

mySQLConnect() - connects to `omni` mySQL database
mySQLClose() - closes mySQL connection

Upcoming Events

Events in the next week:

No upcoming events.