classroom 的 database

CREATE DATABASE IF NOT EXISTS classroom;

USE classroom;

CREATE DATABASE IF NOT EXISTS classroom;

USE classroom;

--

-- Definition of table `class_activity`

--

DROP TABLE IF EXISTS `class_activity`;

CREATE TABLE `class_activity` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `master_activity_id` int(11) NOT NULL,

  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;

INSERT INTO `class_activity` (`id`,`master_activity_id`,`date`) VALUES

 (4,53,'2010-12-14 00:00:00'),

 (8,153,'2011-05-23 00:00:00'),

 (12,59,'2011-03-08 00:00:00'),

 (13,20,'2010-11-02 00:00:00'),

 (14,213,'2011-02-22 00:00:00'),

 (18,144,'2011-02-01 00:00:00'),

 (32,151,'2011-04-12 00:00:00'),

 (37,12,'2011-03-22 00:00:00'),

 (40,116,'2011-01-11 00:00:00'),

 (48,183,'2011-06-07 00:00:00');

DROP TABLE IF EXISTS `master_activity`;

CREATE TABLE `master_activity` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(128) DEFAULT NULL,

  `address` varchar(128) DEFAULT NULL,

  `city` varchar(32) DEFAULT NULL,

  `state` char(2) DEFAULT NULL,

  `details` varchar(256) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=226 DEFAULT CHARSET=latin1;

/*!40000 ALTER TABLE `master_activity` DISABLE KEYS */;

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (3,'Ocean Park Playground','2400 Barnard Way at Ocean Park.','Santa Monica','CA','This is a marvelous playground, with an ocean view, situated right next to'),

 (4,'Santa Anita Park','285 West Huntington Drive','Arcadia','CA','The historic Santa Anita Park is known as one of the most beautiful race tracks in the world, and on a clear day, with the snow-capped mountains in the distance, the waving palm trees, s...'),

 (9,'Santa Monica Pier Aquarium','1600 Ocean Front Walk','Santa Monica','CA','Built underneath the Santa Monica Pier for the purpose of research and ed...'),

 (11,'Griffith Park','4730 Crystal Springs Drive','Los Angeles','CA','Los Angeles doesn\'t have many of those beloved public spaces that give energy and a sense of identity to great cities like New York, Chicago or Boston. Griffith Park is one of the few such spac...'),

 (12,'Adventure City','1238 S. Beach Blvd.','Anaheim','CA','There is little room for doubt that the local Disney theme parks and'),

 (14,'The Getty Center','1200 Getty Center Drive','Los Angeles','CA','A must-see on everyone\'s list is The Getty Center, featuring the J Paul Getty Museum sitting high atop the Santa Monica Mountains.\r\nA world class art collection, including...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (18,'Mar Vista Farmers\' Market','Grand View Ave. and Venice Blvd.','Los Angeles','CA','A local favorite, the Mar Vista Farmers\' Market brings a host of fresh fruits, vegetables, seafood, and more to the post office parking lot every Sunday. The market is here rain or shine.'),

 (20,'Brand Park and Library','1601 West Mountain Street','Glendale','CA','This is a beautiful park in the foothills north of Glendale, a great favorite with the locals. It has enormous trees, a recently renovated playground, plenty of running around space, and a coup...'),

 (21,'El Dustberry Ranch','3000 Rustic Canyon Road','Pacific Palisades','CA','El Dustberry Ranch is an equine assisted therapeutic activity center and outdoor classroom. Formerly located in Topanga, the facility brings together rescue horses and the children who c...'),

 (23,'Polliwog Park','1601 Manhattan Beach Blvd.','Manhattan Beach','CA','Polliwog Park has two playgrounds for children, including special play equipment for toddlers.\r\nA huge pond in the park is a favorite spot for children to feed the ducks, watch for fish...'),

 (24,'Forneris Farms','15200 Rinaldi Street','Mission Hills','CA','Forneris Farms is a great seasonal excursion - stop by in the fall to pick a pumpkin, get lost in the corn maze, and take a ride on a mini-train pulled by a tractor. Other highlights include fa...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (25,'Hopkins Wilderness Park','1102 Camino Real','Redondo Beach','CA','Hopkins Wilderness Park was developed in 1977 as a center for camping, nature study, and conservation. It is a large, shady wilderness park with self-guided nature walks and two large ponds wit...'),

 (31,'Thousand Oaks Civic Arts Plaza','2100 Thousand Oaks Blvd','Thousand Oaks','CA','The Thousand Oaks Civic Arts Plaza houses the 1,800-seat Fred Kavli Theatre for the Performing Arts, the 394-seat Janet and Ray Scherr Forum, a spacious three-acre park, and City ...'),

 (36,'LA County Fair & Exposition Complex/Fairplex','1101 W. McKinley Avenue','Pomona','CA','The Fairplex in Pomona hosts some 300 events each year, but it\'s best known for hosting the Los Angeles County Fair every September - one of the largest events of its kind in the country, and a...'),

 (38,'Disney\'s California Adventure','1313 S. Harbor Boulevard','Anaheim','CA','California Adventure, the companion park to Disneyland, serves up the industry gian...'),

 (48,'Neophyte Farms - Horseback Riding','Nonchalant Road','Simi Valley','CA','Neophyte Farms is a small, neighborhood riding school with horses appropriate for beginners to intermediate riders. All lessons are one-on-one.\n\nIn addition to lessons and trail rides, Neoph...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (49,'Marina Beach (aka Mother\'s Beach)','4101 Admiralty Way','Marina del Rey','CA','Marina Beach, also called Mother\'s Beach, is a favorite among mothers with small children for its lack of surf. There are climbing gyms and a pirate ship as well as picnic shelters nearb...'),

 (52,'Corriganville Park','Smith Road','Simi Valley','CA','First purchased as a movie ranch and later run as a western-themed and stunt amusement park, Corriganville Park is now owned by the city of Simi Valley and is a 246-acre regional park.\n...'),

 (53,'Orange County Model Engineers','2525 Placentia Avenue','Costa Mesa','CA','The Orange County Model Engineers operate the Mackerel Flats and Goat Hill Junction Railroad - a seven and a half inch gauge railroad over a five mile layout of track at Fairview Park in Costa ...'),

 (54,'O\'Melveny Park','17300 Sesnon Blvd.','Granada Hills','CA','O\'Melveny Park in the San Fernando Valley is the city\'s second largest park, sprawling over 672 acres. Located in the mountains above Granada Hills, the park is unstaffed but features miles of ...'),

 (58,'Magnolia Park','2500-4500 Magnolia Boulevard','Burbank','CA','The Magnolia Park neighborhood offers several blocks of fun shopping, dining, and other family activities along Magnolia Boulevard from Buena Vista to Clybourn. Highlights along the way include...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (59,'Animal Acres','5200 Escondido Canyon Road','Acton','CA','Animal Acres is home to rescued cows, pigs, chickens, turkeys, sheep, goats, and other critters.\nVolunteering opportunities are available for ages 12 and over (ages 12 to 18 must be acc...'),

 (61,'Rick Baer Training Stables','18381 Goldenwest Street','Huntington Beach','CA','Rick Baer Training Stables offers all phases of western horseback riding lessons for beginners to advanced riders, from children to adults. The stables are located in Huntington Beach Central P...'),

 (63,'Little Tokyo','San Pedro Street and 2nd Street','Los Angeles','CA','One of the gems of downtown Los Angeles; a day in Little Tokyo will remind residents of how wonderful their city is, and visitors will feel as though they\'ve uncovered a treasure.\n\nThe neighbor...'),

 (64,'Six Flags Hurricane Harbor','26101 Magic Mountain Pkwy','Valencia','CA','Six Flags Hurricane Harbor holds up the wetter end of the Six Flags California experience, anchored by'),

 (66,'The SEA Lab','1021 North Harbor Drive','Redondo Beach','CA','The SEA Lab is a hands-on coastal science education center in Redondo Beach that offers free and low cost programs for explorers of all ages. The SEA Lab houses over a hundred rescued an...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (67,'Portuguese Bend Riding Club','40 Narcissa Drive','Rancho Palos Verdes','CA','PBRC offers beginning, intermediate and advanced lessons in English-style riding and Hunter/Jumpers. Children ages six and up - and adults - are welcome.\n\nThe facility offers a beautiful and re...'),

 (68,'Griffith Park & Southern Railroad','Crystal Springs Drive near Los Feliz Boulevard','Los Angeles','CA','All aboard the Griffith Park & Southern Railroad for a trip through Gr...'),

 (69,'Griffith Park Pool','3401 Riverside Drive','Los Angeles','CA','The Recreation and Parks Department\'s Aquatics Division categorizes Griffith Park Pool as a summer pool, meaning that it\'s open daily from the third Saturday in June through Labor Day.'),

 (70,'Rustic Canyon Park','601 Latimer Road','Santa Monica','CA','This idyllic park is actually a hive of activity.\n\nTennis lessons are available for $80/eight weekly sessions. The six courts are also open to the public during the day, on a first-come...'),

 (71,'Naya\'s Garden','2836 W Sunset Boulevard','Los Angeles','CA','Naya\'s Garden indoor and outdoor playground provides a safe environment where children can play and socialize. Play areas include a climbing wall, giant maze with ball pit, bouncy area, treehou...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (72,'Eaton Canyon','1750 Altadena Drive','Pasadena','CA','The Eaton Canyon Nature Center, at the foot of Mount Wilson, is a great place to begin for some family-friendly hikes into the 190-acre Eaton Canyon Nature Area, and the San Gabriel Moun...'),

 (73,'UCLA','405 Hilgard Avenue','Los Angeles','CA','From a simple outdoor picnic in the sculpture garden to a kids\' show at Royce Hall, the University of California, Los Angeles (UCLA) is more than just a world-class educational instituti...'),

 (75,'Lake Casitas Water Adventure','1311 Santa Ana Road','Ventura','CA','The Lake Casitas Water Adventure is a water park and recreation area offering several distinct water playgrounds for families, as well as a fully-loaded campground adjacent.\nFor ...'),

 (76,'Zone Club, Inc.','826 N. Glendale Avenue','Glendale','CA','Zone Club offers both a two-story indoor playground and a two-story laser tag arena under one roof, as well as a food court and party room.\n\nThe younger kids\' playground includes a rock climbin...'),

 (77,'Juan Bautista de Anza Park','3701 Lost Hills Road','Calabasas','CA','It\'s not the largest park around, but Juan Bautista de Anza is very popular with families in the west valley. The playground is next to the parking lot, and the adjacent recreation center is br...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (81,'PiggyArt','Saint Andrews Church, 1432 Engracia Avenue','Torrance','CA','PiggyArt offers art classes for toddlers and preschoolers.\n\nChildren explore the world of art through the use of tempera paints, acrylic paints, homemade playdough, stampers, and more. Storytim...'),

 (83,'Bears, Buddies & Toys','3877 Alton Parkway','Irvine','CA','Bears, Buddies & Toys is a clothing boutique, toy store, party place, stuff-a-buddy or -bear center, and storytime place all rolled into one.'),

 (85,'Roxbury Park','471 S. Roxbury Drive','Beverly Hills','CA','Roxbury Park offers one of the largest children\'s playgrounds in Beverly Hills with plenty of metered parking surrounding the perimeter.\r\nThe playground features a toddler play area'),

 (86,'Bass Pro Shop','7777 Victoria Gardens Lane','Rancho Cucamonga','CA','Whether you live for the outdoors or not, Bass Pro Shop is a real treat to visit: The 165,000-square-foot, two-story building is built of logs and rocks, reminiscent of old-style Adirondack ...'),

 (95,'Under the Sea','8471 Beverly Boulevard #206','Los Angeles','CA','Under the Sea is the answer to 100+ degree summers and wet, wet, wet winters: kids can jump, bounce, run, climb, and even have make-believe tea parties at this indoor playground for the ..');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (100,'Rolling Robots','21712 Hawthorne Blvd. #295','Torrance','CA','Robot building parties and robotics camps are all in a day\'s work for Rolling Robots. Parties can be customized for any ages, and camps take place in three-hour labs that can be b...'),

 (102,'Hands-on 3rd','8377 W. Third Street','Los Angeles','CA','Hands-on 3rd is an arts space on Third Street in West Hollywood, offering a variety of crafty classes for kids and adults. Arts camps are available during most school vacations.'),

 (104,'Piccolo Chef','12120 Wagner Street','Culver City','CA','Italian cooking can\'t get much more authentic than the classes at Piccolo Chef, a culinary academy for kids that operates under the auspices of the Italian Consulate. The academy is based at th...'),

 (105,'Totz Only','3009 W. Magnolia Blvd.','Burbank','CA','Totz Only is a kids\' clothing store that also sells books and toys for children up to eight years old. The store offers free arts and crafts activities, free storytelling, and kindermusik class...'),

 (116,'McGroarty Arts Center','7570 McGroarty Terrace','Tujunga','CA','Located in the former home of John McGroarty (1923-1944, journalist, playwright, poet laureate, and Congressman), the McGroarty Arts Center seeks to provide affordable instruction in the arts a...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (117,'Art-Works Studio','8688 Washington Blvd','Culver City','CA','Classes at Art-Works are designed to give students the opportunity to explore in depth the rich experience of painting, drawing, and mixed media. Continuous classes are weekly and students may ...'),

 (119,'Broadway Gymnastic School','5433 Beethoven Street','Los Angeles','CA','Whether your child wants to learn a new sport, has special needs, or hopes to become an Olympic competitor, he or she can find a comfortable niche at Broadway Gymnastic School. The instructors ...'),

 (120,'AdventurePlex','1701 Marine Avenue','Manhattan Beach','CA','AdventurePlex, South Bay\'s health and fitness center designed especially for kids, is a fun place to play, with an outdoor climbing wall, gymnasium and fitness center, challenging mazes, tunnel...'),

 (126,'Child\'s Play','2299 Westwood Blvd','Los Angeles','CA','Note: Child\'s Play closes for good on July 13, 2009.\r\nA wonderful indoor playground, Child\'s Play has open play and classes on weekdays and private birthday parties on the weeken...'),

 (128,'Zinnia','1040 Mission Street','South Pasadena','CA','Zinnia, located within the Mission-Meridian Dis...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (129,'Original Los Angeles Farmers Market','6333 West Third Street','Los Angeles','CA','In 1934, a group of farmers gathered at Third and Fairfax to sell fresh food from their trucks. Since that time, The Original Los Angeles Farmers Market has fed and entertained countless touris...'),

 (131,'The Huntington','1151 Oxford Road','San Marino','CA','An afternoon at The Huntington Library, Art Collections, and Botanical Gardens is an ideal way to spend quality family time, and perfect day to spend with grandparents and other special out-of-...'),

 (132,'Aquarium of the Pacific','100 Aquarium Way','Long Beach','CA','The Aquarium in Long Beach is a terrific facility celebrating the inhabitants of the Pacific Ocean. You\'ll find tropical fish exhibits, coral reefs, sea otters, seals and sea lions, sea turtles...'),

 (133,'Chevalier\'s Books','126 N. Larchmont Blvd.','Los Angeles','CA','This lovely independent bookstore is a popular stop for'),

 (136,'Ronald Reagan Presidential Library and Museum','40 Presidential Drive','Simi Valley','CA','One of only twelve presidential libraries directed by the National Archives and Records Administration, the Ronald Reagan Presidential Library and Museum sits on a mountaintop with sweeping vie...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (137,'Stoner Park','1835 Stoner Avenue','Los Angeles','CA','Stoner Park is probably best known for its unique swimming facility in summer months. The outdoor pool features a wide shoreline effect, allowing kids to make their way gradually into th...'),

 (138,'Gull Wings Children\'s Museum','418 W 4th Street','Oxnard','CA','Oxnard\'s interactive Gull Wings Children\'s Museum is a hidden gem in Ventura County. The museum is divided into areas, including highlights like a touch tank full of starfish and other local ti...'),

 (139,'Zoom Room Dog Agility Training Center','11836 Teale St.','Culver City','CA','The Zoom Room is a dog agility center offering after school classes in which kids can teach their dogs how to run through tunnels, jump hurdles, and climb over obstacles.\nThe parents\' l...'),

 (140,'The Page Museum at the La Brea Tar Pits','5801 Wilshire Boulevard','Los Angeles','CA','About four Great Ice Ages ago, during the Pleistocene Epoch, hundreds of different kinds of animals roamed the hills and valleys of what is now Los Angeles. Some of them, sadly, made the mistak...'),

 (141,'Scribble Press','1109 Montana Ave.','Santa Monica','CA','The inviting studio at Scribble Press is a place where families can create all sorts of gratifying creative projects. Kids can write and illustrate their own books; parents can turn artwork int...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (143,'Boone Children\'s Gallery','6067 Wilshire Boulevard','Los Angeles','CA','The Boone Children\'s Gallery is an interactive gallery for children and families, located at'),

 (144,'Froggy\'s Arts and Crafts','11332 Camarillo Street','North Hollywood','CA','Froggy\'s Arts and Crafts offers children\'s art classes, music classes, story time with craft, workshops, birthday parties, and studio art time. Classes can be purchased by the session or indivi...'),

 (148,'Every Picture Tells a Story','1311-C Montana Avenue','Santa Monica','CA','Once located in LA\'s Fairfax district, this gallery dedicated to the art of illustration and children\'s literature is now in the heart of Santa Monica\'s pedestrian-friendly'),

 (149,'Griffith Observatory','2800 E. Observatory Road','Los Angeles','CA','The newly renovated Griffith Park Observatory is one of the city\'s top attractions. While retaining the charm of the original 1935 structure, it has acquired new features like a seamless dome i...'),

 (150,'Ceramic Art Space','6020 Woodman Avenue','Van Nuys','CA','Ceramic Art Space is a ceramic supply house with more than 700 colors, over 4,000 items for painting, and a wide variety of brushes, sponges, and stencils. The possibilities for creating a mast...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (151,'Los Angeles State Historic Park','1245 N. Spring Street','Los Angeles','CA','Located right in the heart of the city, Los Angeles State Historic Park offers 32 acres of open space directly adjacent to Chinatown, with views of downtown and opportunities to explore the cul...'),

 (152,'Heritage Hill Historical Park','25151 Serrano Road','Lake Forest','CA','The small village at Heritage Hill Historical Park preserves some of the cultural heritage of Orange County. The four historical buildings represent different eras in the early development of t...'),

 (153,'South Pasadena Arts Center','1506 Mission Street','South Pasadena','CA','South Pasadena Arts Center, also known by the acronym SPACE, is a gallery that offers art workshops for families.'),

 (154,'California State University, Northridge','18111 Nordhoff Street','Northridge','CA','CSUN, the San Fernando Valley campus of the huge California State University public system, is one of the largest universities in the country, with some 30,000 graduate and undergraduate studen...'),

 (155,'Geffen Playhouse','10886 Le Conte Avenue','Los Angeles','CA','In just a few years, the Geffen Playhouse has changed the cultural landscape of Los Angeles\' Westside, growing into a vital performing arts organization with over 130,000 annual attendees.');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (156,'Westwood Branch Library','1246 Glendon Avenue','Los Angeles','CA','Library programs at Westwood Branch Library include storytime, classes for teens, Grandparents and Books, puppet shows, movies, crafts, and family activities. See our events'),

 (157,'Santa Monica Playhouse','1211 Fourth Street','Santa Monica','CA','This 92-seat Santa Monica Playhouse has a regular schedule of original musical theater for children on weekends. Check our'),

 (159,'Caltech Campus','1200 East California Blvd','Pasadena','CA','The California Institute of Technology, or Caltech, is a paradise for kids with surplus energy. The campus comprises acres of green space, public art, plazas, water fountains, pon...'),

 (162,'Bubblegum Playhouse','13500 Ventura Blvd','Sherman Oaks','CA','The Bubblegum Playhouse operates out of the Whitefire Theatre, offeri...'),

 (163,'Bob Baker Marionette Theater','1345 W. 1st Street','Los Angeles','CA','With the founding of the Bob Baker Marionette Theater in 1963, Bob, along with his partner Alton Wood, established the longest running children\'s theater in Los Angeles. All of the marionettes,...'),

 (164,'Victoria Gardens Cultural Center','12505 Cultural Center Drive','Rancho Cucamonga','CA','The Victoria Gardens Cultural Center is home to the Paul A. Biane Library, the Lewis Family Playhouse, and Celebration Hall. Combined, the facility offers 89,000 square feet; meeting and...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (165,'The All American Melodrama','429 Shoreline Village Drive, Suite E','Los Angeles','CA','The All American Melodrama Theater and Music Hall offers Long Beach area families some good old-fashioned fun. The old-time revues, classic melodramas, and holiday extravaganzas are performed b...'),

 (166,'Los Angeles County Arboretum & Botanic Garden','310 North Baldwin Avenue','Arcadia','CA','An arboretum is a place where trees, shrubs, and herbaceous plants are cultivated for scientific and educational purposes; it\'s also a place for strolling, sunning, and relaxing among shady trees, flo...'),

 (167,'Douglas Park','1116 Chelsea Avenue','Santa Monica','CA','Douglas Park, a beloved Santa Monica green space, used to be a reservoir; a renovation created four-and-half acres that hold a great playground, ponds and streams filled with lily pads and fish...'),

 (168,'California Science Center','700 Exposition Park Drive','Exposition Park','CA','This state-of-the-art science museum easily merits a day-long visit to experience fully all three floors of stimulating - and fun - hands-on exhibitions and activities.\nThe experience starts b...'),

 (169,'McCabe\'s Guitar Shop','3101 Pico Blvd','Santa Monica','CA','Since becoming a major force on the LA music scene in the early \'70s, McCabe\'s Guitar Shop is known as much for its folk and rock concerts as for its superb selection and service to the string-...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (170,'Debbie Allen Dance Academy','3623 Hayden Avenue','Culver City','CA','We all remember her name; the Debbie Allen Dance Academy is the studio for parents who wish they had gone to that Fame school made so famous by Ms. Allen when they were kids. And there\'s...'),

 (171,'Rollerskating Fundraiser Party at Moonlight Rollerway','5110 San Fernando Rd','Glendale','CA','Moonlight Rollerways in Glendale has a junior and senior Syncronized Rollerskating team \"Precision Team In Sync\".  Come join in the Rollerskating FUN on Sunday May 3rd 11-1pm. They are having a Fundra...'),

 (172,'Magicopolis','1418 Fourth Street','Santa Monica','CA','Magicopolis combines magic, music, and special effects to awe and delight those taken with the mysteries of fantasy and illusion.\r\nThe large Abracadabra Theater hosts major perfo...'),

 (174,'Glendora Public Library','140 S. Glendora Avenue','Glendora','CA','Glendora Public Library houses a young adult collection of 4,900 items, including fiction, nonfiction, and reference titles. Computer use with internet connection is available to library card h...'),

 (175,'Skirball Cultural Center','2701 North Sepulveda Blvd','Los Angeles','CA','This lively cultural center in the Santa Monica Mountains celebrates 4,000 years of Jewish tradition and history.\r\n\r\nThe Museum has some 30,000 items representing the richness and diver...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (177,'LA Connection Comedy Theatre','13442 Ventura Boulevard','Sherman Oaks','CA','Parents can sign budding performers up for a Comedy Improv for Kids workshop at the LA Connection Comedy Theatre.\r\nKids get to learn, rehearse, and, eventually - after about six ...'),

 (180,'Bang Comedy Theater','457 N. Fairfax Ave.','Los Angeles','CA','Bang Comedy Theater is a small comedy improv space in the Fairfax district. Most shows are adult-oriented, but child-friendly shows are occasionally offered as well.'),

 (182,'Secret Rose Theatre','11246 Magnolia Blvd','North Hollywood','CA','The Secret Rose Theatre, established in 1999, is a fully-equipped professional theatre.\r\nThe theater offers Acting Classes for kids ages five to seven, and for kids ages eight to...'),

 (183,'Adamson House and Malibu Lagoon Museum & Beach','23200 Pacific Coast Highway','Malibu','CA','The park has two entrances: the southern one for Adamson House, and the northern one for Malibu Lagoon Beach.\r\nThe classic home, designed by Stiles O. Clements in 1929, wa...'),

 (184,'The Grove at Farmers Market','189 The Grove Drive','Los Angeles','CA','The Grove features first class open air shopping, with Pottery Barn K...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (185,'Occidental College Children\'s Theater','1600 Campus Road','Los Angeles','CA','Performances at the Occidental College Children\'s Theater are offered in the summer, at the Remsen Bird Hillside Theater on campus.\r\nWhen shows are in session, a cast of six Occidental ...'),

 (186,'Armory Center for the Arts','145 N. Raymond Avenue','Pasadena','CA','Armory Center for the Arts is a 20,000 square-foot space conceived to give the community opportunities to appreciate and create contemporary art. The Armory started as the educati...'),

 (187,'Cabrillo Marine Aquarium','3720 Stephen White Drive','San Pedro','CA','The Cabrillo Marine Aquarium is an educational, recreational, and research facility devoted to encouraging active public participation to promote knowledge and conservation of the marine life o...'),

 (188,'Starlight Bowl','1249 Lockheed View Drive','Burbank','CA','Right in the heart of Burbank, the Starlight Bowl hosts summertime family-friendly performances.\r\nBring a blanket or spring for higher priced stadium seats. Sunday evening\'s \"almost fre...'),

 (189,'Christine Emerson Reed Park','1150 Lincoln Boulevard','Santa Monica','CA','Christine Emerson Reed Park, formerly known as Lincoln Park, offers a variety of cultural events, community classes, activities, and park amenities, including playground equipment and pi...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (190,'Joy Theatre','5233 Lankershim Blvd','North Hollywood','CA','Joy Theatre is a children\'s comedy theater located in North Hollywood. It offers four regularly scheduled comedy variety shows starring children and teens that are fun for the entire fam...'),

 (192,'Blue Chair Children\'s Books','177 N. Glendora Avenue','Glendora','CA','Blue Chair Children\'s Books Store is as cozy as its namesake - packed with great kid and teen lit. Weekly free events are offered, including storytime, puppet shows, costume parties, and...'),

 (193,'Westchester Playhouse','8301 Hindry Avenue','Los Angeles','CA','Home of the Kentwood Players, the Westchester Playhouse often hosts family-friendly productions.'),

 (194,'Quick Culture','9190 W. Olympic Blvd., Suite 125','Beverly Hills','CA','Quick Culture offers specially crafted tours to introduce children (and adults) to the permanent collection at the'),

 (195,'Cynthia Bain\'s Young Actor Studio','12265 Ventura Blvd., Suite 210','Studio City','CA','Hollywood acting coach Cynthia Bain offers professional level acting classes and coaching for kids at her Young Actor Studio.'),

 (196,'The Commons at Calabasas','4700 Commons Way','Calabasas','CA','The Commons at Calabasas is an upscale, attractive shopping center, recreated as an authentic Italian village (they even hired a movie set director to help design it) with plenty of plac...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (198,'Lopez Pumpkin Patch','West Third St. and Fairfax Blvd.','Los Angeles','CA','A low-key, traditional alternative to the flashy patches, Lopez Pumpkin Patch has been at the same location every October for over 40 years. Kids can climb on a giant fiberglass jack-o-lantern ...'),

 (199,'The Bridge Cinema De Lux','6081 Center Drive','Los Angeles','CA','The IMAX Theatre at the Bridge is one of the neatest state-of-the-art movie theaters we\'ve seen! The giant screen brings you back to the days when going to the movies was something out of the o...'),

 (200,'Santa Fe Dam Recreation Area','15501 E. Arrow Highway','Baldwin Park','CA','Operated by LA County Parks, Santa Fe Dam Recreation Area has a 70-acre lake for sailing, swimming, and fishing and a popular children\'s water play area open during summer months. Other feature...'),

 (202,'Skull Kingdom Haunted House','23210 Ventura Boulevard','Woodland Hills','CA','When Halloween rolls around, Skull Kingdom Haunted House opens its doors for a month of ghoulish entertainment. A non-scary version for little ones is generally available as well.\r\nS...'),

 (203,'McGrath Street Pumpkin Patch','5156 McGrath St.','Ventura','CA','Families looking for a real pumpkin patch - the kind Linus would sit in all night - should check out Ventura\'s McGrath Street Pumpkin Patch. The extra drive from central LA means that, instead ...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (206,'Highways Performance Space','1651 18th Street','Santa Monica','CA','Highways Performance Space in a cultural center in Santa Monica offering a home to experimental theater, dance, solo drama, and other multimedia performance.'),

 (207,'Assistance League Playhouse','1367 North Saint Andrews Place','Los Angeles','CA','This big and beautiful theater presents children\'s musicals, mostly performed by the all-women theater company, the'),

 (208,'Hollywood Walk of Fame','Hollywood Boulevard','Los Angeles','CA','This legendary sidewalk honors over 2500 TV, film, radio, and theater celebrities with a bronze medallion in the center of a granite star along Hollywood Blvd. and Vine Street.\r\nThe pub...'),

 (210,'Morgan-Wixson Theatre','2627 Pico Blvd','Santa Monica','CA','Santa Monica\'s 200-seat Morgan-Wixson is home to the YES - Youth Education/Entertainment Series, offering productions based on children\'s literature and featuring youth and teen actors working ...'),

 (211,'Averyboo Arts','3908 Atlantic Ave.','Long Beach','CA','Averyboo Arts in Bixby Knolls is a creativity center and gallery offering art enrichment classes and and an open studio. Kids can indulge in easel painting, craft tables, a variety of building ...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (212,'Franklin Canyon Park','2600 Franklin Canyon Drive','Beverly Hills','CA','A quiet hideaway in the center of the city\'s hustle and bustle, Franklin Canyon Park rests on 605 acres at the geographic center of Los Angeles, between the San Fernando Valley and Beverly Hill...'),

 (213,'Discovery Science Center','2500 N. Main Street','Santa Ana','CA','The Discovery Science Center, also known as the Discovery Cube is a 59,000-square-foot interactive, hands-on learning facility designed to spark children\'s natural curiosity. Dedicated t...'),

 (214,'Dragonfly DuLou','2066 Hillhurst Avenue','Los Angeles','CA','A popular children\'s clothing boutique in the hip Los Feliz neighborhood, Dragonfly DuLou sells a variety of handmade children\'s furniture, toys, dolls, paintings, and other unique items.'),

 (216,'Venice Beach Boardwalk','1800 Ocean Front Walk','Venice','CA','One of southern California\'s most famous attractions is also one of of its most interesting. There is a sandy three-mile beach here, but that is not what attracts visitors, who come to Venice\'s Boardw...'),

 (217,'Annenberg Community Beach House','415 Pacific Coast Highway','Santa Monica','CA','Decades in the planning, the Annenberg Community Beach House opened in April 2009 as a public facility for the people of Santa Monica to enjoy a family day at the beach.\r\nThe Annenberg ...');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (218,'The Game Coach','2755 N. Lincoln Street','Los Angeles','CA','The Game Coach is a state-of-the-art Video Gaming Vehicle (VGV). The high-tech trailer brings five X-box 360 video game consoles, a 50-inch plasma television, four LCD monitors, an Alpin...'),

 (219,'Ventura Harbor Village','1583 Spinnaker Drive','Ventura','CA','Ventura Harbor Village is 33 acres of SoCal at its best, with sea breezes rolling in off the harbor, shopping, dining, and easy access to the Channel Islands National Park.'),

 (220,'Monrovia\'s Friday Night Family Festival','Myrtle Avenue, between Lemon and Walnut','Monrovia','CA','The Friday Night Family Festival is half party, half farmer\'s market, with items for sale ranging from hand made crafts to food. There are activities for kids, kiddie rides, and free live enter...'),

 (221,'Faulkner Farm Pumpkin Patch','14292 W. Telegraph Road','Santa Paula','CA','Historic Faulkner Farm opens its gates to the public every autumn to provide a month-long celebration of country fun and Halloween magic; check our calendar for details.\r\nVisitors can b...'),

 (222,'California State University, Los Angeles','5151 State University Drive','Los Angeles','CA','Cal State LA has been serving the community for over 50 years.\n\nThe Luckman Fine Arts Complex hosts exhibits throughout the year, as well as concerts and plays; check our');

INSERT INTO `master_activity` (`id`,`name`,`address`,`city`,`state`,`details`) VALUES

 (223,'Electric Lodge Theatre','1416 Electric Avenue','Venice','CA','The Electric Lodge Theatre is a solar-powered visual and performing arts center in Venice. In addition to its theater space, it also has various studio spaces and is home to a myriad of classes...'),

 (225,'Holman United Methodist Church','3320 W. Adams Blvd.','Los Angeles','CA','Holman United Methodist Church is the home of the famed Holman Choir, one of the great gospel music choirs in Los Angeles, and its annual Concert of Negro Spirituals. Check our calendar ...');

/*!40000 ALTER TABLE `master_activity` ENABLE KEYS */;

DROP TABLE IF EXISTS `participation_type`;

CREATE TABLE `participation_type` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(32) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

INSERT INTO `participation_type` (`id`,`name`) VALUES

 (1,'none'),

 (2,'Supplies'),

 (3,'Prep'),

 (4,'Assist'),

 (5,'Lead');

DROP TABLE IF EXISTS `student`;

CREATE TABLE `student` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `user_id` int(11) NOT NULL,

  `s_name` varchar(64) DEFAULT NULL,

  `p_name` varchar(64) DEFAULT NULL,

  `address` varchar(128) DEFAULT NULL,

  `city` varchar(32) DEFAULT NULL,

  `state` char(2) DEFAULT NULL,

  `zip` char(10) DEFAULT NULL,

  `phone` char(20) DEFAULT NULL,

  `email` varchar(64) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `user_id` (`user_id`)

) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO `student` (`id`,`user_id`,`s_name`,`p_name`,`address`,`city`,`state`,`zip`,`phone`,`email`) VALUES

 (1,2,'Leena Green','Lisa & Kevin Green','900 Farlon Rd.','Los Angeles','CA','90034','310-893-0993','keving@greenery.com'),

 (2,2,'Rebecca Green','Lisa & Kevin Green','900 Farlon Rd.','Los Angeles','CA','90034','310-893-0993','keving@greenery.com'),

 (3,3,'Jonah Ross','Robert & Natalie Ross','1293 Law Street','Los Angeles','CA','90035','310-480-9495','ross_boss@gmail.com'),

 (4,4,'Samuel P. Logan','Steven Logan','400 Green Lake Road, 9th Floor','Eastbrook Village','CA','90036','310-400-5595','misterSAL@sbcglobal.net'),

 (5,6,'Audrey Christiansen','Lainie Christiansen','5760 Justin Road','Eastbrook Canyon','CA','90036','310-400-9642','lac_23@aol.com'),

 (6,5,'Jack Straw','Mr. & Mrs. J.G. Straw','11 Tennessee Lane','Los Angeles','CA','90035','310-899-4321','jgstraw@proxicom.net');

DROP TABLE IF EXISTS `users`;

CREATE TABLE `user` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `username` varchar(64) NOT NULL,

  `password` varchar(64) NOT NULL,

  `is_admin` tinyint(1) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`),

  UNIQUE KEY `username` (`username`)

) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO `users` (`id`,`username`,`password`,`is_admin`) VALUES

 (1,'teacher','098f6bcd4621d373cade4e832627b4f6',1),

 (2,'parent1','098f6bcd4621d373cade4e832627b4f6',0),

 (3,'parent2','098f6bcd4621d373cade4e832627b4f6',0),

 (4,'parent3','098f6bcd4621d373cade4e832627b4f6',0),

 (5,'parent4','098f6bcd4621d373cade4e832627b4f6',0),

 (6,'parent5','098f6bcd4621d373cade4e832627b4f6',0);

DROP TABLE IF EXISTS `user_class_activity`;

CREATE TABLE `user_class_activity` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `class_activity_id` int(11) NOT NULL,

  `user_id` int(11) NOT NULL,

  `participation_type_id` int(11) NOT NULL DEFAULT '1',

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;

INSERT INTO `user_class_activity` (`id`,`class_activity_id`,`user_id`,`participation_type_id`) VALUES

 (29,48,4,4),

 (30,13,2,2),

 (31,14,2,3),

 (32,12,2,3),

 (33,48,2,5),

 (34,13,3,4),

 (35,4,3,4),

 (36,14,3,3),

 (37,8,3,2),

 (38,32,3,2),

 (39,37,4,5),

 (40,12,4,5),

 (41,40,5,5),

 (42,18,5,5),

 (43,14,5,2),

 (44,12,5,2),

 (45,8,5,2),

 (46,13,6,5),

 (47,18,6,2),

 (48,14,6,2),

 (49,37,6,4),

 (50,8,6,5);