Differences between revisions 1 and 3 (spanning 2 versions)

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

-  ⇤ ← Revision 1 as of 2011-12-20 07:34:39 → 
  Size: 395
  Editor: heb
  Comment:
+   ← Revision 3 as of 2011-12-20 08:47:22 → ⇥
  Size: 600
  Editor: heb
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 4:
+CREATE SEQUENCE drsendeplansdata_sequence;
-Line 5:
+Line 7:
+id integer DEFAULT nextval('"drsendeplansdata_sequence"') PRIMARY KEY,
-Line 12:
+Line 15:
-samsender_kanal VARCHAR(255))}}}
+samsender_kanal VARCHAR(255))
-Line 14:
+Line 17:
-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/drsendeplansdata/drsendeplansdata_Rpro_Soes.sql}}}