Chattaddict.mobi

[riderz]

here are one ive just removed the images so its smaller now

-- phpMyAdmin SQL Dump
-- version 3.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 12, 2009 at 12:51 AM
-- Server version: 5.1.30
-- PHP Version: 5.2.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `chataddict`
--

-- --------------------------------------------------------

--
-- Table structure for table `buddies`
--

CREATE TABLE IF NOT EXISTS `buddies` (
  `username1` varchar(15) NOT NULL,
  `username2` varchar(15) NOT NULL,
  `isaccepted` tinyint(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `chat`
--

CREATE TABLE IF NOT EXISTS `chat` (
  `id` mediumint(20) NOT NULL AUTO_INCREMENT,
  `chatusername` varchar(15) NOT NULL,
  `message` varchar(255) NOT NULL,
  `room` varchar(30) NOT NULL,
  `endtime` int(20) NOT NULL,
  `member` tinyint(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `chattersonline`
--

CREATE TABLE IF NOT EXISTS `chattersonline` (
  `chatusername` varchar(15) NOT NULL,
  `time` int(20) NOT NULL,
  `id` varchar(40) NOT NULL,
  PRIMARY KEY (`chatusername`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `forumreplies`
--

CREATE TABLE IF NOT EXISTS `forumreplies` (
  `id` bigint(10) DEFAULT NULL,
  `username` varchar(15) DEFAULT NULL,
  `message` varchar(400) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `key` bigint(10) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`key`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `forumthreads`
--

CREATE TABLE IF NOT EXISTS `forumthreads` (
  `id` bigint(6) NOT NULL AUTO_INCREMENT,
  `username` varchar(15) NOT NULL,
  `topic` varchar(20) NOT NULL,
  `message` varchar(400) NOT NULL,
  `sticky` tinyint(2) NOT NULL,
  `locked` tinyint(2) NOT NULL,
  `date` datetime NOT NULL,
  `forum` varchar(20) NOT NULL,
  `views` int(5) NOT NULL DEFAULT '0',
  `lastdate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `gallery`
--

CREATE TABLE IF NOT EXISTS `gallery` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(15) NOT NULL,
  `ext` varchar(5) NOT NULL,
  `number` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `inbox`
--

CREATE TABLE IF NOT EXISTS `inbox` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `message` varchar(250) NOT NULL,
  `readed` tinyint(2) NOT NULL DEFAULT '0',
  `sender` varchar(20) NOT NULL,
  `thetime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `members`
--

CREATE TABLE IF NOT EXISTS `members` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `username` varchar(15) NOT NULL,
  `password` varchar(20) NOT NULL,
  `email` varchar(150) NOT NULL,
  `timezone` varchar(30) DEFAULT NULL,
  `banned` tinyint(3) DEFAULT NULL,
  PRIMARY KEY (`id`,`password`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `onlineusers`
--

CREATE TABLE IF NOT EXISTS `onlineusers` (
  `username` varchar(15) NOT NULL DEFAULT '',
  `time` int(20) NOT NULL,
  `id` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `profile`
--

CREATE TABLE IF NOT EXISTS `profile` (
  `username` varchar(20) NOT NULL,
  `name` varchar(20) DEFAULT NULL,
  `day` varchar(2) DEFAULT NULL,
  `month` varchar(2) DEFAULT NULL,
  `year` varchar(4) DEFAULT NULL,
  `location` varchar(20) DEFAULT NULL,
  `interests` varchar(150) DEFAULT NULL,
  `occupation` varchar(100) DEFAULT NULL,
  `aboutme` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `secrets`
--

CREATE TABLE IF NOT EXISTS `secrets` (
  `id` bigint(15) NOT NULL AUTO_INCREMENT,
  `message` varchar(240) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `shoutbox`
--

CREATE TABLE IF NOT EXISTS `shoutbox` (
  `id` bigint(15) NOT NULL AUTO_INCREMENT,
  `username` varchar(15) NOT NULL,
  `message` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

u can just addd ur own smilies