install.sql 508 B

123456789
  1. CREATE TABLE `__PREFIX__invite` (
  2. `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  3. `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  4. `invited_user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '被邀请人',
  5. `ip` varchar(50) NOT NULL DEFAULT '' COMMENT '注册IP',
  6. `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  7. PRIMARY KEY (`id`),
  8. KEY `user_id` (`user_id`)
  9. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='邀请表';