~azzar1/unity/add-show-desktop-key

INSERT INTO login (loginid, login, passhash, state, admin, unixid, nick, pass_exp, acct_exp, last_login, svn_pass, email, fullname, studentid, settings) VALUES (1, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'enabled', true, 5000, 'Anne Admin', NULL, NULL, '2009-12-08 11:44:02.285862', 'password', NULL, 'Anne Admin', NULL, NULL);

142

INSERT INTO login (loginid, login, passhash, state, admin, unixid, nick, pass_exp, acct_exp, last_login, svn_pass, email, fullname, studentid, settings) VALUES (2, 'lecturer', '5f4dcc3b5aa765d61d8327deb882cf99', 'enabled', false, 5001, 'Larry Lecturer', NULL, NULL, '2009-12-08 12:12:16.375628', 'password', NULL, 'Larry Lecturer', NULL, NULL);

143

INSERT INTO login (loginid, login, passhash, state, admin, unixid, nick, pass_exp, acct_exp, last_login, svn_pass, email, fullname, studentid, settings) VALUES (3, 'tutor', '5f4dcc3b5aa765d61d8327deb882cf99', 'enabled', false, 5002, 'Terry Tutor', NULL, NULL, '2009-12-08 19:08:59.817505', 'password', NULL, 'Terry Tutor', NULL, NULL);

144

INSERT INTO login (loginid, login, passhash, state, admin, unixid, nick, pass_exp, acct_exp, last_login, svn_pass, email, fullname, studentid, settings) VALUES (4, 'studenta', '5f4dcc3b5aa765d61d8327deb882cf99', 'enabled', false, 5003, 'Alice Student', NULL, NULL, '2009-12-08 12:11:46.349133', 'password', NULL, 'Alice Student', NULL, NULL);

145

INSERT INTO login (loginid, login, passhash, state, admin, unixid, nick, pass_exp, acct_exp, last_login, svn_pass, email, fullname, studentid, settings) VALUES (5, 'studentb', '5f4dcc3b5aa765d61d8327deb882cf99', 'no_agreement', false, 5004, 'Bob Student', NULL, NULL, NULL, NULL, NULL, 'Bob Student', NULL, NULL);

146

147

148

ALTER TABLE login ENABLE TRIGGER ALL;

149

150

151

-- Data for Name: semester; Type: TABLE DATA; Schema: public; Owner: -

152

153

154

ALTER TABLE semester DISABLE TRIGGER ALL;

155

156

INSERT INTO semester (semesterid, year, semester, state) VALUES (1, '2009', '1', 'past');

157

INSERT INTO semester (semesterid, year, semester, state) VALUES (2, '2009', '2', 'current');

158

INSERT INTO semester (semesterid, year, semester, state) VALUES (3, '2010', '1', 'future');

159

INSERT INTO semester (semesterid, year, semester, state) VALUES (4, '2010', '2', 'future');

160

161

162

ALTER TABLE semester ENABLE TRIGGER ALL;

163

164

165

-- Data for Name: subject; Type: TABLE DATA; Schema: public; Owner: -

166

167

168

ALTER TABLE subject DISABLE TRIGGER ALL;

169

170

INSERT INTO subject (subjectid, subj_code, subj_name, subj_short_name, url) VALUES (1, '100101', 'Introduction to IVLE', 'ivle-101', 'http://www.ivle.org/example/101');

171

INSERT INTO subject (subjectid, subj_code, subj_name, subj_short_name, url) VALUES (2, '100102', 'Intermediate IVLE', 'ivle-102', 'http://www.ivle.org/example/102');

172

INSERT INTO subject (subjectid, subj_code, subj_name, subj_short_name, url) VALUES (3, '100201', 'Advanced IVLE', 'ivle-201', 'http://www.ivle.org/example/201');

173

INSERT INTO subject (subjectid, subj_code, subj_name, subj_short_name, url) VALUES (4, '100202', 'Mastering IVLE', 'ivle-202', 'http://www.ivle.org/example/202');

174

175

176

ALTER TABLE subject ENABLE TRIGGER ALL;

177

178

179

-- Data for Name: offering; Type: TABLE DATA; Schema: public; Owner: -

180

181

182

ALTER TABLE offering DISABLE TRIGGER ALL;

183

184

INSERT INTO offering (offeringid, subject, semesterid, groups_student_permissions) VALUES (1, 1, 1, 'none');

185

INSERT INTO offering (offeringid, subject, semesterid, groups_student_permissions) VALUES (2, 2, 2, 'none');

186

INSERT INTO offering (offeringid, subject, semesterid, groups_student_permissions) VALUES (3, 1, 3, 'none');

187

INSERT INTO offering (offeringid, subject, semesterid, groups_student_permissions) VALUES (4, 3, 3, 'none');

188

INSERT INTO offering (offeringid, subject, semesterid, groups_student_permissions) VALUES (5, 2, 4, 'none');

189

INSERT INTO offering (offeringid, subject, semesterid, groups_student_permissions) VALUES (6, 4, 4, 'none');

190

191

192

ALTER TABLE offering ENABLE TRIGGER ALL;

193

194

195

-- Data for Name: project_set; Type: TABLE DATA; Schema: public; Owner: -

196

197

198

ALTER TABLE project_set DISABLE TRIGGER ALL;

199

200

INSERT INTO project_set (projectsetid, offeringid, max_students_per_group) VALUES (1, 2, NULL);

201

INSERT INTO project_set (projectsetid, offeringid, max_students_per_group) VALUES (2, 2, 3);

202

203

204

ALTER TABLE project_set ENABLE TRIGGER ALL;

205

206

207

-- Data for Name: project; Type: TABLE DATA; Schema: public; Owner: -

208

209

210

ALTER TABLE project DISABLE TRIGGER ALL;

211

212

INSERT INTO project (projectid, short_name, name, synopsis, url, projectsetid, deadline) VALUES (1, 'phase1', 'Phase 1', 'This is the first project in Intermediate IVLE.', NULL, 1, '2009-08-21 18:00:00');

213

INSERT INTO project (projectid, short_name, name, synopsis, url, projectsetid, deadline) VALUES (2, 'phase2', 'Phase 2', 'This is the second project in Intermediate IVLE.

214

Get into groups of 3.', NULL, 2, '2009-09-11 18:00:00');

215

INSERT INTO project (projectid, short_name, name, synopsis, url, projectsetid, deadline) VALUES (3, 'phase3', 'Phase 3', 'This is the final project in Intermediate IVLE.

216

Complete this with the same group as Phase 2.', NULL, 2, '2009-09-25 18:00:00');

217

218

219

ALTER TABLE project ENABLE TRIGGER ALL;

220

221

222

-- Data for Name: project_group; Type: TABLE DATA; Schema: public; Owner: -

223

224

225

ALTER TABLE project_group DISABLE TRIGGER ALL;

226

227

INSERT INTO project_group (groupnm, groupid, projectsetid, nick, createdby, epoch) VALUES ('group1', 1, 2, 'group1', 2, '2009-12-08 17:04:42.981005');

228

229

230

ALTER TABLE project_group ENABLE TRIGGER ALL;

231

232

133

233

-- Data for Name: assessed; Type: TABLE DATA; Schema: public; Owner: -

134

234

135

235

190

290

ALTER TABLE exercise ENABLE TRIGGER ALL;

191

291

192

292

293

-- Data for Name: worksheet; Type: TABLE DATA; Schema: public; Owner: -

294

295

296

ALTER TABLE worksheet DISABLE TRIGGER ALL;

297

298

299

300

ALTER TABLE worksheet ENABLE TRIGGER ALL;

301

302

303

-- Data for Name: worksheet_exercise; Type: TABLE DATA; Schema: public; Owner: -

304

305

306

ALTER TABLE worksheet_exercise DISABLE TRIGGER ALL;

307

308

309

310

ALTER TABLE worksheet_exercise ENABLE TRIGGER ALL;

311

312

193

313

-- Data for Name: exercise_attempt; Type: TABLE DATA; Schema: public; Owner: -

194

314

195

315

232

352

ALTER TABLE group_member ENABLE TRIGGER ALL;

233

353

234

354

235

236

237

ALTER TABLE login DISABLE TRIGGER ALL;

238

239

240

241

242

243

244

245

246

ALTER TABLE login ENABLE TRIGGER ALL;

247

248

249

250

251

ALTER TABLE offering DISABLE TRIGGER ALL;

252

253

INSERT INTO offering (offeringid, subject, semesterid, description, url, groups_student_permissions) VALUES (1, 1, 1, 'This subject will introduce you to the basics of IVLE.', 'http://www.ivle.org/example/101', 'none');

254

INSERT INTO offering (offeringid, subject, semesterid, description, url, groups_student_permissions) VALUES (2, 2, 2, 'Enhancing your understanding of IVLE''s usage and operation, this subject will consolidate and expand your general IVLE knowledge.', 'http://www.ivle.org/example/102', 'none');

255

INSERT INTO offering (offeringid, subject, semesterid, description, url, groups_student_permissions) VALUES (3, 1, 3, 'This subject will introduce you to the basics of IVLE, again.', 'http://www.ivle.org/example/101', 'none');

256

INSERT INTO offering (offeringid, subject, semesterid, description, url, groups_student_permissions) VALUES (4, 3, 3, 'This subject will provide you with a working knowledge of advanced IVLE concepts.', 'http://www.ivle.org/example/201', 'none');

257

INSERT INTO offering (offeringid, subject, semesterid, description, url, groups_student_permissions) VALUES (5, 2, 4, 'Enhancing your understanding of IVLE''s usage and operation, this subject will consolidate and expand your general IVLE knowledge, again.', 'http://www.ivle.org/example/102', 'none');

258

INSERT INTO offering (offeringid, subject, semesterid, description, url, groups_student_permissions) VALUES (6, 4, 4, 'After undertaking this subject, you should be a master of all things IVLEy.', 'http://www.ivle.org/example/202', 'none');

259

260

261

ALTER TABLE offering ENABLE TRIGGER ALL;

262

263

264

265

266

ALTER TABLE project DISABLE TRIGGER ALL;

267

268

269

INSERT INTO project (projectid, short_name, name, synopsis, url, projectsetid, deadline) VALUES (2, 'phase2', 'Phase 2', 'This is the second project in Intermediate IVLE.

270

Get into groups of 3.', NULL, 2, '2009-09-11 18:00:00');

271

INSERT INTO project (projectid, short_name, name, synopsis, url, projectsetid, deadline) VALUES (3, 'phase3', 'Phase 3', 'This is the final project in Intermediate IVLE.

272

Complete this with the same group as Phase 2.', NULL, 2, '2009-09-25 18:00:00');

273

274

275

ALTER TABLE project ENABLE TRIGGER ALL;

276

277

278

355

-- Data for Name: project_extension; Type: TABLE DATA; Schema: public; Owner: -

279

356

280

357

288

362

ALTER TABLE project_extension ENABLE TRIGGER ALL;

289

363

290

364

291

292

293

ALTER TABLE project_group DISABLE TRIGGER ALL;

294

295

INSERT INTO project_group (groupnm, groupid, projectsetid, nick, createdby, epoch) VALUES ('group1', 1, 2, 'group1', 2, '2009-12-08 17:04:42.981005');

296

297

298

ALTER TABLE project_group ENABLE TRIGGER ALL;

299

300

301

365

-- Data for Name: project_mark; Type: TABLE DATA; Schema: public; Owner: -

302

366

303

367

309

372

ALTER TABLE project_mark ENABLE TRIGGER ALL;

310

373

311

374

312

313

314

ALTER TABLE project_set DISABLE TRIGGER ALL;

315

316

INSERT INTO project_set (projectsetid, offeringid, max_students_per_group) VALUES (1, 2, NULL);

317

INSERT INTO project_set (projectsetid, offeringid, max_students_per_group) VALUES (2, 2, 3);

318

319

320

ALTER TABLE project_set ENABLE TRIGGER ALL;

321

322

323

375

-- Data for Name: project_submission; Type: TABLE DATA; Schema: public; Owner: -

324

376

325

377

331

382

ALTER TABLE project_submission ENABLE TRIGGER ALL;

332

383

333

384

334

335

336

ALTER TABLE semester DISABLE TRIGGER ALL;

337

338

INSERT INTO semester (semesterid, year, semester, state) VALUES (1, '2009', '1', 'past');

339

INSERT INTO semester (semesterid, year, semester, state) VALUES (2, '2009', '2', 'current');

340

INSERT INTO semester (semesterid, year, semester, state) VALUES (3, '2010', '1', 'future');

341

INSERT INTO semester (semesterid, year, semester, state) VALUES (4, '2010', '2', 'future');

342

343

344

ALTER TABLE semester ENABLE TRIGGER ALL;

345

346

347

348

349

ALTER TABLE subject DISABLE TRIGGER ALL;

350

351

INSERT INTO subject (subjectid, subj_code, subj_name, subj_short_name) VALUES (1, '100101', 'Introduction to IVLE', 'ivle-101');

352

INSERT INTO subject (subjectid, subj_code, subj_name, subj_short_name) VALUES (2, '100102', 'Intermediate IVLE', 'ivle-102');

353

INSERT INTO subject (subjectid, subj_code, subj_name, subj_short_name) VALUES (3, '100201', 'Advanced IVLE', 'ivle-201');

354

INSERT INTO subject (subjectid, subj_code, subj_name, subj_short_name) VALUES (4, '100202', 'Mastering IVLE', 'ivle-202');

355

356

357

ALTER TABLE subject ENABLE TRIGGER ALL;

385

-- Data for Name: test_suite; Type: TABLE DATA; Schema: public; Owner: -

386

387

388

ALTER TABLE test_suite DISABLE TRIGGER ALL;

389

390

INSERT INTO test_suite (suiteid, exerciseid, description, seq_no, function, stdin) VALUES (2, 'factorial', 'Test fac(5)', 1, 'fac', '');

391

INSERT INTO test_suite (suiteid, exerciseid, description, seq_no, function, stdin) VALUES (1, 'factorial', 'Test fac(4)', 0, 'fac', '');

392

INSERT INTO test_suite (suiteid, exerciseid, description, seq_no, function, stdin) VALUES (3, 'factorial', 'Test main', 2, 'main', '4

393

');

394

395

396

ALTER TABLE test_suite ENABLE TRIGGER ALL;

358

397

359

398

360

399

-- Data for Name: suite_variable; Type: TABLE DATA; Schema: public; Owner: -

403

440

ALTER TABLE test_case_part ENABLE TRIGGER ALL;

404

441

405

442

406

407

408