1
0

001_EstateStore.sql 2.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485
  1. BEGIN TRANSACTION
  2. CREATE TABLE [dbo].[estate_managers](
  3. [EstateID] [int] NOT NULL,
  4. [uuid] [varchar](36) NOT NULL,
  5. CONSTRAINT [PK_estate_managers] PRIMARY KEY CLUSTERED
  6. (
  7. [EstateID] ASC
  8. )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
  9. ) ON [PRIMARY];
  10. CREATE TABLE [dbo].[estate_groups](
  11. [EstateID] [int] NOT NULL,
  12. [uuid] [varchar](36) NOT NULL,
  13. CONSTRAINT [PK_estate_groups] PRIMARY KEY CLUSTERED
  14. (
  15. [EstateID] ASC
  16. )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
  17. ) ON [PRIMARY];
  18. CREATE TABLE [dbo].[estate_users](
  19. [EstateID] [int] NOT NULL,
  20. [uuid] [varchar](36) NOT NULL,
  21. CONSTRAINT [PK_estate_users] PRIMARY KEY CLUSTERED
  22. (
  23. [EstateID] ASC
  24. )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
  25. ) ON [PRIMARY];
  26. CREATE TABLE [dbo].[estateban](
  27. [EstateID] [int] NOT NULL,
  28. [bannedUUID] [varchar](36) NOT NULL,
  29. [bannedIp] [varchar](16) NOT NULL,
  30. [bannedIpHostMask] [varchar](16) NOT NULL,
  31. [bannedNameMask] [varchar](64) NULL DEFAULT (NULL),
  32. CONSTRAINT [PK_estateban] PRIMARY KEY CLUSTERED
  33. (
  34. [EstateID] ASC
  35. )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
  36. ) ON [PRIMARY];
  37. CREATE TABLE [dbo].[estate_settings](
  38. [EstateID] [int] IDENTITY(1,100) NOT NULL,
  39. [EstateName] [varchar](64) NULL DEFAULT (NULL),
  40. [AbuseEmailToEstateOwner] [bit] NOT NULL,
  41. [DenyAnonymous] [bit] NOT NULL,
  42. [ResetHomeOnTeleport] [bit] NOT NULL,
  43. [FixedSun] [bit] NOT NULL,
  44. [DenyTransacted] [bit] NOT NULL,
  45. [BlockDwell] [bit] NOT NULL,
  46. [DenyIdentified] [bit] NOT NULL,
  47. [AllowVoice] [bit] NOT NULL,
  48. [UseGlobalTime] [bit] NOT NULL,
  49. [PricePerMeter] [int] NOT NULL,
  50. [TaxFree] [bit] NOT NULL,
  51. [AllowDirectTeleport] [bit] NOT NULL,
  52. [RedirectGridX] [int] NOT NULL,
  53. [RedirectGridY] [int] NOT NULL,
  54. [ParentEstateID] [int] NOT NULL,
  55. [SunPosition] [float] NOT NULL,
  56. [EstateSkipScripts] [bit] NOT NULL,
  57. [BillableFactor] [float] NOT NULL,
  58. [PublicAccess] [bit] NOT NULL,
  59. [AbuseEmail] [varchar](255) NOT NULL,
  60. [EstateOwner] [varchar](36) NOT NULL,
  61. [DenyMinors] [bit] NOT NULL,
  62. CONSTRAINT [PK_estate_settings] PRIMARY KEY CLUSTERED
  63. (
  64. [EstateID] ASC
  65. )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
  66. ) ON [PRIMARY];
  67. CREATE TABLE [dbo].[estate_map](
  68. [RegionID] [varchar](36) NOT NULL DEFAULT ('00000000-0000-0000-0000-000000000000'),
  69. [EstateID] [int] NOT NULL,
  70. CONSTRAINT [PK_estate_map] PRIMARY KEY CLUSTERED
  71. (
  72. [RegionID] ASC
  73. )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
  74. ) ON [PRIMARY];
  75. COMMIT