~vcs-imports/wacs/trunk

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
create table photographer
( pref             varchar(6) primary key,
  pname            varchar(40),
  paliases         varchar(80),
  pgender          char(1),
  paddress         varchar(120),
  pemail           varchar(80),
  pwebsite         varchar(80),
  pusual           varchar(40),
  pregion          varchar(20),
  pcountry         varchar(50),
  plocation        varchar(50),
  pstyledesc	   varchar(80),
  prating	   integer(2),
  phardness        integer(2),
  psolo		   char(1),
  ptoys            char(1),
  plesbian         char(1),
  pstraight        char(1),
  pgroup           char(1),
  pfetish          char(1),
  pdigital	   char(1),
  pfilm		   char(1),
  pvideo           char(1),
  phdvideo         char(1),
  pcamera	   varchar(40),
  pcamnotes        varchar(80),
  pcomments        varchar(240),
  pnotes           varchar(240),
  pbiography       varchar(1024),
  padded           date,
  pamended         date
);