root/alternc-awstats/branches/r0/awstats.sql

Revision 1030, 0.8 kB (checked in by anonymous, 4 years ago)

Initial revision

  • 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 `aws_users` (
12   `uid` int(10) unsigned NOT NULL,
13   `login` varchar(128) NOT NULL,
14   `pass` varchar(32) NOT NULL,
15   PRIMARY KEY (`login`),
16   INDEX (`uid`)
17 ) COMMENT = 'Comptes pouvant accéder aux stats awstats.';
18
19 # --------------------------------------------------------
20 CREATE TABLE `aws_access` (
21 `id` int(10) unsigned NOT NULL,
22 `login` varchar(128) NOT NULL,
23 INDEX (`id`)
24 ) COMMENT = 'Qui peut accéder aux stats awstats ';
25
Note: See TracBrowser for help on using the browser.