rpicms

commit 07078783d0fec0cb36ad5409ad509919d0630646
parent 86fc8f6ca970d27cbe3b7e7c8dfa4875e648925d
Author: MTRNord <mtrnord1@gmail.com>
Date:   Sat, 29 Nov 2014 16:40:14 +0100

new db structure for new login/register srript by quintus

Diffstat:
M
install/add_tables.php
 | 
68
+++++++++++++++++++++++++++++++++++++++++++++++++++-----------------

1 file changed, 51 insertions(+), 17 deletions(-)
diff --git a/install/add_tables.php b/install/add_tables.php
@@ -7,37 +7,71 @@
 * @author	Marcel Radzio <info@nordgedanken.de>
 * @version	0.2 18/08/2014 18:49
 */
+
 //Posts erstellen
 	require_once ('../core/config/connect.db.inc.php');
 	$sql = "
 		 CREATE TABLE `posts` (
-		`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
-		`text` TEXT NOT NULL ,
-		`title` TEXT NOT NULL ,
-		`author` TEXT NOT NULL ,
-		`date` DATETIME NOT NULL ,
-		`category` TEXT NOT NULL
+			`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+			`text` TEXT NOT NULL ,
+			`title` TEXT NOT NULL ,
+			`author` TEXT NOT NULL ,
+			`date` DATETIME NOT NULL ,
+			`category` TEXT NOT NULL
 		) ENGINE = MYISAM ;
-		";
+	";
 	$result = mysqli_query($connection, $sql)
 	or die("Anfrage fehlgeschlagen: " . mysql_error());
 	echo 'Erstellen erfolgreich';
 //User erstellen
+
 	require_once ('../core/config/connect.db.inc.php');
 	$sql = "
-		 CREATE TABLE `users` (
-		`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
-		`name` VARCHAR( 11 ) NOT NULL ,
-		`email` TEXT NOT NULL ,
-		`password` VARCHAR(50) NOT NULL ,
-		`registertime` TEXT NOT NULL ,
-		`activationcode` INT( 11 ) NOT NULL,
-		`activated` TEXT NOT NULL
-		) ENGINE = MYISAM ;
-		";
+		CREATE TABLE IF NOT EXISTS `user` (
+  			`id` int(11) NOT NULL AUTO_INCREMENT,
+  			`name` varchar(50) NOT NULL,
+  			`passwdhash` varchar(140) NOT NULL,
+  			`ga_secret` varchar(20) NOT NULL,
+  			PRIMARY KEY (`id`)
+		) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;
+	";
+	$result = mysqli_query($connection, $sql)
+	or die("Anfrage fehlgeschlagen: " . mysql_error());
+	echo 'Erstellen erfolgreich';
+
+//cookiedata
+	require_once ('../core/config/connect.db.inc.php');
+	$sql = "
+		CREATE TABLE IF NOT EXISTS `cookiedata` (
+  			`id` int(11) NOT NULL AUTO_INCREMENT,
+  			`hash` varchar(140) NOT NULL,
+  			`vaildtime` int(11) NOT NULL,
+  			`createtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  			`userid` int(11) NOT NULL,
+  			`cookie_hash` varchar(140) NOT NULL,
+  			PRIMARY KEY (`id`)
+		) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
+	";
+	$result = mysqli_query($connection, $sql)
+	or die("Anfrage fehlgeschlagen: " . mysql_error());
+	echo 'Erstellen erfolgreich';
+
+//hashzoken
+	require_once ('../core/config/connect.db.inc.php');
+	$sql = "
+		CREATE TABLE IF NOT EXISTS `hashtoken` (
+  			`id` int(11) NOT NULL AUTO_INCREMENT,
+  			`token` varchar(140) NOT NULL,
+  			`time` int(11) NOT NULL,
+  			`vaild_sec` int(11) NOT NULL DEFAULT '300',
+  			PRIMARY KEY (`id`)
+		) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=84 ;
+	";
 	$result = mysqli_query($connection, $sql)
 	or die("Anfrage fehlgeschlagen: " . mysql_error());
 	echo 'Erstellen erfolgreich';
+
+
 	header("HTTP/1.1 301 Moved Permanently");
 	header("Location:../");
 	exit;