~ubuntu-branches/ubuntu/hoary/moodle/hoary

« back to all changes in this revision

Viewing changes to mod/journal/db/postgres7.sql

  • Committer: Bazaar Package Importer
  • Author(s): Isaac Clerencia
  • Date: 2004-12-29 00:49:52 UTC
  • mfrom: (1.1.1 upstream)
  • Revision ID: james.westby@ubuntu.com-20041229004952-gliyqzpj2w3e7clx
Tags: 1.4.3-1
* Urgency high as upstream release fixes several security bugs
* New upstream release
* Write database creation errors and warn the user about it, 
closes: #285842, #285842

Show diffs side-by-side

added added

removed removed

Lines of Context:
24
24
  assessed integer NOT NULL default '0',
25
25
  timemodified integer NOT NULL default '0'
26
26
);
 
27
 
 
28
CREATE INDEX prefix_journal_course_idx ON prefix_journal (course);
 
29
 
27
30
# --------------------------------------------------------
28
31
 
29
32
#
44
47
  mailed integer NOT NULL default '0'
45
48
);
46
49
 
 
50
CREATE INDEX prefix_journal_entries_journal_idx ON prefix_journal_entries (journal);
 
51
CREATE INDEX prefix_journal_entries_userid_idx ON prefix_journal_entries (userid);
 
52
 
47
53
#
48
54
# Dumping data for table `log_display`
49
55
#