From: Bharat M. <bh...@us...> - 2003-03-13 17:53:38
|
Update of /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/postgres In directory sc8-pr-cvs1:/tmp/cvs-serv4060/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/postgres Modified Files: GalleryItem.sql Log Message: Moved "canContainChildren" out of the API and into the database. This allows us to locate containers using a database query (fast) instead of having to walk the tree (very slow). Index: GalleryItem.sql =================================================================== RCS file: /cvsroot/gallery/gallery2/modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/postgres/GalleryItem.sql,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- GalleryItem.sql 17 Feb 2003 20:20:26 -0000 1.2 +++ GalleryItem.sql 13 Mar 2003 17:53:02 -0000 1.3 @@ -10,22 +10,26 @@ NOT NULL , + DB_COLUMN_PREFIXcanContainChildren + SMALLINT + + , DB_COLUMN_PREFIXdescription TEXT , - DB_COLUMN_PREFIXlayout + DB_COLUMN_PREFIXkeywords VARCHAR( - 32 + 255 ) , - DB_COLUMN_PREFIXkeywords + DB_COLUMN_PREFIXlayout VARCHAR( - 255 + 32 ) |