9m3EJZZr

1public class PurseContract {
2
3    public static final  String TYPE_TEXT ="TEXT";
4    public static final String TYPE_INTEGER = "INTEGER";
5    public static final String TYPE_REAL= "REAL";
6
7    public static  final class IncomeCategoriesEntry implements BaseColumns {
8        public static final String TABLE_INCOME_CATEGORY = "categoriesIncome";
9        public static final String INCOME_CATEGORY_NAME = "name";
10
11        public static final String CREATE_INCOME_CATEGORY = "CREATE TABLE IF NOT EXISTS " + TABLE_INCOME_CATEGORY +
12                "(" + _ID + " " + TYPE_INTEGER + " PRIMARY KEY AUTOINCREMENT, " + INCOME_CATEGORY_NAME + " "
13                + TYPE_TEXT + ")";
14
15        public static final String DROP_INCOME_CATEGORY = "DROP TABLE IF EXISTS " + INCOME_CATEGORY_NAME;
16
17    }
18        public static final class OutcomeCategoriesEntry implements BaseColumns
19        {
20            public static final String TABLE_OUTCOME_CATEGORY = "categoriesOutcome";
21            public static  final String OUTCOME_CATEGORY_NAME = "name";
22
23            public static final  String TYPE_TEXT ="TEXT";
24            public static final String TYPE_INTEGER = "INTEGER";
25
26            public static final String CREATE_OUTCOME_CATEGORY = "CREATE TABLE IF NOT EXISTS "+ TABLE_OUTCOME_CATEGORY +
27                    "("+_ID + " " + TYPE_INTEGER + " PRIMARY KEY AUTOINCREMENT, " + OUTCOME_CATEGORY_NAME + " "
28                    + TYPE_TEXT + ")";
29
30            public static final String DROP_OUTCOME_CATEGORY = "DROP TABLE IF EXISTS " + OUTCOME_CATEGORY_NAME;
31        }
32
33    public static final class OutcomeEntry implements BaseColumns
34    {
35        public static final String TABLE_OUTCOME = "Outcome";
36        public static  final String OUTCOME_DATE = "date";
37        public static  final String OUTCOME_CATEGORY = "category";
38        public static  final String OUTCOME_SUM = "sum";
39        public static  final String OUTCOME_CURRENCY = "currency";
40        public static  final String OUTCOME_COMMENT = "comment";
41        public static  final String OUTCOME_SUM_IN_RUB = "sumInRub";
42
43        public static final String CREATE_OUTCOME = "CREATE TABLE IF NOT EXISTS "+ TABLE_OUTCOME +
44                "("+_ID + " " + TYPE_INTEGER + " PRIMARY KEY AUTOINCREMENT, " + OUTCOME_DATE + " "
45                + TYPE_TEXT + ", "+  OUTCOME_CATEGORY + " " + TYPE_TEXT + ", " +  OUTCOME_SUM + " "
46                + TYPE_INTEGER + ", " + OUTCOME_CURRENCY + " " + TYPE_TEXT + ", " + OUTCOME_COMMENT + " "
47                + TYPE_TEXT + ", " + OUTCOME_SUM_IN_RUB + " " + TYPE_REAL + ")";
48
49        public static final String DROP_OUTCOME = "DROP TABLE IF EXISTS " + TABLE_OUTCOME;
50    }
51
52    public static final class IncomeEntry implements BaseColumns
53    {
54        public static final String TABLE_INCOME = "Income";
55        public static  final String INCOME_DATE = "date";
56        public static  final String INCOME_CATEGORY = "category";
57        public static  final String INCOME_SUM = "sum";
58        public static  final String INCOME_CURRENCY = "currency";
59        public static  final String INCOME_COMMENT = "comment";
60        public static  final String INCOME_SUM_IN_RUB = "sumInRub";
61
62        public static final String CREATE_INCOME = "CREATE TABLE IF NOT EXISTS "+ TABLE_INCOME +
63                "("+_ID + " " + TYPE_INTEGER + " PRIMARY KEY AUTOINCREMENT, " + INCOME_DATE + " "
64                + TYPE_TEXT + ", "+  INCOME_CATEGORY + " " + TYPE_TEXT + ", " +  INCOME_SUM + " "
65                + TYPE_INTEGER + ", " + INCOME_CURRENCY + " " + TYPE_TEXT + ", " + INCOME_COMMENT + " "
66                + TYPE_TEXT + ", " + INCOME_SUM_IN_RUB + " " + TYPE_REAL + ")";
67
68        public static final String DROP_INCOME = "DROP TABLE IF EXISTS " + TABLE_INCOME;
69    }
70}