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