Changeset 339 for trunk/sql/full.sql


Ignore:
Timestamp:
Jan 10, 2012, 10:26:53 AM (13 years ago)
Author:
chronos
Message:
  • Aktualizace souboru se strukturou databáze.
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/sql/full.sql

    r318 r339  
    11-- phpMyAdmin SQL Dump
    2 -- version 3.4.3.1
     2-- version 3.4.4
    33-- http://www.phpmyadmin.net
    44--
    55-- Počítač: localhost
    6 -- Vygenerováno: Pon 01. srp 2011, 19:43
    7 -- Verze MySQL: 5.1.56
    8 -- Verze PHP: 5.3.6
     6-- Vygenerováno: Úte 10. led 2012, 10:14
     7-- Verze MySQL: 5.1.58
     8-- Verze PHP: 5.3.8
    99
    1010SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
    1111SET time_zone = "+00:00";
     12
     13
     14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
     15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
     16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
     17/*!40101 SET NAMES utf8 */;
    1218
    1319--
     
    7177  KEY `DocumentLine` (`DocumentLine`),
    7278  KEY `FinanceYear` (`FinanceYear`)
    73 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=19 ;
     79) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=25 ;
    7480
    7581-- --------------------------------------------------------
     
    8995  PRIMARY KEY (`Id`),
    9096  KEY `Archive` (`Archive`)
    91 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1631 ;
     97) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2107 ;
    9298
    9399-- --------------------------------------------------------
     
    130136  `Comment` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    131137  PRIMARY KEY (`Id`)
    132 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2 ;
     138) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ;
    133139
    134140-- --------------------------------------------------------
     
    164170  KEY `Subject` (`Subject`),
    165171  KEY `Subject_2` (`Subject`)
    166 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4362 ;
     172) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4957 ;
    167173
    168174-- --------------------------------------------------------
     
    180186  PRIMARY KEY (`Id`),
    181187  KEY `Bill` (`Bill`)
    182 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=15903 ;
     188) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=16498 ;
    183189
    184190-- --------------------------------------------------------
     
    201207  KEY `Subject` (`Subject`),
    202208  KEY `Bill` (`Bill`)
    203 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6805 ;
     209) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=7430 ;
    204210
    205211-- --------------------------------------------------------
     
    236242  KEY `Subject` (`Subject`),
    237243  KEY `Bill` (`Bill`)
    238 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5459 ;
     244) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5779 ;
    239245
    240246-- --------------------------------------------------------
     
    263269CREATE TABLE IF NOT EXISTS `FinanceTariff` (
    264270  `Id` int(11) NOT NULL AUTO_INCREMENT,
    265   `Tariff` int(11) NOT NULL DEFAULT '0',
    266   `Period` int(11) NOT NULL DEFAULT '0',
    267271  `Name` varchar(32) COLLATE utf8_czech_ci NOT NULL,
    268272  `Group` int(11) NOT NULL DEFAULT '0',
     
    272276  `Price` int(11) NOT NULL DEFAULT '0',
    273277  `MemberCount` int(11) NOT NULL DEFAULT '0',
    274   PRIMARY KEY (`Id`),
    275   KEY `Tariff` (`Tariff`)
    276 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=288 ;
     278  `ReplaceId` int(11) DEFAULT NULL,
     279  `Public` int(11) NOT NULL DEFAULT '1',
     280  PRIMARY KEY (`Id`),
     281  KEY `ReplaceId` (`ReplaceId`),
     282  KEY `Public` (`Public`)
     283) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14 ;
    277284
    278285-- --------------------------------------------------------
     
    288295  `DateEnd` date NOT NULL,
    289296  PRIMARY KEY (`Id`)
    290 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=7 ;
     297) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ;
    291298
    292299-- --------------------------------------------------------
     
    340347  `investment` int(11) NOT NULL,
    341348  PRIMARY KEY (`id`)
    342 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=103 ;
     349) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=109 ;
    343350
    344351-- --------------------------------------------------------
     
    478485  KEY `BillingPeriod` (`BillingPeriod`),
    479486  KEY `BillingPeriodNext` (`BillingPeriodNext`)
    480 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=162 ;
     487) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=177 ;
    481488
    482489-- --------------------------------------------------------
     
    497504  PRIMARY KEY (`Id`),
    498505  KEY `Member` (`Member`)
    499 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=145 ;
     506) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=161 ;
    500507
    501508-- --------------------------------------------------------
     
    513520  PRIMARY KEY (`Id`),
    514521  KEY `NetworkDevice` (`NetworkDevice`)
    515 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=43 ;
     522) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=44 ;
    516523
    517524-- --------------------------------------------------------
     
    558565  KEY `Location` (`Location`),
    559566  KEY `Type` (`Type`)
    560 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=590 ;
     567) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=604 ;
    561568
    562569-- --------------------------------------------------------
     
    602609  `Comment` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    603610  PRIMARY KEY (`Id`)
    604 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=32 ;
     611) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=35 ;
    605612
    606613-- --------------------------------------------------------
     
    645652  KEY `Device` (`Device`),
    646653  KEY `Type` (`Type`)
    647 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=649 ;
     654) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=667 ;
    648655
    649656-- --------------------------------------------------------
     
    720727  PRIMARY KEY (`Id`),
    721728  KEY `AddressRange` (`AddressRange`)
    722 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=126 ;
     729) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=144 ;
    723730
    724731-- --------------------------------------------------------
     
    733740  PRIMARY KEY (`Id`),
    734741  KEY `Comment` (`Comment`)
    735 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1189 ;
     742) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1278 ;
    736743
    737744-- --------------------------------------------------------
     
    756763  `ExtMask` int(11) NOT NULL DEFAULT '32',
    757764  `AddressRangeIPv6` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    758   PRIMARY KEY (`Id`),
    759   KEY `Member` (`Member`)
    760 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=39 ;
     765  `Configure` int(11) NOT NULL DEFAULT '1',
     766  PRIMARY KEY (`Id`),
     767  KEY `Member` (`Member`),
     768  KEY `Configure` (`Configure`)
     769) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=41 ;
    761770
    762771-- --------------------------------------------------------
     
    827836  KEY `Title` (`Title`),
    828837  KEY `Link` (`Link`)
    829 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=34316 ;
     838) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=34573 ;
    830839
    831840-- --------------------------------------------------------
     
    9911000  `Note` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    9921001  PRIMARY KEY (`Id`)
    993 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=182 ;
     1002) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=203 ;
    9941003
    9951004-- --------------------------------------------------------
     
    10681077  UNIQUE KEY `Nick` (`Name`),
    10691078  KEY `Member` (`Member`)
    1070 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=207 ;
     1079) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=222 ;
    10711080
    10721081-- --------------------------------------------------------
     
    10871096  PRIMARY KEY (`Id`),
    10881097  KEY `User` (`User`)
    1089 ) ENGINE=MEMORY  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2236 ;
     1098) ENGINE=MEMORY  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8430 ;
    10901099
    10911100--
     
    11411150--
    11421151ALTER TABLE `Member`
    1143   ADD CONSTRAINT `Member_ibfk_10` FOREIGN KEY (`InternetTariffNextMonth`) REFERENCES `FinanceTariff` (`Tariff`),
    1144   ADD CONSTRAINT `Member_ibfk_11` FOREIGN KEY (`BillingPeriod`) REFERENCES `FinanceBillingPeriod` (`Id`),
    1145   ADD CONSTRAINT `Member_ibfk_12` FOREIGN KEY (`BillingPeriodNext`) REFERENCES `FinanceBillingPeriod` (`Id`),
    1146   ADD CONSTRAINT `Member_ibfk_7` FOREIGN KEY (`Subject`) REFERENCES `Subject` (`Id`),
    1147   ADD CONSTRAINT `Member_ibfk_8` FOREIGN KEY (`ResponsibleUser`) REFERENCES `User` (`Id`),
    1148   ADD CONSTRAINT `Member_ibfk_9` FOREIGN KEY (`InternetTariffCurrentMonth`) REFERENCES `FinanceTariff` (`Tariff`);
     1152  ADD CONSTRAINT `Member_ibfk_28` FOREIGN KEY (`BillingPeriodNext`) REFERENCES `FinanceBillingPeriod` (`Id`),
     1153  ADD CONSTRAINT `Member_ibfk_23` FOREIGN KEY (`Subject`) REFERENCES `Subject` (`Id`),
     1154  ADD CONSTRAINT `Member_ibfk_24` FOREIGN KEY (`ResponsibleUser`) REFERENCES `User` (`Id`),
     1155  ADD CONSTRAINT `Member_ibfk_25` FOREIGN KEY (`InternetTariffCurrentMonth`) REFERENCES `FinanceTariff` (`Id`),
     1156  ADD CONSTRAINT `Member_ibfk_26` FOREIGN KEY (`InternetTariffNextMonth`) REFERENCES `FinanceTariff` (`Id`),
     1157  ADD CONSTRAINT `Member_ibfk_27` FOREIGN KEY (`BillingPeriod`) REFERENCES `FinanceBillingPeriod` (`Id`);
    11491158
    11501159--
     
    12221231ALTER TABLE `User`
    12231232  ADD CONSTRAINT `User_ibfk_1` FOREIGN KEY (`Member`) REFERENCES `Member` (`Id`);
     1233
     1234/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
     1235/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
     1236/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Note: See TracChangeset for help on using the changeset viewer.