tkt1449.test

sqlite-3.4.1,嵌入式数据库.是一个功能强大的开源数据库,给学习和研发以及小型公司的发展带来了全所未有的好处.

    			select p.USERID USERID, p.ISSUEID ISSUEID, iset.ISSUENAME ISSUENAME, iset.ISSUEDUEDATE DATE1
    				from PARTICIPANTS p
    				join PARTICIPANTSETTINGS ps on ps.PARTICIPANTID = p.OBJECTID
    				join ISSUESETTINGS iset on iset.ISSUEID = p.ISSUEID
    				where ps.MARKEDCRITICAL = 'y'
    				and iset.ISSUESTATUS = 1
    			) as CRITICALDATA
    			group by USERID, ISSUEID, ISSUENAME;
    CREATE VIEW CURRENTFILES as 
    
   
   		select
    			d.ISSUEID as ISSUEID,
    			d.REFERENCEDOCUMENTID as OBJECTID,
    			f.VISIBLENAME as VISIBLENAME
    			from
    				DOCREFERENCES d
    				join FILES f on f.OBJECTID = d.REFERENCEDOCUMENTID;
    CREATE VIEW ISSUEDATA as 
    
   
   		select
    			ISSUES.OBJECTID as ISSUEID,
    			ISSUES.CREATIONDATE as CREATIONDATE,
    			ISSUES.AUTHORID as AUTHORID,
    			ISSUES.LASTMODIFIEDDATE as LASTMODIFIEDDATE,
    			ISSUES.LASTMODIFIEDBYID as LASTMODIFIEDBYID,
    			ISSUESETTINGS.ISSUENAME as ISSUENAME,
    			ISSUES.ISINITIALIZED as ISINITIALIZED,
    			ISSUES.ISSYSTEMISSUE as ISSYSTEMISSUE,
    			ISSUES.ISSUETYPE as ISSUETYPE,
    			ISSUES.ISINCOMPLETE as ISINCOMPLETE,
    			ISSUESETTINGS.REVISIONNUM as ISSUESETTINGS_REVISIONNUM,
    			ISSUESETTINGS.LASTMODIFIEDDATE as ISSUESETTINGS_LASTMODIFIEDDATE,
    			ISSUESETTINGS.LASTMODIFIEDBYID as ISSUESETTINGS_LASTMODIFIEDBYID,
    			ISSUESETTINGS.ISSUEDUEDATE as ISSUEDUEDATE,
    			ISSUESETTINGS.ISSUEPRIORITY as ISSUEPRIORITY,
    			ISSUESETTINGS.ISSUESTATUS as ISSUESTATUS,
    			ISSUESETTINGS.DESCRIPTION as DESCRIPTION,
    			ISSUESETTINGS.PROJECTID as PROJECTID,
    			ISSUESETTINGS.PROJECTNAME as PROJECTNAME,
    			ISSUESETTINGS.PROJECTNAMEISCUSTOM as PROJECTNAMEISCUSTOM,
    			ENTERPRISEDATA.REVISIONNUM as ENTERPRISEDATA_REVISIONNUM,
    			ENTERPRISEDATA.CREATIONDATE as ENTERPRISEDATA_CREATIONDATE,
    			ENTERPRISEDATA.AUTHORID as ENTERPRISEDATA_AUTHORID,
    			ENTERPRISEDATA.LASTMODIFIEDDATE as ENTERPRISEDATA_LASTMODIFIEDDATE,
    			ENTERPRISEDATA.LASTMODIFIEDBYID as ENTERPRISEDATA_LASTMODIFIEDBYID,
    			ENTERPRISEDATA.DATE1 as DATE1,
    			ENTERPRISEDATA.DATE2 as DATE2,
    			ENTERPRISEDATA.DATE3 as DATE3,
    			ENTERPRISEDATA.DATE4 as DATE4,
    			ENTERPRISEDATA.DATE5 as DATE5,
    			ENTERPRISEDATA.DATE6 as DATE6,
    			ENTERPRISEDATA.DATE7 as DATE7,
    			ENTERPRISEDATA.DATE8 as DATE8,
    			ENTERPRISEDATA.DATE9 as DATE9,
    			ENTERPRISEDATA.DATE10 as DATE10,
    			ENTERPRISEDATA.VALUE1 as VALUE1,
    			ENTERPRISEDATA.VALUE2 as VALUE2,
    			ENTERPRISEDATA.VALUE3 as VALUE3,
    			ENTERPRISEDATA.VALUE4 as VALUE4,
    			ENTERPRISEDATA.VALUE5 as VALUE5,
    			ENTERPRISEDATA.VALUE6 as VALUE6,
    			ENTERPRISEDATA.VALUE7 as VALUE7,
    			ENTERPRISEDATA.VALUE8 as VALUE8,
    			ENTERPRISEDATA.VALUE9 as VALUE9,
    			ENTERPRISEDATA.VALUE10 as VALUE10,
    			ENTERPRISEDATA.VALUE11 as VALUE11,
    			ENTERPRISEDATA.VALUE12 as VALUE12,
    			ENTERPRISEDATA.VALUE13 as VALUE13,
    			ENTERPRISEDATA.VALUE14 as VALUE14,
    			ENTERPRISEDATA.VALUE15 as VALUE15,
    			ENTERPRISEDATA.VALUE16 as VALUE16,
    			ENTERPRISEDATA.VALUE17 as VALUE17,
    			ENTERPRISEDATA.VALUE18 as VALUE18,
    			ENTERPRISEDATA.VALUE19 as VALUE19,
    			ENTERPRISEDATA.VALUE20 as VALUE20,
    			ENTERPRISEDATA.STRING1 as STRING1,
    			ENTERPRISEDATA.STRING2 as STRING2,
    			ENTERPRISEDATA.STRING3 as STRING3,
    			ENTERPRISEDATA.STRING4 as STRING4,
    			ENTERPRISEDATA.STRING5 as STRING5,
    			ENTERPRISEDATA.STRING6 as STRING6,
    			ENTERPRISEDATA.STRING7 as STRING7,
    			ENTERPRISEDATA.STRING8 as STRING8,
    			ENTERPRISEDATA.STRING9 as STRING9,
    			ENTERPRISEDATA.STRING10 as STRING10,
    			ENTERPRISEDATA.LONGSTRING1 as LONGSTRING1,