-- phpMyAdmin SQL Dump
-- version 2.6.0-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Aug 21, 2007 at 04:52 PM
-- Server version: 4.0.26
-- PHP Version: 4.4.4
-- 
-- Database: `floorplan`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `coords_circle`
-- 

CREATE TABLE `coords_circle` (
  `rollspotID` smallint(5) unsigned NOT NULL auto_increment,
  `x` smallint(5) unsigned NOT NULL default '0',
  `y` smallint(5) unsigned NOT NULL default '0',
  `r` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`rollspotID`)
) TYPE=MyISAM AUTO_INCREMENT=47 ;

-- 
-- Dumping data for table `coords_circle`
-- 

INSERT INTO `coords_circle` VALUES (1, 102, 184, 12);
INSERT INTO `coords_circle` VALUES (2, 115, 153, 15);
INSERT INTO `coords_circle` VALUES (3, 120, 248, 15);
INSERT INTO `coords_circle` VALUES (4, 120, 282, 15);
INSERT INTO `coords_circle` VALUES (5, 120, 349, 15);
INSERT INTO `coords_circle` VALUES (6, 120, 383, 15);
INSERT INTO `coords_circle` VALUES (7, 130, 504, 15);
INSERT INTO `coords_circle` VALUES (8, 139, 52, 15);
INSERT INTO `coords_circle` VALUES (9, 155, 248, 15);
INSERT INTO `coords_circle` VALUES (10, 155, 282, 15);
INSERT INTO `coords_circle` VALUES (11, 155, 349, 15);
INSERT INTO `coords_circle` VALUES (12, 155, 383, 15);
INSERT INTO `coords_circle` VALUES (13, 155, 459, 12);
INSERT INTO `coords_circle` VALUES (14, 196, 52, 15);
INSERT INTO `coords_circle` VALUES (15, 197, 140, 15);
INSERT INTO `coords_circle` VALUES (16, 207, 355, 10);
INSERT INTO `coords_circle` VALUES (17, 236, 333, 10);
INSERT INTO `coords_circle` VALUES (18, 238, 144, 15);
INSERT INTO `coords_circle` VALUES (19, 238, 178, 15);
INSERT INTO `coords_circle` VALUES (20, 260, 42, 15);
INSERT INTO `coords_circle` VALUES (21, 261, 208, 15);
INSERT INTO `coords_circle` VALUES (22, 266, 103, 11);
INSERT INTO `coords_circle` VALUES (23, 267, 345, 10);
INSERT INTO `coords_circle` VALUES (24, 361, 334, 10);
INSERT INTO `coords_circle` VALUES (25, 388, 175, 27);
INSERT INTO `coords_circle` VALUES (26, 426, 348, 15);
INSERT INTO `coords_circle` VALUES (27, 44, 40, 21);
INSERT INTO `coords_circle` VALUES (28, 443, 605, 21);
INSERT INTO `coords_circle` VALUES (29, 45, 510, 15);
INSERT INTO `coords_circle` VALUES (30, 465, 343, 15);
INSERT INTO `coords_circle` VALUES (31, 473, 446, 15);
INSERT INTO `coords_circle` VALUES (32, 486, 411, 12);
INSERT INTO `coords_circle` VALUES (33, 49, 191, 15);
INSERT INTO `coords_circle` VALUES (34, 493, 206, 30);
INSERT INTO `coords_circle` VALUES (35, 50, 148, 15);
INSERT INTO `coords_circle` VALUES (36, 506, 343, 15);
INSERT INTO `coords_circle` VALUES (37, 52, 281, 15);
INSERT INTO `coords_circle` VALUES (38, 52, 321, 15);
INSERT INTO `coords_circle` VALUES (39, 52, 378, 15);
INSERT INTO `coords_circle` VALUES (40, 563, 347, 15);
INSERT INTO `coords_circle` VALUES (41, 563, 404, 15);
INSERT INTO `coords_circle` VALUES (42, 563, 457, 15);
INSERT INTO `coords_circle` VALUES (43, 61, 447, 15);
INSERT INTO `coords_circle` VALUES (44, 236, 355, 10);
INSERT INTO `coords_circle` VALUES (45, 296, 461, 15);
INSERT INTO `coords_circle` VALUES (46, 334, 371, 12);

-- --------------------------------------------------------

-- 
-- Table structure for table `coords_circle_italy`
-- 

CREATE TABLE `coords_circle_italy` (
  `rollspotID` smallint(5) unsigned NOT NULL auto_increment,
  `x` smallint(5) unsigned NOT NULL default '0',
  `y` smallint(5) unsigned NOT NULL default '0',
  `r` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`rollspotID`)
) TYPE=MyISAM AUTO_INCREMENT=105 ;

-- 
-- Dumping data for table `coords_circle_italy`
-- 

INSERT INTO `coords_circle_italy` VALUES (100, 183, 300, 15);
INSERT INTO `coords_circle_italy` VALUES (101, 452, 300, 15);
INSERT INTO `coords_circle_italy` VALUES (102, 612, 315, 10);
INSERT INTO `coords_circle_italy` VALUES (103, 600, 405, 10);

-- --------------------------------------------------------

-- 
-- Table structure for table `coords_rect`
-- 

CREATE TABLE `coords_rect` (
  `rollspotID` smallint(5) unsigned NOT NULL auto_increment,
  `x1` smallint(5) unsigned NOT NULL default '0',
  `y1` smallint(5) unsigned NOT NULL default '0',
  `x2` smallint(5) unsigned NOT NULL default '0',
  `y2` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`rollspotID`)
) TYPE=MyISAM AUTO_INCREMENT=72 ;

-- 
-- Dumping data for table `coords_rect`
-- 

INSERT INTO `coords_rect` VALUES (51, 105, 212, 171, 222);
INSERT INTO `coords_rect` VALUES (52, 170, 159, 212, 187);
INSERT INTO `coords_rect` VALUES (53, 171, 451, 232, 471);
INSERT INTO `coords_rect` VALUES (54, 174, 475, 250, 536);
INSERT INTO `coords_rect` VALUES (55, 196, 227, 276, 278);
INSERT INTO `coords_rect` VALUES (56, 196, 282, 300, 319);
INSERT INTO `coords_rect` VALUES (57, 196, 369, 215, 406);
INSERT INTO `coords_rect` VALUES (58, 197, 323, 277, 365);
INSERT INTO `coords_rect` VALUES (59, 213, 163, 221, 188);
INSERT INTO `coords_rect` VALUES (60, 236, 451, 253, 471);
INSERT INTO `coords_rect` VALUES (61, 254, 446, 311, 534);
INSERT INTO `coords_rect` VALUES (62, 281, 320, 300, 368);
INSERT INTO `coords_rect` VALUES (63, 281, 431, 294, 445);
INSERT INTO `coords_rect` VALUES (64, 304, 324, 346, 383);
INSERT INTO `coords_rect` VALUES (65, 315, 432, 403, 534);
INSERT INTO `coords_rect` VALUES (66, 336, 384, 373, 396);
INSERT INTO `coords_rect` VALUES (67, 351, 324, 383, 381);
INSERT INTO `coords_rect` VALUES (68, 380, 625, 425, 647);
INSERT INTO `coords_rect` VALUES (69, 381, 548, 412, 575);
INSERT INTO `coords_rect` VALUES (70, 448, 486, 499, 539);
INSERT INTO `coords_rect` VALUES (71, 70, 16, 118, 100);

-- --------------------------------------------------------

-- 
-- Table structure for table `entities`
-- 

CREATE TABLE `entities` (
  `entityID` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(60) default NULL,
  `title` varchar(100) default NULL,
  `description` varchar(150) default NULL,
  `pictureURL` varchar(30) NOT NULL default 'default.jpg',
  `class` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`entityID`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=169 ;

-- 
-- Dumping data for table `entities`
-- 

INSERT INTO `entities` VALUES (101, 'The door that isn''t', 'interdimensional portal', 'An intern walked through here once and was never seen again. As you can see, appropriate preventative measures have been implemented.', 'portal.jpg', 'object');
INSERT INTO `entities` VALUES (102, 'Rev. Robert A. Sirico', 'President', 'If it wasn''t for Robert, we wouldn''t be here. This place is his mission. If you get the chance, get to know him - he is a fascinating person.', 'sirico.jpg', 'person');
INSERT INTO `entities` VALUES (103, 'Karen Abbs', 'Director of Human Resources and Administration', 'Karen''s desk is messy because she''s busy making sure YOU have insurance. So no snide comments, smartypants.', 'abbs.jpg', 'person');
INSERT INTO `entities` VALUES (104, 'Steven de Polo', 'Associate Director, Corporate and Foundation Relations', 'Where does the cash come from to keep Acton afloat? Steven gets it. Hooray for Steven!', 'de_polo.jpg', 'person');
INSERT INTO `entities` VALUES (105, 'Kara Eagle', 'Programs Coordinator', 'Kara works closely with Elly. She is secretly working on a device that will cause Dave Cooper to dance via remote control.', 'eagle.jpg', 'person');
INSERT INTO `entities` VALUES (106, 'Empty desk', 'This Space Available', 'Look ye upon the void... and DESPAIR!', 'empty_desk.jpg', 'empty');
INSERT INTO `entities` VALUES (107, 'Fridge of Rot', 'cooling device', 'The name says it all. However, YOU the Acton employee are the solution to the problem: throw out your unwanted stuff.', 'fridge.jpg', 'object');
INSERT INTO `entities` VALUES (108, 'Stephen Grabill', 'Research Fellow', 'Stephen reads and writes. A LOT.', 'grabill.jpg', 'person');
INSERT INTO `entities` VALUES (109, 'Samuel Gregg, D.Phil.', 'Director of Research', 'Sam is our resident guy with a cool accent. His main role is to heap abuse on the Dutch, but he does do research on the side.', 'gregg.jpg', 'person');
INSERT INTO `entities` VALUES (110, 'Kris Alan Mauren', 'Executive Director', 'Kris exemplifies what we like to call ''Acton at its Best.'' He also makes a mean pot of coffee.', 'mauren.jpg', 'person');
INSERT INTO `entities` VALUES (111, 'Hallway', 'alternative route', 'This is a nice back way to the bathrooms or the dismal north stairs. Keep in mind that it''s all connected.', 'hallway.jpg', 'area');
INSERT INTO `entities` VALUES (112, 'Intern', 'scapegoat', 'This could be you.', 'intern.jpg', 'empty');
INSERT INTO `entities` VALUES (113, 'Kitchen', 'where the hungry assemble', 'Contains the three essentials for life on Earth: a fridge, a microwave, and a sink.', 'kitchen.jpg', 'area');
INSERT INTO `entities` VALUES (114, 'Large Conference Room', 'meeting place', 'Much like the small conference room, only bigger. There are a lot of books in here.', 'largeconference.jpg', 'area');
INSERT INTO `entities` VALUES (115, 'Library', 'a place to read', 'Many of our books are in here too.', 'library.jpg', 'area');
INSERT INTO `entities` VALUES (116, 'Mailboxes', 'self-explanatory', 'This is where you pick up and drop off mail. A paper cutter is here as well.', 'mailboxes.jpg', 'object');
INSERT INTO `entities` VALUES (117, 'Mail & Copier room', 'a noisy, bustling room', 'The place where Actonites duplicate and distribute their free-market propaganda literature. Exciting!', 'mailroom.jpg', 'area');
INSERT INTO `entities` VALUES (118, 'Mechanical room', 'loud, cold and dismal', 'Try not to get yourself locked in here over a weekend like the last intern did. Still, it might be a good refuge during bad days.', 'mechanical.jpg', 'area');
INSERT INTO `entities` VALUES (119, 'Joan Miller', 'Administrative Coordinator', 'Contrary to what some seem to think, it is NOT Joan''s job to clean up your kitchen messes.', 'j_miller.jpg', 'person');
INSERT INTO `entities` VALUES (120, 'Nook', 'full o'' books', 'Just a nook. Periodicals are kept here.', 'nook.jpg', 'area');
INSERT INTO `entities` VALUES (121, 'North Stairs', 'fire escape', 'These stairs will take you safely down to the basement, and ONLY the basement.', 'north_stairs.jpg', 'area');
INSERT INTO `entities` VALUES (122, 'Postage Meter', 'interesting device', 'Acton''s mechanical interface with our USPS Overlords.', 'postage_meter.jpg', 'object');
INSERT INTO `entities` VALUES (123, 'Big ol'' Equipment Rack', 'Cool Tech Thingie', 'All your base are belong to this thing. Only Dave knows what exactly it does, and he ain''t talkin''.', 'rack.jpg', 'object');
INSERT INTO `entities` VALUES (124, 'Robert''s Conference Room', 'meeting place', 'This is where the high-security Acton meetings happen.', 'robert_conf.jpg', 'area');
INSERT INTO `entities` VALUES (125, 'Holly Rowley', 'Executive Assistant', 'Holly knows all, and uses her substantial powers for good, not evil. One shudders to think of what woudl happen were she to turn to the dark side.', 'rowley.jpg', 'person');
INSERT INTO `entities` VALUES (126, 'Server Room', 'Technological Hub', 'Hot enough to double as a large kiln for when the pottery classes start. It has also served as an intern''s workspace.', 'server.jpg', 'area');
INSERT INTO `entities` VALUES (127, 'Small Conference Room', 'room', 'It''s a conference room, only smaller. You may remember being interviewed in here.', 'small_conference.jpg', 'area');
INSERT INTO `entities` VALUES (128, 'Jonathan Spalink', 'Webmaster', 'Spars with HTML, PHP, CSS, and other acronyms on a daily basis.', 'spalink.jpg', 'person');
INSERT INTO `entities` VALUES (129, 'Marc Vander Maas', 'Multimedia Manager', 'Contrary to popular belief, Marc is NOT wanted by the police anymore, so please stop calling them.', 'vandermaas.jpg', 'person');
INSERT INTO `entities` VALUES (130, 'Water Cooler', 'informal meeting spot', 'So, did you watch LOST last night?', 'water.jpg', 'object');
INSERT INTO `entities` VALUES (131, 'Rachel Wondergem Eardley', 'Director of Strategy and Planning', 'Rachel (aka Wonder Woman) is all about strategery. Here, we see her cheerfully planning Acton''s eventual world domination.', 'wondergem.jpg', 'person');
INSERT INTO `entities` VALUES (132, 'Jordan Ballor', 'Imperial Henchman', 'He IS your father. (And the associate editor for <i>Markets and Morality</i>.)', 'ballor.jpg', 'person');
INSERT INTO `entities` VALUES (133, 'Elly Barnette', 'Director of Development Operations', 'Elly has the ability to sleep with her eyes open. It''s very unnerving.', 'barnette.jpg', 'person');
INSERT INTO `entities` VALUES (134, 'Bookshoppe', 'repository of knowledge', 'Well... it USED to look like this.', 'bookshoppe.jpg', 'area');
INSERT INTO `entities` VALUES (135, 'Lord Acton bust', 'Namesake', 'Acton was the historian of freedom, famous for the quote ''Power tends to corrupt, and absolute power corrupts absolutely.''', 'bust.jpg', 'object');
INSERT INTO `entities` VALUES (136, 'Jennifer Chalut', 'Senior Accountant', 'Works on the finance end of things. She also cuts those expense checks we all love so much.', 'chalut.jpg', 'person');
INSERT INTO `entities` VALUES (137, 'Supply Closet', 'den of replenishing', 'Holly alone knows the secrets of the supply closet.', 'closet.jpg', 'area');
INSERT INTO `entities` VALUES (138, 'Coat of Arms', 'for you English History buffs', 'Lord Acton''s Coat of Arms. Possibly the least prominently displayed Acton-related artifact at the institute.', 'coatofarms.jpg', 'object');
INSERT INTO `entities` VALUES (139, 'Coat Room', 'also full of water', 'You can hang your coat in here. Also can serve as an office for an intern.', 'coats.jpg', 'area');
INSERT INTO `entities` VALUES (140, 'Coffee Makers', 'dispensers of wakefulness', 'I need caffeine... CAAAAFFFEEEEIIIIIINNNNE...', 'coffee.jpg', 'object');
INSERT INTO `entities` VALUES (141, 'Dave Cooper', 'Information Technology Manager', 'Dave takes care of our computers, and is working on a device to defeat Kara''s secret remote dance controller.', 'cooper.jpg', 'person');
INSERT INTO `entities` VALUES (142, 'Copier', 'for all your duplication needs', 'Brought to you by the good people of the Toshiba Corporation.', 'copier.jpg', 'object');
INSERT INTO `entities` VALUES (143, 'John Couretas', 'Director of Communications, Executive Editor of Religion & Liberty', 'John manages Acton''s communications, but really aspires to a career in male modeling. Yeah, good luck with that.', 'couretas.jpg', 'person');
INSERT INTO `entities` VALUES (144, 'Filing Cabinets', 'drawers of mystery', 'Herein is preserved Acton''s history in meticulous detail.', 'filing_cabinets.jpg', 'object');
INSERT INTO `entities` VALUES (145, 'Printers', 'full of toner and ink', 'These devices convert electrical signals into printed materials. Amazing!', 'printers.jpg', 'object');
INSERT INTO `entities` VALUES (146, 'Diane Satterlee', 'Bookshoppe Manager', '', 'satterlee.jpg', 'person');
INSERT INTO `entities` VALUES (147, 'Anthony S. Pienta', 'Research Project Coordinator', 'Makes phone calls and types between occasional episodes of narcolepsy.', 'pienta.jpg', 'person');
INSERT INTO `entities` VALUES (148, 'Michael Miller', 'Director of Programs and Education', 'He has almost 10 years of international experience and has lived and traveled in Europe, Asia, Africa, and Latin America, but still hasn''t tanned.', 'm_miller.jpg', 'person');
INSERT INTO `entities` VALUES (149, 'Katrina Kelly', 'none', 'none', 'kelly.jpg', 'person');
INSERT INTO `entities` VALUES (150, 'Charissa Romens', 'Programs Coordinator', '', 'romens.jpg', 'person');
INSERT INTO `entities` VALUES (151, 'Jonathan Witt', 'Research Fellow', 'Jon does research for Acton and is also a writer-in-residence with Acton Media.', 'witt.jpg', 'person');
INSERT INTO `entities` VALUES (152, 'Peter Ho', 'Graphics Editor', 'All those nice-looking publications Acton puts out? Without Peter, they''d look rather bland.', 'ho.jpg', 'person');
INSERT INTO `entities` VALUES (153, 'Kaylin Wainwright', 'Research Assistant', 'Kaylin reads & researches books for Jay, and consequently is much smarter than you.', 'wainwright.jpg', 'person');
INSERT INTO `entities` VALUES (154, 'Jay W. Richards', 'Director of Acton Media, Research Fellow', 'He is the author of many scholarly and popular articles, as well as several books.', 'richards.jpg', 'person');
INSERT INTO `entities` VALUES (155, 'Karen Weber', 'Samaritan Award Coordinator', 'Karen cheerfully leads the charge for more effective nonprofits.', 'weber.jpg', 'person');
INSERT INTO `entities` VALUES (156, 'Margaret Brunett', 'Executive Assistant', 'Born to run but not to have her picture taken.', 'brunett.jpg', 'person');
INSERT INTO `entities` VALUES (157, 'Ben Sikma', 'Assistant to the President', 'This guy does all the president''s scheduling grunt work.', 'sikma.jpg', 'person');
INSERT INTO `entities` VALUES (158, 'Judy Carl', 'Events Manager', 'none', 'carl.jpg', 'person');
INSERT INTO `entities` VALUES (159, 'Kim Brink', 'Donor Database Administrator', 'She was BORN to do Raiser''s Edge.', 'brink.jpg', 'person');
INSERT INTO `entities` VALUES (160, 'Empty office', 'This room available', 'Offices don''t stay empty for long. Or do they?', 'empty_office.jpg', 'empty');
INSERT INTO `entities` VALUES (164, 'Tabitha Folkerts', 'Production Associate', 'Tabitha does whatever Mark or Jay tells her to do.', 'folkerts.jpg', 'person');
INSERT INTO `entities` VALUES (165, 'Eric Knibbe', 'Media & Web Intern', 'Eric works on cool web-esqe stuff like this floorplan you''re looking at.', 'knibbe.jpg', 'person');
INSERT INTO `entities` VALUES (166, 'Tom Vogt', 'Finance Director', 'What, you thought your check comes from the check fairy? No, it comes from Tom.', 'vogt.jpg', 'person');
INSERT INTO `entities` VALUES (167, 'Brooke Levitske', 'Just an intern', 'She has no idea what she does here.', 'levitske.jpg', 'person');
INSERT INTO `entities` VALUES (168, 'Ray Nothstine', 'Associate Editor, Religion & Liberty and Acton Notes', '"Hey guys... what''s going on..."', 'nothstine.jpg', 'person');

-- --------------------------------------------------------

-- 
-- Table structure for table `entities_italy`
-- 

CREATE TABLE `entities_italy` (
  `entityID` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(60) default NULL,
  `title` varchar(100) default NULL,
  `description` varchar(150) default NULL,
  `pictureURL` varchar(30) NOT NULL default 'default.jpg',
  `class` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`entityID`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=204 ;

-- 
-- Dumping data for table `entities_italy`
-- 

INSERT INTO `entities_italy` VALUES (200, 'Kishore Jayabalan', 'Director of Istituto Acton', 'Kishore organizes the institute’s educational and outreach efforts in Rome and throughout Europe.', 'jayabalan.jpg', 'person');
INSERT INTO `entities_italy` VALUES (201, 'Michael Severance', 'Development Operations Director', 'Michael helps organize conferences, increase private funding, expand networking, and assist with the daily administration of the Rome office.', 'severance.jpg', 'person');
INSERT INTO `entities_italy` VALUES (202, 'Valentina Ramadori', 'Secretary', 'Valentina has worked at the Pontifical Council for Justice and Peace and is now enjoying her administration work for Istituto Acton’s Rome office.', 'ramadori.jpg', 'person');
INSERT INTO `entities_italy` VALUES (203, 'Joseph Kosten', 'Intern', 'Joseph is the current intern for Istituto Acton and is a man of many talents.', 'kosten.jpg', 'person');

-- --------------------------------------------------------

-- 
-- Table structure for table `rollspots`
-- 

CREATE TABLE `rollspots` (
  `rollspotID` smallint(5) unsigned NOT NULL auto_increment,
  `shape` varchar(10) NOT NULL default '',
  `entityID` smallint(5) unsigned default NULL,
  PRIMARY KEY  (`rollspotID`),
  UNIQUE KEY `rollspotID` (`rollspotID`)
) TYPE=MyISAM AUTO_INCREMENT=109 ;

-- 
-- Dumping data for table `rollspots`
-- 

INSERT INTO `rollspots` VALUES (1, 'circle', 155);
INSERT INTO `rollspots` VALUES (2, 'circle', 125);
INSERT INTO `rollspots` VALUES (3, 'circle', 164);
INSERT INTO `rollspots` VALUES (4, 'circle', 152);
INSERT INTO `rollspots` VALUES (5, 'circle', 128);
INSERT INTO `rollspots` VALUES (6, 'circle', 105);
INSERT INTO `rollspots` VALUES (7, 'circle', 104);
INSERT INTO `rollspots` VALUES (8, 'circle', 110);
INSERT INTO `rollspots` VALUES (9, 'circle', 141);
INSERT INTO `rollspots` VALUES (10, 'circle', 132);
INSERT INTO `rollspots` VALUES (11, 'circle', 112);
INSERT INTO `rollspots` VALUES (12, 'circle', 150);
INSERT INTO `rollspots` VALUES (13, 'circle', 106);
INSERT INTO `rollspots` VALUES (14, 'circle', 131);
INSERT INTO `rollspots` VALUES (15, 'circle', 157);
INSERT INTO `rollspots` VALUES (16, 'circle', 123);
INSERT INTO `rollspots` VALUES (17, 'circle', 142);
INSERT INTO `rollspots` VALUES (18, 'circle', 159);
INSERT INTO `rollspots` VALUES (19, 'circle', 112);
INSERT INTO `rollspots` VALUES (20, 'circle', 133);
INSERT INTO `rollspots` VALUES (21, 'circle', 153);
INSERT INTO `rollspots` VALUES (22, 'circle', 112);
INSERT INTO `rollspots` VALUES (23, 'circle', 122);
INSERT INTO `rollspots` VALUES (24, 'circle', 107);
INSERT INTO `rollspots` VALUES (25, 'circle', 101);
INSERT INTO `rollspots` VALUES (26, 'circle', 109);
INSERT INTO `rollspots` VALUES (27, 'circle', 102);
INSERT INTO `rollspots` VALUES (28, 'circle', 146);
INSERT INTO `rollspots` VALUES (29, 'circle', 148);
INSERT INTO `rollspots` VALUES (30, 'circle', 160);
INSERT INTO `rollspots` VALUES (31, 'circle', 108);
INSERT INTO `rollspots` VALUES (32, 'circle', 119);
INSERT INTO `rollspots` VALUES (33, 'circle', 154);
INSERT INTO `rollspots` VALUES (34, 'circle', 101);
INSERT INTO `rollspots` VALUES (35, 'circle', 156);
INSERT INTO `rollspots` VALUES (36, 'circle', 136);
INSERT INTO `rollspots` VALUES (37, 'circle', 129);
INSERT INTO `rollspots` VALUES (38, 'circle', 151);
INSERT INTO `rollspots` VALUES (39, 'circle', 143);
INSERT INTO `rollspots` VALUES (40, 'circle', 166);
INSERT INTO `rollspots` VALUES (41, 'circle', 147);
INSERT INTO `rollspots` VALUES (42, 'circle', 103);
INSERT INTO `rollspots` VALUES (43, 'circle', 168);
INSERT INTO `rollspots` VALUES (44, 'circle', 116);
INSERT INTO `rollspots` VALUES (51, 'rect', 144);
INSERT INTO `rollspots` VALUES (52, 'rect', 145);
INSERT INTO `rollspots` VALUES (53, 'rect', 137);
INSERT INTO `rollspots` VALUES (54, 'rect', 118);
INSERT INTO `rollspots` VALUES (55, 'rect', 126);
INSERT INTO `rollspots` VALUES (56, 'rect', 111);
INSERT INTO `rollspots` VALUES (57, 'rect', 139);
INSERT INTO `rollspots` VALUES (58, 'rect', 117);
INSERT INTO `rollspots` VALUES (59, 'rect', 101);
INSERT INTO `rollspots` VALUES (60, 'rect', 138);
INSERT INTO `rollspots` VALUES (61, 'rect', 115);
INSERT INTO `rollspots` VALUES (62, 'rect', 121);
INSERT INTO `rollspots` VALUES (63, 'rect', 130);
INSERT INTO `rollspots` VALUES (64, 'rect', 120);
INSERT INTO `rollspots` VALUES (65, 'rect', 114);
INSERT INTO `rollspots` VALUES (66, 'rect', 140);
INSERT INTO `rollspots` VALUES (67, 'rect', 113);
INSERT INTO `rollspots` VALUES (68, 'rect', 134);
INSERT INTO `rollspots` VALUES (69, 'rect', 135);
INSERT INTO `rollspots` VALUES (70, 'rect', 127);
INSERT INTO `rollspots` VALUES (71, 'rect', 124);
INSERT INTO `rollspots` VALUES (100, 'circle_it', 200);
INSERT INTO `rollspots` VALUES (101, 'circle_it', 201);
INSERT INTO `rollspots` VALUES (102, 'circle_it', 202);
INSERT INTO `rollspots` VALUES (103, 'circle_it', 203);
INSERT INTO `rollspots` VALUES (104, 'circle_it', 204);
INSERT INTO `rollspots` VALUES (45, 'circle', 112);
INSERT INTO `rollspots` VALUES (46, 'circle', 112);