Skip to content
This repository was archived by the owner on Feb 7, 2024. It is now read-only.

Commit 4590b58

Browse files
cicalesecicalese
committed
Updated schema to include version record table
1 parent ced8d22 commit 4590b58

File tree

4 files changed

+55
-16
lines changed

4 files changed

+55
-16
lines changed

‎sql/mysql/tables.sql‎

Lines changed: 11 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -17,6 +17,7 @@ CREATE TABLE /*_*/w8y_scrape_records (
1717
w8y_sr_api_url VARCHAR(255) NOT NULL,
1818
w8y_sr_timestamp INT UNSIGNED NOT NULL,
1919
w8y_sr_is_alive TINYINT(1) NOT NULL,
20+
w8y_sr_vr_id INT UNSIGNED NOT NULL,
2021
w8y_sr_mw_version VARCHAR(255) DEFAULT NULL,
2122
w8y_sr_db_version VARCHAR(255) DEFAULT NULL,
2223
w8y_sr_php_version VARCHAR(255) DEFAULT NULL,
@@ -29,21 +30,27 @@ CREATE TABLE /*_*/w8y_scrape_records (
2930
) /*$wgDBTableOptions*/;
3031

3132

33+
CREATE TABLE /*_*/w8y_version_records (
34+
w8y_vr_vr_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
35+
PRIMARY KEY(w8y_vr_vr_id)
36+
) /*$wgDBTableOptions*/;
37+
38+
3239
CREATE TABLE /*_*/w8y_skins (
33-
w8y_sk_sr_id INT UNSIGNED NOT NULL,
40+
w8y_sk_vr_id INT UNSIGNED NOT NULL,
3441
w8y_sk_name VARCHAR(255) NOT NULL,
3542
w8y_sk_version VARCHAR(255) DEFAULT NULL,
3643
w8y_sk_doc_url VARCHAR(255) DEFAULT NULL,
37-
PRIMARY KEY(w8y_sk_sr_id, w8y_sk_name)
44+
PRIMARY KEY(w8y_sk_vr_id, w8y_sk_name)
3845
) /*$wgDBTableOptions*/;
3946

4047

4148
CREATE TABLE /*_*/w8y_extensions (
42-
w8y_ex_sr_id INT UNSIGNED NOT NULL,
49+
w8y_ex_vr_id INT UNSIGNED NOT NULL,
4350
w8y_ex_name VARCHAR(255) NOT NULL,
4451
w8y_ex_version VARCHAR(255) DEFAULT NULL,
4552
w8y_ex_doc_url VARCHAR(255) DEFAULT NULL,
46-
PRIMARY KEY(w8y_ex_sr_id, w8y_ex_name)
53+
PRIMARY KEY(w8y_ex_vr_id, w8y_ex_name)
4754
) /*$wgDBTableOptions*/;
4855

4956

‎sql/postgres/tables.sql‎

Lines changed: 11 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -17,6 +17,7 @@ CREATE TABLE w8y_scrape_records (
1717
w8y_sr_api_url VARCHAR(255) NOT NULL,
1818
w8y_sr_timestamp INT NOT NULL,
1919
w8y_sr_is_alive BOOLEAN NOT NULL,
20+
w8y_sr_vr_id INT NOT NULL,
2021
w8y_sr_mw_version VARCHAR(255) DEFAULT NULL,
2122
w8y_sr_db_version VARCHAR(255) DEFAULT NULL,
2223
w8y_sr_php_version VARCHAR(255) DEFAULT NULL,
@@ -29,21 +30,27 @@ CREATE TABLE w8y_scrape_records (
2930
);
3031

3132

33+
CREATE TABLE w8y_version_records (
34+
w8y_vr_vr_id SERIAL NOT NULL,
35+
PRIMARY KEY(w8y_vr_vr_id)
36+
);
37+
38+
3239
CREATE TABLE w8y_skins (
33-
w8y_sk_sr_id INT NOT NULL,
40+
w8y_sk_vr_id INT NOT NULL,
3441
w8y_sk_name VARCHAR(255) NOT NULL,
3542
w8y_sk_version VARCHAR(255) DEFAULT NULL,
3643
w8y_sk_doc_url VARCHAR(255) DEFAULT NULL,
37-
PRIMARY KEY(w8y_sk_sr_id, w8y_sk_name)
44+
PRIMARY KEY(w8y_sk_vr_id, w8y_sk_name)
3845
);
3946

4047

4148
CREATE TABLE w8y_extensions (
42-
w8y_ex_sr_id INT NOT NULL,
49+
w8y_ex_vr_id INT NOT NULL,
4350
w8y_ex_name VARCHAR(255) NOT NULL,
4451
w8y_ex_version VARCHAR(255) DEFAULT NULL,
4552
w8y_ex_doc_url VARCHAR(255) DEFAULT NULL,
46-
PRIMARY KEY(w8y_ex_sr_id, w8y_ex_name)
53+
PRIMARY KEY(w8y_ex_vr_id, w8y_ex_name)
4754
);
4855

4956

‎sql/sqlite/tables.sql‎

Lines changed: 10 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -17,6 +17,7 @@ CREATE TABLE /*_*/w8y_scrape_records (
1717
w8y_sr_api_url VARCHAR(255) NOT NULL,
1818
w8y_sr_timestamp INTEGER UNSIGNED NOT NULL,
1919
w8y_sr_is_alive BOOLEAN NOT NULL,
20+
w8y_sr_vr_id INTEGER UNSIGNED NOT NULL,
2021
w8y_sr_mw_version VARCHAR(255) DEFAULT NULL,
2122
w8y_sr_db_version VARCHAR(255) DEFAULT NULL,
2223
w8y_sr_php_version VARCHAR(255) DEFAULT NULL,
@@ -28,21 +29,26 @@ CREATE TABLE /*_*/w8y_scrape_records (
2829
);
2930

3031

32+
CREATE TABLE /*_*/w8y_version_records (
33+
w8y_vr_vr_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL
34+
);
35+
36+
3137
CREATE TABLE /*_*/w8y_skins (
32-
w8y_sk_sr_id INTEGER UNSIGNED NOT NULL,
38+
w8y_sk_vr_id INTEGER UNSIGNED NOT NULL,
3339
w8y_sk_name VARCHAR(255) NOT NULL,
3440
w8y_sk_version VARCHAR(255) DEFAULT NULL,
3541
w8y_sk_doc_url VARCHAR(255) DEFAULT NULL,
36-
PRIMARY KEY(w8y_sk_sr_id, w8y_sk_name)
42+
PRIMARY KEY(w8y_sk_vr_id, w8y_sk_name)
3743
);
3844

3945

4046
CREATE TABLE /*_*/w8y_extensions (
41-
w8y_ex_sr_id INTEGER UNSIGNED NOT NULL,
47+
w8y_ex_vr_id INTEGER UNSIGNED NOT NULL,
4248
w8y_ex_name VARCHAR(255) NOT NULL,
4349
w8y_ex_version VARCHAR(255) DEFAULT NULL,
4450
w8y_ex_doc_url VARCHAR(255) DEFAULT NULL,
45-
PRIMARY KEY(w8y_ex_sr_id, w8y_ex_name)
51+
PRIMARY KEY(w8y_ex_vr_id, w8y_ex_name)
4652
);
4753

4854

‎sql/tables.json‎

Lines changed: 23 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -56,6 +56,11 @@
5656
"type": "boolean",
5757
"options": { "notnull": true }
5858
},
59+
{
60+
"name": "w8y_sr_vr_id",
61+
"type": "integer",
62+
"options": { "unsigned": true, "notnull": true }
63+
},
5964
{
6065
"name": "w8y_sr_mw_version",
6166
"type": "string",
@@ -102,11 +107,25 @@
102107
"w8y_sr_sr_id"
103108
]
104109
},
110+
{
111+
"name": "w8y_version_records",
112+
"columns": [
113+
{
114+
"name": "w8y_vr_vr_id",
115+
"type": "integer",
116+
"options": { "unsigned": true, "notnull": true, "autoincrement": true }
117+
}
118+
],
119+
"indexes": [],
120+
"pk": [
121+
"w8y_vr_vr_id"
122+
]
123+
},
105124
{
106125
"name": "w8y_skins",
107126
"columns": [
108127
{
109-
"name": "w8y_sk_sr_id",
128+
"name": "w8y_sk_vr_id",
110129
"type": "integer",
111130
"options": { "unsigned": true, "notnull": true }
112131
},
@@ -128,14 +147,14 @@
128147
],
129148
"indexes": [],
130149
"pk": [
131-
"w8y_sk_sr_id", "w8y_sk_name"
150+
"w8y_sk_vr_id", "w8y_sk_name"
132151
]
133152
},
134153
{
135154
"name": "w8y_extensions",
136155
"columns": [
137156
{
138-
"name": "w8y_ex_sr_id",
157+
"name": "w8y_ex_vr_id",
139158
"type": "integer",
140159
"options": { "unsigned": true, "notnull": true }
141160
},
@@ -157,7 +176,7 @@
157176
],
158177
"indexes": [],
159178
"pk": [
160-
"w8y_ex_sr_id", "w8y_ex_name"
179+
"w8y_ex_vr_id", "w8y_ex_name"
161180
]
162181
},
163182
{

0 commit comments

Comments
 (0)