cvs: php-src /ext/pdo/tests pdo_009.phpt pdo_010.phpt pdo_018.phpt

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\')');