Xoops - (データベース定義)

2012-02-13, xoops_database

/tips/linux/xoops_database $$作成日時：2006-04-19 11:31:35.959

データベース: MySQL 4.1.16 ドライバ: MySQL-AB JDBC Driver mysql-connector-java-3.0.16-ga ( $Date: 2004/09/30 07:35:03 $, $Revision: 1.27.2.44 $ ) ドライバクラス: org.gjt.mm.mysql.Driver URL: jdbc:mysql://amu-supsup.com/amu_supsup_com 接続ユーザ: root@219.117.203.41

**xoops_analyzer2_data :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,ip,varchar,○,○,, ,time,int,○,○,, ,mods,varchar,○,○,, ,ref,varchar,,,, ,ua,varchar,,,, ,user,varchar,,,, ,analysis,tinyint,,○,, ,date,int,○,○,, ,jikan,int,,,, ,searchtext,varchar,,,, ,searcheng,varchar,,,, ,host,varchar,,,, ,browser,varchar,,,, ,os,varchar,,,, ,crawl,varchar,,,,

**xoops_analyzer2_noip :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,ip,varchar,○,○,,

**xoops_avatar :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,avatar_id,mediumint unsigned,○,○,, ,avatar_file,varchar,,○,, ,avatar_name,varchar,,○,, ,avatar_mimetype,varchar,,○,, ,avatar_created,int,,○,, ,avatar_display,tinyint unsigned,,○,, ,avatar_weight,smallint unsigned,,○,, ,avatar_type,char,,○,,

**xoops_avatar_user_link :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,avatar_id,mediumint unsigned,,○,, ,user_id,mediumint unsigned,,○,,

**xoops_banner :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,bid,smallint unsigned,○,○,, ,cid,tinyint unsigned,,○,, ,imptotal,mediumint unsigned,,○,, ,impmade,mediumint unsigned,,○,, ,clicks,mediumint unsigned,,○,, ,imageurl,varchar,,○,, ,clickurl,varchar,,○,, ,date,int,,○,, ,htmlbanner,tinyint,,○,, ,htmlcode,text,,○,,

**xoops_bannerclient :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,cid,smallint unsigned,○,○,, ,name,varchar,,○,, ,contact,varchar,,○,, ,email,varchar,,○,, ,login,varchar,,○,, ,passwd,varchar,,○,, ,extrainfo,text,,○,,

**xoops_bannerfinish :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,bid,smallint unsigned,○,○,, ,cid,smallint unsigned,,○,, ,impressions,mediumint unsigned,,○,, ,clicks,mediumint unsigned,,○,, ,datestart,int unsigned,,○,, ,dateend,int unsigned,,○,,

**xoops_bb_categories :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,cat_id,smallint unsigned,○,○,, ,cat_title,varchar,,○,, ,cat_order,varchar,,,,

**xoops_bb_forum_access :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,forum_id,int unsigned,○,○,, ,user_id,int unsigned,○,○,, ,can_post,tinyint,,○,,

**xoops_bb_forum_mods :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,forum_id,int unsigned,,○,, ,user_id,int unsigned,,○,,

**xoops_bb_forums :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,forum_id,int unsigned,○,○,, ,forum_name,varchar,,○,, ,forum_desc,text,,,, ,forum_access,tinyint,,○,, ,forum_moderator,int,,,, ,forum_topics,int,,○,, ,forum_posts,int,,○,, ,forum_last_post_id,int unsigned,,○,, ,cat_id,int,,○,, ,forum_type,int,,,, ,allow_html,enum,,○,, ,allow_sig,enum,,○,, ,posts_per_page,tinyint unsigned,,○,, ,hot_threshold,tinyint unsigned,,○,, ,topics_per_page,tinyint unsigned,,○,,

**xoops_bb_posts :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,post_id,int unsigned,○,○,, ,pid,int,,○,, ,topic_id,int,,○,, ,forum_id,int,,○,, ,post_time,int,,○,, ,uid,int unsigned,,○,, ,poster_ip,varchar,,○,, ,subject,varchar,,○,, ,nohtml,tinyint,,○,, ,nosmiley,tinyint,,○,, ,icon,varchar,,○,, ,attachsig,tinyint,,○,,

**xoops_bb_posts_text :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,post_id,int unsigned,○,○,, ,post_text,text,,,,

**xoops_bb_topics :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,topic_id,int unsigned,○,○,, ,topic_title,varchar,,,, ,topic_poster,int,,○,, ,topic_time,int,,○,, ,topic_views,int,,○,, ,topic_replies,int,,○,, ,topic_last_post_id,int unsigned,,○,, ,forum_id,int,,○,, ,topic_status,tinyint,,○,, ,topic_sticky,tinyint,,○,,

**xoops_block_module_link :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,block_id,mediumint unsigned,,○,, ,module_id,smallint,,○,,

**xoops_config :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,conf_id,smallint unsigned,○,○,, ,conf_modid,smallint unsigned,,○,, ,conf_catid,smallint unsigned,,○,, ,conf_name,varchar,,○,, ,conf_title,varchar,,○,, ,conf_value,text,,○,, ,conf_desc,varchar,,○,, ,conf_formtype,varchar,,○,, ,conf_valuetype,varchar,,○,, ,conf_order,smallint unsigned,,○,,

**xoops_configcategory :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,confcat_id,smallint unsigned,○,○,, ,confcat_name,varchar,,○,, ,confcat_order,smallint unsigned,,○,,

**xoops_configoption :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,confop_id,mediumint unsigned,○,○,, ,confop_name,varchar,,○,, ,confop_value,varchar,,○,, ,conf_id,smallint unsigned,,○,,

**xoops_group_permission :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,gperm_id,int unsigned,○,○,, ,gperm_groupid,smallint unsigned,,○,, ,gperm_itemid,mediumint unsigned,,○,, ,gperm_modid,mediumint unsigned,,○,, ,gperm_name,varchar,,○,,

**xoops_groups :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,groupid,smallint unsigned,○,○,, ,name,varchar,,○,, ,description,text,,○,, ,group_type,varchar,,○,,

**xoops_groups_users_link :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,linkid,mediumint unsigned,○,○,, ,groupid,smallint unsigned,,○,, ,uid,mediumint unsigned,,○,,

**xoops_image :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,image_id,mediumint unsigned,○,○,, ,image_name,varchar,,○,, ,image_nicename,varchar,,○,, ,image_mimetype,varchar,,○,, ,image_created,int unsigned,,○,, ,image_display,tinyint unsigned,,○,, ,image_weight,smallint unsigned,,○,, ,imgcat_id,smallint unsigned,,○,,

**xoops_imagebody :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,image_id,mediumint unsigned,,○,, ,image_body,mediumblob,,,,

**xoops_imagecategory :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,imgcat_id,smallint unsigned,○,○,, ,imgcat_name,varchar,,○,, ,imgcat_maxsize,int unsigned,,○,, ,imgcat_maxwidth,smallint unsigned,,○,, ,imgcat_maxheight,smallint unsigned,,○,, ,imgcat_display,tinyint unsigned,,○,, ,imgcat_weight,smallint unsigned,,○,, ,imgcat_type,char,,○,, ,imgcat_storetype,varchar,,○,,

**xoops_imgset :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,imgset_id,smallint unsigned,○,○,, ,imgset_name,varchar,,○,, ,imgset_refid,mediumint unsigned,,○,,

**xoops_imgset_tplset_link :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,imgset_id,smallint unsigned,,○,, ,tplset_name,varchar,,○,,

**xoops_imgsetimg :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,imgsetimg_id,mediumint unsigned,○,○,, ,imgsetimg_file,varchar,,○,, ,imgsetimg_body,blob,,○,, ,imgsetimg_imgset,smallint unsigned,,○,,

**xoops_modules :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,mid,smallint unsigned,○,○,, ,name,varchar,,○,, ,version,smallint unsigned,,○,, ,last_update,int unsigned,,○,, ,weight,smallint unsigned,,○,, ,isactive,tinyint unsigned,,○,, ,dirname,varchar,,○,, ,hasmain,tinyint unsigned,,○,, ,hasadmin,tinyint unsigned,,○,, ,hassearch,tinyint unsigned,,○,, ,hasconfig,tinyint unsigned,,○,, ,hascomments,tinyint unsigned,,○,, ,hasnotification,tinyint unsigned,,○,,

**xoops_multimenu01 :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,id,int unsigned,○,○,, ,title,varchar,,○,, ,hide,tinyint unsigned,,○,, ,link,varchar,,,, ,weight,tinyint unsigned,,○,, ,target,varchar,,,, ,groups,varchar,,,,

**xoops_multimenu02 :TABLE

**xoops_multimenu03 :TABLE

**xoops_multimenu04 :TABLE

**xoops_multimenu05 :TABLE

**xoops_multimenu06 :TABLE

**xoops_multimenu07 :TABLE

**xoops_multimenu08 :TABLE

**xoops_myalbum_cat :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,cid,int unsigned,○,○,, ,pid,int unsigned,,○,, ,title,varchar,,○,, ,imgurl,varchar,,○,,

**xoops_myalbum_photos :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,lid,int unsigned,○,○,, ,cid,int unsigned,,○,, ,title,varchar,,○,, ,ext,varchar,,○,, ,res_x,int,,○,, ,res_y,int,,○,, ,submitter,int unsigned,,○,, ,status,tinyint,,○,, ,date,int,,○,, ,hits,int unsigned,,○,, ,rating,double,,○,, ,votes,int unsigned,,○,, ,comments,int unsigned,,○,,

**xoops_myalbum_text :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,lid,int unsigned,,○,, ,description,text,,○,,

**xoops_myalbum_votedata :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,ratingid,int unsigned,○,○,, ,lid,int unsigned,,○,, ,ratinguser,int unsigned,,○,, ,rating,tinyint unsigned,,○,, ,ratinghostname,varchar,,○,, ,ratingtimestamp,int,,○,,

**xoops_mylinks_broken :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,reportid,int,○,○,, ,lid,int unsigned,,○,, ,sender,int unsigned,,○,, ,ip,varchar,,○,,

**xoops_mylinks_cat :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,cid,int unsigned,○,○,, ,pid,int unsigned,,○,, ,title,varchar,,○,, ,imgurl,varchar,,○,,

**xoops_mylinks_links :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,lid,int unsigned,○,○,, ,cid,int unsigned,,○,, ,title,varchar,,○,, ,url,varchar,,○,, ,logourl,varchar,,○,, ,submitter,int unsigned,,○,, ,status,tinyint,,○,, ,date,int,,○,, ,hits,int unsigned,,○,, ,rating,double,,○,, ,votes,int unsigned,,○,, ,comments,int unsigned,,○,,

**xoops_mylinks_mod :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,requestid,int unsigned,○,○,, ,lid,int unsigned,,○,, ,cid,int unsigned,,○,, ,title,varchar,,○,, ,url,varchar,,○,, ,logourl,varchar,,○,, ,description,text,,○,, ,modifysubmitter,int unsigned,,○,,

**xoops_mylinks_text :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,lid,int unsigned,,○,, ,description,text,,○,,

**xoops_mylinks_votedata :TABLE

**xoops_newblocks :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,bid,mediumint unsigned,○,○,, ,mid,smallint unsigned,,○,, ,func_num,tinyint unsigned,,○,, ,options,varchar,,○,, ,name,varchar,,○,, ,title,varchar,,○,, ,content,text,,○,, ,side,tinyint unsigned,,○,, ,weight,smallint unsigned,,○,, ,visible,tinyint unsigned,,○,, ,block_type,char,,○,, ,c_type,char,,○,, ,isactive,tinyint unsigned,,○,, ,dirname,varchar,,○,, ,func_file,varchar,,○,, ,show_func,varchar,,○,, ,edit_func,varchar,,○,, ,template,varchar,,○,, ,bcachetime,int unsigned,,○,, ,last_modified,int unsigned,,○,,

**xoops_online :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,online_uid,mediumint unsigned,,○,, ,online_uname,varchar,,○,, ,online_updated,int unsigned,,○,, ,online_module,smallint unsigned,,○,, ,online_ip,varchar,,○,,

**xoops_popnupblog :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,postid,int unsigned,○,○,, ,uid,int unsigned,,○,, ,blogid,int unsigned,,○,, ,blog_date,datetime,,○,, ,title,varchar,,,, ,post_text,text,,,, ,last_update,timestamp,,,, ,votes_yes,int unsigned,,○,, ,votes_no,int unsigned,,○,,

**xoops_popnupblog_application :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,uid,int unsigned,○,○,, ,groupid,smallint unsigned,,○,, ,cat_id,smallint unsigned,,○,, ,title,varchar,,,, ,blog_desc,text,,,, ,permission,smallint unsigned,,○,, ,group_read,varchar,,,, ,group_comment,varchar,,,, ,group_vote,varchar,,,, ,create_date,timestamp,,,, ,email,varchar,,,, ,emailalias,varchar,,,,

**xoops_popnupblog_categories :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,cat_id,smallint unsigned,○,○,, ,cat_title,varchar,,○,, ,cat_order,varchar,,,,

**xoops_popnupblog_comment :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,blogid,int unsigned,,○,, ,postid,int unsigned,,○,, ,blog_date,datetime,,○,, ,comment_id,int unsigned,○,○,, ,comment_uid,int unsigned,,○,, ,comment_name,varchar,,,, ,post_text,text,,,, ,create_date,datetime,,○,, ,vote,tinyint,,○,,

**xoops_popnupblog_emailalias :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,blogid,int unsigned,○,○,, ,public,tinyint,○,○,, ,email,varchar,○,○,, ,uid,int unsigned,,○,,

**xoops_popnupblog_info :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,blogid,int unsigned,○,○,, ,uid,int unsigned,,○,, ,groupid,smallint unsigned,,○,, ,cat_id,smallint unsigned,,○,, ,title,varchar,,,, ,blog_desc,text,,,, ,blog_permission,smallint unsigned,,○,, ,group_read,varchar,,,, ,group_comment,varchar,,,, ,group_vote,varchar,,,, ,last_update,datetime,,○,, ,email,varchar,,,, ,plugin,varchar,,,,

**xoops_popnupblog_trackback :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,blogid,int unsigned,,○,, ,postid,int unsigned,,○,, ,t_date,datetime,,○,, ,count,int unsigned,,,, ,title,varchar,,,, ,url,text,,,,

**xoops_priv_msgs :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,msg_id,mediumint unsigned,○,○,, ,msg_image,varchar,,,, ,subject,varchar,,○,, ,from_userid,mediumint unsigned,,○,, ,to_userid,mediumint unsigned,,○,, ,msg_time,int unsigned,,○,, ,msg_text,text,,○,, ,read_msg,tinyint unsigned,,○,,

**xoops_protector_access :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,ip,varchar,,○,, ,request_uri,varchar,,○,, ,malicious_actions,varchar,,○,, ,expire,int,,○,,

**xoops_protector_log :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,lid,mediumint unsigned,○,○,, ,uid,mediumint unsigned,,○,, ,ip,varchar,,○,, ,type,varchar,,○,, ,agent,varchar,,○,, ,description,text,,○,, ,extra,text,,○,, ,timestamp,timestamp,,,,

**xoops_ranks :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,rank_id,smallint unsigned,○,○,, ,rank_title,varchar,,○,, ,rank_min,mediumint unsigned,,○,, ,rank_max,mediumint unsigned,,○,, ,rank_special,tinyint unsigned,,○,, ,rank_image,varchar,,,,

**xoops_search :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,mid,int,,○,, ,notshow,tinyint,,○,,

**xoops_session :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,sess_id,varchar,○,○,, ,sess_updated,int unsigned,,○,, ,sess_ip,varchar,,○,, ,sess_data,text,,○,,

**xoops_smiles :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,id,smallint unsigned,○,○,, ,code,varchar,,○,, ,smile_url,varchar,,○,, ,emotion,varchar,,○,, ,display,tinyint,,○,,

**xoops_stories :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,storyid,int unsigned,○,○,, ,uid,int unsigned,,○,, ,title,varchar,,○,, ,created,int unsigned,,○,, ,published,int unsigned,,○,, ,expired,int unsigned,,○,, ,hostname,varchar,,○,, ,nohtml,tinyint,,○,, ,nosmiley,tinyint,,○,, ,hometext,text,,○,, ,bodytext,text,,○,, ,counter,int unsigned,,○,, ,topicid,smallint unsigned,,○,, ,ihome,tinyint,,○,, ,notifypub,tinyint,,○,, ,story_type,varchar,,○,, ,topicdisplay,tinyint,,○,, ,topicalign,char,,○,, ,comments,smallint unsigned,,○,,

**xoops_tinycontent :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,storyid,int,○,○,, ,blockid,int unsigned,,○,, ,title,varchar,,○,, ,text,text,,,, ,visible,tinyint,,○,, ,homepage,tinyint,,○,, ,nohtml,tinyint,,○,, ,nosmiley,tinyint,,○,, ,nobreaks,tinyint,,○,, ,nocomments,tinyint,,○,, ,link,tinyint,,○,, ,address,varchar,,,, ,submenu,tinyint,,○,, ,last_modified,timestamp,,,, ,created,datetime,,○,, ,html_header,text,,,,

**xoops_tinycontent1 :TABLE

**xoops_tinycontent2 :TABLE

**xoops_topics :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,topic_id,smallint unsigned,○,○,, ,topic_pid,smallint unsigned,,○,, ,topic_imgurl,varchar,,○,, ,topic_title,varchar,,○,,

**xoops_tplfile :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,tpl_id,mediumint unsigned,○,○,, ,tpl_refid,smallint unsigned,,○,, ,tpl_module,varchar,,○,, ,tpl_tplset,varchar,,○,, ,tpl_file,varchar,,○,, ,tpl_desc,varchar,,○,, ,tpl_lastmodified,int unsigned,,○,, ,tpl_lastimported,int unsigned,,○,, ,tpl_type,varchar,,○,,

**xoops_tplset :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,tplset_id,int unsigned,○,○,, ,tplset_name,varchar,,○,, ,tplset_desc,varchar,,○,, ,tplset_credits,text,,○,, ,tplset_created,int unsigned,,○,,

**xoops_tplsource :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,tpl_id,mediumint unsigned,,○,, ,tpl_source,mediumtext,,○,,

**xoops_users :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,uid,mediumint unsigned,○,○,, ,name,varchar,,○,, ,uname,varchar,,○,, ,email,varchar,,○,, ,url,varchar,,○,, ,user_avatar,varchar,,○,, ,user_regdate,int unsigned,,○,, ,user_icq,varchar,,○,, ,user_from,varchar,,○,, ,user_sig,tinytext,,○,, ,user_viewemail,tinyint unsigned,,○,, ,actkey,varchar,,○,, ,user_aim,varchar,,○,, ,user_yim,varchar,,○,, ,user_msnm,varchar,,○,, ,pass,varchar,,○,, ,posts,mediumint unsigned,,○,, ,attachsig,tinyint unsigned,,○,, ,rank,smallint unsigned,,○,, ,level,tinyint unsigned,,○,, ,theme,varchar,,○,, ,timezone_offset,float,,○,, ,last_login,int unsigned,,○,, ,umode,varchar,,○,, ,uorder,tinyint unsigned,,○,, ,notify_method,tinyint,,○,, ,notify_mode,tinyint,,○,, ,user_occ,varchar,,○,, ,bio,tinytext,,○,, ,user_intrest,varchar,,○,, ,user_mailok,tinyint unsigned,,○,,

**xoops_weblog :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,blog_id,mediumint,○,○,, ,user_id,mediumint,,○,, ,cat_id,int unsigned,,○,, ,created,int,,○,, ,title,varchar,,○,, ,contents,text,,○,, ,private,char,,○,, ,comments,int,,○,, ,reads,int,,○,, ,trackbacks,int,,○,, ,description,text,,○,, ,dohtml,tinyint unsigned,,○,, ,dobr,tinyint unsigned,,○,, ,permission_group,varchar,,○,,

**xoops_weblog_category :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,cat_id,int unsigned,○,○,, ,cat_pid,int unsigned,,○,, ,cat_title,varchar,,○,, ,cat_description,text,,○,, ,cat_created,int,,○,, ,cat_imgurl,varchar,,○,,

**xoops_weblog_priv :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,priv_id,smallint unsigned,○,○,, ,priv_gid,smallint unsigned,,○,,

**xoops_weblog_trackback :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,blog_id,mediumint,○,○,, ,tb_url,text,○,○,, ,blog_name,varchar,,○,, ,title,varchar,,○,, ,description,text,,○,, ,link,text,,○,, ,direction,enum,○,○,, ,trackback_created,int,,○,,

**xoops_weblogmyalbum_photos :TABLE

**xoops_whatsnew_config :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,id,smallint unsigned,○,○,, ,conf_id,smallint unsigned,,○,, ,conf_name,varchar,,○,, ,conf_value,text,,○,, ,aux_int_1,int,,,, ,aux_int_2,int,,,, ,aux_text_1,varchar,,,, ,aux_text_2,varchar,,,,

**xoops_whatsnew_module :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,id,smallint unsigned,○,○,, ,mid,int unsigned,,○,, ,dirname,varchar,,○,, ,block_show,tinyint unsigned,,○,, ,block_limit,int unsigned,,○,, ,rss_show,tinyint unsigned,,○,, ,rss_limit,int unsigned,,○,, ,block_icon,varchar,,,, ,aux_int_1,int,,,, ,aux_int_2,int,,,, ,aux_text_1,varchar,,,, ,aux_text_2,varchar,,,,

**xoops_xoopscomments :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,com_id,mediumint unsigned,○,○,, ,com_pid,mediumint unsigned,,○,, ,com_rootid,mediumint unsigned,,○,, ,com_modid,smallint unsigned,,○,, ,com_itemid,mediumint unsigned,,○,, ,com_icon,varchar,,○,, ,com_created,int unsigned,,○,, ,com_modified,int unsigned,,○,, ,com_uid,mediumint unsigned,,○,, ,com_ip,varchar,,○,, ,com_title,varchar,,○,, ,com_text,text,,○,, ,com_sig,tinyint unsigned,,○,, ,com_status,tinyint unsigned,,○,, ,com_exparams,varchar,,○,, ,dohtml,tinyint unsigned,,○,, ,dosmiley,tinyint unsigned,,○,, ,doxcode,tinyint unsigned,,○,, ,doimage,tinyint unsigned,,○,, ,dobr,tinyint unsigned,,○,,

**xoops_xoopsfaq_categories :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,category_id,tinyint unsigned,○,○,, ,category_title,varchar,,○,, ,category_order,tinyint unsigned,,○,,

**xoops_xoopsfaq_contents :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,contents_id,smallint unsigned,○,○,, ,category_id,tinyint unsigned,,○,, ,contents_title,varchar,,○,, ,contents_contents,text,,○,, ,contents_time,int unsigned,,○,, ,contents_order,smallint unsigned,,○,, ,contents_visible,tinyint unsigned,,○,, ,contents_nohtml,tinyint unsigned,,○,, ,contents_nosmiley,tinyint unsigned,,○,, ,contents_noxcode,tinyint unsigned,,○,,

**xoops_xoopsnotifications :TABLE

,*列名,*型,*PK,*NULL禁止,*FK,*説明 ,not_id,mediumint unsigned,○,○,, ,not_modid,smallint unsigned,,○,, ,not_itemid,mediumint unsigned,,○,, ,not_category,varchar,,○,, ,not_event,varchar,,○,, ,not_uid,mediumint unsigned,,○,, ,not_mode,tinyint,,○,,

タグ別一覧: [xoops_database]
チップス一覧

この記事は役に立ちましたか？