PageRenderTime 50ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 1ms

/upgrade/upgrade2.php

https://github.com/sahilbabu/phpb2b
PHP | 3002 lines | 2687 code | 302 blank | 13 comment | 59 complexity | 0a38090b826f85c35300bdcb4258bd8f MD5 | raw file
Possible License(s): LGPL-2.1

Large files files are truncated, but you can click here to view the full file

  1. <?php
  2. /**
  3. * PHPB2B : Opensource B2B Script (http://www.phpb2b.com/)
  4. * Copyright (C) 2007-2010, Ualink. All Rights Reserved.
  5. *
  6. * Licensed under The Languages Packages Licenses.
  7. * Support : phpb2b@hotmail.com
  8. *
  9. * @version $Revision$
  10. */
  11. $alter_tb = <<<EOT
  12. -- 程序名称: PHPB2B
  13. -- 程序版本: 3.2 - ATHENA
  14. -- 最后更新: 2010-3-15
  15. -- --------------------------------------------------------
  16. --
  17. -- 表的结构 `pb_adminfields`
  18. --
  19. DROP TABLE IF EXISTS `pb_adminfields`;
  20. CREATE TABLE `pb_adminfields` (
  21. `member_id` int(10) NOT NULL,
  22. `depart_id` tinyint(1) NOT NULL default '0',
  23. `first_name` varchar(25) NOT NULL default '',
  24. `last_name` varchar(25) NOT NULL default '',
  25. `level` tinyint(1) NOT NULL default '0',
  26. `last_login` int(10) NOT NULL default '0',
  27. `last_ip` varchar(25) NOT NULL default '',
  28. `expired` int(10) NOT NULL default '0',
  29. `created` int(10) NOT NULL default '0',
  30. `modified` int(10) NOT NULL default '0',
  31. PRIMARY KEY (`member_id`)
  32. ) TYPE=MyISAM;
  33. -- --------------------------------------------------------
  34. --
  35. -- 表的结构 `pb_adminmodules`
  36. --
  37. DROP TABLE IF EXISTS `pb_adminmodules`;
  38. CREATE TABLE `pb_adminmodules` (
  39. `id` smallint(3) NOT NULL auto_increment,
  40. `parent_id` smallint(3) NOT NULL default '0',
  41. `name` varchar(50) NOT NULL default '',
  42. PRIMARY KEY (`id`)
  43. ) TYPE=MyISAM;
  44. -- --------------------------------------------------------
  45. --
  46. -- 表的结构 `pb_adminnotes`
  47. --
  48. DROP TABLE IF EXISTS `pb_adminnotes`;
  49. CREATE TABLE `pb_adminnotes` (
  50. `id` int(10) NOT NULL auto_increment,
  51. `member_id` int(10) NOT NULL default '0',
  52. `title` varchar(100) NOT NULL default '',
  53. `content` text,
  54. `created` int(10) NOT NULL default '0',
  55. `modified` int(10) NOT NULL default '0',
  56. PRIMARY KEY (`id`)
  57. ) TYPE=MyISAM;
  58. -- --------------------------------------------------------
  59. --
  60. -- 表的结构 `pb_adminprivileges`
  61. --
  62. DROP TABLE IF EXISTS `pb_adminprivileges`;
  63. CREATE TABLE `pb_adminprivileges` (
  64. `id` int(5) NOT NULL auto_increment,
  65. `adminmodule_id` int(5) NOT NULL default '0',
  66. `name` varchar(25) NOT NULL default '',
  67. PRIMARY KEY (`id`)
  68. ) TYPE=MyISAM;
  69. -- --------------------------------------------------------
  70. --
  71. -- 表的结构 `pb_adminroles`
  72. --
  73. DROP TABLE IF EXISTS `pb_adminroles`;
  74. CREATE TABLE `pb_adminroles` (
  75. `id` tinyint(2) NOT NULL auto_increment,
  76. `name` varchar(25) default NULL,
  77. PRIMARY KEY (`id`)
  78. ) TYPE=MyISAM;
  79. -- --------------------------------------------------------
  80. --
  81. -- 表的结构 `pb_adses`
  82. --
  83. DROP TABLE IF EXISTS `pb_adses`;
  84. CREATE TABLE `pb_adses` (
  85. `id` smallint(6) NOT NULL auto_increment,
  86. `adzone_id` smallint(3) NOT NULL default '0',
  87. `title` varchar(50) NOT NULL default '',
  88. `description` text,
  89. `is_image` tinyint(1) NOT NULL default '1',
  90. `source_name` varchar(100) NOT NULL default '',
  91. `source_type` varchar(100) NOT NULL default '',
  92. `source_url` varchar(100) NOT NULL default '',
  93. `target_url` varchar(100) NOT NULL default '',
  94. `width` smallint(6) NOT NULL default '0',
  95. `height` smallint(6) NOT NULL default '0',
  96. `alt_words` varchar(25) NOT NULL default '',
  97. `start_date` int(10) NOT NULL default '0',
  98. `end_date` int(10) NOT NULL default '0',
  99. `priority` tinyint(1) NOT NULL default '0',
  100. `clicked` smallint(6) NOT NULL default '1',
  101. `target` enum('_parent','_self','_blank') NOT NULL default '_blank',
  102. `seq` tinyint(1) NOT NULL default '0',
  103. `state` tinyint(1) NOT NULL default '1',
  104. `status` tinyint(1) NOT NULL default '0',
  105. `picture_replace` varchar(255) NOT NULL default '',
  106. `created` int(10) NOT NULL default '0',
  107. `modified` int(10) NOT NULL default '0',
  108. PRIMARY KEY (`id`)
  109. ) TYPE=MyISAM;
  110. -- --------------------------------------------------------
  111. --
  112. -- 表的结构 `pb_adzones`
  113. --
  114. DROP TABLE IF EXISTS `pb_adzones`;
  115. CREATE TABLE `pb_adzones` (
  116. `id` smallint(6) NOT NULL auto_increment,
  117. `what` varchar(10) NOT NULL default '',
  118. `name` varchar(100) NOT NULL default '',
  119. `description` text,
  120. `additional_adwords` text,
  121. `price` varchar(50) NOT NULL default '0',
  122. `file_name` varchar(100) NOT NULL default '',
  123. `width` smallint(6) NOT NULL default '0',
  124. `height` smallint(6) NOT NULL default '0',
  125. `wrap` smallint(6) NOT NULL default '0',
  126. `max_ad` smallint(6) NOT NULL default '0',
  127. `created` int(10) NOT NULL default '0',
  128. `modified` int(10) NOT NULL default '0',
  129. PRIMARY KEY (`id`)
  130. ) TYPE=MyISAM;
  131. -- --------------------------------------------------------
  132. --
  133. -- 表的结构 `pb_albums`
  134. --
  135. DROP TABLE IF EXISTS `pb_albums`;
  136. CREATE TABLE `pb_albums` (
  137. `id` int(10) NOT NULL auto_increment,
  138. `member_id` int(10) NOT NULL default '0',
  139. `attachment_id` int(10) NOT NULL default '0',
  140. PRIMARY KEY (`id`)
  141. ) TYPE=MyISAM;
  142. -- --------------------------------------------------------
  143. --
  144. -- 表的结构 `pb_announcements`
  145. --
  146. DROP TABLE IF EXISTS `pb_announcements`;
  147. CREATE TABLE `pb_announcements` (
  148. `id` smallint(6) unsigned NOT NULL auto_increment,
  149. `announcetype_id` smallint(3) NOT NULL default '0',
  150. `subject` varchar(255) NOT NULL default '',
  151. `message` text,
  152. `display_order` tinyint(1) NOT NULL default '0',
  153. `created` int(10) unsigned NOT NULL default '0',
  154. `modified` int(10) NOT NULL default '0',
  155. PRIMARY KEY (`id`)
  156. ) TYPE=MyISAM;
  157. -- --------------------------------------------------------
  158. --
  159. -- 表的结构 `pb_announcementtypes`
  160. --
  161. DROP TABLE IF EXISTS `pb_announcementtypes`;
  162. CREATE TABLE `pb_announcementtypes` (
  163. `id` smallint(3) NOT NULL auto_increment,
  164. `title` varchar(255) NOT NULL default '',
  165. PRIMARY KEY (`id`)
  166. ) TYPE=MyISAM;
  167. -- --------------------------------------------------------
  168. --
  169. -- 表的结构 `pb_areas`
  170. --
  171. DROP TABLE IF EXISTS `pb_areas`;
  172. CREATE TABLE `pb_areas` (
  173. `id` smallint(6) NOT NULL auto_increment,
  174. `attachment_id` int(10) NOT NULL default '0',
  175. `areatype_id` smallint(3) NOT NULL default '0',
  176. `child_ids` text,
  177. `top_parentid` smallint(6) NOT NULL default '0',
  178. `level` tinyint(1) NOT NULL default '1',
  179. `name` varchar(255) NOT NULL default '',
  180. `url` varchar(255) NOT NULL default '',
  181. `alias_name` varchar(255) NOT NULL default '',
  182. `highlight` tinyint(1) NOT NULL default '0',
  183. `parent_id` smallint(6) NOT NULL default '0',
  184. `display_order` tinyint(1) NOT NULL default '0',
  185. `description` text,
  186. `available` tinyint(1) NOT NULL default '1',
  187. `created` int(10) NOT NULL default '0',
  188. `modified` int(10) NOT NULL default '0',
  189. PRIMARY KEY (`id`)
  190. ) TYPE=MyISAM;
  191. -- --------------------------------------------------------
  192. --
  193. -- 表的结构 `pb_areatypes`
  194. --
  195. DROP TABLE IF EXISTS `pb_areatypes`;
  196. CREATE TABLE `pb_areatypes` (
  197. `id` smallint(3) NOT NULL auto_increment,
  198. `name` varchar(64) NOT NULL default '',
  199. PRIMARY KEY (`id`)
  200. ) TYPE=MyISAM;
  201. -- --------------------------------------------------------
  202. --
  203. -- 表的结构 `pb_attachments`
  204. --
  205. DROP TABLE IF EXISTS `pb_attachments`;
  206. CREATE TABLE `pb_attachments` (
  207. `id` int(10) NOT NULL auto_increment,
  208. `attachmenttype_id` smallint(3) NOT NULL default '0',
  209. `member_id` int(10) NOT NULL default '-1',
  210. `file_name` char(100) NOT NULL default '',
  211. `attachment` char(255) NOT NULL default '',
  212. `title` char(100) NOT NULL default '',
  213. `description` text,
  214. `file_type` char(50) NOT NULL default '0',
  215. `file_size` mediumint(8) NOT NULL default '0',
  216. `thumb` varchar(100) NOT NULL default '',
  217. `remote` varchar(100) NOT NULL default '',
  218. `is_image` tinyint(1) NOT NULL default '1',
  219. `status` tinyint(1) NOT NULL default '1',
  220. `created` int(10) NOT NULL default '0',
  221. `modified` int(10) NOT NULL default '0',
  222. PRIMARY KEY (`id`)
  223. ) TYPE=MyISAM;
  224. -- --------------------------------------------------------
  225. --
  226. -- 表的结构 `pb_companies`
  227. --
  228. DROP TABLE IF EXISTS `pb_companies`;
  229. CREATE TABLE `pb_companies` (
  230. `id` int(10) NOT NULL auto_increment,
  231. `member_id` int(10) NOT NULL default '0',
  232. `cache_spacename` varchar(255) NOT NULL default '',
  233. `cache_membergroupid` smallint(3) NOT NULL default '0',
  234. `cache_credits` smallint(6) NOT NULL default '0',
  235. `topleveldomain` varchar(255) NOT NULL default '',
  236. `industry_id1` smallint(6) NOT NULL default '0',
  237. `industry_id2` smallint(6) NOT NULL default '0',
  238. `industry_id3` smallint(6) NOT NULL default '0',
  239. `area_id1` char(6) NOT NULL default '0',
  240. `area_id2` char(6) NOT NULL default '0',
  241. `area_id3` char(6) NOT NULL default '0',
  242. `type_id` tinyint(2) NOT NULL default '0',
  243. `name` char(255) NOT NULL default '',
  244. `description` text,
  245. `english_name` char(100) NOT NULL default '',
  246. `keywords` varchar(50) NOT NULL default '',
  247. `boss_name` varchar(25) NOT NULL default '',
  248. `manage_type` varchar(25) NOT NULL default '',
  249. `year_annual` tinyint(2) NOT NULL default '0',
  250. `property` tinyint(1) NOT NULL default '0',
  251. `configs` text,
  252. `bank_from` varchar(50) NOT NULL default '',
  253. `bank_account` varchar(50) NOT NULL default '',
  254. `main_prod` varchar(100) NOT NULL default '',
  255. `employee_amount` varchar(25) NOT NULL default '',
  256. `found_date` char(10) NOT NULL default '0',
  257. `reg_fund` tinyint(2) NOT NULL default '0',
  258. `reg_address` varchar(200) NOT NULL default '',
  259. `address` varchar(200) NOT NULL default '',
  260. `zipcode` varchar(15) NOT NULL default '',
  261. `main_brand` varchar(100) NOT NULL default '',
  262. `main_market` varchar(200) NOT NULL default '',
  263. `main_biz_place` varchar(50) NOT NULL default '',
  264. `main_customer` varchar(200) NOT NULL default '',
  265. `link_man` varchar(25) NOT NULL default '',
  266. `link_man_gender` tinyint(1) NOT NULL default '0',
  267. `position` tinyint(1) NOT NULL default '0',
  268. `tel` varchar(25) NOT NULL default '',
  269. `fax` varchar(25) NOT NULL default '',
  270. `mobile` varchar(25) NOT NULL default '',
  271. `email` varchar(100) NOT NULL default '',
  272. `site_url` varchar(100) NOT NULL default '',
  273. `picture` varchar(50) NOT NULL default '',
  274. `status` tinyint(1) NOT NULL default '0',
  275. `first_letter` char(2) NOT NULL default '',
  276. `if_commend` tinyint(1) NOT NULL default '0',
  277. `clicked` int(5) NOT NULL default '1',
  278. `created` int(10) NOT NULL default '0',
  279. `modified` int(10) NOT NULL default '0',
  280. PRIMARY KEY (`id`),
  281. KEY `member_id` (`member_id`)
  282. ) TYPE=MyISAM;
  283. -- --------------------------------------------------------
  284. --
  285. -- 表的结构 `pb_companyfields`
  286. --
  287. DROP TABLE IF EXISTS `pb_companyfields`;
  288. CREATE TABLE `pb_companyfields` (
  289. `company_id` int(10) NOT NULL default '0',
  290. `map_longitude` varchar(25) NOT NULL default '',
  291. `map_latitude` varchar(25) NOT NULL default '',
  292. PRIMARY KEY (`company_id`)
  293. ) TYPE=MyISAM;
  294. -- --------------------------------------------------------
  295. --
  296. -- 表的结构 `pb_companynewses`
  297. --
  298. DROP TABLE IF EXISTS `pb_companynewses`;
  299. CREATE TABLE `pb_companynewses` (
  300. `id` int(10) NOT NULL auto_increment,
  301. `member_id` int(10) NOT NULL default '-1',
  302. `company_id` int(10) NOT NULL default '-1',
  303. `title` varchar(100) NOT NULL default '',
  304. `content` text,
  305. `picture` varchar(100) NOT NULL default '',
  306. `status` tinyint(1) NOT NULL default '0',
  307. `clicked` int(5) NOT NULL default '1',
  308. `created` int(11) NOT NULL default '0',
  309. `modified` int(11) NOT NULL default '0',
  310. PRIMARY KEY (`id`)
  311. ) TYPE=MyISAM;
  312. -- --------------------------------------------------------
  313. --
  314. -- 表的结构 `pb_expoes`
  315. --
  316. DROP TABLE IF EXISTS `pb_expoes`;
  317. CREATE TABLE `pb_expoes` (
  318. `id` int(10) NOT NULL auto_increment,
  319. `expotype_id` smallint(3) NOT NULL default '0',
  320. `name` varchar(100) NOT NULL default '',
  321. `description` text,
  322. `begin_time` int(10) NOT NULL default '0',
  323. `end_time` int(10) NOT NULL default '0',
  324. `industry_ids` varchar(100) NOT NULL default '0',
  325. `industry_id1` smallint(6) NOT NULL default '0',
  326. `industry_id2` smallint(6) NOT NULL default '0',
  327. `industry_id3` smallint(6) NOT NULL default '0',
  328. `area_id1` smallint(6) NOT NULL default '0',
  329. `area_id2` smallint(6) NOT NULL default '0',
  330. `area_id3` smallint(6) NOT NULL default '0',
  331. `address` varchar(100) NOT NULL default '',
  332. `stadium_name` varchar(100) NOT NULL default '',
  333. `refresh_method` varchar(100) NOT NULL default '',
  334. `scope` varchar(100) NOT NULL default '',
  335. `hosts` varchar(255) NOT NULL default '',
  336. `organisers` varchar(255) NOT NULL default '',
  337. `co_organisers` varchar(255) NOT NULL default '',
  338. `sponsors` varchar(255) NOT NULL default '',
  339. `contacts` text,
  340. `important_notice` text,
  341. `picture` varchar(100) NOT NULL default '',
  342. `if_commend` tinyint(1) NOT NULL default '0',
  343. `status` tinyint(1) NOT NULL default '0',
  344. `hits` smallint(6) NOT NULL default '1',
  345. `created` int(10) NOT NULL default '0',
  346. `modified` int(10) NOT NULL default '0',
  347. PRIMARY KEY (`id`)
  348. ) TYPE=MyISAM;
  349. -- --------------------------------------------------------
  350. --
  351. -- 表的结构 `pb_expomembers`
  352. --
  353. DROP TABLE IF EXISTS `pb_expomembers`;
  354. CREATE TABLE `pb_expomembers` (
  355. `id` smallint(6) NOT NULL auto_increment,
  356. `expo_id` smallint(6) NOT NULL default '0',
  357. `member_id` int(10) NOT NULL,
  358. `company_id` int(10) NOT NULL,
  359. `created` int(10) NOT NULL default '0',
  360. `modified` int(10) NOT NULL default '0',
  361. PRIMARY KEY (`id`),
  362. UNIQUE KEY `expo_id` (`expo_id`,`member_id`)
  363. ) TYPE=MyISAM;
  364. -- --------------------------------------------------------
  365. --
  366. -- 表的结构 `pb_expostadiums`
  367. --
  368. DROP TABLE IF EXISTS `pb_expostadiums`;
  369. CREATE TABLE `pb_expostadiums` (
  370. `id` smallint(6) NOT NULL auto_increment,
  371. `sa` varchar(100) default '',
  372. `country_id` smallint(6) default '0',
  373. `province_id` smallint(6) default '0',
  374. `city_id` smallint(6) default '0',
  375. `sb` varchar(200) default '',
  376. `sc` varchar(150) default '',
  377. `sd` varchar(150) default '',
  378. `se` varchar(150) default '',
  379. `sf` varchar(150) default '',
  380. `sg` text,
  381. `sh` smallint(6) default '0',
  382. `created` int(10) default NULL,
  383. `modified` int(10) default NULL,
  384. PRIMARY KEY (`id`)
  385. ) TYPE=MyISAM;
  386. -- --------------------------------------------------------
  387. --
  388. -- 表的结构 `pb_expotypes`
  389. --
  390. DROP TABLE IF EXISTS `pb_expotypes`;
  391. CREATE TABLE `pb_expotypes` (
  392. `id` smallint(3) NOT NULL auto_increment,
  393. `name` varchar(50) NOT NULL default '',
  394. `created` int(10) NOT NULL default '0',
  395. `modified` int(10) NOT NULL default '0',
  396. PRIMARY KEY (`id`)
  397. ) TYPE=MyISAM;
  398. -- --------------------------------------------------------
  399. --
  400. -- 表的结构 `pb_favorites`
  401. --
  402. DROP TABLE IF EXISTS `pb_favorites`;
  403. CREATE TABLE `pb_favorites` (
  404. `id` int(10) NOT NULL auto_increment,
  405. `member_id` int(10) NOT NULL default '-1',
  406. `target_id` int(10) NOT NULL,
  407. `type_id` tinyint(1) NOT NULL,
  408. `created` int(10) NOT NULL default '0',
  409. `modified` int(10) NOT NULL default '0',
  410. PRIMARY KEY (`id`),
  411. UNIQUE KEY `member_id` (`member_id`,`target_id`,`type_id`)
  412. ) TYPE=MyISAM;
  413. -- --------------------------------------------------------
  414. --
  415. -- 表的结构 `pb_formattributes`
  416. --
  417. DROP TABLE IF EXISTS `pb_formattributes`;
  418. CREATE TABLE `pb_formattributes` (
  419. `id` int(10) NOT NULL auto_increment,
  420. `type_id` tinyint(1) NOT NULL,
  421. `form_id` smallint(3) NOT NULL default '0',
  422. `formitem_id` smallint(3) NOT NULL default '0',
  423. `primary_id` int(10) NOT NULL,
  424. `attribute` text,
  425. PRIMARY KEY (`id`)
  426. ) TYPE=MyISAM;
  427. -- --------------------------------------------------------
  428. --
  429. -- 表的结构 `pb_formitems`
  430. --
  431. DROP TABLE IF EXISTS `pb_formitems`;
  432. CREATE TABLE `pb_formitems` (
  433. `id` smallint(3) NOT NULL auto_increment,
  434. `form_id` smallint(3) NOT NULL default '0',
  435. `title` varchar(100) NOT NULL default '',
  436. `description` text,
  437. `identifier` varchar(50) NOT NULL default '',
  438. `type` enum('checkbox','select','radio','calendar','url','image','textarea','email','number','text') NOT NULL default 'text',
  439. `rules` text,
  440. `display_order` tinyint(1) NOT NULL,
  441. PRIMARY KEY (`id`)
  442. ) TYPE=MyISAM;
  443. -- --------------------------------------------------------
  444. --
  445. -- 表的结构 `pb_forms`
  446. --
  447. DROP TABLE IF EXISTS `pb_forms`;
  448. CREATE TABLE `pb_forms` (
  449. `id` smallint(3) NOT NULL auto_increment,
  450. `type_id` tinyint(1) NOT NULL,
  451. `name` varchar(100) NOT NULL default '',
  452. `items` text,
  453. PRIMARY KEY (`id`)
  454. ) TYPE=MyISAM;
  455. -- --------------------------------------------------------
  456. --
  457. -- 表的结构 `pb_friendlinks`
  458. --
  459. DROP TABLE IF EXISTS `pb_friendlinks`;
  460. CREATE TABLE `pb_friendlinks` (
  461. `id` smallint(3) NOT NULL auto_increment,
  462. `friendlinktype_id` tinyint(1) NOT NULL default '0',
  463. `industry_id` smallint(6) NOT NULL default '0',
  464. `area_id` smallint(6) NOT NULL default '0',
  465. `title` varchar(50) NOT NULL default '',
  466. `logo` varchar(100) NOT NULL default '',
  467. `url` varchar(50) NOT NULL default '',
  468. `priority` smallint(3) NOT NULL default '0',
  469. `status` tinyint(1) NOT NULL default '1',
  470. `description` text,
  471. `created` int(10) NOT NULL default '0',
  472. `modified` int(10) NOT NULL default '0',
  473. PRIMARY KEY (`id`)
  474. ) TYPE=MyISAM;
  475. -- --------------------------------------------------------
  476. --
  477. -- 表的结构 `pb_friendlinktypes`
  478. --
  479. DROP TABLE IF EXISTS `pb_friendlinktypes`;
  480. CREATE TABLE `pb_friendlinktypes` (
  481. `id` tinyint(1) NOT NULL auto_increment,
  482. `name` varchar(25) NOT NULL default '',
  483. PRIMARY KEY (`id`)
  484. ) TYPE=MyISAM;
  485. -- --------------------------------------------------------
  486. --
  487. -- 表的结构 `pb_goods`
  488. --
  489. DROP TABLE IF EXISTS `pb_goods`;
  490. CREATE TABLE `pb_goods` (
  491. `id` smallint(6) NOT NULL auto_increment,
  492. `name` varchar(255) NOT NULL default '',
  493. `description` text,
  494. `price` float(7,2) NOT NULL default '0.00',
  495. `closed` tinyint(1) NOT NULL default '1',
  496. `picture` varchar(100) NOT NULL default '',
  497. `if_commend` tinyint(1) NOT NULL default '0',
  498. `created` int(10) NOT NULL default '0',
  499. `modified` int(10) NOT NULL default '0',
  500. PRIMARY KEY (`id`)
  501. ) TYPE=MyISAM;
  502. -- --------------------------------------------------------
  503. --
  504. -- 表的结构 `pb_helps`
  505. --
  506. DROP TABLE IF EXISTS `pb_helps`;
  507. CREATE TABLE `pb_helps` (
  508. `id` smallint(6) NOT NULL auto_increment,
  509. `helptype_id` smallint(3) NOT NULL default '0',
  510. `title` varchar(100) NOT NULL default '',
  511. `content` text,
  512. `highlight` tinyint(1) NOT NULL default '0',
  513. `created` int(10) NOT NULL default '0',
  514. `modified` int(10) NOT NULL default '0',
  515. PRIMARY KEY (`id`)
  516. ) TYPE=MyISAM;
  517. -- --------------------------------------------------------
  518. --
  519. -- 表的结构 `pb_helptypes`
  520. --
  521. DROP TABLE IF EXISTS `pb_helptypes`;
  522. CREATE TABLE `pb_helptypes` (
  523. `id` smallint(3) NOT NULL auto_increment,
  524. `title` varchar(100) NOT NULL default '',
  525. `description` varchar(100) NOT NULL default '',
  526. `parent_id` smallint(3) NOT NULL default '0',
  527. `level` tinyint(1) NOT NULL default '0',
  528. `display_order` tinyint(1) NOT NULL default '0',
  529. `created` int(10) NOT NULL default '0',
  530. `modified` int(10) NOT NULL default '0',
  531. PRIMARY KEY (`id`)
  532. ) TYPE=MyISAM;
  533. -- --------------------------------------------------------
  534. --
  535. -- 表的结构 `pb_htmlcaches`
  536. --
  537. DROP TABLE IF EXISTS `pb_htmlcaches`;
  538. CREATE TABLE `pb_htmlcaches` (
  539. `id` int(5) NOT NULL auto_increment,
  540. `page_name` varchar(100) NOT NULL default '',
  541. `last_cached_time` int(10) NOT NULL default '0',
  542. `cache_cycle_time` int(10) NOT NULL default '86400',
  543. PRIMARY KEY (`id`)
  544. ) TYPE=MyISAM;
  545. -- --------------------------------------------------------
  546. --
  547. -- 表的结构 `pb_industries`
  548. --
  549. DROP TABLE IF EXISTS `pb_industries`;
  550. CREATE TABLE `pb_industries` (
  551. `id` smallint(6) NOT NULL auto_increment,
  552. `attachment_id` int(9) NOT NULL default '0',
  553. `industrytype_id` smallint(3) NOT NULL default '0',
  554. `child_ids` text,
  555. `name` varchar(255) NOT NULL default '',
  556. `url` varchar(255) NOT NULL default '',
  557. `alias_name` varchar(255) NOT NULL default '',
  558. `highlight` tinyint(1) NOT NULL default '0',
  559. `parent_id` smallint(6) NOT NULL default '0',
  560. `top_parentid` smallint(6) NOT NULL default '0',
  561. `level` tinyint(1) NOT NULL default '1',
  562. `display_order` tinyint(1) NOT NULL default '0',
  563. `description` text,
  564. `available` tinyint(1) NOT NULL default '1',
  565. `created` int(10) NOT NULL default '0',
  566. `modified` int(10) NOT NULL default '0',
  567. PRIMARY KEY (`id`)
  568. ) TYPE=MyISAM;
  569. -- --------------------------------------------------------
  570. --
  571. -- 表的结构 `pb_industryfields`
  572. --
  573. DROP TABLE IF EXISTS `pb_industryfields`;
  574. CREATE TABLE `pb_industryfields` (
  575. `industry_id` smallint(6) NOT NULL,
  576. `type_id` enum('offer','company','product','fair','market','news','hr') NOT NULL default 'offer',
  577. `keyword_ids` text,
  578. PRIMARY KEY (`industry_id`)
  579. ) TYPE=MyISAM;
  580. -- --------------------------------------------------------
  581. --
  582. -- 表的结构 `pb_industrymodels`
  583. --
  584. DROP TABLE IF EXISTS `pb_industrymodels`;
  585. CREATE TABLE `pb_industrymodels` (
  586. `industry_id` smallint(6) NOT NULL,
  587. `model_id` enum('offers','products','companies') NOT NULL default 'offers',
  588. PRIMARY KEY (`industry_id`,`model_id`)
  589. ) TYPE=MyISAM;
  590. -- --------------------------------------------------------
  591. --
  592. -- 表的结构 `pb_industrytypes`
  593. --
  594. DROP TABLE IF EXISTS `pb_industrytypes`;
  595. CREATE TABLE `pb_industrytypes` (
  596. `id` smallint(3) NOT NULL auto_increment,
  597. `name` varchar(64) NOT NULL default '',
  598. PRIMARY KEY (`id`)
  599. ) TYPE=MyISAM;
  600. -- --------------------------------------------------------
  601. --
  602. -- 表的结构 `pb_inqueries`
  603. --
  604. DROP TABLE IF EXISTS `pb_inqueries`;
  605. CREATE TABLE `pb_inqueries` (
  606. `id` int(10) NOT NULL auto_increment,
  607. `to_member_id` int(10) default NULL,
  608. `to_company_id` int(10) default NULL,
  609. `title` varchar(50) NOT NULL default '',
  610. `content` text,
  611. `send_achive` tinyint(1) default NULL,
  612. `know_more` varchar(50) default '',
  613. `exp_quantity` varchar(15) default '',
  614. `exp_price` varchar(15) default '',
  615. `contacts` text,
  616. `user_ip` varchar(11) default '',
  617. `created` int(10) NOT NULL default '0',
  618. PRIMARY KEY (`id`)
  619. ) TYPE=MyISAM;
  620. -- --------------------------------------------------------
  621. --
  622. -- 表的结构 `pb_ipbanned`
  623. --
  624. DROP TABLE IF EXISTS `pb_ipbanned`;
  625. CREATE TABLE `pb_ipbanned` (
  626. `id` smallint(6) NOT NULL auto_increment,
  627. `ip1` char(3) NOT NULL default '',
  628. `ip2` char(3) NOT NULL default '',
  629. `ip3` char(3) NOT NULL default '',
  630. `ip4` char(3) NOT NULL default '',
  631. `expiration` int(10) NOT NULL default '0',
  632. PRIMARY KEY (`id`),
  633. UNIQUE KEY `ip1` (`ip1`,`ip2`,`ip3`,`ip4`)
  634. ) TYPE=MyISAM;
  635. -- --------------------------------------------------------
  636. --
  637. -- 表的结构 `pb_jobs`
  638. --
  639. DROP TABLE IF EXISTS `pb_jobs`;
  640. CREATE TABLE `pb_jobs` (
  641. `id` int(10) NOT NULL auto_increment,
  642. `member_id` int(10) NOT NULL default '-1',
  643. `company_id` int(10) NOT NULL default '-1',
  644. `cache_spacename` varchar(25) NOT NULL default '',
  645. `industry_id1` smallint(6) NOT NULL default '0',
  646. `industry_id2` smallint(6) NOT NULL default '0',
  647. `industry_id3` smallint(6) NOT NULL default '0',
  648. `area_id1` smallint(6) NOT NULL default '0',
  649. `area_id2` smallint(6) NOT NULL default '0',
  650. `area_id3` smallint(6) NOT NULL default '0',
  651. `name` varchar(150) NOT NULL default '',
  652. `work_station` varchar(50) NOT NULL default '',
  653. `content` text,
  654. `require_gender_id` tinyint(1) NOT NULL default '0',
  655. `peoples` varchar(5) NOT NULL default '',
  656. `require_education_id` tinyint(1) NOT NULL default '0',
  657. `require_age` varchar(10) NOT NULL default '',
  658. `salary_id` tinyint(1) NOT NULL default '0',
  659. `worktype_id` tinyint(1) NOT NULL default '0',
  660. `status` tinyint(1) NOT NULL default '0',
  661. `clicked` int(5) NOT NULL default '1',
  662. `expire_time` int(10) NOT NULL default '0',
  663. `created` int(10) NOT NULL default '0',
  664. `modified` int(10) NOT NULL default '0',
  665. PRIMARY KEY (`id`)
  666. ) TYPE=MyISAM;
  667. -- --------------------------------------------------------
  668. --
  669. -- 表的结构 `pb_keywords`
  670. --
  671. DROP TABLE IF EXISTS `pb_keywords`;
  672. CREATE TABLE `pb_keywords` (
  673. `id` int(5) NOT NULL auto_increment,
  674. `title` varchar(25) NOT NULL default '',
  675. `target_id` int(10) NOT NULL default '0',
  676. `target_position` tinyint(1) NOT NULL default '0',
  677. `type_name` enum('trades','companies','newses','products') NOT NULL default 'trades',
  678. `hits` smallint(6) NOT NULL default '1',
  679. `status` tinyint(1) NOT NULL default '0',
  680. PRIMARY KEY (`id`),
  681. KEY `title` (`title`)
  682. ) TYPE=MyISAM;
  683. -- --------------------------------------------------------
  684. --
  685. -- 表的结构 `pb_logs`
  686. --
  687. DROP TABLE IF EXISTS `pb_logs`;
  688. CREATE TABLE `pb_logs` (
  689. `id` int(10) NOT NULL auto_increment,
  690. `handle_type` enum('error','info','warning') NOT NULL default 'info',
  691. `source_module` varchar(50) NOT NULL default '',
  692. `description` text,
  693. `ip_address` int(10) NOT NULL default '0',
  694. `created` int(10) NOT NULL default '0',
  695. `modified` int(10) NOT NULL default '0',
  696. PRIMARY KEY (`id`)
  697. ) TYPE=MyISAM;
  698. -- --------------------------------------------------------
  699. --
  700. -- 表的结构 `pb_marketprice`
  701. --
  702. DROP TABLE IF EXISTS `pb_marketprice`;
  703. CREATE TABLE `pb_marketprice` (
  704. `id` int(10) NOT NULL auto_increment,
  705. `product_id` int(10) default NULL,
  706. `units` varchar(25) default '',
  707. `max_price` smallint(6) default '0',
  708. `min_price` smallint(6) default '0',
  709. `av_price` smallint(6) default '0',
  710. `content` text,
  711. `created` int(10) default NULL,
  712. `modified` int(10) default NULL,
  713. PRIMARY KEY (`id`)
  714. ) TYPE=MyISAM;
  715. -- --------------------------------------------------------
  716. --
  717. -- 表的结构 `pb_markets`
  718. --
  719. DROP TABLE IF EXISTS `pb_markets`;
  720. CREATE TABLE `pb_markets` (
  721. `id` int(10) NOT NULL auto_increment,
  722. `name` varchar(255) NOT NULL default '',
  723. `content` text,
  724. `area_id1` smallint(6) NOT NULL default '0',
  725. `area_id2` smallint(6) NOT NULL default '0',
  726. `area_id3` smallint(6) NOT NULL default '0',
  727. `industry_id1` smallint(6) NOT NULL default '0',
  728. `industry_id2` smallint(6) NOT NULL default '0',
  729. `industry_id3` smallint(6) NOT NULL default '0',
  730. `picture` varchar(50) NOT NULL default '',
  731. `ip_address` int(10) NOT NULL default '0',
  732. `status` tinyint(1) NOT NULL default '0',
  733. `clicked` smallint(6) NOT NULL default '1',
  734. `if_commend` tinyint(1) NOT NULL default '0',
  735. `created` int(10) NOT NULL default '0',
  736. `modified` int(10) NOT NULL default '0',
  737. PRIMARY KEY (`id`)
  738. ) TYPE=MyISAM;
  739. -- --------------------------------------------------------
  740. --
  741. -- 表的结构 `pb_memberfields`
  742. --
  743. DROP TABLE IF EXISTS `pb_memberfields`;
  744. CREATE TABLE `pb_memberfields` (
  745. `member_id` int(10) NOT NULL default '0',
  746. `today_logins` smallint(6) NOT NULL default '0',
  747. `total_logins` smallint(6) NOT NULL default '0',
  748. `area_id1` smallint(6) NOT NULL default '0',
  749. `area_id2` smallint(6) NOT NULL default '0',
  750. `area_id3` smallint(6) NOT NULL default '0',
  751. `first_name` varchar(25) NOT NULL default '',
  752. `last_name` varchar(25) NOT NULL default '',
  753. `gender` tinyint(1) NOT NULL default '0',
  754. `tel` varchar(25) NOT NULL default '',
  755. `fax` varchar(25) NOT NULL default '',
  756. `mobile` varchar(25) NOT NULL default '',
  757. `qq` varchar(12) NOT NULL default '',
  758. `msn` varchar(50) NOT NULL default '',
  759. `icq` varchar(12) NOT NULL default '',
  760. `yahoo` varchar(50) NOT NULL default '',
  761. `address` varchar(50) NOT NULL default '',
  762. `zipcode` varchar(16) NOT NULL default '',
  763. `site_url` varchar(100) NOT NULL default '',
  764. `question` varchar(50) NOT NULL default '',
  765. `answer` varchar(50) NOT NULL default '',
  766. `reg_ip` varchar(25) NOT NULL default '0',
  767. PRIMARY KEY (`member_id`)
  768. ) TYPE=MyISAM;
  769. -- --------------------------------------------------------
  770. --
  771. -- 表的结构 `pb_membergroups`
  772. --
  773. DROP TABLE IF EXISTS `pb_membergroups`;
  774. CREATE TABLE `pb_membergroups` (
  775. `id` smallint(3) NOT NULL auto_increment,
  776. `membertype_id` tinyint(1) NOT NULL default '-1',
  777. `name` varchar(50) NOT NULL default '',
  778. `description` text,
  779. `type` enum('define','special','system') NOT NULL default 'define',
  780. `system` enum('private','public') NOT NULL default 'private',
  781. `picture` varchar(50) NOT NULL default 'default.gif',
  782. `point_max` smallint(6) NOT NULL default '0',
  783. `point_min` smallint(6) NOT NULL default '0',
  784. `max_offer` smallint(3) NOT NULL default '0',
  785. `max_product` smallint(3) NOT NULL default '0',
  786. `max_job` smallint(3) NOT NULL default '0',
  787. `max_companynews` smallint(3) NOT NULL default '0',
  788. `max_producttype` smallint(3) NOT NULL default '3',
  789. `max_album` smallint(3) NOT NULL default '0',
  790. `max_attach_size` smallint(6) NOT NULL default '0',
  791. `max_size_perday` smallint(6) NOT NULL default '0',
  792. `max_favorite` smallint(3) NOT NULL default '0',
  793. `is_default` tinyint(1) NOT NULL default '0',
  794. `allow_offer` tinyint(1) NOT NULL default '0',
  795. `allow_market` tinyint(1) NOT NULL default '0',
  796. `allow_company` tinyint(1) NOT NULL default '0',
  797. `allow_product` tinyint(1) NOT NULL default '0',
  798. `allow_job` tinyint(1) NOT NULL default '0',
  799. `allow_companynews` tinyint(1) NOT NULL default '1',
  800. `allow_album` tinyint(1) NOT NULL default '0',
  801. `allow_space` tinyint(1) NOT NULL default '1',
  802. `default_live_time` tinyint(1) NOT NULL default '1',
  803. `after_live_time` tinyint(1) NOT NULL default '1',
  804. `exempt` tinyint(1) unsigned zerofill NOT NULL default '0',
  805. `created` int(10) NOT NULL default '0',
  806. `modified` int(10) NOT NULL default '0',
  807. PRIMARY KEY (`id`)
  808. ) TYPE=MyISAM;
  809. -- --------------------------------------------------------
  810. --
  811. -- 表的结构 `pb_members`
  812. --
  813. DROP TABLE IF EXISTS `pb_members`;
  814. CREATE TABLE `pb_members` (
  815. `id` int(10) NOT NULL auto_increment,
  816. `space_name` varchar(255) NOT NULL default '',
  817. `templet_id` smallint(3) NOT NULL default '0',
  818. `username` varchar(25) NOT NULL default '',
  819. `userpass` varchar(50) NOT NULL default '',
  820. `email` varchar(100) NOT NULL default '',
  821. `points` smallint(6) NOT NULL default '0',
  822. `credits` smallint(6) NOT NULL default '0',
  823. `balance_amount` float(7,2) NOT NULL default '0.00',
  824. `trusttype_ids` varchar(25) NOT NULL default '',
  825. `status` enum('3','2','1','0') NOT NULL default '0',
  826. `photo` varchar(100) NOT NULL default '',
  827. `membertype_id` smallint(3) NOT NULL default '0',
  828. `membergroup_id` smallint(3) NOT NULL default '0',
  829. `last_login` varchar(11) NOT NULL default '0',
  830. `last_ip` varchar(25) NOT NULL default '0',
  831. `service_start_date` varchar(11) NOT NULL default '0',
  832. `service_end_date` varchar(11) NOT NULL default '0',
  833. `office_redirect` smallint(6) NOT NULL default '0',
  834. `created` varchar(10) NOT NULL default '0',
  835. `modified` varchar(10) NOT NULL default '0',
  836. PRIMARY KEY (`id`),
  837. UNIQUE KEY `username` (`username`)
  838. ) TYPE=MyISAM;
  839. -- --------------------------------------------------------
  840. --
  841. -- 表的结构 `pb_membertypes`
  842. --
  843. DROP TABLE IF EXISTS `pb_membertypes`;
  844. CREATE TABLE `pb_membertypes` (
  845. `id` smallint(3) NOT NULL auto_increment,
  846. `default_membergroup_id` smallint(3) NOT NULL default '0',
  847. `name` varchar(50) NOT NULL default '',
  848. `description` text,
  849. PRIMARY KEY (`id`)
  850. ) TYPE=MyISAM;
  851. -- --------------------------------------------------------
  852. --
  853. -- 表的结构 `pb_messages`
  854. --
  855. DROP TABLE IF EXISTS `pb_messages`;
  856. CREATE TABLE `pb_messages` (
  857. `id` int(10) NOT NULL auto_increment,
  858. `type` enum('system','user','inquery') NOT NULL default 'user',
  859. `from_member_id` int(10) NOT NULL default '-1',
  860. `cache_from_username` varchar(25) NOT NULL default '',
  861. `to_member_id` int(10) NOT NULL default '-1',
  862. `cache_to_username` varchar(25) NOT NULL default '',
  863. `title` varchar(255) NOT NULL default '',
  864. `content` text,
  865. `status` tinyint(1) NOT NULL default '0',
  866. `created` int(10) NOT NULL default '0',
  867. PRIMARY KEY (`id`)
  868. ) TYPE=MyISAM;
  869. -- --------------------------------------------------------
  870. --
  871. -- 表的结构 `pb_navs`
  872. --
  873. DROP TABLE IF EXISTS `pb_navs`;
  874. CREATE TABLE `pb_navs` (
  875. `id` smallint(3) NOT NULL auto_increment,
  876. `parent_id` smallint(3) NOT NULL default '0',
  877. `name` varchar(50) NOT NULL default '',
  878. `description` varchar(255) NOT NULL default '',
  879. `url` varchar(255) NOT NULL default '',
  880. `target` enum('_blank','_self') NOT NULL default '_self',
  881. `status` tinyint(1) NOT NULL default '1',
  882. `display_order` smallint(3) NOT NULL default '0',
  883. `highlight` tinyint(1) NOT NULL default '0',
  884. `level` tinyint(1) NOT NULL default '0',
  885. `class_name` varchar(25) NOT NULL default '',
  886. `created` int(10) NOT NULL default '0',
  887. `modified` int(10) NOT NULL default '0',
  888. PRIMARY KEY (`id`)
  889. ) TYPE=MyISAM;
  890. -- --------------------------------------------------------
  891. --
  892. -- 表的结构 `pb_newscomments`
  893. --
  894. DROP TABLE IF EXISTS `pb_newscomments`;
  895. CREATE TABLE `pb_newscomments` (
  896. `id` int(10) NOT NULL auto_increment,
  897. `news_id` int(10) NOT NULL default '0',
  898. `member_id` int(10) NOT NULL default '-1',
  899. `cache_username` varchar(25) NOT NULL default '',
  900. `message` text,
  901. `ip_address` char(15) NOT NULL default '',
  902. `invisible` tinyint(1) NOT NULL default '1',
  903. `created` int(10) NOT NULL default '0',
  904. `date_line` datetime NOT NULL,
  905. PRIMARY KEY (`id`)
  906. ) TYPE=MyISAM;
  907. -- --------------------------------------------------------
  908. --
  909. -- 表的结构 `pb_newses`
  910. --
  911. DROP TABLE IF EXISTS `pb_newses`;
  912. CREATE TABLE `pb_newses` (
  913. `id` int(10) NOT NULL auto_increment,
  914. `type_id` int(5) NOT NULL default '0',
  915. `industry_id` smallint(3) NOT NULL default '0',
  916. `area_id` smallint(3) NOT NULL default '0',
  917. `title` varchar(255) NOT NULL default '',
  918. `content` text,
  919. `source` varchar(25) NOT NULL default '',
  920. `picture` varchar(50) NOT NULL default '',
  921. `if_focus` tinyint(1) NOT NULL default '0',
  922. `if_commend` tinyint(1) NOT NULL default '0',
  923. `highlight` tinyint(1) NOT NULL default '0',
  924. `clicked` int(10) NOT NULL default '1',
  925. `status` tinyint(1) NOT NULL default '1',
  926. `require_membertype` varchar(15) NOT NULL default '0',
  927. `tag_ids` varchar(255) default '',
  928. `created` int(10) NOT NULL default '0',
  929. `create_time` datetime NOT NULL default '0000-00-00 00:00:00',
  930. `modified` int(10) NOT NULL default '0',
  931. PRIMARY KEY (`id`)
  932. ) TYPE=MyISAM;
  933. -- --------------------------------------------------------
  934. --
  935. -- 表的结构 `pb_newstypes`
  936. --
  937. DROP TABLE IF EXISTS `pb_newstypes`;
  938. CREATE TABLE `pb_newstypes` (
  939. `id` int(5) NOT NULL auto_increment,
  940. `name` varchar(25) NOT NULL default '',
  941. `level_id` tinyint(1) NOT NULL default '1',
  942. `status` tinyint(1) NOT NULL default '1',
  943. `parent_id` smallint(3) NOT NULL default '0',
  944. `created` int(10) NOT NULL default '0',
  945. PRIMARY KEY (`id`)
  946. ) TYPE=MyISAM;
  947. -- --------------------------------------------------------
  948. --
  949. -- 表的结构 `pb_ordergoods`
  950. --
  951. DROP TABLE IF EXISTS `pb_ordergoods`;
  952. CREATE TABLE `pb_ordergoods` (
  953. `goods_id` smallint(6) NOT NULL default '0',
  954. `order_id` smallint(6) unsigned zerofill NOT NULL default '000000',
  955. `amount` smallint(3) NOT NULL default '1',
  956. PRIMARY KEY (`goods_id`,`order_id`)
  957. ) TYPE=MyISAM;
  958. -- --------------------------------------------------------
  959. --
  960. -- 表的结构 `pb_orders`
  961. --
  962. DROP TABLE IF EXISTS `pb_orders`;
  963. CREATE TABLE `pb_orders` (
  964. `id` smallint(6) unsigned zerofill NOT NULL auto_increment,
  965. `member_id` int(10) NOT NULL default '-1',
  966. `anonymous` tinyint(1) NOT NULL default '0',
  967. `cache_username` varchar(25) NOT NULL default '',
  968. `total_price` smallint(3) NOT NULL default '0',
  969. `content` text,
  970. `status` tinyint(1) NOT NULL default '0',
  971. `created` int(10) NOT NULL default '0',
  972. `modified` int(10) NOT NULL default '0',
  973. PRIMARY KEY (`id`)
  974. ) TYPE=MyISAM;
  975. -- --------------------------------------------------------
  976. --
  977. -- 表的结构 `pb_passports`
  978. --
  979. DROP TABLE IF EXISTS `pb_passports`;
  980. CREATE TABLE `pb_passports` (
  981. `id` smallint(3) NOT NULL auto_increment,
  982. `name` varchar(25) NOT NULL default '',
  983. `title` varchar(25) NOT NULL default '',
  984. `description` text,
  985. `url` varchar(25) NOT NULL default '',
  986. `config` text,
  987. `available` tinyint(1) NOT NULL default '1',
  988. `created` int(10) NOT NULL default '0',
  989. `modified` int(10) NOT NULL default '0',
  990. PRIMARY KEY (`id`)
  991. ) TYPE=MyISAM;
  992. -- --------------------------------------------------------
  993. --
  994. -- 表的结构 `pb_payments`
  995. --
  996. DROP TABLE IF EXISTS `pb_payments`;
  997. CREATE TABLE `pb_payments` (
  998. `id` smallint(3) NOT NULL auto_increment,
  999. `name` varchar(25) NOT NULL default '',
  1000. `title` varchar(25) NOT NULL default '',
  1001. `description` text,
  1002. `config` text,
  1003. `available` tinyint(1) NOT NULL default '1',
  1004. `if_online_support` tinyint(1) NOT NULL default '0',
  1005. `created` int(10) NOT NULL default '0',
  1006. `modified` int(10) NOT NULL default '0',
  1007. PRIMARY KEY (`id`)
  1008. ) TYPE=MyISAM;
  1009. -- --------------------------------------------------------
  1010. --
  1011. -- 表的结构 `pb_personals`
  1012. --
  1013. DROP TABLE IF EXISTS `pb_personals`;
  1014. CREATE TABLE `pb_personals` (
  1015. `member_id` int(10) NOT NULL,
  1016. `resume_status` tinyint(1) NOT NULL default '0',
  1017. `max_education` tinyint(1) NOT NULL default '0',
  1018. PRIMARY KEY (`member_id`)
  1019. ) TYPE=MyISAM;
  1020. -- --------------------------------------------------------
  1021. --
  1022. -- 表的结构 `pb_plugins`
  1023. --
  1024. DROP TABLE IF EXISTS `pb_plugins`;
  1025. CREATE TABLE `pb_plugins` (
  1026. `id` smallint(3) NOT NULL auto_increment,
  1027. `name` varchar(25) NOT NULL default '',
  1028. `title` varchar(25) NOT NULL default '',
  1029. `description` text,
  1030. `copyright` varchar(25) NOT NULL default '',
  1031. `version` varchar(15) NOT NULL default '',
  1032. `pluginvar` text,
  1033. `available` tinyint(1) NOT NULL default '1',
  1034. `created` int(10) NOT NULL default '0',
  1035. `modified` int(10) NOT NULL default '0',
  1036. PRIMARY KEY (`id`)
  1037. ) TYPE=MyISAM;
  1038. -- --------------------------------------------------------
  1039. --
  1040. -- 表的结构 `pb_pointlogs`
  1041. --
  1042. DROP TABLE IF EXISTS `pb_pointlogs`;
  1043. CREATE TABLE `pb_pointlogs` (
  1044. `id` int(10) NOT NULL auto_increment,
  1045. `member_id` int(10) NOT NULL,
  1046. `action_name` varchar(25) NOT NULL default '',
  1047. `points` smallint(3) NOT NULL default '0',
  1048. `description` text,
  1049. `ip_address` varchar(15) NOT NULL default '',
  1050. `created` int(10) NOT NULL default '0',
  1051. `modified` int(10) NOT NULL default '0',
  1052. PRIMARY KEY (`id`)
  1053. ) TYPE=MyISAM;
  1054. -- --------------------------------------------------------
  1055. --
  1056. -- 表的结构 `pb_products`
  1057. --
  1058. DROP TABLE IF EXISTS `pb_products`;
  1059. CREATE TABLE `pb_products` (
  1060. `id` int(10) NOT NULL auto_increment,
  1061. `member_id` int(10) NOT NULL,
  1062. `company_id` int(10) NOT NULL default '0',
  1063. `cache_companyname` varchar(100) NOT NULL default '',
  1064. `sort_id` tinyint(1) NOT NULL default '1',
  1065. `industry_id1` smallint(6) NOT NULL default '0',
  1066. `industry_id2` smallint(6) NOT NULL default '0',
  1067. `industry_id3` smallint(6) NOT NULL default '0',
  1068. `area_id1` smallint(6) NOT NULL default '0',
  1069. `area_id2` smallint(6) NOT NULL default '0',
  1070. `area_id3` smallint(6) NOT NULL default '0',
  1071. `name` varchar(255) NOT NULL default '',
  1072. `price` varchar(15) NOT NULL default '0',
  1073. `sn` varchar(20) NOT NULL default '',
  1074. `spec` varchar(20) NOT NULL default '',
  1075. `produce_area` varchar(50) NOT NULL default '',
  1076. `packing_content` varchar(100) NOT NULL default '',
  1077. `picture` varchar(50) NOT NULL default '',
  1078. `content` text,
  1079. `producttype_id` smallint(6) NOT NULL default '0',
  1080. `status` tinyint(1) NOT NULL default '0',
  1081. `state` tinyint(1) NOT NULL default '1',
  1082. `ifnew` tinyint(1) NOT NULL default '0',
  1083. `ifcommend` tinyint(1) NOT NULL default '0',
  1084. `priority` tinyint(1) NOT NULL default '0',
  1085. `tag_ids` varchar(255) default '',
  1086. `clicked` smallint(6) NOT NULL default '1',
  1087. `formattribute_ids` text,
  1088. `created` int(10) NOT NULL default '0',
  1089. `modified` int(10) NOT NULL default '0',
  1090. PRIMARY KEY (`id`)
  1091. ) TYPE=MyISAM;
  1092. -- --------------------------------------------------------
  1093. --
  1094. -- 表的结构 `pb_producttypes`
  1095. --
  1096. DROP TABLE IF EXISTS `pb_producttypes`;
  1097. CREATE TABLE `pb_producttypes` (
  1098. `id` int(10) NOT NULL auto_increment,
  1099. `member_id` int(10) NOT NULL,
  1100. `company_id` int(10) NOT NULL,
  1101. `name` varchar(25) NOT NULL default '',
  1102. `level` tinyint(1) NOT NULL default '0',
  1103. `created` int(10) NOT NULL default '0',
  1104. `modified` int(10) NOT NULL default '0',
  1105. PRIMARY KEY (`id`)
  1106. ) TYPE=MyISAM;
  1107. -- --------------------------------------------------------
  1108. --
  1109. -- 表的结构 `pb_roleadminers`
  1110. --
  1111. DROP TABLE IF EXISTS `pb_roleadminers`;
  1112. CREATE TABLE `pb_roleadminers` (
  1113. `id` int(5) NOT NULL auto_increment,
  1114. `adminrole_id` int(2) default NULL,
  1115. `adminer_id` int(2) default NULL,
  1116. PRIMARY KEY (`id`)
  1117. ) TYPE=MyISAM;
  1118. -- --------------------------------------------------------
  1119. --
  1120. -- 表的结构 `pb_roleprivileges`
  1121. --
  1122. DROP TABLE IF EXISTS `pb_roleprivileges`;
  1123. CREATE TABLE `pb_roleprivileges` (
  1124. `id` int(5) NOT NULL auto_increment,
  1125. `adminrole_id` int(2) default NULL,
  1126. `adminprivilege_id` int(2) default NULL,
  1127. PRIMARY KEY (`id`)
  1128. ) TYPE=MyISAM;
  1129. -- --------------------------------------------------------
  1130. --
  1131. -- 表的结构 `pb_segmentcaches`
  1132. --
  1133. DROP TABLE IF EXISTS `pb_segmentcaches`;
  1134. CREATE TABLE `pb_segmentcaches` (
  1135. `id` int(10) NOT NULL auto_increment,
  1136. `title` varchar(255) NOT NULL default '',
  1137. `data` text,
  1138. `display_order` smallint(3) NOT NULL default '0',
  1139. PRIMARY KEY (`id`)
  1140. ) TYPE=MyISAM;
  1141. -- --------------------------------------------------------
  1142. --
  1143. -- 表的结构 `pb_segmentdicts`
  1144. --
  1145. DROP TABLE IF EXISTS `pb_segmentdicts`;
  1146. CREATE TABLE `pb_segmentdicts` (
  1147. `id` int(10) NOT NULL auto_increment,
  1148. `word` varchar(64) NOT NULL default '',
  1149. PRIMARY KEY (`id`)
  1150. ) TYPE=MyISAM;
  1151. -- --------------------------------------------------------
  1152. --
  1153. -- 表的结构 `pb_services`
  1154. --
  1155. DROP TABLE IF EXISTS `pb_services`;
  1156. CREATE TABLE `pb_services` (
  1157. `id` smallint(6) NOT NULL auto_increment,
  1158. `member_id` int(10) NOT NULL,
  1159. `title` varchar(25) NOT NULL default '',
  1160. `content` text,
  1161. `nick_name` varchar(25) default '',
  1162. `email` varchar(25) NOT NULL default '',
  1163. `user_ip` varchar(11) NOT NULL default '',
  1164. `type_id` tinyint(1) NOT NULL default '0',
  1165. `status` tinyint(1) NOT NULL default '0',
  1166. `created` int(10) NOT NULL default '0',
  1167. `revert_content` text,
  1168. `revert_date` int(10) NOT NULL default '0',
  1169. PRIMARY KEY (`id`)
  1170. ) TYPE=MyISAM;
  1171. -- --------------------------------------------------------
  1172. --
  1173. -- 表的结构 `pb_sessions`
  1174. --
  1175. DROP TABLE IF EXISTS `pb_sessions`;
  1176. CREATE TABLE `pb_sessions` (
  1177. `sesskey` char(32) NOT NULL default '',
  1178. `expiry` int(10) NOT NULL default '0',
  1179. `expireref` char(64) NOT NULL default '',
  1180. `data` text,
  1181. `created` int(10) NOT NULL default '0',
  1182. `modified` int(10) NOT NULL default '0',
  1183. KEY `sess2_expiry` (`expiry`),
  1184. KEY `sess2_expireref` (`expireref`)
  1185. ) TYPE=MyISAM;
  1186. -- --------------------------------------------------------
  1187. --
  1188. -- 表的结构 `pb_settings`
  1189. --
  1190. DROP TABLE IF EXISTS `pb_settings`;
  1191. CREATE TABLE `pb_settings` (
  1192. `id` smallint(3) NOT NULL auto_increment,
  1193. `type_id` tinyint(1) NOT NULL default '0',
  1194. `variable` varchar(150) NOT NULL default '',
  1195. `valued` text,
  1196. PRIMARY KEY (`id`),
  1197. UNIQUE KEY `variable` (`variable`)
  1198. ) TYPE=MyISAM;
  1199. -- --------------------------------------------------------
  1200. --
  1201. -- 表的结构 `pb_spacelinks`
  1202. --
  1203. DROP TABLE IF EXISTS `pb_spacelinks`;
  1204. CREATE TABLE `pb_spacelinks` (
  1205. `id` int(10) NOT NULL auto_increment,
  1206. `member_id` int(10) NOT NULL,
  1207. `company_id` int(10) NOT NULL,
  1208. `display_order` smallint(3) NOT NULL default '0',
  1209. `title` varchar(100) NOT NULL default '',
  1210. `url` varchar(255) NOT NULL default '',
  1211. `is_outlink` tinyint(1) NOT NULL default '0',
  1212. `description` varchar(100) NOT NULL default '',
  1213. `logo` varchar(255) NOT NULL default '',
  1214. `highlight` tinyint(1) NOT NULL default '0',
  1215. `created` int(10) NOT NULL default '0',
  1216. PRIMARY KEY (`id`)
  1217. ) TYPE=MyISAM;
  1218. -- --------------------------------------------------------
  1219. --
  1220. -- 表的结构 `pb_spreads`
  1221. --
  1222. DROP TABLE IF EXISTS `pb_spreads`;
  1223. CREATE TABLE `pb_spreads` (
  1224. `keyword_id` int(10) NOT NULL,
  1225. `target_id` int(10) NOT NULL,
  1226. `type_name` enum('trades','companies','newses','products') NOT NULL default 'trades',
  1227. `expiration` int(10) NOT NULL default '0',
  1228. `display_order` tinyint(1) NOT NULL,
  1229. PRIMARY KEY (`keyword_id`),
  1230. KEY `spread` (`keyword_id`,`target_id`)
  1231. ) TYPE=MyISAM;
  1232. -- --------------------------------------------------------
  1233. --
  1234. -- 表的结构 `pb_stats`
  1235. --
  1236. DROP TABLE IF EXISTS `pb_stats`;
  1237. CREATE TABLE `pb_stats` (
  1238. `id` smallint(6) NOT NULL auto_increment,
  1239. `sa` varchar(25) default '',
  1240. `sb` varchar(50) default '',
  1241. `description` varchar(50) NOT NULL default '',
  1242. `sc` int(10) default NULL,
  1243. `sd` int(10) default NULL,
  1244. `se` smallint(6) default '0',
  1245. PRIMARY KEY (`id`)
  1246. ) TYPE=MyISAM;
  1247. -- --------------------------------------------------------
  1248. --
  1249. -- 表的结构 `pb_tags`
  1250. --
  1251. DROP TABLE IF EXISTS `pb_tags`;
  1252. CREATE TABLE `pb_tags` (
  1253. `id` int(10) NOT NULL auto_increment,
  1254. `member_id` int(10) NOT NULL,
  1255. `name` varchar(255) NOT NULL default '',
  1256. `numbers` smallint(6) NOT NULL default '0',
  1257. `closed` tinyint(1) NOT NULL default '0',
  1258. `created` int(10) NOT NULL default '0',
  1259. `modified` int(10) NOT NULL default '0',
  1260. PRIMARY KEY (`id`),
  1261. KEY `title` (`name`)
  1262. ) TYPE=MyISAM;
  1263. -- --------------------------------------------------------
  1264. --
  1265. -- 表的结构 `pb_templets`
  1266. --
  1267. DROP TABLE IF EXISTS `pb_templets`;
  1268. CREATE TABLE `pb_templets` (
  1269. `id` smallint(3) NOT NULL auto_increment,
  1270. `name` varchar(25) NOT NULL default '',
  1271. `title` varchar(25) NOT NULL default '',
  1272. `directory` varchar(100) NOT NULL default '',
  1273. `type` enum('system','user') NOT NULL default 'system',
  1274. `author` varchar(100) NOT NULL default '',
  1275. `description` text,
  1276. `is_default` tinyint(1) NOT NULL default '0',
  1277. `require_membertype` varchar(100) NOT NULL default '0',
  1278. `require_membergroups` varchar(100) NOT NULL default '0',
  1279. `status` tinyint(1) NOT NULL default '1',
  1280. PRIMARY KEY (`id`)
  1281. ) TYPE=MyISAM;
  1282. -- --------------------------------------------------------
  1283. --
  1284. -- 表的结构 `pb_topicnews`
  1285. --
  1286. DROP TABLE IF EXISTS `pb_topicnews`;
  1287. CREATE TABLE `pb_topicnews` (
  1288. `topic_id` smallint(6) NOT NULL default '0',
  1289. `news_id` smallint(6) NOT NULL default '0'
  1290. ) TYPE=MyISAM;
  1291. -- --------------------------------------------------------
  1292. --
  1293. -- 表的结构 `pb_topics`
  1294. --
  1295. DROP TABLE IF EXISTS `pb_topics`;
  1296. CREATE TABLE `pb_topics` (
  1297. `id` smallint(6) NOT NULL auto_increment,
  1298. `title` varchar(255) NOT NULL default '',
  1299. `picture` varchar(255) NOT NULL default '',
  1300. `description` text,
  1301. `created` int(10) NOT NULL default '0',
  1302. `modified` int(10) NOT NULL default '0',
  1303. PRIMARY KEY (`id`)
  1304. ) TYPE=MyISAM;
  1305. -- --------------------------------------------------------
  1306. --
  1307. -- 表的结构 `pb_tradefields`
  1308. --
  1309. DROP TABLE IF EXISTS `pb_tradefields`;
  1310. CREATE TABLE `pb_tradefields` (
  1311. `trade_id` int(10) NOT NULL default '0',
  1312. `member_id` int(10) NOT NULL default '0',
  1313. `link_man` varchar(100) NOT NULL default '',
  1314. `address` varchar(100) NOT NULL default '',
  1315. `company_name` varchar(100) NOT NULL default '',
  1316. `email` varchar(100) NOT NULL default '',
  1317. `prim_tel` tinyint(1) NOT NULL default '0',
  1318. `prim_telnumber` varchar(25) NOT NULL default '',
  1319. `prim_im` tinyint(1) NOT NULL default '0',
  1320. `prim_imaccount` varchar(100) NOT NULL default '',
  1321. PRIMARY KEY (`trade_id`),
  1322. UNIQUE KEY `trade_id` (`trade_id`)
  1323. ) TYPE=MyISAM;
  1324. -- --------------------------------------------------------
  1325. --
  1326. -- 表的结构 `pb_trades`
  1327. --
  1328. DROP TABLE IF EXISTS `pb_trades`;
  1329. CREATE TABLE `pb_trades` (
  1330. `id` int(10) NOT NULL auto_increment,
  1331. `type_id` enum('8','7','6','5','4','3','2','1') NOT NULL default '1',
  1332. `industry_id1` smallint(6) NOT NULL default '0',
  1333. `industry_id2` smallint(6) NOT NULL default '0',
  1334. `industry_id3` smallint(6) NOT NULL default '0',
  1335. `area_id1` smallint(6) NOT NULL default '0',
  1336. `area_id2` smallint(6) NOT NULL default '0',
  1337. `area_id3` smallint(6) NOT NULL default '0',
  1338. `member_id` int(10) NOT NULL default '0',
  1339. `company_id` int(5) NOT NULL default '0',
  1340. `cache_username` varchar(25) NOT NULL default '',
  1341. `cache_companyname` varchar(100) NOT NULL default '',
  1342. `title` varchar(100) NOT NULL default '',
  1343. `content` text,
  1344. `price` float(8,2) NOT NULL default '0.00',
  1345. `measuring_unit` varchar(15) NOT NULL default '0',
  1346. `monetary_unit` varchar(15) NOT NULL default '0',
  1347. `packing` varchar(150) NOT NULL default '',
  1348. `quantity` varchar(25) NOT NULL default '',
  1349. `offer_expire` int(10) NOT NULL default '0',
  1350. `spec` varchar(200) NOT NULL default '',
  1351. `sn` varchar(25) NOT NULL default '',
  1352. `picture` varchar(50) NOT NULL default '',
  1353. `picture_remote` varchar(50) NOT NULL default '',
  1354. `status` tinyint(2) NOT NULL default '0',
  1355. `submit_time` int(10) NOT NULL default '0',
  1356. `expire_time` int(10) NOT NULL default '0',
  1357. `expire_days` int(3) NOT NULL default '0',
  1358. `if_commend` tinyint(1) NOT NULL default '0',
  1359. `if_urgent` enum('0','1') NOT NULL default '0',
  1360. `if_locked` enum('0','1') NOT NULL default '0',
  1361. `require_point` smallint(6) NOT NULL default '0',
  1362. `require_membertype` smallint(6) NOT NULL default '0',
  1363. `require_freedate` int(10) NOT NULL default '0',
  1364. `ip_addr` varchar(15) NOT NULL default '',
  1365. `clicked` int(10) NOT NULL default '1',
  1366. `tag_ids` varchar(255) default '',
  1367. `formattribute_ids` text,
  1368. `created` int(10) NOT NULL default '0',
  1369. `modified` int(10) NOT NULL default '0',
  1370. PRIMARY KEY (`id`)
  1371. ) TYPE=MyISAM;
  1372. -- --------------------------------------------------------
  1373. --
  1374. -- 表的结构 `pb_tradetypes`
  1375. --
  1376. DROP TABLE IF EXISTS `pb_tradetypes`;
  1377. CREATE TABLE `pb_tradetypes` (
  1378. `id` smallint(3) NOT NULL auto_increment,
  1379. `name` varchar(25) NOT NULL default '',
  1380. `display_order` tinyint(1) NOT NULL default '0',
  1381. PRIMARY KEY (`id`)
  1382. ) TYPE=MyISAM ;
  1383. -- --------------------------------------------------------
  1384. --
  1385. -- 表的结构 `pb_trustlogs`
  1386. --
  1387. DROP TABLE IF EXISTS `pb_trustlogs`;
  1388. CREATE TABLE `pb_trustlogs` (
  1389. `member_id` int(10) NOT NULL auto_increment,
  1390. `trusttype_id` smallint(3) NOT NULL default '0',
  1391. PRIMARY KEY (`member_id`)
  1392. ) TYPE=MyISAM;
  1393. -- --------------------------------------------------------
  1394. --
  1395. -- 表的结构 `pb_trusttypes`
  1396. --
  1397. DROP TABLE IF EXISTS `pb_trusttypes`;
  1398. CREATE TABLE `pb_trusttypes` (
  1399. `id` smallint(3) NOT NULL auto_increment,
  1400. `name` varchar(64) NOT NULL default '',
  1401. `description` text,
  1402. `image` varchar(255) NOT NULL default '',
  1403. `…

Large files files are truncated, but you can click here to view the full file