1 CREATE TABLE `nucleus_actionlog` (
\r
2 `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
\r
3 `message` varchar(255) NOT NULL default ''
\r
6 CREATE TABLE `nucleus_ban` (
\r
7 `iprange` varchar(15) NOT NULL default '',
\r
8 `reason` varchar(255) NOT NULL default '',
\r
9 `blogid` int(11) NOT NULL default '0'
\r
12 CREATE TABLE `nucleus_blog` (
\r
13 `bnumber` int(11) NOT NULL auto_increment,
\r
14 `bname` varchar(60) NOT NULL default '',
\r
15 `bshortname` varchar(15) NOT NULL default '',
\r
16 `bdesc` varchar(200) default NULL,
\r
17 `bcomments` tinyint(2) NOT NULL default '1',
\r
18 `bmaxcomments` int(11) NOT NULL default '0',
\r
19 `btimeoffset` decimal(3,1) NOT NULL default '0.0',
\r
20 `bnotify` varchar(60) default NULL,
\r
21 `burl` varchar(100) default NULL,
\r
22 `bupdate` varchar(60) default NULL,
\r
23 `bdefskin` int(11) NOT NULL default '1',
\r
24 `bpublic` tinyint(2) NOT NULL default '1',
\r
25 `bsendping` tinyint(2) NOT NULL default '0',
\r
26 `bconvertbreaks` tinyint(2) NOT NULL default '1',
\r
27 `bdefcat` int(11) default NULL,
\r
28 `bnotifytype` int(11) NOT NULL default '15',
\r
29 `ballowpast` tinyint(2) NOT NULL default '0',
\r
30 `bincludesearch` tinyint(2) NOT NULL default '0',
\r
31 PRIMARY KEY (`bnumber`),
\r
32 UNIQUE KEY `bnumber` (`bnumber`),
\r
33 UNIQUE KEY `bshortname` (`bshortname`)
\r
36 INSERT INTO `nucleus_blog` VALUES (1, 'My Nucleus Weblog', 'myweblog', '', 1, 0, 0.0, '', 'http://localhost:8080/nucleus/', '', 1, 1, 0, 1, 1, 1, 1, 0);
\r
38 CREATE TABLE `nucleus_category` (
\r
39 `catid` int(11) NOT NULL auto_increment,
\r
40 `cblog` int(11) NOT NULL default '0',
\r
41 `cname` varchar(40) default NULL,
\r
42 `cdesc` varchar(200) default NULL,
\r
43 PRIMARY KEY (`catid`)
\r
46 INSERT INTO `nucleus_category` VALUES (1, 1, 'General', 'Items that do not fit in other categories');
\r
48 CREATE TABLE `nucleus_comment` (
\r
49 `cnumber` int(11) NOT NULL auto_increment,
\r
50 `cbody` text NOT NULL,
\r
51 `cuser` varchar(40) default NULL,
\r
52 `cmail` varchar(100) default NULL,
\r
53 `cmember` int(11) default NULL,
\r
54 `citem` int(11) NOT NULL default '0',
\r
55 `ctime` datetime NOT NULL default '0000-00-00 00:00:00',
\r
56 `chost` varchar(60) default NULL,
\r
57 `cip` varchar(15) NOT NULL default '',
\r
58 `cblog` int(11) NOT NULL default '0',
\r
59 PRIMARY KEY (`cnumber`),
\r
60 UNIQUE KEY `cnumber` (`cnumber`),
\r
61 KEY `citem` (`citem`),
\r
62 FULLTEXT KEY `cbody` (`cbody`)
\r
65 CREATE TABLE `nucleus_config` (
\r
66 `name` varchar(20) NOT NULL default '',
\r
67 `value` varchar(128) default NULL,
\r
68 PRIMARY KEY (`name`)
\r
71 INSERT INTO `nucleus_config` VALUES ('DefaultBlog', '1');
\r
72 INSERT INTO `nucleus_config` VALUES ('AdminEmail', 'example@example.org');
\r
73 INSERT INTO `nucleus_config` VALUES ('IndexURL', 'http://localhost:8080/nucleus/');
\r
74 INSERT INTO `nucleus_config` VALUES ('Language', 'japanese-utf8');
\r
75 INSERT INTO `nucleus_config` VALUES ('SessionCookie', '');
\r
76 INSERT INTO `nucleus_config` VALUES ('AllowMemberCreate', '');
\r
77 INSERT INTO `nucleus_config` VALUES ('AllowMemberMail', '1');
\r
78 INSERT INTO `nucleus_config` VALUES ('SiteName', 'My Nucleus Weblog');
\r
79 INSERT INTO `nucleus_config` VALUES ('AdminURL', 'http://localhost:8080/nucleus/nucleus/');
\r
80 INSERT INTO `nucleus_config` VALUES ('NewMemberCanLogon', '1');
\r
81 INSERT INTO `nucleus_config` VALUES ('DisableSite', '');
\r
82 INSERT INTO `nucleus_config` VALUES ('DisableSiteURL', 'http://www.this-page-intentionally-left-blank.org/');
\r
83 INSERT INTO `nucleus_config` VALUES ('LastVisit', '');
\r
84 INSERT INTO `nucleus_config` VALUES ('MediaURL', 'http://localhost:8080/nucleus/media/');
\r
85 INSERT INTO `nucleus_config` VALUES ('AllowedTypes', 'jpg,jpeg,gif,mpg,mpeg,avi,mov,mp3,swf,png');
\r
86 INSERT INTO `nucleus_config` VALUES ('AllowLoginEdit', '');
\r
87 INSERT INTO `nucleus_config` VALUES ('AllowUpload', '1');
\r
88 INSERT INTO `nucleus_config` VALUES ('DisableJsTools', '2');
\r
89 INSERT INTO `nucleus_config` VALUES ('CookiePath', '/');
\r
90 INSERT INTO `nucleus_config` VALUES ('CookieDomain', '');
\r
91 INSERT INTO `nucleus_config` VALUES ('CookieSecure', '');
\r
92 INSERT INTO `nucleus_config` VALUES ('MediaPrefix', '1');
\r
93 INSERT INTO `nucleus_config` VALUES ('MaxUploadSize', '1048576');
\r
94 INSERT INTO `nucleus_config` VALUES ('NonmemberMail', '');
\r
95 INSERT INTO `nucleus_config` VALUES ('PluginURL', 'http://localhost:8080/plugins/');
\r
96 INSERT INTO `nucleus_config` VALUES ('ProtectMemNames', '1');
\r
97 INSERT INTO `nucleus_config` VALUES ('BaseSkin', '1');
\r
98 INSERT INTO `nucleus_config` VALUES ('SkinsURL', 'http://localhost:8080/nucleus/skins/');
\r
99 INSERT INTO `nucleus_config` VALUES ('ActionURL', 'http://localhost:8080/nucleus/action.php');
\r
100 INSERT INTO `nucleus_config` VALUES ('URLMode', 'normal');
\r
101 INSERT INTO `nucleus_config` VALUES ('DatabaseVersion', '310');
\r
103 CREATE TABLE `nucleus_item` (
\r
104 `inumber` int(11) NOT NULL auto_increment,
\r
105 `ititle` varchar(160) default NULL,
\r
106 `ibody` text NOT NULL,
\r
108 `iblog` int(11) NOT NULL default '0',
\r
109 `iauthor` int(11) NOT NULL default '0',
\r
110 `itime` datetime NOT NULL default '0000-00-00 00:00:00',
\r
111 `iclosed` tinyint(2) NOT NULL default '0',
\r
112 `idraft` tinyint(2) NOT NULL default '0',
\r
113 `ikarmapos` int(11) NOT NULL default '0',
\r
114 `icat` int(11) default NULL,
\r
115 `ikarmaneg` int(11) NOT NULL default '0',
\r
116 PRIMARY KEY (`inumber`),
\r
117 UNIQUE KEY `inumber` (`inumber`),
\r
118 KEY `itime` (`itime`),
\r
119 FULLTEXT KEY `ibody` (`ibody`,`ititle`,`imore`)
\r
120 ) TYPE=MyISAM PACK_KEYS=0;
\r
122 INSERT INTO `nucleus_item` VALUES (1, 'Nucleus バージョン3.15へようこそ', 'ウェブページの作成を補助する積み木がここにあります。それは心躍るblogになるかもしれませんし、観るものを和ませる家族のページになるかもしれませんし、実り多き趣味のサイトになるかもしれません。あるいは現在のあなたには想像がつかないものになることだってあるでしょう。<br />\r\n<br />\r\n用途が思いつきませんでしたか? それならここへ来て正解です、なぜならあなた同様私たちにもわからないのですから。', '<b>Read Me</b><br />\r\n<br />\r\nこれはサイトにおける最初のエントリーです。スタートを切りやすいように、リンクと情報を入れておきました。<br />\r\n<br />\r\nこの記事を削除することもできますが、どちらにせよ記事を追加していくことによってやがてメインページからは見えなくなります。Nucleusを扱ううちに生じたメモをコメントとして追加し、将来アクセスできるようにこのページをブックマークしておくのも手です。<br />\r\n<br />\r\n<b>リンク</b><br />\r\n<br />\r\nNucleus CMSの<a href="http://nucleuscms.org">本家</a>と<a href="http://japan.nucleuscms.org">日本語公式</a>ページ。<br />\r\n<br />\r\nNucleus CMSのSourceForge<a href="http://sourceforge.net/projects/nucleuscms/">プロジェクト</a>ページ。<br />\r\n<br />\r\nNucleus CMSのプラグイン<a href="http://wakka.xiffy.nl/Plugin/">倉庫</a>と<a href="http://japan.nucleuscms.org/wakka/CategorizedPlugin">日本語のリスト</a>ページ。<br />\r\n<br />\r\n<b>ドキュメント - <a href="http://docs.nucleuscms.org/">docs.nucleuscms.org</a></b><br />\r\n<br />\r\nNucleusの<a href="http://japan.nucleuscms.org/faq.php">FAQ(よくある質問集)</a>(<a href="http://nucleuscms.org/faq.php">原文</a>)ページ。<br />\r\n<br />\r\nインストール方法等は<a href="nucleus/documentation/">ユーザー向け</a>と<a href="nucleus/documentation/devdocs/">開発者向け</a>文書がファイルに含まれています。<br />\r\n<br />\r\nポップアップ<a href="./nucleus/documentation/help.html">ヘルプ</a>が管理エリアのいたるところにあり、サイトのカスタマイズやデザインを手助けしてくれることでしょう。<br />\r\n<br />\r\n一度用意されているドキュメントに目を通したら、<a href="http://wiki.nucleuscms.org/">Wiki</a>(<a href="http://japan.nucleuscms.org/wakka/Nucleus">日本版</a>)を訪れてください。ユーザーの書いたハウツーや小技が掲載されています。<br />\r\n<br />\r\n<b>サポート</b><br />\r\n<br />\r\n<a href="http://forum.nucleuscms.org/">forum.nucleuscms.org</a>(本家)<br />\r\n<a href="http://japan.nucleuscms.org/bb/">japan.nucleuscms.org/bb/</a>(日本版)<br />\r\n<br />\r\n<a href="http://forum.nucleuscms.org/groupcp.php?g=3">moderators</a>とサポートフォーラムで活動する全てのボランティアに感謝します。<br />\r\n<br />\r\n- <a href="http://edmondhui.homeip.net/blog/">admun</a> - Ottawa, ON, Canada <br />\r\n- <a href="http://www.tamizhan.com/">anand</a> - Bangalore, India<br />\r\n- <a href="http://hcgtv.com">hcgtv</a> - Miami, Florida, USA<br />\r\n- <a href="http://www.adrenalinsports.nl/">ikeizer</a> - Maastricht<br />\r\n- <a href="http://www.tipos.com.br/">moraes</a> - Brazil<br />\r\n- <a href="http://roelg.nl/">roel </a>- The Netherlands<br />\r\n- <a href="http://budts.be/weblog/">TeRanEX </a>- Ekeren, Antwerp, Belgium<br />\r\n- <a href="http://www.trentadams.com/">Trent </a>- Alberta, Canada<br />\r\n- <a href="http://xiffy.nl/weblog/">xiffy </a>- Deventer<br />\r\n<br />\r\nもし手助けが必要なら、1400を超える登録ユーザーのいる私たちのフォーラムに参加してください。23,000を超える投稿された記事を検索できるようになっておりますので、求める答えに数回のクリックでたどり着けるかもしれません。<br />\r\n<br />\r\n<b>Personalization - <a href="http://skins.nucleuscms.org/">skins.nucleuscms.org</a></b><br />\r\n<br />\r\nマルチウェブログとスキン/テンプレートの組み合わせは強力な相乗効果を生み出します。個人的なサイト作成、友人や親戚あるいはクライアントに対するサイトデザインいずれに対してもです。<br />\r\n<br />\r\n636の登録された<a href="http://nucleuscms.org/sites.php">Nucleusで運用されているサイト</a>(<a href="http://japan.nucleuscms.org/sites.php">日本版</a>)の中から特色あるサイトをサンプルとしてご紹介します。<br />\r\n<br />\r\nThe Zen of Nucleus<br />\r\n- <a href="http://beefcake.nl/">beefcake.nl</a> - Beefcake | Nuke the whales!<br />\r\n- <a href="http://www.leng-lui.com//">leng-lui.com</a> - Leng-Lui.com - v7.0: "Memento"<br />\r\n<br />\r\nPersonal blogs<br />\r\n- <a href="http://bloggard.com/">bloggard.com</a> - The Adventures of Bloggard<br />\r\n- <a href="http://battleangel.org/">battleangel.org</a> - Giving meaning to the meaningless<br />\r\n- <a href="http://www.yetanotherblog.de/">yetanotherblog.de</a> - Yet Another Blog<br />\r\n<br />\r\nMulti user blogs<br />\r\n- <a href="http://tipos.com.br/">tipos.com.br</a> - Blogging community<br />\r\n<br />\r\nHobby, Travel and News sites<br />\r\n- <a href="http://adrenalinsports.nl/">adrenalinsports.nl</a> - Extreme sports<br />\r\n- <a href="http://hsbluebird.com/">hsbluebird.com</a> - Hot Springs, Montana''s Online Resource <br />\r\n- <a href="http://groningen-info.de/">groningen-info.de</a> - Neues aus Groningen. Fr Leute aus Duitsland.<br />\r\n- <a href="http://www.americandaily.com/">americandaily.com</a> - American Daily - Home<br />\r\n<br />\r\n<b>Nucleus Developer Network - <a href="http://dev.nucleuscms.org/">dev.nucleuscms.org</a></b><br />\r\n<br />\r\nThe NUDN is a hub for developer sites and programming resources.<br />\r\n<br />\r\nNUDN satellite sites, handles, location and UTC offset:<br />\r\n- <a href="http://karma.nucleuscms.org/">karma</a> - Izegem +02<br />\r\n- <a href="http://hcgtv.net/">hcgtv</a> - Miami -05<br />\r\n- <a href="http://edmondhui.homeip.net/blog/nudn.php">admun</a> - Ottawa -04<br />\r\n- <a href="http://dev.budts.be/nucleus/">TeRanEX</a> - Ekeren +02<br />\r\n<br />\r\nSourceforge.net graciously hosts our <a href="http://sourceforge.net/projects/nucleuscms/">CVS repository</a>.<br />\r\n<br />\r\nWant to play around or test changes, visit our demo site at <a href="http://demo.nucleuscms.org/">demo.nucleuscms.org</a>.<br />\r\n<br />\r\nNot sure what plugins to use, visit the <a href="http://showcase.trentadams.com/">showcase site</a> where you can see plugins at play in their native habitat.<br />\r\n<br />\r\nThen visit the plugin repository at <a href="http://plugins.nucleuscms.org/">plugins.nucleuscms.org</a> for download and installation instructions.<br />\r\n<br />\r\n<b>寄付者一覧</b><br />\r\n<br />\r\n以下の<a href="http://nucleuscms.org/donators.php">素晴らしい人々</a>による<a href="http://nucleuscms.org/donate.php">援助</a>感謝を捧げます。<em>ありがとう!</em><br />\r\n<br />\r\n- <a href="http://reddustrec.net/">dkex</a><br />\r\n- <a href="http://www.uncoverthenet.com/">Uncover the Net</a><br />\r\n- <a href="http://www.webatlas.org/">Web Atlas</a><br />\r\n- <a href="http://www.ipnlighting.com/">IPN Lighting</a><br />\r\n- <a href="http://blog.datoka.jp/">Yu (blog.datoka.jp)</a><br />\r\n- <a href="http://www.thegadgetreview.com/">Sony Gadgets and Reviews</a><br />\r\n- <a href="http://sites.proliphus.com/blueZhift/blog/">Thomas McKibben</a><br />\r\n- <a href="http://cheapweb.us/">CheapWeb.us</a><br />\r\n- Robert Seyfriedsberger<br />\r\n- <a href="http://www.toxicologie.nl/">Toxicologie.nl</a><br />\r\n- Gordon Shum<br />\r\n- <a href="http://www.subsim.com/">Neal Stevens</a><br />\r\n- <a href="http://www.GamblingHelper.com/">GamblingHelper</a><br />\r\n- Oliver Kirstein<br />\r\n- <a href="http://www.dominiek.be/">Dominiek</a><br />\r\n- <a href="http://www.aardschok.net/">Aardschok</a><br />\r\n- <a href="http://www.nieuwevoordeur.be/">nieuwevoordeur.be</a><br />\r\n- <a href="http://www.scene24.net/">Scene24</a><br />\r\n- <a href="http://www.eug.be/">Eug''s Weblog</a><br />\r\n- <a href="http://www.bloggard.com/">The Adventures of Bloggard</a><br />\r\n- <a href="http://www.voltos.com/">Arthur Cronos from Voltos</a><br />\r\n- <a href="http://www.webmaster-toolkit.com/">Free Webmaster Tools and Resources</a><br />\r\n- <a href="http://www.domilog.be/">Domi''s Weblog</a><br />\r\n- Infodoma <br />\r\n- <a href="http://carvingcode.com/">carvingCode.com</a><br />\r\n- <a href="http://www.traweb.com/">Traweb</a><br />\r\n- <a href="http://gene.mm2u.com/">Gene''s MoBlog</a><br />\r\n- <a href="http://interfacethis.com/">InterfaceThis</a><br />\r\n- <a href="http://www.thefinsters.com/flog/">The Finster Log</a><br />\r\n- <a href="http://www.mrhop.com/">Hop Nguyen</a><br />\r\n- <a href="http://www.zwavel.com/~zwavelaars" title="Zwavelaars">Zwavelaars</a><br />\r\n- <a href="http://beefcake.nl/">Joaquin Scholten</a> <br />\r\n- <a href="http://www.roelgroeneveld.com/">Roel Groeneveld</a><br />\r\n- <a href="http://lvb.net/">LVBlog</a><br />\r\n- <a href="http://xandermol.com/">Xander Mol</a><br />\r\n- Danilo Massa<br />\r\n- <a href="http://01FTP.com/">01FTP.com</a><br />\r\n- <a href="http://www.adrenalinsports.nl/">Irmo Keizer</a><br />\r\n- <a href="http://www.jasonkrogh.com/">Jason Krogh</a><br />\r\n- <a href="http://www.higuchi.com/">Osamu Higuchi</a><br />\r\n- <a href="http://www.trentadams.com/">Trent Adams</a><br />\r\n- <a href="http://www.ppcw.net/">Arne Hess</a><br />\r\n- <a href="http://hsbluebird.com/">The Bluebird</a><br />\r\n- Rainer Bickel<br />\r\n- Fritz Elfers<br />\r\n- <a href="http://www.european-wall-tapestries.com/">European Wall Tapestries</a><br />\r\n- <a href="http://www.jamier.net/">Jamie R. Rytlewski</a><br />\r\n- Madolyn Piper<br />\r\n- <a href="http://www.batteryvalues.com/">Battery Values</a><br />\r\n- <a href="http://www.mixburnrip.de/">Janko Roettgers</a><br />\r\n- Lukas Loesche<br />\r\n- <a href="http://www.seobook.com/">SEO Book</a><br />\r\n- <a href="http://www.brandweerdematen.nl/">Brandweer de Maten</a><br />\r\n- Andy Fuchs<br />\r\n- <a href="http://www.sumoforce.com/">Sumoforce</a><br />\r\n- <a href="http://love.silverindigo.com/">Al''ky''mie</a><br />\r\n- <a href="http://www.pejo.us/">Peter Johnson</a><br />\r\n- <a href="http://www.triv.nl/">TriV Internet Solutions</a><br />\r\n- <a href="http://www.torontomusicians.org/nucleus/">Margaret Stowe</a><br />\r\n- <a href="http://www.zenkey.org/">zenkey dot org</a><br />\r\n- <a href="http://www.golb.org/">Blots of Info</a><br />\r\n- <a href="http://www.zonderpartij.be/">Rudi De Kerpel</a><br />\r\n- <a href="http://staylorx.com/">Steve Taylor</a><br />\r\n- <a href="http://lmhcave.com/">Malcolm Farnsworth</a><br />\r\n- Birgit Kellner<br />\r\n- <a href="http://www.tobiasly.com/">Toby Johnson</a><br />\r\n- <a href="http://www.kapingamarangi.be/">Kapingamarangi</a><br />\r\n- <a href="http://www.pallalink.net/">Pallalink</a><br />\r\n- <a href="http://publiustx.net/">PubliusTX Weblog</a><br />\r\n- <a href="http://www.reductioadabsurdum.net/">Reductio Ad Absurdum</a><br />\r\n- <a href="http://www.gagaweb.org/">GagaWeb</a><br />\r\n- <a href="http://www.videokid.be/">Videokid</a><br />\r\n- Jon Marr<br />\r\n- <a href="http://www.docblog.org/">Luigi Cristiano</a><br />\r\n- J Keith Lehman<br />\r\n- Bohemian Cachet<br />\r\n- Jesus Mourazos<br />\r\n- <a href="http://ltp-design.com/">Stephen Jones</a><br />\r\n- <a href="http://oha.nu/">One-Handed Apps</a><br />\r\n- Alwin Hawkins<br />\r\n- <a href="http://jstigall.bloomington.in.us">Justin Stigall</a><br />\r\n- <a href="http://www.itismylife.com/">It is my life</a><br />\r\n- Greg Morrill<br />\r\n- <a href="http://www.dutchsubmarines.com/">Dutch Submarines</a><br />\r\n- <a href="http://www.7thwatch.com/">Seventh Watch Design Studios</a> <br />\r\n- <a href="http://www.macnet2.com/">MacNetv2</a> <br />\r\n- Richard Noordhof<br />\r\n- <a href="http://www.jamier.net/">Jamie Rytlewski</a><br />\r\n<br />\r\nNucleusが気に入りましたか? <a href="http://www.hotscripts.com/Detailed/13368.html?RID=nucleus@demuynck.org">HotScripts</a>や<a href="http://www.opensourcecms.com/index.php?option=content&task=view&id=145">opensourceCMS<a>での投票をお願いします。<br />\r\n<br />\r\n<b>ライセンス</b><br />\r\n<br />\r\n私たちがフリー・ソフトウェアについて口にする場合は自由のことに言及しているのであって、価格のことではありません。私たちの<a href="http://www.gnu.org/licenses/gpl.html">一般公有使用許諾書</a>(<a href="http://www.key.ne.jp/Report/Counter/files/gpl2-j.text">日本語訳</a>と<a href="http://www.atmarkit.co.jp/aig/03linux/gpl.html">概要</a>)は、フリー・ソフトウェアの複製物を自由に頒布できること(そして、望むならこのサービスに対して対価を請求できること)、ソース・コードを実際に受け取るか希望しさえすれば入手することが可能であること、入手したソフトウェアを変更したり新しいフリー・プログラムの一部として使用できること、以上の各内容を行なうことができるということをユーザ自身が知っていることを実現できるようにデザインされています。', 1, 1, '2004-11-13 19:24:22', 0, 0, 0, 1, 0);
\r
124 CREATE TABLE `nucleus_karma` (
\r
125 `itemid` int(11) NOT NULL default '0',
\r
126 `ip` char(15) NOT NULL default ''
\r
129 CREATE TABLE `nucleus_member` (
\r
130 `mnumber` int(11) NOT NULL auto_increment,
\r
131 `mname` varchar(16) NOT NULL default '',
\r
132 `mrealname` varchar(60) default NULL,
\r
133 `mpassword` varchar(40) NOT NULL default '',
\r
134 `memail` varchar(60) default NULL,
\r
135 `murl` varchar(100) default NULL,
\r
136 `mnotes` varchar(100) default NULL,
\r
137 `madmin` tinyint(2) NOT NULL default '0',
\r
138 `mcanlogin` tinyint(2) NOT NULL default '1',
\r
139 `mcookiekey` varchar(40) default NULL,
\r
140 `deflang` varchar(20) NOT NULL default '',
\r
141 PRIMARY KEY (`mnumber`),
\r
142 UNIQUE KEY `mname` (`mname`),
\r
143 UNIQUE KEY `mnumber` (`mnumber`)
\r
146 INSERT INTO `nucleus_member` VALUES (1, 'God', 'Test User', '714d82a0a84f9c6e3495fe2aa5618627', 'example@example.org', 'http://localhost:8080/nucleus/', '', 1, 1, 'd95a775494f1b589011aed122f197c8a', '');
\r
148 CREATE TABLE `nucleus_plugin` (
\r
149 `pid` int(11) NOT NULL auto_increment,
\r
150 `pfile` varchar(40) NOT NULL default '',
\r
151 `porder` int(11) NOT NULL default '0',
\r
152 PRIMARY KEY (`pid`),
\r
154 KEY `porder` (`porder`)
\r
157 CREATE TABLE `nucleus_plugin_event` (
\r
158 `pid` int(11) NOT NULL default '0',
\r
159 `event` varchar(40) default NULL,
\r
163 CREATE TABLE `nucleus_plugin_option` (
\r
164 `ovalue` text NOT NULL,
\r
165 `oid` int(11) NOT NULL auto_increment,
\r
166 `ocontextid` int(11) NOT NULL default '0',
\r
167 PRIMARY KEY (`oid`,`ocontextid`)
\r
170 CREATE TABLE `nucleus_plugin_option_desc` (
\r
171 `oid` int(11) NOT NULL auto_increment,
\r
172 `opid` int(11) NOT NULL default '0',
\r
173 `oname` varchar(20) NOT NULL default '',
\r
174 `ocontext` varchar(20) NOT NULL default '',
\r
175 `odesc` varchar(255) default NULL,
\r
176 `otype` varchar(20) default NULL,
\r
179 PRIMARY KEY (`opid`,`oname`,`ocontext`),
\r
180 UNIQUE KEY `oid` (`oid`)
\r
183 CREATE TABLE `nucleus_skin` (
\r
184 `sdesc` int(11) NOT NULL default '0',
\r
185 `stype` varchar(20) NOT NULL default '',
\r
186 `scontent` text NOT NULL,
\r
187 PRIMARY KEY (`sdesc`,`stype`)
\r
190 INSERT INTO `nucleus_skin` VALUES (2, 'index', '<?xml version="1.0" encoding="utf-8"?>\r\n<feed version="0.3" xmlns="http://purl.org/atom/ns#">\r\n <title><%blogsetting(name)%></title>\r\n <link rel="alternate" type="text/html" href="<%blogsetting(url)%>" />\r\n <generator url="http://nucleuscms.org/"><%version%></generator>\r\n <modified><%blog(feeds/atom/modified,1)%></modified>\r\n <%blog(feeds/atom/entries,10)%>\r\n</feed>');
\r
191 INSERT INTO `nucleus_skin` VALUES (4, 'index', '<?xml version="1.0"?>\r\n<rsd version="1.0">\r\n <service>\r\n <engineName><%version%></engineName>\r\n <engineLink>http://nucleuscms.org/</engineLink>\r\n <homepageLink><%sitevar(url)%></homepageLink>\r\n <apis>\r\n <api name="MetaWeblog" preferred="true" apiLink="<%adminurl%>xmlrpc/server.php" blogID="<%blogsetting(id)%>">\r\n <docs>http://nucleuscms.org/documentation/devdocs/xmlrpc.html</docs>\r\n </api>\r\n <api name="Blogger" preferred="false" apiLink="<%adminurl%>xmlrpc/server.php" blogID="<%blogsetting(id)%>">\r\n <docs>http://nucleuscms.org/documentation/devdocs/xmlrpc.html</docs>\r\n </api>\r\n </apis>\r\n </service>\r\n</rsd>');
\r
192 INSERT INTO `nucleus_skin` VALUES (3, 'index', '<?xml version="1.0" encoding="UTF-8"?>\r\n<rss version="2.0">\r\n <channel>\r\n <title><%blogsetting(name)%></title>\r\n <link><%blogsetting(url)%></link>\r\n <description><%blogsetting(desc)%></description>\r\n <!-- optional tags -->\r\n <language>ja</language> <!-- valid langugae goes here -->\r\n <generator><%version%></generator>\r\n <copyright>©</copyright> <!-- Copyright notice -->\r\n <category>Weblog</category>\r\n <docs>http://backend.userland.com/rss</docs>\r\n <image>\r\n <url><%adminurl%>nucleus2.gif</url>\r\n <title><%blogsetting(name)%></title>\r\n <link><%blogsetting(url)%></link>\r\n </image>\r\n <%blog(feeds/rss20,10)%>\r\n </channel>\r\n</rss>');
\r
193 INSERT INTO `nucleus_skin` VALUES (1, 'item', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\n\n<html>\n<head>\n <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\n <title><%itemtitle%> - <%blogsetting(name)%></title>\n\n <!-- some meta information (search engines might read this) -->\n <meta name="generator" content="<%version%>" />\n <meta name="description" content="<%blogsetting(desc)%>" />\n\n <!-- stylesheet definition (points to the place where colors -->\n <!-- and layout is defined -->\n <link rel="stylesheet" type="text/css" href="<%skinfile(grey.css)%>" />\n\n <!-- prevent caching (can be removed) -->\n <meta http-equiv="Pragma" content="no-cache" />\n <meta http-equiv="Cache-Control" content="no-cache, must-revalidate" />\n <meta http-equiv="Expires" content="-1" />\n \n <!-- extra navigational links -->\n <link rel="bookmark" title="Nucleus" href="http://nucleuscms.org/" />\n <link rel="alternate" type="application/xml+rss" title="RSS" href="xml-rss2.php" />\n <link rel="archives" title="Archives" href="<%archivelink%>" />\n <link rel="top" title="Today" href="<%sitevar(url)%>" />\n <link rel="next" href="<%nextlink%>" title="Next Item" />\n <link rel="prev" href="<%prevlink%>" title="Previous Item" />\n <link rel="up" href="<%todaylink%>" title="Today" />\n\n</head>\n<body>\n\n<!-- here starts the code that will be displayed in your browser -->\n<div class="contents">\n\n <!-- page title -->\n <h1><%blogsetting(name)%></h1>\n\n <!-- this is a normally hidden link, included for accessibility reasons -->\n <a href="#navigation" class="skip">Jump to navigation</a>\n\n <!-- inserts the selected item using the template named ''grey/full'' -->\n <%item(grey/full)%>\n\n <!-- this tag inserts the comments on the selected item, also using the -->\n <!-- template with name ''grey/full'' -->\n <h2>Comments</h2>\n <%comments(grey/full)%>\n\n <h2>Add Comments</h2>\n <%commentform%>\n\n</div><!-- end of the contents div -->\n\n<!-- definition of the logo left-top -->\n<div class="logo">\n <a href="<%sitevar(url)%>"><img src="<%skinfile(atom3.gif)%>" width="155" height="137" alt="" /></a>\n</div>\n\n<!-- definition of the menu -->\n<div class="menu">\n\n <!-- accessibility anchor -->\n <a name="navigation" id="navigation" class="skip"></a>\n <h1 class="skip">Navigation</h1>\n\n <h2>Navigation</h2>\n <ul class="nobullets">\n <li><a href="<%nextlink%>">Previous Item</a></li>\n <li><a href="<%prevlink%>">Next Item</a></li>\n <li><a href="<%todaylink%>">Today</a></li>\n <li><a href="<%archivelink%>">Archives</a></li>\n <li><a href="<%adminurl%>">Admin Area</a></li>\n </ul>\n\n <h2>Categories</h2>\n <%categorylist(grey/short)%>\n\n <h2>Search</h2>\n <%searchform%>\n \n <h2>Login</h2>\n <%loginform%>\n\n <h2>Powered by</h2>\n <%nucleusbutton(nucleus.gif,85,31)%>\n\n</div>\n\n</body>\n</html>');
\r
194 INSERT INTO `nucleus_skin` VALUES (1, 'member', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\n\n<html>\n<head>\n <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\n <title><%sitevar(name)%></title>\n\n <!-- some meta information (search engines might read this) -->\n <meta name="generator" content="<%version%>" />\n\n <!-- stylesheet definition (points to the place where colors -->\n <!-- and layout is defined -->\n <link rel="stylesheet" type="text/css" href="<%skinfile(grey.css)%>" />\n\n <!-- prevent caching (can be removed) -->\n <meta http-equiv="Pragma" content="no-cache" />\n <meta http-equiv="Cache-Control" content="no-cache, must-revalidate" />\n <meta http-equiv="Expires" content="-1" />\n \n <!-- extra navigational links -->\n <link rel="bookmark" title="Nucleus" href="http://nucleuscms.org/" />\n <link rel="top" title="Today" href="<%todaylink%>" />\n <link rel="up" href="<%todaylink%>" title="Today" />\n\n</head>\n<body>\n\n<!-- here starts the code that will be displayed in your browser -->\n<div class="contents">\n\n <!-- this is a normally hidden link, included for accessibility reasons -->\n <a href="#navigation" class="skip">Jump to navigation</a>\n\n <!-- a title -->\n <h1><%sitevar(name)%></h1>\n\n <h2>Info about <%member(name)%></h2>\n\n <ul>\n <li>Real name: <%member(realname)%></li>\n <li>Website: <a href="<%member(url)%>"><%member(url)%></a></li>\n </ul>\n\n <h2>Send Message</h2>\n <%membermailform%>\n\n</div><!-- end of the contents div -->\n\n<!-- definition of the logo left-top -->\n<div class="logo">\n <a href="<%sitevar(url)%>"><img src="<%skinfile(atom3.gif)%>" width="155" height="137" alt="" /></a>\n</div>\n\n<!-- definition of the menu -->\n<div class="menu">\n <!-- accessibility anchor -->\n <a name="navigation" id="navigation" class="skip"></a>\n <h1 class="skip">Navigation</h1>\n\n <h2>Navigation</h2>\n\n <ul class="nobullets">\n <li><a href="<%todaylink%>">Today</a></li>\n <li><a href="<%adminurl%>">Admin Area</a></li>\n </ul>\n \n <h2>Login</h2>\n <%loginform%>\n\n <h2>Powered by</h2>\n <%nucleusbutton(nucleus.gif,85,31)%>\n\n</div>\n\n</body>\n</html>');
\r
195 INSERT INTO `nucleus_skin` VALUES (1, 'search', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\n\n<html>\n<head>\n <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\n <title><%blogsetting(name)%></title>\n\n <!-- some meta information (search engines might read this) -->\n <meta name="generator" content="<%version%>" />\n <meta name="description" content="<%blogsetting(desc)%>" />\n\n <!-- stylesheet definition (points to the place where colors -->\n <!-- and layout is defined -->\n <link rel="stylesheet" type="text/css" href="<%skinfile(grey.css)%>" />\n \n <!-- prevent caching (can be removed) -->\n <meta http-equiv="Pragma" content="no-cache" />\n <meta http-equiv="Cache-Control" content="no-cache, must-revalidate" />\n <meta http-equiv="Expires" content="-1" />\n \n <!-- extra navigational links -->\n <link rel="bookmark" title="Nucleus" href="http://nucleuscms.org/" />\n <link rel="alternate" type="application/xml+rss" title="RSS" href="xml-rss2.php" />\n <link rel="archives" title="Archives" href="<%archivelink%>" />\n <link rel="top" title="Today" href="<%sitevar(url)%>" />\n <link rel="up" href="<%todaylink%>" title="Today" />\n\n</head>\n<body>\n\n<!-- here starts the code that will be displayed in your browser -->\n<div class="contents">\n\n <!-- this is a normally hidden link, included for accessibility reasons -->\n <a href="#navigation" class="skip">Jump to navigation</a>\n\n <!-- a title -->\n <h1><%blogsetting(name)%></h1>\n\n <h2>Search</h2>\n <%searchform%>\n\n <h2>Search results</h2>\n <%searchresults(grey/short)%>\n\n</div><!-- end of the contents div -->\n\n<!-- definition of the logo left-top -->\n<div class="logo">\n <a href="<%sitevar(url)%>"><img src="<%skinfile(atom3.gif)%>" width="155" height="137" alt="" /></a>\n</div>\n\n<!-- definition of the menu -->\n<div class="menu">\n <!-- accessibility anchor -->\n <a name="navigation" id="navigation" class="skip"></a>\n <h1 class="skip">Navigation</h1>\n\n <h2>Navigation</h2>\n\n <ul class="nobullets">\n <li><a href="<%todaylink%>">Today</a></li>\n <li><a href="<%archivelink%>">Archives</a></li>\n <li><a href="<%adminurl%>">Admin Area</a></li>\n </ul>\n\n <h2>Search</h2>\n <%searchform%>\n \n <h2>Login</h2>\n <%loginform%>\n\n <h2>Powered by</h2>\n <%nucleusbutton(nucleus.gif,85,31)%>\n\n</div>\n\n</body>\n</html>');
\r
196 INSERT INTO `nucleus_skin` VALUES (1, 'error', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\n\n<html>\n<head>\n <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\n <title><%sitevar(name)%></title>\n\n <!-- some meta information (search engines might read this) -->\n <meta name="generator" content="<%version%>" />\n\n <!-- stylesheet definition (points to the place where colors -->\n <!-- and layout is defined -->\n <link rel="stylesheet" type="text/css" href="<%skinfile(grey.css)%>" />\n\n <!-- prevent caching (can be removed) -->\n <meta http-equiv="Pragma" content="no-cache" />\n <meta http-equiv="Cache-Control" content="no-cache, must-revalidate" />\n <meta http-equiv="Expires" content="-1" />\n \n <!-- extra navigational links -->\n <link rel="bookmark" title="Nucleus" href="http://nucleuscms.org/" />\n <link rel="top" title="Today" href="<%todaylink%>" />\n <link rel="up" href="<%todaylink%>" title="Today" />\n</div>\n\n</head>\n<body>\n\n<!-- here starts the code that will be displayed in your browser -->\n<div class="contents">\n\n <!-- this is a normally hidden link, included for accessibility reasons -->\n <a href="#navigation" class="skip">Jump to navigation</a>\n\n <!-- a title -->\n <h1><%sitevar(name)%></h1>\n\n <h2>Error!</h2>\n\n <p><%errormessage%></p>\n\n <p><a href="javascript:history.go(-1);">Go back</a></p>\n\n</div><!-- end of the contents div -->\n\n<!-- definition of the logo left-top -->\n<div class="logo">\n <a href="<%sitevar(url)%>"><img src="<%skinfile(atom3.gif)%>" width="155" height="137" alt="" /></a>\n</div>\n\n<!-- definition of the menu -->\n<div class="menu">\n <!-- accessibility anchor -->\n <a name="navigation" id="navigation" class="skip"></a>\n <h1 class="skip">Navigation</h1>\n\n <h2>Navigation</h2>\n\n <ul class="nobullets">\n <li><a href="<%todaylink%>">Today</a></li>\n <li><a href="<%adminurl%>">Admin Area</a></li>\n </ul>\n \n <h2>Login</h2>\n <%loginform%>\n\n <h2>Powered by</h2>\n <%nucleusbutton(nucleus.gif,85,31)%>\n\n</div>\n\n</body>\n</html>');
\r
197 INSERT INTO `nucleus_skin` VALUES (1, 'imagepopup', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\n\n<html>\n<head>\n <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\n <title><%imagetext%></title>\n <style type="text/css">\n img { border: none; }\n body { margin: 0px; }\n </style>\n</head>\n<body onblur="window.close()">\n <a href="javascript:window.close();"><%image%></a>\n</body>\n</html>');
\r
198 INSERT INTO `nucleus_skin` VALUES (1, 'index', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\n\n<html>\n<head>\n <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\n <title><%blogsetting(name)%></title>\n\n <!-- some meta information (search engines might read this) -->\n <meta name="generator" content="<%version%>" />\n <meta name="description" content="<%blogsetting(desc)%>" />\n\n <!-- stylesheet definition (points to the place where colors -->\n <!-- and layout is defined -->\n <link rel="stylesheet" type="text/css" href="<%skinfile(grey.css)%>" />\n\n <!-- prevent caching (can be removed) -->\n <meta http-equiv="Pragma" content="no-cache" />\n <meta http-equiv="Cache-Control" content="no-cache, must-revalidate" />\n <meta http-equiv="Expires" content="-1" />\n \n <!-- extra navigational links -->\n <link rel="bookmark" title="Nucleus" href="http://nucleuscms.org/" />\n <link rel="archives" title="Archives" href="<%archivelink%>" />\n <link rel="top" title="Today" href="<%todaylink%>" />\n\n <!-- link RSS as alternate version -->\n <link rel="alternate" type="application/xml+rss" title="RSS" href="xml-rss2.php" />\n\n <!-- RSD support -->\n <link rel="EditURI" type="application/rsd+xml" title="RSD" href="rsd.php" />\n\n</head>\n<body>\n\n<!-- here starts the code that will be displayed in your browser -->\n<div class="contents">\n <!-- page title -->\n <h1><%blogsetting(name)%></h1>\n\n <!-- this is a normally hidden link, included for accessibility reasons -->\n <a href="#navigation" class="skip">Jump to navigation</a>\n\n <!-- this tag inserts a weblog using the template named ''grey/short'' -->\n <!-- and showing 15 entries -->\n <%blog(grey/short,15)%>\n\n</div><!-- end of the contents div -->\n\n<!-- definition of the logo (left-top) -->\n<div class="logo">\n <a href="<%sitevar(url)%>"><img src="<%skinfile(atom3.gif)%>" width="155" height="137" alt="" /></a>\n</div>\n\n<!-- definition of the menu -->\n<div class="menu">\n <!-- accessibility anchor -->\n <a name="navigation" id="navigation" class="skip"></a>\n <h1 class="skip">Navigation</h1>\n\n <h2>Navigation</h2>\n <ul class="nobullets">\n <li><a href="<%todaylink%>">Today</a></li>\n <li><a href="<%archivelink%>">Archives</a></li>\n <li><a href="<%adminurl%>">Admin Area</a></li>\n </ul>\n\n <h2>Categories</h2>\n <%categorylist(grey/short)%>\n\n <h2>Search</h2>\n <%searchform%>\n \n <h2>Login</h2>\n <%loginform%>\n\n <h2>My Links</h2>\n\n <ul class="nobullets">\n <li><a href="http://nucleuscms.org/" title="This site is Nucleus-powered">Nucleus</a></li>\n <li><a href="http://www.weblogs.com/" title="latest updates">Weblogs</a></li>\n <li><a href="http://www.daypop.com/" title="Search news & weblog sites">DayPop</a></li>\n <li><a href="http://www.google.com/" title="Search the web">Google</a></li>\n </ul>\n\n <h2>Powered by</h2>\n <%nucleusbutton(nucleus.gif,85,31)%>\n\n</div>\n\n</body>\n</html>');
\r
199 INSERT INTO `nucleus_skin` VALUES (1, 'archivelist', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\n\n<html>\n<head>\n <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\n <title><%blogsetting(name)%></title>\n\n <!-- some meta information (search engines might read this) -->\n <meta name="generator" content="<%version%>" />\n <meta name="description" content="<%blogsetting(desc)%>" />\n\n <!-- stylesheet definition (points to the place where colors -->\n <!-- and layout is defined -->\n <link rel="stylesheet" type="text/css" href="<%skinfile(grey.css)%>" />\n\n <!-- prevent caching (can be removed) -->\n <meta http-equiv="Pragma" content="no-cache" />\n <meta http-equiv="Cache-Control" content="no-cache, must-revalidate" />\n <meta http-equiv="Expires" content="-1" />\n \n <!-- extra navigational links -->\n <link rel="bookmark" title="Nucleus" href="http://nucleuscms.org/" />\n <link rel="alternate" type="application/xml+rss" title="RSS" href="xml-rss2.php" />\n <link rel="archives" title="Archives" href="<%archivelink%>" />\n <link rel="top" title="Today" href="<%sitevar(url)%>" />\n <link rel="up" href="<%todaylink%>" title="Today" />\n\n</head>\n<body>\n\n<!-- here starts the code that will be displayed in your browser -->\n<div class="contents">\n\n<!-- a title -->\n<h1><%blogsetting(name)%></h1>\n\n <!-- this is a normally hidden link, included for accessibility reasons -->\n <a href="#navigation" class="skip">Jump to navigation</a>\n\n <h2>Archives</h2>\n <!-- This tag inserts the archivelist using the grey/short template -->\n <%archivelist(grey/short)%>\n\n</div><!-- end of the contents div -->\n\n<!-- definition of the logo left-top -->\n<div class="logo">\n <a href="<%sitevar(url)%>"><img src="<%skinfile(atom3.gif)%>" width="155" height="137" alt="" /></a> \n</div>\n\n<!-- definition of the menu -->\n<div class="menu">\n <!-- accessibility anchor -->\n <a name="navigation" id="navigation" class="skip"></a>\n <h1 class="skip">Navigation</h1>\n\n <h2>Navigation</h2>\n <ul class="nobullets">\n <li><a href="<%todaylink%>">Today</a></li>\n <li><a href="<%archivelink%>">Archives</a></li>\n <li><a href="<%adminurl%>">Admin Area</a></li>\n </ul>\n\n <h2>Categories</h2>\n <%categorylist(grey/short)%>\n \n <h2>Search</h2>\n <%searchform%>\n \n <h2>Login</h2>\n <%loginform%>\n\n <h2>Powered by</h2>\n <%nucleusbutton(nucleus.gif,85,31)%>\n\n</div>\n\n</body>\n</html>');
\r
200 INSERT INTO `nucleus_skin` VALUES (1, 'archive', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\n\n<html>\n<head>\n <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />\n <title><%blogsetting(name)%></title>\n\n <!-- some meta information (search engines might read this) -->\n <meta name="generator" content="<%version%>" />\n <meta name="description" content="<%blogsetting(desc)%>" />\n\n <!-- stylesheet definition (points to the place where colors -->\n <!-- and layout is defined -->\n <link rel="stylesheet" type="text/css" href="<%skinfile(grey.css)%>" />\n\n <!-- prevent caching (can be removed) -->\n <meta http-equiv="Pragma" content="no-cache" />\n <meta http-equiv="Cache-Control" content="no-cache, must-revalidate" />\n <meta http-equiv="Expires" content="-1" />\n \n <!-- extra navigational links -->\n <link rel="bookmark" title="Nucleus" href="http://nucleuscms.org/" />\n <link rel="alternate" type="application/xml+rss" title="RSS" href="xml-rss2.php" />\n <link rel="archives" title="Archives" href="<%archivelink%>" />\n <link rel="top" title="Today" href="<%sitevar(url)%>" />\n <link rel="up" href="<%todaylink%>" title="Today" />\n\n</head>\n<body>\n\n<!-- here starts the code that will be displayed in your browser -->\n<div class="contents">\n\n <!-- this is a normally hidden link, included for accessibility reasons -->\n <a href="#navigation" class="skip">Jump to navigation</a>\n\n <!-- a title -->\n <h1><%blogsetting(name)%></h1>\n\n <!-- This tag inserts the archive using the grey/short template -->\n <%archive(grey/short)%>\n\n</div><!-- end of the contents div -->\n\n<!-- definition of the logo left-top -->\n<div class="logo">\n <a href="<%sitevar(url)%>"><img src="<%skinfile(atom3.gif)%>" width="155" height="137" alt="" /></a>\n</div>\n\n<!-- definition of the menu -->\n<div class="menu">\n <!-- accessibility anchor -->\n <a name="navigation" id="navigation" class="skip"></a>\n <h1 class="skip">Navigation</h1>\n\n <h2>Navigation</h2>\n\n <ul class="nobullets">\n <li><a href="<%prevlink%>">前の<%archivetype%></a></li>\n <li><a href="<%nextlink%>">次の<%archivetype%></a></li>\n <li><a href="<%todaylink%>">Today</a></li>\n <li><a href="<%archivelink%>">Archives</a></li>\n <li><a href="<%adminurl%>">Admin Area</a></li>\n </ul>\n\n <h2>Categories</h2>\n <%categorylist(grey/short)%>\n\n <h2>Search</h2>\n <%searchform%>\n \n <h2>Login</h2>\n <%loginform%>\n\n <h2>Powered by</h2>\n <%nucleusbutton(nucleus.gif,85,31)%>\n \n</div>\n\n</body>\n</html>');
\r
202 CREATE TABLE `nucleus_skin_desc` (
\r
203 `sdnumber` int(11) NOT NULL auto_increment,
\r
204 `sdname` varchar(20) NOT NULL default '',
\r
205 `sddesc` varchar(200) default NULL,
\r
206 `sdtype` varchar(40) NOT NULL default 'text/html',
\r
207 `sdincmode` varchar(10) NOT NULL default 'normal',
\r
208 `sdincpref` varchar(50) NOT NULL default '',
\r
209 PRIMARY KEY (`sdnumber`),
\r
210 UNIQUE KEY `sdname` (`sdname`),
\r
211 UNIQUE KEY `sdnumber` (`sdnumber`)
\r
214 INSERT INTO `nucleus_skin_desc` VALUES (2, 'feeds/atom', 'Atom 0.3 weblog syndication', 'application/atom+xml', 'normal', '');
\r
215 INSERT INTO `nucleus_skin_desc` VALUES (3, 'feeds/rss20', 'RSS 2.0 syndication of weblogs', 'text/xml', 'normal', '');
\r
216 INSERT INTO `nucleus_skin_desc` VALUES (4, 'api/rsd', 'RSD (Really Simple Discovery) information for weblog clients', 'text/xml', 'normal', '');
\r
217 INSERT INTO `nucleus_skin_desc` VALUES (1, 'grey', 'Default skin to display your blog', 'text/html', 'skindir', 'grey/');
\r
219 CREATE TABLE `nucleus_team` (
\r
220 `tmember` int(11) NOT NULL default '0',
\r
221 `tblog` int(11) NOT NULL default '0',
\r
222 `tadmin` tinyint(2) NOT NULL default '0',
\r
223 PRIMARY KEY (`tmember`,`tblog`)
\r
226 INSERT INTO `nucleus_team` VALUES (1, 1, 1);
\r
228 CREATE TABLE `nucleus_template` (
\r
229 `tdesc` int(11) NOT NULL default '0',
\r
230 `tpartname` varchar(20) NOT NULL default '',
\r
231 `tcontent` text NOT NULL,
\r
232 PRIMARY KEY (`tdesc`,`tpartname`)
\r
235 INSERT INTO `nucleus_template` VALUES (3, 'ITEM', '<item>\r\n <title><![CDATA[<%title%>]]></title>\r\n <link><%blogurl%>?itemid=<%itemid%></link>\r\n<description><![CDATA[<%body%><%more%>]]></description>\r\n <category><%category%></category>\r\n<comments><%blogurl%>?itemid=<%itemid%></comments>\r\n <pubDate><%date(rfc822)%></pubDate>\r\n</item>');
\r
236 INSERT INTO `nucleus_template` VALUES (3, 'EDITLINK', '<a href="<%editlink%>" onclick="<%editpopupcode%>">edit</a>');
\r
237 INSERT INTO `nucleus_template` VALUES (4, 'ITEM', '<%date(utc)%>');
\r
238 INSERT INTO `nucleus_template` VALUES (5, 'ITEM', '<entry>\r\n <title type="text/html" mode="escaped"><![CDATA[<%title%>]]></title>\r\n <link rel="alternate" type="text/html" href="<%blogurl%>?itemid=<%itemid%>" />\r\n <author>\r\n <name><%author%></name>\r\n </author>\r\n <modified><%date(utc)%></modified>\r\n <issued><%date(iso8601)%></issued>\r\n <content type="text/html" mode="escaped"><![CDATA[<%body%><%more%>]]></content>\r\n <id><%blogurl%>:<%blogid%>:<%itemid%></id>\r\n</entry>');
\r
239 INSERT INTO `nucleus_template` VALUES (1, 'ITEM', '\n<h3 class="item"><%title%></h3>\n\n<div class="itembody">\n <%body%>\n <%morelink%>\n</div>\n\n<div class="iteminfo">\n <%time%> -\n <a href="<%authorlink%>"><%author%></a> -\n <%edit%>\n <%comments%>\n</div>\n');
\r
240 INSERT INTO `nucleus_template` VALUES (1, 'FORMAT_TIME', '%H:%M:%S');
\r
241 INSERT INTO `nucleus_template` VALUES (1, 'IMAGE_CODE', '<%image%>');
\r
242 INSERT INTO `nucleus_template` VALUES (1, 'FORMAT_DATE', '%Y-%m-%d');
\r
243 INSERT INTO `nucleus_template` VALUES (1, 'EDITLINK', '<a href="<%editlink%>" onclick="<%editpopupcode%>">edit</a> -');
\r
244 INSERT INTO `nucleus_template` VALUES (1, 'DATE_HEADER', '<h2>%Y-%m-%d</h2>');
\r
245 INSERT INTO `nucleus_template` VALUES (1, 'COMMENTS_TOOMUCH', '<a href="<%itemlink%>" rel="bookmark"><%commentcount%> <%commentword%></a>');
\r
246 INSERT INTO `nucleus_template` VALUES (1, 'COMMENTS_ONE', 'comment');
\r
247 INSERT INTO `nucleus_template` VALUES (1, 'COMMENTS_NONE', '<a href="<%itemlink%>" rel="bookmark">No <%commentword%></a>');
\r
248 INSERT INTO `nucleus_template` VALUES (1, 'CATLIST_LISTITEM', ' <li><a href="<%catlink%>"><%catname%></a></li>');
\r
249 INSERT INTO `nucleus_template` VALUES (1, 'COMMENTS_MANY', 'comments');
\r
250 INSERT INTO `nucleus_template` VALUES (1, 'CATLIST_HEADER', '<ul class="nobullets"><li><a href="<%blogurl%>">All</a></li>');
\r
251 INSERT INTO `nucleus_template` VALUES (1, 'CATLIST_FOOTER', '</ul>');
\r
252 INSERT INTO `nucleus_template` VALUES (1, 'ARCHIVELIST_LISTITEM', '<li><a href="<%archivelink%>">%Y-%m</a></li>');
\r
253 INSERT INTO `nucleus_template` VALUES (1, 'ARCHIVELIST_HEADER', '<ul>');
\r
254 INSERT INTO `nucleus_template` VALUES (1, 'ARCHIVELIST_FOOTER', '</ul>');
\r
255 INSERT INTO `nucleus_template` VALUES (2, 'ITEM', '\n<h2><%date(%Y-%m-%d)%></h2>\n<h3 class="item"><%title%></h3>\n\n<div class="itembody">\n <%body%>\n <br /><br />\n <%more%>\n</div>\n\n<div class="iteminfo">\n posted at <%time%> on <%date%>\n by <a href="?memberid=<%authorid%>"><%author%></a> -\n Category: <a href="<%categorylink%>"><%category%></a>\n <%edit%>\n</div>\n');
\r
256 INSERT INTO `nucleus_template` VALUES (2, 'COMMENTS_NONE', '<div class="comments">No comments yet</div>');
\r
257 INSERT INTO `nucleus_template` VALUES (2, 'COMMENTS_ONE', 'comment');
\r
258 INSERT INTO `nucleus_template` VALUES (2, 'EDITLINK', '- <a href="<%editlink%>" onclick="<%editpopupcode%>">edit</a>');
\r
259 INSERT INTO `nucleus_template` VALUES (2, 'FORMAT_DATE', '%Y-%m-%d');
\r
260 INSERT INTO `nucleus_template` VALUES (2, 'FORMAT_TIME', '%H:%M:%S');
\r
261 INSERT INTO `nucleus_template` VALUES (2, 'IMAGE_CODE', '<%image%>');
\r
262 INSERT INTO `nucleus_template` VALUES (3, 'FORMAT_DATE', '%Y-%m-%d');
\r
263 INSERT INTO `nucleus_template` VALUES (3, 'FORMAT_TIME', '%H:%M:%S');
\r
264 INSERT INTO `nucleus_template` VALUES (2, 'COMMENTS_MANY', 'comments');
\r
265 INSERT INTO `nucleus_template` VALUES (2, 'COMMENTS_BODY', '<h3 class="comment"><%userlink%> wrote:</h3>\n\n<div class="commentbody">\n <%body%>\n</div>\n\n<div class="commentinfo">\n <%date%> <%time%>\n</div>');
\r
266 INSERT INTO `nucleus_template` VALUES (1, 'LOCALE', 'ja_JP.UTF-8');
\r
267 INSERT INTO `nucleus_template` VALUES (1, 'MEDIA_CODE', '<%media%>');
\r
268 INSERT INTO `nucleus_template` VALUES (1, 'MORELINK', '<a href="<%itemlink%>">[Read More!]</a>');
\r
269 INSERT INTO `nucleus_template` VALUES (1, 'POPUP_CODE', '<%popuplink%>');
\r
270 INSERT INTO `nucleus_template` VALUES (1, 'SEARCH_HIGHLIGHT', '<span class="highlight">\\0</span>');
\r
271 INSERT INTO `nucleus_template` VALUES (1, 'SEARCH_NOTHINGFOUND', 'No search results found for <b><%query%></b>');
\r
272 INSERT INTO `nucleus_template` VALUES (2, 'LOCALE', 'ja_JP.UTF-8');
\r
273 INSERT INTO `nucleus_template` VALUES (2, 'MEDIA_CODE', '<%media%>');
\r
274 INSERT INTO `nucleus_template` VALUES (2, 'POPUP_CODE', '<%popuplink%>');
\r
275 INSERT INTO `nucleus_template` VALUES (2, 'SEARCH_HIGHLIGHT', '<span class="highlight">\\0</span>');
\r
277 CREATE TABLE `nucleus_template_desc` (
\r
278 `tdnumber` int(11) NOT NULL auto_increment,
\r
279 `tdname` varchar(20) NOT NULL default '',
\r
280 `tddesc` varchar(200) default NULL,
\r
281 PRIMARY KEY (`tdnumber`),
\r
282 UNIQUE KEY `tdnumber` (`tdnumber`),
\r
283 UNIQUE KEY `tdname` (`tdname`)
\r
286 INSERT INTO `nucleus_template_desc` VALUES (4, 'feeds/atom/modified', 'Atom feeds: Inserts last modification date');
\r
287 INSERT INTO `nucleus_template_desc` VALUES (5, 'feeds/atom/entries', 'Atom feeds: Feed items');
\r
288 INSERT INTO `nucleus_template_desc` VALUES (3, 'feeds/rss20', 'Used for RSS 2.0 syndication of your blog');
\r
289 INSERT INTO `nucleus_template_desc` VALUES (1, 'grey/short', 'The default template that is used to display your Nucleus blog');
\r
290 INSERT INTO `nucleus_template_desc` VALUES (2, 'grey/full', 'Used for detailed item pages');
\r