X-Git-Url: http://git.sourceforge.jp/view?p=nucleus-jp%2Fnucleus-jp-ancient.git;a=blobdiff_plain;f=utf8%2Fnucleus%2Fdocumentation%2Fdevdocs%2Fsqltables.html;h=bfcfab0c492aaa37adb1f6583d9f6bb1609b0c57;hp=64e5bc7f063a7dec9e9a4fcb1dfb8c6f313f64b3;hb=b2b24bddc4efe4c0c3d6e26d7500d3df34f65fd2;hpb=502b5af74f2f3008daf5a6ac13daa929d4df1ca2
diff --git a/utf8/nucleus/documentation/devdocs/sqltables.html b/utf8/nucleus/documentation/devdocs/sqltables.html
index 64e5bc7..bfcfab0 100755
--- a/utf8/nucleus/documentation/devdocs/sqltables.html
+++ b/utf8/nucleus/documentation/devdocs/sqltables.html
@@ -1,46 +1,70 @@
-
-
+
-
-Nucleus - SQL Table Structure
+
+
+
+ Nucleus - SQL ãã¼ãã«æ§é
-
-
+ .autoinc {
+ }
+
+ /* primary-keys */
+ .primary {
+ text-decoration: underline;
+ font-weight: bold;
+ }
+
+ /* NOT NULL */
+ .notnull {
+ }
+
+ /* unique key */
+ .unique {
+ }
+
+ /* foreign keys */
+ .foreign {
+ font-style: italic;
+ }
+
+ /* auto increment table columns*/
+ .autoinc {
+ }
+
+ /* fulltext index */
+ .fulltext {
+ }
+
+ /* columns/tables to remove in later versions */
+ .toremove {
+ color: red;
+ }
+
+
+
+
+
+
- SQLãã¼ãã«ã»ãªãã¡ã¬ã³ã¹ May 30, 2004
+ SQLãã¼ãã«ã»ãªãã¡ã¬ã³ã¹ 2005å¹´3æ5æ¥
訳è
注ï¼
ã¯ããã«
éçºè
åãããã¥ã¡ã³ãã®ç®æ¬¡ã¸æ»ã
ãã®ããã¥ã¡ã³ãã¯Nucleusã®ãã¼ã¿ãã¼ã¹ã»ãã¼ãã«ã®ãã£ã¼ã«ãã解説ãã¦ãã¾ãã
-æ§é ã¯Nucleus v3.0ã®ãã®ã«å¾ã£ã¦ãã¾ã
+æ§é ã¯Nucleus v3.2ã®ãã®ã«å¾ã£ã¦ãã¾ã
ç®æ¬¡
+ nucleus_tickets
+ nucleus_activation
ãã®ä»
@@ -117,7 +143,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -154,7 +180,7 @@
bmaxcomments |
int(11) |
'0' |
- indexã¹ãã³ã¿ã¤ãã§è¡¨ç¤ºããã³ã¡ã³ãã®æ大æ°ãè¦å®å¤(0)ã¯å¶éããªããã¨ã説æãããã¤ã³ã©ã¤ã³ã»ã³ã¡ã³ãã使ããªãã®ãªãï¼ããã¯ããããªãã㨠|
+ indexã¹ãã³ã¿ã¤ãã§è¡¨ç¤ºããã³ã¡ã³ãã®æ大æ°ãæ¢å®å¤(0)ã¯å¶éããªããã¨ã説æãããã¤ã³ã©ã¤ã³ã»ã³ã¡ã³ãã使ããªãã®ãªãï¼ããã¯ããããªãã㨠|
btimeoffset |
@@ -220,7 +246,7 @@
5: æ°ããã«ã«ãæ票
7: æ°ããã¢ã¤ãã
- è¦å®å¤ = æ°ããã³ã¡ã³ãã¨æ°ããã«ã«ãæ票ï¼3Ã5=15ï¼
+ æ¢å®å¤ = æ°ããã³ã¡ã³ãã¨æ°ããã«ã«ãæ票ï¼3Ã5=15ï¼
ballowpast |
@@ -243,7 +269,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -279,7 +305,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -347,7 +373,7 @@
ikarmaneg |
int(11) |
'0' |
- ï¼ã®ã«ã«ãæ票ã®ç·æ° |
+ âã®ã«ã«ãæ票ã®ç·æ° |
icat |
@@ -364,7 +390,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -436,7 +462,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -516,7 +542,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -546,7 +572,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -577,7 +603,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -602,7 +628,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -640,7 +666,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -685,7 +711,7 @@
odef |
text |
|
- ãªãã·ã§ã³ã®è¦å®å¤ |
+ ãªãã·ã§ã³ã®æ¢å®å¤ |
oextra |
@@ -702,7 +728,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -743,7 +769,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -796,7 +822,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -851,7 +877,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -908,7 +934,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -933,7 +959,7 @@
Name |
- è¦å®å¤ Value |
+ æ¢å®å¤ Value |
説æ |
@@ -1037,6 +1063,11 @@
ã¯ããã¼ãã»ãããããã¹ |
+ CookiePrefix |
+ |
+ ã¯ããã¼ã®å称ã«è¿½å ãããã¬ãã£ã¯ã¹æååãè¤æ°ã® Nucleus ãåããã¡ã¤ã³ã«ã¤ã³ã¹ãã¼ã«ããéã«ä¾¿å©ã§ãå¥ã® Nucleus ã§åãã»ãã·ã§ã³ãé©ç¨ããããã¨ãäºé²ããã
+ |
+
CookieDomain |
|
ã¯ããã¼ãã»ãããããã¡ã¤ã³ |
@@ -1100,6 +1131,90 @@
+
+
+nucleus_ticketsãã¼ãã«
+
+Nucleus 㯠nucleus_tickets
ã使ç¨ãããã¨ã«ããã»ãã¥ãªãã£ä¸ã®åé¡ãäºé²ãããç¹ã«ã管çã¨ãªã¢ã«ããã¦è«¸è¨å®ããã¼ã¿ãã¼ã¹ã®å
容ã«å½±é¿ããå ´åããã±ãããå¿
é ã¨ããããã±ããã¯ç®¡çãã¼ã¸ããªã¯ã¨ã¹ããããæã¨ãã©ã¼ã ããå¼ã³åºãããæã«çºè¡ãããããã±ããã¯çºè¡ãã 1æéå¾ã«ç ´æ£ãããã
+
+
+
+ ã«ã©ã å |
+ å |
+ æ¢å®å¤ |
+ 説æ |
+
+
+ ticket |
+ varchar(40) |
+ |
+ ç¹å®ã®åä¸ã¦ã¼ã¶ã«å²ãå½ã¦ãããã¦ãã¼ã¯ãªãã±ãããä¸è¬ã«ããã±ããã¯æ¬¡ã®ãããªå½¢ã«ãªã: 65303a785423b4d53c7b3e6579766f26 |
+
+
+ member |
+ int(11) |
+ |
+ å½è©²ãã±ãããæå¹é©ç¨ãããã¡ã³ãã¼ã |
+
+
+ ctime |
+ datetime |
+ |
+ ãã±ããã®çºè¡æ¥æããã±ããã®æå¹æé㯠1æéã§ããã |
+
+
+
+
+
+nucleus_activationãã¼ãã«
+
+æ°ããã¡ã³ãã¼ãç»é²ãããæç¹ã§ã¯ããã®ã¡ã³ãã¼ã¢ã«ã¦ã³ããã¢ã¯ãã£ãã¼ããããã¾ã§ Nucleus ã¯ãã°ã¤ã³ã許å¯ããªããã¢ã¯ãã£ãã¼ãã®ããã®ãªã³ã¯ãå«ãã¡ã¼ã«ãéä¿¡ãããããã«ãã£ã¦ã¢ã¯ãã£ãã¼ããããã¨ãã§ãããnucleus_activation
ãã¼ãã«ã¯ã¢ã¯ãã£ãã¼ãã®é²æç¶æ³ã追跡ããã
+
+
+
+ ã«ã©ã å |
+ å |
+ æ¢å®å¤ |
+ 説æ |
+
+
+ vkey |
+ varchar(40) |
+ |
+ ã¢ã¯ãã£ãã¼ããã¼ããã®ãã¼ã¯ã¡ã³ãã¼ã®ã¢ã¯ãã£ãã¼ãã³ã¼ãã«æ¸¡ããããä¸è¬çã«ããã¼ã¯æ¬¡ã®ãããªå½¢ã«ãªãï¼ 41cf637d4fbeeff954b4ca70b8bde9dd |
+
+
+ vmember |
+ int(11) |
+ |
+ ã¢ã¯ãã£ãã¼ãã®å¿
è¦ãããã¡ã³ãã¼ã |
+
+
+ vtime |
+ datetime |
+ |
+ ã¢ã¯ãã£ãã¼ããã¼ãçºè¡ãããæ¥æãã¢ã¯ãã£ãã¼ããã¼ã®æå¹æé㯠2æ¥éã§ããã |
+
+
+ vtype |
+ varchar(15) |
+ |
+ ã¢ã¯ãã£ãã¼ãã®ç¨®å¥ã
+
+ forgot : ãã¹ã¯ã¼ããå¿ããã¡ã³ãã¼ã
+ register : æ°ããç»é²ãããã¡ã³ãã¼ã
+ addresschange : ã¡ã¼ã«ã¢ãã¬ã¹ãå¤æ´ããã¡ã³ãã¼ã
+
+ |
+
+
+ vextra |
+ varchar(128) |
+ |
+ 追å çãªæ
å ±ãã¢ã¯ãã£ãã¼ã種å¥ã addresschange ã®å ´åãããã«ã¯ oldemailaddress/x ã¨ãã¦ãx ã«ã¯ 0 ã¾ã㯠1 ã®å¤ãå
¥ããx 㯠memberãã¼ãã«ã«ãã mcanlogin ã®å¤ãåç
§ãããï¼ã¢ã¯ãã£ãã¼ããå®å
¨ã«çµäºããã¾ã§ããã®ã¦ã¼ã¶ã¯ãã°ã¤ã³ã§ããªãï¼ |
+
+
+
nucleus_karmaãã¼ãã«
ãã®ãã¼ãã«ã¯å°æ¥ã¯ãªããªãå¯è½æ§ãé«ããåãæ©è½ãæä¾ãããã©ã°ã¤ã³ã«è²ãããã ã
@@ -1109,7 +1224,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -1135,7 +1250,7 @@
ã«ã©ã å |
å |
- è¦å®å¤ |
+ æ¢å®å¤ |
説æ |
@@ -1162,3 +1277,4 @@
+