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

--
-- Table structure for table `tbl_sshow`
--

CREATE TABLE IF NOT EXISTS `tbl_sshow` (
  `sshow_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_create` datetime NOT NULL,
  `status` tinyint(1) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `dconf` text DEFAULT NULL,
  PRIMARY KEY (`sshow_id`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001;

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

--
-- Table structure for table `tbl_tmp`
--

CREATE TABLE IF NOT EXISTS `tbl_tmp` (
  `tmp_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_create` datetime NOT NULL,
  `tcat` varchar(20) DEFAULT NULL,
  `tkey` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`tmp_id`),
  KEY `dt_create` (`dt_create`),
  KEY `tcat` (`tcat`),
  KEY `tkey` (`tkey`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1001;

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

--
-- Table structure for table `tbl_user`
--

CREATE TABLE IF NOT EXISTS `tbl_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_create` datetime NOT NULL,
  `status` tinyint(1) NOT NULL,
  `b_super` tinyint(1) NOT NULL,
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(24) DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `usess_token` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1002;

--
-- Dumping data for table `tbl_user`
--

INSERT INTO `tbl_user` (`user_id`, `dt_create`, `status`, `b_super`, `username`, `password`, `first_name`, `last_name`, `email`, `usess_token`) VALUES
(1001, '2000-01-01 00:00:00', 1, 1, 'admin', 'password', 'super', 'admin', 'admin@admin.com', '');

