API tools faq
paste
Guest User

Untitled

a guest
Feb 21st, 2018
71
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.49 KB | None | 0 0
raw download clone embed print report
  1. <h1>SQL result</h1>
  2. <p>
  3.  
  4. <b>Host:</b> localhost<br />
  5. <b>Database:</b> dev<br />
  6. <b>Generation Time:</b> Oct 28, 2011 at 01:38 AM<br />
  7. <b>Generated by:</b> phpMyAdmin&nbsp;2.11.9.6&nbsp;/ MySQL&nbsp;4.1.20-log<br />
  8.  
  9. <b>SQL query:</b> describe products;
  10. <br />
  11. <b>Rows:</b> 81 </p>
  12.  
  13.  
  14. <table id="table_results" class="data">
  15. <thead><tr>
  16. <th>Field
  17. </th><th>Type
  18. </th><th>Null
  19.  
  20. </th><th>Key
  21. </th><th>Default
  22. </th><th>Extra
  23. </th></tr>
  24. </thead>
  25. <tbody>
  26. <tr class="odd">
  27. <td class="">products_id</td>
  28. <td class="">int(11)</td>
  29. <td class="">&nbsp;</td>
  30.  
  31. <td class="">PRI</td>
  32. <td class=""><i>NULL</i></td>
  33. <td class="">auto_increment</td>
  34. </tr>
  35.  
  36. <tr class="even">
  37. <td class="">master_products_id</td>
  38. <td class="">int(11)</td>
  39.  
  40. <td class="">&nbsp;</td>
  41. <td class="">MUL</td>
  42. <td class="">0</td>
  43. <td class="">&nbsp;</td>
  44. </tr>
  45.  
  46. <tr class="odd">
  47. <td class="">products_quantity</td>
  48. <td class="">int(4)</td>
  49.  
  50. <td class="">&nbsp;</td>
  51. <td class="">&nbsp;</td>
  52. <td class="">0</td>
  53. <td class="">&nbsp;</td>
  54. </tr>
  55.  
  56. <tr class="even">
  57. <td class="">products_class</td>
  58. <td class="">varchar(64)</td>
  59.  
  60. <td class="">&nbsp;</td>
  61. <td class="">&nbsp;</td>
  62. <td class="">&nbsp;</td>
  63. <td class="">&nbsp;</td>
  64. </tr>
  65.  
  66. <tr class="odd">
  67. <td class="">stock_class</td>
  68. <td class="">varchar(48)</td>
  69.  
  70. <td class="">&nbsp;</td>
  71. <td class="">&nbsp;</td>
  72. <td class="">stock_default</td>
  73. <td class="">&nbsp;</td>
  74. </tr>
  75.  
  76. <tr class="even">
  77. <td class="">products_model</td>
  78. <td class="">varchar(12)</td>
  79.  
  80. <td class="">YES</td>
  81. <td class="">MUL</td>
  82. <td class=""><i>NULL</i></td>
  83. <td class="">&nbsp;</td>
  84. </tr>
  85.  
  86. <tr class="odd">
  87. <td class="">products_sku</td>
  88.  
  89. <td class="">varchar(40)</td>
  90. <td class="">&nbsp;</td>
  91. <td class="">MUL</td>
  92. <td class="">&nbsp;</td>
  93. <td class="">&nbsp;</td>
  94. </tr>
  95.  
  96. <tr class="even">
  97. <td class="">products_upc</td>
  98.  
  99. <td class="">varchar(24)</td>
  100. <td class="">&nbsp;</td>
  101. <td class="">MUL</td>
  102. <td class="">&nbsp;</td>
  103. <td class="">&nbsp;</td>
  104. </tr>
  105.  
  106. <tr class="odd">
  107. <td class="">Featured_product</td>
  108.  
  109. <td class="">int(4)</td>
  110. <td class="">&nbsp;</td>
  111. <td class="">&nbsp;</td>
  112. <td class="">0</td>
  113. <td class="">&nbsp;</td>
  114. </tr>
  115.  
  116. <tr class="even">
  117. <td class="">products_image</td>
  118.  
  119. <td class="">varchar(64)</td>
  120. <td class="">YES</td>
  121. <td class="">&nbsp;</td>
  122. <td class=""><i>NULL</i></td>
  123. <td class="">&nbsp;</td>
  124. </tr>
  125.  
  126. <tr class="odd">
  127. <td class="">products_image_med</td>
  128.  
  129. <td class="">varchar(64)</td>
  130. <td class="">YES</td>
  131. <td class="">&nbsp;</td>
  132. <td class=""><i>NULL</i></td>
  133. <td class="">&nbsp;</td>
  134. </tr>
  135.  
  136. <tr class="even">
  137. <td class="">products_image_lrg</td>
  138.  
  139. <td class="">varchar(64)</td>
  140. <td class="">YES</td>
  141. <td class="">&nbsp;</td>
  142. <td class=""><i>NULL</i></td>
  143. <td class="">&nbsp;</td>
  144. </tr>
  145.  
  146. <tr class="odd">
  147. <td class="">products_image_sm_1</td>
  148.  
  149. <td class="">varchar(64)</td>
  150. <td class="">YES</td>
  151. <td class="">&nbsp;</td>
  152. <td class=""><i>NULL</i></td>
  153. <td class="">&nbsp;</td>
  154. </tr>
  155.  
  156. <tr class="even">
  157. <td class="">products_image_xl_1</td>
  158.  
  159. <td class="">varchar(64)</td>
  160. <td class="">YES</td>
  161. <td class="">&nbsp;</td>
  162. <td class=""><i>NULL</i></td>
  163. <td class="">&nbsp;</td>
  164. </tr>
  165.  
  166. <tr class="odd">
  167. <td class="">products_image_sm_2</td>
  168.  
  169. <td class="">varchar(64)</td>
  170. <td class="">YES</td>
  171. <td class="">&nbsp;</td>
  172. <td class=""><i>NULL</i></td>
  173. <td class="">&nbsp;</td>
  174. </tr>
  175.  
  176. <tr class="even">
  177. <td class="">products_image_xl_2</td>
  178.  
  179. <td class="">varchar(64)</td>
  180. <td class="">YES</td>
  181. <td class="">&nbsp;</td>
  182. <td class=""><i>NULL</i></td>
  183. <td class="">&nbsp;</td>
  184. </tr>
  185.  
  186. <tr class="odd">
  187. <td class="">products_image_sm_3</td>
  188.  
  189. <td class="">varchar(64)</td>
  190. <td class="">YES</td>
  191. <td class="">&nbsp;</td>
  192. <td class=""><i>NULL</i></td>
  193. <td class="">&nbsp;</td>
  194. </tr>
  195.  
  196. <tr class="even">
  197. <td class="">products_image_xl_3</td>
  198.  
  199. <td class="">varchar(64)</td>
  200. <td class="">YES</td>
  201. <td class="">&nbsp;</td>
  202. <td class=""><i>NULL</i></td>
  203. <td class="">&nbsp;</td>
  204. </tr>
  205.  
  206. <tr class="odd">
  207. <td class="">products_image_sm_4</td>
  208.  
  209. <td class="">varchar(64)</td>
  210. <td class="">YES</td>
  211. <td class="">&nbsp;</td>
  212. <td class=""><i>NULL</i></td>
  213. <td class="">&nbsp;</td>
  214. </tr>
  215.  
  216. <tr class="even">
  217. <td class="">products_image_xl_4</td>
  218.  
  219. <td class="">varchar(64)</td>
  220. <td class="">YES</td>
  221. <td class="">&nbsp;</td>
  222. <td class=""><i>NULL</i></td>
  223. <td class="">&nbsp;</td>
  224. </tr>
  225.  
  226. <tr class="odd">
  227. <td class="">products_image_sm_5</td>
  228.  
  229. <td class="">varchar(64)</td>
  230. <td class="">YES</td>
  231. <td class="">&nbsp;</td>
  232. <td class=""><i>NULL</i></td>
  233. <td class="">&nbsp;</td>
  234. </tr>
  235.  
  236. <tr class="even">
  237. <td class="">products_image_xl_5</td>
  238.  
  239. <td class="">varchar(64)</td>
  240. <td class="">YES</td>
  241. <td class="">&nbsp;</td>
  242. <td class=""><i>NULL</i></td>
  243. <td class="">&nbsp;</td>
  244. </tr>
  245.  
  246. <tr class="odd">
  247. <td class="">products_image_sm_6</td>
  248.  
  249. <td class="">varchar(64)</td>
  250. <td class="">YES</td>
  251. <td class="">&nbsp;</td>
  252. <td class=""><i>NULL</i></td>
  253. <td class="">&nbsp;</td>
  254. </tr>
  255.  
  256. <tr class="even">
  257. <td class="">products_image_xl_6</td>
  258.  
  259. <td class="">varchar(64)</td>
  260. <td class="">YES</td>
  261. <td class="">&nbsp;</td>
  262. <td class=""><i>NULL</i></td>
  263. <td class="">&nbsp;</td>
  264. </tr>
  265.  
  266. <tr class="odd">
  267. <td class="">products_image_sm_7</td>
  268.  
  269. <td class="">varchar(64)</td>
  270. <td class="">YES</td>
  271. <td class="">&nbsp;</td>
  272. <td class=""><i>NULL</i></td>
  273. <td class="">&nbsp;</td>
  274. </tr>
  275.  
  276. <tr class="even">
  277. <td class="">products_image_xl_7</td>
  278.  
  279. <td class="">varchar(64)</td>
  280. <td class="">YES</td>
  281. <td class="">&nbsp;</td>
  282. <td class=""><i>NULL</i></td>
  283. <td class="">&nbsp;</td>
  284. </tr>
  285.  
  286. <tr class="odd">
  287. <td class="">products_image_sm_8</td>
  288.  
  289. <td class="">varchar(64)</td>
  290. <td class="">YES</td>
  291. <td class="">&nbsp;</td>
  292. <td class=""><i>NULL</i></td>
  293. <td class="">&nbsp;</td>
  294. </tr>
  295.  
  296. <tr class="even">
  297. <td class="">products_image_xl_8</td>
  298.  
  299. <td class="">varchar(64)</td>
  300. <td class="">YES</td>
  301. <td class="">&nbsp;</td>
  302. <td class=""><i>NULL</i></td>
  303. <td class="">&nbsp;</td>
  304. </tr>
  305.  
  306. <tr class="odd">
  307. <td class="">products_price</td>
  308.  
  309. <td class="">decimal(15,4)</td>
  310. <td class="">&nbsp;</td>
  311. <td class="">&nbsp;</td>
  312. <td class="">0.0000</td>
  313. <td class="">&nbsp;</td>
  314. </tr>
  315.  
  316. <tr class="even">
  317. <td class="">products_date_added</td>
  318.  
  319. <td class="">datetime</td>
  320. <td class="">&nbsp;</td>
  321. <td class="">MUL</td>
  322. <td class="">0000-00-00 00:00:00</td>
  323. <td class="">&nbsp;</td>
  324. </tr>
  325.  
  326. <tr class="odd">
  327. <td class="">products_last_modified</td>
  328.  
  329. <td class="">datetime</td>
  330. <td class="">YES</td>
  331. <td class="">&nbsp;</td>
  332. <td class=""><i>NULL</i></td>
  333. <td class="">&nbsp;</td>
  334. </tr>
  335.  
  336. <tr class="even">
  337. <td class="">products_date_available</td>
  338.  
  339. <td class="">datetime</td>
  340. <td class="">YES</td>
  341. <td class="">&nbsp;</td>
  342. <td class=""><i>NULL</i></td>
  343. <td class="">&nbsp;</td>
  344. </tr>
  345.  
  346. <tr class="odd">
  347. <td class="">products_featured_until</td>
  348.  
  349. <td class="">text</td>
  350. <td class="">YES</td>
  351. <td class="">&nbsp;</td>
  352. <td class=""><i>NULL</i></td>
  353. <td class="">&nbsp;</td>
  354. </tr>
  355.  
  356. <tr class="even">
  357. <td class="">products_weight</td>
  358.  
  359. <td class="">decimal(5,2)</td>
  360. <td class="">&nbsp;</td>
  361. <td class="">&nbsp;</td>
  362. <td class="">0.00</td>
  363. <td class="">&nbsp;</td>
  364. </tr>
  365.  
  366. <tr class="odd">
  367. <td class="">products_status</td>
  368.  
  369. <td class="">tinyint(1)</td>
  370. <td class="">&nbsp;</td>
  371. <td class="">&nbsp;</td>
  372. <td class="">0</td>
  373. <td class="">&nbsp;</td>
  374. </tr>
  375.  
  376. <tr class="even">
  377. <td class="">products_featured</td>
  378.  
  379. <td class="">text</td>
  380. <td class="">YES</td>
  381. <td class="">&nbsp;</td>
  382. <td class=""><i>NULL</i></td>
  383. <td class="">&nbsp;</td>
  384. </tr>
  385.  
  386. <tr class="odd">
  387. <td class="">products_tax_class_id</td>
  388.  
  389. <td class="">int(11)</td>
  390. <td class="">&nbsp;</td>
  391. <td class="">&nbsp;</td>
  392. <td class="">0</td>
  393. <td class="">&nbsp;</td>
  394. </tr>
  395.  
  396. <tr class="even">
  397. <td class="">manufacturers_id</td>
  398.  
  399. <td class="">int(11)</td>
  400. <td class="">YES</td>
  401. <td class="">MUL</td>
  402. <td class=""><i>NULL</i></td>
  403. <td class="">&nbsp;</td>
  404. </tr>
  405.  
  406. <tr class="odd">
  407.  
  408. <td class="">products_make</td>
  409. <td class="">varchar(32)</td>
  410. <td class="">YES</td>
  411. <td class="">&nbsp;</td>
  412. <td class=""><i>NULL</i></td>
  413. <td class="">&nbsp;</td>
  414. </tr>
  415.  
  416.  
  417. <tr class="even">
  418. <td class="">products_ordered</td>
  419. <td class="">int(11)</td>
  420. <td class="">&nbsp;</td>
  421. <td class="">&nbsp;</td>
  422. <td class="">0</td>
  423. <td class="">&nbsp;</td>
  424.  
  425. </tr>
  426.  
  427. <tr class="odd">
  428. <td class="">products_length</td>
  429. <td class="">decimal(6,2)</td>
  430. <td class="">&nbsp;</td>
  431. <td class="">&nbsp;</td>
  432. <td class="">12.00</td>
  433. <td class="">&nbsp;</td>
  434.  
  435. </tr>
  436.  
  437. <tr class="even">
  438. <td class="">products_width</td>
  439. <td class="">decimal(6,2)</td>
  440. <td class="">&nbsp;</td>
  441. <td class="">&nbsp;</td>
  442. <td class="">12.00</td>
  443. <td class="">&nbsp;</td>
  444.  
  445. </tr>
  446.  
  447. <tr class="odd">
  448. <td class="">products_height</td>
  449. <td class="">decimal(6,2)</td>
  450. <td class="">&nbsp;</td>
  451. <td class="">&nbsp;</td>
  452. <td class="">12.00</td>
  453. <td class="">&nbsp;</td>
  454.  
  455. </tr>
  456.  
  457. <tr class="even">
  458. <td class="">products_ready_to_ship</td>
  459. <td class="">int(1)</td>
  460. <td class="">&nbsp;</td>
  461. <td class="">&nbsp;</td>
  462. <td class="">0</td>
  463. <td class="">&nbsp;</td>
  464.  
  465. </tr>
  466.  
  467. <tr class="odd">
  468. <td class="">products_image_1</td>
  469. <td class="">varchar(64)</td>
  470. <td class="">YES</td>
  471. <td class="">&nbsp;</td>
  472. <td class=""><i>NULL</i></td>
  473.  
  474. <td class="">&nbsp;</td>
  475. </tr>
  476.  
  477. <tr class="even">
  478. <td class="">products_image_2</td>
  479. <td class="">varchar(64)</td>
  480. <td class="">YES</td>
  481. <td class="">&nbsp;</td>
  482. <td class=""><i>NULL</i></td>
  483.  
  484. <td class="">&nbsp;</td>
  485. </tr>
  486.  
  487. <tr class="odd">
  488. <td class="">products_image_3</td>
  489. <td class="">varchar(64)</td>
  490. <td class="">YES</td>
  491. <td class="">&nbsp;</td>
  492. <td class=""><i>NULL</i></td>
  493.  
  494. <td class="">&nbsp;</td>
  495. </tr>
  496.  
  497. <tr class="even">
  498. <td class="">products_price_competitor</td>
  499. <td class="">decimal(15,4)</td>
  500. <td class="">&nbsp;</td>
  501. <td class="">&nbsp;</td>
  502. <td class="">0.0000</td>
  503.  
  504. <td class="">&nbsp;</td>
  505. </tr>
  506.  
  507. <tr class="odd">
  508. <td class="">products_price1</td>
  509. <td class="">decimal(15,4)</td>
  510. <td class="">&nbsp;</td>
  511. <td class="">&nbsp;</td>
  512. <td class="">0.0000</td>
  513.  
  514. <td class="">&nbsp;</td>
  515. </tr>
  516.  
  517. <tr class="even">
  518. <td class="">products_price2</td>
  519. <td class="">decimal(15,4)</td>
  520. <td class="">&nbsp;</td>
  521. <td class="">&nbsp;</td>
  522. <td class="">0.0000</td>
  523.  
  524. <td class="">&nbsp;</td>
  525. </tr>
  526.  
  527. <tr class="odd">
  528. <td class="">products_price3</td>
  529. <td class="">decimal(15,4)</td>
  530. <td class="">&nbsp;</td>
  531. <td class="">&nbsp;</td>
  532. <td class="">0.0000</td>
  533.  
  534. <td class="">&nbsp;</td>
  535. </tr>
  536.  
  537. <tr class="even">
  538. <td class="">products_price4</td>
  539. <td class="">decimal(15,4)</td>
  540. <td class="">&nbsp;</td>
  541. <td class="">&nbsp;</td>
  542. <td class="">0.0000</td>
  543.  
  544. <td class="">&nbsp;</td>
  545. </tr>
  546.  
  547. <tr class="odd">
  548. <td class="">products_price5</td>
  549. <td class="">decimal(15,4)</td>
  550. <td class="">&nbsp;</td>
  551. <td class="">&nbsp;</td>
  552. <td class="">0.0000</td>
  553.  
  554. <td class="">&nbsp;</td>
  555. </tr>
  556.  
  557. <tr class="even">
  558. <td class="">products_price6</td>
  559. <td class="">decimal(15,4)</td>
  560. <td class="">&nbsp;</td>
  561. <td class="">&nbsp;</td>
  562. <td class="">0.0000</td>
  563.  
  564. <td class="">&nbsp;</td>
  565. </tr>
  566.  
  567. <tr class="odd">
  568. <td class="">products_price7</td>
  569. <td class="">decimal(15,4)</td>
  570. <td class="">&nbsp;</td>
  571. <td class="">&nbsp;</td>
  572. <td class="">0.0000</td>
  573.  
  574. <td class="">&nbsp;</td>
  575. </tr>
  576.  
  577. <tr class="even">
  578. <td class="">products_price8</td>
  579. <td class="">decimal(15,4)</td>
  580. <td class="">&nbsp;</td>
  581. <td class="">&nbsp;</td>
  582. <td class="">0.0000</td>
  583.  
  584. <td class="">&nbsp;</td>
  585. </tr>
  586.  
  587. <tr class="odd">
  588. <td class="">products_price1_qty</td>
  589. <td class="">int(11)</td>
  590. <td class="">&nbsp;</td>
  591. <td class="">&nbsp;</td>
  592. <td class="">0</td>
  593.  
  594. <td class="">&nbsp;</td>
  595. </tr>
  596.  
  597. <tr class="even">
  598. <td class="">products_price2_qty</td>
  599. <td class="">int(11)</td>
  600. <td class="">&nbsp;</td>
  601. <td class="">&nbsp;</td>
  602. <td class="">0</td>
  603.  
  604. <td class="">&nbsp;</td>
  605. </tr>
  606.  
  607. <tr class="odd">
  608. <td class="">products_price3_qty</td>
  609. <td class="">int(11)</td>
  610. <td class="">&nbsp;</td>
  611. <td class="">&nbsp;</td>
  612. <td class="">0</td>
  613.  
  614. <td class="">&nbsp;</td>
  615. </tr>
  616.  
  617. <tr class="even">
  618. <td class="">products_price4_qty</td>
  619. <td class="">int(11)</td>
  620. <td class="">&nbsp;</td>
  621. <td class="">&nbsp;</td>
  622. <td class="">0</td>
  623.  
  624. <td class="">&nbsp;</td>
  625. </tr>
  626.  
  627. <tr class="odd">
  628. <td class="">products_price5_qty</td>
  629. <td class="">int(11)</td>
  630. <td class="">&nbsp;</td>
  631. <td class="">&nbsp;</td>
  632. <td class="">0</td>
  633.  
  634. <td class="">&nbsp;</td>
  635. </tr>
  636.  
  637. <tr class="even">
  638. <td class="">products_price6_qty</td>
  639. <td class="">int(11)</td>
  640. <td class="">&nbsp;</td>
  641. <td class="">&nbsp;</td>
  642. <td class="">0</td>
  643.  
  644. <td class="">&nbsp;</td>
  645. </tr>
  646.  
  647. <tr class="odd">
  648. <td class="">products_price7_qty</td>
  649. <td class="">int(11)</td>
  650. <td class="">&nbsp;</td>
  651. <td class="">&nbsp;</td>
  652. <td class="">0</td>
  653.  
  654. <td class="">&nbsp;</td>
  655. </tr>
  656.  
  657. <tr class="even">
  658. <td class="">products_price8_qty</td>
  659. <td class="">int(11)</td>
  660. <td class="">&nbsp;</td>
  661. <td class="">&nbsp;</td>
  662. <td class="">0</td>
  663.  
  664. <td class="">&nbsp;</td>
  665. </tr>
  666.  
  667. <tr class="odd">
  668. <td class="">products_qty_blocks</td>
  669. <td class="">int(11)</td>
  670. <td class="">&nbsp;</td>
  671. <td class="">&nbsp;</td>
  672. <td class="">1</td>
  673.  
  674. <td class="">&nbsp;</td>
  675. </tr>
  676.  
  677. <tr class="even">
  678. <td class="">products_free_shipping</td>
  679. <td class="">tinyint(1)</td>
  680. <td class="">&nbsp;</td>
  681. <td class="">&nbsp;</td>
  682. <td class="">0</td>
  683.  
  684. <td class="">&nbsp;</td>
  685. </tr>
  686.  
  687. <tr class="odd">
  688. <td class="">products_show_qview</td>
  689. <td class="">int(1)</td>
  690. <td class="">&nbsp;</td>
  691. <td class="">&nbsp;</td>
  692. <td class="">1</td>
  693.  
  694. <td class="">&nbsp;</td>
  695. </tr>
  696.  
  697. <tr class="even">
  698. <td class="">products_separate_shipping</td>
  699. <td class="">tinyint(4)</td>
  700. <td class="">&nbsp;</td>
  701. <td class="">&nbsp;</td>
  702. <td class="">0</td>
  703.  
  704. <td class="">&nbsp;</td>
  705. </tr>
  706.  
  707. <tr class="odd">
  708. <td class="">product_special</td>
  709. <td class="">tinyint(1)</td>
  710. <td class="">&nbsp;</td>
  711. <td class="">&nbsp;</td>
  712. <td class="">0</td>
  713.  
  714. <td class="">&nbsp;</td>
  715. </tr>
  716.  
  717. <tr class="even">
  718. <td class="">products_seo_page_name</td>
  719. <td class="">varchar(255)</td>
  720. <td class="">&nbsp;</td>
  721. <td class="">&nbsp;</td>
  722. <td class="">&nbsp;</td>
  723.  
  724. <td class="">&nbsp;</td>
  725. </tr>
  726.  
  727. <tr class="odd">
  728. <td class="">products_image_4</td>
  729. <td class="">varchar(255)</td>
  730. <td class="">&nbsp;</td>
  731. <td class="">&nbsp;</td>
  732. <td class="">&nbsp;</td>
  733.  
  734. <td class="">&nbsp;</td>
  735. </tr>
  736.  
  737. <tr class="even">
  738. <td class="">bs_icon</td>
  739. <td class="">tinyint(1)</td>
  740. <td class="">&nbsp;</td>
  741. <td class="">&nbsp;</td>
  742. <td class="">0</td>
  743.  
  744. <td class="">&nbsp;</td>
  745. </tr>
  746.  
  747. <tr class="odd">
  748. <td class="">qbi_imported</td>
  749. <td class="">tinyint(2) unsigned</td>
  750. <td class="">&nbsp;</td>
  751. <td class="">MUL</td>
  752. <td class="">0</td>
  753.  
  754. <td class="">&nbsp;</td>
  755. </tr>
  756.  
  757. <tr class="even">
  758. <td class="">supplier_id</td>
  759. <td class="">tinyint(4)</td>
  760. <td class="">&nbsp;</td>
  761. <td class="">&nbsp;</td>
  762. <td class="">0</td>
  763.  
  764. <td class="">&nbsp;</td>
  765. </tr>
  766.  
  767. <tr class="odd">
  768. <td class="">suppliers_id</td>
  769. <td class="">int(11)</td>
  770. <td class="">&nbsp;</td>
  771. <td class="">&nbsp;</td>
  772. <td class="">0</td>
  773.  
  774. <td class="">&nbsp;</td>
  775. </tr>
  776.  
  777. <tr class="even">
  778. <td class="">cost_price</td>
  779. <td class="">int(11)</td>
  780. <td class="">&nbsp;</td>
  781. <td class="">&nbsp;</td>
  782. <td class="">0</td>
  783.  
  784. <td class="">&nbsp;</td>
  785. </tr>
  786.  
  787. <tr class="odd">
  788. <td class="">products_price_myself</td>
  789. <td class="">decimal(15,4)</td>
  790. <td class="">&nbsp;</td>
  791. <td class="">&nbsp;</td>
  792. <td class="">0.0000</td>
  793.  
  794. <td class="">&nbsp;</td>
  795. </tr>
  796.  
  797. <tr class="even">
  798. <td class="">products_sort_order</td>
  799. <td class="">int(11)</td>
  800. <td class="">&nbsp;</td>
  801. <td class="">&nbsp;</td>
  802. <td class="">100</td>
  803.  
  804. <td class="">&nbsp;</td>
  805. </tr>
  806.  
  807. <tr class="odd">
  808. <td class="">purchase_handler</td>
  809. <td class="">varchar(32)</td>
  810. <td class="">YES</td>
  811. <td class="">&nbsp;</td>
  812. <td class=""><i>NULL</i></td>
  813.  
  814. <td class="">&nbsp;</td>
  815. </tr>
  816.  
  817. <tr class="even">
  818. <td class="">purchase_handler_data</td>
  819. <td class="">text</td>
  820. <td class="">YES</td>
  821. <td class="">&nbsp;</td>
  822. <td class=""><i>NULL</i></td>
  823.  
  824. <td class="">&nbsp;</td>
  825. </tr>
  826.  
  827. <tr class="odd">
  828. <td class="">products_template</td>
  829. <td class="">varchar(24)</td>
  830. <td class="">&nbsp;</td>
  831. <td class="">&nbsp;</td>
  832. <td class="">&nbsp;</td>
  833.  
  834. <td class="">&nbsp;</td>
  835. </tr>
  836.  
  837. </tbody>
  838. </table>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!