Added paid field and handling to expenses.

[timetracker.git] / mysql.sql

diff --git a/mysql.sql b/mysql.sql
index a450cadb31edc4609685d34fa24f70cb61d46791..1e415c149afffb66d33d3b3512a7783890da6493 100644 (file)
--- 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
   `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`)
 );
   `status` tinyint(4) default '1',     # item status
   PRIMARY KEY  (`id`)
 );