PageRenderTime 53ms CodeModel.GetById 22ms RepoModel.GetById 0ms app.codeStats 0ms

/install/sql/yabs-1.0-mysql.sql

http://mp-rechnungs-und-kundenverwaltung.googlecode.com/
SQL | 1664 lines | 1373 code | 291 blank | 0 comment | 5 complexity | 1563e2bb43f346abb65349b04f175d3a MD5 | raw file
Possible License(s): LGPL-3.0, Apache-2.0, GPL-3.0, GPL-2.0, AGPL-3.0, JSON, BSD-3-Clause 
    

  1. CREATE TABLE accounts  (

    2. 

  2. 	ids             	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    3. 

  3. 	intaccountclass 	SMALLINT DEFAULT 0,

    4. 

  4. 	cname           	VARCHAR(250) NOT NULL,

    5. 

  5. 	description     	VARCHAR(250) NOT NULL,

    6. 

  6. 	taxvalue        	DOUBLE NOT NULL DEFAULT 0,

    7. 

  7. 	dateadded       	DATE NOT NULL,

    8. 

  8. 	intaddedby      	BIGINT(20) DEFAULT 0,

    9. 

  9. 	intparentaccount	BIGINT(20) DEFAULT 0,

    10. 

  10. 	groupsids       	BIGINT(20) UNSIGNED NOT NULL  DEFAULT 1,

    11. 

  11. 	invisible       	SMALLINT DEFAULT 0,

    12. 

  12. 	intaccounttype  	SMALLINT NOT NULL,

    13. 

  13. 	intprofitfid    	SMALLINT NOT NULL,

    14. 

  14. 	inttaxfid       	SMALLINT NOT NULL,

    15. 

  15. 	inttaxuid       	SMALLINT NOT NULL,

    16. 

  16. 	frame           	VARCHAR(25) NOT NULL,

    17. 

  17. 	hierarchypath   	VARCHAR(250) DEFAULT NULL

    18. 

  18. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    19. 

  19. 

    20. 

  20. CREATE TABLE addresses  (

    21. 

  21. 	ids        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    22. 

  22. 	groupsids  	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    23. 

  23. 	contactsids	BIGINT(20) UNSIGNED NOT NULL ,

    24. 

  24. 	title      	VARCHAR(250) DEFAULT NULL,

    25. 

  25. 	taxnumber  	VARCHAR(250) DEFAULT NULL,

    26. 

  26. 	prename    	VARCHAR(250) DEFAULT NULL,

    27. 

  27. 	cname      	VARCHAR(250) DEFAULT NULL,

    28. 

  28. 	street     	VARCHAR(250) DEFAULT NULL,

    29. 

  29. 	zip        	VARCHAR(50) DEFAULT NULL,

    30. 

  30. 	city       	VARCHAR(300) DEFAULT NULL,

    31. 

  31. 	company    	VARCHAR(250) DEFAULT NULL,

    32. 

  32. 	department 	VARCHAR(250) DEFAULT NULL,

    33. 

  33. 	country    	VARCHAR(50) DEFAULT NULL,

    34. 

  34. 	ismale     	SMALLINT DEFAULT 0,

    35. 

  35. 	intaddedby 	BIGINT(20) DEFAULT 0,

    36. 

  36. 	dateadded  	DATE DEFAULT NULL,

    37. 

  37. 	inttype    	SMALLINT DEFAULT 0,

    38. 

  38. 	reserve1   	VARCHAR(500) DEFAULT NULL,

    39. 

  39. 	reserve2   	VARCHAR(500) DEFAULT NULL

    40. 

  40. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    41. 

  41. 

    42. 

  42. CREATE TABLE comps  (

    43. 

  43. 	ids          	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    44. 

  44. 	groupsids    	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    45. 

  45. 	cname        	VARCHAR(250) DEFAULT NULL,

    46. 

  46. 	state        	VARCHAR(250) DEFAULT NULL,

    47. 

  47. 	phoneprefix  	VARCHAR(250) DEFAULT NULL,

    48. 

  48. 	business     	VARCHAR(250) DEFAULT NULL,

    49. 

  49. 	taxadvisor   	VARCHAR(250) DEFAULT NULL,

    50. 

  50. 	city         	VARCHAR(250) DEFAULT NULL,

    51. 

  51. 	taxadvjob    	VARCHAR(250) DEFAULT NULL,

    52. 

  52. 	street       	VARCHAR(250) DEFAULT NULL,

    53. 

  53. 	stb          	VARCHAR(250) DEFAULT NULL,

    54. 

  54. 	email        	VARCHAR(250) DEFAULT NULL,

    55. 

  55. 	name         	VARCHAR(250) DEFAULT NULL,

    56. 

  56. 	zipcode      	VARCHAR(250) DEFAULT NULL,

    57. 

  57. 	phone        	VARCHAR(250) DEFAULT NULL,

    58. 

  58. 	firstname    	VARCHAR(250) DEFAULT NULL,

    59. 

  59. 	taxauthority 	VARCHAR(250) DEFAULT NULL,

    60. 

  60. 	taxnumber    	VARCHAR(250) DEFAULT NULL,

    61. 

  61. 	taxadvmandant	VARCHAR(250) DEFAULT NULL,

    62. 

  62. 	dateadded    	DATE NOT NULL,

    63. 

  63. 	ismale       	SMALLINT DEFAULT 0,

    64. 

  64. 	isenabled    	SMALLINT DEFAULT 1,

    65. 

  65. 	intaddedby   	BIGINT(20) DEFAULT 0,

    66. 

  66. 	invisible    	SMALLINT DEFAULT 0,

    67. 

  67. 	reserve1     	VARCHAR(500) DEFAULT NULL,

    68. 

  68. 	reserve2     	VARCHAR(500) DEFAULT NULL

    69. 

  69. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    70. 

  70. 

    71. 

  71. CREATE TABLE contacts  (

    72. 

  72. 	ids           	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    73. 

  73. 	cnumber       	VARCHAR(250) DEFAULT NULL,

    74. 

  74. 	taxnumber     	VARCHAR(250),

    75. 

  75. 	title         	VARCHAR(250) DEFAULT NULL,

    76. 

  76. 	groupsids     	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    77. 

  77. 	country       	VARCHAR(50) DEFAULT NULL,

    78. 

  78. 	prename       	VARCHAR(250) DEFAULT NULL,

    79. 

  79. 	cname         	VARCHAR(250) DEFAULT NULL,

    80. 

  80. 	street        	VARCHAR(250) DEFAULT NULL,

    81. 

  81. 	zip           	VARCHAR(50) DEFAULT NULL,

    82. 

  82. 	city          	VARCHAR(300) DEFAULT NULL,

    83. 

  83. 	mainphone     	VARCHAR(250) DEFAULT NULL,

    84. 

  84. 	fax           	VARCHAR(250) DEFAULT NULL,

    85. 

  85. 	mobilephone   	VARCHAR(250) DEFAULT NULL,

    86. 

  86. 	workphone     	VARCHAR(250) DEFAULT NULL,

    87. 

  87. 	mailaddress   	VARCHAR(350) DEFAULT NULL,

    88. 

  88. 	company       	VARCHAR(250) DEFAULT NULL,

    89. 

  89. 	department    	VARCHAR(250) DEFAULT NULL,

    90. 

  90. 	website       	VARCHAR(350) DEFAULT NULL,

    91. 

  91. 	notes         	VARCHAR(10000),

    92. 

  92. 	dateadded     	DATE NOT NULL,

    93. 

  93. 	isactive      	SMALLINT DEFAULT 0,

    94. 

  94. 	iscustomer    	SMALLINT DEFAULT 0,

    95. 

  95. 	ismanufacturer	SMALLINT DEFAULT 0,

    96. 

  96. 	issupplier    	SMALLINT DEFAULT 0,

    97. 

  97. 	iscompany     	SMALLINT DEFAULT 0,

    98. 

  98. 	ismale        	SMALLINT DEFAULT 0,

    99. 

  99. 	isenabled     	SMALLINT DEFAULT 1,

    100. 

  100. 	intaddedby    	BIGINT(20) DEFAULT 0,

    101. 

  101. 	invisible     	SMALLINT DEFAULT 0,

    102. 

  102. 	reserve1      	VARCHAR(500) DEFAULT NULL,

    103. 

  103. 	reserve2      	VARCHAR(500) DEFAULT NULL

    104. 

  104. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    105. 

  105. 

    106. 

  106. CREATE TABLE countries  (

    107. 

  107. 	ids      	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    108. 

  108. 	cname    	VARCHAR(250) NOT NULL,

    109. 

  109. 	iso      	SMALLINT NOT NULL,

    110. 

  110. 	groupsids	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    111. 

  111. 	reserve1 	VARCHAR(500) DEFAULT NULL,

    112. 

  112. 	reserve2 	VARCHAR(500) DEFAULT NULL

    113. 

  113. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    114. 

  114. 

    115. 

  115. CREATE TABLE expenses  (

    116. 

  116. 	ids            	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    117. 

  117. 	groupsids      	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    118. 

  118. 	cnumber        	VARCHAR(250) DEFAULT NULL,

    119. 

  119. 	cname          	VARCHAR(250) DEFAULT NULL,

    120. 

  120. 	accountsids    	BIGINT(20) UNSIGNED NOT NULL ,

    121. 

  121. 	netvalue       	DOUBLE DEFAULT 0,

    122. 

  122. 	taxpercentvalue	DOUBLE DEFAULT 0,

    123. 

  123. 	brutvalue      	DOUBLE DEFAULT 0,

    124. 

  124. 	description    	VARCHAR(5000) DEFAULT NULL,

    125. 

  125. 	dateadded      	DATE NOT NULL,

    126. 

  126. 	intaddedby     	BIGINT(20) DEFAULT 0,

    127. 

  127. 	invisible      	SMALLINT DEFAULT 0,

    128. 

  128. 	reserve1       	VARCHAR(500) DEFAULT NULL,

    129. 

  129. 	reserve2       	VARCHAR(500) DEFAULT NULL

    130. 

  130. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    131. 

  131. 

    132. 

  132. CREATE TABLE favourites  (

    133. 

  133. 	ids       	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    134. 

  134. 	cname     	VARCHAR(250) NOT NULL,

    135. 

  135. 	usersids  	BIGINT(20) UNSIGNED NOT NULL ,

    136. 

  136. 	groupsids 	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    137. 

  137. 	itemsids  	BIGINT(20) UNSIGNED NOT NULL NOT NULL,

    138. 

  138. 	dateadded 	DATE NOT NULL,

    139. 

  139. 	intaddedby	BIGINT(20) DEFAULT 0,

    140. 

  140. 	invisible 	SMALLINT DEFAULT 0,

    141. 

  141. 	reserve1  	VARCHAR(500) DEFAULT NULL,

    142. 

  142. 	reserve2  	VARCHAR(500) DEFAULT NULL

    143. 

  143. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    144. 

  144. 

    145. 

  145. CREATE TABLE files  (

    146. 

  146. 	ids       	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    147. 

  147. 	cname     	VARCHAR(25) NOT NULL,

    148. 

  148. 	groupsids 	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    149. 

  149. 	dateadded 	DATE NOT NULL,

    150. 

  150. 	data      	BLOB(5242880) NOT NULL,

    151. 

  151. 	filesize  	BIGINT(20) NOT NULL,

    152. 

  152. 	intaddedby	BIGINT(20) DEFAULT 0,

    153. 

  153. 	invisible 	SMALLINT DEFAULT 0

    154. 

  154. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    155. 

  155. 

    156. 

  156. CREATE TABLE filestocontacts  (

    157. 

  157. 	ids        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    158. 

  158. 	cname      	VARCHAR(250) NOT NULL,

    159. 

  159. 	description	VARCHAR(550) DEFAULT NULL,

    160. 

  160. 	contactsids	BIGINT(20) UNSIGNED NOT NULL NOT NULL,

    161. 

  161. 	filename   	VARCHAR(25) NOT NULL,

    162. 

  162. 	intsize    	BIGINT(20) DEFAULT 0,

    163. 

  163. 	mimetype   	VARCHAR(25) DEFAULT NULL,

    164. 

  164. 	intaddedby 	BIGINT(20) DEFAULT 0,

    165. 

  165. 	dateadded  	DATE NOT NULL,

    166. 

  166. 	groupsids  	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1

    167. 

  167. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    168. 

  168. 

    169. 

  169. CREATE TABLE filestoitems  (

    170. 

  170. 	ids        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    171. 

  171. 	cname      	VARCHAR(250) NOT NULL,

    172. 

  172. 	description	VARCHAR(550) DEFAULT NULL,

    173. 

  173. 	itemsids   	BIGINT(20) UNSIGNED NOT NULL NOT NULL,

    174. 

  174. 	filename   	VARCHAR(25) NOT NULL,

    175. 

  175. 	intsize    	BIGINT(20) DEFAULT 0,

    176. 

  176. 	mimetype   	VARCHAR(25) DEFAULT NULL,

    177. 

  177. 	intaddedby 	BIGINT(20) DEFAULT 0,

    178. 

  178. 	dateadded  	DATE NOT NULL,

    179. 

  179. 	groupsids  	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1

    180. 

  180. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    181. 

  181. 

    182. 

  182. CREATE TABLE filestoproducts  (

    183. 

  183. 	ids        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    184. 

  184. 	cname      	VARCHAR(250) NOT NULL,

    185. 

  185. 	description	VARCHAR(550) DEFAULT NULL,

    186. 

  186. 	productsids	BIGINT(20) UNSIGNED NOT NULL NOT NULL,

    187. 

  187. 	filename   	VARCHAR(25) NOT NULL,

    188. 

  188. 	intsize    	BIGINT(20) DEFAULT 0,

    189. 

  189. 	mimetype   	VARCHAR(25) DEFAULT NULL,

    190. 

  190. 	intaddedby 	BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,

    191. 

  191. 	dateadded  	DATE NOT NULL,

    192. 

  192. 	groupsids  	BIGINT(20)  UNSIGNED NOT NULL DEFAULT 1

    193. 

  193. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    194. 

  194. 

    195. 

  195. CREATE TABLE formatstousers  (

    196. 

  196. 	ids     	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    197. 

  197. 	cname   	VARCHAR(250) NOT NULL,

    198. 

  198. 	usersids	BIGINT(20) UNSIGNED NOT NULL ,

    199. 

  199. 	inttype 	SMALLINT DEFAULT 0

    200. 

  200. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    201. 

  201. 

    202. 

  202. CREATE TABLE globalsettings  (

    203. 

  203. 	ids      	BIGINT(20) DEFAULT 1,

    204. 

  204. 	cname    	VARCHAR(250) NOT NULL,

    205. 

  205. 	groupsids	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    206. 

  206. 	value    	VARCHAR(250) NOT NULL

    207. 

  207. 	)ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    208. 

  208. 

    209. 

  209. CREATE TABLE groups  (

    210. 

  210. 	ids          	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    211. 

  211. 	cname        	VARCHAR(250) NOT NULL,

    212. 

  212. 	description  	VARCHAR(750) DEFAULT NULL,

    213. 

  213. 	defaults     	VARCHAR(250) DEFAULT NULL,

    214. 

  214. 	groupsids    	BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,

    215. 

  215. 	dateadded    	DATE NOT NULL,

    216. 

  216. 	reserve1     	VARCHAR(500) DEFAULT NULL,

    217. 

  217. 	intaddedby   	BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,

    218. 

  218. 	hierarchypath	VARCHAR(500) DEFAULT NULL,

    219. 

  219. 	reserve2     	VARCHAR(500) DEFAULT NULL

    220. 

  220. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    221. 

  221. 

    222. 

  222. CREATE TABLE history  (

    223. 

  223. 	ids       	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    224. 

  224. 	cname     	VARCHAR(250) NOT NULL,

    225. 

  225. 	username  	VARCHAR(250) NOT NULL,

    226. 

  226. 	dbidentity	VARCHAR(25) NOT NULL,

    227. 

  227. 	intitem   	SMALLINT NOT NULL,

    228. 

  228. 	groupsids 	BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,

    229. 

  229. 	dateadded 	DATE NOT NULL,

    230. 

  230. 	intaddedby	BIGINT(20) DEFAULT 0,

    231. 

  231. 	reserve1  	VARCHAR(500) DEFAULT NULL,

    232. 

  232. 	reserve2  	VARCHAR(500) DEFAULT NULL

    233. 

  233. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    234. 

  234. 

    235. 

  235. CREATE TABLE items  (

    236. 

  236. 	ids          	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    237. 

  237. 	cname        	VARCHAR(250) NOT NULL,

    238. 

  238. 	cnumber      	VARCHAR(250) NOT NULL,

    239. 

  239. 	description  	VARCHAR(2500) DEFAULT NULL,

    240. 

  240. 	groupsids    	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    241. 

  241. 	accountsids  	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    242. 

  242. 	contactsids  	BIGINT(20) UNSIGNED NOT NULL ,

    243. 

  243. 	netvalue     	DOUBLE DEFAULT 0,

    244. 

  244. 	taxvalue     	DOUBLE DEFAULT 0,

    245. 

  245. 	discountvalue	DOUBLE DEFAULT 0,

    246. 

  246. 	shippingvalue	DOUBLE DEFAULT 0,

    247. 

  247. 	datetodo     	DATE DEFAULT NULL,

    248. 

  248. 	dateend      	DATE DEFAULT NULL,

    249. 

  249. 	intreminders 	INTEGER DEFAULT 0,

    250. 

  250. 	inttype      	SMALLINT DEFAULT 0,

    251. 

  251. 	dateadded    	DATE NOT NULL,

    252. 

  252. 	intaddedby   	BIGINT(20) DEFAULT 0,

    253. 

  253. 	invisible    	SMALLINT DEFAULT 0,

    254. 

  254. 	intstatus    	SMALLINT DEFAULT 0,

    255. 

  255. 	hierarchypath	VARCHAR(500) DEFAULT NULL,

    256. 

  256. 	reserve1     	VARCHAR(500) DEFAULT NULL,

    257. 

  257. 	reserve2     	VARCHAR(500) DEFAULT NULL

    258. 

  258. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    259. 

  259. 

    260. 

  260. CREATE TABLE itemstoaccounts  (

    261. 

  261. 	ids        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    262. 

  262. 	itemsids   	BIGINT(20) UNSIGNED NOT NULL NOT NULL,

    263. 

  263. 	accountsids	BIGINT(20) UNSIGNED NOT NULL ,

    264. 

  264. 	reserve1   	VARCHAR(500) DEFAULT NULL,

    265. 

  265. 	reserve2   	VARCHAR(500) DEFAULT NULL

    266. 

  266. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    267. 

  267. 

    268. 

  268. CREATE TABLE languages  (

    269. 

  269. 	ids       	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    270. 

  270. 	cname     	VARCHAR(250) NOT NULL,

    271. 

  271. 	groupsids 	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    272. 

  272. 	longname  	VARCHAR(250) NOT NULL,

    273. 

  273. 	filename  	VARCHAR(25) NOT NULL,

    274. 

  274. 	dateadded 	DATE NOT NULL,

    275. 

  275. 	intaddedby	BIGINT(20) DEFAULT 0,

    276. 

  276. 	invisible 	SMALLINT DEFAULT 0,

    277. 

  277. 	reserve1  	VARCHAR(500) DEFAULT NULL,

    278. 

  278. 	reserve2  	VARCHAR(500) DEFAULT NULL

    279. 

  279. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    280. 

  280. 

    281. 

  281. CREATE TABLE mails  (

    282. 

  282. 	ids        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    283. 

  283. 	cname      	VARCHAR(1000) NOT NULL,

    284. 

  284. 	dateadded  	DATE NOT NULL,

    285. 

  285. 	intaddedby 	BIGINT(20) DEFAULT 0,

    286. 

  286. 	groupsids  	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    287. 

  287. 	invisible  	SMALLINT DEFAULT 0,

    288. 

  288. 	usersids   	BIGINT(20) UNSIGNED NOT NULL ,

    289. 

  289. 	description	VARCHAR(5000) NOT NULL

    290. 

  290. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    291. 

  291. 

    292. 

  292. CREATE TABLE plugins  (

    293. 

  293. 	ids        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    294. 

  294. 	cname      	VARCHAR(250) NOT NULL,

    295. 

  295. 	description	VARCHAR(550) DEFAULT NULL,

    296. 

  296. 	filename   	VARCHAR(25) NOT NULL,

    297. 

  297. 	intaddedby 	BIGINT(20) DEFAULT 0,

    298. 

  298. 	dateadded  	DATE NOT NULL,

    299. 

  299. 	groupsids  	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1

    300. 

  300. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    301. 

  301. 

    302. 

  302. CREATE TABLE pluginstousers  (

    303. 

  303. 	ids       	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    304. 

  304. 	cname     	VARCHAR(250) NOT NULL,

    305. 

  305. 	usersids  	BIGINT(20) UNSIGNED NOT NULL NOT NULL,

    306. 

  306. 	pluginsids	BIGINT(20) UNSIGNED NOT NULL NOT NULL,

    307. 

  307. 	intaddedby	BIGINT(20) DEFAULT 0,

    308. 

  308. 	dateadded 	DATE NOT NULL,

    309. 

  309. 	groupsids 	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1

    310. 

  310. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    311. 

  311. 

    312. 

  312. CREATE TABLE productgroups  (

    313. 

  313. 	ids             	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    314. 

  314. 	cname           	VARCHAR(250) NOT NULL,

    315. 

  315. 	description     	VARCHAR(750) DEFAULT NULL,

    316. 

  316. 	defaults        	VARCHAR(250) DEFAULT NULL,

    317. 

  317. 	groupsids       	BIGINT(20) UNSIGNED NOT NULL  DEFAULT 0,

    318. 

  318. 	productgroupsids	BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,

    319. 

  319. 	dateadded       	DATE NOT NULL,

    320. 

  320. 	hierarchypath   	VARCHAR(500) DEFAULT NULL,

    321. 

  321. 	reserve1        	VARCHAR(500) DEFAULT NULL,

    322. 

  322. 	intaddedby      	BIGINT(20) DEFAULT 0,

    323. 

  323. 	reserve2        	VARCHAR(500) DEFAULT NULL

    324. 

  324. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    325. 

  325. 

    326. 

  326. CREATE TABLE productlistitems  (

    327. 

  327. 	ids                	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    328. 

  328. 	cname              	VARCHAR(2500) DEFAULT NULL,

    329. 

  329. 	linkurl            	VARCHAR(250) DEFAULT NULL,

    330. 

  330. 	groupsids          	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    331. 

  331. 	productlistsids    	BIGINT(20) UNSIGNED NOT NULL ,

    332. 

  332. 	originalproductsids	BIGINT(20) UNSIGNED NOT NULL ,

    333. 

  333. 	countvalue         	DOUBLE NOT NULL DEFAULT 0,

    334. 

  334. 	quantityvalue      	DOUBLE NOT NULL DEFAULT 0,

    335. 

  335. 	measure            	VARCHAR(250) NOT NULL,

    336. 

  336. 	description        	VARCHAR(1000) DEFAULT NULL,

    337. 

  337. 	internalvalue      	DOUBLE DEFAULT 0,

    338. 

  338. 	totalnetvalue      	DOUBLE DEFAULT 0,

    339. 

  339. 	totalbrutvalue     	DOUBLE DEFAULT 0,

    340. 

  340. 	externalvalue      	DOUBLE DEFAULT 0,

    341. 

  341. 	taxpercentvalue    	DOUBLE NOT NULL DEFAULT 0,

    342. 

  342. 	dateadded          	DATE NOT NULL,

    343. 

  343. 	intaddedby         	BIGINT(20) DEFAULT 0,

    344. 

  344. 	invisible          	SMALLINT DEFAULT 0,

    345. 

  345. 	reserve1           	VARCHAR(500) DEFAULT NULL,

    346. 

  346. 	reserve2           	VARCHAR(500) DEFAULT NULL

    347. 

  347. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    348. 

  348. 

    349. 

  349. CREATE TABLE productlists  (

    350. 

  350. 	ids        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    351. 

  351. 	cname      	VARCHAR(2500) DEFAULT NULL,

    352. 

  352. 	groupsids  	BIGINT(20) UNSIGNED NOT NULL  DEFAULT 1,

    353. 

  353. 	description	VARCHAR(1000) DEFAULT NULL,

    354. 

  354. 	dateadded  	DATE NOT NULL,

    355. 

  355. 	intaddedby 	BIGINT(20) DEFAULT 0,

    356. 

  356. 	invisible  	SMALLINT DEFAULT 0,

    357. 

  357. 	reserve1   	VARCHAR(500) DEFAULT NULL,

    358. 

  358. 	reserve2   	VARCHAR(500) DEFAULT NULL

    359. 

  359. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    360. 

  360. 

    361. 

  361. CREATE TABLE products  (

    362. 

  362. 	ids             	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    363. 

  363. 	cname           	VARCHAR(500) NOT NULL,

    364. 

  364. 	cnumber         	VARCHAR(250) NOT NULL,

    365. 

  365. 	description     	VARCHAR(5000),

    366. 

  366. 	externalnetvalue	DOUBLE DEFAULT 0,

    367. 

  367. 	internalnetvalue	DOUBLE DEFAULT 0,

    368. 

  368. 	measure         	VARCHAR(250) NOT NULL,

    369. 

  369. 	taxids          	BIGINT(20) UNSIGNED NOT NULL ,

    370. 

  370. 	manufacturersids	BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,

    371. 

  371. 	suppliersids    	BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,

    372. 

  372. 	groupsids       	BIGINT(20) UNSIGNED NOT NULL  DEFAULT 1,

    373. 

  373. 	productgroupsids	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    374. 

  374. 	url             	VARCHAR(250) DEFAULT NULL,

    375. 

  375. 	ean             	VARCHAR(25) DEFAULT NULL,

    376. 

  376. 	reference       	VARCHAR(50) DEFAULT NULL,

    377. 

  377. 	dateadded       	DATE NOT NULL,

    378. 

  378. 	intaddedby      	BIGINT(20) DEFAULT 0,

    379. 

  379. 	invisible       	SMALLINT DEFAULT 0,

    380. 

  380. 	inttype         	SMALLINT NOT NULL,

    381. 

  381. 	defaultimage    	VARCHAR(30) DEFAULT NULL,

    382. 

  382. 	reserve1        	VARCHAR(500) DEFAULT NULL,

    383. 

  383. 	reserve2        	VARCHAR(500) DEFAULT NULL

    384. 

  384. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    385. 

  385. 

    386. 

  386. CREATE TABLE reminders  (

    387. 

  387. 	ids        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    388. 

  388. 	cname      	VARCHAR(250) NOT NULL,

    389. 

  389. 	description	VARCHAR(550) DEFAULT NULL,

    390. 

  390. 	stagesids  	BIGINT(20) UNSIGNED NOT NULL,

    391. 

  391. 	itemsids   	BIGINT(20) UNSIGNED NOT NULL,

    392. 

  392. 	extravalue 	DOUBLE DEFAULT 0,

    393. 

  393. 	intaddedby 	BIGINT(20) DEFAULT 0,

    394. 

  394. 	dateadded  	DATE NOT NULL,

    395. 

  395. 	groupsids  	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1

    396. 

  396. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    397. 

  397. 

    398. 

  398. CREATE TABLE revenues  (

    399. 

  399. 	ids            	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    400. 

  400. 	groupsids      	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    401. 

  401. 	cnumber        	VARCHAR(250) DEFAULT NULL,

    402. 

  402. 	cname          	VARCHAR(250) DEFAULT NULL,

    403. 

  403. 	accountsids    	BIGINT(20) UNSIGNED NOT NULL,

    404. 

  404. 	netvalue       	DOUBLE DEFAULT 0,

    405. 

  405. 	taxpercentvalue	DOUBLE DEFAULT 0,

    406. 

  406. 	brutvalue      	DOUBLE DEFAULT 0,

    407. 

  407. 	description    	VARCHAR(5000) DEFAULT NULL,

    408. 

  408. 	dateadded      	DATE NOT NULL,

    409. 

  409. 	intaddedby     	BIGINT(20) DEFAULT 0,

    410. 

  410. 	invisible      	SMALLINT DEFAULT 0,

    411. 

  411. 	reserve1       	VARCHAR(500) DEFAULT NULL,

    412. 

  412. 	reserve2       	VARCHAR(500) DEFAULT NULL

    413. 

  413. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    414. 

  414. 

    415. 

  415. CREATE TABLE schedule  (

    416. 

  416. 	ids          	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    417. 

  417. 	cname        	VARCHAR(250) NOT NULL,

    418. 

  418. 	groupsids    	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    419. 

  419. 	usersids     	BIGINT(20) UNSIGNED NOT NULL ,

    420. 

  420. 	itemsids     	BIGINT(20) UNSIGNED NOT NULL ,

    421. 

  421. 	stopdate     	DATE NOT NULL,

    422. 

  422. 	startdate    	DATE NOT NULL,

    423. 

  423. 	nextdate     	DATE NOT NULL,

    424. 

  424. 	isdone       	SMALLINT DEFAULT 0,

    425. 

  425. 	intervalmonth	SMALLINT NOT NULL,

    426. 

  426. 	dateadded    	DATE NOT NULL,

    427. 

  427. 	intaddedby   	BIGINT(20) DEFAULT 0,

    428. 

  428. 	invisible    	SMALLINT DEFAULT 0,

    429. 

  429. 	reserve1     	VARCHAR(500) DEFAULT NULL,

    430. 

  430. 	reserve2     	VARCHAR(500) DEFAULT NULL

    431. 

  431. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    432. 

  432. 

    433. 

  433. CREATE TABLE searchindex  (

    434. 

  434. 	ids       	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    435. 

  435. 	dbidentity	VARCHAR(25) NOT NULL,

    436. 

  436. 	groupsids 	BIGINT(20) UNSIGNED NOT NULL ,

    437. 

  437. 	rowid     	BIGINT(20) NOT NULL,

    438. 

  438. 	text      	VARCHAR(5000) DEFAULT NULL

    439. 

  439. 	)ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    440. 

  440. 

    441. 

  441. CREATE TABLE stages  (

    442. 

  442. 	ids        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    443. 

  443. 	cname      	VARCHAR(250) NOT NULL,

    444. 

  444. 	description	VARCHAR(550) DEFAULT NULL,

    445. 

  445. 	extravalue 	DOUBLE DEFAULT 0,

    446. 

  446. 	intaddedby 	BIGINT(20) DEFAULT 0,

    447. 

  447. 	dateadded  	DATE NOT NULL,

    448. 

  448. 	groupsids  	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1

    449. 

  449. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    450. 

  450. 

    451. 

  451. CREATE TABLE subitems  (

    452. 

  452. 	ids                	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    453. 

  453. 	cname              	VARCHAR(5000) DEFAULT NULL,

    454. 

  454. 	itemsids           	BIGINT(20) UNSIGNED NOT NULL ,

    455. 

  455. 	groupsids          	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    456. 

  456. 	originalproductsids	BIGINT(20) UNSIGNED DEFAULT NULL,

    457. 

  457. 	countvalue         	DOUBLE NOT NULL DEFAULT 0,

    458. 

  458. 	quantityvalue      	DOUBLE NOT NULL DEFAULT 0,

    459. 

  459. 	measure            	VARCHAR(250) NOT NULL,

    460. 

  460. 	linkurl            	VARCHAR(1000) DEFAULT NULL,

    461. 

  461. 	description        	VARCHAR(1000) DEFAULT NULL,

    462. 

  462. 	internalvalue      	DOUBLE DEFAULT 0,

    463. 

  463. 	totalnetvalue      	DOUBLE DEFAULT 0,

    464. 

  464. 	totalbrutvalue     	DOUBLE DEFAULT 0,

    465. 

  465. 	externalvalue      	DOUBLE DEFAULT 0,

    466. 

  466. 	taxpercentvalue    	DOUBLE NOT NULL DEFAULT 0,

    467. 

  467. 	datedelivery       	DATE DEFAULT NULL,

    468. 

  468. 	dateadded          	DATE NOT NULL,

    469. 

  469. 	intaddedby         	BIGINT(20) DEFAULT 0,

    470. 

  470. 	invisible          	SMALLINT DEFAULT 0,

    471. 

  471. 	reserve1           	VARCHAR(500) DEFAULT NULL,

    472. 

  472. 	reserve2           	VARCHAR(500) DEFAULT NULL

    473. 

  473. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    474. 

  474. 

    475. 

  475. CREATE TABLE tablelock  (

    476. 

  476. 	ids     	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    477. 

  477. 	cname   	VARCHAR(250),

    478. 

  478. 	rowid   	BIGINT(20) NOT NULL,

    479. 

  479. 	usersids	BIGINT(20) UNSIGNED NOT NULL ,

    480. 

  480. 	reserve1	VARCHAR(500) DEFAULT NULL,

    481. 

  481. 	reserve2	VARCHAR(500) DEFAULT NULL

    482. 

  482. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    483. 

  483. 

    484. 

  484. CREATE TABLE tax  (

    485. 

  485. 	ids       	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    486. 

  486. 	cname     	VARCHAR(250),

    487. 

  487. 	taxvalue  	DOUBLE DEFAULT 0,

    488. 

  488. 	identifier	VARCHAR(250) DEFAULT NULL,

    489. 

  489. 	groupsids 	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    490. 

  490. 	country   	VARCHAR(50) DEFAULT NULL,

    491. 

  491. 	dateadded 	DATE NOT NULL,

    492. 

  492. 	intaddedby	BIGINT(20) DEFAULT 0,

    493. 

  493. 	invisible 	SMALLINT DEFAULT 0,

    494. 

  494. 	reserve1  	VARCHAR(500) DEFAULT NULL,

    495. 

  495. 	reserve2  	VARCHAR(500) DEFAULT NULL

    496. 

  496. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    497. 

  497. 

    498. 

  498. CREATE TABLE templates  (

    499. 

  499. 	ids        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    500. 

  500. 	cname      	VARCHAR(250) NOT NULL,

    501. 

  501. 	format     	VARCHAR(55) DEFAULT NULL,

    502. 

  502. 	description	VARCHAR(550) DEFAULT NULL,

    503. 

  503. 	intsize    	BIGINT(20) DEFAULT 0,

    504. 

  504. 	mimetype   	VARCHAR(25) DEFAULT NULL,

    505. 

  505. 	filename   	VARCHAR(25) NOT NULL,

    506. 

  506. 	intaddedby 	BIGINT(20) DEFAULT 0,

    507. 

  507. 	dateadded  	DATE NOT NULL,

    508. 

  508. 	groupsids  	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1

    509. 

  509. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    510. 

  510. 

    511. 

  511. CREATE TABLE templatestousers  (

    512. 

  512. 	ids         	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    513. 

  513. 	cname       	VARCHAR(250) NOT NULL,

    514. 

  514. 	usersids    	BIGINT(20) UNSIGNED NOT NULL ,

    515. 

  515. 	templatesids	BIGINT(20) UNSIGNED NOT NULL NOT NULL,

    516. 

  516. 	groupsids   	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1

    517. 

  517. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    518. 

  518. 

    519. 

  519. CREATE TABLE trashbin  (

    520. 

  520. 	ids        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    521. 

  521. 	cname      	VARCHAR(500),

    522. 

  522. 	rowid      	BIGINT(20) NOT NULL,

    523. 

  523. 	description	VARCHAR(2500),

    524. 

  524. 	deleteme   	SMALLINT DEFAULT 1,

    525. 

  525. 	reserve1   	VARCHAR(500) DEFAULT NULL,

    526. 

  526. 	reserve2   	VARCHAR(500) DEFAULT NULL

    527. 

  527. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    528. 

  528. 

    529. 

  529. CREATE TABLE userproperties  (

    530. 

  530. 	ids       	BIGINT(20) DEFAULT 1,

    531. 

  531. 	cname     	VARCHAR(250) NOT NULL,

    532. 

  532. 	value     	VARCHAR(250) NOT NULL,

    533. 

  533. 	usersids  	BIGINT(20) UNSIGNED NOT NULL NOT NULL,

    534. 

  534. 	dateadded 	DATE NOT NULL,

    535. 

  535. 	intaddedby	BIGINT(20) DEFAULT 0,

    536. 

  536. 	groupsids 	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    537. 

  537. 	invisible 	SMALLINT DEFAULT 0

    538. 

  538. 	)ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    539. 

  539. 

    540. 

  540. CREATE TABLE users  (

    541. 

  541. 	ids              	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    542. 

  542. 	cname            	VARCHAR(250) NOT NULL,

    543. 

  543. 	groupsids        	BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,

    544. 

  544. 	intdefaultaccount	BIGINT(20) DEFAULT 1,

    545. 

  545. 	compsids         	BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,

    546. 

  546. 	intdefaultstatus 	BIGINT(20) DEFAULT 1,

    547. 

  547. 	fullname         	VARCHAR(250) NOT NULL,

    548. 

  548. 	password         	VARCHAR(250) NOT NULL,

    549. 

  549. 	laf              	VARCHAR(50) DEFAULT NULL,

    550. 

  550. 	locale           	VARCHAR(50) DEFAULT NULL,

    551. 

  551. 	defcountry       	VARCHAR(50) DEFAULT NULL,

    552. 

  552. 	mail             	VARCHAR(50) DEFAULT NULL,

    553. 

  553. 	language         	VARCHAR(50) DEFAULT NULL,

    554. 

  554. 	inthighestright  	SMALLINT DEFAULT 3,

    555. 

  555. 	isenabled        	SMALLINT DEFAULT 1,

    556. 

  556. 	isrgrouped       	SMALLINT DEFAULT 0,

    557. 

  557. 	isloggedin       	SMALLINT DEFAULT 0,

    558. 

  558. 	datelastlog      	DATE DEFAULT NULL,

    559. 

  559. 	dateadded        	DATE NOT NULL,

    560. 

  560. 	intaddedby       	BIGINT(20) DEFAULT 0,

    561. 

  561. 	invisible        	SMALLINT DEFAULT 0,

    562. 

  562. 	reserve1         	VARCHAR(500) DEFAULT NULL,

    563. 

  563. 	reserve2         	VARCHAR(500) DEFAULT NULL

    564. 

  564. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    565. 

  565. 

    566. 

  566. CREATE TABLE webshops  (

    567. 

  567. 	ids                 	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    568. 

  568. 	cname               	VARCHAR(250) NOT NULL,

    569. 

  569. 	description         	VARCHAR(750) DEFAULT NULL,

    570. 

  570. 	groupsids           	BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,

    571. 

  571. 	dateadded           	DATE NOT NULL,

    572. 

  572. 	isrequestcompression	SMALLINT DEFAULT 0,

    573. 

  573. 	isauthenticated     	SMALLINT DEFAULT 0,

    574. 

  574. 	username            	VARCHAR(50) DEFAULT NULL,

    575. 

  575. 	passw               	VARCHAR(50) DEFAULT NULL,

    576. 

  576. 	reserve1            	VARCHAR(500) DEFAULT NULL,

    577. 

  577. 	intaddedby          	BIGINT(20) DEFAULT 0,

    578. 

  578. 	interv               	BIGINT(20) DEFAULT 0,

    579. 

  579. 	url                 	VARCHAR(500) DEFAULT NULL,

    580. 

  580. 	reserve2            	VARCHAR(500) DEFAULT NULL

    581. 

  581. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    582. 

  582. 

    583. 

  583. CREATE TABLE wscontactsmapping  (

    584. 

  584. 	ids        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    585. 

  585. 	webshopsids	BIGINT(20) UNSIGNED NOT NULL ,

    586. 

  586. 	cname      	VARCHAR(250) NOT NULL,

    587. 

  587. 	groupsids  	BIGINT(20) UNSIGNED NOT NULL ,

    588. 

  588. 	contactsids	BIGINT(20) UNSIGNED NOT NULL ,

    589. 

  589. 	wscontact  	VARCHAR(250) NOT NULL,

    590. 

  590. 	dateadded  	DATE DEFAULT NULL,

    591. 

  591. 	intaddedby 	BIGINT(20) DEFAULT 0,

    592. 

  592. 	invisible  	SMALLINT DEFAULT 0,

    593. 

  593. 	reserve1   	VARCHAR(500) DEFAULT NULL,

    594. 

  594. 	reserve2   	VARCHAR(500) DEFAULT NULL

    595. 

  595. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    596. 

  596. 

    597. 

  597. CREATE TABLE wsitemsmapping  (

    598. 

  598. 	ids        	BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY auto_increment,

    599. 

  599. 	webshopsids	BIGINT(20) UNSIGNED NOT NULL ,

    600. 

  600. 	cname      	VARCHAR(250) NOT NULL,

    601. 

  601. 	groupsids  	BIGINT(20) UNSIGNED NOT NULL ,

    602. 

  602. 	itemsids   	BIGINT(20) UNSIGNED NOT NULL ,

    603. 

  603. 	wsitem     	VARCHAR(250) NOT NULL,

    604. 

  604. 	dateadded  	DATE DEFAULT NULL,

    605. 

  605. 	intaddedby 	BIGINT(20) DEFAULT 0,

    606. 

  606. 	invisible  	SMALLINT DEFAULT 0,

    607. 

  607. 	reserve1   	VARCHAR(500) DEFAULT NULL,

    608. 

  608. 	reserve2   	VARCHAR(500) DEFAULT NULL

    609. 

  609. )ENGINE=MyISAM  DEFAULT CHARSET=utf8;

    610. 

  610. 

    611. 

  611. CREATE UNIQUE INDEX SQL091006084310810

    612. 

  612. 	ON groups(cname);

    613. 

  613. 

    614. 

  614. CREATE UNIQUE INDEX SQL091006084310820

    615. 

  615. 	ON groups(ids);

    616. 

  616. 

    617. 

  617. CREATE UNIQUE INDEX SQL091006084311391

    618. 

  618. 	ON productgroups(cname, groupsids);

    619. 

  619. 

    620. 

  620. CREATE UNIQUE INDEX SQL091006084311390

    621. 

  621. 	ON productgroups(ids);

    622. 

  622. 

    623. 

  623. CREATE UNIQUE INDEX SQL091006084311800

    624. 

  624. 	ON history(ids);

    625. 

  625. 

    626. 

  626. CREATE UNIQUE INDEX SQL091006084312110

    627. 

  627. 	ON countries(iso);

    628. 

  628. 

    629. 

  629. CREATE UNIQUE INDEX SQL091006084312111

    630. 

  630. 	ON countries(ids);

    631. 

  631. 

    632. 

  632. CREATE UNIQUE INDEX SQL091006084312620

    633. 

  633. 	ON globalsettings(cname, groupsids);

    634. 

  634. 

    635. 

  635. CREATE UNIQUE INDEX SQL091006084312900

    636. 

  636. 	ON tax(ids);

    637. 

  637. 

    638. 

  638. CREATE INDEX SQL091006084312890

    639. 

  639. 	ON tax(groupsids);

    640. 

  640. 

    641. 

  641. CREATE UNIQUE INDEX SQL091006084313452

    642. 

  642. 	ON contacts(cnumber, groupsids);

    643. 

  643. 

    644. 

  644. CREATE UNIQUE INDEX SQL091006084313451

    645. 

  645. 	ON contacts(ids);

    646. 

  646. 

    647. 

  647. CREATE INDEX SQL091006084313450

    648. 

  648. 	ON contacts(groupsids);

    649. 

  649. 

    650. 

  650. CREATE UNIQUE INDEX SQL091006084313971

    651. 

  651. 	ON users(cname, groupsids);

    652. 

  652. 

    653. 

  653. CREATE UNIQUE INDEX SQL091006084313970

    654. 

  654. 	ON users(ids);

    655. 

  655. 

    656. 

  656. CREATE INDEX SQL091006084313960

    657. 

  657. 	ON users(groupsids);

    658. 

  658. 

    659. 

  659. CREATE UNIQUE INDEX SQL091006084314570

    660. 

  660. 	ON files(cname);

    661. 

  661. 

    662. 

  662. CREATE UNIQUE INDEX SQL091006084314572

    663. 

  663. 	ON files(ids);

    664. 

  664. 

    665. 

  665. CREATE INDEX SQL091006084314571

    666. 

  666. 	ON files(groupsids);

    667. 

  667. 

    668. 

  668. CREATE UNIQUE INDEX SQL091006084315174

    669. 

  669. 	ON languages(cname, groupsids);

    670. 

  670. 

    671. 

  671. CREATE UNIQUE INDEX SQL091006084315171

    672. 

  672. 	ON languages(longname);

    673. 

  673. 

    674. 

  674. CREATE UNIQUE INDEX SQL091006084315173

    675. 

  675. 	ON languages(ids);

    676. 

  676. 

    677. 

  677. CREATE INDEX SQL091006084315170

    678. 

  678. 	ON languages(groupsids);

    679. 

  679. 

    680. 

  680. CREATE INDEX SQL091006084315172

    681. 

  681. 	ON languages(filename);

    682. 

  682. 

    683. 

  683. CREATE UNIQUE INDEX SQL091006084315882

    684. 

  684. 	ON favourites(ids);

    685. 

  685. 

    686. 

  686. CREATE INDEX SQL091006084315880

    687. 

  687. 	ON favourites(usersids);

    688. 

  688. 

    689. 

  689. CREATE INDEX SQL091006084315881

    690. 

  690. 	ON favourites(groupsids);

    691. 

  691. 

    692. 

  692. CREATE UNIQUE INDEX SQL091006084316451

    693. 

  693. 	ON accounts(ids);

    694. 

  694. 

    695. 

  695. CREATE INDEX SQL091006084316450

    696. 

  696. 	ON accounts(groupsids);

    697. 

  697. 

    698. 

  698. CREATE UNIQUE INDEX SQL091006084316862

    699. 

  699. 	ON items(cnumber, inttype);

    700. 

  700. 

    701. 

  701. CREATE UNIQUE INDEX SQL091006084316861

    702. 

  702. 	ON items(ids);

    703. 

  703. 

    704. 

  704. CREATE INDEX SQL091006084316850

    705. 

  705. 	ON items(groupsids);

    706. 

  706. 

    707. 

  707. CREATE INDEX SQL091006084316851

    708. 

  708. 	ON items(accountsids);

    709. 

  709. 

    710. 

  710. CREATE INDEX SQL091006084316860

    711. 

  711. 	ON items(contactsids);

    712. 

  712. 

    713. 

  713. CREATE UNIQUE INDEX SQL091006084317902

    714. 

  714. 	ON subitems(ids);

    715. 

  715. 

    716. 

  716. CREATE INDEX SQL091006084317900

    717. 

  717. 	ON subitems(itemsids);

    718. 

  718. 

    719. 

  719. CREATE INDEX SQL091006084317901

    720. 

  720. 	ON subitems(groupsids);

    721. 

  721. 

    722. 

  722. CREATE UNIQUE INDEX SQL091006084318483

    723. 

  723. 	ON schedule(ids);

    724. 

  724. 

    725. 

  725. CREATE INDEX SQL091006084318480

    726. 

  726. 	ON schedule(groupsids);

    727. 

  727. 

    728. 

  728. CREATE INDEX SQL091006084318481

    729. 

  729. 	ON schedule(usersids);

    730. 

  730. 

    731. 

  731. CREATE INDEX SQL091006084318482

    732. 

  732. 	ON schedule(itemsids);

    733. 

  733. 

    734. 

  734. CREATE UNIQUE INDEX SQL091006084319621

    735. 

  735. 	ON products(cnumber, groupsids);

    736. 

  736. 

    737. 

  737. CREATE UNIQUE INDEX SQL091006084319620

    738. 

  738. 	ON products(ids);

    739. 

  739. 

    740. 

  740. CREATE INDEX SQL091006084319610

    741. 

  741. 	ON products(taxids);

    742. 

  742. 

    743. 

  743. CREATE INDEX SQL091006084319611

    744. 

  744. 	ON products(groupsids);

    745. 

  745. 

    746. 

  746. CREATE INDEX SQL091006084319612

    747. 

  747. 	ON products(productgroupsids);

    748. 

  748. 

    749. 

  749. CREATE UNIQUE INDEX SQL091006084320591

    750. 

  750. 	ON productlists(ids);

    751. 

  751. 

    752. 

  752. CREATE INDEX SQL091006084320590

    753. 

  753. 	ON productlists(groupsids);

    754. 

  754. 

    755. 

  755. CREATE UNIQUE INDEX SQL091006084321141

    756. 

  756. 	ON productlistitems(ids);

    757. 

  757. 

    758. 

  758. CREATE INDEX SQL091006084321130

    759. 

  759. 	ON productlistitems(groupsids);

    760. 

  760. 

    761. 

  761. CREATE INDEX SQL091006084321131

    762. 

  762. 	ON productlistitems(productlistsids);

    763. 

  763. 

    764. 

  764. CREATE INDEX SQL091006084321140

    765. 

  765. 	ON productlistitems(originalproductsids);

    766. 

  766. 

    767. 

  767. CREATE INDEX SQL091006084322190

    768. 

  768. 	ON userproperties(groupsids);

    769. 

  769. 

    770. 

  770. CREATE UNIQUE INDEX SQL091006084322552

    771. 

  771. 	ON mails(ids);

    772. 

  772. 

    773. 

  773. CREATE INDEX SQL091006084322550

    774. 

  774. 	ON mails(groupsids);

    775. 

  775. 

    776. 

  776. CREATE INDEX SQL091006084322551

    777. 

  777. 	ON mails(usersids);

    778. 

  778. 

    779. 

  779. CREATE UNIQUE INDEX SQL091006084323381

    780. 

  780. 	ON comps(ids);

    781. 

  781. 

    782. 

  782. CREATE INDEX SQL091006084323380

    783. 

  783. 	ON comps(groupsids);

    784. 

  784. 

    785. 

  785. CREATE UNIQUE INDEX SQL091006084324160

    786. 

  786. 	ON expenses(ids);

    787. 

  787. 

    788. 

  788. CREATE INDEX SQL091006084324140

    789. 

  789. 	ON expenses(groupsids);

    790. 

  790. 

    791. 

  791. CREATE INDEX SQL091006084324141

    792. 

  792. 	ON expenses(accountsids);

    793. 

  793. 

    794. 

  794. CREATE UNIQUE INDEX SQL091006084324810

    795. 

  795. 	ON revenues(ids);

    796. 

  796. 

    797. 

  797. CREATE INDEX SQL091006084324790

    798. 

  798. 	ON revenues(groupsids);

    799. 

  799. 

    800. 

  800. CREATE INDEX SQL091006084324800

    801. 

  801. 	ON revenues(accountsids);

    802. 

  802. 

    803. 

  803. CREATE UNIQUE INDEX SQL091006084325551

    804. 

  804. 	ON webshops(cname, groupsids);

    805. 

  805. 

    806. 

  806. CREATE UNIQUE INDEX SQL091006084325550

    807. 

  807. 	ON webshops(ids);

    808. 

  808. 

    809. 

  809. CREATE UNIQUE INDEX SQL091006084326054

    810. 

  810. 	ON wscontactsmapping(wscontact, groupsids, webshopsids);

    811. 

  811. 

    812. 

  812. CREATE UNIQUE INDEX SQL091006084326053

    813. 

  813. 	ON wscontactsmapping(ids);

    814. 

  814. 

    815. 

  815. CREATE INDEX SQL091006084326050

    816. 

  816. 	ON wscontactsmapping(webshopsids);

    817. 

  817. 

    818. 

  818. CREATE INDEX SQL091006084326051

    819. 

  819. 	ON wscontactsmapping(groupsids);

    820. 

  820. 

    821. 

  821. CREATE INDEX SQL091006084326052

    822. 

  822. 	ON wscontactsmapping(contactsids);

    823. 

  823. 

    824. 

  824. CREATE UNIQUE INDEX SQL091006084326881

    825. 

  825. 	ON wsitemsmapping(wsitem, groupsids, webshopsids);

    826. 

  826. 

    827. 

  827. CREATE UNIQUE INDEX SQL091006084326880

    828. 

  828. 	ON wsitemsmapping(ids);

    829. 

  829. 

    830. 

  830. CREATE INDEX SQL091006084326870

    831. 

  831. 	ON wsitemsmapping(webshopsids);

    832. 

  832. 

    833. 

  833. CREATE INDEX SQL091006084326871

    834. 

  834. 	ON wsitemsmapping(groupsids);

    835. 

  835. 

    836. 

  836. CREATE INDEX SQL091006084326872

    837. 

  837. 	ON wsitemsmapping(itemsids);

    838. 

  838. 

    839. 

  839. CREATE UNIQUE INDEX SQL091006084327910

    840. 

  840. 	ON tablelock(ids);

    841. 

  841. 

    842. 

  842. CREATE UNIQUE INDEX SQL091006084327911

    843. 

  843. 	ON tablelock(cname, rowid);

    844. 

  844. 

    845. 

  845. CREATE INDEX SQL091006084327890

    846. 

  846. 	ON tablelock(usersids);

    847. 

  847. 

    848. 

  848. CREATE UNIQUE INDEX SQL091006084328480

    849. 

  849. 	ON itemstoaccounts(ids);

    850. 

  850. 

    851. 

  851. CREATE INDEX SQL091006084328460

    852. 

  852. 	ON itemstoaccounts(itemsids);

    853. 

  853. 

    854. 

  854. CREATE INDEX SQL091006084328461

    855. 

  855. 	ON itemstoaccounts(accountsids);

    856. 

  856. 

    857. 

  857. CREATE UNIQUE INDEX SQL091006084329120

    858. 

  858. 	ON trashbin(ids);

    859. 

  859. 

    860. 

  860. CREATE UNIQUE INDEX SQL091006084329671

    861. 

  861. 	ON filestocontacts(ids);

    862. 

  862. 

    863. 

  863. CREATE INDEX SQL091006084329650

    864. 

  864. 	ON filestocontacts(contactsids);

    865. 

  865. 

    866. 

  866. CREATE INDEX SQL091006084329651

    867. 

  867. 	ON filestocontacts(filename);

    868. 

  868. 

    869. 

  869. CREATE INDEX SQL091006084329670

    870. 

  870. 	ON filestocontacts(groupsids);

    871. 

  871. 

    872. 

  872. CREATE UNIQUE INDEX SQL091006084330492

    873. 

  873. 	ON templates(ids);

    874. 

  874. 

    875. 

  875. CREATE INDEX SQL091006084330490

    876. 

  876. 	ON templates(filename);

    877. 

  877. 

    878. 

  878. CREATE INDEX SQL091006084330491

    879. 

  879. 	ON templates(groupsids);

    880. 

  880. 

    881. 

  881. CREATE UNIQUE INDEX SQL091006084331263

    882. 

  882. 	ON filestoitems(ids);

    883. 

  883. 

    884. 

  884. CREATE INDEX SQL091006084331260

    885. 

  885. 	ON filestoitems(itemsids);

    886. 

  886. 

    887. 

  887. CREATE INDEX SQL091006084331261

    888. 

  888. 	ON filestoitems(filename);

    889. 

  889. 

    890. 

  890. CREATE INDEX SQL091006084331262

    891. 

  891. 	ON filestoitems(groupsids);

    892. 

  892. 

    893. 

  893. CREATE UNIQUE INDEX SQL091006084332163

    894. 

  894. 	ON filestoproducts(ids);

    895. 

  895. 

    896. 

  896. CREATE INDEX SQL091006084332160

    897. 

  897. 	ON filestoproducts(productsids);

    898. 

  898. 

    899. 

  899. CREATE INDEX SQL091006084332161

    900. 

  900. 	ON filestoproducts(filename);

    901. 

  901. 

    902. 

  902. CREATE INDEX SQL091006084332162

    903. 

  903. 	ON filestoproducts(groupsids);

    904. 

  904. 

    905. 

  905. CREATE UNIQUE INDEX SQL091006084333560

    906. 

  906. 	ON plugins(ids);

    907. 

  907. 

    908. 

  908. CREATE INDEX SQL091006084333550

    909. 

  909. 	ON plugins(filename);

    910. 

  910. 

    911. 

  911. CREATE INDEX SQL091006084333551

    912. 

  912. 	ON plugins(groupsids);

    913. 

  913. 

    914. 

  914. CREATE UNIQUE INDEX SQL091006084334241

    915. 

  915. 	ON pluginstousers(ids);

    916. 

  916. 

    917. 

  917. CREATE INDEX SQL091006084334230

    918. 

  918. 	ON pluginstousers(pluginsids);

    919. 

  919. 

    920. 

  920. CREATE INDEX SQL091006084334240

    921. 

  921. 	ON pluginstousers(groupsids);

    922. 

  922. 

    923. 

  923. CREATE UNIQUE INDEX SQL091006084334891

    924. 

  924. 	ON formatstousers(ids);

    925. 

  925. 

    926. 

  926. CREATE INDEX SQL091006084334890

    927. 

  927. 	ON formatstousers(usersids);

    928. 

  928. 

    929. 

  929. CREATE UNIQUE INDEX SQL091006084335461

    930. 

  930. 	ON templatestousers(ids);

    931. 

  931. 

    932. 

  932. CREATE INDEX SQL091006084335450

    933. 

  933. 	ON templatestousers(usersids);

    934. 

  934. 

    935. 

  935. CREATE INDEX SQL091006084335451

    936. 

  936. 	ON templatestousers(templatesids);

    937. 

  937. 

    938. 

  938. CREATE INDEX SQL091006084335460

    939. 

  939. 	ON templatestousers(groupsids);

    940. 

  940. 

    941. 

  941. CREATE UNIQUE INDEX SQL091006084336332

    942. 

  942. 	ON addresses(ids);

    943. 

  943. 

    944. 

  944. CREATE INDEX SQL091006084336330

    945. 

  945. 	ON addresses(groupsids);

    946. 

  946. 

    947. 

  947. CREATE INDEX SQL091006084336331

    948. 

  948. 	ON addresses(contactsids);

    949. 

  949. 

    950. 

  950. CREATE UNIQUE INDEX SQL091006084336882

    951. 

  951. 	ON reminders(ids);

    952. 

  952. 

    953. 

  953. CREATE INDEX SQL091006084336880

    954. 

  954. 	ON reminders(itemsids);

    955. 

  955. 

    956. 

  956. CREATE INDEX SQL091006084336881

    957. 

  957. 	ON reminders(groupsids);

    958. 

  958. 

    959. 

  959. CREATE UNIQUE INDEX SQL091006084337581

    960. 

  960. 	ON stages(ids);

    961. 

  961. 

    962. 

  962. CREATE INDEX SQL091006084337580

    963. 

  963. 	ON stages(groupsids);

    964. 

  964. 

    965. 

  965. ALTER TABLE contacts

    966. 

  966. 	ADD CONSTRAINT CONST3

    967. 

  967. 	 UNIQUE (cnumber, groupsids) ;

    968. 

  968. 

    969. 

  969. ALTER TABLE countries

    970. 

  970. 	ADD CONSTRAINT SQL0910060843121101

    971. 

  971. 	 UNIQUE (iso) ;

    972. 

  972. 

    973. 

  973. ALTER TABLE files

    974. 

  974. 	ADD CONSTRAINT SQL0910060843145701

    975. 

  975. 	 UNIQUE (cname) ;

    976. 

  976. 

    977. 

  977. ALTER TABLE globalsettings

    978. 

  978. 	ADD CONSTRAINT CONST2

    979. 

  979. 	 UNIQUE (cname, groupsids) ;

    980. 

  980. 

    981. 

  981. ALTER TABLE groups

    982. 

  982. 	ADD CONSTRAINT SQL0910060843108101

    983. 

  983. 	 UNIQUE (cname) ;

    984. 

  984. 

    985. 

  985. ALTER TABLE items

    986. 

  986. 	ADD CONSTRAINT CONST7

    987. 

  987. 	 UNIQUE (cnumber, inttype) ;

    988. 

  988. 

    989. 

  989. ALTER TABLE languages

    990. 

  990. 	ADD CONSTRAINT SQL0910060843151711

    991. 

  991. 	 UNIQUE (longname) ;

    992. 

  992. 

    993. 

  993. ALTER TABLE languages

    994. 

  994. 	ADD CONSTRAINT CONST6

    995. 

  995. 	 UNIQUE (cname, groupsids) ;

    996. 

  996. 

    997. 

  997. ALTER TABLE productgroups

    998. 

  998. 	ADD CONSTRAINT CONST1

    999. 

  999. 	 UNIQUE (cname, groupsids) ;

    1000. 

  1000. 

    1001. 

  1001. ALTER TABLE products

    1002. 

  1002. 	ADD CONSTRAINT CONST8

    1003. 

  1003. 	 UNIQUE (cnumber, groupsids) ;

    1004. 

  1004. 

    1005. 

  1005. ALTER TABLE tablelock

    1006. 

  1006. 	ADD CONSTRAINT ONE_LOCK

    1007. 

  1007. 	 UNIQUE (cname, rowid) ;

    1008. 

  1008. 

    1009. 

  1009. ALTER TABLE users

    1010. 

  1010. 	ADD CONSTRAINT CONST4

    1011. 

  1011. 	 UNIQUE (cname, groupsids) ;

    1012. 

  1012. 

    1013. 

  1013. ALTER TABLE webshops

    1014. 

  1014. 	ADD CONSTRAINT CONST9

    1015. 

  1015. 	 UNIQUE (cname, groupsids) ;

    1016. 

  1016. 

    1017. 

  1017. ALTER TABLE wscontactsmapping

    1018. 

  1018. 	ADD CONSTRAINT CONST10

    1019. 

  1019. 	 UNIQUE (wscontact, groupsids, webshopsids) ;

    1020. 

  1020. 

    1021. 

  1021. ALTER TABLE wsitemsmapping

    1022. 

  1022. 	ADD CONSTRAINT CONST11

    1023. 

  1023. 	 UNIQUE (wsitem, groupsids, webshopsids) ;

    1024. 

  1024. 

    1025. 

  1025. ALTER TABLE accounts

    1026. 

  1026. 	ADD CONSTRAINT SQL0910060843164501

    1027. 

  1027. 	FOREIGN KEY(groupsids)

    1028. 

  1028. 	REFERENCES groups(ids);

    1029. 

  1029. 

    1030. 

  1030. ALTER TABLE addresses

    1031. 

  1031. 	ADD CONSTRAINT SQL0910060843363311

    1032. 

  1032. 	FOREIGN KEY(contactsids)

    1033. 

  1033. 	REFERENCES contacts(ids);

    1034. 

  1034. 

    1035. 

  1035. ALTER TABLE addresses

    1036. 

  1036. 	ADD CONSTRAINT SQL0910060843363301

    1037. 

  1037. 	FOREIGN KEY(groupsids)

    1038. 

  1038. 	REFERENCES groups(ids);

    1039. 

  1039. 

    1040. 

  1040. ALTER TABLE comps

    1041. 

  1041. 	ADD CONSTRAINT SQL0910060843233801

    1042. 

  1042. 	FOREIGN KEY(groupsids)

    1043. 

  1043. 	REFERENCES groups(ids);

    1044. 

  1044. 

    1045. 

  1045. ALTER TABLE contacts

    1046. 

  1046. 	ADD CONSTRAINT SQL0910060843134501

    1047. 

  1047. 	FOREIGN KEY(groupsids)

    1048. 

  1048. 	REFERENCES groups(ids);

    1049. 

  1049. 

    1050. 

  1050. ALTER TABLE expenses

    1051. 

  1051. 	ADD CONSTRAINT SQL0910060843241411

    1052. 

  1052. 	FOREIGN KEY(accountsids)

    1053. 

  1053. 	REFERENCES accounts(ids);

    1054. 

  1054. 

    1055. 

  1055. ALTER TABLE expenses

    1056. 

  1056. 	ADD CONSTRAINT SQL0910060843241401

    1057. 

  1057. 	FOREIGN KEY(groupsids)

    1058. 

  1058. 	REFERENCES groups(ids);

    1059. 

  1059. 

    1060. 

  1060. ALTER TABLE favourites

    1061. 

  1061. 	ADD CONSTRAINT SQL0910060843158811

    1062. 

  1062. 	FOREIGN KEY(groupsids)

    1063. 

  1063. 	REFERENCES groups(ids);

    1064. 

  1064. 

    1065. 

  1065. ALTER TABLE favourites

    1066. 

  1066. 	ADD CONSTRAINT SQL0910060843158801

    1067. 

  1067. 	FOREIGN KEY(usersids)

    1068. 

  1068. 	REFERENCES users(ids)

    1069. 

  1069. 	ON DELETE CASCADE ;

    1070. 

  1070. 

    1071. 

  1071. ALTER TABLE files

    1072. 

  1072. 	ADD CONSTRAINT SQL0910060843145711

    1073. 

  1073. 	FOREIGN KEY(groupsids)

    1074. 

  1074. 	REFERENCES groups(ids);

    1075. 

  1075. 

    1076. 

  1076. ALTER TABLE filestocontacts

    1077. 

  1077. 	ADD CONSTRAINT SQL0910060843296701

    1078. 

  1078. 	FOREIGN KEY(groupsids)

    1079. 

  1079. 	REFERENCES groups(ids);

    1080. 

  1080. 

    1081. 

  1081. ALTER TABLE filestocontacts

    1082. 

  1082. 	ADD CONSTRAINT SQL0910060843296511

    1083. 

  1083. 	FOREIGN KEY(filename)

    1084. 

  1084. 	REFERENCES files(cname)

    1085. 

  1085. 	ON DELETE CASCADE ;

    1086. 

  1086. 

    1087. 

  1087. ALTER TABLE filestocontacts

    1088. 

  1088. 	ADD CONSTRAINT SQL0910060843296501

    1089. 

  1089. 	FOREIGN KEY(contactsids)

    1090. 

  1090. 	REFERENCES contacts(ids)

    1091. 

  1091. 	ON DELETE CASCADE ;

    1092. 

  1092. 

    1093. 

  1093. ALTER TABLE filestoitems

    1094. 

  1094. 	ADD CONSTRAINT SQL0910060843312621

    1095. 

  1095. 	FOREIGN KEY(groupsids)

    1096. 

  1096. 	REFERENCES groups(ids);

    1097. 

  1097. 

    1098. 

  1098. ALTER TABLE filestoitems

    1099. 

  1099. 	ADD CONSTRAINT SQL0910060843312611

    1100. 

  1100. 	FOREIGN KEY(filename)

    1101. 

  1101. 	REFERENCES files(cname)

    1102. 

  1102. 	ON DELETE CASCADE ;

    1103. 

  1103. 

    1104. 

  1104. ALTER TABLE filestoitems

    1105. 

  1105. 	ADD CONSTRAINT SQL0910060843312601

    1106. 

  1106. 	FOREIGN KEY(itemsids)

    1107. 

  1107. 	REFERENCES items(ids)

    1108. 

  1108. 	ON DELETE CASCADE ;

    1109. 

  1109. 

    1110. 

  1110. ALTER TABLE filestoproducts

    1111. 

  1111. 	ADD CONSTRAINT SQL0910060843321621

    1112. 

  1112. 	FOREIGN KEY(groupsids)

    1113. 

  1113. 	REFERENCES groups(ids);

    1114. 

  1114. 

    1115. 

  1115. ALTER TABLE filestoproducts

    1116. 

  1116. 	ADD CONSTRAINT SQL0910060843321611

    1117. 

  1117. 	FOREIGN KEY(filename)

    1118. 

  1118. 	REFERENCES files(cname)

    1119. 

  1119. 	ON DELETE CASCADE ;

    1120. 

  1120. 

    1121. 

  1121. ALTER TABLE filestoproducts

    1122. 

  1122. 	ADD CONSTRAINT SQL0910060843321601

    1123. 

  1123. 	FOREIGN KEY(productsids)

    1124. 

  1124. 	REFERENCES products(ids)

    1125. 

  1125. 	ON DELETE CASCADE ;

    1126. 

  1126. 

    1127. 

  1127. ALTER TABLE formatstousers

    1128. 

  1128. 	ADD CONSTRAINT SQL0910060843348901

    1129. 

  1129. 	FOREIGN KEY(usersids)

    1130. 

  1130. 	REFERENCES users(ids)

    1131. 

  1131. 	ON DELETE CASCADE ;

    1132. 

  1132. 

    1133. 

  1133. ALTER TABLE items

    1134. 

  1134. 	ADD CONSTRAINT SQL0910060843168601

    1135. 

  1135. 	FOREIGN KEY(contactsids)

    1136. 

  1136. 	REFERENCES contacts(ids)

    1137. 

  1137. 	ON DELETE CASCADE ;

    1138. 

  1138. 

    1139. 

  1139. ALTER TABLE items

    1140. 

  1140. 	ADD CONSTRAINT SQL0910060843168511

    1141. 

  1141. 	FOREIGN KEY(accountsids)

    1142. 

  1142. 	REFERENCES accounts(ids);

    1143. 

  1143. 

    1144. 

  1144. ALTER TABLE items

    1145. 

  1145. 	ADD CONSTRAINT SQL0910060843168501

    1146. 

  1146. 	FOREIGN KEY(groupsids)

    1147. 

  1147. 	REFERENCES groups(ids);

    1148. 

  1148. 

    1149. 

  1149. ALTER TABLE itemstoaccounts

    1150. 

  1150. 	ADD CONSTRAINT SQL0910060843284611

    1151. 

  1151. 	FOREIGN KEY(accountsids)

    1152. 

  1152. 	REFERENCES accounts(ids)

    1153. 

  1153. 	ON DELETE CASCADE ;

    1154. 

  1154. 

    1155. 

  1155. ALTER TABLE itemstoaccounts

    1156. 

  1156. 	ADD CONSTRAINT SQL0910060843284601

    1157. 

  1157. 	FOREIGN KEY(itemsids)

    1158. 

  1158. 	REFERENCES items(ids)

    1159. 

  1159. 	ON DELETE CASCADE ;

    1160. 

  1160. 

    1161. 

  1161. ALTER TABLE languages

    1162. 

  1162. 	ADD CONSTRAINT SQL0910060843151721

    1163. 

  1163. 	FOREIGN KEY(filename)

    1164. 

  1164. 	REFERENCES files(cname)

    1165. 

  1165. 	ON DELETE CASCADE ;

    1166. 

  1166. 

    1167. 

  1167. ALTER TABLE languages

    1168. 

  1168. 	ADD CONSTRAINT SQL0910060843151701

    1169. 

  1169. 	FOREIGN KEY(groupsids)

    1170. 

  1170. 	REFERENCES groups(ids);

    1171. 

  1171. 

    1172. 

  1172. ALTER TABLE mails

    1173. 

  1173. 	ADD CONSTRAINT SQL0910060843225511

    1174. 

  1174. 	FOREIGN KEY(usersids)

    1175. 

  1175. 	REFERENCES users(ids)

    1176. 

  1176. 	ON DELETE CASCADE ;

    1177. 

  1177. 

    1178. 

  1178. ALTER TABLE mails

    1179. 

  1179. 	ADD CONSTRAINT SQL0910060843225501

    1180. 

  1180. 	FOREIGN KEY(groupsids)

    1181. 

  1181. 	REFERENCES groups(ids);

    1182. 

  1182. 

    1183. 

  1183. ALTER TABLE plugins

    1184. 

  1184. 	ADD CONSTRAINT SQL0910060843335511

    1185. 

  1185. 	FOREIGN KEY(groupsids)

    1186. 

  1186. 	REFERENCES groups(ids);

    1187. 

  1187. 

    1188. 

  1188. ALTER TABLE plugins

    1189. 

  1189. 	ADD CONSTRAINT SQL0910060843335501

    1190. 

  1190. 	FOREIGN KEY(filename)

    1191. 

  1191. 	REFERENCES files(cname)

    1192. 

  1192. 	ON DELETE CASCADE ;

    1193. 

  1193. 

    1194. 

  1194. ALTER TABLE pluginstousers

    1195. 

  1195. 	ADD CONSTRAINT SQL0910060843342401

    1196. 

  1196. 	FOREIGN KEY(groupsids)

    1197. 

  1197. 	REFERENCES groups(ids);

    1198. 

  1198. 

    1199. 

  1199. ALTER TABLE pluginstousers

    1200. 

  1200. 	ADD CONSTRAINT SQL0910060843342301

    1201. 

  1201. 	FOREIGN KEY(pluginsids)

    1202. 

  1202. 	REFERENCES plugins(ids)

    1203. 

  1203. 	ON DELETE CASCADE ;

    1204. 

  1204. 

    1205. 

  1205. ALTER TABLE productlistitems

    1206. 

  1206. 	ADD CONSTRAINT SQL0910060843211401

    1207. 

  1207. 	FOREIGN KEY(originalproductsids)

    1208. 

  1208. 	REFERENCES products(ids)

    1209. 

  1209. 	ON DELETE CASCADE ;

    1210. 

  1210. 

    1211. 

  1211. ALTER TABLE productlistitems

    1212. 

  1212. 	ADD CONSTRAINT SQL0910060843211311

    1213. 

  1213. 	FOREIGN KEY(productlistsids)

    1214. 

  1214. 	REFERENCES productlists(ids)

    1215. 

  1215. 	ON DELETE CASCADE ;

    1216. 

  1216. 

    1217. 

  1217. ALTER TABLE productlistitems

    1218. 

  1218. 	ADD CONSTRAINT SQL0910060843211301

    1219. 

  1219. 	FOREIGN KEY(groupsids)

    1220. 

  1220. 	REFERENCES groups(ids);

    1221. 

  1221. 

    1222. 

  1222. ALTER TABLE productlists

    1223. 

  1223. 	ADD CONSTRAINT SQL0910060843205901

    1224. 

  1224. 	FOREIGN KEY(groupsids)

    1225. 

  1225. 	REFERENCES groups(ids);

    1226. 

  1226. 

    1227. 

  1227. ALTER TABLE products

    1228. 

  1228. 	ADD CONSTRAINT SQL0910060843196121

    1229. 

  1229. 	FOREIGN KEY(productgroupsids)

    1230. 

  1230. 	REFERENCES productsgroups(ids);

    1231. 

  1231. 

    1232. 

  1232. ALTER TABLE products

    1233. 

  1233. 	ADD CONSTRAINT SQL0910060843196111

    1234. 

  1234. 	FOREIGN KEY(groupsids)

    1235. 

  1235. 	REFERENCES groups(ids);

    1236. 

  1236. 

    1237. 

  1237. ALTER TABLE products

    1238. 

  1238. 	ADD CONSTRAINT SQL0910060843196101

    1239. 

  1239. 	FOREIGN KEY(taxids)

    1240. 

  1240. 	REFERENCES tax(ids);

    1241. 

  1241. 

    1242. 

  1242. ALTER TABLE reminders

    1243. 

  1243. 	ADD CONSTRAINT SQL0910060843368811

    1244. 

  1244. 	FOREIGN KEY(groupsids)

    1245. 

  1245. 	REFERENCES groups(ids);

    1246. 

  1246. 

    1247. 

  1247. ALTER TABLE reminders

    1248. 

  1248. 	ADD CONSTRAINT SQL0910060843368801

    1249. 

  1249. 	FOREIGN KEY(itemsids)

    1250. 

  1250. 	REFERENCES items(ids)

    1251. 

  1251. 	ON DELETE CASCADE ;

    1252. 

  1252. 

    1253. 

  1253. ALTER TABLE revenues

    1254. 

  1254. 	ADD CONSTRAINT SQL0910060843248001

    1255. 

  1255. 	FOREIGN KEY(accountsids)

    1256. 

  1256. 	REFERENCES accounts(ids);

    1257. 

  1257. 

    1258. 

  1258. ALTER TABLE revenues

    1259. 

  1259. 	ADD CONSTRAINT SQL0910060843247901

    1260. 

  1260. 	FOREIGN KEY(groupsids)

    1261. 

  1261. 	REFERENCES groups(ids);

    1262. 

  1262. 

    1263. 

  1263. ALTER TABLE schedule

    1264. 

  1264. 	ADD CONSTRAINT SQL0910060843184821

    1265. 

  1265. 	FOREIGN KEY(itemsids)

    1266. 

  1266. 	REFERENCES items(ids)

    1267. 

  1267. 	ON DELETE CASCADE ;

    1268. 

  1268. 

    1269. 

  1269. ALTER TABLE schedule

    1270. 

  1270. 	ADD CONSTRAINT SQL0910060843184811

    1271. 

  1271. 	FOREIGN KEY(usersids)

    1272. 

  1272. 	REFERENCES users(ids)

    1273. 

  1273. 	ON DELETE CASCADE ;

    1274. 

  1274. 

    1275. 

  1275. ALTER TABLE schedule

    1276. 

  1276. 	ADD CONSTRAINT SQL0910060843184801

    1277. 

  1277. 	FOREIGN KEY(groupsids)

    1278. 

  1278. 	REFERENCES groups(ids);

    1279. 

  1279. 

    1280. 

  1280. ALTER TABLE stages

    1281. 

  1281. 	ADD CONSTRAINT SQL0910060843375801

    1282. 

  1282. 	FOREIGN KEY(groupsids)

    1283. 

  1283. 	REFERENCES groups(ids);

    1284. 

  1284. 

    1285. 

  1285. ALTER TABLE subitems

    1286. 

  1286. 	ADD CONSTRAINT SQL0910060843179011

    1287. 

  1287. 	FOREIGN KEY(groupsids)

    1288. 

  1288. 	REFERENCES groups(ids);

    1289. 

  1289. 

    1290. 

  1290. ALTER TABLE subitems

    1291. 

  1291. 	ADD CONSTRAINT SQL0910060843179001

    1292. 

  1292. 	FOREIGN KEY(itemsids)

    1293. 

  1293. 	REFERENCES items(ids)

    1294. 

  1294. 	ON DELETE CASCADE ;

    1295. 

  1295. 

    1296. 

  1296. ALTER TABLE tablelock

    1297. 

  1297. 	ADD CONSTRAINT SQL0910060843278901

    1298. 

  1298. 	FOREIGN KEY(usersids)

    1299. 

  1299. 	REFERENCES users(ids)

    1300. 

  1300. 	ON DELETE CASCADE ;

    1301. 

  1301. 

    1302. 

  1302. ALTER TABLE tax

    1303. 

  1303. 	ADD CONSTRAINT SQL0910060843128901

    1304. 

  1304. 	FOREIGN KEY(groupsids)

    1305. 

  1305. 	REFERENCES groups(ids);

    1306. 

  1306. 

    1307. 

  1307. ALTER TABLE templates

    1308. 

  1308. 	ADD CONSTRAINT SQL0910060843304911

    1309. 

  1309. 	FOREIGN KEY(groupsids)

    1310. 

  1310. 	REFERENCES groups(ids);

    1311. 

  1311. 

    1312. 

  1312. ALTER TABLE templates

    1313. 

  1313. 	ADD CONSTRAINT SQL0910060843304901

    1314. 

  1314. 	FOREIGN KEY(filename)

    1315. 

  1315. 	REFERENCES files(cname)

    1316. 

  1316. 	ON DELETE CASCADE ;

    1317. 

  1317. 

    1318. 

  1318. ALTER TABLE templatestousers

    1319. 

  1319. 	ADD CONSTRAINT SQL0910060843354601

    1320. 

  1320. 	FOREIGN KEY(groupsids)

    1321. 

  1321. 	REFERENCES groups(ids);

    1322. 

  1322. 

    1323. 

  1323. ALTER TABLE templatestousers

    1324. 

  1324. 	ADD CONSTRAINT SQL0910060843354511

    1325. 

  1325. 	FOREIGN KEY(templatesids)

    1326. 

  1326. 	REFERENCES templates(ids)

    1327. 

  1327. 	ON DELETE CASCADE ;

    1328. 

  1328. 

    1329. 

  1329. ALTER TABLE templatestousers

    1330. 

  1330. 	ADD CONSTRAINT SQL0910060843354501

    1331. 

  1331. 	FOREIGN KEY(usersids)

    1332. 

  1332. 	REFERENCES users(ids)

    1333. 

  1333. 	ON DELETE CASCADE ;

    1334. 

  1334. 

    1335. 

  1335. ALTER TABLE userproperties

    1336. 

  1336. 	ADD CONSTRAINT SQL0910060843221901

    1337. 

  1337. 	FOREIGN KEY(groupsids)

    1338. 

  1338. 	REFERENCES groups(ids);

    1339. 

  1339. 

    1340. 

  1340. ALTER TABLE users

    1341. 

  1341. 	ADD CONSTRAINT SQL0910060843139601

    1342. 

  1342. 	FOREIGN KEY(groupsids)

    1343. 

  1343. 	REFERENCES groups(ids);

    1344. 

  1344. 

    1345. 

  1345. ALTER TABLE wscontactsmapping

    1346. 

  1346. 	ADD CONSTRAINT SQL0910060843260521

    1347. 

  1347. 	FOREIGN KEY(contactsids)

    1348. 

  1348. 	REFERENCES contacts(ids)

    1349. 

  1349. 	ON DELETE CASCADE ;

    1350. 

  1350. 

    1351. 

  1351. ALTER TABLE wscontactsmapping

    1352. 

  1352. 	ADD CONSTRAINT SQL0910060843260511

    1353. 

  1353. 	FOREIGN KEY(groupsids)

    1354. 

  1354. 	REFERENCES groups(ids)

    1355. 

  1355. 	ON DELETE CASCADE ;

    1356. 

  1356. 

    1357. 

  1357. ALTER TABLE wscontactsmapping

    1358. 

  1358. 	ADD CONSTRAINT SQL0910060843260501

    1359. 

  1359. 	FOREIGN KEY(webshopsids)

    1360. 

  1360. 	REFERENCES webshops(ids)

    1361. 

  1361. 	ON DELETE CASCADE ;

    1362. 

  1362. 

    1363. 

  1363. ALTER TABLE wsitemsmapping

    1364. 

  1364. 	ADD CONSTRAINT SQL0910060843268721

    1365. 

  1365. 	FOREIGN KEY(itemsids)

    1366. 

  1366. 	REFERENCES contacts(ids)

    1367. 

  1367. 	ON DELETE CASCADE ;

    1368. 

  1368. 

    1369. 

  1369. ALTER TABLE wsitemsmapping

    1370. 

  1370. 	ADD CONSTRAINT SQL0910060843268711

    1371. 

  1371. 	FOREIGN KEY(groupsids)

    1372. 

  1372. 	REFERENCES groups(ids)

    1373. 

  1373. 	ON DELETE CASCADE ;

    1374. 

  1374. 

    1375. 

  1375. ALTER TABLE wsitemsmapping

    1376. 

  1376. 	ADD CONSTRAINT SQL0910060843268701

    1377. 

  1377. 	FOREIGN KEY(webshopsids)

    1378. 

  1378. 	REFERENCES webshops(ids)

    1379. 

  1379. 	ON DELETE CASCADE ;

    1380. 

  1380. 

    1381. 

  1381. 

    1382. 

  1382. 

    1383. 

  1383. DELIMITER %

    1384. 

  1384. 

    1385. 

  1385. DROP TRIGGER IF EXISTS contacts_INDEXER1

    1386. 

  1386. %

    1387. 

  1387. CREATE TRIGGER contacts_INDEXER1

    1388. 

  1388.         AFTER INSERT ON contacts

    1389. 

  1389. 

    1390. 

  1390.         FOR EACH ROW BEGIN

    1391. 

  1391.         INSERT INTO searchindex (groupsids, dbidentity, rowid, text) VALUES (NEW.groupsids, 'contacts',NEW.ids,NEW.cnumber||' '||NEW.taxnumber||' '||NEW.title||' '||NEW.country||' '|| NEW.prename||' '|| NEW.cname||' '|| NEW.street||' '||NEW.zip||' '|| NEW.city ||' '||NEW.mainphone||' '||NEW.fax||' '||NEW.mobilephone||' '||NEW.workphone||' '||NEW.mailaddress||' '||NEW.company||' '|| NEW.department||' '||NEW.website||' '||NEW.notes);

    1392. 

  1392. END;

    1393. 

  1393.         %

    1394. 

  1394. 

    1395. 

  1395. DROP TRIGGER IF EXISTS contacts_INDEXER2

    1396. 

  1396. %

    1397. 

  1397. CREATE TRIGGER contacts_INDEXER2

    1398. 

  1398.         AFTER UPDATE ON contacts

    1399. 

  1399. 

    1400. 

  1400.         FOR EACH ROW BEGIN

    1401. 

  1401.         DELETE FROM searchindex WHERE dbidentity = 'contacts' AND  rowid = NEW.ids;

    1402. 

  1402.         INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (NEW.groupsids,'contacts',NEW.ids,NEW.cnumber||' '||NEW.taxnumber||' '||NEW.title||' '||NEW.country||' '|| NEW.prename||' '|| NEW.cname||' '|| NEW.street||' '||NEW.zip||' '|| NEW.city ||' '||NEW.mainphone||' '||NEW.fax||' '||NEW.mobilephone||' '||NEW.workphone||' '||NEW.mailaddress||' '||NEW.company||' '|| NEW.department||' '||NEW.website||' '||NEW.notes);

    1403. 

  1403.         IF NEW.invisible != '0' THEN            

    1404. 

  1404.           INSERT INTO trashbin (deleteme, cname, rowid, description) VALUES (NEW.invisible,'contacts',NEW.ids,NEW.cnumber||' ('|| NEW.cname||')');                    

    1405. 

  1405.         ELSE

    1406. 

  1406.           DELETE FROM trashbin WHERE cname = 'contacts' AND rowid = NEW.ids; 

    1407. 

  1407.         END IF;

    1408. 

  1408. END;

    1409. 

  1409. %

    1410. 

  1410. 

    1411. 

  1411. DROP TRIGGER IF EXISTS contacts_INDEXER4

    1412. 

  1412. %

    1413. 

  1413. CREATE TRIGGER contacts_INDEXER4

    1414. 

  1414.         AFTER DELETE ON contacts

    1415. 

  1415. 

    1416. 

  1416.         FOR EACH ROW BEGIN

    1417. 

  1417.         DELETE FROM searchindex WHERE dbidentity = 'contacts' AND  rowid = OLD.ids;

    1418. 

  1418.         DELETE FROM trashbin WHERE cname = 'contacts' AND  rowid = OLD.ids;

    1419. 

  1419. END;

    1420. 

  1420. %

    1421. 

  1421. 

    1422. 

  1422. DROP TRIGGER IF EXISTS expenses_INDEXER1

    1423. 

  1423. %

    1424. 

  1424. CREATE TRIGGER expenses_INDEXER1

    1425. 

  1425.         AFTER INSERT ON expenses

    1426. 

  1426. 

    1427. 

  1427.         FOR EACH ROW BEGIN

    1428. 

  1428.         INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (NEW.groupsids,'expenses',NEW.ids,NEW.cname||' '||NEW.dateadded);

    1429. 

  1429. END;

    1430. 

  1430.         %

    1431. 

  1431. 

    1432. 

  1432. DROP TRIGGER IF EXISTS expenses_INDEXER2

    1433. 

  1433. %        

    1434. 

  1434. CREATE TRIGGER expenses_INDEXER2

    1435. 

  1435.         AFTER UPDATE ON expenses

    1436. 

  1436. 

    1437. 

  1437.         FOR EACH ROW BEGIN

    1438. 

  1438.         DELETE FROM searchindex WHERE dbidentity = 'expenses' AND  rowid = NEW.ids;

    1439. 

  1439.         INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (NEW.groupsids,'expenses',NEW.ids,NEW.cname||' '||NEW.dateadded);

    1440. 

  1440.         IF NEW.invisible != '0' THEN            

    1441. 

  1441.           INSERT INTO trashbin (deleteme, cname, rowid, description) VALUES (NEW.invisible,'expenses',NEW.ids,NEW.cname);          

    1442. 

  1442.         ELSE

    1443. 

  1443.           DELETE FROM trashbin WHERE cname = 'expenses' AND rowid = NEW.ids; 

    1444. 

  1444.         END IF;

    1445. 

  1445. END;

    1446. 

  1446. %

    1447. 

  1447. 

    1448. 

  1448. DROP TRIGGER IF EXISTS expenses_INDEXER4

    1449. 

  1449. %

    1450. 

  1450. CREATE TRIGGER expenses_INDEXER4

    1451. 

  1451.         AFTER DELETE ON expenses

    1452. 

  1452. 

    1453. 

  1453.         FOR EACH ROW BEGIN

    1454. 

  1454.         DELETE FROM searchindex WHERE dbidentity = 'expenses' AND  rowid = OLD.ids;

    1455. 

  1455.         DELETE FROM trashbin WHERE cname = 'expenses' AND  rowid = OLD.ids;

    1456. 

  1456. END;

    1457. 

  1457. %

    1458. 

  1458. 

    1459. 

  1459. DROP TRIGGER IF EXISTS filestocontacts_INDEXER1

    1460. 

  1460. %

    1461. 

  1461. CREATE TRIGGER filestocontacts_INDEXER1

    1462. 

  1462.         AFTER INSERT ON filestocontacts

    1463. 

  1463. 

    1464. 

  1464.         FOR EACH ROW BEGIN

    1465. 

  1465.         INSERT INTO searchindex (groupsids, dbidentity, rowid, text) VALUES (NEW.groupsids,'filestocontacts',NEW.ids,NEW.cname||' '||NEW.description||' '||NEW.filename);

    1466. 

  1466. END;

    1467. 

  1467.         %

    1468. 

  1468. 

    1469. 

  1469. DROP TRIGGER IF EXISTS filestocontacts_INDEXER2

    1470. 

  1470. %        

    1471. 

  1471. CREATE TRIGGER filestocontacts_INDEXER2

    1472. 

  1472.         AFTER UPDATE ON filestocontacts

    1473. 

  1473. 

    1474. 

  1474.         FOR EACH ROW BEGIN

    1475. 

  1475.   DELETE FROM searchindex WHERE dbidentity = 'filestocontacts' AND  rowid = NEW.ids;

    1476. 

  1476.         INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (NEW.groupsids,'filestocontacts',NEW.ids,NEW.cname||' '||NEW.description||' '||NEW.filename);

    1477. 

  1477. END;

    1478. 

  1478.         %

    1479. 

  1479. 

    1480. 

  1480. DROP TRIGGER IF EXISTS filestocontacts_INDEXER4

    1481. 

  1481. %

    1482. 

  1482. CREATE TRIGGER filestocontacts_INDEXER4

    1483. 

  1483.         AFTER DELETE ON filestocontacts

    1484. 

  1484. 

    1485. 

  1485.         FOR EACH ROW BEGIN

    1486. 

  1486.         DELETE FROM searchindex WHERE dbidentity = 'filestocontacts' AND  rowid = OLD.ids;

    1487. 

  1487. 

    1488. 

  1488.         END;

    1489. 

  1489.         %

    1490. 

  1490. 

    1491. 

  1491. DROP TRIGGER IF EXISTS groups_INDEXER1

    1492. 

  1492. %        

    1493. 

  1493. CREATE TRIGGER groups_INDEXER1

    1494. 

  1494.         AFTER INSERT ON groups

    1495. 

  1495. 

    1496. 

  1496.         FOR EACH ROW BEGIN

    1497. 

  1497.         INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (NEW.groupsids,'groups',NEW.ids,NEW.cname||' '||NEW.description||' '||NEW.dateadded);

    1498. 

  1498. END;

    1499. 

  1499.         %

    1500. 

  1500.         

    1501. 

  1501. DROP TRIGGER IF EXISTS groups_INDEXER2

    1502. 

  1502. %  

    1503. 

  1503. CREATE TRIGGER groups_INDEXER2

    1504. 

  1504.         AFTER UPDATE ON groups

    1505. 

  1505. 

    1506. 

  1506.         FOR EACH ROW BEGIN

    1507. 

  1507.         DELETE FROM searchindex WHERE dbidentity = 'groups' AND  rowid = NEW.ids;

    1508. 

  1508.         INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (NEW.groupsids,'groups',NEW.ids,NEW.cname||' '||NEW.description||' '||NEW.dateadded);

    1509. 

  1509. END;

    1510. 

  1510. %

    1511. 

  1511. 

    1512. 

  1512. DROP TRIGGER IF EXISTS groups_INDEXER4

    1513. 

  1513. %  

    1514. 

  1514. CREATE TRIGGER groups_INDEXER4

    1515. 

  1515.         AFTER DELETE ON groups

    1516. 

  1516. 

    1517. 

  1517.         FOR EACH ROW BEGIN

    1518. 

  1518.         DELETE FROM searchindex WHERE dbidentity = 'groups' AND  rowid = OLD.ids;

    1519. 

  1519. END;

    1520. 

  1520.         %

    1521. 

  1521. 

    1522. 

  1522. DROP TRIGGER IF EXISTS items_INDEXER1

    1523. 

  1523. %          

    1524. 

  1524. CREATE TRIGGER items_INDEXER1

    1525. 

  1525.         AFTER INSERT ON items

    1526. 

  1526. 

    1527. 

  1527.         FOR EACH ROW BEGIN

    1528. 

  1528.         INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (NEW.groupsids,'items',NEW.ids,NEW.cname||' '||NEW.dateadded);

    1529. 

  1529. END;

    1530. 

  1530.         %

    1531. 

  1531.         

    1532. 

  1532. DROP TRIGGER IF EXISTS items_INDEXER2

    1533. 

  1533. % 

    1534. 

  1534. CREATE TRIGGER items_INDEXER2

    1535. 

  1535.         AFTER UPDATE ON items

    1536. 

  1536. 

    1537. 

  1537.         FOR EACH ROW BEGIN

    1538. 

  1538.         DELETE FROM searchindex WHERE dbidentity = 'items' AND  rowid = NEW.ids;

    1539. 

  1539.         INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (NEW.groupsids,'items',NEW.ids,NEW.cname||' '||NEW.dateadded);

    1540. 

  1540.         IF NEW.invisible != '0' THEN            

    1541. 

  1541.           INSERT INTO trashbin (deleteme, cname, rowid, description) VALUES (NEW.invisible,'items',NEW.ids,NEW.cname);          

    1542. 

  1542.         ELSE

    1543. 

  1543.           DELETE FROM trashbin WHERE cname = 'items' AND rowid = NEW.ids; 

    1544. 

  1544.         END IF;

    1545. 

  1545. END;

    1546. 

  1546. %

    1547. 

  1547. 

    1548. 

  1548. DROP TRIGGER IF EXISTS items_INDEXER4

    1549. 

  1549. % 

    1550. 

  1550. CREATE TRIGGER items_INDEXER4

    1551. 

  1551.         AFTER DELETE ON items

    1552. 

  1552. 

    1553. 

  1553.         FOR EACH ROW BEGIN

    1554. 

  1554.         DELETE FROM searchindex WHERE dbidentity = 'items' AND  rowid = OLD.ids;

    1555. 

  1555.         DELETE FROM trashbin WHERE cname = 'items' AND  rowid = OLD.ids;

    1556. 

  1556. END;

    1557. 

  1557.         %

    1558. 

  1558. 

    1559. 

  1559. DROP TRIGGER IF EXISTS products_INDEXER1

    1560. 

  1560. % 

    1561. 

  1561. CREATE TRIGGER products_INDEXER1

    1562. 

  1562.         AFTER INSERT ON products

    1563. 

  1563. 

    1564. 

  1564.         FOR EACH ROW BEGIN

    1565. 

  1565.         INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (NEW.groupsids,'products',NEW.ids,NEW.cname||' '||NEW.cnumber||' '||NEW.description||' '||NEW.dateadded);

    1566. 

  1566. END;

    1567. 

  1567.         %

    1568. 

  1568. 

    1569. 

  1569. DROP TRIGGER IF EXISTS products_INDEXER2

    1570. 

  1570. %         

    1571. 

  1571. CREATE TRIGGER products_INDEXER2

    1572. 

  1572.         AFTER UPDATE ON products

    1573. 

  1573. 

    1574. 

  1574.         FOR EACH ROW BEGIN

    1575. 

  1575.         DELETE FROM searchindex WHERE dbidentity = 'products' AND  rowid = NEW.ids;

    1576. 

  1576.         INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (NEW.groupsids,'products',NEW.ids,NEW.cname||' '||NEW.cnumber||' '||NEW.description||' '||NEW.dateadded);

    1577. 

  1577.         IF NEW.invisible != '0' THEN            

    1578. 

  1578.           INSERT INTO trashbin (deleteme, cname, rowid, description) VALUES (NEW.invisible, 'products',NEW.ids,NEW.cnumber||' ('|| NEW.cname||')');          

    1579. 

  1579.         ELSE

    1580. 

  1580.           DELETE FROM trashbin WHERE cname = 'products' AND rowid = NEW.ids; 

    1581. 

  1581.         END IF;

    1582. 

  1582. END;

    1583. 

  1583. %

    1584. 

  1584. 

    1585. 

  1585. DROP TRIGGER IF EXISTS products_INDEXER4

    1586. 

  1586. % 

    1587. 

  1587. CREATE TRIGGER products_INDEXER4

    1588. 

  1588.         AFTER DELETE ON products

    1589. 

  1589. 

    1590. 

  1590.         FOR EACH ROW BEGIN

    1591. 

  1591.         DELETE FROM searchindex WHERE dbidentity = 'products' AND  rowid = OLD.ids;

    1592. 

  1592.         DELETE FROM trashbin WHERE cname = 'products' AND  rowid = OLD.ids;

    1593. 

  1593. END;

    1594. 

  1594.         %

    1595. 

  1595. 

    1596. 

  1596. DROP TRIGGER IF EXISTS revenues_INDEXER1

    1597. 

  1597. % 

    1598. 

  1598. CREATE TRIGGER revenues_INDEXER1

    1599. 

  1599.         AFTER INSERT ON revenues

    1600. 

  1600. 

    1601. 

  1601.         FOR EACH ROW BEGIN

    1602. 

  1602.         INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (NEW.groupsids,'revenues',NEW.ids,NEW.cname||' '||NEW.dateadded);

    1603. 

  1603. END;

    1604. 

  1604.         %

    1605. 

  1605. 

    1606. 

  1606. DROP TRIGGER IF EXISTS revenues_INDEXER2

    1607. 

  1607. %         

    1608. 

  1608. CREATE TRIGGER revenues_INDEXER2

    1609. 

  1609.         AFTER UPDATE ON revenues

    1610. 

  1610. 

    1611. 

  1611.         FOR EACH ROW BEGIN

    1612. 

  1612.         DELETE FROM searchindex WHERE dbidentity = 'revenues' AND  rowid = NEW.ids;

    1613. 

  1613.         INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (NEW.groupsids,'revenues',NEW.ids,NEW.cname||' '||NEW.dateadded);

    1614. 

  1614.         IF NEW.invisible != '0' THEN            

    1615. 

  1615.           INSERT INTO trashbin (deleteme, cname, rowid, description) VALUES (NEW.invisible,'revenues',NEW.ids,NEW.cname);          

    1616. 

  1616.         ELSE

    1617. 

  1617.           DELETE FROM trashbin WHERE cname = 'revenues' AND rowid = NEW.ids; 

    1618. 

  1618.         END IF;

    1619. 

  1619. END;

    1620. 

  1620.         %

    1621. 

  1621. 

    1622. 

  1622. DROP TRIGGER IF EXISTS revenues_INDEXER4

    1623. 

  1623. %         

    1624. 

  1624. CREATE TRIGGER revenues_INDEXER4

    1625. 

  1625.         AFTER DELETE ON revenues

    1626. 

  1626. 

    1627. 

  1627.         FOR EACH ROW BEGIN

    1628. 

  1628.         DELETE FROM searchindex WHERE dbidentity = 'revenues' AND  rowid = OLD.ids;

    1629. 

  1629.         DELETE FROM trashbin WHERE cname = 'revenues' AND  rowid = OLD.ids;

    1630. 

  1630. END;

    1631. 

  1631. %

    1632. 

  1632. 

    1633. 

  1633. DROP TRIGGER IF EXISTS subitems_INDEXER1

    1634. 

  1634. % 

    1635. 

  1635. CREATE TRIGGER subitems_INDEXER1

    1636. 

  1636.         AFTER INSERT ON subitems

    1637. 

  1637. 

    1638. 

  1638.         FOR EACH ROW BEGIN

    1639. 

  1639.         INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (NEW.groupsids,'subitems',NEW.ids,NEW.cname||' '||NEW.description||' '||NEW.dateadded);

    1640. 

  1640. END;

    1641. 

  1641.         %

    1642. 

  1642. 

    1643. 

  1643. DROP TRIGGER IF EXISTS subitems_INDEXER2

    1644. 

  1644. %         

    1645. 

  1645. CREATE TRIGGER subitems_INDEXER2

    1646. 

  1646.         AFTER UPDATE ON subitems

    1647. 

  1647. 

    1648. 

  1648.         FOR EACH ROW BEGIN

    1649. 

  1649.         DELETE FROM searchindex WHERE dbidentity = 'subitems' AND  rowid = NEW.ids;

    1650. 

  1650.         INSERT INTO searchindex  (groupsids, dbidentity, rowid, text) VALUES (NEW.groupsids,'subitems',NEW.ids,NEW.cname||' '||NEW.description||' '||NEW.dateadded);

    1651. 

  1651. END;

    1652. 

  1652.         %

    1653. 

  1653. 

    1654. 

  1654. DROP TRIGGER IF EXISTS subitems_INDEXER4

    1655. 

  1655. % 

    1656. 

  1656. CREATE TRIGGER subitems_INDEXER4

    1657. 

  1657.         AFTER DELETE ON subitems

    1658. 

  1658. 

    1659. 

  1659.         FOR EACH ROW BEGIN

    1660. 

  1660.         DELETE FROM searchindex WHERE dbidentity = 'subitems' AND  rowid = OLD.ids;

    1661. 

  1661. END;

    1662. 

  1662.         %

    1663. 

  1663. DELIMITER ;

    1664. 

  1664. 

    1665. 

  1665.