summaryrefslogtreecommitdiff
path: root/controller/schema.sql
AgeCommit message (Collapse)Author
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-15Netconf docs, add clock field to status, simplify netconf a bit by ↵Adam Ierymenko
eliminating caching for now. We will re-add if it is needed.
2015-04-21CRUDAdam Ierymenko
2015-04-21More CRUD, almost done...Adam Ierymenko
2015-04-21Network controller CRUD... :PAdam 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.