请问每个字段代表什么意思?- DROP TABLE IF EXISTS `pda_attachments`;
- CREATE TABLE `pda_attachments` (
- `aid` mediumint(8) unsigned NOT NULL auto_increment,
- `tid` mediumint(8) unsigned NOT NULL default '0',
- `pid` int(10) unsigned NOT NULL default '0',
- `dateline` int(10) unsigned NOT NULL default '0',
- `readperm` tinyint(3) unsigned NOT NULL default '0',
- `price` smallint(6) unsigned NOT NULL default '0',
- `filename` char(100) NOT NULL default '',
- `description` char(100) NOT NULL default '',
- `filetype` char(50) NOT NULL default '',
- `filesize` int(10) unsigned NOT NULL default '0',
- `attachment` char(100) NOT NULL default '',
- `downloads` mediumint(8) NOT NULL default '0',
- `isimage` tinyint(1) unsigned NOT NULL default '0',
- `uid` mediumint(8) unsigned NOT NULL default '0',
- `thumb` tinyint(1) unsigned NOT NULL default '0',
- `remote` tinyint(1) unsigned NOT NULL default '0',
- PRIMARY KEY (`aid`),
- KEY `tid` (`tid`),
- KEY `pid` (`pid`,`aid`),
- KEY `uid` (`uid`)
- ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=gbk;
复制代码 这是一个附件的数据:- INSERT INTO `pda_attachments` VALUES (1,16,16,1211690825,0,0,'crazybubbles_1.2.rar','','application/octet-stream',374691,'day_080525/20080525_335ad48cc84c49f6b292MBWJMACCDNLv.rar',0,0,1,0,0)
复制代码 配合以上字段怎么解释? |