PHP Classes
elePHPant
Icontem

File: MySQL_Test_Schema.sql

Recommend this page to a friend!
  Classes of Aziz S. Hussain  >  mysql_* functions using PDO  >  MySQL_Test_Schema.sql  >  Download  
File: MySQL_Test_Schema.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL data required for unit test
Class: mysql_* functions using PDO
Access MySQL databases using PDO wrapper functions
Author: By
Last change: Release V1.1 - Bug Fixes
Date: 3 years ago
Size: 441 bytes
 

Contents

Class file image Download 
DROP DATABASE IF EXISTS unit_sql_v_1;
DROP DATABASE IF EXISTS unit_sql_v_2;
CREATE DATABASE unit_sql_v_1;
CREATE TABLE `unit_sql_v_1`.`unit_sql_table_1` (
  `field_id` bigint(20) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `field_name` varchar(200) DEFAULT NULL,
  `field_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1