summaryrefslogtreecommitdiff
path: root/src/shim/shim.php
diff options
context:
space:
mode:
authorFreya Murphy <freya@freyacat.org>2024-12-20 04:15:58 -0500
committerFreya Murphy <freya@freyacat.org>2024-12-20 04:17:05 -0500
commit4334596d4bebc9a76f5ca8400813847eef5b3bb7 (patch)
tree4bd2229fd48715bcf4ae96bc3d070b7f3c29aa58 /src/shim/shim.php
parentadd lang column to user (diff)
downloadxssbook2-4334596d4bebc9a76f5ca8400813847eef5b3bb7.tar.gz
xssbook2-4334596d4bebc9a76f5ca8400813847eef5b3bb7.tar.bz2
xssbook2-4334596d4bebc9a76f5ca8400813847eef5b3bb7.zip
rework styles with scss
Diffstat (limited to 'src/shim/shim.php')
-rwxr-xr-xsrc/shim/shim.php26
1 files changed, 13 insertions, 13 deletions
diff --git a/src/shim/shim.php b/src/shim/shim.php
index 318d825..eb84412 100755
--- a/src/shim/shim.php
+++ b/src/shim/shim.php
@@ -69,12 +69,12 @@ function clear_all() {
extract($GLOBALS);
$psql->beginTransaction();
$psql->exec(
- 'DELETE FROM admin.user;
- DELETE FROM admin.post;
- DELETE FROM admin.comment;
- DELETE FROM admin.like;
- DELETE FROM admin.follow;
- DELETE FROM admin.user_media;'
+ 'DELETE FROM xssbook.user;
+ DELETE FROM xssbook.post;
+ DELETE FROM xssbook.comment;
+ DELETE FROM xssbook.like;
+ DELETE FROM xssbook.follow;
+ DELETE FROM xssbook.user_media;'
);
}
@@ -87,7 +87,7 @@ function migrate_users() {
'SELECT user_id, firstname, lastname, email, password, gender, date, day, month, year FROM users;'
);
$submit = $psql->prepare(
- 'INSERT INTO admin.user
+ 'INSERT INTO xssbook.user
(id, username, password, first_name, last_name, email, gender, birth_date, created)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, to_timestamp(?));'
@@ -125,7 +125,7 @@ function migrate_posts() {
'SELECT post_id, user_id, content, date FROM posts;'
);
$submit = $psql->prepare(
- 'INSERT INTO admin.post
+ 'INSERT INTO xssbook.post
(id, user_id, content, created)
VALUES
(?, ?, ?, to_timestamp(?));'
@@ -154,7 +154,7 @@ function migrate_comments() {
'SELECT comment_id, user_id, post_id, content, date FROM comments;'
);
$submit = $psql->prepare(
- 'INSERT INTO admin.comment
+ 'INSERT INTO xssbook.comment
(id, user_id, post_id, content, created)
VALUES
(?, ?, ?, ?, to_timestamp(?));'
@@ -184,7 +184,7 @@ function migrate_likes() {
'SELECT user_id, post_id FROM likes;'
);
$submit = $psql->prepare(
- 'INSERT INTO admin.like
+ 'INSERT INTO xssbook.like
(user_id, post_id)
VALUES
(?, ?);'
@@ -210,7 +210,7 @@ function migrate_follow() {
'SELECT follower_id, followee_id FROM friends;'
);
$submit = $psql->prepare(
- 'INSERT INTO admin.follow
+ 'INSERT INTO xssbook.follow
(follower_id, followee_id)
VALUES
(?, ?);'
@@ -233,7 +233,7 @@ function migrate_user_media($type) {
// load queries
$submit = $psql->prepare(
- 'INSERT INTO admin.user_media
+ 'INSERT INTO xssbook.user_media
(user_id, content, mime, type)
VALUES
(?, decode(?, \'base64\'), ?, ?);'
@@ -273,7 +273,7 @@ function migrate_seq() {
$tables = array('user', 'post', 'like', 'comment', 'follow', 'user_media');
foreach ($tables as $table) {
- $sql = "SELECT setval('sys.{$table}_id_seq', (SELECT MAX(id) FROM admin.{$table}), true);";
+ $sql = "SELECT setval('sys.{$table}_id_seq', (SELECT MAX(id) FROM xssbook.{$table}), true);";
$psql->exec($sql);
}
}