Publishing h-node.org code.

- this is the h-node.org code, except
  - removed a js file (3x copies at three different locations) without license / copyright headers
    - /Js/linkToForm.js
    - /Public/Js/linkToForm.js
    - /admin/Public/Js/linkToForm.js
  - removed config files containing credentials
    - /Application/Include/params.php
    - /Config/Config.php
    - /admin/Application/Include/params.php
    - /admin/Config/Config.php
  - added license and copyright header to one php file
    - /admin/Library/ErrorReporting.php (almost identical to /Library/ErrorReporting.php which has the headers)

1 files changed, 160 insertions, 0 deletions

diff --git a/h-source/tabelle.txt b/h-source/tabelle.txt
new file mode 100755
index 0000000..528322b
--- /dev/null
+++ b/h-source/tabelle.txt
@@ -0,0 +1,160 @@
+create table hardware (
+	id_hard INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	type varchar(50) not null,
+	subtype char(15) not null,
+	kernel varchar(50) not null,
+	vendor varchar(50) not null,
+	model varchar(100) not null,
+	created_by int not null,
+	updated_by int not null,
+	creation_date timestamp default CURRENT_TIMESTAMP,
+	update_date datetime not null,
+	compatibility char(15) not null,
+	description text CHARACTER SET utf8 not null,
+	distribution varchar(300) CHARACTER SET utf8 not null,
+	video_card_type varchar(100) CHARACTER SET utf8 not null,
+	video_card_works varchar(30) CHARACTER SET utf8 not null,
+	wifi_type varchar(100) CHARACTER SET utf8 not null,
+	wifi_works varchar(30) CHARACTER SET utf8 not null,
+	comm_year char(15) not null,
+	ask_for_del char(4) not null default 'no',
+	deleted char(4) not null default 'no',
+	pci_id char(10) not null,
+	driver varchar(50) not null,
+	interface char(15) not null default 'not-specified'
+)engine=innodb;
+
+create table revisions (
+	id_rev INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	type varchar(50) not null,
+	subtype char(15) not null,
+	kernel varchar(50) not null,
+	vendor varchar(50) not null,
+	model varchar(100) not null,
+	created_by int not null,
+	updated_by int not null,
+	creation_date timestamp default CURRENT_TIMESTAMP,
+	update_date datetime not null,
+	compatibility char(15) not null,
+	description text CHARACTER SET utf8 not null,
+	distribution varchar(300) CHARACTER SET utf8 not null,
+	video_card_type varchar(100) CHARACTER SET utf8 not null,
+	video_card_works varchar(30) CHARACTER SET utf8 not null,
+	wifi_type varchar(100) CHARACTER SET utf8 not null,
+	wifi_works varchar(30) CHARACTER SET utf8 not null,
+	comm_year char(15) not null,
+	pci_id char(10) not null,
+	driver varchar(50) not null,
+	interface char(15) not null default 'not-specified',
+	id_hard INT UNSIGNED NOT NULL
+)engine=innodb;
+
+create table hardware_users (
+	id_user int(11) UNSIGNED not null,
+	id_hard int(11) UNSIGNED not null,
+	index hard_indx(id_hard),
+	index user_indx(id_user),
+	foreign key hard_fky(id_hard) references hardware (id_hard),
+	foreign key user_fky(id_user) references regusers (id_user),
+	unique (id_user,id_hard)
+)engine=innodb;
+
+
+create table talk (
+	id_talk INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	created_by int not null,
+	creation_date timestamp default CURRENT_TIMESTAMP,
+	title varchar(100) CHARACTER SET utf8 not null,
+	message text CHARACTER SET utf8 not null,   
+	id_hard INT UNSIGNED NOT NULL,
+	deleted char(4) not null default 'no'
+)engine=innodb;
+
+
+create table profile (
+	id_prof INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	created_by int not null,
+	creation_date timestamp default CURRENT_TIMESTAMP,
+	update_date datetime not null,
+	real_name varchar(100)  CHARACTER SET utf8 not null,
+	where_you_are varchar(100) CHARACTER SET utf8 not null,
+	birth_date varchar(100)  CHARACTER SET utf8 not null,
+	fav_distro varchar(100)  CHARACTER SET utf8 not null,
+	projects  text CHARACTER SET utf8 not null ,
+	publish_mail char(4) not null default 'no',
+	description text CHARACTER SET utf8 not null,
+	website varchar(100)  CHARACTER SET utf8 not null
+)engine=innodb;
+
+
+create table issues (
+	id_issue INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	created_by int not null,
+	creation_date timestamp default CURRENT_TIMESTAMP,
+	update_date datetime not null,
+	topic char(35) CHARACTER SET utf8 not null,
+	title varchar(100) CHARACTER SET utf8 not null,
+	message text CHARACTER SET utf8 not null,
+	priority char(15) CHARACTER SET utf8 not null,
+	status char(15) CHARACTER SET utf8 not null,
+	notice text CHARACTER SET utf8 not null,
+	deleted char(4) not null default 'no'
+)engine=innodb;
+
+
+create table deletion (
+	id_del INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	created_by int not null,
+	creation_date timestamp default CURRENT_TIMESTAMP,
+	object char(15) not null,
+	message text CHARACTER SET utf8 not null,
+	id_hard INT UNSIGNED NOT NULL,
+	id_duplicate INT UNSIGNED NOT NULL
+)engine=innodb;
+
+create table params (
+	id_par INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	updating char(4) not null default 'no'
+)engine=innodb;
+
+insert into params (updating) values ('no');
+
+
+create table news (
+	id_news INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	creation_date timestamp default CURRENT_TIMESTAMP,
+	title varchar(150) not null,
+	message text CHARACTER SET utf8 not null
+)engine=innodb;
+
+
+create table boxes (
+	id_box int not null auto_increment primary key,
+	creation_date timestamp default CURRENT_TIMESTAMP,
+	title varchar(150) not null,
+	message text CHARACTER SET utf8 not null
+);
+
+create table messages (
+	id_mes int not null auto_increment primary key,
+	created_by int not null,
+	creation_date timestamp default CURRENT_TIMESTAMP,
+	message text CHARACTER SET utf8 not null,
+	id_issue INT UNSIGNED NOT NULL,
+	deleted char(4) not null default 'no',
+	has_read char(4) not null default 'no'
+);
+
+
+
+create table history (
+	id_history int not null auto_increment primary key,
+	created_by int not null,
+	creation_date timestamp default CURRENT_TIMESTAMP,
+	type char(10) not null,
+	action char(10) not null,
+	id INT UNSIGNED NOT NULL,
+	message text CHARACTER SET utf8 not null
+);
+
+insert into reggroups (name) values ('moderator');