Closed cholmes closed 11 years ago
To start I'd say just take them all out and put in a sql-triggers.md document. We can then evolve that in to a nicer annex, but at least get them out of the main document.
Branch made with an initial commit for a skeleton document at https://github.com/cholmes/gpkg-tiles/tree/sql-reorg
@jpoffen - assigning to you. I made a branch that you can use. I think we should start using branches more - develop things there, and merge to the mainline when ready. I'd say investigate the sql tables, and see if any do make a bit of sense in the main document. But definitely move the big long creation statements over. And remove any text around then.
The big sections on sql triggers don't seem necessary to have in the standard. We could move them to a best practices paper on a 'safe geopackage' that keeps the state consistent. But does not need to be part of the main standard.