-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.0.67-log
/*!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 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
--
-- Create schema ja00028
--
CREATE DATABASE IF NOT EXISTS ja00028;
USE ja00028;
--
-- Definition of table `appraisal`
--
DROP TABLE IF EXISTS `appraisal`;
CREATE TABLE `appraisal` (
`Id` int(11) NOT NULL auto_increment,
`contents` varchar(120) default NULL COMMENT '评价内容',
`articlesId` int(11) default NULL COMMENT '文章id',
`isuse` int(11) default NULL COMMENT '是否可用',
`userId` int(11) default NULL COMMENT '用户id',
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章评价表';
--
-- Dumping data for table `appraisal`
--
/*!40000 ALTER TABLE `appraisal` DISABLE KEYS */;
/*!40000 ALTER TABLE `appraisal` ENABLE KEYS */;
--
-- Definition of table `articles`
--
DROP TABLE IF EXISTS `articles`;
CREATE TABLE `articles` (
`Id` int(11) NOT NULL auto_increment,
`title` varchar(255) default NULL COMMENT '标题',
`newtime` datetime default NULL COMMENT '创建时间',
`usersId` int(11) default NULL COMMENT '用户id',
`sort` int(11) default NULL COMMENT '顺序',
`contents` blob COMMENT '文章正文',
`isuse` varchar(16) default NULL COMMENT '是否可用',
`columnid` int(11) default NULL COMMENT '所属栏目',
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COMMENT='文章表';
--
-- Dumping data for table `articles`
--
/*!40000 ALTER TABLE `articles` DISABLE KEYS */;
INSERT INTO `articles` (`Id`,`title`,`newtime`,`usersId`,`sort`,`contents`,`isuse`,`columnid`) VALUES
(8,' java介绍','2009-09-10 13:07:39',1,1,0x3C703ED2BB6A617661B5C4D3A6D3C3B7BDC3E63A6A327365A1A26A326565A1A26A326D653C6272202F3E0D0A4A325345C9CCD2B5B0E6B1BEA3ACB1EAD7BCB0E6B1BE20284A61766132205374616E646172642045646974696F6E2920B6A8CEBBD4DABFCDBBA7B6CBA3ACD6F7D2AAD3C3D3DAD7C0C3E6D3A6D3C3C8EDBCFEB5C4B1E0B3CCA1A33C2F703E0D0A3C703E4A32534520B0FCBAACC4C7D0A9B9B9B3C94A617661D3EFD1D4BACBD0C4B5C4C0E0A1A33C2F703E0D0A3C703EB1C8C8E7A3BACAFDBEDDBFE2C1ACBDD3A1A2BDD3BFDAB6A8D2E5A1A2CAE4C8EB2FCAE4B3F6A1A2CDF8C2E7B1E0B3CC3C2F703E0D0A3C703E4A324545204A61766132C6BDCCA8C6F3D2B5B0E6A3A84A617661203220506C6174666F726D2C456E74657270726973652045646974696F6EA3A93C2F703E0D0A3C703E4A324545CAC7D2BBCCD7C8ABC8BBB2BBCDACD3DAB4ABCDB3D3A6D3C3BFAAB7A2B5C4BCBCCAF5BCDCB9B9A3ACB0FCBAACD0EDB6E0D7E9BCFEA3ACD6F7D2AABFC9BCF2BBAFC7D2B9E6B7B6D3A6D3C3CFB5CDB3B5C4BFAAB7A2D3EBB2BFCAF0A3ACBDF8B6F8CCE1B8DFBFC9D2C6D6B2D0D4A1A2B0B2C8ABD3EBD4D9D3C3BCDBD6B5A1A33C2F703E0D0A3C703E4A324D4520D4DAC9E8BCC6C6E4B9E6B8F1B5C4CAB1BAF2A3ACD7F1D1ADD7C5A1B8B6D4D3DAB8F7D6D6B2BBCDACB5C4D7B0D6C3B6F8D4ECB3F6D2BBB8F6B5A5D2BBB5C4BFAAB7A2CFB5CDB3CAC7C3BBD3D0D2E2D2E5B5C4CAC2A1B9D5E2B8F6BBF9B1BED4ADD4F2A1A3D3DACAC7204A324D4520CFC8BDABCBF9D3D0B5C4C7B6C8EBCABDD7B0D6C3B4F3CCE5C9CFC7F8B7D6CEAAC1BDD6D6203AD2BBD6D6CAC7D4CBCBE3B9A6C4DCD3D0CFDEA1A2B5E7C1A6B9A9D3A6D2B2D3D0CFDEB5C4C7B6C8EBCABDD7B0D6C328B1C8B7BDCBB550444120A1A2CAD6BBFA29A3BBC1EDCDE2D2BBD6D6D4F2CAC7D4CBCBE3C4DCC1A6CFE0B6D4BDCFBCD1A1A2B2A2C7EBD4DAB5E7C1A6B9A9D3A6C9CFCFE0B6D4B1C8BDCFB3E4D7E3B5C4C7B6C8EBCABDD7B0D6C32028B1C8B7BDCBB5C0E4C6F8BBFAA1A2B5E7B1F9CFE4A1A2B5E7CAD3BBFAC9CFBAD020287365742D746F7020626F782929A1A3D2F2CEAAD5E2C1BDD6D6D0CDCCACB5C4C7B6C8EBCABDD7B0D6C3A3ACCBF9D2D44A61766120D2FDC8EBC1CBD2BBB8F6BDD0D7F6436F6E66696775726174696F6E20B5C4B8C5C4EEA3ACC8BBBAF3B0D1C9CFCAF6D4CBCBE3B9A6C4DCD3D0CFDEA1A2B5E7C1A6D3D0CFDEB5C4C7B6C8EBCABDD7B0D6C3B6A8D2E5D4DA436F6E6E6563746564204C696D697465642044657669636520436F6E66696775726174696F6E28434C444329B9E6B8F1D6AED6D0A3BBB6F8C1EDCDE2D2BBD6D6D7B0D6C3D4F2B9E6B7B6CEAA20436F6E6E65637465642044657669636520436F6E66696775726174696F6E2843444329B9E6B8F1A1A3D2B2BECDCAC7CBB5A3AC204A324D4520CFC8B0D1CBF9D3D0B5C4C7B6C8EBCABDD7B0D6C3C0FBD3C3436F6E66696775726174696F6E20B5C4B8C5C4EEC7F8B8F4B3C9C1BDD6D6B3E9CFF3B5C4D0CDCCACA1A33C2F703E0D0A3C703EB6FE6A326565CCE5CFB5BDE1B9B9BCF2B5A5BDE9C9DC3C6272202F3E0D0AA1A1A1A131A1A220C6F3D2B5BCB6D3A6D3C3BFF2BCDCB5C4D0E8C7F33C2F703E0D0A3C703EA1A1A1A1D4DAD0EDB6E0C6F3D2B5BCB6D3A6D3C3D6D0A3ACC0FDC8E7CAFDBEDDBFE2C1ACBDD3A1A2D3CABCFEB7FECEF1A1A2CAC2CEF1B4A6C0EDB5C8B6BCCAC7D2BBD0A9CDA8D3C3C6F3D2B5D0E8C7F3C4A3BFE9A3ACD5E2D0A9C4A3BFE9C8E7B9FBC3BFB4CED4D9BFAAB7A2D6D0B6BCD3C9BFAAB7A2C8CBD4B1C0B4CDEAB3C9B5C4BBB0A3ACBDABBBE1D4ECB3C9BFAAB7A2D6DCC6DAB3A4BACDB4FAC2EBBFC9BFBFD0D4B2EEB5C8CECACCE2A1A3D3DACAC7D0EDB6E0B4F3B9ABCBBEBFAAB7A2C1CBD7D4BCBAB5C4CDA8D3C3C4A3BFE9B7FECEF1A1A3D5E2D0A9B7FECEF1D0D4B5C4C8EDBCFECFB5C1D0CDACB3C2CEAAD6D0BCE4BCFEA1A33C2F703E0D0A3C703EA1A1A1A132A1A220CEAAC1CBCDA8D3C3B1D8D0EBD2AACCE1B3F6B9E6B7B6A3ACB2BBC8BBCEDEB7A8B4EFB5BDCDA8D3C33C2F703E0D0A3C703EA1A1A1A1D4DAC9CFC3E6B5C4D0E8C7F3BBF9B4A1D6AEC9CFA3ACD0EDB6E0B9ABCBBEB6BCBFAAB7A2C1CBD7D4BCBAB5C4D6D0BCE4BCFEA3ACB5ABC6E4D3EBD3C3BBA7B5C4B9B5CDA8B6BCB8F7D3D0B2BBCDACA3ACB4D3B6F8B5BCD6C2D3C3BBA7CEDEB7A8BDABB8F7B8F6B9ABCBBEB2BBCDACB5C4D6D0BCE4BCFED7E9D7B0D4DAD2BBBFE9CEAAD7D4BCBAB7FECEF1A1A3B4D3B6F8B2FAC9FAC6BFBEB1A1A3D3DACAC7CCE1B3F6B1EAD7BCB5C4B8C5C4EEA1A3C6E4CAB54A324545BECDCAC7BBF9D3DA4A415641BCBCCAF5B5C4D2BBCFB5C1D0B1EAD7BCA1A33C2F703E0D0A3C703EA1A1A1A1D7A2A3BAD6D0BCE4BCFEB5C4BDE2CACD20D6D0BCE4BCFEB4A6D4DAB2D9D7F7CFB5CDB3BACDB8FCB8DFD2BBBCB6D3A6D3C3B3CCD0F2D6AEBCE4A1A3CBFBB3E4B5B1B5C4B9A6C4DCCAC7A3BABDABD3A6D3C3B3CCD0F2D4CBD0D0BBB7BEB3D3EBB2D9D7F7CFB5CDB3B8F4C0EBA3ACB4D3B6F8CAB5CFD6D3A6D3C3B3CCD0F2BFAAB7A2D5DFB2BBB1D8CEAAB8FCB6E0CFB5CDB3CECACCE2D3C7C2C7A3ACB6F8D6B1BDD3B9D8D7A2B8C3D3A6D3C3B3CCD0F2D4DABDE2BEF6CECACCE2C9CFB5C4C4DCC1A620A1A3CED2C3C7BAF3C3E6CBB5B5BDB5C4C8DDC6F7B5C4B8C5C4EEBECDCAC7D6D0BCE4BCFEB5C4D2BBD6D6A1A33C2F703E0D0A3C703EA1A1A1A1B6FEA1A2CFE0B9D8C3FBB4CABDE2CACD3C2F703E0D0A3C703EA1A1A1A1C8DDC6F7A3BAB3E4B5B1D6D0BCE4BCFEB5C4BDC7C9AB3C2F703E0D0A3C703EA1A1A1A1574542C8DDC6F7A3BAB8F8B4A6D3DAC6E4D6D0B5C4D3A6D3C3B3CCD0F2D7E9BCFE284A5350A3AC534552564C455429CCE1B9A9D2BBB8F6BBB7BEB3A3ACCAB94A53502C534552564C4554D6B1BDD3B8FCC8DDC6F7D6D0B5C4BBB7BEB3B1E4C1BFBDD3BFDABDBBBBA5A3ACB2BBB1D8B9D8D7A2C6E4CBFCCFB5CDB3CECACCE2A1A3D6F7D2AAD3D0574542B7FECEF1C6F7C0B4CAB5CFD6A1A3C0FDC8E7A3BA544F4D4341542C5745424C4F4749432C574542535048455245B5C8A1A3B8C3C8DDC6F7CCE1B9A9B5C4BDD3BFDAD1CFB8F1D7F1CAD84A324545B9E6B7B6D6D0B5C4574542204150504C49434154494F4E20B1EAD7BCA1A3CED2C3C7B0D1D7F1CAD8D2D4C9CFB1EAD7BCB5C4574542B7FECEF1C6F7BECDBDD0D7F64A324545D6D0B5C4574542C8DDC6F7A1A33C2F703E0D0A3C703EA1A1A1A1C8DDC6F7A3BA456E7465727072697365206A617661206265616E20C8DDC6F7A1A3B8FCBEDFD3D0D0D0D2B5C1ECD3F2CCD8C9ABA1A3CBFBCCE1B9A9B8F8D4CBD0D0D4DAC6E4D6D0B5C4D7E9BCFE454A42B8F7D6D6B9DCC0EDB9A6C4DCA1A3D6BBD2AAC2FAD7E34A324545B9E6B7B6B5C4454A42B7C5C8EBB8C3C8DDC6F7A3ACC2EDC9CFBECDBBE1B1BBC8DDC6F7BDF8D0D0B8DFD0A7C2CAB5C4B9DCC0EDA1A3B2A2C7D2BFC9D2D4CDA8B9FDCFD6B3C9B5C4BDD3BFDAC0B4BBF1B5C3CFB5CDB3BCB6B1F0B5C4B7FECEF1A1A3C0FDC8E7D3CABCFEB7FECEF1A1A2CAC2CEF1B9DCC0EDA1A33C2F703E0D0A3C703EA1A1A1A1574542C8DDC6F7BACD454A42C8DDC6F7D4DAD4ADC0EDC9CFCAC7B4F3CCE5CFE0CDACB5C4A3ACB8FCB6E0B5C4C7F8B1F0CAC7B1BBB8F4C0EBB5C4CDE2BDE7BBB7BEB3A1A3574542C8DDC6F7B8FCB6E0B5C4CAC7B8FABBF9D3DA48545450B5C4C7EBC7F3B4F2BDBBB5C0A1A3B6F8454A42C8DDC6F7B2BBCAC7A1A3CBFCCAC7B8FCB6E0B5C4B8FACAFDBEDDBFE2A1A2C6E4CBFCB7FECEF1B4F2BDBBB5C0A1A3B5ABCBFBC3C7B6BCCAC7B0D1D3EBCDE2BDE7B5C4BDBBBBA5CAB5CFD6B4D3B6F8BCF5C7E1D3A6D3C3B3CCD0F2B5C4B8BAB5A3A1A3C0FDC8E7534552564C4554B2BBD3C3B9D8D0C448545450B5C4CFB8BDDAA3ACD6B1BDD3D2FDD3C3BBB7BEB3B1E4C1BF73657373696F6E2C726571756573742C726573706F6E7365BECDD0D0A1A2454A42B2BBD3C3B9D8D0C4CAFDBEDDBFE2C1ACBDD3CBD9B6C8A1A2B8F7D6D6CAC2CEF1BFD8D6C6A3ACD6B1BDD3D3C9C8DDC6F7C0B4CDEAB3C
- 1
- 2
- 3
- 4
前往页