diff options
author | terry%netscape.com <> | 1998-08-26 13:14:15 +0000 |
---|---|---|
committer | terry%netscape.com <> | 1998-08-26 13:14:15 +0000 |
commit | 482763c95359bd0352878542826693064d9e365e (patch) | |
tree | af570f3e013f34f28ca7967e4b7dcd7a9f05f854 /makeversiontable.sh | |
download | bugs-482763c95359bd0352878542826693064d9e365e.tar bugs-482763c95359bd0352878542826693064d9e365e.tar.gz bugs-482763c95359bd0352878542826693064d9e365e.tar.bz2 bugs-482763c95359bd0352878542826693064d9e365e.tar.xz bugs-482763c95359bd0352878542826693064d9e365e.zip |
Bugzilla source.
Diffstat (limited to 'makeversiontable.sh')
-rwxr-xr-x | makeversiontable.sh | 51 |
1 files changed, 51 insertions, 0 deletions
diff --git a/makeversiontable.sh b/makeversiontable.sh new file mode 100755 index 000000000..111b6d190 --- /dev/null +++ b/makeversiontable.sh @@ -0,0 +1,51 @@ +#!/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 versions +OK_ALL_DONE + +mysql << OK_ALL_DONE +use bugs; +create table versions ( +value tinytext, +program tinytext +); + + + +insert into versions (value, program) values ("other", "Communicator"); +insert into versions (value, program) values ("1998-03-31", "Communicator"); +insert into versions (value, program) values ("1998-04-08", "Communicator"); +insert into versions (value, program) values ("1998-04-29", "Communicator"); +insert into versions (value, program) values ("1998-06-03", "Communicator"); +insert into versions (value, program) values ("1998-07-28", "Communicator"); +insert into versions (value, program) values ("1.0", "Bugzilla"); +insert into versions (value, program) values ("other", "Bugzilla"); + +select * from versions; + +show columns from versions; +show index from versions; + +OK_ALL_DONE |