(2015-02-13, 02:52 PM)dragonexpert Wrote: I need to know the table structure of the Xenforo equivalent. If you know the name of the table, you can execute this query to give the structure:
SHOW CREATE TABLE $x;
If it isn't clear which id is the person receiving feedback and who is giving feedback by column name, I'll let you know so you can use a specific example.
Sorry for the late reply.
Is this what you are looking for:
CREATE TABLE
xc_trade_feedback
(
fb_id
int(10) unsigned NOT NULL AUTO_INCREMENT,
foruserid
int(10) unsigned NOT NULL,
fromuserid
int(10) unsigned NOT NULL,
amount
tinyint(1) NOT NULL,
type
enum('buy','sell','trade') DEFAULT NULL,
review
varchar(255) NOT NULL,
dealurl
varchar(255) NOT NULL,
threadid
int(11) NOT NULL,
dateline
int(10) unsigned NOT NULL,
ip_id
int(10) unsigned NOT NULL,
importid
bigint(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (
fb_id
),
KEY
foruserid
(
foruserid
),
KEY
importid
(
importid
),
KEY
threadid
(
threadid
),
KEY
amount
(
amount
,
dateline
),
KEY
fromuserid
(
fromuserid
)
) ENGINE=InnoDB AUTO_INCREMENT=56178 DEFAULT CHARSET=utf8