i-opeen

Merge lp:~jbruni/i-opeen/i-opeen into lp:i-opeen

  1. i-opeen
  2. Merge into trunk
Proposed by UndiFineD
Status: Merged
Approved by: UndiFineD
Approved revision: 27
Merged at revision: 28
Proposed branch: lp:~jbruni/i-opeen/i-opeen
Merge into: lp:i-opeen
Diff against target: 1522 lines (+1488/-3)
4 files modified
app/config/database.php (+8/-3)
app/database/migrations/2014_01_24_024524_schema_creation.php (+33/-0)
app/database/migrations/2014_01_24_024524_schema_creation.sql (+1320/-0)
app/database/migrations/2014_01_24_024524_schema_creation_revert.sql (+127/-0)
To merge this branch: bzr merge lp:~jbruni/i-opeen/i-opeen
Reviewer Review Type Date Requested Status
UndiFineD Approve
Review via email: mp+203142@code.launchpad.net
To post a comment you must log in.
Revision history for this message
UndiFineD (k.dejong) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'app/config/database.php'
2--- app/config/database.php 2014-01-19 21:01:03 +0000
3+++ app/config/database.php 2014-01-24 18:10:37 +0000
4@@ -52,12 +52,17 @@
5 'prefix' => '',
6 ),
7
8+ // # To create the database, run the following commands using privileged MySQL user (like root):
9+ // CREATE SCHEMA IF NOT EXISTS `iopeen_database` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
10+ // GRANT ALL PRIVILEGES ON iopeen_database.* TO 'iopeen_user'@'localhost' IDENTIFIED BY 'iopeen_pass';
11+ // FLUSH PRIVILEGES;
12+ // # Let "iopeen_pass" be the password for development, but change the DB password for production!
13 'mysql' => array(
14 'driver' => 'mysql',
15 'host' => 'localhost',
16- 'database' => 'database',
17- 'username' => 'root',
18- 'password' => '',
19+ 'database' => 'iopeen_database',
20+ 'username' => 'iopeen_user',
21+ 'password' => 'iopeen_pass',
22 'charset' => 'utf8',
23 'collation' => 'utf8_unicode_ci',
24 'prefix' => '',
25
26=== added file 'app/database/migrations/2014_01_24_024524_schema_creation.mwb'
27Binary files app/database/migrations/2014_01_24_024524_schema_creation.mwb 1970-01-01 00:00:00 +0000 and app/database/migrations/2014_01_24_024524_schema_creation.mwb 2014-01-24 18:10:37 +0000 differ
28=== added file 'app/database/migrations/2014_01_24_024524_schema_creation.php'
29--- app/database/migrations/2014_01_24_024524_schema_creation.php 1970-01-01 00:00:00 +0000
30+++ app/database/migrations/2014_01_24_024524_schema_creation.php 2014-01-24 18:10:37 +0000
31@@ -0,0 +1,33 @@
32+<?php
33+
34+use Illuminate\Database\Migrations\Migration;
35+
36+class SchemaCreation extends Migration {
37+
38+ /**
39+ * Run the migrations.
40+ *
41+ * @return void
42+ */
43+ public function up()
44+ {
45+ $vals = Config::get('database.connections.mysql');
46+ $script_path = str_replace('php', 'sql', __FILE__);
47+ $command = "mysql -u{$vals['username']} -p{$vals['password']} -h {$vals['host']} -D {$vals['database']} < {$script_path}";
48+ shell_exec($command);
49+ }
50+
51+ /**
52+ * Reverse the migrations.
53+ *
54+ * @return void
55+ */
56+ public function down()
57+ {
58+ $vals = Config::get('database.connections.mysql');
59+ $script_path = str_replace('.php', '_revert.sql', __FILE__);
60+ $command = "mysql -u{$vals['username']} -p{$vals['password']} -h {$vals['host']} -D {$vals['database']} < {$script_path}";
61+ shell_exec($command);
62+ }
63+
64+}
65\ No newline at end of file
66
67=== added file 'app/database/migrations/2014_01_24_024524_schema_creation.sql'
68--- app/database/migrations/2014_01_24_024524_schema_creation.sql 1970-01-01 00:00:00 +0000
69+++ app/database/migrations/2014_01_24_024524_schema_creation.sql 2014-01-24 18:10:37 +0000
70@@ -0,0 +1,1320 @@
71+SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
72+SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
73+SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,ALLOW_INVALID_DATES';
74+
75+CREATE TABLE IF NOT EXISTS `iopeen_database`.`members_table` (
76+ `member_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
77+ `active` TINYINT(1) NOT NULL DEFAULT 0,
78+ `policy_agreed` TINYINT(1) NOT NULL DEFAULT 0,
79+ `confirmed` TINYINT(1) NOT NULL DEFAULT 0,
80+ `suspended` TINYINT(1) NOT NULL DEFAULT 0,
81+ `deleted` TINYINT(1) NOT NULL DEFAULT 0,
82+ `acceptedterms` TINYINT(1) NOT NULL DEFAULT 0,
83+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
84+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
85+ `timezone` INT(11) NOT NULL DEFAULT 0,
86+ `language_id` BIGINT(20) NOT NULL DEFAULT 1,
87+ `theme` BIGINT(20) NOT NULL,
88+ `gender` CHAR NOT NULL,
89+ `date_of_birth` TIMESTAMP NOT NULL DEFAULT 0,
90+ `login_name` VARCHAR(45) NOT NULL,
91+ `login_pass` VARCHAR(45) NOT NULL,
92+ `display_name` VARCHAR(45) NOT NULL,
93+ `first_name` VARCHAR(45) NOT NULL,
94+ `last_name` VARCHAR(45) NOT NULL,
95+ `email_id` BIGINT(20) NOT NULL,
96+ `address_id` BIGINT(20) NOT NULL,
97+ `dateformat_id` BIGINT(20) NOT NULL,
98+ `currencyformat_id` BIGINT(20) NOT NULL,
99+ `expiration` TIMESTAMP NULL DEFAULT 0,
100+ `decription` VARCHAR(255) NULL DEFAULT NULL,
101+ `skype` VARCHAR(45) NULL DEFAULT NULL,
102+ `facebook` VARCHAR(45) NULL DEFAULT NULL,
103+ `phone` VARCHAR(45) NULL DEFAULT NULL,
104+ `mobile` VARCHAR(45) NULL DEFAULT NULL,
105+ `website` VARCHAR(255) NULL DEFAULT NULL,
106+ `question` VARCHAR(255) NULL DEFAULT NULL,
107+ `answer` VARCHAR(255) NULL DEFAULT NULL,
108+ `identification` BLOB NULL DEFAULT NULL,
109+ `picture` BLOB NULL DEFAULT NULL,
110+ PRIMARY KEY (`member_id`),
111+ UNIQUE INDEX `user_id_UNIQUE` (`member_id` ASC),
112+ INDEX `address_id_idx` (`address_id` ASC),
113+ INDEX `email_id_idx` (`email_id` ASC),
114+ INDEX `language_id_idx` (`language_id` ASC),
115+ INDEX `dateformat_id_idx` (`dateformat_id` ASC),
116+ INDEX `currencyformat_id_idx` (`currencyformat_id` ASC))
117+ENGINE = InnoDB
118+DEFAULT CHARACTER SET = utf8
119+COLLATE = utf8_general_ci
120+COMMENT = 'members table, all participants, including branch administrators';
121+
122+CREATE TABLE IF NOT EXISTS `iopeen_database`.`membergroups_table` (
123+ `membergroup_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
124+ `active` TINYINT(1) NOT NULL DEFAULT 0,
125+ `group_id` BIGINT(20) NOT NULL,
126+ `member_id` BIGINT(20) NOT NULL,
127+ PRIMARY KEY (`membergroup_id`),
128+ UNIQUE INDEX `usergroup_id_UNIQUE` (`membergroup_id` ASC),
129+ INDEX `fk_usergroups_users_idx` (`member_id` ASC),
130+ INDEX `fk_usergroups_groups1_idx` (`group_id` ASC),
131+ CONSTRAINT `fk_usergroups_users`
132+ FOREIGN KEY (`member_id`)
133+ REFERENCES `iopeen_database`.`members_table` (`member_id`)
134+ ON DELETE NO ACTION
135+ ON UPDATE NO ACTION,
136+ CONSTRAINT `fk_usergroups_groups1`
137+ FOREIGN KEY (`group_id`)
138+ REFERENCES `iopeen_database`.`groups_table` (`group_id`)
139+ ON DELETE NO ACTION
140+ ON UPDATE NO ACTION)
141+ENGINE = InnoDB
142+DEFAULT CHARACTER SET = utf8
143+COLLATE = utf8_general_ci;
144+
145+CREATE TABLE IF NOT EXISTS `iopeen_database`.`groups_table` (
146+ `group_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
147+ `active` TINYINT(1) NOT NULL DEFAULT 0,
148+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
149+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
150+ `name` VARCHAR(255) NOT NULL,
151+ `descr` VARCHAR(255) NULL DEFAULT NULL,
152+ UNIQUE INDEX `group_name_UNIQUE` (`name` ASC),
153+ PRIMARY KEY (`group_id`),
154+ UNIQUE INDEX `group_id_UNIQUE` (`group_id` ASC))
155+ENGINE = InnoDB
156+DEFAULT CHARACTER SET = utf8
157+COLLATE = utf8_general_ci;
158+
159+CREATE TABLE IF NOT EXISTS `iopeen_database`.`rights_table` (
160+ `right_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
161+ `active` TINYINT(1) NOT NULL DEFAULT 0,
162+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
163+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
164+ `name` VARCHAR(255) NOT NULL,
165+ `descr` VARCHAR(255) NOT NULL,
166+ PRIMARY KEY (`right_id`),
167+ UNIQUE INDEX `right_id_UNIQUE` (`right_id` ASC))
168+ENGINE = InnoDB
169+DEFAULT CHARACTER SET = utf8
170+COLLATE = utf8_general_ci;
171+
172+CREATE TABLE IF NOT EXISTS `iopeen_database`.`grouprights_table` (
173+ `groupright_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
174+ `active` TINYINT(1) NOT NULL DEFAULT 0,
175+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
176+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
177+ `group_id` BIGINT(20) NOT NULL,
178+ `right_id` BIGINT(20) NOT NULL,
179+ PRIMARY KEY (`groupright_id`),
180+ UNIQUE INDEX `groupright_id_UNIQUE` (`groupright_id` ASC),
181+ INDEX `fk_grouprights_rights1_idx` (`right_id` ASC),
182+ INDEX `fk_grouprights_groups1_idx` (`group_id` ASC),
183+ CONSTRAINT `fk_grouprights_rights1`
184+ FOREIGN KEY (`right_id`)
185+ REFERENCES `iopeen_database`.`rights_table` (`right_id`)
186+ ON DELETE NO ACTION
187+ ON UPDATE NO ACTION,
188+ CONSTRAINT `fk_grouprights_groups1`
189+ FOREIGN KEY (`group_id`)
190+ REFERENCES `iopeen_database`.`groups_table` (`group_id`)
191+ ON DELETE NO ACTION
192+ ON UPDATE NO ACTION)
193+ENGINE = InnoDB
194+DEFAULT CHARACTER SET = utf8
195+COLLATE = utf8_general_ci;
196+
197+CREATE TABLE IF NOT EXISTS `iopeen_database`.`sessions_table` (
198+ `session_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
199+ `active` TINYINT(1) NOT NULL DEFAULT 0,
200+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
201+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
202+ `name` VARCHAR(64) NOT NULL,
203+ `cookie` VARCHAR(255) NOT NULL,
204+ `ipaddress` VARCHAR(16) NOT NULL,
205+ PRIMARY KEY (`session_id`),
206+ UNIQUE INDEX `session_id_UNIQUE` (`session_id` ASC))
207+ENGINE = InnoDB
208+DEFAULT CHARACTER SET = utf8
209+COLLATE = utf8_general_ci;
210+
211+CREATE TABLE IF NOT EXISTS `iopeen_database`.`membersessions_table` (
212+ `membersession_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
213+ `active` TINYINT(1) NOT NULL DEFAULT 0,
214+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
215+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
216+ `member_id` BIGINT(20) NOT NULL,
217+ `session_id` BIGINT(20) NOT NULL,
218+ PRIMARY KEY (`membersession_id`),
219+ INDEX `fk_usersessions_session1_idx` (`session_id` ASC),
220+ INDEX `fk_usersessions_users1_idx` (`member_id` ASC),
221+ CONSTRAINT `fk_usersessions_session1`
222+ FOREIGN KEY (`session_id`)
223+ REFERENCES `iopeen_database`.`sessions_table` (`session_id`)
224+ ON DELETE NO ACTION
225+ ON UPDATE NO ACTION,
226+ CONSTRAINT `fk_usersessions_users1`
227+ FOREIGN KEY (`member_id`)
228+ REFERENCES `iopeen_database`.`members_table` (`member_id`)
229+ ON DELETE NO ACTION
230+ ON UPDATE NO ACTION)
231+ENGINE = InnoDB
232+DEFAULT CHARACTER SET = utf8
233+COLLATE = utf8_general_ci;
234+
235+CREATE TABLE IF NOT EXISTS `iopeen_database`.`visitpages_table` (
236+ `visitpage_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
237+ `active` TINYINT(1) NOT NULL DEFAULT 0,
238+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
239+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
240+ `page_id` BIGINT(20) NOT NULL,
241+ PRIMARY KEY (`visitpage_id`),
242+ UNIQUE INDEX `visitpage_id_UNIQUE` (`visitpage_id` ASC),
243+ INDEX `fk_visitpages_page1_idx` (`page_id` ASC),
244+ CONSTRAINT `fk_visitpages_page1`
245+ FOREIGN KEY (`page_id`)
246+ REFERENCES `iopeen_database`.`pages_table` (`page_id`)
247+ ON DELETE NO ACTION
248+ ON UPDATE NO ACTION)
249+ENGINE = InnoDB
250+DEFAULT CHARACTER SET = utf8
251+COLLATE = utf8_general_ci;
252+
253+CREATE TABLE IF NOT EXISTS `iopeen_database`.`sessionvisitpages_table` (
254+ `sessionvisitpage_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
255+ `active` TINYINT(1) NOT NULL DEFAULT 0,
256+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
257+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
258+ `visitpage_id` BIGINT(20) NOT NULL,
259+ `session_id` BIGINT(20) NOT NULL,
260+ PRIMARY KEY (`sessionvisitpage_id`),
261+ UNIQUE INDEX `sessionvisitpage_id_UNIQUE` (`sessionvisitpage_id` ASC),
262+ INDEX `fk_sessionvisitpages_sessions1_idx` (`session_id` ASC),
263+ INDEX `fk_sessionvisitpages_visitpages1_idx` (`visitpage_id` ASC),
264+ CONSTRAINT `fk_sessionvisitpages_sessions1`
265+ FOREIGN KEY (`session_id`)
266+ REFERENCES `iopeen_database`.`sessions_table` (`session_id`)
267+ ON DELETE NO ACTION
268+ ON UPDATE NO ACTION,
269+ CONSTRAINT `fk_sessionvisitpages_visitpages1`
270+ FOREIGN KEY (`visitpage_id`)
271+ REFERENCES `iopeen_database`.`visitpages_table` (`visitpage_id`)
272+ ON DELETE NO ACTION
273+ ON UPDATE NO ACTION)
274+ENGINE = InnoDB
275+DEFAULT CHARACTER SET = utf8
276+COLLATE = utf8_general_ci;
277+
278+CREATE TABLE IF NOT EXISTS `iopeen_database`.`pages_table` (
279+ `page_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
280+ `active` TINYINT(1) NOT NULL DEFAULT 0,
281+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
282+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
283+ `name` VARCHAR(255) NOT NULL,
284+ `title` VARCHAR(255) NOT NULL,
285+ PRIMARY KEY (`page_id`),
286+ UNIQUE INDEX `page_id_UNIQUE` (`page_id` ASC))
287+ENGINE = InnoDB
288+DEFAULT CHARACTER SET = utf8
289+COLLATE = utf8_general_ci;
290+
291+CREATE TABLE IF NOT EXISTS `iopeen_database`.`passwordreset` (
292+ `passwordreset_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
293+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
294+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
295+ `member_id` BIGINT(20) NOT NULL,
296+ `email_id` BIGINT(20) NOT NULL,
297+ `previous` VARCHAR(255) NOT NULL,
298+ `generated` VARCHAR(255) NOT NULL,
299+ PRIMARY KEY (`passwordreset_id`),
300+ UNIQUE INDEX `passwordreset_id_UNIQUE` (`passwordreset_id` ASC),
301+ INDEX `fk_passwordreset_users1_idx` (`member_id` ASC),
302+ INDEX `fk_passwordreset_emails1_idx` (`email_id` ASC),
303+ CONSTRAINT `fk_passwordreset_users1`
304+ FOREIGN KEY (`member_id`)
305+ REFERENCES `iopeen_database`.`members_table` (`member_id`)
306+ ON DELETE NO ACTION
307+ ON UPDATE NO ACTION,
308+ CONSTRAINT `fk_passwordreset_emails1`
309+ FOREIGN KEY (`email_id`)
310+ REFERENCES `iopeen_database`.`emails` (`email_id`)
311+ ON DELETE NO ACTION
312+ ON UPDATE NO ACTION)
313+ENGINE = InnoDB
314+DEFAULT CHARACTER SET = utf8
315+COLLATE = utf8_general_ci;
316+
317+CREATE TABLE IF NOT EXISTS `iopeen_database`.`memberaccounts_table` (
318+ `memberaccount_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
319+ `active` TINYINT(1) NOT NULL DEFAULT 0,
320+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
321+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
322+ `member_id` BIGINT(20) NOT NULL,
323+ `account_id` BIGINT(20) NOT NULL,
324+ PRIMARY KEY (`memberaccount_id`),
325+ UNIQUE INDEX `useraccount_id_UNIQUE` (`memberaccount_id` ASC),
326+ INDEX `fk_useraccount_users1_idx` (`member_id` ASC),
327+ INDEX `fk_useraccount_account1_idx` (`account_id` ASC),
328+ CONSTRAINT `fk_useraccount_users1`
329+ FOREIGN KEY (`member_id`)
330+ REFERENCES `iopeen_database`.`members_table` (`member_id`)
331+ ON DELETE NO ACTION
332+ ON UPDATE NO ACTION,
333+ CONSTRAINT `fk_useraccount_account1`
334+ FOREIGN KEY (`account_id`)
335+ REFERENCES `iopeen_database`.`account_table` (`account_id`)
336+ ON DELETE NO ACTION
337+ ON UPDATE NO ACTION)
338+ENGINE = InnoDB
339+DEFAULT CHARACTER SET = utf8
340+COLLATE = utf8_general_ci;
341+
342+CREATE TABLE IF NOT EXISTS `iopeen_database`.`account_table` (
343+ `account_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
344+ `active` TINYINT(1) NOT NULL DEFAULT 0,
345+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
346+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
347+ `currency_id` BIGINT(20) NOT NULL,
348+ `value` FLOAT(11) NOT NULL DEFAULT 2000,
349+ `name` VARCHAR(255) NOT NULL,
350+ PRIMARY KEY (`account_id`),
351+ UNIQUE INDEX `account_id_UNIQUE` (`account_id` ASC),
352+ INDEX `currency_id_idx` (`currency_id` ASC))
353+ENGINE = InnoDB
354+DEFAULT CHARACTER SET = utf8
355+COLLATE = utf8_general_ci;
356+
357+CREATE TABLE IF NOT EXISTS `iopeen_database`.`transactions_table` (
358+ `transaction_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
359+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
360+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
361+ `currency_id` BIGINT(20) NOT NULL,
362+ `value` FLOAT(11) NOT NULL,
363+ `memberaccount_id1` BIGINT(20) NOT NULL,
364+ `memberaccount_id2` BIGINT(20) NOT NULL,
365+ PRIMARY KEY (`transaction_id`),
366+ UNIQUE INDEX `accounthistory_UNIQUE` (`transaction_id` ASC),
367+ INDEX `fk_accounthistory_useraccount1_idx` (`memberaccount_id1` ASC),
368+ INDEX `fk_accounthistory_useraccount2_idx` (`memberaccount_id2` ASC),
369+ INDEX `index5` (`currency_id` ASC),
370+ CONSTRAINT `fk_accounthistory_useraccount1`
371+ FOREIGN KEY (`memberaccount_id1`)
372+ REFERENCES `iopeen_database`.`memberaccounts_table` (`memberaccount_id`)
373+ ON DELETE NO ACTION
374+ ON UPDATE NO ACTION,
375+ CONSTRAINT `fk_accounthistory_useraccount2`
376+ FOREIGN KEY (`memberaccount_id2`)
377+ REFERENCES `iopeen_database`.`memberaccounts_table` (`memberaccount_id`)
378+ ON DELETE NO ACTION
379+ ON UPDATE NO ACTION)
380+ENGINE = InnoDB
381+DEFAULT CHARACTER SET = utf8
382+COLLATE = utf8_general_ci;
383+
384+CREATE TABLE IF NOT EXISTS `iopeen_database`.`currencies_table` (
385+ `currency_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
386+ `active` TINYINT(1) NOT NULL DEFAULT 0,
387+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
388+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
389+ `total_amount` FLOAT(11) NOT NULL,
390+ `name` VARCHAR(255) NOT NULL,
391+ `symbol` VARCHAR(10) NOT NULL,
392+ `ticker` VARCHAR(255) NOT NULL,
393+ PRIMARY KEY (`currency_id`),
394+ UNIQUE INDEX `currency_id_UNIQUE` (`currency_id` ASC),
395+ CONSTRAINT `fk_currency_account1`
396+ FOREIGN KEY (`currency_id`)
397+ REFERENCES `iopeen_database`.`account_table` (`currency_id`)
398+ ON DELETE NO ACTION
399+ ON UPDATE NO ACTION,
400+ CONSTRAINT `fk_currency_transactions1`
401+ FOREIGN KEY (`currency_id`)
402+ REFERENCES `iopeen_database`.`transactions_table` (`currency_id`)
403+ ON DELETE NO ACTION
404+ ON UPDATE NO ACTION,
405+ CONSTRAINT `fk_currencies_table_loans_table1`
406+ FOREIGN KEY (`currency_id`)
407+ REFERENCES `iopeen_database`.`loans_table` (`currency_id`)
408+ ON DELETE NO ACTION
409+ ON UPDATE NO ACTION)
410+ENGINE = InnoDB
411+DEFAULT CHARACTER SET = utf8
412+COLLATE = utf8_general_ci;
413+
414+CREATE TABLE IF NOT EXISTS `iopeen_database`.`configurations_table` (
415+ `configuration_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
416+ `active` TINYINT(1) NOT NULL DEFAULT 0,
417+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
418+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
419+ `member_id` BIGINT(20) NOT NULL,
420+ `name` VARCHAR(255) NOT NULL,
421+ `value` VARCHAR(255) NOT NULL,
422+ PRIMARY KEY (`configuration_id`),
423+ UNIQUE INDEX `configuration_id_UNIQUE` (`configuration_id` ASC),
424+ INDEX `fk_configurations_users1_idx` (`member_id` ASC),
425+ CONSTRAINT `fk_configurations_users1`
426+ FOREIGN KEY (`member_id`)
427+ REFERENCES `iopeen_database`.`members_table` (`member_id`)
428+ ON DELETE NO ACTION
429+ ON UPDATE NO ACTION)
430+ENGINE = InnoDB
431+DEFAULT CHARACTER SET = utf8
432+COLLATE = utf8_general_ci
433+COMMENT = 'user specific configuration, outside table scopes';
434+
435+CREATE TABLE IF NOT EXISTS `iopeen_database`.`address_table` (
436+ `address_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
437+ `active` TINYINT(1) NOT NULL DEFAULT 0,
438+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
439+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
440+ `country_id` BIGINT(20) NOT NULL,
441+ `province_id` BIGINT(20) NOT NULL,
442+ `city_id` BIGINT(20) NOT NULL,
443+ `postalcode` VARCHAR(20) NOT NULL,
444+ `address1` VARCHAR(255) NOT NULL,
445+ `address2` VARCHAR(255) NULL DEFAULT NULL,
446+ `location` VARCHAR(52) NULL DEFAULT NULL,
447+ PRIMARY KEY (`address_id`),
448+ INDEX `fk_address_provinces1_idx` (`province_id` ASC),
449+ INDEX `fk_address_cities1_idx` (`city_id` ASC),
450+ INDEX `country_id_idx` (`country_id` ASC),
451+ CONSTRAINT `fk_address_members_table1`
452+ FOREIGN KEY (`address_id`)
453+ REFERENCES `iopeen_database`.`members_table` (`address_id`)
454+ ON DELETE NO ACTION
455+ ON UPDATE NO ACTION,
456+ CONSTRAINT `fk_address_provinces1`
457+ FOREIGN KEY (`province_id`)
458+ REFERENCES `iopeen_database`.`provinces_table` (`province_id`)
459+ ON DELETE NO ACTION
460+ ON UPDATE NO ACTION,
461+ CONSTRAINT `fk_address_cities1`
462+ FOREIGN KEY (`city_id`)
463+ REFERENCES `iopeen_database`.`cities_table` (`city_id`)
464+ ON DELETE NO ACTION
465+ ON UPDATE NO ACTION)
466+ENGINE = InnoDB
467+DEFAULT CHARACTER SET = utf8
468+COLLATE = utf8_general_ci
469+COMMENT = 'addresses of members';
470+
471+CREATE TABLE IF NOT EXISTS `iopeen_database`.`emails` (
472+ `email_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
473+ `active` TINYINT(1) NOT NULL DEFAULT 0,
474+ `hidden` TINYINT(1) NOT NULL DEFAULT 0,
475+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
476+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
477+ `email` VARCHAR(255) NOT NULL,
478+ PRIMARY KEY (`email_id`),
479+ CONSTRAINT `fk_emails_members_table1`
480+ FOREIGN KEY (`email_id`)
481+ REFERENCES `iopeen_database`.`members_table` (`email_id`)
482+ ON DELETE NO ACTION
483+ ON UPDATE NO ACTION)
484+ENGINE = InnoDB
485+DEFAULT CHARACTER SET = utf8
486+COLLATE = utf8_general_ci
487+COMMENT = 'email addresses';
488+
489+CREATE TABLE IF NOT EXISTS `iopeen_database`.`branches_table` (
490+ `branch_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
491+ `branch_parent_id` BIGINT(20) NOT NULL DEFAULT 0,
492+ `active` TINYINT(1) NOT NULL DEFAULT 0,
493+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
494+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
495+ `name` VARCHAR(255) NOT NULL,
496+ `address_id` BIGINT(20) NOT NULL,
497+ `website` VARCHAR(255) NOT NULL,
498+ `terms` LONGTEXT NOT NULL,
499+ PRIMARY KEY (`branch_id`),
500+ INDEX `fk_branches_branches1_idx` (`branch_parent_id` ASC),
501+ INDEX `fk_branches_address1_idx` (`address_id` ASC),
502+ CONSTRAINT `fk_branches_branches1`
503+ FOREIGN KEY (`branch_parent_id`)
504+ REFERENCES `iopeen_database`.`branches_table` (`branch_id`)
505+ ON DELETE NO ACTION
506+ ON UPDATE NO ACTION,
507+ CONSTRAINT `fk_branches_address1`
508+ FOREIGN KEY (`address_id`)
509+ REFERENCES `iopeen_database`.`address_table` (`address_id`)
510+ ON DELETE NO ACTION
511+ ON UPDATE NO ACTION)
512+ENGINE = InnoDB
513+DEFAULT CHARACTER SET = utf8
514+COLLATE = utf8_general_ci;
515+
516+CREATE TABLE IF NOT EXISTS `iopeen_database`.`forex` (
517+ `forex_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
518+ `active` TINYINT(1) NOT NULL DEFAULT 0,
519+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
520+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
521+ `name` VARCHAR(45) NOT NULL,
522+ `website` VARCHAR(45) NULL DEFAULT NULL,
523+ PRIMARY KEY (`forex_id`))
524+ENGINE = InnoDB
525+DEFAULT CHARACTER SET = utf8
526+COLLATE = utf8_general_ci;
527+
528+CREATE TABLE IF NOT EXISTS `iopeen_database`.`languages_table` (
529+ `language_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
530+ `active` TINYINT(1) NOT NULL DEFAULT 0,
531+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
532+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
533+ `name` VARCHAR(255) NOT NULL,
534+ `domain` VARCHAR(4) NOT NULL,
535+ `utf` VARCHAR(6) NOT NULL,
536+ PRIMARY KEY (`language_id`),
537+ CONSTRAINT `fk_languages_members_table1`
538+ FOREIGN KEY (`language_id`)
539+ REFERENCES `iopeen_database`.`members_table` (`language_id`)
540+ ON DELETE NO ACTION
541+ ON UPDATE NO ACTION)
542+ENGINE = InnoDB
543+DEFAULT CHARACTER SET = utf8
544+COLLATE = utf8_general_ci;
545+
546+CREATE TABLE IF NOT EXISTS `iopeen_database`.`countries_table` (
547+ `country_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
548+ `active` TINYINT(1) NOT NULL DEFAULT 0,
549+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
550+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
551+ `dateformat_id` BIGINT(20) NOT NULL,
552+ `currencyformat_id` BIGINT(20) NOT NULL,
553+ `name` VARCHAR(255) NOT NULL,
554+ `location` VARCHAR(52) NOT NULL,
555+ PRIMARY KEY (`country_id`),
556+ INDEX `dateformat_id_idx` (`dateformat_id` ASC),
557+ INDEX `currencyformat_id_idx` (`currencyformat_id` ASC),
558+ CONSTRAINT `fk_countries_address1`
559+ FOREIGN KEY (`country_id`)
560+ REFERENCES `iopeen_database`.`address_table` (`country_id`)
561+ ON DELETE NO ACTION
562+ ON UPDATE NO ACTION)
563+ENGINE = InnoDB
564+DEFAULT CHARACTER SET = utf8
565+COLLATE = utf8_general_ci;
566+
567+CREATE TABLE IF NOT EXISTS `iopeen_database`.`countrylanguages_table` (
568+ `countrylanguage_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
569+ `active` TINYINT(1) NOT NULL DEFAULT 0,
570+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
571+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
572+ `country_id` BIGINT(20) NOT NULL,
573+ `language_id` BIGINT(20) NOT NULL,
574+ PRIMARY KEY (`countrylanguage_id`),
575+ INDEX `fk_countrylanguages_languages1_idx` (`language_id` ASC),
576+ INDEX `fk_countrylanguages_countries1_idx` (`country_id` ASC),
577+ CONSTRAINT `fk_countrylanguages_languages1`
578+ FOREIGN KEY (`language_id`)
579+ REFERENCES `iopeen_database`.`languages_table` (`language_id`)
580+ ON DELETE NO ACTION
581+ ON UPDATE NO ACTION,
582+ CONSTRAINT `fk_countrylanguages_countries1`
583+ FOREIGN KEY (`country_id`)
584+ REFERENCES `iopeen_database`.`countries_table` (`country_id`)
585+ ON DELETE NO ACTION
586+ ON UPDATE NO ACTION)
587+ENGINE = InnoDB
588+DEFAULT CHARACTER SET = utf8
589+COLLATE = utf8_general_ci;
590+
591+CREATE TABLE IF NOT EXISTS `iopeen_database`.`webshops_table` (
592+ `webshop_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
593+ `active` TINYINT(1) NOT NULL DEFAULT 0,
594+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
595+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
596+ `member_id` BIGINT(20) NOT NULL,
597+ `theme_id` BIGINT(20) NOT NULL,
598+ `name` VARCHAR(255) NOT NULL,
599+ PRIMARY KEY (`webshop_id`),
600+ INDEX `fk_webshops_members_table1_idx` (`member_id` ASC),
601+ CONSTRAINT `fk_webshops_members_table1`
602+ FOREIGN KEY (`member_id`)
603+ REFERENCES `iopeen_database`.`members_table` (`member_id`)
604+ ON DELETE NO ACTION
605+ ON UPDATE NO ACTION)
606+ENGINE = InnoDB
607+DEFAULT CHARACTER SET = utf8
608+COLLATE = utf8_general_ci;
609+
610+CREATE TABLE IF NOT EXISTS `iopeen_database`.`webshopcategories_table` (
611+ `webshopcategory_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
612+ `active` TINYINT(1) NOT NULL DEFAULT 0,
613+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
614+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
615+ `webshop_id` BIGINT(20) NOT NULL,
616+ `category_id` BIGINT(20) NOT NULL,
617+ `sort` BIGINT(20) NULL DEFAULT NULL,
618+ PRIMARY KEY (`webshopcategory_id`),
619+ INDEX `fk_webshopproducts_webshops1_idx` (`webshop_id` ASC),
620+ INDEX `fk_webshopcategories_categories1_idx` (`category_id` ASC),
621+ CONSTRAINT `fk_webshopproducts_webshops1`
622+ FOREIGN KEY (`webshop_id`)
623+ REFERENCES `iopeen_database`.`webshops_table` (`webshop_id`)
624+ ON DELETE NO ACTION
625+ ON UPDATE NO ACTION,
626+ CONSTRAINT `fk_webshopcategories_categories1`
627+ FOREIGN KEY (`category_id`)
628+ REFERENCES `iopeen_database`.`categories_table` (`category_id`)
629+ ON DELETE NO ACTION
630+ ON UPDATE NO ACTION)
631+ENGINE = InnoDB
632+DEFAULT CHARACTER SET = utf8
633+COLLATE = utf8_general_ci;
634+
635+CREATE TABLE IF NOT EXISTS `iopeen_database`.`products_table` (
636+ `product_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
637+ `active` TINYINT(1) NOT NULL DEFAULT 0,
638+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
639+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
640+ `ending` TIMESTAMP NOT NULL DEFAULT 0,
641+ `imagegroup_id` BIGINT(20) NOT NULL,
642+ `currency_id` BIGINT(20) NOT NULL,
643+ `value` VARCHAR(45) NOT NULL,
644+ `quanity` FLOAT(11) NOT NULL DEFAULT 1,
645+ `name` VARCHAR(255) NOT NULL,
646+ `descr` LONGTEXT NULL DEFAULT NULL,
647+ `quality` FLOAT(11) NULL DEFAULT NULL,
648+ PRIMARY KEY (`product_id`),
649+ INDEX `fk_products_currency1_idx` (`currency_id` ASC),
650+ INDEX `imagegroup_id_idx` (`imagegroup_id` ASC),
651+ CONSTRAINT `fk_products_currency1`
652+ FOREIGN KEY (`currency_id`)
653+ REFERENCES `iopeen_database`.`currencies_table` (`currency_id`)
654+ ON DELETE NO ACTION
655+ ON UPDATE NO ACTION)
656+ENGINE = InnoDB
657+DEFAULT CHARACTER SET = utf8
658+COLLATE = utf8_general_ci;
659+
660+CREATE TABLE IF NOT EXISTS `iopeen_database`.`mediagroups_table` (
661+ `mediagroup_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
662+ `active` TINYINT(1) NOT NULL DEFAULT 0,
663+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
664+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
665+ PRIMARY KEY (`mediagroup_id`),
666+ CONSTRAINT `fk_imagegroups_products1`
667+ FOREIGN KEY (`mediagroup_id`)
668+ REFERENCES `iopeen_database`.`products_table` (`imagegroup_id`)
669+ ON DELETE NO ACTION
670+ ON UPDATE NO ACTION,
671+ CONSTRAINT `fk_imagegroups_images1`
672+ FOREIGN KEY (`mediagroup_id`)
673+ REFERENCES `iopeen_database`.`media_table` (`mediagroup_id`)
674+ ON DELETE NO ACTION
675+ ON UPDATE NO ACTION)
676+ENGINE = InnoDB
677+DEFAULT CHARACTER SET = utf8
678+COLLATE = utf8_general_ci;
679+
680+CREATE TABLE IF NOT EXISTS `iopeen_database`.`media_table` (
681+ `media_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
682+ `active` TINYINT(1) NOT NULL DEFAULT 0,
683+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
684+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
685+ `mediagroup_id` BIGINT(20) NOT NULL,
686+ `type` VARCHAR(255) NOT NULL,
687+ `mediafile` VARCHAR(255) NOT NULL,
688+ `sort` BIGINT(20) NULL DEFAULT NULL,
689+ `name` VARCHAR(255) NULL DEFAULT NULL,
690+ `description` VARCHAR(255) NULL DEFAULT NULL,
691+ PRIMARY KEY (`media_id`),
692+ INDEX `mediagroup_id` (`mediagroup_id` ASC))
693+ENGINE = InnoDB
694+DEFAULT CHARACTER SET = utf8
695+COLLATE = utf8_general_ci;
696+
697+CREATE TABLE IF NOT EXISTS `iopeen_database`.`categories_table` (
698+ `category_id` BIGINT(20) NOT NULL,
699+ `active` TINYINT(1) NOT NULL DEFAULT 0,
700+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
701+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
702+ `name` VARCHAR(255) NULL DEFAULT NULL,
703+ `descr` VARCHAR(255) NULL DEFAULT NULL,
704+ PRIMARY KEY (`category_id`))
705+ENGINE = InnoDB
706+DEFAULT CHARACTER SET = utf8
707+COLLATE = utf8_general_ci;
708+
709+CREATE TABLE IF NOT EXISTS `iopeen_database`.`categoryproducts_table` (
710+ `categoryproduct_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
711+ `active` TINYINT(1) NOT NULL DEFAULT 0,
712+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
713+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
714+ `category_id` BIGINT(20) NOT NULL,
715+ `product_id` BIGINT(20) NOT NULL,
716+ `sort` INT(11) NULL DEFAULT NULL,
717+ PRIMARY KEY (`categoryproduct_id`),
718+ INDEX `fk_categoryproducts_categories1_idx` (`category_id` ASC),
719+ INDEX `fk_categoryproducts_products1_idx` (`product_id` ASC),
720+ CONSTRAINT `fk_categoryproducts_categories1`
721+ FOREIGN KEY (`category_id`)
722+ REFERENCES `iopeen_database`.`categories_table` (`category_id`)
723+ ON DELETE NO ACTION
724+ ON UPDATE NO ACTION,
725+ CONSTRAINT `fk_categoryproducts_products1`
726+ FOREIGN KEY (`product_id`)
727+ REFERENCES `iopeen_database`.`products_table` (`product_id`)
728+ ON DELETE NO ACTION
729+ ON UPDATE NO ACTION)
730+ENGINE = InnoDB
731+DEFAULT CHARACTER SET = utf8
732+COLLATE = utf8_general_ci;
733+
734+CREATE TABLE IF NOT EXISTS `iopeen_database`.`productforecast_table` (
735+ `productforecast_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
736+ `productforecastcol` TINYINT(1) NOT NULL DEFAULT 0,
737+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
738+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
739+ `product_id` BIGINT(20) NOT NULL,
740+ `quantity` FLOAT(11) NOT NULL,
741+ `value` FLOAT(11) NOT NULL,
742+ PRIMARY KEY (`productforecast_id`),
743+ INDEX `fk_productforecast_products1_idx` (`product_id` ASC),
744+ CONSTRAINT `fk_productforecast_products1`
745+ FOREIGN KEY (`product_id`)
746+ REFERENCES `iopeen_database`.`products_table` (`product_id`)
747+ ON DELETE NO ACTION
748+ ON UPDATE NO ACTION)
749+ENGINE = InnoDB
750+DEFAULT CHARACTER SET = utf8
751+COLLATE = utf8_general_ci;
752+
753+CREATE TABLE IF NOT EXISTS `iopeen_database`.`tags_table` (
754+ `tag_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
755+ `active` TINYINT(1) NOT NULL DEFAULT 0,
756+ `name` VARCHAR(255) NOT NULL,
757+ PRIMARY KEY (`tag_id`),
758+ CONSTRAINT `fk_tags_taggings1`
759+ FOREIGN KEY (`tag_id`)
760+ REFERENCES `iopeen_database`.`taggings_table` (`tag_id`)
761+ ON DELETE NO ACTION
762+ ON UPDATE NO ACTION)
763+ENGINE = InnoDB
764+DEFAULT CHARACTER SET = utf8
765+COLLATE = utf8_general_ci
766+COMMENT = 'attach a tag to about anything you want, to lookup information quickly and relevant';
767+
768+CREATE TABLE IF NOT EXISTS `iopeen_database`.`taggings_table` (
769+ `tagging_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
770+ `active` TINYINT(1) NOT NULL DEFAULT 0,
771+ `tag_id` BIGINT(20) NOT NULL,
772+ `table_id` BIGINT(20) NOT NULL,
773+ `table` VARCHAR(255) NOT NULL,
774+ PRIMARY KEY (`tagging_id`),
775+ INDEX `tag_id_idx` (`tag_id` ASC))
776+ENGINE = InnoDB
777+DEFAULT CHARACTER SET = utf8
778+COLLATE = utf8_general_ci;
779+
780+CREATE TABLE IF NOT EXISTS `iopeen_database`.`links_table` (
781+ `link_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
782+ `active` TINYINT(1) NOT NULL DEFAULT 0,
783+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
784+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
785+ `name` VARCHAR(255) NOT NULL,
786+ `url` VARCHAR(255) NOT NULL,
787+ PRIMARY KEY (`link_id`))
788+ENGINE = InnoDB
789+DEFAULT CHARACTER SET = utf8
790+COLLATE = utf8_general_ci;
791+
792+CREATE TABLE IF NOT EXISTS `iopeen_database`.`chat_table` (
793+ `chat_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
794+ `active` TINYINT(1) NOT NULL DEFAULT 0,
795+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
796+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
797+ `name` VARCHAR(255) NULL DEFAULT NULL,
798+ PRIMARY KEY (`chat_id`))
799+ENGINE = InnoDB
800+DEFAULT CHARACTER SET = utf8
801+COLLATE = utf8_general_ci;
802+
803+CREATE TABLE IF NOT EXISTS `iopeen_database`.`chatrooms_table` (
804+ `chatroom_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
805+ `active` TINYINT(1) NOT NULL DEFAULT 0,
806+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
807+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
808+ `chat_id` BIGINT(20) NOT NULL,
809+ `name` VARCHAR(255) NOT NULL,
810+ PRIMARY KEY (`chatroom_id`),
811+ INDEX `fk_chatrooms_chat1_idx` (`chat_id` ASC),
812+ CONSTRAINT `fk_chatrooms_chat1`
813+ FOREIGN KEY (`chat_id`)
814+ REFERENCES `iopeen_database`.`chat_table` (`chat_id`)
815+ ON DELETE NO ACTION
816+ ON UPDATE NO ACTION)
817+ENGINE = InnoDB
818+DEFAULT CHARACTER SET = utf8
819+COLLATE = utf8_general_ci;
820+
821+CREATE TABLE IF NOT EXISTS `iopeen_database`.`chatmessages_table` (
822+ `chatmessage_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
823+ `chatroom_id` BIGINT(20) NOT NULL,
824+ `member_id` BIGINT(20) NOT NULL,
825+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
826+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
827+ `message` VARCHAR(255) NOT NULL,
828+ PRIMARY KEY (`chatmessage_id`),
829+ INDEX `fk_chatmessages_members_table1_idx` (`member_id` ASC),
830+ INDEX `fk_chatmessages_chatrooms1_idx` (`chatroom_id` ASC),
831+ CONSTRAINT `fk_chatmessages_members_table1`
832+ FOREIGN KEY (`member_id`)
833+ REFERENCES `iopeen_database`.`members_table` (`member_id`)
834+ ON DELETE NO ACTION
835+ ON UPDATE NO ACTION,
836+ CONSTRAINT `fk_chatmessages_chatrooms1`
837+ FOREIGN KEY (`chatroom_id`)
838+ REFERENCES `iopeen_database`.`chatrooms_table` (`chatroom_id`)
839+ ON DELETE NO ACTION
840+ ON UPDATE NO ACTION)
841+ENGINE = InnoDB
842+DEFAULT CHARACTER SET = utf8
843+COLLATE = utf8_general_ci;
844+
845+CREATE TABLE IF NOT EXISTS `iopeen_database`.`needs_table` (
846+ `need_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
847+ `active` TINYINT(1) NOT NULL DEFAULT 0,
848+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
849+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
850+ `name` VARCHAR(255) NULL DEFAULT NULL,
851+ `descr` VARCHAR(255) NULL DEFAULT NULL,
852+ `product_id` BIGINT(20) NULL DEFAULT NULL,
853+ PRIMARY KEY (`need_id`),
854+ INDEX `fk_needs_products1_idx` (`product_id` ASC),
855+ CONSTRAINT `fk_needs_products1`
856+ FOREIGN KEY (`product_id`)
857+ REFERENCES `iopeen_database`.`products_table` (`product_id`)
858+ ON DELETE NO ACTION
859+ ON UPDATE NO ACTION)
860+ENGINE = InnoDB
861+DEFAULT CHARACTER SET = utf8
862+COLLATE = utf8_general_ci
863+COMMENT = 'needs or wants of known and unknown products or services';
864+
865+CREATE TABLE IF NOT EXISTS `iopeen_database`.`memberneeds_table` (
866+ `memberneed_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
867+ `active` TINYINT(1) NOT NULL DEFAULT 0,
868+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
869+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
870+ `member_id` BIGINT(20) NOT NULL,
871+ `need_id` BIGINT(20) NOT NULL,
872+ `want` TINYINT(1) NOT NULL DEFAULT 0,
873+ PRIMARY KEY (`memberneed_id`),
874+ INDEX `fk_memberneeds_members_table1_idx` (`member_id` ASC),
875+ INDEX `fk_memberneeds_needs1_idx` (`need_id` ASC),
876+ CONSTRAINT `fk_memberneeds_members_table1`
877+ FOREIGN KEY (`member_id`)
878+ REFERENCES `iopeen_database`.`members_table` (`member_id`)
879+ ON DELETE NO ACTION
880+ ON UPDATE NO ACTION,
881+ CONSTRAINT `fk_memberneeds_needs1`
882+ FOREIGN KEY (`need_id`)
883+ REFERENCES `iopeen_database`.`needs_table` (`need_id`)
884+ ON DELETE NO ACTION
885+ ON UPDATE NO ACTION)
886+ENGINE = InnoDB
887+DEFAULT CHARACTER SET = utf8
888+COLLATE = utf8_general_ci
889+COMMENT = 'product needs or wants of a member';
890+
891+CREATE TABLE IF NOT EXISTS `iopeen_database`.`branchpeerings_table` (
892+ `peering_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
893+ `active` TINYINT(1) NOT NULL DEFAULT 0,
894+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
895+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
896+ `branch_id_1` BIGINT(20) NOT NULL,
897+ `branch_id_2` BIGINT(20) NOT NULL,
898+ `peer_id_1` BIGINT(20) NOT NULL,
899+ `peer_id_2` BIGINT(20) NOT NULL,
900+ PRIMARY KEY (`peering_id`),
901+ INDEX `fk_branchpeerings_branches1_idx` (`branch_id_1` ASC),
902+ INDEX `fk_branchpeerings_branches2_idx` (`branch_id_2` ASC),
903+ INDEX `fk_branchpeerings_peers1_idx` (`peer_id_1` ASC),
904+ INDEX `fk_branchpeerings_peers2_idx` (`peer_id_2` ASC),
905+ CONSTRAINT `fk_branchpeerings_branches1`
906+ FOREIGN KEY (`branch_id_1`)
907+ REFERENCES `iopeen_database`.`branches_table` (`branch_id`)
908+ ON DELETE NO ACTION
909+ ON UPDATE NO ACTION,
910+ CONSTRAINT `fk_branchpeerings_branches2`
911+ FOREIGN KEY (`branch_id_2`)
912+ REFERENCES `iopeen_database`.`branches_table` (`branch_id`)
913+ ON DELETE NO ACTION
914+ ON UPDATE NO ACTION,
915+ CONSTRAINT `fk_branchpeerings_peers1`
916+ FOREIGN KEY (`peer_id_1`)
917+ REFERENCES `iopeen_database`.`peers_table` (`peer_id`)
918+ ON DELETE NO ACTION
919+ ON UPDATE NO ACTION,
920+ CONSTRAINT `fk_branchpeerings_peers2`
921+ FOREIGN KEY (`peer_id_2`)
922+ REFERENCES `iopeen_database`.`peers_table` (`peer_id`)
923+ ON DELETE NO ACTION
924+ ON UPDATE NO ACTION)
925+ENGINE = InnoDB
926+DEFAULT CHARACTER SET = utf8
927+COLLATE = utf8_general_ci;
928+
929+CREATE TABLE IF NOT EXISTS `iopeen_database`.`peers_table` (
930+ `peer_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
931+ `active` TINYINT(1) NOT NULL DEFAULT 0,
932+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
933+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
934+ `ipaddress` VARCHAR(255) NULL DEFAULT NULL,
935+ `port` VARCHAR(255) NULL DEFAULT NULL,
936+ `db_type` VARCHAR(255) NULL DEFAULT '(mysql,postgresql,mssql,)',
937+ `db_user` VARCHAR(255) NULL DEFAULT NULL,
938+ `db_pass` VARCHAR(255) NULL DEFAULT NULL,
939+ `db_database` VARCHAR(255) NULL DEFAULT NULL,
940+ `pk_certificate` VARCHAR(4096) NULL DEFAULT NULL,
941+ PRIMARY KEY (`peer_id`))
942+ENGINE = InnoDB
943+DEFAULT CHARACTER SET = utf8
944+COLLATE = utf8_general_ci
945+COMMENT = 'master master server duplication is easy on same software type database servers but difficult for different ones\nhttp://www.howtoforge.com/mysql_master_master_replication ';
946+
947+CREATE TABLE IF NOT EXISTS `iopeen_database`.`provinces_table` (
948+ `province_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
949+ `active` TINYINT(1) NOT NULL DEFAULT 0,
950+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
951+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
952+ `name` VARCHAR(255) NOT NULL,
953+ PRIMARY KEY (`province_id`))
954+ENGINE = InnoDB
955+DEFAULT CHARACTER SET = utf8
956+COLLATE = utf8_general_ci;
957+
958+CREATE TABLE IF NOT EXISTS `iopeen_database`.`cities_table` (
959+ `city_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
960+ `active` TINYINT(1) NOT NULL DEFAULT 0,
961+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
962+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
963+ `name` VARCHAR(255) NOT NULL,
964+ PRIMARY KEY (`city_id`))
965+ENGINE = InnoDB
966+DEFAULT CHARACTER SET = utf8
967+COLLATE = utf8_general_ci;
968+
969+CREATE TABLE IF NOT EXISTS `iopeen_database`.`branchmembers_table` (
970+ `branchmember_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
971+ `active` TINYINT(1) NOT NULL DEFAULT 0,
972+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
973+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
974+ `branch_id` BIGINT(20) NOT NULL,
975+ `member_id` BIGINT(20) NOT NULL,
976+ `admin` TINYINT(1) NOT NULL DEFAULT 0,
977+ PRIMARY KEY (`branchmember_id`),
978+ INDEX `fk_branchadmins_branches1_idx` (`branch_id` ASC),
979+ INDEX `fk_branchadmins_members_table1_idx` (`member_id` ASC),
980+ CONSTRAINT `fk_branchadmins_branches1`
981+ FOREIGN KEY (`branch_id`)
982+ REFERENCES `iopeen_database`.`branches_table` (`branch_id`)
983+ ON DELETE NO ACTION
984+ ON UPDATE NO ACTION,
985+ CONSTRAINT `fk_branchadmins_members_table1`
986+ FOREIGN KEY (`member_id`)
987+ REFERENCES `iopeen_database`.`members_table` (`member_id`)
988+ ON DELETE NO ACTION
989+ ON UPDATE NO ACTION)
990+ENGINE = InnoDB
991+DEFAULT CHARACTER SET = utf8
992+COLLATE = utf8_general_ci
993+COMMENT = 'members of a brache, also defines who is an admin';
994+
995+CREATE TABLE IF NOT EXISTS `iopeen_database`.`dateformats_table` (
996+ `dateformat_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
997+ `active` TINYINT(1) NOT NULL DEFAULT 0,
998+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
999+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
1000+ `format` VARCHAR(255) NOT NULL,
1001+ PRIMARY KEY (`dateformat_id`),
1002+ CONSTRAINT `fk_dateformats_table_members_table1`
1003+ FOREIGN KEY (`dateformat_id`)
1004+ REFERENCES `iopeen_database`.`members_table` (`dateformat_id`)
1005+ ON DELETE NO ACTION
1006+ ON UPDATE NO ACTION,
1007+ CONSTRAINT `fk_dateformats_table_countries_table1`
1008+ FOREIGN KEY (`dateformat_id`)
1009+ REFERENCES `iopeen_database`.`countries_table` (`dateformat_id`)
1010+ ON DELETE NO ACTION
1011+ ON UPDATE NO ACTION)
1012+ENGINE = InnoDB
1013+DEFAULT CHARACTER SET = utf8
1014+COLLATE = utf8_general_ci;
1015+
1016+CREATE TABLE IF NOT EXISTS `iopeen_database`.`currencyformat_table` (
1017+ `currencyformat_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
1018+ `active` TINYINT(1) NOT NULL DEFAULT 0,
1019+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
1020+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
1021+ `format` VARCHAR(255) NOT NULL,
1022+ PRIMARY KEY (`currencyformat_id`),
1023+ CONSTRAINT `fk_currencyformat_table_members_table1`
1024+ FOREIGN KEY (`currencyformat_id`)
1025+ REFERENCES `iopeen_database`.`members_table` (`currencyformat_id`)
1026+ ON DELETE NO ACTION
1027+ ON UPDATE NO ACTION,
1028+ CONSTRAINT `fk_currencyformat_table_countries_table1`
1029+ FOREIGN KEY (`currencyformat_id`)
1030+ REFERENCES `iopeen_database`.`countries_table` (`currencyformat_id`)
1031+ ON DELETE NO ACTION
1032+ ON UPDATE NO ACTION)
1033+ENGINE = InnoDB
1034+DEFAULT CHARACTER SET = utf8
1035+COLLATE = utf8_general_ci;
1036+
1037+CREATE TABLE IF NOT EXISTS `iopeen_database`.`needfulfilleds_table` (
1038+ `needfulfilled_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
1039+ `active` TINYINT(1) NOT NULL DEFAULT 0,
1040+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
1041+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
1042+ `memberneed_id` BIGINT(20) NOT NULL,
1043+ `member_id` BIGINT(20) NOT NULL,
1044+ `product_id` BIGINT(20) NOT NULL,
1045+ `reward` VARCHAR(255) NULL DEFAULT NULL,
1046+ PRIMARY KEY (`needfulfilled_id`),
1047+ INDEX `fk_needfulfilleds_table_members_table1_idx` (`member_id` ASC),
1048+ INDEX `fk_needfulfilleds_table_products_table1_idx` (`product_id` ASC),
1049+ INDEX `fk_needfulfilleds_table_memberneeds_table1_idx` (`memberneed_id` ASC),
1050+ CONSTRAINT `fk_needfulfilleds_table_members_table1`
1051+ FOREIGN KEY (`member_id`)
1052+ REFERENCES `iopeen_database`.`members_table` (`member_id`)
1053+ ON DELETE NO ACTION
1054+ ON UPDATE NO ACTION,
1055+ CONSTRAINT `fk_needfulfilleds_table_products_table1`
1056+ FOREIGN KEY (`product_id`)
1057+ REFERENCES `iopeen_database`.`products_table` (`product_id`)
1058+ ON DELETE NO ACTION
1059+ ON UPDATE NO ACTION,
1060+ CONSTRAINT `fk_needfulfilleds_table_memberneeds_table1`
1061+ FOREIGN KEY (`memberneed_id`)
1062+ REFERENCES `iopeen_database`.`memberneeds_table` (`memberneed_id`)
1063+ ON DELETE NO ACTION
1064+ ON UPDATE NO ACTION)
1065+ENGINE = InnoDB
1066+DEFAULT CHARACTER SET = utf8
1067+COLLATE = utf8_general_ci;
1068+
1069+CREATE TABLE IF NOT EXISTS `iopeen_database`.`works_table` (
1070+ `work_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
1071+ `active` TINYINT(1) NOT NULL DEFAULT 0,
1072+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
1073+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
1074+ `owner` BIGINT(20) NOT NULL,
1075+ `currency_id` BIGINT(20) NOT NULL,
1076+ `value` VARCHAR(45) NOT NULL,
1077+ `name` VARCHAR(255) NOT NULL,
1078+ `price_per` VARCHAR(45) NULL DEFAULT NULL,
1079+ `description` VARCHAR(255) NULL DEFAULT NULL,
1080+ `who` VARCHAR(255) NULL DEFAULT NULL,
1081+ `what` VARCHAR(255) NULL DEFAULT NULL,
1082+ `where` VARCHAR(255) NULL DEFAULT NULL,
1083+ `when` VARCHAR(255) NULL DEFAULT NULL,
1084+ `why` VARCHAR(255) NULL DEFAULT NULL,
1085+ `which` VARCHAR(255) NULL DEFAULT NULL,
1086+ `how` VARCHAR(255) NULL DEFAULT NULL,
1087+ `quantity` VARCHAR(255) NULL DEFAULT NULL,
1088+ `quality` VARCHAR(255) NULL DEFAULT NULL,
1089+ PRIMARY KEY (`work_id`))
1090+ENGINE = InnoDB
1091+DEFAULT CHARACTER SET = utf8
1092+COLLATE = utf8_general_ci;
1093+
1094+CREATE TABLE IF NOT EXISTS `iopeen_database`.`jobs_table` (
1095+ `job_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
1096+ `active` TINYINT(1) NOT NULL DEFAULT 0,
1097+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
1098+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
1099+ `name` VARCHAR(255) NOT NULL,
1100+ `descr` VARCHAR(255) NULL DEFAULT NULL,
1101+ PRIMARY KEY (`job_id`))
1102+ENGINE = InnoDB
1103+DEFAULT CHARACTER SET = utf8
1104+COLLATE = utf8_general_ci;
1105+
1106+CREATE TABLE IF NOT EXISTS `iopeen_database`.`memberjobs_table` (
1107+ `memberjob_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
1108+ `active` TINYINT(1) NOT NULL DEFAULT 0,
1109+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
1110+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
1111+ `member_id` BIGINT(20) NOT NULL,
1112+ `job_id` BIGINT(20) NOT NULL,
1113+ PRIMARY KEY (`memberjob_id`),
1114+ INDEX `fk_memberjobs_table_members_table1_idx` (`member_id` ASC),
1115+ INDEX `fk_memberjobs_table_jobs_table1_idx` (`job_id` ASC),
1116+ CONSTRAINT `fk_memberjobs_table_members_table1`
1117+ FOREIGN KEY (`member_id`)
1118+ REFERENCES `iopeen_database`.`members_table` (`member_id`)
1119+ ON DELETE NO ACTION
1120+ ON UPDATE NO ACTION,
1121+ CONSTRAINT `fk_memberjobs_table_jobs_table1`
1122+ FOREIGN KEY (`job_id`)
1123+ REFERENCES `iopeen_database`.`jobs_table` (`job_id`)
1124+ ON DELETE NO ACTION
1125+ ON UPDATE NO ACTION)
1126+ENGINE = InnoDB
1127+DEFAULT CHARACTER SET = utf8
1128+COLLATE = utf8_general_ci;
1129+
1130+CREATE TABLE IF NOT EXISTS `iopeen_database`.`jobworks_table` (
1131+ `jobwork_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
1132+ `active` TINYINT(1) NOT NULL DEFAULT 0,
1133+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
1134+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
1135+ `job_id` BIGINT(20) NOT NULL,
1136+ `work_id` BIGINT(20) NOT NULL,
1137+ PRIMARY KEY (`jobwork_id`),
1138+ INDEX `fk_jobworks_table_jobs_table1_idx` (`job_id` ASC),
1139+ INDEX `fk_jobworks_table_works_table1_idx` (`work_id` ASC),
1140+ CONSTRAINT `fk_jobworks_table_jobs_table1`
1141+ FOREIGN KEY (`job_id`)
1142+ REFERENCES `iopeen_database`.`jobs_table` (`job_id`)
1143+ ON DELETE NO ACTION
1144+ ON UPDATE NO ACTION,
1145+ CONSTRAINT `fk_jobworks_table_works_table1`
1146+ FOREIGN KEY (`work_id`)
1147+ REFERENCES `iopeen_database`.`works_table` (`work_id`)
1148+ ON DELETE NO ACTION
1149+ ON UPDATE NO ACTION)
1150+ENGINE = InnoDB
1151+DEFAULT CHARACTER SET = utf8
1152+COLLATE = utf8_general_ci;
1153+
1154+CREATE TABLE IF NOT EXISTS `iopeen_database`.`loans_table` (
1155+ `loan_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
1156+ `active` TINYINT(1) NOT NULL DEFAULT 0,
1157+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
1158+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
1159+ `creditor_member_id` BIGINT(20) NOT NULL,
1160+ `debitor_member_id` BIGINT(20) NOT NULL,
1161+ `currency_id` BIGINT(20) NOT NULL,
1162+ `amount` FLOAT(11) NOT NULL,
1163+ `fee` FLOAT(11) NOT NULL,
1164+ `runtime` VARCHAR(255) NULL DEFAULT NULL,
1165+ `paymentperiod` VARCHAR(255) NULL DEFAULT NULL,
1166+ `descr` VARCHAR(255) NULL DEFAULT NULL,
1167+ PRIMARY KEY (`loan_id`),
1168+ INDEX `fk_loans_table_members_table1_idx` (`debitor_member_id` ASC),
1169+ INDEX `fk_loans_table_members_table2_idx` (`creditor_member_id` ASC),
1170+ INDEX `currency_id_idx` (`currency_id` ASC),
1171+ CONSTRAINT `fk_loans_table_members_table1`
1172+ FOREIGN KEY (`debitor_member_id`)
1173+ REFERENCES `iopeen_database`.`members_table` (`member_id`)
1174+ ON DELETE NO ACTION
1175+ ON UPDATE NO ACTION,
1176+ CONSTRAINT `fk_loans_table_members_table2`
1177+ FOREIGN KEY (`creditor_member_id`)
1178+ REFERENCES `iopeen_database`.`members_table` (`member_id`)
1179+ ON DELETE NO ACTION
1180+ ON UPDATE NO ACTION)
1181+ENGINE = InnoDB
1182+DEFAULT CHARACTER SET = utf8
1183+COLLATE = utf8_general_ci;
1184+
1185+CREATE TABLE IF NOT EXISTS `iopeen_database`.`loantransactions_table` (
1186+ `loantransaction_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
1187+ `active` TINYINT(1) NOT NULL DEFAULT 0,
1188+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
1189+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
1190+ `loan_id` BIGINT(20) NOT NULL,
1191+ `transaction_id` BIGINT(20) NOT NULL,
1192+ PRIMARY KEY (`loantransaction_id`),
1193+ INDEX `fk_loantransactions_table_loans_table1_idx` (`loan_id` ASC),
1194+ INDEX `fk_loantransactions_table_transactions_table1_idx` (`transaction_id` ASC),
1195+ CONSTRAINT `fk_loantransactions_table_loans_table1`
1196+ FOREIGN KEY (`loan_id`)
1197+ REFERENCES `iopeen_database`.`loans_table` (`loan_id`)
1198+ ON DELETE NO ACTION
1199+ ON UPDATE NO ACTION,
1200+ CONSTRAINT `fk_loantransactions_table_transactions_table1`
1201+ FOREIGN KEY (`transaction_id`)
1202+ REFERENCES `iopeen_database`.`transactions_table` (`transaction_id`)
1203+ ON DELETE NO ACTION
1204+ ON UPDATE NO ACTION)
1205+ENGINE = InnoDB
1206+DEFAULT CHARACTER SET = utf8
1207+COLLATE = utf8_general_ci;
1208+
1209+CREATE TABLE IF NOT EXISTS `iopeen_database`.`translations_table` (
1210+ `translation_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
1211+ `active` TINYINT(1) NOT NULL DEFAULT 0,
1212+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
1213+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
1214+ `member_id` BIGINT(20) NOT NULL,
1215+ `line_id` BIGINT(20) NOT NULL,
1216+ `language_id` BIGINT(20) NOT NULL,
1217+ `translation` VARCHAR(255) NOT NULL,
1218+ PRIMARY KEY (`translation_id`),
1219+ INDEX `fk_translations_table_languages_table1_idx` (`language_id` ASC),
1220+ INDEX `fk_translations_table_members_table1_idx` (`member_id` ASC),
1221+ INDEX `fk_translations_table_lines_table1_idx` (`line_id` ASC),
1222+ CONSTRAINT `fk_translations_table_languages_table1`
1223+ FOREIGN KEY (`language_id`)
1224+ REFERENCES `iopeen_database`.`languages_table` (`language_id`)
1225+ ON DELETE NO ACTION
1226+ ON UPDATE NO ACTION,
1227+ CONSTRAINT `fk_translations_table_members_table1`
1228+ FOREIGN KEY (`member_id`)
1229+ REFERENCES `iopeen_database`.`members_table` (`member_id`)
1230+ ON DELETE NO ACTION
1231+ ON UPDATE NO ACTION,
1232+ CONSTRAINT `fk_translations_table_lines_table1`
1233+ FOREIGN KEY (`line_id`)
1234+ REFERENCES `iopeen_database`.`lines_table` (`line_id`)
1235+ ON DELETE NO ACTION
1236+ ON UPDATE NO ACTION)
1237+ENGINE = InnoDB
1238+DEFAULT CHARACTER SET = utf8
1239+COLLATE = utf8_general_ci;
1240+
1241+CREATE TABLE IF NOT EXISTS `iopeen_database`.`lines_table` (
1242+ `line_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
1243+ `active` TINYINT(1) NOT NULL DEFAULT 0,
1244+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
1245+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
1246+ `line` VARCHAR(255) NOT NULL,
1247+ PRIMARY KEY (`line_id`))
1248+ENGINE = InnoDB
1249+DEFAULT CHARACTER SET = utf8
1250+COLLATE = utf8_general_ci;
1251+
1252+CREATE TABLE IF NOT EXISTS `iopeen_database`.`reviews_table` (
1253+ `review_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
1254+ `active` TINYINT(1) NOT NULL DEFAULT 0,
1255+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
1256+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
1257+ `member_id` BIGINT(20) NOT NULL,
1258+ `name` VARCHAR(255) NULL DEFAULT NULL,
1259+ `descr` VARCHAR(255) NULL DEFAULT NULL,
1260+ PRIMARY KEY (`review_id`),
1261+ INDEX `fk_reviews_table_members_table1_idx` (`member_id` ASC),
1262+ CONSTRAINT `fk_reviews_table_members_table1`
1263+ FOREIGN KEY (`member_id`)
1264+ REFERENCES `iopeen_database`.`members_table` (`member_id`)
1265+ ON DELETE NO ACTION
1266+ ON UPDATE NO ACTION)
1267+ENGINE = InnoDB
1268+DEFAULT CHARACTER SET = utf8
1269+COLLATE = utf8_general_ci;
1270+
1271+CREATE TABLE IF NOT EXISTS `iopeen_database`.`reviewtransactions_table` (
1272+ `reviewtransaction_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
1273+ `active` TINYINT(1) NOT NULL DEFAULT 0,
1274+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
1275+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
1276+ `review_id` BIGINT(20) NOT NULL,
1277+ `transaction_id` BIGINT(20) NOT NULL,
1278+ PRIMARY KEY (`reviewtransaction_id`),
1279+ INDEX `fk_reviewtransations_table_reviews_table1_idx` (`review_id` ASC),
1280+ INDEX `fk_reviewtransations_table_transactions_table1_idx` (`transaction_id` ASC),
1281+ CONSTRAINT `fk_reviewtransations_table_reviews_table1`
1282+ FOREIGN KEY (`review_id`)
1283+ REFERENCES `iopeen_database`.`reviews_table` (`review_id`)
1284+ ON DELETE NO ACTION
1285+ ON UPDATE NO ACTION,
1286+ CONSTRAINT `fk_reviewtransations_table_transactions_table1`
1287+ FOREIGN KEY (`transaction_id`)
1288+ REFERENCES `iopeen_database`.`transactions_table` (`transaction_id`)
1289+ ON DELETE NO ACTION
1290+ ON UPDATE NO ACTION)
1291+ENGINE = InnoDB
1292+DEFAULT CHARACTER SET = utf8
1293+COLLATE = utf8_general_ci;
1294+
1295+CREATE TABLE IF NOT EXISTS `iopeen_database`.`exchange_ION_USD_table` (
1296+ `exchange_ION_USD_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
1297+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
1298+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
1299+ `previous_price` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(ion_value)',
1300+ `new_members` BIGINT(20) NOT NULL DEFAULT 0,
1301+ `total_members` BIGINT(20) NOT NULL DEFAULT 0 COMMENT '(total_members + new_members)',
1302+ `ions_added` FLOAT(11) NOT NULL DEFAULT 0,
1303+ `ions_removed` FLOAT(11) NOT NULL DEFAULT 0,
1304+ `ions_exchanged` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(ions_added – ions_removed)',
1305+ `ions_markettrades` FLOAT(11) NOT NULL DEFAULT 0,
1306+ `ions_exhanged_market` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '((ions_added + ions_removed) / ions_markettrades)',
1307+ `market_value` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(ions_markettrades * previous_price)',
1308+ `total_ions` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(total_ions +(total_members*100) + (new_members*2000) + ions_added + ions_removed)',
1309+ `hosting_benefits` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(balance + profit)',
1310+ `hosting_costs` FLOAT(11) NOT NULL DEFAULT 2.21,
1311+ `added_value` FLOAT(11) NOT NULL DEFAULT 0,
1312+ `removed_value` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '((ions_removed * previous_price) * (buy_per_usd * sell_per_ion))',
1313+ `balance` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(hosting_benefits + hosting_costs + added_value + removed_value)',
1314+ `ions_balance` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(total_ions / balance)',
1315+ `ion_value` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(hosting_benefits / (total_ions + ions_markettrades) ) * (if (balance_total_ions_value <0, 1.01, 0.99))',
1316+ `total_ions_value` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(total_ions * ion_value)',
1317+ `balance_total_ions_value` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(balance - total_ions_value)',
1318+ `predict_ion_value` FLOAT(11) NOT NULL DEFAULT 0 COMMENT 'average(previous_ion_value-1 ,previous_ion_value)',
1319+ `predict_ion_correct` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(IF(ROUND(predict_ion_value,4)=ROUND(ion_value,4),100, (predict_ion_value - ion_value)))',
1320+ `average_ions` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(total_ions / total_members)',
1321+ `average_member_value` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(average_ions * ion_value)',
1322+ `dollar_usd` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(previous_dollar_usd - (previous_dollar_usd/36600))',
1323+ `ions_per_usd` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(dollar_usd / ion_value)',
1324+ `buy_per_usd` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(ions_per_usd - (ions_per_usd * 0.4))',
1325+ `predict_usd_value` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(AVERAGE(previous_buy_per_usd-1, previous_buy_per_usd)-(MAX(previous_buy_per_usd-1, previous_buy_per_usd)-MIN(previous_buy_per_usd-1, previous_buy_per_usd)))',
1326+ `predict_usd_correct` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(IF(ROUND(predict_usd_value,1)=ROUND(buy_per_usd,1),100, (predict_usd_value - buy_per_usd)))',
1327+ `buy_per_usd_ion_value` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(buy_per_usd * ion_value)',
1328+ `account` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(balance * 0.1)',
1329+ `excess` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(account + hosting_costs + removed_value)',
1330+ `savings` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(balance * 0.4)',
1331+ `projects` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(balance * 0.25)',
1332+ `crypto` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(balance * 0.25)',
1333+ `profit` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '((savings + projects + crypto) *1.02)',
1334+ `sum` FLOAT(11) NOT NULL DEFAULT 0 COMMENT '(account + savings + projects + crypto + profit)',
1335+ PRIMARY KEY (`exchange_ION_USD_id`))
1336+ENGINE = MyISAM
1337+DEFAULT CHARACTER SET = utf8
1338+COLLATE = utf8_general_ci;
1339+
1340+CREATE TABLE IF NOT EXISTS `iopeen_database`.`chatroommembers_table` (
1341+ `chatroommember_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
1342+ `active` TINYINT(1) NOT NULL DEFAULT 0,
1343+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
1344+ `updated_at` TIMESTAMP NULL DEFAULT 0,
1345+ `chatroom_id` BIGINT(20) NOT NULL,
1346+ `member_id` BIGINT(20) NOT NULL,
1347+ PRIMARY KEY (`chatroommember_id`),
1348+ INDEX `fk_chatroommembers_table_chatrooms_table1_idx` (`chatroom_id` ASC),
1349+ INDEX `fk_chatroommembers_table_members_table1_idx` (`member_id` ASC),
1350+ CONSTRAINT `fk_chatroommembers_table_chatrooms_table1`
1351+ FOREIGN KEY (`chatroom_id`)
1352+ REFERENCES `iopeen_database`.`chatrooms_table` (`chatroom_id`)
1353+ ON DELETE NO ACTION
1354+ ON UPDATE NO ACTION,
1355+ CONSTRAINT `fk_chatroommembers_table_members_table1`
1356+ FOREIGN KEY (`member_id`)
1357+ REFERENCES `iopeen_database`.`members_table` (`member_id`)
1358+ ON DELETE NO ACTION
1359+ ON UPDATE NO ACTION)
1360+ENGINE = InnoDB
1361+DEFAULT CHARACTER SET = utf8
1362+COLLATE = utf8_general_ci;
1363+
1364+CREATE TABLE IF NOT EXISTS `iopeen_database`.`chatroommessagesreceived_table` (
1365+ `chatroommessagesreceived_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
1366+ `chatmessage_id` BIGINT(20) NOT NULL,
1367+ `chatroommember_id` BIGINT(20) NOT NULL,
1368+ `created_at` TIMESTAMP NOT NULL DEFAULT 0,
1369+ `updated_at` TIMESTAMP NOT NULL DEFAULT 0,
1370+ PRIMARY KEY (`chatroommessagesreceived_id`),
1371+ INDEX `fk_chatroommessagesrecieved_table_chatmessages_table1_idx` (`chatmessage_id` ASC),
1372+ INDEX `fk_chatroommessagesrecieved_table_chatroommembers_table1_idx` (`chatroommember_id` ASC),
1373+ CONSTRAINT `fk_chatroommessagesrecieved_table_chatmessages_table1`
1374+ FOREIGN KEY (`chatmessage_id`)
1375+ REFERENCES `iopeen_database`.`chatmessages_table` (`chatmessage_id`)
1376+ ON DELETE NO ACTION
1377+ ON UPDATE NO ACTION,
1378+ CONSTRAINT `fk_chatroommessagesrecieved_table_chatroommembers_table1`
1379+ FOREIGN KEY (`chatroommember_id`)
1380+ REFERENCES `iopeen_database`.`chatroommembers_table` (`chatroommember_id`)
1381+ ON DELETE NO ACTION
1382+ ON UPDATE NO ACTION)
1383+ENGINE = InnoDB
1384+DEFAULT CHARACTER SET = utf8
1385+COLLATE = utf8_general_ci;
1386+
1387+
1388+SET SQL_MODE=@OLD_SQL_MODE;
1389+SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
1390+SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
1391
1392=== added file 'app/database/migrations/2014_01_24_024524_schema_creation_revert.sql'
1393--- app/database/migrations/2014_01_24_024524_schema_creation_revert.sql 1970-01-01 00:00:00 +0000
1394+++ app/database/migrations/2014_01_24_024524_schema_creation_revert.sql 2014-01-24 18:10:37 +0000
1395@@ -0,0 +1,127 @@
1396+SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
1397+SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
1398+SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
1399+
1400+DROP TABLE IF EXISTS `iopeen_database`.`members_table`;
1401+
1402+DROP TABLE IF EXISTS `iopeen_database`.`membergroups_table`;
1403+
1404+DROP TABLE IF EXISTS `iopeen_database`.`groups_table`;
1405+
1406+DROP TABLE IF EXISTS `iopeen_database`.`rights_table`;
1407+
1408+DROP TABLE IF EXISTS `iopeen_database`.`grouprights_table`;
1409+
1410+DROP TABLE IF EXISTS `iopeen_database`.`sessions_table`;
1411+
1412+DROP TABLE IF EXISTS `iopeen_database`.`membersessions_table`;
1413+
1414+DROP TABLE IF EXISTS `iopeen_database`.`visitpages_table`;
1415+
1416+DROP TABLE IF EXISTS `iopeen_database`.`sessionvisitpages_table`;
1417+
1418+DROP TABLE IF EXISTS `iopeen_database`.`pages_table`;
1419+
1420+DROP TABLE IF EXISTS `iopeen_database`.`passwordreset`;
1421+
1422+DROP TABLE IF EXISTS `iopeen_database`.`memberaccounts_table`;
1423+
1424+DROP TABLE IF EXISTS `iopeen_database`.`account_table`;
1425+
1426+DROP TABLE IF EXISTS `iopeen_database`.`transactions_table`;
1427+
1428+DROP TABLE IF EXISTS `iopeen_database`.`currencies_table`;
1429+
1430+DROP TABLE IF EXISTS `iopeen_database`.`configurations_table`;
1431+
1432+DROP TABLE IF EXISTS `iopeen_database`.`address_table`;
1433+
1434+DROP TABLE IF EXISTS `iopeen_database`.`emails`;
1435+
1436+DROP TABLE IF EXISTS `iopeen_database`.`branches_table`;
1437+
1438+DROP TABLE IF EXISTS `iopeen_database`.`forex`;
1439+
1440+DROP TABLE IF EXISTS `iopeen_database`.`languages_table`;
1441+
1442+DROP TABLE IF EXISTS `iopeen_database`.`countries_table`;
1443+
1444+DROP TABLE IF EXISTS `iopeen_database`.`countrylanguages_table`;
1445+
1446+DROP TABLE IF EXISTS `iopeen_database`.`webshops_table`;
1447+
1448+DROP TABLE IF EXISTS `iopeen_database`.`webshopcategories_table`;
1449+
1450+DROP TABLE IF EXISTS `iopeen_database`.`products_table`;
1451+
1452+DROP TABLE IF EXISTS `iopeen_database`.`mediagroups_table`;
1453+
1454+DROP TABLE IF EXISTS `iopeen_database`.`media_table`;
1455+
1456+DROP TABLE IF EXISTS `iopeen_database`.`categories_table`;
1457+
1458+DROP TABLE IF EXISTS `iopeen_database`.`categoryproducts_table`;
1459+
1460+DROP TABLE IF EXISTS `iopeen_database`.`productforecast_table`;
1461+
1462+DROP TABLE IF EXISTS `iopeen_database`.`tags_table`;
1463+
1464+DROP TABLE IF EXISTS `iopeen_database`.`taggings_table`;
1465+
1466+DROP TABLE IF EXISTS `iopeen_database`.`links_table`;
1467+
1468+DROP TABLE IF EXISTS `iopeen_database`.`chat_table`;
1469+
1470+DROP TABLE IF EXISTS `iopeen_database`.`chatrooms_table`;
1471+
1472+DROP TABLE IF EXISTS `iopeen_database`.`chatmessages_table`;
1473+
1474+DROP TABLE IF EXISTS `iopeen_database`.`needs_table`;
1475+
1476+DROP TABLE IF EXISTS `iopeen_database`.`memberneeds_table`;
1477+
1478+DROP TABLE IF EXISTS `iopeen_database`.`branchpeerings_table`;
1479+
1480+DROP TABLE IF EXISTS `iopeen_database`.`peers_table`;
1481+
1482+DROP TABLE IF EXISTS `iopeen_database`.`provinces_table`;
1483+
1484+DROP TABLE IF EXISTS `iopeen_database`.`cities_table`;
1485+
1486+DROP TABLE IF EXISTS `iopeen_database`.`branchemembers_table`;
1487+
1488+DROP TABLE IF EXISTS `iopeen_database`.`dateformats_table`;
1489+
1490+DROP TABLE IF EXISTS `iopeen_database`.`currencyformat_table`;
1491+
1492+DROP TABLE IF EXISTS `iopeen_database`.`needfulfilleds_table`;
1493+
1494+DROP TABLE IF EXISTS `iopeen_database`.`works_table`;
1495+
1496+DROP TABLE IF EXISTS `iopeen_database`.`jobs_table`;
1497+
1498+DROP TABLE IF EXISTS `iopeen_database`.`memberjobs_table`;
1499+
1500+DROP TABLE IF EXISTS `iopeen_database`.`jobworks_table`;
1501+
1502+DROP TABLE IF EXISTS `iopeen_database`.`loans_table`;
1503+
1504+DROP TABLE IF EXISTS `iopeen_database`.`loantransactions_table`;
1505+
1506+DROP TABLE IF EXISTS `iopeen_database`.`translations_table`;
1507+
1508+DROP TABLE IF EXISTS `iopeen_database`.`lines_table`;
1509+
1510+DROP TABLE IF EXISTS `iopeen_database`.`reviews_table`;
1511+
1512+DROP TABLE IF EXISTS `iopeen_database`.`reviewtransations_table`;
1513+
1514+DROP TABLE IF EXISTS `iopeen_database`.`exchange_ION_USD_table`;
1515+
1516+DROP TABLE IF EXISTS `iopeen_database`.`chatroommembers_table`;
1517+
1518+DROP TABLE IF EXISTS `iopeen_database`.`chatroommessagesrecieved_table`;
1519+
1520+SET SQL_MODE=@OLD_SQL_MODE;
1521+SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
1522+SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

Subscribers

People subscribed via source and target branches

to all changes: