[mirrorbrain-commits] [opensuse-svn] r6429 - trunk/tools/download-redirector-v2/sql

Author: poeml
Date: 2009-02-11 07:59:29 -0700 (Wed, 11 Feb 2009)
New Revision: 6429

Modified:
   trunk/tools/download-redirector-v2/sql/mirrorbrain-mysql.sql
   trunk/tools/download-redirector-v2/sql/mirrorbrain-postgresql.sql
Log:
MirrorBrain SQL schema: add asn and prefix field, and flags to limit mirror selection by these, and remove obsolete netblock field

Modified: trunk/tools/download-redirector-v2/sql/mirrorbrain-mysql.sql
===================================================================
--- trunk/tools/download-redirector-v2/sql/mirrorbrain-mysql.sql	2009-02-11 14:57:44 UTC (rev 6428)
+++ trunk/tools/download-redirector-v2/sql/mirrorbrain-mysql.sql	2009-02-11 14:59:29 UTC (rev 6429)
@@ -39,6 +39,8 @@
 -- region should be altered to char(2) - as we use it
   `region` varchar(10) default NULL,
   `country` char(2) default NULL,
+  `asn` int(11) default NULL,
+  `prefix` char(18) default NULL,
   `score` int(11) default NULL,
   `scan_fpm` int(11) default NULL,
   `last_scan` timestamp NULL default NULL,
@@ -48,11 +50,12 @@
   `operator_name` text NOT NULL,
   `operator_url` text NOT NULL,
   `public_notes` varchar(512) NOT NULL default '',
-  `netblock` text,
   `lat` float default NULL,
   `lng` float default NULL,
   `country_only` tinyint(1) default '0',
   `region_only` tinyint(1) default '0',
+  `as_only` tinyint(1) default '0',
+  `prefix_only` tinyint(1) default '0',
   `other_countries` text NOT NULL,
   `file_maxsize` int(11) NOT NULL default '0',
   PRIMARY KEY  (`id`),

Modified: trunk/tools/download-redirector-v2/sql/mirrorbrain-postgresql.sql
===================================================================
--- trunk/tools/download-redirector-v2/sql/mirrorbrain-postgresql.sql	2009-02-11 14:57:44 UTC (rev 6428)
+++ trunk/tools/download-redirector-v2/sql/mirrorbrain-postgresql.sql	2009-02-11 14:59:29 UTC (rev 6429)
@@ -27,6 +27,8 @@
         "status_baseurl" boolean NOT NULL,
         "region"  varchar(2) NOT NULL,
         "country" varchar(2) NOT NULL,
+        "asn" integer NOT NULL,
+        "prefix" varchar(18) NOT NULL,
         "score" smallint NOT NULL,
         "scan_fpm" integer NOT NULL,
         "last_scan" timestamp with time zone NULL,
@@ -36,11 +38,12 @@
         "public_notes" varchar(512) NOT NULL,
         "admin"       varchar(128) NOT NULL,
         "admin_email" varchar(128) NOT NULL,
-        "netblock" text,
         "lat" numeric(6, 3) NULL,
         "lng" numeric(6, 3) NULL,
         "country_only" boolean NOT NULL,
         "region_only" boolean NOT NULL,
+        "as_only" boolean NOT NULL,
+        "prefix_only" boolean NOT NULL,
         "other_countries" varchar(512) NOT NULL,
         "file_maxsize" integer NOT NULL default 0
 );

_______________________________________________
Opensuse-svn mailing list
Opensuse-svn_at_forge.novell.com
http://forge.novell.com/mailman/listinfo/opensuse-svn


_______________________________________________
mirrorbrain-commits mailing list

Note: To remove yourself from this list, send a mail with the content
 	unsubscribe
to the address mirrorbrain-commits-request_at_mirrorbrain.org