Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `Utente` (
- `username` VARCHAR(20) NOT NULL,
- `email` VARCHAR(50) NOT NULL,
- `password` VARCHAR(10) NOT NULL,
- `nome` VARCHAR(20) DEFAULT NULL,
- `cognome` VARCHAR(20) DEFAULT NULL,
- `nascita` DATE(10) DEFAULT NULL,
- `residenza` VARCHAR(20) DEFAULT NULL,
- `sesso` ENUM DEFAULT NULL,
- `cellulare` VARCHAR(11) DEFAULT NULL,
- `foto` BLOB,
- `behance` VARCHAR(512) DEFAULT NULL,
- `instagram` VARCHAR(512) DEFAULT NULL,
- `facebook` VARCHAR(512) DEFAULT NULL,
- `sito` VARCHAR(512) DEFAULT NULL,
- `linkedin` VARCHAR(512) DEFAULT NULL,
- PRIMARY KEY (`username`)
- UNIQUE KEY (‘email’)
- UNIQUE KEY (‘facebook’)
- UNIQUE KEY (‘linkedin’)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement