MySql_insertDefault.sql
3.46 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
INSERT INTO losp_BE_profile (MTextID, NickName, EMail, Url, Fingerprint, Jabber, OnlineState) VALUES ('0','all', 'dev@mensch.coop', '', '', '', '0');
INSERT INTO losp_BasisElement_categorynamelist (BECategoryID, BECategoryName) VALUES ('0', '');
INSERT INTO losp_BasisElement_categorylist (BECategoryListID, BECategoryID) VALUES ('0', '0');
INSERT INTO losp_BasisElement_tagnamelist (TagID, TagName) VALUES ('0', '0');
INSERT INTO losp_BasisElement_taglist (TagListID, TagID) VALUES ('0', '0');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('0','class');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('1','Account');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('2','MultimediaText');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('4','CultureDirectManager');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('5','DateBE');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('6','DirectManager');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('7','EconomyDirectManager');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('8','FileBE');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('9','FileUnderBE');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('10','FileUnderImageBE');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('12','LocationBE');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('13','NewsfeedBE');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('14','NewsfeedItemBE');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('15','OfficeManager');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('18','ThreadMessageBE');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('19','ThreadMessageUnderBE');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('20','TopicBE');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('21','UrlBE');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('22','Treepart');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('23','Profile');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('24','PostMessageBE');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('25','CampaignBE');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('26','GroupProfileBE');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('27','');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('28','');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('29','');
INSERT INTO losp_class (ClassID, ClassName) VALUES ('30','');
INSERT INTO losp_BasisElement (ID, Author_ProfileID , Text , AuthReadListID , AuthWriteListID, ClassID) VALUES ('0','0', 'alles fuer alle', '0', '0', '0');
INSERT INTO losp_BE_newsfeed (MTextID, Url) VALUES ('0', 'nothing');
INSERT INTO losp_BasisClipboard_category (CategoryID, CategoryName) VALUES ('0', '');
INSERT INTO losp_BasisElement_writeauthorisation ( ListID, ProfileID) VALUES (0, 0);
INSERT INTO losp_BasisElement_readauthorisation ( ListID, ProfileID) VALUES (0, 0);
INSERT INTO losp_BE_date (MTextID, Start , End) VALUES ('0', '0', '0');
INSERT INTO losp_BE_topic (MTextID, Name) VALUES ('0','topic');
INSERT INTO losp_BE_treepart (MTextID, Name) VALUES ('0','treepart');
INSERT INTO losp_BE_file (MTextID,Link) VALUES ('0', 'nothing');
INSERT INTO losp_BE_url (MTextID,Url) VALUES ('0', 'nothing');
INSERT INTO losp_BasisElement_profilecollection_writeauthorisation (PCListID, ProfileCollectionID) VALUES (0, 0);
INSERT INTO losp_BasisElement_profilecollection_readauthorisation (PCListID, ProfileCollectionID) VALUES (0, 0);