JustPaste.it

public override void OnCreate(SQLiteDatabase db)
{
//create database tables
//db.ExecSQL(@"DROP DATABASE DNDMusicDB");


db.ExecSQL(@"
CREATE TABLE IF NOT EXISTS SoundEffectItemsName (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
Name TEXT UNIQUE NOT NULL,
Category TEXT,
Subcategory TEXT
)");

db.ExecSQL(@"
CREATE TABLE IF NOT EXISTS MusicItems (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
Name TEXT NOT NULL,
Tension TEXT NOT NULL,
Category TEXT,
Subcategory TEXT,
ResId INTEGER NOT NULL,
LoopStart INTEGER NOT NULL
)");
db.ExecSQL(@"
CREATE TABLE IF NOT EXISTS Ambient (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
Name TEXT NOT NULL,
Category TEXT,
Subcategory TEXT,
ResId INTEGER NOT NULL,
LoopStart INTEGER NOT NULL
)");

db.ExecSQL(@"
CREATE TABLE IF NOT EXISTS SoundEffectItemID (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
Name TEXT NOT NULL,
ResId INTEGER NOT NULL
)");

db.ExecSQL(@"
CREATE TABLE IF NOT EXISTS Themes (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
ThemeName TEXT NOT NULL,
ThemeDesc TEXT NOT NULL,
ThemeCategory TEXT,
ThemeSubcategory TEXT,
ThemeImg INTEGER NOT NULL
)");

db.ExecSQL(@"
CREATE TABLE IF NOT EXISTS MusicInThemes (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
ResId INTEGER NOT NULL,
ThemeId INTEGER NOT NULL
)");

}

public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
{
if (oldVersion < 2)
{
//perform any database upgrade tasks for versions prior to version 2
}
if (oldVersion < 3)
{
//perform any database upgrade tasks for versions prior to version 3
}
}
}
public class MusicFiles
{
public List<MusicItems> MusicItems { get; set; }

public List<SoundEffectsItems> SoundEffectsItems { get; set; }

public List<Ambient> Ambient { get; set; }

public List<Playlist> ListLow { get; set; }

public List<Playlist> ListMed { get; set; }

public List<Playlist> ListHigh { get; set; }

public List<Themes> AllThemes { get; set; }

public MusicFiles()
{
SoundEffectsItems = new List<SoundEffectsItems>
{
// new SoundEffectsItems(){ Name = "..", MultiResId = new int[] { Resource.Raw.SE_01, Resource.Raw.SE_02}},
};
}

}
public class MusicItems
{
[PrimaryKey, AutoIncrement]
public int Id { get; set; }

public String Name { get; set; }
public String Tension { get; set; }
public String Category { get; set; }
public String Subcategory { get; set; }
public int ResId { get; set; }
public int LoopStart { get; set; }
}
public class Playlist
{
public String Name { get; set; }
public int ResId { get; set; }
public int LoopStart { get; set; }
}
public class SoundEffectItemsName
{
[PrimaryKey, AutoIncrement]
public int Id { get; set; }

public String Name { get; set; }
public String Category { get; set; }
public String Subcategory { get; set; }
}
public class SoundEffectItemID
{
[PrimaryKey, AutoIncrement]
public int Id { get; set; }

public String Name { get; set; }
public int ResId { get; set; }
}
public class SoundEffectsItems
{
public String Name { get; set; }
public String Category { get; set; }
public String Subcategory { get; set; }
public int[] MultiResId { get; set; }
}
public class Ambient
{
[PrimaryKey, AutoIncrement]
public int Id { get; set; }

public String Name { get; set; }
public String Category { get; set; }
public String Subcategory { get; set; }
public int ResId { get; set; }
public int LoopStart { get; set; }
}
public class Themes
{
[PrimaryKey, AutoIncrement]
public int Id { get; set; }

public String ThemeName { get; set; }
public String ThemeDesc { get; set; }
public int ThemeImg { get; set; }
public String ThemeCategory { get; set; }
public String ThemeSubcategory { get; set; }
}
public class MusicInThemes
{
[PrimaryKey, AutoIncrement]
public int Id { get; set; }

public int ResId { get; set; }
public int ThemeId { get; set; }
}