zingi/Vitalba_CMS
Folders and files
| Name | Name | Last commit date | ||
|---|---|---|---|---|
Repository files navigation
**************************************************
* *
* Fabio Vitalba - Copyright (c) *
* PHP Vitalba Content Management System *
* *
**************************************************
0.0 Contributors
- Fabio Vitalba
- Benedikt Troi
- Aaron Zingerle
1.0 Introduction
1.1 Requirements
- A Webserver with a MySQL Database
-
1.2 Structures
- CLASSES
--- database.php
--- navigation.php
--- subpage.php
--- gallery.php
--- article.php
--- comment.php
--- formmanagement.php
--- sessionmanagement.php
--- user.php
---
- PAGES
--- index.php
--- template.html
---
- SCRIPTS
---
1.3 Database Architecture
- VCMS_Article
--- ID, INT NOT NULL AUTO_INCREMENT PRIMARY KEY
--- Page_ID, INT NOT NULL FOREIGN KEY
--- Title_Code, VARCHAR(5) NOT NULL FOREIGN KEY
--- Content_Code, VARCHAR(5) NOT NULL FOREIGN KEY
--- Author_ID, INT NOT NULL FOREIGN KEY
--- Creation, DATETIME NOT NULL
--- Modification, DATETIME NULL
--- CSS_Class, VARCHAR(255) NULL
--- Permissionset_ID, INT NOT NULL FOREIGN KEY
--- Promote, BOOLEAN NOT NULL
--- Archive_ID, INT NULL FOREIGN KEY
--- Comments, BOOLEAN NOT NULL
- VCMS_Page
--- ID, INT NOT NULL AUTO_INCREMENT PRIMARY KEY
--- Title_Code, VARCHAR(5) NOT NULL FOREIGN KEY
--- Content_Code, VARCHAR(5) NOT NULL FOREIGN KEY
--- Creation, DATETIME NOT NULL
--- Modification, DATETIME NULL
--- Author_ID, INT NOT NULL FOREIGN KEY
--- Permissionset_ID, INT NOT NULL FOREIGN KEY
--- Parent_ID, INT NOT NULL FOREIGN KEY
--- Order_No, INT NOT NULL
- VCMS_Gallery
--- ID, INT NOT NULL AUTO_INCREMENT PRIMARY KEY
--- Title_Code, VARCHAR(5) NOT NULL FOREIGN KEY
--- Content_Code, VARCHAR(5) NOT NULL FOREIGN KEY
--- Creation, DATETIME NOT NULL
--- Modification, DATETIME NULL
--- Author_ID, INT NOT NULL FOREIGN KEY
--- Permissionset_ID, INT NOT NULL FOREIGN KEY
- VCMS_Image
--- ID, INT NOT NULL AUTO_INCREMENT PRIMARY KEY
--- Title_Code, VARCHAR(5) NOT NULL FOREIGN KEY
--- Content_Code, VARCHAR(5) NOT NULL FOREIGN KEY
--- Creation, DATETIME NOT NULL
--- Modification, DATETIME NULL
--- Author_ID, INT NOT NULL FOREIGN KEY
--- Permissionset_ID, INT NOT NULL FOREIGN KEY
--- URL, VARCHAR(255) NOT NULL
--- CSS_Class, VARCHAR(255) NULL
--- CSS_ID, VARCHAR(255) NULL
--- Gallery_ID, INT NOT NULL FOREIGN KEY
- VCMS_Title
--- Code, VARCHAR(5) NOT NULL PRIMARY KEY
--- Language_ID, INT NOT NULL FOREIGN KEY PRIMARY KEY
--- Text, VARCHAR(255) NOT NULL
--- Creation, DATETIME NOT NULL
--- Modification, DATETIME NULL
--- Author_ID, INT NOT NULL FOREIGN KEY
- VCMS_Content
--- Code, VARCHAR(5) NOT NULL PRIMARY KEY
--- Language_ID, INT NOT NULL FOREIGN KEY PRIMARY KEY
--- Content, TEXT NOT NULL
--- Creation, DATETIME NOT NULL
--- Modification, DATETIME NULL
--- Author_ID, INT NOT NULL FOREIGN KEY
- VCMS_User
--- ID, INT NOT NULL AUTO_INCREMENT PRIMARY KEY
--- Username, VARCHAR(10) NOT NULL
--- Password, VARCHAR(20) NOT NULL
--- Language_ID, INT NOT NULL FOREIGN KEY
--- Name, VARCHAR(20) NOT NULL
--- Surname, VARCHAR(20) NOT NULL
--- Birthdate, DATE NOT NULL
--- Description, TEXT NULL
--- Sex, VARCHAR(1) NOT NULL
--- Address_ID, INT NOT NULL FOREIGN KEY
--- Contact_ID, INT NOT NULL FOREIGN KEY
--- Join_Date, DATETIME NOT NULL
--- Last_Login, DATETIME NOT NULL
--- Premissionset_ID, INT NOT NULL FOREIGN KEY
--- Image_ID, INT NOT NULL FOREIGN KEY
--- SSL, BOOLEAN NOT NULL
- VCMS_Permissionset
--- ID, INT NOT NULL AUTO_INCREMENT PRIMARY KEY
--- Name, VARCHAR(10) NOT NULL
--- Creation, DATETIME NOT NULL
--- Modification, DATETIME NULL
- VCMS_Language
--- ID, INT NOT NULL AUTO_INCREMENT PRIMARY KEY
--- Code, VARCHAR(3) NOT NULL
--- Description, VARCHAR(10) NOT NULL
- VCMS_Login
--- User_ID, INT NOT NULL FOREIGN KEY PRIMARY KEY
--- Date, DATETIME NOT NULL PRIMARY KEY
--- IP, VARCHAR(15) NOT NULL
--- Browser, VARCHAR(255) NULL
--- Operating_System, VARCHAR(255) NULL
- VCMS_Permission
--- ID, INT NOT NULL AUTO_INCREMENT PRIMARY KEY
--- Name, VARCHAR(10) NOT NULL
--- Read, BOOLEAN NOT NULL
--- Modify, BOOLEAN NOT NULL
--- Create, BOOLEAN NOT NULL
--- Creation, DATETIME NOT NULL
--- Modification, DATETIME NULL
- VCMS_Permissionset_Permission
--- Permissionset_ID, INT NOT NULL FOREIGN KEY PRIMARY KEY
--- Permission_ID, INT NOT NULL FOREIGN KEY PRIMARY KEY
--- Creation, DATETIME NOT NULL
--- Modification, DATETIME NULL
- VCMS_Address
--- ID, INT NOT NULL AUTO_INCREMENT PRIMARY KEY
--- Street_1, VARCHAR(20) NOT NULL
--- Street_2, VARCHAR(20) NULL
--- House_No, VARCHAR(5) NOT NULL
--- Postal_Code, VARCHAR(5) NOT NULL
--- City, VARCHAR(10) NOT NULL
--- Province_Code, VARCHAR(3) NOT NULL
--- Region, VARCHAR(10) NULL
--- Country_Code, VARCHAR(3) NOT NULL
--- Prefix, VARCHAR(4) NULL
- VCMS_Contact
--- ID, INT NOT NULL AUTO_INCREMENT PRIMARY KEY
--- Email, VARCHAR(35) NOT NULL
--- Telephone, VARCHAR(10) NULL
--- Fax, VARCHAR(10) NULL
- VCMS_Log
--- ID, INT NOT NULL AUTO_INCREMENT PRIMARY KEY
--- Date, DATE NOT NULL
--- Time, TIME NOT NULL
--- Event, VARCHAR(255) NOT NULL
- VCMS_Comment
--- ID, INT NOT NULL AUTO_INCREMENT PRIMARY KEY
--- Article_ID, INT NOT NULL FOREIGN KEY
--- Parent_ID, INT NOT NULL FOREIGN KEY
--- Title_Code, VARCHAR(5) NOT NULL FOREIGN KEY
--- Content_Code, VARCHAR(5) NOT NULL FOREIGN KEY
--- Permissionset_ID, INT NOT NULL FOREIGN KEY
--- Votes, INT NOT NULL
- VCMS_Vote
--- User_ID, INT NOT NULL FOREIGN KEY PRIMARY KEY
--- Comment_ID, INT NOT NULL FOREIGN KEY PRIMARY KEY
--- Date, DATE NOT NULL
--- Time, TIME NOT NULL
- VCMS_Caption
--- Code, VARCHAR(5) NOT NULL PRIMARY KEY
--- Language_ID, INT NOT NULL FOREIGN KEY PRIMARY KEY
--- Group, VARCHAR(10) NOT NULL PRIMARY KEY
--- Text, VARCHAR(255) NOT NULL
--- Creation, DATETIME NOT NULL
--- Modification, DATETIME NULL
--- Author_ID, INT NOT NULL FOREIGN KEY