forked from CloudBreadProject/CloudBread-NodeJS
-
Notifications
You must be signed in to change notification settings - Fork 10
/
install-db.js
259 lines (223 loc) · 37.4 KB
/
install-db.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
const server_arg = process.argv[2];
const user_arg = process.argv[3];
const password_arg = process.argv[4];
const db_arg = process.argv[5];
const fs = require('fs');
const path = require('path');
const dbsetting = {
development: {
username: '',
password: '',
database: '',
host: '',
timezone: '+09:00',
port: 1433,
dialect: 'mssql',
pool: {
max: 5,
min: 0,
idle: 10000,
},
},
test: {
username: '',
password: '',
database: '',
host: '',
timezone: '+09:00',
port: 1433,
dialect: 'mssql',
pool: {
max: 5,
min: 0,
idle: 10000,
},
},
production: {
username: '',
password: '',
database: '',
host: '',
timezone: '+09:00',
port: 1433,
dialect: 'mssql',
pool: {
max: 5,
min: 0,
idle: 10000,
},
},
};
dbsetting.development.username = user_arg;
dbsetting.development.password = password_arg;
dbsetting.development.host = server_arg;
dbsetting.development.database = db_arg;
dbsetting.test.username = user_arg;
dbsetting.test.password = password_arg;
dbsetting.test.host = server_arg;
dbsetting.test.database = db_arg;
dbsetting.production.username = user_arg;
dbsetting.production.password = password_arg;
dbsetting.production.host = server_arg;
dbsetting.production.database = db_arg;
const dbsetStr = JSON.stringify(dbsetting);
fs.writeFileSync(`${__dirname}/config/sequelize.json`, dbsetStr, 'utf8');
console.log('writeFileSync completed!');
const exec = require('child_process').exec;
exec(`${__dirname}/models/index.js`);
console.log('index.js process end!');
const Sequelize = require('sequelize');
const env = process.env.NODE_ENV || 'development';
const config = require(`${__dirname}/config/sequelize.json`)[env];
const sequelize = new Sequelize(config.database, config.username, config.password, config);
const db = require('./models');
sequelize.Sequelize.Promise.all([
db.Member.hasMany(db.MemberItems, {
foreignKey: 'MemberID',
targetKey: 'MemberID',
}),
db.ItemList.hasMany(db.MemberItems, {
foreignKey: 'ItemListID',
targetKey: 'ItemListID',
}),
db.Member.hasMany(db.MemberGameInfoStages, {
foreignKey: 'MemberID',
targetKey: 'MemberID',
}),
db.ItemList.hasMany(db.GiftDepository, {
foreignKey: 'ItemListID',
targetKey: 'ItemListID',
}),
db.Member.hasMany(db.GiftDepository, {
foreignKey: 'FromMemberID',
targetKey: 'MemberID',
}),
db.Member.hasMany(db.GiftDepository, {
foreignKey: 'ToMemberID',
targetKey: 'MemberID',
}),
db.ItemList.hasMany(db.GameEvents, {
foreignKey: 'ItemListID',
targetKey: 'ItemListID',
}),
db.ItemList.hasMany(db.Coupon, {
foreignKey: 'ItemListID',
targetKey: 'ItemListID',
}),
db.Coupon.hasMany(db.CouponMember, {
foreignKey: 'CouponID',
targetKey: 'CouponID',
}),
db.Member.hasMany(db.CouponMember, {
foreignKey: 'MemberID',
targetKey: 'MemberID',
}),
db.Member.hasMany(db.MemberAccountBlockLog, {
foreignKey: 'MemberID',
targetKey: 'MemberID',
}),
db.ItemList.hasMany(db.MemberItemPurchase, {
foreignKey: 'ItemListID',
targetKey: 'ItemListID',
}),
db.Member.hasMany(db.MemberItemPurchase, {
foreignKey: 'MemberID',
targetKey: 'MemberID',
}),
db.Member.hasMany(db.GameEventMember, {
foreignKey: 'MemberID',
targetKey: 'MemberID',
}),
db.Member.sync(),
db.AdminMember.sync(),
db.ItemList.sync(),
db.Notices.sync(),
db.ServerInfo.sync(),
db.StatData.sync(),
db.MemberGameInfo.sync(),
db.MemberGameInfoStages.sync(),
db.MemberAccountBlockLog.sync(),
db.MemberItemPurchase.sync(),
db.MemberItems.sync(),
db.GameEvents.sync(),
db.GiftDepository.sync(),
db.GameEventMember.sync(),
db.Coupon.sync(), // 2
db.CouponMember.sync(),
// //Sample insert
// Member
db.Member.create({ MemberID: 'aaa', MemberPWD: 'MemberPWD', EmailAddress: '[email protected]', EmailConfirmedYN: 'Y', PhoneNumber1: 'PhoneNumber1', PhoneNumber2: 'PhoneNumber2', PINumber: 'PINumber', Name1: 'aaa', Name2: 'Name2', Name3: 'Name3', DOB: '19900101', RecommenderID: 'RecommenderID', MemberGroup: 'MemberGropu', LastDeviceID: 'LastDeviceID', LastIPaddress: 'LastIPaddress', LastLoginDT: sequelize.fn('GETDATE'), LastLogoutDT: sequelize.fn('GETDATE'), LastMACAddress: 'LastMACAddress', AccountBlockYN: 'N', AccountBlockEndDT: '1900-01-01', AnonymousYN: 'N', ThirdAuthProvider: '3rdAuthProvider', ThirdAuthID: '3rdAuthIDaaa', ThirdAuthParam: '3rdAuthParam', PushNotificationID: 'PushNotisficationID', PushNotificationProvider: 'PushNotificationProvider', PushNotificationGroup: 'PushNotificationGroup', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', TimeZoneID: 'Korea Standard Time', DataFromRegion: '', DataFromRegionDT: sequelize.fn('GETDATE') }),
db.Member.create({ MemberID: 'bbb', MemberPWD: 'MemberPWD', EmailAddress: '[email protected]', EmailConfirmedYN: 'Y', PhoneNumber1: 'PhoneNumber1', PhoneNumber2: 'PhoneNumber2', PINumber: 'PINumber', Name1: 'bbb', Name2: 'Name2', Name3: 'Name3', DOB: '19900101', RecommenderID: 'RecommenderID', MemberGroup: 'MemberGropu', LastDeviceID: 'LastDeviceID', LastIPaddress: 'LastIPaddress', LastLoginDT: sequelize.fn('GETDATE'), LastLogoutDT: sequelize.fn('GETDATE'), LastMACAddress: 'LastMACAddress', AccountBlockYN: 'N', AccountBlockEndDT: '1900-01-01', AnonymousYN: 'N', ThirdAuthProvider: '3rdAuthProvider', ThirdAuthID: '3rdAuthIDaaa', ThirdAuthParam: '3rdAuthParam', PushNotificationID: 'PushNotisficationID', PushNotificationProvider: 'PushNotificationProvider', PushNotificationGroup: 'PushNotificationGroup', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', TimeZoneID: 'Korea Standard Time', DataFromRegion: '', DataFromRegionDT: sequelize.fn('GETDATE') }),
db.Member.create({ MemberID: 'ccc', MemberPWD: 'MemberPWD', EmailAddress: '[email protected]', EmailConfirmedYN: 'Y', PhoneNumber1: 'PhoneNumber1', PhoneNumber2: 'PhoneNumber2', PINumber: 'PINumber', Name1: 'ccc', Name2: 'Name2', Name3: 'Name3', DOB: '19900101', RecommenderID: 'RecommenderID', MemberGroup: 'MemberGropu', LastDeviceID: 'LastDeviceID', LastIPaddress: 'LastIPaddress', LastLoginDT: sequelize.fn('GETDATE'), LastLogoutDT: sequelize.fn('GETDATE'), LastMACAddress: 'LastMACAddress', AccountBlockYN: 'N', AccountBlockEndDT: '1900-01-01', AnonymousYN: 'N', ThirdAuthProvider: '3rdAuthProvider', ThirdAuthID: '3rdAuthIDaaa', ThirdAuthParam: '3rdAuthParam', PushNotificationID: 'PushNotisficationID', PushNotificationProvider: 'PushNotificationProvider', PushNotificationGroup: 'PushNotificationGroup', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', TimeZoneID: 'Korea Standard Time', DataFromRegion: '', DataFromRegionDT: sequelize.fn('GETDATE') }),
db.Member.create({ MemberID: 'ddd', MemberPWD: 'MemberPWD', EmailAddress: '[email protected]', EmailConfirmedYN: 'Y', PhoneNumber1: 'PhoneNumber1', PhoneNumber2: 'PhoneNumber2', PINumber: 'PINumber', Name1: 'ddd', Name2: 'Name2', Name3: 'Name3', DOB: '19900101', RecommenderID: 'RecommenderID', MemberGroup: 'MemberGropu', LastDeviceID: 'LastDeviceID', LastIPaddress: 'LastIPaddress', LastLoginDT: sequelize.fn('GETDATE'), LastLogoutDT: sequelize.fn('GETDATE'), LastMACAddress: 'LastMACAddress', AccountBlockYN: 'N', AccountBlockEndDT: '1900-01-01', AnonymousYN: 'N', ThirdAuthProvider: '3rdAuthProvider', ThirdAuthID: '3rdAuthIDaaa', ThirdAuthParam: '3rdAuthParam', PushNotificationID: 'PushNotisficationID', PushNotificationProvider: 'PushNotificationProvider', PushNotificationGroup: 'PushNotificationGroup', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', TimeZoneID: 'Korea Standard Time', DataFromRegion: '', DataFromRegionDT: sequelize.fn('GETDATE') }),
db.Member.create({ MemberID: 'eee', MemberPWD: 'MemberPWD', EmailAddress: '[email protected]', EmailConfirmedYN: 'Y', PhoneNumber1: 'PhoneNumber1', PhoneNumber2: 'PhoneNumber2', PINumber: 'PINumber', Name1: 'eee', Name2: 'Name2', Name3: 'Name3', DOB: '19900101', RecommenderID: 'RecommenderID', MemberGroup: 'MemberGropu', LastDeviceID: 'LastDeviceID', LastIPaddress: 'LastIPaddress', LastLoginDT: sequelize.fn('GETDATE'), LastLogoutDT: sequelize.fn('GETDATE'), LastMACAddress: 'LastMACAddress', AccountBlockYN: 'N', AccountBlockEndDT: '1900-01-01', AnonymousYN: 'N', ThirdAuthProvider: '3rdAuthProvider', ThirdAuthID: '3rdAuthIDaaa', ThirdAuthParam: '3rdAuthParam', PushNotificationID: 'PushNotisficationID', PushNotificationProvider: 'PushNotificationProvider', PushNotificationGroup: 'PushNotificationGroup', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', TimeZoneID: 'Korea Standard Time', DataFromRegion: '', DataFromRegionDT: sequelize.fn('GETDATE') }),
// ItemList
db.ItemList.create({ ItemListID: 'itemid1', ItemName: 'ItemName1', ItemDescription: 'ItemDescription', ItemPrice: '10', ItemSellPrice: '10', ItemCategory1: 'ItemCategory1', ItemCategory2: 'ItemCategory2', ItemCategory3: 'ItemCategory3', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', ItemCreateAdminID: 'IteamCreateAdminID', ItemUpdateAdminID: 'IteamUpdateAdminID', HideYN: 'N', DeleteYN: 'N' }),
db.ItemList.create({ ItemListID: 'itemid2', ItemName: 'ItemName2', ItemDescription: 'ItemDescription', ItemPrice: '10', ItemSellPrice: '10', ItemCategory1: 'ItemCategory1', ItemCategory2: 'ItemCategory2', ItemCategory3: 'ItemCategory3', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', ItemCreateAdminID: 'IteamCreateAdminID', ItemUpdateAdminID: 'IteamUpdateAdminID', HideYN: 'N', DeleteYN: 'N' }),
db.ItemList.create({ ItemListID: 'itemid3', ItemName: 'ItemName3', ItemDescription: 'ItemDescription', ItemPrice: '10', ItemSellPrice: '10', ItemCategory1: 'ItemCategory1', ItemCategory2: 'ItemCategory2', ItemCategory3: 'ItemCategory3', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', ItemCreateAdminID: 'IteamCreateAdminID', ItemUpdateAdminID: 'IteamUpdateAdminID', HideYN: 'N', DeleteYN: 'N' }),
db.ItemList.create({ ItemListID: 'itemid4', ItemName: 'ItemName4', ItemDescription: 'ItemDescription', ItemPrice: '10', ItemSellPrice: '10', ItemCategory1: 'ItemCategory1', ItemCategory2: 'ItemCategory2', ItemCategory3: 'ItemCategory3', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', ItemCreateAdminID: 'IteamCreateAdminID', ItemUpdateAdminID: 'IteamUpdateAdminID', HideYN: 'N', DeleteYN: 'N' }),
// GiftDepository
db.GiftDepository.create({ GiftDepositoryID: 'GiftID1', ItemListID: 'itemid1', ItemCount: '1', FromMemberID: 'bbb', ToMemberID: 'aaa', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', SentMemberYN: 'N', HideYN: 'N', DeleteYN: 'N' }),
db.GiftDepository.create({ GiftDepositoryID: 'GiftID2', ItemListID: 'itemid1', ItemCount: '2', FromMemberID: 'ccc', ToMemberID: 'aaa', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', SentMemberYN: 'N', HideYN: 'N', DeleteYN: 'N' }),
db.GiftDepository.create({ GiftDepositoryID: 'GiftID3', ItemListID: 'itemid2', ItemCount: '3', FromMemberID: 'bbb', ToMemberID: 'aaa', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', SentMemberYN: 'N', HideYN: 'N', DeleteYN: 'N' }),
db.GiftDepository.create({ GiftDepositoryID: 'GiftID4', ItemListID: 'itemid2', ItemCount: '4', FromMemberID: 'ccc', ToMemberID: 'bbb', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', SentMemberYN: 'N', HideYN: 'N', DeleteYN: 'N' }),
// MemberItems
db.MemberItems.create({ MemberItemID: 'MemberItemsID1', MemberID: 'aaa', ItemListID: 'itemid1', ItemCount: '1', ItemStatus: 'ItemStatus', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
db.MemberItems.create({ MemberItemID: 'MemberItemsID2', MemberID: 'aaa', ItemListID: 'itemid2', ItemCount: '1', ItemStatus: 'ItemStatus', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
db.MemberItems.create({ MemberItemID: 'MemberItemsID3', MemberID: 'aaa', ItemListID: 'itemid3', ItemCount: '1', ItemStatus: 'ItemStatus', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
db.MemberItems.create({ MemberItemID: 'MemberItemsID4', MemberID: 'bbb', ItemListID: 'itemid1', ItemCount: '1', ItemStatus: 'ItemStatus', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
db.MemberItems.create({ MemberItemID: 'MemberItemsID5', MemberID: 'aaa', ItemListID: 'itemid4', ItemCount: '1', ItemStatus: 'ItemStatus', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
// MemberGameInfo
db.MemberGameInfo.create({ MemberID: 'aaa', Level: '10', Exps: '10', Points: '10', UserSTAT1: 'UserSTAT1', UserSTAT2: 'UserSTAT2', UserSTAT3: 'UserSTAT3', UserSTAT4: 'UserSTAT4', UserSTAT5: 'UserSTAT5', UserSTAT6: 'UserSTAT6', UserSTAT7: 'UserSTAT7', UserSTAT8: 'UserSTAT8', UserSTAT9: 'UserSTAT9', UserSTAT10: 'UserSTAT10', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
db.MemberGameInfo.create({ MemberID: 'bbb', Level: '20', Exps: '20', Points: '20', UserSTAT1: 'UserSTAT1', UserSTAT2: 'UserSTAT2', UserSTAT3: 'UserSTAT3', UserSTAT4: 'UserSTAT4', UserSTAT5: 'UserSTAT5', UserSTAT6: 'UserSTAT6', UserSTAT7: 'UserSTAT7', UserSTAT8: 'UserSTAT8', UserSTAT9: 'UserSTAT9', UserSTAT10: 'UserSTAT10', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
db.MemberGameInfo.create({ MemberID: 'ccc', Level: '30', Exps: '30', Points: '30', UserSTAT1: 'UserSTAT1', UserSTAT2: 'UserSTAT2', UserSTAT3: 'UserSTAT3', UserSTAT4: 'UserSTAT4', UserSTAT5: 'UserSTAT5', UserSTAT6: 'UserSTAT6', UserSTAT7: 'UserSTAT7', UserSTAT8: 'UserSTAT8', UserSTAT9: 'UserSTAT9', UserSTAT10: 'UserSTAT10', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
db.MemberGameInfo.create({ MemberID: 'ddd', Level: '40', Exps: '40', Points: '40', UserSTAT1: 'UserSTAT1', UserSTAT2: 'UserSTAT2', UserSTAT3: 'UserSTAT3', UserSTAT4: 'UserSTAT4', UserSTAT5: 'UserSTAT5', UserSTAT6: 'UserSTAT6', UserSTAT7: 'UserSTAT7', UserSTAT8: 'UserSTAT8', UserSTAT9: 'UserSTAT9', UserSTAT10: 'UserSTAT10', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
// MemberItemPurchase
db.MemberItemPurchase.create({ MemberItemPurchaseID: 'MemberItemPurchasesID1', MemberID: 'aaa', ItemListID: 'itemid1', PurchaseQuantity: '10', PurchasePrice: '10', PGinfo1: 'PGinfo1', PGinfo2: 'PGinfo2', PGinfo3: 'PGinfo3', PGinfo4: 'PGinfo4', PGinfo5: 'PGinfo5', PurchaseDeviceID: 'PurchaseDeviceID', PurchaseDeviceIPAddress: 'PurchaseDeviceIPAddress', PurchaseDeviceMACAddress: 'PurchaseDeviceMACAddress', PurchaseDT: sequelize.fn('GETDATE'), PurchaseCancelYN: 'N', PurchaseCancelDT: '1900-01-01', PurchaseCancelingStatus: 'ok', PurchaseCancelReturnedAmount: '100', PurchaseCancelDeviceID: 'PurchaseCancelDeviceID', PurchaseCancelDeviceIPAddress: 'PurchaseCancelDeviceIPAddress', PurchaseCancelDeviceMACAddress: 'PurchaseCancelDeviceMACAddress', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N', PurchaseCancelConfirmAdminMemberID: 'admin1', DataFromRegionDT: '1900-01-01' }),
db.MemberItemPurchase.create({ MemberItemPurchaseID: 'MemberItemPurchasesID2', MemberID: 'aaa', ItemListID: 'itemid2', PurchaseQuantity: '10', PurchasePrice: '10', PGinfo1: 'PGinfo1', PGinfo2: 'PGinfo2', PGinfo3: 'PGinfo3', PGinfo4: 'PGinfo4', PGinfo5: 'PGinfo5', PurchaseDeviceID: 'PurchaseDeviceID', PurchaseDeviceIPAddress: 'PurchaseDeviceIPAddress', PurchaseDeviceMACAddress: 'PurchaseDeviceMACAddress', PurchaseDT: sequelize.fn('GETDATE'), PurchaseCancelYN: 'N', PurchaseCancelDT: '1900-01-01', PurchaseCancelingStatus: 'ok', PurchaseCancelReturnedAmount: '100', PurchaseCancelDeviceID: 'PurchaseCancelDeviceID', PurchaseCancelDeviceIPAddress: 'PurchaseCancelDeviceIPAddress', PurchaseCancelDeviceMACAddress: 'PurchaseCancelDeviceMACAddress', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N', PurchaseCancelConfirmAdminMemberID: 'admin1', DataFromRegionDT: '1900-01-01' }),
db.MemberItemPurchase.create({ MemberItemPurchaseID: 'MemberItemPurchasesID3', MemberID: 'aaa', ItemListID: 'itemid3', PurchaseQuantity: '10', PurchasePrice: '10', PGinfo1: 'PGinfo1', PGinfo2: 'PGinfo2', PGinfo3: 'PGinfo3', PGinfo4: 'PGinfo4', PGinfo5: 'PGinfo5', PurchaseDeviceID: 'PurchaseDeviceID', PurchaseDeviceIPAddress: 'PurchaseDeviceIPAddress', PurchaseDeviceMACAddress: 'PurchaseDeviceMACAddress', PurchaseDT: sequelize.fn('GETDATE'), PurchaseCancelYN: 'N', PurchaseCancelDT: '1900-01-01', PurchaseCancelingStatus: 'ok', PurchaseCancelReturnedAmount: '100', PurchaseCancelDeviceID: 'PurchaseCancelDeviceID', PurchaseCancelDeviceIPAddress: 'PurchaseCancelDeviceIPAddress', PurchaseCancelDeviceMACAddress: 'PurchaseCancelDeviceMACAddress', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N', PurchaseCancelConfirmAdminMemberID: 'admin1', DataFromRegionDT: '1900-01-01' }),
db.MemberItemPurchase.create({ MemberItemPurchaseID: 'MemberItemPurchasesID4', MemberID: 'ccc', ItemListID: 'itemid1', PurchaseQuantity: '10', PurchasePrice: '10', PGinfo1: 'PGinfo1', PGinfo2: 'PGinfo2', PGinfo3: 'PGinfo3', PGinfo4: 'PGinfo4', PGinfo5: 'PGinfo5', PurchaseDeviceID: 'PurchaseDeviceID', PurchaseDeviceIPAddress: 'PurchaseDeviceIPAddress', PurchaseDeviceMACAddress: 'PurchaseDeviceMACAddress', PurchaseDT: sequelize.fn('GETDATE'), PurchaseCancelYN: 'N', PurchaseCancelDT: '1900-01-01', PurchaseCancelingStatus: 'ok', PurchaseCancelReturnedAmount: '100', PurchaseCancelDeviceID: 'PurchaseCancelDeviceID', PurchaseCancelDeviceIPAddress: 'PurchaseCancelDeviceIPAddress', PurchaseCancelDeviceMACAddress: 'PurchaseCancelDeviceMACAddress', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N', PurchaseCancelConfirmAdminMemberID: 'admin1', DataFromRegionDT: '1900-01-01' }),
// AdminMembers
db.AdminMember.create({ AdminMemberID: 'admin1', AdminMemberPWD: 'AdminMemberPWD', AdminMemberEmail: '[email protected]', IDCreateAdminMember: 'admin1', AdminGroup: 'AdminGroup', TimeZoneID: 'Korea Standard Time', PINumber: 'PINumber', Name1: 'Name1', Name2: 'Name2', Name3: 'Name3', DOB: '19991212', LastIPaddress: 'LastIPaddress', LastLoginDT: sequelize.fn('GETDATE'), LastLogoutDT: sequelize.fn('GETDATE'), sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
db.AdminMember.create({ AdminMemberID: 'admin2', AdminMemberPWD: 'AdminMemberPWD', AdminMemberEmail: '[email protected]', IDCreateAdminMember: 'admin1', AdminGroup: 'AdminGroup', TimeZoneID: 'Korea Standard Time', PINumber: 'PINumber', Name1: 'Name1', Name2: 'Name2', Name3: 'Name3', DOB: '19991212', LastIPaddress: 'LastIPaddress', LastLoginDT: sequelize.fn('GETDATE'), LastLogoutDT: sequelize.fn('GETDATE'), sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
db.AdminMember.create({ AdminMemberID: 'admin3', AdminMemberPWD: 'AdminMemberPWD', AdminMemberEmail: '[email protected]', IDCreateAdminMember: 'admin2', AdminGroup: 'AdminGroup', TimeZoneID: 'Korea Standard Time', PINumber: 'PINumber', Name1: 'Name1', Name2: 'Name2', Name3: 'Name3', DOB: '19991212', LastIPaddress: 'LastIPaddress', LastLoginDT: sequelize.fn('GETDATE'), LastLogoutDT: sequelize.fn('GETDATE'), sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
db.AdminMember.create({ AdminMemberID: 'admin4', AdminMemberPWD: 'AdminMemberPWD', AdminMemberEmail: '[email protected]', IDCreateAdminMember: 'admin2', AdminGroup: 'AdminGroup', TimeZoneID: 'Korea Standard Time', PINumber: 'PINumber', Name1: 'Name1', Name2: 'Name2', Name3: 'Name3', DOB: '19991212', LastIPaddress: 'LastIPaddress', LastLoginDT: sequelize.fn('GETDATE'), LastLogoutDT: sequelize.fn('GETDATE'), sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
// MemberGameInfoStages
db.MemberGameInfoStages.create({ MemberGameInfoStageID: 'MemberGameInfoStageID1', MemberID: 'aaa', StageName: 'StageName1', StageStatus: 'StageStatus', Category1: 'Category1', Category2: 'Category2', Category3: 'Category3', Mission1: 'Mission1', Mission2: 'Mission2', Mission3: 'Mission3', Mission4: 'Mission4', Mission5: 'Mission5', Points: '100', StageStat1: 'StageStat1', StageStat2: 'StageStat2', StageStat3: 'StageStat3', StageStat4: 'StageStat4', StageStat5: 'StageStat5', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
db.MemberGameInfoStages.create({ MemberGameInfoStageID: 'MemberGameInfoStageID2', MemberID: 'aaa', StageName: 'StageName2', StageStatus: 'StageStatus', Category1: 'Category1', Category2: 'Category2', Category3: 'Category3', Mission1: 'Mission1', Mission2: 'Mission2', Mission3: 'Mission3', Mission4: 'Mission4', Mission5: 'Mission5', Points: '100', StageStat1: 'StageStat1', StageStat2: 'StageStat2', StageStat3: 'StageStat3', StageStat4: 'StageStat4', StageStat5: 'StageStat5', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
db.MemberGameInfoStages.create({ MemberGameInfoStageID: 'MemberGameInfoStageID3', MemberID: 'aaa', StageName: 'StageName3', StageStatus: 'StageStatus', Category1: 'Category1', Category2: 'Category2', Category3: 'Category3', Mission1: 'Mission1', Mission2: 'Mission2', Mission3: 'Mission3', Mission4: 'Mission4', Mission5: 'Mission5', Points: '100', StageStat1: 'StageStat1', StageStat2: 'StageStat2', StageStat3: 'StageStat3', StageStat4: 'StageStat4', StageStat5: 'StageStat5', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
db.MemberGameInfoStages.create({ MemberGameInfoStageID: 'MemberGameInfoStageID4', MemberID: 'bbb', StageName: 'StageName1', StageStatus: 'StageStatus', Category1: 'Category1', Category2: 'Category2', Category3: 'Category3', Mission1: 'Mission1', Mission2: 'Mission2', Mission3: 'Mission3', Mission4: 'Mission4', Mission5: 'Mission5', Points: '100', StageStat1: 'StageStat1', StageStat2: 'StageStat2', StageStat3: 'StageStat3', StageStat4: 'StageStat4', StageStat5: 'StageStat5', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
// Notices
db.Notices.create({ NoticeID: 'NoticeID1', NoticeCategory1: 'NoticeCategory1', NoticeCategory2: 'NoticeCategory2', NoticeCategory3: 'NoticeCategory3', TargetGroup: 'TargetGroup', TargetOS: 'TargetOS', TargetDevice: 'TargetDevice', NoticeImageLink: 'NoticeImageLink', title: 'title1', content: 'content', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', NoticeDurationFrom: '2015-03-01', NoticeDurationTo: '2025-04-01', OrderNumber: 0, CreateAdminID: 'admin1', HideYN: 'N', DeleteYN: 'N' }),
db.Notices.create({ NoticeID: 'NoticeID2', NoticeCategory1: 'NoticeCategory1', NoticeCategory2: 'NoticeCategory2', NoticeCategory3: 'NoticeCategory3', TargetGroup: 'TargetGroup', TargetOS: 'TargetOS', TargetDevice: 'TargetDevice', NoticeImageLink: 'NoticeImageLink', title: 'title2', content: 'content', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', NoticeDurationFrom: '2015-03-01', NoticeDurationTo: '2025-04-01', OrderNumber: 0, CreateAdminID: 'admin1', HideYN: 'N', DeleteYN: 'N' }),
db.Notices.create({ NoticeID: 'NoticeID3', NoticeCategory1: 'NoticeCategory1', NoticeCategory2: 'NoticeCategory2', NoticeCategory3: 'NoticeCategory3', TargetGroup: 'TargetGroup', TargetOS: 'TargetOS', TargetDevice: 'TargetDevice', NoticeImageLink: 'NoticeImageLink', title: 'title3', content: 'content', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', NoticeDurationFrom: '2015-03-01', NoticeDurationTo: '2025-04-01', OrderNumber: 0, CreateAdminID: 'admin1', HideYN: 'N', DeleteYN: 'N' }),
db.Notices.create({ NoticeID: 'NoticeID4', NoticeCategory1: 'NoticeCategory1', NoticeCategory2: 'NoticeCategory2', NoticeCategory3: 'NoticeCategory3', TargetGroup: 'TargetGroup', TargetOS: 'TargetOS', TargetDevice: 'TargetDevice', NoticeImageLink: 'NoticeImageLink', title: 'title4', content: 'content', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', NoticeDurationFrom: '2015-03-01', NoticeDurationTo: '2025-04-01', OrderNumber: 0, CreateAdminID: 'admin1', HideYN: 'N', DeleteYN: 'N' }),
// GameEvents
db.GameEvents.create({ GameEventID: 'evtid1', EventCategory1: 'EventCategory1', EventCategory2: 'EventCategory2', EventCategory3: 'EventCategory3', ItemListID: 'itemid1', ItemCount: 1, Itemstatus: 'Itemstatus', TargetGroup: 'TargetGroup', TargetOS: 'TargetOS', TargetDevice: 'TargetDevice', EventImageLink: 'EventImageLink', Title: 'Title1', Content: 'Content', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', EventDurationFrom: '2015-03-01', EventDurationTo: '2025-04-01', OrderNumber: 0, CreateAdminID: 'admin1', HideYN: 'N', DeleteYN: 'N' }),
db.GameEvents.create({ GameEventID: 'evtid2', EventCategory1: 'EventCategory1', EventCategory2: 'EventCategory2', EventCategory3: 'EventCategory3', ItemListID: 'itemid1', ItemCount: 2, Itemstatus: 'Itemstatus', TargetGroup: 'TargetGroup', TargetOS: 'TargetOS', TargetDevice: 'TargetDevice', EventImageLink: 'EventImageLink', Title: 'Title2', Content: 'Content', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', EventDurationFrom: '2015-03-01', EventDurationTo: '2025-04-01', OrderNumber: 0, CreateAdminID: 'admin1', HideYN: 'N', DeleteYN: 'N' }),
db.GameEvents.create({ GameEventID: 'evtid3', EventCategory1: 'EventCategory1', EventCategory2: 'EventCategory2', EventCategory3: 'EventCategory3', ItemListID: 'itemid1', ItemCount: 3, Itemstatus: 'Itemstatus', TargetGroup: 'TargetGroup', TargetOS: 'TargetOS', TargetDevice: 'TargetDevice', EventImageLink: 'EventImageLink', Title: 'Title3', Content: 'Content', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', EventDurationFrom: '2015-03-01', EventDurationTo: '2025-04-01', OrderNumber: 0, CreateAdminID: 'admin1', HideYN: 'N', DeleteYN: 'N' }),
db.GameEvents.create({ GameEventID: 'evtid4', EventCategory1: 'EventCategory1', EventCategory2: 'EventCategory2', EventCategory3: 'EventCategory3', ItemListID: 'itemid1', ItemCount: 4, Itemstatus: 'Itemstatus', TargetGroup: 'TargetGroup', TargetOS: 'TargetOS', TargetDevice: 'TargetDevice', EventImageLink: 'EventImageLink', Title: 'Title4', Content: 'Content', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', EventDurationFrom: '2015-03-01', EventDurationTo: '2025-04-01', OrderNumber: 0, CreateAdminID: 'admin1', HideYN: 'N', DeleteYN: 'N' }),
// GameEventMember
db.GameEventMember.create({ GameEventMemberID: 'GameEventMemberID1', eventID: 'evtid1', MemberID: 'aaa', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
db.GameEventMember.create({ GameEventMemberID: 'GameEventMemberID2', eventID: 'evtid2', MemberID: 'aaa', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
db.GameEventMember.create({ GameEventMemberID: 'GameEventMemberID3', eventID: 'evtid3', MemberID: 'aaa', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
db.GameEventMember.create({ GameEventMemberID: 'GameEventMemberID4', eventID: 'evtid2', MemberID: 'bbb', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', HideYN: 'N', DeleteYN: 'N' }),
// Coupon
db.Coupon.create({ CouponID: 'cpid1', CouponCategory1: 'CouponCategory1', CouponCategory2: 'CouponCategory2', CouponCategory3: 'CouponCategory3', ItemListID: 'itemid1', ItemCount: '1', ItemStatus: 'ItemStatus', TargetGroup: 'TargetGroup', TargetOS: 'TargetOS', TargetDevice: 'TargetDevice', Title: 'Title1', Content: 'Content', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', DupeYN: 'N', OrderNumber: '0', CouponDurationFrom: '2015-03-01', CouponDurationTo: '2025-04-01', CreateAdminID: 'admin1', HideYN: 'N', DeleteYN: 'N' }),
db.Coupon.create({ CouponID: 'cpid2', CouponCategory1: 'CouponCategory1', CouponCategory2: 'CouponCategory2', CouponCategory3: 'CouponCategory3', ItemListID: 'itemid2', ItemCount: '2', ItemStatus: 'ItemStatus', TargetGroup: 'TargetGroup', TargetOS: 'TargetOS', TargetDevice: 'TargetDevice', Title: 'Title2', Content: 'Content', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', DupeYN: 'Y', OrderNumber: '0', CouponDurationFrom: '2015-03-01', CouponDurationTo: '2025-04-01', CreateAdminID: 'admin1', HideYN: 'N', DeleteYN: 'N' }),
db.Coupon.create({ CouponID: 'cpid3', CouponCategory1: 'CouponCategory1', CouponCategory2: 'CouponCategory2', CouponCategory3: 'CouponCategory3', ItemListID: 'itemid3', ItemCount: '3', ItemStatus: 'ItemStatus', TargetGroup: 'TargetGroup', TargetOS: 'TargetOS', TargetDevice: 'TargetDevice', Title: 'Title3', Content: 'Content', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', DupeYN: 'N', OrderNumber: '0', CouponDurationFrom: '2015-03-01', CouponDurationTo: '2025-04-01', CreateAdminID: 'admin1', HideYN: 'N', DeleteYN: 'N' }),
db.Coupon.create({ CouponID: 'cpid4', CouponCategory1: 'CouponCategory1', CouponCategory2: 'CouponCategory2', CouponCategory3: 'CouponCategory3', ItemListID: 'itemid4', ItemCount: '4', ItemStatus: 'ItemStatus', TargetGroup: 'TargetGroup', TargetOS: 'TargetOS', TargetDevice: 'TargetDevice', Title: 'Title4', Content: 'Content', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', DupeYN: 'Y', OrderNumber: '0', CouponDurationFrom: '2015-03-01', CouponDurationTo: '2025-04-01', CreateAdminID: 'admin1', HideYN: 'N', DeleteYN: 'N' }),
// MemberAccountBlockLog
db.MemberAccountBlockLog.create({ MemberAccountBlockID: 'MemberAccountBlockLog1', MemberID: 'ddd', MemberAccountBlockReasonCategory1: 'cheater', MemberAccountBlockReasonCategory2: 'MemberAccountBlockReasonCategory2', MemberAccountBlockReasonCategory3: 'MemberAccountBlockReasonCategory3', MemberAccountBlockReason: 'MemberAccountBlockReason', MemberAccountBlockProcess: 'block start', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', CreateAdminID: 'admin1', HideYN: 'N', DeleteYN: 'N' }),
db.MemberAccountBlockLog.create({ MemberAccountBlockID: 'MemberAccountBlockLog2', MemberID: 'ccc', MemberAccountBlockReasonCategory1: 'cheater', MemberAccountBlockReasonCategory2: 'MemberAccountBlockReasonCategory2', MemberAccountBlockReasonCategory3: 'MemberAccountBlockReasonCategory3', MemberAccountBlockReason: 'MemberAccountBlockReason', MemberAccountBlockProcess: 'block end', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', CreateAdminID: 'admin1', HideYN: 'N', DeleteYN: 'N' }),
db.MemberAccountBlockLog.create({ MemberAccountBlockID: 'MemberAccountBlockLog3', MemberID: 'ddd', MemberAccountBlockReasonCategory1: 'cheater', MemberAccountBlockReasonCategory2: 'MemberAccountBlockReasonCategory2', MemberAccountBlockReasonCategory3: 'MemberAccountBlockReasonCategory3', MemberAccountBlockReason: 'MemberAccountBlockReason', MemberAccountBlockProcess: 'block canceled', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', CreateAdminID: 'admin1', HideYN: 'N', DeleteYN: 'N' }),
db.MemberAccountBlockLog.create({ MemberAccountBlockID: 'MemberAccountBlockLog4', MemberID: 'ddd', MemberAccountBlockReasonCategory1: 'cheater', MemberAccountBlockReasonCategory2: 'MemberAccountBlockReasonCategory2', MemberAccountBlockReasonCategory3: 'MemberAccountBlockReasonCategory3', MemberAccountBlockReason: 'MemberAccountBlockReason', MemberAccountBlockProcess: 'block delete', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', sCol6: 'sCol6', sCol7: 'sCol7', sCol8: 'sCol8', sCol9: 'sCol9', sCol10: 'sCol10', CreateAdminID: 'admin1', HideYN: 'N', DeleteYN: 'N' }),
// ServerInfo
db.ServerInfo.create({ InfoID: 'InfoID1', FEServerLists: 'FEServerLists', SocketServerLists: 'SocketServerLists', Version: '1.0', ResourceLink: 'ResourceLink', EULAText: 'EULAText', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', CreatedAt: '1900-01-01', UpdatedAt: '1900-01-01', DataFromRegionDT: '1900-01-01' }),
db.ServerInfo.create({ InfoID: 'InfoID2', FEServerLists: 'frontend1,frontend2', SocketServerLists: 'socketServer1,socketServer1', Version: '1.2', ResourceLink: 'bloblink', EULAText: 'EULA', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', CreatedAt: '1900-01-01', UpdatedAt: '1900-01-01', DataFromRegionDT: '1900-01-01' }),
db.ServerInfo.create({ InfoID: 'InfoID3', FEServerLists: 'webserver1,webserver2', SocketServerLists: 'tcpserver1,tcpserver2', Version: '1.0', ResourceLink: 'ResourceLink', EULAText: 'EULAText', sCol1: 'sCol1', sCol2: 'sCol2', sCol3: 'sCol3', sCol4: 'sCol4', sCol5: 'sCol5', CreatedAt: '1900-01-01', UpdatedAt: '1900-01-01', DataFromRegionDT: '1900-01-01' }),
// statInfo
])
.catch((err) => {
console.log(err);
});