eghankook / 02.23.nicemul star
03-25
Closed
45 나이스물 초기화 해주세요 star
03-25 Closed
황순일 @eghankook
Issue Sharer
Comment 1
  • 김동주
    srirama 김동주 03-25 Reference in new issue
    • Markdown help
    • Header
    • Text Style
    • Link
    • List
    • Checklist
    • Image
    • Blockquote
    • Code
    • Table
    • Short Link
    • Markdown Input
      Markdown Output
      # This is an H1
## This is an H2
### This is an H3
      # This is an H1 ## This is an H2 ### This is an H3
    • Markdown Input
      Markdown Output
      *This is an italic*
**This is an bold**
~~This is an strike~~
      *This is an italic* **This is an bold** ~~This is an strike~~
    • Markdown Input
      Markdown Output
      [Site](http://yobi.io/ "Yobi Site")

http://yobi.io/
      [Site](http://yobi.io/ "Yobi Site") http://yobi.io/
    • Markdown Input
      Markdown Output
      - Red
    1. White
    2. Blue
- Green.
      - Red 1. White 2. Blue - Green
    • Markdown Input
      Markdown Output
      - [ ] Todos
    - [x] To do A
    - [ ] To do B
    - [ ] To do C
      • Todos
        • To do A
        • To do B
        • To do C
    • Markdown Input
      Markdown Output
      ![title](https://repo.yona.io/assets/images/ico-like-small.png "Yobi")
      ![title](/assets/images/ico-like-small.png "Yobi")
    • Markdown Input
      Markdown Output
      > Lorem ipsum dolor sit amet, consectetuer adipiscing elit.
>
> Aenean commodo ligula eget dolor.
      > Lorem ipsum dolor sit amet, consectetuer adipiscing elit. > > Aenean commodo ligula eget dolor.
    • Markdown Input
      Markdown Output
      `function test() {console.log("hello world");}`

```javascript
function test() {
  console.log("hello world");
}
```
      `function test() {console.log("hello world");}` ```javascript function test() { console.log("hello world"); } ```
    • Markdown Input
      Markdown Output
      | Default      | Align center | Align right |
| ------------ | :----------: | ------: |
| Carrot       | Red          | 1,000   |
| Banana       | Yellow       | 32,000  |
      | Default | Align center | Align right | | ------------ | :----------: | ------: | | Carrot | Red | 1,000 | | Banana | Yellow | 32,000 | Also, you can copy & paste table from excel sheet
    • Markdown Input
      Markdown Output
      Issue no: #2
Mention: @yobi
commit: @763575 or @763575f177a4ce8b9370954de3ea1a1410205593

      Issue no: #2

      Mention: @yobi

      commit: @763575 or @763575

    Notification receivers
    Drag & Drop files here to upload.
    Tasks

    나이스몰 초기화

    truncate table member_hierarchies;
delete from members where id > 1000000;
alter table members auto_increment=1000001;
-- 레벨구매
truncate table package_orders;
truncate table orders;
truncate table carts;

truncate table assets;
truncate table seeds;
truncate table seed_hierarchies;
-- 자산관리
truncate table assets;
truncate table asset_withdrawals;
# truncate table asset_transfers;
truncate table asset_charges;
-- 초기화

select * from assets;
select * from members;

truncate table orders;
truncate table assets;
truncate table asset_withdrawals;
# truncate table asset_transfers;
truncate table asset_charges;
truncate table asset_exch_rates;
truncate table api_income_logs;
# truncate table asset_withdrawal_requests;
truncate table package_orders;
truncate table marketing_accounts;
truncate table seed_hierarchies;
truncate table seeds;
    Reply
  • Closed 김동주 closed this issue 03-25
Add a comment
New subtask
Assignee
김동주 @srirama
Milestone
New milestone
Due date
No due date
Keyboard shortcuts