Miscellany

-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-2ubuntu1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jul 05, 2007 at 04:52 PM
-- Server version: 5.0.38
-- PHP Version: 5.2.1
-- 
-- Database: `lansintv`
-- 

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

-- 
-- Table structure for table `admins`
-- 

CREATE TABLE `admins` (
  `userid` int(11) NOT NULL,
  `privileges` tinyint(4) NOT NULL,
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `banfile`
-- 

CREATE TABLE `banfile` (
  `fileid` int(11) NOT NULL,
  `filebanned` tinyint(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `history`
-- 

CREATE TABLE `history` (
  `historyid` int(11) NOT NULL auto_increment,
  `clipid` int(11) NOT NULL,
  `timestamp` int(11) NOT NULL,
  PRIMARY KEY  (`historyid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=144 ;

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

-- 
-- Table structure for table `playlist`
-- 

CREATE TABLE `playlist` (
  `clipid` int(11) NOT NULL auto_increment,
  `filename` text NOT NULL,
  `votes` int(11) NOT NULL default '0',
  `md5sum` varchar(64) NOT NULL,
  `uploaderid` int(11) NOT NULL,
  PRIMARY KEY  (`clipid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

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

-- 
-- Table structure for table `user`
-- 

CREATE TABLE `user` (
  `userid` int(11) NOT NULL,
  `votes` int(11) NOT NULL,
  `group` tinyint(4) NOT NULL,
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `votesleft`
-- 

CREATE TABLE `votesleft` (
  `userid` int(11) NOT NULL,
  `votesleft` int(11) NOT NULL default '10',
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;