summaryrefslogtreecommitdiffstats
path: root/sql
AgeCommit message (Collapse)AuthorFilesLines
2018-06-28Add RFID supportJohannes Rudolph1-0/+1
2017-06-13adds the joined_at column and support in the db/webHolger Cremer1-1/+1
2017-04-16adds a new feature: a user can select it's sond theme in the web interface. ↵Holger Cremer1-1/+1
If not selected, a random theme is used.
2017-04-15adds 'disabled' and 'hidden'Holger Cremer1-1/+1
2016-01-21add sql constraint allowing only valid EAN numbersSebastian Reichel1-1/+1
2015-10-28add product categorySebastian Reichel2-2/+3
2015-10-28sql: view: invoice: fix price calculation for special usersSebastian Reichel1-3/+4
the price for special users is supposed to be the average of the restock price. After this commit only prices, that happened before the invoice entry are taken into account, so that its possible to recalculate the same invoice at a later point.
2015-09-13Add support for aliased EANsSebastian Reichel1-0/+1
Some products are sold under different EANs (e.g. per-country EANs). The alias table can be used to map multiple EANs to a single product.
2015-02-14web: more detailed authentication systemSebastian Reichel1-1/+1
2013-06-15cashbox trackingSebastian Reichel2-0/+18
2013-05-24add minimal support for deprecation flagSebastian Reichel2-1/+2
2013-05-21sql: create indexSebastian Reichel1-0/+1
2013-03-02initial support for suppliers & best before datesSebastian Reichel1-1/+2
2012-12-09Prepare PGP supportSebastian Reichel1-1/+1
- add database field for PGP Key ID - add PGP Key ID support to CSV import - show PGP Key ID in user profile
2012-12-08rename table sells -> salesSebastian Reichel3-5/+5
2012-12-08sqlite: false -> 0Sebastian Reichel1-1/+1
2012-10-02restructure code, switch from GTK to Web based UISebastian Reichel3-0/+57
- move barcode generation scripts into generation/ - move code to src/ - remove database analysis from invoice/graph - put database creation sql files into sql/ - remove glade builder file - add new templates/ directory, which contains files used by the Web-UI