Re: [Apc-aa-coders] bug: object_text table missing

[Honza M. <hon...@ec...>]

Hi Norbert,

   You are right, I forgot to add the table to the sql_update.php3
script. I'm sorry. Now fixed in CVS (but, not tested yet).


In fact there are three new tables, which is planed to be used as
general object store - something similar as 'content' table. Instead of
fields we will store there object properties.=20

   In case of xmlclient.php3 we are storing there (experimentally, for
now) AA_CSV_Importer object.

   The structure is a bit improved compared to 'content' table - we use
three tables - for each "datatype" one (text, number, float). This
approach do not waste space (in content table we use two columns - text
and number, where only one holds content). Float (real) numbers are
impossible to store in 'content' table for now.

   Honza

   Structure, grabbed from our database=20
   (ignore the last row for each table (ENGINE=3D...))=20

-- Generation Time: Jun 30, 2006 at 03:56 PM
-- Server version: 5.0.21
-- PHP Version: 5.1.4

CREATE TABLE `object_float` (
  `id` bigint(20) NOT NULL auto_increment COMMENT 'just for row identific=
ation',
  `object_id` varbinary(32) NOT NULL default '',
  `property` varbinary(16) NOT NULL default '',
  `priority` smallint(20) default NULL,
  `float` double default NULL,
  `flag` smallint(6) default NULL,
  PRIMARY KEY  (`id`),
  KEY `item_id` (`object_id`,`property`,`float`),
  KEY `integer` (`float`)
) ENGINE=3DInnoDB DEFAULT CHARSET=3Dcp1250 AUTO_INCREMENT=3D1 ;

CREATE TABLE `object_integer` (
  `id` bigint(20) NOT NULL auto_increment COMMENT 'just for row identific=
ation',
  `object_id` varbinary(32) NOT NULL default '',
  `property` varbinary(16) NOT NULL default '',
  `priority` smallint(20) default NULL,
  `integer` bigint(20) default NULL,
  `flag` smallint(6) default NULL,
  PRIMARY KEY  (`id`),
  KEY `item_id` (`object_id`,`property`,`integer`),
  KEY `integer` (`integer`)
) ENGINE=3DInnoDB DEFAULT CHARSET=3Dcp1250 AUTO_INCREMENT=3D1 ;

CREATE TABLE `object_text` (
  `id` bigint(20) NOT NULL auto_increment COMMENT 'just for row identific=
ation',
  `object_id` varbinary(32) NOT NULL default '',
  `property` varbinary(16) NOT NULL default '',
  `priority` smallint(20) default NULL,
  `text` longtext,
  `flag` smallint(6) default NULL,
  PRIMARY KEY  (`id`),
  KEY `text` (`text`(10)),
  KEY `item_id` (`object_id`,`property`,`text`(16))
) ENGINE=3DInnoDB DEFAULT CHARSET=3Dcp1250 AUTO_INCREMENT=3D73 ;

  =20



Norbert Brazda p=ED=B9e v P=E1 30. 06. 2006 v 13:26 +0200:
> Some scripts (e.g. xmlclient.php3) now use new "object_text" table but=20
> the table is not created by sql_update.php3 script. Inbound AA/RSS feed=
s=20
> are thus not working.
>=20
> I guess that the table should look something like this:
>=20
> CREATE TABLE `object_text` (
>    `object_id` tinyint(6) NOT NULL auto_increment,
>    `property` varbinary(32) NOT NULL default '',
>    `text` blob NOT NULL,
>    UNIQUE KEY `object_id` (`object_id`),
>    KEY `property` (`property`)
> );
>=20
>=20
>=20
> norbert
> br...@ch...
>=20
>=20
>=20
> Using Tomcat but need to do more? Need to support web services, securit=
y?
> Get stuff done quickly with pre-integrated technology to make your job =
easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geron=
imo
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> _______________________________________________
> Apc-aa-coders mailing list
> Apc...@li...
> https://lists.sourceforge.net/lists/listinfo/apc-aa-coders
>=20
--=20