CREATE TABLE `admins` (
`id` varchar(32) NOT NULL default '',
`user` text NOT NULL,
`password` varchar(32) NOT NULL default '',
`email` varchar(63) NOT NULL default '',
`status` char(2) NOT NULL default '',
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `admins`
#
INSERT INTO `admins` VALUES ('aa2dfefd34c06bf20c81cc04d31f2579', 'webadmin', 'add6bb58e139be103324d04d82d8f545', '[email protected]', 'a');
# --------------------------------------------------------
#
# Table structure for table `comments`
#
CREATE TABLE `comments` (
`id` varchar(5) NOT NULL default '',
`entry` text NOT NULL,
`name` text NOT NULL,
`email` varchar(63) NOT NULL default '',
`homepage` varchar(63) NOT NULL default '',
`date` varchar(20) NOT NULL default '',
`time` varchar(5) NOT NULL default '',
KEY `id` (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `comments`
#
# --------------------------------------------------------
#
# Table structure for table `posts`
#
CREATE TABLE `posts` (
`id` int(5) unsigned zerofill NOT NULL auto_increment,
`entry` text NOT NULL,
`title` text NOT NULL,
`author` text NOT NULL,
`day` varchar(20) NOT NULL default '',
`date` varchar(20) NOT NULL default '',
`time` varchar(5) NOT NULL default '',
`commentxt` text NOT NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;
#
# Dumping data for table `posts`
#