You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2019/11/18 01:17:38 UTC

[GitHub] [incubator-shardingsphere] hao110937733 opened a new issue #3544: NO PRIMARY KEY

hao110937733 opened a new issue #3544: NO PRIMARY KEY
URL: https://github.com/apache/incubator-shardingsphere/issues/3544
 
 
   when I create table by sharding-proxy,open any table in sharidng-proxy,The system prompts that there is no primary key
   this is my mysql:
   CREATE TABLE PT_DM_PKG
   (
      PKG_ID               VARCHAR(32) NOT NULL COMMENT '包ID',
      PKG_NAME             VARCHAR(64) NOT NULL COMMENT '包名称',
      PAR_PKG_ID           VARCHAR(32) COMMENT '父包ID',
      APP_ID               VARCHAR(32) NOT NULL COMMENT '应用ID',
      PKG_DESC             VARCHAR(256) COMMENT '描述',
      PKG_EXTOPT           VARCHAR(1024) COMMENT '扩展定义',
      PKG_DISPIDX          INT NOT NULL COMMENT '显示顺序',
      PKG_CTIME            TIMESTAMP NOT NULL COMMENT '创建时间',
      PKG_MTIME            TIMESTAMP NOT NULL COMMENT '最后修改时间',
      PRIMARY KEY (PKG_ID)
   ) ENGINE=INNODB DEFAULT CHARSET=UTF8;
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services