Drop files here

SQL upload ( 0 ) x-

Server: rdbms.strato.de »Database: DB69570
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
Number of tables: 0
v DB69570 nuke_authors
* aid : varchar(25)
* name : varchar(50)
* url : varchar(255)
* email : varchar(255)
* pwd : varchar(40)
* counter : int(11)
* radminarticle : tinyint(2)
* radmintopic : tinyint(2)
* radminuser : tinyint(2)
* radminsurvey : tinyint(2)
* radminsection : tinyint(2)
* radminephem : tinyint(2)
* radminfaq : tinyint(2)
* radmindownload : tinyint(2)
* radminreviews : tinyint(2)
* radminnewsletter : tinyint(2)
* radminforum : tinyint(2)
* radmincontent : tinyint(2)
* radminency : tinyint(2)
* radminsuper : tinyint(2)
* admlanguage : varchar(30)
v DB69570 nuke_autonews
* anid : int(11)
* catid : int(11)
* aid : varchar(30)
* title : varchar(80)
* time : varchar(19)
* hometext : text
* bodytext : text
* topic : int(3)
* informant : varchar(20)
* notes : text
* ihome : int(1)
* alanguage : varchar(30)
* acomm : int(1)
* associated : text
v DB69570 nuke_banner
* bid : int(11)
* cid : int(11)
* imptotal : int(11)
* impmade : int(11)
* clicks : int(11)
* imageurl : varchar(100)
* clickurl : varchar(200)
* alttext : varchar(255)
* date : datetime
* dateend : datetime
* type : tinyint(1)
* active : tinyint(1)
v DB69570 nuke_bannerclient
* cid : int(11)
* name : varchar(60)
* contact : varchar(60)
* email : varchar(60)
* login : varchar(10)
* passwd : varchar(10)
* extrainfo : text
v DB69570 nuke_bbauth_access
* group_id : mediumint(8)
* forum_id : smallint(5) unsigned
* auth_view : tinyint(1)
* auth_read : tinyint(1)
* auth_post : tinyint(1)
* auth_reply : tinyint(1)
* auth_edit : tinyint(1)
* auth_delete : tinyint(1)
* auth_sticky : tinyint(1)
* auth_announce : tinyint(1)
* auth_vote : tinyint(1)
* auth_pollcreate : tinyint(1)
* auth_attachments : tinyint(1)
* auth_mod : tinyint(1)
v DB69570 nuke_bbbanlist
* ban_id : mediumint(8) unsigned
* ban_userid : mediumint(8)
* ban_ip : varchar(8)
* ban_email : varchar(255)
v DB69570 nuke_bbcategories
* cat_id : mediumint(8) unsigned
* cat_title : varchar(100)
* cat_order : mediumint(8) unsigned
v DB69570 nuke_bbconfig
* config_name : varchar(255)
* config_value : varchar(255)
v DB69570 nuke_bbdisallow
* disallow_id : mediumint(8) unsigned
* disallow_username : varchar(25)
v DB69570 nuke_bbforums
* forum_id : smallint(5) unsigned
* cat_id : mediumint(8) unsigned
* forum_name : varchar(150)
* forum_desc : text
* forum_status : tinyint(4)
* forum_order : mediumint(8) unsigned
* forum_posts : mediumint(8) unsigned
* forum_topics : mediumint(8) unsigned
* forum_last_post_id : mediumint(8) unsigned
* prune_next : int(11)
* prune_enable : tinyint(1)
* auth_view : tinyint(2)
* auth_read : tinyint(2)
* auth_post : tinyint(2)
* auth_reply : tinyint(2)
* auth_edit : tinyint(2)
* auth_delete : tinyint(2)
* auth_sticky : tinyint(2)
* auth_announce : tinyint(2)
* auth_vote : tinyint(2)
* auth_pollcreate : tinyint(2)
* auth_attachments : tinyint(2)
v DB69570 nuke_bbforum_prune
* prune_id : mediumint(8) unsigned
* forum_id : smallint(5) unsigned
* prune_days : tinyint(4) unsigned
* prune_freq : tinyint(4) unsigned
v DB69570 nuke_bbgroups
* group_id : mediumint(8)
* group_type : tinyint(4)
* group_name : varchar(40)
* group_description : varchar(255)
* group_moderator : mediumint(8)
* group_single_user : tinyint(1)
v DB69570 nuke_bbposts
* post_id : mediumint(8) unsigned
* topic_id : mediumint(8) unsigned
* forum_id : smallint(5) unsigned
* poster_id : mediumint(8)
* post_time : int(11)
* poster_ip : varchar(8)
* post_username : varchar(25)
* enable_bbcode : tinyint(1)
* enable_html : tinyint(1)
* enable_smilies : tinyint(1)
* enable_sig : tinyint(1)
* post_edit_time : int(11)
* post_edit_count : smallint(5) unsigned
v DB69570 nuke_bbposts_text
* post_id : mediumint(8) unsigned
* bbcode_uid : varchar(10)
* post_subject : varchar(60)
* post_text : text
v DB69570 nuke_bbprivmsgs
* privmsgs_id : mediumint(8) unsigned
* privmsgs_type : tinyint(4)
* privmsgs_subject : varchar(255)
* privmsgs_from_userid : mediumint(8)
* privmsgs_to_userid : mediumint(8)
* privmsgs_date : int(11)
* privmsgs_ip : varchar(8)
* privmsgs_enable_bbcode : tinyint(1)
* privmsgs_enable_html : tinyint(1)
* privmsgs_enable_smilies : tinyint(1)
* privmsgs_attach_sig : tinyint(1)
v DB69570 nuke_bbprivmsgs_text
* privmsgs_text_id : mediumint(8) unsigned
* privmsgs_bbcode_uid : varchar(10)
* privmsgs_text : text
v DB69570 nuke_bbranks
* rank_id : smallint(5) unsigned
* rank_title : varchar(50)
* rank_min : mediumint(8)
* rank_max : mediumint(8)
* rank_special : tinyint(1)
* rank_image : varchar(255)
v DB69570 nuke_bbsearch_results
* search_id : int(11) unsigned
* session_id : varchar(32)
* search_array : text
v DB69570 nuke_bbsearch_wordlist
* word_text : varchar(50)
* word_id : mediumint(8) unsigned
* word_common : tinyint(1) unsigned
v DB69570 nuke_bbsearch_wordmatch
* post_id : mediumint(8) unsigned
* word_id : mediumint(8) unsigned
* title_match : tinyint(1)
v DB69570 nuke_bbsessions
* session_id : char(32)
* session_user_id : mediumint(8)
* session_start : int(11)
* session_time : int(11)
* session_ip : char(8)
* session_page : int(11)
* session_logged_in : tinyint(1)
v DB69570 nuke_bbsmilies
* smilies_id : smallint(5) unsigned
* code : varchar(50)
* smile_url : varchar(100)
* emoticon : varchar(75)
v DB69570 nuke_bbthemes
* themes_id : mediumint(8) unsigned
* template_name : varchar(30)
* style_name : varchar(30)
* head_stylesheet : varchar(100)
* body_background : varchar(100)
* body_bgcolor : varchar(6)
* body_text : varchar(6)
* tr_color1 : varchar(6)
* tr_color2 : varchar(6)
* tr_color3 : varchar(6)
* tr_class1 : varchar(25)
* tr_class2 : varchar(25)
* tr_class3 : varchar(25)
* th_color1 : varchar(6)
* th_color2 : varchar(6)
* th_color3 : varchar(6)
* th_class1 : varchar(25)
* th_class2 : varchar(25)
* th_class3 : varchar(25)
* td_color1 : varchar(6)
* td_color2 : varchar(6)
* td_color3 : varchar(6)
* td_class1 : varchar(25)
* td_class2 : varchar(25)
* td_class3 : varchar(25)
* fontface1 : varchar(50)
* fontface2 : varchar(50)
* fontface3 : varchar(50)
* fontsize1 : tinyint(4)
* fontsize2 : tinyint(4)
* fontsize3 : tinyint(4)
* fontcolor1 : varchar(6)
* fontcolor2 : varchar(6)
* fontcolor3 : varchar(6)
* span_class1 : varchar(25)
* span_class2 : varchar(25)
* span_class3 : varchar(25)
* img_size_poll : smallint(5) unsigned
* img_size_privmsg : smallint(5) unsigned
v DB69570 nuke_bbthemes_name
* themes_id : smallint(5) unsigned
* tr_color1_name : char(50)
* tr_color2_name : char(50)
* tr_color3_name : char(50)
* tr_class1_name : char(50)
* tr_class2_name : char(50)
* tr_class3_name : char(50)
* th_color1_name : char(50)
* th_color2_name : char(50)
* th_color3_name : char(50)
* th_class1_name : char(50)
* th_class2_name : char(50)
* th_class3_name : char(50)
* td_color1_name : char(50)
* td_color2_name : char(50)
* td_color3_name : char(50)
* td_class1_name : char(50)
* td_class2_name : char(50)
* td_class3_name : char(50)
* fontface1_name : char(50)
* fontface2_name : char(50)
* fontface3_name : char(50)
* fontsize1_name : char(50)
* fontsize2_name : char(50)
* fontsize3_name : char(50)
* fontcolor1_name : char(50)
* fontcolor2_name : char(50)
* fontcolor3_name : char(50)
* span_class1_name : char(50)
* span_class2_name : char(50)
* span_class3_name : char(50)
v DB69570 nuke_bbtopics
* topic_id : mediumint(8) unsigned
* forum_id : smallint(8) unsigned
* topic_title : char(60)
* topic_poster : mediumint(8)
* topic_time : int(11)
* topic_views : mediumint(8) unsigned
* topic_replies : mediumint(8) unsigned
* topic_status : tinyint(3)
* topic_vote : tinyint(1)
* topic_type : tinyint(3)
* topic_last_post_id : mediumint(8) unsigned
* topic_first_post_id : mediumint(8) unsigned
* topic_moved_id : mediumint(8) unsigned
v DB69570 nuke_bbtopics_watch
* topic_id : mediumint(8) unsigned
* user_id : mediumint(8)
* notify_status : tinyint(1)
v DB69570 nuke_bbuser_group
* group_id : mediumint(8)
* user_id : mediumint(8)
* user_pending : tinyint(1)
v DB69570 nuke_bbvote_desc
* vote_id : mediumint(8) unsigned
* topic_id : mediumint(8) unsigned
* vote_text : text
* vote_start : int(11)
* vote_length : int(11)
v DB69570 nuke_bbvote_results
* vote_id : mediumint(8) unsigned
* vote_option_id : tinyint(4) unsigned
* vote_option_text : varchar(255)
* vote_result : int(11)
v DB69570 nuke_bbvote_voters
* vote_id : mediumint(8) unsigned
* vote_user_id : mediumint(8)
* vote_user_ip : char(8)
v DB69570 nuke_bbwords
* word_id : mediumint(8) unsigned
* word : char(100)
* replacement : char(100)
v DB69570 nuke_blocks
* bid : int(10)
* bkey : varchar(15)
* title : varchar(60)
* content : text
* url : varchar(200)
* bposition : char(1)
* weight : int(10)
* active : int(1)
* refresh : int(10)
* time : varchar(14)
* blanguage : varchar(30)
* blockfile : varchar(255)
* view : int(1)
v DB69570 nuke_comments
* tid : int(11)
* pid : int(11)
* sid : int(11)
* date : datetime
* name : varchar(60)
* email : varchar(60)
* url : varchar(60)
* host_name : varchar(60)
* subject : varchar(85)
* comment : text
* score : tinyint(4)
* reason : tinyint(4)
v DB69570 nuke_config
* sitename : varchar(255)
* nukeurl : varchar(255)
* slogan : varchar(255)
* startdate : varchar(50)
* adminmail : varchar(255)
* anonpost : tinyint(1)
* Default_Theme : varchar(255)
* foot1 : text
* foot2 : text
* foot3 : text
* commentlimit : int(9)
* anonymous : varchar(255)
* minpass : tinyint(1)
* pollcomm : tinyint(1)
* articlecomm : tinyint(1)
* broadcast_msg : tinyint(1)
* my_headlines : tinyint(1)
* top : int(3)
* storyhome : int(2)
* user_news : tinyint(1)
* oldnum : int(2)
* ultramode : tinyint(1)
* banners : tinyint(1)
* backend_title : varchar(255)
* backend_language : varchar(10)
* language : varchar(100)
* locale : varchar(10)
* multilingual : tinyint(1)
* useflags : tinyint(1)
* notify : tinyint(1)
* notify_email : varchar(255)
* notify_subject : varchar(255)
* notify_message : varchar(255)
* notify_from : varchar(255)
* footermsgtxt : text
* email_send : tinyint(1)
* attachmentdir : varchar(255)
* attachments : tinyint(1)
* attachments_view : tinyint(1)
* download_dir : varchar(255)
* defaultpopserver : varchar(255)
* singleaccount : tinyint(1)
* singleaccountname : varchar(255)
* numaccounts : tinyint(2)
* imgpath : varchar(255)
* filter_forward : tinyint(1)
* moderate : tinyint(1)
* admingraphic : tinyint(1)
* httpref : tinyint(1)
* httprefmax : int(5)
* CensorMode : tinyint(1)
* CensorReplace : varchar(10)
* copyright : text
* Version_Num : varchar(10)
v DB69570 nuke_contactbook
* uid : int(11)
* contactid : int(11)
* firstname : varchar(50)
* lastname : varchar(50)
* email : varchar(255)
* company : varchar(255)
* homeaddress : varchar(255)
* city : varchar(80)
* homephone : varchar(255)
* workphone : varchar(255)
* homepage : varchar(255)
* IM : varchar(255)
* events : text
* reminders : int(11)
* notes : text
v DB69570 nuke_counter
* type : varchar(80)
* var : varchar(80)
* count : int(10) unsigned
v DB69570 nuke_dis_er
* dis_er_400 : text
* dis_er_400_tit : text
* dis_er_401 : text
* dis_er_401_tit : text
* dis_er_403 : text
* dis_er_403_tit : text
* dis_er_404 : text
* dis_er_404_tit : text
* dis_er_405 : text
* dis_er_405_tit : text
* dis_er_406 : text
* dis_er_406_tit : text
* dis_er_408 : text
* dis_er_408_tit : text
* dis_er_410 : text
* dis_er_410_tit : text
* dis_er_411 : text
* dis_er_411_tit : text
* dis_er_414 : text
* dis_er_414_tit : text
* dis_er_500 : text
* dis_er_500_tit : text
* dis_er_503 : text
* dis_er_503_tit : text
* dis_error : text
* dis_error_tit : text
v DB69570 nuke_downloads_categories
* cid : int(11)
* title : varchar(50)
* cdescription : text
* parentid : int(11)
v DB69570 nuke_downloads_downloads
* lid : int(11)
* cid : int(11)
* sid : int(11)
* title : varchar(100)
* url : varchar(100)
* description : text
* date : datetime
* name : varchar(100)
* email : varchar(100)
* hits : int(11)
* submitter : varchar(60)
* downloadratingsummary : double(6,4)
* totalvotes : int(11)
* totalcomments : int(11)
* filesize : int(11)
* version : varchar(10)
* homepage : varchar(200)
v DB69570 nuke_downloads_editorials
* downloadid : int(11)
* adminid : varchar(60)
* editorialtimestamp : datetime
* editorialtext : text
* editorialtitle : varchar(100)
v DB69570 nuke_downloads_modrequest
* requestid : int(11)
* lid : int(11)
* cid : int(11)
* sid : int(11)
* title : varchar(100)
* url : varchar(100)
* description : text
* modifysubmitter : varchar(60)
* brokendownload : int(3)
* name : varchar(100)
* email : varchar(100)
* filesize : int(11)
* version : varchar(10)
* homepage : varchar(200)
v DB69570 nuke_downloads_newdownload
* lid : int(11)
* cid : int(11)
* sid : int(11)
* title : varchar(100)
* url : varchar(100)
* description : text
* name : varchar(100)
* email : varchar(100)
* submitter : varchar(60)
* filesize : int(11)
* version : varchar(10)
* homepage : varchar(200)
v DB69570 nuke_downloads_votedata
* ratingdbid : int(11)
* ratinglid : int(11)
* ratinguser : varchar(60)
* rating : int(11)
* ratinghostname : varchar(60)
* ratingcomments : text
* ratingtimestamp : datetime
v DB69570 nuke_encyclopedia
* eid : int(10)
* title : varchar(255)
* description : text
* elanguage : varchar(30)
* active : int(1)
v DB69570 nuke_encyclopedia_text
* tid : int(10)
* eid : int(10)
* title : varchar(255)
* text : text
* counter : int(10)
v DB69570 nuke_ephem
* eid : int(11)
* did : int(2)
* mid : int(2)
* yid : int(4)
* content : text
* elanguage : varchar(30)
v DB69570 nuke_events
* eid : int(10)
* aid : varchar(25)
* title : varchar(150)
* posteddate : datetime
* hometext : text
* topic : int(3)
* informant : varchar(25)
* startDate : date
* endDate : date
* startTime : time
* endTime : time
* alldayevent : int(1)
* categorie : char(2)
* activ : tinyint(1)
v DB69570 nuke_faqanswer
* id : tinyint(4)
* id_cat : tinyint(4)
* question : varchar(255)
* answer : text
v DB69570 nuke_faqcategories
* id_cat : tinyint(3)
* categories : varchar(255)
* flanguage : varchar(30)
v DB69570 nuke_headlines
* hid : int(11)
* sitename : varchar(30)
* headlinesurl : varchar(200)
v DB69570 nuke_hobby_categories
* cid : int(11)
* title : varchar(50)
* cdescription : text
* parentid : int(11)
v DB69570 nuke_hobby_editorials
* downloadid : int(11)
* adminid : varchar(60)
* editorialtimestamp : datetime
* editorialtext : text
* editorialtitle : varchar(100)
v DB69570 nuke_hobby_hobby
* lid : int(11)
* cid : int(11)
* sid : int(11)
* title : varchar(100)
* url : varchar(100)
* description : text
* date : datetime
* name : varchar(100)
* email : varchar(100)
* hits : int(11)
* submitter : varchar(60)
* downloadratingsummary : double(6,4)
* totalvotes : int(11)
* totalcomments : int(11)
* filesize : int(11)
* version : varchar(10)
* homepage : varchar(200)
v DB69570 nuke_hobby_modrequest
* requestid : int(11)
* lid : int(11)
* cid : int(11)
* sid : int(11)
* title : varchar(100)
* url : varchar(100)
* description : text
* modifysubmitter : varchar(60)
* brokendownload : int(3)
* name : varchar(100)
* email : varchar(100)
* filesize : int(11)
* version : varchar(10)
* homepage : varchar(200)
v DB69570 nuke_hobby_newdownload
* lid : int(11)
* cid : int(11)
* sid : int(11)
* title : varchar(100)
* url : varchar(100)
* description : text
* name : varchar(100)
* email : varchar(100)
* submitter : varchar(60)
* filesize : int(11)
* version : varchar(10)
* homepage : varchar(200)
v DB69570 nuke_hobby_votedata
* ratingdbid : int(11)
* ratinglid : int(11)
* ratinguser : varchar(60)
* rating : int(11)
* ratinghostname : varchar(60)
* ratingcomments : text
* ratingtimestamp : datetime
v DB69570 nuke_journal
* jid : int(11)
* aid : varchar(30)
* title : varchar(80)
* bodytext : text
* mood : varchar(48)
* pdate : varchar(48)
* ptime : varchar(48)
* status : varchar(48)
* mtime : varchar(48)
* mdate : varchar(48)
v DB69570 nuke_journal_comments
* cid : int(11)
* rid : varchar(48)
* aid : varchar(30)
* comment : text
* pdate : varchar(48)
* ptime : varchar(48)
v DB69570 nuke_journal_stats
* id : int(11)
* joid : varchar(48)
* nop : varchar(48)
* ldp : varchar(24)
* ltp : varchar(24)
* micro : varchar(128)
v DB69570 nuke_main
* main_module : varchar(255)
v DB69570 nuke_message
* mid : int(11)
* title : varchar(100)
* content : text
* date : varchar(14)
* expire : int(7)
* active : int(1)
* view : int(1)
* mlanguage : varchar(30)
v DB69570 nuke_modules
* mid : int(10)
* title : varchar(255)
* custom_title : varchar(255)
* active : int(1)
* view : int(1)
* inmenu : tinyint(1)
v DB69570 nuke_nfs_buyers
* Name : varchar(100)
* Address1 : varchar(100)
* Address2 : varchar(100)
* City : varchar(100)
* State : char(2)
* Zip : varchar(20)
* Email : varchar(100)
* DayPhone : varchar(100)
* EvePhone : varchar(100)
* Contact : int(1)
* PayMethod : varchar(100)
* CCType : varchar(100)
* CCNum : varchar(100)
* CCExpire : varchar(100)
* OrderTotal : decimal(8,2)
* Date : varchar(100)
* OrderNumber : bigint(20)
* UserID : varchar(100)
* BuyerID : bigint(20)
v DB69570 nuke_nfs_cartitems
* UserID : varchar(100)
* ItemID : varchar(25)
* ItemQuantity : int(4)
* Date : varchar(100)
* CartItemsID : bigint(20)
v DB69570 nuke_nfs_category
* catprinc : bigint(20)
* Category : varchar(100)
* CategoryID : bigint(20)
v DB69570 nuke_nfs_catprinc
* catprinc : varchar(100)
* catprincID : bigint(20)
v DB69570 nuke_nfs_critique
* critique_id : int(5)
* produit_id : int(5)
* critique_text : text
* critique_vote : int(1)
* critique_nom : text
* critique_date : int(8)
* critique_vu : int(9)
* produit_nom : text
v DB69570 nuke_nfs_devises
* cles : int(4)
* dev_nom : varchar(20)
* dev_g : varchar(10)
* dev_d : varchar(10)
* dev_act : int(1)
* dev_maitre : int(1)
* dev_taux : longtext
* dev_infos : longtext
v DB69570 nuke_nfs_items
* ItemSKU : varchar(25)
* ItemName : varchar(100)
* ItemDescription : mediumtext
* ItemCost : decimal(7,2)
* Category : bigint(20)
* ShippingCost : decimal(6,2)
* dateajout : int(8)
* ItemID : bigint(20)
* produit_vu : int(9)
* promo : int(1)
v DB69570 nuke_nfs_orders
* BuyerID : bigint(20)
* UserID : varchar(100)
* Date : varchar(100)
* OrderTotal : decimal(8,2)
* OrderNumber : bigint(20)
v DB69570 nuke_nfs_promo
* promo_id : int(5)
* produit_id : int(5)
* ancien_prix : int(20)
* nouveau_prix : int(20)
* superpromo : int(1)
* petit_txt : varchar(50)
* auto : int(1)
* debut_date : int(8)
* debut_fin : int(8)
* fin_ok : int(1)
v DB69570 nuke_nfs_receipts
* BuyerID : bigint(20)
* UserID : varchar(100)
* OrderNumber : bigint(20)
* Date : varchar(100)
* ItemID : bigint(20)
* ItemSKU : varchar(25)
* ItemName : varchar(100)
* ItemCost : decimal(7,2)
* ShippingCost : decimal(6,2)
* ItemQuantity : int(11)
* TotalCost : decimal(8,2)
* itemtaxe : text
v DB69570 nuke_nfs_users
* User : varchar(100)
* Date : int(4)
v DB69570 nuke_nukebook
* id : int(9)
* name : varchar(50)
* email : varchar(60)
* url : varchar(70)
* date : int(11)
* host : varchar(60)
* comment : text
* nukeuser : smallint(1)
v DB69570 nuke_nukebook_queue
* id : int(9)
* name : varchar(50)
* email : varchar(60)
* url : varchar(70)
* date : int(11)
* host : varchar(60)
* comment : text
* nukeuser : smallint(1)
v DB69570 nuke_optimize_gain
* gain : decimal(10,3)
v DB69570 nuke_pages
* pid : int(10)
* cid : int(10)
* title : varchar(255)
* subtitle : varchar(255)
* active : int(1)
* page_header : text
* text : text
* signature : text
* date : datetime
* counter : int(10)
* clanguage : varchar(30)
v DB69570 nuke_pages_categories
* cid : int(10)
* title : varchar(255)
* description : text
v DB69570 nuke_pollcomments
* tid : int(11)
* pid : int(11)
* pollID : int(11)
* date : datetime
* name : varchar(60)
* email : varchar(60)
* url : varchar(60)
* host_name : varchar(60)
* subject : varchar(60)
* comment : text
* score : tinyint(4)
* reason : tinyint(4)
v DB69570 nuke_poll_check
* ip : varchar(20)
* time : varchar(14)
* pollID : int(10)
v DB69570 nuke_poll_data
* pollID : int(11)
* optionText : char(50)
* optionCount : int(11)
* voteID : int(11)
v DB69570 nuke_poll_desc
* pollID : int(11)
* pollTitle : varchar(100)
* timeStamp : int(11)
* voters : mediumint(9)
* planguage : varchar(30)
* artid : int(10)
v DB69570 nuke_popsettings
* id : int(11)
* uid : int(11)
* account : varchar(50)
* popserver : varchar(255)
* port : int(5)
* uname : varchar(100)
* passwd : varchar(20)
* numshow : int(11)
* deletefromserver : char(1)
* refresh : int(11)
* timeout : int(11)
v DB69570 nuke_priv_msgs
* msg_id : int(10)
* msg_image : varchar(100)
* subject : varchar(100)
* from_userid : int(10)
* to_userid : int(10)
* msg_time : varchar(20)
* msg_text : text
* read_msg : tinyint(10)
v DB69570 nuke_public_messages
* mid : int(10)
* content : varchar(255)
* date : varchar(14)
* who : varchar(25)
v DB69570 nuke_queue
* qid : smallint(5) unsigned
* uid : mediumint(9)
* uname : varchar(40)
* subject : varchar(100)
* story : text
* storyext : text
* timestamp : datetime
* topic : varchar(20)
* alanguage : varchar(30)
v DB69570 nuke_quotes
* qid : int(10) unsigned
* quote : text
v DB69570 nuke_referer
* rid : int(11)
* url : varchar(100)
v DB69570 nuke_reviews
* id : int(10)
* date : date
* title : varchar(150)
* text : text
* reviewer : varchar(20)
* email : varchar(60)
* score : int(10)
* cover : varchar(100)
* url : varchar(100)
* url_title : varchar(50)
* hits : int(10)
* rlanguage : varchar(30)
v DB69570 nuke_reviews_add
* id : int(10)
* date : date
* title : varchar(150)
* text : text
* reviewer : varchar(20)
* email : varchar(60)
* score : int(10)
* url : varchar(100)
* url_title : varchar(50)
* rlanguage : varchar(30)
v DB69570 nuke_reviews_comments
* cid : int(10)
* rid : int(10)
* userid : varchar(25)
* date : datetime
* comments : text
* score : int(10)
v DB69570 nuke_reviews_main
* title : varchar(100)
* description : text
v DB69570 nuke_seccont
* artid : int(11)
* secid : int(11)
* title : text
* content : text
* counter : int(11)
* slanguage : varchar(30)
v DB69570 nuke_sections
* secid : int(11)
* secname : varchar(40)
* image : varchar(50)
v DB69570 nuke_session
* uname : varchar(25)
* time : varchar(14)
* host_addr : varchar(48)
* guest : int(1)
v DB69570 nuke_stats_date
* year : smallint(6)
* month : tinyint(4)
* date : tinyint(4)
* hits : bigint(20)
v DB69570 nuke_stats_hour
* year : smallint(6)
* month : tinyint(4)
* date : tinyint(4)
* hour : tinyint(4)
* hits : int(11)
v DB69570 nuke_stats_month
* year : smallint(6)
* month : tinyint(4)
* hits : bigint(20)
v DB69570 nuke_stats_year
* year : smallint(6)
* hits : bigint(20)
v DB69570 nuke_stories
* sid : int(11)
* catid : int(11)
* aid : varchar(30)
* title : varchar(80)
* time : datetime
* hometext : text
* bodytext : text
* comments : int(11)
* counter : mediumint(8) unsigned
* topic : int(3)
* informant : varchar(20)
* notes : text
* ihome : int(1)
* alanguage : varchar(30)
* acomm : int(1)
* haspoll : int(1)
* pollID : int(10)
* score : int(10)
* ratings : int(10)
* associated : text
v DB69570 nuke_stories_cat
* catid : int(11)
* title : varchar(20)
* counter : int(11)
v DB69570 nuke_topics
* topicid : int(3)
* topicname : varchar(20)
* topicimage : varchar(20)
* topictext : varchar(40)
* counter : int(11)
v DB69570 nuke_users
* user_id : int(11)
* name : varchar(60)
* username : varchar(25)
* user_email : varchar(255)
* femail : varchar(255)
* user_website : varchar(255)
* user_avatar : varchar(255)
* user_regdate : varchar(20)
* user_icq : varchar(15)
* user_occ : varchar(100)
* user_from : varchar(100)
* user_interests : varchar(150)
* user_sig : varchar(255)
* user_viewemail : tinyint(2)
* user_theme : int(3)
* user_aim : varchar(18)
* user_yim : varchar(25)
* user_msnm : varchar(25)
* user_password : varchar(40)
* storynum : tinyint(4)
* umode : varchar(10)
* uorder : tinyint(1)
* thold : tinyint(1)
* noscore : tinyint(1)
* bio : tinytext
* ublockon : tinyint(1)
* ublock : tinytext
* theme : varchar(255)
* commentmax : int(11)
* counter : int(11)
* newsletter : int(1)
* user_posts : int(10)
* user_attachsig : int(2)
* user_rank : int(10)
* user_level : int(10)
* broadcast : tinyint(1)
* popmeson : tinyint(1)
* user_active : tinyint(1)
* user_session_time : int(11)
* user_session_page : smallint(5)
* user_lastvisit : int(11)
* user_timezone : tinyint(4)
* user_style : tinyint(4)
* user_lang : varchar(255)
* user_dateformat : varchar(14)
* user_new_privmsg : smallint(5) unsigned
* user_unread_privmsg : smallint(5) unsigned
* user_last_privmsg : int(11)
* user_emailtime : int(11)
* user_allowhtml : tinyint(1)
* user_allowbbcode : tinyint(1)
* user_allowsmile : tinyint(1)
* user_allowavatar : tinyint(1)
* user_allow_pm : tinyint(1)
* user_allow_viewonline : tinyint(1)
* user_notify : tinyint(1)
* user_notify_pm : tinyint(1)
* user_popup_pm : tinyint(1)
* user_avatar_type : tinyint(4)
* user_sig_bbcode_uid : varchar(10)
* user_actkey : varchar(32)
* user_newpasswd : varchar(32)
v DB69570 nuke_users_config
* ucid : int(2)
* allowuserreg : int(1)
* sendaddmail : int(1)
* allowuserdelete : int(1)
* senddeletemail : int(1)
* allowusertheme : int(1)
* allowmailchange : int(1)
* requireadmin : int(1)
* servermail : int(1)
* useactivate : int(1)
* usegfxcheck : int(1)
* autosuspend : int(11)
* perpage : int(4)
v DB69570 nuke_users_temp
* user_id : int(10)
* username : varchar(25)
* user_email : varchar(255)
* user_password : varchar(40)
* user_regdate : varchar(20)
* check_num : varchar(50)
* time : varchar(14)
v DB69570 pma__bookmark
* id : int(10) unsigned
* dbase : varchar(255)
* user : varchar(255)
* label : varchar(255)
* query : text
v DB69570 pma__central_columns
* db_name : varchar(64)
* col_name : varchar(64)
* col_type : varchar(64)
* col_length : text
* col_collation : varchar(64)
* col_isNull : tinyint(1)
* col_extra : varchar(255)
* col_default : text
v DB69570 pma__column_info
* id : int(5) unsigned
* db_name : varchar(64)
* table_name : varchar(64)
* column_name : varchar(64)
* comment : varchar(255)
* mimetype : varchar(255)
* transformation : varchar(255)
* transformation_options : varchar(255)
* input_transformation : varchar(255)
* input_transformation_options : varchar(255)
v DB69570 pma__designer_settings
* username : varchar(64)
* settings_data : text
v DB69570 pma__export_templates
* id : int(5) unsigned
* username : varchar(64)
* export_type : varchar(10)
* template_name : varchar(64)
* template_data : text
v DB69570 pma__favorite
* username : varchar(64)
* tables : text
v DB69570 pma__history
* id : bigint(20) unsigned
* username : varchar(64)
* db : varchar(64)
* table : varchar(64)
* timevalue : timestamp
* sqlquery : text
v DB69570 pma__navigationhiding
* username : varchar(64)
* item_name : varchar(64)
* item_type : varchar(64)
* db_name : varchar(64)
* table_name : varchar(64)
v DB69570 pma__pdf_pages
* db_name : varchar(64)
* page_nr : int(10) unsigned
* page_descr : varchar(50)
v DB69570 pma__recent
* username : varchar(64)
* tables : text
v DB69570 pma__relation
* master_db : varchar(64)
* master_table : varchar(64)
* master_field : varchar(64)
* foreign_db : varchar(64)
* foreign_table : varchar(64)
* foreign_field : varchar(64)
v DB69570 pma__savedsearches
* id : int(5) unsigned
* username : varchar(64)
* db_name : varchar(64)
* search_name : varchar(64)
* search_data : text
v DB69570 pma__table_coords
* db_name : varchar(64)
* table_name : varchar(64)
* pdf_page_number : int(11)
* x : float unsigned
* y : float unsigned
v DB69570 pma__table_info
* db_name : varchar(64)
* table_name : varchar(64)
* display_field : varchar(64)
v DB69570 pma__table_uiprefs
* username : varchar(64)
* db_name : varchar(64)
* table_name : varchar(64)
* prefs : text
* last_update : timestamp
v DB69570 pma__tracking
* db_name : varchar(64)
* table_name : varchar(64)
* version : int(10) unsigned
* date_created : datetime
* date_updated : datetime
* schema_snapshot : text
* schema_sql : text
* data_sql : longtext
* tracking : set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW')
* tracking_active : int(1) unsigned
v DB69570 pma__userconfig
* username : varchar(64)
* timevalue : timestamp
* config_data : text
v DB69570 pma__usergroups
* usergroup : varchar(64)
* tab : varchar(64)
* allowed : enum('Y','N')
v DB69570 pma__users
* username : varchar(64)
* usergroup : varchar(64)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship