Bigboard upgrade question, pre run queries. 3.5.1 to 3.6

[telc]

Would it be ok for me to prerun these queries and comment out he lines in the upgrade file, before I even run the upgrade.php scripts.

I rather run them beforehand if I can, then encounter a timeout and have to run them.



ALTER TABLE post ADD COLUMN infraction smallint(5);
ALTER TABLE thread ADD COLUMN deletedcount smallint(5);
ALTER TABLE post ADD COLUMN reportthreadid int(11);
ALTER TABLE thread ADD COLUMN lastpostid int(11);


http://www.andreas-kraus.net/blog/updating-to-vbulletin-36-update-timeouts/

[InfidelMatt]

Yes. Versions <3.6 have no use for those fields, so extra fields won't cause any harm.

Of course the locking of the tables would make your forum all but impossible to use during the period in which you perform these queries. I have 3.6 million posts and each post query took 39 minutes. The thread queries only took a couple of seconds.

Matt