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 8497 by niro, Fri Feb 5 13:48:23 2016 UTC revision 8740 by niro, Wed Feb 17 12:07:37 2016 UTC
    # Line 1  Line 1 
    1  create_database_schema()  create_database_schema()
    2  {  {
    3   TABLE_DEFINITION=(   TABLE_DEFINITION=(
    4   "meta"   "meta_schema"
    5   "schema_version int(11) NOT NULL PRIMARY KEY"   "version int(11) NOT NULL PRIMARY KEY"
    6     )
    7     sql_create_table
    8    
    9     TABLE_DEFINITION=(
    10     "meta_values"
    11     "version int(11) NOT NULL PRIMARY KEY"
    12   )   )
    13   sql_create_table   sql_create_table
    14    
    # Line 183  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 200  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 217  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 249  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     "bootserver varchar(255) NOT NULL"
    261   "controlserver varchar(255) NOT NULL"   "controlserver varchar(255) NOT NULL"
    262   "pxe_default_entry varchar(255) NOT NULL"   "pxe_default_entry varchar(255) NOT NULL"
    263   "pxe_prompt tinyint(1) NOT NULL"   "pxe_prompt tinyint(1) NOT NULL"
    # Line 363  create_database_schema() Line 370  create_database_schema()
    370   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    371   "value varchar(255) NOT NULL"   "value varchar(255) NOT NULL"
    372   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
    373     )
    374     sql_create_table
    375    
    376     TABLE_DEFINITION=(
    377     "values_network_wireless_auth_mode"
    378     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    379     "value varchar(255) NOT NULL"
    380     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    381     )
    382     sql_create_table
    383    
    384     TABLE_DEFINITION=(
    385     "values_network_wireless_bitrate"
    386     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    387     "value varchar(255) NOT NULL"
    388     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    389     )
    390     sql_create_table
    391    
    392     TABLE_DEFINITION=(
    393     "values_network_wireless_channel"
    394     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    395     "value varchar(255) NOT NULL"
    396     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    397     )
    398     sql_create_table
    399    
    400     TABLE_DEFINITION=(
    401     "values_network_wireless_frequency"
    402     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    403     "value varchar(255) NOT NULL"
    404     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    405     )
    406     sql_create_table
    407    
    408     TABLE_DEFINITION=(
    409     "values_network_wireless_key_length"
    410     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    411     "value varchar(255) NOT NULL"
    412     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    413     )
    414     sql_create_table
    415    
    416     TABLE_DEFINITION=(
    417     "values_network_wireless_mode"
    418     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
    419     "value varchar(255) NOT NULL"
    420     "enabled tinyint(1) NOT NULL DEFAULT '1'"
    421   )   )
    422   sql_create_table   sql_create_table
    423    
    Legend:
    Removed from v.8497  
    changed lines
      Added in v.8740