SVN追加
cd /home/svn/
svnadmin create ./idg-front
svn mkdir file:///home/svn/idg-front/trunk file:///home/svn/idg-front/tags file:///home/svn/idg-front/branches -m 'Create trunk, tags, and branches.'
chown -R apache.apache ./idg-front
http://210.188.220.108/repos/idg-front/
//ユーザを追加する場合
htpasswd ./dav_svn.passwd idg-developer
GION
select date_format(create_date,'%y/%m/') dates, count(*) id from access_log group by dates order by dates;
SELECT create_date FROM access_log WHERE TO_DAYS(NOW()) - TO_DAYS(create_date) <= 30 GROUP BY create_date;
SELECT COUNT(*) FROM access_log where create_date <= (select date_add(now(), interval -2 month));
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- +
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
dates | id |
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- +
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
07/07/ | 7116 |
07/08/ | 34110 |
07/09/ | 40857 |
07/10/ | 39434 |
07/11/ | 36044 |
07/12/ | 34245 |
08/01/ | 33229 |
08/02/ | 7057 |
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- +
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
ページを開くのにかかる時間42s
Total:232,091
htpasswdコマンド
usr/bin/htpasswd ./dav_svn.passwd idg-developer
hidemaru
(name=")[a-z0-9_]+(")