爱秀代码 » Sclub模板修改与美化 » 插件数据库

icode 发表于 2020-4-5 13:54

插件数据库

点评（楼中楼）[code]CREATE TABLE  `zy_postinner` (
`uid` INT( 8 ) NOT NULL ,
`name` CHAR( 15 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`pid` INT( 15 ) NOT NULL ,
`ptid` INT( 15 ) NOT NULL ,
`msg` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`time` INT( 10 ) NOT NULL
) ENGINE = MYISAM ;
ALTER TABLE  `cdb_posts` ADD  `zy_postinner` INT( 5 ) NOT NULL ;[/code]艾特[code]ALTER TABLE  `cdb_posts` ADD  `zy_at` INT NOT NULL ;
ALTER TABLE  `cdb_posts` CHANGE  `zy_at`  `zy_at` VARCHAR( 32 ) NOT NULL;
CREATE TABLE  `zy_at` (
`aid` INT NOT NULL ,
`ater` VARCHAR( 45 ) NOT NULL ,
`title` VARCHAR( 300 ) NOT NULL ,
`date` INT NOT NULL ,
`atman` VARCHAR( 45 ) NOT NULL ,
`readed` SMALLINT NOT NULL ,
`tid` INT NOT NULL ,
`pid` INT NOT NULL ,
`floor` INT NOT NULL
) ENGINE = MYISAM ;
ALTER TABLE  `cdb_members` ADD  `zy_at` INT NOT NULL ;
ALTER TABLE  `zy_at` ADD PRIMARY KEY (  `aid` );
ALTER TABLE  `zy_at` CHANGE  `ater`  `ater` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE  `zy_at` CHANGE  `title`  `title` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE  `zy_at` CHANGE  `atman`  `atman` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE  `cdb_posts` ADD  `zy_at_man` TEXT NOT NULL ;
ALTER TABLE  `cdb_posts` CHANGE  `zy_at_man`  `zy_at_man` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;[/code]聊天室[code]CREATE TABLE  `zy_chatroom` (
`pid` INT( 10 ) NOT NULL ,
`uid` INT( 10 ) NOT NULL ,
`name` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`message` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`time` INT( 15 ) NOT NULL
) ENGINE = MYISAM ;[/code]回帖奖励[code]ALTER TABLE  `cdb_posts` ADD  `zy_replyaward` TEXT NOT NULL ;
ALTER TABLE  `cdb_threads` ADD  `zy_replyaward` TEXT NOT NULL ;[/code]许愿墙[code]CREATE TABLE  `zy_lovewall` (
`uid` INT( 10 ) NOT NULL ,
`name` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`pid` INT( 10 ) NOT NULL ,
`message` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`x` INT( 3 ) NOT NULL ,
`y` INT( 3 ) NOT NULL ,
`paper` INT( 3 ) NOT NULL ,
`time` INT( 11 ) NOT NULL
) ENGINE = MYISAM ;[/code]发帖机遇[code]CREATE TABLE zy_ftjy (
jid int(10),
word text,
credit int(6),
min int(6),
max int(6),
rate int(4),
kind tinyint(1)
);
ALTER TABLE  `zy_ftjy` ADD PRIMARY KEY (  `jid` );
INSERT INTO zy_ftjy (jid,word,credit,min,max,rate,kind) VALUES (0,"",0,10,10,0,0);
ALTER TABLE  `cdb_posts` ADD  `zy_jiyu` INT(11) NOT NULL ;
ALTER TABLE  `cdb_posts` ADD  `zy_get` INT(6) NOT NULL ;
UPDATE cdb_posts SET zy_jiyu = -1;
ALTER TABLE  `zy_ftjy` CHANGE  `word`  `word` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL[/code]帖子脚印[code]ALTER TABLE  `cdb_threads` ADD  `zy_footprint` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;[/code]

天使小小 发表于 2020-4-6 09:47

[attach]768[/attach]

[size=7][color=Red][b]还有这个数据库没有，游客打开帖子内容页是这样的。[/b][/color][/size]

天使小小 发表于 2020-4-6 09:51

[attach]769[/attach]
[size=7][color=Red][b]还有这个数据库没有，游客打开帖子内容页是这样的。[/b][/color][/size]

icode 发表于 2020-4-6 12:45

[b]回复 [url=http://icode.258club.com/redirect.php?goto=findpost&pid=43613&ptid=1704]3#[/url] [i]天使小小[/i] [/b]


    viewthread_fastpost.htm恢复为默认模板

天使小小 发表于 2020-4-9 10:15

[b]回复 [url=http://icode.258club.com/redirect.php?goto=findpost&pid=43614&ptid=1704]4#[/url] [i]icode[/i] [/b]


    模板还有很多数据库问题，请问能不能把你整个数据库导出来，让我导入我论坛内这样可以解决到很多模板的数据问题吗？

查看完整版本: 插件数据库