public static void MusicItemsTable(IdbMigration db) { var t = new TableMigration { HasIdentity = true, TableName = xmConsts.MusicItems }; t.Fields = new List <TableMigrationField>(); t.Fields.Add(new TableMigrationField { FieldName = "Artist", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 5000, IsNullAble = true }); t.Fields.Add(new TableMigrationField { FieldName = "FullFileName", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 5000, IsNullAble = true }); t.Fields.Add(new TableMigrationField { FieldName = "FileName", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 5000, IsNullAble = true }); t.Fields.Add(new TableMigrationField { FieldName = "Title", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 5000, IsNullAble = true }); t.Fields.Add(new TableMigrationField { FieldName = "MachineName", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 5000, IsNullAble = true }); //t.Fields.Add(new TableMigrationField { FieldName = "ToUsb", FieldType = TableMigrationFieldType.Bit, IsNullAble = true }); //t.Fields.Add(new TableMigrationField { FieldName = "ToPlaylist", FieldType = TableMigrationFieldType.Bit, IsNullAble = true }); db.ExecurteCreateTable(t.ToString()); }
public static void UserPlaylistsTable(IdbMigration db) { var t = new TableMigration { HasIdentity = true, TableName = xmConsts.UserPlayList }; t.Fields = new List <TableMigrationField>(); t.Fields.Add(new TableMigrationField { FieldName = "UserId", FieldType = TableMigrationFieldType.Integer, IsNullAble = true }); t.Fields.Add(new TableMigrationField { FieldName = "ItemId", FieldType = TableMigrationFieldType.Integer, IsNullAble = true }); db.ExecurteCreateTable(t.ToString()); }
public static void UsersTable(IdbMigration db) { var t = new TableMigration { HasIdentity = true, TableName = xmConsts.Users }; t.Fields = new List <TableMigrationField>(); t.Fields.Add(new TableMigrationField { FieldName = "UserName", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 5000, IsNullAble = true }); t.Fields.Add(new TableMigrationField { FieldName = "Password", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 5000, IsNullAble = true }); db.ExecurteCreateTable(t.ToString()); }
//public static void T3(IDbMigration db) //{ // //var t = new TableMigration // //{ // // HasIdentity = true, // // TableName = "testmigration3" // //}; // //t.Fields = new List<TableMigrationField>(); // //t.Fields.Add(new TableMigrationField { FieldName = "col1", FieldType = TableMigrationFieldType.Integer, IsNullAble = false }); // //t.Fields.Add(new TableMigrationField { FieldName = "col2", FieldType = TableMigrationFieldType.Decimal, IsNullAble = true }); // //t.Fields.Add(new TableMigrationField { FieldName = "col3", FieldType = TableMigrationFieldType.Date, IsNullAble = true }); // //t.Fields.Add(new TableMigrationField { FieldName = "col4", FieldType = TableMigrationFieldType.Text, IsNullAble = true }); // //t.Fields.Add(new TableMigrationField { FieldName = "col5", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 500, IsNullAble = true }); // //db.ExecurteCreateTable(t.ToString()); //} public static void MigrationTable(IdbMigration db) { var t = new TableMigration { HasIdentity = true, TableName = "migItems" }; t.Fields = new List <TableMigrationField>(); t.Fields.Add(new TableMigrationField { FieldName = "Name", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 5000, IsNullAble = true }); t.Fields.Add(new TableMigrationField { FieldName = "Date", FieldType = TableMigrationFieldType.Date, IsNullAble = true }); db.ExecurteCreateTable(t.ToString()); }