[Sommaire] [Imprimer]

   1  
   2   /* Table: WEBCAL_ENTRY, Owner: SYSDBA */
   3  
   4  CREATE TABLE "WEBCAL_ENTRY" 
   5  (
   6     "CAL_ID" INTEGER NOT NULL,
   7     "CAL_GROUP_ID" INTEGER,
   8     "CAL_DATE" INTEGER NOT NULL,
   9     "CAL_EXT_FOR_ID" INT NULL,
  10     "CAL_TIME" INTEGER,
  11     "CAL_MOD_DATE" INTEGER,
  12     "CAL_MOD_TIME" INTEGER,
  13     "CAL_DURATION" INTEGER NOT NULL,
  14     "CAL_PRIORITY" INTEGER DEFAULT 2,
  15     "CAL_TYPE" CHAR(1) CHARACTER SET WIN1252 DEFAULT 'E',
  16     "CAL_ACCESS" CHAR(1) CHARACTER SET WIN1252 DEFAULT 'P',
  17     "CAL_NAME" VARCHAR(80) CHARACTER SET WIN1252 NOT NULL,
  18     "CAL_DESCRIPTION" VARCHAR(500) CHARACTER SET WIN1252,
  19     "CAL_CREATE_BY" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL
  20  );
  21  
  22  /* create a default admin user */
  23  INSERT INTO webcal_user ( cal_login, cal_passwd, cal_lastname, cal_firstname, cal_is_admin ) VALUES ( 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Administrator', 'Default', 'Y' );
  24  
  25  
  26  
  27  
  28  
  29  /* Table: WEBCAL_ENTRY_REPEATS, Owner: SYSDBA */
  30  
  31  CREATE TABLE "WEBCAL_ENTRY_REPEATS" 
  32  (
  33     "CAL_ID" INTEGER DEFAULT 0 NOT NULL,
  34     "CAL_TYPE" VARCHAR(20) CHARACTER SET WIN1252,
  35     "CAL_END" INTEGER,
  36     "CAL_FREQUENCY" INTEGER DEFAULT 1,
  37     "CAL_DAYS" CHAR(7) CHARACTER SET WIN1252
  38  );
  39  
  40  /* Table: WEBCAL_ENTRY_REPEATS_NOT, Owner: SYSDBA */
  41  CREATE TABLE "WEBCAL_ENTRY_REPEATS_NOT" 
  42     "CAL_ID" INTEGER DEFAULT 0 NOT NULL,
  43     "CAL_DATE" INTEGER NOT NULL
  44  );
  45  
  46  
  47  /* Table: WEBCAL_ENTRY_USER, Owner: SYSDBA */
  48  
  49  CREATE TABLE "WEBCAL_ENTRY_USER" 
  50  (
  51     "CAL_ID" INTEGER DEFAULT 0 NOT NULL,
  52     "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 DEFAULT '' NOT NULL,
  53     "CAL_STATUS" VARCHAR(1) CHARACTER SET WIN1252 DEFAULT 'A',
  54     "CAL_CATEGORY" INTEGER NULL
  55  );
  56  
  57  
  58  /* Table: WEBCAL_ENTRY_EXT_USER, Owner: SYSDBA */
  59  
  60  CREATE TABLE "WEBCAL_ENTRY_EXT_USER" 
  61  (
  62     "CAL_ID" INTEGER DEFAULT 0 NOT NULL,
  63     "CAL_FULLNAME" VARCHAR(50) CHARACTER SET WIN1252 DEFAULT '' NOT NULL,
  64     "CAL_EMAIL" VARCHAR(75) CHARACTER SET WIN1252
  65  );
  66  
  67  
  68  /* Table: WEBCAL_REMINDER_LOG, Owner: SYSDBA */
  69  
  70  CREATE TABLE "WEBCAL_REMINDER_LOG" 
  71  (
  72     "CAL_ID" INTEGER DEFAULT 0 NOT NULL,
  73     "CAL_NAME" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
  74     "CAL_EVENT_DATE" INTEGER DEFAULT 0 NOT NULL,
  75     "CAL_LAST_SENT" INTEGER DEFAULT 0 NOT NULL
  76  );
  77  
  78  
  79  /* Table: WEBCAL_SITE_EXTRAS, Owner: SYSDBA */
  80  
  81  CREATE TABLE "WEBCAL_SITE_EXTRAS" 
  82  (
  83     "CAL_ID" INTEGER DEFAULT 0 NOT NULL,
  84     "CAL_NAME" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
  85     "CAL_TYPE" INTEGER NOT NULL,
  86     "CAL_DATE" INTEGER DEFAULT 0,
  87     "CAL_REMIND" INTEGER DEFAULT 0,
  88     "CAL_DATA" VARCHAR(500) CHARACTER SET WIN1252
  89  );
  90  
  91  
  92  /* Table: WEBCAL_USER, Owner: SYSDBA */
  93  
  94  CREATE TABLE "WEBCAL_USER" 
  95  (
  96     "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
  97     "CAL_PASSWD" VARCHAR(32) CHARACTER SET WIN1252,
  98     "CAL_LASTNAME" VARCHAR(25) CHARACTER SET WIN1252,
  99     "CAL_FIRSTNAME" VARCHAR(25) CHARACTER SET WIN1252,
 100     "CAL_IS_ADMIN" CHAR(1) CHARACTER SET WIN1252 DEFAULT 'N',
 101     "CAL_EMAIL" VARCHAR(75) CHARACTER SET WIN1252
 102  );
 103  
 104  
 105  /* Table: WEBCAL_USER_LAYERS, Owner: SYSDBA */
 106  
 107  CREATE TABLE "WEBCAL_USER_LAYERS" 
 108  (
 109     "CAL_LAYERID" INTEGER DEFAULT 0 NOT NULL,
 110     "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
 111     "CAL_LAYERUSER" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
 112     "CAL_COLOR" VARCHAR(25) CHARACTER SET WIN1252,
 113     "CAL_DUPS" CHAR(1) CHARACTER SET WIN1252 DEFAULT 'N'
 114  );
 115  
 116  
 117  /* Table: WEBCAL_USER_PREF, Owner: SYSDBA */
 118  
 119  CREATE TABLE "WEBCAL_USER_PREF" 
 120  (
 121     "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
 122     "CAL_SETTING" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
 123     "CAL_VALUE" VARCHAR(100) CHARACTER SET WIN1252
 124  );
 125  
 126  /* Table: WEBCAL_GROUP, Owner: SYSDBA */
 127  
 128  CREATE TABLE "WEBCAL_GROUP" 
 129  (
 130     "CAL_GROUP_ID" INTEGER DEFAULT 0 NOT NULL,
 131     "CAL_OWNER" VARCHAR(25) CHARACTER SET WIN1252 NULL,
 132     "CAL_NAME" VARCHAR(50) CHARACTER SET WIN1252 NOT NULL,
 133     "CAL_LAST_UPDATE" INTEGER DEFAULT 0 NOT NULL
 134  );
 135  
 136  /* Table: WEBCAL_GROUP_USER, Owner: SYSDBA */
 137  
 138  CREATE TABLE "WEBCAL_GROUP_USER" 
 139  (
 140     "CAL_GROUP_ID" INTEGER DEFAULT 0 NOT NULL,
 141     "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL
 142  );
 143  
 144  /* Table: WEBCAL_VIEW, Owner: SYSDBA */
 145  
 146  CREATE TABLE "WEBCAL_VIEW" 
 147  (
 148     "CAL_VIEW_ID" INTEGER DEFAULT 0 NOT NULL,
 149     "CAL_OWNER" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
 150     "CAL_NAME" VARCHAR(50) CHARACTER SET WIN1252 NOT NULL,
 151     "CAL_VIEW_TYPE" VARCHAR(1) CHARACTER SET WIN1252 NOT NULL,
 152     "CAL_IS_GLOBAL" CHAR(1) CHARACTER SET WIN1252 NOT NULL DEFAULT 'N'
 153  );
 154  
 155  /* Table: WEBCAL_VIEW_USER, Owner: SYSDBA */
 156  
 157  CREATE TABLE "WEBCAL_VIEW_USER" 
 158  (
 159     "CAL_VIEW_ID" INTEGER DEFAULT 0 NOT NULL,
 160     "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL
 161  );
 162  
 163  /* Table: WEBCAL_CONFIG, Owner: SYSDBA */
 164  
 165  CREATE TABLE "WEBCAL_CONFIG" 
 166  (
 167     "CAL_SETTING" VARCHAR(50) CHARACTER SET WIN1252 NOT NULL,
 168     "CAL_VALUE" VARCHAR(100) CHARACTER SET WIN1252
 169  );
 170  
 171  
 172  
 173  /* default system settings */
 174  INSERT INTO webcal_config ( cal_setting, cal_value )
 175    VALUES ( 'application_name', 'WebCalendar' );
 176  INSERT INTO webcal_config ( cal_setting, cal_value )
 177    VALUES ( 'LANGUAGE', 'Browser-defined' );
 178  INSERT INTO webcal_config ( cal_setting, cal_value )
 179    VALUES ( 'demo_mode', 'N' );
 180  INSERT INTO webcal_config ( cal_setting, cal_value )
 181    VALUES ( 'require_approvals', 'Y' );
 182  INSERT INTO webcal_config ( cal_setting, cal_value )
 183    VALUES ( 'groups_enabled', 'N' );
 184  INSERT INTO webcal_config ( cal_setting, cal_value )
 185    VALUES ( 'user_sees_only_his_groups', 'N' );
 186  INSERT INTO webcal_config ( cal_setting, cal_value )
 187    VALUES ( 'categories_enabled', 'N' );
 188  INSERT INTO webcal_config ( cal_setting, cal_value )
 189    VALUES ( 'allow_conflicts', 'N' );
 190  INSERT INTO webcal_config ( cal_setting, cal_value )
 191    VALUES ( 'conflict_repeat_months', '6' );
 192  INSERT INTO webcal_config ( cal_setting, cal_value )
 193    VALUES ( 'disable_priority_field', 'N' );
 194  INSERT INTO webcal_config ( cal_setting, cal_value )
 195    VALUES ( 'disable_access_field', 'N' );
 196  INSERT INTO webcal_config ( cal_setting, cal_value )
 197    VALUES ( 'disable_participants_field', 'N' );
 198  INSERT INTO webcal_config ( cal_setting, cal_value )
 199    VALUES ( 'disable_repeating_field', 'N' );
 200  INSERT INTO webcal_config ( cal_setting, cal_value )
 201    VALUES ( 'allow_view_other', 'Y' );
 202  INSERT INTO webcal_config ( cal_setting, cal_value )
 203    VALUES ( 'email_fallback_from', 'youremailhere' );
 204  INSERT INTO webcal_config ( cal_setting, cal_value )
 205    VALUES ( 'remember_last_login', 'Y' );
 206  INSERT INTO webcal_config ( cal_setting, cal_value )
 207    VALUES ( 'allow_color_customization', 'Y' );
 208  INSERT INTO webcal_config ( cal_setting, cal_value )
 209    VALUES ('BGCOLOR','#FFFFFF');
 210  INSERT INTO webcal_config ( cal_setting, cal_value )
 211    VALUES ('TEXTCOLOR','#000000');
 212  INSERT INTO webcal_config ( cal_setting, cal_value )
 213    VALUES ('H2COLOR','#000000');
 214  INSERT INTO webcal_config ( cal_setting, cal_value )
 215    VALUES ('CELLBG','#C0C0C0');
 216  INSERT INTO webcal_config ( cal_setting, cal_value )
 217    VALUES ('WEEKENDBG','#D0D0D0');
 218  INSERT INTO webcal_config ( cal_setting, cal_value )
 219    VALUES ('TABLEBG','#000000');
 220  INSERT INTO webcal_config ( cal_setting, cal_value )
 221    VALUES ('THBG','#FFFFFF');
 222  INSERT INTO webcal_config ( cal_setting, cal_value )
 223    VALUES ('THFG','#000000');
 224  INSERT INTO webcal_config ( cal_setting, cal_value )
 225    VALUES ('POPUP_FG','#000000');
 226  INSERT INTO webcal_config ( cal_setting, cal_value )
 227    VALUES ('POPUP_BG','#FFFFFF');
 228  INSERT INTO webcal_config ( cal_setting, cal_value )
 229    VALUES ('TODAYCELLBG','#FFFF33');
 230  INSERT INTO webcal_config ( cal_setting, cal_value )
 231    VALUES ( 'STARTVIEW', 'week.php' );
 232  INSERT INTO webcal_config ( cal_setting, cal_value )
 233    VALUES ( 'WEEK_START', '0' );
 234  INSERT INTO webcal_config ( cal_setting, cal_value )
 235    VALUES ( 'TIME_FORMAT', '12' );
 236  INSERT INTO webcal_config ( cal_setting, cal_value )
 237    VALUES ( 'DISPLAY_UNAPPROVED', 'Y' );
 238  INSERT INTO webcal_config ( cal_setting, cal_value )
 239    VALUES ( 'DISPLAY_WEEKNUMBER', 'Y' );
 240  INSERT INTO webcal_config ( cal_setting, cal_value )
 241    VALUES ( 'WORK_DAY_START_HOUR', '8' );
 242  INSERT INTO webcal_config ( cal_setting, cal_value )
 243    VALUES ( 'WORK_DAY_END_HOUR', '17' );
 244  INSERT INTO webcal_config ( cal_setting, cal_value )
 245    VALUES ( 'send_email', 'N' );
 246  INSERT INTO webcal_config ( cal_setting, cal_value )
 247    VALUES ( 'EMAIL_REMINDER', 'Y' );
 248  INSERT INTO webcal_config ( cal_setting, cal_value )
 249    VALUES ( 'EMAIL_EVENT_ADDED', 'Y' );
 250  INSERT INTO webcal_config ( cal_setting, cal_value )
 251    VALUES ( 'EMAIL_EVENT_UPDATED', 'Y' );
 252  INSERT INTO webcal_config ( cal_setting, cal_value )
 253    VALUES ( 'EMAIL_EVENT_DELETED', 'Y' );
 254  INSERT INTO webcal_config ( cal_setting, cal_value )
 255    VALUES ( 'EMAIL_EVENT_REJECTED', 'Y' );
 256  INSERT INTO webcal_config ( cal_setting, cal_value )
 257    VALUES ('auto_refresh', 'N');
 258  INSERT INTO webcal_config ( cal_setting, cal_value )
 259    VALUES ('nonuser_enabled', 'N');
 260  INSERT INTO webcal_config ( cal_setting, cal_value )
 261    VALUES ('allow_html_description', 'N');
 262  INSERT INTO webcal_config ( cal_setting, cal_value )
 263    VALUES ('reports_enabled', 'N');
 264  INSERT INTO webcal_config ( cal_setting, cal_value )
 265    VALUES ('DISPLAY_WEEKENDS', 'Y');
 266  INSERT INTO webcal_config ( cal_setting, cal_value )
 267    VALUES ('DISPLAY_DESC_PRINT_DAY', 'N');
 268  INSERT INTO webcal_config ( cal_setting, cal_value )
 269    VALUES ('DATE_FORMAT', '__month__ __dd__, __yyyy__');
 270  INSERT INTO webcal_config ( cal_setting, cal_value )
 271    VALUES ('TIME_SLOTS', '12');
 272  INSERT INTO webcal_config ( cal_setting, cal_value )
 273    VALUES ('TIMED_EVT_LEN', 'D');
 274  INSERT INTO webcal_config ( cal_setting, cal_value )
 275    VALUES ('PUBLISH_ENABLED', 'N');
 276  INSERT INTO webcal_config ( cal_setting, cal_value )
 277    VALUES ('DATE_FORMAT_MY', '__month__ __yyyy__');
 278  INSERT INTO webcal_config ( cal_setting, cal_value )
 279    VALUES ('DATE_FORMAT_MD', '__month__ __dd__');
 280  INSERT INTO webcal_config ( cal_setting, cal_value )
 281    VALUES ('CUSTOM_SCRIPT', 'N');
 282  INSERT INTO webcal_config ( cal_setting, cal_value )
 283    VALUES ('CUSTOM_HEADER', 'N');
 284  INSERT INTO webcal_config ( cal_setting, cal_value )
 285    VALUES ('CUSTOM_TRAILER', 'N');
 286  INSERT INTO webcal_config ( cal_setting, cal_value )
 287    VALUES ('bold_days_in_year', 'Y');
 288  INSERT INTO webcal_config ( cal_setting, cal_value )
 289    VALUES ('site_extras_in_popup', 'N');
 290  INSERT INTO webcal_config ( cal_setting, cal_value )
 291    VALUES ('add_link_in_views', 'Y');
 292  INSERT INTO webcal_config ( cal_setting, cal_value )
 293    VALUES ('allow_conflict_override', 'Y');
 294  INSERT INTO webcal_config ( cal_setting, cal_value )
 295    VALUES ('limit_appts', 'N');
 296  INSERT INTO webcal_config ( cal_setting, cal_value )
 297    VALUES ('limit_appts_number', '6');
 298  INSERT INTO webcal_config ( cal_setting, cal_value )
 299    VALUES ('public_access', 'N');
 300  INSERT INTO webcal_config ( cal_setting, cal_value )
 301    VALUES ('public_access_default_visible', 'N');
 302  INSERT INTO webcal_config ( cal_setting, cal_value )
 303    VALUES ('public_access_default_selected', 'N');
 304  INSERT INTO webcal_config ( cal_setting, cal_value )
 305    VALUES ('public_access_others', 'N');
 306  INSERT INTO webcal_config ( cal_setting, cal_value )
 307    VALUES ('public_access_can_add', 'N');
 308  INSERT INTO webcal_config ( cal_setting, cal_value )
 309    VALUES ('public_access_add_needs_approval', 'Y');
 310  INSERT INTO webcal_config ( cal_setting, cal_value )
 311    VALUES ('public_access_view_part', 'N');
 312  INSERT INTO webcal_config ( cal_setting, cal_value )
 313    VALUES ('nonuser_at_top', 'Y');
 314  INSERT INTO webcal_config ( cal_setting, cal_value )
 315    VALUES ('allow_external_users', 'N');
 316  INSERT INTO webcal_config ( cal_setting, cal_value )
 317    VALUES ('external_notifications', 'N');
 318  INSERT INTO webcal_config ( cal_setting, cal_value )
 319    VALUES ('external_reminders', 'N');
 320  INSERT INTO webcal_config ( cal_setting, cal_value )
 321    VALUES ('enable_gradients', 'N');
 322  
 323  
 324  
 325  /* Table: WEBCAL_ENTRY_LOG, Owner: SYSDBA */
 326  
 327  CREATE TABLE "WEBCAL_ENTRY_LOG" 
 328  (
 329     "CAL_LOG_ID" INTEGER DEFAULT 0 NOT NULL,
 330     "CAL_ENTRY_ID" INTEGER DEFAULT 0 NOT NULL,
 331     "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
 332     "CAL_USER_CAL" VARCHAR(25) CHARACTER SET WIN1252 NULL,
 333     "CAL_TYPE" VARCHAR(1) CHARACTER SET WIN1252 NOT NULL,
 334     "CAL_DATE" INTEGER NULL,
 335     "CAL_TIME" INTEGER NULL,
 336     "CAL_TEXT" VARCHAR(500) CHARACTER SET WIN1252 NULL
 337  );
 338  
 339  
 340  /* Table: WEBCAL_CATEGORIES, Owner: SYSDBA */
 341  
 342  CREATE TABLE "WEBCAL_CATEGORIES" 
 343  (
 344     "CAT_ID" INTEGER DEFAULT 0 NOT NULL,
 345     "CAT_OWNER" VARCHAR(25) CHARACTER SET WIN1252 NULL,
 346     "CAT_NAME" VARCHAR(80) CHARACTER SET WIN1252 NOT NULL
 347  );
 348  
 349  /* Table: WEBCAL_ASST, Owner: SYSDBA */
 350  CREATE TABLE "WEBCAL_ASST"
 351  (
 352    "CAL_BOSS" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
 353    "CAL_ASSISTANT"  VARCHAR(25) CHARACTER SET WIN1252 NOT NULL
 354  );
 355  
 356  /* Table: "WEBCAL_NONUSER_CALS", Owner: SYSDBA */
 357  CREATE TABLE WEBCAL_NONUSER_CALS (
 358    "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
 359    "CAL_LASTNAME" VARCHAR(25) CHARACTER SET WIN1252,
 360    "CAL_FIRSTNAME" VARCHAR(25) CHARACTER SET WIN1252,
 361    "CAL_ADMIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL
 362  );
 363  
 364  /* Table: "WEBCAL_IMPORT", Owner: SYSDBA */
 365  CREATE TABLE WEBCAL_IMPORT (
 366    "CAL_IMPORT_ID" INTEGER DEFAULT 0 NOT NULL,
 367    "CAL_NAME" VARCHAR(50) CHARACTER SET WIN1252 NULL,
 368    "CAL_DATE" INTEGER DEFAULT 0 NOT NULL,
 369    "CAL_TYPE" VARCHAR(10) CHARACTER SET WIN1252 NOT NULL,
 370    "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL
 371  );
 372  
 373  /* Table: "WEBCAL_IMPORT_DATA", Owner: SYSDBA */
 374  CREATE TABLE WEBCAL_IMPORT_DATA (
 375    "CAL_IMPORT_ID" INTEGER DEFAULT 0 NOT NULL,
 376    "CAL_ID" INTEGER DEFAULT 0 NOT NULL,
 377    "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
 378    "CAL_IMPORT_TYPE" VARCHAR(15) CHARACTER SET WIN1252 NOT NULL,
 379    "CAL_EXTERNAL_ID" VARCHAR(200) CHARACTER SET WIN1252 NULL,
 380    "CAL_EXTERNAL_ID" VARCHAR(200) NULL
 381  );
 382  
 383  /* Table: "WEBCAL_REPORT", Owner: SYSDBA */
 384  CREATE TABLE WEBCAL_REPORT (
 385    "CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
 386    "CAL_REPORT_ID INTEGER DEFAULT 0 NOT NULL,
 387    "CAL_IS_GLOBAL VARCHAR(1) DEFAULT 'N' CHARACTER SET WIN1252 NOT NULL,
 388    "CAL_REPORT_TYPE VARCHAR(20) CHARACTER SET WIN1252 NOT NULL,
 389    "CAL_INCLUDE_HEADER VARCHAR(1) DEFAULT 'Y' CHARACTER SET WIN1252 NOT NULL,
 390    "CAL_REPORT_NAME VARCHAR(50) CHARACTER SET WIN1252 NOT NULL,
 391    "CAL_TIME_RANGE INTEGER DEFAULT 0 NOT NULL,
 392    "CAL_USER VARCHAR(25) CHARACTER SET WIN1252 NULL,
 393    "CAL_ALLOW_NAV VARCHAR(1) DEFAULT 'Y' CHARACTER SET WIN1252 NOT NULL,
 394    "CAL_CAT_ID INTEGER NULL,
 395    "CAL_INCLUDE_EMPTY VARCHAR(1) DEFAULT 'N' CHARACTER SET WIN1252 NOT NULL,
 396    "CAL_SHOW_IN_TRAILER VARCHAR(1) DEFAULT 'N' CHARACTER SET WIN1252 NOT NULL,
 397    "CAL_UPDATE_DATE INTEGER DEFAULT 0 NOT NULL
 398  );
 399  
 400  /* Table: "WEBCAL_REPORT_TEMPLATE", Owner: SYSDBA */
 401  CREATE TABLE WEBCAL_REPORT_TEMPLATE (
 402    "CAL_REPORT_ID" INTEGER DEFAULT 0 NOT NULL,
 403    "CAL_TEMPLATE_TYPE" VARCHAR(1) CHARACTER SET WIN1252 NOT NULL,
 404    "CAL_TEMPLATE_TEXT" VARCHAR(1024) CHARACTER SET WIN1252 NOT NULL
 405  );
 406  
 407  
 408  
 409  
 410  
 411  
 412  /*  Index definitions for all user tables */
 413  
 414  CREATE INDEX "IWEBCAL_ENTRYNEWINDEX" ON "WEBCAL_ENTRY"("CAL_ID");
 415  CREATE INDEX "IWEBCAL_ENTRY_REPEATSNEWINDEX" ON "WEBCAL_ENTRY_REPEATS"("CAL_ID");
 416  CREATE INDEX "IWEBCAL_ENTRY_REPEATS_NOTNEWINDEX" ON "WEBCAL_ENTRY_REPEATS_NOT"("CAL_ID", "CAL_DATE");
 417  CREATE INDEX "IWEBCAL_ENTRY_USERNEWINDEX" ON "WEBCAL_ENTRY_USER"("CAL_ID", "CAL_LOGIN");
 418  CREATE INDEX "IWEBCAL_ENTRY_EXTUSERNEWINDEX" ON "WEBCAL_ENTRY_EXT_USER"("CAL_ID", "CAL_FULLNAME");
 419  CREATE INDEX "IWEBCAL_REMINDER_LOGNEWINDEX" ON "WEBCAL_REMINDER_LOG"("CAL_ID", "CAL_NAME", "CAL_EVENT_DATE");
 420  CREATE INDEX "IWEBCAL_SITE_EXTRASNEWINDEX" ON "WEBCAL_SITE_EXTRAS"("CAL_ID", "CAL_NAME", "CAL_TYPE");
 421  CREATE INDEX "IWEBCAL_USERNEWINDEX" ON "WEBCAL_USER"("CAL_LOGIN");
 422  CREATE INDEX "IWEBCAL_USER_LAYERSNEWINDEX" ON "WEBCAL_USER_LAYERS"("CAL_LOGIN", "CAL_LAYERUSER");
 423  CREATE INDEX "IWEBCAL_USER_PREFNEWINDEX" ON "WEBCAL_USER_PREF"("CAL_LOGIN", "CAL_SETTING");
 424  CREATE INDEX "IWEBCAL_GROUPNEWINDEX" ON "WEBCAL_GROUP"("CAL_GROUP_ID");
 425  CREATE INDEX "IWEBCAL_GROUPUSERNEWINDEX" ON "WEBCAL_GROUP_USER"("CAL_GROUP_ID", "CAL_LOGIN");
 426  CREATE INDEX "IWEBCAL_VIEWNEWINDEX" ON "WEBCAL_VIEW"("CAL_VIEW_ID");
 427  CREATE INDEX "IWEBCAL_VIEWUSERNEWINDEX" ON "WEBCAL_VIEW_USER"("CAL_VIEW_ID", "CAL_LOGIN");
 428  CREATE INDEX "IWEBCAL_CONFIGNEWINDEX" ON "WEBCAL_CONFIG"("CAL_SETTING");
 429  CREATE INDEX "IWEBCAL_ENTRYLOGINDEX" ON "WEBCAL_CONFIG"("CAL_LOG_ID");
 430  CREATE INDEX "IWEBCAL_CATEGORIESINDEX" ON "WEBCAL_CATEGORIES"("CAT_ID");
 431  CREATE INDEX "IWEBCAL_BOSSINDEX" ON "WEBCAL_ASST"("CAL_BOSS", "CAL_ASSISTANT");
 432  CREATE INDEX "IWEBCAL_NONUSERCALSINDEX" ON "WEBCAL_NONUSER_CALS"("CAL_LOGIN");
 433  CREATE INDEX "IWEBCAL_IMPORT2INDEX" ON "WEBCAL_IMPORT"("CAL_IMPORT_ID");
 434  CREATE INDEX "IWEBCAL_IMPORTINDEX" ON "WEBCAL_IMPORT_DATA"("CAL_LOGIN", "CAL_ID");
 435  CREATE INDEX "IWEBCAL_REPORTINDEX" ON "WEBCAL_REPORT"("CAL_REPORT_ID");
 436  CREATE INDEX "IWEBCAL_REPORTTEMPLATEINDEX" ON "WEBCAL_REPORT_TEMPLATE"("CAL_REPORT_ID", "CAL_TEMPLATE_TYPE");
 437  
 438