package com.example.fmkpl.fmkmobile;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
/**
* Created by polsk on 29.08.2017.
*/
public class BazaDanych extends SQLiteOpenHelper {
public static final String NazwaBazyp = "FMKMobileBaza.db";
public static final String NazwaTabeli_1_klub = "LegiaPilkarzeBaza";
public static final String COL_1 = "ID";
public static final String COL_2 = "Imie";
public static final String COL_3 = "Nazwisko";
public static final String COL_4 = "Wiek";
public static final String COL_5 = "Wzrost";
public static final String COL_6 = "Waga";
public static final String COL_7 = "ID_Zdjecia";
public static final String COL_8 = "Umiejetnosci_Ogolne";
public static final String COL_9 = "Potencjal";
public static final String COL_10 = "Atr_1";
public static final String COL_11 = "Atr_2";
public static final String COL_12 = "Atr_3";
public static final String COL_13 = "Atr_4";
public static final String COL_14 = "Atr_5";
public static final String COL_15 = "DlugoscKontraktu";
public static final String COL_16 = "PlacaTygodniowo";
public static final String COL_17 = "WartoscTransferowa";
public static final String COL_18 = "Kondycja";
public static final String COL_19 = "Morale";
public static final String COL_20 = "Narodowosc";
public static final String COL_21 = "LiczbaMeczyWSezonie";
public static final String COL_22 = "LiczbaGoliWSezonie";
public static final String COL_23 = "LiczbaAsystWSezonie";
public static final String COL_24 = "LiczbaZoltychKartekWSezonie";
public static final String COL_25 = "LiczbaCzerwonychKartekWSezonie";
public static final String COL_26 = "CzyMaKontuzje";
public static final String COL_27 = "IloscMeczyPauzy";
public static final String COL_28 = "Forma";
public static final String COL_29 = "LiczbaMinutWSezonie";
public BazaDanych(Context kontekst)
{
super(kontekst,NazwaBazyp,null,1);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE " + NazwaTabeli_1_klub +" (ID INTEGER PRIMARY KEY AUTOINCREMENT,"
+"Imie TEXT ,"
+"Nazwisko TEXT ,"
+"Wiek INTEGER ,"
+"Wzrost INTEGER ,"
+"Waga INTEGER ,"
+"ID_Zdjecia INTEGER ,"
+"Umiejetnosci_Ogolne INTEGER ,"
+"Potencjal INTEGER ,"
+"Atr_1 INTEGER ,"
+"Atr_2 INTEGER ,"
+"Atr_3 INTEGER ,"
+"Atr_4 INTEGER ,"
+"Atr_5 INTEGER ,"
+"DlugoscKontraktu INTEGER ,"
+"PlacaTygodniowo INTEGER ,"
+"WartoscTransferowa INTEGER ,"
+"Kondycja INTEGER ,"
+"Morale INTEGER ,"
+"Narodowosc TEXT ,"
+"LiczbaMeczyWSezonie INTEGER ,"
+"LiczbaGoliWSezonie INTEGER ,"
+"LiczbaAsystWSezonie INTEGER ,"
+"LiczbaZoltychKartekWSezonie INTEGER ,"
+"LiczbaCzerwonychKartekWSezonie INTEGER ,"
+"CzyMaKontuzje INTEGER ,"
+"IloscMeczyPauzy INTEGER ,"
+"Forma INTEGER ,"
+"LiczbaMinutWSezonie INTEGER ,"
);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}