请问怎样用SQL创建这个表和索引？

Question

create table t2
(id number(10),
accounts varchar2(50),
password varchar2(50),
port varchar2(20),
company varchar2(20),
short_name varchar2(20),
address varchar2(100),
linkman varchar2(20),  
fax varchar2(20),  
email varchar2(50),
code char(6), 
trade varchar2(50),
re long,
state varchar2(1),
time_from date,
time_to date,
phone varchar2(20),
constraint pkt primary key(id),
constraint uk1 unique(accounts),
constraint uk2 unique(port),
constraint uk3 unique(company),
constraint uk4 unique(short_name)
);