|
Revision 1791, 1.0 kB
(checked in by engelaere, 2 years ago)
|
--
|
- Property svn:eol-style set to
native
- Property svn:keywords set to
Author Date Id Revision
|
| Line | |
|---|
| 1 |
# -------------------------------------------------------- |
|---|
| 2 |
CREATE TABLE IF NOT EXISTS `aws` ( |
|---|
| 3 |
`id` int(10) unsigned NOT NULL auto_increment, |
|---|
| 4 |
`uid` int(10) unsigned NOT NULL default '0', |
|---|
| 5 |
`hostname` varchar(255) NOT NULL default '', |
|---|
| 6 |
PRIMARY KEY (`id`) |
|---|
| 7 |
) TYPE=MyISAM COMMENT='Statistiques web par Awstats'; |
|---|
| 8 |
|
|---|
| 9 |
|
|---|
| 10 |
# -------------------------------------------------------- |
|---|
| 11 |
CREATE TABLE IF NOT EXISTS `aws_users` ( |
|---|
| 12 |
`uid` int(10) unsigned NOT NULL, |
|---|
| 13 |
`login` varchar(128) NOT NULL, |
|---|
| 14 |
`pass` varchar(38) NOT NULL, |
|---|
| 15 |
PRIMARY KEY (`login`), |
|---|
| 16 |
INDEX (`uid`) |
|---|
| 17 |
) COMMENT = 'Comptes pouvant accéder aux stats awstats.'; |
|---|
| 18 |
|
|---|
| 19 |
# -------------------------------------------------------- |
|---|
| 20 |
CREATE TABLE IF NOT EXISTS `aws_access` ( |
|---|
| 21 |
`id` int(10) unsigned NOT NULL, |
|---|
| 22 |
`uid` int(10) unsigned NOT NULL, |
|---|
| 23 |
`login` varchar(128) NOT NULL, |
|---|
| 24 |
INDEX (`id`) |
|---|
| 25 |
) COMMENT = 'Qui peut accéder aux stats awstats '; |
|---|
| 26 |
|
|---|
| 27 |
ALTER TABLE `aws` ADD `public` INT(1) unsigned NOT NULL DEFAULT '1'; |
|---|
| 28 |
ALTER TABLE `aws` ADD `hostaliases` TEXT ; |
|---|
