SCDBQuery.sql

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',
  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 last_updated;