ss

 -- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2009 年 11 月 20 日 13:48
-- 服务器版本: 5.0.51
-- PHP 版本: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- 数据库: `assistant`
--

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

--
-- 表的结构 `memo_tbl`
--

CREATE TABLE IF NOT EXISTS `memo_tbl` (
  `memoID` int(11) NOT NULL auto_increment,
  `userID` varchar(15) NOT NULL,
  `memotitle` varchar(50) NOT NULL,
  `memocontent` varchar(500) NOT NULL,
  `isremind` int(1) NOT NULL,
  `remindtime` datetime NOT NULL,
  `isdelete` int(1) NOT NULL,
  `up_date` date NOT NULL,
  `insertdate` date NOT NULL,
  PRIMARY KEY  (`memoID`,`userID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=91103069 ;

--
-- 导出表中的数据 `memo_tbl`
--

INSERT INTO `memo_tbl` (`memoID`, `userID`, `memotitle`, `memocontent`, `isremind`, `remindtime`, `isdelete`, `up_date`, `insertdate`) VALUES
(91103006, '2008017', '的撒旦', '十大十大十大十大十大十大十大十大十大十大十大十大十大十大十大十大十大十大十大十大十大十大十大十大十大十大', 0, '2009-11-04 13:06:36', 1, '2009-11-04', '2009-11-04'),
(91103034, '2008017', 'fdsaf', 'asfasfasf', 0, '2009-11-08 17:41:37', 0, '2009-11-06', '2009-11-05'),
(91103035, '2008017', 'fdsafasf', 'afasfasf', 1, '2009-11-05 13:33:58', 1, '2009-11-05', '2009-11-05'),
(91103047, '2008017', '取经d', '叫醒唐僧d', 1, '2009-11-07 14:53:59', 0, '2009-11-05', '2009-11-05'),
(91103049, '2008017', '开始吃饭2', '开始吃饭2', 0, '2009-11-05 13:37:57', 0, '2009-11-05', '2009-11-05'),
(91103055, '2008017', 'qqqqq', 'qqq', 0, '2009-11-05 18:17:46', 1, '2009-11-05', '2009-11-05'),
(91103056, '2008017', 'q', 'q', 0, '2009-11-05 18:22:09', 1, '2009-11-05', '2009-11-05'),
(91103057, '2008017', 'ssss', 'ssss', 0, '2009-11-06 11:09:52', 1, '2009-11-06', '2009-11-05'),
(91103058, '2008017', '方式大法', '反对萨芬', 0, '2009-11-06 10:38:46', 0, '2009-11-06', '2009-11-06'),
(91103059, '2008017', 'dfasd', 'afdaf', 0, '2009-11-06 10:38:53', 0, '2009-11-06', '2009-11-06'),
(91103060, '2008017', 'fdasfda', 'fasfd', 1, '2009-11-06 10:39:00', 0, '2009-11-06', '2009-11-06'),
(91103061, '2008017', '1', '1', 0, '2009-11-06 10:40:53', 0, '2009-11-06', '2009-11-06'),
(91103062, '2008017', '2', '2', 0, '2009-11-06 10:41:05', 0, '2009-11-06', '2009-11-06'),
(91103063, '2008017', '3', '3', 0, '2009-11-06 10:41:10', 0, '2009-11-06', '2009-11-06'),
(91103064, '2008017', 's', 'sa', 0, '2009-11-06 11:37:09', 0, '2009-11-10', '2009-11-06'),
(91103065, '2008017', 'ss', 'ssa', 1, '2009-11-06 11:09:42', 0, '2009-11-10', '2009-11-06'),
(91103066, '2008017', 'sss', 'sss', 0, '2009-11-06 11:09:47', 1, '2009-11-06', '2009-11-06'),
(91103067, '2008017', 'ssss', 'ssss', 0, '2009-11-06 11:09:52', 0, '2009-11-06', '2009-11-06'),
(91103068, '2008017', 'fdsaf', 'asfasfasf', 0, '2009-11-08 17:41:37', 0, '2009-11-06', '2009-11-06');

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

--
-- 表的结构 `user_tbl`
--

CREATE TABLE IF NOT EXISTS `user_tbl` (
  `userID` varchar(15) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(10) NOT NULL,
  `age` int(2) NOT NULL,
  `hobby` varchar(200) NOT NULL,
  `indivimemo` varchar(300) NOT NULL,
  `update` date default NULL,
  `insertdate` date NOT NULL,
  PRIMARY KEY  (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 导出表中的数据 `user_tbl`
--

INSERT INTO `user_tbl` (`userID`, `username`, `password`, `age`, `hobby`, `indivimemo`, `update`, `insertdate`) VALUES
('2008017', '刘建宏', '111', 20, '睡觉', '明天不一定美好，但是美好明天一定会来', '2009-10-29', '2009-10-29'),
('20080171', '第三大对方', '111', 11, '第三大对方亲亲', '第三大对方', NULL, '2009-10-30'),
('20080172', '222', '222', 22, '2222', '22222', NULL, '2009-10-30'),
('2008017222', '2222', '22', 222, '2222', '222', NULL, '2009-10-30'),
('20080172w', 'sdad', 'www', 11, 'ww', 'ww', NULL, '2009-10-30'),
('20080174', 'sdfsfa', '111', 222, 'eee', 'eeeeee', NULL, '2009-11-02');