Magellan Linux

  • Back to homepage
    • /[alx-svn]/alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh

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

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

    revision 8573 by niro, Tue Feb 9 13:07:06 2016 UTC revision 13666 by niro, Thu Jul 25 12:55:42 2019 UTC
    # Line 13  create_database_schema() Line 13  create_database_schema()
    13   sql_create_table   sql_create_table
    14    
    15   TABLE_DEFINITION=(   TABLE_DEFINITION=(
      "cfg_autostart"  
      "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"  
      "serial int(11) NOT NULL"  
      "name varchar(255) NOT NULL"  
      "exec varchar(255) DEFAULT NULL"  
      "enabled tinyint(1) NOT NULL DEFAULT '1'"  
      "flg_modified tinyint(1) NOT NULL DEFAULT '0'"  
      )  
      sql_create_table  
       
      TABLE_DEFINITION=(  
    16   "cfg_citrix_serverlist"   "cfg_citrix_serverlist"
    17   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    18   "serial int(11) NOT NULL"   "serial int(11) NOT NULL"
    # Line 47  create_database_schema() Line 36  create_database_schema()
    36   "name varchar(255) NOT NULL"   "name varchar(255) NOT NULL"
    37   "exec varchar(255) NOT NULL"   "exec varchar(255) NOT NULL"
    38   "comment varchar(255) DEFAULT NULL"   "comment varchar(255) DEFAULT NULL"
    39     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    40   )   )
    41   sql_create_table   sql_create_table
    42    
    # Line 142  create_database_schema() Line 132  create_database_schema()
    132   sql_create_table   sql_create_table
    133    
    134   TABLE_DEFINITION=(   TABLE_DEFINITION=(
      "cfg_other_menuitems"  
      "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"  
      "serial int(11) NOT NULL"  
      "name varchar(255) DEFAULT NULL"  
      "exec varchar(255) DEFAULT NULL"  
      "workdir varchar(255) DEFAULT NULL"  
      "icon varchar(255) DEFAULT NULL"  
      )  
      sql_create_table  
       
      TABLE_DEFINITION=(  
    135   "cfg_printers"   "cfg_printers"
    136   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    137   "serial int(11) NOT NULL"   "serial int(11) NOT NULL"
    # Line 257  create_database_schema() Line 236  create_database_schema()
    236   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    237   "client_locations"   "client_locations"
    238   "location varchar(255) NOT NULL PRIMARY KEY"   "location varchar(255) NOT NULL PRIMARY KEY"
    239     "bootserver varchar(255) NOT NULL"
    240   "controlserver varchar(255) NOT NULL"   "controlserver varchar(255) NOT NULL"
    241   "pxe_default_entry varchar(255) NOT NULL"   "pxe_default_entry varchar(255) NOT NULL"
    242   "pxe_prompt tinyint(1) NOT NULL"   "pxe_prompt tinyint(1) NOT NULL"
    # Line 275  create_database_schema() Line 255  create_database_schema()
    255    
    256   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    257   "client_serials"   "client_serials"
    258   "serial int(11) NOT NULL PRIMARY KEY"   "serial int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    259   "location varchar(255) NOT NULL"   "location varchar(255) NOT NULL"
    260   "mtime int(11) DEFAULT NULL"   "mtime int(11) DEFAULT NULL"
    261   "mac varchar(17) NOT NULL"   "mac varchar(17) NOT NULL"
    # Line 289  create_database_schema() Line 269  create_database_schema()
    269   "serial int(11) NOT NULL PRIMARY KEY"   "serial int(11) NOT NULL PRIMARY KEY"
    270   "os varchar(50) NOT NULL"   "os varchar(50) NOT NULL"
    271   "utils varchar(50) NOT NULL"   "utils varchar(50) NOT NULL"
    272     "arch varchar(50) NOT NULL"
    273   )   )
    274   sql_create_table   sql_create_table
    275    
    # Line 369  create_database_schema() Line 350  create_database_schema()
    350   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    351   "value varchar(255) NOT NULL"   "value varchar(255) NOT NULL"
    352   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    353     "description varchar(255) DEFAULT NULL"
    354   )   )
    355   sql_create_table   sql_create_table
    356    
    # Line 445  create_database_schema() Line 427  create_database_schema()
    427   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    428   )   )
    429   sql_create_table   sql_create_table
    430    
    431     TABLE_DEFINITION=(
    432     "client_boot"
    433     "serial int(255) NOT NULL PRIMARY KEY"
    434     "cmdline varchar(255) DEFAULT NULL"
    435     )
    436     sql_create_table
    437  }  }
    Legend:
    Removed from v.8573  
    changed lines
      Added in v.13666