You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
61 lines
1.5 KiB
SQL
61 lines
1.5 KiB
SQL
-- phpMyAdmin SQL Dump
|
|
-- version 3.4.7
|
|
-- http://www.phpmyadmin.net
|
|
--
|
|
-- Host: localhost
|
|
-- Generation Time: Mar 07, 2013 at 09:20 PM
|
|
-- Server version: 5.5.29
|
|
-- PHP Version: 5.3.19
|
|
|
|
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
|
|
SET time_zone = "+00:00";
|
|
|
|
--
|
|
-- Database: `transfer`
|
|
--
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `emails`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `emails` (
|
|
`Id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
|
`EmailAddress` varchar(250) NOT NULL,
|
|
`Key` varchar(16) NOT NULL,
|
|
PRIMARY KEY (`Id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `entries`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `entries` (
|
|
`Id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
|
`VpsId` varchar(100) NOT NULL,
|
|
`Username` varchar(100) NOT NULL,
|
|
`EmailAddress` varchar(250) DEFAULT NULL,
|
|
`TargetNode` varchar(160) NOT NULL,
|
|
`Position` int(10) unsigned DEFAULT NULL,
|
|
`Finished` tinyint(3) unsigned NOT NULL,
|
|
`DiskUsage` bigint(20) NOT NULL,
|
|
PRIMARY KEY (`Id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `servers`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `servers` (
|
|
`Id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
|
`Host` varchar(200) NOT NULL,
|
|
`Busy` tinyint(3) unsigned NOT NULL,
|
|
`Current` int(10) unsigned NOT NULL,
|
|
PRIMARY KEY (`Id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|