-- MySQL dump 10.16 Distrib 10.2.12-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: ethanl6_noise -- ------------------------------------------------------ -- Server version 10.2.12-MariaDB-log /*!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 utf8mb4 */; /*!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 `guestbook_v2` -- DROP TABLE IF EXISTS `guestbook_v2`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `guestbook_v2` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `fullname` mediumtext COLLATE utf8_unicode_ci NOT NULL, `email` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `comments` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=574 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `guestbook_v2` -- LOCK TABLES `guestbook_v2` WRITE; /*!40000 ALTER TABLE `guestbook_v2` DISABLE KEYS */; INSERT INTO `guestbook_v2` (`id`, `date`, `fullname`, `email`, `comments`) VALUES (504,'14-09-2007','Webmaster General','undefined','Welcome to The Noisebook! Please feel free to leave comments about the site, the show or those involved in it. Keep it clean now!!!'),(508,'21-09-2007','beth williams','undefined','hello, \r\nloved it last year and cant wait to usher the show this year when it comes back to the marlowe!'),(505,'15-09-2007','Elton','undefined','Hey! Good to see the Noisebook up and running again! Saw the first night of the tour at Welwyn this week - better than before!'),(506,'15-09-2007','Karen','undefined','Just wanted to say how much I thoroughly enjoyed the show (Welwyn Gdn City). Keep it up for the rest of the tour!'),(507,'17-09-2007','Stephen Heliczer','undefined','Everything about the show was superb. The music, lights, production, choreography and standard of musicianship was entirely captivating throughout'),(509,'29-09-2007','clev','undefined','Great to see the CD released at last! We saw the show at Edinburgh in 2005 having been given free tickets by Mrs ELM (normally done for rubbish shows) and we enjoyed it so much that we paid to go and see it again. Pity you are not coming to North West England but we will do our best to get to Llandudno in November. Good luck with the tour.'),(510,'01-10-2007','lara','undefined','im only in year nine and we had actully won tickets to the show! it was excellent. I did nothing but drum the beat over and over driving my friends sick with envy :P i absolutly ,loved it. good luck in the future'),(511,'17-10-2007','Denise & Jack','undefined','My son Jack (aged 7) and I came to see your show on Friday at Tunbridge Wells, Assembly Hall. The show was amazing, unlike any other show I have ever seen. So much energy and passion went into the performance, you could see you all loved what you were doing. \r\n\r\nJack was beaming, as he loves music especially the Guitar and Drums, you can imagine what is on his Xmas list (I dont think so). Thank you for such an enjoyable evening. I came away buzzing, and I have been telling everyone how fantastic it was. Best wishes to you all.'),(512,'19-10-2007','conor canterbury','undefined','it was the best thing i have ever seen and heard i came with the cardiff county music service and i was really hopein you could come back to cardiff for another tour because you are the best thing that has evre come to cardiff thank you it was amzing aged 15'),(513,'23-10-2007','Debbie','undefined','Just got the CD the other day and was really pleased with how well it captures the energy, intensity and musicality of the show. In fact, it\'s a fantastic piece of work in its own right and incredibly pleasurable to listen to. Can\'t wait to see the live show again in Northampton.'),(514,'23-10-2007','Jean','undefined','Have just left the Marlowe Theatre in Canterbury and the Noise Ensemble is fantastic! What a wonderful show! Exciting drumming mixed with funny bits. Particularly enjoyable because I didn\'t know what to expect, no preconceived ideas, so came to the show ready for anything - and was amazed!! Thanks to all the drummers, crew and everyone.'),(515,'23-10-2007','Ben and Louisa Jones','undefined','My wife and I have just come back from seeing your show, we thought it was amazing! So impressed in fact we bought your CD in the intermission before seeing the second half of the show! Keep up the good work please, hope to see you again soon.'),(516,'24-10-2007','Matt','undefined','Had to search the internet for you after seeing you at the Marlowe last night. Fantastic show, I had goosebumps from start to finish'),(517,'24-10-2007','Catherine','undefined','Thanks for a great show at the Marlowe last night! What energy, what fun! I took my three children, two of whom take drum lessons. They loved it! Keep drumming!'),(518,'25-10-2007','Patricia','undefined','What a wonderful fantastic show at the Marlow. We didnt know what to expect but it was beautiful. Come back again next year to Kent.'),(519,'25-10-2007','Sandra','undefined','Just got back from seeing the show in Salisbury. It was inspirational. What a fantastically entertaining evening. Many thanks we thoroughly enjoyed the performance and will look out for you next year.'),(520,'26-10-2007','Penny','undefined','Fabulous show last night in Salisbury - thank you so much for a wonderful evening. Please come back soon!'),(521,'26-10-2007','Pam','undefined','Saw your show last night in Salisbury. It was fantastic. Wanted to buy the CD straight away but had to come back and order it! Please come back again next year.'),(522,'26-10-2007','stevo','undefined','Went to see the salisbury show. It was fantastic. Thank you to everyone involved in making this show happen. hope to see you again in salisbury soon.'),(548,'26-02-2009','Kirsty%20Patterson','kirstand@btinternet.com','I%20was%20at%20your%20show%20in%20Inverness%20last%20night%20(25/02/09).%20OMG%20it%20was%20amazing!!!%20%20I%20play%20the%20snare%20drum%20for%20the%20Tain%20pipe%20band.%20I%20would%20love%20to%20do%20what%20you%20guys%20do.%20Keep%20up%20the%20good%20work!!!!%20x'),(547,'26-02-2009','June%20Seaber-Tellum','','The%20show%20last%20night%20in%20Inverness%20was%20awesome.%20Thanks%20a%20million%20for%20a%20terrific%20show.%20Come%20back%20soon'),(545,'21-02-2009','Floree','babe_of_glitter9@hotmail.co.uk','Last%20night%20in%20Keswick%20was%20brilliant!'),(546,'22-02-2009','John%20&%20Joy','','Saw%20you%20for%20the%20first%20time%20Friday%20night,%20in%20Keswick.%20Absolutely%20brilliant,%20especially%20in%20such%20a%20small%20venue.%20When%20are%20you%20coming%20back'),(544,'21-02-2009','Chris','','Saw%20the%20show%20last%20night%20-%20stunning!!!%20what%20else%20can%20be%20said'),(543,'1-02-2009','paul','','what%20a%20great%20show!'),(549,'26-02-2009','Ryan%20Mackay','sir_fray_bentos@hotmail.co.uk','Wow!%20your%20show%20is%20mind%20blowing!%20I%20was%20also%20at%20the%20inverness%20show%20last%20night%20and%20all%20of%20my%20friends%20and%20i%20were%20blown%20away%20with%20the%20show!%20I%20play%20the%20drums%20and%20you%20guys%20inspired%20me%20to%20start%20playing%20the%20snare%20drum%20in%20school%20today!'),(551,'9-03-2009','Paul%20Foster','','I saw the show in Belfast last night..... OUTSTANDING.!!! It \'BEATS\' the hell of of Stomp. It has much more to it and the comedy factor was brilliant. Visuals were impressive and it was good to see such a talented cast enjoying their work...\r\nPURE BRILLIANCE, HOPE TO SEE IT BACK HERE SOON...'),(552,'9-03-2009','Mick','','U%20blew%20me%20away%20last%20night,%20fantastic%20show!'),(555,'27-03-2009','Grant%20R','','I%20saw%20the%20show%20in%20eden%20court,%20you%20guys%20were%20AWESOME!%20The%20thing%20with%20the%20tambourines%20was%20genious!'),(556,'27-03-2009','Val%20Williams','valwilliams2009@hotmail.co.uk','Saw%20your%20show%20a%20while%20back%20when%20you%20came%20to%20Truro,%20Cornwall%20and%20loved%20it%20as%20I%20know%20Scott%20and%20Mike%20well.%20%20Gutted%20that%20I%20missed%20the%20fact%20that%20you%20were%20in%20Exmouth%20as%20I%20would%20definitely%20have%20attended.%20%20Please%20come%20to%20Plymouth!!!!!%20Please!!!!!!'),(553,'11-03-2009','Frank','','Saw%20the%20show%20in%20Belfast%20-%20FANTASTIC!%20Pure%20theatre,%20great%20percussion%20and%20hilarious%20in%20places.%20A%20great%20night%20out%20-%20keep%20it%20up%20.%20.%20.%20and%20come%20back%20soon.'),(554,'16-03-2009','Rohan%20Hunniford','','Awesome%20show%20last%20week%20in%20Belfast.%20The%20comic%20touches%20and%20variation%20of%20instruments%20made%20it%20well%20worth%20seeing.%20Would%20like%20to%20see%20it%20in%20Northern%20Ireland%20again'),(557,'4-04-2009','Daniel','dan@byroms.net','absolutely%20amazing'),(558,'12-04-2009','Emily%20Turner','turnertomfoolery@hotmail.co.uk','FANTASTIC!!!!!%20COULDNT%20SIT%20STILL'),(559,'25-04-2009','simon%20mortimer','','Unbelievable...Cambridge%20rocked.........'),(560,'30-05-2009','Al%20Stringer','sales@southwickbrewhouse.co.uk','Great%20show%20in%20Basingstoke%20last%20night.%20Thankyou%20and%20well%20done.%20Might%20catch%20you%20in%20Crawley%20!'),(561,'13-06-2009','Andrew%20Orchard','andrew.orchard@live.co.uk','as%20a%20drummer%20myself,%20i%20was%20amazed%20at%20the%20show%20you%20put%20on!%20and%20canterbury%20was%20not%20too%20far%20away%20for%20me%20either!'),(562,'','','',''),(563,'','','',''),(564,'','','',''),(565,'','','',''),(566,'','','',''),(567,'','','',''),(568,'','','',''),(569,'','','',''),(570,'','','',''),(571,'','','',''),(572,'','','',''),(573,'','','',''); /*!40000 ALTER TABLE `guestbook_v2` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `guestbook_v2_login` -- DROP TABLE IF EXISTS `guestbook_v2_login`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `guestbook_v2_login` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `userpassword` varchar(100) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `guestbook_v2_login` -- LOCK TABLES `guestbook_v2_login` WRITE; /*!40000 ALTER TABLE `guestbook_v2_login` DISABLE KEYS */; INSERT INTO `guestbook_v2_login` (`id`, `username`, `userpassword`) VALUES (1,'ethanfox','spanker1'); /*!40000 ALTER TABLE `guestbook_v2_login` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'ethanl6_noise' -- -- -- Dumping routines for database 'ethanl6_noise' -- /*!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 2019-04-23 13:23:50