kamM6VDm

1package com.example.nimicik.lab16sql.dao;
2
3public class UsersTable
4{
5    public static final String TABLE_USERS = "users";
6    public static final String COLUMN_ID = "id";
7    public static final String COLUMN_NAME = "name";
8    public static final String COLUMN_AGE = "age";
9
10    public static final String [] ALL_COLUMNS = {COLUMN_ID, COLUMN_NAME, COLUMN_AGE};
11
12    public static final String SQL_CREATE =
13            "CREATE TABLE IF NOT EXISTS " + TABLE_USERS + " (" +
14                    COLUMN_ID + " INTEGER PRIMARY KEY, " +
15                    COLUMN_NAME + " TEXT, " +
16                    COLUMN_AGE + " INT);";
17
18    public static final String SQL_DROP = "DROP TABLE " + TABLE_USERS;
19}