source: trunk/sql/structure.sql

Last change on this file was 10, checked in by maron, 12 years ago

připojení do databáze
  • Property svn:executable set to *
File size: 484 bytes
Line 
1--19.6.2012
2
3CREATE TABLE IF NOT EXISTS `User` (
4 `ID` int(11) NOT NULL AUTO_INCREMENT,
5 `Name` varchar(64) NOT NULL,
6 `Pass` text NOT NULL,
7 `Salt` varchar(255) NOT NULL,
8 `LastIP` text NOT NULL,
9 `LastLogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
10 `LastLogout` datetime DEFAULT NULL,
11 `Email` text NOT NULL,
12 `RegistrationTime` datetime DEFAULT NULL,
13 PRIMARY KEY (`ID`),
14 UNIQUE KEY `user` (`Name`)
15) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
Note: See TracBrowser for help on using the repository browser.