contrib/import-data.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

--
-- Load files to Database xxv
--

DELETE from AUTOTIMER;
DELETE from CHRONICLE;
DELETE from MEDIALIB_ACTORS;
DELETE from MEDIALIB_VIDEODATA;
DELETE from MEDIALIB_VIDEOGENRE;
DELETE from USER;

load data infile '/tmp/autotimer.sav' into table AUTOTIMER;
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/user.sav' into table USER;