Changeset 11460 for branches/dev/html/install/sql/insert_data.sql
- Timestamp:
- 2007/02/28 16:17:07 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/html/install/sql/insert_data.sql
r24 r11460 23 23 update dtb_pagelayout set page_id = 0 where page_id = 5; 24 24 25 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'category'),2,'category');26 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'guide'),3,'guide');27 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'cart'),1,'cart');28 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,3, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'search_products'),2,'search_products');29 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,4, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'news'),1,'news');30 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,3, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'login'),1,'login');31 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,4, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'best5'),2,'best5');32 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'category'),2,'category');33 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'guide'),3,'guide');34 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'cart'),1,'cart');35 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'search_products'),0,'search_products');36 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'news'),0,'news');37 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'login'),0,'login');38 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'best5'),0,'best5');39 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'category'),2,'category');40 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'guide'),3,'guide');41 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'cart'),1,'cart');42 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'search_products'),0,'search_products');43 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'news'),0,'news');44 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'login'),0,'login');45 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5, (SELECT bloc_id FROM dtb_bloc WHERE filename = 'best5'),0,'best5');25 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,1,2,'category'); 26 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,2,3,'guide'); 27 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,3,1,'cart'); 28 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,3,4,2,'search_products'); 29 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,4,5,1,'news'); 30 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,3,6,1,'login'); 31 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,4,7,2,'best5'); 32 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,1,2,'category'); 33 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,2,3,'guide'); 34 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,3,1,'cart'); 35 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,4,0,'search_products'); 36 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,5,0,'news'); 37 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,6,0,'login'); 38 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,7,0,'best5'); 39 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,1,2,'category'); 40 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,2,3,'guide'); 41 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,3,1,'cart'); 42 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,4,0,'search_products'); 43 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,5,0,'news'); 44 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,6,0,'login'); 45 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,7,0,'best5'); 46 46 47 47 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.