把下面的oracle创建的数据库到建表过程的语句,用MYSQL语句表达,意思对就可以了!换句话说,就是看懂下面oracle的内容,用mysql语句来创建同样的数据库和表,注意约束关系!一定要用mysql语句!-----------------------------------------------
-- Export file for user SCOTT --
-- Created by david on 2011-1-2, 9:15:53 --
-----------------------------------------------spool myblog.logprompt
prompt Creating table FAVORITE
prompt =======================
prompt
create table FAVORITE
(
FAVORITE_ID NUMBER(10) not null,
USERNAME VARCHAR2(16),
LOG_ID NUMBER(10)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table FAVORITE
add primary key (FAVORITE_ID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);prompt
prompt Creating table LOG
prompt ==================
prompt
create table LOG
(
LOGID NUMBER(10) not null,
LOGTITLE VARCHAR2(30),
LOGCONTENT VARCHAR2(2700),
USERNAME VARCHAR2(16),
CREATEDATE DATE default sysdate
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table LOG
add primary key (LOGID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);prompt
prompt Creating table PHOTOS
prompt =====================
prompt
create table PHOTOS
(
PHOTO_ID NUMBER(5) not null,
PHOTO_TITLE VARCHAR2(50),
PHOTO_CONTENT VARCHAR2(500),
URL VARCHAR2(100) not null,
FLAG VARCHAR2(1) default 0,
USERNAME VARCHAR2(16),
CREATEDATE DATE default sysdate,
FILENAME VARCHAR2(50)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table PHOTOS
add primary key (PHOTO_ID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);prompt
prompt Creating table REVIEW
prompt =====================
prompt
create table REVIEW
(
REVIEWID NUMBER(10) not null,
REVIEWCONTENT VARCHAR2(3000),
REVIEWNAME VARCHAR2(16),
LOGID NUMBER(10),
REVIEWDATE DATE default SYSDATE
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table REVIEW
add primary key (REVIEWID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);prompt
prompt Creating table USERS
prompt ====================
prompt
create table USERS
(
USER_ID VARCHAR2(10) not null,
USER_NAME VARCHAR2(16) not null,
USER_SEX VARCHAR2(1) not null,
USER_PW VARCHAR2(16) not null,
USER_QUESTION VARCHAR2(25) not null,
USER_ANSWER VARCHAR2(25) not null,
USER_EMAIL VARCHAR2(40) not null,
USER_CONTENT VARCHAR2(100) not null,
USER_CREATEDATE DATE default SYSDATE not null
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table USERS
add primary key (USER_ID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);prompt
prompt Creating sequence FAVORITE_INSERT
prompt =================================
prompt
create sequence FAVORITE_INSERT
minvalue 1
maxvalue 9999999999999999999999999999
start with 21
increment by 1
cache 20;prompt
prompt Creating sequence LOG_INSERT
prompt ============================
prompt
create sequence LOG_INSERT
minvalue 1
maxvalue 9999999999999999999999999999
start with 61
increment by 1
cache 20;prompt
prompt Creating sequence PHOTO_INSERT
prompt ==============================
prompt
create sequence PHOTO_INSERT
minvalue 1
maxvalue 9999999999999999999999999999
start with 21
increment by 1
cache 20;prompt
prompt Creating sequence REVIEW_INSERT
prompt ===============================
prompt
create sequence REVIEW_INSERT
minvalue 1
maxvalue 9999999999999999999999999999
start with 21
increment by 1
cache 20;prompt
prompt Creating sequence USERS_INSERT
prompt ==============================
prompt
create sequence USERS_INSERT
minvalue 1
maxvalue 9999999999999999999999999999
start with 81
increment by 1
cache 20;prompt
prompt Creating trigger LOG_TRIGGER
prompt ============================
prompt
CREATE OR REPLACE TRIGGER "LOG_TRIGGER" BEFORE
INSERT ON "LOG" REFERENCING OLD AS old NEW AS new FOR EACH ROW
begin
select log_insert.nextval into:new.logid from dual;
end;
/prompt
prompt Creating trigger PAVORITE_TRIGGER
prompt =================================
prompt
CREATE OR REPLACE TRIGGER "PAVORITE_TRIGGER" BEFORE
INSERT ON "FAVORITE" REFERENCING OLD AS old NEW AS new FOR EACH ROW
begin
select favorite_insert.nextval into:new.favorite_id from dual;
end;
/prompt
prompt Creating trigger PHOTO_TRIGGER
prompt ==============================
prompt
CREATE OR REPLACE TRIGGER "PHOTO_TRIGGER" BEFORE
INSERT ON "PHOTOS" REFERENCING OLD AS old NEW AS new FOR EACH ROW
begin
select photo_insert.nextval into:new.photo_id from dual;
end;
/prompt
prompt Creating trigger REVIEW_TRIGGER
prompt ===============================
prompt
CREATE OR REPLACE TRIGGER "REVIEW_TRIGGER" BEFORE
INSERT ON "REVIEW" REFERENCING OLD AS old NEW AS new FOR EACH ROW
begin
select review_insert.nextval into:new.reviewid from dual;
end;
/prompt
prompt Creating trigger USER_TRRIGER
prompt =============================
prompt
CREATE OR REPLACE TRIGGER "USER_TRRIGER" BEFORE
INSERT ON "USERS" REFERENCING OLD AS old NEW AS new FOR EACH ROW
begin
select users_insert.nextval into:new.user_id from dual;
end;
/
spool off
-- Export file for user SCOTT --
-- Created by david on 2011-1-2, 9:15:53 --
-----------------------------------------------spool myblog.logprompt
prompt Creating table FAVORITE
prompt =======================
prompt
create table FAVORITE
(
FAVORITE_ID NUMBER(10) not null,
USERNAME VARCHAR2(16),
LOG_ID NUMBER(10)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table FAVORITE
add primary key (FAVORITE_ID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);prompt
prompt Creating table LOG
prompt ==================
prompt
create table LOG
(
LOGID NUMBER(10) not null,
LOGTITLE VARCHAR2(30),
LOGCONTENT VARCHAR2(2700),
USERNAME VARCHAR2(16),
CREATEDATE DATE default sysdate
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table LOG
add primary key (LOGID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);prompt
prompt Creating table PHOTOS
prompt =====================
prompt
create table PHOTOS
(
PHOTO_ID NUMBER(5) not null,
PHOTO_TITLE VARCHAR2(50),
PHOTO_CONTENT VARCHAR2(500),
URL VARCHAR2(100) not null,
FLAG VARCHAR2(1) default 0,
USERNAME VARCHAR2(16),
CREATEDATE DATE default sysdate,
FILENAME VARCHAR2(50)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table PHOTOS
add primary key (PHOTO_ID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);prompt
prompt Creating table REVIEW
prompt =====================
prompt
create table REVIEW
(
REVIEWID NUMBER(10) not null,
REVIEWCONTENT VARCHAR2(3000),
REVIEWNAME VARCHAR2(16),
LOGID NUMBER(10),
REVIEWDATE DATE default SYSDATE
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table REVIEW
add primary key (REVIEWID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);prompt
prompt Creating table USERS
prompt ====================
prompt
create table USERS
(
USER_ID VARCHAR2(10) not null,
USER_NAME VARCHAR2(16) not null,
USER_SEX VARCHAR2(1) not null,
USER_PW VARCHAR2(16) not null,
USER_QUESTION VARCHAR2(25) not null,
USER_ANSWER VARCHAR2(25) not null,
USER_EMAIL VARCHAR2(40) not null,
USER_CONTENT VARCHAR2(100) not null,
USER_CREATEDATE DATE default SYSDATE not null
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table USERS
add primary key (USER_ID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);prompt
prompt Creating sequence FAVORITE_INSERT
prompt =================================
prompt
create sequence FAVORITE_INSERT
minvalue 1
maxvalue 9999999999999999999999999999
start with 21
increment by 1
cache 20;prompt
prompt Creating sequence LOG_INSERT
prompt ============================
prompt
create sequence LOG_INSERT
minvalue 1
maxvalue 9999999999999999999999999999
start with 61
increment by 1
cache 20;prompt
prompt Creating sequence PHOTO_INSERT
prompt ==============================
prompt
create sequence PHOTO_INSERT
minvalue 1
maxvalue 9999999999999999999999999999
start with 21
increment by 1
cache 20;prompt
prompt Creating sequence REVIEW_INSERT
prompt ===============================
prompt
create sequence REVIEW_INSERT
minvalue 1
maxvalue 9999999999999999999999999999
start with 21
increment by 1
cache 20;prompt
prompt Creating sequence USERS_INSERT
prompt ==============================
prompt
create sequence USERS_INSERT
minvalue 1
maxvalue 9999999999999999999999999999
start with 81
increment by 1
cache 20;prompt
prompt Creating trigger LOG_TRIGGER
prompt ============================
prompt
CREATE OR REPLACE TRIGGER "LOG_TRIGGER" BEFORE
INSERT ON "LOG" REFERENCING OLD AS old NEW AS new FOR EACH ROW
begin
select log_insert.nextval into:new.logid from dual;
end;
/prompt
prompt Creating trigger PAVORITE_TRIGGER
prompt =================================
prompt
CREATE OR REPLACE TRIGGER "PAVORITE_TRIGGER" BEFORE
INSERT ON "FAVORITE" REFERENCING OLD AS old NEW AS new FOR EACH ROW
begin
select favorite_insert.nextval into:new.favorite_id from dual;
end;
/prompt
prompt Creating trigger PHOTO_TRIGGER
prompt ==============================
prompt
CREATE OR REPLACE TRIGGER "PHOTO_TRIGGER" BEFORE
INSERT ON "PHOTOS" REFERENCING OLD AS old NEW AS new FOR EACH ROW
begin
select photo_insert.nextval into:new.photo_id from dual;
end;
/prompt
prompt Creating trigger REVIEW_TRIGGER
prompt ===============================
prompt
CREATE OR REPLACE TRIGGER "REVIEW_TRIGGER" BEFORE
INSERT ON "REVIEW" REFERENCING OLD AS old NEW AS new FOR EACH ROW
begin
select review_insert.nextval into:new.reviewid from dual;
end;
/prompt
prompt Creating trigger USER_TRRIGER
prompt =============================
prompt
CREATE OR REPLACE TRIGGER "USER_TRRIGER" BEFORE
INSERT ON "USERS" REFERENCING OLD AS old NEW AS new FOR EACH ROW
begin
select users_insert.nextval into:new.user_id from dual;
end;
/
spool off
(
FAVORITE_ID int primary key,
USERNAME VARCHAR(16),
LOG_ID int
)
如果dml很少,大部分时间用于查询,最好用myisam,如果有事务需要的话,最好指定innodB