Пример #1
0
        public static void UsersTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.Users
            };

            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "UserName", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "DisplayName", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Password", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 12
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "AllowedClientPagePermissions", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000, IsNullAble = true
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "EmailAdress", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000, IsNullAble = true
            });
            db.ExecurteCreateTable(t.ToString());
        }
        public static void DiaryTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.DiaryData
            };

            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "title", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000, IsNullAble = true
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "description", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000, IsNullAble = true
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "date", FieldType = TableMigrationFieldType.Date
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "CreationDate", FieldType = TableMigrationFieldType.Date
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Shared", FieldType = TableMigrationFieldType.Bit
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "RepeatEvery", FieldType = TableMigrationFieldType.Integer, IsNullAble = true
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "UserId", FieldType = TableMigrationFieldType.Integer
            });

            db.ExecurteCreateTable(t.ToString());
        }
        public static void WorkHoursDataTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.WorkHoursData
            };

            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "Month", FieldType = TableMigrationFieldType.Date
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Active", FieldType = TableMigrationFieldType.Bit
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "CurrentMonthTotal", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "CurrentShiftStart", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "CurrentShiftEnd", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000
            });
            db.ExecurteCreateTable(t.ToString());
        }
        public static void SQuickTasksDataTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.QuickTasks
            };


            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "Name", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000, IsNullAble = true
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Description", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000, IsNullAble = true
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Active", FieldType = TableMigrationFieldType.Bit
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "CreationDate", FieldType = TableMigrationFieldType.Date
            });

            db.ExecurteCreateTable(t.ToString());
        }
        public static void MoneyTransactionsTemplatesTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.MoneyTransactionTemplatess
            };

            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "TransactionType", FieldType = TableMigrationFieldType.Integer
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Amount", FieldType = TableMigrationFieldType.Integer
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Active", FieldType = TableMigrationFieldType.Bit
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Auto", FieldType = TableMigrationFieldType.Bit
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Name", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000
            });

            t.Fields.Add(new TableMigrationField {
                FieldName = "FromDate", FieldType = TableMigrationFieldType.Date
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "ToDate", FieldType = TableMigrationFieldType.Date, IsNullAble = true
            });

            db.ExecurteCreateTable(t.ToString());
        }
        public static void PermissionGroupsTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.PermissionGroups
            };

            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "Name", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000
            });

            db.ExecurteCreateTable(t.ToString());
        }
        public static void LottoRowsTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.LottoRows
            };

            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "N1", FieldType = TableMigrationFieldType.Integer, IsNullAble = false
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "N2", FieldType = TableMigrationFieldType.Integer, IsNullAble = false
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "N3", FieldType = TableMigrationFieldType.Integer, IsNullAble = false
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "N4", FieldType = TableMigrationFieldType.Integer, IsNullAble = false
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "N5", FieldType = TableMigrationFieldType.Integer, IsNullAble = false
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "N6", FieldType = TableMigrationFieldType.Integer, IsNullAble = false
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "S", FieldType = TableMigrationFieldType.Integer, IsNullAble = false
            });

            t.Fields.Add(new TableMigrationField {
                FieldName = "PoleKey", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 250, IsNullAble = true
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "PoleDestinationDate", FieldType = TableMigrationFieldType.Date
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "CreationDate", FieldType = TableMigrationFieldType.Date
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "WinsData", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000, IsNullAble = true
            });

            db.ExecurteCreateTable(t.ToString());
        }
        public static void GoogleAPICredentialsTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                TableName = SynnDataProvider.TableNames.GoogleAPICredentials
            };

            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "userid", FieldType = TableMigrationFieldType.Integer
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Credentials", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000
            });

            db.ExecurteCreateTable(t.ToString());
        }
        public static void ShiftsDataTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.ShiftsData
            };

            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "DaylyShift", FieldType = TableMigrationFieldType.Integer
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Date", FieldType = TableMigrationFieldType.Date
            });

            db.ExecurteCreateTable(t.ToString());
        }
        public static void UserPreferencesTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.UserPreferences
            };

            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "pdata", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "UserId", FieldType = TableMigrationFieldType.Integer
            });

            db.ExecurteCreateTable(t.ToString());
        }
Пример #11
0
        public static void MigrationItemsTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.MigrationItems
            };

            t.Fields = new List <TableMigrationField>();

            t.Fields.Add(new TableMigrationField {
                FieldName = "Name", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 500, IsNullAble = true
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Date", FieldType = TableMigrationFieldType.Date
            });

            db.ExecurteCreateTable(t.ToString());
        }
        public static void WeddingItemsTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.WeddingItems
            };


            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "GuestName", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000, IsNullAble = true
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Payment", FieldType = TableMigrationFieldType.Integer
            });

            db.ExecurteCreateTable(t.ToString());
        }
        public static void UserDictionaryTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.UserDictionary
            };


            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "dKey", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000, IsNullAble = true
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Value", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000, IsNullAble = true
            });

            db.ExecurteCreateTable(t.ToString());
        }
        public static void DevTasksTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.DevTasks
            };

            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "Status", FieldType = TableMigrationFieldType.Integer, IsNullAble = false
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Name", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 500, IsNullAble = true
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Description", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000, IsNullAble = true
            });

            db.ExecurteCreateTable(t.ToString());
        }
        public static void ThemeItemsTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.ThemeItems
            };

            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "ElementIdentifier", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000, IsNullAble = false
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "CssAttribute", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000, IsNullAble = false
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "CssValue", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000, IsNullAble = false
            });

            db.ExecurteCreateTable(t.ToString());
        }
Пример #16
0
        public static void LogTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.Log
            };


            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "Message", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Trace", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Date", FieldType = TableMigrationFieldType.Date
            });

            db.ExecurteCreateTable(t.ToString());
        }
        public static void MoneyTransactionItems(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.MoneyTransactionItems
            };

            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "Amount", FieldType = TableMigrationFieldType.Integer
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "TemplateId", FieldType = TableMigrationFieldType.Integer
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Month", FieldType = TableMigrationFieldType.Date
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Closed", FieldType = TableMigrationFieldType.Bit
            });

            db.ExecurteCreateTable(t.ToString());
        }
        public static void ShoppingItemsTable(IDbMigration db)
        {
            var t = new TableMigration
            {
                HasIdentity = true,
                TableName   = SynnDataProvider.TableNames.ShoppingItems
            };

            t.Fields = new List <TableMigrationField>();
            t.Fields.Add(new TableMigrationField {
                FieldName = "Name", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 4000, IsNullAble = true
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "LastBought", FieldType = TableMigrationFieldType.Date, IsNullAble = true
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "Active", FieldType = TableMigrationFieldType.Bit
            });
            t.Fields.Add(new TableMigrationField {
                FieldName = "CategoryId", FieldType = TableMigrationFieldType.Bit, IsNullAble = true
            });

            db.ExecurteCreateTable(t.ToString());
        }