Changeset 3035

Show
Ignore:
Timestamp:
11/08/06 18:29:49 (7 years ago)
Author:
qldrob
Message:

Fix for sqlite patch (no backticks for sqlite)

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • freepbx/trunk/SQL/newinstall.sqlite.sql

    r3033 r3035  
    7676--  
    7777 
    78 INSERT INTO `globals` VALUES ('CALLFILENAME', '""'); 
    79 INSERT INTO `globals` VALUES ('DIAL_OPTIONS', 'tr'); 
    80 INSERT INTO `globals` VALUES ('TRUNK_OPTIONS', ''); 
    81 INSERT INTO `globals` VALUES ('DIAL_OUT', '9'); 
    82 INSERT INTO `globals` VALUES ('FAX', ''); 
    83 INSERT INTO `globals` VALUES ('FAX_RX', 'system'); 
    84 INSERT INTO `globals` VALUES ('FAX_RX_EMAIL', 'fax@mydomain.com'); 
    85 INSERT INTO `globals` VALUES ('FAX_RX_FROM', 'freepbx@gmail.com'); 
    86 INSERT INTO `globals` VALUES ('INCOMING', 'group-all'); 
    87 INSERT INTO `globals` VALUES ('NULL', '""'); 
    88 INSERT INTO `globals` VALUES ('OPERATOR', ''); 
    89 INSERT INTO `globals` VALUES ('OPERATOR_XTN', ''); 
    90 INSERT INTO `globals` VALUES ('PARKNOTIFY', 'SIP/200'); 
    91 INSERT INTO `globals` VALUES ('RECORDEXTEN', '""'); 
    92 INSERT INTO `globals` VALUES ('RINGTIMER', '15'); 
    93 INSERT INTO `globals` VALUES ('DIRECTORY', 'last'); 
    94 INSERT INTO `globals` VALUES ('AFTER_INCOMING', ''); 
    95 INSERT INTO `globals` VALUES ('IN_OVERRIDE', 'forcereghours'); 
    96 INSERT INTO `globals` VALUES ('REGTIME', '7:55-17:05'); 
    97 INSERT INTO `globals` VALUES ('REGDAYS', 'mon-fri'); 
    98 INSERT INTO `globals` VALUES ('DIRECTORY_OPTS', ''); 
    99 INSERT INTO `globals` VALUES ('DIALOUTIDS', '1'); 
    100 INSERT INTO `globals` VALUES ('OUT_1', 'ZAP/g0'); 
    101 INSERT INTO `globals` VALUES ('VM_PREFIX', '*'); 
    102 INSERT INTO `globals` VALUES ('VM_OPTS', ''); 
    103 INSERT INTO `globals` VALUES ('VM_GAIN', ''); 
    104 INSERT INTO `globals` VALUES ('VM_DDTYPE', ''); 
    105 INSERT INTO `globals` VALUES ('TIMEFORMAT', 'kM'); 
    106 INSERT INTO `globals` VALUES ('TONEZONE', 'us'); 
    107 INSERT INTO `globals` VALUES ('ALLOW_SIP_ANON', 'no'); 
     78INSERT INTO globals VALUES ('CALLFILENAME', '""'); 
     79INSERT INTO globals VALUES ('DIAL_OPTIONS', 'tr'); 
     80INSERT INTO globals VALUES ('TRUNK_OPTIONS', ''); 
     81INSERT INTO globals VALUES ('DIAL_OUT', '9'); 
     82INSERT INTO globals VALUES ('FAX', ''); 
     83INSERT INTO globals VALUES ('FAX_RX', 'system'); 
     84INSERT INTO globals VALUES ('FAX_RX_EMAIL', 'fax@mydomain.com'); 
     85INSERT INTO globals VALUES ('FAX_RX_FROM', 'freepbx@gmail.com'); 
     86INSERT INTO globals VALUES ('INCOMING', 'group-all'); 
     87INSERT INTO globals VALUES ('NULL', '""'); 
     88INSERT INTO globals VALUES ('OPERATOR', ''); 
     89INSERT INTO globals VALUES ('OPERATOR_XTN', ''); 
     90INSERT INTO globals VALUES ('PARKNOTIFY', 'SIP/200'); 
     91INSERT INTO globals VALUES ('RECORDEXTEN', '""'); 
     92INSERT INTO globals VALUES ('RINGTIMER', '15'); 
     93INSERT INTO globals VALUES ('DIRECTORY', 'last'); 
     94INSERT INTO globals VALUES ('AFTER_INCOMING', ''); 
     95INSERT INTO globals VALUES ('IN_OVERRIDE', 'forcereghours'); 
     96INSERT INTO globals VALUES ('REGTIME', '7:55-17:05'); 
     97INSERT INTO globals VALUES ('REGDAYS', 'mon-fri'); 
     98INSERT INTO globals VALUES ('DIRECTORY_OPTS', ''); 
     99INSERT INTO globals VALUES ('DIALOUTIDS', '1'); 
     100INSERT INTO globals VALUES ('OUT_1', 'ZAP/g0'); 
     101INSERT INTO globals VALUES ('VM_PREFIX', '*'); 
     102INSERT INTO globals VALUES ('VM_OPTS', ''); 
     103INSERT INTO globals VALUES ('VM_GAIN', ''); 
     104INSERT INTO globals VALUES ('VM_DDTYPE', ''); 
     105INSERT INTO globals VALUES ('TIMEFORMAT', 'kM'); 
     106INSERT INTO globals VALUES ('TONEZONE', 'us'); 
     107INSERT INTO globals VALUES ('ALLOW_SIP_ANON', 'no'); 
    108108 
    109109-- -------------------------------------------------------- 
    …… 
    223223); 
    224224 
    225 CREATE TABLE `freepbx_log` ( 
     225CREATE TABLE freepbx_log ( 
    226226  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY , 
    227227  time DATETIME NOT NULL ,