Login   Register  
PHP Classes
elePHPant
Icontem

File: createtable.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Pierre FAUQUE  >  QCM Class  >  createtable.sql  >  Download  
File: createtable.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL Table structure for storage results
Class: QCM Class
Load, display and correct online questionnaires
Author: By
Last change:
Date: 9 years ago
Size: 887 bytes
 

Contents

Class file image Download
#-----------------------------------------------
# MySQL script to make the table to be used
# Pierre FAUQUE, mar 2005
#-----------------------------------------------

drop table if exists RTests;
create table RTests (
  idtest integer not null auto_increment,
  date datetime default '0000-00-00 00:00:00',
  lname varchar(25) default '',
  fname varchar(30) default '',
  email varchar(50) default '',
  tel varchar(10) default '',
  raddr varchar(15) default '0.0.0.0',
  idqcm mediumint default '0',
  version varchar(6) default '',
  duration varchar(8) default '00:00:00',
  nbq tinyint default '0',
  nbca tinyint default '0',
  nbia tinyint default '0',
  nbna tinyint default '0',
  skills decimal(6,2) 0.00,
  detail mediumtext default '',
  fdetails mediumtext default '',
  primary key (idtest)
) type=MyISAM comment='Table of online tests results';