-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 02, 2007 at 09:10 PM
-- Server version: 4.1.22
-- PHP Version: 5.2.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `mystic_chat`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_acc`
--
CREATE TABLE `ibwf_acc` (
`id` int(100) NOT NULL auto_increment,
`gid` int(100) NOT NULL default '0',
`fid` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_acc`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_announcements`
--
CREATE TABLE `ibwf_announcements` (
`id` int(100) NOT NULL auto_increment,
`antext` varchar(200) NOT NULL default '',
`clid` int(100) NOT NULL default '0',
`antime` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_announcements`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_avatars`
--
CREATE TABLE `ibwf_avatars` (
`id` int(10) NOT NULL auto_increment,
`avlink` varchar(150) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `avlink` (`avlink`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_avatars`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_blockedsite`
--
CREATE TABLE `ibwf_blockedsite` (
`id` int(11) NOT NULL auto_increment,
`site` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_blockedsite`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_blogs`
--
CREATE TABLE `ibwf_blogs` (
`id` int(100) NOT NULL auto_increment,
`bowner` int(100) NOT NULL default '0',
`bname` varchar(30) NOT NULL default '',
`btext` blob NOT NULL,
`bgdate` int(100) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `bname` (`bname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_blogs`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_brate`
--
CREATE TABLE `ibwf_brate` (
`id` int(100) NOT NULL auto_increment,
`blogid` int(100) NOT NULL default '0',
`uid` int(100) NOT NULL default '0',
`brate` char(1) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_brate`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_buddies`
--
CREATE TABLE `ibwf_buddies` (
`id` int(100) NOT NULL auto_increment,
`uid` int(100) NOT NULL default '0',
`tid` int(100) NOT NULL default '0',
`agreed` char(1) NOT NULL default '0',
`reqdt` int(100) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_buddies`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_cards`
--
CREATE TABLE `ibwf_cards` (
`id` int(10) NOT NULL auto_increment,
`fntsz` int(5) NOT NULL default '0',
`xst` int(10) NOT NULL default '0',
`yst` int(10) NOT NULL default '0',
`xjp` int(10) NOT NULL default '0',
`yjp` int(10) NOT NULL default '0',
`tcolor` varchar(20) NOT NULL default '',
`category` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_cards`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_chat`
--
CREATE TABLE `ibwf_chat` (
`id` int(99) NOT NULL auto_increment,
`chatter` int(100) NOT NULL default '0',
`who` int(100) NOT NULL default '0',
`timesent` int(50) NOT NULL default '0',
`msgtext` varchar(255) NOT NULL default '',
`rid` int(99) NOT NULL default '0',
`exposed` char(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_chat`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_chonline`
--
CREATE TABLE `ibwf_chonline` (
`lton` int(15) NOT NULL default '0',
`uid` int(100) NOT NULL default '0',
`rid` int(99) NOT NULL default '0',
PRIMARY KEY (`lton`),
UNIQUE KEY `username` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ibwf_chonline`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_clubmembers`
--
CREATE TABLE `ibwf_clubmembers` (
`id` int(100) NOT NULL auto_increment,
`uid` int(100) NOT NULL default '0',
`clid` int(100) NOT NULL default '0',
`accepted` char(1) NOT NULL default '0',
`points` int(100) NOT NULL default '0',
`joined` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_clubmembers`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_clubs`
--
CREATE TABLE `ibwf_clubs` (
`id` int(100) NOT NULL auto_increment,
`owner` int(100) NOT NULL default '0',
`name` varchar(30) NOT NULL default '',
`description` varchar(200) NOT NULL default '',
`rules` blob NOT NULL,
`logo` varchar(200) NOT NULL default '',
`plusses` int(100) NOT NULL default '0',
`created` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_clubs`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_faqs`
--
CREATE TABLE `ibwf_faqs` (
`id` int(100) NOT NULL auto_increment,
`category` varchar(10) NOT NULL default '',
`question` varchar(100) NOT NULL default '',
`answer` varchar(250) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_faqs`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_fcats`
--
CREATE TABLE `ibwf_fcats` (
`id` int(50) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`position` int(50) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_fcats`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_forums`
--
CREATE TABLE `ibwf_forums` (
`id` int(50) NOT NULL auto_increment,
`name` varchar(20) NOT NULL default '',
`position` int(50) NOT NULL default '0',
`cid` int(100) NOT NULL default '0',
`clubid` int(100) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_forums`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_games`
--
CREATE TABLE `ibwf_games` (
`id` int(100) NOT NULL auto_increment,
`uid` int(100) NOT NULL default '0',
`gvar1` varchar(30) NOT NULL default '',
`gvar2` varchar(30) NOT NULL default '',
`gvar3` varchar(30) NOT NULL default '',
`gvar4` varchar(30) NOT NULL default '',
`gvar5` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_games`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_gbook`
--
CREATE TABLE `ibwf_gbook` (
`id` int(100) NOT NULL auto_increment,
`gbowner` int(100) NOT NULL default '0',
`gbsigner` int(100) NOT NULL default '0',
`gbmsg` blob NOT NULL,
`dtime` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_gbook`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_groups`
--
CREATE TABLE `ibwf_groups` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`autoass` char(1) NOT NULL default '1',
`mage` int(10) NOT NULL default '0',
`maxage` int(10) NOT NULL default '0',
`userst` char(1) NOT NULL default '0',
`posts` int(100) NOT NULL default '0',
`plusses` int(100) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_groups`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_ignore`
--
CREATE TABLE `ibwf_ignore` (
`id` int(10) NOT NULL auto_increment,
`name` int(99) NOT NULL default '0',
`target` int(99) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_ignore`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_judges`
--
CREATE TABLE `ibwf_judges` (
`id` int(100) NOT NULL auto_increment,
`uid` int(100) NOT NULL default '0',
`fid` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_judges`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_links`
--
CREATE TABLE `ibwf_links` (
`url` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
PRIMARY KEY (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ibwf_links`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_mangr`
--
CREATE TABLE `ibwf_mangr` (
`id` int(100) NOT NULL auto_increment,
`uid` int(100) NOT NULL default '0',
`gid` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_mangr`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_mlog`
--
CREATE TABLE `ibwf_mlog` (
`id` int(100) NOT NULL auto_increment,
`action` varchar(10) NOT NULL default '',
`details` text NOT NULL,
`actdt` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_mlog`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_modr`
--
CREATE TABLE `ibwf_modr` (
`id` int(11) NOT NULL auto_increment,
`name` int(100) NOT NULL default '0',
`forum` varchar(99) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_modr`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_moods`
--
CREATE TABLE `ibwf_moods` (
`id` int(99) NOT NULL auto_increment,
`text` varchar(10) NOT NULL default '',
`img` varchar(100) NOT NULL default '',
`dscr` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
--
-- Dumping data for table `ibwf_moods`
--
INSERT INTO `ibwf_moods` VALUES(1, '[:/]', '../moods/angry.gif', 'angry');
INSERT INTO `ibwf_moods` VALUES(2, '[:8]', '../moods/blush.gif', 'Shy/redface/blushing');
INSERT INTO `ibwf_moods` VALUES(3, '[:/]', '../moods/careless.gif', 'Careless/Angry/Disappointed');
INSERT INTO `ibwf_moods` VALUES(4, '[:?]', '../moods/confused.gif', 'Confused');
INSERT INTO `ibwf_moods` VALUES(5, '[8)]', '../moods/cool.gif', 'Cool');
INSERT INTO `ibwf_moods` VALUES(6, '[:,(]', '../moods/cry.gif', 'Crying');
INSERT INTO `ibwf_moods` VALUES(7, '[x-(]', '../moods/dead.gif', 'Dead');
INSERT INTO `ibwf_moods` VALUES(8, '[=P]', '../moods/disgust.gif', 'Disgusts/like yeah whatever');
INSERT INTO `ibwf_moods` VALUES(9, '[>:)]', '../moods/evil.gif', 'Evil');
INSERT INTO `ibwf_moods` VALUES(10, '[~:(]', '../moods/grr.gif', 'GRRR/Angry/Mad');
INSERT INTO `ibwf_moods` VALUES(11, '[=D]', '../moods/happy.gif', 'Happy');
INSERT INTO `ibwf_moods` VALUES(12, 'loved', '../moods/loved.gif', 'In Love');
INSERT INTO `ibwf_moods` VALUES(13, 'luvya', '../moods/luvya.gif', 'Luv Ya');
INSERT INTO `ibwf_moods` VALUES(14, '[:*]', '../moods/nasty.gif', 'Nasty/Drools');
INSERT INTO `ibwf_moods` VALUES(15, '[:O]', '../moods/retard.gif', 'eek/going huh');
INSERT INTO `ibwf_moods` VALUES(16, '[:(]', '../moods/sad.gif', 'Sad');
INSERT INTO `ibwf_moods` VALUES(17, '[:/]', '../moods/shy.gif', 'shy');
INSERT INTO `ibwf_moods` VALUES(18, '[8(,]', '../moods/sick.gif', 'Sick/Tired/Sour');
INSERT INTO `ibwf_moods` VALUES(19, '[3(]', '../moods/sleep.gif', 'Sleeping/Sleepy');
INSERT INTO `ibwf_moods` VALUES(20, '[:)]', '../moods/smile.gif', 'Smiling/Happy');
INSERT INTO `ibwf_moods` VALUES(21, '[(:(]', '../moods/sorry.gif', 'Sorry');
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_mpot`
--
CREATE TABLE `ibwf_mpot` (
`id` int(10) NOT NULL auto_increment,
`ddt` varchar(20) NOT NULL default '',
`dtm` varchar(20) NOT NULL default '',
`ppl` int(20) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_mpot`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_mypage`
--
CREATE TABLE `ibwf_mypage` (
`id` int(100) NOT NULL auto_increment,
`uid` int(100) NOT NULL default '0',
`mimg` varchar(200) NOT NULL default '',
`thid` int(100) NOT NULL default '1',
`msg` varchar(250) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_mypage`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_nicks`
--
CREATE TABLE `ibwf_nicks` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`nicklvl` char(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_nicks`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_online`
--
CREATE TABLE `ibwf_online` (
`id` int(10) NOT NULL auto_increment,
`userid` int(100) NOT NULL default '0',
`actvtime` int(100) NOT NULL default '0',
`place` varchar(50) NOT NULL default '',
`placedet` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_online`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_penalties`
--
CREATE TABLE `ibwf_penalties` (
`id` int(10) NOT NULL auto_increment,
`uid` int(100) NOT NULL default '0',
`penalty` char(1) NOT NULL default '0',
`exid` int(100) NOT NULL default '0',
`timeto` int(100) NOT NULL default '0',
`pnreas` varchar(100) NOT NULL default '',
`ipadd` varchar(30) NOT NULL default '',
`browserm` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_penalties`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_polls`
--
CREATE TABLE `ibwf_polls` (
`id` int(100) NOT NULL auto_increment,
`pqst` varchar(255) NOT NULL default '',
`opt1` varchar(100) NOT NULL default '',
`opt2` varchar(100) NOT NULL default '',
`opt3` varchar(100) NOT NULL default '',
`opt4` varchar(100) NOT NULL default '',
`opt5` varchar(100) NOT NULL default '',
`pdt` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_polls`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_popups`
--
CREATE TABLE `ibwf_popups` (
`id` int(100) NOT NULL auto_increment,
`text` blob NOT NULL,
`byuid` int(100) NOT NULL default '0',
`touid` int(100) NOT NULL default '0',
`unread` char(1) NOT NULL default '1',
`timesent` int(100) NOT NULL default '0',
`reported` char(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_popups`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_posts`
--
CREATE TABLE `ibwf_posts` (
`id` int(100) NOT NULL auto_increment,
`text` blob NOT NULL,
`tid` int(100) NOT NULL default '0',
`uid` int(100) NOT NULL default '0',
`dtpost` int(100) NOT NULL default '0',
`reported` char(1) NOT NULL default '0',
`quote` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_posts`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_pp_gbook`
--
CREATE TABLE `ibwf_pp_gbook` (
`id` int(100) NOT NULL auto_increment,
`uid` int(100) NOT NULL default '0',
`sname` varchar(15) NOT NULL default '',
`semail` varchar(100) NOT NULL default '',
`stext` text NOT NULL,
`sdate` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_pp_gbook`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_pp_pres`
--
CREATE TABLE `ibwf_pp_pres` (
`id` int(100) NOT NULL auto_increment,
`pid` int(100) NOT NULL default '0',
`ans` int(5) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_pp_pres`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_presults`
--
CREATE TABLE `ibwf_presults` (
`id` int(100) NOT NULL auto_increment,
`pid` int(100) NOT NULL default '0',
`uid` int(100) NOT NULL default '0',
`ans` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_presults`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_private`
--
CREATE TABLE `ibwf_private` (
`id` int(100) NOT NULL auto_increment,
`text` text NOT NULL,
`byuid` int(100) NOT NULL default '0',
`touid` int(100) NOT NULL default '0',
`unread` char(1) NOT NULL default '1',
`timesent` int(100) NOT NULL default '0',
`starred` char(1) NOT NULL default '0',
`reported` char(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_private`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_quiz`
--
CREATE TABLE `ibwf_quiz` (
`id` int(11) NOT NULL auto_increment,
`question` varchar(200) NOT NULL default '',
`answer` varchar(30) NOT NULL default '',
`difficulty` varchar(12) NOT NULL default '',
`number` int(11) NOT NULL default '0',
`answer1` varchar(50) NOT NULL default '',
`answer2` varchar(50) NOT NULL default '',
`answer3` varchar(50) NOT NULL default '',
`answer4` varchar(50) NOT NULL default '',
`switch` char(3) NOT NULL default 'on',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
--
-- Dumping data for table `ibwf_quiz`
--
INSERT INTO `ibwf_quiz` VALUES(1, 'Who preceded Margaret Thatcher as Prime Minister of Great Britain*wank*', 'james callaghan', 'easy', 1, ' shaun texas', 'john newton', 'james callaghan', 'greg peterson', 'on');
INSERT INTO `ibwf_quiz` VALUES(2, 'Who was the second man to step foot on the surface of the moon?', 'buzz aldrin', 'easy', 2, 'no man', 'buzz aldrin', 'james newman', 'paul newton', 'on');
INSERT INTO `ibwf_quiz` VALUES(3, 'Where were the 1970 football World Cup finals held*wank*', 'mexico', 'easy', 3, 'russia', 'mexico', 'spain', 'georgia', 'on');
INSERT INTO `ibwf_quiz` VALUES(4, 'In books by JRR Tolkien, what kind of creatures are Bilbo and Frodo Baggins*wank*', 'hobbits', 'easy', 4, 'trees', 'kings', 'hobbits', 'elfs', 'on');
INSERT INTO `ibwf_quiz` VALUES(5, 'Which Italian city is home of the car manufacturer Fiat?*wank*', 'turin', 'easy', 5, 'rome', 'grease', 'turin', 'italy', 'on');
INSERT INTO `ibwf_quiz` VALUES(6, 'What do the French call the English Channel*wank*', 'le manche', 'easy', 6, 'le moon', 'le manche', 'le river', 'le lake', 'on');
INSERT INTO `ibwf_quiz` VALUES(7, 'In which year of the 1940''s did the D-Day landings take place on the coast of Normandy*wank*', '1944', 'easy', 7, '1950', '1949', '1945', '1944', 'on');
INSERT INTO `ibwf_quiz` VALUES(8, 'Who starred in the films Some Like It Hot Bus Stop The Seven Year Itch*wank*', 'marilyn monroe', 'easy', 8, 'betty moore', 'patrica newman', 'marilyn monroe', 'sue white', 'on');
INSERT INTO `ibwf_quiz` VALUES(9, 'What is the largest mammal on Earth*wank*', 'blue whale', 'easy', 9, 'white shark', 'man eating whale', 'blue whale', 'red whale', 'on');
INSERT INTO `ibwf_quiz` VALUES(10, 'What is North Americas highest mountain?*wank*', 'mount mckinley', 'easy', 10, 'mount hilton', 'mount america', 'mount mckinley', 'mount nothing', 'on');
INSERT INTO `ibwf_quiz` VALUES(11, 'What is the chemical symbol for tin?*wank*', 'sn', 'med', 1, 'ca', 'pn', 'sn', 'vp', 'on');
INSERT INTO `ibwf_quiz` VALUES(12, 'What are Corvettes, Sloops and Brigantines*wank*', 'sailing ships', 'med', 2, 'ships', 'raceing ships', 'sailing ships', 'small ships', 'on');
INSERT INTO `ibwf_quiz` VALUES(13, 'Until the introduction of the Euro, what is the unit of currency in Austria*wank*', 'schilling', 'med', 3, 'penny', 'dollar', 'cents', 'schilling', 'on');
INSERT INTO `ibwf_quiz` VALUES(14, 'Which African country s capital city is Luanda', 'angola', 'med', 4, 'angola', 'pangoa', 'africa', 'zambia', 'on');
INSERT INTO `ibwf_quiz` VALUES(15, 'what is the Meaning before noon what does the abbreviation am stand for *wank*', 'ante meridiem', 'med', 5, 'ante sun rize', 'ante meridiem', 'ante morning', 'ante night', 'on');
INSERT INTO `ibwf_quiz` VALUES(16, 'hat is the fifth book book of the Old Testament?', 'deuteronomy', 'med', 6, 'mark', 'luke', 'matthew', 'deuteronomy', 'on');
INSERT INTO `ibwf_quiz` VALUES(17, 'Other than the Sun what is the nearest star to the Earth*wank*', 'proxima centauri', 'med', 7, 'sun centauri', 'Proxima sun', 'proxima centauri', 'centauri sun', 'on');
INSERT INTO `ibwf_quiz` VALUES(18, 'Which band topped the UK album charts in 1991 with their debut LP Nevermind', 'nirvana', 'med', 8, 'pearl jam', 'nirvana', 'ozzy', 'acdc', 'on');
INSERT INTO `ibwf_quiz` VALUES(19, 'In which city was the first series of Auf Wiedersehen Pet primarily set', 'dusseldorf', 'med', 9, 'the pet primarily', 'dusseldorf', 'the auf', 'pet house', 'on');
INSERT INTO `ibwf_quiz` VALUES(20, 'What precious gemstone is associated with the 45th wedding anniversary*wank*', 'sapphire', 'med', 10, 'ruby', 'pink ruby', 'sapphire', 'topaz', 'on');
INSERT INTO `ibwf_quiz` VALUES(21, ' What is the square root of 121*wank*', '11', 'hard', 1, '54', '17', '11', '23', 'on');
INSERT INTO `ibwf_quiz` VALUES(22, 'How many dimes are in a US dollar?', '10', 'hard', 2, '30', '24', '15', '10', 'on');
INSERT INTO `ibwf_quiz` VALUES(23, 'What is the chemical symbol for Gold*wank*', 'au', 'hard', 3, 'pn', 'ga', 'au', 'cn', 'on');
INSERT INTO `ibwf_quiz` VALUES(24, 'Which television character has the car registration plate FAB1*wank*', 'lady penelope', 'hard', 4, 'fed', 'smufs', 'lady penelope', 'tom and jerry', 'on');
INSERT INTO `ibwf_quiz` VALUES(25, 'Who composed the ballets The Nutcracker and Swan Lake *wank*', 'peter tchaikovsky', 'hard', 5, 'rob tilton', 'james corbet', 'peter tchaikovsky', 'tom hanks', 'on');
INSERT INTO `ibwf_quiz` VALUES(26, 'If you suffered from arachnophobia what would you have an irrational fear of', 'spiders', 'hard', 6, 'brids', 'dogs', 'spiders', 'ants', 'on');
INSERT INTO `ibwf_quiz` VALUES(27, 'Which company produces the computer operating system Windows', 'microsoft', 'hard', 7, 'windows xp', 'vesta', 'windows nt', 'microsoft', 'on');
INSERT INTO `ibwf_quiz` VALUES(28, 'What is the deepest lake in the world, with depths over 1,600 metres', 'lake baykal', 'hard', 8, 'lake baykal', 'lake tinaroo', 'lake paroo', 'the glass lake', 'on');
INSERT INTO `ibwf_quiz` VALUES(29, 'What city does Sugar Loaf mountain overlook?', 'rio de janeiro', 'hard', 9, 'vegas', 'reno', 'rio de janeiro', 'green land', 'on');
INSERT INTO `ibwf_quiz` VALUES(30, 'What were the names of the 3 ships Christopher Columbus led in his discovery of da Americas in 1492', 'santa maria nina', 'hard', 10, 'santa maria nina', 'maria pinta nina', 'pinta santa nove', 'nina pinta santa', 'on');
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_quizusers`
--
CREATE TABLE `ibwf_quizusers` (
`uid` int(100) NOT NULL default '0',
`easy_question` char(2) NOT NULL default '0',
`easy_next` char(2) NOT NULL default '0',
`med_question` char(2) NOT NULL default '0',
`med_next` char(2) NOT NULL default '0',
`hard_question` char(2) NOT NULL default '0',
`hard_next` char(2) NOT NULL default '0',
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ibwf_quizusers`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_rooms`
--
CREATE TABLE `ibwf_rooms` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`pass` varchar(100) NOT NULL default '',
`static` char(1) NOT NULL default '',
`mage` int(10) NOT NULL default '0',
`maxage` int(10) NOT NULL default '0',
`chposts` int(100) NOT NULL default '0',
`perms` int(10) NOT NULL default '0',
`censord` char(1) NOT NULL default '1',
`freaky` char(1) NOT NULL default '0',
`lastmsg` int(100) NOT NULL default '0',
`clubid` int(100) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
FULLTEXT KEY `name_2` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_rooms`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_rss`
--
CREATE TABLE `ibwf_rss` (
`id` int(50) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`link` varchar(150) NOT NULL default '',
`srcd` varchar(200) NOT NULL default '',
`dscr` varchar(100) NOT NULL default '',
`imgsrc` varchar(100) NOT NULL default '',
`pubdate` varchar(50) NOT NULL default '',
`fid` int(50) NOT NULL default '0',
`lupdate` int(100) NOT NULL default '0',
`pgurl` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_rss`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_rssdata`
--
CREATE TABLE `ibwf_rssdata` (
`id` int(100) NOT NULL auto_increment,
`rssid` int(50) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`link` varchar(255) NOT NULL default '',
`imgsrc` varchar(255) NOT NULL default '',
`text` blob NOT NULL,
`pubdate` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_rssdata`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_search`
--
CREATE TABLE `ibwf_search` (
`id` int(20) NOT NULL auto_increment,
`svar1` varchar(50) NOT NULL default '',
`svar2` varchar(50) NOT NULL default '',
`svar3` varchar(50) NOT NULL default '',
`svar4` varchar(50) NOT NULL default '',
`svar5` varchar(50) NOT NULL default '',
`stime` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_search`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_ses`
--
CREATE TABLE `ibwf_ses` (
`id` varchar(100) NOT NULL default '',
`uid` varchar(30) NOT NULL default '',
`expiretm` int(100) NOT NULL default '0',
UNIQUE KEY `id` (`id`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ibwf_ses`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_settings`
--
CREATE TABLE `ibwf_settings` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`value` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `ibwf_settings`
--
INSERT INTO `ibwf_settings` VALUES(1, 'sesexp', '20');
INSERT INTO `ibwf_settings` VALUES(2, '', '');
INSERT INTO `ibwf_settings` VALUES(3, '4ummsg', '');
INSERT INTO `ibwf_settings` VALUES(4, 'Counter', '0');
INSERT INTO `ibwf_settings` VALUES(5, 'pmaf', '');
INSERT INTO `ibwf_settings` VALUES(6, 'reg', '0');
INSERT INTO `ibwf_settings` VALUES(7, 'fview', '0');
INSERT INTO `ibwf_settings` VALUES(8, 'lastbpm', '2007-11-02');
INSERT INTO `ibwf_settings` VALUES(9, 'sitename', '');
INSERT INTO `ibwf_settings` VALUES(10, 'vldtn', '1');
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_shouts`
--
CREATE TABLE `ibwf_shouts` (
`id` int(100) NOT NULL auto_increment,
`shout` varchar(100) NOT NULL default '',
`shouter` int(100) NOT NULL default '0',
`shtime` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_shouts`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_smilies`
--
CREATE TABLE `ibwf_smilies` (
`id` int(100) NOT NULL auto_increment,
`scode` varchar(15) NOT NULL default '',
`imgsrc` varchar(200) NOT NULL default '',
`hidden` char(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `scode` (`scode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=83 ;
--
-- Dumping data for table `ibwf_smilies`
--
INSERT INTO `ibwf_smilies` VALUES(1, '(advice)', '../smilies/advice.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(2, '(angry)', '../smilies/angry.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(3, '(anvil)', '../smilies/anvil.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(4, '(ape)', '../smilies/ape.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(5, '(argh)', '../smilies/argh.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(6, '(ausflag)', '../smilies/ausflag.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(7, '(backstab)', '../smilies/backstab.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(8, '(grin)', '../smilies/grin.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(9, '(badidea)', '../smilies/badidea.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(10, '(blowkiss)', '../smilies/blowkiss.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(11, '(boast)', '../smilies/boast.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(12, '(boo)', '../smilies/boo.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(13, '(bored)', '../smilies/bored.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(14, '(bounce)', '../smilies/bounce.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(15, '(clap)', '../smilies/clap.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(16, '(comein)', '../smilies/comein.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(17, '(crazy)', '../smilies/crazy.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(18, '(crying)', '../smilies/crying.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(19, '(dance)', '../smilies/dance.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(20, '(depressed)', '../smilies/depressed.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(21, '(devil)', '../smilies/devil.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(22, '(dizzy)', '../smilies/dizzy.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(23, '(excited)', '../smilies/excited.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(24, '(faceslap)', '../smilies/faceslap.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(25, '(faint)', '../smilies/faint.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(26, '(felix)', '../smilies/felix.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(27, '(fire)', '../smilies/fire.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(28, '(friends)', '../smilies/friends.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(29, '(fukoff)', '../smilies/fukoff.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(30, '(getout)', '../smilies/getout.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(31, '(girlfight)', '../smilies/girlfight.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(32, '(giveheart)', '../smilies/giveheart.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(33, '(haha)', '../smilies/haha.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(34, '(heart)', '../smilies/heart.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(35, '(heaven)', '../smilies/heaven.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(36, '(hehe)', '../smilies/hehe.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(37, '(hello)', '../smilies/hello.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(38, '(hi)', '../smilies/hi.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(39, '(hifive)', '../smilies/hifive.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(40, '(horn)', '../smilies/horn.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(41, '(hug)', '../smilies/hug.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(42, '(kick)', '../smilies/kick.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(43, '(king)', '../smilies/king.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(44, '(kiss)', '../smilies/kiss.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(45, '(latch)', '../smilies/latch.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(46, '(laugh)', '../smilies/laugh.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(47, '(lmao)', '../smilies/lmao.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(48, '(lovebump)', '../smilies/lovebump.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(49, '(mwah)', '../smilies/mwah.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(50, '(nod)', '../smilies/nod.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(51, '(nono)', '../smilies/nono.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(52, '(photo)', '../smilies/photo.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(53, '(poke)', '../smilies/poke.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(54, '(poledance)', '../smilies/poledance.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(55, '(poof)', '../smilies/poof.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(56, '(punch)', '../smilies/punch.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(57, '(queen)', '../smilies/queen.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(58, '(rose)', '../smilies/rose.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(59, '(screw)', '../smilies/screw.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(60, '(secret)', '../smilies/secret.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(61, '(slap)', '../smilies/slap.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(62, '(slug)', '../smilies/slug.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(63, '(smooch)', '../smilies/smooch.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(64, '(snatch)', '../smilies/snatch.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(65, '(sniper)', '../smilies/sniper.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(66, '(spin)', '../smilies/spin.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(67, '(spinbounce)', '../smilies/spinbounce.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(68, '(spy)', '../smilies/spy.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(69, '(starfish)', '../smilies/starfish.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(70, '(stars)', '../smilies/stars.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(71, '(suicide)', '../smilies/suicide.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(72, '(swing)', '../smilies/swing.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(73, '(tea)', '../smilies/tea.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(74, '(tired)', '../smilies/tired.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(75, '(trip)', '../smilies/trip.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(76, '(vampire)', '../smilies/vampire.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(77, '(wakeup)', '../smilies/wakeup.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(78, '(warriordude)', '../smilies/warriordude.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(79, '(welcome)', '../smilies/welcome.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(80, '(welcome2)', '../smilies/welcome2.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(81, '(witch)', '../smilies/witch.gif', '0');
INSERT INTO `ibwf_smilies` VALUES(82, '(yum)', '../smilies/yum.gif', '0');
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_themes`
--
CREATE TABLE `ibwf_themes` (
`id` int(100) NOT NULL auto_increment,
`name` varchar(15) NOT NULL default '',
`bgc` varchar(6) NOT NULL default '',
`txc` varchar(6) NOT NULL default '',
`lnk` varchar(6) NOT NULL default '',
`hdc` varchar(6) NOT NULL default '',
`hbg` varchar(6) NOT NULL default '',
`brdr` varchar(6) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_themes`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_topics`
--
CREATE TABLE `ibwf_topics` (
`id` int(100) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`fid` int(100) NOT NULL default '0',
`authorid` int(100) NOT NULL default '0',
`text` blob NOT NULL,
`pinned` char(1) NOT NULL default '0',
`closed` char(1) NOT NULL default '0',
`crdate` int(100) NOT NULL default '0',
`views` int(100) NOT NULL default '0',
`reported` char(1) NOT NULL default '0',
`lastpost` int(100) NOT NULL default '0',
`moved` char(1) NOT NULL default '0',
`pollid` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_topics`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_uploads`
--
CREATE TABLE `ibwf_uploads` (
`id` int(11) NOT NULL auto_increment,
`uid` int(11) NOT NULL default '0',
`filename` text NOT NULL,
`date` varchar(100) NOT NULL default '',
`filesize` text NOT NULL,
`uip` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_uploads`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_users`
--
CREATE TABLE `ibwf_users` (
`id` int(100) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`pass` varchar(60) NOT NULL default '',
`birthday` varchar(50) NOT NULL default '',
`sex` char(1) NOT NULL default '',
`location` varchar(100) NOT NULL default '',
`perm` char(1) NOT NULL default '0',
`posts` int(100) NOT NULL default '0',
`plusses` int(100) NOT NULL default '700',
`signature` varchar(100) NOT NULL default '',
`avatar` varchar(100) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`browserm` varchar(50) NOT NULL default '',
`ipadd` varchar(30) NOT NULL default '',
`lastact` int(100) NOT NULL default '0',
`regdate` int(100) NOT NULL default '0',
`chmsgs` int(100) NOT NULL default '0',
`chmood` int(100) NOT NULL default '0',
`shield` char(1) NOT NULL default '0',
`gplus` int(100) NOT NULL default '700',
`budmsg` varchar(100) NOT NULL default '',
`lastpnreas` varchar(100) NOT NULL default '',
`lastplreas` varchar(100) NOT NULL default '',
`shouts` int(100) NOT NULL default '0',
`pollid` int(100) NOT NULL default '0',
`rbcid` varchar(255) NOT NULL default '',
`hvia` char(1) NOT NULL default '1',
`lastvst` int(100) NOT NULL default '0',
`battlep` int(100) NOT NULL default '700',
`popmsg` char(1) NOT NULL default '1',
`automsgs` char(1) NOT NULL default '1',
`validated` char(1) NOT NULL default '0',
`theme` varchar(100) NOT NULL default 'white_medium.css',
`hidden` char(1) NOT NULL default '0',
`quiz_score` varchar(20) NOT NULL default '0',
`quiz_easy` char(3) NOT NULL default 'no',
`quiz_medium` char(3) NOT NULL default 'no',
`quiz_hard` char(3) NOT NULL default 'no',
`total_score` varchar(10) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_users`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_usfun`
--
CREATE TABLE `ibwf_usfun` (
`id` int(100) NOT NULL auto_increment,
`uid` int(100) NOT NULL default '0',
`action` varchar(10) NOT NULL default '',
`target` int(100) NOT NULL default '0',
`actime` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_usfun`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_vault`
--
CREATE TABLE `ibwf_vault` (
`id` int(100) NOT NULL auto_increment,
`uid` int(100) NOT NULL default '0',
`title` varchar(50) NOT NULL default '',
`itemurl` varchar(255) NOT NULL default '',
`pudt` int(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_vault`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_xinfo`
--
CREATE TABLE `ibwf_xinfo` (
`id` int(100) NOT NULL auto_increment,
`uid` int(100) NOT NULL default '0',
`country` varchar(50) NOT NULL default '',
`city` varchar(50) NOT NULL default '',
`street` varchar(50) NOT NULL default '',
`timezone` char(3) NOT NULL default '',
`height` varchar(10) NOT NULL default '',
`weight` varchar(10) NOT NULL default '',
`phoneno` varchar(20) NOT NULL default '',
`likes` varchar(250) NOT NULL default '',
`deslikes` varchar(250) NOT NULL default '',
`realname` varchar(100) NOT NULL default '',
`racerel` varchar(100) NOT NULL default '',
`hairtype` varchar(50) NOT NULL default '',
`eyescolor` varchar(10) NOT NULL default '',
`profession` varchar(100) NOT NULL default '',
`habitsb` varchar(250) NOT NULL default '',
`habitsg` varchar(250) NOT NULL default '',
`favsport` varchar(100) NOT NULL default '',
`favmusic` varchar(100) NOT NULL default '',
`moretext` blob NOT NULL,
`budsonly` char(1) NOT NULL default '1',
`sexpre` char(1) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_xinfo`
--