[[PSSdev/WebDB]]

* area
* area [#l80a9ed1]

 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
* user_info [#t524df0f]

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

* genre
* genre [#n77995a9]

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

* element_info
* element_info [#s62d88f1]
 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
* sequences [#dc347f05]

 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