update bidding set won=0 where id=1;
update bidding set won=0 where id=2;
update bidding set won=0 where id=3;
update bidding set won=0 where id=4;
update bidding set won=0 where id=5;
update bidding set won=0 where id=6;
update bidding set won=0 where id=7;
update bidding set won=0 where id=8;
update bidding set won=0 where id=9;
update bidding set won=0 where id=10;
update bidding set won=0 where id=11;
update bidding set won=0 where id=12;
update bidding set won=0 where id=13;
update bidding set won=0 where id=14;
update product set progressed=1 where id=1;
update product set progressed=1 where id=2;
update product set progressed=1 where id=3;
update product set progressed=1 where id=4;
update product set progressed=1 where id=5;
update product set progressed=1 where id=6;
update product set progressed=1 where id=7;
update product set progressed=1 where id=8;
update product set progressed=1 where id=9;
update product set progressed=1 where id=10;
update product set progressed=1 where id=11;
update product set progressed=1 where id=12;
update product set progressed=1 where id=13;
update product set progressed=1 where id=14;
update product set progressed=1 where id=15;
update product set progressed=1 where id=16;
update product set progressed=1 where id=17;
update product set progressed=1 where id=18;
update product set progressed=1 where id=19;
update product set progressed=1 where id=20;
update product set expire_at='2022-08-16T12:45:00' where id=1;
update product set expire_at='2022-08-16T14:45:00' where id=2;
update product set expire_at='2022-08-16T14:40:00' where id=3;
update product set expire_at='2022-08-16T13:08:00' where id=4;
update product set expire_at='2022-08-16T14:25:00' where id=5;
update product set expire_at='2022-08-16T14:30:00' where id=6;
update product set expire_at='2022-08-16T14:45:00' where id=7;
update product set expire_at='2022-08-16T14:50:00' where id=8;
update product set expire_at='2022-08-16T14:55:00' where id=9;
update product set expire_at='2022-08-16T15:00:00' where id=10;
update product set expire_at='2022-08-16T15:05:00' where id=11;
update product set expire_at='2022-08-16T15:10:00' where id=12;
update product set expire_at='2022-08-16T15:15:00' where id=13;
update product set expire_at='2022-08-16T15:20:00' where id=14;
update product set expire_at='2022-08-16T15:25:00' where id=16;
update product set expire_at='2022-08-16T15:30:00' where id=17;
update product set expire_at='2022-08-16T15:35:00' where id=18;
update product set expire_at='2022-08-16T15:40:00' where id=19;
update product set expire_at='2022-08-16T15:45:00' where id=20;
INSERT INTO `product`(title, `description`, minimum_price, category, location, thumbnail_image,
progressed, expire_at, created_at, user_id)
VALUES ('M1 맥북프로 13',
'M1 MacBook Pro 13인치 판매합니다.
회사에서 사용하던 제품이라 상태 좋고, 초기화 되어 있습니다.
[사양]
- Apple M1 CPU
- 16GB 메모리
- 256GB SSD
- 배터리 (57 Cycle, 100%)
[구성]
- 맥북
- 전원선
회사에서 판매하는 제품이라 삼성중앙역에서만 거래가 가능합니다.
전자제품 특성상 교환 및 취소가 어렵습니다.',
600000, 'DIGITAL_DEVICE', '제주 서귀포시 동홍동',
'https://dnvefa72aowie.cloudfront.net/origin/article/202207/adf7131956708b6221ff430f840e75f0065fd0fc1edbaa9219f9eac4bd50da5b.webp?q=95&s=1440x1440&t=inside',
1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 1);
update image set url = 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/E9CD41986EC23E8E7DD6451502CC596787F59A0CC41CF5CD7EAD01BC25A3DC87.jpg?q=95&s=1440x1440&t=inside' where id=51;
update image set url = 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/076CF2B8987D36C61C1480856DE886E5F51B6AEF1C4C57C5F42CE69E8F3F9966.jpg?q=95&s=1440x1440&t=inside' where id=52;
delete from product where id=30;
delete from image where product_id=30;
delete from notification where product_id=30;
INSERT INTO `image`(product_id,url,`order`,created_at)
VALUES (50, 'https://dnvefa72aowie.cloudfront.net/origin/article/202206/4CB30B6DA5F5388D591B9A05FF752EE648BAFAB765F1A40E7AA8DBC01F9922CF.jpg?q=95&s=1440x1440&t=inside', 1, '2022-07-21T14:47:00'),
(51, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/9d0d88038818aa4ae16532e9e01ba7f1069f3dd537c7e65db6d6eff77fd6aa91.webp?q=95&s=1440x1440&t=inside', 1, '2022-07-21T14:47:00'),
(52, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/479f19089a29db8f4b07cc07b485b794bc10ff884355dadbfee173dfaa712bfb.webp?q=95&s=1440x1440&t=inside', 1, '2022-07-21T14:47:00'),
(52, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/0561e9e9555c49ebadcfdd29e918b566caada163b209828a820bddca6cb8b719.webp?q=95&s=1440x1440&t=inside', 2, '2022-07-21T14:47:00'),
(52, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/99c654fd4496de3f1863072b5364cc764ba6f222cdd4674a700cf621460e7d0a.webp?q=95&s=1440x1440&t=inside', 3, '2022-07-21T14:47:00'),
(53, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/F04E734834A284763D1D740E9DD26E513D6B50D69FB357A72DA572EB06CA0E69.jpg?q=95&s=1440x1440&t=inside', 1, '2022-07-21T14:47:00'),
(53, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/A43AA0B4110013AB6834B86090EC62EE4D03DBAFDED976E2723428126B3D6953.jpg?q=95&s=1440x1440&t=inside', 2, '2022-07-21T14:47:00'),
(53, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/09F0E5F9B07D9B18A7513FC5F2B4686DAA9A093D9E754227D0260ED02B9A6AF4.jpg?q=95&s=1440x1440&t=inside', 3, '2022-07-21T14:47:00'),
(54, 'https://dnvefa72aowie.cloudfront.net/origin/article/202206/295C3D0C49B044FA087B2123237537453D7E9827E6E5A23F6EF1061C33416CF1.jpg?q=95&s=1440x1440&t=inside', 1, '2022-07-21T14:47:00'),
(54, 'https://dnvefa72aowie.cloudfront.net/origin/article/202206/F5D3D30AC8242BD2D5714E09E26E864B0727457B9B826984FAE6D56F9102EB3D.jpg?q=95&s=1440x1440&t=inside', 2, '2022-07-21T14:47:00'),
(54, 'https://dnvefa72aowie.cloudfront.net/origin/article/202206/555E23BAE3AC46827BA200BB929BC69CCFE38FFA62D64A7226BD5D08E014A996.jpg?q=95&s=1440x1440&t=inside', 3, '2022-07-21T14:47:00'),
(55, 'https://dnvefa72aowie.cloudfront.net/origin/article/202207/D1C5535E090FAAF7C6C6632DB39443922A7F751E1D516AF2D3839C49EBBE170A.jpg?q=95&s=1440x1440&t=inside', 1, '2022-07-21T14:47:00'),
(56, 'https://dnvefa72aowie.cloudfront.net/origin/article/202207/26aef1be795eeeef50b8636c721f1c5c379bd6d17aaf2c4bd244340e5487d87b.webp?q=95&s=1440x1440&t=inside', 1, '2022-07-21T14:47:00'),
(56, 'https://dnvefa72aowie.cloudfront.net/origin/article/202207/9dd3202e0f6eb1dbc9bdbd9ea39ed9b6da56cef0c9a0f0f7b453144b27fe78ee.webp?q=95&s=1440x1440&t=inside', 2, '2022-07-21T14:47:00'),
(57, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/CA8A1BF0388F5C7E24B97CC66E5BF4A3DFA72ECF4D397610E2557AE8763C7CCD.jpg?q=95&s=1440x1440&t=inside', 1, '2022-07-21T14:47:00'),
(57, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/FBEA9CEF72CEA507AF331409BE80BDEB4465128954D7D8E12E3B5AAC37AC6C93.jpg?q=95&s=1440x1440&t=inside', 2, '2022-07-21T14:47:00'),
(57, 'https://dnvefa72aowie.cloudfront.net/origin/article/202208/1B83C5DF48D4D9F46029FC09B49DE351EC99CE76A0D5736A32D76C4836C4A2C0.jpg?q=95&s=1440x1440&t=inside', 3, '2022-07-21T14:47:00');
INSERT INTO `product`(title, `description`, minimum_price, category, location, thumbnail_image,
progressed, expire_at, created_at, user_id)
VALUES ('에어포스 나이키 포스 신발',
'나이키 공홈 구매 정품입니다
직거래시 나이키 쇼핑백에 넣어드려요
제가 계신곳으로 이동하고요
직거래시 거파 방지 예약금(홀드금) 1만원
받고 진행합니다
현장에서 차액 주시면되요
당일 거래파기시 홀드금 환불 없습니다
(직거래 잡고 연락두절인 사람이 많습니다)
택배거래는 택포 가격 16.5
직거래시 17
제 위치로 오시면 16
우체국으로 당일 운송장 드려요
(배송비만 4000원 택포로 드려요)
',
170000, 'MAN_FASHION_GOODS', '서울역',
'https://dnvefa72aowie.cloudfront.net/origin/article/202206/4CB30B6DA5F5388D591B9A05FF752EE648BAFAB765F1A40E7AA8DBC01F9922CF.jpg?q=95&s=1440x1440&t=inside',
1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 7),
('나이키덩크하이범고래 신발',
'광복 나이키 구매 상품 나코텝
덩크로우 범고래265랑 교신가능',
180000, 'MAN_FASHION_GOODS', '서울역',
'https://dnvefa72aowie.cloudfront.net/origin/article/202208/9d0d88038818aa4ae16532e9e01ba7f1069f3dd537c7e65db6d6eff77fd6aa91.webp?q=95&s=1440x1440&t=inside',
1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 7),
('에어조던1미드브레드밴드 신발',
'새상품입니다
에어조던1미드브레드밴드
260
슬램덩크 강백호신발',
150000, 'MAN_FASHION_GOODS', '서울역',
'https://dnvefa72aowie.cloudfront.net/origin/article/202208/479f19089a29db8f4b07cc07b485b794bc10ff884355dadbfee173dfaa712bfb.webp?q=95&s=1440x1440&t=inside',
1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 7),
('호피탭 골구 골든구스 신발',
'******마지막 가격 입니다******
골든구스 수퍼스타 호피탭
사이즈: 35사이즈 225-230신으면 잘 맞아요
(전 보통 구두, 운동화 모두 230신어요)
구입가격 : 50만원대 / 구입은 3년 정도 된것 같은데
원래 빈티지 하게 나왔고 굽닳음 별로 없어요
안쪽 살짝 속굽 있는 모델이라 신음 키도 커보이고
편하고 이뻐요^^
직거래,택배거래 가능
택배 선불시 +2900/ 반값 택배시 ***-****-**** 원
교환 반품 환불 안되니 신중거래 부탁드려요',
100000, 'WOMAN_GOODS', '서울역',
'https://dnvefa72aowie.cloudfront.net/origin/article/202208/F04E734834A284763D1D740E9DD26E513D6B50D69FB357A72DA572EB06CA0E69.jpg?q=95&s=1440x1440&t=inside',
1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 7),
('레오파드탭 슈퍼스타 신발',
'선물받은건데 별로 신지않았구요
가산디지털단지 또는 현대아울렛 앞에서 직거래원해요
사이즈는 37이구요
제가 235인데 딱맞았어요
230-235 생각하시면될꺼같아요',
120000, 'WOMAN_GOODS', '서울역',
'https://dnvefa72aowie.cloudfront.net/origin/article/202206/295C3D0C49B044FA087B2123237537453D7E9827E6E5A23F6EF1061C33416CF1.jpg?q=95&s=1440x1440&t=inside',
1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 7),
('반스 레드 반스245 신발',
'abc마트 매장에서 3일 전에 구매한 거의 새상품입니다. 집 근처에 잠깐 신었는데 저한테는 너무 크네요.
택, 박스, 쇼핑백 모두 있습니다.
교환은 하지않습니다. 직거래 가능합니다.
배송비는 포함되지 않은 가격입니다.
반값택배, 일반택배 모두 가능합니다.',
59000, 'WOMAN_GOODS', '서울역',
'https://dnvefa72aowie.cloudfront.net/origin/article/202207/D1C5535E090FAAF7C6C6632DB39443922A7F751E1D516AF2D3839C49EBBE170A.jpg?q=95&s=1440x1440&t=inside',
1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 7),
('토리버치 플랫 신발',
'토리버치 슬립온 8 사이즈 입니다(250)
토리버치 슬립온입니다
해외에서 사와서 한국에 없는 디자인이예요
몇번 안신었구요
가죽이라 부드럽고 신으면 더 고급져 보여요
녹양역,가능역부근 입니다
집앞 거래 합니다',
50000, 'WOMAN_GOODS', '서울역',
'https://dnvefa72aowie.cloudfront.net/origin/article/202207/26aef1be795eeeef50b8636c721f1c5c379bd6d17aaf2c4bd244340e5487d87b.webp?q=95&s=1440x1440&t=inside',
1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 7),
('구찌 신발 쇼핑백, 발렌시아가 수트케이스',
'각 만원이며 수트케이스만 2만원입니다!
직거래시 저희 집앞입니다~
사진순서대로 크기 측정해놨습니다~
2번은 두개이상 구매시에 그냥 드리겠습니다 보니깐 상태가 별로네요ㅜ
1번- 가로32 세로45 폭13
2번- 가로45 세로36 폭16(모서리 살짝 까짐)
3번- 가로45 세로36 폭16
수트케이스- 가로63 세로120 (어지간한거 다들어갑니다)',
10000, 'WOMAN_GOODS', '서울역',
'https://dnvefa72aowie.cloudfront.net/origin/article/202208/CA8A1BF0388F5C7E24B97CC66E5BF4A3DFA72ECF4D397610E2557AE8763C7CCD.jpg?q=95&s=1440x1440&t=inside',
1, '2022-08-16T15:00:00', '2022-07-21T14:47:00', 7);