Changeset 181 for trunk/sql/full.sql

Timestamp:

Mar 24, 2009, 10:49:59 PM (16 years ago)

Author:

george

Message:

• Přidáno: Nastavení telefóního čísla a ICQ uživatele.
• Opraveno: Nelogovat odhlášení anonymního uživatele.

File:

• trunk/sql/full.sql (modified) (12 diffs)

trunk/sql/full.sql

@@ -4 +4 @@
 --
 -- Počítač: localhost
--- Vygenerováno: Úterý 24. března 2009, 13:43
+-- Vygenerováno: Úterý 24. března 2009, 22:51
 -- Verze MySQL: 5.0.51
 -- Verze PHP: 5.2.6
@@ -147 +147 @@
   `Text` varchar(255) collate utf8_czech_ci NOT NULL default '',
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4182 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4183 ;
 
 -- --------------------------------------------------------
@@ -254 +254 @@
 
 --
--- Struktura tabulky `finance_operations`
---
-
-CREATE TABLE IF NOT EXISTS `finance_operations` (
+-- Struktura tabulky `finance_operations_old`
+--
+
+CREATE TABLE IF NOT EXISTS `finance_operations_old` (
   `id` int(11) NOT NULL auto_increment,
   `user` int(11) NOT NULL default '0',
@@ -321 +321 @@
   `used` int(11) NOT NULL default '1',
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=347 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=348 ;
 
 -- --------------------------------------------------------
@@ -448 +448 @@
   `NetworkSegment` int(11) NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=98 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=99 ;
 
 -- --------------------------------------------------------
@@ -466 +466 @@
   `Cash` float NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=83 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=84 ;
 
 -- --------------------------------------------------------
@@ -580 +580 @@
   `date` datetime NOT NULL default '0000-00-00 00:00:00',
   `target_date` datetime NOT NULL default '0000-00-00 00:00:00',
-  `author` varchar(32) collate utf8_czech_ci NOT NULL default 'Anonym',
+  `author` varchar(32) collate utf8_czech_ci NOT NULL default '',
   `ip` varchar(16) collate utf8_czech_ci NOT NULL default '',
   `category` int(11) NOT NULL default '0',
@@ -588 +588 @@
   KEY `category` (`category`),
   KEY `date` (`date`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=30854 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=30855 ;
 
 -- --------------------------------------------------------
@@ -716 +716 @@
   `WWW` varchar(255) collate utf8_czech_ci NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=105 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=106 ;
 
 -- --------------------------------------------------------
@@ -822 +822 @@
   `SecondName` varchar(128) collate utf8_czech_ci NOT NULL default '',
   `Nick` varchar(128) collate utf8_czech_ci NOT NULL default '',
-  `Password` text collate utf8_czech_ci NOT NULL,
+  `Password` varchar(255) collate utf8_czech_ci NOT NULL,
   `Email` varchar(128) collate utf8_czech_ci NOT NULL default '',
   `LastIpAddress` varchar(16) collate utf8_czech_ci NOT NULL default '',
@@ -828 +828 @@
   `RegistrationTime` datetime NOT NULL default '0000-00-00 00:00:00',
   `Member` int(11) NOT NULL,
-  `Locked` tinyint(1) NOT NULL default '1',
+  `Locked` tinyint(1) NOT NULL default '0',
   `ICQ` int(11) NOT NULL default '0',
   `PhoneNumber` varchar(32) collate utf8_czech_ci NOT NULL default '',
   `InitPassword` varchar(255) collate utf8_czech_ci NOT NULL,
-  PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=99 ;
+  PRIMARY KEY  (`Id`),
+  UNIQUE KEY `Name` (`Name`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=104 ;
 
 -- --------------------------------------------------------
@@ -852 +853 @@
   PRIMARY KEY  (`Id`),
   KEY `User` (`User`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=299 ;
 
 -- --------------------------------------------------------