CyberVX

Audit [AgioLab]

Aug 19th, 2019
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 58.93 KB | None | 0 0
  1. Auditor: CyberVX
  2.  
  3. - OS:
  4. # KALI LINUX;
  5. # WHONIX
  6.  
  7. - TOOLS:
  8. # NMAP;
  9. # SQLMAP;
  10.  
  11. - VULNERABILITY:
  12. # SQL INJECTION;
  13. # INSECURE CRYPTOGRAPHIC STORAGE;
  14. # FAILURE TO RESTRICT URL ACESS;
  15.  
  16. - TARGET:
  17. # http://www.angiobio.com
  18.  
  19. ========================
  20. REPORT 1
  21. ========================
  22.  
  23. Database: angioprod
  24. Table: wdb_countries
  25. [5 columns]
  26. +----------------------+--------------+
  27. | Column | Type |
  28. +----------------------+--------------+
  29. | address_format_id | int(9) |
  30. | countries_id | int(9) |
  31. | countries_iso_code_2 | varchar(2) |
  32. | countries_iso_code_3 | varchar(3) |
  33. | countries_name | varchar(128) |
  34. +----------------------+--------------+
  35.  
  36. Database: angioprod
  37. Table: wdb_orders_status_history
  38. [6 columns]
  39. +--------------------------+----------+
  40. | Column | Type |
  41. +--------------------------+----------+
  42. | comments | text |
  43. | customer_notified | int(1) |
  44. | date_added | datetime |
  45. | orders_id | int(9) |
  46. | orders_status_history_id | int(11) |
  47. | orders_status_id | int(9) |
  48. +--------------------------+----------+
  49.  
  50. Database: angioprod
  51. Table: wdb_categories
  52. [9 columns]
  53. +----------------------+--------------+
  54. | Column | Type |
  55. +----------------------+--------------+
  56. | categories_bimage | varchar(64) |
  57. | categories_id | int(9) |
  58. | categories_image | varchar(64) |
  59. | categories_name | varchar(64) |
  60. | categories_parent_id | int(9) |
  61. | is_enabled | int(5) |
  62. | products_sort_by | varchar(30) |
  63. | seo_file_name | varchar(128) |
  64. | sort_order | int(5) |
  65. +----------------------+--------------+
  66.  
  67. Database: angioprod
  68. Table: wdb_related_products
  69. [3 columns]
  70. +---------------------+--------+
  71. | Column | Type |
  72. +---------------------+--------+
  73. | products_id | int(9) |
  74. | related_products_id | int(9) |
  75. | sort_order | int(5) |
  76. +---------------------+--------+
  77.  
  78. Database: angioprod
  79. Table: wdb_consume_reward
  80. [5 columns]
  81. +---------------+---------+
  82. | Column | Type |
  83. +---------------+---------+
  84. | customer_id | int(9) |
  85. | id | int(9) |
  86. | orders_id | int(9) |
  87. | prefix | char(1) |
  88. | reward_poiont | int(9) |
  89. +---------------+---------+
  90.  
  91. Database: angioprod
  92. Table: wdb_sessions
  93. [3 columns]
  94. +--------------+------------------+
  95. | Column | Type |
  96. +--------------+------------------+
  97. | value | text |
  98. | expiry | int(11) unsigned |
  99. | sessions_key | varchar(32) |
  100. +--------------+------------------+
  101.  
  102. Database: angioprod
  103. Table: wdb_reviews_description
  104. [5 columns]
  105. +--------------+----------+
  106. | Column | Type |
  107. +--------------+----------+
  108. | languages_id | int(9) |
  109. | reply_date | datetime |
  110. | reply_text | text |
  111. | reviews_id | int(9) |
  112. | reviews_text | text |
  113. +--------------+----------+
  114.  
  115. Database: angioprod
  116. Table: wdb_specials
  117. [7 columns]
  118. +------------------------+---------------+
  119. | Column | Type |
  120. +------------------------+---------------+
  121. | enabled | tinyint(1) |
  122. | expirydate | datetime |
  123. | products_id | int(9) |
  124. | specials_date_add | datetime |
  125. | specials_id | int(9) |
  126. | specials_last_modified | datetime |
  127. | specials_new_price | decimal(10,2) |
  128. +------------------------+---------------+
  129.  
  130. Database: angioprod
  131. Table: wdb_seo_tag
  132. [7 columns]
  133. +---------------------+--------------+
  134. | Column | Type |
  135. +---------------------+--------------+
  136. | languages_id | int(9) |
  137. | misc_id | int(9) |
  138. | seo_tag_description | text |
  139. | seo_tag_id | int(9) |
  140. | seo_tag_keyword | varchar(255) |
  141. | seo_tag_title | varchar(255) |
  142. | url | varchar(128) |
  143. +---------------------+--------------+
  144.  
  145. Database: angioprod
  146. Table: wdb_newsletter_register
  147. [3 columns]
  148. +------------------------+----------+
  149. | Column | Type |
  150. +------------------------+----------+
  151. | email_address | text |
  152. | newsletter_register_id | int(9) |
  153. | signupdate | datetime |
  154. +------------------------+----------+
  155.  
  156. Database: angioprod
  157. Table: wdb_related_publications
  158. [3 columns]
  159. +----------------+---------+
  160. | Column | Type |
  161. +----------------+---------+
  162. | products_id | int(11) |
  163. | publication_id | int(11) |
  164. | sort_order | int(11) |
  165. +----------------+---------+
  166.  
  167. Database: angioprod
  168. Table: wdb_information
  169. [11 columns]
  170. +------------------+-------------+
  171. | Column | Type |
  172. +------------------+-------------+
  173. | enabled | tinyint(1) |
  174. | infor_brief | text |
  175. | information_id | int(9) |
  176. | information_name | varchar(64) |
  177. | information_text | text |
  178. | is_leafage | tinyint(1) |
  179. | languages_id | int(9) |
  180. | parent_id | int(11) |
  181. | show_title | tinyint(1) |
  182. | sort_order | int(5) |
  183. | tree_level | tinyint(2) |
  184. +------------------+-------------+
  185.  
  186. Database: angioprod
  187. Table: wdb_menu
  188. [7 columns]
  189. +----------------+--------------+
  190. | Column | Type |
  191. +----------------+--------------+
  192. | menu_id | int(11) |
  193. | menu_image | varchar(64) |
  194. | menu_title | varchar(64) |
  195. | menu_toolbar | text |
  196. | menu_url | varchar(255) |
  197. | parent_menu_id | int(11) |
  198. | sort_order | int(5) |
  199. +----------------+--------------+
  200.  
  201. Database: angioprod
  202. Table: wdb_layout
  203. [4 columns]
  204. +---------------------------+--------------+
  205. | Column | Type |
  206. +---------------------------+--------------+
  207. | direction_id | int(5) |
  208. | direction_title | varchar(64) |
  209. | layout_installed_box_html | varchar(255) |
  210. | pages_id | int(5) |
  211. +---------------------------+--------------+
  212.  
  213. Database: angioprod
  214. Table: wdb_orders_total
  215. [7 columns]
  216. +-----------------+---------------+
  217. | Column | Type |
  218. +-----------------+---------------+
  219. | value | decimal(15,4) |
  220. | class | varchar(32) |
  221. | orders_id | int(9) |
  222. | orders_total_id | int(11) |
  223. | sort_order | int(5) |
  224. | text | varchar(255) |
  225. | title | varchar(255) |
  226. +-----------------+---------------+
  227.  
  228. Database: angioprod
  229. Table: wdb_orders
  230. [62 columns]
  231. +----------------------------+---------------+
  232. | Column | Type |
  233. +----------------------------+---------------+
  234. | billing_address_format_id | int(9) |
  235. | billing_city | varchar(32) |
  236. | billing_company | varchar(32) |
  237. | billing_country | varchar(64) |
  238. | billing_name | varchar(32) |
  239. | billing_postcode | varchar(10) |
  240. | billing_state | varchar(32) |
  241. | billing_street_address | varchar(64) |
  242. | billing_street_address2 | varchar(64) |
  243. | billing_suburb | varchar(32) |
  244. | currency | varchar(3) |
  245. | currency_value | decimal(14,6) |
  246. | customer_address_format_id | int(9) |
  247. | customer_city | varchar(32) |
  248. | customer_company | varchar(32) |
  249. | customer_country | varchar(64) |
  250. | customer_email_address | varchar(96) |
  251. | customer_firstname | varchar(32) |
  252. | customer_id | int(9) |
  253. | customer_idno | varchar(32) |
  254. | customer_lastname | varchar(32) |
  255. | customer_name | varchar(32) |
  256. | customer_postcode | varchar(10) |
  257. | customer_state | varchar(32) |
  258. | customer_street_address | varchar(64) |
  259. | customer_street_address2 | varchar(64) |
  260. | customer_suburb | varchar(32) |
  261. | customer_telephone | varchar(32) |
  262. | delivery_address_format_id | int(9) |
  263. | delivery_city | varchar(32) |
  264. | delivery_company | varchar(32) |
  265. | delivery_country | varchar(64) |
  266. | delivery_name | varchar(32) |
  267. | delivery_postcode | varchar(10) |
  268. | delivery_state | varchar(32) |
  269. | delivery_street_address | varchar(64) |
  270. | delivery_street_address2 | varchar(64) |
  271. | delivery_suburb | varchar(32) |
  272. | last_modified | datetime |
  273. | orders_cc_cvv2 | varchar(4) |
  274. | orders_cc_expires | varchar(4) |
  275. | orders_cc_number | varchar(32) |
  276. | orders_cc_owner | varchar(64) |
  277. | orders_cc_type | varchar(20) |
  278. | orders_date_finished | datetime |
  279. | orders_date_purchased | datetime |
  280. | orders_deliverynote | text |
  281. | orders_id | int(9) |
  282. | orders_invoiced | datetime |
  283. | orders_last_modified | datetime |
  284. | orders_note | text |
  285. | orders_payment_method | varchar(32) |
  286. | orders_point | float |
  287. | orders_rma | varchar(128) |
  288. | orders_shipped | datetime |
  289. | orders_shipping_cost | decimal(15,4) |
  290. | orders_status_id | int(9) |
  291. | orders_tax | decimal(15,4) |
  292. | orders_total | decimal(15,4) |
  293. | orders_trackingnumber | varchar(128) |
  294. | orders_type | tinyint(4) |
  295. | paid_order | int(9) |
  296. +----------------------------+---------------+
  297.  
  298. Database: angioprod
  299. Table: wdb_roles_to_menu
  300. [2 columns]
  301. +----------+---------+
  302. | Column | Type |
  303. +----------+---------+
  304. | menu_id | int(11) |
  305. | roles_id | int(9) |
  306. +----------+---------+
  307.  
  308. Database: angioprod
  309. Table: wdb_elements
  310. [7 columns]
  311. +-------------------------+-------------+
  312. | Column | Type |
  313. +-------------------------+-------------+
  314. | elements_class | varchar(36) |
  315. | elements_deploy_enabled | tinyint(4) |
  316. | elements_descripition | text |
  317. | elements_id | int(9) |
  318. | elements_owner | varchar(3) |
  319. | elements_title | varchar(64) |
  320. | elements_type | varchar(10) |
  321. +-------------------------+-------------+
  322.  
  323. Database: angioprod
  324. Table: wdb_options
  325. [5 columns]
  326. +---------------+-------------+
  327. | Column | Type |
  328. +---------------+-------------+
  329. | languages_id | int(9) |
  330. | options_id | int(9) |
  331. | options_name | varchar(64) |
  332. | options_style | tinyint(1) |
  333. | sort_order | int(5) |
  334. +---------------+-------------+
  335.  
  336. Database: angioprod
  337. Table: wdb_products_package
  338. [10 columns]
  339. +--------------------+--------------+
  340. | Column | Type |
  341. +--------------------+--------------+
  342. | netweight | decimal(5,2) |
  343. | package_code | varchar(32) |
  344. | package_height | decimal(5,2) |
  345. | package_id | int(9) |
  346. | package_length | decimal(5,2) |
  347. | package_name | varchar(64) |
  348. | package_width | decimal(5,2) |
  349. | percase_qty | int(11) |
  350. | product_package_id | int(9) |
  351. | products_id | int(9) |
  352. +--------------------+--------------+
  353.  
  354. Database: angioprod
  355. Table: wdb_brand
  356. [5 columns]
  357. +------------------+--------------+
  358. | Column | Type |
  359. +------------------+--------------+
  360. | brand_enable | tinyint(1) |
  361. | brand_id | int(9) |
  362. | brand_image | varchar(128) |
  363. | brand_title | varchar(36) |
  364. | manufacturers_id | int(9) |
  365. +------------------+--------------+
  366.  
  367. Database: angioprod
  368. Table: wdb_pw_config
  369. [3 columns]
  370. +----------+-------------+
  371. | Column | Type |
  372. +----------+-------------+
  373. | db_name | varchar(30) |
  374. | db_value | text |
  375. | decrip | text |
  376. +----------+-------------+
  377.  
  378. Database: angioprod
  379. Table: wdb_customers_wishlist_attributes
  380. [5 columns]
  381. +--------------------------------+----------+
  382. | Column | Type |
  383. +--------------------------------+----------+
  384. | customer_id | int(9) |
  385. | customers_basket_attributes_id | int(9) |
  386. | options_id | int(9) |
  387. | options_values_id | int(9) |
  388. | products_id | tinytext |
  389. +--------------------------------+----------+
  390.  
  391. Database: angioprod
  392. Table: wdb_options_values
  393. [4 columns]
  394. +---------------------+-------------+
  395. | Column | Type |
  396. +---------------------+-------------+
  397. | languages_id | int(9) |
  398. | options_values_id | int(9) |
  399. | options_values_name | varchar(64) |
  400. | sort_order | int(5) |
  401. +---------------------+-------------+
  402.  
  403. Database: angioprod
  404. Table: wdb_shipping_methods
  405. [7 columns]
  406. +---------------------+-------------+
  407. | Column | Type |
  408. +---------------------+-------------+
  409. | code | varchar(32) |
  410. | description | varchar(64) |
  411. | enabled | tinyint(1) |
  412. | name | varchar(64) |
  413. | shipping_methods_id | int(9) |
  414. | sort_order | int(5) |
  415. | type | varchar(20) |
  416. +---------------------+-------------+
  417.  
  418. Database: angioprod
  419. Table: wdb_gallery_images_extend
  420. [6 columns]
  421. +---------------------------+-------------+
  422. | Column | Type |
  423. +---------------------------+-------------+
  424. | products_bimage | varchar(64) |
  425. | products_id | int(9) |
  426. | products_image | varchar(64) |
  427. | products_images_extend_id | int(9) |
  428. | products_thumbnail | varchar(64) |
  429. | sort_order | int(5) |
  430. +---------------------------+-------------+
  431.  
  432. Database: angioprod
  433. Table: wdb_publication
  434. [9 columns]
  435. +---------------------+--------------+
  436. | Column | Type |
  437. +---------------------+--------------+
  438. | create_time | timestamp |
  439. | enabled | tinyint(1) |
  440. | languages_id | int(9) |
  441. | link_to | text |
  442. | publication_content | varchar(255) |
  443. | publication_id | int(9) |
  444. | publication_name | varchar(64) |
  445. | show_title | tinyint(1) |
  446. | sort_order | int(5) |
  447. +---------------------+--------------+
  448.  
  449. Database: angioprod
  450. Table: wdb_products_images_extend
  451. [6 columns]
  452. +---------------------------+-------------+
  453. | Column | Type |
  454. +---------------------------+-------------+
  455. | products_bimage | varchar(64) |
  456. | products_id | int(9) |
  457. | products_image | varchar(64) |
  458. | products_images_extend_id | int(9) |
  459. | products_thumbnail | varchar(64) |
  460. | sort_order | int(5) |
  461. +---------------------------+-------------+
  462.  
  463. Database: angioprod
  464. Table: wdb_options_to_options_values
  465. [2 columns]
  466. +-------------------+--------+
  467. | Column | Type |
  468. +-------------------+--------+
  469. | options_id | int(9) |
  470. | options_values_id | int(9) |
  471. +-------------------+--------+
  472.  
  473. Database: angioprod
  474. Table: wdb_rewards_rule
  475. [6 columns]
  476. +--------------------------+-------------+
  477. | Column | Type |
  478. +--------------------------+-------------+
  479. | rewards_rule_code | varchar(32) |
  480. | rewards_rule_description | text |
  481. | rewards_rule_expire | datetime |
  482. | rewards_rule_id | int(11) |
  483. | rewards_rule_points | tinyint(4) |
  484. | rewards_rule_start | datetime |
  485. +--------------------------+-------------+
  486.  
  487. Database: angioprod
  488. Table: wdb_configuration
  489. [13 columns]
  490. +---------------------------+--------------+
  491. | Column | Type |
  492. +---------------------------+--------------+
  493. | configuration_description | varchar(255) |
  494. | configuration_group_id | int(11) |
  495. | configuration_id | int(9) |
  496. | configuration_key | varchar(128) |
  497. | configuration_key_text | varchar(128) |
  498. | configuration_tag | varchar(64) |
  499. | configuration_title | varchar(64) |
  500. | configuration_value | varchar(255) |
  501. | date_added | datetime |
  502. | last_modified | datetime |
  503. | set_function | varchar(255) |
  504. | sort_order | int(5) |
  505. | use_function | varchar(255) |
  506. +---------------------------+--------------+
  507.  
  508. Database: angioprod
  509. Table: wdb_orders_products
  510. [15 columns]
  511. +--------------------+---------------+
  512. | Column | Type |
  513. +--------------------+---------------+
  514. | final_price | decimal(15,4) |
  515. | orders_id | int(9) |
  516. | orders_products_id | int(11) |
  517. | orders_shipped | datetime |
  518. | package_code | varchar(32) |
  519. | package_price | decimal(15,4) |
  520. | package_quantity | int(11) |
  521. | product_package_id | int(9) |
  522. | products_id | int(9) |
  523. | products_model | varchar(24) |
  524. | products_name | varchar(64) |
  525. | products_price | decimal(15,4) |
  526. | products_quantity | int(11) |
  527. | products_sku_code | varchar(64) |
  528. | products_tax | decimal(7,4) |
  529. +--------------------+---------------+
  530.  
  531. Database: angioprod
  532. Table: wdb_product_prices_customer_type
  533. [3 columns]
  534. +------------------+---------------+
  535. | Column | Type |
  536. +------------------+---------------+
  537. | customer_type_id | int(11) |
  538. | prices | decimal(11,2) |
  539. | products_id | int(11) |
  540. +------------------+---------------+
  541.  
  542. Database: angioprod
  543. Table: wdb_coupons
  544. [17 columns]
  545. +-----------------------+---------------+
  546. | Column | Type |
  547. +-----------------------+---------------+
  548. | coupons_active | tinyint(4) |
  549. | coupons_amount | float(8,4) |
  550. | coupons_application | tinyint(4) |
  551. | coupons_code | varchar(32) |
  552. | coupons_customerlimit | int(11) |
  553. | coupons_description | text |
  554. | coupons_expire | datetime |
  555. | coupons_id | int(11) |
  556. | coupons_images | varchar(64) |
  557. | coupons_restrict | varchar(64) |
  558. | coupons_rule_id | int(11) |
  559. | coupons_start | datetime |
  560. | coupons_threshold | decimal(15,4) |
  561. | coupons_type | tinyint(4) |
  562. | coupons_uselimit | int(11) |
  563. | date_create | datetime |
  564. | date_modify | datetime |
  565. +-----------------------+---------------+
  566.  
  567. Database: angioprod
  568. Table: wdb_gifts
  569. [15 columns]
  570. +----------------+-------------+
  571. | Column | Type |
  572. +----------------+-------------+
  573. | customer_id | int(9) |
  574. | email_address | varchar(96) |
  575. | first_name | varchar(32) |
  576. | gifts_active | tinyint(4) |
  577. | gifts_code | varchar(32) |
  578. | gifts_comm | text |
  579. | gifts_create | datetime |
  580. | gifts_expire | datetime |
  581. | gifts_id | int(11) |
  582. | gifts_password | varchar(40) |
  583. | gifts_start | datetime |
  584. | gifts_values | float(8,4) |
  585. | last_name | varchar(32) |
  586. | orders_id | int(9) |
  587. | receiver_name | varchar(64) |
  588. +----------------+-------------+
  589.  
  590. Database: angioprod
  591. Table: wdb_customer_rewards
  592. [6 columns]
  593. +---------------------+----------+
  594. | Column | Type |
  595. +---------------------+----------+
  596. | coupon_amount | int(9) |
  597. | coupons_id | int(11) |
  598. | coupons_rule_id | int(9) |
  599. | customer_id | int(9) |
  600. | customer_rewards_id | int(11) |
  601. | date_create | datetime |
  602. +---------------------+----------+
  603.  
  604. Database: angioprod
  605. Table: wdb_meetings
  606. [10 columns]
  607. +-------------------+--------------+
  608. | Column | Type |
  609. +-------------------+--------------+
  610. | create_time | timestamp |
  611. | enabled | tinyint(1) |
  612. | languages_id | int(9) |
  613. | meetings_content | text |
  614. | meetings_id | int(9) |
  615. | meetings_location | varchar(255) |
  616. | meetings_name | varchar(64) |
  617. | meetings_time | datetime |
  618. | show_title | tinyint(1) |
  619. | sort_order | int(5) |
  620. +-------------------+--------------+
  621.  
  622. Database: angioprod
  623. Table: wdb_integrateim
  624. [6 columns]
  625. +-------------------------+------------------+
  626. | Column | Type |
  627. +-------------------------+------------------+
  628. | integrateim_account | varchar(128) |
  629. | integrateim_description | varchar(255) |
  630. | integrateim_id | int(11) unsigned |
  631. | integrateim_type | varchar(128) |
  632. | last_modify_date | date |
  633. | sort_order | tinyint(2) |
  634. +-------------------------+------------------+
  635.  
  636. Database: angioprod
  637. Table: wdb_categories_description
  638. [6 columns]
  639. +-------------------------+--------------+
  640. | Column | Type |
  641. +-------------------------+--------------+
  642. | categories_barimage | varchar(64) |
  643. | categories_barimageover | varchar(64) |
  644. | categories_id | int(9) |
  645. | categories_title | varchar(255) |
  646. | description | text |
  647. | languages_id | int(9) |
  648. +-------------------------+--------------+
  649.  
  650. Database: angioprod
  651. Table: wdb_slideshows
  652. [8 columns]
  653. +-----------------+--------------+
  654. | Column | Type |
  655. +-----------------+--------------+
  656. | create_time | timestamp |
  657. | enabled | tinyint(1) |
  658. | languages_id | int(9) |
  659. | show_title | tinyint(1) |
  660. | slideshows_id | int(9) |
  661. | slideshows_name | varchar(64) |
  662. | slideshows_url | varchar(255) |
  663. | sort_order | int(5) |
  664. +-----------------+--------------+
  665.  
  666. Database: angioprod
  667. Table: wdb_layout_item
  668. [8 columns]
  669. +------------------+--------------+
  670. | Column | Type |
  671. +------------------+--------------+
  672. | parameter | varchar(255) |
  673. | direction_id | int(5) |
  674. | freebox_id | int(5) |
  675. | layout_item_box | varchar(64) |
  676. | layout_item_id | int(9) |
  677. | layout_item_type | tinyint(1) |
  678. | page_id | int(5) |
  679. | sort_order | int(5) |
  680. +------------------+--------------+
  681.  
  682. Database: angioprod
  683. Table: wdb_orders_status
  684. [3 columns]
  685. +--------------------+-------------+
  686. | Column | Type |
  687. +--------------------+-------------+
  688. | languages_id | int(9) |
  689. | orders_status_id | int(9) |
  690. | orders_status_name | varchar(24) |
  691. +--------------------+-------------+
  692.  
  693. Database: angioprod
  694. Table: wdb_page
  695. [5 columns]
  696. +--------------+--------------+
  697. | Column | Type |
  698. +--------------+--------------+
  699. | page_comment | varchar(255) |
  700. | page_id | int(5) |
  701. | page_key | varchar(32) |
  702. | page_path | varchar(255) |
  703. | page_title | varchar(64) |
  704. +--------------+--------------+
  705.  
  706. Database: angioprod
  707. Table: wdb_products_to_categories
  708. [2 columns]
  709. +---------------+--------+
  710. | Column | Type |
  711. +---------------+--------+
  712. | categories_id | int(9) |
  713. | products_id | int(9) |
  714. +---------------+--------+
  715.  
  716. Database: angioprod
  717. Table: wdb_packages
  718. [9 columns]
  719. +----------------+--------------+
  720. | Column | Type |
  721. +----------------+--------------+
  722. | netweight | decimal(5,2) |
  723. | package_code | varchar(32) |
  724. | package_height | decimal(5,2) |
  725. | package_id | int(9) |
  726. | package_length | decimal(5,2) |
  727. | package_name | varchar(64) |
  728. | package_width | decimal(5,2) |
  729. | percase_qty | int(11) |
  730. | sort_order | int(5) |
  731. +----------------+--------------+
  732.  
  733. Database: angioprod
  734. Table: wdb_news
  735. [11 columns]
  736. +----------------------+--------------+
  737. | Column | Type |
  738. +----------------------+--------------+
  739. | create_time | timestamp |
  740. | enabled | tinyint(1) |
  741. | languages_id | int(9) |
  742. | news_id | int(9) |
  743. | news_meta_desc | varchar(255) |
  744. | news_meta_keyword | varchar(255) |
  745. | news_name | varchar(64) |
  746. | news_static_php_name | varchar(128) |
  747. | news_text | text |
  748. | show_title | tinyint(1) |
  749. | sort_order | int(5) |
  750. +----------------------+--------------+
  751.  
  752. Database: angioprod
  753. Table: wdb_cart_product_assembled_options
  754. [5 columns]
  755. +-----------------------------------+---------+
  756. | Column | Type |
  757. +-----------------------------------+---------+
  758. | cart_product_assembled_options_id | int(9) |
  759. | options_id | int(9) |
  760. | options_values_id | int(9) |
  761. | product_assembled_id | int(11) |
  762. | product_id | int(11) |
  763. +-----------------------------------+---------+
  764.  
  765. Database: angioprod
  766. Table: wdb_reviews
  767. [11 columns]
  768. +----------------+-------------+
  769. | Column | Type |
  770. +----------------+-------------+
  771. | customer_id | int(9) |
  772. | customer_name | varchar(32) |
  773. | date_added | datetime |
  774. | email_address | varchar(96) |
  775. | is_enabled | tinyint(1) |
  776. | lastmodify | datetime |
  777. | products_id | int(9) |
  778. | reviews_id | int(9) |
  779. | reviews_rating | tinyint(4) |
  780. | reviews_read | int(9) |
  781. | telephone | varchar(32) |
  782. +----------------+-------------+
  783.  
  784. Database: angioprod
  785. Table: wdb_city
  786. [4 columns]
  787. +-----------+-------------+
  788. | Column | Type |
  789. +-----------+-------------+
  790. | city_code | varchar(32) |
  791. | city_id | int(9) |
  792. | city_name | varchar(32) |
  793. | zones_id | int(9) |
  794. +-----------+-------------+
  795.  
  796. Database: angioprod
  797. Table: wdb_customers_basket
  798. [8 columns]
  799. +-----------------------------+---------------+
  800. | Column | Type |
  801. +-----------------------------+---------------+
  802. | customer_id | int(9) |
  803. | customers_basket_date_added | varchar(8) |
  804. | customers_basket_id | int(9) |
  805. | customers_basket_quantity | int(2) |
  806. | final_price | decimal(15,4) |
  807. | orders_shipped | datetime |
  808. | product_package_id | int(9) |
  809. | products_id | tinytext |
  810. +-----------------------------+---------------+
  811.  
  812. Database: angioprod
  813. Table: wdb_direction
  814. [2 columns]
  815. +-----------------+-------------+
  816. | Column | Type |
  817. +-----------------+-------------+
  818. | direction_id | int(5) |
  819. | direction_title | varchar(64) |
  820. +-----------------+-------------+
  821.  
  822. Database: angioprod
  823. Table: wdb_suppliers_to_orders
  824. [2 columns]
  825. +--------------+--------+
  826. | Column | Type |
  827. +--------------+--------+
  828. | orders_id | int(9) |
  829. | suppliers_id | int(9) |
  830. +--------------+--------+
  831.  
  832. Database: angioprod
  833. Table: wdb_retailer_app_form
  834. [53 columns]
  835. +----------------------+--------------+
  836. | Column | Type |
  837. +----------------------+--------------+
  838. | app_first_name | varchar(32) |
  839. | app_form_date | timestamp |
  840. | app_last_name | varchar(32) |
  841. | app_title | varchar(32) |
  842. | authorized_signature | varchar(64) |
  843. | authorized_title | varchar(32) |
  844. | bank_account | varchar(64) |
  845. | bank_addr | varchar(128) |
  846. | bank_city | varchar(64) |
  847. | bank_country | int(9) |
  848. | bank_fax | varchar(32) |
  849. | bank_name | varchar(64) |
  850. | bank_phone | varchar(32) |
  851. | bank_zip | varchar(10) |
  852. | bank_zone_id | int(9) |
  853. | company_address | varchar(128) |
  854. | company_address2 | varchar(128) |
  855. | company_city | varchar(32) |
  856. | company_countries_id | int(9) |
  857. | company_email | varchar(100) |
  858. | company_fax | varchar(32) |
  859. | company_name | varchar(64) |
  860. | company_phone | varchar(32) |
  861. | company_state | int(9) |
  862. | company_zipcode | varchar(10) |
  863. | customer_id | int(9) |
  864. | dba | varchar(32) |
  865. | if_accept | tinyint(1) |
  866. | main_business | varchar(255) |
  867. | organization_type | varchar(120) |
  868. | period | varchar(50) |
  869. | prin_addr | varchar(128) |
  870. | prin_city | varchar(64) |
  871. | prin_country | int(9) |
  872. | prin_fax | varchar(32) |
  873. | prin_name | varchar(64) |
  874. | prin_phone | varchar(32) |
  875. | prin_social | varchar(64) |
  876. | prin_zip | varchar(10) |
  877. | prin_zone_id | int(9) |
  878. | retailer_app_form_id | int(11) |
  879. | sales_permit_no | varchar(50) |
  880. | trad_account | varchar(64) |
  881. | trad_addr | varchar(128) |
  882. | trad_city | varchar(32) |
  883. | trad_company | varchar(128) |
  884. | trad_country | int(9) |
  885. | trad_email | varchar(64) |
  886. | trad_fax | varchar(32) |
  887. | trad_name | varchar(64) |
  888. | trad_pay | varchar(64) |
  889. | trad_zip | varchar(10) |
  890. | trad_zone_id | int(9) |
  891. +----------------------+--------------+
  892.  
  893. Database: angioprod
  894. Table: wdb_users
  895. [6 columns]
  896. +----------------+-------------+
  897. | Column | Type |
  898. +----------------+-------------+
  899. | roles_id | int(9) |
  900. | users_email | varchar(64) |
  901. | users_id | int(9) |
  902. | users_name | varchar(32) |
  903. | users_password | varchar(32) |
  904. | users_status | tinyint(1) |
  905. +----------------+-------------+
  906.  
  907. Database: angioprod
  908. Table: wdb_suppliers
  909. [12 columns]
  910. +----------------+--------------+
  911. | Column | Type |
  912. +----------------+--------------+
  913. | address | varchar(64) |
  914. | city | varchar(64) |
  915. | countries_id | int(9) |
  916. | email | varchar(96) |
  917. | fax | varchar(25) |
  918. | phone | varchar(25) |
  919. | postal_code | varchar(32) |
  920. | state | varchar(64) |
  921. | suppliers_id | int(9) |
  922. | suppliers_name | varchar(64) |
  923. | url | varchar(250) |
  924. | zones_id | int(9) |
  925. +----------------+--------------+
  926.  
  927. Database: angioprod
  928. Table: wdb_tag
  929. [4 columns]
  930. +-------------+--------------+
  931. | Column | Type |
  932. +-------------+--------------+
  933. | is_inner | tinyint(4) |
  934. | tag_content | text |
  935. | tag_name | varchar(64) |
  936. | tag_path | varchar(255) |
  937. +-------------+--------------+
  938.  
  939. Database: angioprod
  940. Table: wdb_menu_description
  941. [4 columns]
  942. +--------------+--------------+
  943. | Column | Type |
  944. +--------------+--------------+
  945. | description | varchar(255) |
  946. | languages_id | int(9) |
  947. | menu_id | int(9) |
  948. | menu_title | varchar(64) |
  949. +--------------+--------------+
  950.  
  951. Database: angioprod
  952. Table: wdb_customers_wishlist
  953. [8 columns]
  954. +-----------------------------+---------------+
  955. | Column | Type |
  956. +-----------------------------+---------------+
  957. | customer_id | int(9) |
  958. | customers_basket_date_added | varchar(8) |
  959. | customers_basket_id | int(9) |
  960. | customers_basket_quantity | int(2) |
  961. | final_price | decimal(15,4) |
  962. | orders_shipped | datetime |
  963. | product_package_id | int(9) |
  964. | products_id | tinytext |
  965. +-----------------------------+---------------+
  966.  
  967. Database: angioprod
  968. Table: wdb_gallery_description
  969. [9 columns]
  970. +-------------------------------+--------------+
  971. | Column | Type |
  972. +-------------------------------+--------------+
  973. | languages_id | int(9) |
  974. | products_description | text |
  975. | products_id | int(9) |
  976. | products_meta_tag_keyword | varchar(250) |
  977. | products_name | varchar(64) |
  978. | products_shortdescription | text |
  979. | products_thumbnaildescription | text |
  980. | products_url | varchar(128) |
  981. | products_viewed | int(6) |
  982. +-------------------------------+--------------+
  983.  
  984. Database: angioprod
  985. Table: wdb_manufacturers
  986. [13 columns]
  987. +---------------------+--------------+
  988. | Column | Type |
  989. +---------------------+--------------+
  990. | address | varchar(64) |
  991. | city | varchar(64) |
  992. | country | int(11) |
  993. | email | varchar(96) |
  994. | enabled | tinyint(1) |
  995. | fax | varchar(25) |
  996. | manufacturers_id | int(9) |
  997. | manufacturers_image | varchar(128) |
  998. | manufacturers_name | varchar(32) |
  999. | phone | varchar(25) |
  1000. | postal_code | varchar(32) |
  1001. | state | varchar(64) |
  1002. | url | varchar(250) |
  1003. +---------------------+--------------+
  1004.  
  1005. Database: angioprod
  1006. Table: wdb_orders_products_attributes
  1007. [5 columns]
  1008. +-------------------------------+-------------+
  1009. | Column | Type |
  1010. +-------------------------------+-------------+
  1011. | options_name | varchar(64) |
  1012. | options_values_name | varchar(64) |
  1013. | orders_id | int(9) |
  1014. | orders_products_attributes_id | int(11) |
  1015. | orders_products_id | int(11) |
  1016. +-------------------------------+-------------+
  1017.  
  1018. Database: angioprod
  1019. Table: wdb_zones_to_geo_zones
  1020. [6 columns]
  1021. +--------------------+----------+
  1022. | Column | Type |
  1023. +--------------------+----------+
  1024. | association_id | int(9) |
  1025. | date_added | datetime |
  1026. | geo_zones_id | int(9) |
  1027. | last_modified | datetime |
  1028. | zones_countries_id | int(9) |
  1029. | zones_id | int(9) |
  1030. +--------------------+----------+
  1031.  
  1032. Database: angioprod
  1033. Table: wdb_ad
  1034. [15 columns]
  1035. +--------------+--------------+
  1036. | Column | Type |
  1037. +--------------+--------------+
  1038. | ad_content | text |
  1039. | ad_id | int(9) |
  1040. | ad_name | varchar(255) |
  1041. | ad_type | varchar(32) |
  1042. | coordinate_x | int(9) |
  1043. | coordinate_y | int(9) |
  1044. | date_from | datetime |
  1045. | date_to | datetime |
  1046. | enabled | tinyint(1) |
  1047. | languages_id | int(9) |
  1048. | pop_type | varchar(32) |
  1049. | pop_url | varchar(255) |
  1050. | size_h | int(9) |
  1051. | size_w | int(9) |
  1052. | sort_order | int(9) |
  1053. +--------------+--------------+
  1054.  
  1055. Database: angioprod
  1056. Table: wdb_products_sku
  1057. [8 columns]
  1058. +-----------------------+---------------+
  1059. | Column | Type |
  1060. +-----------------------+---------------+
  1061. | enabled | tinyint(1) |
  1062. | is_default | tinyint(1) |
  1063. | products_id | int(9) |
  1064. | products_sku_code | varchar(64) |
  1065. | products_sku_name | varchar(32) |
  1066. | products_sku_price | decimal(10,2) |
  1067. | products_sku_quantity | int(11) |
  1068. | products_sku_weight | decimal(10,2) |
  1069. +-----------------------+---------------+
  1070.  
  1071. Database: angioprod
  1072. Table: wdb_redeem_track
  1073. [8 columns]
  1074. +-------------------+-------------+
  1075. | Column | Type |
  1076. +-------------------+-------------+
  1077. | coupons_id | int(11) |
  1078. | customer_id | int(9) |
  1079. | gifts_id | int(11) |
  1080. | gifts_spent | float(8,4) |
  1081. | orders_id | int(9) |
  1082. | redeem_track_date | datetime |
  1083. | redeem_track_id | int(11) |
  1084. | redeem_track_ip | varchar(20) |
  1085. +-------------------+-------------+
  1086.  
  1087. Database: angioprod
  1088. Table: wdb_freebox
  1089. [4 columns]
  1090. +------------------+--------------+
  1091. | Column | Type |
  1092. +------------------+--------------+
  1093. | freebox_filename | varchar(128) |
  1094. | freebox_id | int(5) |
  1095. | freebox_key | varchar(64) |
  1096. | freebox_title | varchar(64) |
  1097. +------------------+--------------+
  1098.  
  1099. Database: angioprod
  1100. Table: wdb_banner_images
  1101. [7 columns]
  1102. +------------------+---------------+
  1103. | Column | Type |
  1104. +------------------+---------------+
  1105. | banner_images_id | int(11) |
  1106. | banner_position | int(11) |
  1107. | banner_url | varchar(255) |
  1108. | image_name | varchar(64) |
  1109. | images | varchar(100) |
  1110. | languages_id | int(11) |
  1111. | status | enum('Y','N') |
  1112. +------------------+---------------+
  1113.  
  1114. Database: angioprod
  1115. Table: wdb_geo_zones
  1116. [5 columns]
  1117. +-----------------------+--------------+
  1118. | Column | Type |
  1119. +-----------------------+--------------+
  1120. | date_added | datetime |
  1121. | geo_zones_description | varchar(255) |
  1122. | geo_zones_id | int(9) |
  1123. | geo_zones_name | varchar(32) |
  1124. | last_modify | datetime |
  1125. +-----------------------+--------------+
  1126.  
  1127. Database: angioprod
  1128. Table: wdb_products
  1129. [44 columns]
  1130. +-------------------------------+---------------+
  1131. | Column | Type |
  1132. +-------------------------------+---------------+
  1133. | brand_id | int(9) |
  1134. | is_customed | tinyint(1) |
  1135. | is_enabled | int(5) |
  1136. | manufacturers_id | int(9) |
  1137. | package_style | tinyint(1) |
  1138. | product_prices_byquantity | varchar(64) |
  1139. | products_application | varchar(64) |
  1140. | products_base_price | decimal(15,4) |
  1141. | products_bimage | varchar(64) |
  1142. | products_date_added | datetime |
  1143. | products_date_avaiable | datetime |
  1144. | products_featured_expirydate | datetime |
  1145. | products_height | decimal(5,2) |
  1146. | products_host | varchar(20) |
  1147. | products_id | int(9) |
  1148. | products_image | varchar(64) |
  1149. | products_inventerylevel | int(11) |
  1150. | products_isbn | varchar(20) |
  1151. | products_isfeatured | tinyint(4) |
  1152. | products_isnew | tinyint(4) |
  1153. | products_isspotlight | tinyint(4) |
  1154. | products_keys | varchar(255) |
  1155. | products_last_modified | datetime |
  1156. | products_length | decimal(5,2) |
  1157. | products_model | varchar(24) |
  1158. | products_price | decimal(15,4) |
  1159. | products_pricelevel | int(11) |
  1160. | products_qtyonorder | int(11) |
  1161. | products_quantity | int(11) |
  1162. | products_reactivity | varchar(20) |
  1163. | products_show_to_url | varchar(128) |
  1164. | products_spotlight_expirydate | datetime |
  1165. | products_spotlight_price | decimal(15,4) |
  1166. | products_status | tinyint(1) |
  1167. | products_thumbnail | varchar(64) |
  1168. | products_total_quantity | int(11) |
  1169. | products_upc | varchar(20) |
  1170. | products_weight | varchar(128) |
  1171. | products_weightlevel | tinyint(1) |
  1172. | products_width | decimal(5,2) |
  1173. | seo_filename | varchar(64) |
  1174. | showed_to_customer | varchar(20) |
  1175. | suppliers_id | int(9) |
  1176. | tax_class_id | int(9) |
  1177. +-------------------------------+---------------+
  1178.  
  1179. Database: angioprod
  1180. Table: wdb_products_option
  1181. [6 columns]
  1182. +----------------------+---------------+
  1183. | Column | Type |
  1184. +----------------------+---------------+
  1185. | options_id | int(9) |
  1186. | options_values_id | int(9) |
  1187. | options_values_price | decimal(15,4) |
  1188. | products_id | int(9) |
  1189. | products_option_id | int(9) |
  1190. | sort_order | int(5) |
  1191. +----------------------+---------------+
  1192.  
  1193. Database: angioprod
  1194. Table: wdb_customer
  1195. [25 columns]
  1196. +------------------------------+--------------+
  1197. | Column | Type |
  1198. +------------------------------+--------------+
  1199. | customer_company | varchar(32) |
  1200. | customer_default_address_id | int(9) |
  1201. | customer_discount_rate | decimal(5,2) |
  1202. | customer_dob | datetime |
  1203. | customer_email_address | varchar(96) |
  1204. | customer_fax | varchar(32) |
  1205. | customer_firstname | varchar(32) |
  1206. | customer_gender | char(1) |
  1207. | customer_hearfrom | varchar(32) |
  1208. | customer_id | int(9) |
  1209. | customer_idno | varchar(32) |
  1210. | customer_lastname | varchar(32) |
  1211. | customer_msn | varchar(64) |
  1212. | customer_name | varchar(32) |
  1213. | customer_newsletter | char(1) |
  1214. | customer_password | varchar(40) |
  1215. | customer_qq | varchar(32) |
  1216. | customer_referredby | varchar(96) |
  1217. | customer_reward_points | float |
  1218. | customer_telephone | varchar(32) |
  1219. | customer_type_id | tinyint(9) |
  1220. | guest_flag | tinyint(1) |
  1221. | handingfee_rate | float |
  1222. | rank | tinyint(1) |
  1223. | shiping_billing_address_same | tinyint(1) |
  1224. +------------------------------+--------------+
  1225.  
  1226. Database: angioprod
  1227. Table: wdb_customer_info
  1228. [5 columns]
  1229. +------------------------------------------+----------+
  1230. | Column | Type |
  1231. +------------------------------------------+----------+
  1232. | customer_id | int(9) |
  1233. | customer_info_date_account_created | datetime |
  1234. | customer_info_date_account_last_modified | datetime |
  1235. | customer_info_date_of_last_logon | datetime |
  1236. | customer_number_of_logons | int(5) |
  1237. +------------------------------------------+----------+
  1238.  
  1239. Database: angioprod
  1240. Table: wdb_tax_class
  1241. [5 columns]
  1242. +-----------------------+--------------+
  1243. | Column | Type |
  1244. +-----------------------+--------------+
  1245. | date_added | datetime |
  1246. | last_modified | datetime |
  1247. | tax_class_description | varchar(255) |
  1248. | tax_class_id | int(9) |
  1249. | tax_class_title | varchar(32) |
  1250. +-----------------------+--------------+
  1251.  
  1252. Database: angioprod
  1253. Table: wdb_address_format
  1254. [3 columns]
  1255. +-------------------+--------------+
  1256. | Column | Type |
  1257. +-------------------+--------------+
  1258. | address_format | varchar(128) |
  1259. | address_format_id | int(11) |
  1260. | address_summary | varchar(48) |
  1261. +-------------------+--------------+
  1262.  
  1263. Database: angioprod
  1264. Table: wdb_configuration_group
  1265. [6 columns]
  1266. +---------------------------------+--------------+
  1267. | Column | Type |
  1268. +---------------------------------+--------------+
  1269. | configuration_group_description | varchar(255) |
  1270. | configuration_group_id | int(9) |
  1271. | configuration_group_text | varchar(64) |
  1272. | configuration_group_title | varchar(64) |
  1273. | sort_order | int(11) |
  1274. | visible | int(1) |
  1275. +---------------------------------+--------------+
  1276.  
  1277. Database: angioprod
  1278. Table: wdb_newsletters
  1279. [8 columns]
  1280. +------------------------+--------------+
  1281. | Column | Type |
  1282. +------------------------+--------------+
  1283. | newsletters_content | text |
  1284. | newsletters_date_added | datetime |
  1285. | newsletters_date_sent | datetime |
  1286. | newsletters_id | int(9) |
  1287. | newsletters_locked | int(1) |
  1288. | newsletters_module | varchar(255) |
  1289. | newsletters_status | int(1) |
  1290. | newsletters_title | varchar(255) |
  1291. +------------------------+--------------+
  1292.  
  1293. Database: angioprod
  1294. Table: wdb_keywords
  1295. [5 columns]
  1296. +----------------+--------------+
  1297. | Column | Type |
  1298. +----------------+--------------+
  1299. | kw_id | int(11) |
  1300. | kw_intopsearch | tinyint(1) |
  1301. | kw_name | varchar(64) |
  1302. | kw_priority | int(11) |
  1303. | URL | varchar(255) |
  1304. +----------------+--------------+
  1305.  
  1306. Database: angioprod
  1307. Table: wdb_gallery
  1308. [40 columns]
  1309. +-------------------------------+---------------+
  1310. | Column | Type |
  1311. +-------------------------------+---------------+
  1312. | brand_id | int(9) |
  1313. | is_customed | tinyint(1) |
  1314. | is_enabled | int(5) |
  1315. | manufacturers_id | int(9) |
  1316. | package_style | tinyint(1) |
  1317. | product_prices_byquantity | varchar(64) |
  1318. | products_base_price | decimal(15,4) |
  1319. | products_bimage | varchar(64) |
  1320. | products_date_added | datetime |
  1321. | products_date_avaiable | datetime |
  1322. | products_featured_expirydate | datetime |
  1323. | products_height | decimal(5,2) |
  1324. | products_id | int(9) |
  1325. | products_image | varchar(64) |
  1326. | products_inventerylevel | int(11) |
  1327. | products_isbn | varchar(20) |
  1328. | products_isfeatured | tinyint(4) |
  1329. | products_isnew | tinyint(4) |
  1330. | products_isspotlight | tinyint(4) |
  1331. | products_keys | varchar(255) |
  1332. | products_last_modified | datetime |
  1333. | products_length | decimal(5,2) |
  1334. | products_model | varchar(24) |
  1335. | products_price | decimal(15,4) |
  1336. | products_pricelevel | int(11) |
  1337. | products_qtyonorder | int(11) |
  1338. | products_quantity | int(11) |
  1339. | products_show_to_url | varchar(128) |
  1340. | products_spotlight_expirydate | datetime |
  1341. | products_status | tinyint(1) |
  1342. | products_thumbnail | varchar(64) |
  1343. | products_total_quantity | int(11) |
  1344. | products_upc | varchar(20) |
  1345. | products_weight | decimal(5,2) |
  1346. | products_weightlevel | tinyint(1) |
  1347. | products_width | decimal(5,2) |
  1348. | seo_filename | varchar(64) |
  1349. | showed_to_customer | varchar(20) |
  1350. | suppliers_id | int(9) |
  1351. | tax_class_id | int(9) |
  1352. +-------------------------------+---------------+
  1353.  
  1354. Database: angioprod
  1355. Table: wdb_roles
  1356. [2 columns]
  1357. +------------+-------------+
  1358. | Column | Type |
  1359. +------------+-------------+
  1360. | roles_id | int(9) |
  1361. | roles_name | varchar(32) |
  1362. +------------+-------------+
  1363.  
  1364. Database: angioprod
  1365. Table: wdb_zones
  1366. [4 columns]
  1367. +--------------+-------------+
  1368. | Column | Type |
  1369. +--------------+-------------+
  1370. | countries_id | int(11) |
  1371. | zones_code | varchar(32) |
  1372. | zones_id | int(11) |
  1373. | zones_name | varchar(32) |
  1374. +--------------+-------------+
  1375.  
  1376. Database: angioprod
  1377. Table: wdb_landing_page
  1378. [14 columns]
  1379. +-----------------+--------------+
  1380. | Column | Type |
  1381. +-----------------+--------------+
  1382. | content | text |
  1383. | created | datetime |
  1384. | f1 | text |
  1385. | f2 | varchar(255) |
  1386. | file | varchar(255) |
  1387. | golink | text |
  1388. | id | int(11) |
  1389. | img | text |
  1390. | metadescription | text |
  1391. | metakeyword | text |
  1392. | pagetitle | text |
  1393. | product | text |
  1394. | title | text |
  1395. | updated | datetime |
  1396. +-----------------+--------------+
  1397.  
  1398. Database: angioprod
  1399. Table: wdb_criteria_values
  1400. [4 columns]
  1401. +------------------+--------------+
  1402. | Column | Type |
  1403. +------------------+--------------+
  1404. | value | varchar(255) |
  1405. | criteria_groups | int(9) |
  1406. | criteria_values | int(9) |
  1407. | pcriteria_values | int(9) |
  1408. +------------------+--------------+
  1409.  
  1410. Database: angioprod
  1411. Table: wdb_favorites
  1412. [3 columns]
  1413. +-------------+----------+
  1414. | Column | Type |
  1415. +-------------+----------+
  1416. | customer_id | int(9) |
  1417. | last_modify | datetime |
  1418. | products_id | int(9) |
  1419. +-------------+----------+
  1420.  
  1421. Database: angioprod
  1422. Table: wdb_ad_to_page
  1423. [2 columns]
  1424. +---------+--------+
  1425. | Column | Type |
  1426. +---------+--------+
  1427. | ad_id | int(9) |
  1428. | page_id | int(9) |
  1429. +---------+--------+
  1430.  
  1431. Database: angioprod
  1432. Table: wdb_currencies
  1433. [10 columns]
  1434. +-----------------+---------------+
  1435. | Column | Type |
  1436. +-----------------+---------------+
  1437. | value | decimal(13,8) |
  1438. | code | varchar(3) |
  1439. | currencies_id | int(9) |
  1440. | decimal_places | char(1) |
  1441. | decimal_point | char(1) |
  1442. | last_updated | datetime |
  1443. | symbol_left | varchar(12) |
  1444. | symbol_right | varchar(12) |
  1445. | thousands_point | char(1) |
  1446. | title | varchar(32) |
  1447. +-----------------+---------------+
  1448.  
  1449. Database: angioprod
  1450. Table: wdb_languages
  1451. [8 columns]
  1452. +--------------+-------------+
  1453. | Column | Type |
  1454. +--------------+-------------+
  1455. | code | varchar(2) |
  1456. | directory | varchar(32) |
  1457. | enabled | tinyint(1) |
  1458. | image | varchar(64) |
  1459. | isdefault | tinyint(1) |
  1460. | languages_id | int(9) |
  1461. | name | varchar(32) |
  1462. | sort_order | int(5) |
  1463. +--------------+-------------+
  1464.  
  1465. Database: angioprod
  1466. Table: wdb_customer_type
  1467. [6 columns]
  1468. +--------------------+-------------+
  1469. | Column | Type |
  1470. +--------------------+-------------+
  1471. | customer_type_id | int(9) |
  1472. | customer_type_name | varchar(32) |
  1473. | handingfee_rate | float |
  1474. | is_b2b | tinyint(1) |
  1475. | languages_id | int(9) |
  1476. | sales_tax | tinyint(1) |
  1477. +--------------------+-------------+
  1478.  
  1479. Database: angioprod
  1480. Table: wdb_customers_basket_attributes
  1481. [5 columns]
  1482. +--------------------------------+----------+
  1483. | Column | Type |
  1484. +--------------------------------+----------+
  1485. | customer_id | int(9) |
  1486. | customers_basket_attributes_id | int(9) |
  1487. | options_id | int(9) |
  1488. | options_values_id | int(9) |
  1489. | products_id | tinytext |
  1490. +--------------------------------+----------+
  1491.  
  1492. Database: angioprod
  1493. Table: wdb_products_description
  1494. [9 columns]
  1495. +-------------------------------+--------------+
  1496. | Column | Type |
  1497. +-------------------------------+--------------+
  1498. | languages_id | int(9) |
  1499. | products_description | text |
  1500. | products_id | int(9) |
  1501. | products_meta_tag_keyword | varchar(250) |
  1502. | products_name | varchar(64) |
  1503. | products_shortdescription | text |
  1504. | products_thumbnaildescription | text |
  1505. | products_url | varchar(128) |
  1506. | products_viewed | int(6) |
  1507. +-------------------------------+--------------+
  1508.  
  1509. Database: angioprod
  1510. Table: wdb_coupons_rule
  1511. [13 columns]
  1512. +--------------------------+---------------+
  1513. | Column | Type |
  1514. +--------------------------+---------------+
  1515. | coupons_application | tinyint(4) |
  1516. | coupons_customerlimit | int(11) |
  1517. | coupons_expire | datetime |
  1518. | coupons_restrict | varchar(64) |
  1519. | coupons_rule_code | varchar(32) |
  1520. | coupons_rule_expire | datetime |
  1521. | coupons_rule_expressions | varchar(128) |
  1522. | coupons_rule_id | int(11) |
  1523. | coupons_rule_start | datetime |
  1524. | coupons_start | datetime |
  1525. | coupons_threshold | decimal(15,4) |
  1526. | coupons_type | tinyint(4) |
  1527. | coupons_uselimit | int(11) |
  1528. +--------------------------+---------------+
  1529.  
  1530. Database: angioprod
  1531. Table: wdb_cart_product_assembled
  1532. [11 columns]
  1533. +---------------------------+---------------+
  1534. | Column | Type |
  1535. +---------------------------+---------------+
  1536. | cart_product_assembled_id | int(11) |
  1537. | categories_id | int(11) |
  1538. | difference_price | decimal(15,4) |
  1539. | is_checked | tinyint(1) |
  1540. | is_multiple | tinyint(1) |
  1541. | is_recommend | varchar(255) |
  1542. | is_required | tinyint(1) |
  1543. | mutex | varchar(255) |
  1544. | product_assembled_id | int(11) |
  1545. | product_id | int(11) |
  1546. | ref_product_id | int(11) |
  1547. +---------------------------+---------------+
  1548.  
  1549. Database: angioprod
  1550. Table: wdb_product_assembled
  1551. [10 columns]
  1552. +----------------------+---------------+
  1553. | Column | Type |
  1554. +----------------------+---------------+
  1555. | categories_id | int(11) |
  1556. | difference_price | decimal(15,4) |
  1557. | is_default | tinyint(1) |
  1558. | is_multiple | tinyint(1) |
  1559. | is_recommend | varchar(255) |
  1560. | is_required | tinyint(1) |
  1561. | mutex | varchar(255) |
  1562. | product_assembled_id | int(11) |
  1563. | product_id | int(11) |
  1564. | sort_order | int(11) |
  1565. +----------------------+---------------+
  1566.  
  1567. Database: angioprod
  1568. Table: wdb_tax_rates
  1569. [8 columns]
  1570. +-----------------+--------------+
  1571. | Column | Type |
  1572. +-----------------+--------------+
  1573. | date_added | datetime |
  1574. | last_modified | datetime |
  1575. | tax_class_id | int(9) |
  1576. | tax_description | varchar(255) |
  1577. | tax_priority | int(5) |
  1578. | tax_rate | decimal(7,4) |
  1579. | tax_rates_id | int(9) |
  1580. | tax_zones_id | int(9) |
  1581. +-----------------+--------------+
  1582.  
  1583. Database: angioprod
  1584. Table: wdb_address_book
  1585. [20 columns]
  1586. +--------------------------+-------------+
  1587. | Column | Type |
  1588. +--------------------------+-------------+
  1589. | address_book_id | int(9) |
  1590. | address_type | tinyint(1) |
  1591. | countries_id | int(9) |
  1592. | customer_city | varchar(32) |
  1593. | customer_company | varchar(32) |
  1594. | customer_dob | datetime |
  1595. | customer_fax | varchar(32) |
  1596. | customer_firstname | varchar(32) |
  1597. | customer_gender | char(1) |
  1598. | customer_id | int(9) |
  1599. | customer_idno | varchar(32) |
  1600. | customer_lastname | varchar(32) |
  1601. | customer_name | varchar(32) |
  1602. | customer_postcode | varchar(10) |
  1603. | customer_state | varchar(32) |
  1604. | customer_street_address | varchar(64) |
  1605. | customer_street_address2 | varchar(64) |
  1606. | customer_suburb | varchar(32) |
  1607. | customer_telephone | varchar(32) |
  1608. | zones_id | int(9) |
  1609. +--------------------------+-------------+
  1610.  
  1611. Database: angioprod
  1612. Table: wdb_app_acceptance
  1613. [3 columns]
  1614. +-------------------+--------+
  1615. | Column | Type |
  1616. +-------------------+--------+
  1617. | app_acceptance_id | int(9) |
  1618. | content | text |
  1619. | languages_id | int(9) |
  1620. +-------------------+--------+
  1621.  
  1622. Database: angioprod
  1623. Table: wdb_criteria_groups
  1624. [4 columns]
  1625. +--------------------+-------------+
  1626. | Column | Type |
  1627. +--------------------+-------------+
  1628. | criteria_groups | int(9) |
  1629. | name | varchar(64) |
  1630. | pcriteria_group_id | int(9) |
  1631. | sort_order | int(5) |
  1632. +--------------------+-------------+
  1633.  
  1634. Database: angioprod
  1635. Table: wdb_email_track
  1636. [7 columns]
  1637. +----------------------+-------------+
  1638. | Column | Type |
  1639. +----------------------+-------------+
  1640. | coupons_id | int(11) |
  1641. | customer_id | int(9) |
  1642. | date_sent | datetime |
  1643. | email_sent_to | varchar(64) |
  1644. | email_track_id | int(11) |
  1645. | email_track_sentname | varchar(32) |
  1646. | gifts_id | int(11) |
  1647. +----------------------+-------------+
  1648.  
  1649. Database: angioprod
  1650. Table: wdb_buy_options
  1651. [3 columns]
  1652. +----------------------+--------+
  1653. | Column | Type |
  1654. +----------------------+--------+
  1655. | buy_options_quantity | int(2) |
  1656. | pro_products_id | int(9) |
  1657. | products_id | int(9) |
  1658. +----------------------+--------+
  1659.  
  1660. ========================
  1661. REPORT 2
  1662. ========================
  1663.  
  1664. Nmap scan report for www.angiobio.com (66.96.149.17)
  1665. rDNS record for 66.96.149.17: 17.149.96.66.static.eigbox.net
  1666. Not shown: 988 filtered ports
  1667.  
  1668. PORT STATE SERVICE VERSION
  1669. 21/tcp closed ftp
  1670. 25/tcp closed smtp
  1671. 465/tcp closed smtps
  1672. 993/tcp closed imaps
  1673. 995/tcp closed pop3s
  1674. 110/tcp closed pop3
  1675. 113/tcp closed ident
  1676. 143/tcp closed imap
  1677.  
  1678. 80/tcp open http nginx
  1679. | http-cookie-flags:
  1680. | /:
  1681. | PHPSESSID:
  1682. |_ httponly flag not set
  1683. | http-methods:
  1684. |_ Potentially risky methods: TRACE
  1685. | http-server-header:
  1686. | Apache/2
  1687. |_ nginx
  1688. | http-title: Welcome to AngioBio!
  1689. |_Requested resource was default.php
  1690.  
  1691. 443/tcp open ssl/http nginx
  1692. | http-cookie-flags:
  1693. | /:
  1694. | PHPSESSID:
  1695. |_ httponly flag not set
  1696. | http-methods:
  1697. |_ Potentially risky methods: TRACE
  1698. | http-server-header:
  1699. | Apache/2
  1700. |_ nginx
  1701. | http-title: Welcome to AngioBio!
  1702. |_Requested resource was default.php
  1703. | ssl-cert: Subject: commonName=*.angiobio.com
  1704. | Subject Alternative Name: DNS:*.angiobio.com, DNS:angiobio.com
  1705. |_ssl-date: TLS randomness does not represent time
  1706. | tls-alpn:
  1707. |_ http/1.1
  1708. | tls-nextprotoneg:
  1709. |_ http/1.1
  1710.  
  1711. 8008/tcp open http
  1712. | fingerprint-strings:
  1713. | FourOhFourRequest:
  1714. | HTTP/1.1 302 Found
  1715. | Location: https://:8010/nice%20ports%2C/Tri%6Eity.txt%2ebak
  1716. | Connection: close
  1717. | X-Frame-Options: SAMEORIGIN
  1718. | X-XSS-Protection: 1; mode=block
  1719. | X-Content-Type-Options: nosniff
  1720. | Content-Security-Policy: frame-ancestors
  1721. | GenericLines, HTTPOptions, RTSPRequest, SIPOptions:
  1722. | HTTP/1.1 302 Found
  1723. | Location: https://:8010
  1724. | Connection: close
  1725. | X-Frame-Options: SAMEORIGIN
  1726. | X-XSS-Protection: 1; mode=block
  1727. | X-Content-Type-Options: nosniff
  1728. | Content-Security-Policy: frame-ancestors
  1729. | GetRequest:
  1730. | HTTP/1.1 302 Found
  1731. | Location: https://:8010/
  1732. | Connection: close
  1733. | X-Frame-Options: SAMEORIGIN
  1734. | X-XSS-Protection: 1; mode=block
  1735. | X-Content-Type-Options: nosniff
  1736. |_ Content-Security-Policy: frame-ancestors
  1737. |_http-title: Did not follow redirect to https://www.angiobio.com:8010/
  1738.  
  1739. 8010/tcp open ssl/http-proxy FortiGate Web Filtering Service
  1740. |_http-title: Web Filter Block Override
  1741. | ssl-cert: Subject: commonName=www.angiobio.com
  1742. | Subject Alternative Name: DNS:www.angiobio.com
  1743.  
  1744. Device type: general purpose|phone|firewall
  1745. Running (JUST GUESSING): Linux 3.X|4.X|2.6.X (91%), Google Android 7.X (91%), IPCop 2.X (85%)
  1746.  
  1747. OS CPE: cpe:/o:linux:linux_kernel:3.2 cpe:/o:linux:linux_kernel:4.9 cpe:/o:google:android:7.1.2 cpe:/o:linux:linux_kernel:3.10 cpe:/o:linux:linux_kernel:2.6.32 cpe:/o:ipcop:ipcop:2.0 cpe:/o:linux:linux_kernel:3.4
  1748. Aggressive OS guesses: Linux 3.2 (91%), Linux 4.9 (91%), Android 7.1.2 (Linux 3.10) (91%), Linux 3.18 (89%), OpenWrt Chaos Calmer (Linux 3.18) (87%), Linux 3.0 (86%), IPCop 2.0 (Linux 2.6.32) (85%), IPCop 2 firewall (Linux 3.4) (85%)
  1749. No exact OS matches for host (test conditions non-ideal).
Add Comment
Please, Sign In to add comment