Code:
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50527
Source Host : localhost:3306
Source Database : silentx
Target Server Type : MYSQL
Target Server Version : 50527
File Encoding : 65001
Date: 2012-12-20 00:27:10
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `online`
-- ----------------------------
DROP TABLE IF EXISTS `online`;
CREATE TABLE `online` (
`id` varchar(3) NOT NULL DEFAULT '',
`currentlyonline` int(4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of online
-- ----------------------------
INSERT INTO `online` VALUES ('1', '0');
-- ----------------------------
-- Table structure for `ratio`
-- ----------------------------
DROP TABLE IF EXISTS `ratio`;
CREATE TABLE `ratio` (
`playerName` varchar(15) NOT NULL DEFAULT '',
`Kills` double DEFAULT NULL,
`Deaths` double DEFAULT NULL,
PRIMARY KEY (`playerName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of ratio
-- ----------------------------
-- ----------------------------
-- Table structure for `skills`
-- ----------------------------
DROP TABLE IF EXISTS `skills`;
CREATE TABLE `skills` (
`playerName` varchar(15) NOT NULL DEFAULT '',
`Attacklvl` double DEFAULT NULL,
`Attackxp` double DEFAULT NULL,
`Defencelvl` double DEFAULT NULL,
`Defencexp` double DEFAULT NULL,
`Strengthlvl` double DEFAULT NULL,
`Strengthxp` double DEFAULT NULL,
`Hitpointslvl` double DEFAULT NULL,
`Hitpointsxp` double DEFAULT NULL,
`Rangelvl` double DEFAULT NULL,
`Rangexp` double DEFAULT NULL,
`Prayerlvl` double DEFAULT NULL,
`Prayerxp` double DEFAULT NULL,
`Magiclvl` double DEFAULT NULL,
`Magicxp` double DEFAULT NULL,
`Cookinglvl` double DEFAULT NULL,
`Cookingxp` double DEFAULT NULL,
`Woodcuttinglvl` double DEFAULT NULL,
`Woodcuttingxp` double DEFAULT NULL,
`Fletchinglvl` double DEFAULT NULL,
`Fletchingxp` double DEFAULT NULL,
`Fishinglvl` double DEFAULT NULL,
`Fishingxp` double DEFAULT NULL,
`Firemakinglvl` double DEFAULT NULL,
`Firemakingxp` double DEFAULT NULL,
`Craftinglvl` double DEFAULT NULL,
`Craftingxp` double DEFAULT NULL,
`Smithinglvl` double DEFAULT NULL,
`Smithingxp` double DEFAULT NULL,
`Mininglvl` double DEFAULT NULL,
`Miningxp` double DEFAULT NULL,
`Herblorelvl` double DEFAULT NULL,
`Herblorexp` double DEFAULT NULL,
`Agilitylvl` double DEFAULT NULL,
`Agilityxp` double DEFAULT NULL,
`Thievinglvl` double DEFAULT NULL,
`Thievingxp` double DEFAULT NULL,
`Slayerlvl` double DEFAULT NULL,
`Slayerxp` double DEFAULT NULL,
`Farminglvl` double DEFAULT NULL,
`Farmingxp` double DEFAULT NULL,
`Runecraftlvl` double DEFAULT NULL,
`Runecraftxp` double DEFAULT NULL,
PRIMARY KEY (`playerName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of skills
-- ----------------------------
-- ----------------------------
-- Table structure for `skillsoverall`
-- ----------------------------
DROP TABLE IF EXISTS `skillsoverall`;
CREATE TABLE `skillsoverall` (
`playerName` varchar(15) NOT NULL DEFAULT '',
`lvl` int(11) DEFAULT NULL,
`xp` int(11) DEFAULT NULL,
PRIMARY KEY (`playerName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of skillsoverall
-- ----------------------------
-- ----------------------------
-- Table structure for `tempvotes`
-- ----------------------------
DROP TABLE IF EXISTS `tempvotes`;
CREATE TABLE `tempvotes` (
`id` int(5) NOT NULL,
`time` int(9) NOT NULL,
`ipaddress` varchar(15) NOT NULL,
`voted` int(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of tempvotes
-- ----------------------------
-- ----------------------------
-- Table structure for `votes`
-- ----------------------------
DROP TABLE IF EXISTS `votes`;
CREATE TABLE `votes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` int(9) NOT NULL,
`ipaddress` varchar(15) NOT NULL,
`authcode` varchar(6) NOT NULL,
`used` int(1) NOT NULL DEFAULT '0',
`username` varchar(14) NOT NULL,
`guid` varchar(45) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of votes
-- ----------------------------