X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/a4314b66a96faca049fe6b383302b58a47d93848..7410339cd9812d0eb37bf94b51dab13158e77c0e:/mysql.sql 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`) );