Changeset 47
- Timestamp:
- 12/28/04 09:30:49 (4 years ago)
- Files:
-
- trunk/AMP/SQL/newinstall.sql (modified) (1 diff)
- trunk/AMP/amp_conf/htdocs/admin/functions.php (modified) (2 diffs)
- trunk/AMP2-UseAmportal/SQL/newinstall.sql (modified) (1 diff)
- trunk/AMP2-UseAmportal/amp_conf/var/www/html/admin/functions.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/AMP/SQL/newinstall.sql
r44 r47 96 96 `id` int(11) NOT NULL default '-1', 97 97 `keyword` varchar(20) NOT NULL default '', 98 `data` varchar( 50) NOT NULL default '',98 `data` varchar(150) NOT NULL default '', 99 99 `flags` int(1) NOT NULL default '0', 100 100 PRIMARY KEY (`id`,`keyword`) trunk/AMP/amp_conf/htdocs/admin/functions.php
r46 r47 173 173 function iaxexists() { 174 174 global $db; 175 $sql = "CREATE TABLE IF NOT EXISTS `iax` (`id` int(11) NOT NULL default '-1',`keyword` varchar(20) NOT NULL default '',`data` varchar( 50) NOT NULL default '',`flags` int(1) NOT NULL default '0',PRIMARY KEY (`id`,`keyword`))";175 $sql = "CREATE TABLE IF NOT EXISTS `iax` (`id` int(11) NOT NULL default '-1',`keyword` varchar(20) NOT NULL default '',`data` varchar(150) NOT NULL default '',`flags` int(1) NOT NULL default '0',PRIMARY KEY (`id`,`keyword`))"; 176 176 $results = $db->query($sql); 177 177 } … … 209 209 function sipexists() { 210 210 global $db; 211 $sql = "CREATE TABLE IF NOT EXISTS `sip` (`id` int(11) NOT NULL default '-1',`keyword` varchar(20) NOT NULL default '',`data` varchar( 50) NOT NULL default '',`flags` int(1) NOT NULL default '0',PRIMARY KEY (`id`,`keyword`))";211 $sql = "CREATE TABLE IF NOT EXISTS `sip` (`id` int(11) NOT NULL default '-1',`keyword` varchar(20) NOT NULL default '',`data` varchar(150) NOT NULL default '',`flags` int(1) NOT NULL default '0',PRIMARY KEY (`id`,`keyword`))"; 212 212 $results = $db->query($sql); 213 213 } trunk/AMP2-UseAmportal/SQL/newinstall.sql
r44 r47 96 96 `id` int(11) NOT NULL default '-1', 97 97 `keyword` varchar(20) NOT NULL default '', 98 `data` varchar( 50) NOT NULL default '',98 `data` varchar(150) NOT NULL default '', 99 99 `flags` int(1) NOT NULL default '0', 100 100 PRIMARY KEY (`id`,`keyword`) trunk/AMP2-UseAmportal/amp_conf/var/www/html/admin/functions.php
r46 r47 173 173 function iaxexists() { 174 174 global $db; 175 $sql = "CREATE TABLE IF NOT EXISTS `iax` (`id` int(11) NOT NULL default '-1',`keyword` varchar(20) NOT NULL default '',`data` varchar( 50) NOT NULL default '',`flags` int(1) NOT NULL default '0',PRIMARY KEY (`id`,`keyword`))";175 $sql = "CREATE TABLE IF NOT EXISTS `iax` (`id` int(11) NOT NULL default '-1',`keyword` varchar(20) NOT NULL default '',`data` varchar(150) NOT NULL default '',`flags` int(1) NOT NULL default '0',PRIMARY KEY (`id`,`keyword`))"; 176 176 $results = $db->query($sql); 177 177 } … … 209 209 function sipexists() { 210 210 global $db; 211 $sql = "CREATE TABLE IF NOT EXISTS `sip` (`id` int(11) NOT NULL default '-1',`keyword` varchar(20) NOT NULL default '',`data` varchar( 50) NOT NULL default '',`flags` int(1) NOT NULL default '0',PRIMARY KEY (`id`,`keyword`))";211 $sql = "CREATE TABLE IF NOT EXISTS `sip` (`id` int(11) NOT NULL default '-1',`keyword` varchar(20) NOT NULL default '',`data` varchar(150) NOT NULL default '',`flags` int(1) NOT NULL default '0',PRIMARY KEY (`id`,`keyword`))"; 212 212 $results = $db->query($sql); 213 213 }
