die user einträge bzw struktur: gibt 3 tabellen die user bezogen sind:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 | ############################################### PHPKIT Database Backup 13.02.2012 - 20:28# Database @########################################################## Table pk1__user#CREATE TABLE pk1__user ( user_id int(10) unsigned NULL auto_increment, uid varchar(32) NULL, user_name varchar(50) NULL, user_pw varchar(50) NULL, user_email varchar(255) NULL, user_emailshow tinyint(1) NULL DEFAULT '1', user_nick varchar(50) NULL, user_sex char(1) NULL, user_country char(3) NULL DEFAULT 'def', user_hpage varchar(75) NULL, user_aimid varchar(30) NULL, user_yim varchar(50) NULL, user_icqid int(12) unsigned NULL DEFAULT '0', user_sig text NULL, user_qou text NULL, user_hobby text NULL, signin int(10) unsigned NULL DEFAULT '0', lastlog int(10) unsigned NULL DEFAULT '0', logtime int(10) unsigned NULL DEFAULT '0', user_status varchar(10) NULL, user_imoption tinyint(1) NULL DEFAULT '1', user_imnotify tinyint(1) NULL DEFAULT '1', user_nloption tinyint(1) NULL DEFAULT '1', user_sigoption tinyint(1) NULL DEFAULT '1', user_groupid tinyint(3) NULL DEFAULT '0', user_avatar varchar(60) NULL, user_gbwelcome text NULL, user_activate tinyint(1) NULL DEFAULT '1', user_posts int(11) NULL DEFAULT '0', user_design int(10) unsigned NULL DEFAULT '0', user_postdelay int(6) NULL DEFAULT '0', user_bd_day tinyint(2) NULL DEFAULT '0', user_bd_month tinyint(2) NULL DEFAULT '0', user_bd_year smallint(4) NULL DEFAULT '0', user_ghost tinyint(1) NULL DEFAULT '0', user_profillock tinyint(1) NULL DEFAULT '0',PRIMARY KEY (user_id),UNIQUE user_name (user_name),UNIQUE user_nick (user_nick),UNIQUE user_email (user_email));############ Table pk1__userfields#CREATE TABLE pk1__userfields ( userid int(10) unsigned NULL DEFAULT '0', field_1 varchar(250) NULL,PRIMARY KEY (userid));############ Table pk1__usergroup#CREATE TABLE pk1__usergroup ( usergroup_id int(3) unsigned NULL auto_increment, usergroup_name varchar(50) NULL, usergroup_description text NULL, access_config tinyint(1) NULL DEFAULT '0', access_user tinyint(1) NULL DEFAULT '0', access_usergroup tinyint(1) NULL DEFAULT '0', access_userinfo tinyint(1) NULL DEFAULT '0', access_navcat tinyint(1) NULL DEFAULT '0', access_navlink tinyint(1) NULL DEFAULT '0', access_stats tinyint(1) NULL DEFAULT '0', access_refferer tinyint(1) NULL DEFAULT '0', access_avatar tinyint(1) NULL DEFAULT '0', access_adview tinyint(1) NULL DEFAULT '0', access_images tinyint(1) NULL DEFAULT '0', access_comment tinyint(1) NULL DEFAULT '0', access_smilies tinyint(1) NULL DEFAULT '0', access_style tinyint(1) NULL DEFAULT '0', access_templates tinyint(1) NULL DEFAULT '0', access_database tinyint(1) NULL DEFAULT '0', access_gbedit tinyint(1) NULL DEFAULT '0', access_gbdelete tinyint(1) NULL DEFAULT '0', access_content tinyint(1) NULL DEFAULT '0', access_article tinyint(1) NULL DEFAULT '0', access_news tinyint(1) NULL DEFAULT '0', access_links tinyint(1) NULL DEFAULT '0', access_download tinyint(1) NULL DEFAULT '0', access_contdelete tinyint(1) NULL DEFAULT '0', access_contfree tinyint(1) NULL DEFAULT '0', access_submit tinyint(1) NULL DEFAULT '0', access_contentcat tinyint(1) NULL DEFAULT '0', access_fedit tinyint(1) NULL DEFAULT '0', access_fdelete tinyint(1) NULL DEFAULT '0', access_frank tinyint(1) NULL DEFAULT '0', access_finfo tinyint(1) NULL DEFAULT '0', access_vote tinyint(1) NULL DEFAULT '0', access_faq tinyint(1) NULL DEFAULT '0', access_faqcat tinyint(1) NULL DEFAULT '0', access_turnier tinyint(1) NULL, access_turnier_dropdown tinyint(1) NULL, access_turnier_team tinyint(1) NULL, access_turnier_config tinyint(1) NULL, access_anfragen tinyint(1) NULL DEFAULT '0', access_bewerbung tinyint(1) NULL DEFAULT '0', access_clankasse tinyint(1) NULL DEFAULT '0', access_dropdown tinyint(1) NULL DEFAULT '0', access_joinfelder tinyint(1) NULL DEFAULT '0', access_email_war tinyint(1) NULL DEFAULT '0', access_map tinyint(1) NULL DEFAULT '0', access_war_field tinyint(1) NULL DEFAULT '0', access_event_edit tinyint(1) NULL, access_event_activ tinyint(1) NULL, access_event_config tinyint(1) NULL, access_ts3viewer tinyint(1) NULL, access_ts3web tinyint(1) NULL,PRIMARY KEY (usergroup_id)); |
das Forum besteht aus 6 Tabellen:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 | ############################################### PHPKIT Database Backup 13.02.2012 - 20:39# Database @########################################################## Table pk1__forumcat#CREATE TABLE pk1__forumcat ( forumcat_id int(10) unsigned NULL auto_increment, forumcat_subcat int(10) unsigned NULL DEFAULT '0', forumcat_name varchar(255) NULL, forumcat_threadcount int(10) unsigned NULL DEFAULT '0', forumcat_postcount int(10) unsigned NULL DEFAULT '0', forumcat_lastreply_time int(10) unsigned NULL DEFAULT '0', forumcat_lastreply_autor varchar(255) NULL, forumcat_lastreply_autorid int(10) unsigned NULL DEFAULT '0', forumcat_order tinyint(2) NULL DEFAULT '1', forumcat_level tinyint(2) unsigned NULL DEFAULT '1', forumcat_description text NULL, forumcat_description_show int(1) unsigned NULL DEFAULT '1', forumcat_status tinyint(1) NULL DEFAULT '1', forumcat_replys int(10) unsigned NULL DEFAULT '15', forumcat_views int(10) unsigned NULL DEFAULT '100', forumcat_posts tinyint(2) unsigned NULL DEFAULT '12', forumcat_threads tinyint(2) unsigned NULL DEFAULT '12', forumcat_threads_option tinyint(1) NULL DEFAULT '1', forumcat_rrights varchar(10) NULL DEFAULT 'guest', forumcat_wrights varchar(10) NULL DEFAULT 'guest', forumcat_trights varchar(10) NULL DEFAULT 'guest', forumcat_option tinyint(1) NULL DEFAULT '1', forumcat_lastreply_threadid int(10) unsigned NULL DEFAULT '0', forumcat_mods text NULL, forumcat_user text NULL,PRIMARY KEY (forumcat_id),KEY forumcat_rrights (forumcat_rrights),KEY forumcat_order (forumcat_order));############ Table pk1__forumfav#CREATE TABLE pk1__forumfav ( forumfav_userid int(10) unsigned NULL DEFAULT '0', forumfav_threadid int(10) unsigned NULL DEFAULT '0',PRIMARY KEY (forumfav_userid, forumfav_threadid));############ Table pk1__foruminfo#CREATE TABLE pk1__foruminfo ( foruminfo_id int(10) unsigned NULL auto_increment, foruminfo_title text NULL, foruminfo_text text NULL, foruminfo_time int(10) unsigned NULL DEFAULT '0', foruminfo_expire int(10) unsigned NULL DEFAULT '0', foruminfo_catids text NULL, foruminfo_autorid int(10) unsigned NULL DEFAULT '0',PRIMARY KEY (foruminfo_id));############ Table pk1__forumnotify#CREATE TABLE pk1__forumnotify ( forumnotify_userid int(10) unsigned NULL DEFAULT '0', forumnotify_email varchar(255) NULL, forumnotify_threadid int(10) unsigned NULL DEFAULT '0',PRIMARY KEY (forumnotify_email, forumnotify_userid, forumnotify_threadid));############ Table pk1__forumpost#CREATE TABLE pk1__forumpost ( forumpost_id int(10) unsigned NULL auto_increment, forumpost_threadid int(10) unsigned NULL DEFAULT '0', forumpost_title varchar(255) NULL, forumpost_autor varchar(60) NULL, forumpost_autorid int(10) unsigned NULL DEFAULT '0', forumpost_time int(10) unsigned NULL DEFAULT '0', forumpost_text text NULL, forumpost_uid varchar(32) NULL, forumpost_icon varchar(255) NULL, forumpost_smilies tinyint(1) NULL DEFAULT '1', forumpost_bbcode tinyint(1) NULL DEFAULT '1', forumpost_editcount tinyint(3) unsigned NULL DEFAULT '0', forumpost_edittime int(10) unsigned NULL DEFAULT '0', forumpost_editautor varchar(255) NULL, forumpost_ipaddr varchar(15) NULL, forumpost_reply int(10) unsigned NULL DEFAULT '0',PRIMARY KEY (forumpost_id),KEY forumpost_threadid (forumpost_threadid),KEY forumpost_autorid (forumpost_autorid));############ Table pk1__forumrank#CREATE TABLE pk1__forumrank ( forumrank_id int(10) unsigned NULL auto_increment, forumrank_post int(10) unsigned NULL DEFAULT '0', forumrank_title text NULL,PRIMARY KEY (forumrank_id),UNIQUE forumrank_post (forumrank_post));############ Table pk1__forumthread#CREATE TABLE pk1__forumthread ( forumthread_id int(10) unsigned NULL auto_increment, forumthread_catid int(10) unsigned NULL DEFAULT '0', forumthread_status tinyint(1) NULL DEFAULT '1', forumthread_replycount int(10) unsigned NULL DEFAULT '0', forumthread_viewcount int(10) unsigned NULL DEFAULT '0', forumthread_lastreply_time int(10) unsigned NULL DEFAULT '0', forumthread_lastreply_autor varchar(255) NULL, forumthread_lastreply_autorid int(10) unsigned NULL DEFAULT '0', forumthread_uid varchar(32) NULL, forumthread_title varchar(255) NULL, forumthread_icon varchar(255) NULL, forumthread_autor varchar(255) NULL, forumthread_autorid int(10) unsigned NULL DEFAULT '0',PRIMARY KEY (forumthread_id),KEY forumthread_catid (forumthread_catid),KEY forumthread_autorid (forumthread_autorid));############ Table pk1__forumthreadreaded#CREATE TABLE pk1__forumthreadreaded ( sid varchar(32) NULL, threadid int(10) unsigned NULL DEFAULT '0', rtime int(10) unsigned NULL DEFAULT '0',PRIMARY KEY (sid, threadid)); |
kann man die einträge irgendwie in ilch importieren?
Zuletzt modifiziert von Avataras am 13.02.2012 - 20:52:49
