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

--
-- 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=1001 DEFAULT CHARSET=utf8;

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', 'admin@admin.com', 'Administrator');

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

--
-- Table structure for table `tbl_option`
--

CREATE TABLE IF NOT EXISTS `tbl_option` (
  `option_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,
  `rlog_last_login_date_time` datetime default NULL,
  `title` varchar(64) DEFAULT NULL,
  `pic_width` int(11) default NULL,
  `pic_height` int(11) default NULL,
  `effect_type` varchar(30) default NULL,
  `trans_duration` int(11) default NULL,
  `pause_duration` int(11) default NULL,
  `b_loop` varchar(1) DEFAULT 'N',
  PRIMARY KEY  (`option_id`)
) ENGINE=MyISAM  AUTO_INCREMENT=1004 DEFAULT CHARSET=utf8;

INSERT INTO `tbl_option` (`option_id`, `active`, `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`, `title`, `pic_width`, `pic_height`, `effect_type`, `trans_duration`, `pause_duration`, `b_loop`) VALUES
(1001, 'Y', NULL, NULL, NULL, NULL, '2013-01-01 01:01:01', 'S', 1001, 'admin', NULL, 'Demo1', 300, 300, 'turnUp', 1000, 1000, 'Y'),
(1002, 'Y', NULL, NULL, NULL, NULL, '2013-01-01 01:01:01', 'S', 1001, 'admin', NULL, 'Demo2', 600, 171, 'fade', 2000, 2000, 'Y'),
(1003, 'Y', NULL, NULL, NULL, NULL, '2013-01-01 01:01:01', 'S', 1001, 'admin', NULL, 'Demo3', 400, 200, 'blindX', 500, 500, 'Y');

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

--
-- Table structure for table `tbl_pic`
--

CREATE TABLE IF NOT EXISTS `tbl_pic` (
  `pic_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,
  `option_id` int(11) NOT NULL,
  `order_num` int(11) default '1000',
  `url_link` varchar(300) default NULL,
  `picture` varchar(300) default NULL,
  `b_new_tab` varchar(1) DEFAULT 'N',
  PRIMARY KEY  (`pic_id`)
) ENGINE=MyISAM  AUTO_INCREMENT=1010 DEFAULT CHARSET=utf8;


INSERT INTO `tbl_pic` (`pic_id`, `active`, `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`, `option_id`, `order_num`, `url_link`, `picture`, `b_new_tab` ) VALUES
(1001, 'Y', '2013-01-01 01:01:01', 'S', 1001, 'admin', NULL, NULL, NULL, NULL, 1001, 1000, NULL, 'f_20130510014300_QwkQlytbSMzreVfqReeJ.png/pic-1-1.png', 'Y'),
(1002, 'Y', '2013-01-01 01:01:01', 'S', 1001, 'admin', NULL, NULL, NULL, NULL, 1001, 1001, NULL, 'f_20130510014307_mtXdutxLQuHgPsTWjWwP.png/pic-1-2.png', 'Y'),
(1003, 'Y', '2013-01-01 01:01:01', 'S', 1001, 'admin', NULL, NULL, NULL, NULL, 1001, 1002, NULL, 'f_20130510014317_DdynNDuScriYomxyvlCT.png/pic-1-3.png', 'Y'),
(1004, 'Y', '2013-01-01 01:01:01', 'S', 1001, 'admin', NULL, NULL, NULL, NULL, 1002, 1000, NULL, 'f_20130510014803_MrpJcxnymRKSSIchMVnj.jpg/pic-2-1.jpg', 'Y'),
(1005, 'Y', '2013-01-01 01:01:01', 'S', 1001, 'admin', NULL, NULL, NULL, NULL, 1002, 1001, NULL, 'f_20130510014828_oaXcpUUqqJpLobziQgIv.jpg/pic-2-2.jpg', 'Y'),
(1006, 'Y', '2013-01-01 01:01:01', 'S', 1001, 'admin', NULL, NULL, NULL, NULL, 1002, 1002, NULL, 'f_20130510014809_BfrHYbxHRPPxGBmzCrZT.jpg/pic-2-3.jpg', 'Y'),
(1007, 'Y', '2013-01-01 01:01:01', 'S', 1001, 'admin', NULL, NULL, NULL, NULL, 1003, 1000, NULL, 'f_20130510015412_YUPkWgsUKWhDVurDKJAZ.png/pic-3-1.png', 'Y'),
(1008, 'Y', '2013-01-01 01:01:01', 'S', 1001, 'admin', NULL, NULL, NULL, NULL, 1003, 1001, NULL, 'f_20130510015420_egTnyhQxJBqGzKxolPfi.png/pic-3-2.png', 'Y'),
(1009, 'Y', '2013-01-01 01:01:01', 'S', 1001, 'admin', NULL, NULL, NULL, NULL, 1003, 1002, NULL, 'f_20130510015435_wfHqGAYYdPaTPeUKAGwI.png/pic-3-3.png', 'Y');

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