-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.1.50-community


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema accesslabelsrocky
--

CREATE DATABASE IF NOT EXISTS accesslabelsrocky;
USE accesslabelsrocky;

--
-- Definition of table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `User_Name` varchar(30) NOT NULL,
  `User_account` varchar(10) NOT NULL,
  `User_Password` varchar(15) NOT NULL,
  `FullName` varchar(30) DEFAULT NULL,
  `Description` varchar(50) DEFAULT NULL,
  `DefaultComp` varchar(25) DEFAULT NULL,
  `DefaultYear` varchar(25) DEFAULT NULL,
  `Access` tinyint(1) DEFAULT NULL,
  `Access_UserManager` tinyint(1) DEFAULT NULL,
  `User_Signature` blob,
  `FullAccess` tinyint(1) DEFAULT NULL,
  `User_IsGroup` tinyint(1) DEFAULT '0',
  `User_Group` varchar(10) DEFAULT NULL,
  `Utilities` tinyint(1) DEFAULT '0',
  `InvCreditLimit` tinyint(1) DEFAULT '0',
  `Discount` double DEFAULT NULL,
  `DiscountMsgWarning` tinyint(1) DEFAULT '0',
  `ModifyBelongsToGrp` tinyint(1) DEFAULT '0',
  `User_logedintoinventory` tinyint(1) DEFAULT '0',
  `User_logedintoaccounting` tinyint(1) DEFAULT '0',
  `User_logedintopayroll` tinyint(1) DEFAULT '0',
  `FA_clientpaymentterms` tinyint(1) DEFAULT NULL,
  `User_groupacc` tinyint(1) DEFAULT NULL,
  `user_email` varchar(100) DEFAULT NULL,
  `user_query` tinyint(1) DEFAULT '0',
  `BRANCH_CODE` varchar(20) DEFAULT NULL,
  `employee_id` varchar(12) DEFAULT NULL,
  `user_admin` tinyint(1) DEFAULT '0',
  `deliverystatus_level` double DEFAULT NULL,
  `user_expirydate` date DEFAULT NULL,
  `user_deactivate` tinyint(1) DEFAULT NULL,
  `user_deactivate_date` date DEFAULT NULL,
  `user_complex_password` tinyint(1) DEFAULT NULL,
  `user_expiry` tinyint(1) DEFAULT NULL,
  `user_first_login` tinyint(1) DEFAULT NULL,
  `user_engineer` tinyint(1) DEFAULT NULL,
  `user_engineerqc` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`User_account`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`User_Name`,`User_account`,`User_Password`,`FullName`,`Description`,`DefaultComp`,`DefaultYear`,`Access`,`Access_UserManager`,`User_Signature`,`FullAccess`,`User_IsGroup`,`User_Group`,`Utilities`,`InvCreditLimit`,`Discount`,`DiscountMsgWarning`,`ModifyBelongsToGrp`,`User_logedintoinventory`,`User_logedintoaccounting`,`User_logedintopayroll`,`FA_clientpaymentterms`,`User_groupacc`,`user_email`,`user_query`,`BRANCH_CODE`,`employee_id`,`user_admin`,`deliverystatus_level`,`user_expirydate`,`user_deactivate`,`user_deactivate_date`,`user_complex_password`,`user_expiry`,`user_first_login`,`user_engineer`,`user_engineerqc`) VALUES 
 ('Administrator','001','Il','F','','DATUM','ACC2023',1,1,NULL,1,0,' ',1,1,NULL,1,1,0,1,0,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 ('Hazim','01','lZch','Ibrahim Hazim','CEO','DATUM','ACC2024',1,1,NULL,1,0,' ',1,0,NULL,0,0,0,0,0,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 ('Daher','02','SSZc','F','','DATUM','ACC2023',1,1,NULL,1,0,' ',1,1,NULL,1,1,0,1,0,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 ('Ayman','03','SihIl','F','','DATUM','ACC2023',1,1,NULL,1,0,' ',1,1,NULL,1,1,0,0,0,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 ('Hirodos','05','IU','Hirodos Moussa','','DATUM','ACC2023',1,1,NULL,1,0,' ',1,1,NULL,1,1,0,1,0,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 ('Destiny','06','Ie','Destiny','','DATUM','ACC2023',1,1,NULL,1,0,' ',1,1,NULL,1,1,0,1,0,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 ('Najjar','07','Ic','Ibrahim Najjar','','DATUM','ACC2023',1,1,NULL,1,0,' ',1,1,NULL,1,1,0,1,0,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 ('Mercy','08','A3@8','F','','DATUM','ACC2024',0,0,NULL,NULL,0,' ',1,0,NULL,0,0,0,1,0,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 ('Rashidat','11','B6+?%8','F',NULL,'DATUM','ACC2023',0,0,NULL,1,0,NULL,1,0,NULL,0,0,0,0,0,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 ('Paul','15','SihIl','F','','DATUM','ACC2023',0,0,NULL,NULL,0,' ',1,0,NULL,0,0,0,1,0,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 ('Blessing','16','SihIl','F','','DATUM','ACC2023',0,0,NULL,1,0,' ',1,0,NULL,0,0,0,1,0,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 ('FC ACT','20','liIhlZ','F','','DATUM','ACC2023',1,1,NULL,1,0,' ',1,1,NULL,1,1,0,1,0,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
 ('stock','60','eI','','','DATUM','ACC2023',NULL,NULL,NULL,NULL,0,' ',0,0,NULL,0,0,0,0,0,NULL,NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;