create table sets
( setno			number(9) primary key,
  stype                 char(1) not null,
  sstatus               char(1) not null,
  sauto                 char(1),
  srating               char(1),
  sflag                 char(1),
  stechqual             number(2),
  svariety              number(2),
  svisits               number(2),
  sformat		varchar2(10),
  scodec                varchar2(40),
  stitle                varchar2(240),
  sofftitle		varchar2(240),
  sofficon		varchar2(160),
  saddicon		varchar2(160),
  sname                 varchar2(80),
  shair                 varchar2(80),
  smodelno              varchar2(40),
  slocation             varchar2(20),
  slocdetail		varchar2(40),
  sphotog		varchar2(6) references photographer,
  ssource               varchar2(80),
  sfoundry              varchar2(80),
  sproddate             date,
  sreldate		date,
  suscattr              char(1),
  snotes                varchar2(240),
  sdesc                 varchar2(2048),
  sindexes              number(6),
  simages               number(6),
  sdurhrs		number(2),
  sdurmin               number(2),
  sdursec               number(2),
  slandx                number(6),
  slandy                number(6),
  sportx                number(6),
  sporty                number(6),
  saspect		varchar(10),
  sbytes		number(12),
  sdvdno		number(6),
  sdvddisc		number(2),
  sdvdtitle		number(3),
  sdvdstartch		number(3),
  sdvdendch             number(3),
  sidlogo		char(1),
  serrors		char(1),
  sduplicates		number(9),
  scatinfo              varchar2(160),
  scatflag		char(1),
  snamestem             varchar2(80),
  sdownload             varchar2(160),
  sarea			varchar2(160),
  scategory		varchar2(160),
  sdirectory		varchar2(240),
  scomments             varchar2(240),
  sadded                date,
  samended              date
);
