| 35 | == Table `notify_watch` |
| 36 | ||'''Table'''||'''Key'''|| |
| 37 | ||''notify_watch''||''id''|| |
| 38 | |
| 39 | ||'''Columns'''||'''Type'''||'''Notes'''|| |
| 40 | ||''id''||`auto_increment`|| || |
| 41 | ||''sid''|| || The session ID of the subscriber. || |
| 42 | ||''authenticated''||`int`|| `1` for authenticated session IDs, `0` for anonymous session IDs || |
| 43 | ||''class''|| || The name of the Python class that stored this watch. || |
| 44 | ||''realm''|| || The realm of this subscription (e.g. `ticket`). || |
| 45 | ||''target''|| || The target of this subscription (e.g. a ticket id). || |
| 46 | |
| 47 | ||'''Indices'''|| |
| 48 | ||''sid'', ''authenticated'', ''class''|| |
| 49 | ||''class'', ''realm'', ''target''|| |
| 50 | |
| 51 | Stores watches to identify the target resource(s) of a subscription (e.g. a watched ticket's id, wiki page filters, joined groups, etc.) |
| 52 | |
| 53 | Use the `trac.notification.model.Watch` model class to access this table. |
| 54 | |
| 55 | See [browser:trunk/trac/notification/model.py#/ trac.notification.model.Watch] |