-- SQL script to demonstrate the use of colors in Entrance
-- see http://todlandis.com/Entrance.html

drop tables if exists entranceColors;
create table entranceColors (
  x    int,
  y    int,
  color  varchar(255)
);


insert into entranceColors
  values

  -- light to dark versions of named colors
  (10,70, 'very dark cyan'),
  (15,70, 'dark cyan'),
  (20,70, 'cyan'),
  (25,70, 'light cyan'),
  (30,70, 'very light cyan'),

  (10,60, 'very dark blue'),
  (15,60, 'dark blue'),
  (20,60, 'blue'),
  (25,60, 'light blue'),
  (30,60, 'very light blue'),

  (10,50, 'very dark green'),
  (15,50, 'dark green'),
  (20,50, 'green'),
  (25,50, 'light green'),
  (30,50, 'very light green'),

  (10,40, 'very dark yellow'),
  (15,40, 'dark yellow'),
  (20,40, 'yellow'),
  (25,40, 'light yellow'),
  (30,40, 'very light yellow'),

  (10,30, 'very dark orange'),
  (15,30, 'dark orange'),
  (20,30, 'orange'),
  (25,30, 'light orange'),
  (30,30, 'very light orange'),


  (10,20, 'very dark red'),
  (15,20, 'dark red'),
  (20,20, 'red'),
  (25,20, 'light red'),
  (30,20, 'very light red'),

  (10,10, 'very dark magenta'),
  (15,10, 'dark magenta'),
  (20,10, 'magenta'),
  (25,10, 'light magenta'),
  (30,10, 'very light magenta'),

  -- named shades of gray
  (50,10, 'white'),
  (65,10, 'lightgray'),
  (60,10, 'gray'),
  (65,10, 'darkgray'),
  (70,10, 'black'),

  -- an 8 step gray specttrum from white to black
  (45,5, 'rgb(255,255,255)'),
  (45,15, 'rgb(224,224,224)'),
  (45,25, 'rgb(192,192,192)'),
  (45,35, 'rgb(160,160,160)'),
  (45,45, 'rgb(128,128,128)'),
  (45,55, 'rgb(96,96,96)'),
  (45,65, 'rgb(64,64,64)'),
  (45,75, 'rgb(32,32,32)'),

  -- a 16 step color spectrum from blue to yellow  
  (10, 90, 'rgb(0,0,255)'),    -- blue
  (15, 90, 'rgb(51,0,255)'),
  (20, 90, 'rgb(102,0,255)'),
  (25, 90, 'rgb(153,0,255)'),
  (30, 90, 'rgb(204,0,255)'),
  (35, 90, 'rgb(255,0,255)'),  -- magenta
 
  (40, 90, 'rgb(255,0,204)'),
  (45, 90, 'rgb(255,0,153)'),
  (50, 90, 'rgb(255,0,102)'),
  (55, 90, 'rgb(255,0,51)'),
  (60, 90, 'rgb(255,0,0)'),   -- red
  (65, 90, 'rgb(255,51,0)'),
  (70, 90, 'rgb(255,102,0)'),
  (75, 90, 'rgb(255,153,0)'),
  (80, 90, 'rgb(255,204,0)'),
  (85, 90, 'rgb(255,255,0)'), -- yellow



  -- misc colors from Wikipedia...
  -- eg. see "Taupe", "Blue", and "List of Colors" 


  -- pale taupe
  (55,50, 'rgb(188,152,126)'),

  -- taupe gray
  (60,50, 'rgb(139,133,137)'),

  -- rose taupe
  (60,50, 'rgb(139,133,137)'),

  -- mauve taupe
  (65,50, 'rgb(175,134,142)'),

  -- taupe
  (70,50, 'rgb(72,60,50)'),

  -- coral
  (60,60, 'rgb(255,127,80)'),

  -- denim
  (60,70, 'rgb(21,96,189)'),
  -- dark blue
  (65,70, 'rgb(0,0,139)'),
  -- dodger blue
  (70,70, 'rgb(30,144,255)'),
  -- aquamarine
  (75,70, 'rgb(127,255,212)'),

  -- russet
  (80,30, 'rgb(128,70,27)'),
  -- burgundy
  (85,30, 'rgb(144,0,32)'),
  -- red-brown
  (90,30, 'rgb(165,42,42)')
;

plot scatter
 x 
 big filled box
 color override 

 scale x 0 100 100
 scale y 0 100 100

select x,y,color from entranceColors;