AL/test/commonal_cppunit.sqlite

-- phpMyAdmin SQL Dump
-- version 2.5.7-pl1
-- http://www.phpmyadmin.net
--
-- ???鴻??: localhost
-- 篏?????????: 2004綛 12?? 17? 20:14
-- ?泣?若???若?????若?吾?с?? 4.0.21
-- PHP ???若?吾?с?? 4.3.8
-- 
-- ???若?帥???若?? youi_xoops
-- 

-- --------------------------------------------------------

--
-- ???若????????? x_avatar
--

DROP TABLE xtest_avatar;

CREATE TABLE xtest_avatar (
  avatar_id INTEGER PRIMARY KEY AUTOINCREMENT,
  avatar_file TEXT(30) NOT NULL default '',
  avatar_name TEXT(100) NOT NULL default '',
  avatar_mimetype TEXT(30) NOT NULL default '',
  avatar_created INTEGER(10) NOT NULL default '0',
  avatar_display INTEGER(1)  NOT NULL default '0',
  avatar_weight INTEGER(5)  NOT NULL default '0',
  avatar_type TEXT(1) NOT NULL default ''
);

CREATE INDEX avatar_type ON xtest_avatar (avatar_type,avatar_display);


-- --------------------------------------------------------

--
-- ???若????????? x_avatar_user_link
--

DROP TABLE xtest_avatar_user_link;

CREATE TABLE xtest_avatar_user_link (
  avatar_id INTEGER(8)  NOT NULL default '0',
  user_id INTEGER(8)  NOT NULL default '0'
);

CREATE INDEX avatar_user_id ON xtest_avatar_user_link (avatar_id,user_id);


-- --------------------------------------------------------

--
-- ???若????????? x_banner
--

DROP TABLE xtest_banner;

CREATE TABLE xtest_banner (
  bid INTEGER PRIMARY KEY AUTOINCREMENT,
  cid INTEGER(3)  NOT NULL default '0',
  imptotal INTEGER(8)  NOT NULL default '0',
  impmade INTEGER(8)  NOT NULL default '0',
  clicks INTEGER(8)  NOT NULL default '0',
  imageurl TEXT(255) NOT NULL default '',
  clickurl TEXT(255) NOT NULL default '',
  date INTEGER(10) NOT NULL default '0',
  htmlbanner INTEGER(1) NOT NULL default '0',
  htmlcode TEXT NOT NULL
);

CREATE INDEX idxbannercid ON xtest_banner (cid);

CREATE INDEX idxbannerbidcid ON xtest_banner (bid,cid);


-- --------------------------------------------------------

--
-- ???若????????? x_bannerclient
--

DROP TABLE xtest_bannerclient;

CREATE TABLE xtest_bannerclient (
  cid INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT(60) NOT NULL default '',
  contact TEXT(60) NOT NULL default '',
  email TEXT(60) NOT NULL default '',
  login TEXT(10) NOT NULL default '',
  passwd TEXT(10) NOT NULL default '',
  extrainfo TEXT NOT NULL
);

CREATE INDEX login ON xtest_bannerclient (login);


-- --------------------------------------------------------

--
-- ???若????????? x_bannerfinish
--

DROP TABLE xtest_bannerfinish;

CREATE TABLE xtest_bannerfinish (
  bid INTEGER PRIMARY KEY AUTOINCREMENT,
  cid INTEGER(5)  NOT NULL default '0',
  impressions INTEGER(8)  NOT NULL default '0',
  clicks INTEGER(8)  NOT NULL default '0',
  datestart INTEGER(10)  NOT NULL default '0',
  dateend INTEGER(10)  NOT NULL default '0'
);

CREATE INDEX cid ON xtest_bannerfinish (cid);


-- --------------------------------------------------------

--
-- ???若????????? x_block_module_link
--

DROP TABLE xtest_block_module_link;

CREATE TABLE xtest_block_module_link (
  block_id INTEGER(8)  NOT NULL default '0',
  module_id INTEGER(5) NOT NULL default '0'
);

CREATE INDEX module_id ON xtest_block_module_link (module_id);

CREATE INDEX block_id ON xtest_block_module_link (block_id);


-- --------------------------------------------------------

--
-- ???若????????? x_config
--

DROP TABLE xtest_config;

CREATE TABLE xtest_config (
  conf_id INTEGER PRIMARY KEY AUTOINCREMENT,
  conf_modid INTEGER(5)  NOT NULL default '0',
  conf_catid INTEGER(5)  NOT NULL default '0',
  conf_name TEXT(25) NOT NULL default '',
  conf_title TEXT(30) NOT NULL default '',
  conf_value TEXT NOT NULL,
  conf_desc TEXT(30) NOT NULL default '',
  conf_formtype TEXT(15) NOT NULL default '',
  conf_valuetype TEXT(10) NOT NULL default '',
  conf_order INTEGER(5)  NOT NULL default '0'
);

CREATE INDEX conf_mod_cat_id ON xtest_config (conf_modid,conf_catid);


-- --------------------------------------------------------

--
-- ???若????????? x_configcategory
--

DROP TABLE xtest_configcategory;

CREATE TABLE xtest_configcategory (
  confcat_id INTEGER PRIMARY KEY AUTOINCREMENT,
  confcat_name TEXT(25) NOT NULL default '',
  confcat_order INTEGER(5)  NOT NULL default '0'
);


-- --------------------------------------------------------

--
-- ???若????????? x_configoption
--

DROP TABLE xtest_configoption;

CREATE TABLE xtest_configoption (
  confop_id INTEGER PRIMARY KEY AUTOINCREMENT,
  confop_name TEXT(255) NOT NULL default '',
  confop_value TEXT(255) NOT NULL default '',
  conf_id INTEGER(5)  NOT NULL default '0'
);

CREATE INDEX conf_id ON xtest_configoption (conf_id);


-- --------------------------------------------------------

--
-- ???若????????? x_group_permission
--

DROP TABLE xtest_group_permission;

CREATE TABLE xtest_group_permission (
  gperm_id INTEGER PRIMARY KEY AUTOINCREMENT,
  gperm_groupid INTEGER(5)  NOT NULL default '0',
  gperm_itemid INTEGER(8)  NOT NULL default '0',
  gperm_modid INTEGER(5)  NOT NULL default '0',
  gperm_name TEXT(50) NOT NULL default ''
);

CREATE INDEX groupid ON xtest_group_permission (gperm_groupid);

CREATE INDEX itemid ON xtest_group_permission (gperm_itemid);

CREATE INDEX gperm_modid ON xtest_group_permission (gperm_modid,gperm_name);


-- --------------------------------------------------------

--
-- ???若????????? x_groups
--

DROP TABLE xtest_groups;

CREATE TABLE xtest_groups (
  groupid INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT(50) NOT NULL default '',
  description TEXT NOT NULL,
  group_type TEXT(10) NOT NULL default ''
);

CREATE INDEX group_type ON xtest_groups (group_type);


-- --------------------------------------------------------

--
-- ???若????????? x_groups_users_link
--

DROP TABLE xtest_groups_users_link;

CREATE TABLE xtest_groups_users_link (
  linkid INTEGER PRIMARY KEY AUTOINCREMENT,
  groupid INTEGER(5)  NOT NULL default '0',
  uid INTEGER(8)  NOT NULL default '0'
);

CREATE INDEX groupid_uid ON xtest_groups_users_link (groupid,uid);


-- --------------------------------------------------------

--
-- ???若????????? x_image
--

DROP TABLE xtest_image;

CREATE TABLE xtest_image (
  image_id INTEGER PRIMARY KEY AUTOINCREMENT,
  image_name TEXT(30) NOT NULL default '',
  image_nicename TEXT(255) NOT NULL default '',
  image_mimetype TEXT(30) NOT NULL default '',
  image_created INTEGER(10)  NOT NULL default '0',
  image_display INTEGER(1)  NOT NULL default '0',
  image_weight INTEGER(5)  NOT NULL default '0',
  imgcat_id INTEGER(5)  NOT NULL default '0'
);

CREATE INDEX imgcat_id ON  xtest_image (imgcat_id);

CREATE INDEX image_display ON  xtest_image (image_display);


-- --------------------------------------------------------

--
-- ???若????????? x_imagebody
--

DROP TABLE xtest_imagebody;

CREATE TABLE xtest_imagebody (
  image_id INTEGER(8)  NOT NULL default '0',
  image_body mediumblob
);

CREATE INDEX image_id ON xtest_imagebody (image_id);


-- --------------------------------------------------------

--
-- ???若????????? x_imagecategory
--

DROP TABLE xtest_imagecategory;

CREATE TABLE xtest_imagecategory (
  imgcat_id INTEGER PRIMARY KEY AUTOINCREMENT,

  imgcat_name TEXT(100) NOT NULL default '',
  imgcat_maxsize INTEGER(8)  NOT NULL default '0',
  imgcat_maxwidth INTEGER(3)  NOT NULL default '0',
  imgcat_maxheight INTEGER(3)  NOT NULL default '0',
  imgcat_display INTEGER(1)  NOT NULL default '0',
  imgcat_weight INTEGER(3)  NOT NULL default '0',
  imgcat_type TEXT(1) NOT NULL default '',
  imgcat_storetype TEXT(5) NOT NULL default ''
);

CREATE INDEX imgcat_display ON xtest_imagecategory (imgcat_display);


-- --------------------------------------------------------

--
-- ???若????????? x_imgset
--

DROP TABLE xtest_imgset;

CREATE TABLE xtest_imgset (
  imgset_id INTEGER PRIMARY KEY AUTOINCREMENT,
  imgset_name TEXT(50) NOT NULL default '',
  imgset_refid INTEGER(8)  NOT NULL default '0'
);

CREATE INDEX imgset_refid ON xtest_imgset (imgset_refid);


-- --------------------------------------------------------

--
-- ???若????????? x_imgset_tplset_link
--

DROP TABLE xtest_imgset_tplset_link;

CREATE TABLE xtest_imgset_tplset_link (
  imgset_id INTEGER(5)  NOT NULL default '0',
  tplset_name TEXT(50) NOT NULL default ''
);

CREATE INDEX tplset_name ON xtest_imgset_tplset_link (tplset_name);


-- --------------------------------------------------------

--
-- ???若????????? x_imgsetimg
--

DROP TABLE xtest_imgsetimg;

CREATE TABLE xtest_imgsetimg (
  imgsetimg_id INTEGER PRIMARY KEY AUTOINCREMENT,
  imgsetimg_file TEXT(50) NOT NULL default '',
  imgsetimg_body blob NOT NULL,
  imgsetimg_imgset INTEGER(5)  NOT NULL default '0'
);

CREATE INDEX imgsetimg_imgset ON xtest_imgsetimg (imgsetimg_imgset);


-- --------------------------------------------------------

--
-- ???若????????? x_modules
--

DROP TABLE xtest_modules;

CREATE TABLE xtest_modules (
  mid INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT(150) NOT NULL default '',
  version INTEGER(5)  NOT NULL default '100',
  last_update INTEGER(10)  NOT NULL default '0',
  weight INTEGER(3)  NOT NULL default '0',
  isactive INTEGER(1)  NOT NULL default '0',
  dirname TEXT(25) NOT NULL default '',
  hasmain INTEGER(1)  NOT NULL default '0',
  hasadmin INTEGER(1)  NOT NULL default '0',
  hassearch INTEGER(1)  NOT NULL default '0',
  hasconfig INTEGER(1)  NOT NULL default '0',
  hascomments INTEGER(1)  NOT NULL default '0',
  hasnotification INTEGER(1)  NOT NULL default '0'
);

CREATE INDEX hasmain ON xtest_modules (hasmain);

CREATE INDEX hasadmin ON xtest_modules (hasadmin);

CREATE INDEX hassearch ON xtest_modules (hassearch);

CREATE INDEX hasnotification ON xtest_modules (hasnotification);

CREATE INDEX dirname ON xtest_modules (dirname);

CREATE INDEX name ON xtest_modules (name);


-- --------------------------------------------------------

--
-- ???若????????? x_newblocks
--

DROP TABLE xtest_newblocks;

CREATE TABLE xtest_newblocks (
  bid INTEGER PRIMARY KEY AUTOINCREMENT,
  mid INTEGER(5)  NOT NULL default '0',
  func_num INTEGER(3)  NOT NULL default '0',
  options TEXT(255) NOT NULL default '',
  name TEXT(150) NOT NULL default '',
  title TEXT(255) NOT NULL default '',
  content TEXT NOT NULL,
  side INTEGER(1)  NOT NULL default '0',
  weight INTEGER(5)  NOT NULL default '0',
  visible INTEGER(1)  NOT NULL default '0',
  block_type TEXT(1) NOT NULL default '',
  c_type TEXT(1) NOT NULL default '',
  isactive INTEGER(1)  NOT NULL default '0',
  dirname TEXT(50) NOT NULL default '',
  func_file TEXT(50) NOT NULL default '',
  show_func TEXT(50) NOT NULL default '',
  edit_func TEXT(50) NOT NULL default '',
  template TEXT(50) NOT NULL default '',
  bcachetime INTEGER(10)  NOT NULL default '0',
  last_modified INTEGER(10)  NOT NULL default '0'
);

CREATE INDEX mid ON xtest_newblocks (mid);

CREATE INDEX visible ON xtest_newblocks (visible);

CREATE INDEX isactive_visible_mid ON xtest_newblocks (isactive,visible,mid);

CREATE INDEX mid_funcnum ON xtest_newblocks (mid,func_num);


-- --------------------------------------------------------

--
-- ???若????????? x_online
--

DROP TABLE xtest_online;

CREATE TABLE xtest_online (
  online_uid INTEGER(8)  NOT NULL default '0',
  online_uname TEXT(25) NOT NULL default '',
  online_updated INTEGER(10)  NOT NULL default '0',
  online_module INTEGER(5)  NOT NULL default '0',
  online_ip TEXT(15) NOT NULL default ''
);

CREATE INDEX online_module ON xtest_online (online_module);


-- --------------------------------------------------------

--
-- ???若????????? x_priv_msgs
--

DROP TABLE xtest_priv_msgs;

CREATE TABLE xtest_priv_msgs (
  msg_id INTEGER PRIMARY KEY AUTOINCREMENT,
  msg_image TEXT(100) default NULL,
  subject TEXT(255) NOT NULL default '',
  from_userid INTEGER(8)  NOT NULL default '0',
  to_userid INTEGER(8)  NOT NULL default '0',
  msg_time INTEGER(10)  NOT NULL default '0',
  msg_TEXT text NOT NULL,
  read_msg INTEGER(1)  NOT NULL default '0'
);

CREATE INDEX to_userid ON xtest_priv_msgs (to_userid);

CREATE INDEX touseridreadmsg ON xtest_priv_msgs (to_userid,read_msg);

CREATE INDEX msgidfromuserid ON xtest_priv_msgs (msg_id,from_userid);


-- --------------------------------------------------------

--
-- ???若????????? x_ranks
--

DROP TABLE xtest_ranks;

CREATE TABLE xtest_ranks (
  rank_id INTEGER PRIMARY KEY AUTOINCREMENT,
  rank_title TEXT(50) NOT NULL default '',
  rank_min INTEGER(8)  NOT NULL default '0',
  rank_max INTEGER(8)  NOT NULL default '0',
  rank_special INTEGER(1)  NOT NULL default '0',
  rank_image TEXT(255) default NULL
);

CREATE INDEX rank_min ON xtest_ranks (rank_min);

CREATE INDEX rank_max ON xtest_ranks (rank_max);

CREATE INDEX rankminrankmaxranspecial ON xtest_ranks (rank_min,rank_max,rank_special);

CREATE INDEX rankspecial ON xtest_ranks (rank_special);


-- --------------------------------------------------------

--
-- ???若????????? x_session
--

DROP TABLE xtest_session;

CREATE TABLE xtest_session (
  sess_id TEXT(32) NOT NULL default ''  PRIMARY KEY,
  sess_updated INTEGER(10)  NOT NULL default '0',
  sess_ip TEXT(15) NOT NULL default '',
  sess_data TEXT NOT NULL
);

CREATE INDEX updated ON xtest_session (sess_updated);


-- --------------------------------------------------------

--
-- ???若????????? x_smiles
--

DROP TABLE xtest_smiles;

CREATE TABLE xtest_smiles (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  code TEXT(50) NOT NULL default '',
  smile_url TEXT(100) NOT NULL default '',
  emotion TEXT(75) NOT NULL default '',
  display INTEGER(1) NOT NULL default '0'
);


-- --------------------------------------------------------

--
-- ???若????????? x_tplfile
--

DROP TABLE xtest_tplfile;

CREATE TABLE xtest_tplfile (
  tpl_id INTEGER PRIMARY KEY AUTOINCREMENT,
  tpl_refid INTEGER(5)  NOT NULL default '0',
  tpl_module TEXT(25) NOT NULL default '',
  tpl_tplset TEXT(50) NOT NULL default '',
  tpl_file TEXT(50) NOT NULL default '',
  tpl_desc TEXT(255) NOT NULL default '',
  tpl_lastmodified INTEGER(10)  NOT NULL default '0',
  tpl_lastimported INTEGER(10)  NOT NULL default '0',
  tpl_type TEXT(20) NOT NULL default ''
);

CREATE INDEX tpl_refid ON xtest_tplfile (tpl_refid,tpl_type);

CREATE INDEX tpl_tplset ON xtest_tplfile (tpl_tplset,tpl_file);


-- --------------------------------------------------------

--
-- ???若????????? x_tplset
--

DROP TABLE xtest_tplset;

CREATE TABLE xtest_tplset (
  tplset_id INTEGER PRIMARY KEY AUTOINCREMENT,
  tplset_name TEXT(50) NOT NULL default '',
  tplset_desc TEXT(255) NOT NULL default '',
  tplset_credits TEXT NOT NULL,
  tplset_created INTEGER(10)  NOT NULL default '0'
);


-- --------------------------------------------------------

--
-- ???若????????? x_tplsource
--

DROP TABLE xtest_tplsource;

CREATE TABLE xtest_tplsource (
  tpl_id INTEGER(7)  NOT NULL default '0',
  tpl_source TEXT NOT NULL
);

CREATE INDEX tpl_id ON xtest_tplsource (tpl_id);


-- --------------------------------------------------------

--
-- ???若????????? x_users
--

DROP TABLE xtest_users;

CREATE TABLE xtest_users (
  uid INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT(60) NOT NULL default '',
  uname TEXT(25) NOT NULL default '',
  email TEXT(60) NOT NULL default '',
  url TEXT(100) NOT NULL default '',
  user_avatar TEXT(30) NOT NULL default 'blank.gif',
  user_regdate INTEGER(10)  NOT NULL default '0',
  user_icq TEXT(15) NOT NULL default '',
  user_from TEXT(100) NOT NULL default '',
  user_sig TEXT NOT NULL,
  user_viewemail INTEGER(1)  NOT NULL default '0',
  actkey TEXT(8) NOT NULL default '',
  user_aim TEXT(18) NOT NULL default '',
  user_yim TEXT(25) NOT NULL default '',
  user_msnm TEXT(100) NOT NULL default '',
  pass TEXT(32) NOT NULL default '',
  posts INTEGER(8)  NOT NULL default '0',
  attachsig INTEGER(1)  NOT NULL default '0',
  rank INTEGER(5)  NOT NULL default '0',
  level INTEGER(3)  NOT NULL default '1',
  theme TEXT(100) NOT NULL default '',
  timezone_offset float(3,1) NOT NULL default '0.0',
  last_login INTEGER(10)  NOT NULL default '0',
  umode TEXT(10) NOT NULL default '',
  uorder INTEGER(1)  NOT NULL default '0',
  notify_method INTEGER(1) NOT NULL default '1',
  notify_mode INTEGER(1) NOT NULL default '0',
  user_occ TEXT(100) NOT NULL default '',
  bio TEXT NOT NULL,
  user_intrest TEXT(150) NOT NULL default '',
  user_mailok INTEGER(1)  NOT NULL default '1'
);

CREATE INDEX uname ON xtest_users (uname);

CREATE INDEX email ON xtest_users (email);

CREATE INDEX uiduname ON xtest_users (uid,uname);

CREATE INDEX unamepass ON xtest_users (uname,pass);


-- --------------------------------------------------------

--
-- ???若????????? x_xnpaccount_config
--

DROP TABLE xtest_xnpaccount_config;

CREATE TABLE xtest_xnpaccount_config (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT(255) NOT NULL default '',
  value blob NOT NULL
);

CREATE INDEX name_index ON xtest_xnpaccount_config (name);


-- --------------------------------------------------------

--
-- ???若????????? x_xnpaccount_groups
--

DROP TABLE xtest_xnpaccount_groups;

CREATE TABLE xtest_xnpaccount_groups (
  gid INTEGER PRIMARY KEY AUTOINCREMENT,
  gname TEXT(255) NOT NULL default '',
  gdesc TEXT(255) NOT NULL default '',
  group_index_id INTEGER(10)  NOT NULL default '0',
  group_item_number_limit INTEGER(10) ,
  group_index_number_limit INTEGER(10) ,
  group_item_storage_limit DOUBLE
);


-- --------------------------------------------------------

--
-- ???若????????? x_xnpaccount_groups_users_link
--

DROP TABLE xtest_xnpaccount_groups_users_link;

CREATE TABLE xtest_xnpaccount_groups_users_link (
  gid INTEGER(10)  NOT NULL default '0',
  uid INTEGER(10)  NOT NULL default '0',
  is_admin INTEGER(1)  NOT NULL default '0',
  UNIQUE(gid,uid)
);

CREATE INDEX giduid ON xtest_xnpaccount_groups_users_link (gid,uid);

-- --------------------------------------------------------

--
-- ???若????????? x_xnpaccount_session
--

DROP TABLE xtest_xnpaccount_session;

CREATE TABLE xtest_xnpaccount_session (
  sid INTEGER PRIMARY KEY AUTOINCREMENT,
  uid INTEGER(10)  NOT NULL default '0',
  timestamp timestamp(14) NOT NULL,
  remote_host INTEGER(10)  NOT NULL default '0'
);


-- --------------------------------------------------------

--
-- ???若????????? x_xnpaccount_users
--

DROP TABLE xtest_xnpaccount_users;

CREATE TABLE xtest_xnpaccount_users (
  uid INTEGER(10)  NOT NULL default '0'  PRIMARY KEY,
  activate INTEGER(1)  NOT NULL default '0',
  address TEXT(255) default NULL,
  division TEXT(255) default NULL,
  tel TEXT(32) NOT NULL default '',
  company_name TEXT(255) default NULL,
  country TEXT(255) NOT NULL default '',
  zipcode TEXT(32) NOT NULL default '',
  fax TEXT(32) NOT NULL default '',
  base_url TEXT(255) default NULL,
  notice_mail INTEGER(10)  default NULL,
  notice_mail_since datetime default NULL,
  private_index_id INTEGER(10)  NOT NULL default '0',
  private_item_number_limit INTEGER(10),
  private_index_number_limit INTEGER(10),
  private_item_storage_limit DOUBLE
);

CREATE INDEX activate ON xtest_xnpaccount_users (activate);


-- --------------------------------------------------------

DROP TABLE xtest_xnpaccount_item_basic;

CREATE TABLE xtest_xnpaccount_item_basic (
  item_id INTEGER PRIMARY KEY AUTOINCREMENT,
  item_type_id INTEGER(10)  NOT NULL default '0',
  uid INTEGER(10)  NOT NULL default '0',
  title TEXT(255) default NULL,
  keywords TEXT,
  description TEXT,
  doi TEXT,
  last_update_date INTEGER(10)  NOT NULL,
  creation_date INTEGER(10)  NOT NULL,
  publication_year INTEGER(4) default 0,
  publication_month INTEGER(2) default NULL,
  publication_mday INTEGER(2) default NULL
);

CREATE INDEX title_index ON xtest_xnpaccount_item_basic (title);


-- --------------------------------------------------------

DROP TABLE xtest_xnpaccount_index;

CREATE TABLE xtest_xnpaccount_index (
  index_id INTEGER PRIMARY KEY AUTOINCREMENT,
  parent_index_id INTEGER(10)  default NULL,
  uid INTEGER(10)  default NULL,
  gid INTEGER(10)  default NULL,
  open_level INTEGER(3) NOT NULL default '0',
  sort_number INTEGER(10)  NOT NULL default '0'
);

CREATE INDEX parent_index_id ON xtest_xnpaccount_index (parent_index_id);


-- --------------------------------------------------------

DROP TABLE xtest_xnpaccount_index_item_link;

CREATE TABLE xtest_xnpaccount_index_item_link (
  index_item_link_id INTEGER PRIMARY KEY AUTOINCREMENT,
  index_id INTEGER(10)  NOT NULL default '0',
  item_id INTEGER(10)  NOT NULL default '0',
  certify_state INTEGER(3)  NOT NULL default '0',
  UNIQUE (index_id,item_id)
);

CREATE INDEX index_id ON xtest_xnpaccount_index_item_link (index_id);

CREATE INDEX item_id ON xtest_xnpaccount_index_item_link (item_id);


-- --------------------------------------------------------

DROP TABLE xtest_xnpaccount_item_type;

CREATE TABLE xtest_xnpaccount_item_type (
  item_type_id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT(30) default NULL,
  mid INTEGER(10),
  display_name TEXT(30)
);


-- --------------------------------------------------------

--
-- ???若????????? x_xoopscomments
--

DROP TABLE xtest_xoopscomments;

CREATE TABLE xtest_xoopscomments (
  com_id INTEGER PRIMARY KEY AUTOINCREMENT,
  com_pid INTEGER(8)  NOT NULL default '0',
  com_rootid INTEGER(8)  NOT NULL default '0',
  com_modid INTEGER(5)  NOT NULL default '0',
  com_itemid INTEGER(8)  NOT NULL default '0',
  com_icon TEXT(25) NOT NULL default '',
  com_created INTEGER(10)  NOT NULL default '0',
  com_modified INTEGER(10)  NOT NULL default '0',
  com_uid INTEGER(8)  NOT NULL default '0',
  com_ip TEXT(15) NOT NULL default '',
  com_title TEXT(255) NOT NULL default '',
  com_TEXT text NOT NULL,
  com_sig INTEGER(1)  NOT NULL default '0',
  com_status INTEGER(1)  NOT NULL default '0',
  com_exparams TEXT(255) NOT NULL default '',
  dohtml INTEGER(1)  NOT NULL default '0',
  dosmiley INTEGER(1)  NOT NULL default '0',
  doxcode INTEGER(1)  NOT NULL default '0',
  doimage INTEGER(1)  NOT NULL default '0',
  dobr INTEGER(1)  NOT NULL default '0'
);

CREATE INDEX com_pid ON xtest_xoopscomments (com_pid);

CREATE INDEX com_itemid ON xtest_xoopscomments (com_itemid);

CREATE INDEX com_uid ON xtest_xoopscomments (com_uid);

CREATE INDEX com_title ON xtest_xoopscomments (com_title);


-- --------------------------------------------------------

--
-- ???若????????? x_xoopsnotifications
--

DROP TABLE xtest_xoopsnotifications;

CREATE TABLE xtest_xoopsnotifications (
  not_id INTEGER PRIMARY KEY AUTOINCREMENT,
  not_modid INTEGER(5)  NOT NULL default '0',
  not_itemid INTEGER(8)  NOT NULL default '0',
  not_category TEXT(30) NOT NULL default '',
  not_event TEXT(30) NOT NULL default '',
  not_uid INTEGER(8)  NOT NULL default '0',
  not_mode INTEGER(1) NOT NULL default '0'
);

CREATE INDEX not_modid ON xtest_xoopsnotifications (not_modid);

CREATE INDEX not_itemid ON xtest_xoopsnotifications (not_itemid);

CREATE INDEX not_class ON xtest_xoopsnotifications (not_category);

CREATE INDEX not_uid ON xtest_xoopsnotifications (not_uid);

CREATE INDEX not_event ON xtest_xoopsnotifications (not_event);


-- --------------------------------------------------------

--
-- ???若????????? xtest_xnpaccount_changelog
--

DROP TABLE xtest_xnpaccount_changelog;

CREATE TABLE xtest_xnpaccount_changelog (
  log_id INTEGER PRIMARY KEY AUTOINCREMENT,
  uid INTEGER default '0',
  item_id INTEGER default '0',
  log_date INTEGER default '0',
  log text
);

CREATE INDEX changelog_item_id ON xtest_xnpaccount_changelog (item_id);

CREATE INDEX changelog_log_date ON xtest_xnpaccount_changelog (log_date);


-- --------------------------------------------------------

--
-- ???若????????? xtest_xnpbinder_binder_item_link
--

DROP TABLE xtest_xnpbinder_binder_item_link;

CREATE TABLE xtest_xnpbinder_binder_item_link (
  binder_item_link_id INTEGER PRIMARY KEY AUTOINCREMENT,
  binder_id INTEGER default '0',
  item_id INTEGER default '0',
  UNIQUE (binder_id,item_id)
);

CREATE INDEX xnpbinder_binder_item_link_index_id ON xtest_xnpbinder_binder_item_link (binder_id);

CREATE INDEX xnpbinder_binder_item_link_item_id ON xtest_xnpbinder_binder_item_link (item_id);

    
-- --------------------------------------------------------

--
-- ???若????????? xtest_xnpaccount_file
--

DROP TABLE xtest_xnpaccount_file;

CREATE TABLE xtest_xnpaccount_file (
  file_id INTEGER PRIMARY KEY AUTOINCREMENT,
  item_id INTEGER default NULL,
  origial_file_name TEXT(255) default NULL,
  file_name TEXT(255) default NULL,
  file_size INTEGER NOT NULL default '0',
  thumbnail_file_name TEXT(255) default NULL,
  thumbnail_file_size INTEGER default NULL,
  caption TEXT(255) default NULL,
  sid INTEGER default NULL,
  file_type_id INTEGER NOT NULL default '0'
);

CREATE INDEX xnpaccount_file_item_id ON xtest_xnpaccount_file (item_id);

CREATE INDEX xnpaccount_file_sid ON xtest_xnpaccount_file (sid);

-- --------------------------------------------------------

--
-- ???若????????? xtest_xnpaccount_file_type
--

DROP TABLE xtest_xnpaccount_file_type;

CREATE TABLE xtest_xnpaccount_file_type (
  file_type_id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT(30) default NULL,
  mid INTEGER default NULL,
  display_name TEXT(30) default NULL
);


INSERT INTO xtest_xnpaccount_users VALUES (2, 1, NULL, NULL, '', NULL, '', '', '', NULL, NULL, NULL,2, 0, 0, 0);

INSERT INTO xtest_xnpaccount_users VALUES (1, 1, '', '', '', '', '', '', '', '', 0, '2004-12-14 15:50:19',1, 0, 0, 0);

INSERT INTO xtest_xnpaccount_users VALUES (3, 1, '', '', '', '', '', '', '', '', 0, '0000-00-00 00:00:00',3, 0, 0, 0);

INSERT INTO xtest_xnpaccount_users VALUES (4, 1, NULL, NULL, '', NULL, '', '', '', NULL, NULL, NULL,4, 0, 0, 0);

INSERT INTO xtest_xnpaccount_users VALUES (169, 1, '', '', '', '', '', '', '', '', 0, '0000-00-00 00:00:00',5, 0, 0, 0);

INSERT INTO xtest_xnpaccount_users VALUES (167, 1, NULL, NULL, '', NULL, '', '', '', NULL, NULL, NULL,6, 0, 0, 0);


INSERT INTO xtest_users VALUES (1, '', 'root', 'yuichit@tsubasa.co.jp', 'https://10.12.60.61/~youi/xoops/', 'blank.gif', 1102397507, '', '', '', 1, '', '', '', '', 'aea6380b5e33432e2f0abda224575d8a', 0, 0, 7, 5, 'default', '9.0', 1103264601, 'thread', 0, 1, 0, '', '', '', 0);

INSERT INTO xtest_users VALUES (2, '', 'kawamata', 'kawamata@tsubasa.co.jp', '', 'blank.gif', 1103004700, '', '', '', 0, '60fea2ce', '', '', '', 'ab8702061956c0a8fb112f6ad0b687d8', 0, 0, 0, 1, '', '9.0', 1103012492, 'nest', 0, 1, 0, '', '', '', 1);

INSERT INTO xtest_users VALUES (3, '', 'gadmin', 'gadmin@hoge.com', '', 'blank.gif', 1103005989, '', '', '', 0, '380b3b95', '', '', '', 'f73767a685634d4a646217735385c0b7', 0, 0, 0, 1, '', '0.0', 1103007141, 'nest', 0, 1, 0, '', '', '', 1);

INSERT INTO xtest_users VALUES (4, '', 'youi', 'youi2@praesens.co.jp', '', 'blank.gif', 1103282226, '', '', '', 0, '', '', '', '', '329435e5e66be809a656af105f42401e', 0, 0, 0, 1, '', '0.0', 0, 'nest', 0, 1, 0, '', '', '', 0);

INSERT INTO xtest_users VALUES (169, '', 'moderator', 'moderator@hoge.fuga', '', 'blank.gif', 1105596870, '', '', '', 0, '5fd83f13', '', '', '', '637dc9f6e01dde3b07bf1604bcc35990', 0, 0, 0, 1, '', '9.0', 0, 'nest', 0, 1, 0, '', '', '', 1);

INSERT INTO xtest_users VALUES (167, '', 'youi256', 'youi256@praesens.co.jp', '', 'blank.gif', 1105594202, '', '', '', 0, '4e122187', '', '', '', '69fe8cbf32f415efcb4166101f1e5851', 0, 0, 0, 1, '', '9.0', 1105594769, 'nest', 0, 1, 0, '', '', '', 1);

   
INSERT INTO xtest_groups VALUES (33, 'moderator', 'platform moderator', '');

INSERT INTO xtest_xnpaccount_config VALUES (1, 'moderator_gid', "33");


INSERT INTO xtest_groups_users_link VALUES (1, 33, 169);


INSERT INTO xtest_xnpaccount_groups VALUES (1, 'default', 'default group', 0, 0, 0, 0);


INSERT INTO xtest_xnpaccount_item_basic VALUES (1,1,0,'Root',NULL,NULL,NULL,0,0,NULL,NULL,NULL);

INSERT INTO xtest_xnpaccount_item_basic VALUES (2,1,0,'Binders',NULL,NULL,NULL,0,0,NULL,NULL,NULL);

INSERT INTO xtest_xnpaccount_item_basic VALUES (3,1,0,'Public',NULL,NULL,NULL,0,0,NULL,NULL,NULL);


INSERT INTO xtest_xnpaccount_index VALUES (1,0,NULL,NULL,1,1);

INSERT INTO xtest_xnpaccount_index VALUES (2,3,NULL,NULL,1,1);

INSERT INTO xtest_xnpaccount_index VALUES (3,1,NULL,NULL,1,1);


INSERT INTO xtest_xnpaccount_item_type VALUES (1,'index',NULL,'Index');

INSERT INTO xtest_xnpaccount_item_type VALUES (2,'binder',NULL,'Binder');

INSERT INTO xtest_xnpaccount_item_type VALUES (3,'0123456789012345678901234567890',NULL,'1234567890123456789012345678901');

