Vote count:
0
/* SQLyog Community Edition- MySQL GUI v7.01 MySQL - 5.1.44-community : Database - webdatalekageall
*/
/*!40101 SET NAMES utf8 */;
/!40101 SET SQL_MODE=''/;
/*!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 DATABASE /!32312 IF NOT EXISTS/webdatalekageall /*!40100 DEFAULT CHARACTER SET latin1 */;
USE webdatalekageall;
/*Table structure for table distributerkeytable */
DROP TABLE IF EXISTS distributerkeytable;
CREATE TABLE distributerkeytable ( ID int(11) NOT NULL, EncryptionFixedKey varchar(255) DEFAULT NULL, DistributerID int(11) DEFAULT NULL, PRIMARY KEY (ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table distributerkeytable */
insert into distributerkeytable(ID,EncryptionFixedKey,DistributerID) values (1,'Go/hm13HjRNUhm9NkQS/KQ==',1),(2,'OciJzx+FFGdUhm9NkQS/KQ==',3);
/*Table structure for table filedetails */
DROP TABLE IF EXISTS filedetails;
CREATE TABLE filedetails ( ID int(11) NOT NULL, FileName varchar(200) DEFAULT NULL, FileLocation varchar(250) DEFAULT NULL, uploadFileName varchar(200) DEFAULT NULL, AccessAgentId varchar(255) DEFAULT NULL, uploadDate datetime DEFAULT NULL, DistributerID int(11) DEFAULT NULL, PRIMARY KEY (ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table filedetails */
insert into filedetails(ID,FileName,FileLocation,uploadFileName,AccessAgentId,uploadDate,DistributerID) values (1,'Image of Arrow','C:\MUJEEB ECLIPSE\UploadTest1','1_arrow.gif','2,4,','2013-11-14 14:32:51',1),(2,'Vehicle Detection','C:\MUJEEB ECLIPSE\UploadTest1','2_Vehicle Detection.mp4','2,','2013-11-15 17:16:39',1);
/*Table structure for table patientaccesstable */
DROP TABLE IF EXISTS patientaccesstable;
CREATE TABLE patientaccesstable ( ID int(11) NOT NULL, AgentAccessId varchar(250) DEFAULT NULL, DistributerId int(11) DEFAULT NULL, PRIMARY KEY (ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table patientaccesstable */
insert into patientaccesstable(ID,AgentAccessId,DistributerId) values (1,'2,',1),(2,',',3);
/*Table structure for table patientrequestaccess */
DROP TABLE IF EXISTS patientrequestaccess;
CREATE TABLE patientrequestaccess ( ID int(11) DEFAULT NULL, UserName varchar(250) DEFAULT NULL, DistributerId int(11) DEFAULT NULL, Status varchar(20) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table patientrequestaccess */
insert into patientrequestaccess(ID,UserName,DistributerId,Status) values (1,'Testing System (test)',1,'hide'),(2,'Test1 (test1)',1,'hide'),(3,'Test1 (test1)',1,'hide');
/*Table structure for table patienttable */
DROP TABLE IF EXISTS patienttable;
CREATE TABLE patienttable ( id int(10) NOT NULL, patientname varchar(100) NOT NULL, patientdisease varchar(100) NOT NULL, patientmedicine varchar(100) NOT NULL, patientage int(11) NOT NULL, location varchar(100) NOT NULL, status int(10) unsigned NOT NULL DEFAULT '0', distributerId int(11) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table patienttable */
insert into patienttable(id,patientname,patientdisease,patientmedicine,patientage,location,status,distributerId) values (1,'Deepali Soni','Fibrosis','Tegretol',15,'Mumbai',0,1),(2,'Mona Rout','Fluorosis','Tegretol-XR',31,'Pune',0,1),(3,'Fluorosis','Fluorosis','Tegretol-XR',23,'Mumbai',0,1),(4,'Smita Biwas','Food Poisioning','Teva Clozpine',45,'Dhule',0,1),(5,'Keelos Mane','Genital Herpes','Thorazine',16,'Mumbai',0,1),(6,'Amol Kadam','Genital warts','Topamax',41,'Pune',0,1),(7,'Hari Janjire','Gout','Tranxene',51,'Dhule',0,1),(8,'Amol Kule','Intveing','Sarafem',54,'Dhule',0,1),(9,'Mohanish Pawar','Iophobia','Serentil',28,'Mumbai',1,1),(10,'Amit Parekh','Lead Posioning','Seroquel',37,'Pune',0,1),(11,'Kishore Ohot','Leglonellosis','Stelazine',58,'Dhule',0,1),(12,'Ajit Yadav','Maleria','Faze-100',23,'Dhule',0,1),(13,'Sandip Gavade','Fibrosis','Tegretol',36,'Mumbai',0,1),(14,'Akshay Ladage','Gout','Tranxene',42,'Mumbai',0,1),(15,'Vrishali Nawale','Thyroid','Axona',56,'Pune',0,1),(16,'Abika Chavan','Intoeing','Sarafem',33,'Dhule',0,1),(17,'Viswaka Patil','Cancer','Facalin XR',26,'Mumbai',0,1),(18,'Vinay Siglo','Ear Infection','Lamictal',60,'Pune',0,1),(19,'Vijay Mandave','Food Poisioning','Teva Clozapine',30,'Dhule',0,1),(20,'Swati Jadhav','Goitre','Namenda',20,'Mumbai',0,1),(21,'Suraj Patil','Hepatitis A','Luvox CR',40,'Pune',0,1),(22,'Keeshav Jadhav','Ablepsy','Mellitus',20,'Dhule',0,1),(23,'Ramdas Rajane','Syphillis','Hypergly',38,'Mumbai',0,1),(24,'Rajesh Bargude','Dengue Fever','Glucosuria',56,'Pune',0,1),(25,'Deepak Vallam','Cramp Colic','Faze-150',41,'Dhule',0,1),(26,'Rohit Gayakwad','Debility','Topamax',16,'Dhule',0,1),(27,'Sumit Shah','Epitaxis','Serentil',29,'Pune',0,1),(28,'Joy Saina','Hemiplegy','Stelazine',33,'Mumbai',0,1),(29,'Yash Kulkarni','Horrors','Facalin',25,'Pune',0,1),(30,'Mangesh Jadhav','Mania','Luvox CR',45,'Pune',0,1),(31,'Nilam More','Starigery','Sarafem',49,'Dhule',0,1),(32,'Swati Shukla','Cancer','Axona',21,'Dhule',0,1),(33,'Manoj Tiwari','Cancer','Axona',33,'Thane',0,1);
/*Table structure for table requestkeytable */
DROP TABLE IF EXISTS requestkeytable;
CREATE TABLE requestkeytable ( ID int(11) NOT NULL, UserName varchar(200) DEFAULT NULL, FileID int(11) DEFAULT NULL, FileName varchar(80) DEFAULT NULL, DistributerID int(11) DEFAULT NULL, Status varchar(20) DEFAULT NULL, PRIMARY KEY (ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table requestkeytable */
insert into requestkeytable(ID,UserName,FileID,FileName,DistributerID,Status) values (1,'Testing System (test)',2,'Vehicle Detection',1,'hide'),(2,'Testing System (test)',1,'Image of Arrow',1,'hide');
/*Table structure for table usertable */
DROP TABLE IF EXISTS usertable;
CREATE TABLE usertable ( ID int(11) NOT NULL, FullName varchar(50) DEFAULT NULL, Address varchar(200) DEFAULT NULL, Role varchar(20) DEFAULT NULL, Gender varchar(20) DEFAULT NULL, Age int(11) DEFAULT NULL, email varchar(100) DEFAULT NULL, mobile varchar(20) DEFAULT NULL, username varchar(150) DEFAULT NULL, password varchar(150) DEFAULT NULL, PRIMARY KEY (ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table usertable */
insert into usertable(ID,FullName,Address,Role,Gender,Age,email,mobile,username,password) values (1,'Siddique Mujeeburrehman','Hajuri Dargah, Wagle Estate, Thane(W).','distributer','Male',22,'mujeeb6384@gmail.com','9029811329','DLkUrbHKpzo=','nyx9o3qWOO5Uhm9NkQS/KQ=='),(2,'Testing System','test','agent','Male',32,'inbotics.projects@gmail.com','1234567890','MeCjL4d40bk=','MeCjL4d40bk='),(3,'Habib','Thane','distributer','Male',20,'habib@gmail.com','8689988767','laR6l+zy8rg=','laR6l+zy8rg='),(4,'Test1','Test1','agent','Male',34,'test1@test.com','1234567890','BKkLLqmmGZw=','BKkLLqmmGZw='),(5,'Test2','Test2','agent','Male',45,'test2@gmail.com','0987654321','cy41msVbRSg=','cy41msVbRSg=');
/* Function structure for function getUserId */
/*!50003 DROP FUNCTION IF EXISTS getUserId */; DELIMITER $$
/*!50003 CREATE DEFINER=root@localhost FUNCTION getUserId(i_username VARCHAR(200)) RETURNS int(11) BEGIN DECLARE myid INT;
SET myid = (SELECT ID FROM usertable WHERE username = i_username);
return myid;
END */$$
DELIMITER ;
/* Function structure for function validateLogin */
/*!50003 DROP FUNCTION IF EXISTS validateLogin */; DELIMITER $$
/*!50003 CREATE DEFINER=root@localhost FUNCTION validateLogin(iUsername VARCHAR(200), iPassword VARCHAR(200)) RETURNS tinyint(1) BEGIN DECLARE isExist BOOL; SET isExist = 0; SELECT EXISTS(SELECT * FROM usertable WHERE username = iUsername AND password = iPassword) INTO isExist; return isExist;
END */$$
DELIMITER ;
/* Function structure for function validateUsername */
/*!50003 DROP FUNCTION IF EXISTS validateUsername */; DELIMITER $$
/*!50003 CREATE DEFINER=root@localhost FUNCTION validateUsername(iUsername VARCHAR(200)) RETURNS tinyint(1) BEGIN DECLARE isExist BOOL; SET isExist = 0; SELECT EXISTS(SELECT * FROM usertable WHERE username = iUsername) INTO isExist; return isExist; END */$$ DELIMITER ;
/* Function structure for function verifyKey */
/*!50003 DROP FUNCTION IF EXISTS verifyKey */; DELIMITER $$
/*!50003 CREATE DEFINER=root@localhost FUNCTION verifyKey(ekey VARCHAR(200)) RETURNS tinyint(1) BEGIN DECLARE isExist BOOL; SET isExist = 0; SELECT EXISTS(SELECT * FROM distributerkeytable WHERE EncryptionFixedKey = ekey) INTO isExist; return isExist; END */$$ DELIMITER ;
/* Procedure structure for procedure AddPatient */
/*!50003 DROP PROCEDURE IF EXISTS AddPatient */;
DELIMITER $$
/*!50003 CREATE DEFINER=root@localhost PROCEDURE AddPatient(IN in_id INT, IN in_name VARCHAR(100), IN in_disease VARCHAR(100), IN in_medicine VARCHAR(100), IN in_age INT, IN in_location VARCHAR(100), IN in_distributerid INT) BEGIN INSERT INTO Patienttable VALUES(in_id, in_name, in_disease, in_medicine, in_age, in_location, 0 , in_distributerid); END */$$ DELIMITER ;
/* Procedure structure for procedure DeletePatient */
/*!50003 DROP PROCEDURE IF EXISTS DeletePatient */;
DELIMITER $$
/*!50003 CREATE DEFINER=root@localhost PROCEDURE DeletePatient(IN in_id INT) BEGIN DELETE FROM PatientTable WHERE id = in_id; END */$$ DELIMITER ;
/* Procedure structure for procedure getDistributerFile */
/*!50003 DROP PROCEDURE IF EXISTS getDistributerFile */;
DELIMITER $$
/*!50003 CREATE DEFINER=root@localhost PROCEDURE getDistributerFile(IN in_distributerid INT) BEGIN SELECT * FROM FileDetails WHERE DistributerID=in_distributerid; END */$$ DELIMITER ;
/* Procedure structure for procedure getDistributerPatientFile */
/*!50003 DROP PROCEDURE IF EXISTS getDistributerPatientFile */;
DELIMITER $$
/*!50003 CREATE DEFINER=root@localhost PROCEDURE getDistributerPatientFile(IN in_distributerid INT) BEGIN SELECT * FROM PatientTable WHERE DistributerID=in_distributerid; END */$$ DELIMITER ;
/* Procedure structure for procedure getUserDetailsByUsername */
/*!50003 DROP PROCEDURE IF EXISTS getUserDetailsByUsername */;
DELIMITER $$
/*!50003 CREATE DEFINER=root@localhost PROCEDURE getUserDetailsByUsername( IN p_username VARCHAR(150), OUT o_id INT, OUT o_fullname VARCHAR(50), OUT o_address VARCHAR(200), OUT o_role VARCHAR(20), OUT o_gender VARCHAR(10), OUT o_age INT, OUT o_email VARCHAR(100), OUT o_mobile VARCHAR(20), OUT o_password VARCHAR(150)) BEGIN SELECT ID, FullName, Address, Role, Gender, Age, email, mobile, password INTO o_id, o_fullname, o_address, o_role, o_gender, o_age, o_email, o_mobile, o_password FROM UserTable WHERE username = p_username; END */$$ DELIMITER ;
/* Procedure structure for procedure PatientAccess */
/*!50003 DROP PROCEDURE IF EXISTS PatientAccess */;
DELIMITER $$
/*!50003 CREATE DEFINER=root@localhost PROCEDURE PatientAccess(IN in_id INT, IN in_distributerid INT) BEGIN INSERT INTO PatientAccessTable VALUES(in_id, ',' , in_distributerid); END */$$ DELIMITER ;
/* Procedure structure for procedure provideKey */
/*!50003 DROP PROCEDURE IF EXISTS provideKey */;
DELIMITER $$
/*!50003 CREATE DEFINER=root@localhost PROCEDURE provideKey(IN in_id INT, IN in_key VARCHAR(50), IN in_distributerId INT) BEGIN INSERT INTO DistributerKeyTable VALUES(in_id, in_key, in_distributerId); END */$$ DELIMITER ;
/* Procedure structure for procedure registration */
/*!50003 DROP PROCEDURE IF EXISTS registration */;
DELIMITER $$
/*!50003 CREATE DEFINER=root@localhost PROCEDURE registration(IN in_id INT, IN in_fullname VARCHAR(50),IN in_address VARCHAR(200), IN in_role VARCHAR(30), IN in_gender VARCHAR(20), IN in_age INT, IN in_email VARCHAR(150), IN in_mobile VARCHAR(20), IN in_username VARCHAR(200), IN in_password VARCHAR(200)) BEGIN INSERT INTO UserTable VALUES(in_id, in_fullname, in_address, in_role, in_gender, in_age, in_email, in_mobile, in_username, in_password); END */$$ DELIMITER ;
/* Procedure structure for procedure UpdatePatient */
/*!50003 DROP PROCEDURE IF EXISTS UpdatePatient */;
DELIMITER $$
/*!50003 CREATE DEFINER=root@localhost PROCEDURE UpdatePatient(IN in_id INT, IN in_name VARCHAR(100), IN in_disease VARCHAR(100), IN in_medicine VARCHAR(100), IN in_age INT, IN in_location VARCHAR(100), IN in_status INT) BEGIN UPDATE PatientTable SET patientname = in_name, patientdisease = in_disease, patientmedicine = in_medicine , patientage = in_age, location = in_location, status = in_status WHERE id = in_id; END */$$ DELIMITER ;
/* Procedure structure for procedure updateUser */
/*!50003 DROP PROCEDURE IF EXISTS updateUser */;
DELIMITER $$
/*!50003 CREATE DEFINER=root@localhost PROCEDURE updateUser(IN in_id INT ,IN in_fullname VARCHAR(50),IN in_address VARCHAR(200), IN in_gender VARCHAR(20), IN in_age INT, IN in_email VARCHAR(150), IN in_mobile VARCHAR(20), IN in_username VARCHAR(200), IN in_password VARCHAR(200)) BEGIN UPDATE UserTable SET FullName=in_fullname, Address=in_address, Gender=in_gender, Age=in_age, email=in_email, mobile=in_mobile, username=in_username, password=in_password WHERE ID=in_id; END */$$ DELIMITER ;
/* Procedure structure for procedure uploadFileDetails */
/*!50003 DROP PROCEDURE IF EXISTS uploadFileDetails */;
DELIMITER $$
/*!50003 CREATE DEFINER=root@localhost PROCEDURE uploadFileDetails(IN in_id INT, IN in_filename VARCHAR(200), IN in_filelocation VARCHAR(250), IN in_uploadfilename VARCHAR(200), IN in_uploaddate DATETIME, IN in_distributerid INT) BEGIN INSERT INTO FileDetails VALUES(in_id, in_filename, in_filelocation, in_uploadfilename, ',', in_uploaddate, in_distributerid); END */$$ DELIMITER ;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE /; /!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
Error Code : 1307 while importing database in mysql-essential-5.0.27-win32
Aucun commentaire:
Enregistrer un commentaire