Execute SQL
You will find a lot of .sql files in there, but you only need the ones starting with the
number 1711 (and up)(this is based on using the 1751 database)
So first click on the 1711 file called 1711_account_restricted_aa.sql and click Open
Then click Start. It will source that sql in to your database.
***NOTE*** - You will have to do this step with each one, especially the ones that have
the word "required" in the name of the file.
Hello,
I am using rev_2022.sql, when I did the above set I get the following error.
[Err] 1060 - Duplicate column name 'account_time_required'
[Err] ALTER TABLE `altadv_vars` ADD `account_time_required` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `clientver`;
[Err] 1060 - Duplicate column name 'time_creation'
[Err] ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
[Msg] Finished - Unsuccessfully
-------------------------------------------------
Also in using rev_2022, this means I will have execute all the files higher than 1711 ?
|