|
Revision 1377, 405 bytes
(checked in by anarcat, 4 years ago)
|
rendre "idempotent": ne pas creer de table si elle existe deja
|
- Property svn:eol-style set to
native
- Property svn:keywords set to
Author Date Id Revision
|
| Line | |
|---|
| 1 |
CREATE TABLE IF NOT EXISTS `stat_http` ( |
|---|
| 2 |
`uid` int(10) unsigned NOT NULL default '0', |
|---|
| 3 |
`day` date NOT NULL default '0000-00-00', |
|---|
| 4 |
`domain` varchar(255) NOT NULL default '', |
|---|
| 5 |
`hit` int(10) unsigned NOT NULL default '0', |
|---|
| 6 |
`size` int(10) unsigned NOT NULL default '0', |
|---|
| 7 |
PRIMARY KEY (`day`,`domain`), |
|---|
| 8 |
KEY `uid` (`uid`), |
|---|
| 9 |
KEY `day` (`day`) |
|---|
| 10 |
) TYPE=MyISAM COMMENT='Hits and bandwith used by domains'; |
|---|
