Re: [Apc-aa-coders] event table missing

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

Hi Norbert,

   I'm quite sure the sql_update.php3 script was updated about two weeks
ago and event table is there. I personally updated some AA installations
and it is working.

   Anyway, there is event table structure:

CREATE TABLE `event` (
  `id` varchar(32) NOT NULL default '' COMMENT 'record id',
  `type` varchar(32) NOT NULL default '' COMMENT 'type of event',
  `class` varchar(32) default NULL COMMENT 'used for event condition',
  `selector` varchar(255) default NULL COMMENT 'used for event condition =
- mostly id of changed item, ...',
  `reaction` varchar(50) NOT NULL default '' COMMENT 'name of php class w=
hich is invoked when the event come',
  `params` text COMMENT 'parameters for reaction object',
  PRIMARY KEY  (`id`),
  KEY `type_class` (`type`,`class`),
  KEY `type_selector` (`type`,`selector`(32))
) ENGINE=3DInnoDB DEFAULT CHARSET=3Dcp1250 COMMENT=3D'list of all event r=
eactions. Stores also conditions, when re';


   Regards,
               Honza

Norbert Brazda p=ED=B9e v =DAt 11. 04. 2006 v 14:23 +0200:
> Functions in apc-aa/include/event.class.php3 use "event" table (e.g. SQ=
L=20
> query "SELECT params FROM event WHERE ...") but that table does not exi=
st.
>=20
> Honza, can you post here structure or CREATE TABLE query for that table=
=20
> and update sql_update.php3?
>=20
>=20
> n.
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting lang=
uage
> that extends applications into web and mobile media. Attend the live we=
bcast
> and join the prime developer group breaking into this new coding territ=
ory!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=
=3D121642
> _______________________________________________
> Apc-aa-coders mailing list
> Apc...@li...
> https://lists.sourceforge.net/lists/listinfo/apc-aa-coders
>=20
--=20