CREATE TABLE schools (school_id int(10) NOT NULL auto_increment,school_name varchar(200) NOT NULL default '',school_email varchar(200) NOT NULL default '',school_phone varchar(200) NOT NULL default '',school_country varchar(200) NOT NULL default '',school_description text NOT NULL,PRIMARY KEY (school_id))