API tools faq
paste
amin007

troli - troli.sql

amin007
Mar 4th, 2012
50
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 9.29 KB | None | 0 0
raw download clone embed print report
  1. --
  2. -- Table structure for table `hargakek`
  3. --
  4.  
  5. CREATE TABLE IF NOT EXISTS `hargakek` (
  6.   `idkek` VARCHAR(20) CHARACTER SET latin1 NOT NULL,
  7.   `saiz` VARCHAR(20) CHARACTER SET latin1 DEFAULT NULL,
  8.   `harga` DECIMAL(10,2) NOT NULL,
  9.   `oum` VARCHAR(20) CHARACTER SET latin1 DEFAULT NULL,
  10.   `hu16` DECIMAL(10,2) NOT NULL,
  11.   `hu25` DECIMAL(10,2) NOT NULL,
  12.   `hu50` DECIMAL(10,2) NOT NULL,
  13.   `hu100` DECIMAL(10,2) NOT NULL
  14. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  15.  
  16. --
  17. -- Dumping data for table `hargakek`
  18. --
  19.  
  20. INSERT INTO `hargakek` (`idkek`, `saiz`, `harga`, `oum`, `hu16`, `hu25`, `hu50`, `hu100`) VALUES
  21. ('P1001', '', '0.40', 'biji', '6.40', '10.00', '20.00', '40.00'),
  22. ('P1002', '', '0.40', 'biji', '6.40', '10.00', '20.00', '40.00'),
  23. ('P1003', '', '0.40', 'biji', '6.40', '10.00', '20.00', '40.00'),
  24. ('P1004', '', '0.40', 'biji', '6.40', '10.00', '20.00', '40.00'),
  25. ('K1001', '', '45.00', 'kg', '720.00', '1125.00', '2250.00', '4500.00'),
  26. ('K1002', '', '80.00', 'kg', '1280.00', '2000.00', '4000.00', '8000.00'),
  27. ('K1003', '', '45.00', 'kg', '720.00', '1125.00', '2250.00', '4500.00'),
  28. ('K1004', '', '40.00', 'kg', '640.00', '1000.00', '2000.00', '4000.00'),
  29. ('K1005', '', '45.00', 'kg', '720.00', '1125.00', '2250.00', '4500.00'),
  30. ('K1006', '', '45.00', 'kg', '720.00', '1125.00', '2250.00', '4500.00'),
  31. ('KC1001', 'medium', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  32. ('KC1001', 'besar', '2.80', 'biji', '44.80', '70.00', '140.00', '280.00'),
  33. ('KC1002', 'medium', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  34. ('KC1002', 'besar', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  35. ('KC1003', 'medium', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  36. ('KC1003', 'besar', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  37. ('KC1004', 'medium', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  38. ('KC1004', 'besar', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  39. ('KC1005', 'medium', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  40. ('KC1005', 'besar', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  41. ('KC1006', 'medium', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  42. ('KC1006', 'besar', '2.80', 'biji', '44.80', '70.00', '140.00', '280.00'),
  43. ('KC1007', 'medium', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  44. ('KC1007', 'besar', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  45. ('KC1008', 'medium', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  46. ('KC1008', 'besar', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  47. ('KC1009', 'medium', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  48. ('KC1009', 'besar', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  49. ('KC1010', 'medium', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  50. ('KC1010', 'besar', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  51. ('KC1011', 'medium', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  52. ('KC1011', 'besar', '2.80', 'biji', '44.80', '70.00', '140.00', '280.00'),
  53. ('KC1012', 'medium', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  54. ('KC1012', 'besar', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  55. ('KC1013', 'medium', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  56. ('KC1013', 'besar', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  57. ('KC1014', 'medium', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  58. ('KC1014', 'besar', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  59. ('KC1015', 'medium', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  60. ('KC1015', 'besar', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  61. ('KC1015', 'mini', '1.50', 'biji', '24.00', '37.50', '75.00', '150.00'),
  62. ('KC1016', 'medium', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  63. ('KC1016', 'besar', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  64. ('KC1017', 'medium', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  65. ('KC1017', 'besar', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  66. ('KC1018', 'medium', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  67. ('KC1018', 'besar', '2.80', 'biji', '44.80', '70.00', '140.00', '280.00'),
  68. ('KCF1001', '', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  69. ('KCF1002', '', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  70. ('KCF1003', '', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  71. ('KCF1004', '', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  72. ('KCF1005', '', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  73. ('KCF1006', '', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  74. ('KCB1001', 'medium', '2.80', 'biji', '44.80', '70.00', '140.00', '280.00'),
  75. ('KCB1001', 'besar', '3.00', 'biji', '48.00', '75.00', '150.00', '300.00'),
  76. ('KCB1002', 'medium', '2.80', 'biji', '44.80', '70.00', '140.00', '280.00'),
  77. ('KCB1002', 'besar', '3.00', 'biji', '48.00', '75.00', '150.00', '300.00'),
  78. ('KCB1003', 'medium', '2.80', 'biji', '44.80', '70.00', '140.00', '280.00'),
  79. ('KCB1003', 'besar', '3.00', 'biji', '48.00', '75.00', '150.00', '300.00'),
  80. ('KCB1004', 'medium', '2.80', 'biji', '44.80', '70.00', '140.00', '280.00'),
  81. ('KCB1004', 'besar', '3.00', 'biji', '48.00', '75.00', '150.00', '300.00'),
  82. ('KCB1005', 'medium', '2.80', 'biji', '44.80', '70.00', '140.00', '280.00'),
  83. ('KCB1005', 'besar', '3.00', 'biji', '48.00', '75.00', '150.00', '300.00'),
  84. ('KCB1006', 'medium', '2.80', 'biji', '44.80', '70.00', '140.00', '280.00'),
  85. ('KCB1006', 'besar', '3.00', 'biji', '48.00', '75.00', '150.00', '300.00'),
  86. ('KCM1001', 'medium', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  87. ('KCM1001', 'besar', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  88. ('KCM1002', 'medium', '2.30', 'biji', '36.80', '57.50', '115.00', '230.00'),
  89. ('KCM1002', 'besar', '2.50', 'biji', '40.00', '62.50', '125.00', '250.00'),
  90. ('KP1001', '', '50.00', 'kg', '800.00', '1250.00', '2500.00', '5000.00'),
  91. ('KP1002', '', '2.00', 'biji', '32.00', '50.00', '100.00', '200.00'),
  92. ('T1001', '', '0.80', 'biji', '12.80', '20.00', '40.00', '80.00'),
  93. ('T1002', '', '0.80', 'biji', '12.80', '20.00', '40.00', '80.00'),
  94. ('T1003', '', '0.80', 'biji', '12.80', '20.00', '40.00', '80.00'),
  95. ('T1004', '', '1.00', 'biji', '16.00', '25.00', '50.00', '100.00');
  96.  
  97. -- --------------------------------------------------------
  98.  
  99. --
  100. -- Table structure for table `senaraikek`
  101. --
  102.  
  103. CREATE TABLE IF NOT EXISTS `senaraikek` (
  104.   `idkek` VARCHAR(50) NOT NULL,
  105.   `namakek` VARCHAR(50) NOT NULL,
  106.   `kategori` VARCHAR(20) NOT NULL,
  107.   `catatan` text NOT NULL,
  108.   PRIMARY KEY  (`idkek`)
  109. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  110.  
  111. --
  112. -- Dumping data for table `senaraikek`
  113. --
  114.  
  115. INSERT INTO `senaraikek` (`idkek`, `namakek`, `kategori`, `catatan`) VALUES
  116. ('K1001', 'Kek Buah', 'kek', ''),
  117. ('K1002', 'Kek Ros bersalut Fondant', 'kek', ''),
  118. ('K1003', 'Kek Oreo', 'kek', ''),
  119. ('K1004', 'Kek Krim Vanilla', 'kek', ''),
  120. ('K1005', 'Kek Kiwi', 'kek', ''),
  121. ('K1006', 'Kek Buah', 'kek', ''),
  122. ('KC1001', 'Kek Cawan Oreo', 'kek cawan', ''),
  123. ('KC1002', 'Kek Cawan Vanilla', 'kek cawan', ''),
  124. ('KC1003', 'kek cawan', 'kek cawan', ''),
  125. ('KC1004', 'kek cawan', 'kek cawan', ''),
  126. ('KC1005', 'kek cawan', 'kek cawan', ''),
  127. ('KC1006', 'kek cawan', 'kek cawan', ''),
  128. ('KC1007', 'kek cawan', 'kek cawan', ''),
  129. ('KC1008', 'kek cawan', 'kek cawan', ''),
  130. ('KC1009', 'kek cawan', 'kek cawan', ''),
  131. ('KC1010', 'kek cawan', 'kek cawan', ''),
  132. ('KC1011', 'kek cawan', 'kek cawan', ''),
  133. ('KC1012', 'kek cawan', 'kek cawan', ''),
  134. ('KC1013', 'kek cawan', 'kek cawan', ''),
  135. ('KC1014', 'kek cawan', 'kek cawan', ''),
  136. ('KC1015', 'kek cawan', 'kek cawan', ''),
  137. ('KC1016', 'kek cawan', 'kek cawan', ''),
  138. ('KC1017', 'kek cawan', 'kek cawan', ''),
  139. ('KC1018', 'kek cawan', 'kek cawan', ''),
  140. ('KCB1001', 'Kek Cawan Buah', 'kek cawan buah', 'Tambahan Coklat = RM 1.00'),
  141. ('KCB1002', 'Kek Cawan Buah', 'kek cawan buah', 'Tambahan Coklat = RM 1.00'),
  142. ('KCB1003', 'Kek Cawan Buah', 'kek cawan buah', 'Tambahan Coklat = RM 1.00'),
  143. ('KCB1004', 'Kek Cawan Buah', 'kek cawan buah', 'Tambahan Coklat = RM 1.00'),
  144. ('KCB1005', 'Kek Cawan Buah', 'kek cawan buah', 'Tambahan Coklat = RM 1.00'),
  145. ('KCB1006', 'Kek Cawan Buah', 'kek cawan buah', 'Tambahan Coklat = RM 1.00'),
  146. ('KCF1001', 'Kek cawan fondant', 'kek cawan fondant', 'Tambahan Fondant =  RM20 - RM40 mengikut permintaan'),
  147. ('KCF1002', 'Kek cawan fondant', 'kek cawan fondant', 'Tambahan Fondant =  RM20 - RM40 mengikut permintaan'),
  148. ('KCF1003', 'Kek cawan fondant', 'kek cawan fondant', 'Tambahan Fondant =  RM20 - RM40 mengikut permintaan'),
  149. ('KCF1004', 'Kek cawan fondant', 'kek cawan fondant', 'Tambahan Fondant =  RM20 - RM40 mengikut permintaan'),
  150. ('KCF1005', 'Kek cawan fondant', 'kek cawan fondant', 'Tambahan Fondant =  RM20 - RM40 mengikut permintaan'),
  151. ('KCF1006', 'Kek cawan fondant', 'kek cawan fondant', 'Tambahan Fondant =  RM20 - RM40 mengikut permintaan'),
  152. ('KCM1001', 'Kek Cawan Muffin (Oreo)', 'kek cawan muffin', ''),
  153. ('KCM1002', 'Kek Cawan Muffin (Vanilla)', 'kek cawan muffin', ''),
  154. ('KP1001', 'Kek Pavlova', 'kek pavlova', ''),
  155. ('KP1002', 'Kek Mini Pavlova', 'kek pavlova', ''),
  156. ('P1001', 'Apam polkadot', 'apam', ''),
  157. ('P1002', 'Apam polkadot', 'apam', ''),
  158. ('P1003', 'Apam polkadot', 'apam', ''),
  159. ('P1004', 'Apam polkadot', 'apam', ''),
  160. ('T1001', 'Tart Buah', 'tart buah', ''),
  161. ('T1002', 'Tart Buah', 'tart buah', ''),
  162. ('T1003', 'Tart Buah', 'tart buah', ''),
  163. ('T1004', 'Tart Buah', 'tart buah', 'Tambahan Coklat = RM 1.00');
Advertisement
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!