-- User [User] create table [dbo].[USER] ( [OID] int not null, [USERNAME] varchar(255), [PASSWORD] varchar(255), [EMAIL] varchar(255), primary key ([OID]) ); -- Group [Group] create table [dbo].[GROUP] ( [OID] int not null, [GROUPNAME] varchar(255), primary key ([OID]) ); -- Module [Module] create table [dbo].[MODULE] ( [OID] int not null, [MODULEID] varchar(255), [MODULENAME] varchar(255), primary key ([OID]) ); -- Product [ent1] create table [dbo].[PRODUCT] ( [OID] int not null, [CODE] int, [DESCRIPTION] text, [NAME] varchar(255), [PRICE] double precision, [THUMBNAIL] varchar(255), [HIGHLIGHTED] tinyint, primary key ([OID]) ); -- TechRecord [ent2] create table [dbo].[TECHRECORD] ( [OID] int not null, [COLORS] varchar(255), [DIMENSIONS] varchar(255), primary key ([OID]) ); -- BigImage [ent3] create table [dbo].[BIGIMAGE] ( [OID] int not null, [DESCRIPTION] text, [PICTURE] varchar(255), primary key ([OID]) ); -- Combination [ent4] create table [dbo].[COMBINATION] ( [OID] int not null, [CODE] int, [DESCRIPTION] text, [NAME] varchar(255), [PRICE] double precision, [PHOTO] varchar(255), [START_DATE] datetime, [END_DATE] datetime, [HIGHLIGHTED] tinyint, primary key ([OID]) ); -- Store [ent5] create table [dbo].[STORE] ( [OID] int not null, [ADDRESS] varchar(255), [EMAIL] varchar(255), [MAP] varchar(255), [PHOTO] varchar(255), primary key ([OID]) ); -- Category [ent6] create table [dbo].[CATEGORY] ( [OID] int not null, [CATEGORY] varchar(255), primary key ([OID]) ); -- User_Group [User2Group_Group2User] create table [dbo].[USER_GROUP] ( [USER_OID] int, [GROUP_OID] int, primary key ([USER_OID], [GROUP_OID]) ); alter table [dbo].[USER_GROUP] add constraint FK_USER_GROUP_USER foreign key ([USER_OID]) references [dbo].[USER] ([OID]); alter table [dbo].[USER_GROUP] add constraint FK_USER_GROUP_GROUP foreign key ([GROUP_OID]) references [dbo].[GROUP] ([OID]); -- User_DefaultGroup [User2DefaultGroup_DefaultGroup2User] alter table [dbo].[USER] ADD [GROUP_OID] int; alter table [dbo].[USER] add constraint FK_GROUP foreign key ([GROUP_OID]) references [dbo].[GROUP] ([OID]); -- Group_DefaultModule [Group2DefaultModule_DefaultModule2Group] alter table [dbo].[GROUP] ADD [MODULE_OID] int; alter table [dbo].[GROUP] add constraint FK_MODULE foreign key ([MODULE_OID]) references [dbo].[MODULE] ([OID]); -- Group_Module [Group2Module_Module2Group] create table [dbo].[GROUP_MODULE] ( [GROUP_OID] int, [MODULE_OID] int, primary key ([GROUP_OID], [MODULE_OID]) ); alter table [dbo].[GROUP_MODULE] add constraint FK_GROUP_MODULE_GROUP foreign key ([GROUP_OID]) references [dbo].[GROUP] ([OID]); alter table [dbo].[GROUP_MODULE] add constraint FK_GROUP_MODULE_MODULE foreign key ([MODULE_OID]) references [dbo].[MODULE] ([OID]); -- Product_Combination [rel1_rel2] create table [dbo].[PRODUCT_COMBINATION] ( [PRODUCT_OID] int, [COMBINATION_OID] int, primary key ([PRODUCT_OID], [COMBINATION_OID]) ); alter table [dbo].[PRODUCT_COMBINATION] add constraint FK_PRODUCT_COMBINATION_PRODUCT foreign key ([PRODUCT_OID]) references [dbo].[PRODUCT] ([OID]); alter table [dbo].[PRODUCT_COMBINATION] add constraint FK_PRODUCT_COMBINATION_COMBINA foreign key ([COMBINATION_OID]) references [dbo].[COMBINATION] ([OID]); -- TechRecord_Product [rel4_rel3] create table [dbo].[TECHRECORD_PRODUCT] ( [PRODUCT_OID] int, [TECHRECORD_OID] int, primary key ([PRODUCT_OID], [TECHRECORD_OID]) ); alter table [dbo].[TECHRECORD_PRODUCT] add constraint FK_TECHRECORD_PRODUCT_PRODUCT foreign key ([PRODUCT_OID]) references [dbo].[PRODUCT] ([OID]); alter table [dbo].[TECHRECORD_PRODUCT] add constraint FK_TECHRECORD_PRODUCT_TECHRECO foreign key ([TECHRECORD_OID]) references [dbo].[TECHRECORD] ([OID]); -- BigImage_Product [rel6_rel5] alter table [dbo].[BIGIMAGE] ADD [PRODUCT_OID] int; alter table [dbo].[BIGIMAGE] add constraint FK_PRODUCT foreign key ([PRODUCT_OID]) references [dbo].[PRODUCT] ([OID]); -- Category_Product [rel8_rel7] alter table [dbo].[PRODUCT] ADD [CATEGORY_OID] int; alter table [dbo].[PRODUCT] add constraint FK_CATEGORY foreign key ([CATEGORY_OID]) references [dbo].[CATEGORY] ([OID]); -- -------- POPULATE DATABASE --------------------------------------------------------------------------------------------- -- ---------- POPUPLATE TABLE `MODULE` ---------- INSERT INTO [dbo]."module" ("oid", "moduleid", "modulename") VALUES (1, 'sv2', 'Acme Administrator'); -- ---------- POPUPLATE TABLE "GROUP" ---------- INSERT INTO [dbo]."group" ("oid", "groupname", "module_oid") VALUES (1, 'manager', 1); -- ---------- POPUPLATE TABLE "USER" ---------- INSERT INTO [dbo]."user" ("oid", "username", "password", "email", "group_oid") VALUES (1, 'manager', 'manager', 'manager@acme.com', 1); -- ---------- POPUPLATE TABLE "USER_GROUP" ---------- INSERT INTO [dbo]."user_group" ("user_oid", "group_oid") VALUES (1, 1); -- ---------- POPUPLATE TABLE "GROUP_MODULE" ---------- INSERT INTO [dbo]."group_module" ("group_oid", "module_oid") VALUES (1, 1); -- ---------- POPUPLATE TABLE "STORE" ---------- INSERT INTO [dbo]."store" ("oid", "address", "email", "map", "photo") VALUES (1, 'Oslo', 'mailto:customer-care@acme.com', 'upload/map_1.jpg', 'upload/location_1.jpg'); INSERT INTO [dbo]."store" ("oid", "address", "email", "map", "photo") VALUES (2, 'Barcelona', 'mailto:customer-care@acme.com', 'upload/map_1.jpg', 'upload/location_1.jpg'); INSERT INTO [dbo]."store" ("oid", "address", "email", "map", "photo") VALUES (3, 'New York', 'mailto:customer-care@acme.com', 'upload/map_1.jpg', 'upload/location_1.jpg'); INSERT INTO [dbo]."store" ("oid", "address", "email", "map", "photo") VALUES (5, 'Montreal', 'mailto:customer-care@acme.com', 'upload/map_1.jpg', 'upload/location_1.jpg'); INSERT INTO [dbo]."store" ("oid", "address", "email", "map", "photo") VALUES (6, 'Hamburg', 'mailto:customer-care@acme.com', 'upload/map_1.jpg', 'upload/location_1.jpg'); INSERT INTO [dbo]."store" ("oid", "address", "email", "map", "photo") VALUES (7, 'Berlin', 'mailto:customer-care@acme.com', 'upload/map_1.jpg', 'upload/location_1.jpg'); INSERT INTO [dbo]."store" ("oid", "address", "email", "map", "photo") VALUES (8, 'Hong Kong', 'mailto:customer-care@acme.com', 'upload/map_1.jpg', 'upload/location_1.jpg'); INSERT INTO [dbo]."store" ("oid", "address", "email", "map", "photo") VALUES (9, 'Madrid', 'mailto:customer-care@acme.com', 'upload/map_1.jpg', 'upload/location_1.jpg'); INSERT INTO [dbo]."store" ("oid", "address", "email", "map", "photo") VALUES (10, 'Copenhagen', 'mailto:customer-care@acme.com', 'upload/map_1.jpg', 'upload/location_1.jpg'); INSERT INTO [dbo]."store" ("oid", "address", "email", "map", "photo") VALUES (11, 'Chicago', 'mailto:customer-care@acme.com', 'upload/map_1.jpg', 'upload/location_1.jpg'); INSERT INTO [dbo]."store" ("oid", "address", "email", "map", "photo") VALUES (12, 'London', 'mailto:customer-care@acme.com', 'upload/map_1.jpg', 'upload/location_1.jpg'); INSERT INTO [dbo]."store" ("oid", "address", "email", "map", "photo") VALUES (13, 'Sidney', 'mailto:customer-care@acme.com', 'upload/map_1.jpg', 'upload/location_1.jpg'); INSERT INTO [dbo]."store" ("oid", "address", "email", "map", "photo") VALUES (15, 'Tokyo', 'mailto:customer-care@acme.com', 'upload/map_1.jpg', 'upload/location_1.jpg'); -- ---------- POPUPLATE TABLE "category" ---------- INSERT INTO [dbo]."category" ("oid", "category") VALUES (1, 'Tables'); INSERT INTO [dbo]."category" ("oid", "category") VALUES (2, 'Chairs'); INSERT INTO [dbo]."category" ("oid", "category") VALUES (3, 'Lamps'); -- ---------- POPUPLATE TABLE "COMBINATION" ---------- INSERT INTO [dbo]."combination" ("oid", "code", "description", "name", "price", "photo", "start_date", "end_date", "highlighted") VALUES (1, 1237, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'Home Bargain', 3000, 'upload/combo_2.jpg', '20070101', '20080101', 1); INSERT INTO [dbo]."combination" ("oid", "code", "description", "name", "price", "photo", "start_date", "end_date", "highlighted") VALUES (2, 9898, 'Make your house a home with the best interior design and the unprecedented quality of our products.', 'Style & Value', 4550, 'upload/combo_1.jpg', '20070205', '20071103', 0); INSERT INTO [dbo]."combination" ("oid", "code", "description", "name", "price", "photo", "start_date", "end_date", "highlighted") VALUES (3, 1237, 'Meet with friends in the comfort of a stylish and functional setting.', 'Pick of the site', 500, 'upload/combo_3.jpg', '20070101', '20080101', 0); INSERT INTO [dbo]."combination" ("oid", "code", "description", "name", "price", "photo", "start_date", "end_date", "highlighted") VALUES (4, 4123, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'Value set', 3500, 'upload/combo_3.jpg', '20070731', '20070709', 0); INSERT INTO [dbo]."combination" ("oid", "code", "description", "name", "price", "photo", "start_date", "end_date", "highlighted") VALUES (5, 1243, 'Make your house a home with the best interior design and the unprecedented quality of our products.', 'Big Bundle', 2000, 'upload/combo_1.jpg', '20070101', '20080101', 0); INSERT INTO [dbo]."combination" ("oid", "code", "description", "name", "price", "photo", "start_date", "end_date", "highlighted") VALUES (6, 6755, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'Special of the day', 500, 'upload/combo_2.jpg', '20070101', '20080101', 0); INSERT INTO [dbo]."combination" ("oid", "code", "description", "name", "price", "photo", "start_date", "end_date", "highlighted") VALUES (7, 9871, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'Christmas Special', 3000, 'upload/combo_5.jpg', '20070306', '20071001', 0); -- ---------- POPUPLATE TABLE "TECHRECORD" ---------- INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (1, 'upload/colors.jpg', '144x34x300'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (2, 'upload/colors.jpg', '144x111x100'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (3, 'upload/colors.jpg', '144x34x300'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (4, 'upload/colors.jpg', '144x34x100'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (5, 'upload/colors.jpg', '144x111x100'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (6, 'upload/colors.jpg', '11x23x23'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (7, 'upload/colors.jpg', '144x23x170'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (8, 'upload/colors.jpg', '144x34x100'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (9, 'upload/colors.jpg', '144x34x150'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (10, 'upload/colors.jpg', '144x34x300'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (11, 'upload/colors.jpg', '144x34x150'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (12, 'upload/colors.jpg', '144x34x150'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (13, 'upload/colors.jpg', '144x111x100'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (14, 'upload/colors.jpg', '144x11x130'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (15, 'upload/colors.jpg', '144x11x130'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (16, 'upload/colors.jpg', '144x111x100'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (17, 'upload/colors.jpg', '144x34x300'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (18, 'upload/colors.jpg', '544x33x100'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (19, 'upload/colors.jpg', '144x111x100'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (20, 'upload/colors.jpg', '144x11x130'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (21, 'upload/colors.jpg', '23x45x67'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (22, 'upload/colors.jpg', '4x5x6'); INSERT INTO [dbo]."techrecord" ("oid", "colors", "dimensions") VALUES (23, 'upload/colors.jpg', '12x34x11'); -- ---------- POPUPLATE TABLE "PRODUCT" ---------- INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (1, 5125, 'Stainless steel meets crystal and silk to make the comfort and look.', 'Wilderness', 1500, 'upload/small_chair_5.jpg', 0, 2); INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (2, 5126, 'The spirit of tradition, renovated by the most modern technologies and design.', 'Pink fantasy', 3500, 'upload/small_table_1.jpg', 0, 1); INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (3, 5127, 'Brighten up your living room with warmly illuminating ideas.', 'Allair', 4550, 'upload/small_chair_2.jpg', 0, 2); INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (4, 6755, 'The spirit of tradition, renovated by the most modern technologies and design.', 'Amplitude', 3000, 'upload/small_chair_2.jpg', 0, 2); INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (5, 8630, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'Baronetto', 3000, 'upload/small_lamp_4.jpg', 0, 3); INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (6, 1243, 'Make your house a home with the best interior design and the unprecedented quality of our products.', 'Atlas', 1000, 'upload/small_table_4.jpg', 0, 1); INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (7, 1237, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'Aladdin', 1500, 'upload/small_table_1.jpg', 1, 1); INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (8, 7145, 'High quality Italian design for relaxing and enjoying life with your family and friends.', 'Silvestream', 1500, 'upload/small_lamp_1.jpg', 0, 3); INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (9, 4678, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'Sara', 500, 'upload/small_lamp_2.jpg', 0, 3); INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (10, 1243, 'Meet with friends in the comfort of a stylish and functional setting.', 'Mambo', 1000, 'upload/small_table_1.jpg', 0, 1); INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (11, 1238, 'Stainless steel meets crystal and silk to make the comfort and look.', 'Euclid', 4550, 'upload/small_table_1.jpg', 0, 1); INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (13, 4680, 'Create your space and make it flexible enough to fit whatever the moment calls for, from meeting friends to enjoying your family.', 'Andros', 1200, 'upload/small_lamp_1.jpg', 0, 3); INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (14, 7148, 'High quality Italian design for relaxing and enjoying life with your family and friends.', 'Byron', 1000, 'upload/small_chair_3.jpg', NULL, 2); INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (16, 1245, 'Create your space and make it flexible enough to fit whatever the moment calls for, from meeting friends to enjoying your family.', 'Landscape', 500, 'upload/small_table_3.jpg', 0, 1); INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (17, 4123, 'The spirit of tradition, renovated by the most modern technologies and design.', 'Rodolfo', 4550, 'upload/small_table_1.jpg', 0, 1); INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (21, 9876, 'A fabulous piece of furniture for relaxing with friends.', 'Lucid', 234, 'upload/small_table_5.jpg', 0, 1); INSERT INTO [dbo]."product" ("oid", "code", "description", "name", "price", "thumbnail", "highlighted", "category_oid") VALUES (22, 3456, 'A marvellous lamp shedding a new light to your family life.', 'Blue Fountain', 124, 'upload/small_lamp_5.jpg', 0, 3); -- ---------- POPUPLATE TABLE "product_combination" ---------- INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (2, 2); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (2, 3); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (2, 5); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (2, 7); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (3, 7); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (4, 3); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (4, 4); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (5, 2); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (5, 6); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (5, 7); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (7, 2); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (7, 3); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (8, 1); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (8, 7); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (9, 4); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (10, 2); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (11, 2); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (11, 3); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (11, 6); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (13, 4); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (13, 5); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (14, 5); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (21, 2); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (21, 5); INSERT INTO [dbo]."product_combination" ("product_oid", "combination_oid") VALUES (22, 4); -- ---------- POPUPLATE TABLE "techrecord_product" ---------- INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (1, 12); INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (2, 9); INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (3, 13); INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (4, 15); INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (5, 3); INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (6, 8); INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (7, 2); INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (8, 17); INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (9, 14); INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (10, 1); INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (11, 19); INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (13, 10); INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (14, 20); INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (16, 5); INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (17, 6); INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (21, 21); INSERT INTO [dbo]."techrecord_product" ("product_oid", "techrecord_oid") VALUES (22, 23); -- ---------- POPUPLATE TABLE "bigimage" ---------- INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (1, 'The spirit of tradition, renovated by the most modern technologies and design.', 'upload/lamp_2.jpg', 14); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (2, 'High quality Italian design for relaxing and enjoying life with your family and friends.', 'upload/table_2.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (3, 'Brighten up your living room with warmly illuminating ideas.', 'upload/table_1.jpg', 11); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (4, 'Meet with friends in the comfort of a stylish and functional setting.', 'upload/lamp_4.jpg', 11); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (5, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'upload/chair_3.jpg', 3); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (6, 'Brighten up your living room with warmly illuminating ideas.', 'upload/lamp_4.jpg', 4); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (7, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'upload/lamp_3.jpg', 10); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (8, 'Make your house a home with the best interior design and the unprecedented quality of our products.', 'upload/lamp_1.jpg', 17); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (9, 'The spirit of tradition, renovated by the most modern technologies and design.', 'upload/table_3.jpg', 2); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (10, 'Brighten up your living room with warmly illuminating ideas.', 'upload/chair_1.jpg', 3); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (11, 'Meet with friends in the comfort of a stylish and functional setting.', 'upload/table_5.jpg', 8); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (12, 'High quality Italian design for relaxing and enjoying life with your family and friends.', 'upload/table_1.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (13, 'The spirit of tradition, renovated by the most modern technologies and design.', 'upload/table_5.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (14, 'Stainless steel meets crystal and silk to make the comfort and look.', 'upload/lamp_5.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (15, 'The spirit of tradition, renovated by the most modern technologies and design.', 'upload/chair_1.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (16, 'Make your house a home with the best interior design and the unprecedented quality of our products.', 'upload/lamp_5.jpg', 1); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (17, 'High quality Italian design for relaxing and enjoying life with your family and friends.', 'upload/table_4.jpg', 9); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (18, 'Stainless steel meets crystal and silk to make the comfort and look.', 'upload/chair_3.jpg', 6); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (19, 'The spirit of tradition, renovated by the most modern technologies and design.', 'upload/chair_4.jpg', 16); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (20, 'Brighten up your living room with warmly illuminating ideas.', 'upload/table_4.jpg', 2); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (21, 'Brighten up your living room with warmly illuminating ideas.', 'upload/lamp_5.jpg', 8); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (22, 'Meet with friends in the comfort of a stylish and functional setting.', 'upload/lamp_2.jpg', 7); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (23, 'Brighten up your living room with warmly illuminating ideas.', 'upload/table_2.jpg', 14); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (24, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'upload/chair_5.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (25, 'Make your house a home with the best interior design and the unprecedented quality of our products.', 'upload/table_2.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (26, 'The spirit of tradition, renovated by the most modern technologies and design.', 'upload/chair_4.jpg', 16); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (27, 'Meet with friends in the comfort of a stylish and functional setting.', 'upload/table_4.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (28, 'Create your space and make it flexible enough to fit whatever the moment calls for, from meeting friends to enjoying your family.', 'upload/table_5.jpg', 10); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (29, 'Create your space and make it flexible enough to fit whatever the moment calls for, from meeting friends to enjoying your family.', 'upload/chair_1.jpg', 11); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (30, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'upload/chair_5.jpg', 4); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (31, 'Brighten up your living room with warmly illuminating ideas.', 'upload/chair_5.jpg', 1); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (32, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'upload/table_4.jpg', 11); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (33, 'Brighten up your living room with warmly illuminating ideas.', 'upload/lamp_4.jpg', 16); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (34, 'Stainless steel meets crystal and silk to make the comfort and look.', 'upload/lamp_4.jpg', 17); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (35, 'Create your space and make it flexible enough to fit whatever the moment calls for, from meeting friends to enjoying your family.', 'upload/lamp_5.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (36, 'Make your house a home with the best interior design and the unprecedented quality of our products.', 'upload/lamp_3.jpg', 8); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (37, 'High quality Italian design for relaxing and enjoying life with your family and friends.', 'upload/table_1.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (38, 'The spirit of tradition, renovated by the most modern technologies and design.', 'upload/chair_2.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (39, 'The spirit of tradition, renovated by the most modern technologies and design.', 'upload/table_2.jpg', 3); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (40, 'Make your house a home with the best interior design and the unprecedented quality of our products.', 'upload/table_4.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (41, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'upload/lamp_4.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (42, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'upload/table_5.jpg', 13); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (43, 'Meet with friends in the comfort of a stylish and functional setting.', 'upload/lamp_4.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (44, 'Brighten up your living room with warmly illuminating ideas.', 'upload/lamp_3.jpg', 16); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (45, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'upload/table_3.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (46, 'Create your space and make it flexible enough to fit whatever the moment calls for, from meeting friends to enjoying your family.', 'upload/chair_4.jpg', 4); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (47, 'Brighten up your living room with warmly illuminating ideas.', 'upload/table_5.jpg', 5); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (48, 'The spirit of tradition, renovated by the most modern technologies and design.', 'upload/table_4.jpg', 13); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (49, 'High quality Italian design for relaxing and enjoying life with your family and friends.', 'upload/table_3.jpg', 8); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (50, 'Meet with friends in the comfort of a stylish and functional setting.', 'upload/chair_3.jpg', 11); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (51, 'Brighten up your living room with warmly illuminating ideas.', 'upload/chair_4.jpg', 4); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (52, 'Brighten up your living room with warmly illuminating ideas.', 'upload/chair_4.jpg', 4); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (53, 'The spirit of tradition, renovated by the most modern technologies and design.', 'upload/table_2.jpg', 3); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (54, 'Make your house a home with the best interior design and the unprecedented quality of our products.', 'upload/chair_4.jpg', 16); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (55, 'High quality Italian design for relaxing and enjoying life with your family and friends.', 'upload/table_3.jpg', 17); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (56, 'Stainless steel meets crystal and silk to make the comfort and look.', 'upload/lamp_3.jpg', 11); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (57, 'Meet with friends in the comfort of a stylish and functional setting.', 'upload/table_2.jpg', 10); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (58, 'Meet with friends in the comfort of a stylish and functional setting.', 'upload/lamp_1.jpg', 1); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (59, 'Meet with friends in the comfort of a stylish and functional setting.', 'upload/table_5.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (60, 'Brighten up your living room with warmly illuminating ideas.', 'upload/lamp_5.jpg', 11); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (61, 'Brighten up your living room with warmly illuminating ideas.', 'upload/chair_2.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (62, 'Create your space and make it flexible enough to fit whatever the moment calls for, from meeting friends to enjoying your family.', 'upload/table_3.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (63, 'High quality Italian design for relaxing and enjoying life with your family and friends.', 'upload/chair_3.jpg', 9); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (64, 'The spirit of tradition, renovated by the most modern technologies and design.', 'upload/chair_1.jpg', 17); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (65, 'Make your house a home with the best interior design and the unprecedented quality of our products.', 'upload/table_4.jpg', 10); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (66, 'Meet with friends in the comfort of a stylish and functional setting.', 'upload/lamp_3.jpg', 1); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (67, 'Meet with friends in the comfort of a stylish and functional setting.', 'upload/table_3.jpg', 3); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (68, 'Meet with friends in the comfort of a stylish and functional setting.', 'upload/lamp_3.jpg', 2); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (69, 'Meet with friends in the comfort of a stylish and functional setting.', 'upload/chair_3.jpg', 6); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (70, 'Stainless steel meets crystal and silk to make the comfort and look.', 'upload/table_4.jpg', 3); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (71, 'High quality Italian design for relaxing and enjoying life with your family and friends.', 'upload/chair_3.jpg', 8); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (72, 'Brighten up your living room with warmly illuminating ideas.', 'upload/chair_4.jpg', 1); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (73, 'Create your space and make it flexible enough to fit whatever the moment calls for, from meeting friends to enjoying your family.', 'upload/table_5.jpg', 2); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (74, 'The spirit of tradition, renovated by the most modern technologies and design.', 'upload/lamp_4.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (75, 'Meet with friends in the comfort of a stylish and functional setting.', 'upload/lamp_1.jpg', 4); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (76, 'Brighten up your living room with warmly illuminating ideas.', 'upload/table_5.jpg', 7); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (77, 'Stainless steel meets crystal and silk to make the comfort and look.', 'upload/chair_5.jpg', 3); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (78, 'The spirit of tradition, renovated by the most modern technologies and design.', 'upload/lamp_1.jpg', 3); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (79, 'Brighten up your living room with warmly illuminating ideas.', 'upload/lamp_3.jpg', 7); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (80, 'Stainless steel meets crystal and silk to make the comfort and look.', 'upload/lamp_1.jpg', 10); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (81, 'Create your space and make it flexible enough to fit whatever the moment calls for, from meeting friends to enjoying your family.', 'upload/chair_4.jpg', 6); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (82, 'High quality Italian design for relaxing and enjoying life with your family and friends.', 'upload/table_2.jpg', 13); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (83, 'High quality Italian design for relaxing and enjoying life with your family and friends.', 'upload/table_4.jpg', 17); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (84, 'Meet with friends in the comfort of a stylish and functional setting.', 'upload/lamp_3.jpg', 11); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (85, 'The spirit of tradition, renovated by the most modern technologies and design.', 'upload/chair_2.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (86, 'Create your space and make it flexible enough to fit whatever the moment calls for, from meeting friends to enjoying your family.', 'upload/table_2.jpg', 9); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (87, 'The spirit of tradition, renovated by the most modern technologies and design.', 'upload/lamp_4.jpg', 5); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (88, 'Stainless steel meets crystal and silk to make the comfort and look.', 'upload/chair_3.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (89, 'Make your house a home with the best interior design and the unprecedented quality of our products.', 'upload/table_3.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (90, 'Meet with friends in the comfort of a stylish and functional setting.', 'upload/lamp_1.jpg', 1); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (91, 'Stainless steel meets crystal and silk to make the comfort and look.', 'upload/table_2.jpg', 16); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (92, 'Make your house a home with the best interior design and the unprecedented quality of our products.', 'upload/lamp_4.jpg', 17); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (93, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'upload/lamp_3.jpg', 4); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (94, 'Make your house a home with the best interior design and the unprecedented quality of our products.', 'upload/table_5.jpg', 11); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (95, 'Create your space and make it flexible enough to fit whatever the moment calls for, from meeting friends to enjoying your family.', 'upload/chair_4.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (96, 'Create your space and make it flexible enough to fit whatever the moment calls for, from meeting friends to enjoying your family.', 'upload/lamp_2.jpg', 2); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (97, 'Stainless steel meets crystal and silk to make the comfort and look.', 'upload/table_2.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (98, 'The spirit of tradition, renovated by the most modern technologies and design.', 'upload/chair_2.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (99, 'Perfect for your office, unbeatable for your home, the most versatile interior design is found at Acme.', 'upload/lamp_4.jpg', 6); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (100, 'Brighten up your living room with warmly illuminating ideas.', 'upload/lamp_4.jpg', 5); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (101, 'A speheric object for a spheric world.', 'upload/bigimage2.jpg', NULL); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (102, 'See the beauty of this article in the glitter of the night.', 'upload/lamp_5_1.jpg', 22); INSERT INTO [dbo]."bigimage" ("oid", "description", "picture", "product_oid") VALUES (103, 'A mix of technology and innovative design that will add value to your h', 'upload/lamp_4.jpg', 22);