创建数据库脚本

create table `proxy` (
`ip` varchar(255) not null default '',
`port` varchar(255) not null default '',
primary key (`ip`,`port`)
) engine=innodb auto_increment=100000 default charset=utf8;

 

create table mydomaintable as
select rownum as id,
to_char(sysdate + rownum/24/3600, 'yyyy-mm-dd hh24:mi:ss') as inc_datetime,
trunc(dbms_random.value(0, 100)) as random_id,
dbms_random.string('x', 20) random_string
from dual
connect by level <= 100000;

create table user(
domid int(10) primary key not null auto_increment,
domain varchar(50) not null,
endLettre varchar(50) not null,
status int(10) not null);