public static void OnInitialize(EventArgs args)
{
database = Database.InitDb("Statistics");
tshock = Database.InitDb("tshock");
var table = new SqlTable("Statistics",
new SqlColumn("ID", MySqlDbType.Int32)
{
Unique = true, Primary = true, AutoIncrement = true
},
new SqlColumn("UserID", MySqlDbType.Int32)
{
Unique = true
},
new SqlColumn("Time", MySqlDbType.Int32),
new SqlColumn("PlayerKills", MySqlDbType.Int32),
new SqlColumn("Deaths", MySqlDbType.Int32),
new SqlColumn("MobKills", MySqlDbType.Int32),
new SqlColumn("BossKills", MySqlDbType.Int32),
new SqlColumn("Logins", MySqlDbType.Int32),
new SqlColumn("MobDamageGiven", MySqlDbType.Int32),
new SqlColumn("BossDamageGiven", MySqlDbType.Int32),
new SqlColumn("PlayerDamageGiven", MySqlDbType.Int32),
new SqlColumn("DamageReceived", MySqlDbType.Int32));
var table2 = new SqlTable("Highscores",
new SqlColumn("ID", MySqlDbType.Int32)
{
Unique = true, Primary = true, AutoIncrement = true
},
new SqlColumn("UserID", MySqlDbType.Int32)
{
Unique = true
},
new SqlColumn("Score", MySqlDbType.Int32));
var table3 = new SqlTable("KillingSpree",
new SqlColumn("ID", MySqlDbType.Int32)
{
Unique = true, Primary = true, AutoIncrement = true
},
new SqlColumn("UserID", MySqlDbType.Int32),
new SqlColumn("StartSpree", MySqlDbType.Text),
new SqlColumn("Deleted", MySqlDbType.Int32),
new SqlColumn("Player", MySqlDbType.Int32),
new SqlColumn("Mob", MySqlDbType.Int32),
new SqlColumn("Boss", MySqlDbType.Int32),
new SqlColumn("Combined", MySqlDbType.Int32));
database.EnsureExists(table, table2);
database.EnsureExists(table3);
}
private void OnInitialize(EventArgs args)
{
database = Database.InitDb("Statistics");
tshock = Database.InitDb("tshock");
var table = new SqlTable("Statistics",
new SqlColumn("UserID", MySqlDbType.Int32),
new SqlColumn("Time", MySqlDbType.Int32),
new SqlColumn("Logins", MySqlDbType.Int32),
new SqlColumn("UserName", MySqlDbType.Text),
new SqlColumn("UserGroup", MySqlDbType.Text));
database.EnsureExists(table);
}
private void OnInitialize(EventArgs args)
{
database = Database.InitDb("Statistics");
tshock = Database.InitDb("tshock");
var table = new SqlTable("Statistics",
new SqlColumn("ID", MySqlDbType.Int32)
{
Unique = true, Primary = true, AutoIncrement = true
},
new SqlColumn("UserID", MySqlDbType.Int32)
{
Unique = true
},
new SqlColumn("Time", MySqlDbType.Int32),
new SqlColumn("PlayerKills", MySqlDbType.Int32),
new SqlColumn("Deaths", MySqlDbType.Int32),
new SqlColumn("MobKills", MySqlDbType.Int32),
new SqlColumn("BossKills", MySqlDbType.Int32),
new SqlColumn("Logins", MySqlDbType.Int32),
new SqlColumn("MobDamageGiven", MySqlDbType.Int32),
new SqlColumn("BossDamageGiven", MySqlDbType.Int32),
new SqlColumn("PlayerDamageGiven", MySqlDbType.Int32),
new SqlColumn("DamageReceived", MySqlDbType.Int32));
var table2 = new SqlTable("Highscores",
new SqlColumn("ID", MySqlDbType.Int32)
{
Unique = true, Primary = true, AutoIncrement = true
},
new SqlColumn("UserID", MySqlDbType.Int32)
{
Unique = true
},
new SqlColumn("Score", MySqlDbType.Int32));
database.EnsureExists(table, table2);
//database.Import();
}