Search the Community

I am having trouble creating a table in SQL with phpmyadmin on my server. I installed the singlecurrency 4.0 for Dayz Overpoch and I get a error message when I enter the Sql table "banking_data". Coins will save on the player but wont save in the bank after relog or restart. I included a pic of the error message. Here is the code I am trying to enter. ANY help would be much appreciated! SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `banking_data` -- ---------------------------- DROP TABLE IF EXISTS `banking_data`; CREATE TABLE `banking_data` ( `PlayerUID` varchar(20) NOT NULL DEFAULT '0', `PlayerName` varchar(128) NOT NULL DEFAULT 'Null', `BankSaldo` bigint(24) NOT NULL DEFAULT '0', `LastUpdated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`PlayerUID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `character_data` -- ---------------------------- ALTER TABLE character_data ADD CashMoney int(11) NOT NULL DEFAULT 0 AFTER Infected;