softbizb2bmarketplacescript.sql

通达OA部分源代码

# phpMyAdmin MySQL-Dump
# version 2.3.2
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Aug 27, 2004 at 05:53 PM
# Server version: 4.00.04
# PHP Version: 4.2.3
# Database : `sbtradeleads`
# --------------------------------------------------------

#
# Table structure for table `sbbleads_admin`
#

DROP TABLE IF EXISTS `sbbleads_admin`;
CREATE TABLE `sbbleads_admin` (
  `sb_id` bigint(20) NOT NULL auto_increment,
  `sb_admin_name` varchar(255) default NULL,
  `sb_pwd` varchar(255) default NULL,
  PRIMARY KEY  (`sb_id`)
) TYPE=MyISAM;

#
# Dumping data for table `sbbleads_admin`
#

INSERT INTO `sbbleads_admin` (`sb_id`, `sb_admin_name`, `sb_pwd`) VALUES (1, 'admin', 'admin');
# --------------------------------------------------------

#
# Table structure for table `sbbleads_ads`
#

DROP TABLE IF EXISTS `sbbleads_ads`;
CREATE TABLE `sbbleads_ads` (
  `sbtitle` varchar(255) default NULL,
  `id` bigint(20) NOT NULL auto_increment,
  `url` varchar(255) NOT NULL default '',
  `bannerurl` varchar(255) NOT NULL default '',
  `credits` bigint(20) NOT NULL default '0',
  `displays` bigint(20) NOT NULL default '0',
  `approved` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `sbbleads_ads`
#

INSERT INTO `sbbleads_ads` (`sbtitle`, `id`, `url`, `bannerurl`, `credits`, `displays`, `approved`) VALUES ('vin.com', 21, 'http://vin.com', 'http://localhost/sbclassified_harvey/changes/Sulekha_com_files/600_60_a1wireless.jpg', 1000, 667, 'no'),
('micx', 22, 'http://micx.com', 'http://localhost/sbclassified_harvey/changes/Sulekha_com_files/120_120_invis_4.gif', 1000, 665, 'no');
# --------------------------------------------------------

#
# Table structure for table `sbbleads_affiliate_banner`
#

DROP TABLE IF EXISTS `sbbleads_affiliate_banner`;
CREATE TABLE `sbbleads_affiliate_banner` (
  `sbaff_id` bigint(20) NOT NULL auto_increment,
  `sbaff_title` varchar(255) default NULL,
  `sbaff_text` longtext,
  `sbaff_active` varchar(255) NOT NULL default 'no',
  PRIMARY KEY  (`sbaff_id`)
) TYPE=MyISAM;

#
# Dumping data for table `sbbleads_affiliate_banner`
#

INSERT INTO `sbbleads_affiliate_banner` (`sbaff_id`, `sbaff_title`, `sbaff_text`, `sbaff_active`) VALUES (6, 'Default', '<a href="linktous.php"><img src=http://localhost/sbtradeleads/images/default_banner.gif border=0 alt="Advertise Here"></a>', 'no');
# --------------------------------------------------------

#
# Table structure for table `sbbleads_banned_words`
#

DROP TABLE IF EXISTS `sbbleads_banned_words`;
CREATE TABLE `sbbleads_banned_words` (
  `sb_id` bigint(20) NOT NULL auto_increment,
  `sb_word` varchar(255) default NULL,
  `sb_type` varchar(255) default NULL,
  PRIMARY KEY  (`sb_id`)
) TYPE=MyISAM;

#
# Dumping data for table `sbbleads_banned_words`
#

INSERT INTO `sbbleads_banned_words` (`sb_id`, `sb_word`, `sb_type`) VALUES (3, 'xxxxx', '2'),
(13, 'harry', '1'),
(16, 'Fuck', '2');
# --------------------------------------------------------

#
# Table structure for table `sbbleads_blocked`
#

DROP TABLE IF EXISTS `sbbleads_blocked`;
CREATE TABLE `sbbleads_blocked` (
  `sb_id` bigint(20) NOT NULL auto_increment,
  `sb_uid` bigint(20) default NULL,
  `sb_blocked_id` bigint(20) default NULL,
  `sb_desc` varchar(255) default NULL,
  PRIMARY KEY  (`sb_id`)
) TYPE=MyISAM;

#
# Dumping data for table `sbbleads_blocked`
#

INSERT INTO `sbbleads_blocked` (`sb_id`, `sb_uid`, `sb_blocked_id`, `sb_desc`) VALUES (33, 1, 2, NULL),
(32, 1, 8, NULL),
(36, 1, 3, ''),
(37, 8, 1, NULL);
# --------------------------------------------------------

#
# Table structure for table `sbbleads_blocked_countries`
#

DROP TABLE IF EXISTS `sbbleads_blocked_countries`;
CREATE TABLE `sbbleads_blocked_countries` (
  `sb_id` bigint(20) NOT NULL auto_increment,
  `sb_uid` bigint(20) default NULL,
  `sb_blocked_id` bigint(20) default NULL,
  `sb_desc` varchar(255) default NULL,
  PRIMARY KEY  (`sb_id`)
) TYPE=MyISAM;

#
# Dumping data for table `sbbleads_blocked_countries`
#

INSERT INTO `sbbleads_blocked_countries` (`sb_id`, `sb_uid`, `sb_blocked_id`, `sb_desc`) VALUES (8, 1, 28, ''),
(10, 8, 22, ''),
(11, 1, 3, ''),
(12, 1, 23, ''),
(13, 1, 24, '');
# --------------------------------------------------------

#
# Table structure for table `sbbleads_businesstypes`
#

DROP TABLE IF EXISTS `sbbleads_businesstypes`;
CREATE TABLE `sbbleads_businesstypes` (
  `sb_id` bigint(20) NOT NULL auto_increment,
  `sb_businesstype` varchar(255) default '',
  PRIMARY KEY  (`sb_id`)
) TYPE=MyISAM;

#
# Dumping data for table `sbbleads_businesstypes`
#

INSERT INTO `sbbleads_businesstypes` (`sb_id`, `sb_businesstype`) VALUES (1, 'Trading'),