Database Documentation

Example Action:

    Example change to 'table'

Create new record:

    Insert into 'chchchanges'
    Insert into 'location'
    Insert into 'location_title'
    Insert into 'rank'
    Insert into 'title'

Delete record:

    Insert into 'chchchanges'
    Remove from 'location'
    Remove from 'location_title'
    Remove from 'rank'
    Remove from 'title'

Create new guide:

    Insert into 'chchchanges'
    Insert into 'subject'
    Insert into 'tab'
    Insert into 'staff_subject'

Add pluslet to guide:

    Insert into 'pluslet'
    Insert into 'pluslet_section'
    Insert into 'section'
    Insert into 'tab'

Add new section to guide:

    Insert into 'section'
    Alter 'pluslet_section'
    Alter 'tab'

Change layout of guide:

    Alter 'pluslet_section'
    Alter 'section'
    Alter 'tab'

Delete guide with pluslet and section:

    Insert into 'chchchanges'
    Remove from 'tab'
    Remove from 'staff_subject'
    Remove from 'subject'
    Remove from 'pluslet'
    Remove from 'pluslet_section'
    Remove from 'section'

Create new FAQ:

    Insert into 'chchchanges'
    Insert into 'faq'
    Insert into 'faq_faqpage'
    Insert into 'faq_subject'

Create new user:

    Insert into 'staff'

Delete user:

    Insert into 'chchchanges'
    Remove from 'staff'

Manually enter video:

    Insert into 'chchchanges'
    Insert into 'video'

Delete video:

    Insert into 'chchchanges'
    Remove from 'video'