asset_id | Rails 3 library that uploads all static assets | AWS library

Below is my sample schema.

I was given the a copy of the folder "httpdocs" and a .sql of the Joomla database from a fully operational site on plesk, and was asked to mount the website locally.

The version of Joomla is 3.6.5, I checked it on the en-GB.xml. The PHP version on the original server was 5.4.45, and now I am using Xampp 1.8.2 with PHP 5.4.31.

After changing the configuration.php to connect to the database, and then accessing the site I get this error:

1054 - Unknown column 'c.version' in 'field list'

SQL=

...

I am trying to update a timestamp in a table called asset when an insert is made in another table using the foreign key asset_id... in psuedo code what i mean is:

on insert into table B,

update asset set last_updated = now()

where asset.asset_id = B.asset_id;

Below is the Postgres script i am trying to use to accomplish that:

I'm trying to create a pallet that users can deposit assets into and withdraw from. I've written the following code, but I'm not sure it's the best way to about things due to frame_system::RawOrigin::Root.into() being accessible by every runtime.

I'm still fairly new to Substrate and not sure this is exactly how it works, would love some guidance on the best design choice.

Making use of assets pallet to deposit:

>::transfer(origin, asset_id, RawOrigin::Root.into(), amount);

To Withdraw:

>::transfer(RawOrigin::Root.into(), asset_id, origin, amount);

Edit

A similar idea written in Solidity:

I need to add multiple content controls and additional text into a single table cell in word using VBA. Here is an example of what I need:

Moby Dick has been read by 2 people who have given it an average score of 3 out of 5

I know I can add a single content controls with the following syntax:

I have the following query in CakePHP 3 which is being used to do a search against a Task entity:

I have data as below

I have an orders ledger which shows some orders relating to a certain asset. The table contains the order updates of a certain order of a certain asset. I need to be able to get the total amount of each asset the user has by adding the amount_filled column of the different orders depending on if its a buy/sell. If it's the same order then we should get the most recent amount filled.

The table looks like this:

I'm writing a server side application for the jquery plugin DataTables, since it's not working I simplified my implementation. This is the js part: