ey_shop_order_details.php 2.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120
  1. <?php
  2. return array (
  3. 'details_id' =>
  4. array (
  5. 'name' => 'details_id',
  6. 'type' => 'int(10) unsigned',
  7. 'notnull' => false,
  8. 'default' => NULL,
  9. 'primary' => true,
  10. 'autoinc' => true,
  11. ),
  12. 'order_id' =>
  13. array (
  14. 'name' => 'order_id',
  15. 'type' => 'int(10)',
  16. 'notnull' => false,
  17. 'default' => '0',
  18. 'primary' => false,
  19. 'autoinc' => false,
  20. ),
  21. 'users_id' =>
  22. array (
  23. 'name' => 'users_id',
  24. 'type' => 'int(10) unsigned',
  25. 'notnull' => false,
  26. 'default' => '0',
  27. 'primary' => false,
  28. 'autoinc' => false,
  29. ),
  30. 'product_id' =>
  31. array (
  32. 'name' => 'product_id',
  33. 'type' => 'int(10) unsigned',
  34. 'notnull' => false,
  35. 'default' => '0',
  36. 'primary' => false,
  37. 'autoinc' => false,
  38. ),
  39. 'product_name' =>
  40. array (
  41. 'name' => 'product_name',
  42. 'type' => 'varchar(100)',
  43. 'notnull' => false,
  44. 'default' => '',
  45. 'primary' => false,
  46. 'autoinc' => false,
  47. ),
  48. 'num' =>
  49. array (
  50. 'name' => 'num',
  51. 'type' => 'int(10)',
  52. 'notnull' => false,
  53. 'default' => '0',
  54. 'primary' => false,
  55. 'autoinc' => false,
  56. ),
  57. 'data' =>
  58. array (
  59. 'name' => 'data',
  60. 'type' => 'text',
  61. 'notnull' => false,
  62. 'default' => NULL,
  63. 'primary' => false,
  64. 'autoinc' => false,
  65. ),
  66. 'product_price' =>
  67. array (
  68. 'name' => 'product_price',
  69. 'type' => 'decimal(10,2)',
  70. 'notnull' => false,
  71. 'default' => '0.00',
  72. 'primary' => false,
  73. 'autoinc' => false,
  74. ),
  75. 'prom_type' =>
  76. array (
  77. 'name' => 'prom_type',
  78. 'type' => 'tinyint(1) unsigned',
  79. 'notnull' => false,
  80. 'default' => '0',
  81. 'primary' => false,
  82. 'autoinc' => false,
  83. ),
  84. 'litpic' =>
  85. array (
  86. 'name' => 'litpic',
  87. 'type' => 'varchar(500)',
  88. 'notnull' => false,
  89. 'default' => '',
  90. 'primary' => false,
  91. 'autoinc' => false,
  92. ),
  93. 'lang' =>
  94. array (
  95. 'name' => 'lang',
  96. 'type' => 'varchar(30)',
  97. 'notnull' => false,
  98. 'default' => 'cn',
  99. 'primary' => false,
  100. 'autoinc' => false,
  101. ),
  102. 'add_time' =>
  103. array (
  104. 'name' => 'add_time',
  105. 'type' => 'int(11) unsigned',
  106. 'notnull' => false,
  107. 'default' => '0',
  108. 'primary' => false,
  109. 'autoinc' => false,
  110. ),
  111. 'update_time' =>
  112. array (
  113. 'name' => 'update_time',
  114. 'type' => 'int(11) unsigned',
  115. 'notnull' => false,
  116. 'default' => '0',
  117. 'primary' => false,
  118. 'autoinc' => false,
  119. ),
  120. );