From 7404b977d6c7d0dc71bb3abc5809ce394c103486 Mon Sep 17 00:00:00 2001 From: "terry%mozilla.org" <> Date: Tue, 12 Oct 1999 23:57:56 +0000 Subject: Patch by Holger Schurig -- replace all the yicky old make*.sh files and the CHANGES file with a new, nifty checksetup.pl file that knows how to create a setup from scratch as well as upgrade an older setup to a new one. Very cool stuff! --- makegroupstable.sh | 69 ------------------------------------------------------ 1 file changed, 69 deletions(-) delete mode 100755 makegroupstable.sh (limited to 'makegroupstable.sh') diff --git a/makegroupstable.sh b/makegroupstable.sh deleted file mode 100755 index 561823878..000000000 --- a/makegroupstable.sh +++ /dev/null @@ -1,69 +0,0 @@ -#!/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 - -mysql > /dev/null 2>/dev/null << OK_ALL_DONE - -use bugs; - -drop table groups -OK_ALL_DONE - -mysql << OK_ALL_DONE -use bugs; -create table groups ( - # This must be a power of two. Groups are identified by a bit; sets of - # groups are indicated by or-ing these values together. - bit bigint not null, - name varchar(255) not null, - description text not null, - - # isbuggroup is nonzero if this is a group that controls access to a set - # of bugs. In otherword, the groupset field in the bugs table should only - # have this group's bit set if isbuggroup is nonzero. - isbuggroup tinyint not null, - - # User regexp is which email addresses are initially put into this group. - # This is only used when an email account is created; otherwise, profiles - # may be individually tweaked to add them in and out of groups. - userregexp tinytext not null, - - - unique(bit), - unique(name) - -); - - -insert into groups (bit, name, description, userregexp) values (pow(2,0), "tweakparams", "Can tweak operating parameters", ""); -insert into groups (bit, name, description, userregexp) values (pow(2,1), "editgroupmembers", "Can put people in and out of groups that they are members of.", ""); -insert into groups (bit, name, description, userregexp) values (pow(2,2), "creategroups", "Can create and destroy groups.", ""); -insert into groups (bit, name, description, userregexp) values (pow(2,3), "editcomponents", "Can create, destroy, and edit components.", ""); - - - -show columns from groups; -show index from groups; - - -# Check for bad bit values. - -select "*** Bad bit value", bit from groups where bit != pow(2, round(log(bit) / log(2))); - -OK_ALL_DONE -- cgit v1.2.3-24-g4f1b