[Summary view]
[Print]
[Text view]
1 -- $Id: web2project.sql 200 2008-08-05 22:51:30Z pedroix $ $URL: https://web2project.svn.sourceforge.net/svnroot/web2project/trunk/install/web2project.sql $
2 -- WEB2PROJECT MANUAL DATABASE CREATION
3 -- USE THIS FILE FOR TESTING PURPOSES ONLY!
4 -- WITH A NORMAL WEB2PROJECT INSTALL YOU WILL NOT NEED TO USE THIS FILE BECAUSE ALL DATABASE CREATION PROCEDURES SHOULD BE HANDLED BY WEB2PROJECT INSTALLER.
5 -- USE THIS FILE AT YOUR OWN RISK AND DON'T FORGET TO BACKUP ANY IMPORTANT DATA OR FILES BEFORE USING IT.
6
7 -- HOW TO USE THIS FILE:
8 -- 1) YOU SHOULD CREATE A NEW EMPTY DATABASE AND THEN IMPORT THIS SCRIPT INTO IT USING PHPMYADMIN.
9 -- NOTE: IF YOU WANT TO USE TABLE NAMES WITH PREFIXES PLEASE REPLACE IN THIS SQL FILE ALL REFERENCES TO CREATE TABLE ` TO CREATE TABLE `yourprefix_
10 -- THEN YOU CAN IMPORT THE SQL SCRIPT WITH PHPMYADMIN. KEEP IN MIND THAT YOU WILL HAVE TO SET THAT PREFIX ON THE includes/config.php FILE WITH $w2Pconfig['dbprefix'] = 'yourprefix_';
11 -- 2) CHANGE YOUR includes/config.php TO POINT TO THE DATABASE WITH THE CORRECT SETTINGS.
12 -- 3) AFTER THAT YOU CAN POINT YOUR BROWSER TO YOUR WEB2PROJECT SITE AND LOGIN WITH USER admin AND PASSWORD passwd
13
14 -- PLEASE PROVIDE US WITH FEEDBACK ON OUR FORUMS AT:
15 -- http://forums.web2project.net
16 --
17 -- AND HELP US SPREAD THE WORD,
18 -- THANK YOU VERY MUCH.
19
20 --
21 -- (C) 2008 WEB2PROJECT DEVELOPMENT TEAM
22 --
23
24 -- phpMyAdmin SQL Dump
25 -- version 2.11.4
26 -- http://www.phpmyadmin.net
27 --
28 -- Host: localhost
29 -- Generation Time: Mar 03, 2008 at 03:34 AM
30 -- Server version: 5.0.45
31 -- PHP Version: 5.2.3
32
33 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
34
35 --
36 -- Database: `web2project`
37 --
38
39 -- --------------------------------------------------------
40
41 --
42 -- Table structure for table `billingcode`
43 --
44
45 CREATE TABLE `billingcode` (
46 `billingcode_id` bigint(20) NOT NULL auto_increment,
47 `billingcode_name` varchar(25) NOT NULL default '',
48 `billingcode_value` float NOT NULL default '0',
49 `billingcode_desc` varchar(255) NOT NULL default '',
50 `billingcode_status` int(1) NOT NULL default '0',
51 `company_id` bigint(20) NOT NULL default '0',
52 PRIMARY KEY (`billingcode_id`),
53 UNIQUE KEY `billingcode_name` (`billingcode_name`,`company_id`),
54 KEY `billingcode_name_2` (`billingcode_name`),
55 KEY `billingcode_status` (`billingcode_status`)
56 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
57
58 -- --------------------------------------------------------
59
60 --
61 -- Table structure for table `companies`
62 --
63
64 CREATE TABLE `companies` (
65 `company_id` int(10) NOT NULL auto_increment,
66 `company_module` int(10) NOT NULL default '0',
67 `company_name` varchar(100) default '',
68 `company_phone1` varchar(30) default '',
69 `company_phone2` varchar(30) default '',
70 `company_fax` varchar(30) default '',
71 `company_address1` varchar(50) default '',
72 `company_address2` varchar(50) default '',
73 `company_city` varchar(30) default '',
74 `company_state` varchar(30) default '',
75 `company_zip` varchar(11) default '',
76 `company_country` varchar(100) NOT NULL default '',
77 `company_primary_url` varchar(255) default '',
78 `company_owner` int(11) NOT NULL default '0',
79 `company_description` text,
80 `company_type` int(3) NOT NULL default '0',
81 `company_email` varchar(255) default NULL,
82 `company_custom` longtext,
83 `company_private` int(1) unsigned NOT NULL default '0',
84 PRIMARY KEY (`company_id`),
85 KEY `idx_cpy1` (`company_owner`),
86 KEY `company_name` (`company_name`),
87 KEY `company_type` (`company_type`)
88 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
89
90 -- --------------------------------------------------------
91
92 --
93 -- Table structure for table `config`
94 --
95
96 CREATE TABLE `config` (
97 `config_id` int(11) NOT NULL auto_increment,
98 `config_name` varchar(255) NOT NULL default '',
99 `config_value` varchar(255) NOT NULL default '',
100 `config_group` varchar(255) NOT NULL default '',
101 `config_type` varchar(255) NOT NULL default '',
102 PRIMARY KEY (`config_id`),
103 UNIQUE KEY `config_name` (`config_name`)
104 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
105
106 --
107 -- Dumping data for table `config`
108 --
109
110 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(1, 'host_locale', 'en', 'admin_system', 'text');
111 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(2, 'check_overallocation', 'false', 'tasks', 'checkbox');
112 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(3, 'currency_symbol', '$', 'budgeting', 'text');
113 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(4, 'host_style', 'web2project', 'admin_system', 'text');
114 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(5, 'company_name', 'web2Project Development', 'admin_system', 'text');
115 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(6, 'page_title', 'web2Project', 'admin_system', 'text');
116 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(7, 'site_domain', 'web2project.net', 'admin_system', 'text');
117 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(8, 'email_prefix', '[web2Project]', 'mail', 'text');
118 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(9, 'admin_username', 'admin', 'admin_users', 'text');
119 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(10, 'username_min_len', '4', 'admin_users', 'text');
120 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(11, 'password_min_len', '4', 'admin_users', 'text');
121 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(12, 'enable_gantt_charts', 'true', 'admin_system', 'checkbox');
122 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(13, 'log_changes', 'true', 'admin_system', 'checkbox');
123 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(14, 'check_task_dates', 'true', 'tasks', 'checkbox');
124 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(15, 'locale_warn', 'false', 'locales', 'checkbox');
125 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(16, 'locale_alert', '^', 'locales', 'text');
126 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(17, 'daily_working_hours', '8.0', 'calendar', 'text');
127 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(18, 'display_debug', 'false', 'admin_system', 'checkbox');
128 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(20, 'show_all_task_assignees', 'false', 'tasks', 'checkbox');
129 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(21, 'direct_edit_assignment', 'true', 'tasks', 'checkbox');
130 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(22, 'restrict_color_selection', 'false', 'projects', 'checkbox');
131 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(23, 'cal_day_view_show_minical', 'true', 'calendar', 'checkbox');
132 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(24, 'cal_day_start', '8', 'calendar', 'text');
133 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(25, 'cal_day_end', '17', 'calendar', 'text');
134 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(26, 'cal_day_increment', '15', 'calendar', 'text');
135 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(27, 'cal_working_days', '1,2,3,4,5', 'calendar', 'text');
136 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(28, 'restrict_task_time_editing', 'false', 'tasks', 'checkbox');
137 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(29, 'default_view_m', 'calendar', 'startup', 'text');
138 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(30, 'default_view_a', 'day_view', 'startup', 'text');
139 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(31, 'default_view_tab', '1', 'startup', 'text');
140 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(32, 'index_max_file_size', '-1', 'files', 'text');
141 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(33, 'session_handling', 'app', 'session', 'select');
142 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(34, 'session_idle_time', '2d', 'session', 'text');
143 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(35, 'session_max_lifetime', '1m', 'session', 'text');
144 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(36, 'debug', '1', 'admin_system', 'text');
145 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(37, 'parser_default', '/usr/bin/strings', 'files', 'text');
146 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(38, 'parser_application/msword', '/usr/bin/strings', 'files', 'text');
147 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(39, 'parser_text/html', '/usr/bin/strings', 'files', 'text');
148 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(40, 'parser_application/pdf', '/usr/bin/pdftotext', 'files', 'text');
149 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(41, 'files_ci_preserve_attr', 'true', 'files', 'checkbox');
150 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(42, 'files_show_versions_edit', 'false', 'files', 'checkbox');
151 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(43, 'reset_memory_limit', '64M', 'admin_system', 'text');
152 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(44, 'auth_method', 'sql', 'auth', 'select');
153 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(45, 'ldap_host', 'localhost', 'ldap', 'text');
154 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(46, 'ldap_port', '389', 'ldap', 'text');
155 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(47, 'ldap_version', '3', 'ldap', 'text');
156 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(48, 'ldap_base_dn', 'dc=web2project,dc=net', 'ldap', 'text');
157 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(49, 'ldap_user_filter', '(uid=%USERNAME%)', 'ldap', 'text');
158 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(50, 'postnuke_allow_login', 'true', 'auth', 'checkbox');
159 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(51, 'mail_transport', 'smtp', 'mail', 'select');
160 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(52, 'mail_host', 'mail.yourdomain.com', 'mail', 'text');
161 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(53, 'mail_port', '25', 'mail', 'text');
162 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(54, 'mail_auth', 'true', 'mail', 'checkbox');
163 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(55, 'mail_user', 'smtpuser', 'mail', 'text');
164 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(56, 'mail_pass', 'smtppasswd', 'mail', 'password');
165 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(57, 'mail_defer', 'false', 'mail', 'checkbox');
166 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(58, 'mail_timeout', '30', 'mail', 'text');
167 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(59, 'task_reminder_control', 'false', 'tasks', 'checkbox');
168 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(60, 'task_reminder_days_before', '1', 'tasks', 'text');
169 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(61, 'task_reminder_repeat', '100', 'tasks', 'text');
170 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(62, 'session_gc_scan_queue', 'false', 'session', 'checkbox');
171 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(63, 'ldap_search_user', 'Manager', 'ldap', 'text');
172 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(64, 'ldap_search_pass', 'secret', 'ldap', 'password');
173 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(65, 'ldap_allow_login', 'true', 'ldap', 'checkbox');
174 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(66, 'activate_external_user_creation', 'true', 'admin_users', 'checkbox');
175 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(67, 'projectdesigner_view_project', 'false', 'projects', 'checkbox');
176 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(68, 'mail_secure', '', 'mail', 'select');
177 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(69, 'mail_debug', 'false', 'mail', 'checkbox');
178 INSERT INTO `config` (`config_id`, `config_name`, `config_value`, `config_group`, `config_type`) VALUES(70, 'template_projects_status_id', '6', 'projects', 'text');
179
180 -- --------------------------------------------------------
181
182 --
183 -- Table structure for table `config_list`
184 --
185
186 CREATE TABLE `config_list` (
187 `config_list_id` int(11) NOT NULL auto_increment,
188 `config_id` int(11) NOT NULL default '0',
189 `config_list_name` varchar(30) NOT NULL default '',
190 PRIMARY KEY (`config_list_id`),
191 KEY `config_id` (`config_id`)
192 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
193
194 --
195 -- Dumping data for table `config_list`
196 --
197
198 INSERT INTO `config_list` (`config_list_id`, `config_id`, `config_list_name`) VALUES(1, 44, 'sql');
199 INSERT INTO `config_list` (`config_list_id`, `config_id`, `config_list_name`) VALUES(2, 44, 'ldap');
200 INSERT INTO `config_list` (`config_list_id`, `config_id`, `config_list_name`) VALUES(3, 44, 'pn');
201 INSERT INTO `config_list` (`config_list_id`, `config_id`, `config_list_name`) VALUES(4, 33, 'app');
202 INSERT INTO `config_list` (`config_list_id`, `config_id`, `config_list_name`) VALUES(5, 33, 'php');
203 INSERT INTO `config_list` (`config_list_id`, `config_id`, `config_list_name`) VALUES(6, 51, 'php');
204 INSERT INTO `config_list` (`config_list_id`, `config_id`, `config_list_name`) VALUES(7, 51, 'smtp');
205 INSERT INTO `config_list` (`config_list_id`, `config_id`, `config_list_name`) VALUES(8, 68, '');
206 INSERT INTO `config_list` (`config_list_id`, `config_id`, `config_list_name`) VALUES(9, 68, 'tls');
207 INSERT INTO `config_list` (`config_list_id`, `config_id`, `config_list_name`) VALUES(10, 68, 'ssl');
208
209 -- --------------------------------------------------------
210
211 --
212 -- Table structure for table `contacts`
213 --
214
215 CREATE TABLE `contacts` (
216 `contact_id` int(11) NOT NULL auto_increment,
217 `contact_first_name` varchar(30) default NULL,
218 `contact_last_name` varchar(30) default NULL,
219 `contact_order_by` varchar(30) NOT NULL default '',
220 `contact_title` varchar(50) default NULL,
221 `contact_birthday` date default NULL,
222 `contact_job` varchar(255) default NULL,
223 `contact_company` int(11) NOT NULL default '0',
224 `contact_department` int(11) NOT NULL default '0',
225 `contact_type` varchar(20) default NULL,
226 `contact_email` varchar(255) default NULL,
227 `contact_email2` varchar(255) default NULL,
228 `contact_url` varchar(255) default NULL,
229 `contact_phone` varchar(30) default NULL,
230 `contact_phone2` varchar(30) default NULL,
231 `contact_fax` varchar(30) default NULL,
232 `contact_mobile` varchar(30) default NULL,
233 `contact_address1` varchar(60) default NULL,
234 `contact_address2` varchar(60) default NULL,
235 `contact_city` varchar(30) default NULL,
236 `contact_state` varchar(30) default NULL,
237 `contact_zip` varchar(11) default NULL,
238 `contact_country` varchar(30) default NULL,
239 `contact_jabber` varchar(255) default NULL,
240 `contact_icq` varchar(20) default NULL,
241 `contact_msn` varchar(255) default NULL,
242 `contact_yahoo` varchar(255) default NULL,
243 `contact_aol` varchar(30) default NULL,
244 `contact_notes` text,
245 `contact_project` int(11) NOT NULL default '0',
246 `contact_icon` varchar(20) default 'obj/contact',
247 `contact_owner` int(10) unsigned default '0',
248 `contact_private` tinyint(3) unsigned default '0',
249 `contact_updatekey` varchar(32) default NULL,
250 `contact_lastupdate` datetime default NULL,
251 `contact_updateasked` datetime default NULL,
252 `contact_skype` varchar(100) NOT NULL,
253 `contact_google` varchar(255) NOT NULL,
254 PRIMARY KEY (`contact_id`),
255 KEY `idx_oby` (`contact_order_by`),
256 KEY `idx_co` (`contact_company`),
257 KEY `idx_prp` (`contact_project`),
258 KEY `contact_first_name` (`contact_first_name`),
259 KEY `contact_last_name` (`contact_last_name`),
260 KEY `contact_updatekey` (`contact_updatekey`),
261 KEY `contact_email` (`contact_email`),
262 KEY `contact_private` (`contact_private`),
263 KEY `contact_department` (`contact_department`)
264 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
265
266 --
267 -- Dumping data for table `contacts`
268 --
269
270 INSERT INTO `contacts` (`contact_id`, `contact_first_name`, `contact_last_name`, `contact_order_by`, `contact_title`, `contact_birthday`, `contact_job`, `contact_company`, `contact_department`, `contact_type`, `contact_email`, `contact_email2`, `contact_url`, `contact_phone`, `contact_phone2`, `contact_fax`, `contact_mobile`, `contact_address1`, `contact_address2`, `contact_city`, `contact_state`, `contact_zip`, `contact_country`, `contact_jabber`, `contact_icq`, `contact_msn`, `contact_yahoo`, `contact_aol`, `contact_notes`, `contact_project`, `contact_icon`, `contact_owner`, `contact_private`, `contact_updatekey`, `contact_lastupdate`, `contact_updateasked`, `contact_skype`, `contact_google`) VALUES(1, 'Admin', 'Person', '', NULL, NULL, NULL, 0, 0, NULL, 'admin@localhost', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'obj/contact', 0, 0, NULL, NULL, NULL, '', '');
271
272 -- --------------------------------------------------------
273
274 --
275 -- Table structure for table `custom_fields_lists`
276 --
277
278 CREATE TABLE `custom_fields_lists` (
279 `field_id` int(11) default NULL,
280 `list_option_id` int(11) default NULL,
281 `list_value` varchar(250) default NULL,
282 KEY `field_id` (`field_id`),
283 KEY `list_value` (`list_value`)
284 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
285
286 -- --------------------------------------------------------
287
288 --
289 -- Table structure for table `custom_fields_struct`
290 --
291
292 CREATE TABLE `custom_fields_struct` (
293 `field_id` int(11) NOT NULL default '0',
294 `field_module` varchar(30) default NULL,
295 `field_page` varchar(30) default NULL,
296 `field_htmltype` varchar(20) default NULL,
297 `field_datatype` varchar(20) default NULL,
298 `field_order` int(11) default NULL,
299 `field_name` varchar(100) default NULL,
300 `field_extratags` varchar(250) default NULL,
301 `field_description` varchar(250) default NULL,
302 `field_tab` int(11) NOT NULL default '0',
303 `field_published` tinyint(1) default '0',
304 PRIMARY KEY (`field_id`),
305 KEY `cfs_field_order` (`field_order`),
306 KEY `field_module` (`field_module`),
307 KEY `field_page` (`field_page`)
308 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
309
310 -- --------------------------------------------------------
311
312 --
313 -- Table structure for table `custom_fields_values`
314 --
315
316 CREATE TABLE `custom_fields_values` (
317 `value_id` int(11) NOT NULL default '0',
318 `value_module` varchar(30) default NULL,
319 `value_object_id` int(11) default NULL,
320 `value_field_id` int(11) default NULL,
321 `value_charvalue` varchar(250) default NULL,
322 `value_intvalue` int(11) default NULL,
323 PRIMARY KEY (`value_id`),
324 KEY `value_field_id` (`value_field_id`),
325 KEY `value_object_id` (`value_object_id`),
326 KEY `value_charvalue` (`value_charvalue`)
327 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
328
329 --
330 -- Dumping data for table `custom_fields_values`
331 --
332
333 -- --------------------------------------------------------
334
335 --
336 -- Table structure for table `departments`
337 --
338
339 CREATE TABLE `departments` (
340 `dept_id` int(10) unsigned NOT NULL auto_increment,
341 `dept_parent` int(10) unsigned NOT NULL default '0',
342 `dept_company` int(10) unsigned NOT NULL default '0',
343 `dept_name` varchar(255) NOT NULL default '',
344 `dept_phone` varchar(30) default NULL,
345 `dept_fax` varchar(30) default NULL,
346 `dept_address1` varchar(30) default NULL,
347 `dept_address2` varchar(30) default NULL,
348 `dept_city` varchar(30) default NULL,
349 `dept_state` varchar(30) default NULL,
350 `dept_zip` varchar(11) default NULL,
351 `dept_url` varchar(25) default NULL,
352 `dept_desc` text,
353 `dept_owner` int(10) unsigned NOT NULL default '0',
354 `dept_country` varchar(100) NOT NULL,
355 `dept_email` varchar(255) NOT NULL default '',
356 `dept_type` int(3) unsigned NOT NULL default '0',
357 PRIMARY KEY (`dept_id`),
358 KEY `dept_parent` (`dept_parent`),
359 KEY `dept_name` (`dept_name`)
360 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Department heirarchy under a company';
361
362 -- --------------------------------------------------------
363
364 --
365 -- Table structure for table `events`
366 --
367
368 CREATE TABLE `events` (
369 `event_id` int(11) NOT NULL auto_increment,
370 `event_title` varchar(255) NOT NULL default '',
371 `event_start_date` datetime default NULL,
372 `event_end_date` datetime default NULL,
373 `event_parent` int(11) unsigned NOT NULL default '0',
374 `event_description` text,
375 `event_url` varchar(255) default NULL,
376 `event_times_recuring` int(11) unsigned NOT NULL default '0',
377 `event_recurs` int(11) unsigned NOT NULL default '0',
378 `event_remind` int(10) unsigned NOT NULL default '0',
379 `event_icon` varchar(20) default 'obj/event',
380 `event_owner` int(11) default '0',
381 `event_project` int(11) default '0',
382 `event_task` int(11) default NULL,
383 `event_private` tinyint(3) default '0',
384 `event_type` tinyint(3) default '0',
385 `event_cwd` tinyint(3) default '0',
386 `event_notify` tinyint(3) NOT NULL default '0',
387 `event_location` varchar(255) NOT NULL default '',
388 PRIMARY KEY (`event_id`),
389 KEY `id_esd` (`event_start_date`),
390 KEY `id_eed` (`event_end_date`),
391 KEY `id_evp` (`event_parent`),
392 KEY `idx_ev1` (`event_owner`),
393 KEY `idx_ev2` (`event_project`),
394 KEY `event_recurs` (`event_recurs`)
395 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
396
397 -- --------------------------------------------------------
398
399 --
400 -- Table structure for table `event_contacts`
401 --
402
403 CREATE TABLE `event_contacts` (
404 `event_id` int(11) NOT NULL default '0',
405 `contact_id` int(11) NOT NULL default '0',
406 PRIMARY KEY (`event_id`,`contact_id`)
407 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
408
409 --
410 -- Dumping data for table `event_contacts`
411 --
412
413
414 -- --------------------------------------------------------
415
416 --
417 -- Table structure for table `event_queue`
418 --
419
420 CREATE TABLE `event_queue` (
421 `queue_id` int(11) NOT NULL auto_increment,
422 `queue_start` int(11) NOT NULL default '0',
423 `queue_type` varchar(40) NOT NULL default '',
424 `queue_repeat_interval` int(11) NOT NULL default '0',
425 `queue_repeat_count` int(11) NOT NULL default '0',
426 `queue_data` longblob NOT NULL,
427 `queue_callback` varchar(127) NOT NULL default '',
428 `queue_owner` int(11) NOT NULL default '0',
429 `queue_origin_id` int(11) NOT NULL default '0',
430 `queue_module` varchar(40) NOT NULL default '',
431 `queue_module_type` varchar(20) NOT NULL default '',
432 PRIMARY KEY (`queue_id`),
433 KEY `queue_start` (`queue_start`),
434 KEY `queue_module` (`queue_module`),
435 KEY `queue_type` (`queue_type`),
436 KEY `queue_origin_id` (`queue_origin_id`)
437 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
438
439 --
440 -- Dumping data for table `event_queue`
441 --
442
443
444 -- --------------------------------------------------------
445
446 --
447 -- Table structure for table `files`
448 --
449
450 CREATE TABLE `files` (
451 `file_id` int(11) NOT NULL auto_increment,
452 `file_real_filename` varchar(255) NOT NULL default '',
453 `file_project` int(11) NOT NULL default '0',
454 `file_task` int(11) NOT NULL default '0',
455 `file_name` varchar(255) NOT NULL default '',
456 `file_parent` int(11) default '0',
457 `file_description` text,
458 `file_type` varchar(100) default NULL,
459 `file_owner` int(11) default '0',
460 `file_date` datetime default NULL,
461 `file_size` int(11) default '0',
462 `file_version` float NOT NULL default '0',
463 `file_icon` varchar(20) default 'obj/',
464 `file_category` int(11) default '0',
465 `file_checkout` varchar(16) NOT NULL,
466 `file_co_reason` text,
467 `file_version_id` int(11) NOT NULL default '0',
468 `file_folder` int(11) NOT NULL default '0',
469 `file_helpdesk_item` int(11) NOT NULL default '0',
470 PRIMARY KEY (`file_id`),
471 KEY `idx_file_task` (`file_task`),
472 KEY `idx_file_project` (`file_project`),
473 KEY `idx_file_parent` (`file_parent`),
474 KEY `idx_file_vid` (`file_version_id`),
475 KEY `file_name` (`file_name`),
476 KEY `file_folder` (`file_folder`),
477 KEY `file_category` (`file_category`),
478 KEY `file_checkout` (`file_checkout`)
479 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
480
481 -- --------------------------------------------------------
482
483 --
484 -- Table structure for table `files_index`
485 --
486
487 CREATE TABLE `files_index` (
488 `file_id` int(11) NOT NULL default '0',
489 `word` varchar(50) NOT NULL default '',
490 `word_placement` int(11) NOT NULL default '0',
491 PRIMARY KEY (`file_id`,`word`,`word_placement`),
492 KEY `idx_fwrd` (`word`)
493 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
494
495 -- --------------------------------------------------------
496
497 --
498 -- Table structure for table `file_folders`
499 --
500
501 CREATE TABLE `file_folders` (
502 `file_folder_id` int(11) NOT NULL auto_increment,
503 `file_folder_parent` int(11) NOT NULL default '0',
504 `file_folder_name` varchar(255) NOT NULL default '',
505 `file_folder_description` text,
506 PRIMARY KEY (`file_folder_id`),
507 KEY `file_folder_parent` (`file_folder_parent`),
508 KEY `file_folder_name` (`file_folder_name`)
509 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
510
511 -- --------------------------------------------------------
512
513 --
514 -- Table structure for table `forums`
515 --
516
517 CREATE TABLE `forums` (
518 `forum_id` int(11) NOT NULL auto_increment,
519 `forum_project` int(11) NOT NULL default '0',
520 `forum_status` tinyint(4) NOT NULL default '-1',
521 `forum_owner` int(11) NOT NULL default '0',
522 `forum_name` varchar(50) NOT NULL default '',
523 `forum_create_date` datetime default '0000-00-00 00:00:00',
524 `forum_last_date` datetime default '0000-00-00 00:00:00',
525 `forum_last_id` int(10) unsigned NOT NULL default '0',
526 `forum_message_count` int(11) NOT NULL default '0',
527 `forum_description` varchar(255) default NULL,
528 `forum_moderated` int(11) NOT NULL default '0',
529 PRIMARY KEY (`forum_id`),
530 KEY `idx_fproject` (`forum_project`),
531 KEY `idx_fowner` (`forum_owner`),
532 KEY `forum_status` (`forum_status`),
533 KEY `forum_name` (`forum_name`)
534 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
535
536 -- --------------------------------------------------------
537
538 --
539 -- Table structure for table `forum_messages`
540 --
541
542 CREATE TABLE `forum_messages` (
543 `message_id` int(11) NOT NULL auto_increment,
544 `message_forum` int(11) NOT NULL default '0',
545 `message_parent` int(11) NOT NULL default '0',
546 `message_author` int(11) NOT NULL default '0',
547 `message_editor` int(11) NOT NULL default '0',
548 `message_title` varchar(255) NOT NULL default '',
549 `message_date` datetime default '0000-00-00 00:00:00',
550 `message_body` text,
551 `message_published` tinyint(1) NOT NULL default '1',
552 PRIMARY KEY (`message_id`),
553 KEY `idx_mparent` (`message_parent`),
554 KEY `idx_mdate` (`message_date`),
555 KEY `idx_mforum` (`message_forum`),
556 KEY `message_author` (`message_author`)
557 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
558
559 -- --------------------------------------------------------
560
561 --
562 -- Table structure for table `forum_visits`
563 --
564
565 CREATE TABLE `forum_visits` (
566 `visit_user` int(10) NOT NULL default '0',
567 `visit_forum` int(10) NOT NULL default '0',
568 `visit_message` int(10) NOT NULL default '0',
569 `visit_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
570 PRIMARY KEY ( `visit_user` , `visit_forum`, `visit_message` )
571 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
572
573 -- --------------------------------------------------------
574
575 --
576 -- Table structure for table `forum_watch`
577 --
578
579 CREATE TABLE `forum_watch` (
580 `watch_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
581 `watch_user` int(10) unsigned NOT NULL default '0',
582 `watch_forum` int(10) unsigned default NULL,
583 `watch_topic` int(10) unsigned default NULL,
584 PRIMARY KEY (`watch_id`),
585 KEY `idx_fw1` (`watch_user`,`watch_forum`),
586 KEY `idx_fw2` (`watch_user`,`watch_topic`)
587 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Links users to the forums/messages they are watching';
588
589 -- --------------------------------------------------------
590
591 --
592 -- Table structure for table `gacl_acl`
593 --
594
595 CREATE TABLE `gacl_acl` (
596 `id` int(11) NOT NULL default '0',
597 `section_value` varchar(80) NOT NULL default 'system',
598 `allow` int(11) NOT NULL default '0',
599 `enabled` int(11) NOT NULL default '0',
600 `return_value` longtext,
601 `note` longtext,
602 `updated_date` int(11) NOT NULL default '0',
603 PRIMARY KEY (`id`),
604 KEY `gacl_enabled_acl` (`enabled`),
605 KEY `gacl_section_value_acl` (`section_value`),
606 KEY `gacl_updated_date_acl` (`updated_date`)
607 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
608
609 --
610 -- Dumping data for table `gacl_acl`
611 --
612
613 INSERT INTO `gacl_acl` (`id`, `section_value`, `allow`, `enabled`, `return_value`, `note`, `updated_date`) VALUES(10, 'user', 1, 1, '', '', 1195510857);
614 INSERT INTO `gacl_acl` (`id`, `section_value`, `allow`, `enabled`, `return_value`, `note`, `updated_date`) VALUES(11, 'user', 1, 1, '', '', 1195510857);
615
616 -- --------------------------------------------------------
617
618 --
619 -- Table structure for table `gacl_acl_sections`
620 --
621
622 CREATE TABLE `gacl_acl_sections` (
623 `id` int(11) NOT NULL default '0',
624 `value` varchar(80) NOT NULL default '',
625 `order_value` int(11) NOT NULL default '0',
626 `name` varchar(230) NOT NULL default '',
627 `hidden` int(11) NOT NULL default '0',
628 PRIMARY KEY (`id`),
629 UNIQUE KEY `gacl_value_acl_sections` (`value`),
630 KEY `gacl_hidden_acl_sections` (`hidden`)
631 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
632
633 --
634 -- Dumping data for table `gacl_acl_sections`
635 --
636
637 INSERT INTO `gacl_acl_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES(1, 'system', 1, 'System', 0);
638 INSERT INTO `gacl_acl_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES(2, 'user', 2, 'User', 0);
639
640 -- --------------------------------------------------------
641
642 --
643 -- Table structure for table `gacl_acl_seq`
644 --
645
646 CREATE TABLE `gacl_acl_seq` (
647 `id` int(11) NOT NULL default '0',
648 PRIMARY KEY ( `id` )
649 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
650
651 --
652 -- Dumping data for table `gacl_acl_seq`
653 --
654
655 INSERT INTO `gacl_acl_seq` (`id`) VALUES(29);
656
657 -- --------------------------------------------------------
658
659 --
660 -- Table structure for table `gacl_aco`
661 --
662
663 CREATE TABLE `gacl_aco` (
664 `id` int(11) NOT NULL default '0',
665 `section_value` varchar(80) NOT NULL default '0',
666 `value` varchar(80) NOT NULL default '',
667 `order_value` int(11) NOT NULL default '0',
668 `name` varchar(255) NOT NULL default '',
669 `hidden` int(11) NOT NULL default '0',
670 PRIMARY KEY (`id`),
671 UNIQUE KEY `gacl_section_value_value_aco` (`section_value`,`value`),
672 KEY `gacl_hidden_aco` (`hidden`)
673 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
674
675 --
676 -- Dumping data for table `gacl_aco`
677 --
678
679 INSERT INTO `gacl_aco` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(10, 'system', 'login', 1, 'Login', 0);
680 INSERT INTO `gacl_aco` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(11, 'application', 'access', 1, 'Access', 0);
681 INSERT INTO `gacl_aco` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(12, 'application', 'view', 2, 'View', 0);
682 INSERT INTO `gacl_aco` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(13, 'application', 'add', 3, 'Add', 0);
683 INSERT INTO `gacl_aco` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(14, 'application', 'edit', 4, 'Edit', 0);
684 INSERT INTO `gacl_aco` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(15, 'application', 'delete', 5, 'Delete', 0);
685
686 -- --------------------------------------------------------
687
688 --
689 -- Table structure for table `gacl_aco_map`
690 --
691
692 CREATE TABLE `gacl_aco_map` (
693 `acl_id` int(11) NOT NULL default '0',
694 `section_value` varchar(80) NOT NULL default '0',
695 `value` varchar(80) NOT NULL default '',
696 PRIMARY KEY (`acl_id`,`section_value`,`value`)
697 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
698
699 --
700 -- Dumping data for table `gacl_aco_map`
701 --
702
703 INSERT INTO `gacl_aco_map` (`acl_id`, `section_value`, `value`) VALUES(10, 'system', 'login');
704 INSERT INTO `gacl_aco_map` (`acl_id`, `section_value`, `value`) VALUES(11, 'application', 'access');
705 INSERT INTO `gacl_aco_map` (`acl_id`, `section_value`, `value`) VALUES(11, 'application', 'add');
706 INSERT INTO `gacl_aco_map` (`acl_id`, `section_value`, `value`) VALUES(11, 'application', 'delete');
707 INSERT INTO `gacl_aco_map` (`acl_id`, `section_value`, `value`) VALUES(11, 'application', 'edit');
708 INSERT INTO `gacl_aco_map` (`acl_id`, `section_value`, `value`) VALUES(11, 'application', 'view');
709
710 -- --------------------------------------------------------
711
712 --
713 -- Table structure for table `gacl_aco_sections`
714 --
715
716 CREATE TABLE `gacl_aco_sections` (
717 `id` int(11) NOT NULL default '0',
718 `value` varchar(80) NOT NULL default '',
719 `order_value` int(11) NOT NULL default '0',
720 `name` varchar(230) NOT NULL default '',
721 `hidden` int(11) NOT NULL default '0',
722 PRIMARY KEY (`id`),
723 UNIQUE KEY `gacl_value_aco_sections` (`value`),
724 KEY `gacl_hidden_aco_sections` (`hidden`)
725 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
726
727 --
728 -- Dumping data for table `gacl_aco_sections`
729 --
730
731 INSERT INTO `gacl_aco_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES(10, 'system', 1, 'System', 0);
732 INSERT INTO `gacl_aco_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES(11, 'application', 2, 'Application', 0);
733
734 -- --------------------------------------------------------
735
736 --
737 -- Table structure for table `gacl_aco_sections_seq`
738 --
739
740 CREATE TABLE `gacl_aco_sections_seq` (
741 `id` int(11) NOT NULL default '0',
742 PRIMARY KEY ( `id` )
743 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
744
745 --
746 -- Dumping data for table `gacl_aco_sections_seq`
747 --
748
749 INSERT INTO `gacl_aco_sections_seq` (`id`) VALUES(11);
750
751 -- --------------------------------------------------------
752
753 --
754 -- Table structure for table `gacl_aco_seq`
755 --
756
757 CREATE TABLE `gacl_aco_seq` (
758 `id` int(11) NOT NULL default '0',
759 PRIMARY KEY ( `id` )
760 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
761
762 --
763 -- Dumping data for table `gacl_aco_seq`
764 --
765
766 INSERT INTO `gacl_aco_seq` (`id`) VALUES(15);
767
768 -- --------------------------------------------------------
769
770 --
771 -- Table structure for table `gacl_aro`
772 --
773
774 CREATE TABLE `gacl_aro` (
775 `id` int(11) NOT NULL default '0',
776 `section_value` varchar(80) NOT NULL default '0',
777 `value` varchar(80) NOT NULL default '',
778 `order_value` int(11) NOT NULL default '0',
779 `name` varchar(255) NOT NULL default '',
780 `hidden` int(11) NOT NULL default '0',
781 PRIMARY KEY (`id`),
782 UNIQUE KEY `gacl_section_value_value_aro` (`section_value`,`value`),
783 KEY `gacl_hidden_aro` (`hidden`)
784 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
785
786 --
787 -- Dumping data for table `gacl_aro`
788 --
789
790 INSERT INTO `gacl_aro` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(10, 'user', '1', 1, 'admin', 0);
791
792 -- --------------------------------------------------------
793
794 --
795 -- Table structure for table `gacl_aro_groups`
796 --
797
798 CREATE TABLE `gacl_aro_groups` (
799 `id` int(11) NOT NULL default '0',
800 `parent_id` int(11) NOT NULL default '0',
801 `lft` int(11) NOT NULL default '0',
802 `rgt` int(11) NOT NULL default '0',
803 `name` varchar(255) NOT NULL default '',
804 `value` varchar(80) NOT NULL default '',
805 PRIMARY KEY (`id`,`value`),
806 KEY `gacl_parent_id_aro_groups` (`parent_id`),
807 KEY `gacl_value_aro_groups` (`value`),
808 KEY `gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
809 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
810
811 --
812 -- Dumping data for table `gacl_aro_groups`
813 --
814
815 INSERT INTO `gacl_aro_groups` (`id`, `parent_id`, `lft`, `rgt`, `name`, `value`) VALUES(10, 0, 1, 12, 'Roles', 'role');
816 INSERT INTO `gacl_aro_groups` (`id`, `parent_id`, `lft`, `rgt`, `name`, `value`) VALUES(11, 10, 2, 3, 'Administrator', 'admin');
817 INSERT INTO `gacl_aro_groups` (`id`, `parent_id`, `lft`, `rgt`, `name`, `value`) VALUES(12, 10, 4, 5, 'Anonymous', 'anon');
818 INSERT INTO `gacl_aro_groups` (`id`, `parent_id`, `lft`, `rgt`, `name`, `value`) VALUES(13, 10, 6, 7, 'Guest', 'guest');
819 INSERT INTO `gacl_aro_groups` (`id`, `parent_id`, `lft`, `rgt`, `name`, `value`) VALUES(14, 10, 8, 9, 'Project worker', 'normal');
820 INSERT INTO `gacl_aro_groups` (`id`, `parent_id`, `lft`, `rgt`, `name`, `value`) VALUES(16, 10, 10, 11, 'Empty Role', 'empty');
821
822 -- --------------------------------------------------------
823
824 --
825 -- Table structure for table `gacl_aro_groups_id_seq`
826 --
827
828 CREATE TABLE `gacl_aro_groups_id_seq` (
829 `id` int(11) NOT NULL default '0',
830 PRIMARY KEY ( `id` )
831 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
832
833 --
834 -- Dumping data for table `gacl_aro_groups_id_seq`
835 --
836
837 INSERT INTO `gacl_aro_groups_id_seq` (`id`) VALUES(16);
838
839 -- --------------------------------------------------------
840
841 --
842 -- Table structure for table `gacl_aro_groups_map`
843 --
844
845 CREATE TABLE `gacl_aro_groups_map` (
846 `acl_id` int(11) NOT NULL default '0',
847 `group_id` int(11) NOT NULL default '0',
848 PRIMARY KEY (`acl_id`,`group_id`)
849 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
850
851 --
852 -- Dumping data for table `gacl_aro_groups_map`
853 --
854
855 INSERT INTO `gacl_aro_groups_map` (`acl_id`, `group_id`) VALUES(10, 10);
856 INSERT INTO `gacl_aro_groups_map` (`acl_id`, `group_id`) VALUES(11, 11);
857
858 -- --------------------------------------------------------
859
860 --
861 -- Table structure for table `gacl_aro_map`
862 --
863
864 CREATE TABLE `gacl_aro_map` (
865 `acl_id` int(11) NOT NULL default '0',
866 `section_value` varchar(80) NOT NULL default '0',
867 `value` varchar(80) NOT NULL default '',
868 PRIMARY KEY (`acl_id`,`section_value`,`value`)
869 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
870
871 --
872 -- Dumping data for table `gacl_aro_map`
873 --
874
875 INSERT INTO `gacl_aro_map` (`acl_id`, `section_value`, `value`) VALUES(23, 'user', '2');
876
877 -- --------------------------------------------------------
878
879 --
880 -- Table structure for table `gacl_aro_sections`
881 --
882
883 CREATE TABLE `gacl_aro_sections` (
884 `id` int(11) NOT NULL default '0',
885 `value` varchar(80) NOT NULL default '',
886 `order_value` int(11) NOT NULL default '0',
887 `name` varchar(230) NOT NULL default '',
888 `hidden` int(11) NOT NULL default '0',
889 PRIMARY KEY (`id`),
890 UNIQUE KEY `gacl_value_aro_sections` (`value`),
891 KEY `gacl_hidden_aro_sections` (`hidden`)
892 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
893
894 --
895 -- Dumping data for table `gacl_aro_sections`
896 --
897
898 INSERT INTO `gacl_aro_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES(10, 'user', 1, 'Users', 0);
899
900 -- --------------------------------------------------------
901
902 --
903 -- Table structure for table `gacl_aro_sections_seq`
904 --
905
906 CREATE TABLE `gacl_aro_sections_seq` (
907 `id` int(11) NOT NULL default '0',
908 PRIMARY KEY ( `id` )
909 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
910
911 --
912 -- Dumping data for table `gacl_aro_sections_seq`
913 --
914
915 INSERT INTO `gacl_aro_sections_seq` (`id`) VALUES(10);
916
917 -- --------------------------------------------------------
918
919 --
920 -- Table structure for table `gacl_aro_seq`
921 --
922
923 CREATE TABLE `gacl_aro_seq` (
924 `id` int(11) NOT NULL default '0',
925 PRIMARY KEY ( `id` )
926 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
927
928 --
929 -- Dumping data for table `gacl_aro_seq`
930 --
931
932 INSERT INTO `gacl_aro_seq` (`id`) VALUES(10);
933
934 -- --------------------------------------------------------
935
936 --
937 -- Table structure for table `gacl_axo`
938 --
939
940 CREATE TABLE `gacl_axo` (
941 `id` int(11) NOT NULL default '0',
942 `section_value` varchar(80) NOT NULL default '0',
943 `value` varchar(80) NOT NULL default '',
944 `order_value` int(11) NOT NULL default '0',
945 `name` varchar(255) NOT NULL default '',
946 `hidden` int(11) NOT NULL default '0',
947 PRIMARY KEY (`id`),
948 UNIQUE KEY `gacl_section_value_value_axo` (`section_value`,`value`),
949 KEY `gacl_hidden_axo` (`hidden`)
950 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
951
952 --
953 -- Dumping data for table `gacl_axo`
954 --
955
956 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(10, 'sys', 'acl', 1, 'ACL Administration', 0);
957 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(11, 'app', 'admin', 1, 'User Administration', 0);
958 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(12, 'app', 'calendar', 2, 'Calendar', 0);
959 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(13, 'app', 'events', 2, 'Events', 0);
960 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(14, 'app', 'companies', 3, 'Companies', 0);
961 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(15, 'app', 'contacts', 4, 'Contacts', 0);
962 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(16, 'app', 'departments', 5, 'Departments', 0);
963 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(17, 'app', 'files', 6, 'Files', 0);
964 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(18, 'app', 'forums', 7, 'Forums', 0);
965 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(19, 'app', 'help', 8, 'Help', 0);
966 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(20, 'app', 'projects', 9, 'Projects', 0);
967 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(21, 'app', 'system', 10, 'System Administration', 0);
968 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(22, 'app', 'tasks', 11, 'Tasks', 0);
969 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(23, 'app', 'task_log', 11, 'Task Logs', 0);
970 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(25, 'app', 'public', 13, 'Public', 0);
971 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(26, 'app', 'roles', 14, 'Roles Administration', 0);
972 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(27, 'app', 'users', 15, 'User Table', 0);
973 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(28, 'app', 'smartsearch', 1, 'SmartSearch', 0);
974 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(55, 'app', 'links', 1, 'Links', 0);
975 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(51, 'app', 'projectdesigner', 1, 'ProjectDesigner', 0);
976 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(31, 'departments', '1', 0, '1', 0);
977 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(36, 'app', 'history', 1, 'History', 0);
978 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(39, 'app', 'reports', 1, 'Reports', 0);
979 INSERT INTO `gacl_axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES(54, 'app', 'resources', 1, 'Resources', 0);
980
981 -- --------------------------------------------------------
982
983 --
984 -- Table structure for table `gacl_axo_groups`
985 --
986
987 CREATE TABLE `gacl_axo_groups` (
988 `id` int(11) NOT NULL default '0',
989 `parent_id` int(11) NOT NULL default '0',
990 `lft` int(11) NOT NULL default '0',
991 `rgt` int(11) NOT NULL default '0',
992 `name` varchar(255) NOT NULL default '',
993 `value` varchar(80) NOT NULL default '',
994 PRIMARY KEY (`id`,`value`),
995 KEY `gacl_parent_id_axo_groups` (`parent_id`),
996 KEY `gacl_value_axo_groups` (`value`),
997 KEY `gacl_lft_rgt_axo_groups` (`lft`,`rgt`)
998 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
999
1000 --
1001 -- Dumping data for table `gacl_axo_groups`
1002 --
1003
1004 INSERT INTO `gacl_axo_groups` (`id`, `parent_id`, `lft`, `rgt`, `name`, `value`) VALUES(10, 0, 1, 8, 'Modules', 'mod');
1005 INSERT INTO `gacl_axo_groups` (`id`, `parent_id`, `lft`, `rgt`, `name`, `value`) VALUES(11, 10, 2, 3, 'All Modules', 'all');
1006 INSERT INTO `gacl_axo_groups` (`id`, `parent_id`, `lft`, `rgt`, `name`, `value`) VALUES(12, 10, 4, 5, 'Admin Modules', 'admin');
1007 INSERT INTO `gacl_axo_groups` (`id`, `parent_id`, `lft`, `rgt`, `name`, `value`) VALUES(13, 10, 6, 7, 'Non-Admin Modules', 'non_admin');
1008
1009 -- --------------------------------------------------------
1010
1011 --
1012 -- Table structure for table `gacl_axo_groups_id_seq`
1013 --
1014
1015 CREATE TABLE `gacl_axo_groups_id_seq` (
1016 `id` int(11) NOT NULL default '0',
1017 PRIMARY KEY ( `id` )
1018 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1019
1020 --
1021 -- Dumping data for table `gacl_axo_groups_id_seq`
1022 --
1023
1024 INSERT INTO `gacl_axo_groups_id_seq` (`id`) VALUES(13);
1025
1026 -- --------------------------------------------------------
1027
1028 --
1029 -- Table structure for table `gacl_axo_groups_map`
1030 --
1031
1032 CREATE TABLE `gacl_axo_groups_map` (
1033 `acl_id` int(11) NOT NULL default '0',
1034 `group_id` int(11) NOT NULL default '0',
1035 PRIMARY KEY (`acl_id`,`group_id`)
1036 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1037
1038 --
1039 -- Dumping data for table `gacl_axo_groups_map`
1040 --
1041
1042 INSERT INTO `gacl_axo_groups_map` (`acl_id`, `group_id`) VALUES(11, 11);
1043 INSERT INTO `gacl_axo_groups_map` (`acl_id`, `group_id`) VALUES(13, 13);
1044 INSERT INTO `gacl_axo_groups_map` (`acl_id`, `group_id`) VALUES(14, 13);
1045 INSERT INTO `gacl_axo_groups_map` (`acl_id`, `group_id`) VALUES(15, 13);
1046
1047 -- --------------------------------------------------------
1048
1049 --
1050 -- Table structure for table `gacl_axo_map`
1051 --
1052
1053 CREATE TABLE `gacl_axo_map` (
1054 `acl_id` int(11) NOT NULL default '0',
1055 `section_value` varchar(80) NOT NULL default '0',
1056 `value` varchar(80) NOT NULL default '',
1057 PRIMARY KEY (`acl_id`,`section_value`,`value`)
1058 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1059
1060 --
1061 -- Dumping data for table `gacl_axo_map`
1062 --
1063
1064 INSERT INTO `gacl_axo_map` (`acl_id`, `section_value`, `value`) VALUES(12, 'sys', 'acl');
1065
1066 -- --------------------------------------------------------
1067
1068 --
1069 -- Table structure for table `gacl_axo_sections`
1070 --
1071
1072 CREATE TABLE `gacl_axo_sections` (
1073 `id` int(11) NOT NULL default '0',
1074 `value` varchar(80) NOT NULL default '',
1075 `order_value` int(11) NOT NULL default '0',
1076 `name` varchar(230) NOT NULL default '',
1077 `hidden` int(11) NOT NULL default '0',
1078 PRIMARY KEY (`id`),
1079 UNIQUE KEY `gacl_value_axo_sections` (`value`),
1080 KEY `gacl_hidden_axo_sections` (`hidden`)
1081 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1082
1083 --
1084 -- Dumping data for table `gacl_axo_sections`
1085 --
1086
1087 INSERT INTO `gacl_axo_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES(10, 'sys', 1, 'System', 0);
1088 INSERT INTO `gacl_axo_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES(11, 'app', 2, 'Application', 0);
1089
1090 -- --------------------------------------------------------
1091
1092 --
1093 -- Table structure for table `gacl_axo_sections_seq`
1094 --
1095
1096 CREATE TABLE `gacl_axo_sections_seq` (
1097 `id` int(11) NOT NULL default '0',
1098 PRIMARY KEY ( `id` )
1099 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1100
1101 --
1102 -- Dumping data for table `gacl_axo_sections_seq`
1103 --
1104
1105 INSERT INTO `gacl_axo_sections_seq` (`id`) VALUES(11);
1106
1107 -- --------------------------------------------------------
1108
1109 --
1110 -- Table structure for table `gacl_axo_seq`
1111 --
1112
1113 CREATE TABLE `gacl_axo_seq` (
1114 `id` int(11) NOT NULL default '0',
1115 PRIMARY KEY ( `id` )
1116 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1117
1118 --
1119 -- Dumping data for table `gacl_axo_seq`
1120 --
1121
1122 INSERT INTO `gacl_axo_seq` (`id`) VALUES(55);
1123
1124 -- --------------------------------------------------------
1125
1126 --
1127 -- Table structure for table `gacl_groups_aro_map`
1128 --
1129
1130 CREATE TABLE `gacl_groups_aro_map` (
1131 `group_id` int(11) NOT NULL default '0',
1132 `aro_id` int(11) NOT NULL default '0',
1133 PRIMARY KEY (`group_id`,`aro_id`)
1134 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1135
1136 --
1137 -- Dumping data for table `gacl_groups_aro_map`
1138 --
1139
1140 INSERT INTO `gacl_groups_aro_map` (`group_id`, `aro_id`) VALUES(11, 10);
1141
1142 -- --------------------------------------------------------
1143
1144 --
1145 -- Table structure for table `gacl_groups_axo_map`
1146 --
1147
1148 CREATE TABLE `gacl_groups_axo_map` (
1149 `group_id` int(11) NOT NULL default '0',
1150 `axo_id` int(11) NOT NULL default '0',
1151 PRIMARY KEY (`group_id`,`axo_id`)
1152 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1153
1154 --
1155 -- Dumping data for table `gacl_groups_axo_map`
1156 --
1157
1158 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 11);
1159 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 12);
1160 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 13);
1161 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 14);
1162 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 15);
1163 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 16);
1164 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 17);
1165 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 18);
1166 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 19);
1167 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 20);
1168 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 21);
1169 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 22);
1170 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 23);
1171 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 24);
1172 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 25);
1173 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 26);
1174 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 27);
1175 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 28);
1176 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 36);
1177 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 39);
1178 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 51);
1179 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 54);
1180 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(11, 55);
1181 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(12, 11);
1182 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(12, 21);
1183 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(12, 26);
1184 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(12, 27);
1185 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 12);
1186 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 13);
1187 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 14);
1188 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 15);
1189 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 16);
1190 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 17);
1191 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 18);
1192 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 19);
1193 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 20);
1194 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 22);
1195 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 23);
1196 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 24);
1197 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 25);
1198 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 28);
1199 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 36);
1200 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 39);
1201 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 51);
1202 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 54);
1203 INSERT INTO `gacl_groups_axo_map` (`group_id`, `axo_id`) VALUES(13, 55);
1204
1205 -- --------------------------------------------------------
1206
1207 --
1208 -- Table structure for table `gacl_permissions`
1209 --
1210
1211 CREATE TABLE `gacl_permissions` (
1212 `user_id` int(11) NOT NULL default '0',
1213 `user_name` varchar(255) NOT NULL default '',
1214 `module` varchar(64) NOT NULL default '',
1215 `item_id` int(11) NOT NULL default '0',
1216 `action` varchar(32) NOT NULL default '',
