Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Tanzania Meteorological Agency
- Target Site: www.meteo.GO.tz
- DATABASES [3]:
- information_schema
- meteogo_meteo
- meteogo_tma
- DATABASE:meteogo_meteo
- [11 TABLES]
- authteam
- authuser
- authuserteam_mapping
- documents_descriptions
- generic_content_file
- generic_news_item
- generic_news_item_category
- generic_news_item_type
- page
- tz_regions
- weather_date
- DATABASE:meteogo_meteo TABLE: documents_descriptions
- [6 COLUMNS]
- +-------------------+--------------+
- | COLUMN | TYPE |
- +-------------------+--------------+
- | intDocumentID | INT(11) |
- | szDescription | longtext |
- | szFilename | VARCHAR(255) |
- | szFilenameAndPath | VARCHAR(255) |
- | szMimeType | VARCHAR(50) |
- | szPath | VARCHAR(255) |
- +-------------------+--------------+
- DATABASE: meteogo_meteo
- TABLE: authuser
- [8 COLUMNS]
- +------------+-------------+
- | COLUMN | TYPE |
- +------------+-------------+
- | id | INT(11) |
- | lastlogin | datetime |
- | level | INT(4) |
- | logincount | INT(11) |
- | passwd | VARCHAR(32) |
- | STATUS | VARCHAR(10) |
- | team | VARCHAR(25) |
- | uname | VARCHAR(25) |
- +------------+-------------+
- DATABASE: meteogo_meteo
- TABLE: generic_news_item_category
- [4 COLUMNS]
- +---------------------+--------------+
- | COLUMN | TYPE |
- +---------------------+--------------+
- | intCategoryID | INT(11) |
- | intParentCategoryID | INT(11) |
- | intTypeID | INT(11) |
- | szCategory | VARCHAR(100) |
- +---------------------+--------------+
- DATABASE: meteogo_meteo
- TABLE: authuserteam_mapping
- [3 COLUMNS]
- +--------+---------+
- | COLUMN | TYPE |
- +--------+---------+
- | id | INT(11) |
- | teamID | INT(11) |
- | userID | INT(11) |
- +--------+---------+
- DATABASE: meteogo_meteo
- TABLE: generic_content_file
- [6 COLUMNS]
- +----------------+--------------+
- | COLUMN | TYPE |
- +----------------+--------------+
- | ID | INT(11) |
- | intFileSize | INT(11) |
- | intItemID | INT(11) |
- | intVariationID | INT(11) |
- | szFileName | VARCHAR(100) |
- | szFileType | VARCHAR(100) |
- +----------------+--------------+
- DATABASE: meteogo_meteo
- TABLE: generic_news_item_type
- [9 COLUMNS]
- +----------------------+--------------+
- | COLUMN | TYPE |
- +----------------------+--------------+
- | intTypeID | INT(11) |
- | lAdminFieldNames | text |
- | lAdminRelevantFields | text |
- | lFieldNames | text |
- | lRelevantFields | text |
- | szAdminFieldLink | VARCHAR(255) |
- | szAdminSortBy | VARCHAR(255) |
- | szType | VARCHAR(100) |
- | szViewPage | VARCHAR(255) |
- +----------------------+--------------+
- DATABASE: meteogo_meteo
- TABLE: generic_news_item
- [28 COLUMNS]
- +-------------------+--------------+
- | COLUMN | TYPE |
- +-------------------+--------------+
- | blArchive | tinyint(1) |
- | blFlag1 | tinyint(1) |
- | blFlag2 | tinyint(1) |
- | blFlag3 | tinyint(1) |
- | blPublish | tinyint(1) |
- | dtCreated | datetime |
- | dtFrom | datetime |
- | dtTo | datetime |
- | dtUpdated | datetime |
- | flFileID | INT(11) |
- | flImageID | INT(11) |
- | ID | INT(11) |
- | intCatID | INT(11) |
- | intItemID | INT(11) |
- | intRank | INT(11) |
- | intTypeID | INT(11) |
- | intVariationID | INT(11) |
- | szAttachmentTitle | VARCHAR(100) |
- | szBody | text |
- | szCaption | VARCHAR(100) |
- | szContactEmail | VARCHAR(100) |
- | szContactName | VARCHAR(100) |
- | szFax | VARCHAR(100) |
- | szLink | VARCHAR(100) |
- | szLocation | VARCHAR(100) |
- | szPhone | VARCHAR(100) |
- | szSummary | text |
- | szTitle | VARCHAR(100) |
- +-------------------+--------------+
- DATABASE: meteogo_meteo
- TABLE: authteam
- [4 COLUMNS]
- +----------+--------------+
- | COLUMN | TYPE |
- +----------+--------------+
- | id | INT(4) |
- | STATUS | VARCHAR(10) |
- | teamlead | VARCHAR(25) |
- | teamname | VARCHAR(100) |
- +----------+--------------+
- DATABASE: meteogo_meteo
- TABLE: tz_regions
- [10 COLUMNS]
- +-------------+--------------+
- | COLUMN | TYPE |
- +-------------+--------------+
- | dtUpdated | DATE |
- | intMax | INT(11) |
- | intMin | INT(11) |
- | intRegionID | INT(11) |
- | szRegion | VARCHAR(255) |
- | szSunrise | VARCHAR(255) |
- | szSunset | VARCHAR(255) |
- | szWeather | VARCHAR(255) |
- | szWind | VARCHAR(255) |
- | szZone | VARCHAR(255) |
- +-------------+--------------+
- DATABASE: meteogo_meteo
- TABLE: weather_date
- [2 COLUMNS]
- +-----------+---------+
- | COLUMN | TYPE |
- +-----------+---------+
- | dtWeather | DATE |
- | id | INT(11) |
- +-----------+---------+
- DATABASE: meteogo_meteo
- TABLE: page
- [2 COLUMNS]
- +---------+----------+
- | COLUMN | TYPE |
- +---------+----------+
- | content | longtext |
- | id | INT(11) |
- +---------+----------+
- DATABASE: meteogo_meteo
- TABLE: authuser
- [2 entries]
- +----+---------+-------+---------------+--------+----------------------------------+---------------------+------------+
- | id | team | level | uname | STATUS | passwd | lastlogin | logincount |
- +----+---------+-------+---------------+--------+----------------------------------+---------------------+------------+
- | 39 | <blank> | 1 | admin | active | 4a1b986c59733daf0a47c4ca2d7bd517 | 2013-07-23 17:14:35 | 1454 |
- | 40 | <blank> | 1 | Administrator | active | 4a1b986c59733daf0a47c4ca2d7bd517 | 2013-07-20 12:04:29 | 290 |
- +----+---------+-------+---------------+--------+----------------------------------+---------------------+------------+
- DATABASE:meteogo_tma
- [112 TABLES]
- kweather_woeid
- tbl_alart
- tz_regions
- z7rl0_assets
- z7rl0_associations
- z7rl0_banner_clients
- z7rl0_banner_tracks
- z7rl0_banners
- z7rl0_categories
- z7rl0_contact_details
- z7rl0_content
- z7rl0_content_frontpage
- z7rl0_content_rating
- z7rl0_core_log_searches
- z7rl0_extensions
- z7rl0_finder_filters
- z7rl0_finder_links
- z7rl0_finder_links_terms0
- z7rl0_finder_links_terms1
- z7rl0_finder_links_terms2
- z7rl0_finder_links_terms3
- z7rl0_finder_links_terms4
- z7rl0_finder_links_terms5
- z7rl0_finder_links_terms6
- z7rl0_finder_links_terms7
- z7rl0_finder_links_terms8
- z7rl0_finder_links_terms9
- z7rl0_finder_links_termsa
- z7rl0_finder_links_termsb
- z7rl0_finder_links_termsc
- z7rl0_finder_links_termsd
- z7rl0_finder_links_termse
- z7rl0_finder_links_termsf
- z7rl0_finder_taxonomy
- z7rl0_finder_taxonomy_map
- z7rl0_finder_terms
- z7rl0_finder_terms_common
- z7rl0_finder_tokens
- z7rl0_finder_tokens_aggregate
- z7rl0_finder_types
- z7rl0_jaem_log
- z7rl0_jaem_services
- z7rl0_jarpx_mapid
- z7rl0_k2_attachments
- z7rl0_k2_categories
- z7rl0_k2_comments
- z7rl0_k2_extra_fields
- z7rl0_k2_extra_fields_groups
- z7rl0_k2_items
- z7rl0_k2_rating
- z7rl0_k2_tags
- z7rl0_k2_tags_xref
- z7rl0_k2_user_groups
- z7rl0_k2_users
- z7rl0_kunena_aliases
- z7rl0_kunena_announcement
- z7rl0_kunena_attachments
- z7rl0_kunena_categories
- z7rl0_kunena_configuration
- z7rl0_kunena_keywords
- z7rl0_kunena_keywords_map
- z7rl0_kunena_messages
- z7rl0_kunena_messages_text
- z7rl0_kunena_polls
- z7rl0_kunena_polls_options
- z7rl0_kunena_polls_users
- z7rl0_kunena_ranks
- z7rl0_kunena_sessions
- z7rl0_kunena_smileys
- z7rl0_kunena_thankyou
- z7rl0_kunena_topics
- z7rl0_kunena_user_categories
- z7rl0_kunena_user_read
- z7rl0_kunena_user_topics
- z7rl0_kunena_users
- z7rl0_kunena_users_banned
- z7rl0_kunena_version
- z7rl0_kweather_station
- z7rl0_languages
- z7rl0_menu
- z7rl0_menu_types
- z7rl0_messages
- z7rl0_messages_cfg
- z7rl0_modules
- z7rl0_modules_menu
- z7rl0_newsfeeds
- z7rl0_overrider
- z7rl0_phocadownload
- z7rl0_phocadownload_categories
- z7rl0_phocadownload_file_votes
- z7rl0_phocadownload_file_votes_statistics
- z7rl0_phocadownload_layout
- z7rl0_phocadownload_licenses
- z7rl0_phocadownload_tags
- z7rl0_phocadownload_tags_ref
- z7rl0_phocadownload_user_stat
- z7rl0_redirect_links
- z7rl0_schemas
- z7rl0_session
- z7rl0_template_styles
- z7rl0_update_categories
- z7rl0_update_sites
- z7rl0_update_sites_extensions
- z7rl0_updates
- z7rl0_user_notes
- z7rl0_user_profiles
- z7rl0_user_usergroup_map
- z7rl0_usergroups
- z7rl0_users
- z7rl0_viewlevels
- z7rl0_vvisit_counter
- z7rl0_weblinks
- DATABASE: meteogo_tma
- TABLE: z7rl0_users
- [1 entry]
- +----+------------+------------------+-------+----------------------------------------------------------------------------------------------+----------+------------+----------------------------------+-----------+------------+------------+---------------------+---------------------+---------------------+
- | id | name | email | block | params | username | usertype | password | sendEmail | activation | resetCount | registerDate | lastResetTime | lastvisitDate |
- +----+------------+------------------+-------+----------------------------------------------------------------------------------------------+----------+------------+----------------------------------+-----------+------------+------------+---------------------+---------------------+---------------------+
- | 42 | Super USER | info@meteo.GO.tz | 0 | {"admin_style":"","admin_language":"","language":"","editor":"","helpsite":"","timezone":""} | admin | deprecated | c33367701511b4f6020ec61ded352059 | 1 | 0 | 0 | 2012-11-30 08:48:46 | 0000-00-00 00:00:00 | 2013-04-09 11:51:09 |
- +----+------------+------------------+-------+----------------------------------------------------------------------------------------------+----------+------------+----------------------------------+-----------+------------+------------+---------------------+---------------------+---------------------+
Add Comment
Please, Sign In to add comment