sql
D:\project\shop_cc_j2ee\src\J2EE\pa18shopcc-dmz.war\daikuan\p\shouxian\js\sxd.js
D:\project\shop_cc_j2ee\src\J2EE\pa18shopcc-dmz.war\product\pshouxian\js\chefangd.js
wap端js-xinjd.js
create table CCDATA.CC_USER_KK_INFO
(
ID_CC_USER_KK_INFO VARCHAR2(40),
USER_NAME VARCHAR2(50) ,
PASS_WORD VARCHAR2(50) ,
CREATED_DATE DATE,
CREATED_BY VARCHAR2(100),
UPDATED_DATE DATE,
UPDATED_BY VARCHAR2(100)
);
comment on column CCDATA.CC_USER_KK_INFO.USER_NAME is '用户名';
comment on column CCDATA.CC_USER_KK_INFO.PASS_WORD is '登陆密码';
comment on column CCDATA.CC_USER_KK_INFO.CREATED_DATE is '创建时间';
comment on column CCDATA.CC_USER_KK_INFO.CREATED_BY is '创建人';
comment on column CCDATA.CC_USER_KK_INFO.UPDATED_DATE is '修改时间';
comment on column CCDATA.CC_USER_KK_INFO.UPDATED_BY is '修改人';
--写主键索引 主键别名 表名 表的主键
CREATE UNIQUE INDEX CCDATA.PK_ID_CC_USER_KK_INFO ON CCDATA.CC_USER_KK_INFO (ID_CC_USER_KK_INFO) initrans 16;
-- 表名 主键别名 表的主键
ALTER TABLE CCDATA.CC_USER_KK_INFO ADD CONSTRAINT PK_ID_CC_USER_KK_INFO PRIMARY KEY (ID_CC_USER_KK_INFO) USING INDEX
CCDATA.PK_ID_CC_USER_KK_INFO;
-- 主键别名
select * from CCDATA.CC_USER_KK_INFO for update;
--同义词
CREATE PUBLIC SYNONYM cc_user_kk_info for CCDATA.cc_user_kk_info;
--角色授权
GRANT SELECT, INSERT, UPDATE, DELETE ON CCDATA.cc_user_kk_info TO R_CCDATA_DML;
GRANT SELECT ON CCDATA.cc_user_kk_info TO R_CCDATA_QRY;
GRANT SELECT ON CCDATA.cc_user_kk_info TO R_CCDATA_DEV_QRY;
GRANT SELECT, INSERT, UPDATE, DELETE ON CCDATA.cc_user_kk_info TO R_CCDATA_DML;
GRANT SELECT ON CCDATA.cc_user_kk_info TO R_CCDATA_QRY;
GRANT SELECT ON CCDATA.cc_user_kk_info TO R_CCDATA_DEV_QRY;
MYSQL建表:
Create Table |
使用mysql某数据库引擎,默认utf-8子符集 |