Location: PHPKode > projects > Lead Follow-Up Database > web/install/sql/sql.txt
-- --------------------------------------------------------

--
-- Table structure for table `tbl_lead`
--

CREATE TABLE IF NOT EXISTS `tbl_lead` (
  `lead_id` int(11) NOT NULL auto_increment,
  `active` varchar(1) NOT NULL,
  `rlog_create_date_time` datetime default NULL,
  `rlog_create_user_type` varchar(1) default NULL,
  `rlog_create_user_id` int(11) default NULL,
  `rlog_create_user_name` varchar(15) default NULL,
  `rlog_edit_date_time` datetime default NULL,
  `rlog_edit_user_type` varchar(1) default NULL,
  `rlog_edit_user_id` int(11) default NULL,
  `rlog_edit_user_name` varchar(15) default NULL,
  `email` varchar(100) default NULL,
  `comment` mediumtext,
  `company_name` varchar(64) default NULL,
  `business_type` varchar(64) default NULL,
  `market_segment` varchar(64) default NULL,
  `contact` varchar(64) default NULL,
  `title` varchar(64) default NULL,
  `street1` varchar(64) default NULL,
  `street2` varchar(64) default NULL,
  `city` varchar(64) default NULL,
  `state` varchar(64) default NULL,
  `zip` varchar(64) default NULL,
  `country` varchar(64) default NULL,
  `office_tel` varchar(64) default NULL,
  `cell_phone` varchar(64) default NULL,
  `fax` varchar(64) default NULL,
  `website` varchar(64) default NULL,
  `follow_up` datetime default NULL,
  PRIMARY KEY  (`lead_id`)
) ENGINE=MyISAM  AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_staff`
--

CREATE TABLE IF NOT EXISTS `tbl_staff` (
  `staff_id` int(11) NOT NULL auto_increment,
  `active` varchar(1) NOT NULL,
  `group_id` int(11) NOT NULL,
  `username` varchar(15) default NULL,
  `password` varchar(50) default NULL,
  `rlog_create_date_time` datetime default NULL,
  `rlog_create_user_type` varchar(1) default NULL,
  `rlog_create_user_id` int(11) default NULL,
  `rlog_create_user_name` varchar(15) default NULL,
  `rlog_edit_date_time` datetime default NULL,
  `rlog_edit_user_type` varchar(1) default NULL,
  `rlog_edit_user_id` int(11) default NULL,
  `rlog_edit_user_name` varchar(15) default NULL,
  `rlog_last_login_date_time` datetime default NULL,
  `email` varchar(100) default NULL,
  `name` varchar(64) default NULL,
  PRIMARY KEY  (`staff_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM  AUTO_INCREMENT=1002 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_staff`
--

INSERT INTO `tbl_staff` (`staff_id`, `active`, `group_id`, `username`, `password`, `rlog_create_date_time`, `rlog_create_user_type`, `rlog_create_user_id`, `rlog_create_user_name`, `rlog_edit_date_time`, `rlog_edit_user_type`, `rlog_edit_user_id`, `rlog_edit_user_name`, `rlog_last_login_date_time`, `email`, `name`) VALUES
(1001, 'Y', 1001, 'admin', 'password', '2000-01-01 00:00:00', 'S', 1001, 'admin', '2000-01-01 00:00:00', 'S', 1001, 'admin', '2000-01-01 00:00:00', 'hide@address.com', 'Administrator');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_genlog`
--

CREATE TABLE IF NOT EXISTS `tbl_genlog` (
  `genlog_id` int(10) NOT NULL auto_increment,
  `time_create` datetime NOT NULL,
  `ip_address` varchar(24) default NULL,
  `sender` varchar(200) default NULL,
  `subject` varchar(200) default NULL,
  `body` mediumtext default NULL,
  `format` varchar(1) NOT NULL,
  PRIMARY KEY  (`genlog_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1001  DEFAULT CHARSET=utf8;

Return current item: Lead Follow-Up Database