From e2a48d8701f91b8e24fbe9e99e91eb72a87bb749 Mon Sep 17 00:00:00 2001
From: horchi <vdr@jwendel.de>
Date: Sun, 5 Mar 2017 16:39:28 +0100
Subject: git init

---
 alter/alter.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100755 alter/alter.sql

(limited to 'alter/alter.sql')

diff --git a/alter/alter.sql b/alter/alter.sql
new file mode 100755
index 0000000..b306ef5
--- /dev/null
+++ b/alter/alter.sql
@@ -0,0 +1,9 @@
+#!/bin/bash 
+
+mysql -u epg2vdr -pepg -Depg2vdr -e 'ALTER TABLE events ADD imagecount int(4) DEFAULT Null after extepnum;'
+mysql -u epg2vdr -pepg -Depg2vdr -e 'ALTER TABLE events CHANGE shorttext shorttext varchar(300) DEFAULT NULL;'
+mysql -u epg2vdr -pepg -Depg2vdr -e 'ALTER TABLE events CHANGE compshorttext compshorttext varchar(300) DEFAULT NULL;'
+mysql -u epg2vdr -pepg -Depg2vdr -e 'ALTER TABLE events CHANGE topic topic varchar(500) DEFAULT NULL;'
+mysql -u epg2vdr -pepg -Depg2vdr -e 'ALTER TABLE events CHANGE guest guest varchar(500) DEFAULT NULL;'
+mysql -u epg2vdr -pepg -Depg2vdr -e "update vdrs set dbapi = 4 where uuid = 'epgd';"
+
-- 
cgit v1.2.3

