Since i downloaded this program...I haven't been able to get it to Install...Any help would be greatly appreciated
DROP TABLE IF EXISTS nsmm_af;
CREATE TABLE nsmm_af (
lvl1 char(3) default NULL,
lvl2 char(3) default NULL,
lvl3 char(3) default NULL,
unit_status varchar(64) default NULL,
unit_type varchar(64) default NULL
) TYPE=MyISAM;
DROP TABLE IF EXISTS nsmm_army;
CREATE TABLE nsmm_army (
lvl1 char(3) default NULL,
lvl2 char(3) default NULL,
lvl3 char(3) default NULL,
unit_status varchar(64) default NULL,
unit_type varchar(64) default NULL
) TYPE=MyISAM;
DROP TABLE IF EXISTS nsmm_marines;
CREATE TABLE nsmm_marines (
lvl1 char(3) default NULL,
lvl2 char(3) default NULL,
lvl3 char(3) default NULL,
unit_status varchar(64) default NULL,
unit_type varchar(64) default NULL
) TYPE=MyISAM;
DROP TABLE IF EXISTS nsmm_navy;
CREATE TABLE nsmm_navy (
lvl1 char(3) default NULL,
lvl2 char(3) default NULL,
lvl3 char(3) default NULL,
unit_status varchar(64) default NULL,
unit_type varchar(64) default NULL
) TYPE=MyISAM;
DROP TABLE IF EXISTS nsmm_storefront_catergories;
CREATE TABLE nsmm_storefront_catergories (
cat_name varchar(64) default NULL,
cat_id int(2) NOT NULL auto_increment,
UNIQUE KEY cat_id (cat_id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS nsmm_storefront_items;
CREATE TABLE nsmm_storefront_items (
item_id int(6) NOT NULL auto_increment,
item_name varchar(64) default NULL,
item_desc text,
item_image varchar(64) default NULL,
item_price varchar(64) default NULL,
item_catergory char(2) default NULL,
KEY item_id (item_id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS nsmm_users;
CREATE TABLE nsmm_users (
username varchar(64) default NULL,
password varchar(64) default NULL,
last_login varchar(64) default NULL
) TYPE=MyISAM