20120101000001_create_base.rb 39 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801
  1. # Copyright (C) 2012-2022 Zammad Foundation, https://zammad-foundation.org/
  2. class CreateBase < ActiveRecord::Migration[4.2]
  3. def up
  4. # clear old caches to start from scratch
  5. Rails.cache.clear
  6. create_table :sessions do |t|
  7. t.string :session_id, null: false
  8. t.boolean :persistent, null: true
  9. t.text :data
  10. t.timestamps limit: 3, null: false
  11. end
  12. add_index :sessions, :session_id
  13. add_index :sessions, :updated_at
  14. add_index :sessions, :persistent
  15. create_table :users do |t|
  16. t.references :organization, null: true
  17. t.string :login, limit: 255, null: false
  18. t.string :firstname, limit: 100, null: true, default: ''
  19. t.string :lastname, limit: 100, null: true, default: ''
  20. t.string :email, limit: 255, null: true, default: ''
  21. t.string :image, limit: 100, null: true
  22. t.string :image_source, limit: 200, null: true
  23. t.string :web, limit: 100, null: true, default: ''
  24. t.string :password, limit: 100, null: true
  25. t.string :phone, limit: 100, null: true, default: ''
  26. t.string :fax, limit: 100, null: true, default: ''
  27. t.string :mobile, limit: 100, null: true, default: ''
  28. t.string :department, limit: 200, null: true, default: ''
  29. t.string :street, limit: 120, null: true, default: ''
  30. t.string :zip, limit: 100, null: true, default: ''
  31. t.string :city, limit: 100, null: true, default: ''
  32. t.string :country, limit: 100, null: true, default: ''
  33. t.string :address, limit: 500, null: true, default: ''
  34. t.boolean :vip, default: false
  35. t.boolean :verified, null: false, default: false
  36. t.boolean :active, null: false, default: true
  37. t.string :note, limit: 5000, null: true, default: ''
  38. t.timestamp :last_login, limit: 3, null: true
  39. t.string :source, limit: 200, null: true
  40. t.integer :login_failed, null: false, default: 0
  41. t.boolean :out_of_office, null: false, default: false
  42. t.date :out_of_office_start_at, null: true
  43. t.date :out_of_office_end_at, null: true
  44. t.integer :out_of_office_replacement_id, null: true
  45. t.string :preferences, limit: 8000, null: true
  46. t.integer :updated_by_id, null: false
  47. t.integer :created_by_id, null: false
  48. t.timestamps limit: 3, null: false
  49. end
  50. add_index :users, [:login], unique: true
  51. add_index :users, [:email]
  52. # add_index :users, [:email], unique: => true
  53. add_index :users, [:organization_id]
  54. add_index :users, [:image]
  55. add_index :users, [:department]
  56. add_index :users, [:phone]
  57. add_index :users, [:fax]
  58. add_index :users, [:mobile]
  59. add_index :users, %i[out_of_office out_of_office_start_at out_of_office_end_at], name: 'index_out_of_office'
  60. add_index :users, [:out_of_office_replacement_id]
  61. add_index :users, [:source]
  62. add_index :users, [:created_by_id]
  63. add_foreign_key :users, :users, column: :created_by_id
  64. add_foreign_key :users, :users, column: :updated_by_id
  65. add_foreign_key :users, :users, column: :out_of_office_replacement_id
  66. create_table :signatures do |t|
  67. t.string :name, limit: 100, null: false
  68. t.text :body, limit: 10.megabytes + 1, null: true
  69. t.boolean :active, null: false, default: true
  70. t.string :note, limit: 250, null: true
  71. t.integer :updated_by_id, null: false
  72. t.integer :created_by_id, null: false
  73. t.timestamps limit: 3, null: false
  74. end
  75. add_index :signatures, [:name], unique: true
  76. add_foreign_key :signatures, :users, column: :created_by_id
  77. add_foreign_key :signatures, :users, column: :updated_by_id
  78. create_table :email_addresses do |t|
  79. t.integer :channel_id, null: true
  80. t.string :realname, limit: 250, null: false
  81. t.string :email, limit: 250, null: false
  82. t.boolean :active, null: false, default: true
  83. t.string :note, limit: 250, null: true
  84. t.string :preferences, limit: 2000, null: true
  85. t.integer :updated_by_id, null: false
  86. t.integer :created_by_id, null: false
  87. t.timestamps limit: 3, null: false
  88. end
  89. add_index :email_addresses, [:email], unique: true
  90. add_foreign_key :email_addresses, :users, column: :created_by_id
  91. add_foreign_key :email_addresses, :users, column: :updated_by_id
  92. create_table :groups do |t|
  93. t.references :signature, null: true
  94. t.references :email_address, null: true
  95. t.string :name, limit: 160, null: false
  96. t.integer :assignment_timeout, null: true
  97. t.string :follow_up_possible, limit: 100, null: false, default: 'yes'
  98. t.boolean :follow_up_assignment, null: false, default: true
  99. t.boolean :active, null: false, default: true
  100. t.boolean :shared_drafts, null: false, default: true
  101. t.string :note, limit: 250, null: true
  102. t.integer :updated_by_id, null: false
  103. t.integer :created_by_id, null: false
  104. t.timestamps limit: 3, null: false
  105. end
  106. add_index :groups, [:name], unique: true
  107. add_foreign_key :groups, :signatures
  108. add_foreign_key :groups, :email_addresses
  109. add_foreign_key :groups, :users, column: :created_by_id
  110. add_foreign_key :groups, :users, column: :updated_by_id
  111. create_table :roles do |t|
  112. t.string :name, limit: 100, null: false
  113. t.text :preferences, limit: 500.kilobytes + 1, null: true
  114. t.boolean :default_at_signup, null: true, default: false
  115. t.boolean :active, null: false, default: true
  116. t.string :note, limit: 250, null: true
  117. t.integer :updated_by_id, null: false
  118. t.integer :created_by_id, null: false
  119. t.timestamps limit: 3, null: false
  120. end
  121. add_index :roles, [:name], unique: true
  122. add_foreign_key :roles, :users, column: :created_by_id
  123. add_foreign_key :roles, :users, column: :updated_by_id
  124. create_table :permissions do |t|
  125. t.string :name, limit: 255, null: false
  126. t.string :note, limit: 500, null: true
  127. t.string :preferences, limit: 10_000, null: true
  128. t.boolean :active, null: false, default: true
  129. t.boolean :allow_signup, null: false, default: false
  130. t.timestamps limit: 3, null: false
  131. end
  132. add_index :permissions, [:name], unique: true
  133. create_table :permissions_roles, id: false do |t|
  134. t.belongs_to :role, index: true
  135. t.belongs_to :permission, index: true
  136. end
  137. create_table :organizations do |t|
  138. t.string :name, limit: 100, null: false
  139. t.boolean :shared, null: false, default: true
  140. t.string :domain, limit: 250, null: true, default: ''
  141. t.boolean :domain_assignment, null: false, default: false
  142. t.boolean :active, null: false, default: true
  143. t.string :note, limit: 5000, null: true, default: ''
  144. t.integer :updated_by_id, null: false
  145. t.integer :created_by_id, null: false
  146. t.timestamps limit: 3, null: false
  147. end
  148. add_index :organizations, [:name], unique: true
  149. add_index :organizations, [:domain]
  150. add_foreign_key :users, :organizations
  151. add_foreign_key :organizations, :users, column: :created_by_id
  152. add_foreign_key :organizations, :users, column: :updated_by_id
  153. create_table :roles_users, id: false do |t|
  154. t.references :user
  155. t.references :role
  156. end
  157. add_index :roles_users, [:user_id]
  158. add_index :roles_users, [:role_id]
  159. add_foreign_key :roles_users, :users
  160. add_foreign_key :roles_users, :roles
  161. create_table :groups_users, id: false do |t|
  162. t.references :user, null: false
  163. t.references :group, null: false
  164. t.string :access, limit: 50, null: false, default: 'full'
  165. end
  166. add_index :groups_users, [:user_id]
  167. add_index :groups_users, [:group_id]
  168. add_index :groups_users, [:access]
  169. add_index :groups_users, %i[user_id group_id access]
  170. add_foreign_key :groups_users, :users
  171. add_foreign_key :groups_users, :groups
  172. create_table :roles_groups, id: false do |t|
  173. t.references :role, null: false
  174. t.references :group, null: false
  175. t.string :access, limit: 50, null: false, default: 'full'
  176. end
  177. add_index :roles_groups, [:role_id]
  178. add_index :roles_groups, [:group_id]
  179. add_index :roles_groups, [:access]
  180. add_foreign_key :roles_groups, :roles
  181. add_foreign_key :roles_groups, :groups
  182. create_table :organizations_users, id: false do |t|
  183. t.references :user
  184. t.references :organization
  185. end
  186. add_index :organizations_users, [:user_id]
  187. add_index :organizations_users, [:organization_id]
  188. add_foreign_key :organizations_users, :users
  189. add_foreign_key :organizations_users, :organizations
  190. create_table :authorizations do |t|
  191. t.string :provider, limit: 250, null: false
  192. t.string :uid, limit: 250, null: false
  193. t.string :token, limit: 2500, null: true
  194. t.string :secret, limit: 250, null: true
  195. t.string :username, limit: 250, null: true
  196. t.references :user, null: false
  197. t.timestamps limit: 3, null: false
  198. end
  199. add_index :authorizations, %i[uid provider], unique: true
  200. add_index :authorizations, [:user_id]
  201. add_index :authorizations, [:username]
  202. add_foreign_key :authorizations, :users
  203. create_table :locales do |t|
  204. t.string :locale, limit: 20, null: false
  205. t.string :alias, limit: 20, null: true
  206. t.string :name, limit: 255, null: false
  207. t.string :dir, limit: 9, null: false, default: 'ltr'
  208. t.boolean :active, null: false, default: true
  209. t.timestamps limit: 3, null: false
  210. end
  211. add_index :locales, [:locale], unique: true
  212. add_index :locales, [:name], unique: true
  213. create_table :translations do |t|
  214. t.string :locale, limit: 10, null: false
  215. t.string :source, limit: 3000, null: false
  216. t.string :target, limit: 3000, null: false
  217. t.string :target_initial, limit: 3000, null: false
  218. t.boolean :is_synchronized_from_codebase, null: false, default: false
  219. t.string :synchronized_from_translation_file, limit: 255
  220. t.integer :updated_by_id, null: false
  221. t.integer :created_by_id, null: false
  222. t.timestamps limit: 3, null: false
  223. end
  224. add_index :translations, [:source], length: 255
  225. add_index :translations, [:locale]
  226. add_foreign_key :translations, :users, column: :created_by_id
  227. add_foreign_key :translations, :users, column: :updated_by_id
  228. create_table :object_lookups do |t|
  229. t.string :name, limit: 250, null: false
  230. t.timestamps limit: 3, null: false
  231. end
  232. add_index :object_lookups, [:name], unique: true
  233. create_table :type_lookups do |t|
  234. t.string :name, limit: 250, null: false
  235. t.timestamps limit: 3, null: false
  236. end
  237. add_index :type_lookups, [:name], unique: true
  238. create_table :tokens do |t|
  239. t.references :user, null: false
  240. t.boolean :persistent
  241. t.string :name, limit: 100, null: false
  242. t.string :action, limit: 40, null: false
  243. t.string :label, limit: 255, null: true
  244. t.text :preferences, limit: 500.kilobytes + 1, null: true
  245. t.timestamp :last_used_at, limit: 3, null: true
  246. t.date :expires_at, null: true
  247. t.timestamps limit: 3, null: false
  248. end
  249. add_index :tokens, :user_id
  250. add_index :tokens, %i[name action], unique: true
  251. add_index :tokens, :created_at
  252. add_index :tokens, :persistent
  253. add_foreign_key :tokens, :users
  254. create_table :packages do |t|
  255. t.string :name, limit: 250, null: false
  256. t.string :version, limit: 50, null: false
  257. t.string :vendor, limit: 150, null: false
  258. t.string :state, limit: 50, null: false
  259. t.integer :updated_by_id, null: false
  260. t.integer :created_by_id, null: false
  261. t.timestamps limit: 3, null: false
  262. end
  263. add_foreign_key :packages, :users, column: :created_by_id
  264. add_foreign_key :packages, :users, column: :updated_by_id
  265. create_table :package_migrations do |t|
  266. t.string :name, limit: 250, null: false
  267. t.string :version, limit: 250, null: false
  268. t.timestamps limit: 3, null: false
  269. end
  270. create_table :taskbars do |t|
  271. t.references :user, null: false
  272. t.datetime :last_contact, null: false, limit: 3
  273. t.string :client_id, null: false
  274. t.string :key, limit: 100, null: false
  275. t.string :callback, limit: 100, null: false
  276. t.text :state, limit: 20.megabytes + 1, null: true
  277. t.text :preferences, limit: 5.megabytes + 1, null: true
  278. t.string :params, limit: 2000, null: true
  279. t.integer :prio, null: false
  280. t.boolean :notify, null: false, default: false
  281. t.boolean :active, null: false, default: false
  282. t.timestamps limit: 3, null: false
  283. end
  284. add_index :taskbars, [:user_id]
  285. add_index :taskbars, [:client_id]
  286. add_index :taskbars, [:key]
  287. add_foreign_key :taskbars, :users
  288. create_table :tag_objects do |t|
  289. t.string :name, limit: 250, null: false
  290. t.timestamps limit: 3, null: false
  291. end
  292. add_index :tag_objects, [:name], unique: true
  293. create_table :tag_items do |t|
  294. t.string :name, limit: 250, null: false
  295. t.string :name_downcase, limit: 250, null: false
  296. t.timestamps limit: 3, null: false
  297. end
  298. add_index :tag_items, [:name_downcase]
  299. create_table :tags do |t|
  300. t.references :tag_item, null: false
  301. t.references :tag_object, null: false
  302. t.integer :o_id, null: false
  303. t.integer :created_by_id, null: false
  304. t.timestamps limit: 3, null: false
  305. end
  306. add_index :tags, [:o_id]
  307. add_index :tags, [:tag_object_id]
  308. add_foreign_key :tags, :tag_items
  309. add_foreign_key :tags, :tag_objects
  310. add_foreign_key :tags, :users, column: :created_by_id
  311. create_table :recent_views do |t|
  312. t.references :recent_view_object, null: false
  313. t.integer :o_id, null: false
  314. t.integer :created_by_id, null: false
  315. t.timestamps limit: 3, null: false
  316. end
  317. add_index :recent_views, [:o_id]
  318. add_index :recent_views, [:created_by_id]
  319. add_index :recent_views, [:created_at]
  320. add_index :recent_views, [:recent_view_object_id]
  321. add_foreign_key :recent_views, :object_lookups, column: :recent_view_object_id
  322. add_foreign_key :recent_views, :users, column: :created_by_id
  323. create_table :activity_streams do |t|
  324. t.references :activity_stream_type, null: false
  325. t.references :activity_stream_object, null: false
  326. t.references :permission, null: true
  327. t.references :group, null: true
  328. t.integer :o_id, null: false
  329. t.integer :created_by_id, null: false
  330. t.timestamps limit: 3, null: false
  331. end
  332. add_index :activity_streams, [:o_id]
  333. add_index :activity_streams, [:created_by_id]
  334. add_index :activity_streams, [:permission_id]
  335. add_index :activity_streams, %i[permission_id group_id]
  336. add_index :activity_streams, %i[permission_id group_id created_at], name: 'index_activity_streams_on_permission_id_group_id_created_at'
  337. add_index :activity_streams, [:group_id]
  338. add_index :activity_streams, [:created_at]
  339. add_index :activity_streams, [:activity_stream_object_id]
  340. add_index :activity_streams, [:activity_stream_type_id]
  341. add_foreign_key :activity_streams, :type_lookups, column: :activity_stream_type_id
  342. add_foreign_key :activity_streams, :object_lookups, column: :activity_stream_object_id
  343. add_foreign_key :activity_streams, :permissions
  344. add_foreign_key :activity_streams, :groups
  345. add_foreign_key :activity_streams, :users, column: :created_by_id
  346. create_table :history_types do |t|
  347. t.string :name, limit: 250, null: false
  348. t.timestamps limit: 3, null: false
  349. end
  350. add_index :history_types, [:name], unique: true
  351. create_table :history_objects do |t|
  352. t.string :name, limit: 250, null: false
  353. t.string :note, limit: 250, null: true
  354. t.timestamps limit: 3, null: false
  355. end
  356. add_index :history_objects, [:name], unique: true
  357. create_table :history_attributes do |t|
  358. t.string :name, limit: 250, null: false
  359. t.timestamps limit: 3, null: false
  360. end
  361. add_index :history_attributes, [:name], unique: true
  362. create_table :histories do |t|
  363. t.references :history_type, null: false
  364. t.references :history_object, null: false
  365. t.references :history_attribute, null: true
  366. t.integer :o_id, null: false
  367. t.integer :related_o_id, null: true
  368. t.integer :related_history_object_id, null: true
  369. t.integer :id_to, null: true
  370. t.integer :id_from, null: true
  371. t.string :value_from, limit: 500, null: true
  372. t.string :value_to, limit: 500, null: true
  373. t.integer :created_by_id, null: false
  374. t.timestamps limit: 3, null: false
  375. end
  376. add_index :histories, [:o_id]
  377. add_index :histories, [:created_by_id]
  378. add_index :histories, [:created_at]
  379. add_index :histories, [:history_object_id]
  380. add_index :histories, [:history_attribute_id]
  381. add_index :histories, [:history_type_id]
  382. add_index :histories, [:id_to]
  383. add_index :histories, [:id_from]
  384. add_index :histories, [:value_from], length: 255
  385. add_index :histories, [:value_to], length: 255
  386. add_index :histories, [:related_o_id]
  387. add_index :histories, [:related_history_object_id]
  388. add_index :histories, %i[o_id history_object_id related_o_id]
  389. add_foreign_key :histories, :history_types
  390. add_foreign_key :histories, :history_objects
  391. add_foreign_key :histories, :history_attributes
  392. add_foreign_key :histories, :users, column: :created_by_id
  393. create_table :settings do |t|
  394. t.string :title, limit: 200, null: false
  395. t.string :name, limit: 200, null: false
  396. t.string :area, limit: 100, null: false
  397. t.string :description, limit: 2000, null: false
  398. t.text :options, null: true
  399. t.text :state_current, limit: 200.kilobytes + 1, null: true
  400. t.string :state_initial, limit: 2000, null: true
  401. t.boolean :frontend, null: false
  402. t.text :preferences, limit: 200.kilobytes + 1, null: true
  403. t.timestamps limit: 3, null: false
  404. end
  405. add_index :settings, [:name], unique: true
  406. add_index :settings, [:area]
  407. add_index :settings, [:frontend]
  408. create_table :store_objects do |t|
  409. t.string :name, limit: 250, null: false
  410. t.string :note, limit: 250, null: true
  411. t.timestamps limit: 3, null: false
  412. end
  413. add_index :store_objects, [:name], unique: true
  414. create_table :store_files do |t|
  415. t.string :sha, limit: 128, null: false
  416. t.string :provider, limit: 20, null: true
  417. t.timestamps limit: 3, null: false
  418. end
  419. add_index :store_files, [:sha], unique: true
  420. add_index :store_files, [:provider]
  421. create_table :stores do |t|
  422. t.references :store_object, null: false
  423. t.references :store_file, null: false
  424. t.integer :o_id, limit: 8, null: false
  425. t.string :preferences, limit: 2500, null: true
  426. t.string :size, limit: 50, null: true
  427. t.string :filename, limit: 250, null: false
  428. t.integer :created_by_id, null: false
  429. t.timestamps limit: 3, null: false
  430. end
  431. add_index :stores, %i[store_object_id o_id]
  432. add_index :stores, %i[store_file_id]
  433. add_foreign_key :stores, :store_objects
  434. add_foreign_key :stores, :store_files
  435. add_foreign_key :stores, :users, column: :created_by_id
  436. create_table :store_provider_dbs do |t|
  437. t.string :sha, limit: 128, null: false
  438. t.binary :data, limit: 200.megabytes, null: true
  439. t.timestamps limit: 3, null: false
  440. end
  441. add_index :store_provider_dbs, [:sha], unique: true
  442. create_table :avatars do |t|
  443. t.integer :o_id, null: false
  444. t.integer :object_lookup_id, null: false
  445. t.boolean :default, null: false, default: false
  446. t.boolean :deletable, null: false, default: true
  447. t.boolean :initial, null: false, default: false
  448. t.integer :store_full_id, null: true
  449. t.integer :store_resize_id, null: true
  450. t.string :store_hash, limit: 32, null: true
  451. t.string :source, limit: 100, null: false
  452. t.string :source_url, limit: 512, null: true
  453. t.integer :updated_by_id, null: false
  454. t.integer :created_by_id, null: false
  455. t.timestamps limit: 3, null: false
  456. end
  457. add_index :avatars, %i[o_id object_lookup_id]
  458. add_index :avatars, [:store_hash]
  459. add_index :avatars, [:source]
  460. add_index :avatars, [:default]
  461. add_foreign_key :avatars, :users, column: :created_by_id
  462. add_foreign_key :avatars, :users, column: :updated_by_id
  463. create_table :online_notifications do |t|
  464. t.integer :o_id, null: false
  465. t.integer :object_lookup_id, null: false
  466. t.integer :type_lookup_id, null: false
  467. t.integer :user_id, null: false
  468. t.boolean :seen, null: false, default: false
  469. t.integer :updated_by_id, null: false
  470. t.integer :created_by_id, null: false
  471. t.timestamps limit: 3, null: false
  472. end
  473. add_index :online_notifications, [:user_id]
  474. add_index :online_notifications, [:seen]
  475. add_index :online_notifications, [:created_at]
  476. add_index :online_notifications, [:updated_at]
  477. add_foreign_key :online_notifications, :users
  478. add_foreign_key :online_notifications, :users, column: :created_by_id
  479. add_foreign_key :online_notifications, :users, column: :updated_by_id
  480. create_table :schedulers do |t|
  481. t.string :name, limit: 250, null: false
  482. t.string :method, limit: 250, null: false
  483. t.integer :period, null: true
  484. t.integer :running, null: false, default: false
  485. t.timestamp :last_run, limit: 3, null: true
  486. t.integer :prio, null: false
  487. t.string :pid, limit: 250, null: true
  488. t.string :note, limit: 250, null: true
  489. t.string :error_message, null: true
  490. t.string :status, null: true
  491. t.boolean :active, null: false, default: false
  492. t.string :timeplan, limit: 2500, null: true
  493. t.integer :updated_by_id, null: false
  494. t.integer :created_by_id, null: false
  495. t.timestamps limit: 3, null: false
  496. end
  497. add_index :schedulers, [:name], unique: true
  498. add_foreign_key :schedulers, :users, column: :created_by_id
  499. add_foreign_key :schedulers, :users, column: :updated_by_id
  500. create_table :calendars do |t|
  501. t.string :name, limit: 250, null: true
  502. t.string :timezone, limit: 250, null: true
  503. t.string :business_hours, limit: 3000, null: true
  504. t.boolean :default, null: false, default: false
  505. t.string :ical_url, limit: 500, null: true
  506. t.text :public_holidays, limit: 500.kilobytes + 1, null: true
  507. t.text :last_log, limit: 500.kilobytes + 1, null: true
  508. t.timestamp :last_sync, limit: 3, null: true
  509. t.integer :updated_by_id, null: false
  510. t.integer :created_by_id, null: false
  511. t.timestamps limit: 3, null: false
  512. end
  513. add_index :calendars, [:name], unique: true
  514. add_foreign_key :calendars, :users, column: :created_by_id
  515. add_foreign_key :calendars, :users, column: :updated_by_id
  516. create_table :user_devices do |t|
  517. t.references :user, null: false
  518. t.string :name, limit: 250, null: false
  519. t.string :os, limit: 150, null: true
  520. t.string :browser, limit: 250, null: true
  521. t.string :location, limit: 150, null: true
  522. t.string :device_details, limit: 2500, null: true
  523. t.string :location_details, limit: 2500, null: true
  524. t.string :fingerprint, limit: 160, null: true
  525. t.string :user_agent, limit: 250, null: true
  526. t.string :ip, limit: 160, null: true
  527. t.timestamps limit: 3, null: false
  528. end
  529. add_index :user_devices, [:user_id]
  530. add_index :user_devices, %i[os browser location]
  531. add_index :user_devices, [:fingerprint]
  532. add_index :user_devices, [:updated_at]
  533. add_index :user_devices, [:created_at]
  534. add_foreign_key :user_devices, :users
  535. create_table :external_credentials do |t|
  536. t.string :name
  537. t.string :credentials, limit: 2500, null: false
  538. t.timestamps limit: 3, null: false
  539. end
  540. create_table :object_manager_attributes do |t|
  541. t.references :object_lookup, null: false
  542. t.string :name, limit: 200, null: false
  543. t.string :display, limit: 200, null: false
  544. t.string :data_type, limit: 100, null: false
  545. t.text :data_option, limit: 800.kilobytes + 1, null: true
  546. t.text :data_option_new, limit: 800.kilobytes + 1, null: true
  547. t.boolean :editable, null: false, default: true
  548. t.boolean :active, null: false, default: true
  549. t.string :screens, limit: 2000, null: true
  550. t.boolean :to_create, null: false, default: false
  551. t.boolean :to_migrate, null: false, default: false
  552. t.boolean :to_delete, null: false, default: false
  553. t.boolean :to_config, null: false, default: false
  554. t.integer :position, null: false
  555. t.integer :created_by_id, null: false
  556. t.integer :updated_by_id, null: false
  557. t.timestamps limit: 3, null: false
  558. end
  559. add_index :object_manager_attributes, %i[object_lookup_id name], unique: true
  560. add_index :object_manager_attributes, [:object_lookup_id]
  561. add_foreign_key :object_manager_attributes, :object_lookups
  562. add_foreign_key :object_manager_attributes, :users, column: :created_by_id
  563. add_foreign_key :object_manager_attributes, :users, column: :updated_by_id
  564. create_table :delayed_jobs, force: true do |t|
  565. t.integer :priority, default: 0 # Allows some jobs to jump to the front of the queue
  566. t.integer :attempts, default: 0 # Provides for retries, but still fail eventually.
  567. t.text :handler # YAML-encoded string of the object that will do work
  568. t.text :last_error # reason for last failure (See Note below)
  569. t.datetime :run_at, limit: 3 # When to run. Could be Time.zone.now for immediately, or sometime in the future.
  570. t.datetime :locked_at, limit: 3 # Set when a client is working on this object
  571. t.datetime :failed_at, limit: 3 # Set when all retries have failed (actually, by default, the record is deleted instead)
  572. t.string :locked_by # Who is working on this object (if locked)
  573. t.string :queue # The name of the queue this job is in
  574. t.timestamps limit: 3, null: false
  575. end
  576. add_index :delayed_jobs, %i[priority run_at], name: 'delayed_jobs_priority'
  577. create_table :external_syncs do |t|
  578. t.string :source, limit: 100, null: false
  579. t.string :source_id, limit: 200, null: false
  580. t.string :object, limit: 100, null: false
  581. t.integer :o_id, null: false
  582. t.text :last_payload, limit: 500.kilobytes + 1, null: true
  583. t.timestamps limit: 3, null: false
  584. end
  585. add_index :external_syncs, %i[source source_id], unique: true
  586. add_index :external_syncs, %i[source source_id object o_id], name: 'index_external_syncs_on_source_and_source_id_and_object_o_id'
  587. add_index :external_syncs, %i[object o_id]
  588. create_table :import_jobs do |t|
  589. t.string :name, limit: 250, null: false
  590. t.boolean :dry_run, default: false
  591. t.text :payload, limit: 80_000
  592. t.text :result, limit: 80_000
  593. t.datetime :started_at, limit: 3
  594. t.datetime :finished_at, limit: 3
  595. t.timestamps limit: 3, null: false
  596. end
  597. create_table :cti_logs do |t|
  598. t.string :direction, limit: 20, null: false
  599. t.string :state, limit: 20, null: false
  600. t.string :from, limit: 100, null: false
  601. t.string :from_comment, limit: 250, null: true
  602. t.string :to, limit: 100, null: false
  603. t.string :to_comment, limit: 250, null: true
  604. t.string :queue, limit: 250, null: true
  605. t.string :call_id, limit: 250, null: false
  606. t.string :comment, limit: 500, null: true
  607. t.timestamp :initialized_at, limit: 3, null: true
  608. t.timestamp :start_at, limit: 3, null: true
  609. t.timestamp :end_at, limit: 3, null: true
  610. t.integer :duration_waiting_time, null: true
  611. t.integer :duration_talking_time, null: true
  612. t.boolean :done, null: false, default: true
  613. t.text :preferences, limit: 500.kilobytes + 1, null: true
  614. t.timestamps limit: 3, null: false
  615. end
  616. add_index :cti_logs, [:call_id], unique: true
  617. add_index :cti_logs, [:direction]
  618. add_index :cti_logs, [:from]
  619. create_table :cti_caller_ids do |t|
  620. t.string :caller_id, limit: 100, null: false
  621. t.string :comment, limit: 500, null: true
  622. t.string :level, limit: 100, null: false
  623. t.string :object, limit: 100, null: false
  624. t.integer :o_id, null: false
  625. t.references :user, null: true
  626. t.text :preferences, limit: 500.kilobytes + 1, null: true
  627. t.timestamps limit: 3, null: false
  628. end
  629. add_index :cti_caller_ids, [:caller_id]
  630. add_index :cti_caller_ids, %i[caller_id level]
  631. add_index :cti_caller_ids, %i[caller_id user_id]
  632. add_index :cti_caller_ids, %i[object o_id]
  633. add_index :cti_caller_ids, %i[object o_id level user_id caller_id], name: 'index_cti_caller_ids_on_object_o_id_level_user_id_caller_id'
  634. add_foreign_key :cti_caller_ids, :users
  635. create_table :stats_stores do |t|
  636. t.references :stats_storable, polymorphic: true, index: true
  637. t.string :key, limit: 250, null: true
  638. t.string :data, limit: 5000, null: true
  639. t.integer :created_by_id, null: false
  640. t.timestamps limit: 3, null: false
  641. end
  642. add_index :stats_stores, [:key]
  643. add_index :stats_stores, [:created_by_id]
  644. add_index :stats_stores, [:created_at]
  645. add_foreign_key :stats_stores, :users, column: :created_by_id
  646. create_table :http_logs do |t|
  647. t.column :direction, :string, limit: 20, null: false
  648. t.column :facility, :string, limit: 100, null: false
  649. t.column :method, :string, limit: 100, null: false
  650. t.column :url, :string, limit: 255, null: false
  651. t.column :status, :string, limit: 20, null: true
  652. t.column :ip, :string, limit: 50, null: true
  653. t.column :request, :string, limit: 10_000, null: false
  654. t.column :response, :string, limit: 10_000, null: false
  655. t.column :updated_by_id, :integer, null: true
  656. t.column :created_by_id, :integer, null: true
  657. t.timestamps limit: 3, null: false
  658. end
  659. add_index :http_logs, [:facility]
  660. add_index :http_logs, [:created_by_id]
  661. add_index :http_logs, [:created_at]
  662. add_foreign_key :http_logs, :users, column: :created_by_id
  663. add_foreign_key :http_logs, :users, column: :updated_by_id
  664. create_table :active_job_locks do |t|
  665. t.string :lock_key
  666. t.string :active_job_id
  667. t.timestamps limit: 3
  668. end
  669. add_index :active_job_locks, :lock_key, unique: true
  670. add_index :active_job_locks, :active_job_id, unique: true
  671. create_table :smime_certificates do |t|
  672. t.string :subject, limit: 500, null: false
  673. t.string :doc_hash, limit: 250, null: false
  674. t.string :fingerprint, limit: 250, null: false
  675. t.string :modulus, limit: 1024, null: false
  676. t.datetime :not_before_at, null: true, limit: 3
  677. t.datetime :not_after_at, null: true, limit: 3
  678. t.binary :raw, limit: 10.megabytes, null: false
  679. t.binary :private_key, limit: 10.megabytes, null: true
  680. t.string :private_key_secret, limit: 500, null: true
  681. t.timestamps limit: 3, null: false
  682. end
  683. add_index :smime_certificates, [:fingerprint], unique: true
  684. add_index :smime_certificates, [:modulus]
  685. add_index :smime_certificates, [:subject]
  686. create_table :data_privacy_tasks do |t|
  687. t.column :state, :string, limit: 150, default: 'in process', null: true
  688. t.references :deletable, polymorphic: true
  689. t.text :preferences
  690. t.column :updated_by_id, :integer, null: false
  691. t.column :created_by_id, :integer, null: false
  692. t.timestamps limit: 3, null: false
  693. end
  694. add_index :data_privacy_tasks, [:state]
  695. create_table :mentions do |t|
  696. t.references :mentionable, polymorphic: true, null: false
  697. t.column :user_id, :integer, null: false
  698. t.column :updated_by_id, :integer, null: false
  699. t.column :created_by_id, :integer, null: false
  700. t.timestamps limit: 3, null: false
  701. end
  702. add_index :mentions, %i[mentionable_id mentionable_type user_id], unique: true, name: 'index_mentions_mentionable_user'
  703. add_foreign_key :mentions, :users, column: :created_by_id
  704. add_foreign_key :mentions, :users, column: :updated_by_id
  705. add_foreign_key :mentions, :users, column: :user_id
  706. create_table :core_workflows do |t|
  707. t.string :name, limit: 100, null: false
  708. t.string :object, limit: 100, null: true
  709. t.text :preferences, limit: 500.kilobytes + 1, null: true
  710. t.text :condition_saved, limit: 500.kilobytes + 1, null: true
  711. t.text :condition_selected, limit: 500.kilobytes + 1, null: true
  712. t.text :perform, limit: 500.kilobytes + 1, null: true
  713. t.boolean :active, null: false, default: true
  714. t.boolean :stop_after_match, null: false, default: false
  715. t.boolean :changeable, null: false, default: true
  716. t.integer :priority, null: false, default: 0
  717. t.integer :updated_by_id, null: false
  718. t.integer :created_by_id, null: false
  719. t.timestamps limit: 3, null: false
  720. end
  721. add_index :core_workflows, [:name], unique: true
  722. add_foreign_key :core_workflows, :users, column: :created_by_id
  723. add_foreign_key :core_workflows, :users, column: :updated_by_id
  724. create_table :ldap_sources do |t|
  725. t.string :name, limit: 100, null: false
  726. t.text :preferences, limit: 5.megabytes + 1, null: true
  727. t.integer :prio, null: false
  728. t.boolean :active, null: false, default: true
  729. t.integer :updated_by_id, null: false
  730. t.integer :created_by_id, null: false
  731. t.timestamps limit: 3, null: false
  732. end
  733. add_index :ldap_sources, [:name], unique: true
  734. add_foreign_key :ldap_sources, :users, column: :created_by_id
  735. add_foreign_key :ldap_sources, :users, column: :updated_by_id
  736. end
  737. end