diff options
Diffstat (limited to 'sql_scripts')
| -rw-r--r-- | sql_scripts/drop-all-tables.sh | 4 | ||||
| -rw-r--r-- | sql_scripts/drop-auth.sql | 8 |
2 files changed, 12 insertions, 0 deletions
diff --git a/sql_scripts/drop-all-tables.sh b/sql_scripts/drop-all-tables.sh new file mode 100644 index 00000000..1e55cb1f --- /dev/null +++ b/sql_scripts/drop-all-tables.sh @@ -0,0 +1,4 @@ +mysql_username='' +mysql_database='' +mysqldump -u $mysql_username -p --add-drop-table --no-data $mysql_database | grep ^DROP +#| mysql -u[USERNAME] -p[PASSWORD] [DATABASE] diff --git a/sql_scripts/drop-auth.sql b/sql_scripts/drop-auth.sql new file mode 100644 index 00000000..bc17dce3 --- /dev/null +++ b/sql_scripts/drop-auth.sql @@ -0,0 +1,8 @@ +drop table auth_group; +drop table auth_group_permissions; +drop table auth_message; +drop table auth_permission; +drop table auth_user; +drop table auth_user_groups; +drop table auth_user_user_permissions; + |