X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/0056678b5dda50f9664753a8134c558c7583dce9..7d4e14287bbbd83a07b093e97ac53266494b7628:/mysql.sql?ds=inline 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`) );