Abertay University | www.abertay.ac.uk | Dump

Dump is to big for Pastebin, view it here - http://carbonic.in/dumps/calb.txt

Database: daretobe_site
[191 tables]
+------------------------------------+
| CHRISdareusers                     |
| DareJudges                         |
| DareJudges2007                     |
| DareSelection                      |
| DareSelectionBackup20100326        |
| DareSelection_backup_20100305      |
| TeamUploads                        |
| Vavles                             |
| accessLevels                       |
| ajax_chat_bans                     |
| ajax_chat_invitations              |
| ajax_chat_messages                 |
| ajax_chat_online                   |
| ajax_example                       |
| applicantUniversities              |
| balloon_race                       |
| buzz                               |
| cache_data                         |
| dareJudgingGroups                  |
| dareJudgingGroups2013              |
| dareRegionalNews                   |
| dareRegions                        |
| dareTV                             |
| dare_application                   |
| dare_application_games             |
| dare_application_games_artworks    |
| dare_application_x_applicant       |
| dare_applications                  |
| dare_applications_applicants       |
| dare_sponsor_categories            |
| dare_sponsor_locations             |
| dare_sponsors                      |
| dareaccesslevels                   |
| darebodylookingforteam             |
| darehostcentres                    |
| darelookingforbody                 |
| daremediafiles                     |
| dareplusteamdiaries                |
| dareplusteamdiariespictures        |
| dareplusteamdiariesreplies         |
| dareplusteams                      |
| dareplusteamsdetails               |
| darestories                        |
| darestorypictures                  |
| dareteamdiaries                    |
| dareteamdiariespictures            |
| dareteamdiariesreplies             |
| dareteams                          |
| dareteamsWithSchollars             |
| dareteams_20120403                 |
| dareteams_copy                     |
| dareteamsdetails                   |
| dareuser_adminfilters              |
| dareuser_list_emails               |
| dareuser_lists                     |
| dareuser_parental_info             |
| dareusers                          |
| dareusers_international            |
| dareusers_international_app        |
| dctdare_entries                    |
| dcthomson                          |
| dreamerComments                    |
| dreamerComments_copy               |
| dreamerGameTags                    |
| dreamerGames                       |
| dreamerGames_copy                  |
| dreamerSubscriptions               |
| dreamerTags                        |
| dreamerVideoCounter                |
| dreamerVotes                       |
| dreamerVotingQuestionSets          |
| dreamerVotingQuestions             |
| dreamersVotesWp                    |
| email_bounce                       |
| emailsToGo                         |
| emails_blocked                     |
| emails_bounces                     |
| emails_ezines                      |
| emails_ezines_items                |
| emails_html                        |
| emails_manual                      |
| emails_perm                        |
| emails_read                        |
| emails_sent                        |
| emails_stats                       |
| emails_tiny                        |
| emails_tosend                      |
| eventAttendees                     |
| eventCompaniesAttending            |
| events                             |
| form_save                          |
| form_save_copy                     |
| future_internet_games_Selection    |
| future_internet_games_judgingGroup |
| future_internet_games_users        |
| futureinternetgames                |
| growApplicantJudging               |
| growApplicationHistory             |
| growApplicationUploads             |
| growApplications                   |
| growCompanies                      |
| growDownloads                      |
| growEducation                      |
| growProjectJudging                 |
| growProjects                       |
| growStatus                         |
| headings                           |
| items                              |
| judgeToGroups                      |
| judgingGroups                      |
| mtc_bookings                       |
| mtc_eventBookings                  |
| mtc_events                         |
| new_tweets                         |
| pages                              |
| phpbb_auth_access                  |
| plogger_albums                     |
| plogger_collections                |
| plogger_comments                   |
| plogger_config                     |
| plogger_pictures                   |
| plogger_tag2picture                |
| plogger_tags                       |
| plogger_thumbnail_config           |
| protoPlayEvents                    |
| protoPlayJuniorJudges              |
| protoplayBookings                  |
| ragnarawk_comments                 |
| ratings                            |
| sections                           |
| sidebar                            |
| site_settings                      |
| slides                             |
| ss_autoresponders                  |
| ss_banned_emails                   |
| ss_customfield_lists               |
| ss_customfields                    |
| ss_form_customfields               |
| ss_form_lists                      |
| ss_form_pages                      |
| ss_forms                           |
| ss_jobs                            |
| ss_jobs_lists                      |
| ss_links                           |
| ss_links_old                       |
| ss_list_subscriber_bounces         |
| ss_list_subscribers                |
| ss_list_subscribers_unsubscribe    |
| ss_lists                           |
| ss_newsletters                     |
| ss_queues                          |
| ss_queues_sequence                 |
| ss_settings                        |
| ss_stats_autoresponders            |
| ss_stats_emailforwards             |
| ss_stats_emailopens                |
| ss_stats_linkclicks                |
| ss_stats_links                     |
| ss_stats_newsletter_lists          |
| ss_stats_newsletters               |
| ss_stats_sequence                  |
| ss_stats_users                     |
| ss_subscribers_data                |
| ss_templates                       |
| ss_user_access                     |
| ss_user_permissions                |
| ss_user_stats_emailsperhour        |
| ss_users                           |
| teamMembers                        |
| teamTwits                          |
| teamTwittersAccounts               |
| team_screenshots                   |
| test                               |
| testdareteams                      |
| user_seq                           |
| versions                           |
| versions_archive                   |
| vgsclicks                          |
| vgsmembers                         |
| vgsteams                           |
| vgsthumbsup                        |
| video_comments                     |
| video_plays                        |
| video_ratings                      |
| videos                             |
| videosNew                          |
| videos_to_upload                   |
| videos_youtube                     |
| votes                              |
| votingQuestionSets                 |
| votingQuestions                    |
+------------------------------------+

Table: CHRISdareusers
[22 columns]
+-----------------------+---------------------+
| Column                | Type                |
+-----------------------+---------------------+
| dtmRegDate            | date                |
| dtmRegDateTime        | timestamp           |
| dtmRegTime            | time                |
| intAccessLevel        | smallint(6)         |
| intAllowDareEmail     | tinyint(1) unsigned |
| intAllowPartnersEmail | tinyint(1) unsigned |
| intConfirmed          | tinyint(1)          |
| intTeamNumber         | smallint(6)         |
| intUserNumber         | smallint(6)         |
| regAge                | varchar(10)         |
| regDescription        | varchar(10)         |
| regGender             | varchar(6)          |
| strConfirmString      | text                |
| strEmail              | text                |
| strForenames          | text                |
| strMobile             | varchar(32)         |
| strPassword           | text                |
| strSurname            | text                |
| strTelephone          | varchar(20)         |
| strTitle              | text                |
| strUserName           | text                |
| user_id               | int(11)             |
+-----------------------+---------------------+

+---------------------------++--------------++-------------++--------------++-------------+
| strEmail                  || strForenames || strPassword || strSurname   || strUserName |
+---------------------------++--------------++-------------++--------------++-------------+
| [email protected] || Elaine       || 134klm      || Administrato || archie      |
| [email protected]      || England      || 134klm      || Administrato || elaine      |
| [email protected]    || Ireland      || dug         || Jenny        || england     |
| [email protected]     || Sarah        || princess    || Johnston     || ireland     |
| [email protected]    || null         || zjjs        || Russell      || Jenny       |
+---------------------------++--------------++-------------++--------------++-------------+