PHP Classes

File: SQL File

Recommend this page to a friend!
  Classes of Rodrigo Faustino   Face ID PHP   app/Database/import.sql   Download  
File: app/Database/import.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Face ID PHP
Recognize faces by analyzing image descriptors
Author: By
Last change:
Date: 2 months ago
Size: 508 bytes
 

Contents

Class file image Download 
USE `faceid`;
CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nome` varchar(145) DEFAULT NULL,
  `registro` varchar(45) DEFAULT NULL,
  `email` varchar(245) DEFAULT NULL,
  `senha` text,
  PRIMARY KEY (`id`)
) ;

CREATE TABLE `faces` (
  `id` int NOT NULL AUTO_INCREMENT,
  `idusers` int DEFAULT NULL,
  `faces` mediumtext,
  PRIMARY KEY (`id`),
  KEY `fk_faces_idx` (`idusers`),
  CONSTRAINT `fk_faces` FOREIGN KEY (`idusers`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ;