Differences between revisions 1 and 2
Revision 1 as of 2011-12-20 07:34:39
Size: 395
Editor: heb
Comment:
Revision 2 as of 2011-12-20 07:49:39
Size: 478
Editor: heb
Comment:
Deletions are marked like this. Additions are marked like this.
Line 14: Line 14:
Udfør sql scriptet der ligger larm@iapetus:~/releases/drsendeplansdata_Rpro_Soes.sql Udfør sql scriptet der ligger fedora@digitv-test-acs.sb {{{
psql -h localhost -d digitaltv -U digitaltv -W -f ~/heb/drsendep
lansdata/drsendeplansdata_Rpro_Soes.sql}}}

Importer dump af metadata i DigiTV-databasen

Lav database:

create table drsendeplansdata (
produktionsnummer VARCHAR(255),
arkivnummer VARCHAR(255),
kanal VARCHAR(255),
titel VARCHAR(255),
sendetid TIMESTAMP,
varighed  VARCHAR(255),
base VARCHAR(255),
samsender_kanal VARCHAR(255))

Udfør sql scriptet der ligger fedora@digitv-test-acs.sb

psql -h localhost -d digitaltv -U digitaltv -W -f ~/heb/drsendeplansdata/drsendeplansdata_Rpro_Soes.sql

MetadataDump (last edited 2011-12-20 10:06:04 by heb)