CREATE TABLE auth (
   id bigint(20) NOT NULL auto_increment,
   username varchar(100) NOT NULL,
   password varchar(100) NOT NULL,
   PRIMARY KEY (id)
);


CREATE TABLE members (
   id bigint(20) unsigned NOT NULL auto_increment,
   username varchar(100) NOT NULL,
   password varchar(100) NOT NULL,
   email varchar(100) NOT NULL,
   name varchar(50) NOT NULL,
   surname varchar(50) NOT NULL,
   address text NOT NULL,
   zipcode varchar(5) NOT NULL,
   NODECODE varchar(10) DEFAULT '0' NOT NULL,
   IP varchar(15) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   UNIQUE id_2 (username)
);