cvs: pear /MDB/tests lob_test.schema
| From: | Lorenzo Alberton | Date: | Sat, 14 Jun 2003 08:32:11 +0000 |
| Subject: | cvs: pear /MDB/tests lob_test.schema | ||
| Groups: | php.pear.cvs | ||
| Request: | Send a blank email to pear-cvs+get-10957@lists.php.net to get a copy of this message | ||
quipo Sat Jun 14 04:32:11 2003 EDT
Modified files:
/pear/MDB/tests lob_test.schema
Log:
added a primary key to LOB table (some dmbs need it to manage LOBs)
Index: pear/MDB/tests/lob_test.schema
diff -u pear/MDB/tests/lob_test.schema:1.1 pear/MDB/tests/lob_test.schema:1.2
--- pear/MDB/tests/lob_test.schema:1.1 Fri Mar 22 15:20:47 2002
+++ pear/MDB/tests/lob_test.schema Sat Jun 14 04:32:11 2003
@@ -2,7 +2,7 @@
<!--
lob_test.schema
- @(#) $Id: lob_test.schema,v 1.1 2002/03/22 20:20:47 lsmith Exp $
+ @(#) $Id: lob_test.schema,v 1.2 2003/06/14 08:32:11 quipo Exp $
-->
@@ -10,13 +10,19 @@
<name><variable>name</variable></name>
<create>0</create>
-
+
<table>
<name>files</name>
<declaration>
- <field> <name>document</name> <type>clob</type> </field>
- <field> <name>picture</name> <type>blob</type> </field>
+ <field> <name>ID</name> <type>integer</type>
<default>0</default> <notnull>1</notnull> </field>
+ <field> <name>document</name> <type>clob</type>
</field>
+ <field> <name>picture</name> <type>blob</type>
</field>
+ <index>
+ <name>lob_id_index</name>
+ <unique>1</unique>
+ <field> <name>ID</name> </field>
+ </index>
</declaration>
</table>