Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE DA;
- CREATE TABLE DA.Users
- (
- UserID int AUTO_INCREMENT PRIMARY KEY,
- Name varchar(150),
- Sex varchar(20),
- Email varchar(150),
- Telephone int,
- Adress varchar(150),
- Locality varchar(150),
- Birthday int,
- Zipcode int,
- CCnum int,
- Isadmin bit
- ) engine = INNODB;
- CREATE TABLE DA.Zipcodes
- (
- Zipcode int PRIMARY KEY,
- Locality varchar(150),
- FOREIGN KEY (FK_ZipZipcode, UserID)
- REFERENCES DA.Users (UserID),
- FOREIGN KEY (FK_LocalityLocality, UserID)
- REFERENCES DA.Users (UserID)
- ) engine = INNODB;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement