/*
SQLyog Enterprise - MySQL GUI v6.07
Host - 4.0.20a-nt : Database - project
*********************************************************************
Server version : 4.0.20a-nt
*/
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*Table structure for table `daysales` */
CREATE TABLE `daysales` (
`idx` int(10) unsigned NOT NULL auto_increment,
`order_num` varchar(20) NOT NULL default '',
`saleYMD` datetime default NULL,
`code` varchar(50) NOT NULL default '',
`Qty` int(5) unsigned NOT NULL default '1',
`Member_id` varchar(20) NOT NULL default '',
`pay_state` varchar(10) NOT NULL default '',
`post_state` varchar(10) NOT NULL default '',
`memo` text,
`opt` varchar(10) NOT NULL default '',
`pay_kind` varchar(6) NOT NULL default '',
PRIMARY KEY (`order_num`),
KEY `idx` (`idx`)
) TYPE=MyISAM;
/*Data for the table `daysales` */
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (1,'20080501_001','2008-05-01 00:00:00','an001',2,'a003','입금확인','배송완료',NULL,'255','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (2,'20080501_002','2008-05-01 00:00:00','am001',5,'a002','입금확인','배송완료',NULL,'250','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (3,'20080501_003','2008-05-01 00:00:00','au002',2,'a033','입금확인','배송완료',NULL,'270','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (4,'20080501_004','2008-05-01 00:00:00','bp001',1,'a008','입금확인','배송완료',NULL,'270','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (5,'20080501_005','2008-05-01 16:22:00','ap001',1,'a001','입금확인','배송완료',NULL,'275','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (6,'20080501_006','2008-05-01 16:22:33','ap002',3,'a002','입금확인','배송완료',NULL,'270','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (7,'20080501_007','2008-05-01 11:22:00','ap003',2,'a004','입금확인','배송완료',NULL,'275','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (8,'20080501_008','2008-05-01 05:22:00','bn001',1,'a001','입금확인','배송완료',NULL,'95','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (9,'20080501_009','2008-05-01 01:00:00','bn001',2,'a006','입금확인','배송완료',NULL,'100','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (10,'20080501_010','2008-05-01 05:00:00','bn001',1,'a007','입금확인','배송완료',NULL,'105','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (11,'20080506_001','2008-05-06 12:00:00','bp001',1,'a003','입금확인','배송완료',NULL,'110','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (12,'20080506_002','2008-05-06 16:00:00','cn002',1,'a003','입금확인','배송완료',NULL,'80','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (13,'20080506_003','2008-05-06 14:00:00','bp001',1,'a006','입금확인','배송완료',NULL,'100','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (14,'20080506_004','2008-05-06 00:00:00','dd001',3,'a011','입금확인','배송완료',NULL,'free','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (15,'20080506_005','2008-05-06 11:00:00','cn002',2,'a010','입금확인','배송완료',NULL,'85','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (16,'20080506_006','2008-05-06 00:00:00','cn002',1,'a013','입금확인','배송완료',NULL,'90','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (17,'20080511_001','2008-05-11 00:00:00','dd001',1,'a006','입금확인','배송완료',NULL,'free','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (18,'20080511_002','2008-05-11 00:00:00','dd001',1,'a015','입금확인','배송완료',NULL,'free','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (19,'20080511_003','2008-05-11 00:00:00','bp002',3,'a009','입금확인','배송완료',NULL,'100','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (20,'20080511_004','2008-05-11 00:00:00','bp002',3,'a009','입금확인','배송완료',NULL,'100','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (21,'20080511_005','2008-05-11 00:00:00','bp002',2,'a018','입금확인','배송완료',NULL,'100','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (22,'20080511_006','2008-05-11 00:00:00','bd002',1,'a020','입금확인','배송완료',NULL,'100','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (23,'20080511_007','2008-05-11 00:00:00','bd002',1,'a024','입금확인','배송완료',NULL,'100','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (24,'20080511_008','2008-05-11 00:00:00','bd002',2,'a021','입금확인','배송완료',NULL,'90','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (25,'20080511_009','2008-05-11 00:00:00','dd002',1,'a034','입금확인','배송완료',NULL,'free','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (26,'20080511_010','2008-05-11 00:00:00','ap003',2,'a024','입금확인','배송완료',NULL,'275','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (27,'20080511_011','2008-05-11 00:00:00','ap002',1,'a030','입금확인','배송완료',NULL,'275','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (28,'20080609_001','2008-06-09 00:00:00','an004',3,'a024','입금확인','배송완료',NULL,'265','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (29,'20080609_002','2008-06-09 00:00:00','an005',1,'a036','입금확인','배송완료',NULL,'255','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (30,'20080609_003','2008-06-09 00:00:00','ad005',1,'a024','입금확인','배송완료',NULL,'260','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (31,'20080609_004','2008-06-09 00:00:00','an005',2,'a018','입금확인','배송완료',NULL,'270','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (32,'20080612_001','2008-06-12 00:00:00','ad002',2,'a044','입금확인','배송완료',NULL,'270','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (33,'20080612_002','2008-06-12 00:00:00','ad004',1,'a041','입금확인','배송완료',NULL,'270','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (34,'20080612_003','2008-06-12 00:00:00','cd001',1,'a042','입금확인','배송완료',NULL,'80','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (35,'20080612_004','2008-06-12 00:00:00','cn001',1,'a042','입금확인','배송완료',NULL,'85','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (36,'20080612_005','2008-06-12 00:00:00','cp002',2,'a024','입금확인','배송완료',NULL,'90','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (37,'20080622_001','2008-06-22 00:00:00','cp002',1,'a050','입금확인','배송완료',NULL,'95','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (38,'20080622_002','2008-06-22 00:00:00','cn001',3,'a048','입금확인','배송완료',NULL,'85','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (39,'20080622_003','2008-06-22 00:00:00','cn001',1,'a043','입금확인','배송완료',NULL,'100','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (40,'20080622_004','2008-06-22 00:00:00','an001',1,'a049','입금확인','배송완료',NULL,'95','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (41,'20080627_001','2008-06-27 00:00:00','an001',1,'a050','입금확인','배송완료',NULL,'95','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (42,'20080627_002','2008-06-27 00:00:00','an005',1,'a010','입금확인','배송완료',NULL,'100','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (43,'20080627_003','2008-06-27 00:00:00','an005',1,'a011','입금확인','배송완료',NULL,'100','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (44,'20080627_004','2008-06-27 00:00:00','an005',2,'a012','입금확인','배송완료',NULL,'100','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (45,'20080627_005','2008-06-27 00:00:00','bd002',3,'a013','입금확인','배송완료',NULL,'80','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (46,'20080627_006','2008-06-27 00:00:00','bd002',1,'a014','입금확인','배송완료',NULL,'100','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (47,'20080627_007','2008-06-27 00:00:00','bd002',1,'a015','입금확인','배송완료',NULL,'100','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (48,'20080627_008','2008-06-27 00:00:00','bd002',1,'a016','입금확인','배송완료',NULL,'100','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (49,'20080627_009','2008-06-27 00:00:00','dd001',1,'a017','입금확인','배송완료',NULL,'free','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (50,'20080627_010','2008-06-27 00:00:00','dd001',2,'a018','입금확인','배송완료',NULL,'free','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (51,'20080627_011','2008-06-27 00:00:00','dd001',1,'a019','입금확인','배송완료',NULL,'free','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (52,'20080702_001','2008-07-02 00:00:00','an005',1,'a019','입금확인','배송완료',NULL,'275','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (53,'20080702_002','2008-07-02 00:00:00','ad002',1,'a019','입금확인','배송완료',NULL,'270','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (54,'20080702_003','2008-07-02 00:00:00','ad004',1,'a019','입금확인','배송완료',NULL,'270','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (55,'20080702_004','2008-07-02 00:00:00','cd001',1,'a030','입금확인','배송완료',NULL,'95','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (56,'20080703_001','2008-07-03 00:00:00','cn001',1,'a024','입금확인','배송완료',NULL,'95','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (57,'20080703_002','2008-07-03 00:00:00','cp002',1,'a036','입금확인','배송완료',NULL,'95','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (58,'20080703_003','2008-07-03 00:00:00','cp002',1,'a024','입금확인','배송완료',NULL,'90','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (59,'20080703_004','2008-07-03 00:00:00','cn002',1,'a018','입금확인','배송완료',NULL,'90','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (60,'20080704_001','2008-07-04 00:00:00','dd001',1,'a044','입금확인','배송완료',NULL,'free','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (61,'20080704_002','2008-07-04 00:00:00','dd001',1,'a041','입금확인','배송완료',NULL,'free','무통장');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (62,'20080704_003','2008-07-04 00:00:00','bp002',1,'a042','입금확인','배송완료',NULL,'95','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (63,'20080704_004','2008-07-04 00:00:00','bp002',1,'a042','입금확인','배송완료',NULL,'95','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (64,'20080704_005','2008-07-04 00:00:00','dd001',1,'a024','입금확인','배송완료',NULL,'free','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (65,'20080704_006','2008-07-04 00:00:00','dd001',1,'a050','입금확인','배송완료',NULL,'free','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (66,'20080704_007','2008-07-04 00:00:00','bp002',1,'a019','입금확인','배송완료',NULL,'90','카드');
insert into `daysales`(`idx`,`order_num`,`saleYMD`,`code`,`Qty`,`Member_id`,`pay_state`,`post_state`,`memo`,`opt`,`pay_kind`) values (67,'20080704_008','2008-07-04 00:00:00','bp002',1,'a019','입금확인','배송완료',NULL,'90','카드');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
[출처] modestia2004
"쇼핑몰·홈페이지·오픈마켓
블로그·페이스북·이메일 등의 각종 마케팅 글쓰기, 각종 광고, 영업, 판매, 제안서, 전단지 반응율 3배×10배 이상 높이는 마법의 8단계 공식" |
☞자세히보기 |
|
|