package com.example.Maps012;

import android.provider.BaseColumns;

public class DBtables 
{
    public DBtables() {}

    public static abstract class TextReport implements BaseColumns 
    {
        public static final String TABLE_NAME = "textreport";

        public static final String COLUMN_NUSER_ID = "userid";
        public static final String COLUMN_REPORT = "report";
        public static final String COLUMN_ISREPOETED = "isreported";
        public static final String COLUMN_DATETIME = "datetime";
        public static final String COLUMN_LATITUDE = "latitude";
        public static final String COLUMN_LONGITUDE = "longtitude";
        public static final String PRIMARY_KEY = "PRIMARY KEY (" + COLUMN_NUSER_ID + "," + COLUMN_REPORT + "," + COLUMN_LONGITUDE + "," + COLUMN_LATITUDE + ")";
        
        public static final String[] ALL_COLUMNS =  {COLUMN_NUSER_ID, COLUMN_REPORT, COLUMN_ISREPOETED, COLUMN_DATETIME, COLUMN_LATITUDE, COLUMN_LONGITUDE};
    }
}
