diff options
author | terry%mozilla.org <> | 1999-05-27 23:13:40 +0200 |
---|---|---|
committer | terry%mozilla.org <> | 1999-05-27 23:13:40 +0200 |
commit | 65aeb54b2937560d2eb4ca46ad9a58c636afb361 (patch) | |
tree | 15a4d0f8cd775556fe5852e3807c918f72e92bac /makedependenciestable.sh | |
parent | b0ce98e67626a85a78ea0defb8533f5adb87e2f3 (diff) | |
download | bugzilla-65aeb54b2937560d2eb4ca46ad9a58c636afb361.tar.gz bugzilla-65aeb54b2937560d2eb4ca46ad9a58c636afb361.tar.xz |
Added dependencies, so that you can mark which bugs depend on which
other ones.
Diffstat (limited to 'makedependenciestable.sh')
-rwxr-xr-x | makedependenciestable.sh | 43 |
1 files changed, 43 insertions, 0 deletions
diff --git a/makedependenciestable.sh b/makedependenciestable.sh new file mode 100755 index 000000000..80a6795b2 --- /dev/null +++ b/makedependenciestable.sh @@ -0,0 +1,43 @@ +#!/bin/sh +# +# The contents of this file are subject to the Mozilla Public License +# Version 1.0 (the "License"); you may not use this file except in +# compliance with the License. You may obtain a copy of the License at +# http://www.mozilla.org/MPL/ +# +# Software distributed under the License is distributed on an "AS IS" +# basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the +# License for the specific language governing rights and limitations +# under the License. +# +# The Original Code is the Bugzilla Bug Tracking System. +# +# The Initial Developer of the Original Code is Netscape Communications +# Corporation. Portions created by Netscape are Copyright (C) 1998 +# Netscape Communications Corporation. All Rights Reserved. +# +# Contributor(s): Terry Weissman <terry@mozilla.org> + +mysql > /dev/null 2>/dev/null << OK_ALL_DONE + +use bugs; + +drop table dependencies +OK_ALL_DONE + +mysql << OK_ALL_DONE +use bugs; +create table dependencies ( + blocked mediumint not null, + dependson mediumint not null, + + index(blocked), + index(dependson) +); + + + +show columns from dependencies; +show index from dependencies; + +OK_ALL_DONE |