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 ); |
| Values For Short Fields In Sets Table | ||
|---|---|---|
| stype | I | Image Set |
| V | Video Clip | |
| A | Audio File | |
| S | DVD Scene | |
| sstatus | M | Manually Added, Details Not Checked |
| A | Automatically Added, Details Not Checked | |
| N | Normal - Checked | |
| G | Good - Thoroughly Checked | |
| U | Unknown | |
| sauto | N | None |
| L | Location Only - catinfo manual | |
| A | Append to catinfo - remove nothing | |
| F | Fully auto-generated | |
| srating | 5 | Finest |
| 4 | Very Good | |
| 3 | Good | |
| 2 | Reasonable | |
| 1 | Mediocre | |
| 0 | None Specified | |
| stechqual | as for srating | |
| svariety | 5 | Very Unusual |
| 4 | Unusual | |
| 3 | Neat | |
| 2 | Cute Twist | |
| 1 | Ordinary | |
| 0 | None Specified | |
| sformat | JPEG | JPEG image |
| GIF | GIF Image | |
| PNG | PNG Image | |
| PNM | PNM Image | |
| WMV | Windows Media Player Video | |
| AVI | AVI Video | |
| QT | QuickTime .mov Video | |
| MPEG | MPEG Video (1/2) | |
| sidlogo | U | Unknown |
| Y | Yes - image/video has burnt-in logo | |
| N | No - image/video is clean of bugs | |
| serrors | N | None detected |
| F | Fixed - faulty images/video have been fixed | |
| E | Encoding Only - causes message but renders OK | |
| C | Some Corrupt Images/Segments of video | |
| scatflag | F | Fuck - straight sex |
| L | Lesbian - lesbian sex | |
| G | Group - more than two people having sex, mixed-gender | |
| T | Toy - Solo but uses toys such as dildo, vibrator, etc | |
| S | Solo | |
| N | None - not determined yet | |
| B | Backstage - Behind The Scenes set featuring this model | |
| C | Clothed - non-nude set featuring this model | |
| D | Duplicate - duplicate set - maybe from a different site | |
| slocation | Bathroom | Bathroom, Toilet or Shower Cubicle |
| Kitchen | Kitchen or Kitchen area of appartment | |
| Hallway | Hallway, Staircase or Entrance | |
| Bedroom | Bedroom or other sleeping area | |
| Lounge | Lounge, Sitting Room or Other Seating Area | |
| Garden | Garden, Back Yard or other residential outside area | |
| suscattr | V | Vendor based - use vendor's USC declaration address |
| P | Photographer based - use photographer's address for USC declaration | |
| N | Suppress declaration - *NOT RECOMMENDED FOR US RESIDENTS* | |
| G | Generic - include generic text with all vendor addresses | |
| NB: this field will not be used until release 0.7.x | ||