-- MySQL dump 10.11 -- -- Host: localhost Database: hardcitizen_production -- ------------------------------------------------------ -- Server version 5.0.45 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `coconspirators` -- DROP TABLE IF EXISTS `coconspirators`; CREATE TABLE `coconspirators` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `bio` text, `coconspirator_photo_file_name` varchar(255) default NULL, `coconspirator_photo_content_type` varchar(255) default NULL, `coconspirator_photo_file_size` varchar(255) default NULL, `created_at` datetime default NULL, `updated_at` datetime default NULL, `home_rank` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; -- -- Dumping data for table `coconspirators` -- LOCK TABLES `coconspirators` WRITE; /*!40000 ALTER TABLE `coconspirators` DISABLE KEYS */; INSERT INTO `coconspirators` VALUES (1,'Secret Location','Secret Location is an award winning digital production and creation company. We work with brands, agencies, producers, and broadcasters to empower ideas, stories and technology to deliver amazing experiences and awesome results.

\r\n\r\n

With our integrated model we engage every project uniquely, starting with research, strategy, collaboration, creative production and distribution.

\r\n\r\n

Some of the techniques we work with include: Games and Rich Media Websites, Original Content, Social Networking and bookmarking, Interactive Filmmaking, Viral marketing, and Interactive Installations.\r\n

\r\n\r\n

thesecretlocation.com

','secret.jpg','image/jpeg','46827','2009-06-08 20:25:11','2010-10-18 17:55:16',1),(3,'Everynone','Everynone is a New York based team. They are Will Hoffman, Daniel Mercadante, and Julius Metoyer.

\r\nTypically, Everynone works with non-actors to capture life as it is. Their work is evidence that the things we see everyday, when carefully framed, can be curiously beautiful.

\r\neverynone.com','everynone2.jpg','image/jpeg','67860','2010-10-14 16:25:52','2010-10-14 17:11:27',2),(4,'Ben Shirinian','Ben was born and raised in Montreal, and is a Film Studies graduate from Queen\'s University.

\r\nBen\'s passion for visual storytelling started at an early age. He was always encouraged to let his imagination play with the endless possibilities found in art and design. Over time, Ben was able to translate his love for storytelling into a career as a director of both traditional and non-traditional media.

\r\nBen\'s wide-ranging experience in digital content, broadcast commercials, film and new media projects, has helped him to create an inspired body of work. From his internationally recognized cinema commercial, The Wait, for the launch of Sony PlayStation 3 to his international new media ballet installation, Impermanence, which premiered in Florence, Italy, featuring world renowned ballet dancer, Guillaume Côté. Ben\'s diverse portfolio also includes work with global brands: AXE, Dreamworks, Pepsi, and Virgin.

\r\nAt the heart of Ben\'s work lies a dedication to using the most innovative visual techniques to communicate ideas in a memorable way. Ben\'s highly evolved design sensibility combined with his expertise in VFX and post-production also allow him to experiment with unique visual methods to complement his work.

\r\nBen\'s new short film, Josef et Aimée, (a hybrid of live action, miniature sets, and CG animation) and international new media exhibit will debut mid-2011.','BEN-SHIRINIAN---DIRECTOR--P.jpg','image/jpeg','68820','2010-10-15 13:00:05','2010-10-15 13:15:35',3),(5,'Adrian Carter','Adrian was a founding partner of Smiley Guy Studios, an animation studio started in 1997 to produce the animated television series Odd Job Jack (The Comedy Network, Adult Swim Latin America, Paramount Comedy) starring Canadian film darling Don McKellar. As a creator, director and producer of Odd Job Jack, Adrian was nominated twice for Best Comedy Series at the Gemini Awards and twice for \"Pretty Funny Direction\" at the Canadian Comedy Awards, as well as winning a Gemini, a Banff Television Festival Award and a CFTPA Indie Award for Odd Job Jack\'s interactive achievements. Odd Job Jack aired for 5 seasons, of which Adrian directed 27 episodes and produced all 52.

\r\nAdrian is a strong proponent of digital filmmaking, and when the RED camera first came on the market in late 1997, Adrian wrote and directed a short film, Sir Francis Drake, The Queen\'s Pirate, that would take advantage of the RED technology. Sir Francis Drake was screened at many film festivals around the world, and won a Special Jury Award at Canada\'s The Nickel Independent Film Festival in St. John\'s Newfoundland.

\r\nIn 2008, Adrian started a new production company called Shark Teeth Films, with a mandate of using digital techniques to create the next generation in entertainment for film, television and the Internet. He has since been developing several series for television, and directing commercials and music videos.

\r\nIn his spare time, Adrian likes to take pictures and talk about himself in the third person.

\r\nsharkteethfilms.com\r\n','AdrianWeb.jpg','image/jpeg','188308','2010-10-18 13:51:23','2010-10-18 17:54:50',4),(8,'TJ Derry','With the opportunity to volunteer on a David Cronenberg film festival piece at age 15, Tj was given his first exposure to the world of filmmaking. He spent the summer of 2000 working with various commercial grip crews as an equipment gofer. Deciding immediately thereafter to pursue a career within the industry, he was hired to intern at Avion Films as the in-house assistant. He then worked as a camera assistant for a few veteran focus pullers. During his time as a camera assistant, he spent countless days working under legendary Cinematographer Dean Cundey (Jurassic Park, Apollo 13, Back to the Future II) watching his technique and style and modeling himself after the Hollywood juggernaut.

\r\nAt age 20 Tj took a hiatus from the film industry and moved to Whistler, British Columbia, to cultivate his budding snowboard career; a side passion that had been left alone for many years. Picking up some solid sponsorship with Zoo York, Technine, Spy and Hustler, to name a few, he turned professional in 2004. During his snowboard career, Tj spent his summers working on film sets.

\r\nOfficially laying down his snowboard for good and returning to the film scene full time in 2006, Tj began quietly chasing work as music video Director/Cameraman. He’s since worked with Kia and Hyundai Canada and with artists such as Alicia Keys, Queen Latifa, Billy Talent and Metric.\r\n','TomWeb.jpg','image/jpeg','79098','2010-10-19 19:15:04','2010-10-19 19:15:04',5); /*!40000 ALTER TABLE `coconspirators` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `photos` -- DROP TABLE IF EXISTS `photos`; CREATE TABLE `photos` ( `id` int(11) NOT NULL auto_increment, `photo_file_name` varchar(255) default NULL, `photo_content_type` varchar(255) default NULL, `photo_file_size` varchar(255) default NULL, `coconspirator_id` int(11) default NULL, `project_id` int(11) default NULL, `created_at` datetime default NULL, `updated_at` datetime default NULL, `currently_viewing` varchar(255) default NULL, `lightbox_file_name` varchar(255) default NULL, `lightbox_content_type` varchar(255) default NULL, `lightbox_file_size` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8; -- -- Dumping data for table `photos` -- LOCK TABLES `photos` WRITE; /*!40000 ALTER TABLE `photos` DISABLE KEYS */; INSERT INTO `photos` VALUES (22,'boards_bathNEW.bmp','application/octet-stream','95291',NULL,4,'2009-07-06 16:17:42','2009-07-30 20:40:24','Rough sketch',NULL,NULL,NULL),(23,'DSC_0794t.jpg','image/jpeg','135155',NULL,9,'2009-07-27 19:03:56','2009-07-30 20:32:48','Crest Pigs Installation','sDSC_0794.jpg','image/jpeg','241200'),(24,'DSC_0825t.jpg','image/jpeg','139106',NULL,9,'2009-07-27 19:07:16','2009-07-30 20:28:23','Crest Pigs Installation','sDSC_0825.jpg','image/jpeg','281746'),(25,'DSC_0883t.jpg','image/jpeg','113896',NULL,9,'2009-07-27 19:09:32','2009-07-30 20:33:04','Crest Pigs Installation','sDSC_0883.jpg','image/jpeg','230762'),(26,'crest.jpg','image/jpeg','146493',NULL,9,'2009-07-27 19:10:17','2009-07-30 20:29:06','Crest Pigs Installation','sDSC_0856.jpg','image/jpeg','275783'),(27,'boards_cover.jpg','image/jpeg','131075',NULL,15,'2009-08-06 14:43:25','2009-08-06 14:43:25','Original photography','boards_cover_sized_desat.jpg','image/jpeg','235489'); /*!40000 ALTER TABLE `photos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `projects` -- DROP TABLE IF EXISTS `projects`; CREATE TABLE `projects` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) default NULL, `brief` text, `production` text, `result` text, `project_pdf_file_name` varchar(255) default NULL, `project_pdf_content_type` varchar(255) default NULL, `project_pdf_file_size` varchar(255) default NULL, `project_photo_file_name` varchar(255) default NULL, `project_photo_content_type` varchar(255) default NULL, `project_photo_file_size` varchar(255) default NULL, `created_at` datetime default NULL, `updated_at` datetime default NULL, `home_rank` int(11) default NULL, `services` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; -- -- Dumping data for table `projects` -- LOCK TABLES `projects` WRITE; /*!40000 ALTER TABLE `projects` DISABLE KEYS */; INSERT INTO `projects` VALUES (2,'Saatchi & Saatchi Canada','Saatchi.ca needed a new design and an intro animated video to show the agency\'s unique approach and vision.','Christopher Hutsul directed a short intro animated film for the site called \"Purpose.\" He illustrated the elements for the film and also the website by hand painting. Digital production by Saatchi & Saatchi Canada.','The site was launched in July 2009. It was featured in Shots \"hutsul\'s new purpose\", Boards \"Christopher Hutsul finds his purpose\" and won an Applied Arts Magazine Interactive Award in May 2010.',NULL,NULL,NULL,'purpose.jpg','image/jpeg','137165','2009-06-16 18:50:01','2010-10-12 17:52:57',8,'\"Purpose\"

\r\n

\r\n- Illustration + Director of Animation\r\n'),(3,'War Child 2008','Common perception is that Canada is a giving nation. But truth is, we are one of the least philanthropic countries in the world. Our blatant apathy makes it difficult for organizations like War Child to attract new members to support their cause. In this campaign we wanted to prove that we’re supporting the problem if we’re doing nothing to stop it. ','A TV spot and YouTube video directed by Henry Lu were released, showing people pitching in to help child soldiers fight. Posters and stencils touting bizarre messages like “It’s never too early for war” went up around the city. People were led to helpchildsoldiers.com where they learned the true campaign message, and could get involved by printing their own posters, downloading wallpapers and signing a petition. Digital production by Principle Inc.','The video became the top featured and most discussed on YouTube, and gained over 100,000 hits within the first two weeks. Since the launch, War Child has seen over seven hundred new memberships, an 80% increase in new volunteers and a 38% increase in donations in 2009.',NULL,NULL,NULL,'war-1.jpg','image/jpeg','91592','2009-06-16 18:53:12','2010-10-12 17:52:57',16,' \"Do Nothing\"

\r\n

\r\n- Production + direction of viral video PSA'),(5,'Fashion Cares','MacLaren McCann needed a spot and a website for the 2007 Fashion Cares \"Peep\" event.','Drew Lightfoot directed the spot and web elements were photographed and taken for the website. Digital production by MacLaren McCann.','The spot aired on TV and tied in with the website. You can still see the Fashion Cares 2007 website.',NULL,NULL,NULL,'fashion.jpg','image/jpeg','69886','2009-06-16 18:54:02','2010-10-12 17:52:57',14,'\"Peep\"

\r\n

\r\n- Art directed elements from broadcast spot used for web'),(6,'IKEA','In addition to a TV spot for IKEA, Zig needed elements for expandable rich media banners for their integrated kitchen campaign.','Jun Diaz directed the broadcast spot and also the performances on green screen for web banners. Digital production by Zig Ideas.','Kitchen TV spots and banners launched at the same time to create a seamless integrated campaign for IKEA. The TV spot won gold at the Marketing Awards.',NULL,NULL,NULL,'ikeajob-1.jpg','image/jpeg','79068','2009-06-16 18:54:21','2010-10-12 17:52:57',11,'\"Dubbed\"

\r\n

\r\n- Integrated broadcast + interactive banners'),(7,'VIFF','Secret Location worked with TBWA Vancouver and director of the Vancouver International Film Festival 2009 trailers, Christopher Hutsul, to design an interactive game to tie-in.','Secret Location generated the game idea, directed the shoot, recorded a soundtrack and animated special moves within the game. Before and during the festival, we distributed thousands of wild postings offline.','Our strategy drove thousands of people to the film festival, enabling its most successful year ever. The site was awarded in the 2009 Applied Arts Annual.',NULL,NULL,NULL,'viff.jpg','image/jpeg','107196','2009-07-02 16:31:07','2010-10-12 17:52:57',9,'\"ElbowWars\"

\r\n

\r\n- Interactive game design, photo shoot, soundtrack, seeding'),(8,'LIVERight Gala','Create assets for the LIVERight microsite for BBDO.','Christopher Hutsul designed and illustrated the characters that appear on the LIVERight microsite. Digital production by Hooplah.','The site has little animated guys on it that are very cute. LIVERight had a successful event, see the website at: liverightgala.ca',NULL,NULL,NULL,'liver.jpg','image/jpeg','73176','2009-07-07 19:01:16','2010-10-12 17:52:57',15,'Gala Site

\r\n

\r\n- Asset illustration'),(9,'Crest','Saatchi & Saatchi, New York showed the importance of flossing with \"pork\" between \"teeth\" on a busy Toronto street.','We provided the production, location scouting, installation, and building of the the pig!','Incredible reaction with lots of organic online buzz.',NULL,NULL,NULL,'crest.jpg','image/jpeg','132270','2009-07-07 19:10:04','2010-10-12 17:52:57',13,'\"Pigs\"

\r\n

\r\n- Ambient installation'),(10,'War Child 2007','In the summer of 2007, War Child Canada launched a campaign with john st. intended to draw attention to the plight of 250,000 children around the world forced to fight as child soldiers.

\r\n\r\nTo do this, we helped john st. create a fictitious local summer camp, called Camp Okutta, where young Canadian kids could go to learn to fire real AK-47s, throw grenades and walk through minefields. It was presented like a real Canadian wilderness camp, with fresh-faced counselors talking about how great the camp was.','It was promoted through handmade posters and brochures handed out by \"counselors\" in Canadian cities and a promotional video on YouTube directed by Henry Lu, that directed viewers to a site where they could tour Camp Okutta for themselves. Only when they clicked on the \"where is Camp Okutta?\" button did they realize that while Okutta was fiction, camps like it around the world are not. Digital production by Indus Blue.','War Child Canada received astounding results from the 2007 promotional campaign called, “Camp Okutta”. When the campaign launched, the charity saw the hits to its website increase close to 400% and their online donations more than double from the previous year. The Camp Okutta campaign brought the attention needed to War Child Canada and brought the world-wide issue of the use of children in combat warfare to the forefront, not only nationally, but world-wide.',NULL,NULL,NULL,'camp2.jpg','image/jpeg','128097','2009-07-07 19:12:01','2010-10-12 17:52:57',17,'\"Camp Okutta\"

\r\n

\r\n- Production + direction of viral video PSA'),(11,'NY Times','New York Times asked us to shoot a documentary film for their online magazine portion that was a compliment to the feature article on artist Cai Guo-Qiang to promote the opening of his show at MOMA.','Yael Staav filmed artist Cai Guo-Qiang. \r\nWe shot it all live in a huge warehouse in Brooklyn, NY. We shot for two days with only three people including the director and Ken Seng, the DOP.\r\n','Beautiful video about the famous internationally acclaimed artist drove people to the New York Times website and feature article.',NULL,NULL,NULL,'nyt.jpg','image/jpeg','70433','2009-07-07 19:16:31','2010-10-12 17:52:57',10,'\"The Pyrotechnic Imagination\"

\r\n

\r\n- Online short film'),(15,'Boards Magazine','Boards magazine needed a cover for their high-profile annual Top Directors issue for 2009.','Director Drew Lightfoot concepted and shot a gorgeous cover for the issue. He also wrote about the behind the scenes process in his cover design diary featured in the same issue.','Check out his cover and the Top Directors issue in the May 2009 issue of Boards.',NULL,NULL,NULL,'boardsblaster.jpg','image/jpeg','76603','2009-08-06 14:23:54','2010-10-12 17:52:57',12,' Top Director Cover Shoot

\r\n

\r\n- Photography + art direction'),(16,'Bullfrog Power','john st. wanted a fresh approach to their Bullfrog Power ‘Pay More’ Facebook campaign animated video that was informational, but also fun and interesting.

\r\n\r\nThey also wanted some web videos, each featuring a Bullfrog Power customer voicing their reason for using Bullfrog.','Working as FiveMileOrange, Drew Lightfoot and Martin Waltz directed and animated the supercool informational video. The video visually explains Bullfrog Power model.

\r\n\r\nDrew Lightfoot also directed the three short web spots featuring real Bullfrog customers.

\r\n\r\nDigital production of the Facebook page by john st.','The Facebook page was re-skinned and updated with the new content. As a result, the page attracted thousands of new fans and awareness and comprehension of Bullfrog Power is at an all-time high.

\r\n\r\nLogin to Facebook to see the Bullfrog Power Page and \"Pay More\" campaign and watch Five Mile Orange\'s animation.',NULL,NULL,NULL,'bullfrog.jpg','image/jpeg','110966','2010-03-26 16:26:08','2010-10-12 17:52:57',5,'“How It Works”

\r\n

\r\n- Animation, direction + video production'),(17,'Nissan Canada','The Canadian car industry’s new guidelines dictate that a car in a commercial has to obey rules of the road. To this end, what if the car was not a real car at all, but a mini RC replica? Could it then be shown drifting, making severely sharp turns and going really fast?','Terri Timely, loving all things miniature and metal, came to the table to direct the viral, as well as a ‘Making of’ documentary for the Nissan Sentra SE-R. YouTube skin developed by TBWA Toronto.','In the first week on the Nissan Sentra SE-R’s YouTube channel, the viral had nearly 200,000 hits, while the documentary had over 50,000. As well, “Drift” was Creativity’s Pick of the Day and slid into the #2 spot on AdCritic’s Top 20.

\r\n

\r\nAfter one month, the spot received over 650,000 views, 363 blog postings and saw a 900% rise in traffic, plus a 60% rise in SE-R sales over the previous year.',NULL,NULL,NULL,'nissan.jpg','image/jpeg','95824','2010-04-09 16:54:17','2010-10-12 18:32:08',2,' Sentra SE-R;

\r\n“Drift\" & \"The Making Of”

\r\n

\r\n- Viral + documentary direction'),(18,'Degrassi','Teen Nick wanted to make a promo for their popular Degrassi series for this year\'s season 10. This season is special, so the promo had to be something more exciting and impressive than anything in the past.','We brought on acclaimed music video director RT! to help Teen Nick create a carnival universe that has Degrassi characters playing archetypal roles associated with the circus and giving small clues to season 10\'s story lines.','The final promo video looks stunning and the fans love it.',NULL,NULL,NULL,'degrassi.jpg','image/jpeg','122209','2010-05-27 19:19:26','2010-10-12 17:52:57',6,'\"High School Is A Circus\"

\r\n

\r\n- Promotional video production'),(19,'ALS Society of Canada','Lowe Roche came to us with a poignant idea for some interactive banners for the ALS Society of Canada. Scheduled to be launched for ALS Awareness month in June, the banners were designed to urge users, with their computer mouse, to help someone with ALS perform a small physical task, so they might feel the importance of helping ALS victims in a real way through donations or volunteer work.','Secret Location worked with Lowe Roche to find the best way to bring the idea to life within the constraints and opportunities of technology. Care was taken to ensure the interactivity and tone was appropriate for the message. After the banners were near completion, the client was so pleased that they asked us to build a microsite to incorporate them.','Results of the fundraising for ALS Awareness Month as a result of the banners have yet to come in. However, the work speaks for itself. It looks and feels very effective, and communicates an important message about this debilitating disease.',NULL,NULL,NULL,'als.jpg','image/jpeg','76893','2010-06-04 20:36:32','2010-10-12 17:52:57',4,'\"Help Someone With ALS\"

\r\n

\r\n- Banner design + development, shoot, microsite design + development'),(20,'VISA GoBiz','TBWA\\Toronto and Hard Citizen teamed up to create two This American Life-inspired documentaries about two Canadian self-made entrepreneurs. The documentaries were part of a larger campaign for VISA GoBiz Small Business.','Hasnain Dattu directed both short web documentaries. The videos can be found on the VISA GO BIZ site and were also used in Rich Media banners. Digital production of the banners and the VISA site by TBWA\\Toronto.\r\n','Both Matthew and JRZ garnered a lot of press through their VISA GoBiz exposure. Results on the campaign itself are still pending, as the campaign is ongoing into September 2010.',NULL,NULL,NULL,'JRZ.jpg','image/jpeg','112342','2010-08-10 21:00:21','2010-10-12 17:52:57',7,'Small Business Campaign;

\r\n“Freshii” + “JRZ”

\r\n

\r\n- Direction + video production'),(21,'Kia Canada','David&Goliath came to us with a need to further their “Drive Change” campaign with documentaries, banners and site-updates. The campaign itself highlights the cars as vehicles to drive change within the community. With our Soft Citizen director, Drew Lightfoot, D&G shot two inspiring spots showcasing the transformation of lots in disuse which became a community basketball court and community garden.','To support the TV, Hard Citizen, along with Director, Tom Derry shot two making of documentaries for the stories behind, “Court” and “Garden”. We also worked with Secret Location to produce standard and rich media banners, as well as a site re-skin to support the push to the Kia site, the Drive Change YouTube channel, a new Facebook and Twitter presence. YouTube, Facebook and Twitter skins developed and populated by Cloud Advertising Agents.','The campaign launched with the Drive Change brand video in July 2010, following soon after were the transformation spots, the documentaries, the banners and the site re-skin. The campaign is still in-market and can be followed on Kia\'s site, YouTube, FaceBook, and Twitter.',NULL,NULL,NULL,'drive_change.jpg','image/jpeg','117933','2010-08-17 14:56:32','2010-10-12 17:52:57',3,'Drive Change;

\r\nThe Making Of \"Court\" + \"Garden\"

\r\n

\r\n- Direction + production of Making of documentaries, development of rich media + standard banners + site re-skin'),(22,'Cadbury Canada','As support to The Hive\'s 360 campaign idea surrounding \'The Quest for the Golden Key\', Secret Location was commissioned to produce an ambient installation that enticed bystanders in Toronto and Montreal with brief animated sequences that were triggered to protect the Caramilk secret.\r\n\r\n','Secret Location produced and animated all of the assets for the installation sequences, as well as consulted with projection and motion sensor-support, Media Merchants to produce a rich motion-sensor activated installation.','The installation ran for eight weeks during the summer of 2010 through July and August to support the online, print, out-of-home and television creative elements that were also in the marketplace at the time.',NULL,NULL,NULL,'Caramilk.jpg','image/jpeg','107878','2010-10-12 17:52:51','2010-10-12 18:32:49',1,'Caramilk;

\r\n“Unlock the Caramilk Secret”

\r\n

\r\n- Live action asset production, motion graphics animation, store-front rear projection installation'); /*!40000 ALTER TABLE `projects` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `schema_migrations` -- DROP TABLE IF EXISTS `schema_migrations`; CREATE TABLE `schema_migrations` ( `version` varchar(255) NOT NULL, UNIQUE KEY `unique_schema_migrations` (`version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `schema_migrations` -- LOCK TABLES `schema_migrations` WRITE; /*!40000 ALTER TABLE `schema_migrations` DISABLE KEYS */; INSERT INTO `schema_migrations` VALUES ('20090601201548'),('20090608134518'),('20090608134650'),('20090608134656'),('20090608134659'),('20090608134705'),('20090616175803'),('20090708185420'),('20090721150516'),('20090722191639'),('20090728144230'),('20090730193635'); /*!40000 ALTER TABLE `schema_migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `scoops` -- DROP TABLE IF EXISTS `scoops`; CREATE TABLE `scoops` ( `id` int(11) NOT NULL auto_increment, `headline` varchar(255) default NULL, `category` varchar(255) default NULL, `article` text, `scoop_pdf_file_name` varchar(255) default NULL, `scoop_pdf_content_type` varchar(255) default NULL, `scoop_pdf_file_size` varchar(255) default NULL, `scoop_photo_file_name` varchar(255) default NULL, `scoop_photo_content_type` varchar(255) default NULL, `scoop_photo_file_size` varchar(255) default NULL, `created_at` datetime default NULL, `updated_at` datetime default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8; -- -- Dumping data for table `scoops` -- LOCK TABLES `scoops` WRITE; /*!40000 ALTER TABLE `scoops` DISABLE KEYS */; INSERT INTO `scoops` VALUES (2,'shots: hutsul\'s new purpose','Press','Chris Hutsul\'s latest project sees the design savvy Soft Citizen director re-skin the Saatchi.ca website with a heart-warming animated tale of finding your own story. Shots.net caught up with the multi-skilled Hutsul from his Toronto studio to rummage through his sketchbooks and find out how he gave Saatchis a new purpose.

\r\n\r\nGo to the shots article \"hutsul\'s new purpose\" to read more.','shots-hutsulsnewpurpose.pdf','application/pdf','336275','hutsul.jpg','image/jpeg','100888','2009-07-07 19:21:23','2009-08-05 17:54:08'),(3,'Boards: Christopher Hutsul finds his purpose','Press','Christopher Hutsul brings the animated village \"Purpose\" to life in Saatchi & Saatchi Canada\'s relaunched website by directing, illustrating and developing the characters.\r\n

\r\nGo to the Boards article \"Christopher Hutsul finds his purpose\" to read more.','Boards-ChristopherHutsulfindshispurpose.pdf','application/pdf','926360','purpose.jpg','image/jpeg','144812','2009-08-05 16:17:38','2009-08-05 18:04:39'),(5,'Boards: Covered: May 2009','Press','Drew Lightfoot explains the process behind creating the May Boards cover in his Design Diary

\r\n\r\nRead more about Drew\'s process in May\'s issue of Boards Covered: May 2009\"','Boards-DrewL.pdf','application/pdf','1747926','drewlightfootcover.jpg','image/jpeg','78867','2009-08-05 18:26:44','2009-08-06 18:12:20'),(7,'Soft launch of hardcitizen.com','News','As you can see, the Hard Citizen site is up! Welcome!',NULL,NULL,NULL,'hard.jpg','image/jpeg','27828','2009-08-10 18:34:32','2009-08-10 18:34:32'),(8,'Secret Location + Strategy AOY','News','Tonight Secret Location is a Gold Sponsor for Strategy\'s Agency of The Year 2009 awards ceremony.

\r\n\r\nThis has been fully realised in what they\'ve magically created for the magazine\'s AOY issue reveal -- it won\'t be your average Strategy AOY cover. Wait for it ...',NULL,NULL,NULL,'agency.png','image/png','12652','2009-10-29 16:33:06','2009-10-30 19:43:07'),(9,'Secret Location Augments Strategy\'s AOY Winners.','News','Secret Location\'s interactive cover design for Strategy\'s AOY was launched at the awards ceremony last night to a very receptive crowd.

\r\n\r\nWith a copy of the magazine in tow you can go here to start the experience.

\r\n\r\nIf you don\'t have a copy of the magazine, download the printable icon when you get to the site!','StrategyMag_AOTY_PrintableCover.pdf','application/pdf','135848','AOY.png','image/png','27148','2009-10-30 14:42:23','2009-10-30 19:40:02'),(10,'ADCC Awards & Hard Citizen','Awards','ADCC is one of our favourite award shows. Even though we\'re still only brand new, Hard is super honoured to be included in a couple of the winners at the show last week, including:\r\n\r\n

Gold TV Public Service: Single and Silver Advertising Multi-Media for War Child Canada \"Help Child Soldiers\" by john st. and director Henry Lu

\r\n\r\n

Silver Interactive Games for VIFF \"Elbow Wars\" by TBWA/Vancouver and Secret Location

\r\n',NULL,NULL,NULL,'adcchard.jpg','image/jpeg','22352','2009-11-16 17:23:49','2009-11-16 17:41:57'),(11,'Bullfrog Power + Drew Lightfoot.','Press','Bullfrog Power and john st. launched the \"Pay More For Energy\" campaign on their Facebook Fan Page this month and they\'re nearly three thousand fans deep!

\r\n\r\nDrew Lightfoot\'s animation in support of the campaign is pretty awesome and can be found here.

\r\n',NULL,NULL,NULL,'bull.jpg','image/jpeg','20157','2010-04-06 20:10:39','2010-04-06 20:13:44'),(12,'Terri Timely is #2 on AdCritic, but #1 in our books!','Press','Finally Terri Timely\'s \"Drift\" viral and \"Making of\" doc is ready to be seen!\r\n
\r\n
The guys worked with Nissan and TBWA Toronto to produce the spots for the Sentra SE-R and they\'re getting a lot of love by grabbing Creativity\'s Pick of the Day and placing #2 on AdCritic\'s Top 20.\r\n\r\n

Watch the viral and the making of on the Nissan Sentra SE-R\'s skinned YouTube channel.',NULL,NULL,NULL,'nissanh.jpg','image/jpeg','22692','2010-04-07 20:49:27','2010-04-07 20:52:30'),(13,'Secret Location at FITC','News','James Milward from Secret Location is speaking at Flash in the Can this year on the aptly titled \"Everything You Know is New Again\" panel. \r\n

Panelists will break out tales of the challenges & success strategies in designing groundbreaking interactive stories that stand alone or extend transmedia content across platforms.\r\n\r\n

This year\'s Flash in the Can is called Storytelling X.0 and takes place April 27th in Toronto. ',NULL,NULL,NULL,'fitc.jpg','image/jpeg','19093','2010-04-19 19:37:25','2010-10-22 13:29:26'),(14,'Secret Location advises at Shift Disturbers','News','James Milward of Secret Location fame is on the advisory panel at this year\'s Shift Disturbers in Toronto May 25th.\r\n

\r\nShift Disturbers brings a mash-up of visionaries from the worlds of advertising, art and design for a half-day of inspiration from the gods of creativity.\r\n

\r\nWhoa, that\'s huge.',NULL,NULL,NULL,'shift.jpg','image/jpeg','59099','2010-05-12 19:24:13','2010-10-22 13:29:35'),(15,'\"Help Someone with ALS\" banners','News','Secret Location and Lowe Roche made these moving banners and a microsite to house them for the ALS Society of Canada. Launched June 1st for ALS Awareness Month.

\r\n\r\nVisit helpsomeonewithALS.ca.',NULL,NULL,NULL,'alsads.jpg','image/jpeg','59518','2010-06-04 21:00:48','2010-10-22 13:29:47'),(16,'Saatchi.ca wins Applied Arts Magazine Interactive Award','Awards','We won in the Business-to-Business category. Congrats to Saatchi Canada and Christopher Hutsul!\r\n

\r\nSee it on the Applied Arts website.',NULL,NULL,NULL,'awards.jpg','image/jpeg','41579','2010-07-06 19:56:46','2010-07-06 19:58:16'),(17,'The Guy At Home In His Underwear!','News','On October 6th, Stanfield\'s underwear and The Canadian Cancer Society will launch a journey where one guy hangs in his man-panties for 25 days! LIKE him on Facebook and follow his progress on the site. Each like he receives, Stanfield\'s will donate $1 in support of Testicular Cancer Awareness.

\r\n\r\nStay tuned!',NULL,NULL,NULL,'Screen_shot_2010-09-23_at_2.54.41_PM.jpg','image/jpeg','62589','2010-09-23 18:11:27','2010-09-23 18:29:58'),(18,'Guy at Home in His Underwear on Creativity','Press','Secrect Location/Hard Citizen and john st. launched \'Stanfield\'s: Guy at Home in His Underwear\' yesterday and our Guy is already garnering the attention of the likes of Creativity and is lucky Nº 7 on AdCritic\'s Top20.

\r\n\'Like\' Mark today to contribute $1 toward his fundamental goal of $25,ooo for The Canadian Cancer Society and Testicular Cancer awareness ... he already has 7,862 \'Like\'s!','Guy_at_Home_in_His_Underwear_-_Interactive_image_-_Creativity_Online.pdf','application/pdf','555633','Screen_shot_2010-10-07_at_1.20.13_PM.jpg','image/jpeg','59410','2010-10-07 16:34:37','2010-10-07 16:37:35'),(19,'Everynone\'s \"Words\" - YouTube Play Official Jury Selection','News','25 YT videos were honoured at the Guggenheim last night selected from a pool of 23,000 by a pretty esteemed jury. Among the 25 was Everynone\'s, \"Words\".

\r\n\r\nEveryone\'s asking if YouTube\'s Play Biennial is a sign of things to come -- I think there\'s an obvious answer for that little question.

\r\n\r\nWatch their profile and their winning film.',NULL,NULL,NULL,'YT.jpg','image/jpeg','61484','2010-10-22 13:38:44','2010-10-22 14:07:26'); /*!40000 ALTER TABLE `scoops` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `urls` -- DROP TABLE IF EXISTS `urls`; CREATE TABLE `urls` ( `id` int(11) NOT NULL auto_increment, `url` varchar(255) default NULL, `screenshot_file_name` varchar(255) default NULL, `screenshot_content_type` varchar(255) default NULL, `screenshot_file_size` varchar(255) default NULL, `coconspirator_id` int(11) default NULL, `project_id` int(11) default NULL, `created_at` datetime default NULL, `updated_at` datetime default NULL, `currently_viewing` varchar(255) default NULL, `clicktext` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8; -- -- Dumping data for table `urls` -- LOCK TABLES `urls` WRITE; /*!40000 ALTER TABLE `urls` DISABLE KEYS */; INSERT INTO `urls` VALUES (2,'http://www.helpchildsoldiers.com/','Picture_16.png','image/png','674890',NULL,3,'2009-07-06 15:29:14','2009-08-06 18:23:43','HelpChildSoldiers.com','Visit Help Child Soldiers'),(3,'http://www.youtube.com/watch?v=E7uW5m_tAGk','Picture_6.png','image/png','655359',NULL,3,'2009-07-06 15:35:45','2009-08-06 18:59:01','\"Do Nothing\" on YouTube','Watch \"Do Nothing\" on YouTube'),(5,'http://www.saatchi.ca','Picture_4.png','image/png','1269367',NULL,2,'2009-07-06 15:40:28','2010-10-22 12:57:33','Saatchi & Saatchi Canada website','Visit Saatchi Canada'),(6,'http://www.elbowwars.com/','Picture_17.png','image/png','616692',NULL,7,'2009-07-06 15:41:36','2009-09-11 14:37:47','ElbowWars game','Play ElbowWars'),(7,'http://www.boardsmag.com/articles/online/20090505/drewlightfootcover.html','drewlightfootcover.body_lead.wide.jpg','image/jpeg','25883',NULL,4,'2009-07-06 16:12:39','2009-07-29 19:15:52','Behind the scenes of the covershoot with Drew Lightfoot','Go behind the Scenes at boardsmag.com'),(8,'http://www.boardsmag.com/articles/online/20090505/topdirectors.html','topdirectors.body_lead.jpg','image/jpeg','35295',NULL,4,'2009-07-06 16:16:54','2009-07-29 19:16:14','Boards Magazine Top Directors Edition','Go to Boards Magazine Top Directors Edition'),(9,'http://www.fashioncares.com/2007index.html','Picture_25.png','image/png','733263',NULL,5,'2009-07-06 16:45:08','2009-08-10 14:50:18','Fashion Cares 2007 website','Visit Fashion Cares \"Peep\"'),(10,'http://www.secretlocation.com','Picture_27.png','image/png','69940',2,NULL,'2009-07-06 17:28:27','2009-07-06 17:28:27',NULL,NULL),(12,'http://www.liverightgala.ca/','liverweb.jpg','image/jpeg','87644',NULL,8,'2009-07-16 18:06:47','2009-08-10 14:51:54','LIVERight Gala microsite','Visit LIVERight Gala'),(13,'http://www.youtube.com/watch?v=iYhCn0jf46U','dove-evolution-billboard.jpg','image/jpeg','86821',NULL,13,'2009-07-20 18:44:48','2009-07-20 18:44:48','Dove \"Evolution\" on YouTube',NULL),(14,'http://campokutta.ca/','campweb.jpg','image/jpeg','168185',NULL,10,'2009-07-20 19:26:36','2009-08-06 19:00:22','Camp Okutta website','Visit Camp Okutta'),(15,'http://ourideas.org/creatives/IKEA/fy09/kitchen/husband/300x250/','grump.jpg','image/jpeg','92311',NULL,6,'2009-07-22 17:21:17','2009-08-10 14:50:50','Grumpy Husband banner','View Husband banner'),(16,'http://ourideas.org/creatives/IKEA/fy09/kitchen/mother/728x90/','over.jpg','image/jpeg','90901',NULL,6,'2009-07-22 17:23:14','2009-08-06 18:26:37','Overbearing Mother-in-Law banner','View Mother-in-Law banner'),(17,'http://ourideas.org/creatives/IKEA/fy09/kitchen/son/728x90/','moody.jpg','image/jpeg','93449',NULL,6,'2009-07-22 17:25:05','2009-08-06 18:26:55','Moody Teenager banner','View Teenager banner'),(18,'http://www.flickr.com/photos/handheldheartbeats/2372174387/in/pool-torontoist/','flickr.jpg','image/jpeg','167254',NULL,9,'2009-07-23 19:54:24','2009-08-10 14:52:47','Photo and comments from flickr','See photo & comments on flickr'),(19,'http://www.boardsmag.com/articles/online/20090505/topdirectors.html','boardsblaster.jpg','image/jpeg','76603',NULL,15,'2009-08-06 14:25:27','2009-08-06 18:24:45','The Top Directors issue','Read the Top Directors issue on Boards'),(20,'http://www.boardsmag.com/articles/online/20090505/drewlightfootcover.html','drewlightfootcover.jpg','image/jpeg','78867',NULL,15,'2009-08-06 14:26:43','2009-08-06 18:25:10','Cover design diary','Read Drew\'s Design Diary on Boards'),(22,'http://www.facebook.com/video/video.php?v=1344644969596','bullfrogvidurl.jpg','image/jpeg','74514',NULL,16,'2010-03-26 16:44:25','2010-03-26 16:44:25','Bullfrog \"How it Works\"','Visit \"How it Works\" animation on Facebook'),(23,'http://serproject.ca','nissanyoutube.jpg','image/jpeg','112545',NULL,17,'2010-04-09 17:20:44','2010-04-09 17:20:44','Nissan Canada\'s Youtube Channel','Visit Nissan Canada\'s Youtube Channel at serproject.ca'),(24,'http://vimeo.com/11928937','degrassivimeo.jpg','image/jpeg','91567',NULL,18,'2010-05-27 19:55:10','2010-05-27 19:55:10','Degrassi Promo on Vimeo','Visit Degrassi Season 10 Carnival Promo'),(25,'http://www.helpsomeonewithals.ca/','alssite.jpg','image/jpeg','57297',NULL,19,'2010-06-04 20:41:25','2010-06-04 20:41:25','ALS Microsite','Visit \"Help Someone with ALS\" Microsite'),(26,'http://adsoftheworld.com/media/online/als_hair','alsads.jpg','image/jpeg','59518',NULL,19,'2010-06-04 20:49:43','2010-06-05 01:21:19','\"Help Someone with ALS\" Banner Campaign on Ads of the World','Visit the banner campaign on Ads of the World site'),(27,'http://www.appliedartsmag.com/winners_details.php?id=795&headerName=h_awards_winners_interactive','purposeapplied.jpg','image/jpeg','122770',NULL,2,'2010-07-06 19:47:09','2010-07-06 19:47:09','The website won an Applied Arts Magazine Interactive Award','Visit Applied Arts Magazine Interactive Award'),(28,'http://www.visa.ca/smallbusiness/gobiz/index.jsp','freshiisite.jpg','image/jpeg','139173',NULL,20,'2010-08-10 21:13:16','2010-08-10 21:43:10','Freshii on VISA GoBiz site','Watch Matthew Corrin, Freshii Founder'),(29,'http://www.visa.ca/smallbusiness/gobiz/jrz-story.jsp','jrzsite.jpg','image/jpeg','143361',NULL,20,'2010-08-10 21:16:41','2010-08-10 21:43:16','JRZ on VISA GoBiz site','Watch Jean-René Lavigueur, JRZ Canada Inc. Founder'),(30,'http://kia.ca/','DriveChangeURL.jpg','image/jpeg','114930',NULL,21,'2010-08-17 15:29:10','2010-08-17 15:29:10','kia.ca Site Re-Skin','Drive Change on kia.ca'),(31,'http://work.thesecretlocation.com/DAVG/KIAB/DEMOS/2/','banner1.jpg','image/jpeg','116286',NULL,21,'2010-08-18 14:36:14','2010-08-18 14:36:53','Forte Leaderboard + Court Slider Banners','See Kia Banners'); /*!40000 ALTER TABLE `urls` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `videos` -- DROP TABLE IF EXISTS `videos`; CREATE TABLE `videos` ( `id` int(11) NOT NULL auto_increment, `video_file_name` varchar(255) default NULL, `video_content_type` varchar(255) default NULL, `video_file_size` varchar(255) default NULL, `video_photo_file_name` varchar(255) default NULL, `video_photo_content_type` varchar(255) default NULL, `video_photo_file_size` varchar(255) default NULL, `coconspirator_id` int(11) default NULL, `project_id` int(11) default NULL, `created_at` datetime default NULL, `updated_at` datetime default NULL, `currently_viewing` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8; -- -- Dumping data for table `videos` -- LOCK TABLES `videos` WRITE; /*!40000 ALTER TABLE `videos` DISABLE KEYS */; INSERT INTO `videos` VALUES (1,'viff1-over_analyzer.mov','video/quicktime','7775485','hardwork.jpg','image/jpeg','309208',2,NULL,'2009-06-08 20:41:07','2009-06-08 20:41:07',NULL),(3,'Purpose-wURL_TAG.mov','video/quicktime','18895149','Picture-24.jpg','image/jpeg','43548',NULL,2,'2009-07-02 17:34:01','2009-08-10 14:47:41','Saatchi.ca \"Purpose\"'),(5,'Warchild_DoNothing_Viral.mov','video/quicktime','23572652','Picture_8.png','image/png','155839',NULL,3,'2009-07-06 15:26:48','2009-08-10 14:49:55','\"Do Nothing\" viral'),(7,'Warchild_-campokutta_Viral.mov','video/quicktime','11328821','camp1.jpg','image/jpeg','104054',NULL,10,'2009-07-20 19:27:44','2009-08-10 14:53:12','Camp Okutta viral'),(8,'IKEA_HusbandDC.mov','video/quicktime','7696380','ikeaspot.jpg','image/jpeg','59254',NULL,6,'2009-07-22 17:32:34','2009-07-22 17:32:34','IKEA \"Dubbed Husband\"'),(9,'NYTimes_USE.mov','video/quicktime','31347995','nyt.jpg','image/jpeg','76575',NULL,11,'2009-08-04 18:25:34','2009-08-04 18:25:58','NY Times \"The Pyrotechnic Imagination\"'),(10,'Fashion_Cares-PEEPdircut-no-date.mov','video/quicktime','7439750','fashionc.jpg','image/jpeg','57535',NULL,5,'2009-08-06 16:04:31','2009-08-07 20:42:13','Fashion Cares \"Peep\"'),(11,'viff1-over_analyzer.mov','video/quicktime','7775485','VIFF.jpg','image/jpeg','62198',NULL,7,'2009-08-07 20:31:27','2009-08-07 20:37:26','VIFF \"Overanalyzer\"'),(12,'reel_assembled_2010_02_25a.mov','video/quicktime','30052555','secret.jpg','image/jpeg','5226',1,NULL,'2009-09-21 20:55:23','2010-07-08 18:30:06','Secret Location Reel'),(13,'Bullfrog_BlueSky_WEB_nologo.mov','video/quicktime','1263561','bullfrogblueskies.jpg','image/jpeg','85006',NULL,16,'2010-03-26 16:51:12','2010-03-26 17:07:29','Bullfrog Power \"Blue Sky\"'),(14,'Bullfrog_MessyKid_WEB_nologo.mov','video/quicktime','1265389','bullfrogmessykids.jpg','image/jpeg','78715',NULL,16,'2010-03-26 17:11:27','2010-03-26 17:11:27','Bullfrog Power \"Messy Kid\"'),(15,'Bullfrog_ReusableBags_WEB_nologo.mov','video/quicktime','1238314','bullfrog3.jpg','image/jpeg','80041',NULL,16,'2010-03-26 17:13:10','2010-03-26 17:13:10','Bullfrog Power \"Reusable Bags\"'),(17,'Nissan_dir_cut_colour_correct_640x480.mov','video/quicktime','8763645','drift.jpg','image/jpeg','61178',NULL,17,'2010-04-09 17:10:47','2010-04-09 17:10:47','Nissan \"Drift\" Director\'s Cut'),(18,'Nissan-themakingof_SER_project.mov','video/quicktime','51456700','making.jpg','image/jpeg','23499',NULL,17,'2010-04-09 17:31:50','2010-04-09 17:31:51','Nissan \"SE - R Project: The Making Of\"'),(20,'VISA_SMALL_BUSINESS_16x9_cutdown.mov','video/quicktime','30016143','Freshii.jpg','image/jpeg','98027',NULL,20,'2010-08-10 21:42:32','2010-08-10 21:42:33','Freshii'),(21,'VISA_JRZ_ENGLISH_15_FC1.mov','video/quicktime','3984352','jrz-url.jpg','image/jpeg','106056',NULL,20,'2010-08-10 21:44:05','2010-08-10 21:44:05','JRZ'),(22,'KIA_COURT_072710_REV_2.mov','video/quicktime','27425410','makingofcourt.jpg','image/jpeg','112560',NULL,21,'2010-08-17 15:11:22','2010-08-17 15:21:43','\"Court\" Story'),(23,'Kia-Court_60_DC.mov','video/quicktime','6845997','Court.jpg','image/jpeg','108449',NULL,21,'2010-08-17 15:16:32','2010-08-17 15:22:33','\"Court\"'),(24,'KIA_GARDEN_072710_REV_2.mov','video/quicktime','21841610','makingofgarden.jpg','image/jpeg','106590',NULL,21,'2010-08-17 15:17:06','2010-08-17 15:24:52','\"Garden\" Story'),(25,'Kia-Garden_60_DC.mov','video/quicktime','6182410','Garden.jpg','image/jpeg','102629',NULL,21,'2010-08-17 15:17:50','2010-08-17 15:25:48','\"Garden\"'),(26,'caramilkB.mov','video/quicktime','13240550','video_thumb.jpg','image/jpeg','121175',NULL,22,'2010-10-12 18:00:32','2010-10-12 18:31:28','Unlock the Caramilk Secret Case Video'),(27,'1._VIP_Mobile_-_Because_We_Care.mov','video/quicktime','4713908','VIP.jpg','image/jpeg','88503',3,NULL,'2010-10-14 16:33:43','2010-10-14 16:37:25','VIP Mobile - Because We Care'),(28,'2._WNYC_s_Radiolab_NPR_-_Words_440x316.mov','video/quicktime','19576879','WNYC.jpg','image/jpeg','45210',3,NULL,'2010-10-14 16:43:25','2010-10-14 17:59:44','WNYC\'s Radiolab + NPR - Words'),(29,'3._Four_Corners_of_Health_Insurance_-_Lou_440x316.mov','video/quicktime','15661963','Four-Corners.jpg','image/jpeg','84948',3,NULL,'2010-10-14 16:46:47','2010-10-14 18:03:02','Four Corners of Health Insurance - Lou'),(30,'4._MediaCom_-_Freshness.mov','video/quicktime','15268728','Mediacom.jpg','image/jpeg','98896',3,NULL,'2010-10-14 16:48:15','2010-10-14 16:48:16','MediaCom - Freshness'),(31,'5._Everyone_Forever_Now_-_Stoop_Sitting_Short_440x316.mov','video/quicktime','22253510','Everyone-.jpg','image/jpeg','109331',3,NULL,'2010-10-14 16:52:58','2010-10-14 18:37:52','Everyone Forever Now - Stoop Sitting Short'),(32,'6._WNYC_s_Radiolab_NPR_-_Moments_440x316.mov','video/quicktime','27883885','WNYC-MOMENTS.jpg','image/jpeg','82974',3,NULL,'2010-10-14 17:27:21','2010-10-14 18:04:14','WNYC\'s Radiolab + NPR - Moments'),(33,'7._NPR_-_Angela_Otis_Prugal_440x316.mov','video/quicktime','28488787','NPR.jpg','image/jpeg','83107',3,NULL,'2010-10-14 17:28:52','2010-10-14 18:05:35','NPR - Angela & Otis Prugal'),(34,'8._EFN02_Gun-h264_1000kbs_440x316.mov','video/quicktime','19712178','EFNO.jpg','image/jpeg','23350',3,NULL,'2010-10-14 17:30:27','2010-10-14 18:06:18','Everyone Forever Now - Shooting a Gun'),(35,'PS3_TheWait.mov','video/quicktime','7696303','PS3.jpg','image/jpeg','57132',4,NULL,'2010-10-15 13:06:40','2010-10-15 13:39:23','PS3 - The Wait'),(36,'2._PlayStation_-_Profiles.mov','video/quicktime','6607735','playstation.jpg','image/jpeg','54465',4,NULL,'2010-10-15 13:07:49','2010-10-15 13:07:49','PlayStation - Profiles'),(37,'3._Pepsi_-_Refresh_Project.mov','video/quicktime','13343736','Pepsi.jpg','image/jpeg','49379',4,NULL,'2010-10-15 13:08:21','2010-10-15 13:08:22','Pepsi - Refresh Project'),(38,'4._PSP_-_Canada_Plays.mov','video/quicktime','3419123','PSP.jpg','image/jpeg','68904',4,NULL,'2010-10-15 13:10:00','2010-10-15 13:10:01','PSP - Canada Plays'),(39,'1._The_Toronto_Sketch_Comedy_Festival_-_Wet_Spot.mov','video/quicktime','3199287','sketchcomedy.jpg','image/jpeg','98213',5,NULL,'2010-10-18 13:52:41','2010-10-18 13:52:41','The Toronto Sketch Comedy Festival - Wet Spot'),(40,'2._The_Queen_s_Pirate.mov','video/quicktime','41564524','thequeenspirate.jpg','image/jpeg','87774',5,NULL,'2010-10-18 13:53:19','2010-10-18 13:53:20','The Queen\'s Pirate'),(45,'smallfoot_milkweed-Apple_ProRes_422.mov','video/quicktime','2659687','MTV.jpg','image/jpeg','77084',5,NULL,'2010-10-18 14:00:52','2010-10-18 14:00:52','MTV - Smallfoot Milkweed'),(46,'4._Nestea_-_Party.mov','video/quicktime','8024428','nestea.jpg','image/jpeg','108399',5,NULL,'2010-10-18 14:01:28','2010-10-18 14:01:28','Nestea - Party'),(47,'5._MTV_-_Smallfoot_Music.mov','video/quicktime','2476340','MTVMUSIC.jpg','image/jpeg','78080',5,NULL,'2010-10-18 14:01:49','2010-10-18 14:01:50','MTV - Smallfoot Music'),(48,'6._DVAS_-_Society.mov','video/quicktime','23006519','DVAS.jpg','image/jpeg','110342',5,NULL,'2010-10-18 14:02:15','2010-10-18 14:02:15','DVAS - Society'),(51,'1._Hyundai-Making_Of_FINAL_Afternoon.mov','video/quicktime','21477634','hyundaiafternoon.jpg','image/jpeg','95832',8,NULL,'2010-10-19 19:16:17','2010-10-19 19:16:17','Hyundai - Making of Afternoon'),(53,'KIA_COURT.mov','video/quicktime','27425410','kiacourt.jpg','image/jpeg','76491',8,NULL,'2010-10-19 19:45:11','2010-10-19 19:45:12','Kia - Making of Court'),(54,'BILLY_TALENT_compressed.mov','video/quicktime','19747396','billy.jpg','image/jpeg','53102',8,NULL,'2010-10-19 19:46:41','2010-10-19 19:46:42','Billy Talent - Making of Diamond on a Landmine'),(55,'4._Hyundai-Creating_The_Illusion.mov','video/quicktime','15988087','hyundai.jpg','image/jpeg','88913',8,NULL,'2010-10-19 19:47:53','2010-10-19 19:47:54','Hyundai - Creating the Illusion'),(56,'5._KIA_GARDEN_072710_REV_2.mov','video/quicktime','21841610','KiaGarden.jpg','image/jpeg','62969',8,NULL,'2010-10-19 19:48:35','2010-10-19 19:48:35','Kia - Making of Garden'),(57,'D-SISIVE_wonderful_world.mov','video/quicktime','30571082','Dsisive.jpg','image/jpeg','65053',8,NULL,'2010-10-19 19:49:38','2010-10-19 19:49:39','D-Sisive - Wonderful World'); /*!40000 ALTER TABLE `videos` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2010-10-26 17:44:27