-- http://www.phpmyadmin.net
--




--
-- Database: `laundry`
--

-- --------------------------------------------------------

--
-- Table structure for table `bulk`
--

CREATE TABLE IF NOT EXISTS `bulk` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bulkid` int(11) NOT NULL,
  `custid` varchar(20) NOT NULL,
  `bulkdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `bulkprice` float NOT NULL,
  `bulkweight` double NOT NULL,
  `bulkAnti` int(11) NOT NULL,
  `bulkSoft` int(11) NOT NULL,
  `bulkSpecial` varchar(200) NOT NULL,
  `bulkstatus` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `bulk`
--

INSERT INTO `bulk` (`id`, `bulkid`, `custid`, `bulkdate`, `bulkprice`, `bulkweight`, `bulkAnti`, `bulkSoft`, `bulkSpecial`, `bulkstatus`) VALUES
(1, 1, 'U2093027503', '2010-10-04 10:08:33', 3, 2, 1, 1, 'Use softlan softener', 3);

-- --------------------------------------------------------

--
-- Table structure for table `customers`
--

CREATE TABLE IF NOT EXISTS `customers` (
  `custid` varchar(20) NOT NULL,
  `custname` varchar(50) NOT NULL,
  `custaddr` varchar(200) NOT NULL,
  `custtel` varchar(10) NOT NULL,
  PRIMARY KEY (`custid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`custid`, `custname`, `custaddr`, `custtel`) VALUES
('U417893751', 'Haziman Hashim', '44 Paya', '0142761522'),
('U2093027503', '3324', '234234', '242424'),
('U485334081', 'Jiman Jiman', '44A Kg Paya Mengkuang 81560 Gelang Patah Johor Bahru Johor', '0142762522'),
('U305970182', 'wrrw', 'werwerwer', 'wrwrwr');

-- --------------------------------------------------------

--
-- Table structure for table `items`
--

CREATE TABLE IF NOT EXISTS `items` (
  `itemid` int(11) NOT NULL AUTO_INCREMENT,
  `itemname` varchar(50) NOT NULL,
  `itemdesc` varchar(200) NOT NULL,
  `ppu` double NOT NULL,
  PRIMARY KEY (`itemid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=101 ;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`itemid`, `itemname`, `itemdesc`, `ppu`) VALUES
(1, 'Suits - 3pc', 'blablablabla', 5.5),
(2, 'Suits - 2pc', 'blablablablabla', 4.5),
(100, 'Other', 'Additional Instructions', 0);

-- --------------------------------------------------------

--
-- Table structure for table `orders`
--

CREATE TABLE IF NOT EXISTS `orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orderid` int(11) NOT NULL,
  `orderdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `custid` varchar(20) NOT NULL,
  `itemid` int(11) NOT NULL,
  `orderqty` int(11) NOT NULL,
  `ordertype` int(11) NOT NULL,
  `extra_data` varchar(200) NOT NULL,
  `orderstatus` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `orderid`, `orderdate`, `custid`, `itemid`, `orderqty`, `ordertype`, `extra_data`, `orderstatus`) VALUES
(1, 1, '2010-10-04 09:28:19', 'U2093027503', 2, 5, 1, 'Fold,', 3),
(2, 1, '2010-10-04 09:28:19', 'U2093027503', 100, 1, 1, 'add something here', 3),
(3, 2, '2010-10-04 11:49:15', 'U485334081', 1, 2, 1, 'Fold,Hang', 3),
(4, 2, '2010-10-04 11:49:15', 'U485334081', 100, 1, 1, 'Plus iron', 3),
(5, 3, '2010-10-04 21:23:26', 'U417893751', 1, 2, 1, 'Fold,Hang', 0);
