Maintenance script: Repair batch-0003 pages from live compare

2026-03-27T00:29:05Z

Repair batch-0003 pages from live compare

← Older revision		Revision as of 00:29, 27 March 2026
Line 1:		Line 1:
	{\| class="wikitable"		{\| class="wikitable" style="width:100%;"
	\|-		\|-
	\|		\|
	\|		\|
	\|		\|
	\| ~~{{{~cpp~~ book ~~}}}~~		\| <code>book</code>
	\|-		\|-
	\| bookid		\| bookid
Line 12:		Line 12:
	\|}		\|}

	{\| class="wikitable"		{\| class="wikitable" style="width:100%;"
	\|-		\|-
	\|		\|
	\|		\|
	\|		\|
	\| ~~{{{~cpp~~ BtoBRel ~~}}}~~		\| <code>BtoBRel</code>
	\|-		\|-
	\| uid		\| uid
Line 25:		Line 25:
	\|}		\|}

	{\| class="wikitable"		{\| class="wikitable" style="width:100%;"
	\|-		\|-
	\|		\|
Line 32:		Line 32:
	\|		\|
	\|		\|
	\| ~~{{{~cpp~~ UtoBRel ~~}}}~~		\| <code>UtoBRel</code>
	\|-		\|-
	\| uid		\| uid
Line 53:		Line 53:
	\|}		\|}

	{\| class="wikitable"		{\| class="wikitable" style="width:100%;"
	\|-		\|-
	\|		\|
Line 70:		Line 70:
	\|}		\|}

	~~~cpp~~ DataBase Create Query for MySQL		<code>DataBase Create Query for MySQL</code>
	{{{~cpp		{{{~cpp
	CREATE TABLE IF NOT EXISTS BtoBRel(		CREATE TABLE IF NOT EXISTS BtoBRel(
Line 118:		Line 118:
	----		----
	[[ProjectPrometheus]]/		[[ProjectPrometheus]]/
	~~~cpp~~ DataBaseSchema		<code>DataBaseSchema</code>

imported>Unknown at 05:24, 7 February 2021

2021-02-07T05:24:05Z

New page

{| class="wikitable"
|-
|
|
|
| {{{~cpp book }}}
|-
| bookid
| isbn
| totalpoint
| title
|}

{| class="wikitable"
|-
|
|
|
| {{{~cpp BtoBRel }}}
|-
| uid
| bookid
| relbookid
| relpoint
|}

{| class="wikitable"
|-
|
|
|
|
|
| {{{~cpp UtoBRel }}}
|-
| uid
| bookid
| userid
| viewpoint
| hviewpoint
| lviewpoint
|}

{| class="wikitable"
|-
|
|
| puser
|-
| userid
| password
| name
|}

{| class="wikitable"
|-
|
|
|
|
|
| review
|-
| uid
| regdate
| bookid
| userid
| title
| contents
|}

~cpp DataBase Create Query for MySQL
{{{~cpp
CREATE TABLE IF NOT EXISTS BtoBRel(
uid int (11) NOT NULL auto_increment,
bookid varchar(12) NOT NULL DEFAULT '',
relbookid varchar(12) NOT NULL DEFAULT '',
relpoint int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (uid)
);

CREATE TABLE IF NOT EXISTS UtoBRel(
uid int (11) NOT NULL auto_increment,
userid varchar(12) NOT NULL DEFAULT '',
bookid varchar(12) NOT NULL DEFAULT '',
viewpoint int(11) NOT NULL DEFAULT 0,
hviewpoint int(11) NOT NULL DEFAULT 0,
lviewpoint int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (uid)
);

CREATE TABLE IF NOT EXISTS book(
bookid varchar(12) NOT NULL DEFAULT '',
isbn varchar(10) NOT NULL DEFAULT '',
totalpoint int(11) NOT NULL DEFAULT 0,
title varchar(40) NOT NULL DEFAULT '',
PRIMARY KEY (bookid)
);

CREATE TABLE IF NOT EXISTS puser(
userid varchar(16) NOT NULL DEFAULT '',
password varchar(8) NOT NULL DEFAULT '',
name varchar(8) NOT NULL DEFAULT '',
PRIMARY KEY(userid)
);

CREATE TABLE review(
uid int (11) NOT NULL auto_increment,
regdate datetime,
bookid varchar(12) NOT NULL DEFAULT '',
userid varchar(16) NOT NULL DEFAULT '',
title varchar(40) NOT NULL DEFAULT '',
contents text NOT NULL DEFAULT '',
PRIMARY KEY(uid)
);
}}}
----
[[ProjectPrometheus]]/
~cpp DataBaseSchema

ProjectPrometheus/DataBaseSchema - Revision history

Maintenance script: Repair batch-0003 pages from live compare

imported>Unknown at 05:24, 7 February 2021