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

Author: poeml
Date: 2009-02-02 17:58:06 -0700 (Mon, 02 Feb 2009)
New Revision: 6326

Modified:
   trunk/tools/download-redirector-v2/sql/mirrorbrain-mysql.sql
Log:
MirrorBrain database schema for MySQL: add a missing field which as been
recently added in production, and the missing "regions" table which was created
for and is used by the mirror list generator.


Modified: trunk/tools/download-redirector-v2/sql/mirrorbrain-mysql.sql
===================================================================
--- trunk/tools/download-redirector-v2/sql/mirrorbrain-mysql.sql	2009-02-03 00:07:06 UTC (rev 6325)
+++ trunk/tools/download-redirector-v2/sql/mirrorbrain-mysql.sql	2009-02-03 00:58:06 UTC (rev 6326)
_at_@ -47,6 +47,7 @@
   `admin_email` text,
   `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,
_at_@ -75,3 +76,11 @@
   PRIMARY KEY  (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
+
+CREATE TABLE `region` (
+  `id` int(2) NOT NULL auto_increment,
+  `code` char(2) NOT NULL,
+  `name` char(64) NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 | 
+

_______________________________________________
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