EstateStore.migrations 3.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112
  1. :VERSION 12
  2. BEGIN TRANSACTION;
  3. -- ----------------------------
  4. -- Table structure for estate_groups
  5. -- ----------------------------
  6. CREATE TABLE IF NOT EXISTS "public"."estate_groups" (
  7. "EstateID" int4 NOT NULL,
  8. "uuid" uuid NOT NULL
  9. )
  10. WITH (OIDS=FALSE);
  11. -- Indexes structure for table estate_groups
  12. -- ----------------------------
  13. CREATE INDEX IF NOT EXISTS "ix_estate_groups" ON "public"."estate_groups" USING btree("EstateID" "pg_catalog"."int4_ops" ASC NULLS LAST);
  14. -- ----------------------------
  15. -- Table structure for estate_managers
  16. -- ----------------------------
  17. CREATE TABLE IF NOT EXISTS "public"."estate_managers" (
  18. "EstateID" int4 NOT NULL,
  19. "uuid" uuid NOT NULL
  20. )
  21. WITH (OIDS=FALSE);
  22. -- Indexes structure for table estate_managers
  23. -- ----------------------------
  24. CREATE INDEX IF NOT EXISTS "ix_estate_managers" ON "public"."estate_managers" USING btree("EstateID" "pg_catalog"."int4_ops" ASC NULLS LAST);
  25. -- ----------------------------
  26. -- Table structure for estate_map
  27. -- ----------------------------
  28. CREATE TABLE IF NOT EXISTS "public"."estate_map" (
  29. "RegionID" uuid NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'::uuid,
  30. "EstateID" int4 NOT NULL
  31. )
  32. WITH (OIDS=FALSE);
  33. -- Primary key structure for table estate_map
  34. -- ----------------------------
  35. ALTER TABLE "public"."estate_map" ADD PRIMARY KEY ("RegionID") NOT DEFERRABLE INITIALLY IMMEDIATE;
  36. -- ----------------------------
  37. -- Table structure for estate_settings
  38. -- ----------------------------
  39. CREATE TABLE IF NOT EXISTS "public"."estate_settings" (
  40. "EstateID" int4 NOT NULL DEFAULT nextval('estate_settings_id'::regclass),
  41. "EstateName" varchar(64) DEFAULT NULL::character varying COLLATE "default",
  42. "AbuseEmailToEstateOwner" bool NOT NULL,
  43. "DenyAnonymous" bool NOT NULL,
  44. "ResetHomeOnTeleport" bool NOT NULL,
  45. "FixedSun" bool NOT NULL,
  46. "DenyTransacted" bool NOT NULL,
  47. "BlockDwell" bool NOT NULL,
  48. "DenyIdentified" bool NOT NULL,
  49. "AllowVoice" bool NOT NULL,
  50. "UseGlobalTime" bool NOT NULL,
  51. "PricePerMeter" int4 NOT NULL,
  52. "TaxFree" bool NOT NULL,
  53. "AllowDirectTeleport" bool NOT NULL,
  54. "RedirectGridX" int4 NOT NULL,
  55. "RedirectGridY" int4 NOT NULL,
  56. "ParentEstateID" int4 NOT NULL,
  57. "SunPosition" float8 NOT NULL,
  58. "EstateSkipScripts" bool NOT NULL,
  59. "BillableFactor" float8 NOT NULL,
  60. "PublicAccess" bool NOT NULL,
  61. "AbuseEmail" varchar(255) NOT NULL COLLATE "default",
  62. "EstateOwner" uuid NOT NULL,
  63. "DenyMinors" bool NOT NULL,
  64. "AllowLandmark" bool NOT NULL DEFAULT true,
  65. "AllowParcelChanges" bool NOT NULL DEFAULT true,
  66. "AllowSetHome" bool NOT NULL DEFAULT true
  67. )
  68. WITH (OIDS=FALSE);
  69. -- Primary key structure for table estate_settings
  70. -- ----------------------------
  71. ALTER TABLE "public"."estate_settings" ADD PRIMARY KEY ("EstateID") NOT DEFERRABLE INITIALLY IMMEDIATE;
  72. -- ----------------------------
  73. -- Table structure for estate_users
  74. -- ----------------------------
  75. CREATE TABLE IF NOT EXISTS "public"."estate_users" (
  76. "EstateID" int4 NOT NULL,
  77. "uuid" uuid NOT NULL
  78. )
  79. WITH (OIDS=FALSE);
  80. -- Indexes structure for table estate_users
  81. -- ----------------------------
  82. CREATE INDEX IF NOT EXISTS "ix_estate_users" ON "public"."estate_users" USING btree("EstateID" "pg_catalog"."int4_ops" ASC NULLS LAST);
  83. -- ----------------------------
  84. -- Table structure for estateban
  85. -- ----------------------------
  86. CREATE TABLE IF NOT EXISTS "public"."estateban" (
  87. "EstateID" int4 NOT NULL,
  88. "bannedUUID" uuid NOT NULL,
  89. "bannedIp" varchar(16) COLLATE "default",
  90. "bannedIpHostMask" varchar(16) COLLATE "default",
  91. "bannedNameMask" varchar(64) COLLATE "default"
  92. )
  93. WITH (OIDS=FALSE);
  94. -- Indexes structure for table estateban
  95. -- ----------------------------
  96. CREATE INDEX IF NOT EXISTS "ix_estateban" ON "public"."estateban" USING btree("EstateID" "pg_catalog"."int4_ops" ASC NULLS LAST);
  97. COMMIT;