wez Thu Jul 7 10:10:00 2005 EDT
Modified files:
/php-src/ext/pdo/tests pdo_009.phpt pdo_010.phpt pdo_018.phpt
Log:
Need to state NOT NULL here, as DB2 won't allow the UNIQUE constraint without
it.
http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_009.phpt?r1=1.2&r2=1.3&ty=u
Index: php-src/ext/pdo/tests/pdo_009.phpt
diff -u php-src/ext/pdo/tests/pdo_009.phpt:1.2
php-src/ext/pdo/tests/pdo_009.phpt:1.3
--- php-src/ext/pdo/tests/pdo_009.phpt:1.2 Wed Jul 6 09:19:25 2005
+++ php-src/ext/pdo/tests/pdo_009.phpt Thu Jul 7 10:09:58 2005
@@ -9,7 +9,7 @@
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\')');
http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_010.phpt?r1=1.2&r2=1.3&ty=u
Index: php-src/ext/pdo/tests/pdo_010.phpt
diff -u php-src/ext/pdo/tests/pdo_010.phpt:1.2
php-src/ext/pdo/tests/pdo_010.phpt:1.3
--- php-src/ext/pdo/tests/pdo_010.phpt:1.2 Wed Jul 6 09:19:25 2005
+++ php-src/ext/pdo/tests/pdo_010.phpt Thu Jul 7 10:09:58 2005
@@ -9,7 +9,7 @@
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\')');
http://cvs.php.net/diff.php/php-src/ext/pdo/tests/pdo_018.phpt?r1=1.2&r2=1.3&ty=u
Index: php-src/ext/pdo/tests/pdo_018.phpt
diff -u php-src/ext/pdo/tests/pdo_018.phpt:1.2
php-src/ext/pdo/tests/pdo_018.phpt:1.3
--- php-src/ext/pdo/tests/pdo_018.phpt:1.2 Wed Jul 6 09:19:25 2005
+++ php-src/ext/pdo/tests/pdo_018.phpt Thu Jul 7 10:09:58 2005
@@ -63,7 +63,7 @@
{
}
-$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\')');
--
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
