-- ----------------------------
-- 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;

-- ----------------------------
-- Table structure for user
-- ----------------------------
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL,
  `email` varchar(99) NOT NULL,
  `password` varchar(99) NOT NULL,
  `user_type` varchar(20) NOT NULL,
  `status` varchar(10) DEFAULT NULL,
  `create_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 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');
INSERT INTO `user` VALUES ('1', 'admin', 'admin@demo.com', '827ccb0eea8a706c4c34a16891f84e7b', 'admin', 'active', '0000-00-00');
