ここの情報は古いです。ご理解頂いた上でお取り扱いください。

Ignore:
Timestamp:
Jul 29, 2008, 2:04:24 AM (13 years ago)
Author:
ebihara
Message:

#2860:フレンドリンク機能の追加

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE3/trunk/data/sql/lib.model.schema.sql

    r7851 r7855  
    133133)Type=InnoDB;
    134134
     135#-----------------------------------------------------------------------------
     136#-- friend
     137#-----------------------------------------------------------------------------
     138
     139DROP TABLE IF EXISTS `friend`;
     140
     141
     142CREATE TABLE `friend`
     143(
     144        `id` INTEGER  NOT NULL AUTO_INCREMENT,
     145        `member_id_to` INTEGER  NOT NULL,
     146        `member_id_from` INTEGER  NOT NULL,
     147        PRIMARY KEY (`id`),
     148        UNIQUE KEY `member_id_to_from` (`member_id_to`, `member_id_from`),
     149        UNIQUE KEY `member_id_from_to` (`member_id_from`, `member_id_to`),
     150        CONSTRAINT `friend_FK_1`
     151                FOREIGN KEY (`member_id_to`)
     152                REFERENCES `member` (`id`),
     153        CONSTRAINT `friend_FK_2`
     154                FOREIGN KEY (`member_id_from`)
     155                REFERENCES `member` (`id`)
     156)Type=InnoDB;
     157
    135158# This restores the fkey checks, after having unset them earlier
    136159SET FOREIGN_KEY_CHECKS = 1;
Note: See TracChangeset for help on using the changeset viewer.