head	1.4;
access;
symbols
	JSBoard-2_0_15:1.4
	JSBoard-2_0_14:1.3
	JSBoard-2_0_13:1.3
	JSBoard-2_0_12:1.3
	JSBoard-2_0_11:1.3
	JSBoard-2_0_10:1.3
	JSBoard-2_0_9:1.3
	JSBoard-2_0_7:1.3
	JSBoard-2_0_6:1.3
	JSBoard-2_0_5:1.3
	JSboard-2:1.3
	branch-release-1-0:1.3.0.2
	JSBoard-2_0_4:1.3
	JSBoard-2_0_3:1.3
	JSBoard-2_0_2:1.3
	JSBoard-2_0_1:1.3
	JSBoard-2_0_0:1.3
	JSBoard-2_0pre4:1.2
	jsboard-2_0pre3:1.1.1.1
	start:1.1.1.1
	JSBoardOpenProject:1.1.1;
locks; strict;
comment	@# @;


1.4
date	2009.11.19.05.29.50;	author oops;	state Exp;
branches;
next	1.3;

1.3
date	2002.07.20.17.41.57;	author oops;	state Exp;
branches;
next	1.2;

1.2
date	2001.12.29.08.07.55;	author oops;	state Exp;
branches;
next	1.1;

1.1
date	2001.12.04.05.48.43;	author oops;	state Exp;
branches
	1.1.1.1;
next	;

1.1.1.1
date	2001.12.04.05.48.43;	author oops;	state Exp;
branches;
next	;


desc
@@


1.4
log
@add cvs id
@
text
@$Id: $

JSBoard main table

+--------+--------------+------+-----+---------+----------------+
| Field  | Type         | Null | Key | Default | Extra          |
+--------+--------------+------+-----+---------+----------------+
| no     | int(6)       |      | PRI | 0       | auto_increment |  Unique Number
| num    | int(6)       |      | MUL | 0       |                |  Number of Article
| idx    | int(6)       |      | MUL | 0       |                |  Number of index(listing)
| date   | int(11)      |      | MUL | 0       |                |  Date
| host   | tinytext     | YES  |     | NULL    |                |  Address of writer
| name   | tinytext     | YES  |     | NULL    |                |  NICK Name of writer
| rname  | tinytext     | YES  |     | NULL    |                |  REAL Name of writer
| passwd | varchar(56)  | YES  |     | NULL    |                |  Password of writer
| email  | tinytext     | YES  |     | NULL    |                |  Email of writer
| url    | tinytext     | YES  |     | NULL    |                |  Homepage of writer
| title  | tinytext     | YES  |     | NULL    |                |  Subject of article
| text   | mediumtext   | YES  |     | NULL    |                |  Content of article
| refer  | int(6)       |      |     | 0       |                |  Number of Read
| reyn   | int(1)       |      |     | 0       |                |  If exists reply article
| reno   | int(6)       |      | MUL | 0       |                |  Number of parents article
| rede   | int(6)       |      |     | 0       |                |  Depth of reply article
| reto   | int(6)       |      | MUL | 0       |                |  Number of founder reply article
| html   | int(1)       |      |     | 1       |                |  If use HTML tag
| bofile | varchar(100) | YES  |     | NULL    |                |  Name of upload file
| bcfile | varchar(100) | YES  |     | NULL    |                |  Name of upload directory
| bfsize | int(4)       | YES  |     | NULL    |                |  Size of upload file
+--------+--------------+------+-----+---------+----------------+



JSBoard userdb table

+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| no       | int(6)       |      | PRI | NULL    | auto_increment | Unique Number
| nid      | varchar(100) |      | UNI |         |                | ID of User(Unique)
| name     | varchar(100) |      | MUL |         |                | Name of User
| email    | tinytext     |      |     |         |                | Email of User
| url      | tinytext     |      |     |         |                | Homepage of User
| passwd   | varchar(100) |      |     |         |                | Password of User(encryption)
| position | int(1)       |      | MUL | 0       |                | Whole admin check
+----------+--------------+------+-----+---------+----------------+



JSBoard comment table

+--------+-------------+------+-----+---------+----------------+
| Field  | Type        | Null | Key | Default | Extra          |
+--------+-------------+------+-----+---------+----------------+
| no     | int(6)      |      | PRI | NULL    | auto_increment |    Unique Number
| reno   | int(20)     |      | MUL | 0       |                |    Number of parents article
| rname  | tinytext    | YES  |     | NULL    |                |    name of writer
| name   | tinytext    | YES  |     | NULL    |                |    ID of writer
| passwd | varchar(56) | YES  |     | NULL    |                |    password
| text   | mediumtext  | YES  |     | NULL    |                |    comment body
| host   | tinytext    | YES  |     | NULL    |                |    regist address of comment
| date   | int(11)     |      |     | 0       |                |    regist date of comment
+--------+-------------+------+-----+---------+----------------+

@


1.3
log
@update documents
@
text
@d1 1
@


1.2
log
@update 20011229170524.diff
@
text
@a29 1
requests mean of moder record to redhands at linux.sarang.net
d45 18
@


1.1
log
@Initial revision
@
text
@d12 3
a14 2
| name   | tinytext     | YES  |     | NULL    |                |  Name of writer
| passwd | varchar(13)  | YES  |     | NULL    |                |  Password of writer
a24 1
| moder  | int(1)       |      |     | 0       |                |  ?
@


1.1.1.1
log
@JSBoard-2.x
@
text
@@
