[Sommaire] [Imprimer]

   1  CREATE TABLE webcal_user (
   2    cal_login VARCHAR(25) NOT NULL,
   3    cal_passwd VARCHAR(32),
   4    cal_lastname VARCHAR(25),
   5    cal_firstname VARCHAR(25),
   6    cal_is_admin CHAR(1) DEFAULT 'N',
   7    cal_email VARCHAR(75),
   8    PRIMARY KEY ( cal_login )
   9  );
  10  
  11  INSERT INTO webcal_user 
  12   (cal_login, cal_passwd, cal_lastname, cal_firstname, cal_is_admin) 
  13   VALUES ( 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Administrator', 'Default', 'Y' );
  14  
  15  
  16  CREATE TABLE webcal_entry (
  17    cal_id INT NOT NULL,
  18    cal_group_id INT,
  19    cal_ext_for_id INT,
  20    cal_create_by VARCHAR(25) NOT NULL,
  21    cal_date INT NOT NULL,
  22    cal_time INT,
  23    cal_mod_date INT,
  24    cal_mod_time INT,
  25    cal_duration INT NOT NULL,
  26    cal_priority INT DEFAULT 2,
  27    cal_type CHAR(1) DEFAULT 'E',
  28    cal_access CHAR(1) DEFAULT 'P',
  29    cal_name VARCHAR(80) NOT NULL,
  30    cal_description varchar(1024),
  31    PRIMARY KEY ( cal_id )
  32  );
  33  
  34  
  35  CREATE TABLE webcal_entry_repeats (
  36     cal_id INT DEFAULT 0 NOT NULL,
  37     cal_type VARCHAR(20),
  38     cal_end INT,
  39     cal_frequency INT DEFAULT 1,
  40     cal_days CHAR(7),
  41     PRIMARY KEY (cal_id)
  42  );
  43  
  44  
  45  CREATE TABLE webcal_entry_repeats_not (
  46    cal_id INT NOT NULL,
  47    cal_date INT NOT NULL,
  48    PRIMARY KEY ( cal_id, cal_date )
  49  );
  50  
  51  
  52  
  53  CREATE TABLE webcal_entry_user (
  54    cal_id int DEFAULT 0 NOT NULL,
  55    cal_login varchar(25) DEFAULT '' NOT NULL, 
  56    cal_status char(1) DEFAULT 'A' NOT NULL,
  57    cal_category INT DEFAULT NULL,
  58    PRIMARY KEY ( cal_id,cal_login )
  59  );
  60  
  61  
  62  CREATE TABLE webcal_entry_ext_user (
  63    cal_id INT DEFAULT 0 NOT NULL,
  64    cal_fullname VARCHAR(50) NOT NULL,
  65    cal_email VARCHAR(75) DEFAULT NULL,
  66    PRIMARY KEY ( cal_id, cal_fullname )
  67  );
  68  
  69  
  70  
  71  CREATE TABLE webcal_user_pref (
  72    cal_login varchar(25) NOT NULL,
  73    cal_setting varchar(25) NOT NULL,
  74    cal_value varchar(100),
  75    PRIMARY KEY ( cal_login, cal_setting )
  76  );
  77  
  78  
  79  
  80  CREATE TABLE webcal_user_layers (
  81    cal_layerid INT DEFAULT 0 NOT NULL,
  82    cal_login varchar(25) NOT NULL,
  83    cal_layeruser varchar(25) NOT NULL,
  84    cal_color varchar(25),
  85    cal_dups CHAR(1) DEFAULT 'N',
  86    PRIMARY KEY ( cal_login, cal_layeruser )
  87  );
  88  
  89  
  90  
  91  CREATE TABLE webcal_site_extras (
  92    cal_id INT DEFAULT 0 NOT NULL,
  93    cal_name VARCHAR(25) NOT NULL,
  94    cal_type INT NOT NULL,
  95    cal_date INT DEFAULT 0,
  96    cal_remind INT DEFAULT 0,
  97    cal_data varchar(1024),
  98    PRIMARY KEY ( cal_id, cal_name, cal_type )
  99  );
 100  
 101  
 102  CREATE TABLE webcal_reminder_log (
 103    cal_id INT DEFAULT 0 NOT NULL,
 104    cal_name VARCHAR(25) NOT NULL,
 105    cal_event_date INT NOT NULL DEFAULT 0,
 106    cal_last_sent INT NOT NULL DEFAULT 0,
 107    PRIMARY KEY ( cal_id, cal_name, cal_event_date )
 108  );
 109  
 110  CREATE TABLE webcal_group (
 111    cal_group_id INT NOT NULL,
 112    cal_owner VARCHAR(25),
 113    cal_name VARCHAR(50) NOT NULL,
 114    cal_last_update INT NOT NULL,
 115    PRIMARY KEY ( cal_group_id )
 116  );
 117  
 118  CREATE TABLE webcal_group_user (
 119    cal_group_id INT NOT NULL,
 120    cal_login VARCHAR(25) NOT NULL,
 121    PRIMARY KEY ( cal_group_id, cal_login )
 122  );
 123  
 124  CREATE TABLE webcal_view (
 125    cal_view_id INT NOT NULL,
 126    cal_owner VARCHAR(25) NOT NULL,
 127    cal_name VARCHAR(50) NOT NULL,
 128    cal_view_type CHAR(1),
 129    cal_is_global CHAR(1) DEFAULT 'N' NOT NULL,
 130    PRIMARY KEY ( cal_view_id )
 131  );
 132  
 133  CREATE TABLE webcal_view_user (
 134    cal_view_id INT NOT NULL,
 135    cal_login VARCHAR(25) NOT NULL,
 136    PRIMARY KEY ( cal_view_id, cal_login )
 137  );
 138  
 139  CREATE TABLE webcal_config (
 140    cal_setting VARCHAR(50) NOT NULL,
 141    cal_value VARCHAR(100),
 142    PRIMARY KEY ( cal_setting )
 143  );
 144  
 145  
 146  INSERT INTO webcal_config ( cal_setting, cal_value )
 147    VALUES ( 'application_name', 'WebCalendar' );
 148  INSERT INTO webcal_config ( cal_setting, cal_value )
 149    VALUES ( 'LANGUAGE', 'Browser-defined' );
 150  INSERT INTO webcal_config ( cal_setting, cal_value )
 151    VALUES ( 'demo_mode', 'N' );
 152  INSERT INTO webcal_config ( cal_setting, cal_value )
 153    VALUES ( 'require_approvals', 'Y' );
 154  INSERT INTO webcal_config ( cal_setting, cal_value )
 155    VALUES ( 'groups_enabled', 'N' );
 156  INSERT INTO webcal_config ( cal_setting, cal_value )
 157    VALUES ( 'user_sees_only_his_groups', 'N' );
 158  INSERT INTO webcal_config ( cal_setting, cal_value )
 159    VALUES ( 'categories_enabled', 'N' );
 160  INSERT INTO webcal_config ( cal_setting, cal_value )
 161    VALUES ( 'allow_conflicts', 'N' );
 162  INSERT INTO webcal_config ( cal_setting, cal_value )
 163    VALUES ( 'conflict_repeat_months', '6' );
 164  INSERT INTO webcal_config ( cal_setting, cal_value )
 165    VALUES ( 'disable_priority_field', 'N' );
 166  INSERT INTO webcal_config ( cal_setting, cal_value )
 167    VALUES ( 'disable_access_field', 'N' );
 168  INSERT INTO webcal_config ( cal_setting, cal_value )
 169    VALUES ( 'disable_participants_field', 'N' );
 170  INSERT INTO webcal_config ( cal_setting, cal_value )
 171    VALUES ( 'disable_repeating_field', 'N' );
 172  INSERT INTO webcal_config ( cal_setting, cal_value )
 173    VALUES ( 'allow_view_other', 'Y' );
 174  INSERT INTO webcal_config ( cal_setting, cal_value )
 175    VALUES ( 'email_fallback_from', 'youremailhere' );
 176  INSERT INTO webcal_config ( cal_setting, cal_value )
 177    VALUES ( 'remember_last_login', 'Y' );
 178  INSERT INTO webcal_config ( cal_setting, cal_value )
 179    VALUES ( 'allow_color_customization', 'Y' );
 180  INSERT INTO webcal_config ( cal_setting, cal_value )
 181    VALUES ('BGCOLOR','#FFFFFF');
 182  INSERT INTO webcal_config ( cal_setting, cal_value )
 183    VALUES ('TEXTCOLOR','#000000');
 184  INSERT INTO webcal_config ( cal_setting, cal_value )
 185    VALUES ('H2COLOR','#000000');
 186  INSERT INTO webcal_config ( cal_setting, cal_value )
 187    VALUES ('CELLBG','#C0C0C0');
 188  INSERT INTO webcal_config ( cal_setting, cal_value )
 189    VALUES ('WEEKENDBG','#D0D0D0');
 190  INSERT INTO webcal_config ( cal_setting, cal_value )
 191    VALUES ('TABLEBG','#000000');
 192  INSERT INTO webcal_config ( cal_setting, cal_value )
 193    VALUES ('THBG','#FFFFFF');
 194  INSERT INTO webcal_config ( cal_setting, cal_value )
 195    VALUES ('THFG','#000000');
 196  INSERT INTO webcal_config ( cal_setting, cal_value )
 197    VALUES ('POPUP_FG','#000000');
 198  INSERT INTO webcal_config ( cal_setting, cal_value )
 199    VALUES ('POPUP_BG','#FFFFFF');
 200  INSERT INTO webcal_config ( cal_setting, cal_value )
 201    VALUES ('TODAYCELLBG','#FFFF33');
 202  INSERT INTO webcal_config ( cal_setting, cal_value )
 203    VALUES ( 'STARTVIEW', 'week.php' );
 204  INSERT INTO webcal_config ( cal_setting, cal_value )
 205    VALUES ( 'WEEK_START', '0' );
 206  INSERT INTO webcal_config ( cal_setting, cal_value )
 207    VALUES ( 'TIME_FORMAT', '12' );
 208  INSERT INTO webcal_config ( cal_setting, cal_value )
 209    VALUES ( 'DISPLAY_UNAPPROVED', 'Y' );
 210  INSERT INTO webcal_config ( cal_setting, cal_value )
 211    VALUES ( 'DISPLAY_WEEKNUMBER', 'Y' );
 212  INSERT INTO webcal_config ( cal_setting, cal_value )
 213    VALUES ( 'WORK_DAY_START_HOUR', '8' );
 214  INSERT INTO webcal_config ( cal_setting, cal_value )
 215    VALUES ( 'WORK_DAY_END_HOUR', '17' );
 216  INSERT INTO webcal_config ( cal_setting, cal_value )
 217    VALUES ( 'send_email', 'N' );
 218  INSERT INTO webcal_config ( cal_setting, cal_value )
 219    VALUES ( 'EMAIL_REMINDER', 'Y' );
 220  INSERT INTO webcal_config ( cal_setting, cal_value )
 221    VALUES ( 'EMAIL_EVENT_ADDED', 'Y' );
 222  INSERT INTO webcal_config ( cal_setting, cal_value )
 223    VALUES ( 'EMAIL_EVENT_UPDATED', 'Y' );
 224  INSERT INTO webcal_config ( cal_setting, cal_value )
 225    VALUES ( 'EMAIL_EVENT_DELETED', 'Y' );
 226  INSERT INTO webcal_config ( cal_setting, cal_value )
 227    VALUES ( 'EMAIL_EVENT_REJECTED', 'Y' );
 228  INSERT INTO webcal_config ( cal_setting, cal_value )
 229    VALUES ('auto_refresh', 'N');
 230  INSERT INTO webcal_config ( cal_setting, cal_value )
 231    VALUES ('nonuser_enabled', 'N');
 232  INSERT INTO webcal_config ( cal_setting, cal_value )
 233    VALUES ('allow_html_description', 'N');
 234  INSERT INTO webcal_config ( cal_setting, cal_value )
 235    VALUES ('reports_enabled', 'N');
 236  INSERT INTO webcal_config ( cal_setting, cal_value )
 237    VALUES ('DISPLAY_WEEKENDS', 'Y');
 238  INSERT INTO webcal_config ( cal_setting, cal_value )
 239    VALUES ('DISPLAY_DESC_PRINT_DAY', 'N');
 240  INSERT INTO webcal_config ( cal_setting, cal_value )
 241    VALUES ('DATE_FORMAT', '__month__ __dd__, __yyyy__');
 242  INSERT INTO webcal_config ( cal_setting, cal_value )
 243    VALUES ('TIME_SLOTS', '12');
 244  INSERT INTO webcal_config ( cal_setting, cal_value )
 245    VALUES ('TIMED_EVT_LEN', 'D');
 246  INSERT INTO webcal_config ( cal_setting, cal_value )
 247    VALUES ('PUBLISH_ENABLED', 'N');
 248  INSERT INTO webcal_config ( cal_setting, cal_value )
 249    VALUES ('DATE_FORMAT_MY', '__month__ __yyyy__');
 250  INSERT INTO webcal_config ( cal_setting, cal_value )
 251    VALUES ('DATE_FORMAT_MD', '__month__ __dd__');
 252  INSERT INTO webcal_config ( cal_setting, cal_value )
 253    VALUES ('CUSTOM_SCRIPT', 'N');
 254  INSERT INTO webcal_config ( cal_setting, cal_value )
 255    VALUES ('CUSTOM_HEADER', 'N');
 256  INSERT INTO webcal_config ( cal_setting, cal_value )
 257    VALUES ('CUSTOM_TRAILER', 'N');
 258  INSERT INTO webcal_config ( cal_setting, cal_value )
 259    VALUES ('bold_days_in_year', 'Y');
 260  INSERT INTO webcal_config ( cal_setting, cal_value )
 261    VALUES ('site_extras_in_popup', 'N');
 262  INSERT INTO webcal_config ( cal_setting, cal_value )
 263    VALUES ('add_link_in_views', 'Y');
 264  INSERT INTO webcal_config ( cal_setting, cal_value )
 265    VALUES ('allow_conflict_override', 'Y');
 266  INSERT INTO webcal_config ( cal_setting, cal_value )
 267    VALUES ('limit_appts', 'N');
 268  INSERT INTO webcal_config ( cal_setting, cal_value )
 269    VALUES ('limit_appts_number', '6');
 270  INSERT INTO webcal_config ( cal_setting, cal_value )
 271    VALUES ('public_access', 'N');
 272  INSERT INTO webcal_config ( cal_setting, cal_value )
 273    VALUES ('public_access_default_visible', 'N');
 274  INSERT INTO webcal_config ( cal_setting, cal_value )
 275    VALUES ('public_access_default_selected', 'N');
 276  INSERT INTO webcal_config ( cal_setting, cal_value )
 277    VALUES ('public_access_others', 'N');
 278  INSERT INTO webcal_config ( cal_setting, cal_value )
 279    VALUES ('public_access_can_add', 'N');
 280  INSERT INTO webcal_config ( cal_setting, cal_value )
 281    VALUES ('public_access_add_needs_approval', 'Y');
 282  INSERT INTO webcal_config ( cal_setting, cal_value )
 283    VALUES ('public_access_view_part', 'N');
 284  INSERT INTO webcal_config ( cal_setting, cal_value )
 285    VALUES ('nonuser_at_top', 'Y');
 286  INSERT INTO webcal_config ( cal_setting, cal_value )
 287    VALUES ('allow_external_users', 'N');
 288  INSERT INTO webcal_config ( cal_setting, cal_value )
 289    VALUES ('external_notifications', 'N');
 290  INSERT INTO webcal_config ( cal_setting, cal_value )
 291    VALUES ('external_reminders', 'N');
 292  INSERT INTO webcal_config ( cal_setting, cal_value )
 293    VALUES ('enable_gradients', 'N');
 294  
 295  
 296  
 297  CREATE TABLE webcal_entry_log (
 298    cal_log_id INT NOT NULL,
 299    cal_entry_id INT NOT NULL,
 300    cal_login VARCHAR(25) NOT NULL,
 301    cal_user_cal VARCHAR(25),
 302    cal_type CHAR(1) NOT NULL,
 303    cal_date INT NOT NULL,
 304    cal_time INT,
 305    cal_text varchar(1024),
 306    PRIMARY KEY ( cal_log_id )
 307  );
 308  
 309  
 310  CREATE TABLE webcal_categories (
 311    cat_id INT NOT NULL,
 312    cat_owner VARCHAR(25),
 313    cat_name VARCHAR(80) NOT NULL,
 314    PRIMARY KEY ( cat_id )
 315  );
 316  
 317  CREATE TABLE webcal_asst (
 318    cal_boss VARCHAR(25) NOT NULL,
 319    cal_assistant VARCHAR(25) NOT NULL,
 320    PRIMARY KEY ( cal_boss, cal_assistant )
 321  );
 322  
 323  CREATE TABLE webcal_nonuser_cals (
 324    cal_login VARCHAR(25) NOT NULL,
 325    cal_lastname VARCHAR(25),
 326    cal_firstname VARCHAR(25),
 327    cal_admin VARCHAR(25) NOT NULL,
 328    PRIMARY KEY ( cal_login )
 329  );
 330  
 331  CREATE TABLE webcal_import (
 332    cal_import_id INT NOT NULL,
 333    cal_name VARCHAR(50) DEFAULT NULL,
 334    cal_date INT NOT NULL,
 335    cal_type VARCHAR(10) NOT NULL,
 336    cal_login VARCHAR(25),
 337    PRIMARY KEY ( cal_import_id )
 338  );
 339  
 340  CREATE TABLE webcal_import_data (
 341    cal_import_id INT NOT NULL,
 342    cal_id int NOT NULL,
 343    cal_login VARCHAR(25) NOT NULL,
 344    cal_import_type VARCHAR(15) NOT NULL,
 345    cal_external_id VARCHAR(200) DEFAULT NULL,
 346    PRIMARY KEY  ( cal_id, cal_login )
 347  );
 348  
 349  CREATE TABLE webcal_report (
 350    cal_login VARCHAR(25) NOT NULL,
 351    cal_report_id INT NOT NULL,
 352    cal_is_global CHAR(1) DEFAULT 'N' NOT NULL,
 353    cal_report_type VARCHAR(20) NOT NULL,
 354    cal_include_header CHAR(1) DEFAULT 'Y' NOT NULL,
 355    cal_report_name VARCHAR(50) NOT NULL,
 356    cal_time_range INT NOT NULL,
 357    cal_user VARCHAR(25) DEFAULT NULL,
 358    cal_allow_nav CHAR(1) DEFAULT 'Y',
 359    cal_cat_id INT DEFAULT NULL,
 360    cal_include_empty CHAR(1) DEFAULT 'N',
 361    cal_show_in_trailer CHAR(1) DEFAULT 'N',
 362    cal_update_date INT NOT NULL,
 363    PRIMARY KEY ( cal_report_id )
 364  );
 365  
 366  CREATE TABLE webcal_report_template (
 367    cal_report_id INT NOT NULL,
 368    cal_template_type CHAR(1) NOT NULL,
 369    cal_template_text VARCHAR(1024),
 370    PRIMARY KEY ( cal_report_id, cal_template_type )
 371  );
 372  
 373  
 374  
 375