Query: --
-- Seagull CMS source code
-- (C)2006 by umop ap!sdn (aka E. Lee Gagnon)
--
-- Module: build_tables.sql
--
-- When installing the CMS, run these MySQL commands to generate the tables that the software needs.
-- Note: this file assumes the users table already exists and contains the necessary fields. If it does
-- not exist, then you will need to run the commands in the build_users_table.sql module before your
-- CMS based site will function.
--
-- ***************************************************************************************************
CREATE TABLE articles
(article_id INT,
user_id INT,
cat_id INT,
article_title VARCHAR(255),
article_subtitle VARCHAR(255),
picture_url VARCHAR(255),
pic_caption VARCHAR(255),
abstract TEXT,
INDEX(abstract(1)),
full_text TEXT,
INDEX(full_text(1)),
full_link_text VARCHAR(255),
when_posted DATETIME
)
Table 'articles' already exists
Query: ALTER TABLE articles ADD (views BIGINT)
Duplicate column name 'views'
Query: ALTER TABLE articles ADD (ip_addr VARCHAR(15))
Duplicate column name 'ip_addr'
Query: CREATE TABLE categories
(cat_id INT,
parent_id INT,
cat_name VARCHAR(255),
cat_descr VARCHAR(255)
)
Table 'categories' already exists
Query: CREATE TABLE comments
(comment_id INT,
article_id INT,
user_id INT,
user_name VARCHAR(255),
email VARCHAR(255),
ip_addr VARCHAR(15),
when_posted DATETIME,
content TEXT,
INDEX(content(1)),
CONSTRAINT comment_id_pk PRIMARY KEY (comment_id)
)
Table 'comments' already exists
Query: CREATE TABLE permissions
(permission_id INT,
permission_desc VARCHAR(255)
)
Table 'permissions' already exists
Query: CREATE TABLE user_permissions
(user_id INT,
permission_id INT
)
Table 'user_permissions' already exists
Query: INSERT INTO permissions (permission_id, permission_desc) VALUES (1, 'ADMIN')
Query: INSERT INTO permissions (permission_id, permission_desc) VALUES (2, 'POST_ARTICLES')
Query: INSERT INTO permissions (permission_id, permission_desc) VALUES (3, 'POST_COMMENTS')
Query: INSERT INTO permissions (permission_id, permission_desc) VALUES (4, 'EDIT_OWN_COMMENTS')
Query: INSERT INTO permissions (permission_id, permission_desc) VALUES (5, 'EDIT_OWN_ARTICLES')
Query: INSERT INTO permissions (permission_id, permission_desc) VALUES (6, 'MODERATE_COMMENTS')
Query: INSERT INTO permissions (permission_id, permission_desc) VALUES (7, 'EDIT_ALL_ARTICLES')
Query: INSERT INTO permissions (permission_id, permission_desc) VALUES (8, 'VIEW_FULL_TEXT')
Query: INSERT INTO permissions (permission_id, permission_desc) VALUES (9, 'SEE_EMAIL_ADDRESSES')
Query: INSERT INTO permissions (permission_id, permission_desc) VALUES (10, 'POST_HTML')
Query: INSERT INTO permissions (permission_id, permission_desc) VALUES (11, 'MANAGE_USER_ACCOUNTS')
Query: // Admin permission automatically includes all others
INSERT INTO user_permissions (user_id, permission_id) VALUES (1, 1)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '// Admin permission automatically includes all others
INSERT INTO user_permiss' at line 1
8 error(s) were encountered during the table installation process.