oracle与mysql和sqlserver数据库移植转换问题
有一个数据库表结构,求数据库高手帮我转成mysql或者sqlserver的表结构:
本人联系方式 msn:zhl_810909@hotmail.com,qq:122468613 谢谢
spool b.log
prompt
prompt Creating table TB_CANDIDATE
prompt ===========================
prompt
create table TB_CANDIDATE
(
ID NUMBER not null,
NAME VARCHAR2(100),
EMAIL VARCHAR2(100),
TELL VARCHAR2(16),
INDUSTRY VARCHAR2(20),
CALLING VARCHAR2(20),
ENABLE NUMBER
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table TB_CANDIDATE
add primary key (ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table TB_CUSTOMER
prompt ==========================
prompt
create table TB_CUSTOMER
(
ID INTEGER not null,
NAME VARCHAR2(50),
MAIL VARCHAR2(30),
WEB VARCHAR2(30),
TELL VARCHAR2(16),
FAX VARCHAR2(16),
INDUSTRY VARCHAR2(20),
ENABLE INTEGER
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table TB_CUSTOMER
add primary key (ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table TB_DIRECTORY
prompt ===========================
prompt
create table TB_DIRECTORY
(
ID INTEGER not null,
NAME VARCHAR2(20),
TYPE VARCHAR2(10),
LINKID INTEGER
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table TB_DIRECTORY
add primary key (ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table TB_IMAGE
prompt =======================
prompt
create table TB_IMAGE
(
ID INTEGER,
URL VARCHAR2(200),
TYPE VARCHAR2(20)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table TB_MAIL
prompt ======================
prompt
create table TB_MAIL
(
ID INTEGER not null,
CONTENT CLOB,
TITLE VARCHAR2(50)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table TB_MAIL
add primary key (ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table TB_MAILCONTENT
prompt =============================
prompt
create table TB_MAILCONTENT
(
ID INTEGER not null,
MAILID VARCHAR2(20),
URL VARCHAR2(100),
EDIT CLOB,
ENABLE INTEGER,
TITLE VARCHAR2(200),
DIRECTORY_ID VARCHAR2(20),
TYPE VARCHAR2(2),
PROPERTY_ID VARCHAR2(20)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table TB_MAILCONTENT
add primary key (ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table TB_MAILPROPERTY
prompt ==============================
prompt
create table TB_MAILPROPERTY
(
ID INTEGER not null,
PERIODICAL VARCHAR2(500),
TEMPLATE VARCHAR2(10),
MAILID VARCHAR2(20),
TIME DATE
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table TB_MAILPROPERTY
add primary key (ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table TB_MAILSETTING
prompt =============================
prompt
create table TB_MAILSETTING
(
ID INTEGER not null,
USERID VARCHAR2(60),
ACCOUNT VARCHAR2(60),
PASSWORD VARCHAR2(20),
SMTP VARCHAR2(50),
EMAIL VARCHAR2(60)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table TB_MAILSETTING
add primary key (ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table TB_SENDMAIL
prompt ==========================
prompt
create table TB_SENDMAIL
(
ID NUMBER not null,
SENDID VARCHAR2(100),
EMAIL VARCHAR2(100),
TYPE VARCHAR2(10),
STATE VARCHAR2(10),
TIME DATE,
NAME VARCHAR2(100),
MAILID VARCHAR2(100)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table TB_SENDMAIL
add primary key (ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table TB_TONGJINUMBER
prompt ==============================
prompt
create table TB_TONGJINUMBER
(
ID INTEGER not null,
NAME VARCHAR2(20),
MAIL VARCHAR2(20),
MAILCONTENT_ID VARCHAR2(20),
DIRECTORY_ID VARCHAR2(20),
TIME DATE
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table T_FILE
prompt =====================
prompt
create table T_FILE
(
FILE_ID CHAR(32) not null,
FILE_NAME VARCHAR2(100),
FILE_CONTENT BLOB,
REMARK VARCHAR2(400)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table T_FILE
add primary key (FILE_ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
spool off