select * from cn_user;
select * from cn_notebook_type;
select * from cn_notebook;
select * from cn_note;
select * from cn_share;
select * from cn_activity;
select * from cn_note_activity;
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `cn_user`
-- ----------------------------
DROP TABLE IF EXISTS `cn_user`;
CREATE TABLE `cn_user` (
`cn_user_id` varchar(100) NOT NULL COMMENT '用户ID',
`cn_user_name` varchar(100) DEFAULT NULL COMMENT '用户名',
`cn_user_password` varchar(100) DEFAULT NULL COMMENT '密码',
`cn_user_token` varchar(100) DEFAULT NULL COMMENT '令牌',
`cn_user_desc` text COMMENT '说明',
PRIMARY KEY (`cn_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of cn_user
-- ----------------------------
INSERT INTO `cn_user` VALUES ('03590914-a934-4da9-ba4d-b41799f917d1', 'zhouj', '55587a910882016321201e6ebbc9f595', null, null);
INSERT INTO `cn_user` VALUES ('2273f742-61ec-4440-b88a-42cf48db19ff', 'zhoujia123', '4297f44b13955235245b2497399d7a93', null, null);
INSERT INTO `cn_user` VALUES ('333c6d0b-e4a2-4596-9902-a5d98c2f665a', 'test1', '96e79218965eb72c92a549dd5a330112', null, null);
INSERT INTO `cn_user` VALUES ('39295a3d-cc9b-42b4-b206-a2e7fab7e77c', 'zhoujia', '4297f44b13955235245b2497399d7a93', null, null);
INSERT INTO `cn_user` VALUES ('48595f52-b22c-4485-9244-f4004255b972', 'demo', 'c8837b23ff8aaa8a2dde915473ce0991', null, null);
INSERT INTO `cn_user` VALUES ('524f7440-7283-4b2d-8af5-4a67570e892e', 'pc', 'e10adc3949ba59abbe56e057f20f883e', null, null);
INSERT INTO `cn_user` VALUES ('52f9b276-38ee-447f-a3aa-0d54e7a736e4', 'wsf', '6e7d70ed3edfb80421235af5c4ad24aa', null, null);
INSERT INTO `cn_user` VALUES ('6f339f0a-2068-4db1-8fef-8e68f444c72c', 'saipi', '4297f44b13955235245b2497399d7a93', null, null);
INSERT INTO `cn_user` VALUES ('974375a8-8557-4308-bd36-9455c7863239', 'zhoujia1231', '6a204bd89f3c8348afd5c77c717a097a', null, null);
INSERT INTO `cn_user` VALUES ('bf9d2885-f34e-4c78-9ae5-2723f62aa2b5', 'saipi', '4297f44b13955235245b2497399d7a93', null, null);
INSERT INTO `cn_user` VALUES ('ea09d9b1-ede7-4bd8-b43d-a546680df00b', 'yht', '96e79218965eb72c92a549dd5a330112', null, null);
commit;
-- ----------------------------
-- Table structure for `cn_notebook_type`
-- ----------------------------
DROP TABLE IF EXISTS `cn_notebook_type`;
CREATE TABLE `cn_notebook_type` (
`cn_notebook_type_id` varchar(100) NOT NULL COMMENT '笔记本类型ID',
`cn_notebook_type_code` varchar(100) DEFAULT NULL COMMENT '笔记本类型Code',
`cn_notebook_type_name` varchar(500) DEFAULT NULL COMMENT '笔记本类型名称',
`cn_notebook_type_desc` text COMMENT '笔记本类型说明',
PRIMARY KEY (`cn_notebook_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of cn_notebook_type
-- ----------------------------
INSERT INTO `cn_notebook_type` VALUES ('1', 'favorites', 'favorites', '收藏');
INSERT INTO `cn_notebook_type` VALUES ('2', 'recycle', 'recycle', '回收站');
INSERT INTO `cn_notebook_type` VALUES ('3', 'action', 'action', '活动');
INSERT INTO `cn_notebook_type` VALUES ('4', 'push', 'push', '推送');
INSERT INTO `cn_notebook_type` VALUES ('5', 'normal', 'normal', '正常');
commit;
-- ----------------------------
-- Table structure for `cn_notebook`
-- ----------------------------
DROP TABLE IF EXISTS `cn_notebook`;
CREATE TABLE `cn_notebook` (
`cn_notebook_id` varchar(100) NOT NULL COMMENT '笔记本ID',
`cn_user_id` varchar(100) DEFAULT NULL COMMENT '用户ID',
`cn_notebook_type_id` varchar(100) DEFAULT NULL COMMENT '笔记本类型ID',
`cn_notebook_name` varchar(500) DEFAULT NULL COMMENT '笔记本名',
`cn_notebook_desc` text COMMENT '笔记本说明',
`cn_notebook_createtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`cn_notebook_id`),
KEY `FK_Note_User_Reference` (`cn_user_id`),
KEY `FK_Reference_6` (`cn_notebook_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of cn_notebook
-- ----------------------------
INSERT INTO `cn_notebook` VALUES ('0037215c-09fe-4eaa-aeb5-25a340c6b39b', '52f9b276-38ee-447f-a3aa-0d54e7a736e4', '5', 'wsf', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('01e24d89-15ab-4b6a-bf6f-2e5ad10b2041', '39295a3d-cc9b-42b4-b206-a2e7fab7e77c', '5', '笔记本1111', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('049d4cd3-943b-4fc0-97cf-520cd788fe85', '39295a3d-cc9b-42b4-b206-a2e7fab7e77c', '5', '笔记本1', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('0b11444a-a6d6-45ff-8d46-282afaa6a655', '39295a3d-cc9b-42b4-b206-a2e7fab7e77c', '5', '笔记本1', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('0cd94778-4d52-486d-a35d-263b3cfe6de9', '39295a3d-cc9b-42b4-b206-a2e7fab7e77c', '5', 'zhoujia_test', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('12119052-874c-4341-b85d-6529e171ed83', '48595f52-b22c-4485-9244-f4004255b972', '5', '测试——5', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('1755013b-05fc-4218-83cf-956287a81b49', 'ea09d9b1-ede7-4bd8-b43d-a546680df00b', '4', 'push', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('1b05c9c7-f1cd-4842-beae-15ed95a1febb', '03590914-a934-4da9-ba4d-b41799f917d1', '3', 'action', null, '2014-07-09 17:16:45');
INSERT INTO `cn_notebook` VALUES ('1d46f5db-f569-4c05-bdba-75106108fcba', '39295a3d-cc9b-42b4-b206-a2e7fab7e77c', '1', 'favorites', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('1db556b9-d1dc-4ed9-8274-45cf0afbe859', '48595f52-b22c-4485-9244-f4004255b972', '3', 'action', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('1ea71525-2a72-4115-abb0-197b78e92f29', '524f7440-7283-4b2d-8af5-4a67570e892e', '5', 'sssss', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('1ecf916f-61b8-409a-8173-1e548ac65d89', 'ea09d9b1-ede7-4bd8-b43d-a546680df00b', '3', 'action', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('1fdb7adb-5da0-41f7-8f4e-5a512dbed9fc', '52f9b276-38ee-447f-a3aa-0d54e7a736e4', '4', 'push', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('20b4cbec-bd55-4c21-9c41-3a11ada2b803', '39295a3d-cc9b-42b4-b206-a2e7fab7e77c', '3', 'action', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('2a4ca5bb-3073-4194-9d4e-5db0ec5c0998', '48595f52-b22c-4485-9244-f4004255b972', '2', 'recycle', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('2c0bda01-b6bb-48b3-92e5-89f42cda6d27', '333c6d0b-e4a2-4596-9902-a5d98c2f665a', '4', 'push', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('4acb305b-5def-47ae-8832-c2a188662085', '39295a3d-cc9b-42b4-b206-a2e7fab7e77c', '4', 'push', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('516f6f4f-eaa3-4c76-84ff-530b92c7f64d', '39295a3d-cc9b-42b4-b206-a2e7fab7e77c', '5', 'hadoop', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('5612df0f-2b3a-4a8c-8df7-e1de67b6abcd', '39295a3d-cc9b-42b4-b206-a2e7fab7e77c', '5', 'time_test', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('59b354f8-47ae-437d-a432-7d28736bd894', '48595f52-b22c-4485-9244-f4004255b972', '5', '333', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('64639e62-9241-4efb-874b-01e97257cb6e', '333c6d0b-e4a2-4596-9902-a5d98c2f665a', '5', 'test_1', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('6666666666666666666666666666666666', '524f7440-7283-4b2d-8af5-4a67570e892e', '3', 'avtion', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('6d763ac9-dca3-42d7-a2a7-a08053095c08', '39295a3d-cc9b-42b4-b206-a2e7fab7e77c', '2', 'recycle', null, '2014-06-27 15:18:59');
INSERT INTO `cn_notebook` VALUES ('6dc39e41-8c9e-4791-9c13-52a8e537fe64', '524f7