summaryrefslogtreecommitdiff
path: root/schema/dump-it.sh
blob: eb9ab84ae85e4439c938be194005d9ab6302fcfb (plain)
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
36
37
#!/bin/bash -x
# Copyright 2016 Ludovic Pouzenc <ludovic@pouzenc.fr>
# Copyright 2016 Nicolas Goaziou <mail@nicolasgoaziou.fr>
# 
# This file is part of CHD Gestion.
# 
# CHD Gestion is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
# 
# CHD Gestion is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
# 
# You should have received a copy of the GNU General Public License
# along with CHD Gestion.  If not, see <http://www.gnu.org/licenses/>.
# 
enum_tables="
adherent_role_types
adherent_statuts
adherent_types
civilites
equipement_modeles
equipement_modes
interesse_statuts
periodicites
service_statuts
service_types
"
mysqldump --defaults-file=/etc/mysql/debian.cnf gestion \
	$enum_tables > enum-tables-data-mysql.sql

mysqldump --defaults-file=/etc/mysql/debian.cnf --no-data gestion \
	| sed -e 's/AUTO_INCREMENT=[0-9]\+ //g' > schema-mysql.sql