Hi Black Belt
this is the sql that came with it.
--
-- Table structure for table supplier_admin_groups
CREATE TABLE supplier_admin_groups (
supplier_admin_group_id int(10) unsigned NOT NULL auto_increment,
supplier_id int(10) unsigned NOT NULL,
supplier_admin_group_enabled tinyint(1) NOT NULL,
supplier_admin_group_name varchar(32) NOT NULL,
supplier_admin_group_issuperadmin tinyint(1) NOT NULL default '0',
PRIMARY KEY (supplier_admin_group_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table supplier_admin_tasks
CREATE TABLE supplier_admin_tasks (
supplier_admin_task_code varchar(32) NOT NULL,
supplier_admin_task_enabled tinyint(1) NOT NULL,
task_name varchar(32) NOT NULL,
task_description varchar(128) NOT NULL,
taskpage_url varchar(64) NOT NULL,
PRIMARY KEY (supplier_admin_task_code)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table supplier_admins
CREATE TABLE supplier_admins (
supplier_admin_id int(10) unsigned NOT NULL auto_increment,
supplier_admin_group_id int(10) unsigned NOT NULL,
supplier_admin_account_enabled tinyint(1) NOT NULL,
supplier_admin_name varchar(32) NOT NULL,
supplier_admin_email varchar(32) NOT NULL,
supplier_admin_password varchar(64) NOT NULL,
PRIMARY KEY (supplier_admin_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table supplier_admintask_admingroup_link
CREATE TABLE supplier_admintask_admingroup_link (
supplier_admin_task_code varchar(32) NOT NULL,
supplier_admin_group_id int(10) unsigned NOT NULL,
PRIMARY KEY (supplier_admin_task_code,supplier_admin_group_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table suppliers
CREATE TABLE suppliers (
supplier_id int(10) unsigned NOT NULL auto_increment,
supplier_enabled tinyint(1) NOT NULL,
supplier_name varchar(32) NOT NULL,
supplier_address varchar(64) NOT NULL,
supplier_email varchar(32) NOT NULL,
supplier_telno varchar(32) NOT NULL,
supplier_contact_person varchar(32) NOT NULL,
PRIMARY KEY (supplier_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Table structure for table suppliers_categories_link
CREATE TABLE suppliers_categories_link (
supplier_id int(10) NOT NULL,
categories_id int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE products ADD supplier_id INT NOT NULL ;