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);
 	}
 }