/[alx-svn]/alx-src/branches/alx-web-070/scripts/sql-schema/include/update_to_database_schema_version_4.sh |
Contents of /alx-src/branches/alx-web-070/scripts/sql-schema/include/update_to_database_schema_version_4.sh
Parent Directory | Revision Log
Revision 8515 -
(show annotations)
(download)
(as text)
Mon Feb 8 09:22:28 2016 UTC (8 years, 2 months ago) by niro
File MIME type: application/x-sh
File size: 1067 byte(s)
Mon Feb 8 09:22:28 2016 UTC (8 years, 2 months ago) by niro
File MIME type: application/x-sh
File size: 1067 byte(s)
-schema version 4 and values version 2, get wireless_ default values from database
1 | update_to_database_schema_version_4() |
2 | { |
3 | TABLE_DEFINITION=( |
4 | "values_network_wireless_auth_mode" |
5 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
6 | "value varchar(255) NOT NULL" |
7 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
8 | ) |
9 | sql_create_table |
10 | |
11 | TABLE_DEFINITION=( |
12 | "values_network_channel" |
13 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
14 | "value varchar(255) NOT NULL" |
15 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
16 | ) |
17 | sql_create_table |
18 | |
19 | TABLE_DEFINITION=( |
20 | "values_network_wireless_frequency" |
21 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
22 | "value varchar(255) NOT NULL" |
23 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
24 | ) |
25 | sql_create_table |
26 | |
27 | TABLE_DEFINITION=( |
28 | "values_network_key_length" |
29 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
30 | "value varchar(255) NOT NULL" |
31 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
32 | ) |
33 | sql_create_table |
34 | |
35 | TABLE_DEFINITION=( |
36 | "values_network_wireless_mode" |
37 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
38 | "value varchar(255) NOT NULL" |
39 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
40 | ) |
41 | sql_create_table |
42 | } |