diff options
| author | Andreas Brachold <vdr07@deltab.de> | 2007-12-28 10:15:45 +0000 |
|---|---|---|
| committer | Andreas Brachold <vdr07@deltab.de> | 2007-12-28 10:15:45 +0000 |
| commit | 8d11e5ef702eb4e7a0448eb43d39f28c9670954e (patch) | |
| tree | 2c1ba3792fd5fac7e542be571d30fa695ed59435 /contrib | |
| parent | e4597ce3619f3d7772436d02d1674c28f4c03a16 (diff) | |
| download | xxv-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.sql | 1 | ||||
| -rw-r--r-- | contrib/import-data.sql | 2 | ||||
| -rwxr-xr-x | contrib/update-xxv | 2 | ||||
| -rw-r--r-- | contrib/upgrade-xxv-db.sql | 17 |
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 |
