Differences between revisions 3 and 4
⇤ ← Revision 3 as of 2011-12-20 08:47:22 →
Size: 600
Editor: heb
Comment:
← Revision 4 as of 2011-12-20 10:06:04 → ⇥
Size: 600
Editor: heb
Comment:
Deletions are marked like this. Additions are marked like this.
Line 6: Line 6:
create table drsendeplansdata ( CREATE TABLE drsendeplansdata (

Importer dump af metadata i DigiTV-databasen

Lav database: 

CREATE SEQUENCE drsendeplansdata_sequence;

CREATE TABLE drsendeplansdata (
id integer DEFAULT nextval('"drsendeplansdata_sequence"') PRIMARY KEY,
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)