package nerd.tuxmobil.fahrplan.congress.persistence;

import android.provider.BaseColumns;

public interface FahrplanContract {

    interface MetasTable {

        String NAME = "meta";

        interface Columns {

            /* 0 */ String VERSION = "version";
            /* 1 */ String TITLE = "title";
            /* 2 */ String SUBTITLE = "subtitle";
            /* 3 */ String DAY_CHANGE_HOUR = "day_change_hour";
            /* 4 */ String DAY_CHANGE_MINUTE = "day_change_minute";
            /* 5 */ String ETAG = "etag";
            /* 6 */ String NUM_DAYS = "numdays";
        }

        interface Defaults {

            int NUM_DAYS_DEFAULT = 0;
            int DAY_CHANGE_HOUR_DEFAULT = 4;
            int DAY_CHANGE_MINUTE_DEFAULT = 0;
            String ETAG_DEFAULT = "''";
        }

    }

    interface AlarmsTable {

        String NAME = "alarms";

        interface Columns {

            /* 0 */ String EVENT_TITLE = "title";
            /* 1 */ String ALARM_TIME_IN_MIN = "alarm_time_in_min";
            /* 2 */ String TIME = "time";
            /* 3 */ String TIME_TEXT = "timeText";
            /* 4 */ String EVENT_ID = "eventid";
            /* 5 */ String DISPLAY_TIME = "displayTime";
            /* 6 */ String DAY = "day";
            /* 7 */ String ID = "_id";
        }

        interface Defaults {

            int ALARM_TIME_IN_MIN_DEFAULT = -1;
        }

    }

    interface HighlightsTable {

        String NAME = "highlight";

        interface Columns {

            /* 0 */ String EVENT_ID = "eventid";
            /* 1 */ String HIGHLIGHT = "highlight";
            /* 2 */ String ID = "_id";
        }

        interface Values {

            int HIGHLIGHT_STATE_OFF = 0;
            int HIGHLIGHT_STATE_ON = 1;
        }

    }

    interface LecturesTable {

        String NAME = "lectures";

        interface Columns extends BaseColumns {

            /* 00 */ String EVENT_ID = "event_id";
            /* 01 */ String TITLE = "title";
            /* 02 */ String SUBTITLE = "subtitle";
            /* 03 */ String DAY = "day";
            /* 04 */ String ROOM = "room";
            /* 05 */ String START = "start";
            /* 06 */ String DURATION = "duration";
            /* 07 */ String SPEAKERS = "speakers";
            /* 08 */ String TRACK = "track";
            /* 09 */ String TYPE = "type";
            /* 10 */ String LANG = "lang";
            /* 11 */ String ABSTRACT = "abstract";
            /* 12 */ String DESCR = "descr";
            /* 13 */ String REL_START = "relStart";
            /* 14 */ String DATE = "date";
            /* 15 */ String LINKS = "links";
            /* 16 */ String DATE_UTC = "dateUTC";
            /* 17 */ String ROOM_IDX = "room_idx";
            /* 18 */ String REC_LICENSE = "rec_license";
            /* 19 */ String REC_OPTOUT = "rec_optout";
            /* 20 */ String CHANGED_TITLE = "changed_title";
            /* 21 */ String CHANGED_SUBTITLE = "changed_subtitle";
            /* 22 */ String CHANGED_ROOM = "changed_room";
            /* 23 */ String CHANGED_DAY = "changed_day";
            /* 24 */ String CHANGED_SPEAKERS = "changed_speakers";
            /* 25 */ String CHANGED_RECORDING_OPTOUT = "changed_recording_optout";
            /* 26 */ String CHANGED_LANGUAGE = "changed_language";
            /* 27 */ String CHANGED_TRACK = "changed_track";
            /* 28 */ String CHANGED_IS_NEW = "changed_is_new";
            /* 29 */ String CHANGED_TIME = "changed_time";
            /* 30 */ String CHANGED_DURATION = "changed_duration";
            /* 31 */ String CHANGED_IS_CANCELED = "changed_is_canceled";
        }

        interface Defaults {

            int DATE_UTC_DEFAULT = 0;
            int ROOM_IDX_DEFAULT = 0;
        }

        interface Values {

            int REC_OPTOUT_OFF = 0;
            int REC_OPTOUT_ON = 1;
        }

    }

}

@@ -906,32 +906,71 @@
          /* 0 */
+ String ID = %22_id%22;%0A            /* 1 */
  String EVENT_TI
@@ -991,33 +991,33 @@
 %0A            /* 
-1
+2
  */ String ALARM
@@ -1059,33 +1059,33 @@
 %0A            /* 
-2
+3
  */ String TIME 
@@ -1101,33 +1101,33 @@
 %0A            /* 
-3
+4
  */ String TIME_
@@ -1152,33 +1152,33 @@
 %0A            /* 
-4
+5
  */ String EVENT
@@ -1201,33 +1201,33 @@
 %0A            /* 
-5
+6
  */ String DISPL
@@ -1258,33 +1258,33 @@
 %0A            /* 
-6
+7
  */ String DAY =
@@ -1295,47 +1295,8 @@
 y%22;%0A
-            /* 7 */ String ID = %22_id%22;%0A
     

Fix documentation for column indices of the "alarms" table.