From 62d926e022aaf35be029f20568e55533caee3bf7 Mon Sep 17 00:00:00 2001
From: Ian C <ianc@noddybox.co.uk>
Date: Sat, 7 Jul 2018 13:26:02 +0000
Subject: Added up/down links to reorder entries.

---
 sql/upgrade_from_1.0_to_1.1.sh | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100755 sql/upgrade_from_1.0_to_1.1.sh

(limited to 'sql/upgrade_from_1.0_to_1.1.sh')

diff --git a/sql/upgrade_from_1.0_to_1.1.sh b/sql/upgrade_from_1.0_to_1.1.sh
new file mode 100755
index 0000000..78c1468
--- /dev/null
+++ b/sql/upgrade_from_1.0_to_1.1.sh
@@ -0,0 +1,26 @@
+#!/bin/sh
+
+dbname="passman"
+echo "Name of database to use [$dbname]:"
+read x
+
+if [ "$x" ] ; then
+    dbname=$x
+fi
+
+script=/tmp/$$
+rm -f $script
+touch $script
+
+cat >> $script << END_OF_SQL
+
+use $dbname;
+alter table pm_store add column display int not null;
+update pm_store set display = id;
+
+END_OF_SQL
+
+cat -n $script
+mysql -u root -p < $script
+
+rm -f $script
-- 
cgit v1.2.3