inserir colun in DB

[jel]

how to insert a column named honor, type INT, size 11 and default 0 in the players table?

thanks

 

[bagocobra]

Go in database in otserv page (where have the config.lua where You configure your ot) i believe that there must have an area where the colums are created, just add there like the others are being added, if isn’t there, is in sql document in the same folder... but i believe that is in DATABASE document...

 

[Snavy]

how to insert a column named honor, type INT, size 11 and default 0 in the players table?

thanks

Execute this in your Database Manager ( phpmyadmin? )

ALTER TABLE `players` ADD COLUMN `honor` INT DEFAULT 0;

Reference: Adding a new SQL column with a default value (https://stackoverflow.com/a/3569372/6212957)