Edgewall Software

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


Ignore:
Timestamp:
Dec 8, 2014, 8:34:47 AM (8 years ago)
Author:
Peter Suter
Comment:

Renamed table subscription_attribute to notify_watch, added indices, updated links

Legend:

Unmodified
Added
Removed
Modified
  • TracDev/Proposals/AdvancedNotification/DatabaseSchema

    v4 v5  
    3333See [browser:psuter/trac/notification/model.py@advanced-notification-subscriptions.2#/ trac.notification.model.Subscription]
    3434
    35 == Table `subscription_attribute`
     35== Table `notify_watch`
    3636||'''Table'''||'''Key'''||
    37 ||''subscription_attribute''||''id''||
     37||''notify_watch''||''id''||
    3838
    3939||'''Columns'''||'''Type'''||'''Notes'''||
     
    4141||''sid''|| || The session ID of the subscriber. ||
    4242||''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. ||
    4444||''realm''|| || The realm of this subscription (e.g. `ticket`). ||
    4545||''target''|| || The target of this subscription (e.g. a ticket id). ||
    4646
    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''||
    4850
    49 Use the `trac.notification.model.SubscriptionAttribute` model class to access this table.
     51Stores watches to identify the target resource(s) of a subscription (e.g. a watched ticket's id, wiki page filters, joined groups, etc.)
    5052
    51 See [browser:psuter/trac/notification/model.py@advanced-notification-subscription-attributes#/ trac.notification.model.SubscriptionAttribute]
     53Use the `trac.notification.model.Watch` model class to access this table.
     54
     55See [browser:psuter/trac/notification/model.py@advanced-notification-dbtable-notify_watch#/ trac.notification.model.Watch]
    5256
    5357== Open Questions
     
    7074DONE Renamed `subscription` to `notify_subscription`.
    7175
    72 TODO Rename `subscription_attribute` when it is implemented.
     76DONE Renamed `subscription_attribute`  to `notify_watch`.
    7377
    7478=== Remove `time` and `changetime` columns?