protected override void Awake() { base.Awake(); #if UNITY_EDITOR PlayerSettings.bundleVersion = buildVersion; // set db // The example does not use the auto-generation db and table(DDL). Sqlite sql = new Sqlite(); if (sql.CreateFile("hellgate.db")) { sql.CreateTable("hellgate.db", new Board().GetType()); sql.CreateTable("hellgate.db", new Comment().GetType()); } // if (sql.CreateFile ("Hellgate.db")) { // sql.ExecuteNonQuery ("CREATE TABLE `board` ( " + // "`idx` INTEGER PRIMARY KEY AUTOINCREMENT, " + // "`name` TEXT, " + // "`description` TEXT " + // ");"); // } #endif // add BGM SoundManager.Instance.AddBGM(bgm); SoundManager.Instance.PlayBGM(); }
private void CreateTables() { // PLayer Table try { //sqlcon.DeleteTable<Players>(); sqlcon.CreateTable <Players>(); } catch (Exception ex) { } // Games Table sqlcon.CreateTable <Games>(); }
private void Form1_Load(object sender, EventArgs e) { Sqlite.Sqlinit(); timer1.Start(); metroLabel1.Text = "版本:" + System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString(); Sqlite.CreateTable("OutTable", new string[] { "ID", "Email", "Name", "Password", "CreatTime" }, new string[] { "integer", "text", "text", "text", "text" }); Untils.Filldgv("OutTable", dgv_OL); Sqlite.CreateTable("EATable", new string[] { "ID", "Email", "Name", "Password", "CreatTime" }, new string[] { "integer", "text", "text", "text", "text" }); Untils.Filldgv("EATable", dgv_EA); Sqlite.CreateTable("ProtonTable", new string[] { "ID", "Email", "Name", "Password", "CreatTime" }, new string[] { "integer", "text", "text", "text", "text" }); Untils.Filldgv("ProtonTable", dgv_pro); }