Hi,
Attached is a small set of most to the create scripts....
--
Yours
Matthew
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
No, my powers can only be used for good.
Index: mnogosearch/create/mysql/categories.txt
===================================================================
RCS file: /usr/src/CVS/mnogosearch/create/mysql/categories.txt,v
retrieving revision 1.1.1.1
diff -u -r1.1.1.1 categories.txt
--- mnogosearch/create/mysql/categories.txt 2001/02/07 12:17:44 1.1.1.1
+++ mnogosearch/create/mysql/categories.txt 2001/02/21 01:06:47
@@ -2,7 +2,7 @@
# Table structure for table 'categories'
#
-#DROP TABLE categories;
+DROP TABLE IF EXISTS categories;
CREATE TABLE categories (
rec_id int(11) DEFAULT '0' NOT NULL auto_increment,
Index: mnogosearch/create/mysql/crc-multi.txt
===================================================================
RCS file: /usr/src/CVS/mnogosearch/create/mysql/crc-multi.txt,v
retrieving revision 1.1.1.1
diff -u -r1.1.1.1 crc-multi.txt
--- mnogosearch/create/mysql/crc-multi.txt 2001/02/07 12:17:44 1.1.1.1
+++ mnogosearch/create/mysql/crc-multi.txt 2001/02/21 01:06:47
@@ -1,16 +1,16 @@
-#DROP TABLE ndict2;
-#DROP TABLE ndict3;
-#DROP TABLE ndict4;
-#DROP TABLE ndict5;
-#DROP TABLE ndict6;
-#DROP TABLE ndict7;
-#DROP TABLE ndict8;
-#DROP TABLE ndict9;
-#DROP TABLE ndict10;
-#DROP TABLE ndict11;
-#DROP TABLE ndict12;
-#DROP TABLE ndict16;
-#DROP TABLE ndict32;
+DROP TABLE IF EXISTS ndict2;
+DROP TABLE IF EXISTS ndict3;
+DROP TABLE IF EXISTS ndict4;
+DROP TABLE IF EXISTS ndict5;
+DROP TABLE IF EXISTS ndict6;
+DROP TABLE IF EXISTS ndict7;
+DROP TABLE IF EXISTS ndict8;
+DROP TABLE IF EXISTS ndict9;
+DROP TABLE IF EXISTS ndict10;
+DROP TABLE IF EXISTS ndict11;
+DROP TABLE IF EXISTS ndict12;
+DROP TABLE IF EXISTS ndict16;
+DROP TABLE IF EXISTS ndict32;
CREATE TABLE ndict2 (
url_id int(11) DEFAULT '0' NOT NULL,
Index: mnogosearch/create/mysql/crc.txt
===================================================================
RCS file: /usr/src/CVS/mnogosearch/create/mysql/crc.txt,v
retrieving revision 1.1.1.1
diff -u -r1.1.1.1 crc.txt
--- mnogosearch/create/mysql/crc.txt 2001/02/07 12:17:44 1.1.1.1
+++ mnogosearch/create/mysql/crc.txt 2001/02/21 01:06:47
@@ -1,4 +1,4 @@
-#DROP TABLE ndict;
+DROP TABLE IF EXISTS ndict;
CREATE TABLE ndict (
url_id int(11) DEFAULT '0' NOT NULL,
Index: mnogosearch/create/mysql/create.txt
===================================================================
RCS file: /usr/src/CVS/mnogosearch/create/mysql/create.txt,v
retrieving revision 1.1.1.1
diff -u -r1.1.1.1 create.txt
--- mnogosearch/create/mysql/create.txt 2001/02/07 12:17:44 1.1.1.1
+++ mnogosearch/create/mysql/create.txt 2001/02/21 01:06:47
@@ -4,10 +4,10 @@
#
-#DROP TABLE url;
-#DROP TABLE dict;
-#DROP TABLE robots;
-#DROP TABLE stopword;
+DROP TABLE IF EXISTS url;
+DROP TABLE IF EXISTS dict;
+DROP TABLE IF EXISTS robots;
+DROP TABLE IF EXISTS stopword;
CREATE TABLE dict (
Index: mnogosearch/create/mysql/cross-crc.txt
===================================================================
RCS file: /usr/src/CVS/mnogosearch/create/mysql/cross-crc.txt,v
retrieving revision 1.2
diff -u -r1.2 cross-crc.txt
--- mnogosearch/create/mysql/cross-crc.txt 2001/02/15 08:55:11 1.2
+++ mnogosearch/create/mysql/cross-crc.txt 2001/02/21 01:06:47
@@ -1,4 +1,4 @@
-DROP TABLE ncrossdict;
+DROP TABLE IF EXISTS ncrossdict;
CREATE TABLE ncrossdict (
url_id int(11) DEFAULT '0' NOT NULL,
Index: mnogosearch/create/mysql/cross.txt
===================================================================
RCS file: /usr/src/CVS/mnogosearch/create/mysql/cross.txt,v
retrieving revision 1.2
diff -u -r1.2 cross.txt
--- mnogosearch/create/mysql/cross.txt 2001/02/15 08:55:11 1.2
+++ mnogosearch/create/mysql/cross.txt 2001/02/21 01:06:47
@@ -1,4 +1,4 @@
-DROP TABLE crossdict;
+DROP TABLE IF EXISTS crossdict;
CREATE TABLE crossdict (
url_id int(11) DEFAULT '0' NOT NULL,
Index: mnogosearch/create/mysql/ispell.txt
===================================================================
RCS file: /usr/src/CVS/mnogosearch/create/mysql/ispell.txt,v
retrieving revision 1.1.1.1
diff -u -r1.1.1.1 ispell.txt
--- mnogosearch/create/mysql/ispell.txt 2001/02/07 12:17:44 1.1.1.1
+++ mnogosearch/create/mysql/ispell.txt 2001/02/21 01:06:47
@@ -1,5 +1,5 @@
-#DROP TABLE affix;
-#DROP TABLE spell;
+DROP TABLE IF EXISTS affix;
+DROP TABLE IF EXISTS spell;
CREATE TABLE affix (
flag char(1) DEFAULT '' NOT NULL,
Index: mnogosearch/create/mysql/multi.txt
===================================================================
RCS file: /usr/src/CVS/mnogosearch/create/mysql/multi.txt,v
retrieving revision 1.1.1.1
diff -u -r1.1.1.1 multi.txt
--- mnogosearch/create/mysql/multi.txt 2001/02/07 12:17:44 1.1.1.1
+++ mnogosearch/create/mysql/multi.txt 2001/02/21 01:06:47
@@ -1,16 +1,16 @@
-#DROP TABLE dict2;
-#DROP TABLE dict3;
-#DROP TABLE dict4;
-#DROP TABLE dict5;
-#DROP TABLE dict6;
-#DROP TABLE dict7;
-#DROP TABLE dict8;
-#DROP TABLE dict9;
-#DROP TABLE dict10;
-#DROP TABLE dict11;
-#DROP TABLE dict12;
-#DROP TABLE dict16;
-#DROP TABLE dict32;
+DROP TABLE IF EXISTS dict2;
+DROP TABLE IF EXISTS dict3;
+DROP TABLE IF EXISTS dict4;
+DROP TABLE IF EXISTS dict5;
+DROP TABLE IF EXISTS dict6;
+DROP TABLE IF EXISTS dict7;
+DROP TABLE IF EXISTS dict8;
+DROP TABLE IF EXISTS dict9;
+DROP TABLE IF EXISTS dict10;
+DROP TABLE IF EXISTS dict11;
+DROP TABLE IF EXISTS dict12;
+DROP TABLE IF EXISTS dict16;
+DROP TABLE IF EXISTS dict32;
CREATE TABLE dict2 (
Index: mnogosearch/create/mysql/servers.txt
===================================================================
RCS file: /usr/src/CVS/mnogosearch/create/mysql/servers.txt,v
retrieving revision 1.3
diff -u -r1.3 servers.txt
--- mnogosearch/create/mysql/servers.txt 2001/02/19 11:03:04 1.3
+++ mnogosearch/create/mysql/servers.txt 2001/02/21 01:06:47
@@ -1,4 +1,4 @@
-DROP TABLE server;
+DROP TABLE IF EXISTS server;
create table server (
rec_id int not null auto_increment primary key,
Index: mnogosearch/create/mysql/track.txt
===================================================================
RCS file: /usr/src/CVS/mnogosearch/create/mysql/track.txt,v
retrieving revision 1.1.1.1
diff -u -r1.1.1.1 track.txt
--- mnogosearch/create/mysql/track.txt 2001/02/07 12:17:44 1.1.1.1
+++ mnogosearch/create/mysql/track.txt 2001/02/21 01:06:47
@@ -1,4 +1,4 @@
-#DROP TABLE qtrack;
+DROP TABLE IF EXISTS qtrack;
CREATE TABLE qtrack (
qwords varchar(63) DEFAULT '' NOT NULL,
Index: mnogosearch/create/mysql/url-raid.txt
===================================================================
RCS file: /usr/src/CVS/mnogosearch/create/mysql/url-raid.txt,v
retrieving revision 1.1.1.1
diff -u -r1.1.1.1 url-raid.txt
--- mnogosearch/create/mysql/url-raid.txt 2001/02/07 12:17:44 1.1.1.1
+++ mnogosearch/create/mysql/url-raid.txt 2001/02/21 01:06:47
@@ -28,7 +28,7 @@
#
-DROP TABLE url;
+DROP TABLE IF EXISTS url;
CREATE TABLE url (
rec_id int(11) DEFAULT '0' NOT NULL,
begin:vcard
n:Sullivan;Matthew
tel;cell:+61 (0)414 861 744
tel;fax:+61 (0)3 9693 7699
tel;home:+61 (0)3 9397 4859
tel;work:+61 (0)3 9693 7640
x-mozilla-html:TRUE
url:http://people.netscape.com/matthews/
org:<TABLE cols=2 width=350 spacing=0 rows=1><TR><TD width=50><img src="http://people.netscape.com/matthews/penguin.gif"></TD><TD><TABLE width=250 spacing=0 border=0><TR><TD><FONT SIZE=2>Senior Technical Support Engineer<TR><TD><FONT SIZE=2>iPlanet E-Commerce Solutions<TR><TD><FONT SIZE=2>Netscape Communications Australia Pty Ltd<TR><TD><FONT SIZE=2>A division of America On Line Inc.</TABLE></TABLE>
version:2.1
email;internet:[EMAIL PROTECTED]
adr;quoted-printable:;;Netscape Communications Australia=0D=0A;Level 1, The Tea House, 28 Clarendon Street;South Melbourne;VIC 3205;Australia
x-mozilla-cpt:nemesis.netscape.com;28656
fn:Matthew Sullivan
end:vcard
S/MIME Cryptographic Signature
