PHP Classes

File: SQL File

Recommend this page to a friend!
  Classes of Andrea Bersi   Forms generator for MYSQL   db.sql   Download  
File: db.sql
Role: Auxiliary data
Content type: text/plain
Description: sql for creation data
Class: Forms generator for MYSQL
Generate forms to edit MySQL table records
Author: By
Last change: Sql for table lingue
Date: 18 years ago
Size: 970 bytes
 

Contents

Class file image Download 
CREATE TABLE `tb_prova` (
  `id` int(11) NOT NULL auto_increment,
  `id_tb_immobile` int(11) NOT NULL default '0',
  `DI` date NOT NULL default '0000-00-00',
  `DE` date NOT NULL default '0000-00-00',
  `persone` int(2) default NULL,
  `note` varchar(255) default NULL,
  `id_tb_utente` int(11) NOT NULL default '0' ,
  `confermato` enum('0','1') default '0',
  `data` date default NULL,
  `data_conferma` date default NULL,
  `lingua` varchar(50) NOT NULL,
  `radio` varchar(1) NOT NULL default '7',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

CREATE TABLE `lingue` (
  `id` int(11) NOT NULL auto_increment,
  `attivo` enum('0','1') collate latin1_general_ci default '0' ,
  `lingua` varchar(10) collate latin1_general_ci default NULL,
  `lng` varchar(3) collate latin1_general_ci default NULL ,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;