PDA

View Full Version : House Keeping


Lee
26-01-2008, 07:18 PM
Hey Guys, I have Uploaded house keeping to my site via ftp and done mysqlphpadmin ad all that but how do i create the first user?

Any Help Much Appreciated And +Rep
Forge
26-01-2008, 07:34 PM
Have you read the README file?
Lee
26-01-2008, 07:38 PM
yes, it dont seem to say how
Forge
26-01-2008, 07:49 PM
is there an install file? (I dont use housekeeping and never have)
Lee
26-01-2008, 07:51 PM
Nope no install file
:job2
26-01-2008, 07:53 PM
Lol i had this problem so I had to install a different panel
Hitman
26-01-2008, 07:58 PM
If you can post the user table, I'll be able to help.
Lee
26-01-2008, 08:04 PM
If you can post the user table, I'll be able to help.
Heres The .sql File:
#
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: mysql2.freehostia.com
-- Generation Time: Nov 07, 2006 at 09:12 PM
-- Server version: 4.1.11
-- PHP Version: 4.3.10-16
--
-- Database: `habgol_panel`
--
-- --------------------------------------------------------
--
-- Table structure for table `Wednesday`
--
CREATE TABLE `Wednesday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `Wednesday`
--
-- --------------------------------------------------------
--
-- Table structure for table `adminmsg`
--
CREATE TABLE `adminmsg` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(225) NOT NULL default '',
`comment` text NOT NULL,
`IP` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `adminmsg`
--

-- --------------------------------------------------------
--
-- Table structure for table `alert`
--
CREATE TABLE `alert` (
`ID` int(11) NOT NULL auto_increment,
`message` text NOT NULL,
`name` varchar(100) NOT NULL default '',
`active` varchar(200) NOT NULL default '',
`direct` varchar(100) NOT NULL default '',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=408 ;
--
-- Dumping data for table `alert`
--
-- --------------------------------------------------------
--
-- Table structure for table `alerts`
--
CREATE TABLE `alerts` (
`id` int(225) NOT NULL auto_increment,
`sender` varchar(225) NOT NULL default '',
`sip` varchar(225) NOT NULL default '',
`msg` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `alerts`
--
-- --------------------------------------------------------
--
-- Table structure for table `application`
--
CREATE TABLE `application` (
`status` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `application`
--

-- --------------------------------------------------------
--
-- Table structure for table `banned_songs`
--
CREATE TABLE `banned_songs` (
`id` int(11) NOT NULL auto_increment,
`Song` text NOT NULL,
`From` text NOT NULL,
`Long` text NOT NULL,
`Reason` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `banned_songs`
--
-- --------------------------------------------------------
--
-- Table structure for table `config`
--
CREATE TABLE `config` (
`config_name` varchar(20) NOT NULL default '',
`config_value` varchar(20) NOT NULL default '',
`config_type_1` varchar(20) NOT NULL default '',
`config_value_2` varchar(50) NOT NULL default '',
`config_type_2` varchar(20) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `config`
--

-- --------------------------------------------------------
--
-- Table structure for table `friday`
--
CREATE TABLE `friday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `friday`
--

-- --------------------------------------------------------
--
-- Table structure for table `hellos`
--
CREATE TABLE `hellos` (
`id` int(11) NOT NULL auto_increment,
`message` text NOT NULL,
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=101 ;
--
-- Dumping data for table `hellos`
--
-- --------------------------------------------------------
--
-- Table structure for table `ipban`
--
CREATE TABLE `ipban` (
`ID` int(11) NOT NULL default '0',
`IP` varchar(15) NOT NULL default '',
`Username` text NOT NULL,
`Reason` text NOT NULL,
`Banned` text NOT NULL,
UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ipban`
--

-- --------------------------------------------------------
--
-- Table structure for table `maintanance`
--
CREATE TABLE `maintanance` (
`status` varchar(200) character set armscii8 collate armscii8_bin NOT NULL default '',
`reason` text NOT NULL,
`title` text NOT NULL,
`image` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `maintanance`
--

-- --------------------------------------------------------
--
-- Table structure for table `missslot`
--
CREATE TABLE `missslot` (
`id` int(11) NOT NULL auto_increment,
`Username` varchar(225) NOT NULL default '',
`Time` text NOT NULL,
`Day` text NOT NULL,
`Reason` text NOT NULL,
`Cover` text NOT NULL,
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
--
-- Dumping data for table `missslot`
--
-- --------------------------------------------------------
--
-- Table structure for table `monday`
--
CREATE TABLE `monday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `monday`
--
-- --------------------------------------------------------
--
-- Table structure for table `news`
--
CREATE TABLE `news` (
`ID` int(11) NOT NULL auto_increment,
`NoticeTitle` text NOT NULL,
`NoticeMessage` text NOT NULL,
`NoticeDAT` text NOT NULL,
`IP` int(11) NOT NULL default '0',
`NoticeUsername` text NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
--
-- Dumping data for table `news`
--
-- --------------------------------------------------------
--
-- Table structure for table `notices`
--
CREATE TABLE `notices` (
`ID` int(11) NOT NULL auto_increment,
`NoticeTitle` text NOT NULL,
`NoticeMessage` text NOT NULL,
`NoticeDAT` text NOT NULL,
`IP` int(11) NOT NULL default '0',
`NoticeUsername` text NOT NULL,
UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `notices`
--

-- --------------------------------------------------------
--
-- Table structure for table `officialdjs`
--
CREATE TABLE `officialdjs` (
`ID` int(11) NOT NULL auto_increment,
`NoticeMessage` text NOT NULL,
`IP` varchar(15) NOT NULL default '',
`hname` text NOT NULL,
UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=59 ;
--
-- Dumping data for table `officialdjs`
--
-- --------------------------------------------------------
--
-- Table structure for table `permmonday`
--
CREATE TABLE `permmonday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `permmonday`
--

-- --------------------------------------------------------
--
-- Table structure for table `pm`
--
CREATE TABLE `pm` (
`id` varchar(50) NOT NULL default '',
`ip` varchar(50) NOT NULL default '',
`send_to` varchar(50) NOT NULL default '',
`send_from` varchar(50) NOT NULL default '',
`message` text NOT NULL,
`date` varchar(50) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `pm`
--

-- --------------------------------------------------------
--
-- Table structure for table `privmsgs`
--
CREATE TABLE `privmsgs` (
`msg_id` int(10) NOT NULL auto_increment,
`msg_title` varchar(100) NOT NULL default '',
`msg_txt` text NOT NULL,
`msg_read` int(1) NOT NULL default '0',
`msg_date` varchar(12) NOT NULL default '0000-00-00',
`msg_time` varchar(100) NOT NULL default '',
`msg_ip` varchar(20) NOT NULL default '',
`msg_to` varchar(50) NOT NULL default '',
`msg_from` varchar(50) NOT NULL default '',
PRIMARY KEY (`msg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=634 ;
--
-- Dumping data for table `privmsgs`
--
-- --------------------------------------------------------
--
-- Table structure for table `profiles`
--
CREATE TABLE `profiles` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(225) NOT NULL default '',
`password` text NOT NULL,
`email` text NOT NULL,
`level` int(1) NOT NULL default '0',
`ban` int(1) NOT NULL default '0',
`lastlogin` varchar(225) NOT NULL default 'never',
`ip` varchar(15) NOT NULL default '',
`avatar` text NOT NULL,
UNIQUE KEY `id` (`id`),
FULLTEXT KEY `password` (`password`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=235 ;
--
-- Dumping data for table `profiles`
--

-- --------------------------------------------------------
--
-- Table structure for table `promotion`
--
CREATE TABLE `promotion` (
`id` int(11) NOT NULL auto_increment,
`yourname` text NOT NULL,
`djname` text NOT NULL,
`djreason` text NOT NULL,
`IP` int(11) NOT NULL default '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `promotion`
--

-- --------------------------------------------------------
--
-- Table structure for table `radioinfo`
--
CREATE TABLE `radioinfo` (
`id` int(11) NOT NULL auto_increment,
`Radio_IP` text NOT NULL,
`Radio_Port` text NOT NULL,
`Radio_Password` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
--
-- Dumping data for table `radioinfo`
--
-- --------------------------------------------------------
--
-- Table structure for table `requests`
--
CREATE TABLE `requests` (
`id` int(11) NOT NULL auto_increment,
`habboname` varchar(225) NOT NULL default '',
`type` varchar(225) NOT NULL default '',
`dj_name` varchar(225) NOT NULL default '',
`message` text NOT NULL,
`date` text NOT NULL,
`ip` varchar(15) NOT NULL default '',
`report` tinyint(1) NOT NULL default '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3269 ;
--
-- Dumping data for table `requests`
--
-- --------------------------------------------------------
--
-- Table structure for table `requests2`
--
CREATE TABLE `requests2` (
`id` int(11) NOT NULL auto_increment,
`habboname` varchar(225) NOT NULL default '',
`type` varchar(225) NOT NULL default '',
`dj_name` varchar(225) NOT NULL default '',
`message` text NOT NULL,
`date` text NOT NULL,
`ip` varchar(15) NOT NULL default '',
`report` tinyint(1) NOT NULL default '0',
`email` text NOT NULL,
`example` text NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1041 ;
--
-- Dumping data for table `requests2`
--

-- --------------------------------------------------------
--
-- Table structure for table `rooms`
--
CREATE TABLE `rooms` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`message` text NOT NULL,
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=122 ;
--
-- Dumping data for table `rooms`
--

-- --------------------------------------------------------
--
-- Table structure for table `saturday`
--
CREATE TABLE `saturday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `saturday`
--
-- --------------------------------------------------------
--
-- Table structure for table `security_images`
--
CREATE TABLE `security_images` (
`ID` int(11) NOT NULL auto_increment,
`insertdate` datetime NOT NULL default '0000-00-00 00:00:00',
`referenceid` varchar(100) NOT NULL default '',
`hiddentext` varchar(100) NOT NULL default '',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
--
-- Dumping data for table `security_images`
--
-- --------------------------------------------------------
--
-- Table structure for table `shoutout`
--
CREATE TABLE `shoutout` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(225) NOT NULL default '',
`comment` text NOT NULL,
`IP` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `shoutout`
--
-- --------------------------------------------------------
--
-- Table structure for table `shows`
--
CREATE TABLE `shows` (
`name` text NOT NULL,
`dj` text NOT NULL,
`day` text NOT NULL,
`time` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `shows`
--

-- --------------------------------------------------------
--
-- Table structure for table `sitenews`
--
CREATE TABLE `sitenews` (
`ID` int(11) NOT NULL auto_increment,
`NoticeTitle` text NOT NULL,
`NoticeMessage` text NOT NULL,
`NoticeDAT` text NOT NULL,
`NoticeTIM` text NOT NULL,
`IP` int(11) NOT NULL default '0',
`NoticeUsername` text NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=83 ;
--
-- Dumping data for table `sitenews`
--
-- --------------------------------------------------------
--
-- Table structure for table `slotrequest`
--
CREATE TABLE `slotrequest` (
`id` int(11) NOT NULL auto_increment,
`Username` varchar(225) NOT NULL default '',
`Day` text NOT NULL,
`Time` text NOT NULL,
`ShowName` text NOT NULL,
`IP` varchar(15) NOT NULL default '',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `slotrequest`
--

-- --------------------------------------------------------
--
-- Table structure for table `special`
--
CREATE TABLE `special` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `special`
--

-- --------------------------------------------------------
--
-- Table structure for table `staff`
--
CREATE TABLE `staff` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(225) NOT NULL default '',
`password` text NOT NULL,
`email` text NOT NULL,
`level` int(1) NOT NULL default '0',
`ban` int(1) NOT NULL default '0',
`lastlogin` varchar(225) NOT NULL default 'never',
`ip` varchar(15) NOT NULL default '',
`avatar` text NOT NULL,
`habboname` text NOT NULL,
UNIQUE KEY `id` (`id`),
FULLTEXT KEY `password` (`password`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=308 ;
--
-- Dumping data for table `staff`
--
INSERT INTO `staff` VALUES (284, 'Admin', 'changeme', 'Changeme', 2, 0, 'never', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `staff_chat`
--
CREATE TABLE `staff_chat` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(225) NOT NULL default '',
`message` text NOT NULL,
`time` time NOT NULL default '00:00:00',
`ip` varchar(15) NOT NULL default '',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=67 ;
--
-- Dumping data for table `staff_chat`
--
-- --------------------------------------------------------
--
-- Table structure for table `staffchat`
--
CREATE TABLE `staffchat` (
`id` tinyint(10) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`body` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `staffchat`
--

-- --------------------------------------------------------
--
-- Table structure for table `status`
--
CREATE TABLE `status` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `status`
--

-- --------------------------------------------------------
--
-- Table structure for table `sunday`
--
CREATE TABLE `sunday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sunday`
--
-- --------------------------------------------------------
--
-- Table structure for table `thursday`
--
CREATE TABLE `thursday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `thursday`
--

-- --------------------------------------------------------
--
-- Table structure for table `top`
--
CREATE TABLE `top` (
`id` int(10) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`artist` varchar(255) NOT NULL default '',
`album` varchar(255) NOT NULL default '',
`votes` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `top`
--

-- --------------------------------------------------------
--
-- Table structure for table `topnotices`
--
CREATE TABLE `topnotices` (
`ID` int(11) NOT NULL auto_increment,
`NoticeMessage` text NOT NULL,
`IP` int(11) NOT NULL default '0',
UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `topnotices`
--

-- --------------------------------------------------------
--
-- Table structure for table `tuesday`
--
CREATE TABLE `tuesday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tuesday`
--

-- --------------------------------------------------------
--
-- Table structure for table `users_online`
--
CREATE TABLE `users_online` (
`id` int(11) NOT NULL default '0',
`username` varchar(225) NOT NULL default '',
`time` text NOT NULL,
`url` text NOT NULL,
`kick` tinyint(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `users_online`
--

-- --------------------------------------------------------
--
-- Table structure for table `wednesday`
--
CREATE TABLE `wednesday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `wednesday`
--

-- --------------------------------------------------------
--
-- Table structure for table `wednsday`
--
CREATE TABLE `wednsday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `wednsday`
--
Lee
26-01-2008, 08:13 PM
Edit: Done It :P Thread Closed :P
Florx
26-01-2008, 08:15 PM
You forgot to close the thread. lol

Want to hide these adverts? Register an account for free!