Changes between Version 4 and Version 5 of TracDev/Proposals/AdvancedNotification/DatabaseSchema

Timestamp:

Dec 8, 2014, 8:34:47 AM (9 years ago)

Author:

Peter Suter

Comment:

Renamed table subscription_attribute to notify_watch, added indices, updated links

TracDev/Proposals/AdvancedNotification/DatabaseSchema

@@ -33 +33 @@
 See [browser:psuter/trac/notification/model.py@advanced-notification-subscriptions.2#/ trac.notification.model.Subscription]
 
-== Table `subscription_attribute`
+== Table `notify_watch`
 ||'''Table'''||'''Key'''||
-||''subscription_attribute''||''id''||
+||''notify_watch''||''id''||
 
 ||'''Columns'''||'''Type'''||'''Notes'''||
@@ -41 +41 @@
 ||''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 subscription attribute. ||
+||''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). ||
 
-Stores attributes to identify the target resource(s) of a subscription (e.g. a watched ticket's id, wiki page filters, joined groups, etc.)
+||'''Indices'''||
+||''sid'', ''authenticated'', ''class''||
+||''class'', ''realm'', ''target''||
 
-Use the `trac.notification.model.SubscriptionAttribute` model class to access this table. 
+Stores watches to identify the target resource(s) of a subscription (e.g. a watched ticket's id, wiki page filters, joined groups, etc.)
 
-See [browser:psuter/trac/notification/model.py@advanced-notification-subscription-attributes#/ trac.notification.model.SubscriptionAttribute]
+Use the `trac.notification.model.Watch` model class to access this table. 
+
+See [browser:psuter/trac/notification/model.py@advanced-notification-dbtable-notify_watch#/ trac.notification.model.Watch]
 
 == Open Questions
@@ -70 +74 @@
 DONE Renamed `subscription` to `notify_subscription`.
 
-TODO Rename `subscription_attribute` when it is implemented.
+DONE Renamed `subscription_attribute`  to `notify_watch`.
 
 === Remove `time` and `changetime` columns?