--
-- Host: localhost    Database: viper
-- ------------------------------------------------------

# how to import this file
# mysql -u root -p viper < sql_setup.sql
#
# how to dump the database
# mysqldump -uroot -p viper > viper.sql

DROP DATABASE `viper`;
CREATE DATABASE `viper`;
USE `viper`;

#GRANT SELECT, INSERT, DELETE, UPDATE ON viper.* TO squander@localhost IDENTIFIED BY 'tobey101';



--
-- Table structure for table `downloads`
--

CREATE TABLE `downloads` (
  `FileName` varchar(50) DEFAULT NULL,
  `Author` varchar(20) DEFAULT NULL,
  `FileSize` int(10) DEFAULT NULL,
  `DownLoaded` int(10) DEFAULT NULL,
  `Description` varchar(200) DEFAULT NULL,
  `id` tinyint(9) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='VGC - downloads';

--
-- Dumping data for table `downloads`
--

INSERT INTO `downloads` VALUES ('sortdemo.zip','Gary Conway',20000,1255,'Sort Demo',0);

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `startid` tinyint(10) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(30) DEFAULT NULL,
  `Password` varchar(100) DEFAULT NULL,
  `RealName` varchar(20) DEFAULT NULL,
  `Email` varchar(40) DEFAULT NULL,
  `Level` varchar(5) DEFAULT '0',
  `Validated` varchar(2) DEFAULT '0',
  PRIMARY KEY (`startid`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COMMENT='VGC - users';

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'viper','54355cc0779a8bca1b079050d5cc6683','Gary','codeboy@iglou.com','255','1'),(2,'bobf','54355cc0779a8bca1b079050d5cc6683','Bob Fergus','bob@iglou.com','1','1');


