Ignore:
Timestamp:
Jan 19, 2014, 12:27:57 AM (11 years ago)
Author:
chronos
Message:
  • Upraveno: Aktualizace počátečního sql.
File:
1 edited

Legend:

Unmodified
Added
Removed

  • branches/php/SQL/structure.sql

    r16 r110  
    11-- phpMyAdmin SQL Dump
    2 -- version 3.0.1.1
     2-- version 3.4.7.1
    33-- http://www.phpmyadmin.net
    44--
    55-- Počítač: localhost
    6 -- Vygenerováno: Pátek 28. listopadu 2008, 08:39
    7 -- Verze MySQL: 5.0.51
    8 -- Verze PHP: 5.2.6
     6-- Vygenerováno: Ned 19. led 2014, 00:22
     7-- Verze MySQL: 5.1.60
     8-- Verze PHP: 5.3.8
    99
    1010SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
     11SET time_zone = "+00:00";
    1112
    1213--
    13 -- Databáze: `zdechovnet`
     14-- Databáze: `www`
    1415--
    1516
    … …  
    1718
    1819--
    19 -- Struktura tabulky `jirihajda_app_errors`
     20-- Struktura tabulky `History`
    2021--
    2122
    22 CREATE TABLE IF NOT EXISTS `jirihajda_app_errors` (
    23   `id` int(11) NOT NULL auto_increment,
    24   `time` varchar(255) NOT NULL default '',
    25   `message` varchar(255) NOT NULL default '',
    26   `exception` varchar(255) NOT NULL default '',
    27   `address` varchar(255) NOT NULL default '',
    28   `application` varchar(255) NOT NULL default '',
    29   `state` varchar(255) NOT NULL default '',
    30   `version` varchar(255) NOT NULL default '',
    31   `release_date` varchar(255) NOT NULL default '',
    32   `method` varchar(255) NOT NULL default '',
    33   `unit` varchar(255) NOT NULL default '',
    34   `line_number` varchar(255) NOT NULL default '',
    35   `remote_addr` varchar(255) NOT NULL default '',
    36   `remote_host` varchar(255) NOT NULL default '',
    37   `url` text NOT NULL,
    38   PRIMARY KEY  (`id`)
    39 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=4109 ;
     23CREATE TABLE IF NOT EXISTS `History` (
     24  `Id` int(11) NOT NULL AUTO_INCREMENT,
     25  `Date` date NOT NULL,
     26  `Text` text COLLATE utf8_czech_ci NOT NULL,
     27  PRIMARY KEY (`Id`)
     28) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=28 ;
    4029
    4130-- --------------------------------------------------------
    4231
    4332--
    44 -- Struktura tabulky `jirihajda_projekty`
     33-- Struktura tabulky `HostedProject`
    4534--
    4635
    47 CREATE TABLE IF NOT EXISTS `jirihajda_projekty` (
    48   `id` int(11) NOT NULL auto_increment,
    49   `title` varchar(255) NOT NULL default '',
    50   `description` text NOT NULL,
    51   `link` varchar(255) NOT NULL default '',
    52   `image` varchar(255) NOT NULL default '',
    53   `finished` int(11) NOT NULL default '0',
    54   PRIMARY KEY  (`id`)
    55 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=12 ;
     36CREATE TABLE IF NOT EXISTS `HostedProject` (
     37  `Id` int(11) NOT NULL AUTO_INCREMENT,
     38  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     39  `Homepage` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     40  `User` int(255) NOT NULL COMMENT 'User.Id',
     41  `TimeCreate` datetime NOT NULL,
     42  `Server` int(11) DEFAULT NULL COMMENT 'NetworkDevice.Id',
     43  `Active` int(11) NOT NULL DEFAULT '1',
     44  `WebHosting` int(11) NOT NULL,
     45  PRIMARY KEY (`Id`)
     46) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=38 ;
    5647
    5748-- --------------------------------------------------------
    5849
    5950--
    60 -- Struktura tabulky `sunrisechat_stat`
     51-- Struktura tabulky `HTTPSession`
    6152--
    6253
    63 CREATE TABLE IF NOT EXISTS `sunrisechat_stat` (
    64   `id` int(11) NOT NULL auto_increment,
    65   `category` varchar(255) NOT NULL default '',
    66   `name` varchar(255) NOT NULL default '',
    67   `hits` int(11) NOT NULL default '0',
    68   `date` date NOT NULL default '0000-00-00',
    69   PRIMARY KEY  (`id`)
    70 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=3499 ;
     54CREATE TABLE IF NOT EXISTS `HTTPSession` (
     55  `Id` int(11) NOT NULL AUTO_INCREMENT,
     56  `Time` datetime NOT NULL,
     57  `Identification` varchar(255) NOT NULL,
     58  `Variables` text NOT NULL,
     59  PRIMARY KEY (`Id`)
     60) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    7161
    7262-- --------------------------------------------------------
    7363
    7464--
    75 -- Struktura tabulky `sunrisechat_user_notes`
     65-- Struktura tabulky `Plans`
    7666--
    7767
    78 CREATE TABLE IF NOT EXISTS `sunrisechat_user_notes` (
    79   `id` int(11) NOT NULL auto_increment,
    80   `time` datetime NOT NULL default '0000-00-00 00:00:00',
    81   `nick` varchar(32) NOT NULL default '',
    82   `title` varchar(64) NOT NULL default '',
    83   `content` varchar(255) NOT NULL default '',
    84   `remote_addr` varchar(128) NOT NULL default '',
    85   PRIMARY KEY  (`id`)
    86 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=5 ;
     68CREATE TABLE IF NOT EXISTS `Plans` (
     69  `Id` int(11) NOT NULL AUTO_INCREMENT,
     70  `TimeCreate` datetime NOT NULL,
     71  `TimeFinished` datetime DEFAULT NULL,
     72  `Description` text COLLATE utf8_czech_ci NOT NULL,
     73  `Conclusion` text COLLATE utf8_czech_ci NOT NULL,
     74  `Public` int(11) NOT NULL DEFAULT '0',
     75  PRIMARY KEY (`Id`),
     76  KEY `TimeCreate` (`TimeCreate`),
     77  KEY `TimeFinished` (`TimeFinished`)
     78) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=18 ;
    8779
    8880-- --------------------------------------------------------
    8981
    9082--
    91 -- Struktura tabulky `www_stat`
     83-- Struktura tabulky `User`
    9284--
    9385
    94 CREATE TABLE IF NOT EXISTS `www_stat` (
    95   `id` int(11) NOT NULL auto_increment,
    96   `category` varchar(255) NOT NULL default '',
    97   `name` varchar(255) NOT NULL default '',
    98   `hits` int(11) NOT NULL default '0',
    99   `date` date NOT NULL default '0000-00-00',
    100   PRIMARY KEY  (`id`),
    101   KEY `date` (`date`),
    102   KEY `category` (`category`),
    103   KEY `name` (`name`)
    104 ) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=35467 ;
     86CREATE TABLE IF NOT EXISTS `User` (
     87  `Id` int(11) NOT NULL AUTO_INCREMENT,
     88  `Name` varchar(255) NOT NULL,
     89  `FullName` varchar(255) NOT NULL,
     90  `Password` varchar(255) NOT NULL,
     91  `Salt` varchar(255) NOT NULL,
     92  `Email` varchar(255) NOT NULL,
     93  `RegistrationTime` datetime NOT NULL,
     94  PRIMARY KEY (`Id`)
     95) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
     96
     97-- --------------------------------------------------------
     98
     99--
     100-- Struktura tabulky `UserOnline`
     101--
     102
     103CREATE TABLE IF NOT EXISTS `UserOnline` (
     104  `Id` int(11) NOT NULL AUTO_INCREMENT,
     105  `User` int(11) NOT NULL DEFAULT '0',
     106  `ActivityTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
     107  `LoginTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
     108  `SessionId` varchar(255) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
     109  `IpAddress` varchar(16) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
     110  `HostName` varchar(255) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
     111  `ScriptName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
     112  PRIMARY KEY (`Id`),
     113  KEY `User` (`User`)
     114) ENGINE=MEMORY  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2 ;
     115
     116-- --------------------------------------------------------
     117
     118--
     119-- Struktura tabulky `VPSHosting`
     120--
     121
     122CREATE TABLE IF NOT EXISTS `VPSHosting` (
     123  `Id` int(11) NOT NULL AUTO_INCREMENT,
     124  `Name` varchar(255) NOT NULL,
     125  `Memory` varchar(255) NOT NULL,
     126  `Space` varchar(255) NOT NULL,
     127  `Internet` varchar(255) NOT NULL,
     128  `CPU` varchar(255) NOT NULL,
     129  `Price` int(11) NOT NULL,
     130  PRIMARY KEY (`Id`)
     131) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
     132
     133-- --------------------------------------------------------
     134
     135--
     136-- Struktura tabulky `Webcam`
     137--
     138
     139CREATE TABLE IF NOT EXISTS `Webcam` (
     140  `Id` int(11) NOT NULL AUTO_INCREMENT,
     141  `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
     142  `Description` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
     143  `ImageName` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
     144  `ImageURL` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
     145  `ImagePeriod` int(11) NOT NULL,
     146  `Width` int(11) NOT NULL,
     147  `Height` int(11) NOT NULL,
     148  `Enabled` int(11) NOT NULL DEFAULT '1',
     149  `DeviceType` varchar(255) NOT NULL,
     150  PRIMARY KEY (`Id`)
     151) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
Note: See TracChangeset for help on using the changeset viewer.