Input:nuAutoNumber
Jump to navigation
Jump to search
The Input:nuAutoNumber field is designed to store a sequence of numbers that increments with each new record. By default, it is a VARCHAR(15) field, but it should ensure that the last character is a digit that increments. While BIGINT can be used for this purpose, it requires manual adjustment at the table level using a MySQL client such as phpMyAdmin.
The user table permits duplicate entries unless other keys or constraints are defined in the schema. Therefore, the AUTO_INCREMENT attribute is not necessary in the schema definition of the user table. The Next Number attribute of the Input parameter can be initialized to start the sequence.
The Auto Increment is done in the functions nuAutoNumber() and nuUpdateCounter() in nudata.php.