File: rt77378.sql

package info (click to toggle)
libdbix-runsql-perl 0.25-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 248 kB
  • sloc: perl: 786; sql: 26; makefile: 10
file content (15 lines) | stat: -rw-r--r-- 346 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 
CREATE TABLE user (
 id             INTEGER PRIMARY KEY,
 name           VARCHAR(255)
);
CREATE TABLE emails (
 uid    INTEGER NOT NULL,
 name   VARCHAR(255) UNIQUE NOT NULL,
 FOREIGN KEY (uid) REFERENCES user(id)
);

CREATE TRIGGER user_cleanup
 BEFORE DELETE ON user FOR EACH ROW
 BEGIN
  DELETE FROM email WHERE uid=OLD.id;
 END;