# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Sep 24, 2004 at 08:28 AM
# Server version: 4.0.20
# PHP Version: 4.3.8
# 
# Database : `allthetr_allthetr`
# 

# --------------------------------------------------------

#
# Table structure for table `triad_banners`
#

CREATE TABLE `surf_banners` (
  `id` int(11) NOT NULL auto_increment,
  `username` text,
  `points` int(11) NOT NULL default '0',
  `showtill` date NOT NULL,
  `stats` int(11) NOT NULL default '0',
  `text` text NOT NULL,
  `link` text NOT NULL,
  `status` text NOT NULL,
  `active` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) ;

# --------------------------------------------------------

#
# Table structure for table `triad_users`
#

CREATE TABLE `surf_users` (
  `userid` int(11) NOT NULL auto_increment,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `activationcode` int(11) NOT NULL default '0',
  `ref` text NOT NULL,
  `points` decimal(7,3) NOT NULL default '50.000',
  `lastsurfed` int(11) NOT NULL default '0',
  `email` text NOT NULL,
  `verified` text NOT NULL,
  `joindate` bigint(20) NOT NULL default '0',
  `realname` text NOT NULL,
  `surftime` int(11) NOT NULL default '0',
  `type` text NOT NULL,
  `level` text NOT NULL, 
  PRIMARY KEY  (`userid`),
  KEY `id_2` (`userid`)
) ;

# --------------------------------------------------------

#
# Table structure for table `triad_websites`
#

CREATE TABLE `surf_websites` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL default '0',
  `url` text NOT NULL,
  `stats` int(11) NOT NULL default '0',
  `active` tinytext NOT NULL,
  `status` text NOT NULL,
  PRIMARY KEY  (`id`)
);
