· 8 years ago · Aug 07, 2018, 04:34 PM
1_command.CommandText ="PRAGMA foreign_keys = ON;";
2 _command.ExecuteNonQuery();
3
4_sqlString = "CREATE TABLE IF NOT EXISTS " + SQL_TABLE_COMBINED_GROUP + " (" +
5 COL_COMBINED_ID + " INTEGER AUTOINCREMENT, " +
6 COL_COMBINED_MEMBER_ID + " TEXT, " +
7 COL_COMBINED_EQUIPMENT_ID + " TEXT, " +
8 COL_COMBINED_EQUIPMENT + " TEXT)";
9
10 _command.CommandText = _sqlString;
11 _command.ExecuteNonQuery();