# MySQL-Front Dump 2.0
#
# Host: mysql1.000webhost.com    Database: a2904705_data
#--------------------------------------------------------
# Server version 3.23.33

DROP DATABASE IF EXISTS forum;

USE forum;


#
# Table structure for table 'posts'
#

CREATE TABLE `posts` (
  `postID` tinyint(3) unsigned NOT NULL auto_increment,
  `userID` tinyint(3) unsigned NOT NULL default '0',
  `threadID` tinyint(3) unsigned NOT NULL default '0',
  `body` text NOT NULL,
  `dateposted` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY (`postID`),
  UNIQUE KEY `postID`(`postID`)
) TYPE=MyISAM;



#
# Dumping data for table 'posts'
#


#
# Table structure for table 'threads'
#

CREATE TABLE `threads` (
  `threadID` tinyint(3) unsigned NOT NULL auto_increment,
  `title` char(50) NOT NULL default '0',
  PRIMARY KEY (`threadID`),
  UNIQUE KEY `threadID`(`threadID`)
) TYPE=MyISAM;


#
# Table structure for table 'users'
#

CREATE TABLE `users` (
  `userID` tinyint(3) unsigned NOT NULL auto_increment,
  `name` char(20) NOT NULL default '',
  `password` char(40) NOT NULL default '0',
  `totalposts` tinyint(3) unsigned default '0',
  `email` char(50) default NULL,
  `showemail` tinyint(3) unsigned NOT NULL default '0',
  `mod` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY (`userID`),
  UNIQUE KEY `userID`(`userID`,`name`)
) TYPE=MyISAM;



#
# Dumping data for table 'users'
#

# Mr X is a moderator. His password is 'letmein'.

INSERT INTO `users` VALUES("1","Mr X","032c41e8435273a7","3","","0","1");

GRANT SELECT, INSERT, UPDATE, DELETE
ON forum.*
TO poseidon@localhost IDENTIFIED BY 'trident';