[root@localhost ~]# mysqldump --no-data --default-character-set=utf8 banpingdb -u root -p>banping.sql
--
-- Table structure for table `a_album_bind`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `a_album_bind` (
`abd_type` char(10) NOT NULL COMMENT 'app鐨勭被鍒?濡俠iz,event绛?,
`abd_id` bigint(20) NOT NULL COMMENT 'app鐨刬d',
`abd_album_id` bigint(20) NOT NULL COMMENT '鐩稿唽id',
`abd_u_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`abd_type`,`abd_id`,`abd_album_id`)
);
mysql> show create table a_album_bind;
+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| a_album_bind | CREATE TABLE `a_album_bind` (
`abd_type` char(10) NOT NULL COMMENT 'app的类别 如biz,event等',
`abd_id` bigint(20) NOT NULL COMMENT 'app的id',
`abd_album_id` bigint(20) NOT NULL COMMENT '相册id',
`abd_u_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`abd_type`,`abd_id`,`abd_album_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='app中需要使用相册,app对象和相册的绑定关系' |
+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
[本帖最后由 ban_ping 于 2011-2-17 11:51 编辑]