CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE CATEGORIES(CATEGORYID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,CATEGORY VARCHAR(10) NOT NULL)
CREATE MEMORY TABLE PHOTOS(PHOTOID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,FILENAME VARCHAR(30) NOT NULL,PHOTOGRAPHER VARCHAR(20) NOT NULL,DESC VARCHAR(100) NOT NULL,CATEGORYID INTEGER NOT NULL)
CREATE MEMORY TABLE ORDERS(ORDERID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,CUSTOMERNAME VARCHAR(30) NOT NULL,EMAIL VARCHAR(30) NOT NULL)
CREATE MEMORY TABLE LINEITEMS(RECORDID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,ORDERID INTEGER NOT NULL,PHOTOID INTEGER NOT NULL)
ALTER TABLE CATEGORIES ALTER COLUMN CATEGORYID RESTART WITH 8
ALTER TABLE PHOTOS ALTER COLUMN PHOTOID RESTART WITH 85
ALTER TABLE ORDERS ALTER COLUMN ORDERID RESTART WITH 1
ALTER TABLE LINEITEMS ALTER COLUMN RECORDID RESTART WITH 1
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20
SET SCHEMA PUBLIC
INSERT INTO CATEGORIES VALUES(1,'Abstract')
INSERT INTO CATEGORIES VALUES(2,'Animals')
INSERT INTO CATEGORIES VALUES(3,'City')
INSERT INTO CATEGORIES VALUES(4,'Flowers')
INSERT INTO CATEGORIES VALUES(5,'Misc')
INSERT INTO CATEGORIES VALUES(6,'Nature')
INSERT INTO CATEGORIES VALUES(7,'People')
INSERT INTO PHOTOS VALUES(1,'nature18.jpg','Lisa Traylor','Crab apple trees in bloom.',6)
INSERT INTO PHOTOS VALUES(2,'animals03.jpg','Emily Kim','Chubby donkey looking for a friend.',2)
INSERT INTO PHOTOS VALUES(3,'people08.jpg','Lisa Traylor','Tulle veil with pearl accents.',7)
INSERT INTO PHOTOS VALUES(4,'nature10.jpg','Lisa Traylor','Green blades of grass.',6)
INSERT INTO PHOTOS VALUES(5,'misc04.jpg','David Hassoun','Thomas Edison''s workshop.',5)
INSERT INTO PHOTOS VALUES(6,'abstract02.jpg','David Hassoun','Firedancer at midnight in downtown Denver.',1)
INSERT INTO PHOTOS VALUES(7,'city04.jpg','Emily Kim','Rooftops in Paris France.',3)
INSERT INTO PHOTOS VALUES(8,'nature16.jpg','Lisa Traylor','Overgrown garden.',6)
INSERT INTO PHOTOS VALUES(9,'nature07.jpg','Lisa Traylor','Sun through trees.',6)
INSERT INTO PHOTOS VALUES(10,'nature08.jpg','Lisa Traylor','Trunk Bay. St. John U.S.V.I.',6)
INSERT INTO PHOTOS VALUES(11,'nature09.jpg','Lisa Traylor','North.',6)
INSERT INTO PHOTOS VALUES(12,'abstract03.jpg','David Hassoun','Performer performing with two flames at once. Camera set at a slow shutter speed.',1)
INSERT INTO PHOTOS VALUES(13,'people06.jpg','Lisa Traylor','Shriner mini-cars.  Music and Blossom Festival Canon City.',7)
INSERT INTO PHOTOS VALUES(14,'abstract05.jpg','Carrie Shizlier','Street performer during Carnivale. Piazza San Marco Venice.',1)
INSERT INTO PHOTOS VALUES(15,'abstract06.jpg','Alida Simms','Chinese New Year celebration. Chinatown San Francisco.',1)
INSERT INTO PHOTOS VALUES(16,'abstract07.jpg','Austin Ryan','The unrelenting sun. Death Valley California.',1)
INSERT INTO PHOTOS VALUES(17,'abstract08.jpg','David Hassoun','Flight pattern of a firework. Camera set at slow shutter speed.',1)
INSERT INTO PHOTOS VALUES(18,'abstract09.jpg','David Hassoun','Group of joggers seen through thermo goggles.',1)
INSERT INTO PHOTOS VALUES(19,'abstract10.jpg','Cole Portman','Energy surge from gases orbiting Venus.',1)
INSERT INTO PHOTOS VALUES(20,'abstract11.jpg','Jason Eberheart','Close up of cigarette being discarded from moving vehicle.',1)
INSERT INTO PHOTOS VALUES(21,'animals01.jpg','Aziz Housaad',' Photo of a doe and deer outside of Cheyenne Wyoming.',2)
INSERT INTO PHOTOS VALUES(22,'animals02.jpg','Diane Rowlings','Close up of a doe outside of Cheyenne Wyoming.',2)
INSERT INTO PHOTOS VALUES(23,'animals04.jpg','Emily Kim','Elsie having corn on the cobb.',2)
INSERT INTO PHOTOS VALUES(24,'animals05.jpg','Emily Kim','Elsie driving to work in the morning.',2)
INSERT INTO PHOTOS VALUES(25,'animals06.jpg','Emily Kim','Elsie helping out with the campfire.',2)
INSERT INTO PHOTOS VALUES(26,'animals07.jpg','Austin Ryan','Mountain goat near the top of Pikes Peak.',2)
INSERT INTO PHOTOS VALUES(27,'animals08.jpg','James Tiner','The purebreads and a donkey at T Cross Ranch Colorado.',2)
INSERT INTO PHOTOS VALUES(28,'animals09.jpg','Carrie Shizlier','Baby racoon discovered after California wildfires.',2)
INSERT INTO PHOTOS VALUES(29,'animals10.jpg','Cole Portman','Monkey and her baby.  Monkey Island Vietnam.',2)
INSERT INTO PHOTOS VALUES(30,'animals11.jpg','Jason Eberheart','Iguana relaxing poolside in Westin St. John USVI.',2)
INSERT INTO PHOTOS VALUES(31,'abstract04.jpg','David Hassoun','Superheated gases demonstration. Senior project MIT.',1)
INSERT INTO PHOTOS VALUES(32,'animals12.jpg','Jason Eberheart','Shy gray parrot that blushes around crowds.',2)
INSERT INTO PHOTOS VALUES(33,'city01.jpg','Lisa Traylor','Twilight. Manhattan.',3)
INSERT INTO PHOTOS VALUES(34,'city02.jpg','Lisa Traylor','Evening rush hour. New York City New York.',3)
INSERT INTO PHOTOS VALUES(35,'city03.jpg','Emily Kim','Traveling Art Exhibit. The Met New York City.',3)
INSERT INTO PHOTOS VALUES(36,'flowers01.jpg','Lisa Traylor','Pink Vermillion.',4)
INSERT INTO PHOTOS VALUES(37,'flowers02.jpg','Cate Reiter','Signs of Fall Martha''s Vineyard.',4)
INSERT INTO PHOTOS VALUES(38,'flowers03.jpg','Lisa Traylor','Sub-alpine meadow blooms.',4)
INSERT INTO PHOTOS VALUES(39,'flowers04.jpg','Aidan Wilson','Cactus flower. Scottsdale Arizona',4)
INSERT INTO PHOTOS VALUES(40,'flowers05.jpg','Emily Kim','Indian paintbrush.',4)
INSERT INTO PHOTOS VALUES(41,'flowers06.jpg','Lisa Traylor','Pink umbrella daisies.',4)
INSERT INTO PHOTOS VALUES(42,'flowers07.jpg','Alexa Dansworth','White tea flowers.',4)
INSERT INTO PHOTOS VALUES(43,'flowers08.jpg','Adam Martin','Native alpine flower Switzerland.',4)
INSERT INTO PHOTOS VALUES(44,'flowers09.jpg','Emily Rossum','Cherry blossoms in bloom. Steamboat Springs Colorado',4)
INSERT INTO PHOTOS VALUES(45,'flowers10.jpg','Lisa Traylor','Close-up of flower pistils and stamen.',4)
INSERT INTO PHOTOS VALUES(46,'flowers11.jpg','Karl Bomblies','The Pride of Holland.',4)
INSERT INTO PHOTOS VALUES(47,'misc01.jpg','Lisa Traylor','19th century sugar mill.  St. John U.S.V.I.',5)
INSERT INTO PHOTOS VALUES(48,'misc02.jpg','Lisa Traylor','Abandoned colonial home.  St. John U.S.V.I.',5)
INSERT INTO PHOTOS VALUES(49,'misc03.jpg','Lisa Traylor','Sunset Caneel Bay. St. John U.S.V.I.',5)
INSERT INTO PHOTOS VALUES(50,'misc05.jpg','Lisa Traylor','Roof damage after Tornado. Kansas.',5)
INSERT INTO PHOTOS VALUES(51,'misc06.jpg','Lisa Traylor','Storm cellar where Kansas resident took shelter from F5 tornado.',5)
INSERT INTO PHOTOS VALUES(52,'misc07.jpg','Lisa Traylor','Abandoned snack stand. Nassau Bahamas.',5)
INSERT INTO PHOTOS VALUES(53,'misc08.jpg','Charles Stapelton','Bear cave.  Moab Utah.',5)
INSERT INTO PHOTOS VALUES(54,'misc09.jpg','David Hassoun','Native American home.  Mesa Verde Colorado',5)
INSERT INTO PHOTOS VALUES(55,'misc10.jpg','Lisa Traylor','Rusted mining headlamp.  Idaho Springs Colorado',5)
INSERT INTO PHOTOS VALUES(56,'misc11.jpg','Gerard Annuit','Roan shipwreck.  St. John U.S.V.I.',5)
INSERT INTO PHOTOS VALUES(57,'nature01.jpg','Lisa Traylor','Adolescent butterfly in the summer. taken atop Mount Evans in Colorado.',6)
INSERT INTO PHOTOS VALUES(58,'nature02.jpg','Collette Annuit','The road to forever.  New Orleans LA.',6)
INSERT INTO PHOTOS VALUES(59,'nature03.jpg','Lisa Traylor','Glorious sunset.  Tanzania Africa.',6)
INSERT INTO PHOTOS VALUES(60,'nature04.jpg','Joel Exeter','Fish Creek.  Wyoming.',6)
INSERT INTO PHOTOS VALUES(61,'nature05.jpg','Howard Aplin','Aspen majesty.',6)
INSERT INTO PHOTOS VALUES(62,'nature06.jpg','Lisa Traylor','Triumph of the survivor.',6)
INSERT INTO PHOTOS VALUES(63,'nature11.jpg','Joel Exeter','Fish Creek. Wyoming.',6)
INSERT INTO PHOTOS VALUES(64,'nature12.jpg','Lisa Traylor','Winter''s end.',6)
INSERT INTO PHOTOS VALUES(65,'nature13.jpg','Lisa Traylor','Apache Teepee.',6)
INSERT INTO PHOTOS VALUES(66,'nature14.jpg','Brooke Preston','Japanese fishing boats.  Okinawa Japan.',6)
INSERT INTO PHOTOS VALUES(67,'nature15.jpg','Brooke Preston','Xiao hill. Okinawa Japan',6)
INSERT INTO PHOTOS VALUES(68,'nature17.jpg','Evita Rhone','Jost Van Dyke. St. John U.S.V.I.',6)
INSERT INTO PHOTOS VALUES(69,'nature20.jpg','Lisa Traylor','Approaching Storm.  Black and White film.',6)
INSERT INTO PHOTOS VALUES(70,'people01.jpg','Lisa Traylor','French bridal veil.',7)
INSERT INTO PHOTOS VALUES(71,'people02.jpg','Evander Sloan','Cambodian orphans.',7)
INSERT INTO PHOTOS VALUES(72,'people04.jpg','Lisa Traylor','Army helicopter pilot.',7)
INSERT INTO PHOTOS VALUES(73,'people05.jpg','Lisa Traylor','Preparation for Moroccan meal.',7)
INSERT INTO PHOTOS VALUES(74,'nature19.jpg','Charles Stapelton','Cascade Falls.  Telluride Colorado.',6)
INSERT INTO PHOTOS VALUES(75,'abstract01.jpg','David Hassoun',' Photo of a performer dancing with fire. Camera set at a slow shutter speed.',1)
INSERT INTO PHOTOS VALUES(76,'people09.jpg','Clay Portman','Buddha statue shop. Chengdu China.',7)
INSERT INTO PHOTOS VALUES(77,'people10.jpg','Emily Kim','Flower carrier in Vietnam.',7)
INSERT INTO PHOTOS VALUES(78,'people11.jpg','Lisa Traylor','Motorcycle bride.',7)
INSERT INTO PHOTOS VALUES(79,'people12.jpg','Lisa Traylor','Cannonball.',7)
INSERT INTO PHOTOS VALUES(80,'people13.jpg','Lisa Traylor','Three piece tulle veil.',7)
INSERT INTO PHOTOS VALUES(81,'people14.jpg','Lisa Traylor','Woman waiting for her suitor.',7)
INSERT INTO PHOTOS VALUES(82,'people07.jpg','Lisa Traylor','Canon City Queen. Music and Blossom Festival Canon City.',7)
INSERT INTO PHOTOS VALUES(83,'people03.jpg','Lisa Traylor','Army drill exercise.',7)
INSERT INTO PHOTOS VALUES(84,'people15.jpg','Lisa Traylor','Parade crowd.',7)
