CREATE TABLE mshopping_sel (
  flname varchar(100) NOT NULL default '',
  PRIMARY KEY  (flname)
);


CREATE TABLE mshopping_users (
  userid int(11) NOT NULL auto_increment,
  username varchar(60) NOT NULL default '',
  user_full_name varchar(200) default NULL,
  `password` varchar(100) NOT NULL default '',
  region varchar(255) NOT NULL default '99',
  branch varchar(255) NOT NULL default '99',
  `status` int(11) NOT NULL default '1',
  `TYPE` int(11) default NULL,
  email varchar(255) NOT NULL,
  PRIMARY KEY  (userid)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

#
# Dumping data for table `thym_users`
#

INSERT INTO mshopping_users (username,user_full_name,`password`,region,branch,`status`,`TYPE`,email)
                     VALUES ('super', 'Suppervisor', password('sadmin'), '0', '0',  1, 1, '');
INSERT INTO mshopping_users (username,user_full_name,`password`,region,branch,`status`,`TYPE`,email) 
										 VALUES ('admin', 'Administrator', password('admin'), '0', '0',  1, 1, '');
INSERT INTO mshopping_users (username,user_full_name,`password`,region,branch,`status`,`TYPE`,email) 
										 VALUES ('parc', 'Parc', password('parc'),'0', '0',  1, 99, '');