建立資料庫腳本

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);

未來星開發團隊--狒狒

QQ：9715234