四 川 铁 FourRiverIron

Au Documentation

 

SQL Tables

Mike's SQL tables

These are the SQL or MySQL tables I created for the site.

  • mike_au_meetings
  • mike_email_letter_editor
  • mike_email_list
  • mike_email_press_release
  • mike_email_test
  • mike_friends
  • mike_speaker_request
  • mike_test_table
  • mike_test_table2

First note that all the tables I created begin with the word "mike_". That makes it easy to figure out that I created them.

The two table that contain the word "test" in them are just test tables for testing.

They are not used for anything other then testing.

They are:

  • mike_test_table
  • mike_test_table2

Mike's Meeting Table

The MySQL table
  • mike_au_meetings
contains a list of all the past and future meeting that AU GP is having.

The computer program or web page:

mike/mike_au_meeting_list.php
Is used to list out upcoming meetings.

To list past meetings the same program is used but it is passed the option "what=p"

mike/mike_au_meeting_list.php?what=p

The program can also list ALL the meetings, which includes past and future meetings with the option "what=a"

mike/mike_au_meeting_list.php?what=a

Adding meetings to the SQL table

You can add new meetings to the sql table with this program:
mike/mike_au_meeting_add.php
You can add future meetings or meetings in the past. You decide that when you select the date and time of the meeting.

Editing meetings in the SQL table

This computer generates a list of all the meetings in the SQL table and displays it.
mike/mike_au_meeting_list2.php
You can click on the "edit" button to edit any of the meetings. When you "edit" a meeting you can delete a meeting, which means people will NEVER see the meeting.

You can "cancel" a meeting which means the meeting is displayed, but marked as canceled. That way people won't waste their time showing up to a meeting that has been canceled.

Last and most important you can also edit the text in any of the meetings.

Word Press Tables

There are a whole bunch of tables that were created to use with Word Press or perhaps WordPress. They all begin with the letters "wp_". I don't used them and I am clueless as to what they are for.

They are:

  • wp_commentmeta
  • wp_comments
  • wp_formbuilder_fields
  • wp_formbuilder_forms
  • wp_formbuilder_pages
  • wp_formbuilder_responses
  • wp_formbuilder_results
  • wp_links
  • wp_options
  • wp_postmeta
  • wp_posts
  • wp_terms
  • wp_term_relationships
  • wp_term_taxonomy
  • wp_usermeta
  • wp_users

 


四 川 铁 Home

四 川 铁 Four River Iron