softbizb2bmarketplacescript.sql

通达OA部分源代码

(2, 'Manufacturing'),
(3, 'Education'),
(5, 'Out Sourcing'),
(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 (1, 'Agriculture', 0, 1, 18, 5, 5, 2),
(2, 'Apparel & Fashion', 0, 2, 8, 1, 1, 0),
(3, 'Equipments', 1, 3, 3, 0, 0, 2),
(4, 'Seeds & Plants', 1, 4, 6, 0, 0, 0),
(5, 'Hardware', 24, 5, 13, 2, 1, 0),
(6, 'Software', 24, 6, 0, 0, 2, 1),
(7, 'Apparel & Fashion', 0, 7, 0, 0, 0, 0),
(8, 'Housing', 0, 8, 4, 4, 3, 1),
(13, 'Cute', 7, 13, 0, 0, 0, 0),
(14, 'Arts, Crafts and Gifts', 0, 14, 14, 6, 9, 6),
(15, 'Chemicals', 0, 15, 8, 5, 6, 3),
(16, 'Food & Bevrages', 0, 16, 12, 3, 4, 0),
(17, 'Textiles & Leather', 0, 17, 3, 1, 1, 2),
(22, 'Energy', 0, 22, 0, 0, 0, 0),
(23, 'Home Appliances', 0, 23, 2, 1, 3, 1),
(24, 'Computer', 0, 24, 13, 9, 9, 4),
(25, 'Minerals & Materials', 0, 25, 0, 0, 0, 0),
(26, 'Home Supplies', 0, 26, 0, 0, 0, 0),
(27, 'Telecommunications', 0, 27, 6, 2, 1, 1),
(28, 'Industrial Supplies', 0, 28, 0, 0, 0, 0),
(29, 'Office Supplies', 0, 29, 0, 0, 0, 0),
(30, 'Electronics & Electrical', 0, 30, 3, 0, 0, 0),
(31, 'Packaging & Paper', 0, 31, 0, 0, 0, 0),
(32, 'Gifts & Crafts', 0, 32, 0, 0, 0, 0),
(33, 'Security & Protection', 0, 33, 0, 0, 0, 0),
(34, 'Printing & Publishing', 0, 34, 1, 0, 0, 0),
(35, 'Toys', 0, 35, 0, 0, 0, 0),
(36, 'Construction', 0, 36, 4, 2, 2, 1),
(37, 'Environment', 0, 37, 1, 0, 0, 0),
(38, 'Sports & Leisure', 0, 38, 0, 0, 0, 0),
(39, 'Automobile', 0, 39, 1, 0, 0, 0),
(40, 'Excess Inventory', 0, 40, 1, 1, 0, 0),
(41, 'Health & Beauty', 0, 41, 0, 0, 0, 0),
(42, 'Transportation', 0, 42, 0, 0, 0, 0),
(43, 'Business Services', 0, 43, 2, 0, 0, 0);
# --------------------------------------------------------

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

INSERT INTO `sbbleads_companyprofiles` (`sb_id`, `sb_companyname`, `sb_logo`, `sb_businesstype`, `sb_services`, `sb_yearestablished`, `sb_markets`, `sb_othermarkets`, `sb_productfocus`, `sb_uid`, `sb_employees`, `sb_companyprofile`, `sb_ceo`, `sb_website`, `sb_type`, `sb_phone`, `sb_fax`, `sb_approved`, `sb_featured`, `sb_viewed`, `tempdate`, `sb_postedon`) VALUES (3, 'Ace Ventura Inc.', '51118507.gif', 2, '<FONT face="Verdana, Arial, Helvetica, sans-serif" color=#993399 size=4>We deal with all kinds of arts, handi crafts and of course hand made gift items like momentos, shields etc. Customer satisfection is our motto.We deal with all kinds of arts, handi crafts and of course hand made gift items like momentos, shields etc. Customer satisfection is our motto.<FONT face="Times New Roman" color=#000000 size=3>&nbsp;<FONT face=Verdana color=#993399 size=4>We deal with all kinds of arts, handi crafts and of course hand made gift items like momentos, shields etc. Customer satisfection is our motto.</FONT>&nbsp;</FONT></FONT>&nbsp; ', 2000, '8,4,7', '', 32, 1, 4, '<P><FONT face="Verdana, Arial, Helvetica, sans-serif" color=#00cccc>We are an MNC with a product range spanning from house hold to land &amp; mining equipment. Ace ventura was established 23 years ago with one purpose to serve the mankind.Our products are</FONT></P>\r\n<UL>\r\n<LI><FONT face=Verdana color=#33ccff>Furniture</FONT> \r\n<LI><FONT face=Verdana color=#33ccff>Lawn mowers</FONT> \r\n<LI><FONT face=Verdana color=#33ccff>Kitchen Articles</FONT> \r\n<LI><FONT face=Verdana color=#33ccff>Machine Tools.</FONT> \r\n<LI><FONT face=Verdana color=#33ccff>Spares of Engine etc.</FONT></LI></UL>', 'TN Rock', 'www.domain.com', 0, '--', '--', 'yes', NULL, 118, 20040713135554, 20040526153608),
(4, 'Janta Enterprise', '24115180.JPG', 1, '<H1><FONT face="Courier New, Courier, mono" color=#996633 size=4><U>Our services include the following:</U></FONT></H1><FONT face="Courier New, Courier, mono" color=#990000>  <OL>  <LI><FONT face="Courier New, Courier, mono" color=#990000><STRONG>Power generation &amp; production</STRONG></FONT>   <LI><FONT face="Courier New, Courier, mono" color=#990000><STRONG>Laying of railway tracks and maintenace</STRONG></FONT>   <LI><FONT face="Courier New, Courier, mono" color=#990000><STRONG>Road safety equipment</STRONG></FONT>   <LI><FONT face="Courier New, Courier, mono" color=#990000><STRONG>Consumer electronics</STRONG></FONT>   <LI><FONT face="Courier New, Courier, mono" color=#990000><STRONG>Air field equipment</STRONG></FONT>   <LI><FONT face="Courier New, Courier, mono" color=#990000><STRONG>Agricultural tools</STRONG></FONT></LI></OL></FONT>', 2001, '0,1', 'sdsds', 9, 2, 3, '<FONT face="Verdana, Arial, Helvetica, sans-serif" color=#993399><EM><STRONG><FONT face="Verdana, Arial, Helvetica, sans-serif" color=#993399><EM><STRONG>  <P><FONT face="Verdana, Arial, Helvetica, sans-serif" color=#993399><EM><STRONG>This companies has a very high profile status among the power generation field. Now we are veturing in the field of oil and natural gas extraction and purification industry.</P>  <P><FONT face="Verdana, Arial, Helvetica, sans-serif" color=#993399><EM><STRONG>This companies has a very high profile status among the power generation field. Now we are veturing in the field of oil and natural gas extraction and purification industry.</P>  <P><FONT face="Verdana, Arial, Helvetica, sans-serif" color=#993399><EM><STRONG>This companies has a very high profile status among the power generation field. Now we are veturing in the field of oil and natural gas extraction and purification industry.</STRONG></EM></FONT></P></STRONG></EM></FONT></STRONG></EM></FONT></STRONG></EM></FONT></STRONG></EM></FONT>', 'JT Rait', 'www.domain.com', 0, '--', '--', 'yes', 'no', 97, 20040708103419, 20040526153606),
(9, 'Ingen corporation', '68190621.JPG', 5, '<STRONG><FONT color=#ff0000>We deal with the genetic science &amp; engineering. Our main products are anti cancer drugs, for the cure and prevention from the disease. Our another proud product is to solve problems related to genetic disordersWe deal with the genetic science &amp; engineering. Our main products are anti cancer drugs, for the cure and prevention from the disease. Our another proud product is to solve problems related to genetic disordersWe deal with the genetic science &amp; engineering. Our main products are anti cancer drugs, for the cure and prevention from the disease. Our another proud product is to solve problems related to genetic disorders</FONT></STRONG>', 2003, '0,2', '', 9, 8, 2, '<P align=center><FONT face="Courier New, Courier, mono" color=#cc0000>We deal with the genetic science&nbsp;and engineering. Our main products are anti cancer drugs, for the cure and prevention from the disease. Our another proud product is to solve problems related to genetic disorders</FONT></P>  <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">  <P><U><FONT color=#00cccc size=4>We deal with the genetic science&nbsp;and engineering. Our main products are anti cancer drugs, for the cure and prevention from the disease. Our another proud product is to solve problems related to genetic disorders</FONT></U></P></BLOCKQUOTE>  <P><STRONG><FONT face="Verdana, Arial, Helvetica, sans-serif" color=#993399>We deal with the genetic science andengineering. Our main products are anti cancer drugs, for the cure and prevention from the disease. Our another proud product is to solve problems related to genetic disorders</FONT></STRONG></P>', 'John Hammanod', '', 0, '--', '--', 'yes', NULL, 42, 20040827155740, 20040701151650);
# --------------------------------------------------------

#
# 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, '[e-mail]', '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">