# MySQL-Front 3.2  (Build 6.2)

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET CHARACTER SET 'utf8' */;

# Host: localhost    Database: gbook
# ------------------------------------------------------
# Server version 5.0.22-community-nt

DROP DATABASE IF EXISTS `gbook`;
CREATE DATABASE `gbook` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `gbook`;

#
# Table structure for table bookcontent
#

CREATE TABLE `bookcontent` (
  `id` varchar(100) NOT NULL,
  `gbtitle` varchar(250) default NULL,
  `gbuser` varchar(50) default NULL,
  `gbmail` varchar(50) default NULL,
  `gbcontent` longtext,
  `gbface` varchar(50) default NULL,
  `gbhide` int(11) default NULL,
  `gbtime` varchar(30) default NULL,
  `gbip` varchar(20) default NULL,
  `gbre` longtext,
  `gbretime` varchar(30) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Dumping data for table bookcontent
#


#
# Table structure for table manager
#

CREATE TABLE `manager` (
  `id` varchar(100) NOT NULL,
  `username` varchar(50) default NULL,
  `userpass` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Dumping data for table manager
#

INSERT INTO `manager` (`id`,`username`,`userpass`) VALUES ('402880821288eb96011289070d7f0002','admin','0CC175B9C0F1B6A831C399E269772661');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
