Changeset 18190 for branches/comu-ver2/html
- Timestamp:
- 2009/07/15 14:39:49 (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
r18069 r18190 901 901 bloc_id int, 902 902 bloc_row int, 903 filename text 903 filename text, 904 anywhere int 904 905 ) TYPE=InnoDB ; 905 906 -
branches/comu-ver2/html/install/sql/create_table_pgsql.sql
r18023 r18190 929 929 bloc_id int4, 930 930 bloc_row int4, 931 filename text 931 filename text, 932 anywhere int2 932 933 ); 933 934 -
branches/comu-ver2/html/install/sql/insert_data.sql
r18189 r18190 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 ) 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,7,4,0,'search_products');37 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ) VALUES (2,7,5,0,'news');38 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ) VALUES (2,7,6,0,'login');39 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ) VALUES (2,7,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,7,4,0,'search_products');44 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ) VALUES (3,7,5,0,'news');45 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ) VALUES (3,7,6,0,'login');46 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename ) VALUES (3,7,7,0,'best5');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,7,4,0,'search_products',0); 37 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename,anywhere) VALUES (2,7,5,0,'news',0); 38 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename,anywhere) VALUES (2,7,6,0,'login',0); 39 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename,anywhere) VALUES (2,7,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,7,4,0,'search_products',0); 44 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename,anywhere) VALUES (3,7,5,0,'news',0); 45 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename,anywhere) VALUES (3,7,6,0,'login',0); 46 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename,anywhere) VALUES (3,7,7,0,'best5',0); 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.