[[PSSdev/WebDB]] * area [#ebb52b1b] 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 [#f4c48ba0] INSERT INTO user_info (uid,name,last_login,mail,password,area_id,gender,birth) VALUES (0,'管理者',0,'hiroaki@v7.com','<管理者パスワード>',0,0,0); * genre [#zdac1001] INSERT INTO genre (id,name) VALUES (0,'英語'); * element_info [#l7e9b039] 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 [#lc5510d7] 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;