summaryrefslogtreecommitdiff
path: root/controller/schema.sql.c
AgeCommit message (Collapse)Author
2015-09-15Drop Sqlite-based Log table for now and switch to an in-memory log for ↵Adam Ierymenko
recent activity. Log table gets too big on busy nodes. Should probably support push of events to some kind of event system later.
2015-07-29Go ahead and spec out controller DB support for AuthToken -- GitHub issue ↵Adam Ierymenko
#211 -- even though full implementation won't make it into 1.0.4.
2015-07-24Add version to log.Adam Ierymenko
2015-07-22Add a Log table to log queries for debugging and security logging. No JSON ↵Adam Ierymenko
API support for querying the log yet, but will probably come via /network/###/member/###/log/... or something.
2015-07-20Get rid of false foreign key in Relay.Adam Ierymenko
2015-07-16Add memberRevision stuff to JSON output, and update docs.Adam Ierymenko
2015-07-16Add a concept of a member revision counter to networks. This can be used to ↵Adam Ierymenko
select all members that have been added or changed since a given point.
2015-06-29ipLocalRoutes now exposed via network objects in JSON controller API, and ↵Adam Ierymenko
documentation changes.
2015-06-29Untested -- modifications to support IP ranges instead of ip/mask for IP ↵Adam Ierymenko
assignment pools, also add portId to Rule for future use.
2015-06-29(1) Both nodeId and portId in Rule can be NULL, (2) remove on delete cascade ↵Adam Ierymenko
since rules should never mysteriously disappear from the rules table. If it let you delete a node with rules, that would be a UI or cleanup function bug.
2015-06-29DB schema changes: separate portId in rules, ranges in IP assignment pools. ↵Adam Ierymenko
(No code changes yet so code is broken.)
2015-06-26GitHub issue #191 - kill intra-network multicast rate limits (which were not ↵Adam Ierymenko
well supported or easily configurable anyway) -- this is really left over from the old collaborative multicast propagation algorithm. New algorithm (in for a while) has been sender-side replication in which sender "pays" all bandwidth, which intrinsically limits multicast.
2015-06-13Gateways support in network controller schema and database (not implemented ↵Adam Ierymenko
yet in client) toward GitHub issue #178
2015-06-13Rename ruleId to ruleNo and optimize some indexes in Sqlite3 schema.Adam Ierymenko
2015-06-11Change schema to enforce foreing keysKees Bos
The foreign keys have 'ON DELETE CASCADE' to simplify the removal of networks etc. (controller code) Some unique constraints are replaced with a multi column primary key. To update an existing database: * install updated binaries * stop service * sqlite3 controller.db .dump | \ egrep '((^PRAGMA)|(^BEGIN)|(^INSERT)|(^COMMIT))' | \ grep -v 'schemaVersion' > data.sql * mv controller.db controller.db.backup * start service * stop service * sqlite3 controller.db < data.sql * start service
2015-05-25Go ahead and add flags and invFlags to the Rule table.Adam Ierymenko
2015-05-16Fix some prepared statement problems.Adam Ierymenko
2015-04-21CRUDAdam Ierymenko
2015-04-21More CRUD, almost done...Adam Ierymenko
2015-04-21Forgot to run schema2c.Adam Ierymenko
2015-04-20Network preferred relay stuff in netconf controller.Adam Ierymenko
2015-04-20Add per-network relay stuff to sqlite table schema.Adam Ierymenko
2015-04-17Add a timestamp to netconf cache, fix some SQL queries in NC.Adam Ierymenko
2015-04-15Rename netconf to controller and NetworkConfigMaster to NetworkController ↵Adam Ierymenko
for consistency.