From c80b4c7440de40b3da2e582dd94f9da62af51cd6 Mon Sep 17 00:00:00 2001 From: Wez Furlong Date: Thu, 7 Jul 2005 14:09:58 +0000 Subject: [PATCH] Need to state NOT NULL here, as DB2 won't allow the UNIQUE constraint without it. --- ext/pdo/tests/pdo_009.phpt | 2 +- ext/pdo/tests/pdo_010.phpt | 2 +- ext/pdo/tests/pdo_018.phpt | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/ext/pdo/tests/pdo_009.phpt b/ext/pdo/tests/pdo_009.phpt index 5194ff4e96..ded40c8be9 100644 --- a/ext/pdo/tests/pdo_009.phpt +++ b/ext/pdo/tests/pdo_009.phpt @@ -9,7 +9,7 @@ if (false == getenv('REDIR_TEST_DIR')) print 'skip no driver'; ?> require getenv('REDIR_TEST_DIR') . 'pdo_test.inc'; $db = PDOTest::factory(); -$db->exec('CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(10) UNIQUE)'); +$db->exec('CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(10) NOT NULL UNIQUE)'); $db->exec('INSERT INTO classtypes VALUES(0, \'stdClass\')'); $db->exec('INSERT INTO classtypes VALUES(1, \'Test1\')'); $db->exec('INSERT INTO classtypes VALUES(2, \'Test2\')'); diff --git a/ext/pdo/tests/pdo_010.phpt b/ext/pdo/tests/pdo_010.phpt index 8898f06702..9e8cecb576 100644 --- a/ext/pdo/tests/pdo_010.phpt +++ b/ext/pdo/tests/pdo_010.phpt @@ -9,7 +9,7 @@ if (false == getenv('REDIR_TEST_DIR')) print 'skip no driver'; ?> require getenv('REDIR_TEST_DIR') . 'pdo_test.inc'; $db = PDOTest::factory(); -$db->exec('CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(10) UNIQUE)'); +$db->exec('CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(10) NOT NULL UNIQUE)'); $db->exec('INSERT INTO classtypes VALUES(0, \'stdClass\')'); $db->exec('INSERT INTO classtypes VALUES(1, \'Test1\')'); $db->exec('INSERT INTO classtypes VALUES(2, \'Test2\')'); diff --git a/ext/pdo/tests/pdo_018.phpt b/ext/pdo/tests/pdo_018.phpt index a0bfdf0f99..6ed6295ee2 100644 --- a/ext/pdo/tests/pdo_018.phpt +++ b/ext/pdo/tests/pdo_018.phpt @@ -63,7 +63,7 @@ class TestLeaf extends TestDerived { } -$db->exec('CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(20) UNIQUE)'); +$db->exec('CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(20) NOT NULL UNIQUE)'); $db->exec('INSERT INTO classtypes VALUES(0, \'stdClass\')'); $db->exec('INSERT INTO classtypes VALUES(1, \'TestBase\')'); $db->exec('INSERT INTO classtypes VALUES(2, \'TestDerived\')'); -- 2.50.1