Changes between Version 4 and Version 5 of TracDev/Proposals/AdvancedNotification/DatabaseSchema
- Timestamp:
- Dec 8, 2014, 8:34:47 AM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TracDev/Proposals/AdvancedNotification/DatabaseSchema
v4 v5 33 33 See [browser:psuter/trac/notification/model.py@advanced-notification-subscriptions.2#/ trac.notification.model.Subscription] 34 34 35 == Table ` subscription_attribute`35 == Table `notify_watch` 36 36 ||'''Table'''||'''Key'''|| 37 ||'' subscription_attribute''||''id''||37 ||''notify_watch''||''id''|| 38 38 39 39 ||'''Columns'''||'''Type'''||'''Notes'''|| … … 41 41 ||''sid''|| || The session ID of the subscriber. || 42 42 ||''authenticated''||`int`|| `1` for authenticated session IDs, `0` for anonymous session IDs || 43 ||''class''|| || The name of the Python class that stored this subscription attribute. ||43 ||''class''|| || The name of the Python class that stored this watch. || 44 44 ||''realm''|| || The realm of this subscription (e.g. `ticket`). || 45 45 ||''target''|| || The target of this subscription (e.g. a ticket id). || 46 46 47 Stores attributes to identify the target resource(s) of a subscription (e.g. a watched ticket's id, wiki page filters, joined groups, etc.) 47 ||'''Indices'''|| 48 ||''sid'', ''authenticated'', ''class''|| 49 ||''class'', ''realm'', ''target''|| 48 50 49 Use the `trac.notification.model.SubscriptionAttribute` model class to access this table. 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.) 50 52 51 See [browser:psuter/trac/notification/model.py@advanced-notification-subscription-attributes#/ trac.notification.model.SubscriptionAttribute] 53 Use the `trac.notification.model.Watch` model class to access this table. 54 55 See [browser:psuter/trac/notification/model.py@advanced-notification-dbtable-notify_watch#/ trac.notification.model.Watch] 52 56 53 57 == Open Questions … … 70 74 DONE Renamed `subscription` to `notify_subscription`. 71 75 72 TODO Rename `subscription_attribute` when it is implemented.76 DONE Renamed `subscription_attribute` to `notify_watch`. 73 77 74 78 === Remove `time` and `changetime` columns?