MySQL:<\/p>\n
create table user
\n(
\n user_id int NOT NULL AUTO_INCREMENT,
\n name varchar(100),
\n phone varchar(100),
\n email varchar(100),
\n password varchar(100),
\n role_id int,
\n primary key(user_id),
\n unique index email_idx(email),
\n index role_idx(role_id)
\n);<\/p>\n
Oracle:<\/p>\n
create table user2
\n(
\n user_id int NOT NULL,
\n name varchar2(100),
\n phone varchar2(100),
\n email varchar2(100),
\n password varchar2(100),
\n role_id int,
\n primary key(user_id),
\n unique (phone),
\n foreign key (role_id) references role(role_id)
\n);
\ncreate unique index cu on user2 (email);
\ncreate index role_idx on user2 (role_id);<\/p>\n
or
\n create table foo (a int primary key,
\n b varchar(20) unique);<\/p>\n","protected":false},"excerpt":{"rendered":"
MySQL: create table user ( user_id int NOT NULL AUTO_INCREMENT, name varchar(100), phone varchar(100), email varchar(100), password varchar(100), role_id int, primary key(user_id), unique index email_idx(email), index role_idx(role_id) ); Oracle: create table user2 ( user_id int NOT NULL, name varchar2(100), phone varchar2(100), email varchar2(100), password varchar2(100), role_id int, primary key(user_id), unique (phone), foreign key (role_id) references … <\/p>\n