6 -- * LICENSE: This source file is licensed under the terms of the GNU General Public License.
\r
8 -- * @package Magic3 Framework
\r
9 -- * @author 平田直毅(Naoki Hirata) <naoki@aplo.co.jp>
\r
10 -- * @copyright Copyright 2006-2012 Magic3 Project.
\r
11 -- * @license http://www.gnu.org/copyleft/gpl.html GPL License
\r
12 -- * @version SVN: $Id: 2012121101_to_2013010901.sql 5549 2013-01-14 12:34:27Z fishbone $
\r
13 -- * @link http://www.magic3.org
\r
15 -- --------------------------------------------------------------------------------------------------
\r
17 -- --------------------------------------------------------------------------------------------------
\r
19 -- *** システムベーステーブル ***
\r
21 ALTER TABLE content ADD cn_regist_dt TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL; -- 登録日時
\r
24 DELETE FROM _language_string WHERE ls_type = 10;
\r
25 INSERT INTO _language_string
\r
26 (ls_type, ls_id, ls_language_id, ls_value, ls_description) VALUES
\r
27 (10, 'COM_CONTENT_CREATED_DATE_ON', 'ja', '作成日:%s', ''),
\r
28 (10, 'COM_CONTENT_LAST_UPDATED', 'ja', '更新日:%s', ''),
\r
29 (10, 'COM_CONTENT_PUBLISHED_DATE_ON', 'ja', '公開日:%s', ''),
\r
30 (10, 'COM_CONTENT_WRITTEN_BY', 'ja', '作者:%s', ''),
\r
31 (10, 'COM_CONTENT_CATEGORY', 'ja', 'カテゴリー:%s', ''),
\r
32 (10, 'COM_CONTENT_ARTICLE_HITS', 'ja', 'アクセス数:%s', ''),
\r
33 (10, 'COM_CONTENT_READ_MORE_TITLE', 'ja', 'もっと読む', ''),
\r
34 (10, 'DATE_FORMAT_LC', 'ja', 'Y年Fd日(l)', ''),
\r
35 (10, 'DATE_FORMAT_LC1', 'ja', 'Y年Fd日(l)', ''),
\r
36 (10, 'DATE_FORMAT_LC2', 'ja', 'Y年Fd日(l)H:i', ''),
\r
37 (10, 'DATE_FORMAT_LC3', 'ja', 'Y年Fd日', ''),
\r
38 (10, 'DATE_FORMAT_LC4', 'ja', 'Y-m-d', ''),
\r
39 (10, 'DATE_FORMAT_JS1', 'ja', 'y-m-d', ''),
\r
40 (10, 'JANUARY_SHORT', 'ja', '1月', ''),
\r
41 (10, 'JANUARY', 'ja', '1月', ''),
\r
42 (10, 'FEBRUARY_SHORT', 'ja', '2月', ''),
\r
43 (10, 'FEBRUARY', 'ja', '2月', ''),
\r
44 (10, 'MARCH_SHORT', 'ja', '3月', ''),
\r
45 (10, 'MARCH', 'ja', '3月', ''),
\r
46 (10, 'APRIL_SHORT', 'ja', '4月', ''),
\r
47 (10, 'APRIL', 'ja', '4月', ''),
\r
48 (10, 'MAY_SHORT', 'ja', '5月', ''),
\r
49 (10, 'MAY', 'ja', '5月', ''),
\r
50 (10, 'JUNE_SHORT', 'ja', '6月', ''),
\r
51 (10, 'JUNE', 'ja', '6月', ''),
\r
52 (10, 'JULY_SHORT', 'ja', '7月', ''),
\r
53 (10, 'JULY', 'ja', '7月', ''),
\r
54 (10, 'AUGUST_SHORT', 'ja', '8月', ''),
\r
55 (10, 'AUGUST', 'ja', '8月', ''),
\r
56 (10, 'SEPTEMBER_SHORT', 'ja', '9月', ''),
\r
57 (10, 'SEPTEMBER', 'ja', '9月', ''),
\r
58 (10, 'OCTOBER_SHORT', 'ja', '10月', ''),
\r
59 (10, 'OCTOBER', 'ja', '10月', ''),
\r
60 (10, 'NOVEMBER_SHORT', 'ja', '11月', ''),
\r
61 (10, 'NOVEMBER', 'ja', '11月', ''),
\r
62 (10, 'DECEMBER_SHORT', 'ja', '12月', ''),
\r
63 (10, 'DECEMBER', 'ja', '12月', ''),
\r
64 (10, 'SUN', 'ja', '日', ''),
\r
65 (10, 'SUNDAY', 'ja', '日曜', ''),
\r
66 (10, 'MON', 'ja', '月', ''),
\r
67 (10, 'MONDAY', 'ja', '月曜', ''),
\r
68 (10, 'TUE', 'ja', '火', ''),
\r
69 (10, 'TUESDAY', 'ja', '火曜', ''),
\r
70 (10, 'WED', 'ja', '水', ''),
\r
71 (10, 'WEDNESDAY', 'ja', '水曜', ''),
\r
72 (10, 'THU', 'ja', '木', ''),
\r
73 (10, 'THURSDAY', 'ja', '木曜', ''),
\r
74 (10, 'FRI', 'ja', '金', ''),
\r
75 (10, 'FRIDAY', 'ja', '金曜', ''),
\r
76 (10, 'SAT', 'ja', '土', ''),
\r
77 (10, 'SATURDAY', 'ja', '土曜', ''),
\r
78 (10, 'LAST_UPDATED2', 'ja', '更新日 %s', '旧バージョン互換用'),
\r
79 (10, 'COM_CONTENT_CREATED_DATE_ON', 'en', 'Created: %s', ''),
\r
80 (10, 'COM_CONTENT_LAST_UPDATED', 'en', 'Last Updated: %s', ''),
\r
81 (10, 'COM_CONTENT_PUBLISHED_DATE_ON', 'en', 'Published: %s', ''),
\r
82 (10, 'COM_CONTENT_WRITTEN_BY', 'en', 'Written by %s', ''),
\r
83 (10, 'COM_CONTENT_CATEGORY', 'en', 'Category: %s', ''),
\r
84 (10, 'COM_CONTENT_ARTICLE_HITS', 'en', 'Hits: %s', ''),
\r
85 (10, 'COM_CONTENT_READ_MORE_TITLE', 'en', 'Read more...', ''),
\r
86 (10, 'DATE_FORMAT_LC', 'en', 'l, d F Y', ''),
\r
87 (10, 'DATE_FORMAT_LC1', 'en', 'l, d F Y', ''),
\r
88 (10, 'DATE_FORMAT_LC2', 'en', 'l, d F Y H:i', ''),
\r
89 (10, 'DATE_FORMAT_LC3', 'en', 'd F Y', ''),
\r
90 (10, 'DATE_FORMAT_LC4', 'en', 'Y-m-d', ''),
\r
91 (10, 'DATE_FORMAT_JS1', 'en', 'y-m-d', ''),
\r
92 (10, 'JANUARY_SHORT', 'en', 'Jan', ''),
\r
93 (10, 'JANUARY', 'en', 'January', ''),
\r
94 (10, 'FEBRUARY_SHORT', 'en', 'Feb', ''),
\r
95 (10, 'FEBRUARY', 'en', 'February', ''),
\r
96 (10, 'MARCH_SHORT', 'en', 'Mar', ''),
\r
97 (10, 'MARCH', 'en', 'March', ''),
\r
98 (10, 'APRIL_SHORT', 'en', 'Apr', ''),
\r
99 (10, 'APRIL', 'en', 'April', ''),
\r
100 (10, 'MAY_SHORT', 'en', 'May', ''),
\r
101 (10, 'MAY', 'en', 'May', ''),
\r
102 (10, 'JUNE_SHORT', 'en', 'Jun', ''),
\r
103 (10, 'JUNE', 'en', 'June', ''),
\r
104 (10, 'JULY_SHORT', 'en', 'Jul', ''),
\r
105 (10, 'JULY', 'en', 'July', ''),
\r
106 (10, 'AUGUST_SHORT', 'en', 'Aug', ''),
\r
107 (10, 'AUGUST', 'en', 'August', ''),
\r
108 (10, 'SEPTEMBER_SHORT', 'en', 'Sep', ''),
\r
109 (10, 'SEPTEMBER', 'en', 'September', ''),
\r
110 (10, 'OCTOBER_SHORT', 'en', 'Oct', ''),
\r
111 (10, 'OCTOBER', 'en', 'October', ''),
\r
112 (10, 'NOVEMBER_SHORT', 'en', 'Nov', ''),
\r
113 (10, 'NOVEMBER', 'en', 'November', ''),
\r
114 (10, 'DECEMBER_SHORT', 'en', 'Dec', ''),
\r
115 (10, 'DECEMBER', 'en', 'December', ''),
\r
116 (10, 'SUN', 'en', 'Sun', ''),
\r
117 (10, 'SUNDAY', 'en', 'Sunday', ''),
\r
118 (10, 'MON', 'en', 'Mon', ''),
\r
119 (10, 'MONDAY', 'en', 'Monday', ''),
\r
120 (10, 'TUE', 'en', 'Tue', ''),
\r
121 (10, 'TUESDAY', 'en', 'Tuesday', ''),
\r
122 (10, 'WED', 'en', 'Wed', ''),
\r
123 (10, 'WEDNESDAY', 'en', 'Wednesday', ''),
\r
124 (10, 'THU', 'en', 'Thu', ''),
\r
125 (10, 'THURSDAY', 'en', 'Thursday', ''),
\r
126 (10, 'FRI', 'en', 'Fri', ''),
\r
127 (10, 'FRIDAY', 'en', 'Friday', ''),
\r
128 (10, 'SAT', 'en', 'Sat', ''),
\r
129 (10, 'SATURDAY', 'en', 'Saturday', ''),
\r
130 (10, 'LAST_UPDATED2', 'en', 'Last Updated on %s', '旧バージョン互換用');
\r
133 -- *** システム標準テーブル ***
\r