[postgres@redhat6 postgres]$ psql test < /tmp/phplib-7.2b/stuff/create_database.pgsql
CREATE TABLE active_sessions ( sid varchar(32) DEFAULT '', name varchar(32) DEFAULT '', val text,
changed varchar(14) DEFAULT '' NOT NULL, PRIMARY KEY (sid,name)
);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'active_sessions_pk
ey' for table 'active_sessions'CREATE
CREATE TABLE active_sessions_split ( ct_sid varchar(32) NOT NULL, ct_name varchar(32) NOT NULL,
ct_pos varchar(6) NOT NULL,
ct_val text,
ct_changed varchar(14) DEFAULT '' NOT NULL,
PRIMARY KEY (ct_sid,ct_name,ct_pos)
);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'active_sessions_sp
lit_pkey' for table 'active_sessions_split'
CREATE
CREATE INDEX k_asp_changed ON active_sessions_split USING btree(ct_changed);
CREATE
CREATE TABLE auth_user (
user_id varchar(32) PRIMARY KEY,
username varchar(32) DEFAULT '' NOT NULL,
password varchar(32) DEFAULT '' NOT NULL,
perms varchar(255)
);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'auth_user_pkey' for table 'auth_user'
CREATE
CREATE TABLE auth_user_md5 (
user_id varchar(32) PRIMARY KEY,
username varchar(32) DEFAULT '' NOT NULL,
password varchar(32) DEFAULT '' NOT NULL,
perms varchar(255)
);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'auth_user_md5_pkey
' for table 'auth_user_md5'
CREATE
CREATE UNIQUE INDEX k_username ON auth_user (username);
CREATE
CREATE UNIQUE INDEX k_username_md5 ON auth_user_md5 (username);
CREATE
INSERT INTO auth_user VALUES ('c14cbf141ab1b7cd009356f555b607dc','kris','test','
admin');
INSERT 21902 1
INSERT INTO auth_user_md5 VALUES ('c14cbf141ab1b7cd009356f555b607dc','kris','098
f6bcd4621d373cade4e832627b4f6','admin');
INSERT 21903 1
EOF
[postgres@redhat6 postgres]$
|
Linuxサ−バ ６台のゆくえ
手始めに、サンプルを動かしてみる。
サンプルのServlet,JSP共に動作。Tomcatて、ねこの名前なのですね。知りませんでした。
ritsuo@mxy.mesh.ne.jp
