1.创建表
- -- ----------------------------
- -- Table structure for `documents`
- -- ----------------------------
- DROP TABLE IF EXISTS `documents`;
- CREATE TABLE `documents` (
- `id` int(11) NOT NULL auto_increment,
- `date_added` datetime NOT NULL,
- `title` varchar(255) NOT NULL,
- `content` text NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of documents
- -- ----------------------------
- INSERT INTO `documents` VALUES ('1', '2012-01-11 23:15:59', 'world', 'test1');
- INSERT INTO &#