blob: 44df786163439610e15c5362416a5a7b67691efd (
plain) (
blame)
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
|
#!/bin/sh -
# $Id$
# Copyright (C) 2007--2008 American Registry for Internet Numbers ("ARIN")
#
# Permission to use, copy, modify, and distribute this software for any
# purpose with or without fee is hereby granted, provided that the above
# copyright notice and this permission notice appear in all copies.
#
# THE SOFTWARE IS PROVIDED "AS IS" AND ARIN DISCLAIMS ALL WARRANTIES WITH
# REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY
# AND FITNESS. IN NO EVENT SHALL ARIN BE LIABLE FOR ANY SPECIAL, DIRECT,
# INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM
# LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE
# OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR
# PERFORMANCE OF THIS SOFTWARE.
# GRANT ALL ON rpki.* TO rpki@localhost IDENTIFIED BY '<secret>';
# GRANT ALL ON irdb.* TO irdb@localhost IDENTIFIED BY '<secret>';
echo "This script destroys and rebuilds our databases."
echo "Don't type the password unless you're sure you want to do this."
(echo 'DROP DATABASE rpki; CREATE DATABASE rpki; USE rpki;'
cat ../docs/rpki-db-schema.sql
echo 'DROP DATABASE irdb; CREATE DATABASE irdb; USE irdb;'
cat ../docs/sample-irdb.sql
) |
mysql -u root -p
|
