diff options
Diffstat (limited to 'sources/potlatch/pre.sql')
| -rw-r--r-- | sources/potlatch/pre.sql | 20 |
1 files changed, 11 insertions, 9 deletions
diff --git a/sources/potlatch/pre.sql b/sources/potlatch/pre.sql index 7f3a40b..9f79445 100644 --- a/sources/potlatch/pre.sql +++ b/sources/potlatch/pre.sql @@ -36,7 +36,6 @@ CREATE TABLE categories ( name TEXT ); - -- -- features -- @@ -44,14 +43,17 @@ CREATE TABLE categories ( DROP TABLE IF EXISTS features; CREATE TABLE features ( - name TEXT, - category_id TEXT REFERENCES categories (id), - category_name TEXT, - help TEXT, - on_point INTEGER, - on_line INTEGER, - on_area INTEGER, - on_relation INTEGER + name TEXT, + category_id TEXT REFERENCES categories (id), + category_name TEXT, + help TEXT, + on_point INTEGER, + on_line INTEGER, + on_area INTEGER, + on_relation INTEGER, + icon_image TEXT, + icon_foreground TEXT, + icon_background TEXT ); -- |