PSSdev/WebDB/テーブルの初期値
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
[[PSSdev/WebDB]]
* 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 [#t524df0f]
INSERT INTO user_info (uid,name,last_login,mail,password...
VALUES (0,'管理者',0,'hiroaki@v7.com','<管理者パスワー...
* genre [#n77995a9]
INSERT INTO genre (id,name) VALUES (0,'英語');
* 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, ...
* 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;
終了行:
[[PSSdev/WebDB]]
* 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 [#t524df0f]
INSERT INTO user_info (uid,name,last_login,mail,password...
VALUES (0,'管理者',0,'hiroaki@v7.com','<管理者パスワー...
* genre [#n77995a9]
INSERT INTO genre (id,name) VALUES (0,'英語');
* 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, ...
* 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;
ページ名: