Changeset 1096 for devel/lib

Show
Ignore:
Timestamp:
05/13/07 20:11:31 (2 years ago)
Author:
sven
Message:

db schema - enforce a bit more uniqueness

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • devel/lib/db/mysql.sql

    r984 r1096  
    9797  `status` varchar(4) NOT NULL default 'perm' COMMENT 'not used?', 
    9898  PRIMARY KEY (`ident`), 
    99   KEY `owner` (`owner`), 
     99  UNIQUE KEY `owner` (`owner`, `friend`), 
    100100  KEY `friend` (`friend`), 
    101101  KEY `status` (`status`) 
    …… 
    113113  `friend` INT NOT NULL COMMENT '-> users.ident, being friended', 
    114114  PRIMARY KEY (`ident`) , 
    115   INDEX (`owner`) 
     115  UNIQUE KEY (`owner`,`friend`) 
    116116) ; 
    117117 
    …… 
    127127  `group_id` int(11) NOT NULL default '0' COMMENT '-> groups.ident', 
    128128  PRIMARY KEY (`ident`), 
    129   KEY `user_id` (`user_id`,`group_id`) 
     129  UNIQUE KEY `user_id` (`user_id`,`group_id`) 
    130130) ; 
    131131