 
 CREATE TABLE `invoices` (
   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `user_id` int(11) NOT NULL,
+  `owner` int(11) NOT NULL,
   `created_date` date NOT NULL,
   `due_date` date NOT NULL,
   `status` varchar(20) NOT NULL DEFAULT '',
-  `date_paid` date NOT NULL,
-  `subtotal` decimal(13,2) DEFAULT NULL,
-  `tax` decimal(13,2) DEFAULT NULL,
-  `amount_due` decimal(13,2) NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-LOCK TABLES `invoices` WRITE;
-/*!40000 ALTER TABLE `invoices` DISABLE KEYS */;
-
-INSERT INTO `invoices` (`id`, `user_id`, `created_date`, `due_date`, `status`, `date_paid`, `subtotal`, `tax`, `amount_due`)
-VALUES
-	(1,2,'2014-07-14','2014-07-21','Unpaid','0000-00-00',590.00,135.70,725.70);
-
-/*!40000 ALTER TABLE `invoices` ENABLE KEYS */;
-UNLOCK TABLES;
+  `date_paid` date DEFAULT NULL,
+  `total` decimal(13,2) DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
 
 
 # Dump of table project_notes

#
# Host: localhost (MySQL 5.6.19)
# Database: simplelance
# Generation Time: 2014-07-14 13:58:28 +0000
# ************************************************************



  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



# Dump of table invoices
