| 1 | --- |
|---|
| 2 | -- Create folders for PhtoFolder test |
|---|
| 3 | --- |
|---|
| 4 | |
|---|
| 5 | delete from photo_collections; |
|---|
| 6 | insert into photo_collections (collection_id, parent, collection_name, collection_desc, create_time, last_modified) values (1, null, 'Top', '', NULL, null); |
|---|
| 7 | insert into photo_collections (collection_id, parent, collection_name, collection_desc, create_time, last_modified) values ( 100, 1, 'subfolderTest', '', NULL, null); |
|---|
| 8 | insert into photo_collections (collection_id, parent, collection_name, collection_desc, create_time, last_modified) values ( 101, 100, 'Subfolder1', '', NULL, null); |
|---|
| 9 | insert into photo_collections (collection_id, parent, collection_name, collection_desc, create_time, last_modified) values ( 102, 100, 'Subfolder2', '', NULL, null); |
|---|
| 10 | insert into photo_collections (collection_id, parent, collection_name, collection_desc, create_time, last_modified) values ( 103, 100, 'Subfolder3', '', NULL, null); |
|---|
| 11 | insert into photo_collections (collection_id, parent, collection_name, collection_desc, create_time, last_modified) values ( 104, 100, 'Subfolder4', '', NULL, null); |
|---|
| 12 | insert into photo_collections (collection_id, parent, collection_name, collection_desc, create_time, last_modified) values ( 105, 1, 'testPhotoRetrieval', '', NULL, null); |
|---|
| 13 | |
|---|
| 14 | delete from photos; |
|---|
| 15 | insert into photos(photo_id, description) values( 1, 'testPhoto1' ); |
|---|
| 16 | insert into photos(photo_id, description) values( 2, 'testPhotoRetrieval1' ); |
|---|
| 17 | insert into photos(photo_id, description) values( 3, 'testPhotoRetrieval2' ); |
|---|
| 18 | |
|---|
| 19 | delete from collection_photos; |
|---|
| 20 | insert into collection_photos (collection_id, photo_id) values( 105, 2 ); |
|---|
| 21 | insert into collection_photos (collection_id, photo_id) values( 105, 3 ); |
|---|
