Advertisement
morante2919

airlines_sql

Feb 9th, 2023
210
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 2.09 KB | None | 0 0
  1. USE [master]
  2. GO
  3.  
  4.  
  5. CREATE DATABASE [WWWings66]
  6. GO
  7.  
  8.  
  9. ALTER DATABASE [WWWings66] SET COMPATIBILITY_LEVEL = 100
  10. GO
  11.  
  12. IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
  13. begin
  14. EXEC [WWWings66].[dbo].[sp_fulltext_database] @action = 'enable'
  15. end
  16. GO
  17.  
  18. ALTER DATABASE [WWWings66] SET ANSI_NULL_DEFAULT OFF
  19. GO
  20.  
  21. ALTER DATABASE [WWWings66] SET ANSI_NULLS OFF
  22. GO
  23.  
  24. ALTER DATABASE [WWWings66] SET ANSI_PADDING OFF
  25. GO
  26.  
  27. ALTER DATABASE [WWWings66] SET ANSI_WARNINGS OFF
  28. GO
  29.  
  30. ALTER DATABASE [WWWings66] SET ARITHABORT OFF
  31. GO
  32.  
  33. ALTER DATABASE [WWWings66] SET AUTO_CLOSE ON
  34. GO
  35.  
  36. ALTER DATABASE [WWWings66] SET AUTO_CREATE_STATISTICS ON
  37. GO
  38.  
  39. ALTER DATABASE [WWWings66] SET AUTO_SHRINK OFF
  40. GO
  41.  
  42. ALTER DATABASE [WWWings66] SET AUTO_UPDATE_STATISTICS ON
  43. GO
  44.  
  45. ALTER DATABASE [WWWings66] SET CURSOR_CLOSE_ON_COMMIT OFF
  46. GO
  47.  
  48. ALTER DATABASE [WWWings66] SET CURSOR_DEFAULT  GLOBAL
  49. GO
  50.  
  51. ALTER DATABASE [WWWings66] SET CONCAT_NULL_YIELDS_NULL OFF
  52. GO
  53.  
  54. ALTER DATABASE [WWWings66] SET NUMERIC_ROUNDABORT OFF
  55. GO
  56.  
  57. ALTER DATABASE [WWWings66] SET QUOTED_IDENTIFIER OFF
  58. GO
  59.  
  60. ALTER DATABASE [WWWings66] SET RECURSIVE_TRIGGERS OFF
  61. GO
  62.  
  63. ALTER DATABASE [WWWings66] SET  DISABLE_BROKER
  64. GO
  65.  
  66. ALTER DATABASE [WWWings66] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
  67. GO
  68.  
  69. ALTER DATABASE [WWWings66] SET DATE_CORRELATION_OPTIMIZATION OFF
  70. GO
  71.  
  72. ALTER DATABASE [WWWings66] SET TRUSTWORTHY OFF
  73. GO
  74.  
  75. ALTER DATABASE [WWWings66] SET ALLOW_SNAPSHOT_ISOLATION OFF
  76. GO
  77.  
  78. ALTER DATABASE [WWWings66] SET PARAMETERIZATION SIMPLE
  79. GO
  80.  
  81. ALTER DATABASE [WWWings66] SET READ_COMMITTED_SNAPSHOT OFF
  82. GO
  83.  
  84. ALTER DATABASE [WWWings66] SET HONOR_BROKER_PRIORITY OFF
  85. GO
  86.  
  87. ALTER DATABASE [WWWings66] SET  READ_WRITE
  88. GO
  89.  
  90. ALTER DATABASE [WWWings66] SET RECOVERY FULL
  91. GO
  92.  
  93. ALTER DATABASE [WWWings66] SET  MULTI_USER
  94. GO
  95.  
  96. ALTER DATABASE [WWWings66] SET PAGE_VERIFY CHECKSUM  
  97. GO
  98.  
  99. ALTER DATABASE [WWWings66] SET DB_CHAINING OFF
  100. GO
  101.  
  102. EXEC [WWWings66].sys.sp_addextendedproperty @name=N'SchemaLastUpdate', @value=N'7.6.2010'
  103. GO
  104.  
  105. EXEC [WWWings66].sys.sp_addextendedproperty @name=N'SchemaVersion', @value=N'6.2.1'
  106. GO
  107.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement