PSSdev/WebDB

area

INSERT INTO area (id,name) VALUES (0,'北海道');
INSERT INTO area (id,name) VALUES (1,'東京');
INSERT INTO area (id,name) VALUES (2,'青森');
INSERT INTO area (id,name) VALUES (3,'岩手');
INSERT INTO area (id,name) VALUES (4,'宮城');
INSERT INTO area (id,name) VALUES (5,'秋田');
INSERT INTO area (id,name) VALUES (6,'山形');
INSERT INTO area (id,name) VALUES (7,'福島');
INSERT INTO area (id,name) VALUES (8,'茨城');
INSERT INTO area (id,name) VALUES (9,'栃木');
INSERT INTO area (id,name) VALUES (10,'群馬');
INSERT INTO area (id,name) VALUES (11,'埼玉');
INSERT INTO area (id,name) VALUES (12,'千葉');
INSERT INTO area (id,name) VALUES (13,'神奈川');
INSERT INTO area (id,name) VALUES (14,'新潟');
INSERT INTO area (id,name) VALUES (15,'富山');
INSERT INTO area (id,name) VALUES (16,'石川');
INSERT INTO area (id,name) VALUES (17,'福井');
INSERT INTO area (id,name) VALUES (18,'山梨');
INSERT INTO area (id,name) VALUES (19,'長野');
INSERT INTO area (id,name) VALUES (20,'岐阜');
INSERT INTO area (id,name) VALUES (21,'静岡');
INSERT INTO area (id,name) VALUES (22,'愛知');
INSERT INTO area (id,name) VALUES (23,'三重');
INSERT INTO area (id,name) VALUES (24,'滋賀');
INSERT INTO area (id,name) VALUES (25,'京都');
INSERT INTO area (id,name) VALUES (26,'大阪');
INSERT INTO area (id,name) VALUES (27,'兵庫');
INSERT INTO area (id,name) VALUES (28,'奈良');
INSERT INTO area (id,name) VALUES (29,'和歌山');
INSERT INTO area (id,name) VALUES (30,'鳥取');
INSERT INTO area (id,name) VALUES (31,'島根');
INSERT INTO area (id,name) VALUES (32,'岡山');
INSERT INTO area (id,name) VALUES (33,'広島');
INSERT INTO area (id,name) VALUES (34,'山口');
INSERT INTO area (id,name) VALUES (35,'徳島');
INSERT INTO area (id,name) VALUES (36,'香川');
INSERT INTO area (id,name) VALUES (37,'愛媛');
INSERT INTO area (id,name) VALUES (38,'高知');
INSERT INTO area (id,name) VALUES (39,'福岡');
INSERT INTO area (id,name) VALUES (40,'佐賀');
INSERT INTO area (id,name) VALUES (41,'長崎');
INSERT INTO area (id,name) VALUES (42,'熊本');
INSERT INTO area (id,name) VALUES (43,'大分');
INSERT INTO area (id,name) VALUES (44,'宮崎');
INSERT INTO area (id,name) VALUES (45,'鹿児島');
INSERT INTO area (id,name) VALUES (46,'沖縄');
INSERT INTO area (id,name) VALUES (47,'海外');

user_info

INSERT INTO user_info (uid,name,last_login,mail,password,area_id,gender,birth)
 VALUES (0,'管理者',0,'hiroaki@v7.com','<管理者パスワード>',0,0,0);

genre

INSERT INTO genre (id,name) VALUES (0,'英語');

element_info

INSERT INTO element_info ( eid, type, genre, name, author,
 writer, description, ctime, utime, c_user, u_user, open )
 VALUES ( 0, 0, 0, 'ROOT', '', '', 'ルートフォルダ', 0, 0, 0, 0, TRUE )

sequences

CREATE SEQUENCE user_id_seq;
CREATE SEQUENCE area_id_seq;
CREATE SEQUENCE question_id_seq;
CREATE SEQUENCE genre_id_seq;
CREATE SEQUENCE element_id_seq;
CREATE SEQUENCE element_log_id_seq;
CREATE SEQUENCE daily_log_id_seq;
このエントリーをはてなブックマークに追加

トップ   編集 凍結 差分 バックアップ 添付 複製 名前変更 リロード   新規 一覧 単語検索 最終更新   ヘルプ   最終更新のRSS
Last-modified: 2005-04-06 (水) 01:38:41 (5283d)