2 -- patch-drop-user-fields.sql
4 -- T188327. Drop old xx_user and xx_user_text fields, and defaults from xx_actor fields.
6 ALTER TABLE /*_*/archive
8 DROP COLUMN ar_user_text
,
9 ALTER COLUMN ar_actor
DROP DEFAULT;
11 ALTER TABLE /*_*/ipblocks
13 DROP COLUMN ipb_by_text
,
14 ALTER COLUMN ipb_by_actor
DROP DEFAULT;
16 ALTER TABLE /*_*/image
17 DROP INDEX /*i*/img_user_timestamp
,
18 DROP INDEX /*i*/img_usertext_timestamp
,
20 DROP COLUMN img_user_text
,
21 ALTER COLUMN img_actor
DROP DEFAULT;
23 ALTER TABLE /*_*/oldimage
24 DROP INDEX /*i*/oi_usertext_timestamp
,
26 DROP COLUMN oi_user_text
,
27 ALTER COLUMN oi_actor
DROP DEFAULT;
29 ALTER TABLE /*_*/filearchive
30 DROP INDEX /*i*/fa_user_timestamp
,
32 DROP COLUMN fa_user_text
,
33 ALTER COLUMN fa_actor
DROP DEFAULT;
35 ALTER TABLE /*_*/recentchanges
36 DROP INDEX /*i*/rc_ns_usertext
,
37 DROP INDEX /*i*/rc_user_text
,
39 DROP COLUMN rc_user_text
,
40 ALTER COLUMN rc_actor
DROP DEFAULT;
42 ALTER TABLE /*_*/logging
43 DROP INDEX /*i*/user_time
,
44 DROP INDEX /*i*/log_user_type_time
,
45 DROP INDEX /*i*/log_user_text_type_time
,
46 DROP INDEX /*i*/log_user_text_time
,
48 DROP COLUMN log_user_text
,
49 ALTER COLUMN log_actor
DROP DEFAULT;