X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=mysql.sql;h=1e415c149afffb66d33d3b3512a7783890da6493;hb=232a12a5e68da662e86d3141ac98a1b12d820964;hp=a450cadb31edc4609685d34fa24f70cb61d46791;hpb=a4314b66a96faca049fe6b383302b58a47d93848;p=timetracker.git diff --git a/mysql.sql b/mysql.sql index a450cadb..1e415c14 100644 --- a/mysql.sql +++ b/mysql.sql @@ -340,6 +340,7 @@ CREATE TABLE `tt_expense_items` ( `name` text NOT NULL, # expense item name (what is an expense for) `cost` decimal(10,2) default '0.00', # item cost (including taxes, etc.) `invoice_id` int(11) default NULL, # invoice id + `paid` tinyint(4) default '0', # whether the item is paid `status` tinyint(4) default '1', # item status PRIMARY KEY (`id`) );