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

Author: poeml
Date: 2009-02-02 09:52:30 -0700 (Mon, 02 Feb 2009)
New Revision: 6312

Added:
   trunk/tools/download-redirector-v2/sql/mirrorbrain-mysql.sql
Removed:
   trunk/tools/download-redirector-v2/sql/opensuse-redirector.sql
Log:
mirrorbrain sql scheme: rename file to be mysql specific and opensuse non-specific


Copied: trunk/tools/download-redirector-v2/sql/mirrorbrain-mysql.sql (from rev 6243, trunk/tools/download-redirector-v2/sql/opensuse-redirector.sql)
===================================================================
--- trunk/tools/download-redirector-v2/sql/mirrorbrain-mysql.sql	                        (rev 0)
+++ trunk/tools/download-redirector-v2/sql/mirrorbrain-mysql.sql	2009-02-02 16:52:30 UTC (rev 6312)
_at_@ -0,0 +1,95 @@
+
+-- 
+-- Database: `redirector`
+-- 
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure of table `file`
+-- 
+
+CREATE TABLE `file` (
+  `id` int(11) unsigned NOT NULL auto_increment,
+  `path` varchar(512) NOT NULL,
+  PRIMARY KEY  (`id`),
+  KEY `file_path_idx` (`path`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure of table `file_server`
+-- 
+
+CREATE TABLE `file_server` (
+  `fileid` int(11) unsigned NOT NULL default '0',
+  `serverid` int(11) unsigned NOT NULL default '0',
+  `timestamp_file` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  `timestamp_scanner` timestamp NOT NULL default '0000-00-00 00:00:00',
+  KEY `fileid` (`fileid`,`serverid`),
+  KEY `file_server_fileid_idx` (`fileid`),
+  KEY `file_server_serverid_idx` (`serverid`),
+  KEY `file_server_fileid_serverid_idx` (`fileid`,`serverid`),
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure of table `server`
+-- 
+
+CREATE TABLE `server` (
+  `id` int(11) unsigned NOT NULL auto_increment,
+  `identifier` varchar(64) NOT NULL,
+  `baseurl` varchar(128) NOT NULL,
+  `baseurl_ftp` varchar(128) NOT NULL,
+  `enabled` tinyint(1) NOT NULL default '0',
+  `status_baseurl` tinyint(1) NOT NULL default '0',
+  `last_scan` timestamp NULL default NULL,
+  `region` varchar(10) default NULL,
+  `country` char(2) default NULL,
+  `score` int(11) default NULL,
+  `scan_fpm` int(11) default NULL,
+  `baseurl_rsync` varchar(128) default NULL,
+  `comment` text,
+  `admin_email` text,
+  `netblock` text,
+  `admin` text,
+  `lat` float default NULL,
+  `lng` float default NULL,
+  `country_only` tinyint(1) default '0',
+  `region_only` tinyint(1) default '0',
+  `other_countries` text NOT NULL,
+  `file_maxsize` int(11) NOT NULL default '0',
+  `operator_name` text NOT NULL,
+  `operator_url` text NOT NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `identifier` (`identifier`),
+  KEY `server_enabled_status_baseurl_score_idx` (`enabled`,`status_baseurl`,`score`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+
+-- 
+-- Table structure of table `marker`
+-- 
+
+CREATE TABLE `marker` (
+  `id` int(11) unsigned NOT NULL auto_increment,
+  `subtree_name` varchar(128) NOT NULL,
+  `markers` varchar(512) NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+
+-- 
+-- Table structure of table `countries`
+-- 
+
+CREATE TABLE `country` (
+  `id` tinyint(1) NOT NULL auto_increment,
+  `code` char(2) NOT NULL,
+  `name` char(64) NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+

Deleted: trunk/tools/download-redirector-v2/sql/opensuse-redirector.sql

_______________________________________________
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