text: /* These are commands used for updating tables.
   */
   
  /*Inserting new users*/
  INSERT INTO Users
  VALUES ( 'UserID', 'UEmail', 'UPassword', 'IsAdmin', 'UBooks', 'UOtherInfo'); /*strings here are just place holder, replace them by real generated strings*/
  
  /*Inserting new books*/
  INSERT INTO Books
  VALUES ( 'BISBN', 'BTitle', 'BAuthor', 'BCourse', 'BPic', 'BNumber');
  
  /*Inserting new postings*/
  INSERT INTO Postings
  VALUES ( 'UserID', 'UBooks', 'PostDates');
  
  
  /* getting course titles through course ID(CourseIDtheUserSelected)
   variable names are just made easier to understand, they can be changed to other names*/
  SELECT *
  FROM Courses
  WHERE CourseID = 'CourseIDthatNeeded'; /*strings can be changed into variables*/
  
  
  /* deleting users if needed */
  DELETE FROM Users
  WHERE UserID = 'UserNeedstobeDeleted';
  
  
  /* getting passwords from a specific user */
  SELECT UPassword
  FROM Users
  WHERE UserID = 'UserNeedstobeChecked';
  
  
  /* getting book info*/
  SELECT *
  FROM Books
  WHERE BISBN = 'ISBNthatNeeded'; /*strings in commands might be replaced by string variables in reality*/
  
  
  /* look up all uesers */
  SELECT * /*can be changed to any other attributes for specific needs*/
  FROM Users
  /*WHERE IsAdmin = 1*/ /*an example for getting user list with further information, here is getting admin user list*/;
  
  
  /* changing/updating information for specific needs */
  UPDATE Users
  SET UBooks = 'NewBooks' /*a string of BISBN in reality*/
  WHERE UserID = 'TheUserthatUpdating';
  