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

Parent Directory | Revision Log | Patch

	revision 8518 by niro, Mon Feb 8 09:41:29 2016 UTC	revision 9462 by niro, Thu Apr 6 12:51:30 2017 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		"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 369  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		"description varchar(255) DEFAULT NULL AFTER value"
374	)	)
375	sql_create_table	sql_create_table
376
#	Line 377  create_database_schema()	Line 379  create_database_schema()
379	"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"	"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
380	"value varchar(255) NOT NULL"	"value varchar(255) NOT NULL"
381	"enabled tinyint(1) NOT NULL DEFAULT '1'"	"enabled tinyint(1) NOT NULL DEFAULT '1'"
382		)
383		sql_create_table
384
385		TABLE_DEFINITION=(
386		"values_network_wireless_bitrate"
387		"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
388		"value varchar(255) NOT NULL"
389		"enabled tinyint(1) NOT NULL DEFAULT '1'"
390	)	)
391	sql_create_table	sql_create_table
392

---

Colored Diff Long Colored Diff Full Colored Diff Unidiff Context Diff Side by Side

Legend: Removed from v.8518   changed lines   Added in v.9462