I am trying to create a four colum table in my post but I don't know how.
I am trying to create a four colum table in my post but I don't know how.
xman, Native code
CREATE TABLE `tbl_name` (
`col1` int(11) NOT NULL AUTO_INCREMENT,
`col2` text COLLATE utf8mb4_unicode_ci NOT NULL,
`col3` int(11) NOT NULL,
`col4` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; [c] # kantry ([time] 05/18/2021 07:47 AM [/ time])
xman, Native code
CREATE TABLE `tbl_name` (
` col1` int (11) NOT NULL AUTO_INCREMENT,
`col2` text COLLATE utf8mb4_unicode_ci NOT NULL,
`col3` int (11) NOT NULL,
` col4` int (11) NOT NULL
) E [/ c] Thank you but I do not understand.
Attached bellow is what I want to do in my forum post and I am using JOHNCMS 9.xx
[/code][code=php]**************************************CREATE TABLE `tbl_name` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`items` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`drafts` int(11) NOT NULL,
`amounts` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; # xman (18.05.2021 / 10:29)
I am trying to create a four colum table in my post but I don't know how.
$schema = Capsule::schema();
$schema->create(
'demo_table',
static function (Blueprint $table) {
$table->increments('id'); // id column auto incre...
$table->boolean('adm')->default(0)->index('adm');
$table->integer('time')->unsigned()->default(0)->index('time');
$table->integer('user_id')->unsigned()->default(0);
$table->string('name')->default('');
$table->text('text');
$table->bigInteger('ip')->default(0)->index('ip');
$table->string('browser')->default('');
$table->string('admin')->default('');
$table->text('otvet');
$table->integer('otime')->unsigned()->default(0);
$table->string('edit_who')->default('');
$table->integer('edit_time')->unsigned()->default(0);
$table->tinyInteger('edit_count')->unsigned()->default(0);
}
);xman, Example for Johncms version 9.4
https://github.com/johncms/joh ... 0.php
Oh great thanks very much. Now I have another problem with JOHNCMS 9.4.1
I am stuck in step 3 installation process, please what should I do to make it work.
Attached below is where I am.
xman,
Максу 10 раз писал что из-за какой то мелочи, половина хостингов не подходит.
$schema = Capsule::Schema();
Schema::defaultStringLength(191);// add string