-- phpMyAdmin SQL Dump
-- version 2.9.1-rc1
-- http://www.phpmyadmin.net
-- 
-- 主機: localhost
-- 生成日期: 2006 年 10 月 09 日 03:31
-- 服務器版本: 4.1.18
-- PHP 版本: 5.1.6
-- 
-- 數據庫: 'newtest'
-- 


-- 
-- 表的結構 'supe_ads'
-- 

DROP TABLE IF EXISTS supe_ads;
CREATE TABLE supe_ads (
  adid smallint(6) unsigned NOT NULL auto_increment,
  `subject` varchar(50) NOT NULL default '',
  adtype enum('js','iframe','echo') NOT NULL default 'js',
  dateline int(10) unsigned NOT NULL default '0',
  width varchar(10) NOT NULL default '',
  height varchar(10) NOT NULL default '',
  clicks int(10) unsigned NOT NULL default '0',
  adcontent text NOT NULL default '',
  PRIMARY KEY  (adid)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_announcements'
-- 

DROP TABLE IF EXISTS supe_announcements;
CREATE TABLE supe_announcements (
  id smallint(6) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  author varchar(15) NOT NULL default '',
  `subject` varchar(80) NOT NULL default '',
  displayorder tinyint(3) unsigned NOT NULL default '0',
  starttime int(10) unsigned NOT NULL default '0',
  endtime int(10) unsigned NOT NULL default '0',
  message text NOT NULL default '',
  PRIMARY KEY  (id),
  KEY timespan (starttime,endtime)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_attachments'
-- 

DROP TABLE IF EXISTS supe_attachments;
CREATE TABLE supe_attachments (
  aid mediumint(8) unsigned NOT NULL auto_increment,
  isavailable tinyint(1) NOT NULL default '0',
  `type` char(20) NOT NULL default '',
  itemid mediumint(8) unsigned NOT NULL default '0',
  catid smallint(6) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  filename char(150) NOT NULL default '',
  `subject` char(80) NOT NULL default '',
  attachtype char(10) NOT NULL default '',
  isimage tinyint(1) NOT NULL default '0',
  size mediumint(8) unsigned NOT NULL default '0',
  filepath char(200) NOT NULL default '',
  thumbpath char(200) NOT NULL default '',
  downloads mediumint(8) unsigned NOT NULL default '0',
  `hash` char(16) NOT NULL default '',
  PRIMARY KEY  (aid),
  KEY `hash` (`hash`),
  KEY `itemid` (`itemid`),
  KEY uid (uid,`type`,dateline),
  KEY `type` (`type`)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_attachmenttypes'
-- 

DROP TABLE IF EXISTS supe_attachmenttypes;
CREATE TABLE supe_attachmenttypes (
  id smallint(6) unsigned NOT NULL auto_increment,
  fileext char(10) NOT NULL default '',
  maxsize int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

-- 
-- 導出表中的數據 'supe_attachmenttypes'
-- 

INSERT INTO supe_attachmenttypes (id, fileext, maxsize) VALUES (1, 'jpg', 2097152);
INSERT INTO supe_attachmenttypes (id, fileext, maxsize) VALUES (2, 'jpeg', 2097152);
INSERT INTO supe_attachmenttypes (id, fileext, maxsize) VALUES (3, 'gif', 2097152);
INSERT INTO supe_attachmenttypes (id, fileext, maxsize) VALUES (4, 'rar', 2097152);
INSERT INTO supe_attachmenttypes (id, fileext, maxsize) VALUES (5, 'txt', 2097152);
INSERT INTO supe_attachmenttypes (id, fileext, maxsize) VALUES (6, 'zip', 2097152);


-- 
-- 表的結構 'supe_blocks'
-- 

DROP TABLE IF EXISTS supe_blocks;
CREATE TABLE supe_blocks (
  blockid smallint(6) unsigned NOT NULL auto_increment,
  dateline int(10) unsigned NOT NULL default '0',
  blocktype varchar(20) NOT NULL default '',
  blockname varchar(80) NOT NULL default '',
  blockmodel tinyint(1) NOT NULL default '1',
  blocktext text NOT NULL default '',
  blockcode text NOT NULL default '',
  PRIMARY KEY  (blockid)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_cache'
-- 

DROP TABLE IF EXISTS supe_cache;
CREATE TABLE supe_cache (
  cachekey varchar(16) NOT NULL default '',
  uid mediumint(8) unsigned NOT NULL default '0',
  cachename varchar(20) NOT NULL default '',
  `value` mediumtext NOT NULL default '',
  updatetime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (cachekey)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_categories'
-- 

DROP TABLE IF EXISTS supe_categories;
CREATE TABLE supe_categories (
  catid smallint(6) unsigned NOT NULL auto_increment,
  upid smallint(6) unsigned NOT NULL default '0',
  name varchar(50) NOT NULL default '',
  note text NOT NULL default '',
  `type` varchar(15) NOT NULL default '',
  ischannel tinyint(1) NOT NULL default '0',
  displayorder mediumint(6) unsigned NOT NULL default '0',
  tpl varchar(80) NOT NULL default '',
  thumb varchar(150) NOT NULL default '',
  image varchar(150) NOT NULL default '',
  haveattach tinyint(1) NOT NULL default '0',
  bbsmodel tinyint(1) NOT NULL default '0',
  bbsurltype varchar(15) NOT NULL default '',
  blockmodel tinyint(1) NOT NULL default '1',
  blockparameter text NOT NULL default '',
  blocktext text NOT NULL default '',
  url varchar(200) NOT NULL default '',
  subcatid varchar(200) NOT NULL default '',
  PRIMARY KEY  (catid),
  KEY `type` (`type`),
  KEY upid (upid)
) TYPE=MyISAM;

-- 
-- 導出表中的數據 `supe_categories`
-- 

INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (1, 0, '科技世界', '', 'news', 0, 0, '', 0, 0, '', 1, '', '', '', '1');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (2, 0, '互聯網絡', '', 'news', 0, 0, '', 0, 0, '', 1, '', '', '', '2');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (3, 0, '財經報道', '', 'news', 0, 0, '', 0, 0, '', 1, '', '', '', '3');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (4, 0, '體育資訊', '', 'news', 0, 0, '', 0, 0, '', 1, '', '', '', '4');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (5, 0, '明星娛樂', '', 'news', 0, 0, '', 0, 0, '', 1, '', '', '', '5');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (6, 0, '生活資訊', '', 'news', 0, 0, '', 0, 0, '', 1, '', '', '', '6');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (7, 0, '網站建設', '', 'news', 0, 0, '', 0, 0, '', 1, '', '', '', '7');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (8, 0, '動態報道', '', 'news', 0, 0, '', 0, 0, '', 1, '', '', '', '8');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (9, 0, '特別關注', '', 'news', 0, 0, '', 0, 0, '', 1, '', '', '', '9');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (10, 0, '書籍期刊', '', 'goods', 0, 0, '', 0, 0, '', 1, '', '', '', '10');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (11, 0, '音樂影視', '', 'goods', 0, 0, '', 0, 0, '', 1, '', '', '', '11');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (12, 0, '軟件遊戲', '', 'goods', 0, 0, '', 0, 0, '', 1, '', '', '', '12');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (13, 0, '數碼產品', '', 'goods', 0, 0, '', 0, 0, '', 1, '', '', '', '13');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (14, 0, '生活用品', '', 'goods', 0, 0, '', 0, 0, '', 1, '', '', '', '14');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (15, 0, '電腦相關', '', 'goods', 0, 0, '', 0, 0, '', 1, '', '', '', '15');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (16, 0, '美容健身', '', 'goods', 0, 0, '', 0, 0, '', 1, '', '', '', '16');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (17, 0, '手機通訊', '', 'goods', 0, 0, '', 0, 0, '', 1, '', '', '', '17');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (18, 0, '家電器材', '', 'goods', 0, 0, '', 0, 0, '', 1, '', '', '', '18');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (19, 0, '食用產品', '', 'goods', 0, 0, '', 0, 0, '', 1, '', '', '', '19');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (20, 0, '衣服服裝', '', 'goods', 0, 0, '', 0, 0, '', 1, '', '', '', '20');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (21, 0, '漫畫卡通', '', 'image', 0, 0, '', 0, 0, '', 1, '', '', '', '21');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (22, 0, '創意設計', '', 'image', 0, 0, '', 0, 0, '', 1, '', '', '', '22');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (23, 0, '經典懷舊', '', 'image', 0, 0, '', 0, 0, '', 1, '', '', '', '23');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (24, 0, '自然風景', '', 'image', 0, 0, '', 0, 0, '', 1, '', '', '', '24');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (25, 0, '偶像明星', '', 'image', 0, 0, '', 0, 0, '', 1, '', '', '', '25');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (26, 0, '輕鬆搞笑', '', 'image', 0, 0, '', 0, 0, '', 1, '', '', '', '26');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (27, 0, '社會紀實', '', 'image', 0, 0, '', 0, 0, '', 1, '', '', '', '27');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (28, 0, '絕色美人', '', 'image', 0, 0, '', 0, 0, '', 1, '', '', '', '28');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (29, 0, '我的生活', '', 'image', 0, 0, '', 0, 0, '', 1, '', '', '', '29');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (30, 0, '精品鑒賞', '', 'image', 0, 0, '', 0, 0, '', 1, '', '', '', '30');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (31, 0, '情感綠洲', '', 'blog', 0, 0, '', 0, 0, '', 1, '', '', '', '31');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (32, 0, '娛樂休閒', '', 'blog', 0, 0, '', 0, 0, '', 1, '', '', '', '32');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (33, 0, '電腦網絡', '', 'blog', 0, 0, '', 0, 0, '', 1, '', '', '', '33');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (34, 0, '經濟金融', '', 'blog', 0, 0, '', 0, 0, '', 1, '', '', '', '34');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (35, 0, '新聞出版', '', 'blog', 0, 0, '', 0, 0, '', 1, '', '', '', '35');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (36, 0, '科學技術', '', 'blog', 0, 0, '', 0, 0, '', 1, '', '', '', '36');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (37, 0, '法學園地', '', 'blog', 0, 0, '', 0, 0, '', 1, '', '', '', '37');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (38, 0, '文學世界', '', 'blog', 0, 0, '', 0, 0, '', 1, '', '', '', '38');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (39, 0, '旅遊自然', '', 'blog', 0, 0, '', 0, 0, '', 1, '', '', '', '39');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (40, 0, '網絡軟件', '', 'file', 0, 0, '', 0, 0, '', 1, '', '', '', '40');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (41, 0, '系統工具', '', 'file', 0, 0, '', 0, 0, '', 1, '', '', '', '41');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (42, 0, '應用軟件', '', 'file', 0, 0, '', 0, 0, '', 1, '', '', '', '42');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (43, 0, '聯絡聊天', '', 'file', 0, 0, '', 0, 0, '', 1, '', '', '', '43');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (44, 0, '圖形圖像', '', 'file', 0, 0, '', 0, 0, '', 1, '', '', '', '44');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (45, 0, '多媒體類', '', 'file', 0, 0, '', 0, 0, '', 1, '', '', '', '45');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (46, 0, '行業軟件', '', 'file', 0, 0, '', 0, 0, '', 1, '', '', '', '46');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (47, 0, '遊戲娛樂', '', 'file', 0, 0, '', 0, 0, '', 1, '', '', '', '47');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (48, 0, '編程開發', '', 'file', 0, 0, '', 0, 0, '', 1, '', '', '', '48');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (49, 0, '安全相關', '', 'file', 0, 0, '', 0, 0, '', 1, '', '', '', '49');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (50, 0, '教育教學', '', 'file', 0, 0, '', 0, 0, '', 1, '', '', '', '50');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (51, 0, '互聯網絡', '', 'link', 0, 0, '', 0, 0, '', 1, '', '', '', '51');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (52, 0, '財經生活', '', 'link', 0, 0, '', 0, 0, '', 1, '', '', '', '52');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (53, 0, '文化知識', '', 'link', 0, 0, '', 0, 0, '', 1, '', '', '', '53');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (54, 0, '生活資訊', '', 'link', 0, 0, '', 0, 0, '', 1, '', '', '', '54');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (55, 0, '休閒娛樂', '', 'link', 0, 0, '', 0, 0, '', 1, '', '', '', '55');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (56, 0, '精彩圖片', '', 'link', 0, 0, '', 0, 0, '', 1, '', '', '', '56');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (57, 0, '視聽動漫', '', 'link', 0, 0, '', 0, 0, '', 1, '', '', '', '57');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (58, 0, '綜合資源', '', 'link', 0, 0, '', 0, 0, '', 1, '', '', '', '58');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (59, 0, '個人空間', '', 'space', 0, 0, '', 0, 0, '', 1, '', '', '', '59');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (60, 0, '經濟金融', '', 'space', 0, 0, '', 0, 0, '', 1, '', '', '', '60');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (61, 0, '電腦網絡', '', 'space', 0, 0, '', 0, 0, '', 1, '', '', '', '61');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (62, 0, '教育學習', '', 'space', 0, 0, '', 0, 0, '', 1, '', '', '', '62');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (63, 0, '情感綠洲', '', 'space', 0, 0, '', 0, 0, '', 1, '', '', '', '63');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (64, 0, '娛樂休閒', '', 'space', 0, 0, '', 0, 0, '', 1, '', '', '', '64');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (65, 0, '文學園地', '', 'space', 0, 0, '', 0, 0, '', 1, '', '', '', '65');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (66, 0, '新聞出版', '', 'space', 0, 0, '', 0, 0, '', 1, '', '', '', '66');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (67, 0, '體育競技', '', 'space', 0, 0, '', 0, 0, '', 1, '', '', '', '67');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (68, 0, '旅遊自然', '', 'space', 0, 0, '', 0, 0, '', 1, '', '', '', '68');
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES (69, 0, '網絡網摘', '', 'blog', 0, 0, '', 0, 0, '', 1, '', '', '', '69');



-- 
-- 表的結構 'supe_corpus'
-- 

DROP TABLE IF EXISTS supe_corpus;
CREATE TABLE supe_corpus (
  cid mediumint(8) unsigned NOT NULL auto_increment,
  authorid mediumint(8) unsigned NOT NULL default '0',
  author varchar(15) NOT NULL default '',
  corpusname varchar(100) NOT NULL default '',
  resume text NOT NULL default '',
  background varchar(15) NOT NULL default '',
  blogs text NOT NULL default '',
  catalog text NOT NULL default '',
  cover text NOT NULL default '',
  prelude text NOT NULL default '',
  backcover text NOT NULL default '',
  createdate int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (cid),
  KEY authorid (authorid,createdate)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_crons'
-- 

DROP TABLE IF EXISTS supe_crons;
CREATE TABLE supe_crons (
  cronid smallint(6) unsigned NOT NULL auto_increment,
  available tinyint(1) NOT NULL default '0',
  `type` enum('user','system') NOT NULL default 'user',
  name char(50) NOT NULL default '',
  filename char(50) NOT NULL default '',
  lastrun int(10) unsigned NOT NULL default '0',
  nextrun int(10) unsigned NOT NULL default '0',
  weekday tinyint(1) NOT NULL default '0',
  `day` tinyint(2) NOT NULL default '0',
  `hour` tinyint(2) NOT NULL default '0',
  `minute` char(36) NOT NULL default '',
  PRIMARY KEY  (cronid),
  KEY nextrun (available,nextrun)
) TYPE=MyISAM;

-- 
-- 導出表中的數據 'supe_crons'
-- 

INSERT INTO supe_crons VALUES (1, 1, 'system', '更新熱門TAG列表', 'tagcontent.php', 1160363259, 1160364600, -1, -1, -1, '0	30');
INSERT INTO supe_crons VALUES (2, 1, 'system', '清理垃圾附件', 'cleanattachment.php', 1160356169, 1160424000, -1, -1, 4, '0');
INSERT INTO supe_crons VALUES (3, 1, 'system', '更新信息查看數', 'updateviewnum.php', 1160363413, 1160364000, -1, -1, -1, '0	10	20	30	40	50');
INSERT INTO supe_crons VALUES (4, 1, 'system', '更新附件下載數', 'updatedownloads.php', 1160363821, 1160364300, -1, -1, -1, '5	15	25	35	45	55');
INSERT INTO supe_crons VALUES (5, 1, 'system', '更新廣告點擊數', 'updateadclicks.php', 1160363821, 1160364720, -1, -1, -1, '12	32	52');
INSERT INTO supe_crons VALUES (6, 1, 'system', '更新空間瀏覽數', 'updatespaceviewnum.php', 1160363259, 1160364360, -1, -1, -1, '6	26	46');
INSERT INTO supe_crons VALUES (7, 1, 'system', '清理臨時文件', 'cleanimporttemp.php', 1160356169, 1160420400, -1, -1, 3, '0');
INSERT INTO supe_crons VALUES (8, 1, 'system', '更新論壇緩存', 'updatebbscache.php', 1160356169, 1160409600, -1, -1, 0, '0');
INSERT INTO supe_crons VALUES (9, 1, 'system', '清理訪客足跡', 'cleanvisitors.php', 1160356169, 1160420400, -1, -1, 3, '0');
INSERT INTO supe_crons VALUES (10, 1, 'system', '清理主題足跡', 'cleantracks.php', 1160356169, 1160422200, -1, -1, 3, '30');


-- 
-- 表的結構 'supe_customfields'
-- 

DROP TABLE IF EXISTS supe_customfields;
CREATE TABLE supe_customfields (
  customfieldid smallint(6) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  `type` varchar(10) NOT NULL default '',
  name varchar(80) NOT NULL default '',
  displayorder smallint(6) unsigned NOT NULL default '0',
  customfieldtext text NOT NULL default '',
  isdefault tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (customfieldid),
  KEY uid (uid,`type`)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_effects'
-- 

DROP TABLE IF EXISTS supe_effects;
CREATE TABLE supe_effects (
  eid smallint(6) unsigned NOT NULL auto_increment,
  name char(50) NOT NULL default '',
  kind char(10) NOT NULL default '',
  `file` char(200) NOT NULL default '',
  PRIMARY KEY  (eid)
) TYPE=MyISAM;

-- 
-- 導出表中的數據 'supe_effects'
-- 

INSERT INTO supe_effects (eid, name, kind, file) VALUES (1, '雨滴', 'flash', 'SITEURL/effects/flash/flash01.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (2, '水泡', 'flash', 'SITEURL/effects/flash/flash02.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (3, '水滴2', 'flash', 'SITEURL/effects/flash/flash03.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (4, '雪花', 'flash', 'SITEURL/effects/flash/flash04.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (5, '浮雲', 'flash', 'SITEURL/effects/flash/flash05.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (6, '星際', 'flash', 'SITEURL/effects/flash/flash06.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (7, '水圈', 'flash', 'SITEURL/effects/flash/flash07.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (8, '水泡2', 'flash', 'SITEURL/effects/flash/flash08.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (9, '水滴3', 'flash', 'SITEURL/effects/flash/flash09.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (10, '雨滴2', 'flash', 'SITEURL/effects/flash/flash10.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (11, '水滴4', 'flash', 'SITEURL/effects/flash/flash11.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (12, '水泡3', 'flash', 'SITEURL/effects/flash/flash12.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (13, '雨滴3', 'flash', 'SITEURL/effects/flash/flash13.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (14, '青蛙', 'flash', 'SITEURL/effects/flash/flash14.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (15, '螞蟻', 'flash', 'SITEURL/effects/flash/flash15.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (16, '天鵝', 'flash', 'SITEURL/effects/flash/flash16.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (17, '蝴蝶', 'flash', 'SITEURL/effects/flash/flash17.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (18, '鳥', 'flash', 'SITEURL/effects/flash/flash18.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (19, '飛雁', 'flash', 'SITEURL/effects/flash/flash19.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (20, '麋鹿', 'flash', 'SITEURL/effects/flash/flash20.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (21, '飛雁2', 'flash', 'SITEURL/effects/flash/flash21.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (22, '鴿子', 'flash', 'SITEURL/effects/flash/flash22.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (23, '鷹', 'flash', 'SITEURL/effects/flash/flash23.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (24, '落葉', 'flash', 'SITEURL/effects/flash/flash24.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (25, '彩蝶', 'flash', 'SITEURL/effects/flash/flash25.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (26, '彩蝶2', 'flash', 'SITEURL/effects/flash/flash26.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (27, '心相印', 'flash', 'SITEURL/effects/flash/flash27.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (28, '蜻蜓', 'flash', 'SITEURL/effects/flash/flash28.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (29, '轉盤', 'flash', 'SITEURL/effects/flash/flash29.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (30, '轉盤2', 'flash', 'SITEURL/effects/flash/flash30.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (31, '轉盤3', 'flash', 'SITEURL/effects/flash/flash31.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (32, '冰淇淋', 'flash', 'SITEURL/effects/flash/flash32.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (33, '禮花', 'flash', 'SITEURL/effects/flash/flash33.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (34, '禮花1', 'flash', 'SITEURL/effects/flash/flash34.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (35, '撞球', 'flash', 'SITEURL/effects/flash/flash35.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (36, '極光', 'flash', 'SITEURL/effects/flash/flash36.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (37, '我心飄飄', 'flash', 'SITEURL/effects/flash/flash37.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (38, 'Thanks', 'flash', 'SITEURL/effects/flash/flash38.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (39, '心相印2', 'flash', 'SITEURL/effects/flash/flash39.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (40, '彩色氣球', 'flash', 'SITEURL/effects/flash/flash40.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (41, '掛墜', 'flash', 'SITEURL/effects/flash/flash41.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (42, '轉盤4', 'flash', 'SITEURL/effects/flash/flash42.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (43, '百葉窗', 'flash', 'SITEURL/effects/flash/flash43.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (44, '箭頭', 'flash', 'SITEURL/effects/flash/flash44.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (45, '星星', 'flash', 'SITEURL/effects/flash/flash45.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (46, '繁星', 'flash', 'SITEURL/effects/flash/flash46.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (47, '繁星2', 'flash', 'SITEURL/effects/flash/flash47.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (48, '星光', 'flash', 'SITEURL/effects/flash/flash48.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (49, '流星', 'flash', 'SITEURL/effects/flash/flash49.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (50, '蒲公英', 'flash', 'SITEURL/effects/flash/flash50.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (51, '繁星3', 'flash', 'SITEURL/effects/flash/flash51.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (52, '星光2', 'flash', 'SITEURL/effects/flash/flash52.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (53, '星光3', 'flash', 'SITEURL/effects/flash/flash53.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (54, '飛星', 'flash', 'SITEURL/effects/flash/flash54.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (55, '飛星2', 'flash', 'SITEURL/effects/flash/flash55.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (56, '星', 'flash', 'SITEURL/effects/flash/flash56.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (57, '流星2', 'flash', 'SITEURL/effects/flash/flash57.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (58, '飛星3', 'flash', 'SITEURL/effects/flash/flash58.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (59, '窗台', 'flash', 'SITEURL/effects/flash/flash59.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (60, '飛花', 'flash', 'SITEURL/effects/flash/flash60.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (61, '鞭炮', 'flash', 'SITEURL/effects/flash/flash61.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (62, '夜空', 'flash', 'SITEURL/effects/flash/flash62.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (63, '落葉3', 'flash', 'SITEURL/effects/flash/flash63.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (64, '落葉4', 'flash', 'SITEURL/effects/flash/flash64.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (65, '落花', 'flash', 'SITEURL/effects/flash/flash65.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (66, '落花2', 'flash', 'SITEURL/effects/flash/flash66.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (67, '玫瑰花', 'flash', 'SITEURL/effects/flash/flash67.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (68, '玫瑰花2', 'flash', 'SITEURL/effects/flash/flash68.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (69, '花瓣', 'flash', 'SITEURL/effects/flash/flash69.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (70, '柳枝', 'flash', 'SITEURL/effects/flash/flash70.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (71, '落花3', 'flash', 'SITEURL/effects/flash/flash71.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (72, '落花4', 'flash', 'SITEURL/effects/flash/flash72.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (73, '落花5', 'flash', 'SITEURL/effects/flash/flash73.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (74, '落葉5', 'flash', 'SITEURL/effects/flash/flash74.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (75, '玫瑰花3', 'flash', 'SITEURL/effects/flash/flash75.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (76, '葉', 'flash', 'SITEURL/effects/flash/flash76.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (77, '雨中葉', 'flash', 'SITEURL/effects/flash/flash77.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (78, '音符', 'flash', 'SITEURL/effects/flash/flash78.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (79, '大雁', 'flash', 'SITEURL/effects/flash/flash79.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (80, '小孩', 'flash', 'SITEURL/effects/flash/flash80.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (81, '氣泡4', 'flash', 'SITEURL/effects/flash/flash81.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (82, '金魚', 'flash', 'SITEURL/effects/flash/flash82.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (83, '煙花3', 'flash', 'SITEURL/effects/flash/flash83.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (84, '煙花4', 'flash', 'SITEURL/effects/flash/flash84.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (85, '花2', 'flash', 'SITEURL/effects/flash/flash85.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (86, '馬', 'flash', 'SITEURL/effects/flash/flash86.swf');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (87, '友誼地久天長', 'media', 'SITEURL/effects/music/music01.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (88, '平安夜', 'media', 'SITEURL/effects/music/music02.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (89, '鈴兒響叮噹', 'media', 'SITEURL/effects/music/music03.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (90, 'Every Breath You Take', 'media', 'SITEURL/effects/music/music04.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (91, '終有一天感動你', 'media', 'SITEURL/effects/music/music05.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (92, '櫻桃小丸子', 'media', 'SITEURL/effects/music/music06.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (93, '傳燈', 'media', 'SITEURL/effects/music/music07.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (94, 'Sultans Of Swing', 'media', 'SITEURL/effects/music/music08.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (95, '愛拼才會贏', 'media', 'SITEURL/effects/music/music09.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (96, '加州旅館', 'media', 'SITEURL/effects/music/music10.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (97, '中華民謠', 'media', 'SITEURL/effects/music/music11.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (98, '蟲兒飛', 'media', 'SITEURL/effects/music/music12.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (99, 'broken wings', 'media', 'SITEURL/effects/music/music13.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (100, '天空之城', 'media', 'SITEURL/effects/music/music14.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (101, 'Let Me Love You', 'media', 'SITEURL/effects/music/music15.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (102, 'you are beautifu', 'media', 'SITEURL/effects/music/music16.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (103, 'as long as you love me', 'media', 'SITEURL/effects/music/music17.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (104, '天長地久', 'media', 'SITEURL/effects/music/music18.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (105, 'fill me in', 'media', 'SITEURL/effects/music/music19.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (106, 'Only You', 'media', 'SITEURL/effects/music/music20.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (107, 'Lionel Ritchie, Stuck on You', 'media', 'SITEURL/effects/music/music21.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (108, 'Careless Whisper', 'media', 'SITEURL/effects/music/music22.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (109, '無情的雨無情的你', 'media', 'SITEURL/effects/music/music23.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (110, 'Master of Puppets', 'media', 'SITEURL/effects/music/music24.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (111, 'to be with you', 'media', 'SITEURL/effects/music/music25.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (112, '失落的愛', 'media', 'SITEURL/effects/music/music26.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (113, 'Everthing I do', 'media', 'SITEURL/effects/music/music27.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (114, 'Now and Forever', 'media', 'SITEURL/effects/music/music28.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (115, 'hey jude', 'media', 'SITEURL/effects/music/music29.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (116, '教父', 'media', 'SITEURL/effects/music/music30.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (117, '寂靜之聲', 'media', 'SITEURL/effects/music/music31.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (118, '神秘的林蔭道', 'media', 'SITEURL/effects/music/music32.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (119, '月亮河', 'media', 'SITEURL/effects/music/music33.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (120, '愛情的故事', 'media', 'SITEURL/effects/music/music34.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (121, '天堂靡靡之音色', 'media', 'SITEURL/effects/music/music35.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (122, 'Rhythm Of The Rain', 'media', 'SITEURL/effects/music/music37.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (123, 'Lemon Tree', 'media', 'SITEURL/effects/music/music36.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (124, 'some where', 'media', 'SITEURL/effects/music/music38.mid');
INSERT INTO supe_effects (eid, name, kind, file) VALUES (125, '去海邊', 'media', 'SITEURL/effects/music/music39.mid');


-- 
-- 表的結構 'supe_favorites'
-- 

DROP TABLE IF EXISTS supe_favorites;
CREATE TABLE supe_favorites (
  uid mediumint(8) unsigned NOT NULL default '0',
  itemid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (uid,itemid),
  KEY uid (uid,dateline)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_friends'
-- 

DROP TABLE IF EXISTS supe_friends;
CREATE TABLE supe_friends (
  uid mediumint(8) unsigned NOT NULL default '0',
  frienduid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  grade tinyint(2) unsigned NOT NULL default '0',
  PRIMARY KEY  (uid,frienduid),
  KEY uid (uid,dateline),
  KEY frienduid (frienduid,dateline)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_goodsprice'
-- 

DROP TABLE IF EXISTS supe_goodsprice;
CREATE TABLE supe_goodsprice (
  priceid mediumint(8) unsigned NOT NULL auto_increment,
  itemid mediumint(8) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  price float unsigned NOT NULL default '0',
  buynum smallint(6) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '0',
  username char(15) NOT NULL default '',
  PRIMARY KEY  (priceid),
  KEY itemid (itemid)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_guestbooks'
-- 

DROP TABLE IF EXISTS supe_guestbooks;
CREATE TABLE supe_guestbooks (
  gid mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  isprivate tinyint(1) NOT NULL default '0',
  authorid mediumint(8) unsigned NOT NULL default '0',
  author varchar(15) NOT NULL default '',
  ip varchar(15) NOT NULL default '',
  dateline int(10) unsigned NOT NULL default '0',
  message text NOT NULL default '',
  PRIMARY KEY  (gid),
  KEY uid (uid,dateline)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_itemtypes'
-- 

DROP TABLE IF EXISTS supe_itemtypes;
CREATE TABLE supe_itemtypes (
  typeid mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  `type` char(10) NOT NULL default '',
  typename char(50) NOT NULL default '',
  viewperm char(15) NOT NULL default '',
  replyperm char(15) NOT NULL default '',
  getattachperm char(15) NOT NULL default '',
  displayorder tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (typeid),
  KEY uid (uid,`type`,displayorder)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_members'
-- 

DROP TABLE IF EXISTS supe_members;
CREATE TABLE supe_members (
  uid mediumint(8) unsigned NOT NULL default '0',
  groupid smallint(6) unsigned NOT NULL default '0',
  username char(15) NOT NULL default '',
  `password` char(32) NOT NULL default '',
  secques char(8) NOT NULL default '',
  timeoffset char(4) NOT NULL default '',
  dateformat char(10) NOT NULL default '',
  timeformat tinyint(1) NOT NULL default '0',
  havespace tinyint(1) NOT NULL default '0',
  newpm tinyint(1) NOT NULL default '0',
  lastsearchtime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (uid)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_polls'
-- 

DROP TABLE IF EXISTS supe_polls;
CREATE TABLE supe_polls (
  pollid smallint(6) unsigned NOT NULL auto_increment,
  pollnum mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  updatetime int(10) unsigned NOT NULL default '0',
  ismulti tinyint(1) NOT NULL default '0',
  `subject` varchar(80) NOT NULL default '',
  summary text NOT NULL default '',
  options text NOT NULL default '',
  voters text NOT NULL default '',
  PRIMARY KEY  (pollid)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_prefields'
-- 

DROP TABLE IF EXISTS supe_prefields;
CREATE TABLE supe_prefields (
  id smallint(6) unsigned NOT NULL auto_increment,
  `type` char(10) NOT NULL default '',
  field char(20) NOT NULL default '',
  `value` char(50) NOT NULL default '',
  isdefault tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY `type` (`type`)
) TYPE=MyISAM;

-- 
-- 導出表中的數據 'supe_prefields'
-- 

INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (1, 'blog', 'mood', '高興', 1);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (2, 'blog', 'mood', '鬱悶', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (3, 'blog', 'mood', '平靜', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (4, 'blog', 'weather', '晴朗', 1);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (5, 'blog', 'weather', '陰雨', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (6, 'blog', 'weather', '大風', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (7, 'blog', 'weather', '熱', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (8, 'blog', 'weather', '冷', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (9, 'blog', 'weather', '舒適', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (10, 'file', 'filesizeunit', 'GB', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (11, 'file', 'filesizeunit', 'MB', 1);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (12, 'file', 'filesizeunit', 'KB', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (13, 'file', 'filesizeunit', 'B', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (14, 'file', 'version', 'V1.0', 1);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (15, 'file', 'version', 'V2.0', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (16, 'file', 'version', 'V3.0', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (17, 'file', 'producer', '本站原創', 1);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (18, 'file', 'producer', '來源網絡', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (19, 'file', 'downfrom', '本地', 1);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (20, 'file', 'downfrom', '網絡', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (21, 'file', 'language', '簡體中文', 1);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (22, 'file', 'language', '繁體中文', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (23, 'file', 'language', 'english', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (24, 'file', 'permission', '免費', 1);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (25, 'file', 'permission', '共享', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (26, 'file', 'permission', '商業', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (27, 'file', 'permission', '破解', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (28, 'file', 'permission', '註冊', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (29, 'file', 'system', 'Win2000/WinXP', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (30, 'file', 'system', 'Win9X/Win2000/WinXP', 1);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (31, 'file', 'system', 'Win9X', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (32, 'file', 'system', 'Windows/Linux', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (33, 'file', 'system', 'Unix/Linux', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (34, 'news', 'newsauthor', 'webmaster', 1);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (35, 'news', 'newsauthor', 'admin', 0);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (36, 'news', 'newsfrom', '本站原創', 1);
INSERT INTO supe_prefields (id, type, field, value, isdefault) VALUES (37, 'news', 'newsauthor', '網絡轉載', 0);


-- 
-- 表的結構 'supe_robotitems'
-- 

DROP TABLE IF EXISTS supe_robotitems;
CREATE TABLE supe_robotitems (
  itemid mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  catid smallint(6) unsigned NOT NULL default '0',
  robotid smallint(6) unsigned NOT NULL default '0',
  robottime int(10) unsigned NOT NULL default '0',
  `subject` char(80) NOT NULL default '',
  author char(35) NOT NULL default '',
  itemfrom char(50) NOT NULL default '',
  dateline char(50) NOT NULL default '',
  isimport tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (itemid),
  KEY `robotid` (`robotid`)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_robotmessages'
-- 

DROP TABLE IF EXISTS supe_robotmessages;
CREATE TABLE supe_robotmessages (
  msgid mediumint(8) unsigned NOT NULL auto_increment,
  itemid mediumint(8) unsigned NOT NULL default '0',
  robotid smallint(6) unsigned NOT NULL default '0',
  message text NOT NULL default '',
  picurls text NOT NULL default '',
  flashurls text NOT NULL default '',
  PRIMARY KEY  (msgid),
  KEY itemid (itemid)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_robots'
-- 

DROP TABLE IF EXISTS supe_robots;
CREATE TABLE supe_robots (
  robotid smallint(6) unsigned NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  uid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  lasttime int(10) unsigned NOT NULL default '0',
  robotnum smallint(6) unsigned NOT NULL default '0',
  listurltype varchar(10) NOT NULL default '',
  listurl text NOT NULL default '',
  listpagestart smallint(6) unsigned NOT NULL default '0',
  listpageend smallint(6) unsigned NOT NULL default '0',
  allnum smallint(6) unsigned NOT NULL default '0',
  pernum smallint(6) unsigned NOT NULL default '0',
  savepic tinyint(1) NOT NULL default '0',
  encode varchar(20) NOT NULL default '',
  picurllinkpre text NOT NULL default '',
  saveflash tinyint(1) NOT NULL default '0',
  subjecturlrule text NOT NULL default '',
  subjecturllinkrule text NOT NULL default '',
  subjecturllinkpre text NOT NULL default '',
  subjectrule text NOT NULL default '',
  subjectfilter text NOT NULL default '',
  subjectreplace text NOT NULL default '',
  subjectreplaceto text NOT NULL default '',
  subjectkey text NOT NULL default '',
  subjectallowrepeat tinyint(1) NOT NULL default '0',
  datelinerule text NOT NULL default '',
  fromrule text NOT NULL default '',
  authorrule text NOT NULL default '',
  messagerule text NOT NULL default '',
  messagefilter text NOT NULL default '',
  messagepagetype varchar(10) NOT NULL default '',
  messagepagerule text NOT NULL default '',
  messagepageurlrule text NOT NULL default '',
  messagepageurllinkpre text NOT NULL default '',
  messagereplace text NOT NULL default '',
  messagereplaceto text NOT NULL default '',
  PRIMARY KEY  (robotid)
) TYPE=MyISAM;

-- 
-- 導出表中的數據 `supe_robots`
-- 

INSERT INTO `supe_robots` VALUES (1, 'Discuz!示範', 1, 1160367980, 1160367984, 1, 'auto', 'http://www.discuz.net/archiver/fid-77-page-[page].html', 1, 2, 50, 2, 0, 'gbk', 'http://www.discuz.net/', 0, '<ul type="1" start="1">[list]</ul>', '<li><a href="[url]">', 'http://www.discuz.net/', '<div class="subtable altbg2 t_msg">*<b>[subject]</b>', '', '', '', '', 1, '', '', '', '<div class="subtable altbg2 t_msg">*</b><br>[message]</div></div>', '', 'page', '', '', '', '', '');


-- 
-- 表的結構 'supe_rss'
-- 

DROP TABLE IF EXISTS supe_rss;
CREATE TABLE supe_rss (
  uid mediumint(8) unsigned NOT NULL default '0',
  `type` varchar(10) NOT NULL default '',
  `data` mediumtext NOT NULL default '',
  updatetime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (uid,`type`)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_settings'
-- 

DROP TABLE IF EXISTS supe_settings;
CREATE TABLE supe_settings (
  variable varchar(32) NOT NULL default '',
  `value` text NOT NULL default '',
  PRIMARY KEY  (variable)
) TYPE=MyISAM;

-- 
-- 導出表中的數據 `supe_settings`
-- 

INSERT INTO `supe_settings` VALUES ('htmlviewspacetime', '300');
INSERT INTO `supe_settings` VALUES ('htmlviewspace', '0');
INSERT INTO `supe_settings` VALUES ('htmlspacelisttime', '300');
INSERT INTO `supe_settings` VALUES ('htmlspacelist', '0');
INSERT INTO `supe_settings` VALUES ('htmlspacetime', '300');
INSERT INTO `supe_settings` VALUES ('htmlspace', '0');
INSERT INTO `supe_settings` VALUES ('htmlviewnewstime', '300');
INSERT INTO `supe_settings` VALUES ('htmlviewnews', '0');
INSERT INTO `supe_settings` VALUES ('channel', '');
INSERT INTO `supe_settings` VALUES ('htmlcategorytime', '300');
INSERT INTO `supe_settings` VALUES ('htmlcategory', '0');
INSERT INTO `supe_settings` VALUES ('htmlindextime', '300');
INSERT INTO `supe_settings` VALUES ('htmlindex', '0');
INSERT INTO `supe_settings` VALUES ('thumbcutstarty', '0');
INSERT INTO `supe_settings` VALUES ('thumbcutstartx', '0');
INSERT INTO `supe_settings` VALUES ('thumbcutmode', '3');
INSERT INTO `supe_settings` VALUES ('thumboption', '4');
INSERT INTO `supe_settings` VALUES ('thumbbgcolor', '#C0C0C0');
INSERT INTO `supe_settings` VALUES ('watermarkjpgquality', '85');
INSERT INTO `supe_settings` VALUES ('watermarktrans', '30');
INSERT INTO `supe_settings` VALUES ('watermarkstatus', '9');
INSERT INTO `supe_settings` VALUES ('watermark', '0');
INSERT INTO `supe_settings` VALUES ('watermarkfile', 'images/system/watermark.gif');
INSERT INTO `supe_settings` VALUES ('bbsurltype', 'site');
INSERT INTO `supe_settings` VALUES ('htmlurl', '');
INSERT INTO `supe_settings` VALUES ('attachmenturl', '');
INSERT INTO `supe_settings` VALUES ('htmldir', './html');
INSERT INTO `supe_settings` VALUES ('attachmentdir', './attachments');
INSERT INTO `supe_settings` VALUES ('debug', '0');
INSERT INTO `supe_settings` VALUES ('attachmentdirtype', 'month');
INSERT INTO `supe_settings` VALUES ('pagepostfix', '.html');
INSERT INTO `supe_settings` VALUES ('urltype', '1');
INSERT INTO `supe_settings` VALUES ('gzipcompress', '1');
INSERT INTO `supe_settings` VALUES ('template', 'default');
INSERT INTO `supe_settings` VALUES ('timeoffset', '8');
INSERT INTO `supe_settings` VALUES ('language', 'chinese.php');
INSERT INTO `supe_settings` VALUES ('sitename', 'SupeSite/X-Space社區門戶');
INSERT INTO `supe_settings` VALUES ('htmlother', '0');
INSERT INTO `supe_settings` VALUES ('htmlothertime', '300');
INSERT INTO `supe_settings` VALUES ('credit', 'credits');
INSERT INTO `supe_settings` VALUES ('allowguest', '0');
INSERT INTO `supe_settings` VALUES ('allowcache', '1');
INSERT INTO `supe_settings` VALUES ('allowdomain', '0');
INSERT INTO `supe_settings` VALUES ('domainroot', '');
INSERT INTO `supe_settings` VALUES ('holddomain', 'admin*|space*|blog*|bbs*|www');
INSERT INTO `supe_settings` VALUES ('rssnum', '10');
INSERT INTO `supe_settings` VALUES ('rssupdatetime', '300');
INSERT INTO `supe_settings` VALUES ('defaultblog', '我的個人空間開通了，歡迎你時常過來做客，大家多多交流哦。我會把一些新鮮有趣的東西記錄下來一塊與你分享。也希望你記住我的地址，你可以把她添加到你的收藏夾，也可以把她複製下來告訴你的朋友們。讓大家一起分享吧。');
INSERT INTO `supe_settings` VALUES ('allowtrackback', '0');
INSERT INTO `supe_settings` VALUES ('needcheck', '0');
INSERT INTO `supe_settings` VALUES ('checkgrade', '				');
INSERT INTO `supe_settings` VALUES ('usetype', 'news,blog,image,file');
INSERT INTO `supe_settings` VALUES ('domainlength', '5');
INSERT INTO `supe_settings` VALUES ('spaceadfooter', '');
INSERT INTO `supe_settings` VALUES ('spaceadfile', '');
INSERT INTO `supe_settings` VALUES ('miibeian', '');
INSERT INTO `supe_settings` VALUES ('allowannounce', 'front,back');
INSERT INTO `supe_settings` VALUES ('searchinterval', '0');

-- 
-- 表的結構 'supe_spaceblogs'
-- 

DROP TABLE IF EXISTS supe_spaceblogs;
CREATE TABLE supe_spaceblogs (
  itemid mediumint(8) unsigned NOT NULL default '0',
  message text NOT NULL default '',
  relativetags text NOT NULL default '',
  postip varchar(15) NOT NULL default '',
  relativeitemids varchar(255) NOT NULL default '',
  customfieldid smallint(6) unsigned NOT NULL default '0',
  customfieldtext text NOT NULL default '',
  includetags text NOT NULL default '',
  mood varchar(25) NOT NULL default '',
  weather varchar(25) NOT NULL default '',
  PRIMARY KEY  (itemid)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_spacecache'
-- 

DROP TABLE IF EXISTS supe_spacecache;
CREATE TABLE supe_spacecache (
  cachekey varchar(16) NOT NULL default '',
  uid mediumint(8) unsigned NOT NULL default '0',
  cachename varchar(20) NOT NULL default '',
  `value` mediumtext NOT NULL default '',
  updatetime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (cachekey)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_spacecomments'
-- 

DROP TABLE IF EXISTS supe_spacecomments;
CREATE TABLE supe_spacecomments (
  cid int(10) unsigned NOT NULL auto_increment,
  itemid mediumint(8) unsigned NOT NULL default '0',
  `type` varchar(10) NOT NULL default '',
  uid mediumint(8) unsigned NOT NULL default '0',
  authorid mediumint(8) unsigned NOT NULL default '0',
  author varchar(15) NOT NULL default '',
  ip varchar(15) NOT NULL default '',
  dateline int(10) unsigned NOT NULL default '0',
  rates smallint(6) NOT NULL default '0',
  url varchar(150) NOT NULL default '',
  `subject` varchar(100) NOT NULL default '',
  message text NOT NULL default '',
  PRIMARY KEY  (cid),
  KEY itemid (itemid,dateline),
  KEY uid (uid,dateline)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_spacefiles'
-- 

DROP TABLE IF EXISTS supe_spacefiles;
CREATE TABLE supe_spacefiles (
  itemid mediumint(8) unsigned NOT NULL default '0',
  message text NOT NULL default '',
  relativetags text NOT NULL default '',
  postip varchar(15) NOT NULL default '',
  relativeitemids varchar(255) NOT NULL default '',
  customfieldid smallint(6) unsigned NOT NULL default '0',
  customfieldtext text NOT NULL default '',
  includetags text NOT NULL default '',
  filesize varchar(10) NOT NULL default '',
  filesizeunit varchar(5) NOT NULL default '',
  version varchar(100) NOT NULL default '',
  producer varchar(100) NOT NULL default '',
  downfrom varchar(100) NOT NULL default '',
  language varchar(100) NOT NULL default '',
  permission varchar(100) NOT NULL default '',
  system varchar(100) NOT NULL default '',
  remoteurl text NOT NULL default '',
  PRIMARY KEY  (itemid)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_spacegoods'
-- 

DROP TABLE IF EXISTS supe_spacegoods;
CREATE TABLE supe_spacegoods (
  itemid mediumint(8) unsigned NOT NULL default '0',
  message text NOT NULL default '',
  relativetags text NOT NULL default '',
  postip varchar(15) NOT NULL default '',
  relativeitemids varchar(255) NOT NULL default '',
  customfieldid smallint(6) unsigned NOT NULL default '0',
  customfieldtext text NOT NULL default '',
  includetags text NOT NULL default '',
  stocknum smallint(6) unsigned NOT NULL default '0',
  quality varchar(10) NOT NULL default '',
  price float unsigned NOT NULL default '0',
  province varchar(10) NOT NULL default '',
  city varchar(10) NOT NULL default '',
  chargemode varchar(10) NOT NULL default '',
  chargemail float unsigned NOT NULL default '0',
  chargeexpress float unsigned NOT NULL default '0',
  chargeems float unsigned NOT NULL default '0',
  paymenttype varchar(10) NOT NULL default '',
  term smallint(6) unsigned NOT NULL default '0',
  alipay varchar(50) NOT NULL default '',
  markup smallint(6) unsigned NOT NULL default '1',
  starttime int(10) unsigned NOT NULL default '0',
  image varchar(150) NOT NULL default '',
  thumb varchar(150) NOT NULL default '',
  `status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (itemid)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_spaceimages'
-- 

DROP TABLE IF EXISTS supe_spaceimages;
CREATE TABLE supe_spaceimages (
  itemid mediumint(8) unsigned NOT NULL default '0',
  message text NOT NULL default '',
  image varchar(200) NOT NULL default '',
  imagenum smallint(6) NOT NULL default '0',
  relativetags text NOT NULL default '',
  postip varchar(15) NOT NULL default '',
  relativeitemids varchar(255) NOT NULL default '',
  customfieldid smallint(6) unsigned NOT NULL default '0',
  customfieldtext text NOT NULL default '',
  includetags text NOT NULL default '',
  PRIMARY KEY  (itemid)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_spaceitems'
-- 

DROP TABLE IF EXISTS supe_spaceitems;
CREATE TABLE supe_spaceitems (
  itemid mediumint(8) unsigned NOT NULL auto_increment,
  catid smallint(6) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  tid mediumint(8) unsigned NOT NULL default '0',
  username char(15) NOT NULL default '',
  itemtypeid mediumint(8) unsigned NOT NULL default '0',
  `type` char(10) NOT NULL default '',
  subtype char(10) NOT NULL default '',
  `subject` char(80) NOT NULL default '',
  dateline int(10) unsigned NOT NULL default '0',
  lastpost int(10) unsigned NOT NULL default '0',
  viewnum mediumint(8) unsigned NOT NULL default '0',
  replynum mediumint(8) unsigned NOT NULL default '0',
  trackbacknum mediumint(8) unsigned NOT NULL default '0',
  goodrate int(10) unsigned NOT NULL default '0',
  badrate int(10) unsigned NOT NULL default '0',
  digest tinyint(1) NOT NULL default '0',
  top tinyint(1) NOT NULL default '0',
  allowreply tinyint(1) NOT NULL default '1',
  `hash` char(16) NOT NULL default '',
  folder tinyint(1) NOT NULL default '1',
  haveattach tinyint(1) NOT NULL default '0',
  grade tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (itemid),
  KEY uid (uid,`type`,folder,top,dateline),
  KEY catid (catid,folder,dateline),
  KEY `type` (`type`)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_spacelinks'
-- 

DROP TABLE IF EXISTS supe_spacelinks;
CREATE TABLE supe_spacelinks (
  itemid mediumint(8) unsigned NOT NULL default '0',
  message text NOT NULL default '',
  relativetags text NOT NULL default '',
  postip varchar(15) NOT NULL default '',
  relativeitemids varchar(255) NOT NULL default '',
  customfieldid smallint(6) unsigned NOT NULL default '0',
  customfieldtext text NOT NULL default '',
  includetags text NOT NULL default '',
  url varchar(255) NOT NULL default '',
  domain varchar(150) NOT NULL default '',
  snaptype tinyint(1) NOT NULL default '0',
  snaptext text NOT NULL default '',
  PRIMARY KEY  (itemid)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_spacenews'
-- 

DROP TABLE IF EXISTS supe_spacenews;
CREATE TABLE supe_spacenews (
  nid mediumint(8) unsigned NOT NULL auto_increment,
  itemid mediumint(8) unsigned NOT NULL default '0',
  message text NOT NULL default '',
  relativetags text NOT NULL default '',
  postip varchar(15) NOT NULL default '',
  relativeitemids varchar(255) NOT NULL default '',
  customfieldid smallint(6) unsigned NOT NULL default '0',
  customfieldtext text NOT NULL default '',
  includetags text NOT NULL default '',
  newsauthor varchar(20) NOT NULL default '',
  newsfrom varchar(50) NOT NULL default '',
  newsurl varchar(255) NOT NULL default '',
  PRIMARY KEY  (nid),
  KEY itemid (itemid)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_spacetags'
-- 

DROP TABLE IF EXISTS supe_spacetags;
CREATE TABLE supe_spacetags (
  itemid mediumint(8) unsigned NOT NULL default '0',
  tagid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  `type` char(10) NOT NULL default '',
  PRIMARY KEY  (itemid,tagid),
  KEY tagid (tagid,dateline)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_styles'
-- 

DROP TABLE IF EXISTS supe_styles;
CREATE TABLE supe_styles (
  tplid smallint(6) unsigned NOT NULL auto_increment,
  tplname varchar(80) NOT NULL default '',
  tplnote text NOT NULL default '',
  tpltype varchar(20) default NULL,
  tplfilepath varchar(80) NOT NULL default '',
  PRIMARY KEY  (tplid),
  KEY tpltype (tpltype)
) TYPE=MyISAM;

-- 
-- 導出表中的數據 'supe_styles'
-- 

INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (1, '分類列表(分類名+圖片)', '風格功能:顯示系統分類\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:分類封面圖片、分類名稱', 'category', 'category_channel');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (2, '分類列表(分類名)', '風格功能:顯示系統分類\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:分類名稱', 'category', 'category_name_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (3, '用戶空間根分類', '風格功能:顯示用戶空間分類\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:用戶空間分類名稱', 'category', 'space_category_name_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (4, '專題列表', '風格作用:顯示分類中的專題名\r\n展示方式:以&lt;div&gt;標籤區域顯示\r\n顯示數據:專題封面圖片、專題名稱\r\n風格備註:封面圖片大小設置 120 x 60', 'category', 'div_category_channel');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (5, '子分類列表', '風格作用:顯示分類下的子分類\r\n展示方式:以&lt;div&gt;標籤區域顯示\r\n顯示數據:子分類名稱', 'category', 'div_category_name_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (6, '資訊列表(標題)', '風格作用:顯示站內資訊\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:資訊標題', 'spacenews', 'item_subject_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (7, '資訊(圖文)', '風格作用:顯示站內圖文資訊\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:資訊標題、資訊圖片', 'spacenews', 'item_image_subject_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (8, '資訊(幻燈片)', '風格作用:顯示站內圖片資訊\r\n展示方式:以幻燈片方式顯示\r\n顯示數據:資訊標題、資訊圖片', 'spacenews', 'item_subject_pic');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (9, '資訊列表(分組+標題+日期)', '風格功能:顯示站內資訊\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:資訊標題、資訊發佈時間\r\n風格備註:每5條資訊為一組，中間用&lt;ul&gt;標籤分隔', 'spacenews', 'item_subject_list_dateline');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (10, '熱點資訊列表', '風格功能:顯示熱點資訊\r\n展示方式:以&lt;div&gt;區域顯示\r\n顯示數據:資訊標題', 'spacenews', 'div_item_subject_hot_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (11, '投票列表(標題)', '風格功能:顯示站內投票\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:投票標題', 'poll', 'item_subject_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (12, '投票列表(表單)', '風格功能:顯示站內投票\r\n展示方式:以並排方式顯示\r\n顯示數據:投票表單', 'poll', 'poll');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (13, '日誌列表(標題)', '風格功能:顯示日誌\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:日誌標題', 'spaceblog', 'item_subject_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (14, '日誌列表(標題+內容)', '風格功能:顯示日誌\r\n展示方式:以並排方式顯示\r\n顯示數據:日誌標題、如有圖片則顯示圖片、日誌部分內容', 'spaceblog', 'item_subject_message');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (15, '日誌列表(標題+用戶空間名)', '風格功能:顯示日誌\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:日誌標題、作者的空間名稱', 'spaceblog', 'item_subject_spacename');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (16, '日誌(幻燈片)', '風格功能:顯示圖文日誌\r\n展示方式:以幻燈片方式顯示\r\n顯示數據:日誌標題、日誌中的圖片', 'spaceblog', 'item_subject_pic');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (17, '日誌(分組)', '風格功能:顯示站內日誌\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:日誌標題\r\n風格備註:每5條日誌為一組，中間用&lt;ul&gt;標籤分隔', 'spaceblog', 'item_subject_span_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (18, '日誌列表(圖片)', '風格作用:顯示日誌圖片\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:日誌中的圖片\r\n風格備註:圖片大小限制為 93 x 93', 'spaceblog', 'item_image_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (19, '日誌列表(分組+標題+用戶空間名)', '風格功能:顯示站內日誌\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:日誌標題、用戶空間名\r\n風格備註:每5條日誌為一組，中間用&lt;ul&gt;標籤分隔', 'spaceblog', 'item_subject_span_list_spacename');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (20, '最新日誌列表', '風格功能:顯示最新日誌\r\n展示方式:以&lt;div&gt;區域顯示\r\n顯示數據:日誌標題\r\n風格備註:分兩列顯示日誌標題', 'spaceblog', 'div_item_subject_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (21, '最新信息列表(類別+標題)', '風格功能:顯示最新發佈信息\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:信息類別(日誌、資訊、圖片、商品、文件、書籤)、信息標題、信息發佈時間', 'spaceblog', 'item_subject_type');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (22, '圖片列表(圖片)', '風格作用:顯示用戶上傳圖片的縮略圖\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:圖片的縮略圖\r\n風格備註:縮略圖大小設置 93 x 93', 'spaceimage', 'item_image_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (23, '圖片展示(標題+圖片)', '風格作用:顯示用戶上傳圖片的縮略圖\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:圖片標題、圖片縮略圖\r\n風格備註:每6條信息一組，每組第一條設置&lt;li class=&quot;fristitem&quot;&gt;標籤', 'spaceimage', 'item_image_subject_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (24, '圖片列表(標題+圖片)', '風格作用:顯示用戶上傳圖片的縮略圖\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:圖片標題、圖片縮略圖\r\n風格備註:每4條信息一組，每組最後一條設置&lt;li class=&quot;lastitem&quot;&gt;標籤', 'spaceimage', 'image_subject_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (25, '圖片展示(幻燈片)', '風格作用:顯示用戶上傳圖片的縮略圖\r\n展示方式:以幻燈片方式顯示\r\n顯示數據:圖片標題、圖片縮略圖', 'spaceimage', 'item_pic_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (26, '文件列表(文件名+詳細信息)', '風格功能:顯示用戶上傳的文件\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:文件標題、文件描述、發佈時間、文件大小、操作系統、文件版權', 'spacefile', 'item_file_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (27, '文件列表(文件名+描述)', '風格功能:顯示用戶上傳的文件\r\n展示方式:以並排方式顯示\r\n顯示數據:文件名稱、文件描述、下載鏈接', 'spacefile', 'item_file');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (28, '文件列表(文件名)', '風格功能:顯示用戶上傳的文件\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:文件名稱', 'spacefile', 'item_subject_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (29, '商品列表(商品名+詳細信息)', '風格作用:顯示用戶發佈的商品\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:商品圖片、商品名稱、商品價格、商品描述、商品賣家\r\n風格備註:商品圖片限制為78 x 78', 'spacegoods', 'item_goods_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (30, '商品列表(商品名+價格)', '風格作用:顯示用戶發佈的商品\r\n展示方式:以並排方式顯示\r\n顯示數據:商品圖片、商品名、商品價格\r\n風格備註:商品圖片限制為 78 x 78', 'spacegoods', 'item_goods');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (31, '商品列表(商品名+圖片)', '風格作用:顯示用戶發佈的商品\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:商品圖片、商品標題\r\n風格備註:商品圖片大小限制為 78 x 78  每5條信息一組，每組第一個設置&lt;li class=&quot;fristitem&quot;&gt;標籤，每組最後一個設置&lt;li class=&quot;lastitem&quot;&gt;標籤', 'spacegoods', 'item_goods_subject_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (32, '書籤列表', '風格作用:顯示用戶發佈的書籤\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:書籤標題', 'spacelink', 'item_subject_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (33, 'TAG名列表(列表)', '風格作用:顯示站內TAG名\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:TAG名稱\r\n風格備註:TAG名顏色隨機變化', 'tag', 'tag_tagname_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (34, 'TAG名', '風格作用:顯示站內TAG名\r\n展示方式:以並排方式顯示\r\n顯示數據:TAG名稱\r\n風格備註:TAG名顏色隨機變化', 'tag', 'tag_tagname');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (35, 'TAG列表(標題)', '風格作用:顯示站內TAG信息\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:TAG信息標題', 'spacetag', 'item_subject_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (36, '回復列表', '風格功能:顯示用戶空間的信息回復\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:回復的部分內容', 'spacecomment', 'item_subject_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (37, '用戶空間列表(空間名)', '風格作用:顯示用戶空間名\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:用戶空間名稱', 'userspace', 'space_name_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (38, '用戶空間列表(空間名+用戶名)', '風格作用:顯示用戶空間名\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:用戶空間名稱、用戶名', 'userspace', 'space_name_user');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (39, '用戶空間列表(空間名+用戶頭像)', '風格作用:顯示用戶空間名\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:用戶空間名、用戶頭像\r\n風格備註:每3個一組，每組第一個設置&lt;li class=&quot;star1&quot;&gt;標籤', 'userspace', 'space_photo_name_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (40, '用戶空間(幻燈片)', '風格作用:顯示用戶空間\r\n展示方式:以幻燈片方式顯示\r\n顯示數據:用戶空間名稱、用戶頭像', 'userspace', 'space_name_pic');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (41, '最新更新個人空間列表', '風格作用:顯示最新更新的個人空間名\r\n展示方式:以&lt;div&gt;標籤區域顯示\r\n顯示數據:用戶空間名、用戶名', 'userspace', 'div_space_name_user');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (42, '論壇主題列表(標題)', '風格功能:顯示論壇主題\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:帖子標題', 'bbsthread', 'thread_subject_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (43, '論壇主題列表(標題+作者)', '風格功能:顯示論壇主題\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:帖子標題、帖子作者', 'bbsthread', 'thread_subject_author');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (44, '論壇主題列表(標題+內容)', '風格功能:顯示論壇主題\r\n展示方式:以&lt;dd&gt;標籤列表顯示\r\n顯示數據:論壇主題貼標題、主題貼部分內容', 'bbsthread', 'thread_subject_message');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (45, '論壇公告列表', '風格作用:顯示論壇公告\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:論壇公告標題', 'bbsannouncement', 'thread_subject_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (46, '論壇版塊列表', '風格作用:顯示論壇版塊\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:論壇版塊名', 'bbsforum', 'bbs_forums_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (47, '論罈子版塊', '風格功能:顯示論罈子版塊\r\n展示方式:以&lt;div&gt;區域顯示\r\n顯示數據:子版塊名稱', 'bbsforum', 'div_bbs_forums_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (48, '論壇友情鏈接', '風格作用:顯示論壇中的友情鏈接\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:友情鏈接logo和鏈接名\r\n風格備註:先顯示有logo的友情鏈接,再顯示無logo的友情鏈接名', 'bbslink', 'bbs_links_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (49, '論壇會員列表(會員名)', '風格功能:顯示論壇會員\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:論壇會員名', 'bbsmember', 'member_name_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (50, '論壇會員列表(會員名+詳細信息)', '風格功能:顯示論壇會員\r\n展示方式:以並排方式\r\n顯示數據:會員頭像、會員名、會員發帖總數、會員積分', 'bbsmember', 'member_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (51, '論壇附件列表', '風格作用:顯示論壇帖子中的附件\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:附件的文件名', 'bbsattachment', 'bbs_attach_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (52, '論壇圖片顯示', '風格作用:顯示論壇圖片附件\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:圖片附件、帖子標題\r\n風格備註:每6條信息一組，每組第一個設置&lt;li class=&quot;fristitem&quot;&gt;標籤', 'bbsattachment', 'item_image_subject_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (53, '論壇帖子列表', '風格功能:顯示論壇帖子\r\n展示方式:以&lt;li&gt;標籤列表顯示\r\n顯示數據:帖子標題、如帶有附件，則顯示附件文件名', 'bbspost', 'bbs_posts_list');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (54, '論壇貼圖顯示(滾動)', '風格作用:顯示論壇圖片附件\r\n展示方式:以不間斷滾動模式顯示圖片\r\n顯示數據:圖片、圖片所在主題的標題', 'bbsattachment', 'bbs_image_subject_list_td');
INSERT INTO supe_styles (tplid, tplname, tplnote, tpltype, tplfilepath) VALUES (55, '論壇公告列表(幻燈)', '風格作用:顯示論壇公告\r\n展示方式:以隱顯交替的幻燈方式顯示公告\r\n顯示數據:論壇公告標題', 'bbsannouncement', 'bbs_announcement_js_list');


-- 
-- 表的結構 'supe_tagcache'
-- 

DROP TABLE IF EXISTS supe_tagcache;
CREATE TABLE supe_tagcache (
  cachekey varchar(16) NOT NULL default '',
  uid mediumint(8) unsigned NOT NULL default '0',
  cachename varchar(20) NOT NULL default '',
  `value` mediumtext NOT NULL default '',
  updatetime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (cachekey)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_tags'
-- 

DROP TABLE IF EXISTS supe_tags;
CREATE TABLE supe_tags (
  tagid mediumint(8) unsigned NOT NULL auto_increment,
  tagname char(20) NOT NULL default '',
  uid mediumint(8) unsigned NOT NULL default '0',
  username char(15) NOT NULL default '',
  dateline int(10) unsigned NOT NULL default '0',
  `close` tinyint(1) NOT NULL default '0',
  spaceallnum mediumint(8) unsigned default '0',
  spacenewsnum mediumint(8) unsigned default '0',
  spaceblognum mediumint(8) unsigned default '0',
  spaceimagenum mediumint(8) unsigned NOT NULL default '0',
  spacefilenum mediumint(8) unsigned default '0',
  spacegoodsnum mediumint(8) unsigned default '0',
  spacelinknum mediumint(8) unsigned default '0',
  relativetags char(255) NOT NULL default '',
  PRIMARY KEY  (tagid),
  KEY tagname (tagname),
  KEY tagid (tagid,dateline)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_tracks'
-- 

DROP TABLE IF EXISTS supe_tracks;
CREATE TABLE supe_tracks (
  uid mediumint(8) unsigned NOT NULL default '0',
  itemid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (uid,itemid)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_usercss'
-- 

DROP TABLE IF EXISTS supe_usercss;
CREATE TABLE supe_usercss (
  id mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  `name` varchar(20) NOT NULL default '',
  css text NOT NULL default '',
  dateline int(10) unsigned NOT NULL default '0',
  thumb varchar(150) NOT NULL default '',
  image varchar(150) NOT NULL default '',
  isshare tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY isshare (isshare),
  KEY uid (uid)
) TYPE=MyISAM;

-- 
-- 表的結構 'supe_userfields'
-- 

DROP TABLE IF EXISTS supe_userfields;
CREATE TABLE supe_userfields (
  uid mediumint(8) unsigned NOT NULL auto_increment,
  nickname char(30) NOT NULL default '',
  sex char(4) NOT NULL default '',
  birthyear smallint(4) unsigned NOT NULL default '0',
  birthmonth tinyint(2) unsigned NOT NULL default '0',
  birthday tinyint(2) unsigned NOT NULL default '0',
  marriage char(4) NOT NULL default '',
  star char(6) NOT NULL default '',
  folk char(10) NOT NULL default '',
  bloodtype char(2) NOT NULL default '',
  tall char(14) NOT NULL default '',
  weight tinyint(3) unsigned NOT NULL default '0',
  native char(60) NOT NULL default '',
  figure char(10) NOT NULL default '',
  email char(100) NOT NULL default '',
  email2 char(100) NOT NULL default '',
  email3 char(100) NOT NULL default '',
  qq char(12) NOT NULL default '',
  msn char(100) NOT NULL default '',
  phone char(20) NOT NULL default '',
  mobile char(12) NOT NULL default '',
  address char(100) NOT NULL default '',
  postalcode char(18) NOT NULL default '',
  edu char(12) NOT NULL default '',
  school char(50) NOT NULL default '',
  job char(20) NOT NULL default '',
  position char(20) NOT NULL default '',
  income char(15) NOT NULL default '',
  housing char(15) NOT NULL default '',
  smoke char(15) NOT NULL default '',
  drink char(24) NOT NULL default '',
  interest char(100) NOT NULL default '',
  PRIMARY KEY  (uid)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_usergroups'
-- 

DROP TABLE IF EXISTS supe_usergroups;
CREATE TABLE supe_usergroups (
  groupid smallint(6) unsigned NOT NULL default '0',
  allowspace tinyint(1) NOT NULL default '0',
  allowspaceblog tinyint(1) NOT NULL default '0',
  allowspaceimage tinyint(1) NOT NULL default '0',
  allowspacefile tinyint(1) NOT NULL default '0',
  allowspacegoods tinyint(1) NOT NULL default '0',
  allowspacelink tinyint(1) NOT NULL default '0',
  attachsize int(12) unsigned NOT NULL default '0',
  allownews tinyint(1) NOT NULL default '0',
  needcheck tinyint(1) NOT NULL default '1',
  allowcheck tinyint(1) NOT NULL default '0',
  allowblogimport tinyint(1) NOT NULL default '0',
  allowbbsimport tinyint(1) NOT NULL default '0',
  allowcheckitem tinyint(1) NOT NULL default '0',
  allowundelete tinyint(1) NOT NULL default '0',
  allowdomain tinyint(1) NOT NULL default '0',
  allowcorpus tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (groupid)
) TYPE=MyISAM;

-- 
-- 導出表中的數據 'supe_usergroups'
-- 

INSERT INTO supe_usergroups (groupid, allowspace, allowspaceblog, allowspaceimage, allowspacefile, allowspacegoods, allowspacelink, attachsize, allownews, needcheck, allowcheck, allowblogimport, allowbbsimport, allowcheckitem, allowundelete, allowdomain, allowcorpus) VALUES (1, 1, 1, 1, 1, 1, 1, 104857600, 1, 0, 1, 1, 1, 1, 1, 1, 1);


-- 
-- 表的結構 'supe_userlinks'
-- 

DROP TABLE IF EXISTS supe_userlinks;
CREATE TABLE supe_userlinks (
  linkid smallint(6) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  name char(50) NOT NULL default '',
  note char(200) NOT NULL default '',
  logo char(100) NOT NULL default '',
  url char(100) NOT NULL default '',
  viewnum smallint(6) unsigned NOT NULL default '0',
  displayorder smallint(6) unsigned NOT NULL default '0',
  PRIMARY KEY  (linkid),
  KEY uid (uid,displayorder)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_userprofile'
-- 

DROP TABLE IF EXISTS supe_userprofile;
CREATE TABLE supe_userprofile (
  proid smallint(6) unsigned NOT NULL auto_increment,
  available tinyint(1) NOT NULL default '0',
  invisible tinyint(1) NOT NULL default '0',
  title varchar(50) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  size tinyint(3) unsigned NOT NULL default '0',
  required tinyint(1) NOT NULL default '0',
  selective tinyint(1) NOT NULL default '0',
  choices text NOT NULL default '',
  displayorder smallint(6) NOT NULL default '0',
  PRIMARY KEY  (proid)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_userspacefields'
-- 

DROP TABLE IF EXISTS supe_userspacefields;
CREATE TABLE supe_userspacefields (
  uid mediumint(8) unsigned NOT NULL default '0',
  perpage tinyint(3) unsigned NOT NULL default '0',
  announcement text NOT NULL default '',
  showblocks varchar(100) NOT NULL default '',
  blocknames text NOT NULL default '',
  summarylen smallint(6) unsigned NOT NULL default '0',
  attachsize int(12) unsigned NOT NULL default '0',
  jammer tinyint(1) NOT NULL default '0',
  blogmod tinyint(1) NOT NULL default '1',
  blognum tinyint(3) unsigned NOT NULL default '0',
  imagenum tinyint(3) unsigned NOT NULL default '0',
  goodsnum tinyint(3) unsigned NOT NULL default '0',
  filenum tinyint(3) unsigned NOT NULL default '0',
  linknum tinyint(3) unsigned NOT NULL default '0',
  threadnum tinyint(3) unsigned NOT NULL default '0',
  othernum tinyint(3) unsigned NOT NULL default '0',
  flash text NOT NULL default '',
  music text NOT NULL default '',
  choiceblockleft text NOT NULL default '',
  choiceblockright text NOT NULL default '',
  choiceblockmain text NOT NULL default '',
  myblock1 text NOT NULL default '',
  myblock2 text NOT NULL default '',
  myblock3 text NOT NULL default '',
  myblock4 text NOT NULL default '',
  myblock5 text NOT NULL default '',
  layout tinyint(1) unsigned NOT NULL default '1',
  showside tinyint(1) NOT NULL default '0',
  diy text NOT NULL default '',
  PRIMARY KEY  (uid)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_userspaces'
-- 

DROP TABLE IF EXISTS supe_userspaces;
CREATE TABLE supe_userspaces (
  uid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  lastpost int(10) unsigned NOT NULL default '0',
  catid smallint(6) unsigned NOT NULL default '0',
  username char(15) NOT NULL default '',
  spacename char(50) NOT NULL default '',
  viewnum int(10) unsigned NOT NULL default '0',
  spaceallnum mediumint(8) unsigned NOT NULL default '0',
  spaceblognum mediumint(8) unsigned NOT NULL default '0',
  spaceimagenum mediumint(8) unsigned NOT NULL default '0',
  spacefilenum mediumint(8) unsigned NOT NULL default '0',
  spacegoodsnum mediumint(8) unsigned NOT NULL default '0',
  spacelinknum mediumint(8) unsigned NOT NULL default '0',
  province char(15) NOT NULL default '',
  city char(25) NOT NULL default '',
  domain char(20) NOT NULL default '',
  islock tinyint(1) NOT NULL default '0',
  isstar tinyint(1) NOT NULL default '0',
  photo char(3) NOT NULL default '',
  PRIMARY KEY  (uid),
  KEY islock (islock,lastpost),
  KEY catid (catid,islock,lastpost)
) TYPE=MyISAM;


-- 
-- 表的結構 'supe_visitors'
-- 

DROP TABLE IF EXISTS supe_visitors;
CREATE TABLE supe_visitors (
  uid mediumint(8) unsigned NOT NULL default '0',
  visitoruid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (uid,visitoruid),
  KEY uid (uid,dateline)
) TYPE=MyISAM;


-- 
-- 表的結構 `cdb_settings`
-- 

REPLACE INTO cdb_settings VALUES ('supe_siteurl', '$siteurl');
REPLACE INTO cdb_settings VALUES ('supe_sitename', '門戶首頁');
REPLACE INTO cdb_settings VALUES ('supe_status', '1');
REPLACE INTO cdb_settings VALUES ('supe_tablepre', '$stablepre');

REPLACE INTO supe_settings VALUES ('dbver', '2.0Final');