package com.satsumasoftware.timetable.db;

public final class ClassesSchema {

    public static final String TABLE_NAME = "classes";
    public static final String COL_ID = "id";
    public static final String COL_SUBJECT_ID = "subject_id";
    public static final String COL_DAY = "day";
    public static final String COL_START_TIME = "start_time";
    public static final String COL_END_TIME = "end_time";
    public static final String COL_ROOM = "room";
    public static final String COL_TEACHER = "teacher";

    protected static final String SQL_CREATE = "CREATE TABLE " + TABLE_NAME + "( " +
            COL_ID + SchemaUtilsKt.INTEGER_TYPE + SchemaUtilsKt.COMMA_SEP +
            COL_SUBJECT_ID + SchemaUtilsKt.INTEGER_TYPE + SchemaUtilsKt.COMMA_SEP +
            COL_DAY + SchemaUtilsKt.INTEGER_TYPE + SchemaUtilsKt.COMMA_SEP +
            COL_START_TIME + SchemaUtilsKt.INTEGER_TYPE + SchemaUtilsKt.COMMA_SEP +
            COL_END_TIME + SchemaUtilsKt.INTEGER_TYPE + SchemaUtilsKt.COMMA_SEP +
            COL_ROOM + SchemaUtilsKt.TEXT_TYPE + SchemaUtilsKt.COMMA_SEP +
            COL_TEACHER + SchemaUtilsKt.TEXT_TYPE +
            " )";

    protected static final String SQL_DELETE =
            "DROP TABLE IF EXISTS " + TABLE_NAME;
}

@@ -324,24 +324,28 @@
 L_START_TIME
+_HRS
  = %22start_ti
@@ -342,24 +342,100 @@
  %22start_time
+_hrs%22;%0A    public static final String COL_START_TIME_MINS = %22start_time_mins
 %22;%0A    publi
@@ -468,16 +468,20 @@
 END_TIME
+_HRS
  = %22end_
@@ -484,16 +484,88 @@
 end_time
+_hrs%22;%0A    public static final String COL_END_TIME_MINS = %22end_time_mins
 %22;%0A    p
@@ -1018,90 +1018,274 @@
 TIME
- + SchemaUtilsKt.INTEGER_TYPE + SchemaUtilsKt.COMMA_SEP +%0A            COL_END_TIME
+_HRS + SchemaUtilsKt.INTEGER_TYPE + SchemaUtilsKt.COMMA_SEP +%0A            COL_START_TIME_MINS + SchemaUtilsKt.INTEGER_TYPE + SchemaUtilsKt.COMMA_SEP +%0A            COL_END_TIME_HRS + SchemaUtilsKt.INTEGER_TYPE + SchemaUtilsKt.COMMA_SEP +%0A            COL_END_TIME_MINS
  + S

Improve the schema for classes to store hours and minutes separately