Changeset 18206 for branches/comu-ver2
- Timestamp:
- 2009/07/18 20:32:58 (15 years ago)
- Location:
- branches/comu-ver2/html/install/sql
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/comu-ver2/html/install/sql/create_table_mysql.sql
r18190 r18206 902 902 bloc_row int, 903 903 filename text, 904 anywhere int 904 anywhere int DEFAULT 0 NOT NULL 905 905 ) TYPE=InnoDB ; 906 906 -
branches/comu-ver2/html/install/sql/create_table_pgsql.sql
r18190 r18206 930 930 bloc_row int4, 931 931 filename text, 932 anywhere int2 932 anywhere int2 DEFAULT 0 NOT NULL 933 933 ); 934 934 -
branches/comu-ver2/html/install/sql/insert_data.sql
r18204 r18206 24 24 update dtb_pagelayout set page_id = 0 where page_id = 5; 25 25 26 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (1,1,1,2,'category',0);27 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (1,1,2,3,'guide',0);28 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (1,1,3,1,'cart',0);29 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (1,3,4,2,'search_products',0);30 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (1,4,5,1,'news',0);31 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (1,3,6,1,'login',0);32 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (1,4,7,2,'best5',0);33 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (2,1,1,2,'category',0);34 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (2,1,2,3,'guide',0);35 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (2,1,3,1,'cart',0);36 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (2,10,4,0,'search_products',0);37 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (2,10,5,0,'news',0);38 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (2,10,6,0,'login',0);39 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (2,10,7,0,'best5',0);40 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (3,1,1,2,'category',0);41 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (3,1,2,3,'guide',0);42 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (3,1,3,1,'cart',0);43 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (3,10,4,0,'search_products',0);44 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (3,10,5,0,'news',0);45 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (3,10,6,0,'login',0);46 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ,anywhere) VALUES (3,10,7,0,'best5',0);26 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (1,1,1,2,'category'); 27 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (1,1,2,3,'guide'); 28 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (1,1,3,1,'cart'); 29 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (1,3,4,2,'search_products'); 30 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (1,4,5,1,'news'); 31 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (1,3,6,1,'login'); 32 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (1,4,7,2,'best5'); 33 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (2,1,1,2,'category'); 34 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (2,1,2,3,'guide'); 35 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (2,1,3,1,'cart'); 36 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (2,10,4,0,'search_products'); 37 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (2,10,5,0,'news'); 38 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (2,10,6,0,'login'); 39 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (2,10,7,0,'best5'); 40 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (3,1,1,2,'category'); 41 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (3,1,2,3,'guide'); 42 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (3,1,3,1,'cart'); 43 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (3,10,4,0,'search_products'); 44 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (3,10,5,0,'news'); 45 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (3,10,6,0,'login'); 46 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (3,10,7,0,'best5'); 47 47 48 48 INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (1,'product_id','商品ID',1,now(),now());
Note: See TracChangeset
for help on using the changeset viewer.