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

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

LOCK TABLES `invoice_items` WRITE;
/*!40000 ALTER TABLE `invoice_items` DISABLE KEYS */;

INSERT INTO `invoice_items` (`id`, `invoice_id`, `item`, `price`, `quantity`, `total`)
VALUES
	(1,1,'Consulting Hour',30.00,3,90.00),
	(2,1,'Development Hour',50.00,10,500.00);

/*!40000 ALTER TABLE `invoice_items` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table invoices


CREATE TABLE `invoices` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `owner` int(11) NOT NULL,
  `created_date` date NOT NULL,
  `due_date` date NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT '',
  `date_paid` date DEFAULT NULL,
  `total` decimal(13,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



# Dump of table project_notes
