Edit - vxgb.sql

Edit: vxgb.sql

-- 
-- Database: `vxgb`
--

-- --------------------------------------------------------

-- 
-- Table structure for table `[[dbprefix]]ban`
--

CREATE TABLE `[[dbprefix]]ban` (
  `bid` int(11) unsigned NOT NULL auto_increment,
  `type` tinyint(4) unsigned NOT NULL default '0',
  `value` varchar(250) NOT NULL default '0',
  PRIMARY KEY  (`bid`),
  KEY `type` (`type`,`value`(1))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `[[dbprefix]]ban`
--

-- --------------------------------------------------------

-- 
-- Table structure for table `[[dbprefix]]config`
--

CREATE TABLE `[[dbprefix]]config` (
  `vid` int(11) unsigned NOT NULL auto_increment,
  `variable` varchar(30) NOT NULL default '0',
  `value` text NOT NULL,
  `req` tinyint(4) unsigned NOT NULL default '1',
  `name` varchar(40) NOT NULL default '0',
  PRIMARY KEY  (`vid`),
  KEY `ivariable` (`variable`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `[[dbprefix]]config`
--

INSERT INTO `[[dbprefix]]config` VALUES (2, 'admin_name', '[[admin_username]]', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (3, 'admin_pass', '[[admin_pass]]', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (4, 'word_censor', '1', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (5, 'captcha', '0', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (6, 'admin_valid', '0', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (7, 'allow_html', '0', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (8, 'allowed_tags', '<i><font><b>', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (9, 'poster_name', '0', 1, '0');
INSERT INTO `[[dbprefix]]config` VALUES (10, 'poster_mail', '1', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (11, 'poster_location', '1', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (12, 'msn', '1', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (13, 'aim', '1', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (14, 'yim', '1', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (15, 'homepage', '1', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (16, 'icq', '1', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (17, 'gender', '1', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (18, 'age', '1', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (19, 'c_field_1', '1', 0, 'field name');
INSERT INTO `[[dbprefix]]config` VALUES (20, 'c_field_2', '1', 0, 'field name');
INSERT INTO `[[dbprefix]]config` VALUES (21, 'c_field_3', '1', 0, 'field name');
INSERT INTO `[[dbprefix]]config` VALUES (22, 'c_field_4', '1', 0, 'field name');
INSERT INTO `[[dbprefix]]config` VALUES (23, 'c_field_5', '1', 0, 'field name');
INSERT INTO `[[dbprefix]]config` VALUES (24, 'template', 'subsilver', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (25, 'lang', 'english', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (26, 'gzip', '0', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (27, 'min_len', '10', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (28, 'max_len', '1024', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (29, 'max_word_lenght', '40', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (30, 'flood_time', '60', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (31, 'per_page', '10', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (32, 'max_visitors_online', '1', 0, '1170642004');
INSERT INTO `[[dbprefix]]config` VALUES (33, 'gb_title', '[[site_desc]]', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (34, 'gb_webpath', '[[softurl]]', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (35, 'copy', 'Powered by <a href="http://phpversion.com">Free PHP VX Guestbook</a>', 1, '1171770911');
INSERT INTO `[[dbprefix]]config` VALUES (36, 'tzone', '0', 1, '0');
INSERT INTO `[[dbprefix]]config` VALUES (37, 'enot', '0', 0, '0');
INSERT INTO `[[dbprefix]]config` VALUES (38, 'admin_mail', '[[admin_email]]', 0, '0');

-- --------------------------------------------------------

-- 
-- Table structure for table `[[dbprefix]]posts`
--

CREATE TABLE `[[dbprefix]]posts` (
  `pid` int(11) unsigned NOT NULL auto_increment,
  `date` int(11) unsigned NOT NULL default '0',
  `text` text NOT NULL,
  `poster` varchar(240) NOT NULL default '',
  `location` varchar(130) NOT NULL default '',
  `posteremail` varchar(240) NOT NULL default '',
  `msn` varchar(25) NOT NULL default '',
  `aim` varchar(70) NOT NULL default '',
  `yim` varchar(25) NOT NULL default '',
  `homepage` varchar(240) NOT NULL default '',
  `icq` int(11) unsigned default NULL,
  `useragent` varchar(240) NOT NULL default '',
  `gender` char(1) NOT NULL default '',
  `age` varchar(40) NOT NULL default '',
  `validated` tinyint(1) unsigned NOT NULL default '1',
  `c_field_1` varchar(100) NOT NULL default '',
  `c_field_2` varchar(100) NOT NULL default '',
  `c_field_3` varchar(100) NOT NULL default '',
  `c_field_4` varchar(100) NOT NULL default '',
  `c_field_5` varchar(100) NOT NULL default '',
  `pip` varchar(16) NOT NULL default '0',
  PRIMARY KEY  (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `[[dbprefix]]posts`
--

INSERT INTO `[[dbprefix]]posts` VALUES (1, 1169100000, 'Thanks for using Free PHP VX Guestook', 'PHP VX Guestbook', 'USA', '', '', '', '', 'phpversion.com', NULL, '', 'M', '28', 1, '', '', '', '', '', '0');

-- --------------------------------------------------------

-- 
-- Table structure for table `[[dbprefix]]sessions`
--

CREATE TABLE `[[dbprefix]]sessions` (
  `ip` varchar(16) default NULL,
  `stime` int(11) unsigned NOT NULL default '0',
  `sname` varchar(10) NOT NULL default '0',
  `sval` varchar(15) NOT NULL default '0',
  PRIMARY KEY  (`stime`),
  KEY `ip_stime_sname` (`ip`,`stime`,`sname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `[[dbprefix]]sessions`
--

-- --------------------------------------------------------

-- 
-- Table structure for table `[[dbprefix]]smilies`
--

CREATE TABLE `[[dbprefix]]smilies` (
  `sid` smallint(5) unsigned NOT NULL auto_increment,
  `code` varchar(50) default NULL,
  `smile_url` varchar(100) default NULL,
  `emoticon` varchar(75) default NULL,
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `[[dbprefix]]smilies`
--

INSERT INTO `[[dbprefix]]smilies` VALUES (1, ':D', 'icon_biggrin.gif', 'Very Happy');
INSERT INTO `[[dbprefix]]smilies` VALUES (4, ':)', 'icon_smile.gif', 'Smile');
INSERT INTO `[[dbprefix]]smilies` VALUES (7, ':(', 'icon_sad.gif', 'Sad');
INSERT INTO `[[dbprefix]]smilies` VALUES (10, ':o)', 'icon_surprised.gif', 'Surprised');
INSERT INTO `[[dbprefix]]smilies` VALUES (12, ':eek:', 'icon_surprised.gif', 'Surprised');
INSERT INTO `[[dbprefix]]smilies` VALUES (13, ':shock:', 'icon_eek.gif', 'Shocked');
INSERT INTO `[[dbprefix]]smilies` VALUES (14, ':?', 'icon_confused.gif', 'Confused');
INSERT INTO `[[dbprefix]]smilies` VALUES (17, '8)', 'icon_cool.gif', 'Cool');
INSERT INTO `[[dbprefix]]smilies` VALUES (20, ':lol:', 'icon_lol.gif', 'Laughing');
INSERT INTO `[[dbprefix]]smilies` VALUES (21, ':x', 'icon_mad.gif', 'Mad');
INSERT INTO `[[dbprefix]]smilies` VALUES (24, ':P', 'icon_razz.gif', 'Razz');
INSERT INTO `[[dbprefix]]smilies` VALUES (27, ':oops:', 'icon_redface.gif', 'Embarassed');
INSERT INTO `[[dbprefix]]smilies` VALUES (28, ':cry:', 'icon_cry.gif', 'Crying or Very sad');
INSERT INTO `[[dbprefix]]smilies` VALUES (29, ':evil:', 'icon_evil.gif', 'Evil or Very Mad');
INSERT INTO `[[dbprefix]]smilies` VALUES (30, ':twisted:', 'icon_twisted.gif', 'Twisted Evil');
INSERT INTO `[[dbprefix]]smilies` VALUES (31, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes');
INSERT INTO `[[dbprefix]]smilies` VALUES (33, ';)', 'icon_wink.gif', 'Wink');
INSERT INTO `[[dbprefix]]smilies` VALUES (35, ':!:', 'icon_exclaim.gif', 'Exclamation');
INSERT INTO `[[dbprefix]]smilies` VALUES (36, ':?:', 'icon_question.gif', 'Question');
INSERT INTO `[[dbprefix]]smilies` VALUES (37, ':idea:', 'icon_idea.gif', 'Idea');
INSERT INTO `[[dbprefix]]smilies` VALUES (38, ':arrow:', 'icon_arrow.gif', 'Arrow');
INSERT INTO `[[dbprefix]]smilies` VALUES (39, ':|', 'icon_neutral.gif', 'Neutral');
INSERT INTO `[[dbprefix]]smilies` VALUES (42, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');

Cancel