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

« back to all changes in this revision

Viewing changes to examples/db/sample.sql

Committer: William Grant
Date: 2010-01-28 00:47:22 UTC
mto: This revision was merged to the branch mainline in revision 1453.
Revision ID: me@williamgrant.id.au-20100128004722-4g7o0dpk3fatu1h3

Move Subject.url to Offering, and add Offering.description. Show these on the offering index.

files added:
userdb/migrations/20091217-01.sql

files modified:
examples/db/sample.sql

ivle/database.py

ivle/webapp/admin/templates/offering.html

ivle/webapp/coremedia/ivle.css

userdb/users.sql

Show diffs side-by-side

added added

removed removed

examples/db/sample.sql

-- PostgreSQL database dump

SET statement_timeout = 0;

SET client_encoding = 'UTF8';

SET standard_conforming_strings = off;

SET check_function_bodies = false;

131

130

132

131

133

132

134

135

136

SET SESSION AUTHORIZATION DEFAULT;

137

138

ALTER TABLE login DISABLE TRIGGER ALL;

139

140

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);

141

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);

142

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);

143

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);

144

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);

145

146

147

ALTER TABLE login ENABLE TRIGGER ALL;

148

149

150

151

152

ALTER TABLE semester DISABLE TRIGGER ALL;

153

154

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

155

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

156

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

157

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

158

159

160

ALTER TABLE semester ENABLE TRIGGER ALL;

161

162

163

164

165

ALTER TABLE subject DISABLE TRIGGER ALL;

166

167

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');

168

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');

169

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');

170

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');

171

172

173

ALTER TABLE subject ENABLE TRIGGER ALL;

174

175

176

177

178

ALTER TABLE offering DISABLE TRIGGER ALL;

179

180

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

181

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

182

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

183

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

184

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

185

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

186

187

188

ALTER TABLE offering ENABLE TRIGGER ALL;

189

190

191

192

193

ALTER TABLE project_set DISABLE TRIGGER ALL;

194

195

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

196

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

197

198

199

ALTER TABLE project_set ENABLE TRIGGER ALL;

200

201

202

203

204

ALTER TABLE project DISABLE TRIGGER ALL;

205

206

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');

207

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

208

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

209

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

210

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

211

212

213

ALTER TABLE project ENABLE TRIGGER ALL;

214

215

216

217

218

ALTER TABLE project_group DISABLE TRIGGER ALL;

219

220

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

221

222

223

ALTER TABLE project_group ENABLE TRIGGER ALL;

224

225

226

133

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

227

134

228

135

290

190

ALTER TABLE exercise ENABLE TRIGGER ALL;

291

191

292

192

293

294

295

ALTER TABLE worksheet DISABLE TRIGGER ALL;

296

297

298

299

ALTER TABLE worksheet ENABLE TRIGGER ALL;

300

301

302

303

304

ALTER TABLE worksheet_exercise DISABLE TRIGGER ALL;

305

306

307

308

ALTER TABLE worksheet_exercise ENABLE TRIGGER ALL;

309

310

311

193

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

312

194

313

195

352

232

ALTER TABLE group_member ENABLE TRIGGER ALL;

353

233

354

234

235

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

236

237

238

ALTER TABLE login DISABLE TRIGGER ALL;

239

240

241

242

243

244

245

246

247

ALTER TABLE login ENABLE TRIGGER ALL;

248

249

250

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

251

252

253

ALTER TABLE offering DISABLE TRIGGER ALL;

254

255

INSERT INTO offering (offeringid, subject, semesterid, groups_student_permissions, description, url) VALUES (1, 1, 1, 'none', NULL, 'http://www.ivle.org/example/101');

256

INSERT INTO offering (offeringid, subject, semesterid, groups_student_permissions, description, url) VALUES (2, 2, 2, 'none', NULL, 'http://www.ivle.org/example/102');

257

INSERT INTO offering (offeringid, subject, semesterid, groups_student_permissions, description, url) VALUES (3, 1, 3, 'none', NULL, 'http://www.ivle.org/example/101');

258

INSERT INTO offering (offeringid, subject, semesterid, groups_student_permissions, description, url) VALUES (4, 3, 3, 'none', NULL, 'http://www.ivle.org/example/201');

259

INSERT INTO offering (offeringid, subject, semesterid, groups_student_permissions, description, url) VALUES (5, 2, 4, 'none', NULL, 'http://www.ivle.org/example/102');

260

INSERT INTO offering (offeringid, subject, semesterid, groups_student_permissions, description, url) VALUES (6, 4, 4, 'none', NULL, 'http://www.ivle.org/example/202');

261

262

263

ALTER TABLE offering ENABLE TRIGGER ALL;

264

265

266

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

267

268

269

ALTER TABLE project DISABLE TRIGGER ALL;

270

271

272

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

273

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

274

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

275

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

276

277

278

ALTER TABLE project ENABLE TRIGGER ALL;

279

280

355

281

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

356

282

357

283

362

288

ALTER TABLE project_extension ENABLE TRIGGER ALL;

363

289

364

290

291

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

292

293

294

ALTER TABLE project_group DISABLE TRIGGER ALL;

295

296

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

297

298

299

ALTER TABLE project_group ENABLE TRIGGER ALL;

300

301

365

302

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

366

303

367

304

372

309

ALTER TABLE project_mark ENABLE TRIGGER ALL;

373

310

374

311

312

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

313

314

315

ALTER TABLE project_set DISABLE TRIGGER ALL;

316

317

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

318

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

319

320

321

ALTER TABLE project_set ENABLE TRIGGER ALL;

322

323

375

324

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

376

325

377

326

382

331

ALTER TABLE project_submission ENABLE TRIGGER ALL;

383

332

384

333

385

386

387

ALTER TABLE test_suite DISABLE TRIGGER ALL;

388

389

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

390

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

391

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

392

');

393

394

395

ALTER TABLE test_suite ENABLE TRIGGER ALL;

334

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

335

336

337

ALTER TABLE semester DISABLE TRIGGER ALL;

338

339

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

340

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

341

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

342

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

343

344

345

ALTER TABLE semester ENABLE TRIGGER ALL;

346

347

348

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

349

350

351

ALTER TABLE subject DISABLE TRIGGER ALL;

352

353

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

354

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

355

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

356

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

357

358

359

ALTER TABLE subject ENABLE TRIGGER ALL;

396

360

397

361

398

362

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

440

403

ALTER TABLE test_case_part ENABLE TRIGGER ALL;

441

404

442

405

406

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

407

408

409