diff options
Diffstat (limited to 'server/initializers/migrations/0130-video-channel-actor.ts')
-rw-r--r-- | server/initializers/migrations/0130-video-channel-actor.ts | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/server/initializers/migrations/0130-video-channel-actor.ts b/server/initializers/migrations/0130-video-channel-actor.ts index 15b67be81..2e4694a75 100644 --- a/server/initializers/migrations/0130-video-channel-actor.ts +++ b/server/initializers/migrations/0130-video-channel-actor.ts | |||
@@ -22,7 +22,7 @@ async function up (utils: { | |||
22 | id integer NOT NULL, | 22 | id integer NOT NULL, |
23 | type enum_actor_type NOT NULL, | 23 | type enum_actor_type NOT NULL, |
24 | uuid uuid NOT NULL, | 24 | uuid uuid NOT NULL, |
25 | name character varying(255) NOT NULL, | 25 | "preferredUsername" character varying(255) NOT NULL, |
26 | url character varying(2000) NOT NULL, | 26 | url character varying(2000) NOT NULL, |
27 | "publicKey" character varying(5000), | 27 | "publicKey" character varying(5000), |
28 | "privateKey" character varying(5000), | 28 | "privateKey" character varying(5000), |
@@ -50,7 +50,7 @@ async function up (utils: { | |||
50 | `ALTER SEQUENCE actor_id_seq OWNED BY actor.id`, | 50 | `ALTER SEQUENCE actor_id_seq OWNED BY actor.id`, |
51 | `ALTER TABLE ONLY actor ALTER COLUMN id SET DEFAULT nextval('actor_id_seq'::regclass)`, | 51 | `ALTER TABLE ONLY actor ALTER COLUMN id SET DEFAULT nextval('actor_id_seq'::regclass)`, |
52 | `ALTER TABLE ONLY actor ADD CONSTRAINT actor_pkey PRIMARY KEY (id);`, | 52 | `ALTER TABLE ONLY actor ADD CONSTRAINT actor_pkey PRIMARY KEY (id);`, |
53 | `CREATE UNIQUE INDEX actor_name_server_id ON actor USING btree (name, "serverId")`, | 53 | `CREATE UNIQUE INDEX actor_preferred_username_server_id ON actor USING btree ("preferredUsername", "serverId")`, |
54 | `ALTER TABLE ONLY actor | 54 | `ALTER TABLE ONLY actor |
55 | ADD CONSTRAINT "actor_avatarId_fkey" FOREIGN KEY ("avatarId") REFERENCES avatar(id) ON UPDATE CASCADE ON DELETE CASCADE`, | 55 | ADD CONSTRAINT "actor_avatarId_fkey" FOREIGN KEY ("avatarId") REFERENCES avatar(id) ON UPDATE CASCADE ON DELETE CASCADE`, |
56 | `ALTER TABLE ONLY actor | 56 | `ALTER TABLE ONLY actor |
@@ -68,7 +68,7 @@ async function up (utils: { | |||
68 | ` | 68 | ` |
69 | INSERT INTO "actor" | 69 | INSERT INTO "actor" |
70 | ( | 70 | ( |
71 | type, uuid, name, url, "publicKey", "privateKey", "followersCount", "followingCount", "inboxUrl", "outboxUrl", | 71 | type, uuid, "preferredUsername", url, "publicKey", "privateKey", "followersCount", "followingCount", "inboxUrl", "outboxUrl", |
72 | "sharedInboxUrl", "followersUrl", "followingUrl", "avatarId", "serverId", "createdAt", "updatedAt" | 72 | "sharedInboxUrl", "followersUrl", "followingUrl", "avatarId", "serverId", "createdAt", "updatedAt" |
73 | ) | 73 | ) |
74 | SELECT | 74 | SELECT |
@@ -83,7 +83,7 @@ async function up (utils: { | |||
83 | ` | 83 | ` |
84 | INSERT INTO "actor" | 84 | INSERT INTO "actor" |
85 | ( | 85 | ( |
86 | type, uuid, name, url, "publicKey", "privateKey", "followersCount", "followingCount", "inboxUrl", "outboxUrl", | 86 | type, uuid, "preferredUsername", url, "publicKey", "privateKey", "followersCount", "followingCount", "inboxUrl", "outboxUrl", |
87 | "sharedInboxUrl", "followersUrl", "followingUrl", "avatarId", "serverId", "createdAt", "updatedAt" | 87 | "sharedInboxUrl", "followersUrl", "followingUrl", "avatarId", "serverId", "createdAt", "updatedAt" |
88 | ) | 88 | ) |
89 | SELECT | 89 | SELECT |
@@ -119,7 +119,7 @@ async function up (utils: { | |||
119 | const query = ` | 119 | const query = ` |
120 | INSERT INTO actor | 120 | INSERT INTO actor |
121 | ( | 121 | ( |
122 | type, uuid, name, url, "publicKey", "privateKey", "followersCount", "followingCount", "inboxUrl", "outboxUrl", | 122 | type, uuid, "preferredUsername", url, "publicKey", "privateKey", "followersCount", "followingCount", "inboxUrl", "outboxUrl", |
123 | "sharedInboxUrl", "followersUrl", "followingUrl", "avatarId", "serverId", "createdAt", "updatedAt" | 123 | "sharedInboxUrl", "followersUrl", "followingUrl", "avatarId", "serverId", "createdAt", "updatedAt" |
124 | ) | 124 | ) |
125 | SELECT | 125 | SELECT |