#
#  dbtables.sql
#
#  Simplifies the task of creating all the database tables
#  used by the login system.
#
#  Can be run from command prompt by typing:
#
#  mysql -u yourusername -D yourdatabasename < dbtables.sql
#
#  That's with dbtables.sql in the mysql bin directory, but
#  you can just include the path to dbtables.sql and that's
#  fine too.
#
#  Written by: Jpmaster77 a.k.a. The Grandmaster of C++ (GMC)
#  Last Updated: August 13, 2004
#

#
#  Table structure for users table
#
DROP TABLE IF EXISTS users;

CREATE TABLE users (
 username varchar(30) primary key,
 password varchar(32),
 userid varchar(32),
 userlevel tinyint(1) unsigned not null,
 email varchar(50),
 timestamp int(11) unsigned not null
);


#
#  Table structure for active users table
#
DROP TABLE IF EXISTS active_users;

CREATE TABLE active_users (
 username varchar(30) primary key,
 timestamp int(11) unsigned not null
);


#
#  Table structure for active guests table
#
DROP TABLE IF EXISTS active_guests;

CREATE TABLE active_guests (
 ip varchar(15) primary key,
 timestamp int(11) unsigned not null
);


#
#  Table structure for banned users table
#
DROP TABLE IF EXISTS banned_users;

CREATE TABLE banned_users (
 username varchar(30) primary key,
 timestamp int(11) unsigned not null
);


DROP TABLE IF EXISTS vs_projects;

CREATE TABLE vs_projects (
 projectid int(32) auto_increment primary key,
 projectname varchar(255),
 username varchar(30),
 title varchar(255),
 description longtext,
 cat int(32),
 keywords varchar(255),
 perday int(32),
 lastsubmitdate DATE,
 sitestosubmit longtext,
 sitesdone longtext,
 sitesfailed longtext,
 active int(2),
 submitstamp DATE,
 destinationurl varchar(255),
 videoid int(32),
 todaycount int(32),
 priority int(32),
 lastsite int(32)
);


DROP TABLE IF EXISTS vs_sites;

CREATE TABLE vs_sites (
 siteid int(32) auto_increment primary key,
 sitename varchar(255),
 url varchar(255),
 active int(2),
 submitfunction varchar(255)
);



DROP TABLE IF EXISTS vs_videos;


CREATE TABLE vs_videos (
 videoid int(32) auto_increment primary key,
 videoname varchar(255),
 size int(32),
 length varchar(255),
 username varchar(30),
 filename varchar(255)
);

DROP TABLE IF EXISTS vs_sitelogins;


CREATE TABLE vs_sitelogins (
 siteloginid int(32) auto_increment primary key,
 login varchar(255),
 username varchar(30),
 password int(32),
 siteid int(32)
);

DROP TABLE IF EXISTS vs_statuslog;


CREATE TABLE vs_statuslog (
 logid int(32) auto_increment primary key,
 projectid int(32),
 username varchar(30),
 siteid int(32),
 status varchar(255),
 videourl longtext,
 views int(32),
 comments int(32),
 ratings int(32)
);