Пример #1
0
        public static void Execute(IDbArchitecture db)
        {
            Audit.Message("\n  ** DROP TABLEs test **");
            db.DropTable(typeof(Folder), true);
            db.DropTable(typeof(Tag), true);
            db.DropTable(typeof(TagCategory), true);
            db.DropTable(typeof(UserAttribute), true);
            db.DropTable(typeof(UserSession), true);
            db.DropTable(typeof(User), true);
            db.DropTable(typeof(StatusConnection), true);

            Audit.Message("\n  ** CREATE TABLEs test **");
            db.CreateTable(typeof(User));
            db.CreateTable(typeof(UserSession));
            db.CreateTable(typeof(UserAttribute));
            db.CreateTable(typeof(StatusConnection));
            db.CreateTable(typeof(Folder));
            db.CreateTable(typeof(TagCategory));
            db.CreateTable(typeof(Tag));

            Audit.Message("\n  ** CREATE STORED PROCEDURES test **");
            CreateAllStoredProcedures(db, typeof(Folder));
            CreateAllStoredProcedures(db, typeof(Tag));
            CreateAllStoredProcedures(db, typeof(TagCategory));
            CreateAllStoredProcedures(db, typeof(User));
            CreateAllStoredProcedures(db, typeof(UserSession));
            CreateAllStoredProcedures(db, typeof(UserAttribute));
            CreateAllStoredProcedures(db, typeof(StatusConnection));
        }