-- ----------------------------
-- Table structure for email_template
-- ----------------------------
CREATE TABLE `email_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `body` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for invoice_settings
-- ----------------------------
CREATE TABLE `invoice_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `settings_name` varchar(99) NOT NULL,
  `settings_value` text NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for settings
-- ----------------------------
CREATE TABLE `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `settings_name` varchar(99) NOT NULL,
  `settings_value` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `email_template` VALUES ('1', 'pending_registration', 'Pending Notification', '<p>Hello,</p>\r\n<p>We got your information. You will get email soon after activating your account.</p>\r\n<p>&nbsp;</p>\r\n<p>Thank You<br /> Tricky Code</p>');
INSERT INTO `email_template` VALUES ('2', 'active_registration', 'Registration Successfully', '<p>Registration Successfully</p>');
INSERT INTO `settings` VALUES ('1', 'site_title', 'Invoice Management');
INSERT INTO `settings` VALUES ('2', 'system_name', 'Invoice<span>Management</span>');
INSERT INTO `settings` VALUES ('3', 'currency_symbol', '$');
INSERT INTO `settings` VALUES ('4', 'email', 'info@trickycode.net');
INSERT INTO `settings` VALUES ('5', 'from_name', 'Tricky Code');
INSERT INTO `settings` VALUES ('8', 'email_notification', 'NO');
