AgentPrefs.migrations 604 B

12345678910111213141516171819
  1. :VERSION 1
  2. BEGIN TRANSACTION;
  3. CREATE TABLE IF NOT EXISTS "public"."agentprefs" (
  4. "PrincipalID" uuid NOT NULL,
  5. "AccessPrefs" char(2) NOT NULL DEFAULT 'M'::bpchar COLLATE "default",
  6. "HoverHeight" float8 NOT NULL DEFAULT 0,
  7. "Language" char(5) NOT NULL DEFAULT 'en-us'::bpchar COLLATE "default",
  8. "LanguageIsPublic" bool NOT NULL DEFAULT true,
  9. "PermEveryone" int4 NOT NULL DEFAULT 0,
  10. "PermGroup" int4 NOT NULL DEFAULT 0,
  11. "PermNextOwner" int4 NOT NULL DEFAULT 532480
  12. )
  13. WITH (OIDS=FALSE);
  14. ALTER TABLE "public"."agentprefs" ADD PRIMARY KEY ("PrincipalID") NOT DEFERRABLE INITIALLY IMMEDIATE;
  15. COMMIT;