CREATE TABLE riders
(
rider_id
int(11) NOT NULL,
rider_name
varchar(255) NOT NULL,
rider_tel
varchar(64) NOT NULL,
rider_email
varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE riders
ADD PRIMARY KEY (rider_id
),
ADD UNIQUE KEY rider_email
(rider_email
);
ALTER TABLE riders
MODIFY rider_id
int(11) NOT NULL AUTO_INCREMENT;
COMMIT;