forked from moga-kit/moga-theme
-
Notifications
You must be signed in to change notification settings - Fork 0
/
setup.sql
145 lines (143 loc) · 11.8 KB
/
setup.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
INSERT INTO `oxconfig` (`OXID`, `OXSHOPID`, `OXMODULE`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`, `OXTIMESTAMP`) VALUES
(uuid(), 1, 'theme:moga', 'sEmailLogo', 'str', 0x942748b21dc5aa40be4dbb4b05b4, NOW()),
(uuid(), 1, 'theme:moga', 'sManufacturerIconsize', 'str', 0x07c4b144c7b838, NOW()),
(uuid(), 1, 'theme:moga', 'sCatIconsize', 'str', 0x070de94ac9b636, NOW()),
(uuid(), 1, 'theme:moga', 'aDetailImageSizes', 'aarr', 0x4dba326a73d2cdcb471b9533d7800b4b898873f7ae9dc29e349deefcb66d850ae01e328b04f76615e932a997c8084dd9ac31e423f22106b7a1dd7cb1451f56975c3fd6159579cd2cab97104f17ae8138a9804be3afb653c4e48881f76289e888a4f8ef570af174e3a150ec63c74cb7ba3fa76665f6a9294d8bf365bf7d3d0d56faf2355d1c38ba2e92bb4eb66100b3f6957ed8ebd700cdae929b8eff817426bf370bb4b92c9468f3d8ca7170cde789d6c1282016056e510050910ce509a25393205f43020972fc45f582c44616b7fea5d92349bc3290f41b221ca302652eabe106a93f9f4d1ed363f2f33c1e29716b955529172573e680701788104c2d0011bff92c28aa6c5fb2503bdde425b5acf963fd4426a6047b0e2bc4896143076e8dbc7dd8a7448ba2a523d3b5db6cbc1bc882194e2a5f96ceacfee4c889593cdefd17faa68394d63465a321d1d774bdb9, NOW()),
(uuid(), 1, 'theme:moga', 'sCatPromotionsize', 'str', 0xb06fb441c2bd94, NOW()),
(uuid(), 1, 'theme:moga', 'sCatThumbnailsize', 'str', 0x071d955c1cd4bda6, NOW()),
(uuid(), 1, 'theme:moga', 'sIconsize', 'str', 0x8064a213b1, NOW()),
(uuid(), 1, 'theme:moga', 'sThumbnailsize', 'str', 0xb0a3ba4f7d95b7, NOW()),
(uuid(), 1, 'theme:moga', 'sZoomImageSize', 'str', 0x170a3340d372be, NOW()),
(uuid(), 1, 'theme:moga', 'bl_showCompareList', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'bl_showListmania', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'bl_showWishlist', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'bl_showVouchers', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'bl_showGiftWrapping', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'blShowBirthdayFields', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'blShowFinalStep', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'sDefaultListDisplayType', 'select', 0x83cd10b7f09064ed, NOW()),
(uuid(), 1, 'theme:moga', 'sStartPageListDisplayType', 'select', 0x25f9f804, NOW()),
(uuid(), 1, 'theme:moga', 'blShowListDisplayType', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'blShowWeightInList', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'iNewBasketItemMessage', 'select', 0xb6, NOW()),
(uuid(), 1, 'theme:moga', 'aNrofCatArticles', 'arr', 0x4dbace2972e14bf2cbd3a9a4113b83ad1c8f7b704f710ba39fd1ecd29b438b41809712e316c6f4fdc92741f7876cc6fca127d78994e604dcc99519, NOW()),
(uuid(), 1, 'theme:moga', 'aNrofCatArticlesInGrid', 'arr', 0x4dbace2972e14bf2cbd3a9a4113b83c51e8d79724d7309a19dd3ee6153448c46879015e411c1f3fa250245f38368c2f8a523d58c91546b92cdf6, NOW()),
(uuid(), 1, 'theme:moga', 'bl_showManufacturerSlider', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'sGoogleMapsAddr', 'str', 0xda37080488abb110f9511073d0f569036f9d5a1f6a7fa627afc72fbe810d0563f7edc6bc19e9faae81865ec3b6f865e0ca, NOW()),
(uuid(), 1, 'theme:moga', 'blUseGAPageTracker', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'sGATrackingId', 'str', '', NOW()),
(uuid(), 1, 'theme:moga', 'sFacebookUrl', 'str', 0x00d0e1aeebd778fa49b315d49dbaf2e6c1349106c9da5a31ae0e49a790442dcface2f5, NOW()),
(uuid(), 1, 'theme:moga', 'sTwitterUrl', 'str', 0x00d0e1aeebd778fac2b08d85307f7aa4f33e9c5280c85d8aafda12218a0c65, NOW()),
(uuid(), 1, 'theme:moga', 'sYouTubeUrl', 'str', 0x00d0e1aeebd778fa49b315d40d88f5aff800205639d85f83435eba8889b06c49b6aabdcf29a076, NOW()),
(uuid(), 1, 'theme:moga', 'blGAAnonymizeIPs', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'blUseGAEcommerceTracking', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'sLogoWidth', 'str', 0xb6c7b2, NOW()),
(uuid(), 1, 'theme:moga', 'sLogoHeight', 'str', 0xb098, NOW()),
(uuid(), 1, 'theme:moga', 'sFaviconFile', 'str', 0x79000644af5767f4d7dc62, NOW()),
(uuid(), 1, 'theme:moga', 'sFavicon16File', 'str', 0x79000644af5767e6228e5470901b92dbd5, NOW()),
(uuid(), 1, 'theme:moga', 'sFavicon32File', 'str', 0x79000644af5767e6952d52c1351b92dbd5, NOW()),
(uuid(), 1, 'theme:moga', 'sFavicon48File', 'str', 0x79000644af5767e6de1c5f87091b92dbd5, NOW()),
(uuid(), 1, 'theme:moga', 'sFavicon64File', 'str', 0x79000644af5767e6326551657e1b92dbd5, NOW()),
(uuid(), 1, 'theme:moga', 'sFavicon128File', 'str', 0x79000644af5767e6222ffa198d7874d59eb3bd, NOW()),
(uuid(), 1, 'theme:moga', 'sFavicon512File', 'str', 0x79000644af5767e6789acb14dac048d59eb3bd, NOW()),
(uuid(), 1, 'theme:moga', 'sFaviconMSTileColor', 'str', 0xdbe489594ca46c, NOW()),
(uuid(), 1, 'theme:moga', 'sBlogUrl', 'str', 0x00d0e1ae33bb2426d4c13ad686d60fed72df8582c8631c9b461319, NOW()),
(uuid(), 1, 'theme:moga', 'sGooglePlusUrl', 'str', 0x00d0e1aeebd778fa21386b3d78d9f35abace215738d95e823f349b6cf969a88386d9ca3fbf80d7d4ffe0156bb2, NOW()),
(uuid(), 1, 'theme:moga', 'sBackgroundColor', 'str', 0xdb8f89a0725ec3, NOW()),
(uuid(), 1, 'theme:moga', 'sBackgroundPath', 'str', 0x679be558191c478fac1bc75462aa22cbfee85c7bfc417650, NOW()),
(uuid(), 1, 'theme:moga', 'sBackgroundRepeat', 'select', 0x8f25902f58076a32dc, NOW()),
(uuid(), 1, 'theme:moga', 'sBackgroundPosHorizontal', 'select', 0x6c95e74d1a80, NOW()),
(uuid(), 1, 'theme:moga', 'sBackgroundPosVertical', 'select', 0x933f05, NOW()),
(uuid(), 1, 'theme:moga', 'sBackgroundSize', 'select', 0x6c280d1171, NOW()),
(uuid(), 1, 'theme:moga', 'blBackgroundAttachment', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'blUseBackground', 'bool', '', NOW()),
(uuid(), 1, 'theme:moga', 'blUseGoogleTS', 'bool', '', NOW()),
(uuid(), 1, 'theme:moga', 'sGoogleVendorId', 'str', '', NOW()),
(uuid(), 1, 'theme:moga', 'sGoogleShoppingAccountId', 'str', '', NOW()),
(uuid(), 1, 'theme:moga', 'sPageLanguage', 'str', 0xce92a204f4, NOW()),
(uuid(), 1, 'theme:moga', 'sShoppingCountry', 'str', 0xec5a, NOW()),
(uuid(), 1, 'theme:moga', 'sShoppingLanguage', 'str', 0xce92, NOW()),
(uuid(), 1, 'theme:moga', 'sShippingDaysOnStock', 'str', 0xb0, NOW()),
(uuid(), 1, 'theme:moga', 'sShippingDaysNotOnStock', 'str', 0x5d, NOW()),
(uuid(), 1, 'theme:moga', 'sDeliveryDaysOnStock', 'str', 0x17, NOW()),
(uuid(), 1, 'theme:moga', 'sDeliveryDaysNotOnStock', 'str', 0x07e1, NOW()),
(uuid(), 1, 'theme:moga', 'blSliderShowImageCaption', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'blFooterShowHelp', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'blFooterShowLinks', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'blFooterShowNewsletter', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'blFooterShowNewsletterForm', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'blEmailsShowProductPictures', 'bool', '', NOW()),
(uuid(), 1, 'theme:moga', 'blFooterShowNews', 'bool', 0x07, NOW()),
(uuid(), 1, 'theme:moga', 'sLogoFile', 'str', 0x942748b21d78ed91e41c4cb2b7, NOW()),
(uuid(), 1, 'theme:moga', 'blFullwidthLayout', 'bool', '', NOW());
INSERT INTO `oxconfigdisplay` (`OXID`, `OXCFGMODULE`, `OXCFGVARNAME`, `OXGROUPING`, `OXVARCONSTRAINT`, `OXPOS`, `OXTIMESTAMP`) VALUES
(uuid(), 'theme:moga', 'sIconsize', 'images', '', 1, NOW()),
(uuid(), 'theme:moga', 'sThumbnailsize', 'images', '', 2, NOW()),
(uuid(), 'theme:moga', 'sCatThumbnailsize', 'images', '', 3, NOW()),
(uuid(), 'theme:moga', 'sZoomImageSize', 'images', '', 4, NOW()),
(uuid(), 'theme:moga', 'aDetailImageSizes', 'images', '', 5, NOW()),
(uuid(), 'theme:moga', 'bl_showCompareList', 'features', '', 6, NOW()),
(uuid(), 'theme:moga', 'bl_showListmania', 'features', '', 7, NOW()),
(uuid(), 'theme:moga', 'bl_showWishlist', 'features', '', 8, NOW()),
(uuid(), 'theme:moga', 'bl_showVouchers', 'features', '', 9, NOW()),
(uuid(), 'theme:moga', 'bl_showGiftWrapping', 'features', '', 10, NOW()),
(uuid(), 'theme:moga', 'blShowBirthdayFields', 'display', '', 14, NOW()),
(uuid(), 'theme:moga', 'blShowFinalStep', 'display', '', 16, NOW()),
(uuid(), 'theme:moga', 'sManufacturerIconsize', 'images', '', 6, NOW()),
(uuid(), 'theme:moga', 'sCatIconsize', 'images', '', 7, NOW()),
(uuid(), 'theme:moga', 'sCatPromotionsize', 'images', '', 8, NOW()),
(uuid(), 'theme:moga', 'sDefaultListDisplayType', 'display', 'infogrid|line|grid', 21, NOW()),
(uuid(), 'theme:moga', 'sStartPageListDisplayType', 'display', 'infogrid|line|grid', 22, NOW()),
(uuid(), 'theme:moga', 'blShowListDisplayType', 'display', '', 20, NOW()),
(uuid(), 'theme:moga', 'iNewBasketItemMessage', 'display', '0|1|2|3', 17, NOW()),
(uuid(), 'theme:moga', 'aNrofCatArticles', 'display', '', 23, NOW()),
(uuid(), 'theme:moga', 'aNrofCatArticlesInGrid', 'display', '', 24, NOW()),
(uuid(), 'theme:moga', 'bl_showManufacturerSlider', 'display', '', 25, NOW()),
(uuid(), 'theme:moga', 'sFacebookUrl', 'footer', '', 0, NOW()),
(uuid(), 'theme:moga', 'sTwitterUrl', 'footer', '', 0, NOW()),
(uuid(), 'theme:moga', 'sYouTubeUrl', 'footer', '', 0, NOW()),
(uuid(), 'theme:moga', 'sGoogleMapsAddr', 'contact', '', 0, NOW()),
(uuid(), 'theme:moga', 'blUseGAPageTracker', 'googleanalytics', '', 0, NOW()),
(uuid(), 'theme:moga', 'sGATrackingId', 'googleanalytics', '', 0, NOW()),
(uuid(), 'theme:moga', 'blGAAnonymizeIPs', 'googleanalytics', '', 0, NOW()),
(uuid(), 'theme:moga', 'sLogoFile', 'logo', '', 0, NOW()),
(uuid(), 'theme:moga', 'blUseGAEcommerceTracking', 'googleanalytics', '', 0, NOW()),
(uuid(), 'theme:moga', 'sLogoWidth', 'logo', '', 0, NOW()),
(uuid(), 'theme:moga', 'sLogoHeight', 'logo', '', 0, NOW()),
(uuid(), 'theme:moga', 'sFaviconFile', 'favicons', '', 1, NOW()),
(uuid(), 'theme:moga', 'sFavicon16File', 'favicons', '', 2, NOW()),
(uuid(), 'theme:moga', 'sFavicon32File', 'favicons', '', 3, NOW()),
(uuid(), 'theme:moga', 'sFavicon48File', 'favicons', '', 4, NOW()),
(uuid(), 'theme:moga', 'sFavicon64File', 'favicons', '', 5, NOW()),
(uuid(), 'theme:moga', 'sFavicon128File', 'favicons', '', 6, NOW()),
(uuid(), 'theme:moga', 'sFavicon512File', 'favicons', '', 7, NOW()),
(uuid(), 'theme:moga', 'sFaviconMSTileColor', 'favicons', '', 8, NOW()),
(uuid(), 'theme:moga', 'sEmailLogo', 'logo', '', 3, NOW()),
(uuid(), 'theme:moga', 'sBlogUrl', 'footer', '', 0, NOW()),
(uuid(), 'theme:moga', 'sGooglePlusUrl', 'footer', '', 0, NOW()),
(uuid(), 'theme:moga', 'blUseBackground', 'background', '', 1, NOW()),
(uuid(), 'theme:moga', 'sBackgroundColor', 'background', '', 2, NOW()),
(uuid(), 'theme:moga', 'sBackgroundPath', 'background', '', 3, NOW()),
(uuid(), 'theme:moga', 'sBackgroundRepeat', 'background', 'no-repeat|repeat-x|repeat-y|repeat', 4, NOW()),
(uuid(), 'theme:moga', 'sBackgroundPosHorizontal', 'background', 'left|right|center', 5, NOW()),
(uuid(), 'theme:moga', 'sBackgroundPosVertical', 'background', 'top|bottom|center', 6, NOW()),
(uuid(), 'theme:moga', 'sBackgroundSize', 'background', 'cover|contain|normal', 7, NOW()),
(uuid(), 'theme:moga', 'blBackgroundAttachment', 'background', '', 8, NOW()),
(uuid(), 'theme:moga', 'blUseGoogleTS', 'googlets', '', 1, NOW()),
(uuid(), 'theme:moga', 'sGoogleVendorId', 'googlets', '', 2, NOW()),
(uuid(), 'theme:moga', 'sGoogleShoppingAccountId', 'googlets', '', 4, NOW()),
(uuid(), 'theme:moga', 'sPageLanguage', 'googlets', '', 5, NOW()),
(uuid(), 'theme:moga', 'sShoppingCountry', 'googlets', '', 6, NOW()),
(uuid(), 'theme:moga', 'sShoppingLanguage', 'googlets', '', 7, NOW()),
(uuid(), 'theme:moga', 'sShippingDaysOnStock', 'googlets', '', 8, NOW()),
(uuid(), 'theme:moga', 'sShippingDaysNotOnStock', 'googlets', '', 9, NOW()),
(uuid(), 'theme:moga', 'sDeliveryDaysOnStock', 'googlets', '', 10, NOW()),
(uuid(), 'theme:moga', 'sDeliveryDaysNotOnStock', 'googlets', '', 11, NOW()),
(uuid(), 'theme:moga', 'blSliderShowImageCaption', 'images', '', 9, NOW()),
(uuid(), 'theme:moga', 'blFullwidthLayout', 'display', '', 10, NOW()),
(uuid(), 'theme:moga', 'blFooterShowHelp', 'footer', '', 1, NOW()),
(uuid(), 'theme:moga', 'blFooterShowLinks', 'footer', '', 2, NOW()),
(uuid(), 'theme:moga', 'blFooterShowNewsletter', 'footer', '', 4, NOW()),
(uuid(), 'theme:moga', 'blFooterShowNewsletterForm', 'footer', '', 5, NOW()),
(uuid(), 'theme:moga', 'blEmailsShowProductPictures', 'emails', '', 1, NOW()),
(uuid(), 'theme:moga', 'blFooterShowNews', 'footer', '', 6, NOW());