diff options
| author | horchi <vdr@jwendel.de> | 2017-03-05 16:39:28 +0100 |
|---|---|---|
| committer | horchi <vdr@jwendel.de> | 2017-03-05 16:39:28 +0100 |
| commit | e2a48d8701f91b8e24fbe9e99e91eb72a87bb749 (patch) | |
| tree | 726f70554b4ca985a09ef6e30a7fdc8df089993c /alter | |
| download | vdr-epg-daemon-e2a48d8701f91b8e24fbe9e99e91eb72a87bb749.tar.gz vdr-epg-daemon-e2a48d8701f91b8e24fbe9e99e91eb72a87bb749.tar.bz2 | |
git init1.1.103
Diffstat (limited to 'alter')
| -rwxr-xr-x | alter/alter.sql | 9 |
1 files changed, 9 insertions, 0 deletions
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';" + |