create table vendor
( vsite            varchar2(20) primary key,
  vname            varchar2(45),
  vshortname       varchar2(20) not null,
  vregion          varchar2(20),
  vcountry         varchar2(50),
  vweburl          varchar2(120),
  vsignup          varchar2(120),
  vrating          number(2),
  vtechrate        number(2),
  vuscdecl         varchar2(240),
  vcurrent         char(1),
  vshow            char(1),
  vsubscribed      char(1),
  vuntil           date,
  vusername        varchar2(80),
  vpassword        varchar2(30),
  vidtimg          number(2),
  vidtvid          number(2),
  vcomexcl         varchar2(240),
  vmdirectory      varchar2(240),
  vmdiruse         char(1),
  vmdirpages       number(3),
  vmpage           varchar2(240),
  vmpaguse         char(1),
  vmbio            varchar2(240),
  vmbiouse         char(1),
  vmvideos         varchar2(240),
  vmviduse         char(1),
  vvidpage         varchar2(240),
  vviduse          char(1),
  vimgpage         varchar2(240),
  vimguse          char(1),
  valtpage         varchar2(240),
  valtuse          char(1),
  vsrvimg          varchar2(240),
  vsrvvid          varchar2(240),
  vmultimg         char(1),
  vmultvid         char(1),
  vnotes           varchar2(240),
  vadded           date,
  vamended         date
);