diff options
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 |