Differences between revisions 2 and 3

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 2 as of 2011-12-20 07:49:39 → 
  Size: 478
  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))

}}}