group.sql 308 B

1234567
  1. CREATE TABLE `group`
  2. (
  3. id INT unsigned AUTO_INCREMENT PRIMARY KEY COMMENT '自增id',
  4. name varchar(10) NOT NULL DEFAULT '' COMMENT '分组名称',
  5. user_id INT unsigned NOT NULL DEFAULT 0 COMMENT '用户id',
  6. parent_id INT unsigned COMMENT '父级组ID'
  7. )COMMENT='分组信息表'