PHP Classes

File: test.sql

Recommend this page to a friend!
  Classes of Martin Latter   PHP Database Fill   test.sql   Download  
File: test.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP Database Fill
Fill records of MySQL tables with test data
Author: By
Last change: Update of test.sql
Date: 6 days ago
Size: 2,687 bytes
 

Contents

Class file image Download
/** * Test database for Database Filler. * * Includes a variety of MySQL datatypes and several formatting quirks. * Created for MySQL 5.x * * @author Martin Latter * @copyright Martin Latter 13/12/2014 * @version 0.06 * @license GNU GPL version 3.0 (GPL v3); http://www.gnu.org/licenses/gpl.html * @link https://github.com/Tinram/Database-Filler.git */ CREATE DATABASE IF NOT EXISTS dbfilltest CHARACTER SET utf8 COLLATE utf8_general_ci; USE dbfilltest; CREATE TABLE IF NOT EXISTS `test_datatypes` ( `td_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `sku` CHAR(20) NOT NULL, `EAN` CHAR(13) DEFAULT NULL, `huge_quantity` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `quantity` INT(10) UNSIGNED NOT NULL DEFAULT 0, `med_quantity` MEDIUMINT(7) UNSIGNED NOT NULL DEFAULT 0, `small_quantity` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0, `tiny_quantity` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, `negative_quantity` INT(10) NOT NULL DEFAULT 0, `price` DECIMAL(10, 2) NOT NULL DEFAULT 0.00, `val_float` FLOAT(20, 2) NOT NULL DEFAULT 0.00, `val_double` DOUBLE(40, 4) NOT NULL DEFAULT 0.0000 COMMENT 'normal schema comment', `enumerator` ENUM('a', 'b', 'c', 'd'), `flag` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `code` CHAR(2) NOT NULL DEFAULT '' , -- deliberate whitespace `notes` VARCHAR(255) NOT NULL DEFAULT '', `tinytxt` TINYTEXT COMMENT "badly placed schema comment" NOT NULL, `added_date` DATE NOT NULL, `added_dtime` DATETIME NOT NULL, `added_time` TIME NOT NULL, `ts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, KEY `flag` (`flag`), PRIMARY KEY (`td_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `logger` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `message` VARCHAR(255) NOT NULL, `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `logger2` ( `logger2_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `counter` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0, `message` VARCHAR(255) NOT NULL, `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`logger2_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;