A
A
Aaron Ramsey2014-03-19 19:10:44
CMS
Aaron Ramsey, 2014-03-19 19:10:44

How to install CMS Academic?

Installing CMS Academic for a blog. What I have been looking for for a long time.
But on the 2nd step it requires me to do the following (awolnation.ru) on the site you can see.
What is it and where can I do it?
Who is afraid to follow the link - that's what the system writes to me.
We now need to create the database tables that will be used by academics. Please login to your mysql database and run the following SQL request:
/* Create the posts table: */
CREATE TABLE posts (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255),
slug VARCHAR(255),
body TEXT,
created DATETIME DEFAULT NULL,
format VARCHAR(20) DEFAULT NULL,
user_id INT
);
/* Insert a publication: */
INSERT INTO posts (title,slug,body,created,format,user_id)
VALUES ('Welcome to academic*', 'welcome_to_academic', "You can edit or delete this publication by creating an administrator account here .", NOW(), 'standard', '1');
/* Create the pages table: */
CREATE TABLE pages (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(50),
slug VARCHAR(255),
body TEXT,
created DATETIME DEFAULT NULL
);
/* Insert two pages: */
INSERT INTO pages (title,slug,body,created)
VALUES ('About', 'about', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut a dui metus, vitae auctor dolor. Fusce leo turpis, sagittis sed dignissim id, rhoncus ac diam. Nam suscipit rutrum venenatis. Donec mi urna, pharetra eget cursus ut, interdum in risus.', NOW());
INSERT INTO pages (title,slug,body,created)
VALUES ('Links', 'links', '###Link category
* [Link1](#)
* [Link2](#)
* [Link3](#)' ,NOW());
/* Create the users table: */
CREATE TABLE users (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
email VARCHAR(150),
pseudo VARCHAR(250),
password VARCHAR(50),
role VARCHAR(20),
about TEXT,
);
/* Create the settings table: */
CREATE TABLE settings (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255),
slug VARCHAR(255),
value VARCHAR(300)
);
/* Insert settings values: */
INSERT INTO settings (name,value)
VALUES ('Site.name', 'Academic blog');
INSERT INTO settings (name,value)
VALUES ('Site.description', 'The minimalist blog CMS');
INSERT INTO settings (name,value)
VALUES ('Site.email', '[email protected]');
INSERT INTO settings (name,value)
VALUES ('Site.layout', 'academic');
INSERT INTO settings (name,value)
VALUES ('
INSERT INTO settings (name,value)
VALUES ('Google.analytics', 'none');
INSERT INTO settings (name,value)
VALUES ('Disqus.id', 'none');
INSERT INTO settings (name,value)
VALUES ('Gripr.info', 'no');

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Stepan, 2014-03-19
@szags

Have you tried reading? Everything is described verbatim there:
Do you use a translator?
In general, cms asks you to go to phpmyadmin and run the queries below to create the necessary tables.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question