-
Notifications
You must be signed in to change notification settings - Fork 0
zingi/Vitalba_CMS
Folders and files
Name | Name | Last commit message | 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
About
Creating my own CMS
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published