SQL-EN.zip_english

-- -------------------------------------------------------- -- Host: db41.grserver.gr -- Server version: 10.0.22-MariaDB - MariaDB Server -- Server OS: Linux -- HeidiSQL Version: 9.3.0.4995 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8mb4 */; /*!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' */; -- Dumping structure for table hr. SQL CREATE TABLE IF NOT EXISTS ` SQL ` ( 'SQLNTD' int (11) NOT NULL AUTO_INCREMENT, 'SQLNUM' int (11) NOT NULL DEFAULT '0', 'SQLMOD' varchar (16) DEFAULT NULL , 'SQLSEN' longtext, 'SQLREM' varchar (32) DEFAULT NULL , PRIMARY KEY ('SQLNTD'), UNIQUE KEY 'SQLNTD' ('SQLNTD'), KEY 'SQLNUM' ('SQLNUM') )ENGINE = InnoDB AUTO_INCREMENT = 158 DEFAULT CHARSET=utf8; -- Dumping data for table hr. SQL: ~157 rows (approximately) DELETE FROM `SQL `; /*!40000 ALTER TABLE 'SQL' DISABLE KEYS */; INSERT INTO `SQL` ('SQLNTD', 'SQLNUM' , 'SQLMOD', 'SQLSEN', 'SQLREM') VALUES (1 , 1, 'DEPT', 'SELECT * FROM DEPT ORDER BY DEPTID', ' Get data'), (2 , 2, 'DEPT', 'SELECT MAX(DEPTID)+1 AS NUM FROM DEPT WHERE Len(DeptID)=%S AND DEPTID LIKE \'%S\'', ' for the sector number'), (3 , 3, 'DEPT', 'SELECT * FROM DEPT WHERE DEPNAM=\'% S\'', ' is used to determine whether the Department name'), (4 , 4, 'DEPT', 'INSERT INTO DEPT(DEPNAM,DEPTID) VALUES (\' % S\ ',\' % S\ ')', ' Add new departments'), (5 , 5, 'DEPT', 'UPDATE DEPT SET DEPNAM=\'% S\' WHERE DEPTID=\'%S\'', ' Modify the Department name'), (6 , 6, 'DEPT', 'SELECT * FROM EMPLOYEE WHERE EMPDEP=\'% S\' AND EMPSTA IN (\'0\',\'1\')', ' Used to determine whether the staffing table in use in the sector'), (7 , 7, 'DEPT', 'DELETE * FROM DEPT WHERE DEPTID=\'% S\'', ' delete departments'), (8 , 8, 'BASE', 'SELECT DISTINCT BASMOD,BASCHS,BASCHT,BASENG FROM BASE WHERE BASTYP=\'1\'', ' get BASE in three languages ITEM Information'), (9 , 9, 'BASE', 'SELECT TABLE,KEY,DATA FROM [TABLE] WHERE [TABLE]=:BASMOD' , 'BASE and TABLE relationship'), (10 , 10, 'EMPL', 'SELECT * FROM [BASE] ORDER BY BASMOD,BASEID' , NULL ), (11 , 11, 'EMPL', 'SELECT * FROM [TABLE] ORDER BY [TABLE],[KEY]' , NULL ), (12 , 12, 'EMPL', 'SELECT* FROM EMPLOYEE,DEPT WHERE EMPDEP=DEPTID AND (( EMPENT<%F+2 AND EMPLEA IS NULL) OR (EMPLEA>=%F+2) AND (EMPENT<%F+2)) %S ORDER BY EMPLID', NULL ), (13 , 13, 'CLAS', 'SELECT* FROM CLASS ORDER BY CLASID', NULL ), (14 , 14, 'BASE', 'SELECT * FROM BASE WHERE BASMOD=\'% S\' ORDER BY BASEID', NULL ), (15 , 15, 'EMPL', 'SELECT MAX(EMPLID) AS EMPLID FROM EMPLOYEE WHERE EMPDEP=\' %S\'AND ((EMPENT<%F+2 AND EMPLEA IS NULL) OR (EMPLEA>=%F+2) AND (EMPENT<%F+2))', ' Gets the biggest number'), (16 , 16, 'EMPL', 'SELECT EMPLID,EMPCAR,EMPNAM FROM EMPLOYEE WHERE EMPNTD <>%S AND EMPLID=\'%S\'AND ((EMPENT<%F+2 AND EMPLEA IS NULL) OR (EMPLEA>=%F+2) AND (EMPENT<%F+2))' , ' When you modify the work number to determine whether repeat'), (17 , 17, 'EMPL', 'SELECT EMPLID,EMPCAR,EMPNAM FROM EMPLOYEE WHERE EMPLID=\ '%S\'AND ((EMPENT<%F+2 AND EMPLEA IS NULL) OR (EMPLEA>=%F+2) AND (EMPENT<%F+2))', ' Add new workers, to determine whether repeat'), (18 , 18, 'EMPL', 'SELECT EMPLID,EMPCAR,EMPNAM FROM EMPLOYEE WHERE EMPNTD <>%S AND EMPCAR=\'%S\'AND (EMPENT<%F+2 AND EMPLEA IS NULL)', ' Modify the numbers to determine whether repeat'), (19 , 19, 'EMPL', 'SELECT EMPLID,EMPCAR,EMPNAM FROM EMPLOYEE WHERE EMPCAR=\ '%S\'AND (EMPENT<%F+2 AND EMPLEA IS NULL) ', ' added the number to determine whether repeat '), (20 , 20, 'EMPL', 'SELECT SUM(Onduty) as Onduty,sum(Adduty) as Adduty,sum( Offduty) as Offduty From (\r\nSELECT COUNT(*) AS Onduty,\'0\'AS Adduty,\'0\'AS Offduty FROM EMPLOYEE WHERE MID(EMPHIS,%S,1)=\'0\'\r\nUNION\r\nSELECT \'0\' AS Onduty,COUNT(*)AS Adduty,\' 0 \ 'AS Offduty FROM EMPLOYEE WHERE Month(EMPENT)=%S\r\nUNION\r\nSELECT \' 0 \ ' AS Onduty,\' 0 \ 'AS Adduty,COUNT(*)AS Offduty FROM EMPLOYEE WHERE MID(EMPHIS,%S,1)=\' 1 \ ') A', NULL ), (21 , 21, 'EXCEL', 'SELECT %S', ' Gets the ExcelTable data'), (22 , 22, 'EXCEL', 'SELECT FIENUM,FIENAM,FIECHS,FIECHT,FIELEN,FIESTA, FIEFOR FROM ExcelTable,ExcelFields Where TABNTD=FIEEXC AND TABNAM=\'%S\' ORDER BY FIENUM', ' Gets the import table data structure'), (23 , 23, 'ONET', 'SELECT ONENTD,ONEEMP,ONEDAT,ONETIM,EMPCAR,EMPNAM, DEPNAM,ONESTA,ONEMEM FROM ONETIM,EMPLOYEE,DEPT WHERE ONEEMP=EMPLID AND EMPDEP=DEPTID AND ONESTA=\'1\' AND ((EMPENT<%F+2 AND EMPLEA IS NULL) OR (EMPLEA>=%F+2) AND (EMPENT<%F+2))%S', ' get the current card replacement during the attendance data'), (24 , 24, 'ONET', 'SELECT (MAX(MEMNTD)+1) AS MEMNTD FROM [MEMO]' , ' Gets the MEMO 's largest MEMNTD and 1'), (25 , 25, 'ONET', 'INSERT INTO [MEMO] VALUES (%S,\'% S\',\'%S\',\'%S\')' , ' first written note form'), (26 , 26, 'ONET', 'INSERT INTO ONETIM(ONEEMP,ONEDAT,ONETIM,ONESTA,ONEMEM ) VALUES (\'%S\',\'%S\',\'%S\ ',\'%S\',%S) ', ' artificial card write'), (27 , 27, 'ONET', 'SELECT ONEEMP,ONEDAT,ONETIM,ONESTA,ONEDEV FROM ONETIM WHERE 1=2', ' to get an empty data'), (28 , 28, 'SHIF', 'SELECT A.*,EMPNAM,DEPNAM FROM SHIFT A,EMPLOYEE,DEPT WHERE SHIEMP=EMPLID AND EMPDEP=DEPTID AND ((EMPENT<%F+2 AND EMPLEA IS NULL) OR (EMPLEA>=%F+2) AND (EMPENT<%F+2)) %S', ' Gets the scheduling data'), (29 , 29, 'CLAS', 'SELECT * FROM [CLASS] ORDER BY CLASID', ' Get frequency data in the main form'), (30 , 30, 'SHIF', 'SELECT * FROM SHIFT WHERE 1=2', ' Gets the specified month schedule data'), (31 , 31, 'SHIF', 'SELECT * FROM SHIFT WHERE SHIEMP=\'% S\' AND SHIMON=\'%S\'', ' Determine if the Member is the current record for attendance during the'), (32 , 32, 'SHIF', 'INSERT INTO SHIFT(SHIEMP,SHIMON,SHID01,SHID02,SHID03, SHID04,SHID05,SHID06,SHID07,SHID08,SHID09,SHID10,SHID11,SHID12,SHID13,SHID14,SHID15,SHID16,SHID17,SHID18,SHID19,SHID20,SHID21,SHID22,SHID23,SHID24,SHID25,SHID26, SHID27,SHID28,SHID29,SHID30,SHID31) VALUES (\'%S\',\'%S\',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ',\' % S\ ')', ' New schedule record'), (33 , 33, 'SHIF', 'UPDATE [SHIFT] SET %S WHERE SHIEMP=\'% S\' AND SHIMON=\'%S\'', ' Modify the schedule record'), (34 , 34, 'LEAV', 'SELECT * FROM LEAVE WHERE 1=2', NULL ), (35 , 35, 'LEAV', 'SELECT LEANTD,LEAEMP,LEABEG,LEAEND,LEATYP,BASCHS, EMPNAM,DEPNAM,LEASTA,LEAMEM FROM LEAVE,EMPLOYEE,DEPT,[BASE] WHERE LEAEMP=EMPLID AND EMPDEP=DEPTID AND BASMOD=\'LEAV\' AND LEATYP=BASEID AND ((EMPENT<% F+2 AND EMPLEA IS NULL) OR (EMPLEA>=%F+2) AND (EMPENT<%F+2)) %S', NULL ), (36 , 36, 'LEAV', 'SELECT * FROM BASE WHERE BASMOD=\'% S\'', ' get information leave category'), (37 , 37, 'RULL', 'SELECT * FROM RULE ORDER BY RULEID', ' Get the attendance rules'), (38 , 38, 'CLAS', 'SELECT * FROM [CLASS] ORDER BY CLASID', ' Get frequency data'), (39 , 39, 'SECT', 'SELECT * FROM [SECTION] WHERE SECCLA=:CLASID' , ' Get data'), (40 , 40, 'HOLI', 'SELECT * FROM HOLIDAY ORDER BY HOLDAT', ' Gets the holiday information'), (41 , 41, 'SHIF', 'SELECT * FROM SHIFT WHERE SHIMON=\'% S\'', ' gets during the attendance roster data'), (42 , 42, 'EMPL', 'SELECT EMPLID,EMPENT,EMPLEA,EMPCLA,EMPRES,RULPSJ, RULREP,RULYCJ,RULLA1,RULLV1,RULLA2,RULLV2,RULLA3,RULLV3,RULLA4,RULLV4,RULLV5,RULPRA,RULRRA,RULHRA,RULYRA,RULLRA,RULKRA,RULREA,RULRVA,RULRE2,RULPJC,RULPJV,RULCZC, RULREC FROM EMPLOYEE,RULE,DEPT WHERE EMPATT=RULEID AND EMPDEP=DEPTID AND ((EMPENT<%F+2 AN