Changes between Version 1 and Version 2 of TracDev/DatabaseSchema/NotificationSystem

Timestamp:

Dec 20, 2014, 7:53:56 PM (9 years ago)

Author:

Peter Suter

Comment:

Added notify_watch table (#11869)

TracDev/DatabaseSchema/NotificationSystem

@@ -33 +33 @@
 See [browser:trunk/trac/notification/model.py#/ trac.notification.model.Subscription]
 
+== Table `notify_watch`
+||'''Table'''||'''Key'''||
+||''notify_watch''||''id''||
+
+||'''Columns'''||'''Type'''||'''Notes'''||
+||''id''||`auto_increment`|| ||
+||''sid''|| || The session ID of the subscriber. ||
+||''authenticated''||`int`|| `1` for authenticated session IDs, `0` for anonymous session IDs ||
+||''class''|| || The name of the Python class that stored this watch. ||
+||''realm''|| || The realm of this subscription (e.g. `ticket`). ||
+||''target''|| || The target of this subscription (e.g. a ticket id). ||
+
+||'''Indices'''||
+||''sid'', ''authenticated'', ''class''||
+||''class'', ''realm'', ''target''||
+
+Stores watches to identify the target resource(s) of a subscription (e.g. a watched ticket's id, wiki page filters, joined groups, etc.)
+
+Use the `trac.notification.model.Watch` model class to access this table. 
+
+See [browser:trunk/trac/notification/model.py#/ trac.notification.model.Watch]