summaryrefslogtreecommitdiffstats
path: root/SQL dump/testdb.sql
diff options
context:
space:
mode:
authorJamie Cressey <jamiecressey89@googlemail.com>2014-07-05 16:14:09 -0400
committerJamie Cressey <jamiecressey89@googlemail.com>2014-07-05 16:14:09 -0400
commit9737cfe130e4a7a56eaa91ba0835efdedb9bceec (patch)
tree6ae1902ef09943295ecb3930fab2c7e10b3ba9ac /SQL dump/testdb.sql
parent66e72318fbac670abe640d62eaf0c87ef9498fb3 (diff)
downloadphp-mysql-pdo-database-class-9737cfe130e4a7a56eaa91ba0835efdedb9bceec.zip
php-mysql-pdo-database-class-9737cfe130e4a7a56eaa91ba0835efdedb9bceec.tar.gz
php-mysql-pdo-database-class-9737cfe130e4a7a56eaa91ba0835efdedb9bceec.tar.bz2
Clean up for my needs
Diffstat (limited to 'SQL dump/testdb.sql')
-rw-r--r--SQL dump/testdb.sql38
1 files changed, 0 insertions, 38 deletions
diff --git a/SQL dump/testdb.sql b/SQL dump/testdb.sql
deleted file mode 100644
index eadf3fb..0000000
--- a/SQL dump/testdb.sql
+++ /dev/null
@@ -1,38 +0,0 @@
-/*
-Navicat MySQL Data Transfer
-
-Source Server : localhost_3306
-Source Server Version : 50527
-Source Host : localhost:3306
-Source Database : testdb
-
-Target Server Type : MYSQL
-Target Server Version : 50527
-File Encoding : 65001
-
-Date: 2012-11-12 14:07:39
-*/
-
-SET FOREIGN_KEY_CHECKS=0;
-
--- ----------------------------
--- Table structure for `persons`
--- ----------------------------
-DROP TABLE IF EXISTS `persons`;
-CREATE TABLE `persons` (
- `Id` int(11) NOT NULL AUTO_INCREMENT,
- `Firstname` varchar(32) DEFAULT NULL,
- `Lastname` varchar(32) DEFAULT NULL,
- `Sex` char(1) DEFAULT NULL,
- `Age` tinyint(3) DEFAULT NULL,
- PRIMARY KEY (`Id`)
-) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
-
--- ----------------------------
--- Records of persons
--- ----------------------------
-INSERT INTO `persons` VALUES ('1', 'John', 'Doe', 'M', '19');
-INSERT INTO `persons` VALUES ('2', 'Bob', 'Black', 'M', '40');
-INSERT INTO `persons` VALUES ('3', 'Zoe', 'Chan', 'F', '21');
-INSERT INTO `persons` VALUES ('4', 'Sekito', 'Khan', 'M', '19');
-INSERT INTO `persons` VALUES ('5', 'Kader', 'Khan', 'M', '56');