Just reviewing code formatting.

[nucleus-jp/nucleus-jp-ancient.git] / utf8 / install / install.sql

diff --git a/utf8/install/install.sql b/utf8/install/install.sql
index bf2fbf8..02fdfbf 100755 (executable)
--- a/utf8/install/install.sql
+++ b/utf8/install/install.sql
@@ -88,7 +88,8 @@ CREATE TABLE `nucleus_comment` (
   `cblog`   int(11)      NOT NULL default '0',
   PRIMARY KEY  (`cnumber`),
   KEY `citem` (`citem`),
-  FULLTEXT KEY `cbody` (`cbody`)
+  FULLTEXT KEY `cbody` (`cbody`),
+  INDEX `cblog` (`cblog`)
 ) TYPE=MyISAM;
 
 CREATE TABLE `nucleus_config` (
@@ -131,7 +132,8 @@ INSERT INTO `nucleus_config` (`name`, `value`) VALUES
     ('URLMode',           'normal'),
     ('DatabaseVersion',   '350'),
     ('DebugVars',         '0'),
-    ('DefaultListSize',   '10');
+    ('DefaultListSize',   '10'),
+    ('AdminCSS',          'contemporary_jp');
 
 CREATE TABLE `nucleus_item` (
   `inumber`   int(11)      NOT NULL auto_increment,
@@ -149,6 +151,9 @@ CREATE TABLE `nucleus_item` (
   `iposted`   tinyint(2)   NOT NULL default '1',
   PRIMARY KEY  (`inumber`),
   KEY `itime` (`itime`),
+  INDEX `iblog` (`iblog`),\r
+  INDEX `idraft` (`idraft`),\r
+  INDEX `icat` (`icat`),
   FULLTEXT KEY `ibody` (`ibody`, `ititle`, `imore`)
 ) TYPE=MyISAM PACK_KEYS=0;