Add simplistic database upgrade mechanism

[debbugs.git] / sql / upgrade / template_schema_XX_to_YY.pl

diff --git a/sql/upgrade/template_schema_XX_to_YY.pl b/sql/upgrade/template_schema_XX_to_YY.pl
new file mode 100644 (file)
index 0000000..470f626
--- /dev/null
+++ b/sql/upgrade/template_schema_XX_to_YY.pl
@@ -0,0 +1,9 @@
+sub upgrade {
+    my $s = shift;
+print STDERR "Foo";
+    $s->prepare_execute(<<'SQL');
+SELECT * FROM db_version;
+SQL
+}
+
+1;