blob: d3cfba4555a7aa810b9a3fab426e1b7878755db3 (
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 --routines gestion \
| sed -e 's/AUTO_INCREMENT=[0-9]\+ //g' > schema-mysql.sql
|
