File: alpha.sql

package info (click to toggle)
librose-db-object-perl 1%3A0.822-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 4,416 kB
  • sloc: perl: 79,681; sql: 28; makefile: 7
file content (15 lines) | stat: -rw-r--r-- 515 bytes parent folder | download | duplicates (9) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 
DROP TABLE IF EXISTS friends;
DROP TABLE IF EXISTS members;

CREATE TABLE members      (    
    id          INT UNSIGNED    NOT NULL AUTO_INCREMENT PRIMARY KEY,
    user        VARCHAR(255)    NOT NULL,
    UNIQUE ( user )
) TYPE = InnoDB;

CREATE TABLE friends (
    id          INT UNSIGNED    NOT NULL AUTO_INCREMENT PRIMARY KEY,
    member_id   INT UNSIGNED    NOT NULL,
    reference   VARCHAR(255)    NOT NULL,    
    FOREIGN KEY ( member_id ) REFERENCES members ( id ) ON DELETE CASCADE
) Engine = InnoDB;