Non puoi selezionare più di 25 argomenti
Gli argomenti devono iniziare con una lettera o un numero, possono includere trattini ('-') e possono essere lunghi fino a 35 caratteri.
61 righe
2.1 KiB
61 righe
2.1 KiB
/*!40101 SET NAMES utf8 */; |
|
|
|
/*!40101 SET SQL_MODE=''*/; |
|
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; |
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; |
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; |
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; |
|
CREATE DATABASE /*!32312 IF NOT EXISTS*/`autenticazione` /*!40100 DEFAULT CHARACTER SET utf8 */; |
|
USE `autenticazione`; |
|
|
|
DROP TABLE IF EXISTS `logins`; |
|
CREATE TABLE `logins` ( |
|
`token` char(40) NOT NULL, |
|
`codice_fiscale` varchar(255) DEFAULT NULL, |
|
`nome` varchar(255) DEFAULT NULL, |
|
`cognome` varchar(255) DEFAULT NULL, |
|
`email` varchar(255) NULL DEFAULT NULL, |
|
`created_at` timestamp NULL DEFAULT NULL, |
|
`modified_at` timestamp NULL DEFAULT NULL, |
|
PRIMARY KEY (`token`) |
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
|
|
DROP TABLE IF EXISTS `sessions`; |
|
CREATE TABLE `sessions` ( |
|
`auth` char(40) NOT NULL, |
|
`user_id` int(10) unsigned NOT NULL, |
|
`username` varchar(255) NOT NULL, |
|
`created_at` timestamp NULL DEFAULT NULL, |
|
`modified_at` timestamp NULL DEFAULT NULL, |
|
PRIMARY KEY (`auth`) |
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
|
|
DROP TABLE IF EXISTS `tokens`; |
|
CREATE TABLE `tokens` ( |
|
`token` char(40) NOT NULL, |
|
`auth` char(40) NOT NULL, |
|
`callback` TEXT DEFAULT NULL, |
|
`created_at` timestamp NULL DEFAULT NULL, |
|
`modified_at` timestamp NULL DEFAULT NULL, |
|
PRIMARY KEY (`token`) |
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
|
|
DROP TABLE IF EXISTS `users`; |
|
CREATE TABLE `users` ( |
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
`username` varchar(255) NOT NULL, |
|
`password` char(64) NOT NULL, |
|
`remote` varchar(45) DEFAULT NULL, |
|
`use_cns` BOOLEAN NOT NULL DEFAULT TRUE, |
|
`created_at` timestamp NULL DEFAULT NULL, |
|
`modified_at` timestamp NULL DEFAULT NULL, |
|
`deleted_at` timestamp NULL DEFAULT NULL, |
|
PRIMARY KEY (`id`), |
|
UNIQUE KEY `users_username_remote_unique` (`username`,`remote`) |
|
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; |
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|