1CREATE TABLE CORE (
2    coreid INTEGER PRIMARY KEY,
3    core text,
4    coredef text);
5
6CREATE INDEX coredef_index ON CORE(coredef);
7
8CREATE TABLE PLATFORM (
9    platformid INTEGER PRIMARY KEY,
10    platform text );
11
12CREATE INDEX platform_index ON PLATFORM(platform);
13
14CREATE TABLE COMPILERKIND (
15    compilerkindid INTEGER PRIMARY KEY,
16    compiler text);
17
18CREATE INDEX compilerkind_index ON COMPILERKIND(compiler);
19
20CREATE TABLE COMPILER (
21    compilerid INTEGER PRIMARY KEY,
22    compilerkindid INTEGER ,
23    version text,
24    testdateid INTEGER,
25    FOREIGN KEY(compilerkindid) REFERENCES COMPILERKIND(compilerkindid),
26    FOREIGN KEY(testdateid) REFERENCES TESTDATE(testdateid)
27    );
28
29CREATE INDEX compiler_index ON COMPILER(compilerkindid,version);
30CREATE INDEX compiler_date_index ON COMPILER(testdateid);
31CREATE INDEX compiler_all_index ON COMPILER(compilerkindid,version,testdateid);
32
33CREATE TABLE RUN (
34    runid INTEGER PRIMARY KEY,
35    date text
36    );
37
38CREATE TABLE TYPE (
39    typeid INTEGER PRIMARY KEY,
40    type text );
41
42CREATE INDEX type_index ON TYPE(type);
43
44CREATE TABLE CATEGORY (
45    categoryid INTEGER PRIMARY KEY,
46    category text);
47
48CREATE INDEX category_index ON CATEGORY(category);
49
50CREATE TABLE TESTNAME (
51    testnameid INTEGER PRIMARY KEY,
52    name text);
53
54CREATE INDEX testname_index ON TESTNAME(name);
55
56CREATE TABLE TESTDATE (
57    testdateid INTEGER PRIMARY KEY,
58    date text);
59
60CREATE INDEX testdate_index ON TESTDATE(date);
61
62CREATE TABLE CONFIG (
63    configid INTEGER PRIMARY KEY,
64    compilerid INTEGER,
65    platformid INTEGER,
66    coreid INTEGER,
67    testdateid INTEGER,
68    FOREIGN KEY(compilerid) REFERENCES COMPILER(compilerid),
69    FOREIGN KEY(platformid) REFERENCES PLATFORM(platformid),
70    FOREIGN KEY(coreid) REFERENCES CORE(coreid)
71    FOREIGN KEY(testdateid) REFERENCES TESTDATE(testdateid)
72);
73
74INSERT INTO TYPE VALUES(1, "q7");
75INSERT INTO TYPE VALUES(2, "q15");
76INSERT INTO TYPE VALUES(3, "q31");
77INSERT INTO TYPE VALUES(4, "f16");
78INSERT INTO TYPE VALUES(5, "f32");
79INSERT INTO TYPE VALUES(6, "f64");
80INSERT INTO TYPE VALUES(7, "s8");
81INSERT INTO TYPE VALUES(8, "u8");
82INSERT INTO TYPE VALUES(9, "s16");
83INSERT INTO TYPE VALUES(10,"u16");
84INSERT INTO TYPE VALUES(11,"s32");
85INSERT INTO TYPE VALUES(12,"u32");
86INSERT INTO TYPE VALUES(13,"s64");
87INSERT INTO TYPE VALUES(14,"u64");
88
89INSERT INTO COMPILERKIND VALUES(1,"AC6");
90INSERT INTO COMPILERKIND VALUES(2,"GCC");
91
92
93INSERT INTO CORE VALUES(1,"m0","ARMCM0");
94INSERT INTO CORE VALUES(2,"m0p","ARMCM0P");
95INSERT INTO CORE VALUES(3,"m3","ARMCM3");
96INSERT INTO CORE VALUES(4,"m4","ARMCM4");
97INSERT INTO CORE VALUES(5,"m4f","ARMCM4_FP");
98INSERT INTO CORE VALUES(6,"m7d","ARMCM7_DP");
99INSERT INTO CORE VALUES(7,"m23","ARMCM23");
100INSERT INTO CORE VALUES(8,"m33f","ARMCM33_DSP_FP");
101INSERT INTO CORE VALUES(9,"m35f","ARMCM35P_DSP_FP");
102INSERT INTO CORE VALUES(10,"a5","ARMCA5");
103INSERT INTO CORE VALUES(11,"a7","ARMCA7");
104INSERT INTO CORE VALUES(12,"a9","ARMCA9");
105INSERT INTO CORE VALUES(13,"a15","ARMCA15");
106INSERT INTO CORE VALUES(14,"m55mvef","ARMv81MML_DSP_DP_MVE_FP");
107
108
109/*
110Second item is text as displayed in UI
111Third is CONFIGID generated by run script
112and different from COREID as was used before
113Above we have entries with COREIDs but it is
114no more used
115*/
116INSERT INTO CORE VALUES(15,"m0","M0");
117INSERT INTO CORE VALUES(16,"m7","M7");
118INSERT INTO CORE VALUES(17,"m33","M33");
119INSERT INTO CORE VALUES(18,"m4","M4");
120INSERT INTO CORE VALUES(19,"m55 mve","M55");
121INSERT INTO CORE VALUES(20,"m55 scalar","M55SCALAR");
122INSERT INTO CORE VALUES(21,"r8","R8");
123INSERT INTO CORE VALUES(22,"r5","R5");
124INSERT INTO CORE VALUES(23,"a32","A32");
125INSERT INTO CORE VALUES(24,"r52","R52");
126INSERT INTO CORE VALUES(25,"m55 autovec","M55AUTOVEC");
127
128
129.quit
130
131