Creación de Tablas

 package com.example.appbanco;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

import androidx.annotation.AttrRes;
import androidx.annotation.Nullable;

public class sqlBanco extends SQLiteOpenHelper {
    //Definición de las tablas de la BD
    String tblcustomer = "CREATE TABLE customer(email text primary key, name text, password text, rol text)";
    String tblaccount = "CREATE TABLE account(accountnumber  integer primary key autoincrement, email text, date text, balance integer)";
    String tbltranstype = "CREATE TABLE  transtype(idtranstype text primary key, descripcion text)";
    String tbltransactionc = "CREATE TABLE transactionc (accountnumber integer, idtranstype text, datetrans text, amount integer)";
    public sqlBanco(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        //Generar las instrucciones para crear las tablas
        db.execSQL(tblcustomer);
        db.execSQL(tblaccount);
        db.execSQL(tbltranstype);
        db.execSQL(tbltransactionc);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        //Actualizar las tablas en SQlite
        db.execSQL("DROP TABLE customer");
        db.execSQL(tblcustomer);
        db.execSQL("DROP TABLE account");
        db.execSQL(tblaccount);
        db.execSQL("DROP TABLE transtype");
        db.execSQL(tbltranstype);
        db.execSQL("DROP TABLE transactionc");
        db.execSQL(tbltransactionc);
    }
}