-
Notifications
You must be signed in to change notification settings - Fork 28
Expand file tree
/
Copy pathtableData.sql
More file actions
213 lines (194 loc) ยท 16.9 KB
/
tableData.sql
File metadata and controls
213 lines (194 loc) ยท 16.9 KB
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
INSERT INTO `com_code` (`CLASSNO`, `CODECD`, `CODENM`) VALUES
(1, 'A', '๊ด๋ฆฌ์'),
(1, 'U', '์ฌ์ฉ์');
INSERT INTO `com_code` (`CLASSNO`, `CODECD`, `CODENM`) VALUES
(2, '0', '์์์ ์ฅ'),
(2, '1', '๋๊ธฐ์ค'),
(2, '2', '์ฌ์ฌ์ค'),
(2, '3', '๋ฐ๋ ค'),
(2, '4', '๊ฒฐ์ฌ ์๋ฃ');
INSERT INTO `com_code` (`CLASSNO`, `CODECD`, `CODENM`) VALUES
(3, '01', '์ ์'),
(3, '02', '์ฃผ์'),
(3, '03', '๋๋ฆฌ'),
(3, '04', '๊ณผ์ฅ'),
(3, '05', '์ฐจ์ฅ'),
(3, '06', '๋ถ์ฅ'),
(3, '07', '์ด์ฌ'),
(3, '08', '์๋ฌด'),
(3, '09', '์ ๋ฌด'),
(3, '10', '๋ถ์ฌ์ฅ'),
(3, '11', '์ฌ์ฅ'),
(3, '12', '๋ถํ์ฅ'),
(3, '13', 'ํ์ฅ');
INSERT INTO `com_code` (`CLASSNO`, `CODECD`, `CODENM`) VALUES
(4, '1', '์
๋ฌด'),
(4, '2', 'ํ์'),
(4, '3', '์ธ๊ทผ'),
(4, '4', '์ถ์ฅ'),
(4, '5', '๊ต์ก'),
(4, '6', 'ํด๊ฐ'),
(4, '7', '๊ธฐํ');
INSERT INTO `com_code` (`CLASSNO`, `CODECD`, `CODENM`) VALUES
(5, '1', '๋ฐ๋ณต์์'),
(5, '2', '์ฃผ๋จ์'),
(5, '3', '์๋จ์');
INSERT INTO `com_code` (`CLASSNO`, `CODECD`, `CODENM`) VALUES
(6, 'Y', '๊ณต๊ฐ'),
(6, 'N', '๋น๊ณต๊ฐ');
INSERT INTO `sch_holiday` (`SHNO`, `SHTITLE`, `SHMONTH`, `SHDATE`, `SHCOLOR`, `DELETEFLAG`) VALUES
(1, '์ ์ ', 1, 1, 'RED', 'N'),
(2, '์ผ์ผ์ ', 3, 1, 'RED', 'N'),
(3, '์๋ชฉ์ผ', 4, 5, 'GREEN', 'N'),
(4, '๊ทผ๋ก์์๋ ', 5, 1, 'GREEN', 'N'),
(5, '์ด๋ฆฐ์ด๋ ', 5, 5, 'RED', 'N'),
(6, '์ด๋ฒ์ด๋ ', 5, 8, 'GREEN', 'N'),
(7, '์ค์น์๋ ', 5, 15, 'GREEN', 'N'),
(8, 'ํ์ถฉ์ผ', 6, 6, 'RED', 'N'),
(9, '์ ํ์ ', 7, 17, 'GREEN', 'N'),
(10, '๊ด๋ณต์ ', 8, 15, 'RED', 'N'),
(11, '๊ฐ์ฒ์ ', 10, 3, 'RED', 'N'),
(12, 'ํ๊ธ๋ ', 10, 9, 'RED', 'N'),
(13, '์ฑํ์ ', 12, 25, 'RED', 'N');
-- select * from com_code;
INSERT INTO `com_dept` (`DEPTNO`, `DEPTNM`, `PARENTNO`, `DELETEFLAG`) VALUES
(1, '์ฃผ์ํ์ฌ', NULL, 'N'),
(2, '๊ธฐํ์ค', 1, 'N'),
(3, '๊ฒฝ๋ฆฌํ', 1, 'N'),
(4, '๊ฐ๋ฐ๋ณธ๋ถ', 1, 'N'),
(5, '๊ฐ๋ฐ 1ํ', 4, 'N'),
(6, '๊ฐ๋ฐ 2ํ', 4, 'N'),
(7, '๋์์ธํ', 1, 'N');
INSERT INTO `tbl_boardgroup` (`BGNO`, `BGNAME`, `BGPARENT`, `BGDELETEFLAG`, `BGUSED`, `BGREPLY`, `BGREADONLY`, `BGNOTICE`, `BGDATE`) VALUES
(1, '๊ฒ์ํ', NULL, 'N', 'N', 'N', 'N', 'N',NOW()),
(2, '๊ณต์ง์ฌํญ', 1, 'N', 'Y', 'N', 'Y', 'Y', NOW()),
(3, '์ผ๋ฐ๊ฒ์ํ', 1, 'N', 'Y', 'Y', 'N', 'N', NOW());
INSERT INTO `com_user` (`USERNO`, `USERID`, `USERNM`, `USERPW`, `USERROLE`, `PHOTO`, `DEPTNO`, `DELETEFLAG`) VALUES
(1, 'admin', '๊ด๋ฆฌ์', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', 'A', NULL, 1, 'N'),
(2, 'user1', '์ด์ฌ๋ถ', '0a041b9462caa4a31bac3567e0b6e6fd9100787db2ab433d96f6d178cabfce90', 'U', NULL, 3, 'N'),
(3, 'user2', '๊ณ๋ฐฑ', '6025d18fe48abd45168528f18a82e265dd98d421a7084aa09f61b341703901a3', 'U', NULL, 4, 'N'),
(4, 'user3', '๊ด์ฐฝ', '5860faf02b6bc6222ba5aca523560f0e364ccd8b67bee486fe8bf7c01d492ccb', 'U', NULL, 5, 'N'),
(5, 'user4', '๊น์ ์ ', '5269ef980de47819ba3d14340f4665262c41e933dc92c1a27dd5d01b047ac80e', 'U', NULL, 6, 'N'),
(6, 'user5', '์ํจ', '5a39bead318f306939acb1d016647be2e38c6501c58367fdb3e9f52542aa2442', 'U', NULL, 2, 'N'),
(7, 'user6', 'ํ์ด', 'ecb48a1cc94f951252ec462fe9ecc55c3ef123fadfe935661396c26a45a5809d', 'U', NULL, 3, 'N'),
(8, 'user7', '์ฅ๋ณด๊ณ ', '3268151e52d97b4cacf97f5b46a5c76c8416e928e137e3b3dc447696a29afbaa', 'U', NULL, 4, 'N'),
(9, 'user8', '๋์กฐ์', 'f60afa4989a7db13314a2ab9881372634b5402c30ba7257448b13fa388de1b78', 'U', NULL, 5, 'N'),
(10, 'user9', '๊ฐ๊ฐ์ฐฌ', '0fb8d3c5dfaf81a387bf0ba439ab40e6343d2155fb4ddf6978a52d9b9ea8d0f8', 'U', NULL, 6, 'N'),
(11, 'user10', '์ํฌ', '5bbf1a9e0de062225a1bb7df8d8b3719591527b74950810f16b1a6bc6d7bd29b', 'U', NULL, 2, 'N'),
(12, 'user11', '์ ์ค๋ถ', '81115e31e22a5801b197750ec12d7a51ad693aa017ecc8bca033cbd500a928b6', 'U', NULL, 3, 'N'),
(13, 'user12', '์ต๋ฌด์ ', 'bd35283fe8fcfd77d7c05a8bf2adb85c773281927e12c9829c72a9462092f7c4', 'U', NULL, 4, 'N'),
(14, 'user13', '์์ถ', '1834e148b518a43a37e04a4e4fbcee1eb845de6ee5a3f04fe9fb749f9695be42', 'U', NULL, 5, 'N'),
(15, 'user14', '์ค์ธ์ฌ', 'daf7996f88742675acb3d0f85a8069d02fdf1c4dc2026de7f01a0ba7e65922fb', 'U', NULL, 6, 'N'),
(16, 'user15', '์ด์ธ๋ก', '2b8b66f64b605318593982b059a08dae101c0bdf5d8cb882a0891241a704f46c', 'U', NULL, 2, 'N'),
(17, 'user16', '์กฐํต', '4de4153595c0977d2389d0880547bd3aa60871e906ce52a26648d8ca0a157e5c', 'U', NULL, 3, 'N'),
(18, 'user17', 'ํฉ๋ณดํญ', '2a60ff641c890283b1d070f827cf9c0cce004769c2a2dc7136bc6d290477275c', 'U', NULL, 4, 'N'),
(19, 'user18', '์ด๋ด์ง', 'ebc835d1b43e63d1ba35af810da3a23e4f8a04cf680f1718c2fefb1ee77fcecf', 'U', NULL, 5, 'N'),
(20, 'user19', 'ํจ์', '0b6ecb3aa9b23589fb9e314b46c832d977e597228c1e358fcc564bd8ba733195', 'U', NULL, 6, 'N'),
(21, 'user20', '๊น๋ถ์', '7febe54e79096749ac43dc6c2e3e5d4dc768993d1f3102889257c9cab7934ec7', 'U', NULL, 2, 'N'),
(22, 'user21', '์ง๋', '8fab3a60577befd765cde83f2737cd1a9f25a72356c94052c2194e816829b331', 'U', NULL, 3, 'N'),
(23, 'user22', '์์ฒ', 'b999205cdacd2c4516598d99b420d29786443e9908556a65f583a6fd4765ee4a', 'U', NULL, 4, 'N'),
(24, 'user23', '์ด์ข
๋ฌด', '2a0fff6e36fbc6a21f7b065f24a3ffb40de209ea8cfc15d76cf786f74dd6f115', 'U', NULL, 5, 'N'),
(25, 'user24', '์ ๋ชฝ์ฃผ', '65303a0ec5984ab62d102031a5c9be89ca21812816af34a8e13c8104be240ab2', 'U', NULL, 6, 'N'),
(26, 'user25', '๋ฌธ์ต์ ', 'dab53605c85e2eff2f2192e08b772cbc06af317d217d09e161215901339300e0', 'U', NULL, 2, 'N'),
(27, 'user26', '์ต์ถฉ', '6356b9f65e6e775b3feb7996bd3e1ba3f20c83366e4aec56f4f3979a0cfd75f5', 'U', NULL, 3, 'N'),
(28, 'user27', '์ผ์ฐ', '590b1a8287729e75223a77d4f64fb13dd1bc1819f4e185fe37f81b97e436edbc', 'U', NULL, 4, 'N'),
(29, 'user28', '์ต์', 'fdc86230e908634cb03015f1a016ffa16f1cd9eac9003b51fcd1c13abb799c06', 'U', NULL, 5, 'N'),
(30, 'user29', 'ํฉํฌ', 'df3c4035da126a48f484133358bedf2306c403af75347c8420a96e461d1709ad', 'U', NULL, 6, 'N'),
(31, 'user30', '๋งน์ฌ์ฑ', '601fbd496628a2a8ad6186af757273b116d9f2a7d666145827c68e0bef1ccd13', 'U', NULL, 2, 'N'),
(32, 'user31', '์ฅ์์ค', '4ccb2f3b57e6de1caea8475b13fb5c968a766f78c3004034f07704ae5fd3e5dd', 'U', NULL, 3, 'N'),
(33, 'user32', '์ ์์ฃผ', '54a2979a455bec056285887a8137d1bfe6cbfd229e558ea4d28cd67cf81ed38e', 'U', NULL, 4, 'N'),
(34, 'user33', 'ํ๋ช
ํ', 'f81e0105e6dcdf3f2e2041d119d1c87b9e66a73f8d0007d2dc505595b20d9809', 'U', NULL, 5, 'N'),
(35, 'user34', '์ด์จ๊ณก', '4d4ec9499ab2bce1c5c8a565004ac27d90a593a360e79bc237b917b43d34c44d', 'U', NULL, 6, 'N'),
(36, 'user35', '์ดํด๊ณ', '3dd5329b7396fda1de5878a24ab7ca98cd47351bcbfb37138565a30771da1590', 'U', NULL, 2, 'N'),
(37, 'user36', '์ ์ฌ์๋น', '06f01542cd526fcfd7624cf9fca3e0e3899e25a9e84da65d3b8cb5ac200dda1f', 'U', NULL, 3, 'N'),
(38, 'user37', '๊ณฝ์ฌ์ฐ', '9c10f9996d42387555f8008224c0b8ffcedd501108b9f6ac1159ecd87bb9f6c3', 'U', NULL, 4, 'N'),
(39, 'user38', '์กฐํ', '85a20bcfad4e8153d5fd624c87ed0ae685d3f70595aaeb561b5228dfbda71f51', 'U', NULL, 5, 'N'),
(40, 'user39', '๊น์๋ฏผ', 'dd69a400ddf28026fe94595eafadd0d1d7163301162a17e3cf7b36115d02e693', 'U', NULL, 6, 'N'),
(41, 'user40', '์ด์์ ', '39a6bd68eee930e937ba05904fd4379444bb6f33c45232d93844788da336c4ee', 'U', NULL, 2, 'N'),
(42, 'user41', '์ฑ์ผ๋ฌธ', 'ce063ef25241f49ef0adef10d7c2ba9108df3aca630b7f03f160d41a7e198c8e', 'U', NULL, 3, 'N'),
(43, 'user42', '๋ฐํฝ๋
', 'fb44d98b9d56bbe49028eacc8574f5715178e6d3470d276a1697de3df68e7579', 'U', NULL, 4, 'N'),
(44, 'user43', 'ํ์์ง', 'f02916fe22baf673a04bc322efd5efc188fa45a378d47c2fd9effaa2952b33ae', 'U', NULL, 5, 'N'),
(45, 'user44', '์ด๊ฐ', '0d28f6929860381621e417f808a811e85d60442aa7d29b69a6302d8d2321c57b', 'U', NULL, 6, 'N'),
(46, 'user45', '์ ์๋ถ', '435fa81d2e3e34b76e40154d878de9f7df8bdc18429d7321f14cd3cb906766a1', 'U', NULL, 2, 'N'),
(47, 'user46', '์ ์ฑ์', '47a268f40a503fc100a1b3ab3413d241c1861f37228761dd2198a94fc6d06811', 'U', NULL, 3, 'N'),
(48, 'user47', '๊น์์ต', '8a43bbd15dc9d40eb8556bc68608a3beb80a3f6903a1c55c1c1686151ea7c50c', 'U', NULL, 4, 'N'),
(49, 'user48', '์ํธ', '70df126f7888b99fd00f45feae219ac1b75c09ae67f84dcf9ecc2d45d54e9f37', 'U', NULL, 5, 'N'),
(50, 'user49', '์ด๋งน์ ', '62752906d749b398b283bb8faa750cc4f0c40e69bef872c80580fa4ff71d65fe', 'U', NULL, 6, 'N'),
(51, 'user50', '์กฐ๋ ค', '59ea123c0d70b150939706c1ed9822e76f87a73d159a4a67792924a85c6f92bb', 'U', NULL, 2, 'N'),
(52, 'user51', '์ฑ๋ด์', '120ab541bb461227b08dbca747bf864427dd25db286e920834f1428d89847617', 'U', NULL, 3, 'N'),
(53, 'user52', '๋จํจ์จ', '24a1b3b47863af96bc133341991d6bdbc21ab12557facbd02fb9c56ec6ec1dcc', 'U', NULL, 4, 'N'),
(54, 'user53', '๋
ผ๊ฐ', '98e98b7a251f18aac9d33b2b5281b561381d478afc594a7d0d4a793fc40b7ced', 'U', NULL, 5, 'N'),
(55, 'user54', '๊ถ์จ', 'f1240fdecd4f7290aaf18e01de8b5818f83d40581295d97ea6864c215797b160', 'U', NULL, 6, 'N'),
(56, 'user55', 'ํ๊ธธ๋', '8d74ee260a93cb1f5a340b66b8fca9a7650de10a3771965705804634c8e0c857', 'U', NULL, 2, 'N'),
(57, 'user56', '์๊บฝ์ ', '3d0273794c791b208eb8f2a1172f8052e476570f79db889c0c19cd79f17a73ab', 'U', NULL, 3, 'N'),
(58, 'user57', 'ํ์ตํ', 'a36931dd2a776f1ad77068a410260c6d7e9eca6640fd47e25a6cfca1423a9926', 'U', NULL, 4, 'N'),
(59, 'user58', '์ค์ง', 'ce364c858b36c7b91dd83d8664055e7cb5eae7cacacba674e66f208488c0af6e', 'U', NULL, 5, 'N'),
(60, 'user59', '์ค๋ฌ์ ', '02dbbc8a7483ed7ef37e34cb6bf3c41c0851721b7a4cc90eb84164baf81d9399', 'U', NULL, 6, 'N'),
(61, 'user60', '๋ฐ๋ฌธ์', 'f4b7e0d1f9fa0594a13aedbaee5599f65e69e1e7562537ddd443404c791bd927', 'U', NULL, 2, 'N'),
(62, 'user61', 'ํ์๋ด', '714556c2e812784d374c4a64fe487de33d637e393f29672e8cb96d6152c016f4', 'U', NULL, 3, 'N'),
(63, 'user62', '๊นํ๋', '56dfcd67f783fe26b80e6a58a3f5afc7aaad511adfd967bee23afb378e9a0472', 'U', NULL, 4, 'N'),
(64, 'user63', '๊น๋ณ์ฐ', 'd4e146fb59c16dccc05a72f977b98f9040c4886592c17cda83a428c61486d216', 'U', NULL, 5, 'N'),
(65, 'user64', '๊น์ ํธ', 'dd6d3ece19671acfc0d4b1e9541a33659bfdb59a3126f6bf483fda76eb81e864', 'U', NULL, 6, 'N'),
(66, 'user65', '์ ์ฝ์ฉ', '55014d30edc4478f9ea6b5c56baf0a0da1d3c98003ae8be9fa3d0c3529461300', 'U', NULL, 2, 'N'),
(67, 'user66', '์ ๋ด์ค', '611f51d44fd7c795ea1ff0bee188e0f4039e7f17b8b42378a07c10d3064923b0', 'U', NULL, 3, 'N'),
(68, 'user67', '๊น๋๊ฑด', '97cdd97cc8798a1a7377141eda51c21af0016be9d594729c8ee708672ce607b0', 'U', NULL, 4, 'N'),
(69, 'user68', 'ํฉ์ง์ด', '6e5acacca08fe171c57529438f3f14e6c67d5aa4cd4d3a024e30701653ae8ff0', 'U', NULL, 5, 'N'),
(70, 'user69', 'ํ๊ฒฝ๋', 'a36b4f42b54219a5dbb5c98680f23adb135b72cd48d34beed6b915ad3632494c', 'U', NULL, 6, 'N'),
(71, 'user70', '๊น์ฅ๊ท ', 'da08eac8478e4c85f16285f8e6acae04c4b1b337b60f0aea18b3607596611df0', 'U', NULL, 2, 'N'),
(72, 'user71', '์์ค๊ทผ', '407d3c1df7b982a9feef9b5c907371342b218502a191254241d5b573bed0fa6c', 'U', NULL, 3, 'N'),
(73, 'user72', '์ค๋์ฃผ', '2bc6ebdf1967fa1d0dd6f19e6812d0a2ad54eac41cc9b863711aafa4e1180278', 'U', NULL, 4, 'N'),
(74, 'user73', '์ง์์', '746465eb17f97008c05b4e0fdfb962c0808a901be5e9aca47426d48d0245b13a', 'U', NULL, 5, 'N'),
(75, 'user74', '์๋ณํฌ', '9de6a56e7c76c073625f401cc25dad0320bdbb5249f5c53bf6a8f5c8974a9ab0', 'U', NULL, 6, 'N'),
(76, 'user75', '์ ๊ด์', 'cd8cbd30586fb98f2901e0b702b6e7c2ef4278fac2dc304fa36394ab68101a5b', 'U', NULL, 2, 'N'),
(77, 'user76', '์์ฐฝํธ', '023736a413a16146837bb207159639c81b0c680e22e0d0c123c06f81241ef214', 'U', NULL, 3, 'N'),
(78, 'user77', '๋ฐฉ์ ํ', '361c39697ce48d431423460a3854b229f41550a97db935f21a84f4c5f3dce61c', 'U', NULL, 4, 'N'),
(79, 'user78', '๊น๋ํ', '706be5e3c19ac35208c6ca79238f197cd0df048bb07ecb6aacb1e5008481baaa', 'U', NULL, 5, 'N'),
(80, 'user79', '์ด์', 'bbee94b7e5bc646a4030556612871e939251a7fc5eaef785eafdae12c2ecc939', 'U', NULL, 6, 'N'),
(81, 'user80', '์ด์ค์ญ', 'eb9c5e78498aa74b123eddf29c801ae7e9d636e39a3cc34d3c46abad28342e2c', 'U', NULL, 2, 'N');
ALTER TABLE COM_USER ADD (USERPOS VARCHAR(2) NULL COMMENT '์ง์');
UPDATE COM_USER SET USERPOS='01';
UPDATE COM_USER SET USERPOS='02' WHERE USERNO BETWEEN 60 AND 59;
UPDATE COM_USER SET USERPOS='03' WHERE USERNO BETWEEN 40 AND 49;
UPDATE COM_USER SET USERPOS='04' WHERE USERNO BETWEEN 30 AND 39;
UPDATE COM_USER SET USERPOS='05' WHERE USERNO BETWEEN 20 AND 29;
UPDATE COM_USER SET USERPOS='06' WHERE USERNO BETWEEN 10 AND 19;
UPDATE COM_USER SET USERPOS='07' WHERE USERNO < 10;
INSERT INTO `tbl_board` (`BGNO`, `BRDNO`, `BRDTITLE`, `USERNO`, `BRDMEMO`, `BRDDATE`, `LASTDATE`, `LASTUSERNO`, `BRDDELETEFLAG`) VALUES
(3, 2, '๋ชจ๋ฐ์ผ ์น ์ฌ์ดํธ ์ ์ ๋ฐ ํ๋ก๊ทธ๋๋ฐ', 11, '๋ชจ๋ฐ์ผ ์น ์ฌ์ดํธ ์ ์ ๋ฐ ํ๋ก๊ทธ๋๋ฐ', now(), now(), 11, 'N'),
(3, 3, '์ธ์์ ์๋๋ฅผ ๋ฐ๋ผ์ก๊ณ ์ถ๋ค๋ฉด DO IT(HTML5 CSS3)', 15, '์ธ์์ ์๋๋ฅผ ๋ฐ๋ผ์ก๊ณ ์ถ๋ค๋ฉด DO IT(HTML5 CSS3)', now(), now(), 15, 'N'),
(3, 4, '๋ง์์ ์์ง์ด๋ ์ฝํ
์ธ ๋์์ธ', 44, '๋ง์์ ์์ง์ด๋ ์ฝํ
์ธ ๋์์ธ', now(), now(), 44, 'N'),
(3, 5, 'ํ์ํ ๋๋ง๋ค ๊ณจ๋ผ์ฐ๋ ํ๋ ์ ํ
์ด์
๋์์ธ 100', 13, 'ํ์ํ ๋๋ง๋ค ๊ณจ๋ผ์ฐ๋ ํ๋ ์ ํ
์ด์
๋์์ธ 100', now(), now(), 13, 'N'),
(3, 6, '์๋๋ก์ด๋ ์ฑ ๊ฐ๋ฐ ์๋ฒฝ ๊ฐ์ด๋', 15, '์๋๋ก์ด๋ ์ฑ ๊ฐ๋ฐ ์๋ฒฝ ๊ฐ์ด๋', now(), now(), 15, 'N'),
(3, 7, '๊ฐ์น๊ด ๊ฒฝ์', 36, '๊ฐ์น๊ด ๊ฒฝ์', now(), now(), 36, 'N'),
(3, 8, 'Ext JS ์น ์ ํ๋ฆฌ์ผ์ด์
๊ฐ๋ฐ', 55, 'Ext JS ์น ์ ํ๋ฆฌ์ผ์ด์
๊ฐ๋ฐ', now(), now(), 55, 'N'),
(3, 9, 'ํ๋ง ์ฝ๋', 6, 'ํ๋ง ์ฝ๋', now(), now(), 6, 'N'),
(3, 10, '๊ณ ๊ธ ์น ํ์ค ์ฌ์ดํธ์ ์์ ์ํ CSS ๋ง์คํฐ ์ ๋ต', 29, '๊ณ ๊ธ ์น ํ์ค ์ฌ์ดํธ์ ์์ ์ํ CSS ๋ง์คํฐ ์ ๋ต', now(), now(), 29, 'N'),
(3, 11, 'DB๋๋ผ-๋๋ DB๋ค', 44, 'DB๋๋ผ-๋๋ DB๋ค', now(), now(), 44, 'N'),
(3, 12, 'HTML5 Canvas', 53, 'HTML5 Canvas', now(), now(), 53, 'N'),
(3, 13, 'Javascript Graphics', 53, 'Javascript Graphics', now(), now(), 53, 'N'),
(3, 14, '๋ฃจ์ฌ ์ธ ์ก์
- ์คํ์์ค ์๋ฐ ๊ฒ์์์ง', 24, '๋ฃจ์ฌ ์ธ ์ก์
- ์คํ์์ค ์๋ฐ ๊ฒ์์์ง', now(), now(), 24, 'N'),
(3, 15, 'Jquery in action', 44, 'Jquery in action', now(), now(), 44, 'N'),
(3, 16, 'Jquery 1.7 ์๊ณ ๊ฐ๋ ฅํ ์๋ฐ์คํฌ๋ฆฝํธ', 66, 'Jquery 1.7 ์๊ณ ๊ฐ๋ ฅํ ์๋ฐ์คํฌ๋ฆฝํธ', now(), now(), 66, 'N'),
(3, 17, 'ํ๋ก ์คํ๋ง3', 37, 'ํ๋ก ์คํ๋ง3', now(), now(), 37, 'N'),
(3, 18, '์คํธ๋ฟ์ธ 2 ํ๋ก๊ทธ๋๋ฐ', 68, '์คํธ๋ฟ์ธ 2 ํ๋ก๊ทธ๋๋ฐ', now(), now(), 68, 'N'),
(3, 19, '์คํธ๋ฟ์ธ 2 ์ค๋ฌด ํ๋ก๊ทธ๋๋ฐ', 69, '์คํธ๋ฟ์ธ 2 ์ค๋ฌด ํ๋ก๊ทธ๋๋ฐ', now(), now(), 69, 'N'),
(3, 20, 'CSS ๋น๋ฐ ๋งค๋ด์ผ(๊ฐ์ถ๊ณ ์ถ์ ๋๋ง์ ๋น๋ฐ ๋
ธํธ) ', 62, 'CSS ๋น๋ฐ ๋งค๋ด์ผ(๊ฐ์ถ๊ณ ์ถ์ ๋๋ง์ ๋น๋ฐ ๋
ธํธ) ', now(), now(), 62, 'N'),
(3, 21, 'Ext JS 4 First look ํ๊ตญ์ดํ/ํ๋ คํ ์น ์ ํ๋ฆฌ์ผ์ด์
์ ์ํ Ext JS ์
๋ฌธ', 20, 'Ext JS 4 First look ํ๊ตญ์ดํ/ํ๋ คํ ์น ์ ํ๋ฆฌ์ผ์ด์
์ ์ํ Ext JS ์
๋ฌธ', now(), now(), 20, 'N'),
(3, 22, 'SQL ์ ๋ฌธ๊ฐ ๊ฐ์ด๋', 77, 'SQL ์ ๋ฌธ๊ฐ ๊ฐ์ด๋', now(), now(), 77, 'N'),
(3, 23, '์ฑ์ฅ์ ์ ์ CRS ๊ธฐ์
์ ์ง์ ์ฑ์ฅ์ ์ํ ํต์ฌ ๊ฒฝ์ ์ ๋ต', 3, '์ฑ์ฅ์ ์ ์ CRS ๊ธฐ์
์ ์ง์ ์ฑ์ฅ์ ์ํ ํต์ฌ ๊ฒฝ์ ์ ๋ต', now(), now(), 3, 'N'),
(3, 24, '์ค์ ํ๋ก์ ํธ ๊ด๋ฆฌ๋ฅผ ์ํ MS Project 2010 ', 27, '์ค์ ํ๋ก์ ํธ ๊ด๋ฆฌ๋ฅผ ์ํ MS Project 2010 ', now(), now(), 27, 'N'),
(3, 25, '์๋ํ๋ ์ค ์ ๋๋ก ํ๊ธฐ', 45, '์๋ํ๋ ์ค ์ ๋๋ก ํ๊ธฐ', now(), now(), 45, 'N'),
(3, 26, 'ํด๋ผ์ฐ๋ ์ปดํจํ
๊ตฌํ ๊ธฐ์ : ๊ตฌ๊ธ, ํ์ด์ค๋ถ, ์ผํ, ์๋ง์กด์ด ์ฑํํ ํต์ฌ ๊ธฐ์ ํํค์น๊ธฐ', 64, 'ํด๋ผ์ฐ๋ ์ปดํจํ
๊ตฌํ ๊ธฐ์ : ๊ตฌ๊ธ, ํ์ด์ค๋ถ, ์ผํ, ์๋ง์กด์ด ์ฑํํ ํต์ฌ ๊ธฐ์ ํํค์น๊ธฐ', now(), now(), 64, 'N'),
(3, 27, 'Real MySQL: ๊ฐ๋ฐ์์ DBA๋ฅผ ์ํ', 25, 'Real MySQL: ๊ฐ๋ฐ์์ DBA๋ฅผ ์ํ', now(), now(), 25, 'N'),
(3, 28, '์คํ๋ง4 ํ๋ก๊ทธ๋๋ฐ(Getting started with Spring Framework)', 15, '์คํ๋ง4 ํ๋ก๊ทธ๋๋ฐ(Getting started with Spring Framework)', now(), now(), 15, 'N'),
(3, 29, '์น ํผํฌ๋จผ์ค ๋ชจ๋ํฐ๋ง๊ณผ ๋๋ฒ๊น
', 80, '์น ํผํฌ๋จผ์ค ๋ชจ๋ํฐ๋ง๊ณผ ๋๋ฒ๊น
', now(), now(), 80, 'N'),
(3, 30, '์ํ์น Solr 4 ๊ตฌ์ถ๊ณผ ๊ด๋ฆฌ(๋ฃจ์ฌ ๊ฒ์ ํ๋ซํผ)', 31, '์ํ์น Solr 4 ๊ตฌ์ถ๊ณผ ๊ด๋ฆฌ(๋ฃจ์ฌ ๊ฒ์ ํ๋ซํผ)', now(), now(), 31, 'N'),
(3, 31, '2015 ์๊ธฐ์ฌ์ด ์ ๋ณด๋ณด์ ๊ธฐ์ฌ ํ๊ธฐ', 78, '2015 ์๊ธฐ์ฌ์ด ์ ๋ณด๋ณด์ ๊ธฐ์ฌ ํ๊ธฐ', now(), now(), 78, 'N'),
(3, 32, '2016 ์๊ธฐ์ฌ์ด ์ ๋ณด๋ณด์ ๊ธฐ์ฌ ์ค๊ธฐ', 54, '2016 ์๊ธฐ์ฌ์ด ์ ๋ณด๋ณด์ ๊ธฐ์ฌ ์ค๊ธฐ', now(), now(), 54, 'N'),
(3, 33, 'Apache Jmeter', 37, 'Apache Jmeter', now(), now(), 37, 'N'),
(3, 34, '์ฝ๋ ํ์ง ์๊ฐํ์ ์ ์', 24, '์ฝ๋ ํ์ง ์๊ฐํ์ ์ ์', now(), now(), 24, 'N'),
(3, 35, 'RabbitMQ ๋ฐ๋ผ์ก๊ธฐ : AMQP ๊ธฐ๋ฐ์ ์คํ์์ค ๋ฉ์์ง ๋ธ๋ก์ปค ', 10, 'RabbitMQ ๋ฐ๋ผ์ก๊ธฐ : AMQP ๊ธฐ๋ฐ์ ์คํ์์ค ๋ฉ์์ง ๋ธ๋ก์ปค ', now(), now(), 10, 'N'),
(3, 36, 'Hyper-V๋ฅผ ๋ค๋ฃจ๋ ๊ธฐ์ ', 59, 'Hyper-V๋ฅผ ๋ค๋ฃจ๋ ๊ธฐ์ ', now(), now(), 59, 'N'),
(3, 37, '์๋์ฐ ์๋ฒ 2012 R2', 24, '์๋์ฐ ์๋ฒ 2012 R2', now(), now(), 24, 'N'),
(3, 38, '๊ฑฐ์นจ์์ด ๋ฐฐ์ฐ๋ Jboss', 24, '๊ฑฐ์นจ์์ด ๋ฐฐ์ฐ๋ Jboss', now(), now(), 24, 'N');
CALL MAKECALENDAR();