Task list

Page 1

• add owner to all dns and fw rules
• on update of system_interfaces mac addr triggers error
• images should be urls not bytea
• add firewall device ips to the fw table
• add hostid auto int
• change isprimary
• subnetid all coumns ip
• comment all uniques
• move functions to proper schemas
• comment all schemas
• alias verifier
• one primary ns per zone
• check inrange
• check uniques!
• add owner to all resources

Page 2

• alias verifier
• one primary ns per zone
• verify all uniques
• comment all uniques
• create checks for dns records
• move functions to proper schemas
• comment all schemas
• system_class checks for firewall/switchports
• user privilages
• comment all functions
• checks for switchport functions
• create firewall (on update/insert to systems)
• create switchport (if type != firewall/router/etc exception)
• add ip addresses check for range
• auto select to occur in insert only
• modify api-crate-subnet ip address insert firewall defaults
• move autopopulation to subnet insert from api create
• check addresses before insert against into interface table (no stray addresses)
• autogen default true
• deprecate logging triggers

Page 3

• user privileges
• on insert to systems create firewall
• on insert switchport check device
• check addresses against subnets
• move timestamp updateing
• fw_metahosts
• compare ip to range to domain
• sequences
• log views
• rename references to "log"
• update functionprivilegess
• sanitization function
• logging calls
• ip migration features
• special users for access?
• dhcp networks
• integrate with personal dns
• change username to owner
• date_renewed

Page 4

• write finish update functions
• logging calls
• rename username to owner
• deprecate all ids with cascade
• rewrite functions not to use ids
• delete firewall ondelete default
• update uniques with new PKs
• check all ondelete functions

Page 5

• api initialize function
• write finish unbreak update functions
• place logging calls in api functions
• rename logging calls
• add santization to api
• document create_subnet changed
• all function comments need ()
• renew functions

Page 6

• api.initialize()
• update/modification functions
• api.renew()
• default ttls to configuration
• api.valdate_domain()