CREATE TABLE register(
	id int(11) not null PRIMARY KEY AUTO_INCREMENT,
    name varchar(255) not null,
     gender varchar(255) not null,
     country varchar(255) not null,
     addr varchar(255) not null,
     phone varchar(255) not null,
     email varchar(255) not null,
     pwd varchar(255) not null,
     btc varchar(255) not null,
     pin varchar(255) not null,
     invest varchar(255) not null,
     profit varchar(255) not null,
     total varchar(255) not null,
    acct varchar(255) not null,
    refb varchar(255) not null,

    verify varchar(255) not null,
   activate varchar(255) not null
    

);




CREATE TABLE verify(
	id int(11) not null PRIMARY KEY AUTO_INCREMENT,
    dtype varchar(255) not null,
     img varchar(255) not null,
email varchar(255) not null


);



CREATE TABLE admin(
	id int(11) not null PRIMARY KEY AUTO_INCREMENT,
    usd varchar(255) not null,
     pwd varchar(255) not null,
    adminbtc varchar(255) not null

);

INSERT INTO admin (usd,pwd) VALUES ('admin','admin');