summaryrefslogtreecommitdiff
path: root/contrib
diff options
context:
space:
mode:
authorAndreas Brachold <vdr07@deltab.de>2007-12-28 10:15:45 +0000
committerAndreas Brachold <vdr07@deltab.de>2007-12-28 10:15:45 +0000
commit8d11e5ef702eb4e7a0448eb43d39f28c9670954e (patch)
tree2c1ba3792fd5fac7e542be571d30fa695ed59435 /contrib
parente4597ce3619f3d7772436d02d1674c28f4c03a16 (diff)
downloadxxv-8d11e5ef702eb4e7a0448eb43d39f28c9670954e.tar.gz
xxv-8d11e5ef702eb4e7a0448eb43d39f28c9670954e.tar.bz2
* New modul: MOVETIMER - This modul move timers between channels.
* rlist.tmpl : Fix typo
Diffstat (limited to 'contrib')
-rw-r--r--contrib/export-data.sql1
-rw-r--r--contrib/import-data.sql2
-rwxr-xr-xcontrib/update-xxv2
-rw-r--r--contrib/upgrade-xxv-db.sql17
4 files changed, 20 insertions, 2 deletions
diff --git a/contrib/export-data.sql b/contrib/export-data.sql
index 3154497..6cd0afa 100644
--- a/contrib/export-data.sql
+++ b/contrib/export-data.sql
@@ -7,5 +7,6 @@ select * INTO OUTFILE '/tmp/chronicle.sav' from CHRONICLE;
select * INTO OUTFILE '/tmp/medialib_actors.sav' from MEDIALIB_ACTORS;
select * INTO OUTFILE '/tmp/medialib_videodata.sav' from MEDIALIB_VIDEODATA;
select * INTO OUTFILE '/tmp/medialib_videogenre.sav' from MEDIALIB_VIDEOGENRE;
+select * INTO OUTFILE '/tmp/movetimer.sav' from MOVETIMER;
select * INTO OUTFILE '/tmp/user.sav' from USER;
diff --git a/contrib/import-data.sql b/contrib/import-data.sql
index 003ff05..e98ca95 100644
--- a/contrib/import-data.sql
+++ b/contrib/import-data.sql
@@ -7,6 +7,7 @@ DELETE from CHRONICLE;
DELETE from MEDIALIB_ACTORS;
DELETE from MEDIALIB_VIDEODATA;
DELETE from MEDIALIB_VIDEOGENRE;
+DELETE from MOVETIMER;
DELETE from USER;
load data infile '/tmp/autotimer.sav' into table AUTOTIMER;
@@ -14,5 +15,6 @@ load data infile '/tmp/chronicle.sav' into table CHRONICLE;
load data infile '/tmp/medialib_actors.sav' into table MEDIALIB_ACTORS;
load data infile '/tmp/medialib_videodata.sav' into table MEDIALIB_VIDEODATA;
load data infile '/tmp/medialib_videogenre.sav' into table MEDIALIB_VIDEOGENRE;
+load data infile '/tmp/movetimer.sav' into table MOVETIMER;
load data infile '/tmp/user.sav' into table USER;
diff --git a/contrib/update-xxv b/contrib/update-xxv
index 9fdd01c..59fd18d 100755
--- a/contrib/update-xxv
+++ b/contrib/update-xxv
@@ -22,7 +22,7 @@ actualVersion=26
# Specify tables to export before and import after update
#
-tables='AUTOTIMER CHRONICLE MEDIALIB_ACTORS MEDIALIB_VIDEODATA MEDIALIB_VIDEOGENRE USER'
+tables='AUTOTIMER CHRONICLE MEDIALIB_ACTORS MEDIALIB_VIDEODATA MEDIALIB_VIDEOGENRE MOVETIMER USER'
showTitle()
{
diff --git a/contrib/upgrade-xxv-db.sql b/contrib/upgrade-xxv-db.sql
index bd39e29..785a5a5 100644
--- a/contrib/upgrade-xxv-db.sql
+++ b/contrib/upgrade-xxv-db.sql
@@ -127,6 +127,21 @@ CREATE TABLE `MEDIALIB_VIDEOGENRE` (
);
--
+-- Table structure for table `MOVETIMER`
+--
+
+DROP TABLE IF EXISTS `MOVETIMER`;
+CREATE TABLE `MOVETIMER` (
+ `id` int(10) unsigned NOT NULL auto_increment,
+ `source` varchar(64) NOT NULL,
+ `destination` varchar(64) NOT NULL,
+ `move` enum('y','n','collision') default 'collision',
+ `original` enum('move','keep','copy') default 'move',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `source` (`source`)
+);
+
+--
-- Table structure for table `USER`
--
@@ -150,4 +165,4 @@ CREATE TABLE `USER` (
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2007-11-24 14:27:24
+-- Dump completed on 2007-12-28 10:05:06