Context Navigation

updatev0.98.sql

Revision 740, 41.5 KB (checked in by nate, 2 years ago)
Update now makes sure that all users that have portal access are also have admin access.

Line
1	--tablecustomfields CREATE--
2	CREATE TABLE tablecustomfields (
3	`id` int(11) NOT NULL auto_increment,
4	`tabledefid` varchar(64) NOT NULL,
5	`name` varchar(128) NOT NULL default '',
6	`field` varchar(8) NOT NULL default '',
7	`format` varchar(32),
8	`generator` TEXT,
9	`required` TINYINT(4) NOT NULL default 0,
10	`displayorder` int(11) NOT NULL default 0,
11	`roleid` varchar(64) NOT NULL default '',
12	PRIMARY KEY (`id`),
13	KEY `tabledef` (`tabledefid`)
14	) ENGINE=INNODB;
15	--end tablecustomfields CREATE--
16	--userpreferences CREATE--
17	CREATE TABLE `userpreferences` (
18	`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
19	`userid` varchar(64) NOT NULL,
20	`name` varchar(64) NOT NULL,
21	`value` TEXT,
22	PRIMARY KEY (`id`),
23	KEY `thename` (`name`)
24	) ENGINE=INNODB;
25	--end userpreferences CREATE--
26	--widgets CREATE--
27	CREATE TABLE `widgets` (
28	`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
29	`uuid` varchar(64) NOT NULL,
30	`type` varchar(64) NOT NULL,
31	`title` varchar(128) NOT NULL,
32	`file` varchar(255) NOT NULL,
33	`roleid` VARCHAR(64),
34	`moduleid` VARCHAR(64),
35	`default` tinyint(4) NOT NULL default '0',
36	`createdby` int(11) default NULL,
37	`creationdate` datetime default NULL,
38	`modifiedby` int(10) unsigned default NULL,
39	`modifieddate` timestamp,
40	PRIMARY KEY (`id`),
41	KEY `uniqueid` (`uuid`)
42	) ENGINE=INNODB;
43	--end widgets CREATE--
44	--reportsettings CREATE--
45	CREATE TABLE `reportsettings` (
46	`id` int(11) NOT NULL auto_increment,
47	`reportuuid` varchar(64) NOT NULL,
48	`name` varchar(64) NOT NULL default '',
49	`value` text default '',
50	`type` varchar(32) NOT NULL default 'string',
51	`required` tinyint(4) NOT NULL default '0',
52	`defaultvalue` varchar(255) NOT NULL,
53	`description` text,
54	PRIMARY KEY (`id`)
55	) ENGINE=INNODB;
56	--end reportsettings CREATE--
57
58	--attachments ALTER--
59	ALTER TABLE `attachments` ENGINE=INNODB;
60	ALTER TABLE `attachments`
61	MODIFY `fileid` VARCHAR(64) NOT NULL,
62	MODIFY `tabledefid` VARCHAR(64) NOT NULL,
63	MODIFY `recordid` VARCHAR(64);
64	--end attachemnts ALTER--
65	--choices ALTER--
66	ALTER TABLE `choices` ENGINE=INNODB;
67	--end choices ALTER--
68	--files ALTER--
69	ALTER TABLE `files` ENGINE=INNODB;
70	ALTER TABLE `files`
71	ADD COLUMN `uuid` varchar(64) NOT NULL AFTER `id`,
72	ADD COLUMN `custom1` DOUBLE,
73	ADD COLUMN `custom2` DOUBLE,
74	ADD COLUMN `custom3` DATETIME,
75	ADD COLUMN `custom4` DATETIME,
76	ADD COLUMN `custom5` VARCHAR(255),
77	ADD COLUMN `custom6` VARCHAR(255),
78	ADD COLUMN `custom7` TINYINT(1) DEFAULT 0,
79	ADD COLUMN `custom8` TINYINT(1) DEFAULT 0,
80	MODIFY `roleid` varchar(64);
81	--end files ALTER--
82	--log ALTER--
83	ALTER TABLE `log` ENGINE=INNODB;
84	ALTER TABLE `log`
85	MODIFY `userid` VARCHAR(64);
86	--end log ALTER--
87	--menu ALTER--
88	ALTER TABLE `menu` ENGINE=INNODB;
89	ALTER TABLE `menu`
90	ADD COlUMN `uuid` varchar(64) NOT NULL AFTER `id`,
91	MODIFY COLUMN `parentid` varchar(64) DEFAULT '',
92	MODIFY `roleid` varchar(64);
93	--end menu ALTER--
94	--modules ALTER--
95	ALTER TABLE `modules` ENGINE=INNODB;
96	ALTER TABLE `modules`
97	ADD COLUMN `uuid` varchar(64) NOT NULL AFTER `id`;
98	--end modules ALTER--
99	UPDATE `modules` SET `uuid`='mod:29873ee8-c12a-e3f6-9010-4cd24174ffd7' WHERE `id`='1';
100	--notes ALTER--
101	ALTER TABLE `notes` ENGINE=INNODB;
102	ALTER TABLE `notes`
103	MODIFY `type` CHAR(2) NOT NULL DEFAULT 'NT',
104	MODIFY `assignedtoid` varchar(64),
105	MODIFY `attachedid` varchar(64),
106	MODIFY `attachedtabledefid` varchar(64),
107	MODIFY `parentid` varchar(64),
108	MODIFY `assignedbyid` varchar(64),
109	ADD COLUMN `uuid` varchar(64) NOT NULL AFTER `id`,
110	ADD COLUMN `custom1` DOUBLE,
111	ADD COLUMN `custom2` DOUBLE,
112	ADD COLUMN `custom3` DATETIME,
113	ADD COLUMN `custom4` DATETIME,
114	ADD COLUMN `custom5` VARCHAR(255),
115	ADD COLUMN `custom6` VARCHAR(255),
116	ADD COLUMN `custom7` TINYINT(1) DEFAULT 0,
117	ADD COLUMN `custom8` TINYINT(1) DEFAULT 0;
118	--end notes ALTER--
119	--relationships ALTER--
120	ALTER TABLE `relationships` ENGINE=INNODB;
121	ALTER TABLE `relationships`
122	ADD COLUMN `uuid` varchar(64) NOT NULL AFTER `id`,
123	MODIFY `fromtableid` VARCHAR(64) NOT NULL,
124	MODIFY `totableid` VARCHAR(64) NOT NULL;
125	--end relationships ALTER--
126	--reports ALTER--
127	ALTER TABLE `reports` ENGINE=INNODB;
128	ALTER TABLE `reports`
129	MODIFY `tabledefid` varchar(64) NOT NULL,
130	MODIFY `roleid` VARCHAR(64),
131	MODIFY `reportfile` VARCHAR(128) NOT NULL,
132	ADD COLUMN `uuid` varchar(64) NOT NULL AFTER `id`;
133	--end reports ALTER--
134	--roles ALTER--
135	ALTER TABLE `roles` ENGINE=INNODB;
136	ALTER TABLE `roles`
137	MODIFY COLUMN `inactive` TINYINT(4) NOT NULL DEFAULT 0,
138	ADD COLUMN `uuid` varchar(64) NOT NULL AFTER `id`,
139	ADD COLUMN `custom1` DOUBLE,
140	ADD COLUMN `custom2` DOUBLE,
141	ADD COLUMN `custom3` DATETIME,
142	ADD COLUMN `custom4` DATETIME,
143	ADD COLUMN `custom5` VARCHAR(255),
144	ADD COLUMN `custom6` VARCHAR(255),
145	ADD COLUMN `custom7` TINYINT(1) DEFAULT 0,
146	ADD COLUMN `custom8` TINYINT(1) DEFAULT 0;
147	--end roles ALTER--
148	--rolestousers ALTER--
149	ALTER TABLE `rolestousers` ENGINE=INNODB;
150	ALTER TABLE `rolestousers`
151	MODIFY `userid` varchar(64),
152	MODIFY `roleid` varchar(64);
153	--end rolestousers ALTER--
154	--scheduler ALTER--
155	ALTER TABLE `scheduler` ENGINE=INNODB;
156	ALTER TABLE `scheduler`
157	ADD COLUMN `uuid` varchar(64) NOT NULL AFTER `id`,
158	ADD COLUMN `pushrecordid` varchar(64) default '' AFTER `job`;
159	--end scheduler ALTER--
160	--settings ALTER--
161	ALTER TABLE `settings` ENGINE=INNODB;
162	--end settings ALTER--
163	--smartsearches ALTER--
164	ALTER TABLE `smartsearches` ENGINE=INNODB;
165	ALTER TABLE `smartsearches`
166	ADD COLUMN `uuid` varchar(64) NOT NULL AFTER `id`,
167	MODIFY `moduleid` VARCHAR(64),
168	MODIFY `tabledefid` VARCHAR(64);
169	--end smartsearches ALTER--
170	--tablecolumns ALTER--
171	ALTER TABLE `tablecolumns` ENGINE=INNODB;
172	ALTER TABLE `tablecolumns`
173	MODIFY `tabledefid` VARCHAR(64) NOT NULL,
174	MODIFY `roleid` VARCHAR(64) NOT NULL DEFAULT '';
175	--end tablecolumns ALTER--
176	--tabledefs ALTER--
177	ALTER TABLE `tabledefs` ENGINE=INNODB;
178	ALTER TABLE `tabledefs`
179	MODIFY COLUMN `defaultwhereclause` TEXT DEFAULT NULL,
180	MODIFY COLUMN `defaultsortorder` TEXT,
181	MODIFY `moduleid` VARCHAR(64) NOT NULL,
182	MODIFY `editroleid` varchar(64),
183	MODIFY `addroleid` varchar(64),
184	MODIFY `searchroleid` varchar(64),
185	MODIFY `advsearchroleid` varchar(64) default 'Admin',
186	MODIFY `viewsqlroleid` varchar(64) default 'Admin',
187	ADD COLUMN `importfile` VARCHAR(128) DEFAULT NULL AFTER `addroleid`,
188	ADD COLUMN `importroleid` VARCHAR(64) NOT NULL DEFAULT 'Admin' AFTER `importfile`,
189	ADD COLUMN `canpost` tinyint(4) NOT NULL default '0' AFTER `deletebutton`,
190	ADD COLUMN `apiaccessible` tinyint(4) NOT NULL default '0' AFTER `deletebutton`,
191	ADD COLUMN `hascustomfields` tinyint(4) NOT NULL default '0' AFTER `canpost`,
192	ADD COLUMN `uuid` varchar(64) NOT NULL AFTER `id`,
193	ADD COLUMN `prefix` VARCHAR(4) AFTER `displayname`;
194	--end tabledefs ALTER--
195	--tablefindoptions ALTER--
196	ALTER TABLE `tablefindoptions` ENGINE=INNODB;
197	ALTER TABLE `tablefindoptions`
198	MODIFY COLUMN `search` TEXT NOT NULL,
199	MODIFY `tabledefid` VARCHAR(64) NOT NULL,
200	MODIFY `roleid` VARCHAR(64) NOT NULL DEFAULT '';
201	--end tablefindoptions ALTER--
202	--tablegroupings ALTER--
203	ALTER TABLE `tablegroupings` ENGINE=INNODB;
204	ALTER TABLE `tablegroupings`
205	MODIFY `tabledefid` VARCHAR(64) NOT NULL,
206	MODIFY `roleid` VARCHAR(64) NOT NULL DEFAULT '';
207	--end tablegroupings ALTER--
208	--tableoptions ALTER--
209	ALTER TABLE `tableoptions` ENGINE=INNODB;
210	ALTER TABLE `tableoptions`
211	ADD COLUMN `needselect` BOOLEAN NOT NULL DEFAULT 1 AFTER `option`,
212	MODIFY `tabledefid` VARCHAR(64) NOT NULL,
213	MODIFY `roleid` VARCHAR(64) NOT NULL DEFAULT '';
214	--tableoptions ALTER--
215	--tablesearchablefields ALTER--
216	ALTER TABLE `tablesearchablefields` ENGINE=INNODB;
217	ALTER TABLE `tablesearchablefields`
218	MODIFY COLUMN `field` TEXT NOT NULL,
219	MODIFY `tabledefid` VARCHAR(64) NOT NULL;
220	--end tablesearchablefields ALTER--
221	--tabs ALTER--
222	ALTER TABLE `tabs` ENGINE=INNODB;
223	ALTER TABLE `tabs`
224	ADD COLUMN `uuid` varchar(64) NOT NULL AFTER `id`,
225	MODIFY `roleid` VARCHAR(64);
226	--end tabs ALTER--
227	--users ALTER--
228	ALTER TABLE `users` ENGINE=INNODB;
229	ALTER TABLE `users`
230	ADD COLUMN `lastip` VARCHAR(45) NOT NULL DEFAULT '' AFTER `lastname`,
231	ADD COLUMN `uuid` varchar(64) NOT NULL AFTER `id`,
232	ADD COLUMN `custom1` DOUBLE,
233	ADD COLUMN `custom2` DOUBLE,
234	ADD COLUMN `custom3` DATETIME,
235	ADD COLUMN `custom4` DATETIME,
236	ADD COLUMN `custom5` VARCHAR(255),
237	ADD COLUMN `custom6` VARCHAR(255),
238	ADD COLUMN `custom7` TINYINT(1) DEFAULT 0,
239	ADD COLUMN `custom8` TINYINT(1) DEFAULT 0;
240	--end users ALTER--
241	--usersearches ALTER--
242	ALTER TABLE `usersearches` ENGINE=INNODB;
243	ALTER TABLE `usersearches`
244	ADD COLUMN `uuid` varchar(64) NOT NULL AFTER `id`,
245	MODIFY `tabledefid` VARCHAR(64) NOT NULL,
246	MODIFY `roleid` VARCHAR(64),
247	MODIFY `userid` VARCHAR(64) NOT NULL;
248	--end usersearches ALTER--
249
250	--files UPDATE--
251	UPDATE `files` SET
252	`uuid`='file:ad761197-e5a2-3fdf-f330-d1508f10813e',
253	`roleid` = 'Admin'
254	WHERE
255	`id`='1';
256	--end files UPDATE--
257	--menu INSERT--
258	DELETE FROM `menu`;
259	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', 'Tools', '', '', '3', 1, 1, NOW(), NOW(), '');
260	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:d9e0eaa6-26b3-fcfb-f1b5-ee0eef8a857a', 'Notes', 'search.php?id=tbld%3Aa4cdd991-cf0a-916f-1240-49428ea1bdd1', 'menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', '30', 1, 1, NOW(), NOW(), '');
261	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:03e984b6-d7ac-def2-a4f5-662003e94bfd', 'Tasks', 'search.php?id=tbld%3A2bc3e683-81f9-694a-9550-a0c7263057de', 'menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', '40', 1, 1, NOW(), NOW(), '');
262	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:c4871074-90e9-c9bb-bcf9-b69ca0c30e8b', 'Events', 'search.php?id=tbld%3A0fcca651-6c34-c74d-ac04-2d88f602dd71', 'menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', '50', 1, 1, NOW(), NOW(), '');
263	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:2bcd88e6-703f-128c-7f18-1aad44fb46fb', 'Snapshot', 'modules/base/snapshot.php', 'menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', '10', 1, 1, NOW(), NOW(), '');
264	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:bbc91ea7-d7e4-33b7-503e-5eb1b928f28b', 'System', '', '', '10', 1, 1, NOW(), NOW(), '-100');
265	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:e44cf976-658a-50d7-4a8f-b575713e3964', 'Configuration', 'modules/base/adminsettings.php', 'menu:bbc91ea7-d7e4-33b7-503e-5eb1b928f28b', '10', 1, 1, NOW(), NOW(), '');
266	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:cf16add3-b02a-bd9b-b3c7-3fe9d0d2e0ba', 'Users', 'search.php?id=tbld%3Aafe6d297-b484-4f0b-57d4-1c39412e9dfb', 'menu:f07d910f-f56d-3d24-e74f-7a3b36b2d3c8', '40', 1, 1, NOW(), NOW(), '-100');
267	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:d727dda4-6ac5-dd23-992b-7cf64cd96620', 'Roles', 'search.php?id=tbld%3A87b9fe06-afe5-d9c6-0fa0-4a0f2ec4ee8a', 'menu:f07d910f-f56d-3d24-e74f-7a3b36b2d3c8', '50', 1, 1, NOW(), NOW(), '-100');
268	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:afddfee1-5ab7-2064-204f-816e9df929ac', '----', 'N/A', 'menu:bbc91ea7-d7e4-33b7-503e-5eb1b928f28b', '15', 1, 1, NOW(), NOW(), '');
269	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:9c845b2d-7383-4182-1bf5-fe9b770f1d63', 'Menu', 'search.php?id=tbld%3A83187e3d-101e-a8a5-037f-31e9800fed2d', 'menu:bbc91ea7-d7e4-33b7-503e-5eb1b928f28b', '50', 1, 1, NOW(), NOW(), '');
270	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:ef5853a0-3b57-06e5-a8d4-31bfbdb207b5', 'Files', 'search.php?id=tbld%3A80b4f38d-b957-bced-c0a0-ed08a0db6475', 'menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', '910', 1, 1, NOW(), NOW(), '-100');
271	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:1f72cd68-1e5a-e718-3b38-8671da9b0a1d', 'Saved Searchs/Sorts', 'search.php?id=tbld%3Ae251524a-2da4-a0c9-8725-d3d0412d8f4a', 'menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', '930', 1, 1, NOW(), NOW(), '-100');
272	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:00ddbccd-2761-3347-22ee-1adce9696b66', '----', 'N/A', 'menu:bbc91ea7-d7e4-33b7-503e-5eb1b928f28b', '45', 1, 1, NOW(), NOW(), '');
273	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:8825339e-76a8-b51a-fdce-7b409451962c', 'Reports', 'search.php?id=tbld%3Ad595ef42-db9d-2233-1b9b-11dfd0db9cbb', 'menu:bbc91ea7-d7e4-33b7-503e-5eb1b928f28b', '70', 1, 1, NOW(), NOW(), '');
274	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:2dea83ff-2927-0859-ab97-530ee76e7bb8', 'Relationships', 'search.php?id=tbld%3A8d19c73c-42fb-d829-3681-d20b4dbe43b9', 'menu:bbc91ea7-d7e4-33b7-503e-5eb1b928f28b', '60', 1, 1, NOW(), NOW(), '');
275	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:76f8b6cd-f42d-0823-3e12-5cbe39f7fbdb', 'Table Definitions', 'search.php?id=tbld%3A5c9d645f-26ab-5003-b98e-89e9049f8ac3', 'menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', '940', 1, 1, NOW(), NOW(), '-100');
276	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:f1780935-8018-d240-8e74-f8fde4f8e1bb', 'Modules', 'search.php?id=tbld%3Aea159d67-5e89-5b7f-f5a0-c740e147cd73', 'menu:bbc91ea7-d7e4-33b7-503e-5eb1b928f28b', '60', 1, 1, NOW(), NOW(), '');
277	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:e0a2cc66-9b44-f0cb-84a7-45eb3307298f', 'My Account', 'modules/base/myaccount.php', 'menu:f07d910f-f56d-3d24-e74f-7a3b36b2d3c8', '20', 1, 1, NOW(), NOW(), '');
278	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:b63e3218-0a12-3e51-88b7-8af400a74a7e', 'Scheduler', 'search.php?id=tbld%3A83de284b-ef79-3567-145c-30ca38b40796', 'menu:bbc91ea7-d7e4-33b7-503e-5eb1b928f28b', '32', 1, 1, NOW(), NOW(), '');
279	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:5f875b57-f499-2307-6d57-61ba49b72e82', 'System Log', 'search.php?id=tbld%3A3f71ab66-1f84-d68b-e2a3-3ee3bb0ec667', 'menu:bbc91ea7-d7e4-33b7-503e-5eb1b928f28b', '20', 1, 1, NOW(), NOW(), '');
280	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:bd2181f5-b938-011b-7e44-81728310bdf5', 'Smart Searches', 'search.php?id=tbld%3A29925e0a-c825-0067-8882-db4b57866a96', 'menu:bbc91ea7-d7e4-33b7-503e-5eb1b928f28b', '80', 1, 1, NOW(), NOW(), '');
281	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:f8392545-41f4-d39a-da7e-9116c9a35502', 'Tabs', 'search.php?id=tbld%3A7e75af48-6f70-d157-f440-69a8e7f59d38', 'menu:bbc91ea7-d7e4-33b7-503e-5eb1b928f28b', '100', 1, 1, NOW(), NOW(), '');
282	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:3620bdc0-edaa-ad59-8ac5-193f855a9584', 'Log Out', 'logout.php', 'menu:f07d910f-f56d-3d24-e74f-7a3b36b2d3c8', '10', 1, 1, NOW(), NOW(), '');
283	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:2da14499-f301-9b18-e384-e0e73f06509e', 'Help', '', '', '200', 1, 1, NOW(), NOW(), '');
284	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:113b56da-3722-6518-4c6a-7804d7ed0d19', 'About phpBMS', 'javascript:menu.showHelp()', 'menu:2da14499-f301-9b18-e384-e0e73f06509e', '0', 1, 1, NOW(), NOW(), '');
285	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:08a6bb60-4557-b7d2-f2ba-09d828a1d9b2', 'Snapshot Widgets', 'search.php?id=tbld%3A2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'menu:bbc91ea7-d7e4-33b7-503e-5eb1b928f28b', '90', 1, 1, NOW(), NOW(), '');
286	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:30bc9743-3530-7705-283a-d740b19238cf', '----', 'N/A', 'menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', '20', 1, 1, NOW(), NOW(), '');
287	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:13e03413-2f08-9b48-98a2-9bb83e4d15a1', '----', 'N/A', 'menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', '900', 1, 1, NOW(), NOW(), '-100');
288	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:83d23ec3-ad10-09e1-8c80-72de0c4747f9', '----', 'N/A', 'menu:1e23c59e-c429-fec5-cc94-99b53c4fc6b0', '920', 1, 1, NOW(), NOW(), '-100');
289	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:f07d910f-f56d-3d24-e74f-7a3b36b2d3c8', 'Account', '', '', '5', 1, 1, NOW(), NOW(), '');
290	INSERT INTO `menu` (`uuid`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES ('menu:e8401ebb-c369-304f-053d-8195988e7faf', '----', 'N/A', 'menu:f07d910f-f56d-3d24-e74f-7a3b36b2d3c8', '30', 1, 1, NOW(), NOW(), '-100');
291	--end menu INSERT--
292	--reports DELETE/INSERT--
293	DELETE FROM `reports` WHERE `name` IN ('Raw Table Print', 'Raw Table Export', 'Note Summary', 'SQL Export', 'Support Tables SQL Export');
294	INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:37cee478-b57e-2d53-d951-baf3937ba9e0', 'Raw Table Print', 'report', '', '0', 'role:259ead9f-100b-55b5-508a-27e33a6216bf', 'report/general_tableprint.php', 'This report will prints out of every field for the table for the given records. The report is displayed HTML format.', 1, NOW(), 1, NOW());
295	INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:dac75fb9-91d2-cb1e-9213-9fab6d32f4c8', 'Raw Table Export', 'export', '', '0', 'role:259ead9f-100b-55b5-508a-27e33a6216bf', 'report/general_export.php', 'This report will generate a comma-delimited text file. Values are encapsulated in quotes, and the first line lists the field names.', 1, NOW(), 1, NOW());
296	INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:2944b204-5967-348a-8679-6835f45f0d79', 'SQL Export', 'export', '', '0', 'Admin', 'report/general_sql.php', 'Generate SQL INSERT statements for records.', 1, NOW(), 1, NOW());
297	INSERT INTO `reports` (`uuid`, `name`, `type`, `tabledefid`, `displayorder`, `roleid`, `reportfile`, `description`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('rpt:37a299d1-d795-ad83-4b47-0778c16a381c', 'Support Tables SQL Export', 'export', 'tbld:5c9d645f-26ab-5003-b98e-89e9049f8ac3', '0', '', 'modules/base/report/tabledefs_sqlexport.php', 'Insert statements for all support table records for table definition records.', 1, NOW(), 1, NOW());
298	--end reports UPDATE--
299	--scheduler INSERT--
300	INSERT INTO `scheduler` (`uuid`, `name`, `job`, `crontab`, `lastrun`, `startdatetime`, `enddatetime`, `description`, `inactive`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('schd:fb52e7fb-bb49-7f5f-89e1-002b2785f085', 'Clean Import Files', './scheduler_delete_tempimport.php', '30::::::::', '2009-05-28 12:30:02', '2009-05-07 17:27:13', NULL, 'This will delete any temporary import files that are present (for whatever reason) after 30 minutes of their creation.', '0', 1, NOW(), 1, NOW());
301	INSERT INTO `scheduler` (`uuid`, `name`, `job`, `crontab`, `lastrun`, `startdatetime`, `enddatetime`, `description`, `inactive`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('schd:d1c247de-9811-d37f-ad94-a8472dc1bc9c', 'Remove Excess System Log Records', './scheduler_delete_logs.php', '::24::::::', NULL, '2009-03-31 12:00:00', NULL, 'This script will trim the system log when there are more than 2000 records present at the time of its calling (default will be every 24 hours).', '0', 1, NOW(), 1, NOW());
302	--end scheduler INSERT--
303	--settings INSERT--
304	INSERT INTO `settings` (`name`, `value`) VALUES ('application_uuid','');
305	INSERT INTO `settings` (`name`, `value`) VALUES ('auto_check_update','1');
306	INSERT INTO `settings` (`name`, `value`) VALUES ('send_metrics','0');
307	INSERT INTO `settings` (`name`, `value`) VALUES ('last_update_check','');
308	--end settings INSERT--
309	--smartsearches UPDATE--
310	UPDATE `smartsearches` SET `uuid`='smrt:ccc73fa4-6176-fad4-fbb1-5186d0edbdd1',`valuefield`='`users`.`uuid`' WHERE `id`='2';
311	UPDATE `smartsearches` SET `uuid`='smrt:855406d5-659d-c907-74a1-acfd3802fd73' WHERE `id`='5';
312	UPDATE `smartsearches` SET `uuid`='smrt:ed5b1d7f-b0fe-2088-f17c-47bfbe1ace25' WHERE `id`='9';
313	--end smartsearches UPDATE--
314	--tablecolumns INSERT--
315	INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'widget', 'concat(\'[b]\', widgets.title, \'[/b][br]\', widgets.uuid)', 'left', '', '0', 'widgets.title', '0', '100%', 'bbcode', '');
316	INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'role', 'IF(widgets.roleid != \'\', IF(widgets.roleid != \'Admin\', roles.name, \'Administrator\'), \'EVERYONE\')', 'left', '', '2', '', '0', '', NULL, '');
317	INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'file', 'widgets.file', 'left', '', '1', '', '0', '', NULL, '');
318	DELETE FROM `tablecolumns` WHERE `tabledefid` = '19';
319	INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:83187e3d-101e-a8a5-037f-31e9800fed2d', 'link', 'menu.link', 'left', '', '1', '', '1', '', NULL, '');
320	INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:83187e3d-101e-a8a5-037f-31e9800fed2d', 'access', 'IF(menu.roleid=\'\' OR menu.roleid IS NULL,\'EVERYONE\',if(menu.roleid=\'Admin\',\'Administrators\',roles.name)) ', 'left', '', '2', '', '0', '', NULL, '');
321	INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:83187e3d-101e-a8a5-037f-31e9800fed2d', 'Item', 'IF(menu.parentid = \'\' OR menu.parentid IS NULL, CONCAT(\'[b]\', menu.name,\' [/b]\'), menu.name)', 'left', '', '0', '', '0', '100%', 'bbcode', '');
322	INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:83187e3d-101e-a8a5-037f-31e9800fed2d', 'display order', 'menu.displayorder', 'right', '', '3', '', '0', '', NULL, '');
323	--end tablecolumns INSERT--
324	--tablecolumns UPDATE--
325	UPDATE `tablecolumns` SET `column` = 'IF(`tabs`.`roleid`=\'\' OR `tabs`.`roleid` IS NULL,\'EVERYONE\',IF(`tabs`.`roleid`=\'Admin\',\'Administrators\',`roles`.`name`))' WHERE `column` = 'if(tabs.roleid=0,\'EVERYONE\',if(tabs.roleid=-100,\'Administrators\',roles.name))' AND `tabledefid` = '203';
326	UPDATE `tablecolumns` SET `column` = 'concat(\'[b]\', tabledefs.displayname, \'[/b][br][space][space]\', tabledefs.uuid)', `format` = 'bbcode' WHERE `name` = 'display' AND `tabledefid` = 11;
327	--end tablecolumns UPDATE--
328	--tabledefs INSERT--
329	INSERT INTO `tabledefs` (`uuid`, `displayname`, `prefix`, `type`, `moduleid`, `maintable`, `querytable`, `editfile`, `editroleid`, `addfile`, `addroleid`, `importfile`, `importroleid`, `searchroleid`, `advsearchroleid`, `viewsqlroleid`, `deletebutton`, `canpost`, `hascustomfields`, `defaultwhereclause`, `defaultsortorder`, `defaultsearchtype`, `defaultcriteriafindoptions`, `defaultcriteriaselection`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('tbld:2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'Snapshot Widgets', 'wdgt', 'system', '1', 'widgets', '((`widgets` INNER JOIN `modules` ON `widgets`.`moduleid` = `modules`.`uuid`) LEFT JOIN `roles` ON `widgets`.`roleid` = `roles`.`uuid`)', 'modules/base/widgets_addedit.php', '-100', 'modules/base/widgets_addedit.php', '-100', NULL, '-100', '-100', '-100', '-100', 'delete', '0', '0', 'widgets.id != -1', 'widgets.title', NULL, NULL, NULL, 1, NOW(), 1, NOW());
330	DELETE FROM `tabledefs` WHERE `id` = '19';
331	INSERT INTO `tabledefs` (`id`,`uuid`, `displayname`, `prefix`, `type`, `moduleid`, `maintable`, `querytable`, `editfile`, `editroleid`, `addfile`, `addroleid`, `importfile`, `importroleid`, `searchroleid`, `advsearchroleid`, `viewsqlroleid`, `deletebutton`, `canpost`, `hascustomfields`, `defaultwhereclause`, `defaultsortorder`, `defaultsearchtype`, `defaultcriteriafindoptions`, `defaultcriteriaselection`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('19','tbld:83187e3d-101e-a8a5-037f-31e9800fed2d', 'Menu', 'menu', 'system', '1', 'menu', '((menu LEFT JOIN menu as parentmenu on menu.parentid=parentmenu.uuid) LEFT JOIN roles on menu.roleid=roles.uuid)', 'modules/base/menu_addedit.php', '-100', 'modules/base/menu_addedit.php', '-100', NULL, 'Admin', '-100', '-100', '-100', 'delete', '0', '0', 'menu.id!=0', 'if(parentmenu.name is null,menu.displayorder,parentmenu.displayorder+(menu.displayorder+1)/10000)', '', '', '', 1, NOW(), 1, NOW());
332	--end tabledefs INSERT--
333	--tabledefs UPDATE--
334	UPDATE `tabledefs` SET `hascustomfields` = 1 WHERE `id` IN(12, 9, 26, 200);
335
336	UPDATE `tabledefs` SET
337	`uuid` = 'tbld:afe6d297-b484-4f0b-57d4-1c39412e9dfb',
338	`searchroleid` = -100,
339	`addroleid` = -100,
340	`editroleid` = -100,
341	`prefix` = 'usr'
342	WHERE
343	`id`='9';
344
345	UPDATE `tabledefs` SET
346	`uuid`='tbld:8d19c73c-42fb-d829-3681-d20b4dbe43b9',
347	`searchroleid` = -100,
348	`addroleid` = -100,
349	`editroleid` = -100,
350	`prefix` = 'rln',
351	`querytable` = '(`relationships` INNER JOIN `tabledefs` AS `fromtable` ON `relationships`.`fromtableid`=`fromtable`.`uuid`) INNER JOIN `tabledefs` AS `totable` ON `relationships`.`totableid`=`totable`.`uuid`'
352	WHERE
353	`id`='10';
354
355	UPDATE `tabledefs` SET
356	`uuid`='tbld:5c9d645f-26ab-5003-b98e-89e9049f8ac3',
357	`prefix` = 'tbld',
358	`querytable` = '`tabledefs` LEFT JOIN `modules` ON `tabledefs`.`moduleid` = `modules`.`uuid`'
359	WHERE
360	`id`='11';
361
362	UPDATE `tabledefs` SET
363	`uuid`='tbld:a4cdd991-cf0a-916f-1240-49428ea1bdd1',
364	`prefix` = 'note'
365	WHERE
366	`id`='12';
367
368	UPDATE `tabledefs` SET
369	`uuid`='tbld:d595ef42-db9d-2233-1b9b-11dfd0db9cbb',
370	`searchroleid` = -100,
371	`addroleid` = -100,
372	`editroleid` = -100,
373	`prefix` = 'rpt',
374	`querytable` = '`reports` LEFT JOIN `tabledefs` ON `reports`.`tabledefid` = `tabledefs`.`uuid`'
375	WHERE
376	`id`='16';
377
378	UPDATE `tabledefs` SET
379	`uuid`='tbld:e251524a-2da4-a0c9-8725-d3d0412d8f4a',
380	`searchroleid` = -100,
381	`addroleid` = -100,
382	`editroleid` = -100,
383	`prefix` = 'sss',
384	`querytable` = '(`usersearches` LEFT JOIN `users` ON `usersearches`.`userid` = `users`.`uuid`) INNER JOIN `tabledefs` ON `usersearches`.`tabledefid`=`tabledefs`.`uuid`'
385	WHERE
386	`id`='17';
387
388	UPDATE `tabledefs` SET
389	`uuid`='tbld:ea159d67-5e89-5b7f-f5a0-c740e147cd73',
390	`searchroleid` = -100,
391	`addroleid` = -100,
392	`editroleid` = -100,
393	`prefix` = 'mod'
394	WHERE
395	`id`='21';
396
397	UPDATE `tabledefs` SET
398	`uuid`='tbld:2bc3e683-81f9-694a-9550-a0c7263057de',
399	`querytable` = '((`notes` LEFT JOIN `users` AS `assignedto` ON `assignedto`.`uuid` = `notes`.`assignedtoid`) LEFT JOIN `users` as `assignedby` ON `assignedby`.`uuid`=`notes`.`assignedbyid`)'
400	WHERE
401	`id`='23';
402
403	UPDATE `tabledefs` SET
404	`uuid`='tbld:0fcca651-6c34-c74d-ac04-2d88f602dd71',
405	`querytable` = '((`notes` LEFT JOIN `users` AS `assignedto` ON `assignedto`.`uuid` = `notes`.`assignedtoid`) LEFT JOIN `users` as `assignedby` ON `assignedby`.`uuid`=`notes`.`assignedbyid`)'
406	WHERE
407	`id`='24';
408
409	UPDATE `tabledefs` SET
410	`uuid`='tbld:80b4f38d-b957-bced-c0a0-ed08a0db6475',
411	`prefix` = 'file'
412	WHERE
413	`id`='26';
414
415	UPDATE `tabledefs` SET
416	`uuid`='tbld:edb8c896-7ce3-cafe-1d58-5aefbcd5f3d7',
417	`querytable` = '(`attachments` INNER JOIN `files` ON `attachments`.`fileid`=`files`.`uuid`)'
418	WHERE
419	`id`='27';
420
421	UPDATE `tabledefs` SET
422	`uuid`='tbld:87b9fe06-afe5-d9c6-0fa0-4a0f2ec4ee8a',
423	`prefix` = 'role'
424	WHERE
425	`id`='200';
426
427	UPDATE `tabledefs` SET
428	`uuid`='tbld:83de284b-ef79-3567-145c-30ca38b40796',
429	`prefix` = 'schd'
430	WHERE
431	`id`='201';
432
433	UPDATE `tabledefs` SET
434	`uuid`='tbld:3f71ab66-1f84-d68b-e2a3-3ee3bb0ec667',
435	`querytable` = 'log LEFT JOIN users ON log.userid=users.uuid'
436	WHERE
437	`id`='202';
438
439	UPDATE `tabledefs` SET
440	`uuid`='tbld:7e75af48-6f70-d157-f440-69a8e7f59d38',
441	`prefix` = 'tab',
442	`querytable` = '`tabs` LEFT JOIN `roles` ON `tabs`.`roleid`=`roles`.`uuid`'
443	WHERE
444	`id`='203';
445
446	UPDATE `tabledefs` SET
447	`uuid`='tbld:29925e0a-c825-0067-8882-db4b57866a96',
448	`prefix` = 'smsr',
449	`querytable` = '(`smartsearches` INNER JOIN `tabledefs` ON `smartsearches`.`tabledefid` = `tabledefs`.`uuid`) INNER JOIN `modules` ON `smartsearches`.`moduleid` = `modules`.`uuid`'
450	WHERE
451	`id`='204';
452
453	--end tabledefs UPDATE--
454	--tablefindoptions INSERST--
455	INSERT INTO `tablefindoptions` (`tabledefid`, `name`, `search`, `displayorder`, `roleid`) VALUES ('tbld:2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'All Records', 'widgets.id!=-1', '0', '');
456	--end tablefindoptions INSERT--
457	--tablefindoptions UPDATE--
458	UPDATE `tablefindoptions` SET `search` = '`notes`.`type`=\'TS\' AND `notes`.`private`=\'0\'' WHERE `tabledefid` = '23' AND `search` = 'notes.type=\'NT\' AND notes.private=0';
459	UPDATE `tablefindoptions` SET `search` = '`notes`.`type`=\'NT\' AND `notes`.`assignedbyid`=\'{{$_SESSION[\'userinfo\'][\'id\']}}\' AND `notes`.`completed`=\'0\'' WHERE `tabledefid`='12' AND `search`='notes.type=\'NT\' and notes.assignedbyid={{$_SESSION[\'userinfo\'][\'id\']}} and notes.completed=0';
460	UPDATE `tablefindoptions` SET `search` = '`notes`.`type`=\'NT\' AND `notes`.`assignedtoid`=\'{{$_SESSION[\'userinfo\'][\'id\']}}\' AND `notes`.`completed`=\'0\'' WHERE `tabledefid`='12' AND `search`='notes.type=\'NT\' and notes.assignedtoid={{$_SESSION[\'userinfo\'][\'id\']}} and notes.completed=0';
461	UPDATE `tablefindoptions` SET `search` = '`notes`.`type`=\'TS\' AND `notes`.`assignedbyid`=\'{{$_SESSION[\'userinfo\'][\'id\']}}\' AND `notes`.`completed`=\'0\'' WHERE `tabledefid`='23' AND `search`='notes.type=\'TS\' and notes.assignedbyid={{$_SESSION[\'userinfo\'][\'id\']}} and notes.completed=0';
462	UPDATE `tablefindoptions` SET `search` = '`notes`.`type`=\'TS\' AND `notes`.`assignedtoid`=\'{{$_SESSION[\'userinfo\'][\'id\']}}\' AND `notes`.`completed`=\'0\'' WHERE `tabledefid`='23' AND `search`='notes.type=\'TS\' and notes.assignedtoid={{$_SESSION[\'userinfo\'][\'id\']}} and notes.completed=0';
463	--Whereclause in the next update is NOT a typo.--
464	UPDATE `tablefindoptions` SET `search` = '`notes`.`type`=\'EV\' AND `notes`.`assignedbyid`=\'{{$_SESSION[\'userinfo\'][\'id\']}}\' AND `notes`.`completed`=\'0\'' WHERE `tabledefid`='24' AND `search`='notes.type=\'NT\' and notes.assignedbyid={{$_SESSION[\'userinfo\'][\'id\']}} and notes.completed=0';
465	UPDATE `tablefindoptions` SET `search` = '`notes`.`type`=\'EV\' AND `notes`.`assignedtoid`=\'{{$_SESSION[\'userinfo\'][\'id\']}}\' AND `notes`.`completed`=\'0\'' WHERE `tabledefid`='24' AND `search`='notes.type=\'EV\' and notes.assignedtoid={{$_SESSION[\'userinfo\'][\'id\']}} and notes.completed=0';
466	--end tablefindoptions UPDATE--
467	--tablegroupings INSERT--
468	INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('tbld:2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'modules.name', '1', '1', 'Module', '');
469	INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('tbld:2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'widgets.type', '2', '1', 'Area', '');
470	DELETE FROM `tablegroupings` WHERE `tabledefid` = '19';
471	INSERT INTO `tablegroupings` (`tabledefid`, `field`, `displayorder`, `ascending`, `name`, `roleid`) VALUES ('tbld:83187e3d-101e-a8a5-037f-31e9800fed2d', 'if(menu.parentid=\'\' OR menu.parentid IS NULL,concat( lpad(menu.displayorder,3,\"0\"), \" - \" ,menu.name ) , concat( lpad(parentmenu.displayorder,3,\"0\") , \" - \",parentmenu.name))', '1', '1', '', '');
472	--end tablegroupings INSERT--
473	--tableoptions DELETE--
474	DELETE FROM `tableoptions` WHERE `name` = 'runSelected' AND `tabledefid` = '201' AND `option` = 'run job(s)';
475	--end tableoptions DELETE--
476	--tableoptions INSERT--
477	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:0fcca651-6c34-c74d-ac04-2d88f602dd71', 'import', '0', '0', '0', 'Admin', '0');
478	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:29925e0a-c825-0067-8882-db4b57866a96', 'import', '0', '0', '0', 'Admin', '0');
479	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:2bc3e683-81f9-694a-9550-a0c7263057de', 'import', '0', '0', '0', 'Admin', '0');
480	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:3f71ab66-1f84-d68b-e2a3-3ee3bb0ec667', 'import', '0', '0', '0', 'Admin', '0');
481	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:5c9d645f-26ab-5003-b98e-89e9049f8ac3', 'import', '0', '0', '0', 'Admin', '0');
482	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:7e75af48-6f70-d157-f440-69a8e7f59d38', 'import', '0', '0', '0', 'Admin', '0');
483	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:80b4f38d-b957-bced-c0a0-ed08a0db6475', 'import', '1', '0', '0', 'Admin', '0');
484	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:83187e3d-101e-a8a5-037f-31e9800fed2d', 'import', '0', '0', '0', 'Admin', '0');
485	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:83de284b-ef79-3567-145c-30ca38b40796', 'import', '0', '0', '0', 'Admin', '0');
486	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:87b9fe06-afe5-d9c6-0fa0-4a0f2ec4ee8a', 'import', '1', '0', '0', 'Admin', '0');
487	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:8d19c73c-42fb-d829-3681-d20b4dbe43b9', 'import', '0', '0', '0', 'Admin', '0');
488	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:a4cdd991-cf0a-916f-1240-49428ea1bdd1', 'import', '1', '0', '0', 'Admin', '0');
489	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:afe6d297-b484-4f0b-57d4-1c39412e9dfb', 'import', '1', '0', '0', 'Admin', '0');
490	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:d595ef42-db9d-2233-1b9b-11dfd0db9cbb', 'import', '0', '0', '0', 'Admin', '0');
491	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:e251524a-2da4-a0c9-8725-d3d0412d8f4a', 'import', '1', '0', '0', 'Admin', '0');
492	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:ea159d67-5e89-5b7f-f5a0-c740e147cd73', 'import', '0', '0', '0', 'Admin', '0');
493	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:edb8c896-7ce3-cafe-1d58-5aefbcd5f3d7', 'import', '0', '0', '0', 'Admin', '0');
494	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'new', '1', '0', '0', '', '0');
495	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'edit', '1', '1', '0', '', '0');
496	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'printex', '1', '0', '0', '', '0');
497	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'select', '1', '0', '0', '', '0');
498	INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `needselect`, `othercommand`, `roleid`, `displayorder`) VALUES ('tbld:2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'import', '1', '0', '0', 'Admin', '0');
499	--end tableoptions INSERT--
500	--tableoptions UPDATE--
501	UPDATE `tableoptions` SET `needselect` = 0 WHERE `name` IN('massEmail','new','printex','select') AND `tabledefid` IN (9,10,11,12,16,17,19,21,23,24,26,27,200,201,202,203,204);
502	--end tableoptions UPDATE--
503	--tablesearchablefields INSERT--
504	INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'widgets.id', 'id', '1', 'field');
505	--end tablesearchablefields INSERT--
506	--tabs INSERT--
507	INSERT INTO `tabs` (`uuid`, `name`, `tabgroup`, `location`, `displayorder`, `enableonnew`, `roleid`, `tooltip`, `notificationsql`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('tab:2ebf956d-5e39-c7d5-16b7-501b64685a5a', 'custom fields', 'tabledefs entry', 'modules/base/tabledefs_custom.php', '60', '0', '-100', NULL, NULL, 1, NOW(), 1, NOW());
508	--end tabs INSERT--
509	--tabs UPDATE--
510	UPDATE `tabs` SET `uuid`='tab:fdf064e0-f2d9-6c67-b64f-449e72e859b9' WHERE `id`='1';
511	UPDATE `tabs` SET `uuid`='tab:b1011143-1d47-520e-5879-3953a4f5055b' WHERE `id`='2';
512	UPDATE `tabs` SET `uuid`='tab:c5bdaf10-062c-fb3a-f40f-ddce821fd579' WHERE `id`='3';
513	UPDATE `tabs` SET `uuid`='tab:276dacd4-4a37-d979-aeda-a7982f632559' WHERE `id`='4';
514	UPDATE `tabs` SET `uuid`='tab:22d08e82-5047-4150-6de7-49e89149f56b' WHERE `id`='5';
515	UPDATE `tabs` SET `uuid`='tab:c111eaf5-692b-9c7d-1d46-1bacb6703361' WHERE `id`='100';
516	--end tabs UPDATE--
517	--users UPDATE--
518	UPDATE `users` SET `admin`='1' WHERE `portalaccess`='1';
519	UPDATE `users` SET `uuid`='usr:5c196e01-193a-8952-fee7-29b4e5e6a0b0' WHERE `id`='1';
520	UPDATE `users` SET `uuid`='usr:cb67a60b-a264-735c-6189-49a7c883af0b' WHERE `id`='2';
521	UPDATE `users` SET `uuid`='usr:42e0cc76-3c31-d9b6-ff12-fe4adfd15e75' WHERE `id`='-2';
522	--end users UPDATE--
523	--widgets INSERT--
524	INSERT INTO `widgets` (`uuid`, `type`, `title`, `file`, `roleid`, `moduleid`, `default`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('wdgt:a1aec114-954b-37c1-0474-7d4e851c728c', 'little', 'Workload', 'widgets/workload/class.php', '', 'mod:29873ee8-c12a-e3f6-9010-4cd24174ffd7', '1', 1, NOW(), 1, NOW());
525	INSERT INTO `widgets` (`uuid`, `type`, `title`, `file`, `roleid`, `moduleid`, `default`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('wdgt:13d228d3-bbee-e7d2-6571-83a568688e3d', 'big', 'Events', 'widgets/events/class.php', '', 'mod:29873ee8-c12a-e3f6-9010-4cd24174ffd7', '1', 1, NOW(), 1, NOW());
526	INSERT INTO `widgets` (`uuid`, `type`, `title`, `file`, `roleid`, `moduleid`, `default`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('wdgt:bc323640-6497-cb6f-5897-029af7dcb3c9', 'little', 'System Statistics', 'widgets/systemstats/class.php', 'Admin', 'mod:29873ee8-c12a-e3f6-9010-4cd24174ffd7', '0', 1, NOW(), 1, NOW());
527	--end widgets INSERT--

Note: See TracBrowser for help on using the browser.

phpBMS

Context Navigation

root/trunk/phpbms/install/updatev0.98.sql

Download in other formats: