-- MySQL dump 10.9 -- -- Host: localhost Database: jodyf_vgb1 -- ------------------------------------------------------ -- Server version 4.1.22-standard-log /*!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 NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `VGB_ACTION` -- DROP TABLE IF EXISTS `VGB_ACTION`; CREATE TABLE `VGB_ACTION` ( `VID` int(11) NOT NULL default '0', `TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00', `ACTION` int(11) NOT NULL default '0', `DETAILS` varchar(255) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_ACTION` -- LOCK TABLES `VGB_ACTION` WRITE; /*!40000 ALTER TABLE `VGB_ACTION` DISABLE KEYS */; INSERT INTO `VGB_ACTION` VALUES (1,'2007-03-13 16:26:14',1,'1'); /*!40000 ALTER TABLE `VGB_ACTION` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_ADMIN` -- DROP TABLE IF EXISTS `VGB_ADMIN`; CREATE TABLE `VGB_ADMIN` ( `ID` int(11) NOT NULL auto_increment, `NAME` varchar(255) NOT NULL default '', `PASSWORD` varchar(30) NOT NULL default '', `LASTLOGIN` datetime NOT NULL default '0000-00-00 00:00:00', `LOGINS` int(10) unsigned NOT NULL default '0', `COMMENTNAME` varchar(255) NOT NULL default '', `COMMENTEMAIL` varchar(127) NOT NULL default '', `ACCEPT` tinyint(1) NOT NULL default '0', `REJECT` tinyint(1) NOT NULL default '0', `EDIT` tinyint(1) NOT NULL default '0', `COMMENT` tinyint(1) NOT NULL default '0', `DEL` tinyint(1) NOT NULL default '0', `CLOSE` tinyint(1) NOT NULL default '0', `BANUSER` tinyint(1) NOT NULL default '0', `ENTRYSENT` tinyint(1) NOT NULL default '0', `COMMENTSENT` tinyint(1) NOT NULL default '0', `EMAILSENT` tinyint(1) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_ADMIN` -- LOCK TABLES `VGB_ADMIN` WRITE; /*!40000 ALTER TABLE `VGB_ADMIN` DISABLE KEYS */; /*!40000 ALTER TABLE `VGB_ADMIN` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_CACHE` -- DROP TABLE IF EXISTS `VGB_CACHE`; CREATE TABLE `VGB_CACHE` ( `ID` int(11) default NULL, `DATE` date NOT NULL default '0000-00-00', `NAME` text, `ENTRY` text NOT NULL, `COMMENT` text, `COUNTRY` int(11) default NULL, `EMAIL` varchar(128) default NULL, `HOMEPAGE` text, `ICQ` int(10) unsigned default NULL, `AIM` text, `MSN` text, `YAHOO` text, `IP` varchar(16) NOT NULL default '', `BROWSER` varchar(255) NOT NULL default '', `HOSTNAME` varchar(128) NOT NULL default '', `SIGNTIME` time default NULL, `PICTURE` varchar(32) default NULL, `PICTEXT` text, `PRIVATE` varchar(20) default NULL, `HIDEEMAIL` tinyint(1) NOT NULL default '0', `UNMODERATED` tinyint(1) NOT NULL default '0', `SKYPE` text, `JABBER` text, `GADUGADU` int(10) unsigned default NULL, `GENDER` tinyint(3) unsigned NOT NULL default '0', `CLOSED` tinyint(1) NOT NULL default '0', `STICKY` tinyint(3) unsigned NOT NULL default '0', `RATINGS` varchar(60) default NULL, `CUSTOMS` text ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_CACHE` -- LOCK TABLES `VGB_CACHE` WRITE; /*!40000 ALTER TABLE `VGB_CACHE` DISABLE KEYS */; /*!40000 ALTER TABLE `VGB_CACHE` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_COMMENT` -- DROP TABLE IF EXISTS `VGB_COMMENT`; CREATE TABLE `VGB_COMMENT` ( `ID` int(11) NOT NULL auto_increment, `ENTRYID` int(11) NOT NULL default '0', `NAME` varchar(40) NOT NULL default '', `EMAIL` varchar(40) default NULL, `TEXT` text NOT NULL, `IP` varchar(16) NOT NULL default '', `HOSTNAME` varchar(128) NOT NULL default '', `DATE` date NOT NULL default '0000-00-00', `SIGNTIME` time NOT NULL default '00:00:00', `ADMIN` tinyint(1) NOT NULL default '0', `UNMODERATED` tinyint(1) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_COMMENT` -- LOCK TABLES `VGB_COMMENT` WRITE; /*!40000 ALTER TABLE `VGB_COMMENT` DISABLE KEYS */; /*!40000 ALTER TABLE `VGB_COMMENT` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_COMMENTSPAM` -- DROP TABLE IF EXISTS `VGB_COMMENTSPAM`; CREATE TABLE `VGB_COMMENTSPAM` ( `IP` varchar(16) NOT NULL default '', `TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00', `ENTRYID` int(11) NOT NULL default '0', PRIMARY KEY (`IP`,`TSTAMP`,`ENTRYID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_COMMENTSPAM` -- LOCK TABLES `VGB_COMMENTSPAM` WRITE; /*!40000 ALTER TABLE `VGB_COMMENTSPAM` DISABLE KEYS */; /*!40000 ALTER TABLE `VGB_COMMENTSPAM` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_COUNTRY` -- DROP TABLE IF EXISTS `VGB_COUNTRY`; CREATE TABLE `VGB_COUNTRY` ( `ID` int(11) NOT NULL auto_increment, `NAME` varchar(255) NOT NULL default '', `FLAGICON` varchar(127) NOT NULL default '', `TRANSLATE` tinyint(1) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=239 DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_COUNTRY` -- LOCK TABLES `VGB_COUNTRY` WRITE; /*!40000 ALTER TABLE `VGB_COUNTRY` DISABLE KEYS */; INSERT INTO `VGB_COUNTRY` VALUES (1,'0','empty.gif',1),(2,'AL','al.gif',1),(3,'AD','ad.gif',1),(4,'AM','am.gif',1),(5,'AT','at.gif',1),(6,'BY','by.gif',1),(7,'BE','be.gif',1),(8,'BA','ba.gif',1),(9,'BG','bg.gif',1),(10,'CV','cv.gif',1),(11,'HR','hr.gif',1),(12,'CZ','cz.gif',1),(13,'DK','dk.gif',1),(14,'EE','ee.gif',1),(15,'FI','fi.gif',1),(16,'FR','fr.gif',1),(17,'GE','ge.gif',1),(18,'DE','de.gif',1),(19,'GR','gr.gif',1),(20,'HU','hu.gif',1),(21,'IS','is.gif',1),(22,'IE','ie.gif',1),(23,'IT','it.gif',1),(24,'LV','lv.gif',1),(25,'LI','li.gif',1),(26,'LT','lt.gif',1),(27,'LU','lu.gif',1),(28,'MK','mk.gif',1),(29,'MT','mt.gif',1),(30,'MD','md.gif',1),(31,'MC','mc.gif',1),(32,'NL','nl.gif',1),(33,'NO','no.gif',1),(34,'PL','pl.gif',1),(35,'PT','pt.gif',1),(36,'RO','ro.gif',1),(37,'SM','sm.gif',1),(38,'SK','sk.gif',1),(39,'SI','si.gif',1),(40,'ES','es.gif',1),(41,'SE','se.gif',1),(42,'CH','ch.gif',1),(43,'UA','ua.gif',1),(44,'UK','uk.gif',1),(45,'VA','va.gif',1),(46,'YU','yu.gif',1),(47,'AG','ag.gif',1),(48,'BS','bs.gif',1),(49,'BB','bb.gif',1),(50,'BZ','bz.gif',1),(51,'CA','ca.gif',1),(52,'CR','cr.gif',1),(53,'CU','cu.gif',1),(54,'DM','dm.gif',1),(55,'DO','do.gif',1),(56,'SV','sv.gif',1),(57,'GD','gd.gif',1),(58,'GT','gt.gif',1),(59,'HT','hi.gif',1),(60,'HN','hn.gif',1),(61,'JM','jm.gif',1),(62,'MX','mx.gif',1),(63,'NI','ni.gif',1),(64,'PA','pa.gif',1),(65,'KN','kn.gif',1),(66,'LC','lc.gif',1),(67,'VC','vc.gif',1),(68,'TT','tt.gif',1),(69,'US','us.gif',1),(70,'AR','ar.gif',1),(71,'BO','bo.gif',1),(72,'BR','br.gif',1),(73,'CL','cl.gif',1),(74,'CO','co.gif',1),(75,'EC','ec.gif',1),(76,'GY','gy.gif',1),(77,'PY','py.gif',1),(78,'PE','pe.gif',1),(79,'SR','sr.gif',1),(80,'UY','uy.gif',1),(81,'VE','ve.gif',1),(82,'CY','cy.gif',1),(83,'RU','ru.gif',1),(84,'TR','tr.gif',1),(85,'AF','af.gif',1),(86,'AZ','az.gif',1),(87,'BH','bh.gif',1),(88,'BD','bd.gif',1),(89,'BT','bt.gif',1),(90,'BN','bn.gif',1),(91,'MM','mm.gif',1),(92,'KH','kh.gif',1),(93,'CN','cn.gif',1),(94,'TP','tp.gif',1),(95,'IN','in.gif',1),(96,'ID','id.gif',1),(97,'IR','ir.gif',1),(98,'IQ','iq.gif',1),(99,'IL','il.gif',1),(100,'JP','jp.gif',1),(101,'JO','jo.gif',1),(102,'KZ','kz.gif',1),(103,'KP','kp.gif',1),(104,'KR','kr.gif',1),(105,'KW','kw.gif',1),(106,'KG','kg.gif',1),(107,'LA','la.gif',1),(108,'LB','lb.gif',1),(109,'MY','my.gif',1),(110,'MV','mv.gif',1),(111,'MN','mn.gif',1),(112,'NP','np.gif',1),(113,'OM','om.gif',1),(114,'PK','pk.gif',1),(115,'PH','ph.gif',1),(116,'QR','qr.gif',1),(117,'SA','sa.gif',1),(118,'SG','sg.gif',1),(119,'LK','lk.gif',1),(120,'SY','sy.gif',1),(121,'TW','tw.gif',1),(122,'TJ','tj.gif',1),(123,'TH','th.gif',1),(124,'TM','tm.gif',1),(125,'AE','ae.gif',1),(126,'UZ','uz.gif',1),(127,'VN','vn.gif',1),(128,'YE','ye.gif',1),(129,'DZ','dz.gif',1),(130,'AO','ao.gif',1),(131,'BJ','bj.gif',1),(132,'BW','bw.gif',1),(133,'BF','bf.gif',1),(134,'BI','bi.gif',1),(135,'CM','cm.gif',1),(136,'CF','cf.gif',1),(137,'TD','td.gif',1),(138,'KM','km.gif',1),(139,'CG','cg.gif',1),(140,'CD','cd.gif',1),(141,'CI','ci.gif',1),(142,'DJ','dj.gif',1),(143,'EG','eg.gif',1),(144,'GQ','gq.gif',1),(145,'ER','er.gif',1),(146,'ET','et.gif',1),(147,'GA','ga.gif',1),(148,'GM','gm.gif',1),(149,'GH','gh.gif',1),(150,'GN','gn.gif',1),(151,'GW','gw.gif',1),(152,'KE','ke.gif',1),(153,'LS','ls.gif',1),(154,'LR','lr.gif',1),(155,'LY','ly.gif',1),(156,'MG','mg.gif',1),(157,'MW','mw.gif',1),(158,'ML','ml.gif',1),(159,'MR','mr.gif',1),(160,'MU','mu.gif',1),(161,'MA','ma.gif',1),(162,'MZ','mz.gif',1),(163,'NA','na.gif',1),(164,'NE','ne.gif',1),(165,'NG','ng.gif',1),(166,'RW','rw.gif',1),(167,'ST','st.gif',1),(168,'SN','sn.gif',1),(169,'SC','sc.gif',1),(170,'SL','sl.gif',1),(171,'SO','so.gif',1),(172,'ZA','za.gif',1),(173,'SD','sd.gif',1),(174,'SZ','sz.gif',1),(175,'TZ','tz.gif',1),(176,'TG','tg.gif',1),(177,'TN','tn.gif',1),(178,'UG','ug.gif',1),(179,'ZM','zm.gif',1),(180,'ZW','zw.gif',1),(181,'AU','au.gif',1),(182,'FJ','fj.gif',1),(183,'KI','ki.gif',1),(184,'MH','mh.gif',1),(185,'FM','fm.gif',1),(186,'NR','nr.gif',1),(187,'NZ','nz.gif',1),(188,'PW','pw.gif',1),(189,'PG','pg.gif',1),(190,'WS','ws.gif',1),(191,'SB','sb.gif',1),(192,'TO','to.gif',1),(193,'TV','tv.gif',1),(194,'VU','vu.gif',1),(195,'AS','as.gif',1),(196,'AI','ai.gif',1),(197,'AW','aw.gif',1),(198,'BM','bm.gif',1),(199,'BV','no.gif',1),(200,'IO','io.gif',1),(201,'VG','vg.gif',1),(202,'KY','ky.gif',1),(203,'CX','au.gif',1),(204,'CC','au.gif',1),(205,'CK','ck.gif',1),(206,'FO','fo.gif',1),(207,'FK','fk.gif',1),(208,'GF','fr.gif',1),(209,'PF','pf.gif',1),(210,'GI','gi.gif',1),(211,'GL','gl.gif',1),(212,'GP','fr.gif',1),(213,'GU','gu.gif',1),(214,'GG','gg.gif',1),(215,'HM','au.gif',1),(216,'HK','hk.gif',1),(217,'IM','im.gif',1),(218,'JE','je.gif',1),(219,'MO','mo.gif',1),(220,'MQ','mq.gif',1),(221,'YT','fr.gif',1),(222,'MS','ms.gif',1),(223,'AN','an.gif',1),(224,'NC','fr.gif',1),(225,'NU','nu.gif',1),(226,'NF','nf.gif',1),(227,'MP','mp.gif',1),(228,'PR','pr.gif',1),(229,'PN','pn.gif',1),(230,'RE','fr.gif',1),(231,'SH','sh.gif',1),(232,'PM','pm.gif',1),(233,'GS','gs.gif',1),(234,'SJ','no.gif',1),(235,'TK','nz.gif',1),(236,'TC','tc.gif',1),(237,'VI','vi.gif',1),(238,'WF','wf.gif',1); /*!40000 ALTER TABLE `VGB_COUNTRY` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_COUNTRYORDER` -- DROP TABLE IF EXISTS `VGB_COUNTRYORDER`; CREATE TABLE `VGB_COUNTRYORDER` ( `LANG` varchar(127) NOT NULL default '', `SORTEDIDS` text NOT NULL, PRIMARY KEY (`LANG`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_COUNTRYORDER` -- LOCK TABLES `VGB_COUNTRYORDER` WRITE; /*!40000 ALTER TABLE `VGB_COUNTRYORDER` DISABLE KEYS */; /*!40000 ALTER TABLE `VGB_COUNTRYORDER` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_CUSTOMENTRY` -- DROP TABLE IF EXISTS `VGB_CUSTOMENTRY`; CREATE TABLE `VGB_CUSTOMENTRY` ( `ENTRY_ID` int(11) NOT NULL default '0', `FIELD_ID` tinyint(3) unsigned NOT NULL default '0', `CONTENT` varchar(255) default NULL, PRIMARY KEY (`ENTRY_ID`,`FIELD_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_CUSTOMENTRY` -- LOCK TABLES `VGB_CUSTOMENTRY` WRITE; /*!40000 ALTER TABLE `VGB_CUSTOMENTRY` DISABLE KEYS */; /*!40000 ALTER TABLE `VGB_CUSTOMENTRY` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_CUSTOMFIELD` -- DROP TABLE IF EXISTS `VGB_CUSTOMFIELD`; CREATE TABLE `VGB_CUSTOMFIELD` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `NAME` varchar(255) NOT NULL default '', `TYPE` tinyint(4) NOT NULL default '0', `RULES` text NOT NULL, `PRIORITY` tinyint(3) unsigned NOT NULL default '0', `FRCE` tinyint(1) NOT NULL default '0', `STATS` tinyint(1) NOT NULL default '0', `LIMITSTATS` int(11) NOT NULL default '0', `FORMTEXT` varchar(255) NOT NULL default '', `FILTER` tinyint(1) NOT NULL default '0', `PREALLOCATE` varchar(255) default NULL, `USEWORDWRAP` tinyint(1) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_CUSTOMFIELD` -- LOCK TABLES `VGB_CUSTOMFIELD` WRITE; /*!40000 ALTER TABLE `VGB_CUSTOMFIELD` DISABLE KEYS */; /*!40000 ALTER TABLE `VGB_CUSTOMFIELD` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_CUSTOMUSER` -- DROP TABLE IF EXISTS `VGB_CUSTOMUSER`; CREATE TABLE `VGB_CUSTOMUSER` ( `USER_ID` int(11) NOT NULL default '0', `FIELD_ID` tinyint(3) unsigned NOT NULL default '0', `CONTENT` varchar(255) NOT NULL default '', PRIMARY KEY (`USER_ID`,`FIELD_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_CUSTOMUSER` -- LOCK TABLES `VGB_CUSTOMUSER` WRITE; /*!40000 ALTER TABLE `VGB_CUSTOMUSER` DISABLE KEYS */; /*!40000 ALTER TABLE `VGB_CUSTOMUSER` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_EMAIL` -- DROP TABLE IF EXISTS `VGB_EMAIL`; CREATE TABLE `VGB_EMAIL` ( `ID` int(11) NOT NULL auto_increment, `ACTIVE` tinyint(1) NOT NULL default '0', `SUBJECT` varchar(127) default NULL, `MESSAGE` text, `HTML` tinyint(1) NOT NULL default '0', `UNCHECKED` tinyint(1) NOT NULL default '0', `IP` varchar(16) NOT NULL default '', `HOSTNAME` varchar(128) NOT NULL default '', `TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00', `SENDTO` varchar(127) NOT NULL default '', `REPLYTO` varchar(127) NOT NULL default '', PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_EMAIL` -- LOCK TABLES `VGB_EMAIL` WRITE; /*!40000 ALTER TABLE `VGB_EMAIL` DISABLE KEYS */; INSERT INTO `VGB_EMAIL` VALUES (1,0,NULL,NULL,0,0,'','','2007-03-13 16:25:36','',''),(2,0,NULL,NULL,0,0,'','','2007-03-13 16:25:36','',''),(3,0,NULL,NULL,0,0,'','','2007-03-13 16:25:36','',''),(4,0,NULL,NULL,0,0,'','','2007-03-13 16:25:36','',''),(5,0,NULL,NULL,0,0,'','','2007-03-13 16:25:36','',''),(6,0,NULL,NULL,0,0,'','','2007-03-13 16:25:36','',''),(7,0,NULL,NULL,0,0,'','','2007-03-13 16:25:36','',''),(8,0,NULL,NULL,0,0,'','','2007-03-13 16:25:36','',''),(9,0,NULL,NULL,0,0,'','','2007-03-13 16:25:36','',''),(10,0,NULL,NULL,0,0,'','','2007-03-13 16:25:36','',''),(11,0,NULL,NULL,0,0,'','','2007-03-13 16:25:36','',''),(12,0,NULL,NULL,0,0,'','','2007-03-13 16:25:36','',''),(20,0,NULL,NULL,0,0,'','','2007-03-13 16:25:36','',''); /*!40000 ALTER TABLE `VGB_EMAIL` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_EMOTICON` -- DROP TABLE IF EXISTS `VGB_EMOTICON`; CREATE TABLE `VGB_EMOTICON` ( `ID` int(11) NOT NULL auto_increment, `CODE` varchar(32) NOT NULL default '', `FILENAME` varchar(127) NOT NULL default '', `PRIORITY` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_EMOTICON` -- LOCK TABLES `VGB_EMOTICON` WRITE; /*!40000 ALTER TABLE `VGB_EMOTICON` DISABLE KEYS */; INSERT INTO `VGB_EMOTICON` VALUES (1,':-)','smile.gif',20),(2,':-D','laugh.gif',25),(3,';-)','wink.gif',30),(4,':-(','sad.gif',35),(5,':-/','angry.gif',40),(6,':-*','sick.gif',45),(7,'8-)','cool.gif',50),(8,':-0','ohmy.gif',55),(9,'8-0','love.gif',60),(10,':-|','unsure.gif',65),(11,':-!','important.gif',70),(12,':-?','question.gif',75),(13,'#-)','crazy.gif',80),(14,':-U','special1.gif',85),(15,':-B','special2.gif',90),(16,':-}','tongue.gif',95); /*!40000 ALTER TABLE `VGB_EMOTICON` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_ENTRY` -- DROP TABLE IF EXISTS `VGB_ENTRY`; CREATE TABLE `VGB_ENTRY` ( `ID` int(11) NOT NULL auto_increment, `DATE` date NOT NULL default '0000-00-00', `NAME` varchar(40) default NULL, `ENTRY` text NOT NULL, `COMMENT` text, `COUNTRY` int(11) default NULL, `EMAIL` varchar(40) default NULL, `HOMEPAGE` varchar(40) default NULL, `ICQ` int(10) unsigned default NULL, `AIM` varchar(40) default NULL, `MSN` varchar(40) default NULL, `YAHOO` varchar(40) default NULL, `IP` varchar(16) NOT NULL default '', `BROWSER` varchar(255) NOT NULL default '', `HOSTNAME` varchar(128) NOT NULL default '', `SIGNTIME` time default NULL, `PICTURE` varchar(32) default NULL, `PICTEXT` varchar(127) default NULL, `PRIVATE` varchar(20) default NULL, `HIDEEMAIL` tinyint(1) NOT NULL default '0', `UNMODERATED` tinyint(1) NOT NULL default '0', `SKYPE` varchar(40) default NULL, `JABBER` varchar(40) default NULL, `GADUGADU` int(10) unsigned default NULL, `GENDER` tinyint(3) unsigned NOT NULL default '0', `CLOSED` tinyint(1) NOT NULL default '0', `STICKY` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_ENTRY` -- LOCK TABLES `VGB_ENTRY` WRITE; /*!40000 ALTER TABLE `VGB_ENTRY` DISABLE KEYS */; INSERT INTO `VGB_ENTRY` VALUES (1,'2006-07-18','Jody Forrester','Test :-)',NULL,172,'jodyforrester@gmail.com',NULL,NULL,NULL,NULL,NULL,'198.54.202.234','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)','rba-cache1-vif0.saix.net','08:32:50',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,0); /*!40000 ALTER TABLE `VGB_ENTRY` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_LANGUAGE` -- DROP TABLE IF EXISTS `VGB_LANGUAGE`; CREATE TABLE `VGB_LANGUAGE` ( `ID` int(11) NOT NULL auto_increment, `NAME` varchar(255) NOT NULL default '', `LANGDIR` varchar(127) NOT NULL default '', `SKINDIR` varchar(127) NOT NULL default '', `PRIORITY` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_LANGUAGE` -- LOCK TABLES `VGB_LANGUAGE` WRITE; /*!40000 ALTER TABLE `VGB_LANGUAGE` DISABLE KEYS */; /*!40000 ALTER TABLE `VGB_LANGUAGE` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_LOGIN` -- DROP TABLE IF EXISTS `VGB_LOGIN`; CREATE TABLE `VGB_LOGIN` ( `IP` varchar(16) NOT NULL default '', `TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00', `ENTRYID` int(11) NOT NULL default '0', `TRY` tinyint(4) default NULL, `SESSIONID` varchar(20) default NULL, PRIMARY KEY (`IP`,`TSTAMP`,`ENTRYID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_LOGIN` -- LOCK TABLES `VGB_LOGIN` WRITE; /*!40000 ALTER TABLE `VGB_LOGIN` DISABLE KEYS */; /*!40000 ALTER TABLE `VGB_LOGIN` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_MAILSPAM` -- DROP TABLE IF EXISTS `VGB_MAILSPAM`; CREATE TABLE `VGB_MAILSPAM` ( `IP` varchar(16) NOT NULL default '', `TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00', `EMAIL` varchar(127) NOT NULL default '', PRIMARY KEY (`IP`,`TSTAMP`,`EMAIL`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_MAILSPAM` -- LOCK TABLES `VGB_MAILSPAM` WRITE; /*!40000 ALTER TABLE `VGB_MAILSPAM` DISABLE KEYS */; /*!40000 ALTER TABLE `VGB_MAILSPAM` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_RATING` -- DROP TABLE IF EXISTS `VGB_RATING`; CREATE TABLE `VGB_RATING` ( `ENTRY_ID` int(11) NOT NULL default '0', `BOX_ID` tinyint(3) unsigned NOT NULL default '0', `RATING` tinyint(4) NOT NULL default '0', PRIMARY KEY (`ENTRY_ID`,`BOX_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_RATING` -- LOCK TABLES `VGB_RATING` WRITE; /*!40000 ALTER TABLE `VGB_RATING` DISABLE KEYS */; /*!40000 ALTER TABLE `VGB_RATING` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_RATINGBOX` -- DROP TABLE IF EXISTS `VGB_RATINGBOX`; CREATE TABLE `VGB_RATINGBOX` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `NAME` varchar(255) NOT NULL default '', `PRIORITY` tinyint(3) unsigned NOT NULL default '0', `FRCE` tinyint(1) NOT NULL default '0', `STATS` tinyint(1) NOT NULL default '0', `FORMTEXT` varchar(255) NOT NULL default '', `MAXVALUE` int(11) NOT NULL default '5', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_RATINGBOX` -- LOCK TABLES `VGB_RATINGBOX` WRITE; /*!40000 ALTER TABLE `VGB_RATINGBOX` DISABLE KEYS */; /*!40000 ALTER TABLE `VGB_RATINGBOX` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_SESSION` -- DROP TABLE IF EXISTS `VGB_SESSION`; CREATE TABLE `VGB_SESSION` ( `IP` varchar(16) NOT NULL default '', `TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00', `SESSIONID` varchar(20) NOT NULL default '', `TRY` tinyint(4) default NULL, `ADMIN` int(11) default NULL, `VERSIONS` varchar(127) NOT NULL default '', PRIMARY KEY (`IP`,`TSTAMP`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_SESSION` -- LOCK TABLES `VGB_SESSION` WRITE; /*!40000 ALTER TABLE `VGB_SESSION` DISABLE KEYS */; INSERT INTO `VGB_SESSION` VALUES ('196.11.241','2007-03-13 16:26:07','0a2e707ffa03e3c59ee1',1,NULL,''); /*!40000 ALTER TABLE `VGB_SESSION` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_SETTINGS` -- DROP TABLE IF EXISTS `VGB_SETTINGS`; CREATE TABLE `VGB_SETTINGS` ( `VERSION` varchar(127) NOT NULL default '', `ONLINEDATE` date NOT NULL default '0000-00-00', `ADMINPASSWORD` varchar(127) NOT NULL default '', `ADMINEMAIL` varchar(127) default NULL, `ACTIVESKIN` varchar(255) NOT NULL default '', `SENDNOTICE` tinyint(1) NOT NULL default '0', `USEFRAMES` tinyint(1) NOT NULL default '0', `USEUSDATE` tinyint(1) NOT NULL default '0', `USEEMOTICONS` tinyint(1) NOT NULL default '0', `PASTENTRIES` int(11) NOT NULL default '0', `MAXSPAMTIME` int(11) NOT NULL default '0', `MAXENTRIES` int(11) NOT NULL default '0', `MAXENTRIESPERPAGE` int(11) NOT NULL default '0', `MAXLENENTRY` int(11) NOT NULL default '0', `MAXLENNAME` tinyint(3) unsigned NOT NULL default '0', `MAXLENEMAIL` tinyint(3) unsigned NOT NULL default '0', `MAXLENHOMEPAGE` tinyint(3) unsigned NOT NULL default '0', `MAXLENAIM` tinyint(3) unsigned NOT NULL default '0', `MAXLENMSN` tinyint(3) unsigned NOT NULL default '0', `MAXLENYAHOO` tinyint(3) unsigned NOT NULL default '0', `FORCEBREAK` tinyint(3) unsigned NOT NULL default '0', `ACTIVATELINKS` tinyint(1) NOT NULL default '0', `ASKEMAIL` tinyint(1) NOT NULL default '0', `ASKHOMEPAGE` tinyint(1) NOT NULL default '0', `ASKICQ` tinyint(1) NOT NULL default '0', `ASKAIM` tinyint(1) NOT NULL default '0', `ASKMSN` tinyint(1) NOT NULL default '0', `ASKYAHOO` tinyint(1) NOT NULL default '0', `ASKCOUNTRY` tinyint(1) NOT NULL default '0', `FORCECOUNTRY` tinyint(1) NOT NULL default '0', `HIDEIP` tinyint(3) unsigned NOT NULL default '0', `HIDEHOST` tinyint(3) unsigned NOT NULL default '0', `HIDESTATS` tinyint(1) NOT NULL default '0', `LIMITBROWSER` int(11) NOT NULL default '0', `LIMITOS` int(11) NOT NULL default '0', `LIMITCOUNTRY` int(11) NOT NULL default '0', `USEFILTER` int(11) NOT NULL default '0', `BADWORDSTRING` varchar(127) NOT NULL default '', `ASKPICTURE` tinyint(1) NOT NULL default '0', `MINX` int(11) NOT NULL default '0', `MAXX` int(11) NOT NULL default '0', `MINY` int(11) NOT NULL default '0', `MAXY` int(11) NOT NULL default '0', `VISITORS` int(11) NOT NULL default '0', `VISITORSSINCE` date NOT NULL default '0000-00-00', `INDEXURL` varchar(127) default NULL, `FORCEEMAIL` tinyint(1) NOT NULL default '0', `USEBBCODE` tinyint(1) NOT NULL default '0', `STRIPCODE` tinyint(1) NOT NULL default '0', `SIZEMIN` tinyint(3) unsigned NOT NULL default '0', `SIZEMAX` tinyint(3) unsigned NOT NULL default '0', `USERCOLORS` text NOT NULL, `USERFONTS` text NOT NULL, `ASKPICTEXT` tinyint(1) NOT NULL default '0', `FILTERNAME` tinyint(1) NOT NULL default '0', `FILTEREMAIL` tinyint(1) NOT NULL default '0', `FILTERHOMEPAGE` tinyint(1) NOT NULL default '0', `FILTERAIM` tinyint(1) NOT NULL default '0', `FILTERMSN` tinyint(1) NOT NULL default '0', `FILTERYAHOO` tinyint(1) NOT NULL default '0', `FILTERPICTEXT` tinyint(1) NOT NULL default '0', `ASKPRIVATE` tinyint(1) NOT NULL default '0', `PRIVPARAMETER` varchar(30) default NULL, `ASKHIDEEMAIL` tinyint(1) NOT NULL default '0', `USEMAILER` tinyint(3) unsigned NOT NULL default '0', `USEADMINEMO` tinyint(1) NOT NULL default '0', `USEIFRAME` tinyint(1) NOT NULL default '0', `PRECOUNTRY` int(11) default NULL, `ALLOWCOMMENTS` tinyint(1) NOT NULL default '0', `ADDHOURS` int(11) NOT NULL default '0', `ADDMINUTES` int(11) NOT NULL default '0', `ADDSECONDS` int(11) NOT NULL default '0', `COMMENTNAME` varchar(40) NOT NULL default '', `COMMENTEMAIL` varchar(40) NOT NULL default '', `MODERATEDMODE` tinyint(1) NOT NULL default '0', `DEACTIVATED` tinyint(1) NOT NULL default '0', `BACKURL` varchar(127) default NULL, `ALLOWSEARCH` tinyint(1) NOT NULL default '0', `USEQUOTE` tinyint(1) NOT NULL default '0', `BANLIST` text NOT NULL, `BANROBOTS` tinyint(1) NOT NULL default '0', `MAXEMPTYLINES` int(11) NOT NULL default '0', `EMAILTOOLTIP` varchar(127) NOT NULL default '', `EMAILFROM` varchar(127) NOT NULL default '', `FIRSTENTRY` tinyint(1) NOT NULL default '0', `FIRSTCOMMENT` tinyint(1) NOT NULL default '0', `ENTRYSENT` tinyint(1) NOT NULL default '0', `COMMENTSENT` tinyint(1) NOT NULL default '0', `PASSPREFIX` varchar(20) NOT NULL default '', `THUMBNAILX` int(11) NOT NULL default '0', `THUMBNAILY` int(11) NOT NULL default '0', `ENCODING` varchar(30) NOT NULL default '', `HOSTRESOLVING` tinyint(1) NOT NULL default '0', `AMPMTIME` tinyint(1) NOT NULL default '0', `REDIRECTSHOW` tinyint(1) NOT NULL default '0', `EMAILMETHOD` tinyint(1) NOT NULL default '0', `RETURNPATH` varchar(127) NOT NULL default '', `MAILCHARSET` varchar(30) NOT NULL default '', `CMDLINEPARAM` varchar(60) NOT NULL default '', `CRLFHEADER` tinyint(1) NOT NULL default '0', `SMTPHOST` varchar(127) NOT NULL default '', `SMTPPORT` int(10) unsigned NOT NULL default '0', `SMTPUSERNAME` varchar(60) NOT NULL default '', `SMTPPASSWORD` varchar(60) NOT NULL default '', `INSERTSKINNAME` tinyint(1) NOT NULL default '0', `ASKSKYPE` tinyint(1) NOT NULL default '0', `ASKJABBER` tinyint(1) NOT NULL default '0', `ASKGADUGADU` tinyint(1) NOT NULL default '0', `MAXLENSKYPE` tinyint(3) unsigned NOT NULL default '0', `MAXLENJABBER` tinyint(3) unsigned NOT NULL default '0', `FILTERSKYPE` tinyint(1) NOT NULL default '0', `FILTERJABBER` tinyint(1) NOT NULL default '0', `ASKGENDER` tinyint(1) NOT NULL default '0', `FORCEGENDER` tinyint(1) NOT NULL default '0', `MAXFILESIZE` int(10) unsigned NOT NULL default '0', `DEFAULTNAME` varchar(255) NOT NULL default '', `ADMINLINK` tinyint(1) NOT NULL default '0', `USECOOKIES` tinyint(1) NOT NULL default '0', `USETICKETS` tinyint(1) NOT NULL default '0', `BBCODEMASK` int(10) unsigned NOT NULL default '0', `QUOTESTYLE` varchar(127) NOT NULL default '', `CODESTYLE` varchar(127) NOT NULL default '', `USETOOLBAR` tinyint(4) NOT NULL default '0', `SAVEACTIONS` int(11) NOT NULL default '0', `MAILLIMIT` int(11) NOT NULL default '0', `CHECKMAILS` tinyint(1) NOT NULL default '0', `VERSIONCHECK` tinyint(1) NOT NULL default '0', `FIRSTEMAIL` tinyint(1) NOT NULL default '0', `EMAILSENT` tinyint(1) NOT NULL default '0', `USECACHE` tinyint(1) NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_SETTINGS` -- LOCK TABLES `VGB_SETTINGS` WRITE; /*!40000 ALTER TABLE `VGB_SETTINGS` DISABLE KEYS */; INSERT INTO `VGB_SETTINGS` VALUES ('X1.1','2006-07-18','EMJpAGyATIOko','jodyforrester@gmail.com','Standard_English',0,0,0,1,0,5,0,10,10000,40,40,40,40,40,40,28,1,1,1,0,0,0,0,1,1,0,0,0,0,0,0,0,'-BADWORD-',0,10,200,10,200,6,'2005-10-01',NULL,0,0,0,1,3,'black=#000000\ngray=#808080\nred=#FF0000\nlime=#00FF00\nyellow=#FFFF00\nblue=#0000FF\nfuchsia=#FF00FF\naqua=#00FFFF\nwhite=#FFFFFF\nmaroon=#800000\ngreen=#008000\nolive=#808000\nnavy=#000080\npurple=#800080\nteal=#008080\nsilver=#C0C0C0','',0,0,0,0,0,0,0,0,0,NULL,0,1,0,0,NULL,0,0,0,0,'','',0,0,NULL,0,0,'',0,3,'::user::(a+)::domain::','',0,0,1,0,'pass=',100,0,'',0,0,0,0,'webmaster@jodyforrester.com','iso-8859-1','-fwebmaster@jodyforrester.com',0,'localhost',25,'','',0,0,0,0,40,40,0,0,0,0,0,'Default',0,0,0,0,'border: 1px dotted #808080; padding: 3px','border: 1px inset; margin: 0px; padding: 3px; height: 100px; overflow: auto',0,10,0,0,0,0,0,0); /*!40000 ALTER TABLE `VGB_SETTINGS` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_SPAM` -- DROP TABLE IF EXISTS `VGB_SPAM`; CREATE TABLE `VGB_SPAM` ( `IP` varchar(16) NOT NULL default '', `TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00', `TRIES` tinyint(4) default NULL, PRIMARY KEY (`IP`,`TSTAMP`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_SPAM` -- LOCK TABLES `VGB_SPAM` WRITE; /*!40000 ALTER TABLE `VGB_SPAM` DISABLE KEYS */; /*!40000 ALTER TABLE `VGB_SPAM` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_TICKET` -- DROP TABLE IF EXISTS `VGB_TICKET`; CREATE TABLE `VGB_TICKET` ( `ID` int(11) NOT NULL auto_increment, `IP` varchar(16) NOT NULL default '', `TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00', `TICKET` varchar(5) NOT NULL default '', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_TICKET` -- LOCK TABLES `VGB_TICKET` WRITE; /*!40000 ALTER TABLE `VGB_TICKET` DISABLE KEYS */; /*!40000 ALTER TABLE `VGB_TICKET` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_USER` -- DROP TABLE IF EXISTS `VGB_USER`; CREATE TABLE `VGB_USER` ( `ID` int(11) NOT NULL auto_increment, `NAME` varchar(40) NOT NULL default '', `RESERVED` tinyint(1) NOT NULL default '0', `PASSWORD` varchar(30) NOT NULL default '', `SIGNATURE` text NOT NULL, `EMAIL` varchar(40) NOT NULL default '', `HIDEEMAIL` tinyint(1) NOT NULL default '0', `HOMEPAGE` varchar(40) NOT NULL default '', `ICQ` int(10) unsigned NOT NULL default '0', `AIM` varchar(40) NOT NULL default '', `MSN` varchar(40) NOT NULL default '', `YAHOO` varchar(40) NOT NULL default '', `COUNTRY` int(11) NOT NULL default '0', `PICTEXT` varchar(127) NOT NULL default '', `PICTURE` varchar(32) NOT NULL default '', `SKYPE` varchar(40) NOT NULL default '', `JABBER` varchar(40) NOT NULL default '', `GADUGADU` int(10) unsigned NOT NULL default '0', `GENDER` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_USER` -- LOCK TABLES `VGB_USER` WRITE; /*!40000 ALTER TABLE `VGB_USER` DISABLE KEYS */; /*!40000 ALTER TABLE `VGB_USER` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VGB_VISITOR` -- DROP TABLE IF EXISTS `VGB_VISITOR`; CREATE TABLE `VGB_VISITOR` ( `ID` int(11) NOT NULL auto_increment, `IP` varchar(16) NOT NULL default '', `TSTAMP` datetime NOT NULL default '0000-00-00 00:00:00', `HOSTNAME` varchar(128) NOT NULL default '', `BROWSER` varchar(255) NOT NULL default '', `ACTIVE` tinyint(1) NOT NULL default '0', `ACTIONS` int(11) NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `VGB_VISITOR` -- LOCK TABLES `VGB_VISITOR` WRITE; /*!40000 ALTER TABLE `VGB_VISITOR` DISABLE KEYS */; INSERT INTO `VGB_VISITOR` VALUES (1,'196.11.241.41','2007-03-13 16:26:14','','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322)',1,1); /*!40000 ALTER TABLE `VGB_VISITOR` ENABLE KEYS */; UNLOCK TABLES; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;