X-Git-Url: http://git.sourceforge.jp/view?p=nucleus-jp%2Fnucleus-jp-ancient.git;a=blobdiff_plain;f=euc%2Finstall.sql;h=3074ce15e46e8b5e6d0cc5655e1e0f671eb38e23;hp=0fe4bcfb53e226a46bed75ca710625b2acb5a1af;hb=17054913b09c3202179a02eea83f031aff1954a8;hpb=d4d9ab10bb515ac1c787d809a995c121f7f4a3be;ds=sidebyside diff --git a/euc/install.sql b/euc/install.sql index 0fe4bcf..3074ce1 100755 --- a/euc/install.sql +++ b/euc/install.sql @@ -1,307 +1,268 @@ -CREATE TABLE `nucleus_actionlog` ( - `timestamp` datetime NOT NULL default '0000-00-00 00:00:00', - `message` varchar(255) NOT NULL default '' -) TYPE=MyISAM; - -CREATE TABLE `nucleus_ban` ( - `iprange` varchar(15) NOT NULL default '', - `reason` varchar(255) NOT NULL default '', - `blogid` int(11) NOT NULL default '0' -) TYPE=MyISAM; - -CREATE TABLE `nucleus_blog` ( - `bnumber` int(11) NOT NULL auto_increment, - `bname` varchar(60) NOT NULL default '', - `bshortname` varchar(15) NOT NULL default '', - `bdesc` varchar(200) default NULL, - `bcomments` tinyint(2) NOT NULL default '1', - `bmaxcomments` int(11) NOT NULL default '0', - `btimeoffset` decimal(3,1) NOT NULL default '0.0', - `bnotify` varchar(60) default NULL, - `burl` varchar(100) default NULL, - `bupdate` varchar(60) default NULL, - `bdefskin` int(11) NOT NULL default '1', - `bpublic` tinyint(2) NOT NULL default '1', - `bsendping` tinyint(2) NOT NULL default '0', - `bconvertbreaks` tinyint(2) NOT NULL default '1', - `bdefcat` int(11) default NULL, - `bnotifytype` int(11) NOT NULL default '15', - `ballowpast` tinyint(2) NOT NULL default '0', - `bincludesearch` tinyint(2) NOT NULL default '0', - PRIMARY KEY (`bnumber`), - UNIQUE KEY `bnumber` (`bnumber`), - UNIQUE KEY `bshortname` (`bshortname`) -) TYPE=MyISAM; - -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); - -CREATE TABLE `nucleus_category` ( - `catid` int(11) NOT NULL auto_increment, - `cblog` int(11) NOT NULL default '0', - `cname` varchar(40) default NULL, - `cdesc` varchar(200) default NULL, - PRIMARY KEY (`catid`) -) TYPE=MyISAM; - -INSERT INTO `nucleus_category` VALUES (1, 1, 'General', 'Items that do not fit in other categories'); - -CREATE TABLE `nucleus_comment` ( - `cnumber` int(11) NOT NULL auto_increment, - `cbody` text NOT NULL, - `cuser` varchar(40) default NULL, - `cmail` varchar(100) default NULL, - `cmember` int(11) default NULL, - `citem` int(11) NOT NULL default '0', - `ctime` datetime NOT NULL default '0000-00-00 00:00:00', - `chost` varchar(60) default NULL, - `cip` varchar(15) NOT NULL default '', - `cblog` int(11) NOT NULL default '0', - PRIMARY KEY (`cnumber`), - UNIQUE KEY `cnumber` (`cnumber`), - KEY `citem` (`citem`), - FULLTEXT KEY `cbody` (`cbody`) -) TYPE=MyISAM; - -CREATE TABLE `nucleus_config` ( - `name` varchar(20) NOT NULL default '', - `value` varchar(128) default NULL, - PRIMARY KEY (`name`) -) TYPE=MyISAM; - -INSERT INTO `nucleus_config` VALUES ('DefaultBlog', '1'); -INSERT INTO `nucleus_config` VALUES ('AdminEmail', 'example@example.org'); -INSERT INTO `nucleus_config` VALUES ('IndexURL', 'http://localhost:8080/nucleus/'); -INSERT INTO `nucleus_config` VALUES ('Language', 'japanese-euc'); -INSERT INTO `nucleus_config` VALUES ('SessionCookie', ''); -INSERT INTO `nucleus_config` VALUES ('AllowMemberCreate', ''); -INSERT INTO `nucleus_config` VALUES ('AllowMemberMail', '1'); -INSERT INTO `nucleus_config` VALUES ('SiteName', 'My Nucleus Weblog'); -INSERT INTO `nucleus_config` VALUES ('AdminURL', 'http://localhost:8080/nucleus/nucleus/'); -INSERT INTO `nucleus_config` VALUES ('NewMemberCanLogon', '1'); -INSERT INTO `nucleus_config` VALUES ('DisableSite', ''); -INSERT INTO `nucleus_config` VALUES ('DisableSiteURL', 'http://www.this-page-intentionally-left-blank.org/'); -INSERT INTO `nucleus_config` VALUES ('LastVisit', ''); -INSERT INTO `nucleus_config` VALUES ('MediaURL', 'http://localhost:8080/nucleus/media/'); -INSERT INTO `nucleus_config` VALUES ('AllowedTypes', 'jpg,jpeg,gif,mpg,mpeg,avi,mov,mp3,swf,png'); -INSERT INTO `nucleus_config` VALUES ('AllowLoginEdit', ''); -INSERT INTO `nucleus_config` VALUES ('AllowUpload', '1'); -INSERT INTO `nucleus_config` VALUES ('DisableJsTools', '2'); -INSERT INTO `nucleus_config` VALUES ('CookiePath', '/'); -INSERT INTO `nucleus_config` VALUES ('CookieDomain', ''); -INSERT INTO `nucleus_config` VALUES ('CookieSecure', ''); -INSERT INTO `nucleus_config` VALUES ('CookiePrefix', ''); -INSERT INTO `nucleus_config` VALUES ('MediaPrefix', '1'); -INSERT INTO `nucleus_config` VALUES ('MaxUploadSize', '1048576'); -INSERT INTO `nucleus_config` VALUES ('NonmemberMail', ''); -INSERT INTO `nucleus_config` VALUES ('PluginURL', 'http://localhost:8080/plugins/'); -INSERT INTO `nucleus_config` VALUES ('ProtectMemNames', '1'); -INSERT INTO `nucleus_config` VALUES ('BaseSkin', '1'); -INSERT INTO `nucleus_config` VALUES ('SkinsURL', 'http://localhost:8080/nucleus/skins/'); -INSERT INTO `nucleus_config` VALUES ('ActionURL', 'http://localhost:8080/nucleus/action.php'); -INSERT INTO `nucleus_config` VALUES ('URLMode', 'normal'); -INSERT INTO `nucleus_config` VALUES ('DatabaseVersion', '310'); - -CREATE TABLE `nucleus_item` ( - `inumber` int(11) NOT NULL auto_increment, - `ititle` varchar(160) default NULL, - `ibody` text NOT NULL, - `imore` text, - `iblog` int(11) NOT NULL default '0', - `iauthor` int(11) NOT NULL default '0', - `itime` datetime NOT NULL default '0000-00-00 00:00:00', - `iclosed` tinyint(2) NOT NULL default '0', - `idraft` tinyint(2) NOT NULL default '0', - `ikarmapos` int(11) NOT NULL default '0', - `icat` int(11) default NULL, - `ikarmaneg` int(11) NOT NULL default '0', - PRIMARY KEY (`inumber`), - UNIQUE KEY `inumber` (`inumber`), - KEY `itime` (`itime`), - FULLTEXT KEY `ibody` (`ibody`,`ititle`,`imore`) -) TYPE=MyISAM PACK_KEYS=0; - -INSERT INTO `nucleus_item` VALUES (1, 'Nucleus ¥Ð¡¼¥¸¥ç¥ó3.1¤Ø¤è¤¦¤³¤½', '¥¦¥§¥Ö¥Ú¡¼¥¸¤ÎºîÀ®¤òÊä½õ¤¹¤ëÀѤßÌÚ¤¬¤³¤³¤Ë¤¢¤ê¤Þ¤¹¡£¤½¤ì¤Ï¿´Ìö¤ëblog¤Ë¤Ê¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¤·¡¢´Ñ¤ë¤â¤Î¤òϤޤ»¤ë²È²¤Î¥Ú¡¼¥¸¤Ë¤Ê¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¤·¡¢¼Â¤ê¿¤­¼ñÌ£¤Î¥µ¥¤¥È¤Ë¤Ê¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¡£¤¢¤ë¤¤¤Ï¸½ºß¤Î¤¢¤Ê¤¿¤Ë¤ÏÁÛÁü¤¬¤Ä¤«¤Ê¤¤¤â¤Î¤Ë¤Ê¤ë¤³¤È¤À¤Ã¤Æ¤¢¤ë¤Ç¤·¤ç¤¦¡£
\r\n
\r\nÍÑÅÓ¤¬»×¤¤¤Ä¤­¤Þ¤»¤ó¤Ç¤·¤¿¤«¡©¡¡¤½¤ì¤Ê¤é¤³¤³¤ØÍè¤ÆÀµ²ò¤Ç¤¹¡¢¤Ê¤¼¤Ê¤é¤¢¤Ê¤¿Æ±Íͻ䤿¤Á¤Ë¤â¤ï¤«¤é¤Ê¤¤¤Î¤Ç¤¹¤«¤é¡£', 'Read Me
\r\n
\r\n¤³¤ì¤Ï¥µ¥¤¥È¤Ë¤ª¤±¤ëºÇ½é¤Î¥¨¥ó¥È¥ê¡¼¤Ç¤¹¡£¥¹¥¿¡¼¥È¤òÀÚ¤ê¤ä¤¹¤¤¤è¤¦¤Ë¡¢¥ê¥ó¥¯¤È¾ðÊó¤òÆþ¤ì¤Æ¤ª¤­¤Þ¤·¤¿¡£
\r\n
\r\n¤³¤Îµ­»ö¤òºï½ü¤¹¤ë¤³¤È¤â¤Ç¤­¤Þ¤¹¤¬¡¢¤É¤Á¤é¤Ë¤»¤èµ­»ö¤òÄɲ䷤Ƥ¤¤¯¤³¤È¤Ë¤è¤Ã¤Æ¤ä¤¬¤Æ¥á¥¤¥ó¥Ú¡¼¥¸¤«¤é¤Ï¸«¤¨¤Ê¤¯¤Ê¤ê¤Þ¤¹¡£Nucleus¤ò°·¤¦¤¦¤Á¤ËÀ¸¤¸¤¿¥á¥â¤ò¥³¥á¥ó¥È¤È¤·¤ÆÄɲä·¡¢¾­Í襢¥¯¥»¥¹¤Ç¤­¤ë¤è¤¦¤Ë¤³¤Î¥Ú¡¼¥¸¤ò¥Ö¥Ã¥¯¥Þ¡¼¥¯¤·¤Æ¤ª¤¯¤Î¤â¼ê¤Ç¤¹¡£
\r\n
\r\n¥ê¥ó¥¯
\r\n
\r\nNucleus CMS¤ÎËܲȤÈÆüËܸì¸ø¼°¥Ú¡¼¥¸¡£
\r\n
\r\nNucleus CMS¤ÎSourceForge¥×¥í¥¸¥§¥¯¥È¥Ú¡¼¥¸¡£
\r\n
\r\nNucleus CMS¤Î¥×¥é¥°¥¤¥óÁҸˤÈÆüËܸì¤Î¥ê¥¹¥È¥Ú¡¼¥¸¡£
\r\n
\r\n¥É¥­¥å¥á¥ó¥È
\r\n
\r\nNucleus¤ÎFAQ¡Ê¤è¤¯¤¢¤ë¼ÁÌ佸¡Ë¡Ê¸¶Ê¸¡Ë¥Ú¡¼¥¸¡£
\r\n
\r\n¥¤¥ó¥¹¥È¡¼¥ëÊýË¡Åù¤Ï¥æ¡¼¥¶¡¼¸þ¤±¤È³«È¯¼Ô¸þ¤±Ê¸½ñ¤¬¥Õ¥¡¥¤¥ë¤Ë´Þ¤Þ¤ì¤Æ¤¤¤Þ¤¹¡£
\r\n
\r\n¥Ý¥Ã¥×¥¢¥Ã¥×¥Ø¥ë¥×¤¬´ÉÍý¥¨¥ê¥¢¤Î¤¤¤¿¤ë¤È¤³¤í¤Ë¤¢¤ê¡¢¥µ¥¤¥È¤Î¥«¥¹¥¿¥Þ¥¤¥º¤ä¥Ç¥¶¥¤¥ó¤ò¼ê½õ¤±¤·¤Æ¤¯¤ì¤ë¤³¤È¤Ç¤·¤ç¤¦¡£
\r\n
\r\n°ìÅÙÍÑ°Õ¤µ¤ì¤Æ¤¤¤ë¥É¥­¥å¥á¥ó¥È¤ËÌܤòÄ̤·¤¿¤é¡¢Wiki¡ÊÆüËÜÈǡˤòˬ¤ì¤Æ¤¯¤À¤µ¤¤¡£¥æ¡¼¥¶¡¼¤Î½ñ¤¤¤¿¥Ï¥¦¥Ä¡¼¤ä¾®µ»¤¬·ÇºÜ¤µ¤ì¤Æ¤¤¤Þ¤¹¡£
\r\n
\r\n¥µ¥Ý¡¼¥È
\r\n
\r\nbeheerders¡Ê³«È¯¿Ø¡©¡Ë¤È¥µ¥Ý¡¼¥È¥Õ¥©¡¼¥é¥à¡ÊËܲȡˤdzèÆ°¤¹¤ë¥Ü¥é¥ó¥Æ¥£¥¢¤Ë´¶¼Õ¤·¤Þ¤¹¡£
\r\n
\r\n- admun - Ottawa, ON, Canada
\r\n- anand - Bangalore, India
\r\n- hcgtv - Miami, Florida, USA
\r\n- ikeizer - Maastricht
\r\n- moraes - Brazil
\r\n- roel - The Netherlands
\r\n- TeRanEX - Ekeren, Antwerp, Belgium
\r\n- Trent - Alberta, Canada
\r\n- xiffy - Deventer
\r\n
\r\n¤â¤·¼ê½õ¤±¤¬É¬Íפʤ顢1000¤òĶ¤¨¤ëÅÐÏ¿¥æ¡¼¥¶¡¼¤Î¤¤¤ë»ä¤¿¤Á¤Î¥Õ¥©¡¼¥é¥à¤Ë»²²Ã¤·¤Æ¤¯¤À¤µ¤¤¡£15000¤òĶ¤¨¤ëÅê¹Æ¤µ¤ì¤¿µ­»ö¤ò¸¡º÷¤Ç¤­¤ë¤è¤¦¤Ë¤Ê¤Ã¤Æ¤ª¤ê¤Þ¤¹¤Î¤Ç¡¢µá¤á¤ëÅú¤¨¤Ë¿ô²ó¤Î¥¯¥ê¥Ã¥¯¤Ç¤¿¤É¤êÃ失¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¡£
\r\n
\r\nÍøÍÑ¥µ¥¤¥È¤Î°ìÎã
\r\n
\r\n531¤ÎÅÐÏ¿¤µ¤ì¤¿Nucleus¤Ç±¿ÍѤµ¤ì¤Æ¤¤¤ë¥µ¥¤¥È¡ÊÆüËÜÈǡˤÎÃ椫¤éÆÿ§¤¢¤ë¥µ¥¤¥È¤ò¥µ¥ó¥×¥ë¤È¤·¤Æ¤´¾Ò²ð¤·¤Þ¤¹¡£
\r\n
\r\n- bloggard.com - The Adventures of Bloggard
\r\n- battleangel.org - Giving meaning to the meaningless.
\r\n- tipos.com.br - Blogging community: multiple user blogs.
\r\n- hsbluebird.com - Hot Springs, Montana\'s Online Resource for Guests.
\r\n- alloutgames.com - Hard core without the hate!
\r\n- adrenalinsports.nl - Extreme sports.
\r\n- reductioadabsurdum.net - A Conservative Review of Politics and Culture.
\r\n
\r\n¥Þ¥ë¥Á¥¦¥§¥Ö¥í¥°¤È¥¹¥­¥ó/¥Æ¥ó¥×¥ì¡¼¥È¤ÎÁȤ߹ç¤ï¤»¤Ï¶¯ÎϤÊÁê¾è¸ú²Ì¤òÀ¸¤ß½Ð¤·¤Þ¤¹¡£¸Ä¿ÍŪ¤Ê¥µ¥¤¥ÈºîÀ®¡¢Í§¿Í¤ä¿ÆÀ̤¢¤ë¤¤¤Ï¥¯¥é¥¤¥¢¥ó¥È¤ËÂФ¹¤ë¥µ¥¤¥È¥Ç¥¶¥¤¥ó¤¤¤º¤ì¤ËÂФ·¤Æ¤â¤Ç¤¹¡£
\r\n
\r\n¥Ç¥Õ¥©¥ë¥È¤ÇÄ󶡤µ¤ì¤Æ¤¤¤ëgrey¥¹¥­¥ó¤È¥Æ¥ó¥×¥ì¡¼¥È¤Ï¡¢Nucleus¤Ë¿Æ¤·¤ó¤Ç¤¤¤¯¤¿¤á¤Î¼ê»Ï¤á¤È»ë³ÐŪ¤Ê¥¬¥¤¥É¤È¤·¤ÆÌòΩ¤Ä¤³¤È¤Ç¤·¤ç¤¦¡£
\r\n
\r\n´óÉÕ¼Ô°ìÍ÷
\r\n
\r\n°Ê²¼¤ÎÁÇÀ²¤é¤·¤¤¿Í¡¹¤Ë¤è¤ë±ç½õ¤Ë´¶¼Õ¤òÊû¤²¤Þ¤¹¡£¤¢¤ê¤¬¤È¤¦¡ª
\r\n
\r\n- Gordon Shum
\r\n- Neal Stevens
\r\n- GamblingHelper
\r\n- Oliver Kirstein
\r\n- Dominiek
\r\n- Aardschok
\r\n- nieuwevoordeur.be
\r\n- Scene24
\r\n- Eug\'s Weblog
\r\n- The Adventures of Bloggard
\r\n- Arthur Cronos from Voltos
\r\n- Free Webmaster Tools and Resources
\r\n- Domi\'s Weblog
\r\n- Infodoma
\r\n- carvingCode.com
\r\n- Traweb
\r\n- Gene\'s MoBlog
\r\n- InterfaceThis
\r\n- The Finster Log
\r\n- Hop Nguyen
\r\n- Zwavelaars
\r\n- Joaquin Scholten
\r\n- Roel Groeneveld
\r\n- LVBlog
\r\n- Xander Mol
\r\n- Danilo Massa
\r\n- 01FTP.com
\r\n- Irmo Keizer
\r\n- Jason Krogh
\r\n- Osamu Higuchi
\r\n- Trent Adams
\r\n- Arne Hess
\r\n- The Bluebird
\r\n- Rainer Bickel
\r\n- Fritz Elfers
\r\n- Andy Fuchs
\r\n- Sumoforce
\r\n- Al\'ky\'mie
\r\n- Peter Johnson
\r\n- TriV Internet Solutions
\r\n- Margaret Stowe
\r\n- zenkey dot org
\r\n- Blots of Info
\r\n- Rudi De Kerpel
\r\n- Steve Taylor
\r\n- Malcolm Farnsworth
\r\n- Birgit Kellner
\r\n- Toby Johnson
\r\n- Kapingamarangi
\r\n- Pallalink
\r\n- PubliusTX Weblog
\r\n- Reductio Ad Absurdum
\r\n- GagaWeb
\r\n- Videokid
\r\n- Jon Marr
\r\n- Luigi Cristiano
\r\n- J Keith Lehman
\r\n- Bohemian Cachet
\r\n- Jesus Mourazos
\r\n- Stephen Jones
\r\n- One-Handed Apps
\r\n- Alwin Hawkins
\r\n- Justin Stigall
\r\n- It is my life
\r\n- Greg Morrill
\r\n- Dutch Submarines
\r\n- Seventh Watch Design Studios
\r\n- MacNetv2
\r\n- Richard Noordhof
\r\n- Jamie Rytlewski
\r\n
\r\nNucleus¤¬µ¤¤ËÆþ¤ê¤Þ¤·¤¿¤«¡©¡¡HotScripts¤Ç¤ÎÅêɼ¤ò¤ª´ê¤¤¤·¤Þ¤¹¡£
\r\n
\r\n¥é¥¤¥»¥ó¥¹
\r\n
\r\n»ä¤¿¤Á¤¬¥Õ¥ê¡¼¡¦¥½¥Õ¥È¥¦¥§¥¢¤Ë¤Ä¤¤¤Æ¸ý¤Ë¤¹¤ë¾ì¹ç¤Ï¼«Í³¤Î¤³¤È¤Ë¸ÀµÚ¤·¤Æ¤¤¤ë¤Î¤Ç¤¢¤Ã¤Æ¡¢²Á³Ê¤Î¤³¤È¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£»ä¤¿¤Á¤Î°ìÈ̸øÍ­»ÈÍѵöÂú½ñ¡ÊÆüËܸìÌõ¤È³µÍסˤϡ¢¥Õ¥ê¡¼¡¦¥½¥Õ¥È¥¦¥§¥¢¤ÎÊ£À½Êª¤ò¼«Í³¤ËÈÒÉۤǤ­¤ë¤³¤È(¤½¤·¤Æ¡¢Ë¾¤à¤Ê¤é¤³¤Î¥µ¡¼¥Ó¥¹¤ËÂФ·¤ÆÂвÁ¤òÀÁµá¤Ç¤­¤ë¤³¤È)¡¢¥½¡¼¥¹¡¦¥³¡¼¥É¤ò¼ÂºÝ¤Ë¼õ¤±¼è¤ë¤«´õ˾¤·¤µ¤¨¤¹¤ì¤ÐÆþ¼ê¤¹¤ë¤³¤È¤¬²Äǽ¤Ç¤¢¤ë¤³¤È¡¢Æþ¼ê¤·¤¿¥½¥Õ¥È¥¦¥§¥¢¤òÊѹ¹¤·¤¿¤ê¿·¤·¤¤¥Õ¥ê¡¼¡¦¥×¥í¥°¥é¥à¤Î°ìÉô¤È¤·¤Æ»ÈÍѤǤ­¤ë¤³¤È¡¢°Ê¾å¤Î³ÆÆâÍƤò¹Ô¤Ê¤¦¤³¤È¤¬¤Ç¤­¤ë¤È¤¤¤¦¤³¤È¤ò¥æ¡¼¥¶¼«¿È¤¬ÃΤäƤ¤¤ë¤³¤È¤ò¼Â¸½¤Ç¤­¤ë¤è¤¦¤Ë¥Ç¥¶¥¤¥ó¤µ¤ì¤Æ¤¤¤Þ¤¹¡£
\r\n', 1, 1, '2004-05-29 13:29:21', 0, 0, 0, 1, 0); - -CREATE TABLE `nucleus_karma` ( - `itemid` int(11) NOT NULL default '0', - `ip` char(15) NOT NULL default '' -) TYPE=MyISAM; - -CREATE TABLE `nucleus_member` ( - `mnumber` int(11) NOT NULL auto_increment, - `mname` varchar(16) NOT NULL default '', - `mrealname` varchar(60) default NULL, - `mpassword` varchar(40) NOT NULL default '', - `memail` varchar(60) default NULL, - `murl` varchar(100) default NULL, - `mnotes` varchar(100) default NULL, - `madmin` tinyint(2) NOT NULL default '0', - `mcanlogin` tinyint(2) NOT NULL default '1', - `mcookiekey` varchar(40) default NULL, - `deflang` varchar(20) NOT NULL default '', - PRIMARY KEY (`mnumber`), - UNIQUE KEY `mname` (`mname`), - UNIQUE KEY `mnumber` (`mnumber`) -) TYPE=MyISAM; - -INSERT INTO `nucleus_member` VALUES (1, 'God', 'Test User', '714d82a0a84f9c6e3495fe2aa5618627', 'example@example.org', 'http://localhost:8080/nucleus/', '', 1, 1, 'd95a775494f1b589011aed122f197c8a', ''); - -CREATE TABLE `nucleus_plugin` ( - `pid` int(11) NOT NULL auto_increment, - `pfile` varchar(40) NOT NULL default '', - `porder` int(11) NOT NULL default '0', - PRIMARY KEY (`pid`), - KEY `pid` (`pid`), - KEY `porder` (`porder`) -) TYPE=MyISAM; - -CREATE TABLE `nucleus_plugin_event` ( - `pid` int(11) NOT NULL default '0', - `event` varchar(40) default NULL, - KEY `pid` (`pid`) -) TYPE=MyISAM; - -CREATE TABLE `nucleus_plugin_option` ( - `ovalue` text NOT NULL, - `oid` int(11) NOT NULL auto_increment, - `ocontextid` int(11) NOT NULL default '0', - PRIMARY KEY (`oid`,`ocontextid`) -) TYPE=MyISAM; - -CREATE TABLE `nucleus_plugin_option_desc` ( - `oid` int(11) NOT NULL auto_increment, - `opid` int(11) NOT NULL default '0', - `oname` varchar(20) NOT NULL default '', - `ocontext` varchar(20) NOT NULL default '', - `odesc` varchar(255) default NULL, - `otype` varchar(20) default NULL, - `odef` text, - `oextra` text, - PRIMARY KEY (`opid`,`oname`,`ocontext`), - UNIQUE KEY `oid` (`oid`) -) TYPE=MyISAM; - -CREATE TABLE `nucleus_skin` ( - `sdesc` int(11) NOT NULL default '0', - `stype` varchar(20) NOT NULL default '', - `scontent` text NOT NULL, - PRIMARY KEY (`sdesc`,`stype`) -) TYPE=MyISAM; - -INSERT INTO `nucleus_skin` VALUES (2, 'index', '\r\n\r\n <%blogsetting(name)%>\r\n \r\n <%version%>\r\n <%blog(feeds/atom/modified,1)%>\r\n <%blog(feeds/atom/entries,10)%>\r\n'); -INSERT INTO `nucleus_skin` VALUES (4, 'index', '\r\n\r\n \r\n <%version%>\r\n http://nucleuscms.org/\r\n <%sitevar(url)%>\r\n \r\n \r\n http://nucleuscms.org/documentation/devdocs/xmlrpc.html\r\n \r\n \r\n http://nucleuscms.org/documentation/devdocs/xmlrpc.html\r\n \r\n \r\n \r\n'); -INSERT INTO `nucleus_skin` VALUES (3, 'index', '\r\n\r\n \r\n <%blogsetting(name)%>\r\n <%blogsetting(url)%>\r\n <%blogsetting(desc)%>\r\n \r\n ja \r\n <%version%>\r\n © \r\n Weblog\r\n http://backend.userland.com/rss\r\n \r\n <%adminurl%>nucleus2.gif\r\n <%blogsetting(name)%>\r\n <%blogsetting(url)%>\r\n \r\n <%blog(feeds/rss20,10)%>\r\n \r\n'); -INSERT INTO `nucleus_skin` VALUES (1, 'imagepopup', '\n\n\n \n <%imagetext%>\n \n\n\n <%image%>\n\n'); -INSERT INTO `nucleus_skin` VALUES (1, 'index', '\r\n\r\n\r\n\r\n \r\n <%blogsetting(name)%>\r\n\r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n\r\n\r\n\r\n\r\n\r\n
\r\n \r\n

<%blogsetting(name)%>

\r\n\r\n \r\n \r\n\r\n \r\n \r\n <%blog(grey/short,15)%>\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'); -INSERT INTO `nucleus_skin` VALUES (1, 'archive', '\r\n\r\n\r\n\r\n \r\n <%blogsetting(name)%>\r\n\r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n \r\n \r\n\r\n \r\n

<%blogsetting(name)%>

\r\n\r\n \r\n <%archive(grey/short)%>\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'); -INSERT INTO `nucleus_skin` VALUES (1, 'archivelist', '\r\n\r\n\r\n\r\n \r\n <%blogsetting(name)%>\r\n\r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n

<%blogsetting(name)%>

\r\n\r\n \r\n \r\n\r\n

Archives

\r\n \r\n <%archivelist(grey/short)%>\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'); -INSERT INTO `nucleus_skin` VALUES (1, 'error', '\r\n\r\n\r\n\r\n \r\n <%sitevar(name)%>\r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n \r\n \r\n\r\n \r\n

<%sitevar(name)%>

\r\n\r\n

Error!

\r\n\r\n

<%errormessage%>

\r\n\r\n

Go back

\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'); -INSERT INTO `nucleus_skin` VALUES (1, 'item', '\r\n\r\n\r\n\r\n \r\n <%itemtitle%> - <%blogsetting(name)%>\r\n\r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n \r\n

<%blogsetting(name)%>

\r\n\r\n \r\n \r\n\r\n \r\n <%item(grey/full)%>\r\n\r\n \r\n \r\n

Comments

\r\n <%comments(grey/full)%>\r\n\r\n

Add Comments

\r\n <%commentform%>\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'); -INSERT INTO `nucleus_skin` VALUES (1, 'member', '\r\n\r\n\r\n\r\n \r\n <%sitevar(name)%>\r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n \r\n \r\n\r\n \r\n

<%sitevar(name)%>

\r\n\r\n

Info about <%member(name)%>

\r\n\r\n \r\n\r\n

Send Message

\r\n <%membermailform%>\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'); -INSERT INTO `nucleus_skin` VALUES (1, 'search', '\r\n\r\n\r\n\r\n \r\n <%blogsetting(name)%>\r\n\r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n \r\n \r\n\r\n \r\n

<%blogsetting(name)%>

\r\n\r\n

Search

\r\n <%searchform%>\r\n\r\n

Search results

\r\n <%searchresults(grey/short)%>\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'); - -CREATE TABLE `nucleus_skin_desc` ( - `sdnumber` int(11) NOT NULL auto_increment, - `sdname` varchar(20) NOT NULL default '', - `sddesc` varchar(200) default NULL, - `sdtype` varchar(40) NOT NULL default 'text/html', - `sdincmode` varchar(10) NOT NULL default 'normal', - `sdincpref` varchar(50) NOT NULL default '', - PRIMARY KEY (`sdnumber`), - UNIQUE KEY `sdname` (`sdname`), - UNIQUE KEY `sdnumber` (`sdnumber`) -) TYPE=MyISAM; - -INSERT INTO `nucleus_skin_desc` VALUES (2, 'feeds/atom', 'Atom 0.3 weblog syndication', 'application/atom+xml', 'normal', ''); -INSERT INTO `nucleus_skin_desc` VALUES (3, 'feeds/rss20', 'RSS 2.0 syndication of weblogs', 'text/xml', 'normal', ''); -INSERT INTO `nucleus_skin_desc` VALUES (4, 'api/rsd', 'RSD (Really Simple Discovery) information for weblog clients', 'text/xml', 'normal', ''); -INSERT INTO `nucleus_skin_desc` VALUES (1, 'grey', 'Default skin to display your blog', 'text/html', 'skindir', 'grey/'); - -CREATE TABLE `nucleus_team` ( - `tmember` int(11) NOT NULL default '0', - `tblog` int(11) NOT NULL default '0', - `tadmin` tinyint(2) NOT NULL default '0', - PRIMARY KEY (`tmember`,`tblog`) -) TYPE=MyISAM; - -INSERT INTO `nucleus_team` VALUES (1, 1, 1); - -CREATE TABLE `nucleus_template` ( - `tdesc` int(11) NOT NULL default '0', - `tpartname` varchar(20) NOT NULL default '', - `tcontent` text NOT NULL, - PRIMARY KEY (`tdesc`,`tpartname`) -) TYPE=MyISAM; - -INSERT INTO `nucleus_template` VALUES (3, 'ITEM', '\r\n <![CDATA[<%title%>]]>\r\n <%blogurl%>?itemid=<%itemid%>\r\n<%more%>]]>\r\n <%category%>\r\n<%blogurl%>?itemid=<%itemid%>\r\n <%date(rfc822)%>\r\n'); -INSERT INTO `nucleus_template` VALUES (3, 'EDITLINK', 'edit'); -INSERT INTO `nucleus_template` VALUES (4, 'ITEM', '<%date(utc)%>'); -INSERT INTO `nucleus_template` VALUES (5, 'ITEM', '\r\n <![CDATA[<%title%>]]>\r\n \r\n \r\n <%author%>\r\n \r\n <%date(utc)%>\r\n <%date(iso8601)%>\r\n <%more%>]]>\r\n <%blogurl%>:<%blogid%>:<%itemid%>\r\n'); -INSERT INTO `nucleus_template` VALUES (1, 'ARCHIVELIST_FOOTER', ''); -INSERT INTO `nucleus_template` VALUES (1, 'ARCHIVELIST_HEADER', ''); -INSERT INTO `nucleus_template` VALUES (1, 'CATLIST_HEADER', '