--------------------------
Wap TOP20List by cuteface
Enjoy! it forever!
--------------------------
-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 06, 2008 at 04:10 AM
-- Server version: 5.0.45
-- PHP Version: 5.1.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `top20`
--
-- --------------------------------------------------------
--
-- Table structure for table `cats`
--
CREATE TABLE `cats` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`dscr` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
--
-- Dumping data for table `cats`
--
INSERT INTO `cats` VALUES(15, 'Pinoy Sites', 'Pilipino Top Sites');
INSERT INTO `cats` VALUES(16, 'Games Sites', 'Games RPG');
INSERT INTO `cats` VALUES(17, 'Entertainment', 'Entertainment Only');
INSERT INTO `cats` VALUES(18, 'Portal Search', 'Portal Search');
INSERT INTO `cats` VALUES(19, 'Messaging - Chat', 'Messaging - Chat');
INSERT INTO `cats` VALUES(20, 'Ringtones - Logos', 'Ringtones - Logos');
-- --------------------------------------------------------
--
-- Table structure for table `misc`
--
CREATE TABLE `misc` (
`id` int(10) NOT NULL auto_increment,
`dscr` varchar(200) NOT NULL default '',
`text` varchar(250) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `misc`
--
-- --------------------------------------------------------
--
-- Table structure for table `sitein`
--
CREATE TABLE `sitein` (
`id` int(100) NOT NULL auto_increment,
`sid` varchar(100) NOT NULL,
`browser` varchar(100) NOT NULL,
`ip` varchar(100) NOT NULL,
`time` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=75 ;
--
-- Dumping data for table `sitein`
--
-- --------------------------------------------------------
--
-- Table structure for table `siteout`
--
CREATE TABLE `siteout` (
`id` int(100) NOT NULL auto_increment,
`sid` varchar(100) NOT NULL,
`ip` varchar(100) NOT NULL,
`browser` varchar(100) NOT NULL,
`time` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;
--
-- Dumping data for table `siteout`
--
-- --------------------------------------------------------
--
-- Table structure for table `sites`
--
CREATE TABLE `sites` (
`id` int(10) NOT NULL auto_increment,
`sitename` varchar(30) NOT NULL default '',
`cid` int(10) NOT NULL default '0',
`sitelink` varchar(200) NOT NULL default '',
`slogo` varchar(200) NOT NULL default '',
`uid` int(10) NOT NULL default '0',
`hin` int(10) NOT NULL default '0',
`hout` int(10) NOT NULL default '0',
`dhits` int(10) NOT NULL default '0',
`thits` int(12) NOT NULL default '0',
`banned` int(5) NOT NULL default '0',
`dscr` varchar(200) NOT NULL default '',
`keywords` varchar(100) NOT NULL,
`active` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sitelink` (`sitelink`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `sites`
--
INSERT INTO `sites` VALUES(1, 'pinoy2.com', 15, 'http://pinoy2.com', 'http://pinoy2.com/logo.gif', 9, 501, 602, 10, 0, 0, 'wap comunity for pinoys RPG', 'PINOY2, pinoy wap, pinoy online', '1212148659', 'aspen@acasa.ro');
INSERT INTO `sites` VALUES(4, 'TOP.PINOY2.COM', 15, 'http://top.pinoy2.com', 'http://top.pinoy2.com', 9, 5, 5, 0, 0, 0, 'TOPLIST', 'TOPLIST', '1212149194', 'aspen@acasa.ro');
INSERT INTO `sites` VALUES(6, 'xyve.wen.ru', 17, 'http://xyve.wen.ru', 'http://xyve.wen.ru', 9, 6, 3, 0, 0, 0, 'wap portal', 'pinoy site, wapple', '1212290725', 'aspen@acasa.ro');
INSERT INTO `sites` VALUES(7, 'http://wapple2.890m.com', 19, 'http://wapple2.890m.com', 'http://', 9, 15, 5, 0, 0, 0, 'wapple community', 'wapple', '1212291425', 'aspen@acasa.ro');
-- --------------------------------------------------------
--
-- Table structure for table `tusers`
--
CREATE TABLE `tusers` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`pass` varchar(60) NOT NULL default '',
`admin` int(5) NOT NULL default '0',
`banned` int(5) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `tusers`
--
INSERT INTO `tusers` VALUES(9, 'pinoy2waptop', 'd1af5dfeec69e0133969744c2cb8dfac', 1, 0);