FlashCardsProject/build/project/src/jf/flashcards/address/model/FlashCardDatabase.java
/**
	 * Creates the FlashCardListTable which stores the flash card stack names
	 * if a duplicate name is inserted to the table, then the action will fail
	 * @return true if successful else false 
	 */
Creates the FlashCardListTable which stores the flash card stack names
if a duplicate name is inserted to the table, then the action will fail
@return true if successful else false
Creates the FlashCardListTable which stores the flash card stack names if a duplicate name is inserted to the table then the action will fail @return true if successful else false
public static boolean createFlashCardListTable() {
		try{
	         String tableQuery = "CREATE TABLE IF NOT EXISTS flash_card_list " +
	        		 		"(id  INTEGER   PRIMARY KEY  AUTOINCREMENT NOT NULL, " +
	        		 		" name  TEXT UNIQUE ON CONFLICT FAIl NOT NULL )";
	         stmt.executeUpdate(tableQuery);
			return true;
		}
		catch( Exception e)
		{
			System.err.println( e.getClass().getName() + ": " + e.getMessage() );
			System.out.println("went to catch statment");
			return false;
		}
	}
public static boolean createFlashCardListTable ( ) { try { String tableQuery = "CREATE TABLE IF NOT EXISTS flash_card_list " + "(id  INTEGER   PRIMARY KEY  AUTOINCREMENT NOT NULL, " + " name  TEXT UNIQUE ON CONFLICT FAIl NOT NULL )" ; stmt . executeUpdate ( tableQuery ) ; return true ; } catch ( Exception e ) { System . err . println ( e . getClass ( ) . getName ( ) + ": " + e . getMessage ( ) ) ; System . out . println ( "went to catch statment" ) ; return false ; } }
Creates the FlashCardListTable which stores the flash card stack names
 if a duplicate name is inserted to the table, then the action will fail
 @return true if successful else false
Creates the FlashCardListTable which stores the flash card stack names if a duplicate name is inserted to the table then the action will fail @return true if successful else false
//I can change this instead of ON CONFLICT INGNORE, I can use ABORT  //and it will cause an exception which i can catch for debugging later  //name  TEXT UNIQUE ON CONFLICT IGNORE