# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# È£½ºÆ®: localhost
# ó¸®ÇÑ ½Ã°£: 04-10-02 13:27 
# ¼­¹ö ¹öÀü: 4.0.18
# PHP ¹öÀü: 4.3.6
# 
# µ¥ÀÌÅͺ£À̽º : `bag`
# 

# --------------------------------------------------------

#
# Å×ÀÌºí ±¸Á¶ `cart`
#

CREATE TABLE `cart` (
  `id` int(4) NOT NULL auto_increment,
  `oid` varchar(40) default NULL,
  `ordernum` int(4) default NULL,
  `pid` int(4) default NULL,
  `color` varchar(30) default NULL,
  `signdate` date default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

#
# Å×À̺íÀÇ ´ýÇÁ µ¥ÀÌÅÍ `cart`
#


# --------------------------------------------------------

#
# Å×ÀÌºí ±¸Á¶ `customer`
#

CREATE TABLE `customer` (
  `id` int(4) NOT NULL auto_increment,
  `fname` varchar(30) default NULL,
  `lname` varchar(30) default NULL,
  `email` varchar(60) default NULL,
  `phone` varchar(30) default NULL,
  `fax` varchar(30) default NULL,
  `address` varchar(70) default NULL,
  `state` varchar(30) default NULL,
  `other` varchar(40) default NULL,
  `country` varchar(30) default NULL,
  `sfname` varchar(40) default NULL,
  `slname` varchar(30) default NULL,
  `semail` varchar(30) default NULL,
  `sphone` varchar(30) default NULL,
  `sfax` varchar(30) default NULL,
  `saddress` varchar(30) default NULL,
  `sstate` varchar(30) default NULL,
  `sother` varchar(30) default NULL,
  `scountry` varchar(30) default NULL,
  `signdate` date default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

#
# Å×À̺íÀÇ ´ýÇÁ µ¥ÀÌÅÍ `customer`
#

INSERT INTO `customer` (`id`, `fname`, `lname`, `email`, `phone`, `fax`, `address`, `state`, `other`, `country`, `sfname`, `slname`, `semail`, `sphone`, `sfax`, `saddress`, `sstate`, `sother`, `scountry`, `signdate`) VALUES (1, '4', '4', '4', '4', '4', '4', 'MB', '4', 'WF', '4', '4', '4', '4', '4', '4', 'MB', '4', 'WF', '0000-00-00');
INSERT INTO `customer` (`id`, `fname`, `lname`, `email`, `phone`, `fax`, `address`, `state`, `other`, `country`, `sfname`, `slname`, `semail`, `sphone`, `sfax`, `saddress`, `sstate`, `sother`, `scountry`, `signdate`) VALUES (2, '4', '4', '4', '4', '4', '4', 'MB', '4', 'WF', '4', '4', '4', '4', '4', '4', 'MB', '4', 'WF', '0000-00-00');
INSERT INTO `customer` (`id`, `fname`, `lname`, `email`, `phone`, `fax`, `address`, `state`, `other`, `country`, `sfname`, `slname`, `semail`, `sphone`, `sfax`, `saddress`, `sstate`, `sother`, `scountry`, `signdate`) VALUES (3, 'd', 'dsf', 'sdf', 'dsf', 'ds', 'df', 'MS', 'dsf', 'ZR', 'd', 'dsf', 'sdf', 'dsf', 'ds', 'df', 'MS', 'dsf', 'ZR', '0000-00-00');

# --------------------------------------------------------

#
# Å×ÀÌºí ±¸Á¶ `porder`
#

CREATE TABLE `porder` (
  `id` int(4) NOT NULL auto_increment,
  `mid` int(4) default NULL,
  `oid` varchar(40) default NULL,
  `ordernum` int(4) default NULL,
  `pid` int(4) default NULL,
  `color` varchar(30) default NULL,
  `signdate` date default NULL,
  `progress` enum('O','P','F') default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=20 ;

#
# Å×À̺íÀÇ ´ýÇÁ µ¥ÀÌÅÍ `porder`
#

INSERT INTO `porder` (`id`, `mid`, `oid`, `ordernum`, `pid`, `color`, `signdate`, `progress`) VALUES (17, 1, '1629812261', 5, 18, 'Baby Red', '2004-10-02', 'O');
INSERT INTO `porder` (`id`, `mid`, `oid`, `ordernum`, `pid`, `color`, `signdate`, `progress`) VALUES (18, 2, '1629812261', 3, 18, 'Baby Red', '2004-10-02', 'O');
INSERT INTO `porder` (`id`, `mid`, `oid`, `ordernum`, `pid`, `color`, `signdate`, `progress`) VALUES (19, 3, '1629812261', 6, 18, 'Baby Red', '2004-10-02', 'O');

# --------------------------------------------------------

#
# Å×ÀÌºí ±¸Á¶ `product`
#

CREATE TABLE `product` (
  `id` int(4) NOT NULL auto_increment,
  `name` varchar(40) default NULL,
  `price` varchar(40) default NULL,
  `balance` int(6) default '0',
  `image` varchar(50) default NULL,
  `contents` text,
  `position` int(2) default NULL,
  `output` enum('Y','N') default NULL,
  `signdate` date default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=19 ;

#
# Å×À̺íÀÇ ´ýÇÁ µ¥ÀÌÅÍ `product`
#

INSERT INTO `product` (`id`, `name`, `price`, `balance`, `image`, `contents`, `position`, `output`, `signdate`) VALUES (16, 'sdf', 'sdf', 0, '10812_bag_1.gif', 'sdf', 1, '', '2004-10-02');
INSERT INTO `product` (`id`, `name`, `price`, `balance`, `image`, `contents`, `position`, `output`, `signdate`) VALUES (17, 'sfd', 'sdf', 0, '17785_bag_1.gif', 'sdf', 0, '', '2004-10-02');
INSERT INTO `product` (`id`, `name`, `price`, `balance`, `image`, `contents`, `position`, `output`, `signdate`) VALUES (18, 'sdf', 'sdf', 0, '37851_bag_p.gif', 'sdf', 0, 'Y', '2004-10-02');