📄 softbizb2bmarketplacescript_empty.sql

📁 通达OA部分源代码
💻 SQL
字号:
# phpMyAdmin MySQL-Dump
# version 2.3.2
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Oct 08, 2004 at 03:43 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`
#

# --------------------------------------------------------

#
# 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`
#

# --------------------------------------------------------

#
# 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`
#

# --------------------------------------------------------

#
# 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`
#

# --------------------------------------------------------

#
# 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`
#

# --------------------------------------------------------

#
# 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 (5, 'Out Sourcing');
INSERT INTO `sbbleads_businesstypes` (`sb_id`, `sb_businesstype`) VALUES (6, 'Call Center');
# --------------------------------------------------------

#
# Table structure for table `sbbleads_categories`
#

DROP TABLE IF EXISTS `sbbleads_categories`;
CREATE TABLE `sbbleads_categories` (
  `sb_id` bigint(20) NOT NULL auto_increment,
  `sb_cat_name` varchar(255) default NULL,
  `sb_pid` bigint(20) default NULL,
  `sb_order_index` bigint(20) NOT NULL default '0',
  `sb_visit_sell` bigint(20) default '0',
  `sb_visit_buy` bigint(20) default '0',
  `sb_visit_product` bigint(20) default '0',
  `sb_visit_profile` bigint(20) default '0',
  PRIMARY KEY  (`sb_id`)
) TYPE=MyISAM;

#
# Dumping data for table `sbbleads_categories`
#

INSERT INTO `sbbleads_categories` (`sb_id`, `sb_cat_name`, `sb_pid`, `sb_order_index`, `sb_visit_sell`, `sb_visit_buy`, `sb_visit_product`, `sb_visit_profile`) VALUES (24, 'Computer', 0, 24, 14, 9, 9, 4);
# --------------------------------------------------------

#
# Table structure for table `sbbleads_companyprofiles`
#

DROP TABLE IF EXISTS `sbbleads_companyprofiles`;
CREATE TABLE `sbbleads_companyprofiles` (
  `sb_id` bigint(20) NOT NULL auto_increment,
  `sb_companyname` varchar(255) default '',
  `sb_logo` varchar(255) default '',
  `sb_businesstype` bigint(20) default NULL,
  `sb_services` longtext,
  `sb_yearestablished` bigint(20) default '0',
  `sb_markets` varchar(255) default '',
  `sb_othermarkets` varchar(255) default NULL,
  `sb_productfocus` bigint(20) default NULL,
  `sb_uid` bigint(20) default '0',
  `sb_employees` bigint(20) default NULL,
  `sb_companyprofile` longtext,
  `sb_ceo` varchar(255) default '',
  `sb_website` varchar(255) default '',
  `sb_type` bigint(20) default '0',
  `sb_phone` varchar(255) default NULL,
  `sb_fax` varchar(255) default NULL,
  `sb_approved` varchar(255) default 'no',
  `sb_featured` varchar(255) default NULL,
  `sb_viewed` bigint(20) NOT NULL default '0',
  `tempdate` timestamp(14) NOT NULL,
  `sb_postedon` timestamp(14) NOT NULL,
  PRIMARY KEY  (`sb_id`)
) TYPE=MyISAM;

#
# Dumping data for table `sbbleads_companyprofiles`
#

# --------------------------------------------------------

#
# Table structure for table `sbbleads_config`
#

DROP TABLE IF EXISTS `sbbleads_config`;
CREATE TABLE `sbbleads_config` (
  `sb_id` bigint(20) NOT NULL auto_increment,
  `sb_admin_email` varchar(255) default NULL,
  `sb_site_name` varchar(255) default NULL,
  `sb_site_root` varchar(255) default NULL,
  `sb_html_header1` longtext,
  `sb_html_footer1` longtext,
  `sb_style_list` bigint(20) default NULL,
  `sb_recperpage` int(11) default '10',
  `sb_icon_list` bigint(20) default NULL,
  `sb_recent_count` int(11) NOT NULL default '0',
  `sb_feature_count` int(11) NOT NULL default '0',
  `sb_th_width` bigint(20) default '50',
  `sb_th_width2` bigint(20) default '70',
  `sb_image_magik` varchar(255) default 'enable',
  `sb_water_marking` varchar(255) default 'enalble',
  `sb_approval_type_offer` varchar(255) default 'admin',
  `sb_profile_approval` varchar(255) default 'admin',
  `sb_date_format` bigint(20) default '2',
  `sb_time_format` bigint(20) default '2',
  `sb_memtype` bigint(20) default '0',
  `sb_mem_approval` varchar(255) default 'auto',
  `sb_expiry_sell` bigint(20) default '1',
  `sb_expiry_buy` bigint(20) default '1',
  `sb_description_length` bigint(20) default '500',
  `sb_image_size` bigint(20) default NULL,
  `sb_null_char` varchar(255) default '- -',
  `sb_latest_news_cnt` bigint(20) default NULL,
  `sb_cat_featured` int(11) default NULL,
  `sb_how_to_sell` longtext,
  `sb_how_to_buy` longtext,
  `sb_legal` longtext,
  `sb_terms` longtext,
  `sb_privacy` longtext,
  `sb_signup_verification` varchar(255) default 'yes',
  `sb_logo` varchar(255) default NULL,
  `sbfee_bs` decimal(10,2) default NULL,
  `sbfee_bg` decimal(10,2) default NULL,
  `sbfee_sg` decimal(10,2) default NULL,
  `sb_site_keywords` varchar(255) default NULL,
  `sb_cat_listing` varchar(255) default 'alpha',
  PRIMARY KEY  (`sb_id`)
) TYPE=MyISAM;

#
# Dumping data for table `sbbleads_config`
#

INSERT INTO `sbbleads_config` (`sb_id`, `sb_admin_email`, `sb_site_name`, `sb_site_root`, `sb_html_header1`, `sb_html_footer1`, `sb_style_list`, `sb_recperpage`, `sb_icon_list`, `sb_recent_count`, `sb_feature_count`, `sb_th_width`, `sb_th_width2`, `sb_image_magik`, `sb_water_marking`, `sb_approval_type_offer`, `sb_profile_approval`, `sb_date_format`, `sb_time_format`, `sb_memtype`, `sb_mem_approval`, `sb_expiry_sell`, `sb_expiry_buy`, `sb_description_length`, `sb_image_size`, `sb_null_char`, `sb_latest_news_cnt`, `sb_cat_featured`, `sb_how_to_sell`, `sb_how_to_buy`, `sb_legal`, `sb_terms`, `sb_privacy`, `sb_signup_verification`, `sb_logo`, `sbfee_bs`, `sbfee_bg`, `sbfee_sg`, `sb_site_keywords`, `sb_cat_listing`) VALUES (1, 'admin@sbtradelead.com', 'Softbiz B2B trading Marketplace Script', 'http://www.domain.com/b2b', '<P><STRONG>Softbiz Business Leads Script<br> Top bar here </STRONG></P>', '<div align="center">\r\n  <font size="2" face="Verdana, Arial, Helvetica, sans-serif"><font size="1">
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -