$n = $db->index_update('user', array('uid' => array('>=' => 1)), array('posts' => 123));
$user = $db->get('user-uid-1');
bbs_assert("index_update()", $n == 3);
bbs_assert("index_update()", $user['posts'] == 123);
// 删除一条记录
$r = $db->delete("user-uid-1");
bbs_assert("delete('user-uid-1')", $r == TRUE);
$n = $db->count('user', '-1');
bbs_assert("count('user', '-1')", $n == 2);
$arr = $db->get("user-uid-1");
bbs_assert("delete('user-uid-1')", $arr == array());
// 翻页取数据
$n = $db->count('user');
bbs_assert("count('user')", $n == 2);
// 翻页取数据
$userlist = $db->index_fetch($table = 'user', $key = 'uid', $cond = array('uid' => array('>=' => 0)), $sort = array(), $start = 0, $limit = 10);
print_r($userlist);
// 删除所有数据
$n = $db->index_delete('user', array('uid' => array('>' => 1)));
$user = $db->get('user-uid-1');
$user2 = $db->get('user-uid-2');
bbs_assert("index_delete()", $user['uid'] != 1);
bbs_assert("index_delete()", empty($user));
// ------------------> 第二部分 primary key 为多个的时候 fid uid
$db->query("DROP TABLE IF EXISTS `bbs_fuser`");
$db->query("CREATE TABLE `bbs_fuser` (\n `fid` int(11) unsigned NOT NULL default '0',\t\t\t# fid\n `uid` int(11) unsigned NOT NULL default '0',\t\t# 用户id\n `regip` int(11) NOT NULL default '0',\t\t\t\t# 注册ip\n `regdate` int(11) unsigned NOT NULL default '0',\t\t# 注册日期\n `username` char(16) NOT NULL default '',\t\t\t# 用户名\n `password` char(32) NOT NULL default '',\t\t\t# 密码 md5()\n `salt` char(8) NOT NULL default '',\t\t\t\t# 随机干扰字符，用来混淆密码\n `email` char(40) NOT NULL default '',\t\t\t\t# EMAIL\n `groupid` tinyint(3) unsigned NOT NULL default '0',\t\t# 用户组 id\n `threads` mediumint(8) unsigned NOT NULL default '0',\t\t# 主题数\n `posts` mediumint(8) unsigned NOT NULL default '0',\t\t# 回帖数\n `avatar` int(11) unsigned NOT NULL default '0',\t\t# 头像最后更新的时间，0为默认头像\n KEY username(`username`),\n PRIMARY KEY (`fid`, `uid`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;");
$db->truncate('fuser');
$db->maxid('fuser-uid', 0);
$db->count('fuser', 0);
// 增加一条记录:
$uid = $db->maxid('fuser-uid', '+1');
