RUuUn8VG

1package com.firewallsol.smartcollege.Database;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6
7/**
8 * Created on 29/10/15.
9 */
10public class Database extends SQLiteOpenHelper {
11
12    public static final int DATABASE_VERSION = 1;
13    public static final String DATABASE_NAME = "smartDB.db";
14
15    private static final String sqlTutor =
16            "CREATE TABLE IF NOT EXISTS tutor (" +
17                    "id VARCHAR, " +
18                    "nombre VARCHAR, " +
19                    "email VARCHAR, " +
20                    "usuario VARCHAR, " +
21                    "escuela VARCHAR, " +
22                    "telefono VARCHAR, " +
23                    "foto VARCHAR, " +
24                    "pass VARCHAR " +
25                    ");";
26
27    private static final String sqlColegio =
28            "CREATE TABLE IF NOT EXISTS colegio (" +
29                    "id VARCHAR, " +
30                    "nombre VARCHAR, " +
31                    "contacto VARCHAR, " +
32                    "telefono VARCHAR, " +
33                    "descripcion VARCHAR, " +
34                    "color VARCHAR, " +
35                    "correo VARCHAR, " +
36                    "direccion VARCHAR, " +
37                    "sitioweb VARCHAR, " +
38                    "foto VARCHAR " +
39                    ");";
40
41    private static final String sqlDirectorio =
42            "CREATE TABLE IF NOT EXISTS directorio (" +
43                    "id INTEGER PRIMARY KEY AUTOINCREMENT, " +
44                    "nombre VARCHAR, " +
45                    "puesto VARCHAR, " +
46                    "contacto VARCHAR " +
47                    ");";
48    private static final String sqlHijos =
49            "CREATE TABLE IF NOT EXISTS hijos (" +
50                    "id VARCHAR, " +
51                    "nombre VARCHAR, " +
52                    "clave VARCHAR, " +
53                    "id_grado VARCHAR, " +
54                    "grado VARCHAR, " +
55                    "id_grupo VARCHAR, " +
56                    "grupo VARCHAR, " +
57                    "id_escuela VARCHAR, " +
58                    "referencia_bancaria VARCHAR " +
59                    ");";
60    private static final String sqlMaterias =
61            "CREATE TABLE IF NOT EXISTS materias (" +
62                    "id VARCHAR, " +
63                    "alumno VARCHAR, " +
64                    "clave VARCHAR, " +
65                    "nombre VARCHAR, " +
66                    "tipo VARCHAR " +
67                    ");";
68
69    public Database(Context contexto) {
70        super(contexto, DATABASE_NAME, null, DATABASE_VERSION);
71    }
72
73    @Override
74    public void onCreate(SQLiteDatabase db) {
75        //creacion de base de datos
76        db.execSQL(sqlTutor);
77        db.execSQL(sqlColegio);
78        db.execSQL(sqlDirectorio);
79        db.execSQL(sqlHijos);
80        db.execSQL(sqlMaterias);
81    }
82
83    @Override
84    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
85        //Updates de base de datos
86        db.execSQL("DROP TABLE IF EXISTS tutor");
87        db.execSQL("DROP TABLE IF EXISTS colegio");
88        db.execSQL("DROP TABLE IF EXISTS directorio");
89        db.execSQL("DROP TABLE IF EXISTS hijos");
90        db.execSQL("DROP TABLE IF EXISTS materias");
91        onCreate(db);
92    }
93}