Lines 1-110
Link Here
|
1 |
|
1 |
|
2 |
DROP TABLE IF EXISTS table_fid; |
|
|
3 |
|
2 |
|
4 |
CREATE TABLE table_fid ( |
|
|
5 |
id INT NOT NULL AUTO_INCREMENT, |
6 |
primary key (id) |
7 |
); |
8 |
|
9 |
DROP FUNCTION IF EXISTS select_fid; |
10 |
|
11 |
DELIMITER // |
12 |
|
13 |
CREATE FUNCTION select_fid () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA |
14 |
BEGIN |
15 |
DECLARE xid INT; |
16 |
INSERT into table_fid VALUES(); |
17 |
SELECT last_insert_id() into xid; |
18 |
RETURN xid; |
19 |
END // |
20 |
|
21 |
DELIMITER ; |
22 |
|
23 |
DROP TABLE IF EXISTS table_serial_id; |
24 |
|
25 |
CREATE TABLE table_serial_id ( |
26 |
id INT NOT NULL AUTO_INCREMENT, |
27 |
primary key (id) |
28 |
) AUTO_INCREMENT = 9; |
29 |
|
30 |
DROP FUNCTION IF EXISTS select_serial_id; |
31 |
|
32 |
DELIMITER // |
33 |
|
34 |
CREATE FUNCTION select_serial_id () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA |
35 |
BEGIN |
36 |
DECLARE xid INT; |
37 |
INSERT into table_serial_id VALUES(); |
38 |
SELECT last_insert_id() into xid; |
39 |
RETURN xid; |
40 |
END // |
41 |
|
42 |
DELIMITER ; |
43 |
|
44 |
|
45 |
DROP TABLE IF EXISTS table_import_id; |
46 |
|
47 |
CREATE TABLE table_import_id ( |
48 |
id INT NOT NULL AUTO_INCREMENT, |
49 |
primary key (id) |
50 |
); |
51 |
|
3 |
|
52 |
DROP FUNCTION IF EXISTS select_import_id; |
|
|
53 |
|
4 |
|
54 |
DELIMITER // |
|
|
55 |
|
5 |
|
56 |
CREATE FUNCTION select_import_id () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA |
|
|
57 |
BEGIN |
58 |
DECLARE xid INT; |
59 |
INSERT into table_import_id VALUES(); |
60 |
SELECT last_insert_id() into xid; |
61 |
RETURN xid; |
62 |
END // |
63 |
|
6 |
|
64 |
DELIMITER ; |
|
|
65 |
|
7 |
|
66 |
|
8 |
|
67 |
DROP TABLE IF EXISTS table_insert_id; |
|
|
68 |
|
9 |
|
69 |
CREATE TABLE table_insert_id ( |
|
|
70 |
id INT NOT NULL AUTO_INCREMENT, |
71 |
primary key (id) |
72 |
) AUTO_INCREMENT = 101; |
73 |
|
10 |
|
74 |
DROP FUNCTION IF EXISTS select_insert_id; |
|
|
75 |
|
76 |
DELIMITER // |
77 |
|
78 |
CREATE FUNCTION select_insert_id () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA |
79 |
BEGIN |
80 |
DECLARE xid INT; |
81 |
INSERT into table_insert_id VALUES(); |
82 |
SELECT last_insert_id() into xid; |
83 |
RETURN xid; |
84 |
END // |
85 |
|
86 |
DELIMITER ; |
87 |
|
88 |
DROP TABLE IF EXISTS table_profile_id; |
89 |
|
90 |
CREATE TABLE table_profile_id ( |
91 |
id INT NOT NULL AUTO_INCREMENT, |
92 |
primary key (id) |
93 |
); |
94 |
|
95 |
DROP FUNCTION IF EXISTS select_profile_id; |
96 |
|
97 |
DELIMITER // |
98 |
|
99 |
CREATE FUNCTION select_profile_id () RETURNS INTEGER DETERMINISTIC MODIFIES SQL DATA |
100 |
BEGIN |
101 |
DECLARE xid INT; |
102 |
INSERT into table_profile_id VALUES(); |
103 |
SELECT last_insert_id() into xid; |
104 |
RETURN xid; |
105 |
END // |
106 |
|
107 |
|
108 |
DELIMITER ; |
109 |
|
11 |
|
110 |
CREATE TABLE prg_dlist ( |
12 |
CREATE TABLE prg_dlist ( |
Lines 309-313
Link Here
|
309 |
changing_date timestamp , |
211 |
changing_date timestamp , |
310 |
changed_from text, |
212 |
changed_from text, |
311 |
login text PRIMARY KEY, |
213 |
login varchar(255) PRIMARY KEY, |
312 |
addr_u text, |
214 |
addr_u text, |
313 |
addr_r text, |
215 |
addr_r text, |
Lines 446-450
Link Here
|
446 |
timestampfield01 timestamp , |
348 |
timestampfield01 timestamp , |
447 |
timestampfield02 timestamp , |
349 |
timestampfield02 timestamp , |
448 |
intfield01 int NOT NULL, |
350 |
intfield01 int PRIMARY KEY, |
449 |
intfield02 int, |
351 |
intfield02 int, |
450 |
intfield03 int, |
352 |
intfield03 int, |
Lines 1328-1332
Link Here
|
1328 |
timestampfield01 timestamp , |
1230 |
timestampfield01 timestamp , |
1329 |
timestampfield02 timestamp , |
1231 |
timestampfield02 timestamp , |
1330 |
intfield01 int NOT NULL, |
1232 |
intfield01 int PRIMARY KEY, |
|
|
1233 |
intfield02 int, |
1234 |
intfield03 int, |
1235 |
intfield04 int, |
1236 |
intfield05 int, |
1237 |
intfield06 int, |
1238 |
field01 text NOT NULL, |
1239 |
field02 text, |
1240 |
field03 text, |
1241 |
field04 text, |
1242 |
field05 text, |
1243 |
field06 text, |
1244 |
field07 text, |
1245 |
field08 text, |
1246 |
field09 text, |
1247 |
field10 text |
1248 |
); |
1249 |
|
1250 |
CREATE TABLE del_docufolders ( |
1251 |
creating_date timestamp NOT NULL, |
1252 |
created_from text NOT NULL, |
1253 |
changing_date timestamp, |
1254 |
changed_from text, |
1255 |
user_right text NOT NULL, |
1256 |
group_right text NOT NULL, |
1257 |
sid text NOT NULL, |
1258 |
tid text, |
1259 |
order_crit text, |
1260 |
timestampfield01 timestamp, |
1261 |
timestampfield02 timestamp, |
1262 |
intfield01 int PRIMARY KEY, |
1331 |
intfield02 int, |
1263 |
intfield02 int, |
1332 |
intfield03 int, |
1264 |
intfield03 int, |
Lines 1358-1362
Link Here
|
1358 |
timestampfield01 timestamp , |
1290 |
timestampfield01 timestamp , |
1359 |
timestampfield02 timestamp , |
1291 |
timestampfield02 timestamp , |
1360 |
intfield01 int NOT NULL, |
1292 |
intfield01 int PRIMARY KEY, |
|
|
1293 |
intfield02 int NOT NULL, |
1294 |
intfield03 int, |
1295 |
intfield04 int, |
1296 |
intfield05 int, |
1297 |
intfield06 int, |
1298 |
field01 text NOT NULL, |
1299 |
field02 text, |
1300 |
field03 text, |
1301 |
field04 text, |
1302 |
field05 text, |
1303 |
field06 text, |
1304 |
field07 text, |
1305 |
field08 text, |
1306 |
field09 text, |
1307 |
field10 text |
1308 |
); |
1309 |
|
1310 |
CREATE TABLE del_documents ( |
1311 |
creating_date timestamp NOT NULL, |
1312 |
created_from text NOT NULL, |
1313 |
changing_date timestamp, |
1314 |
changed_from text, |
1315 |
user_right text NOT NULL, |
1316 |
group_right text NOT NULL, |
1317 |
sid text NOT NULL, |
1318 |
tid text, |
1319 |
order_crit text, |
1320 |
timestampfield01 timestamp, |
1321 |
timestampfield02 timestamp, |
1322 |
intfield01 int PRIMARY KEY, |
1361 |
intfield02 int NOT NULL, |
1323 |
intfield02 int NOT NULL, |
1362 |
intfield03 int, |
1324 |
intfield03 int, |
Lines 1388-1392
Link Here
|
1388 |
timestampfield01 timestamp , |
1350 |
timestampfield01 timestamp , |
1389 |
timestampfield02 timestamp , |
1351 |
timestampfield02 timestamp , |
1390 |
intfield01 int NOT NULL, |
1352 |
intfield01 int PRIMARY KEY, |
|
|
1353 |
intfield02 int NOT NULL, |
1354 |
intfield03 int NOT NULL, |
1355 |
intfield04 int, |
1356 |
intfield05 int, |
1357 |
intfield06 int, |
1358 |
field01 text NOT NULL, |
1359 |
field02 text, |
1360 |
field03 text NOT NULL, |
1361 |
field04 text NOT NULL, |
1362 |
field05 text, |
1363 |
field06 text, |
1364 |
field07 text, |
1365 |
field08 text, |
1366 |
field09 text, |
1367 |
field10 text |
1368 |
); |
1369 |
|
1370 |
CREATE TABLE del_documents_files ( |
1371 |
creating_date timestamp NOT NULL, |
1372 |
created_from text, |
1373 |
changing_date timestamp, |
1374 |
changed_from text, |
1375 |
user_right text, |
1376 |
group_right text, |
1377 |
sid text NOT NULL, |
1378 |
tid text, |
1379 |
order_crit text, |
1380 |
timestampfield01 timestamp, |
1381 |
timestampfield02 timestamp, |
1382 |
intfield01 int PRIMARY KEY, |
1391 |
intfield02 int NOT NULL, |
1383 |
intfield02 int NOT NULL, |
1392 |
intfield03 int NOT NULL, |
1384 |
intfield03 int NOT NULL, |
Lines 1972-1976
Link Here
|
1972 |
CREATE TABLE sys_linkage ( |
1964 |
CREATE TABLE sys_linkage ( |
1973 |
changing_date timestamp NOT NULL, |
1965 |
changing_date timestamp NOT NULL, |
1974 |
luid int NOT NULL, |
1966 |
luid int PRIMARY KEY, |
1975 |
source_id int NOT NULL, |
1967 |
source_id int NOT NULL, |
1976 |
src_table text NOT NULL, |
1968 |
src_table text NOT NULL, |
Lines 1992-1996
Link Here
|
1992 |
CREATE TABLE del_linkage ( |
1984 |
CREATE TABLE del_linkage ( |
1993 |
changing_date timestamp NOT NULL, |
1985 |
changing_date timestamp NOT NULL, |
1994 |
luid int NOT NULL, |
1986 |
luid int PRIMARY KEY, |
1995 |
source_id int NOT NULL, |
1987 |
source_id int NOT NULL, |
1996 |
src_table text NOT NULL, |
1988 |
src_table text NOT NULL, |
Lines 2046-2049
Link Here
|
2046 |
); |
2038 |
); |
2047 |
|
2039 |
|
|
|
2040 |
CREATE TABLE oxfolder_userfolders_standardfolders ( |
2041 |
owner text, |
2042 |
module text, |
2043 |
fuid int |
2044 |
); |
2045 |
|
2048 |
CREATE TABLE del_oxfolder_tree ( |
2046 |
CREATE TABLE del_oxfolder_tree ( |
2049 |
fuid int, |
2047 |
fuid int, |
Lines 2110-2113
Link Here
|
2110 |
); |
2108 |
); |
2111 |
|
2109 |
|
|
|
2110 |
CREATE TABLE del_system_objects ( |
2111 |
object_type int, |
2112 |
object_id text, |
2113 |
deleting_date timestamp |
2114 |
); |
2115 |
|
2112 |
INSERT INTO oxfolder_tree VALUES (1, 0, 'private', 'system', 'system','system', 'system', now(), 'System', null, null); |
2116 |
INSERT INTO oxfolder_tree VALUES (1, 0, 'private', 'system', 'system','system', 'system', now(), 'System', null, null); |
2113 |
INSERT INTO oxfolder_tree VALUES (2, 0, 'public', 'system', 'system','system', 'system', now(), 'System', null, null); |
2117 |
INSERT INTO oxfolder_tree VALUES (2, 0, 'public', 'system', 'system','system', 'system', now(), 'System', null, null); |
Lines 2127-2130
Link Here
|
2127 |
INSERT INTO oxfolder_permissions VALUES (select_serial_id(), 7, 512, 'all_ox_users_and_ox_groups', 0, 2, 0, 0, 0); |
2131 |
INSERT INTO oxfolder_permissions VALUES (select_serial_id(), 7, 512, 'all_ox_users_and_ox_groups', 0, 2, 0, 0, 0); |
2128 |
INSERT INTO oxfolder_permissions VALUES (select_serial_id(), 8, 512, 'all_ox_users_and_ox_groups', 0, 8, 4, 2, 2); |
2132 |
INSERT INTO oxfolder_permissions VALUES (select_serial_id(), 8, 512, 'all_ox_users_and_ox_groups', 0, 8, 4, 2, 2); |
|
|
2133 |
INSERT INTO oxfolder_permissions VALUES (select_serial_id(), 9, 32768, 'mailadmin', 0, 128, 128, 128, 128); |
2129 |
|
2134 |
|
2130 |
INSERT INTO oxfolder_specialfolders VALUES ('private', 1); |
2135 |
INSERT INTO oxfolder_specialfolders VALUES ('private', 1); |