Magellan Linux

Diff of /alx-src/branches/alx-web-070/scripts/sql-schema/include/update_to_database_schema_version_2.sh

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 8490 by niro, Fri Feb 5 12:28:33 2016 UTC revision 8491 by niro, Fri Feb 5 13:07:55 2016 UTC
# Line 2  update_to_database_schema_version_2() Line 2  update_to_database_schema_version_2()
2  {  {
3   TABLE_DEFINITION=(   TABLE_DEFINITION=(
4   "cfg_scm_egk"   "cfg_scm_egk"
5   "serial int(11) NOT NULL PRIMARY KEY"   "serial int(255) NOT NULL PRIMARY KEY"
6   "facility tinyint(1) NOT NULL DEFAULT '1'"   "facility tinyint(1) NOT NULL DEFAULT '1'"
7   )   )
8   sql_create_table   sql_create_table
9    
10   TABLE_DEFINITION=(   TABLE_DEFINITION=(
11   "cfg_sessions_rdesktop"   "cfg_sessions_rdesktop"
12   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT"
13   "serial int(11) NOT NULL"   "serial int(255) NOT NULL"
14   "name varchar(255) NOT NULL"   "name varchar(255) NOT NULL"
15   "server varchar(255) NOT NULL"   "server varchar(255) NOT NULL"
16   "filename varchar(255) DEFAULT NULL"   "filename varchar(255) DEFAULT NULL"

Legend:
Removed from v.8490  
changed lines
  Added in v.8491