cms/cmstables.php at master · JordanRhode/cms · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
<?php //cmstables.php
	require_once "conn.php";
	$sql = <<<EOS
	CREATE TABLE IF NOT EXISTS cms_access_levels (
		access_lvl tinyint(4) NOT NULL auto_increment,
		access_name varchar(50) NOT NULL default '',
		PRIMARY KEY (access_lvl)
	)
EOS;
		$result = mysql_query($sql) or
		die(mysql_error());
	$sql = "INSERT IGNORE INTO cms_access_levels " .
			"VALUES (1, 'Users'), " .
			"(2, 'Moderator'), " .
			"(3, 'Administrator')";
	$result = mysql_query($sql) or
		die(mysql_error());
	$sql = <<<EOS
	CREATE TABLE IF NOT EXISTS cms_articles (
		article_id int(11) NOT NULL auto_increment,
		author_id int(11) NOT NULL default '0',
		is_published tinyint(1) NOT NULL default '0',
		date_submitted datetime NOT NULL default '0000-00-00 00:00:00',
		date_published datetime NOT NULL default '0000-00-00 00:00:00',
		title varchar(255) NOT NULL default '',
		body mediumtext NOT NULL,
		PRIMARY KEY (article_id),
		KEY IdxArticle (author_id,date_submitted),
		FULLTEXT KEY IdxText (title, body)
	)
EOS;
	$result = mysql_query($sql) or
		die(mysql_error());
	$sql = <<<EOS
	CREATE TABLE IF NOT EXISTS cms_comments (
		comment_id int(11) NOT NULL auto_increment,
		article_id int(11) NOT NULL default '0',
		comment_date datetime NOT NULL default '0000-00-00 00:00:00',
		comment_user int(11) NOT NULL default '0',
		comment text NOT NULL,
		PRIMARY KEY (comment_id),
		KEY IdxComment (article_id)
	)
EOS;
	$result = mysql_query($sql) or
		die(mysql_error());
	$sql = <<<EOS
	CREATE TABLE IF NOT EXISTS cms_users (
		user_id int(11) NOT NULL auto_increment,
		email varchar(255) NOT NULL default '',
		password varchar(50) NOT NULL default '',
		name varchar(100) NOT NULL default '',
		access_lvl tinyint(4) NOT NULL default '1',
		PRIMARY KEY (user_id),
		UNIQUE KEY uniq_email (email)
		)
EOS;
	$result = mysql_query($sql) or
		die(mysql_error());
		$adminemail = "jrhod547@uwsp.edu";
		$adminpass = "temp";
		$adminname = "temp";
		$sql = "INSERT INTO cms_users" .
			"VALUES (NULL, '$adminemail', $adminpass', '$adminname', 3)";
		$result = mysql_query($sql) or
			die(mysql_error());
		echo "<html><head><title>CMS Tables Created</title></head><body>";
		echo "CMS Tables created, Here is the initial login information: <br/>";
		echo "<ul><li><strong>Login: </strong> " . $adminemail . "</li><br/>";
		echo "<li><strong>Password: </strong>" . $adminpass . "</li><br/>";
		echo "<a href='login.php'>Login</a> to the site now.";
		echo "</ul></body></html>";
?>