• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

How do i add table to my database?

leeebux

Awsome
Premium User
Joined
May 18, 2009
Messages
104
Reaction score
5
Location
Sweden
Hello all, i'm using xampp and want to add a new acution system to my OT, now this is my first time running a ot and i need help how and where to add
`players` ADD `auction_balance` INT( 11 ) NOT NULL DEFAULT '0';
and also this code
CREATE TABLE `auction_system` (
`id` int(11) NOT NULL auto_increment,
`player` int(11),
`item_id` int(11),
`item_name` varchar(255),
`count` int(11),
`cost` int(11),
`date` int(11),
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
been searching all day, but can't find a guide for it, so would someone please help me? :p
Btw, i know its has something to do "creat new tabel in blabla" but how man colums and what should i write there?

Rep to the one that help me
 
its not;
`players` ADD `auction_balance` INT( 11 ) NOT NULL DEFAULT '0';
but it is;
ALTER TABLE `players` ADD `auction_balance` INT( 11 ) NOT NULL DEFAULT '0';
 
like this;
25irwq1.jpg
 
Back
Top