This repository has been archived by the owner on Aug 10, 2024. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
deleteAll.sql
35 lines (32 loc) · 1.51 KB
/
deleteAll.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
/**************************************************************/
/* */
/* Copyright 2014 MAC0426-PROJECT */
/* */
/* Licensed under the Apache License, Version 2.0 */
/* (the "License"); you may not use this file except in */
/* compliance with the License. You may obtain a copy of the */
/* License at */
/* */
/* http://www.apache.org/licenses/LICENSE-2.0 */
/* */
/* Unless required by applicable law or agreed to in writing, */
/* software distributed under the License is distributed on */
/* an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY */
/* KIND, either express or implied. */
/* See the License for the specific language governing */
/* permissions and limitations under the License. */
/* */
/**************************************************************/
USE gamestore;
DELETE FROM rel_win;
DELETE FROM rel_play;
DELETE FROM rel_participate;
DELETE FROM rel_owns;
DELETE FROM rel_distribute;
DELETE FROM rel_dispute;
DELETE FROM challenge;
DELETE FROM distributor;
DELETE FROM game;
DELETE FROM team;
DELETE FROM gamer;
ALTER TABLE challenge AUTO_INCREMENT=1;