Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE locale (
- locale_id INT NOT NULL AUTO_INCREMENT,
- locale_code VARCHAR(8) NOT NULL,
- PRIMARY KEY (locale_id),
- UNIQUE(locale_id)
- );
- CREATE TABLE provider (
- provider_id INT NOT NULL AUTO_INCREMENT,
- url VARCHAR(450) NOT NULL,
- locale_id INT NOT NULL,
- PRIMARY KEY (provider_id),
- FOREIGN KEY (locale_id) REFERENCES locale,
- UNIQUE(provider_id)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement