PHP Classes

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: Update of MySQL_Test_Schema.sql
Date: 5 years ago
Size: 433 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