SALESMANAGER.h2.db

Home / sm-shop / SALESMANAGER.h2.db
1420 lines | 5.23 MB Blame History Raw Download
-- H2 0.5/B -- 
-- H2 0.5/B -- 
-- H2 0.5/B -- 
-	?2=7<-	?2=7<$???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????>鐁桁濔C??x???????????????????????????????????~zvrnjfb^ZVRNJFB>:62.*&"
????????????????????????????????~zvrnjfb^ZVRNJFB>:62.*&"

?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
~
z
v
r
n
j
f
b
^
Z
V
R
N
J
F
B
>
:
6
2
.
*
&
"







????????????????????????????????~zvrnjfb^ZVRNJFB>:62.*&"
?????????????????????????~ytoje`[VQLGB=83.)$
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?

z
u
p
k
f
a
\
W
R
M
H
C
>
9
4
/
*
%
 





	?	?	?	?	?	?	?	?	?	?	?	?	?	?	?	????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????~?~?}?}?|?|?{?{?z?z?y?y?x?x?w?w?v?v?u?u?t?t?s?s?r?r?q?q?p?p?o?o?n?n?m?m?l?l?k?k?j?j?i?i?h?h?g?g?f?f?e?e?d?d?c?c?b?b?a?a?`?`?_?_?^?^?]?]?\?\?[?[?Z?Z?Y?Y?X?X?W?W?V?V?U?U?T?T?S?S?R?R?Q?Q?P?P?O?O?N?N?M?M?L?L?K?K?J?J?I?I?H?H?G?G?F?F?E?E?D?D?C?C?B?B?A?A?@?@?????>?>?=?=?<?<?;?;?:?:?9?9?8?8?7?7?6?6?5?5?4?4?3?3?2?2?1?1?0?0?/?/?.?.?-?-?,?,?+?+?*?*?)?)?(?(?'?'?&?&?%?%?$?$?#?#?"?"?!?!? ? ???????????????????????????????????
?
?????
?
?	?	???7?7?6?6?5?5?4?4?3?3?2?2?1?1x?1???!x?x?@?????????6?5?4?3?2?1@????1:???!F????18???!x?x?[?????????6?5?4?3?2?1T??????????65432211x?"????????!!!!!!x? ???????????!?!?!?!f!e!2!!]????????5?4?3?2?1.???????!!!!!
x?x?(p????X?梵恤扶燋國n?U?=?%??髠趧羻﹪悏w?^?E?,??
麜
銞
蕶
矝
殱
偀
j?
R?
:?
"?
?瘾噩慨Π嵅s?Y?@?'??艏诮辆ɡ徛w?_?F?.??

逅
掏
诚
浶
傄
i?
P?
7?
?
?	磔	赃	会	€	夊	p?	W?	>?	&?	
?躏荞麦庽t?[?C?)??鰝輨膯珗搲x? ?6QOFF,0,,,falseG0,1?!?%QOFF,0,,,falseE8?!?7QOFF,0,,,falseE7?!?8QOFF,0,,,falseE2?!?9QOFF,0,,,falseE0?!?:QOFF,0,,,falseE1?!?;QOFF,0,,,falseF19?!?=QOFF,0,,,falseF18?!?&QOFF,0,,,falseE8?!?>QOFF,0,,,falseE7?!??QOFF,0,,,falseF13?!?@QOFF,0,,,falseF12?!?AQOFF,0,,,falseF11?!?BQOFF,0,,,falseF10?!?CQOFF,0,,,falseE9?!?'QOFF,0,,,falseE3?!?EQOFF,0,,,falseE9?!?(QOFF,0,,,falseE8?!?FQOFF,0,,,falseE9?!?GQOFF,0,,,falseE6?!?HQOFF,0,,,falseE5?!?IQOFF,0,,,falseE6?!?JQOFF,0,,,falseE8?!?LQOFF,0,,,falseE7?!?MQOFF,0,,,falseE6?!?)QOFF,0,,,falseE8?!?NQOFF,0,,,falseE7?!?OQOFF,0,,,falseE9?!?PQOFF,0,,,falseE8?!?QQOFF,0,,,falseE5?!?RQOFF,0,,,falseE4?!?TQOFF,0,,,falseE3?!?*QOFF,0,,,falseE8?!?UQOFF,0,,,falseE7?!?VQOFF,0,,,falseE8?!?+QOFF,0,,,falseE8?!?WQOFF,0,,,falseE7?!?,QOFF,0,,,falseE5?!?-QOFF,0,,,falseE9?!?XQOFF,0,,,falseE8?!?.QOFF,0,,,falseE5?!?/QOFF,0,,,falseE9?!?ZQOFF,0,,,falseE8?!?[QOFF,0,,,falseE6?!?QOFF,0,,,falseE2?!?QOFF,0,,,falseF14?!?\QOFF,0,,,falseF13?!?QOFF,0,,,falseE0?!?]QOFF,0,,,falseE1?!?_QOFF,0,,,falseE9?!?`QOFF,0,,,falseF11?!?QOFF,0,,,falseF10?!?aQOFF,0,,,falseE9?!~bQOFF,0,,,falseF23?!~cQOFF,0,,,falseF22?!~QOFF,0,,,falseF21?!~dQOFF,0,,,falseF20?!}fQOFF,0,,,falseE0?!}gQOFF,0,,,falseE1?!whQOFF,0,,,falseE9?!tiQOFF,0,,,falseE5?!qjQOFF,0,,,falseE8?!nkQOFF,0,,,falseE4?!klQOFF,0,,,falseE8?!hnQOFF,0,,,falseE5?!eoQOFF,0,,,falseF10?!epQOFF,0,,,falseE9?!bqQOFF,0,,,falseE4?!_rQOFF,0,,,falseF44?!_sQOFF,0,,,falseF43?!_tQOFF,0,,,falseF42?!_vQOFF,0,,,falseF41?!_wQOFF,0,,,falseF40?!_xQOFF,0,,,falseF39?!\QOFF,0,,,falseE5?!VyQOFF,0,,,falseF22?!VzQOFF,0,,,falseF21?!V{QOFF,0,,,falseF20?!V|QOFF,0,,,falseF19?!S~QOFF,0,,,falseE3?!PQOFF,0,,,falseE7?!MQOFF,0,,,falseF11?!MQOFF,0,,,falseF10?!JQOFF,0,,,falseE7?!DQOFF,0,,,falseE8?!D?QOFF,0,,,falseE7?!>QOFF,0,,,falseE7?!;QOFF,0,,,falseE8P????1+???!Y???1S????1???!g???1???????????????????????????????????????????????????????|yvspmjgda^[XUROLIFC@=:741.+(%"

????????????????????????????????????????}yuqmiea]YUQMIEA=951-)%!
	
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
??_?_?^?^?]?]?\?\?[?[?Z?Z?Y?Y?X?X?W?W?V?V?U?U?T?T?S?S?R?R?Q?Q?P?P?O?O?N?N?M?M?L?L?K?K?J?J?I?I?H?H?G?G?F?F?E?E?D?D?C?C?B?B?A?A?@@~?}?|>{>z=y=x<w<v;u;t:s:r9q9p8o8n7m7l6k6j5i5h4g4f3e3d2c2b1a1`0_0^/]/\.[.Z-Y-X,W,V+U+T*S*R)Q)P(O(N'M'L&K&J%I%H$G$F#E#D"C"B!A!@ ? >=<;:9876543210/.-,+*)('&%$#"! //..--,,++**))(('
'&&
%	%$$##""!!7x?0x?l?????????????????7?7?6?6?5?5?4?4?3?3?2?2?1?1?????????!!!!!!!騁6?髁
昝鹋??
&?
??	骨	=?吷愂???? %
?ALTER TABLE SALESMANAGER.ZONE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_11L2IFK07G04697NMB9ARIFNB FOREIGN KEY(ZONE_ID) INDEX SALESMANAGER.UK_M64LAXGRV9FXM6IO232AP4SU9_INDEX_1 REFERENCES SALESMANAGER.ZONE(ZONE_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.TAX_RATE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_LD9JWC8VXB7FTKU6YXX2MKJBF FOREIGN KEY(TAX_RATE_ID) INDEX SALESMANAGER.UK_T3XG8PL88YACDXG49NB46EFFG_INDEX_2 REFERENCES SALESMANAGER.TAX_RATE(TAX_RATE_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.TAX_CLASS ADD CONSTRAINT SALESMANAGER.FK_HS8KJI9QD3Y9SC8YB38K8FEFB FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_A4Q5Q57A8OEH2OJEO8DHR935K_INDEX_D REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.SYSTEM_NOTIFICATION ADD CONSTRAINT SALESMANAGER.FK_6POW79MEFOFMD6SVPDB47P1TQ FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_NPDNLC390VGR2MHEPIB1MTRMR_INDEX_8 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.PRODUCT_REVIEW_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_M7SU4LEPERKHLINCCX5EC3KJA FOREIGN KEY(PRODUCT_REVIEW_ID) INDEX SALESMANAGER.UK_QNO5WJDTCJ8PM3YKKKH7T4RXJ_INDEX_A REFERENCES SALESMANAGER.PRODUCT_REVIEW(PRODUCT_REVIEW_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.PRODUCT_PRICE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_2XU1K5V5BLWC7W6X65G4WW0AU FOREIGN KEY(PRODUCT_PRICE_ID) INDEX SALESMANAGER.UK_FRSW8D41SXXOGVXXOYD8NWAXU_INDEX_5 REFERENCES SALESMANAGER.PRODUCT_PRICE(PRODUCT_PRICE_ID) NOCHECK鼼6??
?
???	锕
_?	嘶屑5??i? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION_VALUE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_4IGJAQWI959O699J6O8JHFFTL FOREIGN KEY(PRODUCT_OPTION_VALUE_ID) INDEX SALESMANAGER.UK_ASGC60OT1WY0UHO96N0J8429P_INDEX_1 REFERENCES SALESMANAGER.PRODUCT_OPTION_VALUE(PRODUCT_OPTION_VALUE_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION_VALUE ADD CONSTRAINT SALESMANAGER.FK_9Q3E32T980PM3XFONWCB94E9T FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_IXBPI4HXRHLJH935C3XFVNVSH_INDEX_8 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION_DESC ADD CONSTRAINT SALESMANAGER.FK_AA0FBX3V56BJBXWIPAG3BBDEV FOREIGN KEY(PRODUCT_OPTION_ID) INDEX SALESMANAGER.UK_MKCM8ISYYYQBJD1YYB8MRPKUW_INDEX_8 REFERENCES SALESMANAGER.PRODUCT_OPTION(PRODUCT_OPTION_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION ADD CONSTRAINT SALESMANAGER.FK_4W5AR6NAHG63CJ3VBM00XR7R7 FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_HFCW5OI9ULLJLOG1B7NS1R9TU_INDEX_1 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.PRODUCT_IMAGE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_1SDAJMRIUTHBEWH872GJI4QGT FOREIGN KEY(PRODUCT_IMAGE_ID) INDEX SALESMANAGER.UK_N7YHDJ6CCYDGF201GIBB882CD_INDEX_7 REFERENCES SALESMANAGER.PRODUCT_IMAGE(PRODUCT_IMAGE_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.PRODUCT_DIGITAL ADD CONSTRAINT SALESMANAGER.FK_7NMMS6PBK5W9YVQM874HW1A1R FOREIGN KEY(PRODUCT_ID) INDEX SALESMANAGER.UK_JUK1QGKH9V5W7GHVB18KRWO8V_INDEX_3 REFERENCES SALESMANAGER.PRODUCT(PRODUCT_ID) NOCHECK麲6?

?$?(?
7?
叜
?	?v?叢?? %
?ALTER TABLE SALESMANAGER.PRODUCT_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_ARUIDFGMBEKI4PU5IPJDD5J7P FOREIGN KEY(PRODUCT_ID) INDEX SALESMANAGER.UK_Q4DNKX5B776AYQAS2H4RR2D8Q_INDEX_3 REFERENCES SALESMANAGER.PRODUCT(PRODUCT_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.PRODUCT_ATTRIBUTE ADD CONSTRAINT SALESMANAGER.FK_R9U2IOT9WKBN263UP3PJ9STC1 FOREIGN KEY(OPTION_ID) INDEX SALESMANAGER.UK_O0C6CFXCFEJWFA2877GFGPUCO_INDEX_8 REFERENCES SALESMANAGER.PRODUCT_OPTION(PRODUCT_OPTION_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.PRODUCT ADD CONSTRAINT SALESMANAGER.FK_A1P3PJ01G4OJBDF1I93IAVWOO FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_S8OFSN9PEHDRSTJG52J5QABXH_INDEX_1 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.OPTIN ADD CONSTRAINT SALESMANAGER.FK_78LSE42PDFCESQV7T666PUQQI FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_MANLX6SIQ6DDF14CUD40K8GW6_INDEX_4 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.MERCHANT_CONFIGURATION ADD CONSTRAINT SALESMANAGER.FK_4HWQHY43W922OTSCGFAH9D30A FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_J0C3H8ONW3M6HJCR3YYLST9FB_INDEX_D REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.MANUFACTURER_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_1O49OME5YMQ7N6XABXYLR6FMG FOREIGN KEY(MANUFACTURER_ID) INDEX SALESMANAGER.UK_LPV09P83SC887CLXE04NROUP6_INDEX_2 REFERENCES SALESMANAGER.MANUFACTURER(MANUFACTURER_ID) NOCHECK?G6?鳚
麩堋辏

?
?	帲潳???? %
?ALTER TABLE SALESMANAGER.MANUFACTURER ADD CONSTRAINT SALESMANAGER.FK_6A0XJJRYA6F08YS6BM5TR84Q5 FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_6BRQFDKGA7JC78N8DH3V595Y3_INDEX_1 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.GEOZONE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_M2XIPV66DA4UJEKWBWXUYHMB8 FOREIGN KEY(GEOZONE_ID) INDEX SALESMANAGER.UK_SOQ8O99W3C8YS3NTAMT5I4MAT_INDEX_1 REFERENCES SALESMANAGER.GEOZONE(GEOZONE_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.FILE_HISTORY ADD CONSTRAINT SALESMANAGER.FK_5P2NKRCJ0B8K5R3MV3LIJIF45 FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_AV35SB3V4NXQ8V1N1RKXUFIR_INDEX_F REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPT_VAL_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_SJ4LCO1GCMPLVQLGFDBDPMTYN FOREIGN KEY(CUSTOMER_OPT_VAL_ID) INDEX SALESMANAGER.UK_GE7F2T1D31R87WNK09H9U1TNV_INDEX_B REFERENCES SALESMANAGER.CUSTOMER_OPTION_VALUE(CUSTOMER_OPTION_VALUE_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION_VALUE ADD CONSTRAINT SALESMANAGER.FK_QBUR9HS0QBTGL3F85L4C6S3YD FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_CB1FMV71NRX7M1RLX1FF5QVDT_INDEX_5 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION_SET ADD CONSTRAINT SALESMANAGER.FK_NW8SYFFQ9LV0P0NC0VVLECBBA FOREIGN KEY(CUSTOMER_OPTION_ID) INDEX SALESMANAGER.UK_4PELI2RITNNQ2XQPYQ188SRM6_INDEX_5 REFERENCES SALESMANAGER.CUSTOMER_OPTION(CUSTOMER_OPTION_ID) NOCHECK礼6???
?)??視
訓
H?	R?聶笟"? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION_DESC ADD CONSTRAINT SALESMANAGER.FK_P7U6VMIIVMPUI2SYTDT41U2YE FOREIGN KEY(CUSTOMER_OPTION_ID) INDEX SALESMANAGER.UK_6OVL4T1CIAG1WUBTCEBAOO7VI_INDEX_4 REFERENCES SALESMANAGER.CUSTOMER_OPTION(CUSTOMER_OPTION_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION ADD CONSTRAINT SALESMANAGER.FK_C8HB7W6E4RLE5VFJF4P96SH80 FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_ROV34A6G4DHHIQUKVHP1GGM0U_INDEX_3 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.CUSTOMER_ATTRIBUTE ADD CONSTRAINT SALESMANAGER.FK_APOTUXWJSVBA5Y88AU4XYW0NH FOREIGN KEY(OPTION_ID) INDEX SALESMANAGER.UK_46KBPRE88YH963GEWM3KMDNI1_INDEX_5 REFERENCES SALESMANAGER.CUSTOMER_OPTION(CUSTOMER_OPTION_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.COUNTRY_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_DLHTY043OQOECR3F37UQVHJ8W FOREIGN KEY(COUNTRY_ID) INDEX SALESMANAGER.UK_T7NSHKI1RBP6157ED0V6CX4Y4_INDEX_B REFERENCES SALESMANAGER.COUNTRY(COUNTRY_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.CONTENT_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_4DS7M2JYMX6N57XXP0QP268OI FOREIGN KEY(CONTENT_ID) INDEX SALESMANAGER.UK_N0W5R7CTBP88R4RVK7AYKLOFM_INDEX_5 REFERENCES SALESMANAGER.CONTENT(CONTENT_ID) NOCHECK?'6
?梻竷R?
p?龁?
秼	翇訉穽蓭O? %
?ALTER TABLE SALESMANAGER.CONTENT ADD CONSTRAINT SALESMANAGER.FK_L2S62G3NT07RX5TDFHSAP7T7H FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_T1V2LD0MRWVIQUQOURQL4UUB0_INDEX_6 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.CATEGORY_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_BY2TLIRQ8WUHX2ML9ASHSJWV2 FOREIGN KEY(CATEGORY_ID) INDEX SALESMANAGER.UK_BUESQQ6CYX7E5HY3MF30CFIEQ_INDEX_9 REFERENCES SALESMANAGER.CATEGORY(CATEGORY_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.FK_B5718WL9WILWJ9K8JE1K2JEO FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X_INDEX_3 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK?  
aCREATE CACHED TABLE SALESMANAGER.SM_SEQUENCER(
    SEQ_NAME VARCHAR(255),
    SEQ_COUNT INTEGER
)? %
?ALTER TABLE SALESMANAGER.ZONE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_C0KDJWP4GDXE36VLU83QFVME5 FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_C0KDJWP4GDXE36VLU83QFVME5_INDEX_1 REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
lCREATE INDEX SALESMANAGER.FK_C0KDJWP4GDXE36VLU83QFVME5_INDEX_1 ON SALESMANAGER.ZONE_DESCRIPTION(LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.ZONE ADD CONSTRAINT SALESMANAGER.FK_7U7308KMAFQHSVHT9XWABA9H8 FOREIGN KEY(COUNTRY_ID) INDEX SALESMANAGER.FK_7U7308KMAFQHSVHT9XWABA9H8_INDEX_2 REFERENCES SALESMANAGER.COUNTRY(COUNTRY_ID) NOCHECK? !
_CREATE INDEX SALESMANAGER.FK_7U7308KMAFQHSVHT9XWABA9H8_INDEX_2 ON SALESMANAGER.ZONE(COUNTRY_ID)? %
?ALTER TABLE SALESMANAGER.USER_GROUP ADD CONSTRAINT SALESMANAGER.FK_3AT466HPMIS1ABRUUH3X6NFTG FOREIGN KEY(USER_ID) INDEX SALESMANAGER.FK_3AT466HPMIS1ABRUUH3X6NFTG_INDEX_C REFERENCES SALESMANAGER.USER(USER_ID) NOCHECK? !
bCREATE INDEX SALESMANAGER.FK_3AT466HPMIS1ABRUUH3X6NFTG_INDEX_C ON SALESMANAGER.USER_GROUP(USER_ID)解攒	*?蹢稑枡v?U?4??鞛藷獱嚒d?A??

枝
阀
槰
q?
J?
'?
?悱庐摨a?;??舫哟钡彾d?9??
骱
栈
臣
惤
m?
@?
?葯蜐?+葯蜐?+VSchleswig-Holstein"??葯蜐?+葯蜐?+VSchleswig-Holstein!??葯蜐?+葯蜐?+LValencia"??葯蜐?+葯蜐?+LValencia!??葯蜐?+葯蜐?+KNavarra"??葯蜐?+葯蜐?+KNavarra!??葯蜐?+葯蜐?+JBayern"??葯蜐?+葯蜐?+JBayern!??葯蜐?+葯蜐?+TBaden-Wrttemberg"??葯蜐?+葯蜐?+TBaden-Wrttemberg!??葯蜐?+葯蜐?+KAlmeria"??葯蜐?+葯蜐?+KAlmeria!??葯蜐?+葯蜐?+JHessen"??葯蜐?+葯蜐?+JHessen!??葯蜐?+葯蜐?+OBrandenburg"??葯蜐?+葯蜐?+OBrandenburg!??葯蜐?+葯蜐?+Y?le-du-Prince-?	douard"??葯蜐?+葯蜐?+XPrince Edward Island!??葯蜐?+葯蜐?+JBremen"??葯蜐?+葯蜐?+JBremen!??葯蜐?+葯蜐?+LVictoria"??葯蜐?+葯蜐?+LVictoria!??葯蜐?+葯蜐?+PPennsylvanie"??葯蜐?+葯蜐?+PPennsylvania!??葯蜐?+葯蜐?+HGuam"??葯蜐?+葯蜐?+HGuam!??葯蜐?+葯蜐?+MGraubnden"??葯蜐?+葯蜐?+MGraubnden!??葯蜐?+葯蜐?+LObwalden"??葯蜐?+葯蜐?+LObwalden!??葯蜐?+葯蜐?+LBaleares"??葯蜐?+葯蜐?+LBaleares!??葯蜐?+葯蜐?+JGlarus"??葯蜐?+葯蜐?+JGlarus!??葯蜐?+葯蜐?+MSalamanca"??葯蜐?+葯蜐?+MSalamanca!??葯蜐?+葯蜐?+JOregon"??葯蜐?+葯蜐?+JOregon!??葯蜐?+葯蜐?+IAvila"??葯蜐?+葯蜐?+IAvila!??葯蜐?+葯蜐?+NBurgenland"??葯蜐?+葯蜐?+NBurgenland!?舭攒	B?握澲u?I?$???捋杰涊y?T?*?
??
遭
层
愪
j?
??
?组店呺R??囝撅滒{?Z?6??
眭
撒

傴
`?
>?
?		埤	羹	??	d?	B?	 ?鼉貏箙殕x?V?5??駤螌瘝悗h?@??鼟訐獢垥f?葯蜐?+葯蜐?+KWyoming"??葯蜐?+葯蜐?+KWyoming!??葯蜐?+葯蜐?+ROberosterreich"??葯蜐?+葯蜐?+ROberosterreich!??葯蜐?+葯蜐?+KOntario"??葯蜐?+葯蜐?+KOntario!??葯蜐?+葯蜐?+QWest Virginia"??葯蜐?+葯蜐?+QWest Virginia!??葯蜐?+葯蜐?+HGenf"??葯蜐?+葯蜐?+HGenf!??葯蜐?+葯蜐?+LOklahoma"??葯蜐?+葯蜐?+LOklahoma!??葯蜐?+葯蜐?+JMurcia"??葯蜐?+葯蜐?+JMurcia!??葯蜐?+葯蜐?+KGeorgie"??葯蜐?+葯蜐?+KGeorgia!??葯蜐?+葯蜐?+HOhio"??葯蜐?+葯蜐?+HOhio!??葯蜐?+葯蜐?+MWisconsin"??葯蜐?+葯蜐?+MWisconsin!??葯蜐?+葯蜐?+KOurense"??葯蜐?+葯蜐?+KOurense!??葯蜐?+葯蜐?+SRheinland-Pfalz"??葯蜐?+葯蜐?+SRheinland-Pfalz!??葯蜐?+葯蜐?+LFreiburg"??葯蜐?+葯蜐?+LFreiburg!??葯蜐?+葯蜐?+ISoria"??葯蜐?+葯蜐?+ISoria!??葯蜐?+葯蜐?+KGranada"??葯蜐?+葯蜐?+KGranada!??葯蜐?+葯蜐?+LNew York"??葯蜐?+葯蜐?+LNew York!??葯蜐?+葯蜐?+NWashington"??葯蜐?+葯蜐?+NWashington!??葯蜐?+葯蜐?+MNidwalden"??葯蜐?+葯蜐?+MNidwalden!??葯蜐?+葯蜐?+JNevada"??葯蜐?+葯蜐?+JNevada!??葯蜐?+葯蜐?+KNunavut"??葯蜐?+葯蜐?+KNunavut!??葯蜐?+葯蜐?+bFederated States Of Micronesia"??葯蜐?+葯蜐?+bFederated States Of Micronesia!??葯蜐?+葯蜐?+\Territores du Nord-Ouest"??葯蜐?+葯蜐?+YNorthwest Territories!??葯蜐?+葯蜐?+KFloride"??葯蜐?+葯蜐?+KFlorida!??葯蜐?+葯蜐?+LSaarland"??葯蜐?+葯蜐?+LSaarland!??葯蜐?+葯蜐?+SNouvelle ?	cosse"??葯蜐?+葯蜐?+ONova Scotia!??葯蜐?+葯蜐?+KSachsen"??葯蜐?+葯蜐?+KSachsen!??葯蜐?+葯蜐?+TNiederosterreich"??葯蜐?+葯蜐?+TNiederosterreich!??葯蜐?+葯蜐?+SNouveau Mexique"??葯蜐?+葯蜐?+NNew Mexico!??葯蜐?+葯蜐?+KVermont"??葯蜐?+葯蜐?+KVermont!??葯蜐?+葯蜐?+JWallis"??葯蜐?+葯蜐?+JWallis!??葯蜐?+葯蜐?+NNew Jersey"??葯蜐?+葯蜐?+NNew Jersey!??葯蜐?+葯蜐?+UNouveau Hampshire"??葯蜐?+葯蜐?+QNew Hampshire!??葯蜐?+葯蜐?+ZTerre-Neuve - Labrador"??葯蜐?+葯蜐?+[Newfoundland - Labrador!?	?攒	B?贀矓悤n?L?*?
?隁藳瑴姖h?C??

丌

劋
b?
@?
#?
?瑭湿Й劕b?@??馨贡柌q?L?+?
?
榉
雀
樄
h?
F?
$?
?	蘧	究	灷	??	b?	C?	$?	?嗥非幦k?H? ?籼送⑽y?N?'?塾??葯蜐?+葯蜐?+LNebraska"??葯蜐?+葯蜐?+LNebraska!??葯蜐?+葯蜐?+RDakota du Nord"??葯蜐?+葯蜐?+PNorth Dakota!??葯蜐?+葯蜐?+TCaroline du Nord"??葯蜐?+葯蜐?+RNorth Carolina!??葯蜐?+葯蜐?+RSachsen-Anhalt"??葯蜐?+葯蜐?+RSachsen-Anhalt!??葯蜐?+葯蜐?+UNouveau Brunswick"??葯蜐?+葯蜐?+QNew Brunswick!??葯蜐?+葯蜐?+LZaragoza"??葯蜐?+葯蜐?+LZaragoza!??葯蜐?+葯蜐?+RVirgin Islands"??葯蜐?+葯蜐?+RVirgin Islands!??葯蜐?+葯蜐?+KSevilla"??葯蜐?+葯蜐?+KSevilla!??葯蜐?+葯蜐?+IWaadt"?葯蜐?+葯蜐?+IWaadt!?葯蜐?+葯蜐?+HWien"~?葯蜐?+葯蜐?+HWien!~?葯蜐?+葯蜐?+JCuenca"}?葯蜐?+葯蜐?+JCuenca!}?葯蜐?+葯蜐?+MVoralberg"|?葯蜐?+葯蜐?+MVoralberg!|?葯蜐?+葯蜐?+LVirginie"{?葯蜐?+葯蜐?+LVirginia!{?葯蜐?+葯蜐?+ZMecklenburg-Vorpommern"z?葯蜐?+葯蜐?+ZMecklenburg-Vorpommern!z?葯蜐?+葯蜐?+KBadajoz"y?葯蜐?+葯蜐?+KBadajoz!y?葯蜐?+葯蜐?+KMontana"x?葯蜐?+葯蜐?+KMontana!x?葯蜐?+葯蜐?+OMississippi"w?葯蜐?+葯蜐?+OMississippi!w?葯蜐?+葯蜐?+MBarcelona"v?葯蜐?+葯蜐?+MBarcelona!v?葯蜐?+葯蜐?+\Northern Mariana Islands"u?葯蜐?+葯蜐?+\Northern Mariana Islands!u?葯蜐?+葯蜐?+LMissouri"t?葯蜐?+葯蜐?+LMissouri!t?葯蜐?+葯蜐?+MMinnesota"s?葯蜐?+葯蜐?+MMinnesota!s?葯蜐?+葯蜐?+HUtah"r?葯蜐?+葯蜐?+HUtah!r?葯蜐?+葯蜐?+GUri"q?葯蜐?+葯蜐?+GUri!q?葯蜐?+葯蜐?+LMichigan"p?葯蜐?+葯蜐?+LMichigan!p?葯蜐?+葯蜐?+TMarshall Islands"o?葯蜐?+葯蜐?+TMarshall Islands!o?葯蜐?+葯蜐?+MCantabria"n?葯蜐?+葯蜐?+MCantabria!n?葯蜐?+葯蜐?+OGuadalajara"m?葯蜐?+葯蜐?+OGuadalajara!m?葯蜐?+葯蜐?+LAlicante"l?葯蜐?+葯蜐?+LAlicante!l?葯蜐?+葯蜐?+IMaine"k?葯蜐?+葯蜐?+IMaine!k?葯蜐?+葯蜐?+JGirona"j?葯蜐?+葯蜐?+JGirona!j?葯蜐?+葯蜐?+LMaryland"i?葯蜐?+葯蜐?+LMaryland!i?葯蜐?+葯蜐?+LManitoba"h?葯蜐?+葯蜐?+LManitoba!h?葯蜐?+葯蜐?+QMassachusetts"g?葯蜐?+葯蜐?+QMassachusetts!g攒	D?傧残徰l?H?$?讨ㄗ勜e?E?'?	?
漭
哭
熯
?
`?
A?
!?
?咤芥涚y?Y?9??镬鬼x?W?6??
痱
象

庻
n?
P?
2?
?	禚	甥		嘄	f?	8?	
?鑱苽倓c?D?"??軌笂構x?X?8??鷲蕬??葯蜐?+葯蜐?+ZSanta Cruz de Tenerife"f?葯蜐?+葯蜐?+ZSanta Cruz de Tenerife!f?葯蜐?+葯蜐?+ICadiz"e?葯蜐?+葯蜐?+ICadiz!e?葯蜐?+葯蜐?+JBurgos"d?葯蜐?+葯蜐?+JBurgos!d?葯蜐?+葯蜐?+JLuzern"c?葯蜐?+葯蜐?+JLuzern!c?葯蜐?+葯蜐?+NQueensland"b?葯蜐?+葯蜐?+NQueensland!b?葯蜐?+葯蜐?+LTasmanie"a?葯蜐?+葯蜐?+LTasmania!a?葯蜐?+葯蜐?+ITexas"`?葯蜐?+葯蜐?+ITexas!`?葯蜐?+葯蜐?+LDelaware"_?葯蜐?+葯蜐?+LDelaware!_?葯蜐?+葯蜐?+LPalencia"^?葯蜐?+葯蜐?+LPalencia!^?葯蜐?+葯蜐?+XDistrict de Columbia"]?葯蜐?+葯蜐?+XDistrict of Columbia!]?葯蜐?+葯蜐?+JToledo"\?葯蜐?+葯蜐?+JToledo!\?葯蜐?+葯蜐?+MTennessee"[?葯蜐?+葯蜐?+MTennessee![?葯蜐?+葯蜐?+MNeuenburg"Z?葯蜐?+葯蜐?+MNeuenburg!Z?葯蜐?+葯蜐?+HLugo"Y?葯蜐?+葯蜐?+HLugo!Y?葯蜐?+葯蜐?+JTessin"X?葯蜐?+葯蜐?+JTessin!X?葯蜐?+葯蜐?+KHamburg"W?葯蜐?+葯蜐?+KHamburg!W?葯蜐?+葯蜐?+MLouisiane"V?葯蜐?+葯蜐?+MLouisiana!V?葯蜐?+葯蜐?+KThurgau"U?葯蜐?+葯蜐?+KThurgau!U?葯蜐?+葯蜐?+
&Territoire de la capitale australienne"T?葯蜐?+葯蜐?+`Australian Capital Territory!T?葯蜐?+葯蜐?+OConnecticut"S?葯蜐?+葯蜐?+OConnecticut!S?葯蜐?+葯蜐?+JBerlin"R?葯蜐?+葯蜐?+JBerlin!R?葯蜐?+葯蜐?+LKentucky"Q?葯蜐?+葯蜐?+LKentucky!Q?葯蜐?+葯蜐?+LColorado"P?葯蜐?+葯蜐?+LColorado!P?葯蜐?+葯蜐?+JKansas"O?葯蜐?+葯蜐?+JKansas!O?葯蜐?+葯蜐?+IAlava"N?葯蜐?+葯蜐?+IAlava!N?葯蜐?+葯蜐?+JSchwyz"M?葯蜐?+葯蜐?+JSchwyz!M?葯蜐?+葯蜐?+OCiudad Real"L?葯蜐?+葯蜐?+OCiudad Real!L?葯蜐?+葯蜐?+HJaen"K?葯蜐?+葯蜐?+HJaen!K?葯蜐?+葯蜐?+JKarten"J?葯蜐?+葯蜐?+IKaten!J?葯蜐?+葯蜐?+NSteiermark"I?葯蜐?+葯蜐?+NSteiermark!I?葯蜐?+葯蜐?+VTerritoire du Nord"H?葯蜐?+葯蜐?+VNorthern Territory!H?葯蜐?+葯蜐?+NCalifornie"G?葯蜐?+葯蜐?+NCalifornia!G?葯蜐?+葯蜐?+MSolothurn"F?葯蜐?+葯蜐?+MSolothurn!F?葯蜐?+葯蜐?+QNiedersachsen"E?葯蜐?+葯蜐?+QNiedersachsen!E攒	D?奚际澦~?Z?6??匮敢椨v?W?8??
髫
寿
澸
?
a?
B?
#?坂结熲~?[?8??痃惕ㄩy?J?*?
?
轭
蕊
涴
n?
L?
*?		絮	ｖ	v?	U?	4?	?酐狱u?U?5??髠覂眲悈o?=??顗褗眿??葯蜐?+葯蜐?+JMalaga"#?葯蜐?+葯蜐?+JMalaga!#?葯蜐?+葯蜐?+GZug""?葯蜐?+葯蜐?+GZug!"?葯蜐?+葯蜐?+\Armed Forces Middle East"!?葯蜐?+葯蜐?+\Armed Forces Middle East!!?葯蜐?+葯蜐?+KAlabama" ?葯蜐?+葯蜐?+KAlabama! ?葯蜐?+葯蜐?+KSegovia"?葯蜐?+葯蜐?+KSegovia!?葯蜐?+葯蜐?+KCaceres"?葯蜐?+葯蜐?+KCaceres!?葯蜐?+葯蜐?+JAlaska"?葯蜐?+葯蜐?+JAlaska!?葯蜐?+葯蜐?+YAppenzell Innerrhoden"?葯蜐?+葯蜐?+YAppenzell Innerrhoden!?葯蜐?+葯蜐?+KA Corua"?葯蜐?+葯蜐?+JAargau"?葯蜐?+葯蜐?+JAargau!?葯蜐?+葯蜐?+KIndiana"?葯蜐?+葯蜐?+KIndiana!?葯蜐?+葯蜐?+WArmed Forces Africa"?葯蜐?+葯蜐?+WArmed Forces Africa!?葯蜐?+葯蜐?+WArmed Forces Europe"?葯蜐?+葯蜐?+WArmed Forces Europe!?葯蜐?+葯蜐?+LIllinois"?葯蜐?+葯蜐?+LIllinois!?葯蜐?+葯蜐?+WArmed Forces Canada"?鄳蜐?+鄳蜐?+WArmed Forces Canada!?鄳蜐?+鄳蜐?+KAlberta"?鄳蜐?+鄳蜐?+KAlberta!?鄳蜐?+鄳蜐?+JTeruel"?鄳蜐?+鄳蜐?+JTeruel!?鄳蜐?+鄳蜐?+YArmed Forces Americas"?鄳蜐?+鄳蜐?+YArmed Forces Americas!?鄳蜐?+鄳蜐?+NPontevedra"?鄳蜐?+鄳蜐?+NPontevedra!?鄳蜐?+鄳蜐?+NLas Palmas"?鄳蜐?+鄳蜐?+NLas Palmas!?鄳蜐?+鄳蜐?+MCastellon"?鄳蜐?+鄳蜐?+MCastellon!?鄳蜐?+鄳蜐?+KA Corua!?鄳蜐?+鄳蜐?+HLeon"
?鄳蜐?+鄳蜐?+HLeon!
?鄳蜐?+鄳蜐?+IYukon"?鄳蜐?+鄳蜐?+SYukon Territory!?鄳蜐?+鄳蜐?+IIdaho"?鄳蜐?+鄳蜐?+IIdaho!?鄳蜐?+鄳蜐?+HIowa"
?鄳蜐?+鄳蜐?+HIowa!
?鄳蜐?+鄳蜐?+WNordrhein-Westfalen"	?鄳蜐?+鄳蜐?+WNordrhein-Westfalen!	?鄳蜐?+鄳蜐?+JQu?)bec"?鄳蜐?+鄳蜐?+JQuebec!?鄳蜐?+鄳蜐?+JLleida"7?鄳蜐?+鄳蜐?+JLleida!7?鄳蜐?+鄳蜐?+LAlbacete"6?鄳蜐?+鄳蜐?+LAlbacete!6?鄳蜐?+鄳蜐?+KVizcaya"5?鄳蜐?+鄳蜐?+KVizcaya!5?鄳蜐?+鄳蜐?+JZamora"4?鄳蜐?+鄳蜐?+JZamora!4?鄳蜐?+鄳蜐?+OPuerto Rico"3?鄳蜐?+鄳蜐?+OPuerto Rico!3?鄳蜐?+鄳蜐?+JHawaii"2?鄳蜐?+鄳蜐?+JHawaii!2?鄳蜐?+鄳蜐?+MGuipuzcoa"1?鄳蜐?+鄳蜐?+MGuipuzcoa!1鮰攒	B?釐聨爮~?P?"??鄶緯湒t?L?#?
髿
記
硿
崫
g?
F?
%?
?纰剑悿p?P?2??舂元かt?J? ??
浒
卤
牪
w?
I?
'?
?	娣	歉	煿	v?	T?	2?	?寰揽浝z?Y?6??锱似內]?7??萏吠??葯蜐?+葯蜐?+PSaskatchewan"D?葯蜐?+葯蜐?+PSaskatchewan!D?葯蜐?+葯蜐?+YAustralie-Occidentale"C?葯蜐?+葯蜐?+UWestern Australia!C?葯蜐?+葯蜐?+PSchaffhausen"B?葯蜐?+葯蜐?+PSchaffhausen!B?葯蜐?+葯蜐?+NSt. Gallen"A?葯蜐?+葯蜐?+NSt. Gallen!A?葯蜐?+葯蜐?+NValladolid"@?葯蜐?+葯蜐?+NValladolid!@?葯蜐?+葯蜐?+MTarragona"??葯蜐?+葯蜐?+MTarragona!??葯蜐?+葯蜐?+KCordoba">?葯蜐?+葯蜐?+KCordoba!>?葯蜐?+葯蜐?+OBasel-Stadt"=?葯蜐?+葯蜐?+OBasel-Stadt!=?葯蜐?+葯蜐?+QDakota du Sud"<?葯蜐?+葯蜐?+PSouth Dakota!<?葯蜐?+葯蜐?+LThringen";?葯蜐?+葯蜐?+LThringen!;?葯蜐?+葯蜐?+SCaroline du Sud":?葯蜐?+葯蜐?+RSouth Carolina!:?葯蜐?+葯蜐?+ITirol"9?葯蜐?+葯蜐?+ITirol!9?葯蜐?+葯蜐?+LSalzburg"8?葯蜐?+葯蜐?+LSalzburg!8?葯蜐?+葯蜐?+XAustralie-Mridionale"7?葯蜐?+葯蜐?+SSouth Australia!7?葯蜐?+葯蜐?+LAsturias"6?葯蜐?+葯蜐?+LAsturias!6?葯蜐?+葯蜐?+HJura"5?葯蜐?+葯蜐?+HJura!5?葯蜐?+葯蜐?+TBasel-Landschaft"4?葯蜐?+葯蜐?+TBasel-Landschaft!4?葯蜐?+葯蜐?+ZAppenzell Ausserrhoden"3?葯蜐?+葯蜐?+ZAppenzell Ausserrhoden!3?葯蜐?+葯蜐?+JHuesca"2?葯蜐?+葯蜐?+JHuesca!2?葯蜐?+葯蜐?+HBern"1?葯蜐?+葯蜐?+HBern!1?葯蜐?+葯蜐?+JHuelva"0?葯蜐?+葯蜐?+JHuelva!0?葯蜐?+葯蜐?+WColumbie Britanique"/?葯蜐?+葯蜐?+TBritish Columbia!/?葯蜐?+葯蜐?+ICeuta".?葯蜐?+葯蜐?+ICeuta!.?葯蜐?+葯蜐?+KArizona"-?葯蜐?+葯蜐?+KArizona!-?葯蜐?+葯蜐?+PRhode Island",?葯蜐?+葯蜐?+PRhode Island!,?葯蜐?+葯蜐?+JMadrid"+?葯蜐?+葯蜐?+JMadrid!+?葯蜐?+葯蜐?+ZNouvelle-Galles du Sud"*?葯蜐?+葯蜐?+SNew South Wales!*?葯蜐?+葯蜐?+RAmerican Samoa")?葯蜐?+葯蜐?+RAmerican Samoa!)?葯蜐?+葯蜐?+LArkansas"(?葯蜐?+葯蜐?+LArkansas!(?葯蜐?+葯蜐?+KMelilla"'?葯蜐?+葯蜐?+KMelilla!'?葯蜐?+葯蜐?+XArmed Forces Pacific"&?葯蜐?+葯蜐?+XArmed Forces Pacific!&?葯蜐?+葯蜐?+LLa Rioja"%?葯蜐?+葯蜐?+LLa Rioja!%?葯蜐?+葯蜐?+IZrich"$?葯蜐?+葯蜐?+IZrich!$磢'	*?輺簵槝u?S?0?
?鉂脼儬c?C?#?

蕙
喀
牕
??
`?
>?
?丨府棷v?U?'?掖喍b?A? ?

鼗
芳
柦
w?
W?鄳蜐?+鄳蜐?+IY?)men"_?鄳蜐?+鄳蜐?+IYemen!_?鄳蜐?+鄳蜐?+KVietnam"^?鄳蜐?+鄳蜐?+KVietnam!^?鄳蜐?+鄳蜐?+MV?)n?)zuela"]?鄳蜐?+鄳蜐?+MVenezuela!]?鄳蜐?+鄳蜐?+KUruguay"\?鄳蜐?+鄳蜐?+KUruguay!\?鄳蜐?+鄳蜐?+NEtats-Unis"[?鄳蜐?+鄳蜐?+QUnited States![?鄳蜐?+鄳蜐?+ORoyaume-Uni"Z?鄳蜐?+鄳蜐?+RUnited Kingdom!Z?鄳蜐?+鄳蜐?+WEmirats Arabes Unis"Y?鄳蜐?+鄳蜐?+XUnited Arab Emirates!Y?鄳蜐?+鄳蜐?+KUkraine"X?鄳蜐?+鄳蜐?+KUkraine!X?鄳蜐?+鄳蜐?+KTurquie"W?鄳蜐?+鄳蜐?+JTurkey!W?鄳蜐?+鄳蜐?+KTunisie"V?鄳蜐?+鄳蜐?+KTunisia!V?鄳蜐?+鄳蜐?+MTha?/lande"U?鄳蜐?+鄳蜐?+LThailand!U?鄳蜐?+鄳蜐?+JTaiwan"T?鄳蜐?+鄳蜐?+JTaiwan!T?鄳蜐?+鄳蜐?+ISyrie"S?鄳蜐?+鄳蜐?+ISyria!S?鄳蜐?+鄳蜐?+JSuisse"R?鄳蜐?+鄳蜐?+OSwitzerland!R?鄳蜐?+鄳蜐?+ISu?(de"Q?鄳蜐?+鄳蜐?+JSweden!Q?鄳蜐?+鄳蜐?+JSoudan"P?鄳蜐?+鄳蜐?+ISudan!P?鄳蜐?+鄳蜐?+KEspagne"O?鄳蜐?+鄳蜐?+ISpain!O?鄳蜐?+鄳蜐?+RAfrique du Sud"N?鄳蜐?+鄳蜐?+PSouth Africa!N?鄳蜐?+鄳蜐?+LSlov?)nie"M?鄳蜐?+鄳蜐?+LSlovenia!M?鄳蜐?+鄳蜐?+MSlovaquie"L?鄳蜐?+鄳蜐?+LSlovakia!L?鄳蜐?+鄳蜐?+MSingapour"K?鄳蜐?+鄳蜐?+MSingapore!K'	L????gG'	?
???
iD%
?
?
?
n
P
1
????{^A  ?!?"?#?$y%\&?' ()
?*
?+
?,
l-
A.
/	?0	?1	?2	?3	o4	K5	+6	7?8?9?:?;l<J=+>?闌華咰dDBE"FG釮翴嘖eLBL鄳蜐?+鄳蜐?+MIndon?)sie"&K鄳蜐?+鄳蜐?+MIndonesia!&J鄳蜐?+鄳蜐?+HInde"%I鄳蜐?+鄳蜐?+IIndia!%H鄳蜐?+鄳蜐?+KIslande"$G鄳蜐?+鄳蜐?+KIceland!$F鄳蜐?+鄳蜐?+KHongrie"#E鄳蜐?+鄳蜐?+KHungary!#D鄳蜐?+鄳蜐?+MHong-Kong""C鄳蜐?+鄳蜐?+MHong Kong!"B鄳蜐?+鄳蜐?+LHonduras"!A鄳蜐?+鄳蜐?+LHonduras!!@鄳蜐?+鄳蜐?+MGuatemala" ?鄳蜐?+鄳蜐?+MGuatemala! >鄳蜐?+鄳蜐?+IGr?(ce"=鄳蜐?+鄳蜐?+JGreece!<鄳蜐?+鄳蜐?+MAllemagne";鄳蜐?+鄳蜐?+KGermany!:鄳蜐?+鄳蜐?+JFrance"9鄳蜐?+鄳蜐?+JFrance!8鄳蜐?+鄳蜐?+LFinlande"7鄳蜐?+鄳蜐?+KFinland!6鄳蜐?+鄳蜐?+KEstonie"5鄳蜐?+鄳蜐?+KEstonia!4鄳蜐?+鄳蜐?+OEl Salvador"3鄳蜐?+鄳蜐?+OEl Salvador!2鄳蜐?+鄳蜐?+JEgypte"1鄳蜐?+鄳蜐?+IEgypt!0鄳蜐?+鄳蜐?+LEquateur"/鄳蜐?+鄳蜐?+KEcuador!.鄳蜐?+鄳蜐?+ZR?)publique Dominicaine"-鄳蜐?+鄳蜐?+VDominican Republic!,鄳蜐?+鄳蜐?+LDanemark"+鄳蜐?+鄳蜐?+KDenmark!*鄳蜐?+鄳蜐?+VR?)publique Tch?(que")鄳蜐?+鄳蜐?+RCzech Republic!(鄳蜐?+鄳蜐?+JChypre"'鄳蜐?+鄳蜐?+JCyprus!&鄳蜐?+鄳蜐?+HCuba"%鄳蜐?+鄳蜐?+HCuba!$鄳蜐?+鄳蜐?+KCroatie"#鄳蜐?+鄳蜐?+KCroatia!"鄳蜐?+鄳蜐?+NCosta Rica"!鄳蜐?+鄳蜐?+NCosta Rica! 鄳蜐?+鄳蜐?+LColombie"鄳蜐?+鄳蜐?+LColombia!鄳蜐?+鄳蜐?+IChine"/鄳蜐?+鄳蜐?+IChina!/鄳蜐?+鄳蜐?+IChili".鄳蜐?+鄳蜐?+IChile!.鄳蜐?+鄳蜐?+JCanada"-鄳蜐?+鄳蜐?+JCanada!-鄳蜐?+鄳蜐?+LBulgarie",鄳蜐?+鄳蜐?+LBulgaria!,鄳蜐?+鄳蜐?+JBr?)sil"+鄳蜐?+鄳蜐?+JBrazil!+鄳蜐?+鄳蜐?+VBosnie-Herz?)govine"*鄳蜐?+鄳蜐?+ZBosnia and Herzegovina!*鄳蜐?+鄳蜐?+KBolivie")鄳蜐?+鄳蜐?+KBolivia!)鄳蜐?+鄳蜐?+LBelgique"(鄳蜐?+鄳蜐?+KBelgium!(鄳蜐?+鄳蜐?+PBi?)lo-Russie"'
鄳蜐?+鄳蜐?+KBelarus!'鄳蜐?+鄳蜐?+KBahre?/n"&鄳蜐?+鄳蜐?+KBahrain!&
鄳蜐?+鄳蜐?+LAutriche"%	鄳蜐?+鄳蜐?+KAustria!%鄳蜐?+鄳蜐?+MAustralie"$7鄳蜐?+鄳蜐?+MAustralia!$6鄳蜐?+鄳蜐?+MArgentine"#5鄳蜐?+鄳蜐?+MArgentina!#4鄳蜐?+鄳蜐?+KAlg?)rie""3鄳蜐?+鄳蜐?+KAlgeria!"2鄳蜐?+鄳蜐?+KAlbanie"!1鄳蜐?+鄳蜐?+KAlbania!!鄳'	HM鉔芆哘gRGS)T
U霽蜽疿嶻jZD[%\]
鏭
芲

坅
jb
Lc
*d
e錰耮爃}i\j;kl?m鄋纎漰xqXr:st
鮱
裿

厁
cy
Dz
#{
|	閩	蕕	?	妧	h?	J?	*?	?鄥绬焽}?[?6??髮詬硯憦q?Q?+??鈹??鄳蜐?+鄳蜐?+JSerbie"J?鄳蜐?+鄳蜐?+JSerbia!J?鄳蜐?+鄳蜐?+SArabie Saoudite"I?鄳蜐?+鄳蜐?+PSaudi Arabia!I?鄳蜐?+鄳蜐?+JRussie"H?鄳蜐?+鄳蜐?+JRussia!H?鄳蜐?+鄳蜐?+LRoumanie"G?鄳蜐?+鄳蜐?+KRomania!G?鄳蜐?+鄳蜐?+IQatar"F?鄳蜐?+鄳蜐?+IQatar!F?鄳蜐?+鄳蜐?+NPorto Rico"E?鄳蜐?+鄳蜐?+OPuerto Rico!E?鄳蜐?+鄳蜐?+LPortugal"D?鄳蜐?+鄳蜐?+LPortugal!D?鄳蜐?+鄳蜐?+KPologne"C?鄳蜐?+鄳蜐?+JPoland!C?鄳蜐?+鄳蜐?+OPhilippines"B?鄳蜐?+鄳蜐?+OPhilippines!B?鄳蜐?+鄳蜐?+IP?)rou"A?鄳蜐?+鄳蜐?+HPeru!A?鄳蜐?+鄳蜐?+LParaguay"@鄳蜐?+鄳蜐?+LParaguay!@~鄳蜐?+鄳蜐?+JPanama"?}鄳蜐?+鄳蜐?+JPanama!?|鄳蜐?+鄳蜐?+HOman">{鄳蜐?+鄳蜐?+HOman!>z鄳蜐?+鄳蜐?+KNorv?(ge"=y鄳蜐?+鄳蜐?+JNorway!=x鄳蜐?+鄳蜐?+MNicaragua"<w鄳蜐?+鄳蜐?+MNicaragua!<v鄳蜐?+鄳蜐?+TNouvelle-Z?)lande";u鄳蜐?+鄳蜐?+ONew Zealand!;t鄳蜐?+鄳蜐?+LPays-Bas":s鄳蜐?+鄳蜐?+ONetherlands!:r鄳蜐?+鄳蜐?+IMaroc"9q鄳蜐?+鄳蜐?+KMorocco!9p鄳蜐?+鄳蜐?+NMont?)n?)gro"8o鄳蜐?+鄳蜐?+NMontenegro!8n鄳蜐?+鄳蜐?+KMexique"7m鄳蜐?+鄳蜐?+JMexico!7l鄳蜐?+鄳蜐?+IMalte"6k鄳蜐?+鄳蜐?+IMalta!6j鄳蜐?+鄳蜐?+LMalaisie"5i鄳蜐?+鄳蜐?+LMalaysia!5h鄳蜐?+鄳蜐?+MMac?)doine"4g鄳蜐?+鄳蜐?+MMacedonia!4f鄳蜐?+鄳蜐?+NLuxembourg"3e鄳蜐?+鄳蜐?+NLuxembourg!3d鄳蜐?+鄳蜐?+MLithuanie"2c鄳蜐?+鄳蜐?+MLithuania!2b鄳蜐?+鄳蜐?+ILibye"1a鄳蜐?+鄳蜐?+ILibya!1`鄳蜐?+鄳蜐?+ILiban"0_鄳蜐?+鄳蜐?+KLebanon!0^鄳蜐?+鄳蜐?+LLettonie"/]鄳蜐?+鄳蜐?+JLatvia!/\鄳蜐?+鄳蜐?+JKoweit".[鄳蜐?+鄳蜐?+JKuwait!.Z鄳蜐?+鄳蜐?+PCor?)e du Sud"-Y鄳蜐?+鄳蜐?+OSouth Korea!-X鄳蜐?+鄳蜐?+LJordanie",W鄳蜐?+鄳蜐?+JJordan!,V鄳蜐?+鄳蜐?+IJapon"+U鄳蜐?+鄳蜐?+IJapan!+T鄳蜐?+鄳蜐?+JItalie"*S鄳蜐?+鄳蜐?+IItaly!*R鄳蜐?+鄳蜐?+JIsra?+l")Q鄳蜐?+鄳蜐?+JIsrael!)P鄳蜐?+鄳蜐?+KIrlande"(O鄳蜐?+鄳蜐?+KIreland!(N鄳蜐?+鄳蜐?+HIrak"'M鄳蜐?+鄳蜐?+HIraq!'H ?$?????!k#T%@'')-?0?3?5?7?;~AgCLE/GI
騅
譓
縉
燩
僑
e[
G^
(_

a骳踖舊玥攊{[MERCH_CONF_SEQ_NEXT_VAL%YCUSTOMER_SEQ_NEXT_VAL"\SHP_CRT_ITM_SEQ_NEXT_VAL"XSHP_CRT_SEQ_NEXT_VAL"ZCUST_ATTR_SEQ_NEXT_VAL!\CUST_OPTSET_SEQ_NEXT_VAL!\DESCRIPTION_SEQ_NEXT_VALaCUSTOMER_OPT_VAL_SEQ_NEXT_VAL!`CUSTOMER_OPTION_SEQ_NEXT_VAL!`PRODUCT_OPT_VAL_SEQ_NEXT_VAL!_PRODUCT_OPTION_SEQ_NEXT_VAL!aPRODUCT_RELATION_SEQ_NEXT_VAL"ZSYST_CONF_SEQ_NEXT_VAL!]ORDER_TOTAL_ID_NEXT_VALUE!_ORDER_PRD_PRICE_ID_NEXT_VAL!bORDER_PRODUCT_DL_ID_NEXT_VALUE!_ORDER_PRODUCT_ID_NEXT_VALUE!]STATUS_HIST_ID_NEXT_VALUE!YORDER_ID_SEQ_NEXT_VAL!\PRODUCT_IMG_SEQ_NEXT_VAL!^PRODUCT_PRICE_SEQ_NEXT_VAL!^PRODUCT_AVAIL_SEQ_NEXT_VAL!XPRODUCT_SEQ_NEXT_VAL!YMANUFACT_SEQ_NEXT_VAL!YCATEGORY_SEQ_NEXT_VAL!UUSER_SEQ_NEXT_VAL![PERMISSION_SEQ_NEXT_VAL!VGROUP_SEQ_NEXT_VAL!YTX_CLASS_SEQ_NEXT_VAL!VSTORE_SEQ_NEXT_VAL!YMOD_CONF_SEQ_NEXT_VAL!YPRD_TYPE_SEQ_NEXT_VAL!YCURRENCY_SEQ_NEXT_VAL$UZONE_SEQ_NEXT_VAL$XCOUNTRY_SEQ_NEXT_VAL"ULANG_SEQ_NEXT_VAL!??x??????????????????????????????????????????|yvspmjgda^[XUROLIFC@=:741.+(%"

???????????????????????????????????????????}zwtqnkheb_\YVSPMJGDA>;852/,)&# 
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
~
{
x
u
r
o
l
i
f
c
`
]
Z
W
T
Q
N
K
H
E
B
?
<
9
6
3
0
-
*
'
$
!







	


??????????????????????????????????????????|yvspmjgda^[XUROLIFC@=:741.+(%"

????????????????????????????????????"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!Z????????????????????????????????????????????????|yvspmjgda^[XUROLIFC@=:741.+(%"

????????????????????????????????????|yvspmjgda^[XUROLIFC@=:741.+(%"


?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
??[?[?[?[?[?[?[?[?[?[?[?[?[?[?[?[?[?[?[?[?[?[{[x[w[u[t[s[r[p[o[k[i[g[`[_[][[[V[S[Q[P[O[G[<[:[-[,[)[([&[![ [[[[[[[[[
[[[?R?R?R?R?R?R?RRqRcRZRXRURMRFRBRAR=R5R4R3R1R$R"RRR?O?O?O?O?O?O?O?O?O?O?O?O}OyOvOnOmOlOjOfOeOdO^O\OYONOLOKO@O?O>O6O2O0O.O+O'O%O#OOOOOOOOO
OOOOOO??????????zWRE;	?-?-?-?-?-?-?-h-D-/----?%?%?%~%|%J%I%9%8%?$b$a$T$H$C$7$*$????11
????"!
???!?6
??
瘤
Z?}???
	琵	^?s?	?$? %
?ALTER TABLE SALESMANAGER.USER_GROUP ADD CONSTRAINT SALESMANAGER.FK_4EX9P3IHRXOYSN8K46KH965SF FOREIGN KEY(GROUP_ID) INDEX SALESMANAGER.FK_4EX9P3IHRXOYSN8K46KH965SF_INDEX_C REFERENCES SALESMANAGER.SM_GROUP(GROUP_ID) NOCHECK? !
cCREATE INDEX SALESMANAGER.FK_4EX9P3IHRXOYSN8K46KH965SF_INDEX_C ON SALESMANAGER.USER_GROUP(GROUP_ID)? %
?ALTER TABLE SALESMANAGER.USER ADD CONSTRAINT SALESMANAGER.FK_650CHNYAKTYNQQ6YKVJP39H0V FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.FK_650CHNYAKTYNQQ6YKVJP39H0V_INDEX_2 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? !
`CREATE INDEX SALESMANAGER.FK_650CHNYAKTYNQQ6YKVJP39H0V_INDEX_2 ON SALESMANAGER.USER(MERCHANT_ID)? %
?ALTER TABLE SALESMANAGER.USER ADD CONSTRAINT SALESMANAGER.FK_K7SH5KE7R2TLFE6NLLVPA7YNU FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_K7SH5KE7R2TLFE6NLLVPA7YNU_INDEX_2 REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
`CREATE INDEX SALESMANAGER.FK_K7SH5KE7R2TLFE6NLLVPA7YNU_INDEX_2 ON SALESMANAGER.USER(LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.TAX_RATE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_5G26JYNI5X8LI9APET7EO5ATG FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_5G26JYNI5X8LI9APET7EO5ATG_INDEX_2 REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
pCREATE INDEX SALESMANAGER.FK_5G26JYNI5X8LI9APET7EO5ATG_INDEX_2 ON SALESMANAGER.TAX_RATE_DESCRIPTION(LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.TAX_RATE ADD CONSTRAINT SALESMANAGER.FK_D505G6BRA836JA1KAMCNHKIJU FOREIGN KEY(ZONE_ID) INDEX SALESMANAGER.FK_D505G6BRA836JA1KAMCNHKIJU_INDEX_1 REFERENCES SALESMANAGER.ZONE(ZONE_ID) NOCHECK? !
`CREATE INDEX SALESMANAGER.FK_D505G6BRA836JA1KAMCNHKIJU_INDEX_1 ON SALESMANAGER.TAX_RATE(ZONE_ID)? %
?ALTER TABLE SALESMANAGER.TAX_RATE ADD CONSTRAINT SALESMANAGER.FK_Q45AVGTX0SCD4E5M2M3K6I3RV FOREIGN KEY(TAX_CLASS_ID) INDEX SALESMANAGER.FK_Q45AVGTX0SCD4E5M2M3K6I3RV_INDEX_1 REFERENCES SALESMANAGER.TAX_CLASS(TAX_CLASS_ID) NOCHECK? !
eCREATE INDEX SALESMANAGER.FK_Q45AVGTX0SCD4E5M2M3K6I3RV_INDEX_1 ON SALESMANAGER.TAX_RATE(TAX_CLASS_ID)? %
?ALTER TABLE SALESMANAGER.TAX_RATE ADD CONSTRAINT SALESMANAGER.FK_5G3SBAQBFH5FNY7EHF58PK869 FOREIGN KEY(PARENT_ID) INDEX SALESMANAGER.FK_5G3SBAQBFH5FNY7EHF58PK869_INDEX_1 REFERENCES SALESMANAGER.TAX_RATE(TAX_RATE_ID) NOCHECK(z??*x?+x?Tx?Ux?Vx?Wx??6?翩?
囪
?2?漓
仡
n?	堭	?.??? !
bCREATE INDEX SALESMANAGER.FK_5G3SBAQBFH5FNY7EHF58PK869_INDEX_1 ON SALESMANAGER.TAX_RATE(PARENT_ID)? %
?ALTER TABLE SALESMANAGER.TAX_RATE ADD CONSTRAINT SALESMANAGER.FK_35A95OA56QEQJQLTVFH5WO2H7 FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.FK_35A95OA56QEQJQLTVFH5WO2H7_INDEX_1 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? !
dCREATE INDEX SALESMANAGER.FK_35A95OA56QEQJQLTVFH5WO2H7_INDEX_1 ON SALESMANAGER.TAX_RATE(MERCHANT_ID)? %
?ALTER TABLE SALESMANAGER.TAX_RATE ADD CONSTRAINT SALESMANAGER.FK_4DK6CMP3GPA7Y7WUWBESVPETB FOREIGN KEY(COUNTRY_ID) INDEX SALESMANAGER.FK_4DK6CMP3GPA7Y7WUWBESVPETB_INDEX_1 REFERENCES SALESMANAGER.COUNTRY(COUNTRY_ID) NOCHECK? !
cCREATE INDEX SALESMANAGER.FK_4DK6CMP3GPA7Y7WUWBESVPETB_INDEX_1 ON SALESMANAGER.TAX_RATE(COUNTRY_ID)? %
?ALTER TABLE SALESMANAGER.SYSTEM_NOTIFICATION ADD CONSTRAINT SALESMANAGER.FK_JW5SEPS7HQ717MGSQJREQUEOU FOREIGN KEY(USER_ID) INDEX SALESMANAGER.FK_JW5SEPS7HQ717MGSQJREQUEOU_INDEX_8 REFERENCES SALESMANAGER.USER(USER_ID) NOCHECK? !
kCREATE INDEX SALESMANAGER.FK_JW5SEPS7HQ717MGSQJREQUEOU_INDEX_8 ON SALESMANAGER.SYSTEM_NOTIFICATION(USER_ID)? %
?ALTER TABLE SALESMANAGER.SM_TRANSACTION ADD CONSTRAINT SALESMANAGER.FK_AJWETT661PBJO6U9TK74OCHVE FOREIGN KEY(ORDER_ID) INDEX SALESMANAGER.FK_AJWETT661PBJO6U9TK74OCHVE_INDEX_D REFERENCES SALESMANAGER.ORDERS(ORDER_ID) NOCHECK? !
gCREATE INDEX SALESMANAGER.FK_AJWETT661PBJO6U9TK74OCHVE_INDEX_D ON SALESMANAGER.SM_TRANSACTION(ORDER_ID)? %
?ALTER TABLE SALESMANAGER.SHOPPING_CART_ITEM ADD CONSTRAINT SALESMANAGER.FK_8NWKBDVOVJBAQOVH1OMTDQD4S FOREIGN KEY(SHP_CART_ID) INDEX SALESMANAGER.FK_8NWKBDVOVJBAQOVH1OMTDQD4S_INDEX_B REFERENCES SALESMANAGER.SHOPPING_CART(SHP_CART_ID) NOCHECK? !
nCREATE INDEX SALESMANAGER.FK_8NWKBDVOVJBAQOVH1OMTDQD4S_INDEX_B ON SALESMANAGER.SHOPPING_CART_ITEM(SHP_CART_ID)? %
?ALTER TABLE SALESMANAGER.SHOPPING_CART_ATTR_ITEM ADD CONSTRAINT SALESMANAGER.FK_SC176CT7C75SMML3PPPGD6X7N FOREIGN KEY(SHP_CART_ITEM_ID) INDEX SALESMANAGER.FK_SC176CT7C75SMML3PPPGD6X7N_INDEX_4 REFERENCES SALESMANAGER.SHOPPING_CART_ITEM(SHP_CART_ITEM_ID) NOCHECKQx?Rx?????221\x?????2!!^x?~?6
?愗べ'?
,?驾修_?
j?		?朵7? !
xCREATE INDEX SALESMANAGER.FK_SC176CT7C75SMML3PPPGD6X7N_INDEX_4 ON SALESMANAGER.SHOPPING_CART_ATTR_ITEM(SHP_CART_ITEM_ID)? %
?ALTER TABLE SALESMANAGER.SHOPPING_CART ADD CONSTRAINT SALESMANAGER.FK_Q71CTU5SJTUIRD3F07PAIM1F2 FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.FK_Q71CTU5SJTUIRD3F07PAIM1F2_INDEX_5 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? !
iCREATE INDEX SALESMANAGER.FK_Q71CTU5SJTUIRD3F07PAIM1F2_INDEX_5 ON SALESMANAGER.SHOPPING_CART(MERCHANT_ID)? %
?ALTER TABLE SALESMANAGER.SHIPING_ORIGIN ADD CONSTRAINT SALESMANAGER.FK_QUBD75IIS2H2U0PMNCWP2ERGP FOREIGN KEY(ZONE_ID) INDEX SALESMANAGER.FK_QUBD75IIS2H2U0PMNCWP2ERGP_INDEX_D REFERENCES SALESMANAGER.ZONE(ZONE_ID) NOCHECK? !
fCREATE INDEX SALESMANAGER.FK_QUBD75IIS2H2U0PMNCWP2ERGP_INDEX_D ON SALESMANAGER.SHIPING_ORIGIN(ZONE_ID)? %
?ALTER TABLE SALESMANAGER.SHIPING_ORIGIN ADD CONSTRAINT SALESMANAGER.FK_8LVFNCPKDND2IVN245U3792K3 FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.FK_8LVFNCPKDND2IVN245U3792K3_INDEX_D REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? !
jCREATE INDEX SALESMANAGER.FK_8LVFNCPKDND2IVN245U3792K3_INDEX_D ON SALESMANAGER.SHIPING_ORIGIN(MERCHANT_ID)? %
?ALTER TABLE SALESMANAGER.SHIPING_ORIGIN ADD CONSTRAINT SALESMANAGER.FK_74FK2WQIC6O7IAYX04OJN63DU FOREIGN KEY(COUNTRY_ID) INDEX SALESMANAGER.FK_74FK2WQIC6O7IAYX04OJN63DU_INDEX_D REFERENCES SALESMANAGER.COUNTRY(COUNTRY_ID) NOCHECK? !
iCREATE INDEX SALESMANAGER.FK_74FK2WQIC6O7IAYX04OJN63DU_INDEX_D ON SALESMANAGER.SHIPING_ORIGIN(COUNTRY_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_REVIEW_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_N52R1GOFHI1SFANCU7LD7XP09 FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_N52R1GOFHI1SFANCU7LD7XP09_INDEX_A REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
vCREATE INDEX SALESMANAGER.FK_N52R1GOFHI1SFANCU7LD7XP09_INDEX_A ON SALESMANAGER.PRODUCT_REVIEW_DESCRIPTION(LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_REVIEW ADD CONSTRAINT SALESMANAGER.FK_I1VHR6IV0I07SY5OGJCB7N8UN FOREIGN KEY(PRODUCT_ID) INDEX SALESMANAGER.FK_I1VHR6IV0I07SY5OGJCB7N8UN_INDEX_1 REFERENCES SALESMANAGER.PRODUCT(PRODUCT_ID) NOCHECK? !
iCREATE INDEX SALESMANAGER.FK_I1VHR6IV0I07SY5OGJCB7N8UN_INDEX_1 ON SALESMANAGER.PRODUCT_REVIEW(PRODUCT_ID)Xx?Yx?Zx?[x?Dx?g?????????6!5!3!2!!!!?????????2665552213u?6?嬎囂?
?浶┭+?
1?	涸空M?]? %
?ALTER TABLE SALESMANAGER.PRODUCT_REVIEW ADD CONSTRAINT SALESMANAGER.FK_PVHCK0HGG98K948IGPH4WTJO1 FOREIGN KEY(CUSTOMERS_ID) INDEX SALESMANAGER.FK_PVHCK0HGG98K948IGPH4WTJO1_INDEX_1 REFERENCES SALESMANAGER.CUSTOMER(CUSTOMER_ID) NOCHECK? !
kCREATE INDEX SALESMANAGER.FK_PVHCK0HGG98K948IGPH4WTJO1_INDEX_1 ON SALESMANAGER.PRODUCT_REVIEW(CUSTOMERS_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_RELATIONSHIP ADD CONSTRAINT SALESMANAGER.FK_JLYFTE1WUVQGDXWWT2FNBG47G FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.FK_JLYFTE1WUVQGDXWWT2FNBG47G_INDEX_D REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? !
pCREATE INDEX SALESMANAGER.FK_JLYFTE1WUVQGDXWWT2FNBG47G_INDEX_D ON SALESMANAGER.PRODUCT_RELATIONSHIP(MERCHANT_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_RELATIONSHIP ADD CONSTRAINT SALESMANAGER.FK_D1M8PSP38JC0NK5UX56918EIK FOREIGN KEY(RELATED_PRODUCT_ID) INDEX SALESMANAGER.FK_D1M8PSP38JC0NK5UX56918EIK_INDEX_D REFERENCES SALESMANAGER.PRODUCT(PRODUCT_ID) NOCHECK? !
wCREATE INDEX SALESMANAGER.FK_D1M8PSP38JC0NK5UX56918EIK_INDEX_D ON SALESMANAGER.PRODUCT_RELATIONSHIP(RELATED_PRODUCT_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_RELATIONSHIP ADD CONSTRAINT SALESMANAGER.FK_SOI25DQ8DN9VMK1YIGGIVP2FL FOREIGN KEY(PRODUCT_ID) INDEX SALESMANAGER.FK_SOI25DQ8DN9VMK1YIGGIVP2FL_INDEX_D REFERENCES SALESMANAGER.PRODUCT(PRODUCT_ID) NOCHECK? !
oCREATE INDEX SALESMANAGER.FK_SOI25DQ8DN9VMK1YIGGIVP2FL_INDEX_D ON SALESMANAGER.PRODUCT_RELATIONSHIP(PRODUCT_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_PRICE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_FYKBB1JC6RP1NSIAAJ9UR40UM FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_FYKBB1JC6RP1NSIAAJ9UR40UM_INDEX_5 REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
uCREATE INDEX SALESMANAGER.FK_FYKBB1JC6RP1NSIAAJ9UR40UM_INDEX_5 ON SALESMANAGER.PRODUCT_PRICE_DESCRIPTION(LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_PRICE ADD CONSTRAINT SALESMANAGER.FK_BT21FP36GAI74HFOSFO02WUCX FOREIGN KEY(PRODUCT_AVAIL_ID) INDEX SALESMANAGER.FK_BT21FP36GAI74HFOSFO02WUCX_INDEX_4 REFERENCES SALESMANAGER.PRODUCT_AVAILABILITY(PRODUCT_AVAIL_ID) NOCHECK? !
nCREATE INDEX SALESMANAGER.FK_BT21FP36GAI74HFOSFO02WUCX_INDEX_4 ON SALESMANAGER.PRODUCT_PRICE(PRODUCT_AVAIL_ID)Az????????6532o?????????!?!?!?!?!?!????????654321l????!c????!?'6?懢*?
0?耗魄C?
B? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION_VALUE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_HMJMI3K2K2XTS6R1B3H59P7DJ FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_HMJMI3K2K2XTS6R1B3H59P7DJ_INDEX_1 REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
|CREATE INDEX SALESMANAGER.FK_HMJMI3K2K2XTS6R1B3H59P7DJ_INDEX_1 ON SALESMANAGER.PRODUCT_OPTION_VALUE_DESCRIPTION(LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION_DESC ADD CONSTRAINT SALESMANAGER.FK_23NQIG56QILWN2F6D76CL5UBX FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_23NQIG56QILWN2F6D76CL5UBX_INDEX_8 REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
oCREATE INDEX SALESMANAGER.FK_23NQIG56QILWN2F6D76CL5UBX_INDEX_8 ON SALESMANAGER.PRODUCT_OPTION_DESC(LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_IMAGE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_RO5T1GKS1IMAT7HJI5P7HESSP FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_RO5T1GKS1IMAT7HJI5P7HESSP_INDEX_7 REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
uCREATE INDEX SALESMANAGER.FK_RO5T1GKS1IMAT7HJI5P7HESSP_INDEX_7 ON SALESMANAGER.PRODUCT_IMAGE_DESCRIPTION(LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_IMAGE ADD CONSTRAINT SALESMANAGER.FK_DMPWG0PDBOTJF8H0CA15TX3QM FOREIGN KEY(PRODUCT_ID) INDEX SALESMANAGER.FK_DMPWG0PDBOTJF8H0CA15TX3QM_INDEX_4 REFERENCES SALESMANAGER.PRODUCT(PRODUCT_ID) NOCHECK? !
hCREATE INDEX SALESMANAGER.FK_DMPWG0PDBOTJF8H0CA15TX3QM_INDEX_4 ON SALESMANAGER.PRODUCT_IMAGE(PRODUCT_ID)Nx?????????654321f?????????!?!?!?!?!?!??????????76443333E6
?挳灟+?
<?某洞@?
N?	鄯旮4?竞?? %
?ALTER TABLE SALESMANAGER.PRODUCT_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_ADHNR56RRG1B3V9UFOEY6VJFS FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_ADHNR56RRG1B3V9UFOEY6VJFS_INDEX_3 REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
oCREATE INDEX SALESMANAGER.FK_ADHNR56RRG1B3V9UFOEY6VJFS_INDEX_3 ON SALESMANAGER.PRODUCT_DESCRIPTION(LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_CATEGORY ADD CONSTRAINT SALESMANAGER.FK_CU9I33D6DBYO4S8JMFEPOYN59 FOREIGN KEY(PRODUCT_ID) REFERENCES SALESMANAGER.PRODUCT(PRODUCT_ID) NOCHECK? %
?ALTER TABLE SALESMANAGER.PRODUCT_CATEGORY ADD CONSTRAINT SALESMANAGER.FK_J0ABHUUIFVOJG9079R0NJJA07 FOREIGN KEY(CATEGORY_ID) INDEX SALESMANAGER.FK_J0ABHUUIFVOJG9079R0NJJA07_INDEX_3 REFERENCES SALESMANAGER.CATEGORY(CATEGORY_ID) NOCHECK? !
lCREATE INDEX SALESMANAGER.FK_J0ABHUUIFVOJG9079R0NJJA07_INDEX_3 ON SALESMANAGER.PRODUCT_CATEGORY(CATEGORY_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_AVAILABILITY ADD CONSTRAINT SALESMANAGER.FK_G32KJ493NTGJNKY10L88Q8BA7 FOREIGN KEY(PRODUCT_ID) INDEX SALESMANAGER.FK_G32KJ493NTGJNKY10L88Q8BA7_INDEX_6 REFERENCES SALESMANAGER.PRODUCT(PRODUCT_ID) NOCHECK? !
oCREATE INDEX SALESMANAGER.FK_G32KJ493NTGJNKY10L88Q8BA7_INDEX_6 ON SALESMANAGER.PRODUCT_AVAILABILITY(PRODUCT_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_ATTRIBUTE ADD CONSTRAINT SALESMANAGER.FK_G2H5GDHGCBN7B3CR26SJ6AX4C FOREIGN KEY(OPTION_VALUE_ID) INDEX SALESMANAGER.FK_G2H5GDHGCBN7B3CR26SJ6AX4C_INDEX_8 REFERENCES SALESMANAGER.PRODUCT_OPTION_VALUE(PRODUCT_OPTION_VALUE_ID) NOCHECK? !
qCREATE INDEX SALESMANAGER.FK_G2H5GDHGCBN7B3CR26SJ6AX4C_INDEX_8 ON SALESMANAGER.PRODUCT_ATTRIBUTE(OPTION_VALUE_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_ATTRIBUTE ADD CONSTRAINT SALESMANAGER.FK_6H8M6OCG2JHU3BFIEQA0DUPB1 FOREIGN KEY(PRODUCT_ID) INDEX SALESMANAGER.FK_6H8M6OCG2JHU3BFIEQA0DUPB1_INDEX_8 REFERENCES SALESMANAGER.PRODUCT(PRODUCT_ID) NOCHECK? !
lCREATE INDEX SALESMANAGER.FK_6H8M6OCG2JHU3BFIEQA0DUPB1_INDEX_8 ON SALESMANAGER.PRODUCT_ATTRIBUTE(PRODUCT_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT ADD CONSTRAINT SALESMANAGER.FK_NOR0I9E2AVL4YYIOIVXYXPR28 FOREIGN KEY(PRODUCT_TYPE_ID) INDEX SALESMANAGER.FK_NOR0I9E2AVL4YYIOIVXYXPR28_INDEX_1 REFERENCES SALESMANAGER.PRODUCT_TYPE(PRODUCT_TYPE_ID) NOCHECK? !
gCREATE INDEX SALESMANAGER.FK_NOR0I9E2AVL4YYIOIVXYXPR28_INDEX_1 ON SALESMANAGER.PRODUCT(PRODUCT_TYPE_ID)????????654321tx?ux?$????????111111u|???????1,????????543321X6
?隣墶
湤
1?M?荪
颚
~?	墾	?'?棘?? %
?ALTER TABLE SALESMANAGER.PRODUCT ADD CONSTRAINT SALESMANAGER.FK_PM6EF7Y9LXY9XEAV2DVCR4N4P FOREIGN KEY(TAX_CLASS_ID) INDEX SALESMANAGER.FK_PM6EF7Y9LXY9XEAV2DVCR4N4P_INDEX_1 REFERENCES SALESMANAGER.TAX_CLASS(TAX_CLASS_ID) NOCHECK? !
dCREATE INDEX SALESMANAGER.FK_PM6EF7Y9LXY9XEAV2DVCR4N4P_INDEX_1 ON SALESMANAGER.PRODUCT(TAX_CLASS_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT ADD CONSTRAINT SALESMANAGER.FK_T03UWPH4R4SI70SIIQAFFF3QJ FOREIGN KEY(MANUFACTURER_ID) INDEX SALESMANAGER.FK_T03UWPH4R4SI70SIIQAFFF3QJ_INDEX_1 REFERENCES SALESMANAGER.MANUFACTURER(MANUFACTURER_ID) NOCHECK? !
gCREATE INDEX SALESMANAGER.FK_T03UWPH4R4SI70SIIQAFFF3QJ_INDEX_1 ON SALESMANAGER.PRODUCT(MANUFACTURER_ID)? %
?ALTER TABLE SALESMANAGER.PERMISSION_GROUP ADD CONSTRAINT SALESMANAGER.FK_NNGTFYDO0O1I7W2LV6K4CSUT FOREIGN KEY(PERMISSION_ID) INDEX SALESMANAGER.FK_NNGTFYDO0O1I7W2LV6K4CSUT_INDEX_9 REFERENCES SALESMANAGER.PERMISSION(PERMISSION_ID) NOCHECK? !
mCREATE INDEX SALESMANAGER.FK_NNGTFYDO0O1I7W2LV6K4CSUT_INDEX_9 ON SALESMANAGER.PERMISSION_GROUP(PERMISSION_ID)? %
?ALTER TABLE SALESMANAGER.PERMISSION_GROUP ADD CONSTRAINT SALESMANAGER.FK_PJ2GJYGLDR9P81W673A27TAW3 FOREIGN KEY(GROUP_ID) INDEX SALESMANAGER.FK_PJ2GJYGLDR9P81W673A27TAW3_INDEX_9 REFERENCES SALESMANAGER.SM_GROUP(GROUP_ID) NOCHECK? !
iCREATE INDEX SALESMANAGER.FK_PJ2GJYGLDR9P81W673A27TAW3_INDEX_9 ON SALESMANAGER.PERMISSION_GROUP(GROUP_ID)? %
?ALTER TABLE SALESMANAGER.ORDER_TOTAL ADD CONSTRAINT SALESMANAGER.FK_KHQUIWOXP3MPAOLSY0HSLFJCH FOREIGN KEY(ORDER_ID) INDEX SALESMANAGER.FK_KHQUIWOXP3MPAOLSY0HSLFJCH_INDEX_2 REFERENCES SALESMANAGER.ORDERS(ORDER_ID) NOCHECK? !
dCREATE INDEX SALESMANAGER.FK_KHQUIWOXP3MPAOLSY0HSLFJCH_INDEX_2 ON SALESMANAGER.ORDER_TOTAL(ORDER_ID)? %
?ALTER TABLE SALESMANAGER.ORDER_STATUS_HISTORY ADD CONSTRAINT SALESMANAGER.FK_N14SLYP7Y649Y5RHBMIKW3PI0 FOREIGN KEY(ORDER_ID) INDEX SALESMANAGER.FK_N14SLYP7Y649Y5RHBMIKW3PI0_INDEX_5 REFERENCES SALESMANAGER.ORDERS(ORDER_ID) NOCHECK? !
mCREATE INDEX SALESMANAGER.FK_N14SLYP7Y649Y5RHBMIKW3PI0_INDEX_5 ON SALESMANAGER.ORDER_STATUS_HISTORY(ORDER_ID)? %
?ALTER TABLE SALESMANAGER.ORDER_PRODUCT_PRICE ADD CONSTRAINT SALESMANAGER.FK_SHR0WNAKWVOD5VKSCEH64UMFY FOREIGN KEY(ORDER_PRODUCT_ID) INDEX SALESMANAGER.FK_SHR0WNAKWVOD5VKSCEH64UMFY_INDEX_8 REFERENCES SALESMANAGER.ORDER_PRODUCT(ORDER_PRODUCT_ID) NOCHECKP??#???????????????????????????????????#-",!, ,+++***)))((('''&&&
%%%
$	$$$$##"!!Q??#???????????????????????????????????#'&%
%"$$$$$	$
##!""""""""""" !!!!!!!!!!!!.?????111/???1,???1-???1xx?D6??
翑
D???聴
綐
P?	j?霙錅f?`??? !
tCREATE INDEX SALESMANAGER.FK_SHR0WNAKWVOD5VKSCEH64UMFY_INDEX_8 ON SALESMANAGER.ORDER_PRODUCT_PRICE(ORDER_PRODUCT_ID)? %
?ALTER TABLE SALESMANAGER.ORDER_PRODUCT_DOWNLOAD ADD CONSTRAINT SALESMANAGER.FK_52KB521VE197OF5311BU3EE5B FOREIGN KEY(ORDER_PRODUCT_ID) INDEX SALESMANAGER.FK_52KB521VE197OF5311BU3EE5B_INDEX_F REFERENCES SALESMANAGER.ORDER_PRODUCT(ORDER_PRODUCT_ID) NOCHECK? !
wCREATE INDEX SALESMANAGER.FK_52KB521VE197OF5311BU3EE5B_INDEX_F ON SALESMANAGER.ORDER_PRODUCT_DOWNLOAD(ORDER_PRODUCT_ID)? %
?ALTER TABLE SALESMANAGER.ORDER_PRODUCT_ATTRIBUTE ADD CONSTRAINT SALESMANAGER.FK_5RJWLJ26IV0E3VNUAJJINIEK7 FOREIGN KEY(ORDER_PRODUCT_ID) INDEX SALESMANAGER.FK_5RJWLJ26IV0E3VNUAJJINIEK7_INDEX_2 REFERENCES SALESMANAGER.ORDER_PRODUCT(ORDER_PRODUCT_ID) NOCHECK? !
xCREATE INDEX SALESMANAGER.FK_5RJWLJ26IV0E3VNUAJJINIEK7_INDEX_2 ON SALESMANAGER.ORDER_PRODUCT_ATTRIBUTE(ORDER_PRODUCT_ID)? %
?ALTER TABLE SALESMANAGER.ORDER_PRODUCT ADD CONSTRAINT SALESMANAGER.FK_4NSXTA166QMI0U7V02P6GTNXA FOREIGN KEY(ORDER_ID) INDEX SALESMANAGER.FK_4NSXTA166QMI0U7V02P6GTNXA_INDEX_9 REFERENCES SALESMANAGER.ORDERS(ORDER_ID) NOCHECK? !
fCREATE INDEX SALESMANAGER.FK_4NSXTA166QMI0U7V02P6GTNXA_INDEX_9 ON SALESMANAGER.ORDER_PRODUCT(ORDER_ID)? %
?ALTER TABLE SALESMANAGER.ORDER_ACCOUNT_PRODUCT ADD CONSTRAINT SALESMANAGER.FK_PCOTJAC5EU4PMSL4DHAQ024PO FOREIGN KEY(ORDER_PRODUCT_ID) INDEX SALESMANAGER.FK_PCOTJAC5EU4PMSL4DHAQ024PO_INDEX_2 REFERENCES SALESMANAGER.ORDER_PRODUCT(ORDER_PRODUCT_ID) NOCHECK? !
vCREATE INDEX SALESMANAGER.FK_PCOTJAC5EU4PMSL4DHAQ024PO_INDEX_2 ON SALESMANAGER.ORDER_ACCOUNT_PRODUCT(ORDER_PRODUCT_ID)? %
?ALTER TABLE SALESMANAGER.ORDER_ACCOUNT_PRODUCT ADD CONSTRAINT SALESMANAGER.FK_RH6OTA16GUHS9W00TRR64087G FOREIGN KEY(ORDER_ACCOUNT_ID) INDEX SALESMANAGER.FK_RH6OTA16GUHS9W00TRR64087G_INDEX_2 REFERENCES SALESMANAGER.ORDER_ACCOUNT(ORDER_ACCOUNT_ID) NOCHECK? !
vCREATE INDEX SALESMANAGER.FK_RH6OTA16GUHS9W00TRR64087G_INDEX_2 ON SALESMANAGER.ORDER_ACCOUNT_PRODUCT(ORDER_ACCOUNT_ID)? %
?ALTER TABLE SALESMANAGER.ORDER_ACCOUNT ADD CONSTRAINT SALESMANAGER.FK_JWOVCYS19BO3GYRKO0KJ0DH4L FOREIGN KEY(ORDER_ID) INDEX SALESMANAGER.FK_JWOVCYS19BO3GYRKO0KJ0DH4L_INDEX_6 REFERENCES SALESMANAGER.ORDERS(ORDER_ID) NOCHECK? !
fCREATE INDEX SALESMANAGER.FK_JWOVCYS19BO3GYRKO0KJ0DH4L_INDEX_6 ON SALESMANAGER.ORDER_ACCOUNT(ORDER_ID)? %
?ALTER TABLE SALESMANAGER.ORDERS ADD CONSTRAINT SALESMANAGER.FK_3B8CM7LVBXJBTEPJN64NNBTC0 FOREIGN KEY(MERCHANTID) INDEX SALESMANAGER.FK_3B8CM7LVBXJBTEPJN64NNBTC0_INDEX_8 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK(???1{x?dx?ex?D???!R???6???-"]6
?搫皢@?
T?鐗?泲
磳
C?	V?鑿??? !
aCREATE INDEX SALESMANAGER.FK_3B8CM7LVBXJBTEPJN64NNBTC0_INDEX_8 ON SALESMANAGER.ORDERS(MERCHANTID)? %
?ALTER TABLE SALESMANAGER.ORDERS ADD CONSTRAINT SALESMANAGER.FK_HQ0MW7HIXMTA7Q34OHL1G18WL FOREIGN KEY(DELIVERY_ZONE_ID) INDEX SALESMANAGER.FK_HQ0MW7HIXMTA7Q34OHL1G18WL_INDEX_8 REFERENCES SALESMANAGER.ZONE(ZONE_ID) NOCHECK? !
gCREATE INDEX SALESMANAGER.FK_HQ0MW7HIXMTA7Q34OHL1G18WL_INDEX_8 ON SALESMANAGER.ORDERS(DELIVERY_ZONE_ID)? %
?ALTER TABLE SALESMANAGER.ORDERS ADD CONSTRAINT SALESMANAGER.FK_4LKAW8WSVT2MFMWNA70LCTUU8 FOREIGN KEY(DELIVERY_COUNTRY_ID) INDEX SALESMANAGER.FK_4LKAW8WSVT2MFMWNA70LCTUU8_INDEX_8 REFERENCES SALESMANAGER.COUNTRY(COUNTRY_ID) NOCHECK? !
jCREATE INDEX SALESMANAGER.FK_4LKAW8WSVT2MFMWNA70LCTUU8_INDEX_8 ON SALESMANAGER.ORDERS(DELIVERY_COUNTRY_ID)? %
?ALTER TABLE SALESMANAGER.ORDERS ADD CONSTRAINT SALESMANAGER.FK_IB790H1PASU1N7MYE2HXL3I99 FOREIGN KEY(CURRENCY_ID) INDEX SALESMANAGER.FK_IB790H1PASU1N7MYE2HXL3I99_INDEX_8 REFERENCES SALESMANAGER.CURRENCY(CURRENCY_ID) NOCHECK? !
bCREATE INDEX SALESMANAGER.FK_IB790H1PASU1N7MYE2HXL3I99_INDEX_8 ON SALESMANAGER.ORDERS(CURRENCY_ID)? %
?ALTER TABLE SALESMANAGER.ORDERS ADD CONSTRAINT SALESMANAGER.FK_8E0096USK6UBO6G1M4G02CDG9 FOREIGN KEY(BILLING_ZONE_ID) INDEX SALESMANAGER.FK_8E0096USK6UBO6G1M4G02CDG9_INDEX_8 REFERENCES SALESMANAGER.ZONE(ZONE_ID) NOCHECK? !
fCREATE INDEX SALESMANAGER.FK_8E0096USK6UBO6G1M4G02CDG9_INDEX_8 ON SALESMANAGER.ORDERS(BILLING_ZONE_ID)? %
?ALTER TABLE SALESMANAGER.ORDERS ADD CONSTRAINT SALESMANAGER.FK_FNBC9PW6WAEWB1YRALIUTNHH1 FOREIGN KEY(BILLING_COUNTRY_ID) INDEX SALESMANAGER.FK_FNBC9PW6WAEWB1YRALIUTNHH1_INDEX_8 REFERENCES SALESMANAGER.COUNTRY(COUNTRY_ID) NOCHECK? !
iCREATE INDEX SALESMANAGER.FK_FNBC9PW6WAEWB1YRALIUTNHH1_INDEX_8 ON SALESMANAGER.ORDERS(BILLING_COUNTRY_ID)? %
?ALTER TABLE SALESMANAGER.MERCHANT_STORE ADD CONSTRAINT SALESMANAGER.FK_141243R2VTH00RQ0LYEM39ABO FOREIGN KEY(ZONE_ID) INDEX SALESMANAGER.FK_141243R2VTH00RQ0LYEM39ABO_INDEX_A REFERENCES SALESMANAGER.ZONE(ZONE_ID) NOCHECK? !
fCREATE INDEX SALESMANAGER.FK_141243R2VTH00RQ0LYEM39ABO_INDEX_A ON SALESMANAGER.MERCHANT_STORE(ZONE_ID)綦??iV???:???-X???L???!??i>???-?'6
?咗岥?
*?湖??]?
n?	齻	? %
?ALTER TABLE SALESMANAGER.MERCHANT_STORE ADD CONSTRAINT SALESMANAGER.FK_TCJ9CBM9UR5ITU2C6WRCT1DNQ FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_TCJ9CBM9UR5ITU2C6WRCT1DNQ_INDEX_A REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
jCREATE INDEX SALESMANAGER.FK_TCJ9CBM9UR5ITU2C6WRCT1DNQ_INDEX_A ON SALESMANAGER.MERCHANT_STORE(LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.MERCHANT_STORE ADD CONSTRAINT SALESMANAGER.FK_4UYYJJYS5BUUI6OE3VP84K5IP FOREIGN KEY(CURRENCY_ID) INDEX SALESMANAGER.FK_4UYYJJYS5BUUI6OE3VP84K5IP_INDEX_A REFERENCES SALESMANAGER.CURRENCY(CURRENCY_ID) NOCHECK? !
jCREATE INDEX SALESMANAGER.FK_4UYYJJYS5BUUI6OE3VP84K5IP_INDEX_A ON SALESMANAGER.MERCHANT_STORE(CURRENCY_ID)? %
?ALTER TABLE SALESMANAGER.MERCHANT_STORE ADD CONSTRAINT SALESMANAGER.FK_4K1MV6PIKWUES6F2UHNJU0AJ6 FOREIGN KEY(COUNTRY_ID) INDEX SALESMANAGER.FK_4K1MV6PIKWUES6F2UHNJU0AJ6_INDEX_A REFERENCES SALESMANAGER.COUNTRY(COUNTRY_ID) NOCHECK? !
iCREATE INDEX SALESMANAGER.FK_4K1MV6PIKWUES6F2UHNJU0AJ6_INDEX_A ON SALESMANAGER.MERCHANT_STORE(COUNTRY_ID)? %
?ALTER TABLE SALESMANAGER.MERCHANT_LOG ADD CONSTRAINT SALESMANAGER.FK_G76DEOLJU6SF5IKVOE5IR23Q3 FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.FK_G76DEOLJU6SF5IKVOE5IR23Q3_INDEX_A REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? !
hCREATE INDEX SALESMANAGER.FK_G76DEOLJU6SF5IKVOE5IR23Q3_INDEX_A ON SALESMANAGER.MERCHANT_LOG(MERCHANT_ID)? %
?ALTER TABLE SALESMANAGER.MANUFACTURER_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_886779UO5MVSJX1AFLIJS3LDI FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_886779UO5MVSJX1AFLIJS3LDI_INDEX_2 REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
tCREATE INDEX SALESMANAGER.FK_886779UO5MVSJX1AFLIJS3LDI_INDEX_2 ON SALESMANAGER.MANUFACTURER_DESCRIPTION(LANGUAGE_ID)jx?E????????!?!?!?!?!攛?涧???!6'6?夐旍?鲲w?z??
? %
?ALTER TABLE SALESMANAGER.GEOZONE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_1LCBKC4TT49Q5QBUE3M9P29C2 FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_1LCBKC4TT49Q5QBUE3M9P29C2_INDEX_1 REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
oCREATE INDEX SALESMANAGER.FK_1LCBKC4TT49Q5QBUE3M9P29C2_INDEX_1 ON SALESMANAGER.GEOZONE_DESCRIPTION(LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPT_VAL_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_5TAN60TG9D812TI5HG0CH784F FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_5TAN60TG9D812TI5HG0CH784F_INDEX_B REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
xCREATE INDEX SALESMANAGER.FK_5TAN60TG9D812TI5HG0CH784F_INDEX_B ON SALESMANAGER.CUSTOMER_OPT_VAL_DESCRIPTION(LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION_SET ADD CONSTRAINT SALESMANAGER.FK_8ROMMESMAVDIJ4J64U80RNPF5 FOREIGN KEY(CUSTOMER_OPTION_VALUE_ID) INDEX SALESMANAGER.FK_8ROMMESMAVDIJ4J64U80RNPF5_INDEX_5 REFERENCES SALESMANAGER.CUSTOMER_OPTION_VALUE(CUSTOMER_OPTION_VALUE_ID) NOCHECK? !
|CREATE INDEX SALESMANAGER.FK_8ROMMESMAVDIJ4J64U80RNPF5_INDEX_5 ON SALESMANAGER.CUSTOMER_OPTION_SET(CUSTOMER_OPTION_VALUE_ID)? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION_DESC ADD CONSTRAINT SALESMANAGER.FK_I3PT01Q982O6F1EELF2WGG16A FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_I3PT01Q982O6F1EELF2WGG16A_INDEX_4 REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
pCREATE INDEX SALESMANAGER.FK_I3PT01Q982O6F1EELF2WGG16A_INDEX_4 ON SALESMANAGER.CUSTOMER_OPTION_DESC(LANGUAGE_ID)沫??1抚???!毛??1骸??'鷳6
??≯
卉
P?a?爝

??	o?	??ф?? %
?ALTER TABLE SALESMANAGER.CUSTOMER_GROUP ADD CONSTRAINT SALESMANAGER.FK_KMD61IH4BV0AAOFDYEL8D2SE1 FOREIGN KEY(CUSTOMER_ID) INDEX SALESMANAGER.FK_KMD61IH4BV0AAOFDYEL8D2SE1_INDEX_3 REFERENCES SALESMANAGER.CUSTOMER(CUSTOMER_ID) NOCHECK? !
jCREATE INDEX SALESMANAGER.FK_KMD61IH4BV0AAOFDYEL8D2SE1_INDEX_3 ON SALESMANAGER.CUSTOMER_GROUP(CUSTOMER_ID)? %
?ALTER TABLE SALESMANAGER.CUSTOMER_GROUP ADD CONSTRAINT SALESMANAGER.FK_7DGMJIV744AK7617BLNSQM560 FOREIGN KEY(GROUP_ID) INDEX SALESMANAGER.FK_7DGMJIV744AK7617BLNSQM560_INDEX_3 REFERENCES SALESMANAGER.SM_GROUP(GROUP_ID) NOCHECK? !
gCREATE INDEX SALESMANAGER.FK_7DGMJIV744AK7617BLNSQM560_INDEX_3 ON SALESMANAGER.CUSTOMER_GROUP(GROUP_ID)? %
?ALTER TABLE SALESMANAGER.CUSTOMER_ATTRIBUTE ADD CONSTRAINT SALESMANAGER.FK_CAEOVXJXL3IYA5JMOAUQSXF9K FOREIGN KEY(OPTION_VALUE_ID) INDEX SALESMANAGER.FK_CAEOVXJXL3IYA5JMOAUQSXF9K_INDEX_5 REFERENCES SALESMANAGER.CUSTOMER_OPTION_VALUE(CUSTOMER_OPTION_VALUE_ID) NOCHECK? !
rCREATE INDEX SALESMANAGER.FK_CAEOVXJXL3IYA5JMOAUQSXF9K_INDEX_5 ON SALESMANAGER.CUSTOMER_ATTRIBUTE(OPTION_VALUE_ID)? %
?ALTER TABLE SALESMANAGER.CUSTOMER_ATTRIBUTE ADD CONSTRAINT SALESMANAGER.FK_29FKUIAADEUS36GASL9Q1TSQ3 FOREIGN KEY(CUSTOMER_ID) INDEX SALESMANAGER.FK_29FKUIAADEUS36GASL9Q1TSQ3_INDEX_5 REFERENCES SALESMANAGER.CUSTOMER(CUSTOMER_ID) NOCHECK? !
nCREATE INDEX SALESMANAGER.FK_29FKUIAADEUS36GASL9Q1TSQ3_INDEX_5 ON SALESMANAGER.CUSTOMER_ATTRIBUTE(CUSTOMER_ID)? %
?ALTER TABLE SALESMANAGER.CUSTOMER ADD CONSTRAINT SALESMANAGER.FK_J00DJ3M9TCAC4SUA8AJQLN77A FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.FK_J00DJ3M9TCAC4SUA8AJQLN77A_INDEX_5 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? !
dCREATE INDEX SALESMANAGER.FK_J00DJ3M9TCAC4SUA8AJQLN77A_INDEX_5 ON SALESMANAGER.CUSTOMER(MERCHANT_ID)? %
?ALTER TABLE SALESMANAGER.CUSTOMER ADD CONSTRAINT SALESMANAGER.FK_2ATBO3AJE6MI15GK8P7A5QVXB FOREIGN KEY(DELIVERY_ZONE_ID) INDEX SALESMANAGER.FK_2ATBO3AJE6MI15GK8P7A5QVXB_INDEX_5 REFERENCES SALESMANAGER.ZONE(ZONE_ID) NOCHECK? !
iCREATE INDEX SALESMANAGER.FK_2ATBO3AJE6MI15GK8P7A5QVXB_INDEX_5 ON SALESMANAGER.CUSTOMER(DELIVERY_ZONE_ID)? %
?ALTER TABLE SALESMANAGER.CUSTOMER ADD CONSTRAINT SALESMANAGER.FK_K7GT46OIMA5W2H4WQ84HHG19C FOREIGN KEY(DELIVERY_COUNTRY_ID) INDEX SALESMANAGER.FK_K7GT46OIMA5W2H4WQ84HHG19C_INDEX_5 REFERENCES SALESMANAGER.COUNTRY(COUNTRY_ID) NOCHECK潍??1汐??1紱???2!!蛙???2臊???-2!粵???2!!瘖???2?(6
?椞餐<?
H?垩鲆動
栐
'?	B?鬃钬{? !
lCREATE INDEX SALESMANAGER.FK_K7GT46OIMA5W2H4WQ84HHG19C_INDEX_5 ON SALESMANAGER.CUSTOMER(DELIVERY_COUNTRY_ID)? %
?ALTER TABLE SALESMANAGER.CUSTOMER ADD CONSTRAINT SALESMANAGER.FK_EYY3EQWVKP4NUDH4R02AFGHHS FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_EYY3EQWVKP4NUDH4R02AFGHHS_INDEX_5 REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
dCREATE INDEX SALESMANAGER.FK_EYY3EQWVKP4NUDH4R02AFGHHS_INDEX_5 ON SALESMANAGER.CUSTOMER(LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.CUSTOMER ADD CONSTRAINT SALESMANAGER.FK_72ORK8LGTLVGWI0IWF0KHDHV7 FOREIGN KEY(BILLING_ZONE_ID) INDEX SALESMANAGER.FK_72ORK8LGTLVGWI0IWF0KHDHV7_INDEX_5 REFERENCES SALESMANAGER.ZONE(ZONE_ID) NOCHECK? !
hCREATE INDEX SALESMANAGER.FK_72ORK8LGTLVGWI0IWF0KHDHV7_INDEX_5 ON SALESMANAGER.CUSTOMER(BILLING_ZONE_ID)? %
?ALTER TABLE SALESMANAGER.CUSTOMER ADD CONSTRAINT SALESMANAGER.FK_3J13FD0W8FCUBKO0FDV53W18J FOREIGN KEY(BILLING_COUNTRY_ID) INDEX SALESMANAGER.FK_3J13FD0W8FCUBKO0FDV53W18J_INDEX_5 REFERENCES SALESMANAGER.COUNTRY(COUNTRY_ID) NOCHECK? !
kCREATE INDEX SALESMANAGER.FK_3J13FD0W8FCUBKO0FDV53W18J_INDEX_5 ON SALESMANAGER.CUSTOMER(BILLING_COUNTRY_ID)? %
?ALTER TABLE SALESMANAGER.CUSTMER_OPTIN ADD CONSTRAINT SALESMANAGER.FK_1F4GG9FCA0SRF7DNOQXGLVTEL FOREIGN KEY(OPTIN_ID) INDEX SALESMANAGER.FK_1F4GG9FCA0SRF7DNOQXGLVTEL_INDEX_9 REFERENCES SALESMANAGER.OPTIN(OPTIN_ID) NOCHECK? !
fCREATE INDEX SALESMANAGER.FK_1F4GG9FCA0SRF7DNOQXGLVTEL_INDEX_9 ON SALESMANAGER.CUSTMER_OPTIN(OPTIN_ID)? %
?ALTER TABLE SALESMANAGER.COUNTRY_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_GXBF63G476N3U9OVTRLNJVEUU FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_GXBF63G476N3U9OVTRLNJVEUU_INDEX_B REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
oCREATE INDEX SALESMANAGER.FK_GXBF63G476N3U9OVTRLNJVEUU_INDEX_B ON SALESMANAGER.COUNTRY_DESCRIPTION(LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.COUNTRY ADD CONSTRAINT SALESMANAGER.FK_2LBINU04SWW6IKU2VIS3QRJ75 FOREIGN KEY(GEOZONE_ID) INDEX SALESMANAGER.FK_2LBINU04SWW6IKU2VIS3QRJ75_INDEX_6 REFERENCES SALESMANAGER.GEOZONE(GEOZONE_ID) NOCHECK? !
bCREATE INDEX SALESMANAGER.FK_2LBINU04SWW6IKU2VIS3QRJ75_INDEX_6 ON SALESMANAGER.COUNTRY(GEOZONE_ID)咬???2--厁???????????????????????????????????????????????????????????????????}zwtqnkheb_\YVSPMJGDA>;852/,)&#!
	??????????????????????????????????????????????????????????~{xurolifc`]ZWTQNKHE?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"?"~"|"z"x"v"t"r"p"n"l"j"h"f"d"b"`"^"\"Z"X"V"T"R"P"N"L"J"H"F"D"B"@">"<":"8"6"4"2"0".","*"("&"$""" """""""""""
"""""?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!?!!}!{!y!w!u!s!q!o!m!k!i!g!e!c!a!_!]![!Y!W!U!S!Q!O!M!K!I!G!E!C!A!?!=!;!9!7!5!3!1!/!-!+!)!'!%!#!!!!!!!!!!!!
!!	!!!!!唞?_????????????????????????????????????????????????????????????????~|zxvtrpnljhfdb`^\ZXVTRPNLJHFDB_^]\[ZYXWVUTSRQPONMLKJIHGFEDCBA@?>=<;:9876543210/.-,+*)('&%$#"! 

	?x?!'6
?偩喛?
?Ｃ寄E?
P?	谏?? %
?ALTER TABLE SALESMANAGER.CONTENT_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_F9IVW889OKP1HUJBVFQ072LL2 FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_F9IVW889OKP1HUJBVFQ072LL2_INDEX_5 REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
oCREATE INDEX SALESMANAGER.FK_F9IVW889OKP1HUJBVFQ072LL2_INDEX_5 ON SALESMANAGER.CONTENT_DESCRIPTION(LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.CATEGORY_DESCRIPTION ADD CONSTRAINT SALESMANAGER.FK_I17O4F83R3Q77M1WPWQXJ3QEH FOREIGN KEY(LANGUAGE_ID) INDEX SALESMANAGER.FK_I17O4F83R3Q77M1WPWQXJ3QEH_INDEX_9 REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
pCREATE INDEX SALESMANAGER.FK_I17O4F83R3Q77M1WPWQXJ3QEH_INDEX_9 ON SALESMANAGER.CATEGORY_DESCRIPTION(LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.FK_BY5AJ5TO9LGMFVLHN4FB5B242 FOREIGN KEY(PARENT_ID) INDEX SALESMANAGER.FK_BY5AJ5TO9LGMFVLHN4FB5B242_INDEX_3 REFERENCES SALESMANAGER.CATEGORY(CATEGORY_ID) NOCHECK? !
bCREATE INDEX SALESMANAGER.FK_BY5AJ5TO9LGMFVLHN4FB5B242_INDEX_3 ON SALESMANAGER.CATEGORY(PARENT_ID)? %
?ALTER TABLE SALESMANAGER.MERCHANT_LANGUAGE ADD CONSTRAINT SALESMANAGER.FK_OTL5JB3NTLUJIF2KRKK7F1HFC FOREIGN KEY(STORES_MERCHANT_ID) INDEX SALESMANAGER.FK_OTL5JB3NTLUJIF2KRKK7F1HFC_INDEX_5 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK? !
tCREATE INDEX SALESMANAGER.FK_OTL5JB3NTLUJIF2KRKK7F1HFC_INDEX_5 ON SALESMANAGER.MERCHANT_LANGUAGE(STORES_MERCHANT_ID)? %
?ALTER TABLE SALESMANAGER.MERCHANT_LANGUAGE ADD CONSTRAINT SALESMANAGER.FK_53O35ARH6914XPJLFKK9FG7HR FOREIGN KEY(LANGUAGES_LANGUAGE_ID) INDEX SALESMANAGER.FK_53O35ARH6914XPJLFKK9FG7HR_INDEX_5 REFERENCES SALESMANAGER.LANGUAGE(LANGUAGE_ID) NOCHECK? !
wCREATE INDEX SALESMANAGER.FK_53O35ARH6914XPJLFKK9FG7HR_INDEX_5 ON SALESMANAGER.MERCHANT_LANGUAGE(LANGUAGES_LANGUAGE_ID)????????????????"?"?"?"?"?"?"?!?!?!?!?!?!?!倆????????3211疀??!瘺??!?x????????????????????????????}xsnid_ZUPKFA<72-(#
?????????????????????????~ytoje`[VQLGB=83.)$
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?

z
u
p
k
f
a
\
W
R
M
H
C
>
9
4
/
*
%
 





??????????????????????????{vqlgb]XSNID?:50+&!
??????????????????????????|wrmhc^YTOJE@;61,'"

?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
z
t
n
h
b
\
V
P
J
D
>
8
2
,
&
 




	?	?	?	?	?	?	?	?	?	?	?	?	?	?	?	?	?	?	?	?	?	~	x	r	l	f	`	Z	T	N	H	B	<	6	0	*	$						?????????????????????|vpjd^XRLF@:??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!??"??!?"?!?~"?~!?}"?}!?|"?|!?{"?{!?z"?z!?y"?y!?x"?x!?w"?w!?v"?v!?u"?u!?t"?t!?s"?s!?r"?r!?q"?q!?p"?p!?o"?o!?n"?n!?m"?m!?l"?l!?k"?k!?j"?j!?i"?i!?h"?h!?g"?g!?f"?f!?e"?e!?d"?d!?c"?c!?b"?b!?a"?a!?`"?`!?_"?_!?^"?^!?]"?]!?\"?\!?["?[!?Z"?Z!?Y"?Y!?X"?X!?W"?W!?V"?V!?U"?U!?T"?T!?S"?S!?R"?R!?Q"?Q!?P"?P!?O"?O!?N"?N!?M"?M!?L"?L!?K"?K!?J"?J!?I"?I!?H"?H!?G"?G!?F"?F!?E"?E!?D"?D!?C"?C!?B"?B!?A"?A!?@"?@!??"??!?>"?>!?="?=!?<"?<!?;"?;!?:"?:!?9"?9!?8"?8!?7"?7!?6"?6!?5"?5!?4"?4!?3"?3!?2"?2!?1"?1!?0"?0!?/"?/!?."?.!?-"?-!?,"?,!?+"?+!?*"?*!?)"?)!?("?(!?'"?'!?&"?&!?%"?%!?$"?$!?#"?#!?""?"!?!"?!!? "? !?"?!?"?!?"?!?"?!?"?"?!?"?!?"?!?"?!?"?!?"?!?"?!?"?!?"?!?"?!?"?!?"?!?!?
"?
!?"?!?"?!?
"?
!?	"?	!?"?!?7"?7!?6"?6!?5"?5!?4"?4!?3"?3!?2"?2!?1"?1!q?????????????????????????}uoiea\XQKEA8-"???????????????????uje_[SKGC?;71-)%!	
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
~
y
t
o
j
e
`
[
V
P
K
F
A
<
2
-
(
#





??????????????????????ri_WRNIE?;7,$??????????????????LZaragozaJZamora$FZH"FZGFYT?FWY?FWV~HWIAT?FWICHWAAU?FWAKVizcaya@NValladolid?LValencia?FVT?FVS?GVIC?FVIFVD|FVB{FVArFUTqFUR\JToledoJTeruel?MTarragona`FTX[FTN9HTIATXFTI;GTHEUFTGaGTAS?ISoria?KSevillaKSegoviafWSantaCruzdeTenerife?MSalamancaMFSZIFSTFFSODFSKBFSHAFSG<FSD?GSCN:FSC8FSB?GSAS?GSAR?GSAC7FSA,FRI?GRHEbGQLDFQCNPontevedra^LPalenciaFPR?FPE?FPA?KOurense?FOW?FOR?FOO?FON?FOK?FOH?KNavarra?FNY?FNW?FNV?FNUHHNTAU?FNT*GNSW?FNS	GNRW?FNO?FNM?FNJ?FNH?FNFZHNECH?FNEEGNDS?FND?FNC?FNB?JMurcia'KMelilla#JMalaga+JMadridxFMTwFMSuFMPtFMOsFMNpFMIoFMHzGMECkFMEiFMDhFMBgFMAYHLugoJLleida
HLeonMLasPalmas%KLaRiojacFLUVFLAQFKYOFKSJFKNKHJaen5FJUFINFILFID
FIA2JHuesca0JHuelvaFHI?GHESWGHAMMGuipuzcoamOGuadalajara?KGranadajJGirona?FGU?FGR?FGL?FGE?FGA?FFR?FFM?FFL_FDE]FDC}JCuenca>KCordobaLNCiudadReal.ICeutaMCastellonnMCantabriaeICadizKCaceresSFCTPFCOGFCAdJBurgosvMBarcelona?LBalearesyKBadajoz=FBS?GBRG?GBRE?HBLAT4FBLRGBER1FBE/FBC?GBAY?GBAW?IAvila6LAsturias?KAlmerialLAlicanteLAlbaceteNIAlava-FAZ)FAS3HARCH(FAR&FAP!FAM FALFAKFAIFAGFAFFAEJACoruaTGACTFACFABFAAKA CoruaUQ6?v?蟮g?

Q?搴=??? !
|CREATE UNIQUE INDEX SALESMANAGER.UK_M64LAXGRV9FXM6IO232AP4SU9_INDEX_1 ON SALESMANAGER.ZONE_DESCRIPTION(ZONE_ID, LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.ZONE ADD CONSTRAINT SALESMANAGER.UK_4TQ3P5W8K4H4EASYF5T3N1JDR UNIQUE(ZONE_CODE) INDEX SALESMANAGER.UK_4TQ3P5W8K4H4EASYF5T3N1JDR_INDEX_2? !
eCREATE UNIQUE INDEX SALESMANAGER.UK_4TQ3P5W8K4H4EASYF5T3N1JDR_INDEX_2 ON SALESMANAGER.ZONE(ZONE_CODE)? %
?ALTER TABLE SALESMANAGER.USER ADD CONSTRAINT SALESMANAGER.UK_7RBCJ0GSTOLIJ2MP5G3XC7XFU UNIQUE(ADMIN_NAME) INDEX SALESMANAGER.UK_7RBCJ0GSTOLIJ2MP5G3XC7XFU_INDEX_2? !
fCREATE UNIQUE INDEX SALESMANAGER.UK_7RBCJ0GSTOLIJ2MP5G3XC7XFU_INDEX_2 ON SALESMANAGER.USER(ADMIN_NAME)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_T3XG8PL88YACDXG49NB46EFFG_INDEX_2 ON SALESMANAGER.TAX_RATE_DESCRIPTION(TAX_RATE_ID, LANGUAGE_ID)? !
|CREATE UNIQUE INDEX SALESMANAGER.UK_A4Q5Q57A8OEH2OJEO8DHR935K_INDEX_D ON SALESMANAGER.TAX_CLASS(MERCHANT_ID, TAX_CLASS_CODE)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_NPDNLC390VGR2MHEPIB1MTRMR_INDEX_8 ON SALESMANAGER.SYSTEM_NOTIFICATION(MERCHANT_ID, CONFIG_KEY)7????J?琊悟呆欥~?e?J?/??麁鄠艅獑張r?W?>?#?
?
頂
蜄
瘶
摎
w?
[?
A?
%?
	?铯应法洩伂g?M?3??叨酶┖徏s?[?C?*??
銮
萑
派

捥
y?
`?
H?
/?
?		豳	芹		撨	z?	b?	I?	0?	???骐戊俄濓咅l?!;?QOFF,0,,,falseE7?!8QOFF,0,,,falseE4?!5?QOFF,0,,,falseE3?!5QOFF,0,,,falseE2?!2QOFF,0,,,falseE9?!2?QOFF,0,,,falseE8?!/ QOFF,0,,,falseE6?!.?QOFF,0,,,falseE0?!.?QOFF,0,,,falseE1?!+?QOFF,0,,,falseE4?!+!QOFF,0,,,falseE3?!+?QOFF,0,,,falseE2?!(?QOFF,0,,,falseF29?!(?QOFF,0,,,falseF28?!(?QOFF,0,,,falseF27?!(?QOFF,0,,,falseF26?!(?QOFF,0,,,falseF25?!(?QOFF,0,,,falseF24?!%?QOFF,0,,,falseE6?!"QOFF,0,,,falseE8?!?QOFF,0,,,falseE7?!?QOFF,0,,,falseE3?!#QOFF,0,,,falseF12?!?QOFF,0,,,falseF11?!$QOFF,0,,,falseE9?!%QOFF,0,,,falseF13?!?QOFF,0,,,falseF12?!?QOFF,0,,,falseF12?!&QOFF,0,,,falseF11?!/?QOFF,0,,,falseE0?!/?QOFF,0,,,falseE1?!??QOFF,0,,,falseG8,7?!??QOFF,0,,,falseE1?!??QOFF,0,,,falseE3?!??QOFF,0,,,falseG8,7?!??POFF,0,,,trueH4,10?!??QOFF,0,,,falseG3,1?!??QOFF,0,,,falseG8,5?!??QOFF,0,,,falseE4?!??QOFF,0,,,falseE4?!??QOFF,0,,,falseE5?!??QOFF,0,,,falseE5?!??QOFF,0,,,falseG8,7?!??QOFF,0,,,falseG8,7?!??QOFF,0,,,falseG8,7?!??QOFF,0,,,falseE1?!??QOFF,0,,,falseG5,1?!??QOFF,0,,,falseG9,8?!??QOFF,0,,,falseE1?!??QOFF,0,,,falseG5,1?!??QOFF,0,,,falseG9,8?!??QOFF,0,,,falseG2,1?!??QOFF,0,,,falseI14,13?!??QOFF,0,,,falseK10,11,9?!~?QOFF,0,,,falseI21,18?!z?QOFF,0,,,falseE4?!\?QOFF,0,,,falseG5,1?!V?QOFF,0,,,falseE1?!P?QOFF,0,,,falseG7,4?!M?QOFF,0,,,falseI11,10?!J?QOFF,0,,,falseG7,4?!D?QOFF,0,,,falseG8,7?!>?QOFF,0,,,falseG7,5?!;?QOFF,0,,,falseG8,7?!8?QOFF,0,,,falseE1?!8?QOFF,0,,,falseG4,1?!5?QOFF,0,,,falseG2,3?!2?QOFF,0,,,falseG9,8?!/?QOFF,0,,,falseE2?!/?QOFF,0,,,falseG6,2?!+?QOFF,0,,,falseG3,2?!%?POFF,0,,,trueG1,6?!"?QOFF,0,,,falseE3?!"?QOFF,0,,,falseE2u???Iadmin媥?磝?e??!KDEFAULT秞?Y????????NSUPERADMINLCUSTOMEROADMIN_STOREOADMIN_ORDERQADMIN_CONTENTSADMIN_CATALOGUEIADMIN眤???22F???
 a4f5eb8373b74408964c16b03b8b8b7c2
 1fbfb6d103ab4264965f379fd2f3ff4eF???
 a4f5eb8373b74408964c16b03b8b8b7c2
 1fbfb6d103ab4264965f379fd2f3ff4e)6?h?颍N?
抚
 ?И颢摤2?
廉
? %
?ALTER TABLE SALESMANAGER.SM_GROUP ADD CONSTRAINT SALESMANAGER.UK_T83RJSOML3O785OJ37LPQPYKO UNIQUE(GROUP_NAME) INDEX SALESMANAGER.UK_T83RJSOML3O785OJ37LPQPYKO_INDEX_3? !
jCREATE UNIQUE INDEX SALESMANAGER.UK_T83RJSOML3O785OJ37LPQPYKO_INDEX_3 ON SALESMANAGER.SM_GROUP(GROUP_NAME)? !
ZCREATE INDEX SALESMANAGER.SHP_CART_CUSTOMER_IDX ON SALESMANAGER.SHOPPING_CART(CUSTOMER_ID)? !
XCREATE INDEX SALESMANAGER.SHP_CART_CODE_IDX ON SALESMANAGER.SHOPPING_CART(SHP_CART_CODE)? %
?ALTER TABLE SALESMANAGER.SHOPPING_CART ADD CONSTRAINT SALESMANAGER.UK_8LD8P40FWRJOBI7T3N95PNA35 UNIQUE(SHP_CART_CODE) INDEX SALESMANAGER.UK_8LD8P40FWRJOBI7T3N95PNA35_INDEX_5? !
rCREATE UNIQUE INDEX SALESMANAGER.UK_8LD8P40FWRJOBI7T3N95PNA35_INDEX_5 ON SALESMANAGER.SHOPPING_CART(SHP_CART_CODE)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_QNO5WJDTCJ8PM3YKKKH7T4RXJ_INDEX_A ON SALESMANAGER.PRODUCT_REVIEW_DESCRIPTION(PRODUCT_REVIEW_ID, LANGUAGE_ID)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_FRSW8D41SXXOGVXXOYD8NWAXU_INDEX_5 ON SALESMANAGER.PRODUCT_PRICE_DESCRIPTION(PRODUCT_PRICE_ID, LANGUAGE_ID)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_ASGC60OT1WY0UHO96N0J8429P_INDEX_1 ON SALESMANAGER.PRODUCT_OPTION_VALUE_DESCRIPTION(PRODUCT_OPTION_VALUE_ID, LANGUAGE_ID)? !
oCREATE INDEX SALESMANAGER.PRD_OPTION_VAL_CODE_IDX ON SALESMANAGER.PRODUCT_OPTION_VALUE(PRODUCT_OPTION_VAL_CODE)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_IXBPI4HXRHLJH935C3XFVNVSH_INDEX_8 ON SALESMANAGER.PRODUCT_OPTION_VALUE(MERCHANT_ID, PRODUCT_OPTION_VAL_CODE)紉?消????????6!?5!?4!?3!?2!?1!帖???1!v???Gredq???!Gred他???1!w???Gabcv???!GabcuI6?姄髸i?
鏅
P?聺Z??? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_MKCM8ISYYYQBJD1YYB8MRPKUW_INDEX_8 ON SALESMANAGER.PRODUCT_OPTION_DESC(PRODUCT_OPTION_ID, LANGUAGE_ID)? !
aCREATE INDEX SALESMANAGER.PRD_OPTION_CODE_IDX ON SALESMANAGER.PRODUCT_OPTION(PRODUCT_OPTION_CODE)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_HFCW5OI9ULLJLOG1B7NS1R9TU_INDEX_1 ON SALESMANAGER.PRODUCT_OPTION(MERCHANT_ID, PRODUCT_OPTION_CODE)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_N7YHDJ6CCYDGF201GIBB882CD_INDEX_7 ON SALESMANAGER.PRODUCT_IMAGE_DESCRIPTION(PRODUCT_IMAGE_ID, LANGUAGE_ID)? !
|CREATE UNIQUE INDEX SALESMANAGER.UK_JUK1QGKH9V5W7GHVB18KRWO8V_INDEX_3 ON SALESMANAGER.PRODUCT_DIGITAL(PRODUCT_ID, FILE_NAME)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_Q4DNKX5B776AYQAS2H4RR2D8Q_INDEX_3 ON SALESMANAGER.PRODUCT_DESCRIPTION(PRODUCT_ID, LANGUAGE_ID)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_O0C6CFXCFEJWFA2877GFGPUCO_INDEX_8 ON SALESMANAGER.PRODUCT_ATTRIBUTE(OPTION_ID, OPTION_VALUE_ID, PRODUCT_ID)? !
oCREATE UNIQUE INDEX SALESMANAGER.UK_S8OFSN9PEHDRSTJG52J5QABXH_INDEX_1 ON SALESMANAGER.PRODUCT(MERCHANT_ID, SKU)??整????????6!?5!?4!?3!?2!?1!爔?????????!JTB2468!KTB12345!LSF333346!LSF333345!JNB1111!LLL333444Y?
?????????????	GTAXNSUPERADMINOSTORE_ADMINISTORELSHIPPINGLPRODUCTS
KPAYMENTIORDERLCUSTOMERKCONTENT
QAUTH_CUSTOMERHAUTHIADMIN?e??KDEFAULT
'6
?們鴧|?
鑹
[?鋵1?紡D?
?? %
?ALTER TABLE SALESMANAGER.PERMISSION ADD CONSTRAINT SALESMANAGER.UK_SS26HGWETKJ8MS5Y5JN2CO4J3 UNIQUE(PERMISSION_NAME) INDEX SALESMANAGER.UK_SS26HGWETKJ8MS5Y5JN2CO4J3_INDEX_F? !
qCREATE UNIQUE INDEX SALESMANAGER.UK_SS26HGWETKJ8MS5Y5JN2CO4J3_INDEX_F ON SALESMANAGER.PERMISSION(PERMISSION_NAME)? !
nCREATE UNIQUE INDEX SALESMANAGER.UK_MANLX6SIQ6DDF14CUD40K8GW6_INDEX_4 ON SALESMANAGER.OPTIN(MERCHANT_ID, CODE)? %
?ALTER TABLE SALESMANAGER.MERCHANT_STORE ADD CONSTRAINT SALESMANAGER.UK_4PVTSNQV4NLAO8725N9LDPGUF UNIQUE(STORE_CODE) INDEX SALESMANAGER.UK_4PVTSNQV4NLAO8725N9LDPGUF_INDEX_A? !
pCREATE UNIQUE INDEX SALESMANAGER.UK_4PVTSNQV4NLAO8725N9LDPGUF_INDEX_A ON SALESMANAGER.MERCHANT_STORE(STORE_CODE)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_J0C3H8ONW3M6HJCR3YYLST9FB_INDEX_D ON SALESMANAGER.MERCHANT_CONFIGURATION(MERCHANT_ID, CONFIG_KEY)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_LPV09P83SC887CLXE04NROUP6_INDEX_2 ON SALESMANAGER.MANUFACTURER_DESCRIPTION(MANUFACTURER_ID, LANGUAGE_ID)? !
uCREATE UNIQUE INDEX SALESMANAGER.UK_6BRQFDKGA7JC78N8DH3V595Y3_INDEX_1 ON SALESMANAGER.MANUFACTURER(MERCHANT_ID, CODE)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_SOQ8O99W3C8YS3NTAMT5I4MAT_INDEX_1 ON SALESMANAGER.GEOZONE_DESCRIPTION(GEOZONE_ID, LANGUAGE_ID)? !
wCREATE UNIQUE INDEX SALESMANAGER.UK_AV35SB3V4NXQ8V1N1RKXUFIR_INDEX_F ON SALESMANAGER.FILE_HISTORY(MERCHANT_ID, FILE_ID)R??????????!OweightBased2!Ufacebook_page_urle!RSUPPORTED_CNTRf!SSHIPPING_CONFIG?!LSHIPPING?!KPAYMENT?!PEMAIL_CONFIG!JCONFIG蓰???????5!?4!?3!?2!?1!U???????!Hsams!Ipackt!Loreilley!Knovells!Kmanning﹛?獂?冫???1!.???MtestValueu'6?x?膑嗻
篾
T?浸J??? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_GE7F2T1D31R87WNK09H9U1TNV_INDEX_B ON SALESMANAGER.CUSTOMER_OPT_VAL_DESCRIPTION(CUSTOMER_OPT_VAL_ID, LANGUAGE_ID)? !
lCREATE INDEX SALESMANAGER.CUST_OPT_VAL_CODE_IDX ON SALESMANAGER.CUSTOMER_OPTION_VALUE(CUSTOMER_OPT_VAL_CODE)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_CB1FMV71NRX7M1RLX1FF5QVDT_INDEX_5 ON SALESMANAGER.CUSTOMER_OPTION_VALUE(MERCHANT_ID, CUSTOMER_OPT_VAL_CODE)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_4PELI2RITNNQ2XQPYQ188SRM6_INDEX_5 ON SALESMANAGER.CUSTOMER_OPTION_SET(CUSTOMER_OPTION_ID, CUSTOMER_OPTION_VALUE_ID)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_6OVL4T1CIAG1WUBTCEBAOO7VI_INDEX_4 ON SALESMANAGER.CUSTOMER_OPTION_DESC(CUSTOMER_OPTION_ID, LANGUAGE_ID)? !
^CREATE INDEX SALESMANAGER.CUST_OPT_CODE_IDX ON SALESMANAGER.CUSTOMER_OPTION(CUSTOMER_OPT_CODE)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_ROV34A6G4DHHIQUKVHP1GGM0U_INDEX_3 ON SALESMANAGER.CUSTOMER_OPTION(MERCHANT_ID, CUSTOMER_OPT_CODE)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_46KBPRE88YH963GEWM3KMDNI1_INDEX_5 ON SALESMANAGER.CUSTOMER_ATTRIBUTE(OPTION_ID, CUSTOMER_ID),???!MtestValue???11Ⅺ???1!>???Htest=???!Htest???11躼?TG??????????????????????????|vqlga\WRMHC>94/*$?????????????????????????zupkfa\WRMHC>93.)#

?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
~
y
t
o
j
e
`
[
V
Q
L
G
B
=
8
3
-
(
#






??????????IGZMKGZAR?GYER0GXPFGXOF?GXDRwGXCDJGXAF?GWSTEGVUVQGVNDFGVEF2GUZSGUYU=GUSDGUGX&GUAHPGTZSGTWD?GTTD_GTRYGTNDaGTJS1GTHB}GSZLoGSYP*GSVCGSTD|GSRDDGSOSGSLL^GSHPAGSGD$GSEKGSDGGSCR?GSBDGSARdGRWF8GRUBGRSDqGRON,GQAR9GPYG?GPLNvGPKR7GPHP"GPGK?GPEN@GPAB!GOMR?GNZD?GNPRmGNOK?GNIOsGNGN?GNAD)GMZNGMYR
GMXVGMXN?GMWK?GMVRnGMUR.GMRO?GMOP?GMNTlGMMK>GMKD?GMGAYGMDLGMAD4GLYDGLVL~GLTLgGLSLKGLRDrGLKR`GLBPGGLAK{GKZT[GKYD6GKWD?GKRWVGKPWGKMFXGKHRCGKGS#GKES?GJPYbGJOD;GJMD:GISK-GIRRGIQD?GINRSGILSZGIDR?GHUFyGHTGLGHRK
GHNLcGHKDUGGYDGGTQ'GGNFGGMDpGGIPTGGHSGGEL?GGBPGFKPGFJDfGEURBGETB(GERN?GEGP?GDZDGDOPhGDKKOGDJFuGCZKGCVEGCUPtGCRC<GCOP/GCNY	GCLP?GCLFMGCHFGCDFiGCAD?GBZD?GBYR]GBWP%GBTNGBSD?GBRLjGBOVWGBOBHGBND5GBMD?GBIFzGBHDkGBGN3GBDTGBBD?GBAM GAZN?GAWGRGAUD+GARS?GAOAxGANG\GAMDNGALL?GAFNeGAEDWG??????????????????????????|vqlga\WRMHC>94/*$?????????????????????????zupkfa\WRMHC>93.)#

?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
~
y
t
o
j
e
`
[
V
Q
L
G
B
=
8
3
-
(
#






??????????IGZMKGZAR?GYER0GXPFGXOF?GXDRwGXCDJGXAF?GWSTEGVUVQGVNDFGVEF2GUZSGUYU=GUSDGUGX&GUAHPGTZSGTWD?GTTD_GTRYGTNDaGTJS1GTHB}GSZLoGSYP*GSVCGSTD|GSRDDGSOSGSLL^GSHPAGSGD$GSEKGSDGGSCR?GSBDGSARdGRWF8GRUBGRSDqGRON,GQAR9GPYG?GPLNvGPKR7GPHP"GPGK?GPEN@GPAB!GOMR?GNZD?GNPRmGNOK?GNIOsGNGN?GNAD)GMZNGMYR
GMXVGMXN?GMWK?GMVRnGMUR.GMRO?GMOP?GMNTlGMMK>GMKD?GMGAYGMDLGMAD4GLYDGLVL~GLTLgGLSLKGLRDrGLKR`GLBPGGLAK{GKZT[GKYD6GKWD?GKRWVGKPWGKMFXGKHRCGKGS#GKES?GJPYbGJOD;GJMD:GISK-GIRRGIQD?GINRSGILSZGIDR?GHUFyGHTGLGHRK
GHNLcGHKDUGGYDGGTQ'GGNFGGMDpGGIPTGGHSGGEL?GGBPGFKPGFJDfGEURBGETB(GERN?GEGP?GDZDGDOPhGDKKOGDJFuGCZKGCVEGCUPtGCRC<GCOP/GCNY	GCLP?GCLFMGCHFGCDFiGCAD?GBZD?GBYR]GBWP%GBTNGBSD?GBRLjGBOVWGBOBHGBND5GBMD?GBIFzGBHDkGBGN3GBDTGBBD?GBAM GAZN?GAWGRGAUD+GARS?GAOAxGANG\GAMDNGALL?GAFNeGAED~)6?夊??婅
匍
O?垤+?
躏
傪	?? %
?ALTER TABLE SALESMANAGER.CURRENCY ADD CONSTRAINT SALESMANAGER.UK_7R1K69CBK5GIEWQR5C9R4V6F UNIQUE(CURRENCY_NAME) INDEX SALESMANAGER.UK_7R1K69CBK5GIEWQR5C9R4V6F_INDEX_5? !
lCREATE UNIQUE INDEX SALESMANAGER.UK_7R1K69CBK5GIEWQR5C9R4V6F_INDEX_5 ON SALESMANAGER.CURRENCY(CURRENCY_NAME)? %
?ALTER TABLE SALESMANAGER.CURRENCY ADD CONSTRAINT SALESMANAGER.UK_M7KU15EKUD52VP67RY73A36TE UNIQUE(CURRENCY_CURRENCY_CODE) INDEX SALESMANAGER.UK_M7KU15EKUD52VP67RY73A36TE_INDEX_5? !
vCREATE UNIQUE INDEX SALESMANAGER.UK_M7KU15EKUD52VP67RY73A36TE_INDEX_5 ON SALESMANAGER.CURRENCY(CURRENCY_CURRENCY_CODE)? %
?ALTER TABLE SALESMANAGER.CURRENCY ADD CONSTRAINT SALESMANAGER.UK_1UBR7N96HJAJAMTGGQP090A4X UNIQUE(CURRENCY_CODE) INDEX SALESMANAGER.UK_1UBR7N96HJAJAMTGGQP090A4X_INDEX_5? !
mCREATE UNIQUE INDEX SALESMANAGER.UK_1UBR7N96HJAJAMTGGQP090A4X_INDEX_5 ON SALESMANAGER.CURRENCY(CURRENCY_CODE)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_T7NSHKI1RBP6157ED0V6CX4Y4_INDEX_B ON SALESMANAGER.COUNTRY_DESCRIPTION(COUNTRY_ID, LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.COUNTRY ADD CONSTRAINT SALESMANAGER.UK_DQB99V22PT27V0TGEQO958E6X UNIQUE(COUNTRY_ISOCODE) INDEX SALESMANAGER.UK_DQB99V22PT27V0TGEQO958E6X_INDEX_6? !
nCREATE UNIQUE INDEX SALESMANAGER.UK_DQB99V22PT27V0TGEQO958E6X_INDEX_6 ON SALESMANAGER.COUNTRY(COUNTRY_ISOCODE)? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_N0W5R7CTBP88R4RVK7AYKLOFM_INDEX_5 ON SALESMANAGER.CONTENT_DESCRIPTION(CONTENT_ID, LANGUAGE_ID)? !
pCREATE UNIQUE INDEX SALESMANAGER.UK_T1V2LD0MRWVIQUQOURQL4UUB0_INDEX_6 ON SALESMANAGER.CONTENT(MERCHANT_ID, CODE)QG??????????????????????????|vqlga\WRMHC>94/*$?????????????????????????zupkfa\WRMHC>93.)#

?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
~
y
t
o
j
e
`
[
V
Q
L
G
B
=
8
3
-
(
#






??????????IGZMKGZAR?GYER0GXPFGXOF?GXDRwGXCDJGXAF?GWSTEGVUVQGVNDFGVEF2GUZSGUYU=GUSDGUGX&GUAHPGTZSGTWD?GTTD_GTRYGTNDaGTJS1GTHB}GSZLoGSYP*GSVCGSTD|GSRDDGSOSGSLL^GSHPAGSGD$GSEKGSDGGSCR?GSBDGSARdGRWF8GRUBGRSDqGRON,GQAR9GPYG?GPLNvGPKR7GPHP"GPGK?GPEN@GPAB!GOMR?GNZD?GNPRmGNOK?GNIOsGNGN?GNAD)GMZNGMYR
GMXVGMXN?GMWK?GMVRnGMUR.GMRO?GMOP?GMNTlGMMK>GMKD?GMGAYGMDLGMAD4GLYDGLVL~GLTLgGLSLKGLRDrGLKR`GLBPGGLAK{GKZT[GKYD6GKWD?GKRWVGKPWGKMFXGKHRCGKGS#GKES?GJPYbGJOD;GJMD:GISK-GIRRGIQD?GINRSGILSZGIDR?GHUFyGHTGLGHRK
GHNLcGHKDUGGYDGGTQ'GGNFGGMDpGGIPTGGHSGGEL?GGBPGFKPGFJDfGEURBGETB(GERN?GEGP?GDZDGDOPhGDKKOGDJFuGCZKGCVEGCUPtGCRC<GCOP/GCNY	GCLP?GCLFMGCHFGCDFiGCAD?GBZD?GBYR]GBWP%GBTNGBSD?GBRLjGBOVWGBOBHGBND5GBMD?GBIFzGBHDkGBGN3GBDTGBBD?GBAM GAZN?GAWGRGAUD+GARS?GAOAxGANG\GAMDNGALL?GAFNeGAED涆?????????????????????????????????????????~zvrnjfb^ZVRNJFB>:62.*&"
????????????????????????????????~zvrnjfb^ZVRNJFB>:62.*&"	
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
}
x
s
n
i
d
_
Z
U
P
K
F
A
<
7
2
-
(
#






??????_"?_!?^"?^!?]"?]!?\"?\!?["?[!?Z"?Z!?Y"?Y!?X"?X!?W"?W!?V"?V!?U"?U!?T"?T!?S"?S!?R"?R!?Q"?Q!?P"?P!?O"?O!?N"?N!?M"?M!?L"?L!?K"?K!?J"?J!?I"?I!?H"?H!?G"?G!?F"?F!?E"?E!?D"?D!?C"?C!?B"?B!?A"?A!?@"@!~?"}?!|>"{>!z="y=!x<"w<!v;"u;!t:"s:!r9"q9!p8"o8!n7"m7!l6"k6!j5"i5!h4"g4!f3"e3!d2"c2!b1"a1!`0"_0!^/"]/!\."[.!Z-"Y-!X,"W,!V+"U+!T*"S*!R)"Q)!P("O(!N'"M'!L&"K&!J%"I%!H$"G$!F#"E#!D""C"!B!"A!!@ "? !>"=!<";!:"9!8"7!6"5!4"3!2"1!0"/!."-!,"+!*")!("'!&"%!$"#!""!! "!/"/!.".!-"-!,",!+"+!*"*!)")!("(!'"
'!&"&!
%"	%!$"$!#"#!"""!!"!!T@?_????????????????????????????????|xtplhd`\XTPLHD@<840,($ ???????????????????????????????NFZA_FYE^FVN]FVE\FUY[FUSXFUATFTWWFTRVFTNUFTHSFSYFSVLFSKMFSIKFSGQFSEPFSDIFSAHFRUJFRSGFROFFQA@FPYDFPTEFPRCFPLBFPHAFPE?FPA>FOM;FNZ=FNO:FNL<FNI5FMY7FMX6FMT4FMK8FME9FMA1FLY/FLV3FLU2FLT0FLB.FKW-FKR+FJP,FJO*FIT$FIS'FIQ%FIN)FIL(FIE&FID#FHUFHR!FHN"FHK FGTFGRZFGBFFRFFIOFESFEGFEEFECFDZFDOFDKFDEFCZFCYFCUFCRFCOFCNFCLRFCH
FCAFBYFBR	FBOFBHFBGFBE
FBAFAUFATFARFALYFAE踴?膞?符????????????????7"?7!?6"?6!?5"?5!?4"?4!?3"?3!?2"?2!?1"?1!(?????????!Gweb!Htech!Jnovels!Kfiction!Qcomputerbooks!Icloud!Lbusiness-?6?
?
,?ж7?ペR?
蛙	忀	)?愡??? !
?CREATE UNIQUE INDEX SALESMANAGER.UK_BUESQQ6CYX7E5HY3MF30CFIEQ_INDEX_9 ON SALESMANAGER.CATEGORY_DESCRIPTION(CATEGORY_ID, LANGUAGE_ID)? !
qCREATE UNIQUE INDEX SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X_INDEX_3 ON SALESMANAGER.CATEGORY(MERCHANT_ID, CODE)? %
?ALTER TABLE SALESMANAGER.ZONE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_17 PRIMARY KEY(DESCRIPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_17? !
_CREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_17 ON SALESMANAGER.ZONE_DESCRIPTION(DESCRIPTION_ID)?  
?CREATE CACHED TABLE SALESMANAGER.ZONE_DESCRIPTION(
    DESCRIPTION_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    DESCRIPTION CLOB,
    NAME VARCHAR(120) NOT NULL,
    TITLE VARCHAR(100),
    LANGUAGE_ID INTEGER NOT NULL,
    ZONE_ID BIGINT NOT NULL
)? %
~ALTER TABLE SALESMANAGER.ZONE ADD CONSTRAINT SALESMANAGER.CONSTRAINT_2A PRIMARY KEY(ZONE_ID) INDEX SALESMANAGER.PRIMARY_KEY_2A? !
LCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_2A ON SALESMANAGER.ZONE(ZONE_ID)?  
?CREATE CACHED TABLE SALESMANAGER.ZONE(
    ZONE_ID BIGINT NOT NULL,
    ZONE_CODE VARCHAR(255) NOT NULL,
    COUNTRY_ID INTEGER NOT NULL
)?  
iCREATE CACHED TABLE SALESMANAGER.USER_GROUP(
    USER_ID BIGINT NOT NULL,
    GROUP_ID INTEGER NOT NULL
)? %
~ALTER TABLE SALESMANAGER.USER ADD CONSTRAINT SALESMANAGER.CONSTRAINT_27 PRIMARY KEY(USER_ID) INDEX SALESMANAGER.PRIMARY_KEY_27? !
LCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_27 ON SALESMANAGER.USER(USER_ID)?  
?CREATE CACHED TABLE SALESMANAGER.USER(
    USER_ID BIGINT NOT NULL,
    ACTIVE BOOLEAN,
    ADMIN_EMAIL VARCHAR(255) NOT NULL,
    ADMIN_NAME VARCHAR(100) NOT NULL,
    ADMIN_PASSWORD VARCHAR(60) NOT NULL,
    ADMIN_A1 VARCHAR(255),
    ADMIN_A2 VARCHAR(255),
    ADMIN_A3 VARCHAR(255),
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    ADMIN_FIRST_NAME VARCHAR(255),
    LAST_ACCESS TIMESTAMP,
    ADMIN_LAST_NAME VARCHAR(255),
    LOGIN_ACCESS TIMESTAMP,
    ADMIN_Q1 VARCHAR(255),
    ADMIN_Q2 VARCHAR(255),
    ADMIN_Q3 VARCHAR(255),
    LANGUAGE_ID INTEGER,
    MERCHANT_ID INTEGER NOT NULL
)??x-1?2?0?/?.?苯??????????	?
???
??xj[TIC<5.' 
??? ?!?"?#?$?%?&?'?(?)?*?+?,z-s.i/c0X1Q2F3=465/6"789:;
?<
?=
?>
??
譆
華
罛
篊
睤
珽

滸
朒
嶪
圝
侹
yL
jM
cN
YO
RP
KQ
DR
<S
5T
.U
'V
 W
X
Y
Z?[鳿韂鎊賍襚薬腷絚禿玡塯俬|iujjkclVmFn8o1p*q#rstuv鵺騲難遺讃衸蕔縹?皜泜崈唲}?u?m?e?^?V?N?F?>?6?/?&?????
??
鴸
饤
铇
鄼
貧
藳
罍
笣
癁

殸
挕
姠
~?
v?
n?
f?
_?
X?
P?
G?
<?
4?
%?
?
?
?	??	鞑	锍	绱	薜	锥	畏	鸥	腹			櫦	嫿	??GSCN?LValenciaO?KNavarraO?GBAY?GBAW?KAlmeriaO?GHES?GBRG?FPE-?GBRE?GVIC$?FPA[?FGU[?FGRR?FOWR?LBalearesO?FGLR?MSalamancaO?FOR[?IAvilaO?HBLAT%?FWY[?FOO%?FON-?FWV[?FGER?FOK[?JMurciaO?FGA[?FOH[?FWI[?KOurenseO?GRHE?FFRR?ISoriaO?KGranadaO?FNY[?FWA[?FNWR?FNV[?FNU-?FFM[?FNT-?FFL[?GSAR?FNS-?GSAS?FNO%?FNM[?FVT[?FVSR?FNJ[?FNH[?FNF-?FNE[?FND[?FNC[?GSAC?FNB-?LZaragozaO?FVI[?KSevillaOFVDR~HWIAT%}JCuencaO|FVB%{FVA[zGMECyKBadajozOxFMT[wFMS[vMBarcelonaOuFMP[tFMO[sFMN[rFUT[qFURRpFMI[oFMH[nMCantabriaOmOGuadalajaraOlLAlicanteOkFME[jJGironaOiFMD[hFMB-gFMA[fWSantaCruzdeTenerifeOeICadizOdJBurgosOcFLURbGQLD$aGTAS$`FTX[_FDE[^LPalenciaO]FDC[\JToledoO[FTN[ZHNECHRYHLugoOXFTIRWGHAMVFLA[UFTGRTGACT$SFCT[RGBERQFKY[PFCO[OFKS[NIAlavaOMFSZRLNCiudadRealOKHJaenOJFKN%IFST%HHNTAU$GFCA[FFSOREGNDSDFSK-CHWAAU$BFSHRAFSGR@NValladolidO?MTarragonaO>KCordobaO=FBSR<FSD[;GTHE:FSC[9HTIAT%8FSB%7FSA$6LAsturiasO5FJUR4FBLR3HARCHR2JHuescaO1FBER0JHuelvaO/FBC-.ICeutaO-FAZ[,FRI[+JMadridO*GNSW$)FAS[(FAR['KMelillaO&FAP[%KLaRiojaO$FZHR#JMalagaO"FZGR!FAM[ FAL[KSegoviaOKCaceresOFAK[FAIRKA CoruaOFAGRFIN[FAF[FAE[FIL[FAC[FAB-JTeruelOFAA[NPontevedraOMLasPalmasOMCastellonOJACoruaO
HLeonOFYT-FID[
FIA[	GNRWFQC-7JLleidaO6LAlbaceteO5KVizcayaO4JZamoraO3FPR[2FHI[1MGuipuzcoaO碴???1!1"鍑?k1AVadmin@shopizer.comIadmin
<$2a$11$QNa0OXOR.ADHRQqij7tLBuyx9MLY5gluA3GBcqjfk/3DZ5UEoznra啊蜐?+痛?+QAdministrator銢麓?+HUser屙痛?+!蒮?	)d6?潦W?
禾毼?
6?	垩	M??υ	? %
?ALTER TABLE SALESMANAGER.TAX_RATE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_26 PRIMARY KEY(DESCRIPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_26? !
cCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_26 ON SALESMANAGER.TAX_RATE_DESCRIPTION(DESCRIPTION_ID)?  
?CREATE CACHED TABLE SALESMANAGER.TAX_RATE_DESCRIPTION(
    DESCRIPTION_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    DESCRIPTION CLOB,
    NAME VARCHAR(120) NOT NULL,
    TITLE VARCHAR(100),
    LANGUAGE_ID INTEGER NOT NULL,
    TAX_RATE_ID BIGINT
)? %
?ALTER TABLE SALESMANAGER.TAX_RATE ADD CONSTRAINT SALESMANAGER.CONSTRAINT_1F PRIMARY KEY(TAX_RATE_ID) INDEX SALESMANAGER.PRIMARY_KEY_1F? !
TCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_1F ON SALESMANAGER.TAX_RATE(TAX_RATE_ID)?  
?CREATE CACHED TABLE SALESMANAGER.TAX_RATE(
    TAX_RATE_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    TAX_CODE VARCHAR(255) NOT NULL,
    PIGGYBACK BOOLEAN,
    STORE_STATE_PROV VARCHAR(100),
    TAX_PRIORITY INTEGER,
    TAX_RATE DECIMAL(7, 4) NOT NULL,
    COUNTRY_ID INTEGER NOT NULL,
    MERCHANT_ID INTEGER NOT NULL,
    PARENT_ID BIGINT,
    TAX_CLASS_ID BIGINT NOT NULL,
    ZONE_ID BIGINT
)? %
?ALTER TABLE SALESMANAGER.TAX_CLASS ADD CONSTRAINT SALESMANAGER.CONSTRAINT_DBB PRIMARY KEY(TAX_CLASS_ID) INDEX SALESMANAGER.PRIMARY_KEY_DBB? !
WCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_DBB ON SALESMANAGER.TAX_CLASS(TAX_CLASS_ID)?  
?CREATE CACHED TABLE SALESMANAGER.TAX_CLASS(
    TAX_CLASS_ID BIGINT NOT NULL,
    TAX_CLASS_CODE VARCHAR(10) NOT NULL,
    TAX_CLASS_TITLE VARCHAR(32) NOT NULL,
    MERCHANT_ID INTEGER
)? %
?ALTER TABLE SALESMANAGER.SYSTEM_NOTIFICATION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_87 PRIMARY KEY(SYSTEM_NOTIF_ID) INDEX SALESMANAGER.PRIMARY_KEY_87? !
cCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_87 ON SALESMANAGER.SYSTEM_NOTIFICATION(SYSTEM_NOTIF_ID)?  
?CREATE CACHED TABLE SALESMANAGER.SYSTEM_NOTIFICATION(
    SYSTEM_NOTIF_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    END_DATE DATE,
    CONFIG_KEY VARCHAR(255),
    START_DATE DATE,
    VALUE VARCHAR(255),
    MERCHANT_ID INTEGER,
    USER_ID BIGINT
)薴?]0??1KDEFAULTKDEFAULT!蚮?
6???1缚袧?+缚袧?+JSYSTEMTTEST_DATA_LOADEDHtrue孫6?尲褰
倬
o?依肓撀?	的	Q?浩吻b??? %
?ALTER TABLE SALESMANAGER.SYSTEM_CONFIGURATION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_9E PRIMARY KEY(SYSTEM_CONFIG_ID) INDEX SALESMANAGER.PRIMARY_KEY_9E? !
eCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_9E ON SALESMANAGER.SYSTEM_CONFIGURATION(SYSTEM_CONFIG_ID)?  
?CREATE CACHED TABLE SALESMANAGER.SYSTEM_CONFIGURATION(
    SYSTEM_CONFIG_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    CONFIG_KEY VARCHAR(255),
    VALUE VARCHAR(255)
)? %
?ALTER TABLE SALESMANAGER.SM_TRANSACTION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_D3 PRIMARY KEY(TRANSACTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_D3? !
]CREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_D3 ON SALESMANAGER.SM_TRANSACTION(TRANSACTION_ID)?  
?CREATE CACHED TABLE SALESMANAGER.SM_TRANSACTION(
    TRANSACTION_ID BIGINT NOT NULL,
    AMOUNT DECIMAL(19, 2),
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    DETAILS CLOB,
    PAYMENT_TYPE VARCHAR(255),
    TRANSACTION_DATE TIMESTAMP,
    TRANSACTION_TYPE VARCHAR(255),
    ORDER_ID BIGINT
)? %
?ALTER TABLE SALESMANAGER.SM_GROUP ADD CONSTRAINT SALESMANAGER.CONSTRAINT_3D PRIMARY KEY(GROUP_ID) INDEX SALESMANAGER.PRIMARY_KEY_3D? !
QCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_3D ON SALESMANAGER.SM_GROUP(GROUP_ID)?  
?CREATE CACHED TABLE SALESMANAGER.SM_GROUP(
    GROUP_ID INTEGER NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    GROUP_NAME VARCHAR(255) NOT NULL,
    GROUP_TYPE VARCHAR(255)
)? %
?ALTER TABLE SALESMANAGER.SHOPPING_CART_ITEM ADD CONSTRAINT SALESMANAGER.CONSTRAINT_B3 PRIMARY KEY(SHP_CART_ITEM_ID) INDEX SALESMANAGER.PRIMARY_KEY_B3? !
cCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_B3 ON SALESMANAGER.SHOPPING_CART_ITEM(SHP_CART_ITEM_ID)?  
?CREATE CACHED TABLE SALESMANAGER.SHOPPING_CART_ITEM(
    SHP_CART_ITEM_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    PRODUCT_ID BIGINT NOT NULL,
    QUANTITY INTEGER,
    SHP_CART_ID BIGINT NOT NULL
)? %
?ALTER TABLE SALESMANAGER.SHOPPING_CART_ATTR_ITEM ADD CONSTRAINT SALESMANAGER.CONSTRAINT_45 PRIMARY KEY(SHP_CART_ATTR_ITEM_ID) INDEX SALESMANAGER.PRIMARY_KEY_45? !
mCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_45 ON SALESMANAGER.SHOPPING_CART_ATTR_ITEM(SHP_CART_ATTR_ITEM_ID)蝔?
HG????sO)'啊蜐?+啊蜐?+LCUSTOMERLCUSTOMER&啊蜐?+啊蜐?+QADMIN_CONTENTIADMIN%啊蜐?+啊蜐?+OADMIN_ORDERIADMIN$啊蜐?+啊蜐?+OADMIN_STOREIADMIN#啊蜐?+啊蜐?+SADMIN_CATALOGUEIADMIN"啊蜐?+啊蜐?+IADMINIADMIN!啊蜐?+啊蜐?+NSUPERADMINIADMIN傎??2?2菥赈?+嗁寤?+5!21垡?+袛?+2!1骹?vN??2?2劢赈?+嗁寤?+2
 1fbfb6d103ab4264965f379fd2f3ff4e!1壱?+袛?+
 a4f5eb8373b74408964c16b03b8b8b7c!??6?f??

??烦!?	莸	y?夥愿t?岷??  
?CREATE CACHED TABLE SALESMANAGER.SHOPPING_CART_ATTR_ITEM(
    SHP_CART_ATTR_ITEM_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    PRODUCT_ATTR_ID BIGINT NOT NULL,
    SHP_CART_ITEM_ID BIGINT NOT NULL
)? %
?ALTER TABLE SALESMANAGER.SHOPPING_CART ADD CONSTRAINT SALESMANAGER.CONSTRAINT_59 PRIMARY KEY(SHP_CART_ID) INDEX SALESMANAGER.PRIMARY_KEY_59? !
YCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_59 ON SALESMANAGER.SHOPPING_CART(SHP_CART_ID)?  
?CREATE CACHED TABLE SALESMANAGER.SHOPPING_CART(
    SHP_CART_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    CUSTOMER_ID BIGINT,
    SHP_CART_CODE VARCHAR(255) NOT NULL,
    MERCHANT_ID INTEGER NOT NULL
)? %
?ALTER TABLE SALESMANAGER.SHIPING_ORIGIN ADD CONSTRAINT SALESMANAGER.CONSTRAINT_DB PRIMARY KEY(SHIP_ORIGIN_ID) INDEX SALESMANAGER.PRIMARY_KEY_DB? !
]CREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_DB ON SALESMANAGER.SHIPING_ORIGIN(SHIP_ORIGIN_ID)?  
?CREATE CACHED TABLE SALESMANAGER.SHIPING_ORIGIN(
    SHIP_ORIGIN_ID BIGINT NOT NULL,
    ACTIVE BOOLEAN,
    STREET_ADDRESS VARCHAR(256) NOT NULL,
    CITY VARCHAR(100) NOT NULL,
    POSTCODE VARCHAR(20) NOT NULL,
    STATE VARCHAR(100),
    COUNTRY_ID INTEGER,
    MERCHANT_ID INTEGER NOT NULL,
    ZONE_ID BIGINT
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_TYPE ADD CONSTRAINT SALESMANAGER.CONSTRAINT_C8 PRIMARY KEY(PRODUCT_TYPE_ID) INDEX SALESMANAGER.PRIMARY_KEY_C8? !
\CREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_C8 ON SALESMANAGER.PRODUCT_TYPE(PRODUCT_TYPE_ID)?  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT_TYPE(
    PRODUCT_TYPE_ID BIGINT NOT NULL,
    PRD_TYPE_ADD_TO_CART BOOLEAN,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    PRD_TYPE_CODE VARCHAR(255)
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_REVIEW_DESCRIPTION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_AD PRIMARY KEY(DESCRIPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_AD? !
iCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_AD ON SALESMANAGER.PRODUCT_REVIEW_DESCRIPTION(DESCRIPTION_ID)?  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT_REVIEW_DESCRIPTION(
    DESCRIPTION_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    DESCRIPTION CLOB,
    NAME VARCHAR(120) NOT NULL,
    TITLE VARCHAR(100),
    LANGUAGE_ID INTEGER NOT NULL,
    PRODUCT_REVIEW_ID BIGINT
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_REVIEW ADD CONSTRAINT SALESMANAGER.CONSTRAINT_19 PRIMARY KEY(PRODUCT_REVIEW_ID) INDEX SALESMANAGER.PRIMARY_KEY_19鬴?	x5??1葯蜐?+葯蜐?+KGENERAL0a????L?????j
R8$???wM7
?
?
? 
?!
|#
\$
F&
"'
)?*?,o-Y/?013?4?6?7?9q:[<3=?
鰼
酈
臗
疎
嘑
qH
OI
9K
L	齆	蚈	稱	慠	{T	]U	GW鮔遉痆橾w^a`蚢穋梔乫Tg>ijl辪萶╬抮jq q?QOFF,0,,,falseU0,1,2,3,4,5,6,7,8o!n QOFF,0,,d,trueE0n n?QOFF,0,,,falseM0,1,2,3,4l!k QOFF,0,,d,trueE0k k?QOFF,0,,,falseU0,1,2,3,4,5,6,7,8i!h QOFF,0,,d,trueE0h h?QOFF,0,,,falseO0,1,2,3,4,5f!e QOFF,0,,d,trueE0e e?QOFF,0,,,falseZ0,1,2,3,4,5,6,7,8,9,10c!b QOFF,0,,d,trueE0b b?QOFF,0,,,falseM0,1,2,3,4`!_ QOFF,0,,d,trueE0_ _?QOFF,0,,,false
|0,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]!\ QOFF,0,,d,trueE0\ \?QOFF,0,,,falseO0,1,2,3,4,5Z!Y QOFF,0,,d,trueE0Y Y?QOFF,0,,,false]0,1,2,3,4,5,6,7,8,9,10,11W!V QOFF,0,,d,trueE0V V?QOFF,0,,,false
:0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22T!S QOFF,0,,d,trueE0S S?QOFF,0,,,falseK0,1,2,3Q!P QOFF,0,,d,trueE0P P?QOFF,0,,,falseS0,1,2,3,4,5,6,7N!M QOFF,0,,d,trueE0M M?QOFF,0,,,false]0,1,2,3,4,5,6,7,8,9,10,11K!J QOFF,0,,d,trueE0J J?QOFF,0,,,falseS0,1,2,3,4,5,6,7H!G QOFF,0,,d,trueE0G G?QOFF,0,,,falseO0,1,2,3,4,5E!D QOFF,0,,d,trueE0D D?QOFF,0,,,falseU0,1,2,3,4,5,6,7,8B!A QOFF,0,,d,trueE0A A?QOFF,0,,,falseI0,1,2?!> QOFF,0,,d,trueE0> >?QOFF,0,,,falseS0,1,2,3,4,5,6,7<!; QOFF,0,,d,trueE0; ;?QOFF,0,,,falseU0,1,2,3,4,5,6,7,89!8 QOFF,0,,d,trueE08 8?QOFF,0,,,falseM0,1,2,3,46!5 QOFF,0,,d,trueE05 5?QOFF,0,,,falseK0,1,2,33!2 QOFF,0,,d,trueE02 2?QOFF,0,,,falseW0,1,2,3,4,5,6,7,8,90!/ QOFF,0,,d,trueE0/ /?QOFF,0,,,falseQ0,1,2,3,4,5,6. .?QOFF,0,,,falseG0,1,!+ QOFF,0,,d,trueE0+ +?QOFF,0,,,falseM0,1,2,3,4)!( QOFF,0,,d,trueE0( (?QOFF,0,,,false
O0,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&!% QOFF,0,,d,trueE0% %?QOFF,0,,,falseQ0,1,2,3,4,5,6#!" QOFF,0,,d,trueE0" "?QOFF,0,,,falseM0,1,2,3,4 ! QOFF,0,,d,trueE0 ?QOFF,0,,,falseU0,1,2,3,4,5,6,7,8! QOFF,0,,d,trueE0 ?QOFF,0,,,falseK0,1,2,3! QOFF,0,,d,trueE0 ?QOFF,0,,,false`0,1,2,3,4,5,6,7,8,9,10,11,12! QOFF,0,,d,trueE0 ?QOFF,0,,,falseW0,1,2,3,4,5,6,7,8,9! QOFF,0,,d,trueE0 ?QOFF,0,,,falsec0,1,2,3,4,5,6,7,8,9,10,11,12,13! QOFF,0,,d,trueE0 ?QOFF,0,,,false`0,1,2,3,4,5,6,7,8,9,10,11,12/ /?QOFF,0,,,falseG0,1+!* QOFF,0,,d,trueE0* *?QOFF,0,,,falseI0,1,2)!&?QOFF,0,,,falseG4,0'!&?QOFF,0,,,falseG0,1& &?QOFF,0,,,falseM0,1,2,3,4%!"?QOFF,0,,,falseE2#!" QOFF,0,,d,trueE0" "?QOFF,0,,,falseI0,1,2   ?QOFF,0,,,falseK0,1,2,3洞????Ps陁葀瞲坹r{R|<~"蛝穫厓m?A?)?
?
駤
祵
潕
?
g?
A?
)?龝鍡翗}?e?A?)???纾饯ウ{?c???'?

惘
拱
〔
}?
e?
;?
#?		寤	良	┚	兛	k?	G?	/?	?肭侨兯k?K?3?阌乖≈V?>?"??燧罗庘q?V?9? ????!"?QOFF,0,,,falseE1?!?QOFF,0,,,falseG8,7?!?QOFF,0,,,falseE1?!?QOFF,0,,,falseI12,11?!?QOFF,0,,,falseG9,4?!?QOFF,0,,,falseI13,12?!?QOFF,0,,,falseH11,6?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseU0,1,2,3,4,5,6,7,8?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseI0,1,2? ??QOFF,0,,,falseG0,1?!? QOFF,0,,d,trueE0? ??QOFF,0,,,false
10,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseU0,1,2,3,4,5,6,7,8?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falsec0,1,2,3,4,5,6,7,8,9,10,11,12,13?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseK0,1,2,3?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseW0,1,2,3,4,5,6,7,8,9?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseO0,1,2,3,4,5?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseW0,1,2,3,4,5,6,7,8,9?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseO0,1,2,3,4,5?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseQ0,1,2,3,4,5,6?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseO0,1,2,3,4,5?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseQ0,1,2,3,4,5,6?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseU0,1,2,3,4,5,6,7,8?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseO0,1,2,3,4,5?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseU0,1,2,3,4,5,6,7,8?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseW0,1,2,3,4,5,6,7,8,9?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseO0,1,2,3,4,5?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseU0,1,2,3,4,5,6,7,8?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseU0,1,2,3,4,5,6,7,8?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseU0,1,2,3,4,5,6,7,8?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseO0,1,2,3,4,5?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseW0,1,2,3,4,5,6,7,8,9?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseO0,1,2,3,4,5?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseW0,1,2,3,4,5,6,7,8,9?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseQ0,1,2,3,4,5,6?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseI0,1,2?!? QOFF,0,,d,trueE0? ??QOFF,0,,,false
"0,1,2,3,4,5,6,7,8,9,10,11,12,13,14?!??QOFF,0,,,falseG0,1? ??QOFF,0,,,falseG0,1?!? QOFF,0,,d,trueE0? ??QOFF,0,,,falseW0,1,2,3,4,5,6,7,8,9?!? QOFF,0,,d,trueE0? ??QOFF,0,,,false]0,1,2,3,4,5,6,7,8,9,10,11!~ QOFF,0,,d,trueE0~ ~?QOFF,0,,,false
=0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23} }?QOFF,0,,,falseG0,1{!z QOFF,0,,d,trueE0z z?QOFF,0,,,falseM0,1,2,3,4x!w QOFF,0,,d,trueE0w w?QOFF,0,,,falseW0,1,2,3,4,5,6,7,8,9u!t QOFF,0,,d,trueE0t t?QOFF,0,,,falseO0,1,2,3,4,5r!q QOFF,0,,d,trueE0鴉?	鹒?
?6?W?
玻
L?播b?
螫
Q?	b?铼I???? !
`CREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_19 ON SALESMANAGER.PRODUCT_REVIEW(PRODUCT_REVIEW_ID)?  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT_REVIEW(
    PRODUCT_REVIEW_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    REVIEW_DATE TIMESTAMP,
    REVIEWS_RATING DOUBLE,
    REVIEWS_READ BIGINT,
    STATUS INTEGER,
    CUSTOMERS_ID BIGINT,
    PRODUCT_ID BIGINT
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_RELATIONSHIP ADD CONSTRAINT SALESMANAGER.CONSTRAINT_DD PRIMARY KEY(PRODUCT_RELATIONSHIP_ID) INDEX SALESMANAGER.PRIMARY_KEY_DD? !
lCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_DD ON SALESMANAGER.PRODUCT_RELATIONSHIP(PRODUCT_RELATIONSHIP_ID)?  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT_RELATIONSHIP(
    PRODUCT_RELATIONSHIP_ID BIGINT NOT NULL,
    ACTIVE BOOLEAN,
    CODE VARCHAR(255),
    PRODUCT_ID BIGINT,
    RELATED_PRODUCT_ID BIGINT,
    MERCHANT_ID INTEGER NOT NULL
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_PRICE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_54 PRIMARY KEY(DESCRIPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_54? !
hCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_54 ON SALESMANAGER.PRODUCT_PRICE_DESCRIPTION(DESCRIPTION_ID)?  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT_PRICE_DESCRIPTION(
    DESCRIPTION_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    DESCRIPTION CLOB,
    NAME VARCHAR(120) NOT NULL,
    TITLE VARCHAR(100),
    LANGUAGE_ID INTEGER NOT NULL,
    PRODUCT_PRICE_ID BIGINT NOT NULL
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_PRICE ADD CONSTRAINT SALESMANAGER.CONSTRAINT_42C PRIMARY KEY(PRODUCT_PRICE_ID) INDEX SALESMANAGER.PRIMARY_KEY_42C? !
_CREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_42C ON SALESMANAGER.PRODUCT_PRICE(PRODUCT_PRICE_ID)?  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT_PRICE(
    PRODUCT_PRICE_ID BIGINT NOT NULL,
    PRODUCT_PRICE_CODE VARCHAR(255) NOT NULL,
    DEFAULT_PRICE BOOLEAN,
    PRODUCT_PRICE_AMOUNT DECIMAL(19, 2) NOT NULL,
    PRODUCT_PRICE_SPECIAL_AMOUNT DECIMAL(19, 2),
    PRODUCT_PRICE_SPECIAL_END_DATE DATE,
    PRODUCT_PRICE_SPECIAL_ST_DATE DATE,
    PRODUCT_PRICE_TYPE VARCHAR(20),
    PRODUCT_AVAIL_ID BIGINT NOT NULL
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION_VALUE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_1E PRIMARY KEY(DESCRIPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_1E忛????2?3?5?6?6AHtest5!5AHtest2!3AHtest!2AQFEATURED_ITEM6!4AQFEATURED_ITEM2!3AQFEATURED_ITEM5!1AQFEATURED_ITEM1!庂?	?萁壕椏t?Q?.?鴢袧?+鴢袧?+NBase price!6?嘎蠞?+嘎蠞?+NBase price!5?鴥蠞?+鴥蠞?+NBase price!4?概螡?+概螡?+NBase price!3???蜐?+??蜐?+NBase price!2?鶏伿?+鶏伿?+NBase price!1i"?	?????m6HbaseA;?LONE_TIME65HbaseA;?LONE_TIME54HbaseA;?LONE_TIME43HbaseA;?LONE_TIME32HbaseA;?LONE_TIME21HbaseA;?;?LONE_TIME1屬?	???拓瓷?+拓瓷?+GRed!1墛6?`?D?
軜
@?詺k?
蠝	灊	*?偀-??? !
oCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_1E ON SALESMANAGER.PRODUCT_OPTION_VALUE_DESCRIPTION(DESCRIPTION_ID)?  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT_OPTION_VALUE_DESCRIPTION(
    DESCRIPTION_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    DESCRIPTION CLOB,
    NAME VARCHAR(120) NOT NULL,
    TITLE VARCHAR(100),
    LANGUAGE_ID INTEGER NOT NULL,
    PRODUCT_OPTION_VALUE_ID BIGINT
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION_VALUE ADD CONSTRAINT SALESMANAGER.CONSTRAINT_8D0 PRIMARY KEY(PRODUCT_OPTION_VALUE_ID) INDEX SALESMANAGER.PRIMARY_KEY_8D0? !
mCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_8D0 ON SALESMANAGER.PRODUCT_OPTION_VALUE(PRODUCT_OPTION_VALUE_ID)?  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT_OPTION_VALUE(
    PRODUCT_OPTION_VALUE_ID BIGINT NOT NULL,
    PRODUCT_OPTION_VAL_CODE VARCHAR(255) NOT NULL,
    PRODUCT_OPT_FOR_DISP BOOLEAN,
    PRODUCT_OPT_VAL_IMAGE VARCHAR(255),
    PRODUCT_OPT_VAL_SORT_ORD INTEGER,
    MERCHANT_ID INTEGER NOT NULL
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION_DESC ADD CONSTRAINT SALESMANAGER.CONSTRAINT_88 PRIMARY KEY(DESCRIPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_88? !
bCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_88 ON SALESMANAGER.PRODUCT_OPTION_DESC(DESCRIPTION_ID)?  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT_OPTION_DESC(
    DESCRIPTION_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    DESCRIPTION CLOB,
    NAME VARCHAR(120) NOT NULL,
    TITLE VARCHAR(100),
    PRODUCT_OPTION_COMMENT CLOB,
    LANGUAGE_ID INTEGER NOT NULL,
    PRODUCT_OPTION_ID BIGINT NOT NULL
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_14D PRIMARY KEY(PRODUCT_OPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_14D? !
aCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_14D ON SALESMANAGER.PRODUCT_OPTION(PRODUCT_OPTION_ID)?  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT_OPTION(
    PRODUCT_OPTION_ID BIGINT NOT NULL,
    PRODUCT_OPTION_CODE VARCHAR(255) NOT NULL,
    PRODUCT_OPTION_SORT_ORD INTEGER,
    PRODUCT_OPTION_TYPE VARCHAR(10),
    PRODUCT_OPTION_READ BOOLEAN,
    MERCHANT_ID INTEGER NOT NULL
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_IMAGE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_7 PRIMARY KEY(DESCRIPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_7脟??1Gred@D!戀?
???垗轄?+垗轄?+HTest!1???1GabcIradio@!錰?
窏???????6A@ Ngoogle.jpg65A@ Pandroid2.jpg54A@ Oandroid.jpg43A@ Lpaas.JPG32A@ Lnode.jpg21A@ Nspring.png1?6?^?
]?魧X?睅G?
⿶	湋	7?煋5??? !
gCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_7 ON SALESMANAGER.PRODUCT_IMAGE_DESCRIPTION(DESCRIPTION_ID)?  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT_IMAGE_DESCRIPTION(
    DESCRIPTION_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    DESCRIPTION CLOB,
    NAME VARCHAR(120) NOT NULL,
    TITLE VARCHAR(100),
    ALT_TAG VARCHAR(100),
    LANGUAGE_ID INTEGER NOT NULL,
    PRODUCT_IMAGE_ID BIGINT NOT NULL
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_IMAGE ADD CONSTRAINT SALESMANAGER.CONSTRAINT_42 PRIMARY KEY(PRODUCT_IMAGE_ID) INDEX SALESMANAGER.PRIMARY_KEY_42? !
^CREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_42 ON SALESMANAGER.PRODUCT_IMAGE(PRODUCT_IMAGE_ID)?  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT_IMAGE(
    PRODUCT_IMAGE_ID BIGINT NOT NULL,
    DEFAULT_IMAGE BOOLEAN,
    IMAGE_CROP BOOLEAN,
    IMAGE_TYPE INTEGER,
    PRODUCT_IMAGE VARCHAR(255),
    PRODUCT_IMAGE_URL VARCHAR(255),
    PRODUCT_ID BIGINT NOT NULL
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_DIGITAL ADD CONSTRAINT SALESMANAGER.CONSTRAINT_332 PRIMARY KEY(PRODUCT_DIGITAL_ID) INDEX SALESMANAGER.PRIMARY_KEY_332? !
cCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_332 ON SALESMANAGER.PRODUCT_DIGITAL(PRODUCT_DIGITAL_ID)?  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT_DIGITAL(
    PRODUCT_DIGITAL_ID BIGINT NOT NULL,
    FILE_NAME VARCHAR(255) NOT NULL,
    PRODUCT_ID BIGINT NOT NULL
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_DESCRIPTION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_35 PRIMARY KEY(DESCRIPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_35? !
bCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_35 ON SALESMANAGER.PRODUCT_DESCRIPTION(DESCRIPTION_ID)?  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT_DESCRIPTION(
    DESCRIPTION_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    DESCRIPTION CLOB,
    NAME VARCHAR(120) NOT NULL,
    TITLE VARCHAR(100),
    META_DESCRIPTION VARCHAR(255),
    META_KEYWORDS VARCHAR(255),
    META_TITLE VARCHAR(255),
    DOWNLOAD_LNK VARCHAR(255),
    PRODUCT_HIGHLIGHT VARCHAR(255),
    SEF_URL VARCHAR(255),
    LANGUAGE_ID INTEGER NOT NULL,
    PRODUCT_ID BIGINT NOT NULL
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_CATEGORY ADD CONSTRAINT SALESMANAGER.CONSTRAINT_39 PRIMARY KEY(PRODUCT_ID, CATEGORY_ID) INDEX SALESMANAGER.PRIMARY_KEY_39鎓?涃??岋E?h?-?鴢袧?+鴢袧?+RThe Big SwitchRthe-big-switch!6?嘎蠞?+嘎蠞?+XAndroid 3.0 CookbookVandroid-3-cookbook!5?鴥蠞?+鴥蠞?+WAndroid developmentcandroid-application-development!4?概螡?+概螡?+XProgramming for PAASXprogramming-for-paas!3???蜐?+??蜐?+XNode Web DevelopmentXNode-Web-Development!2?鄙?+鄙?+$<p>
	Spring boot and security</p>
TSpring in ActionDDTSpring in ActionDDTSpring-in-Action!1??????????6653433724231413忹?????????6653433724231413箺?
??????6
犇?@d  AE*65
犇?@d  AE*54
犇?@d  AE*43
犇?@d  AE*32
犇?@d  AE*21
犇?@d  AE*1?6}剘?G?粊	瑐	??焺=?袉/?磮E? !
hCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_39 ON SALESMANAGER.PRODUCT_CATEGORY(PRODUCT_ID, CATEGORY_ID)?  
tCREATE CACHED TABLE SALESMANAGER.PRODUCT_CATEGORY(
    PRODUCT_ID BIGINT NOT NULL,
    CATEGORY_ID BIGINT NOT NULL
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_AVAILABILITY ADD CONSTRAINT SALESMANAGER.CONSTRAINT_63B PRIMARY KEY(PRODUCT_AVAIL_ID) INDEX SALESMANAGER.PRIMARY_KEY_63B? !
fCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_63B ON SALESMANAGER.PRODUCT_AVAILABILITY(PRODUCT_AVAIL_ID)?  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT_AVAILABILITY(
    PRODUCT_AVAIL_ID BIGINT NOT NULL,
    DATE_AVAILABLE DATE,
    FREE_SHIPPING BOOLEAN,
    QUANTITY INTEGER NOT NULL,
    QUANTITY_ORD_MAX INTEGER,
    QUANTITY_ORD_MIN INTEGER,
    STATUS BOOLEAN,
    REGION VARCHAR(255),
    REGION_VARIANT VARCHAR(255),
    PRODUCT_ID BIGINT NOT NULL
)? %
?ALTER TABLE SALESMANAGER.PRODUCT_ATTRIBUTE ADD CONSTRAINT SALESMANAGER.CONSTRAINT_8D PRIMARY KEY(PRODUCT_ATTRIBUTE_ID) INDEX SALESMANAGER.PRIMARY_KEY_8D? !
fCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_8D ON SALESMANAGER.PRODUCT_ATTRIBUTE(PRODUCT_ATTRIBUTE_ID)?  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT_ATTRIBUTE(
    PRODUCT_ATTRIBUTE_ID BIGINT NOT NULL,
    PRODUCT_ATTRIBUTE_DEFAULT BOOLEAN,
    PRODUCT_ATTRIBUTE_DISCOUNTED BOOLEAN,
    PRODUCT_ATTRIBUTE_FOR_DISP BOOLEAN,
    PRODUCT_ATTRIBUTE_REQUIRED BOOLEAN,
    PRODUCT_ATTRIBUTE_FREE BOOLEAN,
    PRODUCT_ATRIBUTE_PRICE DECIMAL(19, 2),
    PRODUCT_ATTRIBUTE_WEIGHT DECIMAL(19, 2),
    PRODUCT_ATTRIBUTE_SORT_ORD INTEGER,
    PRODUCT_ID BIGINT NOT NULL,
    OPTION_ID BIGINT NOT NULL,
    OPTION_VALUE_ID BIGINT NOT NULL
)? %
?ALTER TABLE SALESMANAGER.PRODUCT ADD CONSTRAINT SALESMANAGER.CONSTRAINT_18 PRIMARY KEY(PRODUCT_ID) INDEX SALESMANAGER.PRIMARY_KEY_18 !
RCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_18 ON SALESMANAGER.PRODUCT(PRODUCT_ID)~  
?CREATE CACHED TABLE SALESMANAGER.PRODUCT(
    PRODUCT_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    AVAILABLE BOOLEAN,
    DATE_AVAILABLE TIMESTAMP,
    PREORDER BOOLEAN,
    PRODUCT_HEIGHT DECIMAL(19, 2),
    PRODUCT_FREE BOOLEAN,
    PRODUCT_LENGTH DECIMAL(19, 2),
    QUANTITY_ORDERED INTEGER,
    REVIEW_AVG DECIMAL(19, 2),
    REVIEW_COUNT INTEGER,
    PRODUCT_SHIP BOOLEAN,
    PRODUCT_VIRTUAL BOOLEAN,
    PRODUCT_WEIGHT DECIMAL(19, 2),
    PRODUCT_WIDTH DECIMAL(19, 2),
    REF_SKU VARCHAR(255),
    SKU VARCHAR(255) NOT NULL,
    SORT_ORDER INTEGER,
    MANUFACTURER_ID BIGINT,
    MERCHANT_ID INTEGER NOT NULL,
    TAX_CLASS_ID BIGINT,
    PRODUCT_TYPE_ID BIGINT
)}  
vCREATE CACHED TABLE SALESMANAGER.PERMISSION_GROUP(
    PERMISSION_ID INTEGER NOT NULL,
    GROUP_ID INTEGER NOT NULL
)靎?嶚~??M??6鴢袧?+鴢袧?+A鴢袧?+@;?@;?A@;dLLL333444 5!15嘎蠞?+嘎蠞?+A嘎蠞?+@;?@;?A@;dLSF333346 3!14鴥蠞?+鴥蠞?+A鴥蠞?+@;?@;?A@;dLSF333345 2!13概螡?+概螡?+A概螡?+@;?@;?A@;dJNB1111 1!12??蜐?+??蜐?+A??蜐?+@;?@;?A@;dJTB2468 3!11啊蜐?+鄙?+A?樃媿+@;?@;?A@;?DKTB12345 4!11}#????????	?
???
??????????????????? ?!?"?#?-',$,",!+"+$+!*"*$*!)")$)!("($(!'&'"'!&"&%&!%#%"%!$%$$$#$"$!#"#!"!!"!!‵z
????{cI1	
??
?-啊蜐?+啊蜐?+QAUTH_CUSTOMER,啊蜐?+啊蜐?+LSHIPPING+啊蜐?+啊蜐?+LCUSTOMER*啊蜐?+啊蜐?+KPAYMENT)啊蜐?+啊蜐?+GTAX(啊蜐?+啊蜐?+ISTORE'啊蜐?+啊蜐?+KCONTENT&啊蜐?+啊蜐?+IORDER%啊蜐?+啊蜐?+LPRODUCTS$啊蜐?+啊蜐?+HAUTH#啊蜐?+啊蜐?+IADMIN"啊蜐?+啊蜐?+NSUPERADMIN!啊蜐?+啊蜐?+OSTORE_ADMIN ?6qWr
鐂
DtMu踲6w	詘	ry輟{獆| %
?ALTER TABLE SALESMANAGER.PERMISSION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_FE PRIMARY KEY(PERMISSION_ID) INDEX SALESMANAGER.PRIMARY_KEY_FE{ !
XCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_FE ON SALESMANAGER.PERMISSION(PERMISSION_ID)z  
?CREATE CACHED TABLE SALESMANAGER.PERMISSION(
    PERMISSION_ID INTEGER NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    PERMISSION_NAME VARCHAR(255) NOT NULL
)y %
?ALTER TABLE SALESMANAGER.ORDER_TOTAL ADD CONSTRAINT SALESMANAGER.CONSTRAINT_2C PRIMARY KEY(ORDER_ACCOUNT_ID) INDEX SALESMANAGER.PRIMARY_KEY_2Cx !
\CREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_2C ON SALESMANAGER.ORDER_TOTAL(ORDER_ACCOUNT_ID)w  
?CREATE CACHED TABLE SALESMANAGER.ORDER_TOTAL(
    ORDER_ACCOUNT_ID BIGINT NOT NULL,
    MODULE VARCHAR(60),
    CODE VARCHAR(255) NOT NULL,
    ORDER_TOTAL_TYPE VARCHAR(255),
    ORDER_VALUE_TYPE VARCHAR(255),
    SORT_ORDER INTEGER NOT NULL,
    TEXT CLOB,
    TITLE VARCHAR(255),
    VALUE DECIMAL(15, 4) NOT NULL,
    ORDER_ID BIGINT NOT NULL
)v %
?ALTER TABLE SALESMANAGER.ORDER_STATUS_HISTORY ADD CONSTRAINT SALESMANAGER.CONSTRAINT_53 PRIMARY KEY(ORDER_STATUS_HISTORY_ID) INDEX SALESMANAGER.PRIMARY_KEY_53u !
lCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_53 ON SALESMANAGER.ORDER_STATUS_HISTORY(ORDER_STATUS_HISTORY_ID)t  
?CREATE CACHED TABLE SALESMANAGER.ORDER_STATUS_HISTORY(
    ORDER_STATUS_HISTORY_ID BIGINT NOT NULL,
    COMMENTS CLOB,
    CUSTOMER_NOTIFIED INTEGER,
    DATE_ADDED TIMESTAMP NOT NULL,
    STATUS VARCHAR(255),
    ORDER_ID BIGINT NOT NULL
)s %
?ALTER TABLE SALESMANAGER.ORDER_PRODUCT_PRICE ADD CONSTRAINT SALESMANAGER.CONSTRAINT_84 PRIMARY KEY(ORDER_PRODUCT_PRICE_ID) INDEX SALESMANAGER.PRIMARY_KEY_84r !
jCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_84 ON SALESMANAGER.ORDER_PRODUCT_PRICE(ORDER_PRODUCT_PRICE_ID)q  
?CREATE CACHED TABLE SALESMANAGER.ORDER_PRODUCT_PRICE(
    ORDER_PRODUCT_PRICE_ID BIGINT NOT NULL,
    DEFAULT_PRICE BOOLEAN NOT NULL,
    PRODUCT_PRICE DECIMAL(19, 2) NOT NULL,
    PRODUCT_PRICE_CODE VARCHAR(64) NOT NULL,
    PRODUCT_PRICE_NAME VARCHAR(255),
    PRODUCT_PRICE_SPECIAL DECIMAL(19, 2),
    PRD_PRICE_SPECIAL_END_DT TIMESTAMP,
    PRD_PRICE_SPECIAL_ST_DT TIMESTAMP,
    ORDER_PRODUCT_ID BIGINT NOT NULL
)L?w
??~3ItotalItotalLONE_TIME"TotalITotal;溡12GtaxGtaxLONE_TIME!TaxGTax;栏11KsummaryLsubtotalLONE_TIME SummaryKSummary;軝1?!t?1We received your order!缚袧?+KORDERED1F?q	?1A;?MbasepriceNBase Price1n?1!ZYour digital file name1gk	&?6e
說
ag篽癷Lj
祂鈒jm縩琽6p?p %
?ALTER TABLE SALESMANAGER.ORDER_PRODUCT_DOWNLOAD ADD CONSTRAINT SALESMANAGER.CONSTRAINT_F3 PRIMARY KEY(ORDER_PRODUCT_DOWNLOAD_ID) INDEX SALESMANAGER.PRIMARY_KEY_F3o !
pCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_F3 ON SALESMANAGER.ORDER_PRODUCT_DOWNLOAD(ORDER_PRODUCT_DOWNLOAD_ID)n  
?CREATE CACHED TABLE SALESMANAGER.ORDER_PRODUCT_DOWNLOAD(
    ORDER_PRODUCT_DOWNLOAD_ID BIGINT NOT NULL,
    DOWNLOAD_COUNT INTEGER NOT NULL,
    DOWNLOAD_MAXDAYS INTEGER NOT NULL,
    ORDER_PRODUCT_FILENAME VARCHAR(255) NOT NULL,
    ORDER_PRODUCT_ID BIGINT NOT NULL
)m %
?ALTER TABLE SALESMANAGER.ORDER_PRODUCT_ATTRIBUTE ADD CONSTRAINT SALESMANAGER.CONSTRAINT_23 PRIMARY KEY(ORDER_PRODUCT_ATTRIBUTE_ID) INDEX SALESMANAGER.PRIMARY_KEY_23l !
rCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_23 ON SALESMANAGER.ORDER_PRODUCT_ATTRIBUTE(ORDER_PRODUCT_ATTRIBUTE_ID)k  
?CREATE CACHED TABLE SALESMANAGER.ORDER_PRODUCT_ATTRIBUTE(
    ORDER_PRODUCT_ATTRIBUTE_ID BIGINT NOT NULL,
    PRODUCT_ATTRIBUTE_IS_FREE BOOLEAN NOT NULL,
    PRODUCT_ATTRIBUTE_NAME VARCHAR(255),
    PRODUCT_ATTRIBUTE_PRICE DECIMAL(15, 4) NOT NULL,
    PRODUCT_ATTRIBUTE_VAL_NAME VARCHAR(255),
    PRODUCT_ATTRIBUTE_WEIGHT DECIMAL(15, 4),
    PRODUCT_OPTION_ID BIGINT NOT NULL,
    PRODUCT_OPTION_VALUE_ID BIGINT NOT NULL,
    ORDER_PRODUCT_ID BIGINT NOT NULL
)j %
?ALTER TABLE SALESMANAGER.ORDER_PRODUCT ADD CONSTRAINT SALESMANAGER.CONSTRAINT_98 PRIMARY KEY(ORDER_PRODUCT_ID) INDEX SALESMANAGER.PRIMARY_KEY_98i !
^CREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_98 ON SALESMANAGER.ORDER_PRODUCT(ORDER_PRODUCT_ID)h  
?CREATE CACHED TABLE SALESMANAGER.ORDER_PRODUCT(
    ORDER_PRODUCT_ID BIGINT NOT NULL,
    ONETIME_CHARGE DECIMAL(19, 2) NOT NULL,
    PRODUCT_NAME VARCHAR(64) NOT NULL,
    PRODUCT_QUANTITY INTEGER,
    PRODUCT_SKU VARCHAR(255),
    ORDER_ID BIGINT NOT NULL
)g %
?ALTER TABLE SALESMANAGER.ORDER_ACCOUNT_PRODUCT ADD CONSTRAINT SALESMANAGER.CONSTRAINT_20 PRIMARY KEY(ORDER_ACCOUNT_PRODUCT_ID) INDEX SALESMANAGER.PRIMARY_KEY_20f !
nCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_20 ON SALESMANAGER.ORDER_ACCOUNT_PRODUCT(ORDER_ACCOUNT_PRODUCT_ID)e  
?CREATE CACHED TABLE SALESMANAGER.ORDER_ACCOUNT_PRODUCT(
    ORDER_ACCOUNT_PRODUCT_ID BIGINT NOT NULL,
    ORDER_ACCOUNT_PRODUCT_ACCNT_DT DATE,
    ORDER_ACCOUNT_PRODUCT_END_DT DATE,
    ORDER_ACCOUNT_PRODUCT_EOT TIMESTAMP,
    ORDER_ACCOUNT_PRODUCT_L_ST_DT TIMESTAMP,
    ORDER_ACCOUNT_PRODUCT_L_TRX_ST INTEGER NOT NULL,
    ORDER_ACCOUNT_PRODUCT_PM_FR_TY INTEGER NOT NULL,
    ORDER_ACCOUNT_PRODUCT_ST_DT DATE NOT NULL,
    ORDER_ACCOUNT_PRODUCT_STATUS INTEGER NOT NULL,
    ORDER_ACCOUNT_ID BIGINT NOT NULL,
    ORDER_PRODUCT_ID BIGINT NOT NULL
)h?1;?PProduct name!KTB123451gegbK6
[b\宂8^
盻萡ta颾鷆杁?d %
?ALTER TABLE SALESMANAGER.ORDER_ACCOUNT ADD CONSTRAINT SALESMANAGER.CONSTRAINT_64 PRIMARY KEY(ORDER_ACCOUNT_ID) INDEX SALESMANAGER.PRIMARY_KEY_64c !
^CREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_64 ON SALESMANAGER.ORDER_ACCOUNT(ORDER_ACCOUNT_ID)b  
?CREATE CACHED TABLE SALESMANAGER.ORDER_ACCOUNT(
    ORDER_ACCOUNT_ID BIGINT NOT NULL,
    ORDER_ACCOUNT_BILL_DAY INTEGER NOT NULL,
    ORDER_ACCOUNT_END_DATE DATE,
    ORDER_ACCOUNT_START_DATE DATE NOT NULL,
    ORDER_ID BIGINT NOT NULL
)a %
ALTER TABLE SALESMANAGER.ORDERS ADD CONSTRAINT SALESMANAGER.CONSTRAINT_8 PRIMARY KEY(ORDER_ID) INDEX SALESMANAGER.PRIMARY_KEY_8` !
NCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_8 ON SALESMANAGER.ORDERS(ORDER_ID)_  
?CREATE CACHED TABLE SALESMANAGER.ORDERS(
    ORDER_ID BIGINT NOT NULL,
    BILLING_STREET_ADDRESS VARCHAR(256),
    BILLING_CITY VARCHAR(100),
    BILLING_COMPANY VARCHAR(100),
    BILLING_FIRST_NAME VARCHAR(64) NOT NULL,
    BILLING_LAST_NAME VARCHAR(64) NOT NULL,
    BILLING_POSTCODE VARCHAR(20),
    BILLING_STATE VARCHAR(100),
    BILLING_TELEPHONE VARCHAR(32),
    CHANNEL VARCHAR(255),
    CONFIRMED_ADDRESS BOOLEAN,
    CARD_TYPE VARCHAR(255),
    CC_CVV VARCHAR(255),
    CC_EXPIRES VARCHAR(255),
    CC_NUMBER VARCHAR(255),
    CC_OWNER VARCHAR(255),
    CURRENCY_VALUE DECIMAL(19, 2),
    CUSTOMER_AGREED BOOLEAN,
    CUSTOMER_EMAIL_ADDRESS VARCHAR(50) NOT NULL,
    CUSTOMER_ID BIGINT,
    DATE_PURCHASED DATE,
    DELIVERY_STREET_ADDRESS VARCHAR(256),
    DELIVERY_CITY VARCHAR(100),
    DELIVERY_COMPANY VARCHAR(100),
    DELIVERY_FIRST_NAME VARCHAR(64),
    DELIVERY_LAST_NAME VARCHAR(64),
    DELIVERY_POSTCODE VARCHAR(20),
    DELIVERY_STATE VARCHAR(100),
    DELIVERY_TELEPHONE VARCHAR(32),
    IP_ADDRESS VARCHAR(255),
    LAST_MODIFIED TIMESTAMP,
    LOCALE VARCHAR(255),
    ORDER_DATE_FINISHED TIMESTAMP,
    ORDER_TYPE VARCHAR(255),
    PAYMENT_MODULE_CODE VARCHAR(255),
    PAYMENT_TYPE VARCHAR(255),
    SHIPPING_MODULE_CODE VARCHAR(255),
    ORDER_STATUS VARCHAR(255),
    ORDER_TOTAL DECIMAL(19, 2),
    BILLING_COUNTRY_ID INTEGER NOT NULL,
    BILLING_ZONE_ID BIGINT,
    CURRENCY_ID BIGINT,
    DELIVERY_COUNTRY_ID INTEGER,
    DELIVERY_ZONE_ID BIGINT,
    MERCHANTID INTEGER
)^ %
?ALTER TABLE SALESMANAGER.OPTIN ADD CONSTRAINT SALESMANAGER.CONSTRAINT_47 PRIMARY KEY(OPTIN_ID) INDEX SALESMANAGER.PRIMARY_KEY_47] !
NCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_47 ON SALESMANAGER.OPTIN(OPTIN_ID)\  
?CREATE CACHED TABLE SALESMANAGER.OPTIN(
    OPTIN_ID BIGINT NOT NULL,
    CODE VARCHAR(255) NOT NULL,
    DESCRIPTION VARCHAR(255),
    END_DATE TIMESTAMP,
    START_DATE TIMESTAMP,
    MERCHANT_ID INTEGER
)[ %
?ALTER TABLE SALESMANAGER.MODULE_CONFIGURATION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_501 PRIMARY KEY(MODULE_CONF_ID) INDEX SALESMANAGER.PRIMARY_KEY_5016?_-1T358 Du LanguadocPBouchervilleSCSTI ConsultingLLeonardoLDiCaprioKJ4B-8J9@;b@Tleo@shopizer.com1
犇?T358 Du LanguadocPBouchervilleLLeonardoLDiCaprioKJ4B-8J9MipAddress缚袧?+Ien_US缚袧?+IORDERJpaypalJPAYPALMDELIVERED;?-i-!g\t?6S]T黆iV2W
襒
?Y荶]Z !
dCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_501 ON SALESMANAGER.MODULE_CONFIGURATION(MODULE_CONF_ID)Y  
?CREATE CACHED TABLE SALESMANAGER.MODULE_CONFIGURATION(
    MODULE_CONF_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    CODE VARCHAR(255) NOT NULL,
    DETAILS CLOB,
    CONFIGURATION CLOB,
    CUSTOM_IND BOOLEAN,
    IMAGE VARCHAR(255),
    MODULE VARCHAR(255),
    REGIONS VARCHAR(255),
    TYPE VARCHAR(255)
)X %
?ALTER TABLE SALESMANAGER.MERCHANT_STORE ADD CONSTRAINT SALESMANAGER.CONSTRAINT_AA PRIMARY KEY(MERCHANT_ID) INDEX SALESMANAGER.PRIMARY_KEY_AAW !
ZCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_AA ON SALESMANAGER.MERCHANT_STORE(MERCHANT_ID)V  
?CREATE CACHED TABLE SALESMANAGER.MERCHANT_STORE(
    MERCHANT_ID INTEGER NOT NULL,
    STORE_CODE VARCHAR(100) NOT NULL,
    CONTINUESHOPPINGURL VARCHAR(150),
    CURRENCY_FORMAT_NATIONAL BOOLEAN,
    DOMAIN_NAME VARCHAR(80),
    IN_BUSINESS_SINCE DATE,
    INVOICE_TEMPLATE VARCHAR(25),
    SEIZEUNITCODE VARCHAR(5),
    STORE_EMAIL VARCHAR(60) NOT NULL,
    STORE_LOGO VARCHAR(100),
    STORE_TEMPLATE VARCHAR(25),
    STORE_ADDRESS VARCHAR(255),
    STORE_CITY VARCHAR(100) NOT NULL,
    STORE_NAME VARCHAR(100) NOT NULL,
    STORE_PHONE VARCHAR(50) NOT NULL,
    STORE_POSTAL_CODE VARCHAR(15) NOT NULL,
    STORE_STATE_PROV VARCHAR(100),
    USE_CACHE BOOLEAN,
    WEIGHTUNITCODE VARCHAR(5),
    COUNTRY_ID INTEGER NOT NULL,
    CURRENCY_ID BIGINT NOT NULL,
    LANGUAGE_ID INTEGER NOT NULL,
    ZONE_ID BIGINT
)U %
?ALTER TABLE SALESMANAGER.MERCHANT_LOG ADD CONSTRAINT SALESMANAGER.CONSTRAINT_A PRIMARY KEY(MERCHANT_LOG_ID) INDEX SALESMANAGER.PRIMARY_KEY_AT !
[CREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_A ON SALESMANAGER.MERCHANT_LOG(MERCHANT_LOG_ID)S  
?CREATE CACHED TABLE SALESMANAGER.MERCHANT_LOG(
    MERCHANT_LOG_ID BIGINT NOT NULL,
    LOG CLOB,
    MODULE VARCHAR(25),
    MERCHANT_ID INTEGER NOT NULL
)a Y?z6
?
?
d
	?
b啊蜐?+啊蜐?+Jstripe?[{"scheme":"https","host":"www.stripe.com","port":"443","uri":"/","env":"TEST","config1":null,"config2":null},{"scheme":"https","host":"www.stripe.com","port":"443","uri":"/","env":"PROD","config1":null,"config2":null}]@Nstripe.pngKPAYMENT
.["US","CA","GB","AU","FI","DK","IE","NO","SE"]Ncreditcard
啊蜐?+啊蜐?+Nbeanstream????Y
?@Rbeanstream.gifKPAYMENTT["US","CA","GB"]Ncreditcard	啊蜐?+啊蜐?+[paypal-express-checkout????Y?@Sicon-paypal.pngKPAYMENTI["*"]Jpaypal啊蜐?+啊蜐?+Nmoneyorder@Rmoneyorder.gifKPAYMENTI["*"]Nmoneyorder7啊蜐?+啊蜐?+OstorePickUp@LSHIPPINGI["*"]6啊蜐?+啊蜐?+SpriceByDistance@LSHIPPINGI["*"]5啊蜐?+啊蜐?+UcustomQuotesRules@LSHIPPINGI["*"]4啊蜐?+啊蜐?+OweightBasedALSHIPPINGI["*"]3啊蜐?+啊蜐?+Gups????Y??[{"scheme":"https","host":"wwwcie.ups.com","port":"443","uri":"/ups.app/xml/Rate","env":"TEST","config1":null,"config2":null},{"scheme":"https","host":"onlinetools.ups.com","port":"443","uri":"/xml/Rate","env":"PROD","config1":null,"config2":null}]@Kups.jpgLSHIPPINGY["US","CA","FR","GB"]2啊蜐?+啊蜐?+Ncanadapost????Y?@Rcanadapost.jpgLSHIPPINGJ["CA"]1啊蜐?+啊蜐?+Husps????Y?@Lusps.jpgLSHIPPINGJ["US"]yVz!KDEFAULT@Rlocalhost:8080
犇?FINQtest@test.comMbootstrapW1234 Street addressKMy cityQDefault storeP888-888-8888KH2H-2H2@FLB-i!gS&?P?2杄Uf?鏃Z?
懭??佼?+佼?+PEMAIL_CONFIGOINTEGRATION?{"protocol":"smtps","password":"julianne001","smtpAuth":true,"starttls":true,"port":"465","host":"smtp.gmail.com","username":"samsoncarl@gmail.com"}!??箴鈶+蜮?+OweightBasedOINTEGRATION?{"moduleCode":"weightBased","active":true,"regions":[{"customRegionName":"CANADA","countries":["CA"],"quoteItems":[{"price":10.00,"maximumWeight":10}]}]}!?疴?+疴?+LSHIPPINGOINTEGRATION`df02614ab6600db0eb4d78e2c4df55740a3632c23495d207674f0bdef76266c558848e0339163624c5fc30cda898f9b1!?辽钼?+辽钼?+KPAYMENTOINTEGRATION????P??!f佧?+???箲+SSHIPPING_CONFIGOINTEGRATION????P??!e蚬?+?+RSUPPORTED_CNTROINTEGRATION["US","HK","CA"]!2貓?+貓?+Ufacebook_page_urlJCONFIGwww.facebook.com!1啊蜐?+?+JCONFIGJCONFIG????P*?!?6G"H蒊>J
K癓M
rN
O	ePNQ郣@R %
?ALTER TABLE SALESMANAGER.MERCHANT_CONFIGURATION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_D PRIMARY KEY(MERCHANT_CONFIG_ID) INDEX SALESMANAGER.PRIMARY_KEY_DQ !
hCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_D ON SALESMANAGER.MERCHANT_CONFIGURATION(MERCHANT_CONFIG_ID)P  
?CREATE CACHED TABLE SALESMANAGER.MERCHANT_CONFIGURATION(
    MERCHANT_CONFIG_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    CONFIG_KEY VARCHAR(255),
    TYPE VARCHAR(255),
    VALUE CLOB,
    MERCHANT_ID INTEGER
)O %
?ALTER TABLE SALESMANAGER.MANUFACTURER_DESCRIPTION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_2F PRIMARY KEY(DESCRIPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_2FN !
gCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_2F ON SALESMANAGER.MANUFACTURER_DESCRIPTION(DESCRIPTION_ID)M  
?CREATE CACHED TABLE SALESMANAGER.MANUFACTURER_DESCRIPTION(
    DESCRIPTION_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    DESCRIPTION CLOB,
    NAME VARCHAR(120) NOT NULL,
    TITLE VARCHAR(100),
    DATE_LAST_CLICK TIMESTAMP,
    MANUFACTURERS_URL VARCHAR(255),
    URL_CLICKED INTEGER,
    LANGUAGE_ID INTEGER NOT NULL,
    MANUFACTURER_ID BIGINT NOT NULL
)L %
?ALTER TABLE SALESMANAGER.MANUFACTURER ADD CONSTRAINT SALESMANAGER.CONSTRAINT_14 PRIMARY KEY(MANUFACTURER_ID) INDEX SALESMANAGER.PRIMARY_KEY_14K !
\CREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_14 ON SALESMANAGER.MANUFACTURER(MANUFACTURER_ID)J  
?CREATE CACHED TABLE SALESMANAGER.MANUFACTURER(
    MANUFACTURER_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    CODE VARCHAR(100) NOT NULL,
    MANUFACTURER_IMAGE VARCHAR(255),
    SORT_ORDER INTEGER,
    MERCHANT_ID INTEGER NOT NULL
)I %
?ALTER TABLE SALESMANAGER.LANGUAGE ADD CONSTRAINT SALESMANAGER.CONSTRAINT_C PRIMARY KEY(LANGUAGE_ID) INDEX SALESMANAGER.PRIMARY_KEY_CH !
SCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_C ON SALESMANAGER.LANGUAGE(LANGUAGE_ID)G  
?CREATE CACHED TABLE SALESMANAGER.LANGUAGE(
    LANGUAGE_ID INTEGER NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    CODE VARCHAR(255) NOT NULL,
    SORT_ORDER INTEGER
)w?M?蹕粚殟w?I?啊蜐?+啊蜐?+VNovells publishing!5?啊蜐?+啊蜐?+KManning!4?啊蜐?+啊蜐?+IPackt!3?啊蜐?+啊蜐?+HSams!2?啊蜐?+啊蜐?+MO'Reilley!1G?J????s5啊蜐?+啊蜐?+Knovells !4啊蜐?+啊蜐?+Kmanning !3啊蜐?+啊蜐?+Ipackt !2啊蜐?+啊蜐?+Hsams !1啊蜐?+啊蜐?+Loreilley !iBG??"鄳蜐?+鄳蜐?+Ffr!鄳蜐?+鄳蜐?+FengD	JN69?:?;
?<
(=?>R?
馌
^A	螧	xC顳礒NF?F %
?ALTER TABLE SALESMANAGER.GEOZONE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_1 PRIMARY KEY(DESCRIPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_1E !
aCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_1 ON SALESMANAGER.GEOZONE_DESCRIPTION(DESCRIPTION_ID)D  
?CREATE CACHED TABLE SALESMANAGER.GEOZONE_DESCRIPTION(
    DESCRIPTION_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    DESCRIPTION CLOB,
    NAME VARCHAR(120) NOT NULL,
    TITLE VARCHAR(100),
    LANGUAGE_ID INTEGER NOT NULL,
    GEOZONE_ID BIGINT
)C %
?ALTER TABLE SALESMANAGER.GEOZONE ADD CONSTRAINT SALESMANAGER.CONSTRAINT_2 PRIMARY KEY(GEOZONE_ID) INDEX SALESMANAGER.PRIMARY_KEY_2B !
QCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_2 ON SALESMANAGER.GEOZONE(GEOZONE_ID)A  
?CREATE CACHED TABLE SALESMANAGER.GEOZONE(
    GEOZONE_ID BIGINT NOT NULL,
    GEOZONE_CODE VARCHAR(255),
    GEOZONE_NAME VARCHAR(255)
)@ %
?ALTER TABLE SALESMANAGER.FILE_HISTORY ADD CONSTRAINT SALESMANAGER.CONSTRAINT_F PRIMARY KEY(FILE_HISTORY_ID) INDEX SALESMANAGER.PRIMARY_KEY_F? !
[CREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_F ON SALESMANAGER.FILE_HISTORY(FILE_HISTORY_ID)>  
?CREATE CACHED TABLE SALESMANAGER.FILE_HISTORY(
    FILE_HISTORY_ID BIGINT NOT NULL,
    ACCOUNTED_DATE TIMESTAMP,
    DATE_ADDED TIMESTAMP NOT NULL,
    DATE_DELETED TIMESTAMP,
    DOWNLOAD_COUNT INTEGER NOT NULL,
    FILE_ID BIGINT,
    FILESIZE INTEGER NOT NULL,
    MERCHANT_ID INTEGER NOT NULL
)= %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPT_VAL_DESCRIPTION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_BB PRIMARY KEY(DESCRIPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_BB< !
kCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_BB ON SALESMANAGER.CUSTOMER_OPT_VAL_DESCRIPTION(DESCRIPTION_ID);  
?CREATE CACHED TABLE SALESMANAGER.CUSTOMER_OPT_VAL_DESCRIPTION(
    DESCRIPTION_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    DESCRIPTION CLOB,
    NAME VARCHAR(120) NOT NULL,
    TITLE VARCHAR(100),
    LANGUAGE_ID INTEGER NOT NULL,
    CUSTOMER_OPT_VAL_ID BIGINT
): %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION_VALUE ADD CONSTRAINT SALESMANAGER.CONSTRAINT_5E PRIMARY KEY(CUSTOMER_OPTION_VALUE_ID) INDEX SALESMANAGER.PRIMARY_KEY_5E9 !
nCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_5E ON SALESMANAGER.CUSTOMER_OPTION_VALUE(CUSTOMER_OPTION_VALUE_ID)gAg>x?;	???樛捔?+樛捔?+NTest Value!1N?8?1MtestValue !n?5?2 11}?2
???紥胬?+紥胬?+HTest!166+,?-
?.
?/V0?1S2	?3	}4?5
6?7?8?8  
?CREATE CACHED TABLE SALESMANAGER.CUSTOMER_OPTION_VALUE(
    CUSTOMER_OPTION_VALUE_ID BIGINT NOT NULL,
    CUSTOMER_OPT_VAL_CODE VARCHAR(255) NOT NULL,
    CUSTOMER_OPT_VAL_IMAGE VARCHAR(255),
    SORT_ORDER INTEGER,
    MERCHANT_ID INTEGER NOT NULL
)7 %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION_SET ADD CONSTRAINT SALESMANAGER.CONSTRAINT_5D PRIMARY KEY(CUSTOMER_OPTIONSET_ID) INDEX SALESMANAGER.PRIMARY_KEY_5D6 !
iCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_5D ON SALESMANAGER.CUSTOMER_OPTION_SET(CUSTOMER_OPTIONSET_ID)5  
?CREATE CACHED TABLE SALESMANAGER.CUSTOMER_OPTION_SET(
    CUSTOMER_OPTIONSET_ID BIGINT NOT NULL,
    SORT_ORDER INTEGER,
    CUSTOMER_OPTION_ID BIGINT NOT NULL,
    CUSTOMER_OPTION_VALUE_ID BIGINT NOT NULL
)4 %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION_DESC ADD CONSTRAINT SALESMANAGER.CONSTRAINT_4 PRIMARY KEY(DESCRIPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_43 !
bCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_4 ON SALESMANAGER.CUSTOMER_OPTION_DESC(DESCRIPTION_ID)2  
?CREATE CACHED TABLE SALESMANAGER.CUSTOMER_OPTION_DESC(
    DESCRIPTION_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    DESCRIPTION CLOB,
    NAME VARCHAR(120) NOT NULL,
    TITLE VARCHAR(100),
    CUSTOMER_OPTION_COMMENT CLOB,
    LANGUAGE_ID INTEGER NOT NULL,
    CUSTOMER_OPTION_ID BIGINT NOT NULL
)1 %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_33 PRIMARY KEY(CUSTOMER_OPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_330 !
bCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_33 ON SALESMANAGER.CUSTOMER_OPTION(CUSTOMER_OPTION_ID)/  
?CREATE CACHED TABLE SALESMANAGER.CUSTOMER_OPTION(
    CUSTOMER_OPTION_ID BIGINT NOT NULL,
    CUSTOMER_OPT_ACTIVE BOOLEAN,
    CUSTOMER_OPT_CODE VARCHAR(255) NOT NULL,
    CUSTOMER_OPTION_TYPE VARCHAR(10),
    CUSTOMER_OPT_PUBLIC BOOLEAN,
    SORT_ORDER INTEGER,
    MERCHANT_ID INTEGER NOT NULL
).  
qCREATE CACHED TABLE SALESMANAGER.CUSTOMER_GROUP(
    CUSTOMER_ID BIGINT NOT NULL,
    GROUP_ID INTEGER NOT NULL
)- %
?ALTER TABLE SALESMANAGER.CUSTOMER_ATTRIBUTE ADD CONSTRAINT SALESMANAGER.CONSTRAINT_5B PRIMARY KEY(CUSTOMER_ATTRIBUTE_ID) INDEX SALESMANAGER.PRIMARY_KEY_5B, !
hCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_5B ON SALESMANAGER.CUSTOMER_ATTRIBUTE(CUSTOMER_ATTRIBUTE_ID)+  
?CREATE CACHED TABLE SALESMANAGER.CUSTOMER_ATTRIBUTE(
    CUSTOMER_ATTRIBUTE_ID BIGINT NOT NULL,
    CUSTOMER_ATTR_TXT_VAL VARCHAR(255),
    CUSTOMER_ID BIGINT NOT NULL,
    OPTION_ID BIGINT NOT NULL,
    OPTION_VALUE_ID BIGINT NOT NULL
)r?/?1AHtestHTextA !H?.?1'Q?+?1FQA111?(?2M2@X358 rue du LanguedocPBouchervilleDHCarlJSamsonKJ4B 8J9N5148048796DDDDDDDXcsamson777@yahoo.comHtest
<$2a$11$/A/h3o5Ao9i5s0oN9DAL5uSbtXqZtSyQPX.RSQ.f1CW2uewIy7tfO-!!!1@T358 Du LanguadocPBouchervilleSCSTI ConsultingLLeonardoLDiCaprioKJ4B-8J9DSCSTI Consulting缚袧?+T358 Du LanguadocPBouchervilleDMLeonardo1LDiCaprioKJ4B-8J9Utest@shopizer.comEMLshopizer
<$2a$11$6A3gAkjxYEi5SG8nJGG1c.cM573.5R/JxcZQgwcxeEBq2reKR3YZS-!-!?6? U!
?"?#}$?%&
?'
(?)c*?* %
?ALTER TABLE SALESMANAGER.CUSTOMER ADD CONSTRAINT SALESMANAGER.CONSTRAINT_52 PRIMARY KEY(CUSTOMER_ID) INDEX SALESMANAGER.PRIMARY_KEY_52) !
TCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_52 ON SALESMANAGER.CUSTOMER(CUSTOMER_ID)(  
?CREATE CACHED TABLE SALESMANAGER.CUSTOMER(
    CUSTOMER_ID BIGINT NOT NULL,
    CUSTOMER_ANONYMOUS BOOLEAN,
    BILLING_STREET_ADDRESS VARCHAR(256),
    BILLING_CITY VARCHAR(100),
    BILLING_COMPANY VARCHAR(100),
    BILLING_FIRST_NAME VARCHAR(64) NOT NULL,
    BILLING_LAST_NAME VARCHAR(64) NOT NULL,
    BILLING_POSTCODE VARCHAR(20),
    BILLING_STATE VARCHAR(100),
    BILLING_TELEPHONE VARCHAR(32),
    CUSTOMER_COMPANY VARCHAR(100),
    CUSTOMER_DOB TIMESTAMP,
    DELIVERY_STREET_ADDRESS VARCHAR(256),
    DELIVERY_CITY VARCHAR(100),
    DELIVERY_COMPANY VARCHAR(100),
    DELIVERY_FIRST_NAME VARCHAR(64),
    DELIVERY_LAST_NAME VARCHAR(64),
    DELIVERY_POSTCODE VARCHAR(20),
    DELIVERY_STATE VARCHAR(100),
    DELIVERY_TELEPHONE VARCHAR(32),
    CUSTOMER_EMAIL_ADDRESS VARCHAR(96) NOT NULL,
    CUSTOMER_GENDER VARCHAR(1),
    CUSTOMER_NICK VARCHAR(96),
    CUSTOMER_PASSWORD VARCHAR(60),
    BILLING_COUNTRY_ID INTEGER NOT NULL,
    BILLING_ZONE_ID BIGINT,
    LANGUAGE_ID INTEGER NOT NULL,
    DELIVERY_COUNTRY_ID INTEGER,
    DELIVERY_ZONE_ID BIGINT,
    MERCHANT_ID INTEGER NOT NULL
)' %
?ALTER TABLE SALESMANAGER.CUSTMER_OPTIN ADD CONSTRAINT SALESMANAGER.CONSTRAINT_99 PRIMARY KEY(CUSTOMER_OPTIN_ID) INDEX SALESMANAGER.PRIMARY_KEY_99& !
_CREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_99 ON SALESMANAGER.CUSTMER_OPTIN(CUSTOMER_OPTIN_ID)%  
?CREATE CACHED TABLE SALESMANAGER.CUSTMER_OPTIN(
    CUSTOMER_OPTIN_ID BIGINT NOT NULL,
    EMAIL VARCHAR(255),
    FIRST VARCHAR(255),
    LAST VARCHAR(255),
    OPTIN_DATE TIMESTAMP,
    VALUE CLOB,
    OPTIN_ID BIGINT
)$ %
?ALTER TABLE SALESMANAGER.CURRENCY ADD CONSTRAINT SALESMANAGER.CONSTRAINT_50 PRIMARY KEY(CURRENCY_ID) INDEX SALESMANAGER.PRIMARY_KEY_50# !
TCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_50 ON SALESMANAGER.CURRENCY(CURRENCY_ID)"  
?CREATE CACHED TABLE SALESMANAGER.CURRENCY(
    CURRENCY_ID BIGINT NOT NULL,
    CURRENCY_CODE VARCHAR(255),
    CURRENCY_CURRENCY_CODE VARCHAR(255) NOT NULL,
    CURRENCY_NAME VARCHAR(255),
    CURRENCY_SUPPORTED BOOLEAN
)! %
?ALTER TABLE SALESMANAGER.COUNTRY_DESCRIPTION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_B PRIMARY KEY(DESCRIPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_B  !
aCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_B ON SALESMANAGER.COUNTRY_DESCRIPTION(DESCRIPTION_ID)  
?CREATE CACHED TABLE SALESMANAGER.COUNTRY_DESCRIPTION(
    DESCRIPTION_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    DESCRIPTION CLOB,
    NAME VARCHAR(120) NOT NULL,
    TITLE VARCHAR(100),
    LANGUAGE_ID INTEGER NOT NULL,
    COUNTRY_ID INTEGER NOT NULL
)4g%g"?????????	?
qbS
D5&?????????rcTE6 '!"	#
?$
?%
?&
?'
?(
?)
?*
?+
?,
s-
d.
U/
F0
71
(2
3
4?5?6?7?8?9?:?;?<?=t>e?V@GA8B)CDE麱鞧轍螴繨盞揗凬uOfPWQHR9S*TUV
齏
頧
遈
衂
羀
瞈

擽
卂
v`
ga
Xb
Ic
:d
+e
f

g	㭎	飅	鄇	裬	耹	砿		昽	唒	wq	hr	Ys	Jt	;u	,v	w	x?y饅醷襹脈磣?杸唩v?f?V?F?6?&???鰥鎷謱茘稁枑啈v?f?V?F?6?&???鰵鏇譁茲稙??GBRLGBRLGBRLA?GCLFGCLFGCLFA?GWSTGWSTGWSTA?GNZDGNZDGNZDA?GPENGPENGPENA?GNIOGNIOGNIOA?GNADGNADGNADA?GMOPGMOPGMOPA?GEGPGEGPGEGPA?GBAMGBAMGBAMA?GBZDGBZDGBZDA?GXDRGXDRGXDRA?GMGAGMGAGMGAA?GMWKGMWKGMWKA?GBIFGBIFGBIFA?GBYRGBYRGBYRA?GHUFGHUFGHUFA?GSBDGSBDGSBDA?GGBPGGBPGGBPA?GPLNGPLNGPLNA?GAOAGAOAGAOAA?GMNTGMNTGMNTA?GJPYGJPYGJPYA?GNPRGNPRGNPRA?GKRWGKRWGKRWA?GAWGGAWGGAWGA?GINRGINRGINRA?GAFNGAFNGAFNA?GMVRGMVRGMVRA?GYERGYERGYERA?GTTDGTTDGTTDAGSARGSARGSARA~GLTLGLTLGLTLA}GSZLGSZLGSZLA|GSRDGSRDGSRDA{GKZTGKZTGKZTAzGBHDGBHDGBHDAyGHTGGHTGGHTGAxGANGGANGGANGAwGXCDGXCDGXCDAvGPKRGPKRGPKRAuGCZKGCZKGCZKAtGCRCGCRCGCRCAsGNGNGNGNGNGNArGLKRGLKRGLKRAqGRONGRONGRONApGGIPGGIPGGIPAoGSYPGSYPGSYPAnGMURGMURGMURAmGNOKGNOKGNOKAlGMMKGMMKGMMKAkGBGNGBGNGBGNAjGBOVGBOVGBOVAiGCADGCADGCADAhGDKKGDKKGDKKAgGLSLGLSLGLSLAfGEURGEURGEURAeGAEDGAEDGAEDAdGRWFGRWFGRWFAcGHKDGHKDGHKDAbGJODGJODGJODAaGTJSGTJSGTJSA`GLBPGLBPGLBPA_GTRYGTRYGTRYA^GSHPGSHPGSHPA]GBWPGBWPGBWPA\GAMDGAMDGAMDA[GKYDGKYDGKYDAZGIDRGIDRGIDRAYGMDLGMDLGMDLAXGKHRGKHRGKHRAWGBOBGBOBGBOBAVGKPWGKPWGKPWAUGGYDGGYDGGYDATGGHSGGHSGGHSASGILSGILSGILSARGAUDGAUDGAUDAQGVNDGVNDGVNDAPGTZSGTZSGTZSAOGDJFGDJFGDJFANGALLGALLGALLAMGCHFGCHFGCHFALGHRKGHRKGHRKAKGLRDGLRDGLRDAJGXAFGXAFGXAFAIGZMKGZMKGZMKAHGBNDGBNDGBNDAGGLAKGLAKGLAKAFGVEFGVEFGVEFAEGVUVGVUVGVUVADGSOSGSOSGSOSACGKGSGKGSGKGSABGETBGETBGETBAAGSGDGSGDGSGDA@GPABGPABGPABA?GDZDGDZDGDZDA>GMKDGMKDGMKDA=GUSDGUSDGUSDA<GCOPGCOPGCOPA;GJMDGJMDGJMDA:GISKGISKGISKA9GPYGGPYGGPYGA8GRUBGRUBGRUBA7GPHPGPHPGPHPA6GKWDGKWDGKWDA5GBMDGBMDGBMDA4GLYDGLYDGLYDA3GBDTGBDTGBDTA2GUZSGUZSGUZSA1GTHBGTHBGTHBA0GXPFGXPFGXPFA/GCNYGCNYGCNYA.GMROGMROGMROA-GIRRGIRRGIRRA,GQARGQARGQARA+GARSGARSGARSA*GSVCGSVCGSVCA)GMZNGMZNGMZNA(GERNGERNGERNA'GGNFGGNFGGNFA&GUAHGUAHGUAHA%GBTNGBTNGBTNA$GSEKGSEKGSEKA#GKESGKESGKESA"GPGKGPGKGPGKA!GOMRGOMRGOMRA GAZNGAZNGAZNAGCVEGCVEGCVEAGMADGMADGMADAGUYUGUYUGUYUAGGELGGELGGELAGXOFGXOFGXOFAGFKPGFKPGFKPAGMYRGMYRGMYRAGKMFGKMFGKMFAGDOPGDOPGDOPAGRSDGRSDGRSDAGTWDGTWDGTWDAGGMDGGMDGGMDAGCUPGCUPGCUPAGIQDGIQDGIQDAGSDGGSDGGSDGAGSLLGSLLGSLLAGBSDGBSDGBSDAGTNDGTNDGTNDA
GMXVGMXVGMXVAGZARGZARGZARAGUGXGUGXGUGXA
GHNLGHNLGHNLA	GCLPGCLPGCLPAGGTQGGTQGGTQA7GBBDGBBDGBBDA6GCDFGCDFGCDFA5GSCRGSCRGSCRA4GLVLGLVLGLVLA3GSTDGSTDGSTDA2GMXNGMXNGMXNA1GFJDGFJDGFJDA%
?34L5?z?_????????	?
???
????????|ung`YRKD=6 /!("!#$%&'?(?)?*?+?,?-?.?/?0?1?2?3?4?5?6?7?8?9?:y;r<k=d>]?V@OAHBAC:D3E,F%GHIJ	KL
鸐
鬘
鞳
鍼
逹
豏
裇
蔜
肬
糣
礧
甔

燴
橻
抃
媇
刕
}_
v_FYEA^FVNA]FVEA\FUYA[FUSAZFGBAYFAEAXFUAAWFTRAVFTNAUFTHATFTWASFSYARFCHAQFSEAPFSDAOFESANFZAAMFSIALFSKAKFSGAJFRSAIFSAAHFRUAGFROAFFQAAEFPRADFPTACFPLABFPHAAFPEA@FPYA?FPAA>FOMA=FNOA<FNIA;FNZA:FNLA9FMAA8FMEA7FMXA6FMTA5FMYA4FMKA3FLUA2FLTA1FLYA0FLBA/FLVA.FKWA-FKRA,FJOA+FJPA*FITA)FILA(FIEA'FIQA&FIDA%FINA$FISA#FHUA"FHKA!FHNA FGTAFGRAFDEAFFRAFFIAFEEAFSVAFEGAFECAFDOAFDKAFCZAFCYAFCUAFHRAFCRAFCOA/FCNA.FCLA-FCAA,FBGA+FBRA*FBAA)FBOA(FBEA'FBYA&FBHA%FATA$FAUA#FARA"FDZA!FALA?6?b?`
?
R?>	?
?
?
/
	?	e?A  
?CREATE CACHED TABLE SALESMANAGER.CATEGORY(
    CATEGORY_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    CATEGORY_IMAGE VARCHAR(100),
    CATEGORY_STATUS BOOLEAN,
    CODE VARCHAR(100) NOT NULL,
    DEPTH INTEGER,
    LINEAGE VARCHAR(255),
    SORT_ORDER INTEGER,
    VISIBLE BOOLEAN,
    MERCHANT_ID INTEGER NOT NULL,
    PARENT_ID BIGINT
)/  
?CREATE CACHED TABLE SALESMANAGER.MERCHANT_LANGUAGE(
    STORES_MERCHANT_ID INTEGER NOT NULL,
    LANGUAGES_LANGUAGE_ID INTEGER NOT NULL
). *
;CREATE SCHEMA IF NOT EXISTS SALESMANAGER AUTHORIZATION TEST- "
?CREATE USER IF NOT EXISTS TEST SALT '0a589b1d838f17ab' HASH 'a24d67fead5cb2b497f6ac9a1dfa5f6a25c53f4415458f752755051a14febb20' ADMIN, %
?ALTER TABLE INFORMATION_SCHEMA.LOB_DATA ADD CONSTRAINT IF NOT EXISTS INFORMATION_SCHEMA.CONSTRAINT_9 PRIMARY KEY(BLOCK) INDEX INFORMATION_SCHEMA.PRIMARY_KEY_9+ !
gCREATE PRIMARY KEY IF NOT EXISTS INFORMATION_SCHEMA.PRIMARY_KEY_9 ON INFORMATION_SCHEMA.LOB_DATA(BLOCK)*  
?CREATE CACHED TABLE IF NOT EXISTS INFORMATION_SCHEMA.LOB_DATA(
    BLOCK BIGINT NOT NULL,
    COMPRESSED INT,
    DATA BINARY
)
HIDDEN) !
nCREATE INDEX IF NOT EXISTS INFORMATION_SCHEMA.INDEX_LOB_MAP_DATA_LOB ON INFORMATION_SCHEMA.LOB_MAP(BLOCK, LOB)( %
?ALTER TABLE INFORMATION_SCHEMA.LOB_MAP ADD CONSTRAINT IF NOT EXISTS INFORMATION_SCHEMA.CONSTRAINT_3 PRIMARY KEY(LOB, SEQ) INDEX INFORMATION_SCHEMA.PRIMARY_KEY_3' !
iCREATE PRIMARY KEY IF NOT EXISTS INFORMATION_SCHEMA.PRIMARY_KEY_3 ON INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ)&  
?CREATE CACHED TABLE IF NOT EXISTS INFORMATION_SCHEMA.LOB_MAP(
    LOB BIGINT NOT NULL,
    SEQ INT NOT NULL,
    POS BIGINT,
    HASH INT,
    BLOCK BIGINT
)
HIDDEN% !
_CREATE INDEX IF NOT EXISTS INFORMATION_SCHEMA.INDEX_LOB_TABLE ON INFORMATION_SCHEMA.LOBS(TABLE)$ %
?ALTER TABLE INFORMATION_SCHEMA.LOBS ADD CONSTRAINT IF NOT EXISTS INFORMATION_SCHEMA.CONSTRAINT_2 PRIMARY KEY(ID) INDEX INFORMATION_SCHEMA.PRIMARY_KEY_2# !
`CREATE PRIMARY KEY IF NOT EXISTS INFORMATION_SCHEMA.PRIMARY_KEY_2 ON INFORMATION_SCHEMA.LOBS(ID)"  
?CREATE CACHED TABLE IF NOT EXISTS INFORMATION_SCHEMA.LOBS(
    ID BIGINT NOT NULL,
    BYTE_COUNT BIGINT,
    TABLE INT
)
HIDDEN! &XSET CREATE_BUILD 191n6?
8?6
?
?
G?G?<? %
?ALTER TABLE SALESMANAGER.COUNTRY ADD CONSTRAINT SALESMANAGER.CONSTRAINT_63 PRIMARY KEY(COUNTRY_ID) INDEX SALESMANAGER.PRIMARY_KEY_63 !
RCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_63 ON SALESMANAGER.COUNTRY(COUNTRY_ID)  
?CREATE CACHED TABLE SALESMANAGER.COUNTRY(
    COUNTRY_ID INTEGER NOT NULL,
    COUNTRY_ISOCODE VARCHAR(255) NOT NULL,
    COUNTRY_SUPPORTED BOOLEAN,
    GEOZONE_ID BIGINT
) %
?ALTER TABLE SALESMANAGER.CONTENT_DESCRIPTION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_5 PRIMARY KEY(DESCRIPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_5 !
aCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_5 ON SALESMANAGER.CONTENT_DESCRIPTION(DESCRIPTION_ID)  
?CREATE CACHED TABLE SALESMANAGER.CONTENT_DESCRIPTION(
    DESCRIPTION_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    DESCRIPTION CLOB,
    NAME VARCHAR(120) NOT NULL,
    TITLE VARCHAR(100),
    META_DESCRIPTION VARCHAR(255),
    META_KEYWORDS VARCHAR(255),
    META_TITLE VARCHAR(255),
    SEF_URL VARCHAR(120),
    LANGUAGE_ID INTEGER NOT NULL,
    CONTENT_ID BIGINT NOT NULL
) %
?ALTER TABLE SALESMANAGER.CONTENT ADD CONSTRAINT SALESMANAGER.CONSTRAINT_6 PRIMARY KEY(CONTENT_ID) INDEX SALESMANAGER.PRIMARY_KEY_6 !
QCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_6 ON SALESMANAGER.CONTENT(CONTENT_ID)  
?CREATE CACHED TABLE SALESMANAGER.CONTENT(
    CONTENT_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    CODE VARCHAR(100) NOT NULL,
    CONTENT_POSITION VARCHAR(10),
    CONTENT_TYPE VARCHAR(10),
    SORT_ORDER INTEGER,
    VISIBLE BOOLEAN,
    MERCHANT_ID INTEGER NOT NULL
) %
?ALTER TABLE SALESMANAGER.CATEGORY_DESCRIPTION ADD CONSTRAINT SALESMANAGER.CONSTRAINT_9 PRIMARY KEY(DESCRIPTION_ID) INDEX SALESMANAGER.PRIMARY_KEY_9 !
bCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_9 ON SALESMANAGER.CATEGORY_DESCRIPTION(DESCRIPTION_ID)  
?CREATE CACHED TABLE SALESMANAGER.CATEGORY_DESCRIPTION(
    DESCRIPTION_ID BIGINT NOT NULL,
    DATE_CREATED TIMESTAMP,
    DATE_MODIFIED TIMESTAMP,
    UPDT_ID VARCHAR(20),
    DESCRIPTION CLOB,
    NAME VARCHAR(120) NOT NULL,
    TITLE VARCHAR(100),
    CATEGORY_HIGHLIGHT VARCHAR(255),
    META_DESCRIPTION VARCHAR(255),
    META_KEYWORDS VARCHAR(255),
    META_TITLE VARCHAR(120),
    SEF_URL VARCHAR(120),
    LANGUAGE_ID INTEGER NOT NULL,
    CATEGORY_ID BIGINT NOT NULL
) %
?ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.CONSTRAINT_3 PRIMARY KEY(CATEGORY_ID) INDEX SALESMANAGER.PRIMARY_KEY_3 !
SCREATE PRIMARY KEY SALESMANAGER.PRIMARY_KEY_3 ON SALESMANAGER.CATEGORY(CATEGORY_ID):g
=g
N??瀑?U?+?呸澾v?J??
磴
夸
冨
7?啊蜐?+啊蜐?+_Programmation pour le cloudWprogrammation-cloud"7?啊蜐?+啊蜐?+SCloud computingScloud-computing!7?啊蜐?+啊蜐?+LAffairesLaffaires"6?啊蜐?+啊蜐?+LBusinessLbusiness!6?啊蜐?+啊蜐?+NSc FictionKfiction"5?啊蜐?+啊蜐?+KFictionKfiction!5?啊蜐?+啊蜐?+GWebJle-web"4?啊蜐?+啊蜐?+GWebKthe-web!4?啊蜐?+啊蜐?+OTechnologieOtechnologie"3?啊蜐?+啊蜐?+NTechnologyNtechnology!3?啊蜐?+啊蜐?+JRomansJromans"2?啊蜐?+啊蜐?+JNovelsJnovels!2?啊蜐?+啊蜐?+YLivres d'informatiqueXlivres-informatiques"1?啊蜐?+啊蜐?+RComputer BooksRcomputer-books!1?
???rM)7啊蜐?+啊蜐?+@Icloud"I/1/3/ A!36啊蜐?+啊蜐?+@Lbusiness E/ A!5啊蜐?+啊蜐?+@Kfiction!G/2/ A!24啊蜐?+啊蜐?+@Gweb!G/1/ A!13啊蜐?+啊蜐?+@Htech!G/1/ @!12啊蜐?+啊蜐?+@Jnovels E/ @!1啊蜐?+啊蜐?+@Qcomputerbooks E/ A!|??!!雠
?
??c
=	
??	_
? ?df02614ab6600db0eb4d78e2c4df5574f9ba1903c78f9da01dded48dcbe5fa1395559a2eb8160dd8615b22e900932a7bac035d6eaa57b1ec05f4cedf94c2d8054819918ba0b244669d6987678949825eee5e06278ad1acdb473840b69721531c51e62999ba70c79fdd7257895873ce0e52ea4c1214dd110aa7042a686a1f18c63c525150f8494786c023d99d59433ac216884a6d0608fafbb9688d8c13965c80c666b18ac40d02259bea5c1e87051de9
 ?{"boxLength":0,"orderTotalFreeShipping":null,"shipBaseType":"SHIPPING","shipOptionPriceType":"HIGHEST","maxWeight":0.0,"boxHeight":0,"taxOnShipping":false,"shipPackageType":"ITEM","freeShippingEnabled":false,"boxWeight":0.0,"shipType":"INTERNATIONAL","boxWidth":0,"handlingFees":12.00,"shipDescription":"SHORT_DESCRIPTION"}	 ?{"boxLength":0,"orderTotalFreeShipping":null,"shipBaseType":"SHIPPING","shipOptionPriceType":"ALL","maxWeight":0.0,"boxHeight":0,"taxOnShipping":false,"shipPackageType":"ITEM","freeShippingEnabled":false,"boxWeight":0.0,"shipType":"INTERNATIONAL","boxWidth":0,"handlingFees":null,"shipDescription":"SHORT_DESCRIPTION"} ?{"boxLength":0,"orderTotalFreeShipping":null,"shipBaseType":"SHIPPING","shipOptionPriceType":"ALL","maxWeight":0.0,"boxHeight":0,"taxOnShipping":false,"shipPackageType":"ITEM","freeShippingEnabled":false,"boxWeight":0.0,"shipType":"NATIONAL","boxWidth":0,"handlingFees":null,"shipDescription":"SHORT_DESCRIPTION"}7 ?{"allowPurchaseItems":true,"displayContactUs":true,"displayCustomerAgreement":true,"defaultSearchConfigPath":{},"displayCustomerSection":true,"displayAddToCartOnFeaturedItems":true,"testMode":false,"displayStoreAddress":true,"displaySearchBox":true,"debugMode":true,"useDefaultSearchConfig":{}}6 ?{"allowPurchaseItems":true,"displayContactUs":false,"displayCustomerAgreement":false,"defaultSearchConfigPath":{},"displayCustomerSection":false,"displayAddToCartOnFeaturedItems":true,"testMode":false,"displayStoreAddress":false,"displaySearchBox":true,"debugMode":false,"useDefaultSearchConfig":{}}5 ?[{"scheme":"https","host":"www.beanstream.com","port":"443","uri":"/scripts/process_transaction.asp","env":"TEST","config1":null,"config2":null},{"scheme":"https","host":"www.beanstream.com","port":"443","uri":"/scripts/process_transaction.asp","env":"PROD","config1":null,"config2":null}]4 ?[{"scheme":"","host":"","port":"","uri":"","env":"TEST","config1":"https://www.sandbox.paypal.com/cgi-bin/webscr?cmd=_express-checkout&token=","config2":null},{"scheme":"","host":"","port":"","uri":"","env":"PROD","config1":"https://www.paypal.com/cgi-bin/webscr?cmd=_express-checkout&token=","config2":null}]3 ?{"01":"UPS Next Day Air","02":"UPS Second Day Air","03":"UPS Ground","07":"UPS Worldwide Express","08":"UPS Worldwide Expedited","11":"UPS Standard","12":"UPS Three-Day Select","13":"UPS Next Day Air Saver","14":"UPS Next Day Air Early A.M.","54":"UPS Worldwide Express Plus","59":"UPS Second Day Air A.M.","69":"UPS Saver"}2 ?[{"scheme":"https","host":"ct.soa-gw.canadapost.ca","port":"443","uri":"/rs/ship/price","env":"TEST","config1":null,"config2":null},{"scheme":"https","host":"soa-gw.canadapost.ca","port":"443","uri":"/rs/ship/price","env":"PROD","config1":null,"config2":null}]1 ?[{"scheme":"http","host":"testing.shippingapis.com","port":"80","uri":"/ShippingAPI.dll","env":"TEST","config1":null,"config2":null},{"scheme":"http","host":"production.shippingapis.com","port":"80","uri":"/ShippingAPI.dll","env":"PROD","config1":null,"config2":null}]F	?????????????????????????{uoic]WQKE?93-'!	??????????????????}vo?????????????????????????{wsokgc_[WSOKGC?;73/+'#
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
{
u
o
i
c
]
W
Q
K
E
?
9
3
-
'
!



	
?????????????????????ysmga[UOIC=71+%
?????????????????????}wqke_YSMGA;5/)#
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
z
s
l
e
^
W
P
I
B
;
4
-
&





	?	?	?	?	?	?	?	?	????
??	????7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7??7?,7*6
5
4362412T??????????????????????????{uoic]WQKE?93-'!	???????????????????????????????????????????????????{wsokgc_[WSOKGC?:5/)#
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
{
u
o
i
c
]
W
Q
K
E
?
9
3
-
'
!



	
?????????????????????ysmga[UOIC=71+%
?????????????????????}wqke_YSMGA;5/)#
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
{
u
o
i
c
]
W
Q
K
E
?
9
3
-
'
!



	
	?	?	?	??? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ,*  

  6 4 2 1
?:8?m??????????????????????????????????|xtplhd`\XTPLHD@<840-*&"?741.+(%"

?????????????????????????????????????{wsokgc_[WSOKGC?;73/+'#
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?

{
w
s
o
k
g
c
_
[
W
S
O
K
G
C
?
;
7
3
/
+
'
#







????????????????????????????????{wsokgc_[WSOKGC?;73/+'#???????????????
YYYYY?P?P?P?P*PP?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B?B[??????
??*茵述曼簼矠獰殹挗姡偆z?r?j?b?Z?R?J?B?:?2?*?"???
??蚨攴飧诠液驶录航簿⒗毩捖娒偰z?r?j?b?Z?R?J?B?:?2?*?"???
??
c

沞
攆
峠
唄
i
xj
qk
jl
cm
\n
Uo
Np
Gq
@r
9s
2t
+u
$v
w
x
y
z
{鷟髛靱?迉謥蝹苾緞秴畣瀳枆帄唻~?v?n?f?^?V?N?F?>?6?.?&?????䴗鰸顬鏌逘帧微疲兢顶Η灗柀帾啱~?v?n?f?^?V?N?F?>?6?.?&?????

鼋
罹
婵
蘩
至
温
泼
灸
杜

η
炄
柹
幨
喫
~?
v?
n?
f?
^?
V?
N?
F?
>?
6?
.?
&?
?
?
?
?		鲚	钷	孢	捺	轴	吴	沏	句	跺		︾	炶	栭	庩	嗠	~?	v?	n?	f?	^?	V?	N?	F?	>?	6?	.?	&?	?	?	?	?鳊铪??迉謥蝹苾緞秴畣瀳枆帄唻~?v?n?f?^?V?N?F?>?6?.?&?????䴗鰸顬鏌逘帧微疲兢顶Η灗柀帾啱~?v?n?f?^?V?N?F?>?6?.?&??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??B??P??P??P??P*?P?P
?Y?Y6?Y4?Y2?Y4
-8)*$*8FRZdp|鼒鰯馉氍浜奕僭逾蓑羳箰盀М溂暿徹囨傯}?u?m?e?^?Y?S?K?D?<?,?+?*?)?(?'?7?@?7=6?;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????	

 !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????	

 !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????	

 !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????	

 !"#$%&'()*+,-./012345N?3????
??,?* 0粫颅7 0B怨傴6
 0B姉播5 0B儬享46 0埁?734 0B鶏會22 0毯1ky38?髝鎲讧通俩氮┇潿懎叜y?m?a?U?I?=?1?%??
??鹾榛菁呀啪箍×暵壝}?q?e?Y?M?A?5?)????

硇
嵫
找
捎
皆
闭
ブ
欁
嵷
佡
u?
i?
]?
T?
H?
<? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0粫颅7? 0B灲? 0銮?7
? 0B炕謹	? 0显铂E7=E7=默7=?
?	?6?厧鰪|?
飸
b?鐡0??
?	輼	C?#?枩??????????????鄈? %
?ALTER TABLE SALESMANAGER.MERCHANT_CONFIGURATION ADD  STRAINT?2UK_J0C3H8ONW3M6HJCR3YYLST9FB UNIQUE(?VID,@H Z_KEY)園?忇?ANUFACTURER_DESCRIP??LPV09P83SC887CLXE04NROUP6?戉X@?LANGU! )咢?x?%?<?6BRQFDKGA7JC78N8DH3V595Y3?壛r@?CODE)凘~呩GEOZONE?#SOQ8O99W3C8YS3NTAMT5I4MAT绬繱@呩侤?z?FILE_HISTORY?AV35SB3V4NXQ8V1N1RKXUFIR纼?
`XA??@?椺
CU | :_OPT_VAL?#GE7F2T1D31R87WNK09H9U1TNV罀?\?? %
掄?#K@?UE?)CB1FMV71NRX7M1RLX1FF5QVD?? 飪ˊ忇F鸃?氞!?SET??4PELI2RITNNQ2XQPYQ188SRM?W?夽磬濦!?U佢鵃?庎!??6OVL4T1CIAG1WUBTCEBAOO7VI?褸嶡⑩?鯜曞$?汔?ROV34A6G4DHH%
	KVHP1GGM0U缾?藖?鬇?冡%ATTRIBUT?^46KBPRE88YH963GEWM3KMDNI1罀#J??鞢?駺?? 蜟?I?
QG32YY79QAJ&2UWR9WJ"N9绤EMAIL, @孉?) INDEX?~?G_`/_9? !
tCREA!啌?/K !痃2A?蜞?闍1??COUNTRYb阪?T7NSHKI1RBP6157ED0V6CX4Y4犣(繱??驵?NTE'鼵g??N0W5R7CTBP88R4RVK7AYKLOFM?寑S??銨?s?X?7?]
T1V2LD0MRWV#\
QOURQL4UUB0?!涘)g_釦y団?"&G&厢#BUESQQ6CYX7E5HY3MF30CFIEQ绹?T?郂?t?爫?	3MQ9I6QMGQUVOIESLX39PEJ6X纴?	E)??4
?-8) * $* @F 	R Z d p | ?鼒 鰯@馉@氍@浜@奕@僭@逾@蓑@羳 5箰@盀@М@溂@暿@徹@囨@傯@}? 5u怈m濦e珸^篅Y菮S諤K銨D駺<? 5,嶡+欯*)睝(継'? 7? )????????????????????????????鄉??
?	_?6?垹?u?
瑁
b?丧8?ぇ	?
b?	瑟	.?‖?煯绡X????????????郙? %
ALTER TABLE SALESMANAGER.ZONE_DESCRIPTION ADD CONSTRAINT?,UK_M64LAXGRV9FXM6IO232AP4SU9 UNIQUE(`PID, LANGU c )禓????TAX_RAT?$?T3XG8PL88YACDXG49NB46EFFG缞?T??碄?班庒
8GH6L9N0XQ03B91SGLP62OELU??
CODE, MERCHANT ?) INDEX?[?M_`/_1? !
uCRE!*燽?/K !脞	?-a6?	?睞3?H@>CLASS?3A4Q5Q57A8OEH2OJEO8DHR935K犘(?),"矤V`?)癅?呩?SYSTEM_NOTIFICA??NPDNLC390VGR2MHEPIB1MTRMR??#	FIG_KEY)ˊ?撪?
PRODUCT_REVIEW?#fQNO5WJDTCJ8PM3YKKKH7T4RXJ罁?ZA*?p?戉?PRIC?$u
FRSW8D41SXXOGV YD8NWAX?蚶檧Y???熰?Od?_VALU?$?ASGC60OT1WY0UHO96N0J8429P?9?`??︶卩E??IXBPI4HXRHLJH"?C3XFVNVSH罋?G?a?烜?屷 AE茑?MKCM8ISYYYQBJD1YYB8MRPKUW罊?屷.淍?夃撪?HFCW5OI9ULLJLOG1B7NS1R9T?c?(D?)欯愨?IMF#?N7YHDJ6CCYDGF201GIBB882CD?*?Y?)楡樺F羑DIGITAL?)JUK1QGKH9V5W7GHVB18KRWO8V??%KFILE_NAM!朄呭F?嗚!Q4DNKX5B776AYQAS2H4RR2D8Q?婁?擛?掆<ATTRIBU&?O0C6CFXCFEJWFA2877GFGPUCO缞A?
刧@历I&?扏?r?禒*??S8OFSN9PEHDRSTJG52J5QABX?
?SKU)嶡xq?x@淬E)?LX6SIQ6DDF14CUD40K8GW6??E#6E)?|? %
tALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X UNIQUE(MERCHANT_ID, CODE)???? %
?ALTER TABLE SALESMANAGER.CATEGORY_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_BUESQQ6CYX7E5HY3MF30CFIEQ UNIQUE(CATEGORY_ID, LANGUAGE_ID)??{? %
sALTER TABLE SALESMANAGER.CONTENT ADD CONSTRAINT SALESMANAGER.UK_T1V2LD0MRWVIQUQOURQL4UUB0 UNIQUE(MERCHANT_ID, CODE)???? %
?ALTER TABLE SALESMANAGER.CONTENT_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_N0W5R7CTBP88R4RVK7AYKLOFM UNIQUE(CONTENT_ID, LANGUAGE_ID)???? %
?ALTER TABLE SALESMANAGER.COUNTRY_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_T7NSHKI1RBP6157ED0V6CX4Y4 UNIQUE(COUNTRY_ID, LANGUAGE_ID)??躼 ? ??????????????????????????????鄎C$??苦%郠?????????????????????????????嘹??
7? J?琊悟呆欥~?e?J?/??麁鄠艅獑張r?W?>?#?
?
頂
蜄
瘶
??
w?
[?
A?
%?
	?铯应??洩伂g?M?3????酶┖徏s?[?C?*??
銮
萑
派

捥
y?
`?
H?
/?
?		豳	芹		撨	z?	b?	I?	0?	???骐戊??濓咅l!3????????????帙?!;?QOFF,0,,,falseE7? 8?4? 5冟03隸?02? 2?9鑐勦H8? / ?06? .呧00鉦嗋1? +堗4郹!?b3轥夃02? (娻F29赻嬥8豟P7=屶7謄嵿6訿庎5襚愢4? %戉!0? "??8蚡掄07? 撪3? #?IF12萡斷1F11? $?2!?? %?F13腵栢J2? 椸
羆&?L1?!/樴1"*紷權1? H?氞G8,7? ?涏 5? ?炧3? ?熰`O? ??P胹
trueH4,10? ?∴73,1? ?⑧8,5? ?｀"?? ?む	珋ム5﹢︵	? ?ㄠ ?7? ?┼? ??!?!_爛G5!
? ?9,8? ? ㄢ Q泙`Q? ?编@Q? ?侧2 ?? ?赤I1!?3? ?脆	K10,11,9? ~掂I21,18? z多!?? \!奏郹?? V膏 ?? P亨G7,4? M秽I ?"?? J监`7? D洁B
? >距7"??Fs苦@5? 8"舌? ?黗锣G!b? 5绵2,3? 2泥A?? /培%?鮜凄G6,2? +青3 ? %茹?G1,6? "#膏?3韅枢E2] ? > 
 鐁 桁 濔 ??????????????????????????????郤?????????????!%?POFF,0,,,trueG1,6?|? !
tCREATE UNIQUE INDEX SALESMANAGER.UK_QG32YY79QAJFIG2UWR9WJ88S9_INDEX_9 ON SALESMANAGER.CUSTMER_OPTIN(EMAIL, OPTIN_ID)??? %
?ALTER TABLE SALESMANAGER.CUSTMER_OPTIN ADD CONSTRAINT SALESMANAGER.UK_QG32YY79QAJFIG2UWR9WJ88S9 UNIQUE(EMAIL, OPTIN_ID) INDEX SALESMANAGER.UK_QG32YY79QAJFIG2UWR9WJ88S9_INDEX_9???? %
?ALTER TABLE SALESMANAGER.CUSTOMER_ATTRIBUTE ADD CONSTRAINT SALESMANAGER.UK_46KBPRE88YH963GEWM3KMDNI1 UNIQUE(OPTION_ID, CUSTOMER_ID)???? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION ADD CONSTRAINT SALESMANAGER.UK_ROV34A6G4DHHIQUKVHP1GGM0U UNIQUE(MERCHANT_ID, CUSTOMER_OPT_CODE)????? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION_DESC ADD CONSTRAINT SALESMANAGER.UK_6OVL4T1CIAG1WUBTCEBAOO7VI UNIQUE(CUSTOMER_OPTION_ID, LANGUAGE_ID)???? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION_SET ADD CONSTRAINT SALESMANAGER.UK_4PELI2RITNNQ2XQPYQ188SRM6 UNIQUE(CUSTOMER_OPTION_ID, CUSTOMER_OPTION_VALUE_ID)???? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION_VALUE ADD CONSTRAINT SALESMANAGER.UK_CB1FMV71NRX7M1RLX1FF5QVDT UNIQUE(MERCHANT_ID, CUSTOMER_OPT_VAL_CODE)???? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPT_VAL_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_GE7F2T1D31R87WNK09H9U1TNV UNIQUE(CUSTOMER_OPT_VAL_ID, LANGUAGE_ID)???? %
zALTER TABLE SALESMANAGER.FILE_HISTORY ADD CONSTRAINT SALESMANAGER.UK_AV35SB3V4NXQ8V1N1RKXUFIR UNIQUE(MERCHANT_ID, FILE_ID)???? %
?ALTER TABLE SALESMANAGER.GEOZONE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_SOQ8O99W3C8YS3NTAMT5I4MAT UNIQUE(GEOZONE_ID, LANGUAGE_ID)???? %
xALTER TABLE SALESMANAGER.MANUFACTURER ADD CONSTRAINT SALESMANAGER.UK_6BRQFDKGA7JC78N8DH3V595Y3 UNIQUE(MERCHANT_ID, CODE)???? %
?ALTER TABLE SALESMANAGER.MANUFACTURER_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_LPV09P83SC887CLXE04NROUP6 UNIQUE(MANUFACTURER_ID, LANGUAGE_ID)???? %
?ALTER TABLE SALESMANAGER.MERCHANT_CONFIGURATION ADD CONSTRAINT SALESMANAGER.UK_J0C3H8ONW3M6HJCR3YYLST9FB UNIQUE(MERCHANT_ID, CONFIG_KEY)??y? %
qALTER TABLE SALESMANAGER.OPTIN ADD CONSTRAINT SALESMANAGER.UK_MANLX6SIQ6DDF14CUD40K8GW6 UNIQUE(MERCHANT_ID, CODE)??z? %
rALTER TABLE SALESMANAGER.PRODUCT ADD CONSTRAINT SALESMANAGER.UK_S8OFSN9PEHDRSTJG52J5QABXH UNIQUE(MERCHANT_ID, SKU)???? %
?ALTER TABLE SALESMANAGER.PRODUCT_ATTRIBUTE ADD CONSTRAINT SALESMANAGER.UK_O0C6CFXCFEJWFA2877GFGPUCO UNIQUE(OPTION_ID, OPTION_VALUE_ID, PRODUCT_ID)???? %
?ALTER TABLE SALESMANAGER.PRODUCT_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_Q4DNKX5B776AYQAS2H4RR2D8Q UNIQUE(PRODUCT_ID, LANGUAGE_ID)???? %
ALTER TABLE SALESMANAGER.PRODUCT_DIGITAL ADD CONSTRAINT SALESMANAGER.UK_JUK1QGKH9V5W7GHVB18KRWO8V UNIQUE(PRODUCT_ID, FILE_NAME)???? %
?ALTER TABLE SALESMANAGER.PRODUCT_IMAGE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_N7YHDJ6CCYDGF201GIBB882CD UNIQUE(PRODUCT_IMAGE_ID, LANGUAGE_ID)???? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION ADD CONSTR3q7=AINT SALESMANAGER.UK_HFCW5OI9ULLJLOG1B7NS1R9TU UNIQUE(MERCHANT_ID, PRODUCT_OPTION_CODE)???? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION_DESC ADD CONSTRAINT SALESMANAGER.UK_MKCM8ISYYYQBJD1YYB8MRPKUW UNIQUE(PRODUCT_OPTION_ID, LANGUAGE_ID)???? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION_VALUE ADD CONSTRAINT SALESMANAGER.UK_IXBPI4HXRHLJH935C3XFVNVSH UNIQUE(MERCHANT_ID, PRODUCT_OPTION_VAL_CODE)???? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION_VALUE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_ASGC60OT1WY0UHO96N0J8429P UNIQUE(PRODUCT_OPTION_VALUE_ID, LANGUAGE_ID)???? %
?ALTER TABLE SALESMANAGER.PRODUCT_PRICE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_FRSW8D41SXXOGVXXOYD8NWAXU UNIQUE(PRODUCT_PRICE_ID, LANGUAGE_ID)???? %
?ALTER TABLE SALESMANAGER.PRODUCT_REVIEW_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_QNO5WJDTCJ8PM3YKKKH7T4RXJ UNIQUE(PRODUCT_REVIEW_ID, LANGUAGE_ID)???? %
?ALTER TABLE SALESMANAGER.SYSTEM_NOTIFICATION ADD CONSTRAINT SALESMANAGER.UK_NPDNLC390VGR2MHEPIB1MTRMR UNIQUE(MERCHANT_ID, CONFIG_KEY)???? %
ALTER TABLE SALESMANAGER.TAX_CLASS ADD CONSTRAINT SALESMANAGER.UK_A4Q5Q57A8OEH2OJEO8DHR935K UNIQUE(MERCHANT_ID, TAX_CLASS_CODE)??磝 ? ??????????????????????????????鄎?????????????!??POFF,0,,,trueH4,10?}? !
uCREATE UNIQUE INDEX SALESMANAGER.UK_8GH6L9N0XQ03B91SGLP62OELU_INDEX_1 ON SALESMANAGER.TAX_RATE(TAX_CODE, MERCHANT_ID)??? %
?ALTER TABLE SALESMANAGER.TAX_RATE ADD CONSTRAINT SALESMANAGER.UK_8GH6L9N0XQ03B91SGLP62OELU UNIQUE(TAX_CODE, MERCHANT_ID) INDEX SALESMANAGER.UK_8GH6L9N0XQ03B91SGLP62OELU_INDEX_1???? %
?ALTER TABLE SALESMANAGER.TAX_RATE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_T3XG8PL88YACDXG49NB46EFFG UNIQUE(TAX_RATE_ID, LANGUAGE_ID)???? %
ALTER TABLE SALESMANAGER.ZONE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_M64LAXGRV9FXM6IO232AP4SU9 UNIQUE(ZONE_ID, LANGUAGE_ID)?M1
  ?: 8? 	??????????????????????????????郼??ky38?髝鎲讧通俩氮┇潿懎叜y?m?a?U?I?=?1?%??
??鹾榛菁呀啪箍×暵壝}?q?e?Y?M?A?5?)????

硇
嵫
找
捎
皆
闭
ブ
欁
嵷
佡
u?
i?
]?
T?
H?
<????????????????????????`
? 0粫颅7朽相梧袜锑肃枢舌揉青凄培泥绵锣拎类苦距洁监秽亨灌膏粪多掂脆赤侧编班┼ㄠо︵ムむ｀⑧∴犩熰炧? 
B灲?"|銮?7
? 	B炕謹	? 显铂?
? 0粫颅7??T? ?????????????????????????{uoic]WQKE?93-'!	????????????????????? '?? )?? +?? -?? /?? 1?? 3?? 5?? 7?? 9??{wsokgc_[WSOKGC?:5/)#
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
{
u
o
i
c
]
W
Q
K
E
?
9
3
-
'
!



	
?????????????????????ysmga[UOIC=71+%
?????????????????????}wqke_YSMGA;5/)#
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
{
u
o
i
c
]
W
Q
K
E
?
9
3
-
'
!



	
	?	?	?	?"Y??????????????????????嗾?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ,*  

  6 4 2 ??F 	?????????????????????????{uoic]WQKE?93-'!	??????????????????}vo? !?? #?? %?? '?? )
?????? /????{ws ;kgc_[WSOKGC?;73/+'#
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
??7=
?
?
?
?
{
u
o
i
c
]
W
Q
K
E
?
9
3
-
'
!



	
?????????????????????ysmga[UOIC=71+%
?????????????????????}wqke_YSMGA;5/)#
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
z
s
l
e
^
W
P
I
B
;
4
-
&





	?	?	?	?	?	?	?	?	?"Y??????????????????????嘌???
??	????7?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?,7*6
5
4362412??[? ?????
??*茵述曼簼矠獰殹挗姡偆z?r?j?b?Z?R?J?B?:?2?*?"???
??蚨攴飧诠液驶录航簿⒗毩捖娒偰z?r?j?b?Z?R?J?B?:?2?*?"???
??
c

沞
攆
峠
唄
i
xj
qk
jl
cm
\n
Uo
Np
Gq
@r
9s
2t
+u
$v
w
x
y
z
{鷟髛靱?迉謥蝹苾緞秴畣瀳枆帄唻~?v?n?f?^?V?N?F?>?6?.?&?????䴗鰸顬鏌逘帧微疲兢顶Η灗柀帾啱~?v?n?f?^?V?N?F?>?6?.?&?????

鼋
罹
婵
蘩
至
温
泼
灸
杜

η
炄
柹
幨
喫
~?
v?
n?
f?
^?
V?
N?
F?
>?
6?
.?
&?
?
?
?
?		鲚	钷	孢	捺	轴	吴	沏	句	跺		︾	炶	栭	庩	嗠	~?	v?	n?	f?	^?	V?	N?	F?	>?	6?	.?	&?	?	?	?	?鳊铪??迉謥蝹苾緞秴畣瀳枆帄唻~?v?n?f?^?V?N?F?>?6?.?&?????䴗鰸顬鏌逘帧微疲兢顶Η灗柀帾啱~?v?n?f?^?V?N?F?>?6?.?&$;??????????????????鄜	??B袪蠣螤蜖虪藸薁蔂葼菭茽艩臓脿聽翣罓繝緺綘紶粻籂範笭窢稜禒礌碃矤睜盃癄疇瓲瑺珷獱牋煚灎	??P?!: ?! ? ? * i  ? 
 OY ?Y6!tY4? 2?Y?	??B??m? ?????????????????????????????????|xtplhd`\XTPLHD@<840-*&"?7 !1.+(% #

?????????????????????????????????????{wsokgc_[WSOKGC?;73/+'#
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?

{
w
s
o
k
g
c
_
[
W
S
O
K
G
C
?
;
7
3
/
+
'
#







????????????????????????????????{wsokgc_[WSOKGC?;73/+'#???????????????"Y????????????????????????郃
YYYYY?P?P? ? 
*PP?B? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??BGH? ??? 
??????????????????????????????鄅221?r傎 
??2? 
???????????????????????????????>2菥赈?+嗁寤?+5!21垡? 袛? 2!1?2?22菥赈?+烐榛?+5!2IG? ??? 
??????????????????????????????鄆2!!?H眤 ??? 
??????????????????????????????鄅22??F ??? 
???????????????????????????????'
 a4f5eb8373b74408964c16b03b8 7c2
 1fbfb6d103ab4264965f379fd2f3ff4e??F ??? 
???????????????????????????????'
 a4f5eb8373b74408964c16b03b8 7c2
 1fbfb6d103ab4264965f379fd2f3ff4e??vN 
??2? 
??????????????????????????????`2劢赈?+嗁寤?+@
 1fbfb6d103ab4264965f379fd2f3ff	4e!1壱? 6袛? 6
 a4f5eb8373b74408964c16b03b8 7c!?2?292_7=劢赈?+烐榛?+2
 1fbfb6d103ab4264965f379fd2f3ff4e!?
? 0粫颅7?	??B?
? 0粫颅7?	??B?2?22菥赈?+陕昊?+5!2?2?292劢赈?+陕昊?+2
 1fbfb6d103ab4264965f379fd2f3ff4e!?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?2?22菥赈?+昊?+5!2?2?292劢赈?+昊?+2
 1fbfb6d103ab4264965f379fd2f3ff4e!?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?2?22菥赈?+㈣昊?+5!2?2?292劢赈?+㈣昊?+2
 1fbfb6d103ab4264965f379fd2f3ff4e!?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?2?22菥赈?+鼤牖?+5!2?2?292劢赈?+龝牖?+2
 1fbfb6d103ab4264965f379fd2f3ff4e!?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?2?22菥赈?+桩牖?+5!2?2?292劢赈?+桩牖?+2
 1fbfb6d103ab4264965f379fd2f3ff4e!?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?2?22菥赈?+屼牖?+5!2?2?292劢赈?+屼牖?+2
 1fbfb6d103ab4264965f379fd2f3ff4e!?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?2?22菥赈?+冽牖?+5!2?2?292劢赈?+冽牖?+2
 1fbfb6d103ab4264965f379fd2f3ff4e!?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?2?22菥赈?+獦旎?+5!2?2?292劢赈?+獦旎?+2
 1fbfb6d103ab4264965f379fd2f3ff4e!?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?2?22菥赈?+ゴ旎?+5!2?2?292劢赈?+ゴ旎?+2
 1fbfb6d103ab4264965f379fd2f3ff4e!?
? 0粫颅7?	??B?
? 0粫颅7?	??B?2?22菥赈?+蛉旎?+5!2?2?292劢赈?+蛉旎?+2
 1fbfb6d103ab4264965f379fd2f3ff4e!?
? 0粫颅7?	??B?
? 0粫颅7?	??B?2?22菥赈?+屋旎?+5!2?2?292劢赈?+屋旎?+2
 1fbfb6d103ab4264965f379fd2f3ff4e!?
? 0粫颅7?	??B?
? 0粫颅7?	??B?2?22菥赈?+欌旎?+5!2?2?292劢赈?+欌旎?+2
 1fbfb6d103ab4264965f379fd2f3ff4e!?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?
? 0粫颅7?	??B?2?22菥赈?+饝锘?+5!2?2?292劢赈?+饝锘?+2
 1fbfb6d103ab4264965f379fd2f3ff4e!?
? 0粫颅7?	??B?
? 0粫颅7?	??B?2?22菥赈?+病锘?+5!2?2?292劢赈?+病锘?+2
 1fbfb6d103ab4264965f379fd2f3ff4e!?
? 0粫颅7?	??B?
? 0粫颅7?	??B?6?厧鰪|?
飸
b?鐡0??
?	輼	C?#?枩????? %
?ALTER TABLE SALESMANAGER.MERCHANT_CONFIGURATION ADD CONSTRAINT SALESMANAGER.UK_J0C3H8ONW3M6HJCR3YYLST9FB UNIQUE(MERCHANT_ID, CONFIG_KEY)? %
?ALTER TABLE SALESMANAGER.MANUFACTURER_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_LPV09P83SC887CLXE04NROUP6 UNIQUE(MANUFACTURER_ID, LANGUAGE_ID)? %
xALTER TABLE SALESMANAGER.MANUFACTURER ADD CONSTRAINT SALESMANAGER.UK_6BRQFDKGA7JC78N8DH3V595Y3 UNIQUE(MERCHANT_ID, CODE)? %
?ALTER TABLE SALESMANAGER.GEOZONE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_SOQ8O99W3C8YS3NTAMT5I4MAT UNIQUE(GEOZONE_ID, LANGUAGE_ID)? %
zALTER TABLE SALESMANAGER.FILE_HISTORY ADD CONSTRAINT SALESMANAGER.UK_AV35SB3V4NXQ8V1N1RKXUFIR UNIQUE(MERCHANT_ID, FILE_ID)? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPT_VAL_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_GE7F2T1D31R87WNK09H9U1TNV UNIQUE(CUSTOMER_OPT_VAL_ID, LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION_VALUE ADD CONSTRAINT SALESMANAGER.UK_CB1FMV71NRX7M1RLX1FF5QVDT UNIQUE(MERCHANT_ID, CUSTOMER_OPT_VAL_CODE)? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION_SET ADD CONSTRAINT SALESMANAGER.UK_4PELI2RITNNQ2XQPYQ188SRM6 UNIQUE(CUSTOMER_OPTION_ID, CUSTOMER_OPTION_VALUE_ID)? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION_DESC ADD CONSTRAINT SALESMANAGER.UK_6OVL4T1CIAG1WUBTCEBAOO7VI UNIQUE(CUSTOMER_OPTION_ID, LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.CUSTOMER_OPTION ADD CONSTRAINT SALESMANAGER.UK_ROV34A6G4DHHIQUKVHP1GGM0U UNIQUE(MERCHANT_ID, CUSTOMER_OPT_CODE)? %
?ALTER TABLE SALESMANAGER.CUSTOMER_ATTRIBUTE ADD CONSTRAINT SALESMANAGER.UK_46KBPRE88YH963GEWM3KMDNI1 UNIQUE(OPTION_ID, CUSTOMER_ID)? %
?ALTER TABLE SALESMANAGER.CUSTMER_OPTIN ADD CONSTRAINT SALESMANAGER.UK_QG32YY79QAJFIG2UWR9WJ88S9 UNIQUE(EMAIL, OPTIN_ID) INDEX SALESMANAGER.UK_QG32YY79QAJFIG2UWR9WJ88S9_INDEX_9? !
tCREATE UNIQUE INDEX SALESMANAGER.UK_QG32YY79QAJFIG2UWR9WJ88S9_INDEX_9 ON SALESMANAGER.CUSTMER_OPTIN(EMAIL, OPTIN_ID)? %
?ALTER TABLE SALESMANAGER.COUNTRY_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_T7NSHKI1RBP6157ED0V6CX4Y4 UNIQUE(COUNTRY_ID, LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.CONTENT_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_N0W5R7CTBP88R4RVK7AYKLOFM UNIQUE(CONTENT_ID, LANGUAGE_ID)? %
sALTER TABLE SALESMANAGER.CONTENT ADD CONSTRAINT SALESMANAGER.UK_T1V2LD0MRWVIQUQOURQL4UUB0 UNIQUE(MERCHANT_ID, CODE)? %
?ALTER TABLE SALESMANAGER.CATEGORY_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_BUESQQ6CYX7E5HY3MF30CFIEQ UNIQUE(CATEGORY_ID, LANGUAGE_ID)? %
tALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X UNIQUE(MERCHANT_ID, CODE)_?6?垹?u?
瑁
b?丧8?ぇ	?
b?	瑟	.?‖?煯绡X??? %
ALTER TABLE SALESMANAGER.ZONE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_M64LAXGRV9FXM6IO232AP4SU9 UNIQUE(ZONE_ID, LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.TAX_RATE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_T3XG8PL88YACDXG49NB46EFFG UNIQUE(TAX_RATE_ID, LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.TAX_RATE ADD CONSTRAINT SALESMANAGER.UK_8GH6L9N0XQ03B91SGLP62OELU UNIQUE(TAX_CODE, MERCHANT_ID) INDEX SALESMANAGER.UK_8GH6L9N0XQ03B91SGLP62OELU_INDEX_1? !
uCREATE UNIQUE INDEX SALESMANAGER.UK_8GH6L9N0XQ03B91SGLP62OELU_INDEX_1 ON SALESMANAGER.TAX_RATE(TAX_CODE, MERCHANT_ID)? %
ALTER TABLE SALESMANAGER.TAX_CLASS ADD CONSTRAINT SALESMANAGER.UK_A4Q5Q57A8OEH2OJEO8DHR935K UNIQUE(MERCHANT_ID, TAX_CLASS_CODE)? %
?ALTER TABLE SALESMANAGER.SYSTEM_NOTIFICATION ADD CONSTRAINT SALESMANAGER.UK_NPDNLC390VGR2MHEPIB1MTRMR UNIQUE(MERCHANT_ID, CONFIG_KEY)? %
?ALTER TABLE SALESMANAGER.PRODUCT_REVIEW_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_QNO5WJDTCJ8PM3YKKKH7T4RXJ UNIQUE(PRODUCT_REVIEW_ID, LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_PRICE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_FRSW8D41SXXOGVXXOYD8NWAXU UNIQUE(PRODUCT_PRICE_ID, LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION_VALUE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_ASGC60OT1WY0UHO96N0J8429P UNIQUE(PRODUCT_OPTION_VALUE_ID, LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION_VALUE ADD CONSTRAINT SALESMANAGER.UK_IXBPI4HXRHLJH935C3XFVNVSH UNIQUE(MERCHANT_ID, PRODUCT_OPTION_VAL_CODE)? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION_DESC ADD CONSTRAINT SALESMANAGER.UK_MKCM8ISYYYQBJD1YYB8MRPKUW UNIQUE(PRODUCT_OPTION_ID, LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_OPTION ADD CONSTRAINT SALESMANAGER.UK_HFCW5OI9ULLJLOG1B7NS1R9TU UNIQUE(MERCHANT_ID, PRODUCT_OPTION_CODE)? %
?ALTER TABLE SALESMANAGER.PRODUCT_IMAGE_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_N7YHDJ6CCYDGF201GIBB882CD UNIQUE(PRODUCT_IMAGE_ID, LANGUAGE_ID)? %
ALTER TABLE SALESMANAGER.PRODUCT_DIGITAL ADD CONSTRAINT SALESMANAGER.UK_JUK1QGKH9V5W7GHVB18KRWO8V UNIQUE(PRODUCT_ID, FILE_NAME)? %
?ALTER TABLE SALESMANAGER.PRODUCT_DESCRIPTION ADD CONSTRAINT SALESMANAGER.UK_Q4DNKX5B776AYQAS2H4RR2D8Q UNIQUE(PRODUCT_ID, LANGUAGE_ID)? %
?ALTER TABLE SALESMANAGER.PRODUCT_ATTRIBUTE ADD CONSTRAINT SALESMANAGER.UK_O0C6CFXCFEJWFA2877GFGPUCO UNIQUE(OPTION_ID, OPTION_VALUE_ID, PRODUCT_ID)? %
rALTER TABLE SALESMANAGER.PRODUCT ADD CONSTRAINT SALESMANAGER.UK_S8OFSN9PEHDRSTJG52J5QABXH UNIQUE(MERCHANT_ID, SKU)? %
qALTER TABLE SALESMANAGER.OPTIN ADD CONSTRAINT SALESMANAGER.UK_MANLX6SIQ6DDF14CUD40K8GW6 UNIQUE(MERCHANT_ID, CODE)