2008-6-8 00:40
iat
@@
這次則變了這個./
升級錯誤，MySQL 提示: Duplicate column name 'board_name' ，請返回。
阿阿阿... 我把sql傳上來麻煩sai您幫我改改可以嗎?
沒附件只好用code..
[code]--
-- Project Parasynthesis Database Structure
--
-- [EN] You should change the `cdb_` as the same as the $tablepre in config.inc.php
-- [CN] 如果你更改過數據庫表明前綴 請批量替換 `cdb_` 為你在 config.inc.php 中設置的 $tablepre
--
--
-- BIG5
--
ALTER TABLE `cdb_forums` ADD `board_name` char(50) NOT NULL;
ALTER TABLE `cdb_forums` ADD `idx_push` tinyint(1) NOT NULL default '0';
ALTER TABLE `cdb_favorites` ADD `dateline` int(10) NOT NULL;
ALTER TABLE `cdb_members` ADD `now_img` mediumint(10) NOT NULL default '0';
ALTER TABLE `cdb_members` ADD `idx_cloud` tinyint(1) NOT NULL default '0';
ALTER TABLE `cdb_members` ADD `usr_geo` varchar(100) NOT NULL default 'earth';
--
-- Table structure for table `cdb_savepoint`
--
CREATE TABLE `cdb_savepoint` (
`svp_id` int(10) unsigned NOT NULL auto_increment,
`svp_uid` int(10) unsigned NOT NULL default '0',
`svp_url` varchar(255) NOT NULL default '',
`svp_rank` int(10) unsigned NOT NULL default '0',
`svp_created` int(10) unsigned NOT NULL default '0',
`svp_lastupdated` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`svp_id`),
KEY `INDEX_UID` (`svp_uid`),
KEY `INDEX_URL` (`svp_url`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `cdb_geo_usage_simple`
--
CREATE TABLE `cdb_geo_usage_simple` (
`gus_geo` varchar(100) NOT NULL default 'earth',
`gus_name_cn` varchar(100) NOT NULL default '地球',
`gus_name_en` varchar(100) NOT NULL default 'Earth',
`gus_hits` int(10) unsigned NOT NULL default '0',
`gus_lastupdated` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`gus_geo`),
UNIQUE KEY `INDEX_NAME_CN` (`gus_name_cn`),
UNIQUE KEY `INDEX_NAME_EN` (`gus_name_en`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `cdb_geo_going`
--
CREATE TABLE `cdb_geo_going` (
`ggg_id` int(10) unsigned NOT NULL auto_increment,
`ggg_uid` int(10) unsigned NOT NULL default '0',
`ggg_geo` varchar(100) NOT NULL,
`ggg_impression` text,
`ggg_created` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`ggg_id`),
KEY `INDEX_UID` (`ggg_uid`),
KEY `INDEX_GEO` (`ggg_geo`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `cdb_geo_been`
--
CREATE TABLE `cdb_geo_been` (
`gbn_id` int(10) unsigned NOT NULL auto_increment,
`gbn_uid` int(10) unsigned NOT NULL default '0',
`gbn_geo` varchar(100) NOT NULL,
`gbn_impression` text,
`gbn_created` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`gbn_id`),
KEY `INDEX_UID` (`gbn_uid`),
KEY `INDEX_GEO` (`gbn_geo`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `cdb_plugin_now`
--
CREATE TABLE IF NOT EXISTS `cdb_plugin_now` (
`vid` mediumint(8) NOT NULL auto_increment,
`dateline` int(10) NOT NULL default '0',
`author` varchar(15) NOT NULL default '',
`authorid` mediumint(8) NOT NULL default '0',
`content` varchar(250) NOT NULL default '',
`background` varchar(35) NOT NULL default '',
`icons` int(2) NOT NULL default '0',
PRIMARY KEY (`vid`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `cdb_plugin_now_stats`
--
CREATE TABLE IF NOT EXISTS `cdb_plugin_now_stats` (
`uid` mediumint(8) NOT NULL default '0',
`total` int(10) NOT NULL default '0',
`monthly` int(10) NOT NULL default '0',
`weekly` int(10) NOT NULL default '0',
`daily` mediumtext NOT NULL,
`firstupdate` int(10) NOT NULL default '0',
`lastupdate` int(10) NOT NULL default '0',
PRIMARY KEY (`uid`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `cdb_expense`
--
CREATE TABLE `cdb_expense` (
`exp_id` int(10) unsigned NOT NULL auto_increment,
`exp_uid` int(10) unsigned NOT NULL default '0',
`exp_amount` double NOT NULL default '0',
`exp_type` int(10) unsigned NOT NULL default '0',
`exp_memo` text,
`exp_created` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`exp_id`),
KEY `INDEX_UID` (`exp_uid`),
KEY `INDEX_TYPE` (`exp_type`),
KEY `INDEX_CREATED` (`exp_created`)
) ENGINE=MyISAM;
CREATE TABLE `cdb_plugin_tod_project` (
`tpr_id` int(10) unsigned NOT NULL auto_increment,
`tpr_uid` int(10) unsigned NOT NULL default '0',
`tpr_private` int(10) unsigned NOT NULL default '0',
`tpr_title` varchar(100) NOT NULL default '',
`tpr_progress` int(10) unsigned NOT NULL default '0',
`tpr_type` int(10) unsigned NOT NULL default '0',
`tpr_tasks` int(10) unsigned NOT NULL default '0',
`tpr_notes` int(10) unsigned NOT NULL default '0',
`tpr_dbs` int(10) unsigned NOT NULL default '0',
`tpr_created` int(10) unsigned NOT NULL default '0',
`tpr_lastupdated` int(10) unsigned NOT NULL default '0',
`tpr_lasttouched` int(10) unsigned NOT NULL default '0',
`tpr_completed` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tpr_id`),
KEY `INDEX_UID` (`tpr_uid`),
KEY `INDEX_PRIVATE` (`tpr_private`),
KEY `INDEX_PROGRESS` (`tpr_progress`)
) ENGINE=MyISAM;
CREATE TABLE `cdb_plugin_tod_task` (
`tta_id` int(10) unsigned NOT NULL auto_increment,
`tta_uid` int(10) unsigned NOT NULL default '0',
`tta_pid` int(10) unsigned NOT NULL default '0',
`tta_title` varchar(100) NOT NULL default '',
`tta_level` int(10) unsigned NOT NULL default '0',
`tta_todo` int(1) unsigned NOT NULL default '0',
`tta_progress` int(10) unsigned NOT NULL default '0',
`tta_created` int(10) unsigned NOT NULL default '0',
`tta_lastupdated` int(10) unsigned NOT NULL default '0',
`tta_lasttouched` int(10) unsigned NOT NULL default '0',
`tta_completed` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tta_id`),
KEY `INDEX_UID` (`tta_uid`),
KEY `INDEX_PID` (`tta_pid`),
KEY `INDEX_PROGRESS` (`tta_progress`)
) ENGINE=MyISAM;[/code]
麻煩了!