Skip to content

Instantly share code, notes, and snippets.

Avatar

Isao Sugimoto d6rkaiz

View GitHub Profile
@d6rkaiz
d6rkaiz / gist:873974
Created Mar 17, 2011
SHOW CREATE TABLE location;
View gist:873974
| location | CREATE TABLE `location` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`location_name` varchar(255) DEFAULT NULL,
`country_id` int(11) DEFAULT NULL,
`latitude` double NOT NULL DEFAULT '0',
`longitude` double NOT NULL DEFAULT '0',
`location_visible` tinyint(4) NOT NULL DEFAULT '1',
`location_date` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3877 DEFAULT CHARSET=utf8 |
@d6rkaiz
d6rkaiz / apache2
Created Mar 18, 2011
apache2.conf
View apache2
#
# Based upon the NCSA server configuration files originally by Rob McCool.
#
# This is the main Apache server configuration file. It contains the
# configuration directives that give the server its instructions.
# See http://httpd.apache.org/docs/2.2/ for detailed information about
# the directives.
#
# Do NOT simply read the instructions in here without understanding
# what they do. They're here only as hints or reminders. If you are unsure
View php5
[PHP]
;;;;;;;;;;;;;;;;;;;
; About php.ini ;
;;;;;;;;;;;;;;;;;;;
; PHP's initialization file, generally called php.ini, is responsible for
; configuring many of the aspects of PHP's behavior.
; PHP attempts to find and load this configuration from a number of locations.
; The following is a summary of its search order:
@d6rkaiz
d6rkaiz / gist:879050
Created Mar 21, 2011
Lingrマニュアル(草案)
View gist:879050
Lingr chatの機能の説明
設定画面
Settings
Account
ユーザのアカウント情報を設定します。
Facebook以外からサインアップしたばかりの時は、Display name、Profileは設定されていません。
View gist:880481
set :cron, false
(ENV["SINSAI_TO"]||"").split(/,/).each do |e|
case e
when "cronsv"
role :app,"ec2-175-41-222-1.ap-northeast-1.compute.amazonaws.com"
set :cron, true
end
end
View gist:881459
$ sudo -s
# dd if=/dev/zero of=/swap bs=512M count=4
# mkswap /swap
# swapon /swap
freeで確認。
/etc/fstabに以下を追加
/swap swap swap defaults 0 0
View gist:882694
echo "Asia/Tokyo" > /etc/timezone
dpkg-reconfigure -f noninteractive tzdata
@d6rkaiz
d6rkaiz / gist:889992
Created Mar 28, 2011
担当者不在でチケットがNewのままのもの
View gist:889992
>の右は作成者
#148 #234 > Fujisaki
#293 > Hagino3000
#120 #158 #159 #164 #264 #279 > Seki
#244 > kiko hideaki
#182 #242 #243 #287 > Miura
#286 > d6rkaiz
#89 > k oquno
#233 > Ko-hei Ohtsuka
@d6rkaiz
d6rkaiz / gist:892042
Created Mar 29, 2011
d6rkaiz@gmail.pub%publickey
View gist:892042
ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEAzXvGAxHaqRWxIQixkgfCSowh997121hbJEbpP8ObDmBOCDGj5Qq8WqVYg0ynYbqWBcfHHybwf59XIh26DVZvz91S+zyPC/itKlFDIZfF3NEKFzSRRCTUH5IF7il2+zwY84zTxu9HXl1G0PRz79ZYZKjqXttrbSLVMMGVDFIEiZ1cJj8di76Zb36UAwh5KqBe6DZx6h86Bf/ylec5/p8ZguKqHRIUWYFAmnLTf9+vK62CIKFXOF8Wmgt3Dslx2o5UMyg1f9M/oDCAClJ1BNeJUdVLxHa8o5V82VjdgWHE2q7if0NNxK6AtPZl1OviiNzQiDIL7k5jhn41jXb0MITxSQ== d6rkaiz@gmail.com