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 8498 by niro, Fri Feb 5 13:57:48 2016 UTC revision 8573 by niro, Tue Feb 9 13:07:06 2016 UTC
    # Line 189  create_database_schema() Line 189  create_database_schema()
    189   "domain varchar(255) DEFAULT NULL"   "domain varchar(255) DEFAULT NULL"
    190   "password varchar(255) DEFAULT NULL"   "password varchar(255) DEFAULT NULL"
    191   "serverlist varchar(255) NOT NULL"   "serverlist varchar(255) NOT NULL"
    192   "autostart tinyint(1) NOT NULL DEFAULT '0'"   "autostart tinyint(1) NOT NULL DEFAULT '1'"
    193   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    194   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
    195   )   )
    # Line 206  create_database_schema() Line 206  create_database_schema()
    206   "password varchar(255) DEFAULT NULL"   "password varchar(255) DEFAULT NULL"
    207   "domain varchar(255) DEFAULT NULL"   "domain varchar(255) DEFAULT NULL"
    208   "shell varchar(255) DEFAULT NULL"   "shell varchar(255) DEFAULT NULL"
    209   "autostart tinyint(1) NOT NULL DEFAULT '0'"   "autostart tinyint(1) NOT NULL DEFAULT '1'"
    210   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    211   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
    212   )   )
    # Line 223  create_database_schema() Line 223  create_database_schema()
    223   "domain varchar(255) DEFAULT NULL"   "domain varchar(255) DEFAULT NULL"
    224   "password varchar(255) DEFAULT NULL"   "password varchar(255) DEFAULT NULL"
    225   "store varchar(255) NOT NULL"   "store varchar(255) NOT NULL"
    226   "autostart tinyint(1) NOT NULL DEFAULT '0'"   "autostart tinyint(1) NOT NULL DEFAULT '1'"
    227   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    228   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"   "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
    229   )   )
    # Line 255  create_database_schema() Line 255  create_database_schema()
    255   sql_create_table   sql_create_table
    256    
    257   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    258   "client_location"   "client_locations"
    259   "location varchar(255) NOT NULL PRIMARY KEY"   "location varchar(255) NOT NULL PRIMARY KEY"
    260   "controlserver varchar(255) NOT NULL"   "controlserver varchar(255) NOT NULL"
    261   "pxe_default_entry varchar(255) NOT NULL"   "pxe_default_entry varchar(255) NOT NULL"
    # Line 369  create_database_schema() Line 369  create_database_schema()
    369   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    370   "value varchar(255) NOT NULL"   "value varchar(255) NOT NULL"
    371   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    372     )
    373     sql_create_table
    374    
    375     TABLE_DEFINITION=(
    376     "values_network_wireless_auth_mode"
    377     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    378     "value varchar(255) NOT NULL"
    379     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    380     )
    381     sql_create_table
    382    
    383     TABLE_DEFINITION=(
    384     "values_network_wireless_bitrate"
    385     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    386     "value varchar(255) NOT NULL"
    387     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    388     )
    389     sql_create_table
    390    
    391     TABLE_DEFINITION=(
    392     "values_network_wireless_channel"
    393     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    394     "value varchar(255) NOT NULL"
    395     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    396     )
    397     sql_create_table
    398    
    399     TABLE_DEFINITION=(
    400     "values_network_wireless_frequency"
    401     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    402     "value varchar(255) NOT NULL"
    403     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    404     )
    405     sql_create_table
    406    
    407     TABLE_DEFINITION=(
    408     "values_network_wireless_key_length"
    409     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    410     "value varchar(255) NOT NULL"
    411     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    412     )
    413     sql_create_table
    414    
    415     TABLE_DEFINITION=(
    416     "values_network_wireless_mode"
    417     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    418     "value varchar(255) NOT NULL"
    419     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    420   )   )
    421   sql_create_table   sql_create_table
    422    
    Legend:
    Removed from v.8498  
    changed lines
      Added in v.8573