/install.sql |
---|
51,22 → 51,13 |
PRIMARY KEY(ID) |
); |
CREATE TABLE ForumTopics |
CREATE TABLE ForumPosts |
( |
ID INT NOT NUll AUTO_INCREMENT, |
AuthorID INT, |
CategoryID INT, |
ParentID INT, |
Title TEXT, |
DatePosted DATETIME, |
PRIMARY KEY(ID) |
); |
CREATE TABLE ForumPosts |
( |
ID INT NOT NUll AUTO_INCREMENT, |
AuthorID INT, |
TopicID INT, |
Title TEXT, |
Content TEXT, |
DatePosted DATETIME, |
Spam BOOLEAN, |
76,3 → 67,6 |
INSERT INTO Users VALUES (1, 0, "admin", SHA1("password"), "admins@tim32.org", "Tim32 Admin", 0); |
INSERT INTO BlogPosts VALUES(1, -1, 1, "Welcome to Tim32!", "Welcome to the new Tim32 website! It has had a complete design re-think to make it simpler and easier to use!", NOW(), "Tim32", FALSE); |
INSERT INTO Projects VALUES (1, 1, "TAIOS", "TAIOS (The All In One System) is a PHP based system to make the Tim32 website very self contained and altogether.", "http://websvn.kde.org/*checkout*/trunk/kdesupport/oxygen-icons/64x64/categories/applications-internet.png", "", "http://tim32.org/~tom/taios/", "SVN", NOW()); |
INSERT INTO ForumCategories VALUES (1, -1, "Tim32", "Talk about Tim32 in here"); |
INSERT INTO ForumCategories VALUES (2, 1, "TAIOS", "Talk about TAIOS in here"); |
INSERT INTO ForumPosts VALUES (1, 1, 2, -1, "TAIOS Almost Finished", "As I speak we are currently in the process of finilising TAIOS so it works perfectly! I'm pleased to accounce that TAIOS should be ready within the next week or so! :D", NOW(), FALSE); |
/photos/albums/ArchLinux Wallpapers/archlinux-berry.jpg |
---|
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
/photos/albums/ArchLinux Wallpapers/archlinux-berry.jpg |
---|
Property changes: |
Deleted: svn:mime-type |
## -1 +0,0 ## |
-application/octet-stream |
\ No newline at end of property |
Index: photos/albums/ArchLinux Wallpapers/archlinux-firestarter.jpg |
=================================================================== |
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
Index: photos/albums/ArchLinux Wallpapers/archlinux-firestarter.jpg |
=================================================================== |
--- photos/albums/ArchLinux Wallpapers/archlinux-firestarter.jpg (revision 241) |
+++ photos/albums/ArchLinux Wallpapers/archlinux-firestarter.jpg (nonexistent) |
/photos/albums/ArchLinux Wallpapers/archlinux-firestarter.jpg |
---|
Property changes: |
Deleted: svn:mime-type |
## -1 +0,0 ## |
-application/octet-stream |
\ No newline at end of property |
Index: photos/albums/Lassitor/Lassitor.png |
=================================================================== |
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
Index: photos/albums/Lassitor/Lassitor.png |
=================================================================== |
--- photos/albums/Lassitor/Lassitor.png (nonexistent) |
+++ photos/albums/Lassitor/Lassitor.png (revision 245) |
/photos/albums/Lassitor/Lassitor.png |
---|
Property changes: |
Added: svn:mime-type |
## -0,0 +1 ## |
+application/octet-stream |
\ No newline at end of property |
Index: photos/albums/Lassitor/Lassitor-3d.png |
=================================================================== |
Cannot display: file marked as a binary type. |
svn:mime-type = application/octet-stream |
Index: photos/albums/Lassitor/Lassitor-3d.png |
=================================================================== |
--- photos/albums/Lassitor/Lassitor-3d.png (nonexistent) |
+++ photos/albums/Lassitor/Lassitor-3d.png (revision 245) |
/photos/albums/Lassitor/Lassitor-3d.png | |
---|---|
Property changes: | |
Added: svn:mime-type | |
## -0,0 +1 ## | |
+application/octet-stream | |
\ No newline at end of property | |
Index: photos/album.php | |
=================================================================== | |
--- photos/album.php (revision 241) | |
+++ photos/album.php (revision 245) | |
@@ -37,7 +37,7 @@ | |
$page->redirect('index.php'); | |
} | |
-write(' Back to Photos '); | |
+write(' '); | |
write('
|