Ejemplo n.º 1
0
 public override void OnCreate(SQLiteDatabase db)
 {
     db.ExecSQL(CREATE_SERVER_TABLE);
     db.ExecSQL(CREATE_GROUP_TABLE);
     db.ExecSQL(DEFAULT_GROUP);
     // Demo data
     //db.execSQL(ADD_SERVER);
 }
Ejemplo n.º 2
0
 public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
 {
     // This database is only a cache for online data, so its upgrade policy is
     // to simply to discard the data and start over
     // Note that this only fires if you change the version number for your database.
     // It does NOT depend on the version number for your application.
     // If you want to update the schema without wiping data, commenting out the next 2 lines
     // should be your top priority before modifying this method.
     db.ExecSQL ("DROP TABLE IF EXISTS " + WeatherContractOpen.LocationEntryOpen.TABLE_NAME);
     db.ExecSQL ("DROP TABLE IF EXISTS " + WeatherContractOpen.WeatherEntryOpen.TABLE_NAME);
     OnCreate (db);
 }
Ejemplo n.º 3
0
		public void CreateDatabase(string sqldb_name)
		{
			try
			{
				sqldb_message = "";
				string sqldb_location = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal);
				string sqldb_path = Path.Combine(sqldb_location,sqldb_name);
				bool sqldb_exists = File.Exists(sqldb_path);
				if(!sqldb_exists)
				{
					
					sqldb = SQLiteDatabase.OpenOrCreateDatabase(sqldb_path,null);
					sqldb_query = "CREATE TABLE IF NOT EXISTS Contact (_id INTEGER PRIMARY KEY AUTOINCREMENT, FirstName VARCHAR, LastName VARCHAR, " +
						"Phone VARCHAR, Photo VARCHAR);";
					sqldb.ExecSQL(sqldb_query);
					sqldb_message = "Database:"+sqldb_name+" created";
				}
				else
				{
					sqldb = SQLiteDatabase.OpenDatabase(sqldb_path,null,DatabaseOpenFlags.OpenReadwrite);
					sqldb_message = "Database:"+sqldb_name+" opened";
				}
				sqldb_available=true;
			}
			catch(SQLiteException ex)
			{
				sqldb_message = ex.Message;
			}
		}   
Ejemplo n.º 4
0
        public override void OnCreate(SQLiteDatabase paramSQLiteDatabase)
        {
            // Create table "wikinotes"
            paramSQLiteDatabase.ExecSQL("CREATE TABLE " + WikiNote.Notes.TABLE_WIKINOTES + " (" + WikiNote.Notes.Id + " INTEGER PRIMARY KEY,"
                + WikiNote.Notes.TITLE + " TEXT COLLATE LOCALIZED NOT NULL,"
                + WikiNote.Notes.BODY + " TEXT,"
                + WikiNote.Notes.CREATED_DATE + " INTEGER,"
                + WikiNote.Notes.MODIFIED_DATE + " INTEGER" + ");");

            // Initialize database
            ContentValues localContentValues = new ContentValues();
            localContentValues.Put(WikiNote.Notes.TITLE, this._context.Resources.GetString(Resource.String.start_page));
            localContentValues.Put(WikiNote.Notes.BODY, this._context.Resources.GetString(Resource.String.top_note));
            long localLong = DateTime.Now.ToFileTimeUtc();
            localContentValues.Put(WikiNote.Notes.CREATED_DATE, localLong);
            localContentValues.Put(WikiNote.Notes.MODIFIED_DATE, localLong);

            paramSQLiteDatabase.Insert(WikiNote.Notes.TABLE_WIKINOTES, "huh?", localContentValues);

            localContentValues.Put(WikiNote.Notes.TITLE, "PageFormatting");
            localContentValues.Put(WikiNote.Notes.BODY, this._context.Resources.GetString(Resource.String.page_formatting_note));
            localContentValues.Put(WikiNote.Notes.CREATED_DATE, localLong);
            localContentValues.Put(WikiNote.Notes.MODIFIED_DATE, localLong);

            paramSQLiteDatabase.Insert(WikiNote.Notes.TABLE_WIKINOTES, "huh?", localContentValues);
        }
Ejemplo n.º 5
0
		public override void OnUpgrade(SQLiteDatabase db, int oldV, int newV)
		{
			//base.OnUpgrade (db, oldV, newV);
			// Drop older table if existed
			db.ExecSQL("DROP TABLE IF EXISTS " + TABLE_QUEST);
			// Create tables again
			OnCreate(db);
		}
Ejemplo n.º 6
0
 public override void OnCreate(SQLiteDatabase db)
 {
     db.ExecSQL(@"
     CREATE TABLE MapLocation (
       ID INTEGER PRIMARY KEY AUTOINCREMENT,
       Longitude FLOAT NOT NULL,
       Latitude FLOAT NOT NULL
     )");
 }
Ejemplo n.º 7
0
 public override void OnCreate(SQLiteDatabase db)
 {
     db.ExecSQL(@"
             CREATE TABLE Note (
                 Id INTEGER PRIMARY KEY AUTOINCREMENT,
                 Title TEXT NOT NULL,
                 Contents TEXT NOT NULL
             )");
 }
Ejemplo n.º 8
0
        public override void OnCreate(SQLiteDatabase db)
        {
            const string SQL_CREATE_WEATHER_TABLE = "CREATE TABLE " + WeatherContractOpen.WeatherEntryOpen.TABLE_NAME + " (" +
                // Why AutoIncrement here, and not above?
                // Unique keys will be auto-generated in either case.  But for weather
                // forecasting, it's reasonable to assume the user will want information
                // for a certain date and all dates *following*, so the forecast data
                // should be sorted accordingly.
                                                    WeatherContractOpen.WeatherEntryOpen._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +

                // the ID of the location entry associated with this weather data
                                                    WeatherContractOpen.WeatherEntryOpen.COLUMN_LOC_KEY + " INTEGER NOT NULL, " +
                                                    WeatherContractOpen.WeatherEntryOpen.COLUMN_DATE + " INTEGER NOT NULL, " +
                                                    WeatherContractOpen.WeatherEntryOpen.COLUMN_SHORT_DESC + " TEXT NOT NULL, " +
                                                    WeatherContractOpen.WeatherEntryOpen.COLUMN_WEATHER_id + " INTEGER NOT NULL," +

                                                    WeatherContractOpen.WeatherEntryOpen.COLUMN_MIN_TEMP + " REAL NOT NULL, " +
                                                    WeatherContractOpen.WeatherEntryOpen.COLUMN_MAX_TEMP + " REAL NOT NULL, " +

                                                    WeatherContractOpen.WeatherEntryOpen.COLUMN_HUMIDITY + " REAL NOT NULL, " +
                                                    WeatherContractOpen.WeatherEntryOpen.COLUMN_PRESSURE + " REAL NOT NULL, " +
                                                    WeatherContractOpen.WeatherEntryOpen.COLUMN_WIND_SPEED + " REAL NOT NULL, " +
                                                    WeatherContractOpen.WeatherEntryOpen.COLUMN_DEGREES + " REAL NOT NULL, " +

                // Set up the location column as a foreign key to location table.
                                                    " FOREIGN KEY (" + WeatherContractOpen.WeatherEntryOpen.COLUMN_LOC_KEY + ") REFERENCES " +
                                                    WeatherContractOpen.LocationEntryOpen.TABLE_NAME + " (" + WeatherContractOpen.LocationEntryOpen._ID + "), " +

                // To assure the application have just one weather entry per day
                // per location, it's created a UNIQUE constraint with REPLACE strategy
                                                    " UNIQUE (" + WeatherContractOpen.WeatherEntryOpen.COLUMN_DATE + ", " +
                                                    WeatherContractOpen.WeatherEntryOpen.COLUMN_LOC_KEY + ") ON CONFLICT REPLACE);";

            db.ExecSQL (SQL_CREATE_WEATHER_TABLE);

            const string SQL_CREATE_LOCATION_TABLE = "CREATE TABLE " + WeatherContractOpen.LocationEntryOpen.TABLE_NAME + " (" +
                                                     WeatherContractOpen.LocationEntryOpen._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
                                                     WeatherContractOpen.LocationEntryOpen.COLUMN_LOCATION_SETTING + " TEXT UNIQUE NOT NULL, " +
                                                     WeatherContractOpen.LocationEntryOpen.COLUMN_CITY_NAME + " TEXT NOT NULL, " +
                                                     WeatherContractOpen.LocationEntryOpen.COLUMN_COORD_LAT + " REAL NOT NULL, " +
                                                     WeatherContractOpen.LocationEntryOpen.COLUMN_COORD_LONG + " REAL NOT NULL);";
            db.ExecSQL (SQL_CREATE_LOCATION_TABLE);
        }
 public override void OnCreate(SQLiteDatabase db)
 {
     db.ExecSQL(@"
         CREATE TABLE " + DATABASE_TABLE_NAME + " ("
             + _ID + " INTEGER PRIMARY KEY NOT NULL," // INTEGER PRIMARY KEY functions as auto increment in SQLite
             + NAME + " TEXT NOT NULL,"
             + LONGITUDE + " REAL NOT NULL,"
             + LATITUTDE + " REAL NOT NULL)"
             );
 }
Ejemplo n.º 10
0
 public override void OnCreate(SQLiteDatabase db)
 {
     db.ExecSQL(@"
         CREATE TABLE history (
             _id INTEGER PRIMARY KEY AUTOINCREMENT,
             Title TEXT NOT NULL,
             Url TEXT NOT NULL,
             Timestamp INT NOT NULL
         )
         ");
 }
Ejemplo n.º 11
0
		public override void OnCreate(SQLiteDatabase db)
		{
			//base.OnCreate (db);
			dbase=db;
			string sql = "CREATE TABLE IF NOT EXISTS " + TABLE_QUEST + " ( "
				+ KEY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + KEY_QUES
				+ " TEXT, " + KEY_ANSWER+ " TEXT, "+KEY_OPTA +" TEXT, "
				+KEY_OPTB +" TEXT, "+KEY_OPTC+" TEXT)";
			db.ExecSQL(sql);		
			addQuestions();
			//db.close();
		}
Ejemplo n.º 12
0
 public override void OnCreate(SQLiteDatabase db)
 {
     db.ExecSQL(create_table_sql);
     // seed with data
     //			db.ExecSQL("INSERT INTO RUOKData (date_time, ergebnis) VALUES ('11.06.82 13:30', 25)");
     //			db.ExecSQL("INSERT INTO RUOKData (date_time, ergebnis) VALUES ('11.06.82 13:30', 25)");
     //			db.ExecSQL("INSERT INTO RUOKData (date_time, ergebnis) VALUES ('11.06.82 13:30', 25)");
     //			db.ExecSQL("INSERT INTO RUOKData (date_time, ergebnis) VALUES ('11.06.82 13:30', 25)");
     //			db.ExecSQL("INSERT INTO RUOKData (date_time, ergebnis) VALUES ('11.06.82 13:30', 25)");
     //			db.ExecSQL("INSERT INTO RUOKData (date_time, ergebnis) VALUES ('11.06.82 13:30', 25)");
     //			db.ExecSQL("INSERT INTO RUOKData (date_time, ergebnis) VALUES ('11.06.82 13:30', 25)");
     //			db.ExecSQL("INSERT INTO RUOKData (date_time, ergebnis) VALUES ('11.06.82 13:30', 25)");
 }
 public override void OnCreate(SQLiteDatabase db)
 {
     db.ExecSQL(create_table_sql);
     // seed with data
     db.ExecSQL("INSERT INTO vegetables (name) VALUES ('Vegetables')");
     db.ExecSQL("INSERT INTO vegetables (name) VALUES ('Fruits')");
     db.ExecSQL("INSERT INTO vegetables (name) VALUES ('Flower Buds')");
     db.ExecSQL("INSERT INTO vegetables (name) VALUES ('Legumes')");
     db.ExecSQL("INSERT INTO vegetables (name) VALUES ('Bulbs')");
     db.ExecSQL("INSERT INTO vegetables (name) VALUES ('Tubers')");
 }
Ejemplo n.º 14
0
 public override void OnCreate(SQLiteDatabase db)
 {
     db.ExecSQL(
         string.Format(@"
             CREATE TABLE {0} (
                 {1} integer primary key autoincrement,
                 {2} text not null,
                 {3} text not null
             )",
             NoteDatabaseConstants.TableName,
             NoteDatabaseConstants.IdColumn,
             NoteDatabaseConstants.TitleColumn,
             NoteDatabaseConstants.ContentColumn
         ));
 }
Ejemplo n.º 15
0
 //Creates a new database which name is given by the parameter
 public void CreateDatabase(string sqldb_name)
 {
     try
     {
         sqldb_message = "";
         string sqldb_location = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal);
         string sqldb_path = Path.Combine(sqldb_location, sqldb_name);
         bool sqldb_exists = File.Exists(sqldb_path);
         if(!sqldb_exists)
         {
             sqldb = SQLiteDatabase.OpenOrCreateDatabase(sqldb_path,null);
             sqldb_query = "CREATE TABLE IF NOT EXISTS Employee (_id INTEGER PRIMARY KEY AUTOINCREMENT, Id VARCHAR, Title VARCHAR, Email VARCHAR, City VARCHAR, Picture VARCHAR, ImageUrl VARCHAR, ReportCount VARCHAR, FName VARCHAR, LName VARCHAR, ManagerId VARCHAR, Department VARCHAR, OfficePhone VARCHAR, CellPhone VARCHAR);";
             sqldb.ExecSQL(sqldb_query);
             sqldb_message = "Database: " + sqldb_name + " created";
         }
         else
         {
             sqldb = SQLiteDatabase.OpenDatabase(sqldb_path, null, DatabaseOpenFlags.OpenReadwrite);
             sqldb_message = "Database: " + sqldb_name + " opened";
         }
         sqldb_available=true;
     }
     catch(SQLiteException ex)
     {
         sqldb_message = ex.Message;
     }
 }
Ejemplo n.º 16
0
			/// <param name="db">The database.</param>
			/// <param name="oldVersion">The old database version.</param>
			/// <param name="newVersion">The new database version.</param>
			/// <summary>
			/// Called when the database needs to be upgraded.
			/// </summary>
			public override void OnUpgrade (SQLiteDatabase db, int oldVersion, int newVersion)
			{
				Log.Warn (TAG, "Actulizando la version de la base de datos " + oldVersion + " a la "	+ newVersion + ", los datos de la version anterior seran borrados.");
				db.ExecSQL ("DROP TABLE IF EXISTS " + FTS_VIRTUAL_TABLE);
				OnCreate (db);
			}
Ejemplo n.º 17
0
			/// <param name="db">The database.</param>
			/// <summary>
			/// Este evento se llama cuando se crea por primera vez.
			/// Ademas ejecuta las sentencias necesarias para construir la tablas de la base de datos
			/// </summary>
			public override async void OnCreate (SQLiteDatabase db)
			{
				database = db;
				//Crea la tabla ejecutando el query
				database.ExecSQL (FTS_TABLE_CREATE);
				//Manda llamar un metodo para cargar los paises 
				await LLamaCargaDatosAsync ();
			}
Ejemplo n.º 18
0
        public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
        {
            db.ExecSQL("DROP TABLE IF EXISTS Note");

            OnCreate(db);
        }
Ejemplo n.º 19
0
        public void Save(MarkovFactory factory)
        {
            Log.Debug ( TAG, "Saving chain." );
            myDatabase = context.OpenOrCreateDatabase(DATABASE_NAME, FileCreationMode.Private, null);
            myDatabase.ExecSQL("DROP TABLE IF EXISTS 'words'");
            myDatabase.ExecSQL("CREATE TABLE IF NOT EXISTS 'words' (firstWord TEXT, secondWord TEXT, instanceCount INTEGER NOT NULL);");

            var chain = factory.chain;
            DatabaseUtils.InsertHelper ih = new DatabaseUtils.InsertHelper (myDatabase, "words");

            Stopwatch stopwatch = Stopwatch.StartNew();
            StringBuilder insertQuery = new StringBuilder();

            //insertQuery.Append("INSERT INTO 'words' ('firstWord', 'secondWord', 'instanceCount') VALUES (?, ?, ?)");
            myDatabase.BeginTransaction();
            string sql = "INSERT INTO 'words' ('firstWord', 'secondWord', 'instanceCount') VALUES (?, ?, ?)";
            SQLiteStatement insert = myDatabase.CompileStatement(sql);

            foreach (KeyValuePair<string, MarkovWord> word in chain)
            {
                foreach (KeyValuePair<MarkovWord, int> after in word.Value.afters)
                {
                    insert.BindString(1, word.Value.word);
                    insert.BindString(2, after.Key.word);
                    insert.BindDouble(3, after.Value);
                    insert.Execute();
                }
            }
            myDatabase.SetTransactionSuccessful();
            myDatabase.EndTransaction();
            stopwatch.Stop ();
            Log.Debug (TAG, "Database insert completed in " + stopwatch.Elapsed.TotalMilliseconds);
        }
Ejemplo n.º 20
0
 public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
 {
     Log.Wtf(Tag, "Upgrading database from version " + oldVersion + " to " + newVersion + ", which will destroy all old data");
     db.ExecSQL("DROP TABLE IF EXISTS notes");
     this.OnCreate(db);
 }
Ejemplo n.º 21
0
 public override void OnCreate(SQLiteDatabase db)
 {
     db.ExecSQL(DatabaseCreate);
 }
 public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
 {
     // Production-quality upgrade code should modify the tables when
     // the database version changes instead of dropping the tables and
     // re-creating them.
     if (newVersion != DATABASE_VERSION)
     {
         Log.Warn(TAG, "Database upgrade from old: " + oldVersion + " to: " + newVersion);
         db.ExecSQL("DROP TABLE IF EXISTS " + PURCHASE_HISTORY_TABLE_NAME);
         db.ExecSQL("DROP TABLE IF EXISTS " + PURCHASED_ITEMS_TABLE_NAME);
         CreatePurchaseTable(db);
         return;
     }
 }
 public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
 {
     Log.Warn (TAG, "Upgrading database from version " + oldVersion + " to "
         + newVersion + ", which will destroy all old data");
     db.ExecSQL ("DROP TABLE IF EXISTS " + FTS_VIRTUAL_TABLE);
     OnCreate (db);
 }
 /// <summary>
 /// Ons the upgrade.
 /// </summary>
 /// <param name='db'>Db.</param>
 /// <param name='oldVersion'>Old version.</param>
 /// <param name='newVersion'>New version.</param>
 public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
 {
     Log.Warn(GetType().Name,"Upgrading database from version " + oldVersion + " to " + newVersion + ", which will destroy all old data");
       db.ExecSQL("DROP TABLE IF EXISTS " + Device.TABLE_NAME);
       db.ExecSQL("DROP TABLE IF EXISTS " + Subscription.TABLE_NAME);
       db.ExecSQL("DROP TABLE IF EXISTS " + Episode.TABLE_NAME);
       OnCreate(db);
 }
Ejemplo n.º 25
0
 public override void OnCreate(SQLiteDatabase db)
 {
     db.ExecSQL(@"CREATE TABLE Task(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, description TEXT, done INTEGER);");
 }
 private void CreatePurchaseTable(SQLiteDatabase db)
 {
     db.ExecSQL("CREATE TABLE " + PURCHASE_HISTORY_TABLE_NAME + "(" + HISTORY_ORDER_ID_COL + " TEXT PRIMARY KEY, " + HISTORY_STATE_COL + " INTEGER, " + HISTORY_PRODUCT_ID_COL + " TEXT, " + HISTORY_DEVELOPER_PAYLOAD_COL + " TEXT, " + HISTORY_PURCHASE_TIME_COL + " INTEGER)");
     db.ExecSQL("CREATE TABLE " + PURCHASED_ITEMS_TABLE_NAME + "(" + PURCHASED_PRODUCT_ID_COL + " TEXT PRIMARY KEY, " + PURCHASED_QUANTITY_COL + " INTEGER)");
 }
 public override void OnCreate(SQLiteDatabase db)
 {
     db.ExecSQL(create_table_sql);
     // seed with data
     db.ExecSQL("INSERT INTO Superheroes (name, description) VALUES ('Adam Strange', 'Adam Strange is the human champion of the alien planet Rann, an archaeologist who fights monsters using a jet pack and ray gun')");
     db.ExecSQL("INSERT INTO Superheroes (name, description) VALUES ('Alfred Pennyworth', 'Alfred Pennyworth is the British butler and valet to the Wayne Family. He took up the role of legal guardian of Bruce Wayne after the murder of Thomas and Martha Wayne')");
     db.ExecSQL("INSERT INTO Superheroes (name, description) VALUES ('Amanda Waller', 'Amanda The Wall Waller is a hardline top-ranking U.S. Government agent involved in clandestine operations')");
     db.ExecSQL("INSERT INTO Superheroes (name, description) VALUES ('Amazo', 'Amazo is a robotic enemy of the Justice League of America, a deadly android designed by the mad scientist Professor Ivo')");
     db.ExecSQL("INSERT INTO Superheroes (name, description) VALUES ('Bane', 'Bane is a brilliant world-class fighter and tactical genius who augments his great physical strength with a steroid called venom')");
     db.ExecSQL("INSERT INTO Superheroes (name, description) VALUES ('Batman', 'Batman is the super-hero protector of Gotham City, a man dressed like a bat who fights against evil and strikes terror into the hearts of criminals everywhere')");
     db.ExecSQL("INSERT INTO Superheroes (name, description) VALUES ('Superman', 'Superman, also known as the Man of Steel, is one of the most powerful superheroes in the DC Universe. His abilities include incredible super-strength, super-speed, invulnerability, freezing breath, flight, and heat-vision')");
     db.ExecSQL("INSERT INTO Superheroes (name, description) VALUES ('Animal Man', 'Animal Man is a super-hero who can use the abilities of any animal. His powers are gained from tapping into the morphogenic field known as The Red, giving him the power of any animal on the planet and sometimes the universe')");
     db.ExecSQL("INSERT INTO Superheroes (name, description) VALUES ('Anti-Monitor', 'The Anti-Monitor is a supremely powerful being who controls the Antimatter Universe, acting as an evil counterpart to his brother the Monitor')");
     db.ExecSQL("INSERT INTO Superheroes (name, description) VALUES ('Aqualad', 'Aqualad, also known as Garth is Aquamans teenage sidekick. As an adult he took the name Tempest. He is a member of the Aquaman Family along with other side-kicks including Aquagirl and Dolphin')");
     //db.ExecSQL("INSERT INTO Superheroes (name, description) VALUES ('', '')");
 }
Ejemplo n.º 28
0
 public override void OnCreate(SQLiteDatabase db)
 {
     db.ExecSQL(VehicleTable.SQL_TO_CREATE_VEHICLES_TABLE);
     db.ExecSQL(TripTable.SQL_TO_CREATE_TRIPS_TABLE);
     db.ExecSQL(VehicleTripDescriptionTable.SQL_TO_CREATE_VEHICLE_TRIP_DESCRIPTIONS_TABLE);
 }
        /// <summary>
        /// Ons the create.
        /// </summary>
        /// <param name='database'>Database.</param>
        public override void OnCreate(SQLiteDatabase database)
        {
            string sql = string.Empty;

              // create the device table
              sql = "create table " + Device.TABLE_NAME + "(";
              sql += Device.COL_ID + " text primary key,";
              sql += Device.COL_CAPTION + " text not null,";
              sql += Device.COL_TYPE + " text not null,";
              sql += Device.COL_SUBSCRIPTIONS + " int);";
              database.ExecSQL(sql);

              // create the subscription table
              sql = "create table " + Subscription.TABLE_NAME + "(";
              sql += Subscription.COL_TITLE + " text primary key,";
              sql += Subscription.COL_DESCRIPTION + " text,";
              sql += Subscription.COL_LOGO_URL + " text,";
              sql += Subscription.COL_MYGPO_LINK + " text,";
              sql += Subscription.COL_POSITION_LAST_WEEK + " int,";
              sql += Subscription.COL_SCALED_LOGO_URL + " text,";
              sql += Subscription.COL_SUBSCRIBERS + " int,";
              sql += Subscription.COL_SUBSRIBERS_LAST_WEEK + " int,";
              sql += Subscription.COL_URL + " text,";
              sql += Subscription.COL_WEBSITE + " text);";
              database.ExecSQL(sql);

              // create the episode table
              sql = "create table " + Episode.TABLE_NAME + "(";
              sql += Episode.COL_URL + " text primary key,";
              sql += Episode.COL_DESCRIPTION + " text,";
              sql += Episode.COL_MYGPO_LINK + " text,";
              sql += Episode.COL_PODCAST_TITLE + " text,";
              sql += Episode.COL_PODCAST_URL + " text,";
              sql += Episode.COL_RELEASED + " text,";
              sql += Episode.COL_STATUS + " text,";
              sql += Episode.COL_TITLE + " text,";
              sql += Episode.COL_PLAYER_POSITION + " int,";
              sql += Episode.COL_DURATION + " int,";
              sql += Episode.COL_WEBSITE + " text);";
              database.ExecSQL(sql);
        }
 public override void OnCreate(SQLiteDatabase db)
 {
     database = db;
     database.ExecSQL (FTS_TABLE_CREATE);
     LoadDictionary ();
 }