Ajax

开发平台：

Java

ajax.sql：源码内容

`seq` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED COMMENT='1.4';
--
-- Dumping data for table `select_menu`
--
LOCK TABLES `select_menu` WRITE;
/*!40000 ALTER TABLE `select_menu` DISABLE KEYS */;
INSERT INTO `select_menu` VALUES ('A1','列表A选项1','INIT',1),('A2','列表A选项2','INIT',2),('B11','列表B选项11','A1',1),('B12','列表B选项12','A1',2),('B13','列表B选项13','A1',3),('B21','列表B选项21','A2',1),('B22','列表B选项22','A2',2),('C111','列表C选项111','B11',1),('C112','列表C选项112','B11',2),('C121','列表C选项121','B12',1),('C122','列表C选项122','B12',2),('C131','列表C选项131','B13',1),('C132','列表C选项132','B13',2),('C211','列表C选项211','B21',1),('C212','列表C选项212','B21',2),('C221','列表C选项221','B22',1),('C222','列表C选项222','B22',2);
/*!40000 ALTER TABLE `select_menu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `servers`
--
DROP TABLE IF EXISTS `servers`;
CREATE TABLE `servers` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`checktime` int(11) NOT NULL,
`url` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT COMMENT='7.3';
--
-- Dumping data for table `servers`
--
LOCK TABLES `servers` WRITE;
/*!40000 ALTER TABLE `servers` DISABLE KEYS */;
INSERT INTO `servers` VALUES (1,'LocalHTML',10000,'http://localhost:8080/ajax/7.3/test1.html'),(2,'LocalJSP',30000,'http://localhost:8080/ajax/7.3/test2.jsp'),(3,'GOOGLE',60000,'http://www.google.com');
/*!40000 ALTER TABLE `servers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sort_info`
--
DROP TABLE IF EXISTS `sort_info`;
CREATE TABLE `sort_info` (
`id` int(11) NOT NULL auto_increment,
`info` varchar(255) NOT NULL,
`seq` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT COMMENT='2.5';
--
-- Dumping data for table `sort_info`
--
LOCK TABLES `sort_info` WRITE;
/*!40000 ALTER TABLE `sort_info` DISABLE KEYS */;
INSERT INTO `sort_info` VALUES (1,'信息01',1),(2,'信息02',5),(3,'信息03',2),(4,'信息04',9),(5,'信息05',7),(6,'信息06',3),(7,'信息07',4),(8,'信息08',6),(9,'信息09',10),(10,'信息10',8);
/*!40000 ALTER TABLE `sort_info` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `suggest_info`
--
DROP TABLE IF EXISTS `suggest_info`;
CREATE TABLE `suggest_info` (
`id` int(10) unsigned NOT NULL,
`info` varchar(45) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT COMMENT='2.2';
--
-- Dumping data for table `suggest_info`
--
LOCK TABLES `suggest_info` WRITE;
/*!40000 ALTER TABLE `suggest_info` DISABLE KEYS */;
INSERT INTO `suggest_info` VALUES (1,'ajax'),(2,'ajax books'),(3,'ajax tags'),(4,'ajax examples'),(5,'ajax site'),(6,'blog'),(7,'bread'),(8,'black');
/*!40000 ALTER TABLE `suggest_info` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `task_lists`
--
DROP TABLE IF EXISTS `task_lists`;
CREATE TABLE `task_lists` (
`id` int(11) NOT NULL auto_increment,
`listname` varchar(255) NOT NULL,
`userid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT COMMENT='9.3';
--
-- Dumping data for table `task_lists`
--
LOCK TABLES `task_lists` WRITE;
/*!40000 ALTER TABLE `task_lists` DISABLE KEYS */;
INSERT INTO `task_lists` VALUES (1,'目前工作',1),(2,'技术研究',1),(3,'备忘录',1),(4,'记事本',1);
/*!40000 ALTER TABLE `task_lists` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `task_tasks`
--
DROP TABLE IF EXISTS `task_tasks`;
CREATE TABLE `task_tasks` (
`id` int(11) NOT NULL auto_increment,
`taskname` varchar(255) NOT NULL,
`listid` int(11) NOT NULL,
`userid` int(11) NOT NULL,
`status` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT COMMENT='9.3';
--
-- Dumping data for table `task_tasks`
--
LOCK TABLES `task_tasks` WRITE;
/*!40000 ALTER TABLE `task_tasks` DISABLE KEYS */;
INSERT INTO `task_tasks` VALUES (2,'提交工作计划',1,1,1),(3,'Ajax技术',2,1,0),(5,'XML',2,1,1),(7,'Java',2,1,0),(13,'周一例会',1,1,0),(16,'安排测试',1,1,0),(21,'请老张吃饭',3,1,0),(23,'回邮件',3,1,1),(24,'购买生日礼物',4,1,0);
/*!40000 ALTER TABLE `task_tasks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `task_users`
--
DROP TABLE IF EXISTS `task_users`;
CREATE TABLE `task_users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT COMMENT='9.3';
--
-- Dumping data for table `task_users`
--
LOCK TABLES `task_users` WRITE;
/*!40000 ALTER TABLE `task_users` DISABLE KEYS */;
INSERT INTO `task_users` VALUES (1,'user','123456'),(2,'josh','111222');
/*!40000 ALTER TABLE `task_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tree`
--
DROP TABLE IF EXISTS `tree`;
CREATE TABLE `tree` (
`id` int(11) NOT NULL auto_increment,
`text` varchar(255) NOT NULL,
`isfolder` varchar(5) NOT NULL default 'false',
`link` varchar(255) default NULL,
`pid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)